Fix indefinite hang in Exasol-to-Exasol ETL transfers
Details
| Detail name | Value |
|---|---|
| Changelog Number | 30594 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | Exasol 8.32.0 |
| Fix Versions | Exasol 2025.1.14 |
| Resolution Date | 2026-08-06 |
Description
In rare scenarios, Exasol-to-Exasol IMPORT and EXPORT operations could hang indefinitely if a connection failure occurred while establishing the parallel ETL operation. During export operations, this could also leave a write lock on the destination table until the job was terminated. In environments with a configured query timeout, users could see a timeout error instead of the actual connection failure.
Workaround
Configure a query timeout on the source database to prevent ETL jobs from hanging indefinitely. This ensures that stalled operations are eventually terminated and any write locks on the destination database are released.
Fix
- Improved failure handling to ensure connection failures terminate the entire ETL operation consistently.
- Enhanced error reporting so the actual failure is reported instead of secondary timeout errors.
