Getting this error on redshift destination connectior while syncing - getting this error "internalMessage" : "java.util.concurrent.CompletionException: io.airbyte.commons.exceptions.SQLRuntimeException: com.amazon.redshift.util.RedshiftException: An I/O error occurred while sending to the backend.",

[abhishek-codes]

The reshift connector is working in async mode and after a while fails with the above error message
at com.amazon.redshift.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1878) ~[redshift-jdbc42-2.1.0.23.jar:?] at com.amazon.redshift.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:375) ~[redshift-jdbc42-2.1.0.23.jar:?] ... 21 more Stack Trace: com.amazon.redshift.util.RedshiftException: An I/O error occurred while sending to the backend. at com.amazon.redshift.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:402) at com.amazon.redshift.jdbc.RedshiftStatementImpl.executeInternal(RedshiftStatementImpl.java:515) at com.amazon.redshift.jdbc.RedshiftStatementImpl.execute(RedshiftStatementImpl.java:436) at com.amazon.redshift.jdbc.RedshiftStatementImpl.executeWithFlags(RedshiftStatementImpl.java:377) at com.amazon.redshift.jdbc.RedshiftStatementImpl.executeCachedSql(RedshiftStatementImpl.java:363) at com.amazon.redshift.jdbc.RedshiftStatementImpl.executeWithFlags(RedshiftStatementImpl.java:340) at com.amazon.redshift.jdbc.RedshiftStatementImpl.executeQuery(RedshiftStatementImpl.java:268) at com.amazon.redshift.jdbc.RedshiftDatabaseMetaData.getColumns(RedshiftDatabaseMetaData.java:2095) at com.zaxxer.hikari.pool.ProxyDatabaseMetaData.getColumns(ProxyDatabaseMetaData.java:107) at com.zaxxer.hikari.pool.HikariProxyDatabaseMetaData.getColumns(HikariProxyDatabaseMetaData.java) at io.airbyte.cdk.integrations.destination.jdbc.typing_deduping.JdbcDestinationHandler$Companion.findExistingTable$lambda$1(JdbcDestinationHandler.kt:510) at io.airbyte.cdk.db.jdbc.DefaultJdbcDatabase.executeMetadataQuery(DefaultJdbcDatabase.kt:88) at io.airbyte.cdk.integrations.destination.jdbc.typing_deduping.JdbcDestinationHandler$Companion.findExistingTable(JdbcDestinationHandler.kt:497) at io.airbyte.cdk.integrations.destination.jdbc.typing_deduping.JdbcV1V2Migrator.getTableIfExists(JdbcV1V2Migrator.kt:63) at io.airbyte.integrations.base.destination.typing_deduping.BaseDestinationV1V2Migrator.doesValidV2RawTableAlreadyExist(BaseDestinationV1V2Migrator.kt:156) at io.airbyte.integrations.base.destination.typing_deduping.BaseDestinationV1V2Migrator.shouldMigrate(BaseDestinationV1V2Migrator.kt:51) at io.airbyte.integrations.base.destination.typing_deduping.BaseDestinationV1V2Migrator.migrateIfNecessary(BaseDestinationV1V2Migrator.kt:23) at io.airbyte.integrations.base.destination.typing_deduping.TyperDeduperUtil$Companion.executeWeirdMigrations$lambda$9$lambda$8(TyperDeduperUtil.kt:141) at java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1768) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642) at java.base/java.lang.Thread.run(Thread.java:1583) Caused by: java.io.EOFException: The server closed the connection. at com.amazon.redshift.core.RedshiftStream.receiveChar(RedshiftStream.java:442) at com.amazon.redshift.core.v3.QueryExecutorImpl.processResultsOnThread(QueryExecutorImpl.java:1914) at com.amazon.redshift.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886) at com.amazon.redshift.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1878) at com.amazon.redshift.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:375) ... 21 more

[fkody1]

Related to this issue
#37835

[marcosmarxm]

Closed as duplciated of #37835