JDBC: IMPORT/EXPORT with local CSV may break if reserve node is specified
Details
| Detail name | Value |
|---|---|
| Changelog Number | 19038 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | |
| Fix Versions | JDBC 24.0.0 |
| Resolution Date | 2024-03-11 |
Description
When connecting with JDBC and running an IMPORT or EXPORT statement with a LOCAL CSV FILE, if the connection string contained the address for the reserve node, the IMPORT or EXPORT may fail with one of the following error messages:
- Connection reset
- No operations allowed on this connection because it was already closed.
Workaround
Remove the Reserve Node from the JDBC Connection String.
Fix
In these cases, the driver will perform retries until it connects to one of the active data nodes. The IMPORT or EXPORT will complete successfully.