Introduction
This article explains the Session Connection Reset error and how to troubleshoot it. A Session Connection Reset error means the connection to your source was disrupted, killed or restarted while the extract was running. It is most commonly seen with database connectors such as PostgreSQL.
Issue description
The error usually occurs when an extract loses its connection to the source before it can finish. In many cases, the source connection is reset because too many extracts start at the same time and overload the source.
Signs
- An extract fails with a Session Connection Reset error.
- The issue appears most often on database connectors such as PostgreSQL, MySQL or MSSQL.
- Several scheduled extracts begin at the same time.
- The same extract may succeed when run on its own.
Basic troubleshooting steps
Use the following checklist to identify the most common cause of the error.
- Check whether seven or more extracts are starting at the same time against the same source.
- Review your extract schedule for overlaps or clustering.
- Run one affected scheduled extract manually, outside its normal schedule.
- Confirm whether the extract completes successfully when it is not competing with other extracts.
Advanced troubleshooting steps
Step 1: Test the extract outside the normal schedule
Run one of the affected scheduled extracts manually at a time when fewer or no other extracts are running. If it completes successfully, the schedule is likely congested and causing the connection reset.
Step 2: Spread out extract schedules
Adjust your schedules so fewer extracts start at the same time against the same source. Spacing out start times can reduce connection pressure and prevent the source from resetting the session.
Contact support
If you need help resolving a Session Connection Reset error, contact Kleene support and include the affected source, extract name, and the time the failure occurred.
Conclusion
A Session Connection Reset error usually indicates that the source connection was interrupted during an extract. In most cases, the fix is to reduce schedule congestion by spreading out extract start times. If that does not resolve the issue, Kleene support can help you investigate further.