Prevent duplicates in TypeProvider #31540
95366 tests run, 2796 skipped, 4 failed.
Annotations
Check failure on line 44 in io/trino/plugin/raptor/legacy/storage/organization/TestShardOrganizer
github-actions / Test Report
TestShardOrganizer.testShardOrganizerInProgress
expected: 1
but was: 0
Raw output
org.opentest4j.AssertionFailedError:
expected: 1
but was: 0
at java.base/jdk.internal.reflect.DirectConstructorHandleAccessor.newInstance(DirectConstructorHandleAccessor.java:62)
at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:502)
at io.trino.plugin.raptor.legacy.storage.organization.TestShardOrganizer.testShardOrganizerInProgress(TestShardOrganizer.java:44)
at java.base/java.lang.reflect.Method.invoke(Method.java:580)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:317)
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)
Check failure on line 1 in io/trino/plugin/redshift/TestRedshiftQueryFailureRecoverySmokeTest
github-actions / Test Report
TestRedshiftQueryFailureRecoverySmokeTest.testCreateTable
pgStatement.getConnection().getAutoCommit() should not throw
Raw output
io.trino.testing.QueryFailedException: pgStatement.getConnection().getAutoCommit() should not throw
at io.trino.testing.AbstractTestingTrinoClient.execute(AbstractTestingTrinoClient.java:133)
at io.trino.testing.DistributedQueryRunner.executeWithQueryId(DistributedQueryRunner.java:502)
at io.trino.testing.BaseFailureRecoveryTest$FailureRecoveryAssert.execute(BaseFailureRecoveryTest.java:526)
at io.trino.testing.BaseFailureRecoveryTest$FailureRecoveryAssert.executeExpected(BaseFailureRecoveryTest.java:486)
at io.trino.testing.BaseFailureRecoveryTest$FailureRecoveryAssert.lambda$failsWithoutRetries$10(BaseFailureRecoveryTest.java:699)
at io.trino.testing.BaseFailureRecoveryTest$FailureRecoveryAssert.getFailureStageId(BaseFailureRecoveryTest.java:723)
at io.trino.testing.BaseFailureRecoveryTest$FailureRecoveryAssert.failsWithoutRetries(BaseFailureRecoveryTest.java:699)
at io.trino.testing.BaseFailureRecoveryTest.testNonSelect(BaseFailureRecoveryTest.java:375)
at io.trino.testing.BaseFailureRecoveryTest.testTableModification(BaseFailureRecoveryTest.java:306)
at io.trino.testing.BaseFailureRecoveryTest.testTableModification(BaseFailureRecoveryTest.java:301)
at io.trino.testing.BaseFailureRecoveryTest.testCreateTable(BaseFailureRecoveryTest.java:185)
at java.base/java.lang.reflect.Method.invoke(Method.java:580)
at java.base/java.util.concurrent.RecursiveAction.exec(RecursiveAction.java:194)
at java.base/java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:387)
at java.base/java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1312)
at java.base/java.util.concurrent.ForkJoinPool.scan(ForkJoinPool.java:1843)
at java.base/java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1808)
at java.base/java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:188)
Suppressed: java.lang.Exception: SQL: CREATE TABLE table_l3pgmv03ep AS SELECT * FROM orders
at io.trino.testing.DistributedQueryRunner.executeWithQueryId(DistributedQueryRunner.java:506)
... 16 more
Suppressed: io.trino.testing.QueryFailedException: java.sql.SQLException: Connection to trino-redshift-ci-cluster-8837528b77fbf267.c38hhhngrndv.us-east-2.redshift.amazonaws.com:5439 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
at io.trino.testing.AbstractTestingTrinoClient.execute(AbstractTestingTrinoClient.java:133)
at io.trino.testing.DistributedQueryRunner.executeWithQueryId(DistributedQueryRunner.java:502)
at io.trino.testing.DistributedQueryRunner.execute(DistributedQueryRunner.java:495)
at io.trino.testing.BaseFailureRecoveryTest$FailureRecoveryAssert.lambda$execute$3(BaseFailureRecoveryTest.java:552)
at java.base/java.util.Optional.ifPresent(Optional.java:178)
at io.trino.testing.BaseFailureRecoveryTest$FailureRecoveryAssert.execute(BaseFailureRecoveryTest.java:552)
... 15 more
Suppressed: java.lang.Exception: SQL: DROP TABLE table_l3pgmv03ep
at io.trino.testing.DistributedQueryRunner.executeWithQueryId(DistributedQueryRunner.java:506)
... 19 more
Caused by: io.trino.spi.TrinoException: java.sql.SQLException: Connection to trino-redshift-ci-cluster-8837528b77fbf267.c38hhhngrndv.us-east-2.redshift.amazonaws.com:5439 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
at io.trino.plugin.jdbc.BaseJdbcClient.getTableHandle(BaseJdbcClient.java:230)
at io.trino.plugin.jdbc.ForwardingJdbcClient.getTableHandle(ForwardingJdbcClient.java:88)
at io.trino.plugin.jdbc.jmx.StatisticsAwareJdbcClient.lambda$getTableHandle$3(StatisticsAwareJdbcClient.java:109)
at io.trino.plugin.jdbc.jmx.JdbcApiStats.wrap(JdbcApiStats.java:34)
at io.trino.plugin.jdbc.jmx.StatisticsAwareJdbcClient.getTableHandle(StatisticsAwareJdbcClient.java:109)
at io.trino.plugin.jdbc.CachingJdbcClient.lambda$getTableHandle$4(CachingJdbcClient.java:350)
at io.trino.cache.EmptyCache.get(EmptyCache.java:94)
at io.trino.plugin.jdbc.CachingJdbcClient.get(CachingJdbcClient.java:758)
at io.trino.plugin.jdbc.CachingJdbcClient.getTableHandle(CachingJdbcClient.java:350)
at io.trino.plugin.jdbc.CachingJdbcClient.lambda$getTableHandle$4(CachingJdbcClient.java:350)
at com.google.common.cache.LocalCache$LocalManualCache$1.load(LocalCache.java:4938)
at com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3576)
at com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2318)
at com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2191)
at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2081)
at com.google.common.cache.LocalCache.get(LocalCache.java:4019)
at com.google.common.cache.LocalCache$LocalManualCache.get(LocalCache.java:4933)
at io.trino.cache.EvictableCache.get(EvictableCache.java:112)
at io.trino.plugin.jdbc.CachingJdbcClient.get(CachingJdbcClient.java:758)
at io.trino.plugin.jdbc.CachingJdbcClient.getTableHandle(CachingJdbcClient.java:350)
at io.trino.plugin.jdbc.DefaultJdbcMetadata.getTableHandle(DefaultJdbcMetadata.java:144)
at io.trino.plugin.jdbc.DefaultJdbcMetadata.getTableHandle(DefaultJdbcMetadata.java:107)
at io.trino.spi.connector.ConnectorMetadata.getTableHandle(ConnectorMetadata.java:141)
at io.trino.plugin.base.classloader.ClassLoaderSafeConnectorMetadata.getTableHandle(ClassLoaderSafeConnectorMetadata.java:1196)
at io.trino.tracing.TracingConnectorMetadata.getTableHandle(TracingConnectorMetadata.java:149)
at io.trino.metadata.MetadataManager.lambda$getTableHandle$5(MetadataManager.java:286)
at java.base/java.util.Optional.flatMap(Optional.java:289)
at io.trino.metadata.MetadataManager.getTableHandle(MetadataManager.java:280)
at io.trino.metadata.MetadataManager.getRedirectionAwareTableHandle(MetadataManager.java:1779)
at io.trino.metadata.MetadataManager.getRedirectionAwareTableHandle(MetadataManager.java:1771)
at io.trino.tracing.TracingMetadata.getRedirectionAwareTableHandle(TracingMetadata.java:1399)
at io.trino.execution.DropTableTask.execute(DropTableTask.java:78)
at io.trino.execution.DropTableTask.execute(DropTableTask.java:36)
at io.trino.execution.DataDefinitionExecution.start(DataDefinitionExecution.java:145)
at io.trino.execution.SqlQueryManager.createQuery(SqlQueryManager.java:256)
at io.trino.dispatcher.LocalDispatchQuery.startExecution(LocalDispatchQuery.java:145)
at io.trino.dispatcher.LocalDispatchQuery.lambda$waitForMinimumWorkers$2(LocalDispatchQuery.java:129)
at io.airlift.concurrent.MoreFutures.lambda$addSuccessCallback$12(MoreFutures.java:568)
at io.airlift.concurrent.MoreFutures$3.onSuccess(MoreFutures.java:543)
at com.google.common.util.concurrent.Futures$CallbackListener.run(Futures.java:1133)
at io.trino.$gen.Trino_testversion____20231121_142743_75.run(Unknown Source)
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.sql.SQLException: java.sql.SQLException: Connection to trino-redshift-ci-cluster-8837528b77fbf267.c38hhhngrndv.us-east-2.redshift.amazonaws.com:5439 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
at io.trino.plugin.jdbc.TracingDataSource.getConnection(TracingDataSource.java:51)
at io.trino.plugin.jdbc.DriverConnectionFactory.openConnection(DriverConnectionFactory.java:78)
at io.trino.plugin.jdbc.jmx.StatisticsAwareConnectionFactory.lambda$openConnection$0(StatisticsAwareConnectionFactory.java:45)
at io.trino.plugin.jdbc.jmx.JdbcApiStats.wrap(JdbcApiStats.java:34)
at io.trino.plugin.jdbc.jmx.StatisticsAwareConnectionFactory.openConnection(StatisticsAwareConnectionFactory.java:45)
at io.trino.plugin.jdbc.RetryingConnectionFactory.lambda$openConnection$0(RetryingConnectionFactory.java:60)
at dev.failsafe.Functions.lambda$toCtxSupplier$11(Functions.java:243)
at dev.failsafe.Functions.lambda$get$0(Functions.java:46)
at dev.failsafe.internal.RetryPolicyExecutor.lambda$apply$0(RetryPolicyExecutor.java:74)
at dev.failsafe.SyncExecutionImpl.executeSync(SyncExecutionImpl.java:187)
at dev.failsafe.FailsafeExecutor.call(FailsafeExecutor.java:376)
at dev.failsafe.FailsafeExecutor.get(FailsafeExecutor.java:112)
at io.trino.plugin.jdbc.RetryingConnectionFactory.openConnection(RetryingConnectionFactory.java:60)
at io.trino.plugin.jdbc.LazyConnectionFactory.lambda$openConnection$0(LazyConnectionFactory.java:44)
at io.trino.plugin.jdbc.LazyConnectionFactory$LazyConnection.delegate(LazyConnectionFactory.java:75)
at io.trino.plugin.jdbc.ForwardingConnection.getMetaData(ForwardingConnection.java:117)
at io.trino.plugin.jdbc.ForwardingConnection.getMetaData(ForwardingConnection.java:117)
at io.trino.plugin.jdbc.BaseJdbcClient.getTables(BaseJdbcClient.java:1160)
at io.trino.plugin.jdbc.BaseJdbcClient.getTableHandle(BaseJdbcClient.java:215)
... 43 more
Suppressed: java.sql.SQLException: java.sql.SQLException: Connection to trino-redshift-ci-cluster-8837528b77fbf267.c38hhhngrndv.us-east-2.redshift.amazonaws.com:5439 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
at io.trino.plugin.jdbc.TracingDataSource.getConnection(TracingDataSource.java:51)
at io.trino.plugin.jdbc.DriverConnectionFactory.openConnection(DriverConnectionFactory.java:78)
at io.trino.plugin.jdbc.jmx.StatisticsAwareConnectionFactory.lambda$openConnection$0(StatisticsAwareConnectionFactory.java:45)
at io.trino.plugin.jdbc.jmx.JdbcApiStats.wrap(JdbcApiStats.java:34)
at io.trino.plugin.jdbc.jmx.StatisticsAwareConnectionFactory.openConnection(StatisticsAwareConnectionFactory.java:45)
at io.trino.plugin.jdbc.RetryingConnectionFactory.lambda$openConnection$0(RetryingConnectionFactory.java:60)
at dev.failsafe.Functions.lambda$toCtxSupplier$11(Functions.java:243)
at dev.failsafe.Functions.lambda$get$0(Functions.java:46)
at dev.failsafe.internal.RetryPolicyExecutor.lambda$apply$0(RetryPolicyExecutor.java:74)
at dev.failsafe.SyncExecutionImpl.executeSync(SyncExecutionImpl.java:187)
at dev.failsafe.FailsafeExecutor.call(FailsafeExecutor.java:376)
at dev.failsafe.FailsafeExecutor.get(FailsafeExecutor.java:112)
at io.trino.plugin.jdbc.RetryingConnectionFactory.openConnection(RetryingConnectionFactory.java:60)
at io.trino.plugin.jdbc.LazyConnectionFactory.lambda$openConnection$0(LazyConnectionFactory.java:44)
at io.trino.plugin.jdbc.LazyConnectionFactory$LazyConnection.delegate(LazyConnectionFactory.java:75)
at io.trino.plugin.jdbc.ForwardingConnection.isClosed(ForwardingConnection.java:110)
at io.trino.plugin.jdbc.ReusableConnectionFactory$CachedConnection.close(ReusableConnectionFactory.java:178)
at io.trino.plugin.jdbc.BaseJdbcClient.getTableHandle(BaseJdbcClient.java:210)
... 43 more
Caused by: java.sql.SQLException: Connection to trino-redshift-ci-cluster-8837528b77fbf267.c38hhhngrndv.us-east-2.redshift.amazonaws.com:5439 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
at com.amazon.redshift.util.RedshiftException.getSQLException(RedshiftException.java:56)
at com.amazon.redshift.Driver.connect(Driver.java:326)
at io.trino.plugin.jdbc.TracingDataSource$JdbcDataSource.getConnection(TracingDataSource.java:73)
at io.opentelemetry.instrumentation.jdbc.datasource.OpenTelemetryDataSource.wrapCall(OpenTelemetryDataSource.java:139)
at io.opentelemetry.instrumentation.jdbc.datasource.OpenTelemetryDataSource.getConnection(OpenTelemetryDataSource.java:77)
at io.trino.plugin.jdbc.TracingDataSource.getConnection(TracingDataSource.java:48)
... 60 more
Caused by: java.net.ConnectException: Connection refused
at java.base/sun.nio.ch.Net.pollConnect(Native Method)
at java.base/sun.nio.ch.Net.pollConnectNow(Net.java:682)
at java.base/sun.nio.ch.NioSocketImpl.timedFinishConnect(NioSocketImpl.java:549)
at java.base/sun.nio.ch.NioSocketImpl.connect(NioSocketImpl.java:592)
at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:327)
at java.base/java.net.Socket.connect(Socket.java:751)
at com.amazon.redshift.core.RedshiftStream.<init>(RedshiftStream.java:97)
at com.amazon.redshift.core.v3.ConnectionFactoryImpl.constructNewStream(ConnectionFactoryImpl.java:140)
at com.amazon.redshift.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:120)
at com.amazon.redshift.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:239)
at com.amazon.redshift.core.ConnectionFactory.openConnection(ConnectionFactory.java:51)
at com.amazon.redshift.jdbc.RedshiftConnectionImpl.<init>(RedshiftConnectionImpl.java:353)
at com.amazon.redshift.Driver.makeConnection(Driver.java:481)
at com.amazon.redshift.Driver.connect(Driver.java:302)
... 64 more
Caused by: java.sql.SQLException: Connection to trino-redshift-ci-cluster-8837528b77fbf267.c38hhhngrndv.us-east-2.redshift.amazonaws.com:5439 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
at com.amazon.redshift.util.RedshiftException.getSQLException(RedshiftException.java:56)
at com.amazon.redshift.Driver.connect(Driver.java:326)
at io.trino.plugin.jdbc.TracingDataSource$JdbcDataSource.getConnection(TracingDataSource.java:73)
at io.opentelemetry.instrumentation.jdbc.datasource.OpenTelemetryDataSource.wrapCall(OpenTelemetryDataSource.java:139)
at io.opentelemetry.instrumentation.jdbc.datasource.OpenTelemetryDataSource.getConnection(OpenTelemetryDataSource.java:77)
at io.trino.plugin.jdbc.TracingDataSource.getConnection(TracingDataSource.java:48)
... 61 more
Caused by: java.net.ConnectException: Connection refused
at java.base/sun.nio.ch.Net.pollConnect(Native Method)
at java.base/sun.nio.ch.Net.pollConnectNow(Net.java:682)
at java.base/sun.nio.ch.NioSocketImpl.timedFinishConnect(NioSocketImpl.java:549)
at java.base/sun.nio.ch.NioSocketImpl.connect(NioSocketImpl.java:592)
at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:327)
at java.base/java.net.Socket.connect(Socket.java:751)
at com.amazon.redshift.core.RedshiftStream.<init>(RedshiftStream.java:97)
at com.amazon.redshift.core.v3.ConnectionFactoryImpl.constructNewStream(ConnectionFactoryImpl.java:140)
at com.amazon.redshift.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:120)
at com.amazon.redshift.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:239)
at com.amazon.redshift.core.ConnectionFactory.openConnection(ConnectionFactory.java:51)
at com.amazon.redshift.jdbc.RedshiftConnectionImpl.<init>(RedshiftConnectionImpl.java:353)
at com.amazon.redshift.Driver.makeConnection(Driver.java:481)
at com.amazon.redshift.Driver.connect(Driver.java:302)
... 65 more
Caused by: java.lang.AssertionError: pgStatement.getConnection().getAutoCommit() should not throw
at com.amazon.redshift.jdbc.BatchResultHandler.isAutoCommit(BatchResultHandler.java:121)
at com.amazon.redshift.jdbc.BatchResultHandler.handleCompletion(BatchResultHandler.java:187)
at com.amazon.redshift.core.ResultHandlerDelegate.handleCompletion(ResultHandlerDelegate.java:61)
at com.amazon.redshift.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:616)
at com.amazon.redshift.jdbc.RedshiftStatementImpl.internalExecuteBatch(RedshiftStatementImpl.java:987)
at com.amazon.redshift.jdbc.RedshiftStatementImpl.executeBatch(RedshiftStatementImpl.java:1015)
at com.amazon.redshift.jdbc.RedshiftPreparedStatement.executeBatch(RedshiftPreparedStatement.java:1809)
at io.opentelemetry.instrumentation.jdbc.internal.OpenTelemetryStatement.wrapCall(OpenTelemetryStatement.java:294)
at io.opentelemetry.instrumentation.jdbc.internal.OpenTelemetryStatement.executeBatch(OpenTelemetryStatement.java:106)
at io.trino.plugin.jdbc.JdbcPageSink.appendPage(JdbcPageSink.java:153)
at io.trino.operator.TableWriterOperator.addInput(TableWriterOperator.java:255)
at io.trino.operator.Driver.processInternal(Driver.java:400)
at io.trino.operator.Driver.lambda$process$8(Driver.java:298)
at io.trino.operator.Driver.tryWithLock(Driver.java:694)
at io.trino.operator.Driver.process(Driver.java:290)
at io.trino.operator.Driver.processForDuration(Driver.java:261)
at io.trino.execution.SqlTaskExecution$DriverSplitRunner.processFor(SqlTaskExecution.java:887)
at io.trino.execution.executor.timesharing.PrioritizedSplitRunner.process(PrioritizedSplitRunner.java:187)
at io.trino.execution.executor.timesharing.TimeSharingTaskExecutor$TaskRunner.run(TimeSharingTaskExecutor.java:565)
at io.trino.$gen.Trino_testversion____20231121_142741_1.run(Unknown Source)
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)
Check failure on line 1 in io/trino/plugin/redshift/TestRedshiftQueryFailureRecoverySmokeTest
github-actions / Test Report
TestRedshiftQueryFailureRecoverySmokeTest.testInsert
An I/O error occurred while sending to the backend.
Raw output
io.trino.testing.QueryFailedException: An I/O error occurred while sending to the backend.
at io.trino.testing.AbstractTestingTrinoClient.execute(AbstractTestingTrinoClient.java:133)
at io.trino.testing.DistributedQueryRunner.executeWithQueryId(DistributedQueryRunner.java:502)
at io.trino.testing.BaseFailureRecoveryTest$FailureRecoveryAssert.execute(BaseFailureRecoveryTest.java:526)
at io.trino.testing.BaseFailureRecoveryTest$FailureRecoveryAssert.executeExpected(BaseFailureRecoveryTest.java:486)
at io.trino.testing.BaseFailureRecoveryTest$FailureRecoveryAssert.lambda$failsWithoutRetries$10(BaseFailureRecoveryTest.java:699)
at io.trino.testing.BaseFailureRecoveryTest$FailureRecoveryAssert.getFailureStageId(BaseFailureRecoveryTest.java:723)
at io.trino.testing.BaseFailureRecoveryTest$FailureRecoveryAssert.failsWithoutRetries(BaseFailureRecoveryTest.java:699)
at io.trino.testing.BaseFailureRecoveryTest.testNonSelect(BaseFailureRecoveryTest.java:355)
at io.trino.testing.BaseFailureRecoveryTest.testTableModification(BaseFailureRecoveryTest.java:306)
at io.trino.testing.BaseFailureRecoveryTest.testTableModification(BaseFailureRecoveryTest.java:301)
at io.trino.testing.BaseFailureRecoveryTest.testInsert(BaseFailureRecoveryTest.java:194)
at java.base/java.lang.reflect.Method.invoke(Method.java:580)
at java.base/java.util.concurrent.RecursiveAction.exec(RecursiveAction.java:194)
at java.base/java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:387)
at java.base/java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1312)
at java.base/java.util.concurrent.ForkJoinPool.scan(ForkJoinPool.java:1843)
at java.base/java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1808)
at java.base/java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:188)
Suppressed: java.lang.Exception: SQL: INSERT INTO table_4yqxdeb7xr SELECT * FROM orders
at io.trino.testing.DistributedQueryRunner.executeWithQueryId(DistributedQueryRunner.java:506)
... 16 more
Suppressed: io.trino.testing.QueryFailedException: java.sql.SQLException: Connection to trino-redshift-ci-cluster-8837528b77fbf267.c38hhhngrndv.us-east-2.redshift.amazonaws.com:5439 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
at io.trino.testing.AbstractTestingTrinoClient.execute(AbstractTestingTrinoClient.java:133)
at io.trino.testing.DistributedQueryRunner.executeWithQueryId(DistributedQueryRunner.java:502)
at io.trino.testing.DistributedQueryRunner.execute(DistributedQueryRunner.java:495)
at io.trino.testing.BaseFailureRecoveryTest$FailureRecoveryAssert.lambda$execute$3(BaseFailureRecoveryTest.java:552)
at java.base/java.util.Optional.ifPresent(Optional.java:178)
at io.trino.testing.BaseFailureRecoveryTest$FailureRecoveryAssert.execute(BaseFailureRecoveryTest.java:552)
... 15 more
Suppressed: java.lang.Exception: SQL: DROP TABLE table_4yqxdeb7xr
at io.trino.testing.DistributedQueryRunner.executeWithQueryId(DistributedQueryRunner.java:506)
... 19 more
Caused by: io.trino.spi.TrinoException: java.sql.SQLException: Connection to trino-redshift-ci-cluster-8837528b77fbf267.c38hhhngrndv.us-east-2.redshift.amazonaws.com:5439 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
at io.trino.plugin.jdbc.BaseJdbcClient.getTableHandle(BaseJdbcClient.java:230)
at io.trino.plugin.jdbc.ForwardingJdbcClient.getTableHandle(ForwardingJdbcClient.java:88)
at io.trino.plugin.jdbc.jmx.StatisticsAwareJdbcClient.lambda$getTableHandle$3(StatisticsAwareJdbcClient.java:109)
at io.trino.plugin.jdbc.jmx.JdbcApiStats.wrap(JdbcApiStats.java:34)
at io.trino.plugin.jdbc.jmx.StatisticsAwareJdbcClient.getTableHandle(StatisticsAwareJdbcClient.java:109)
at io.trino.plugin.jdbc.CachingJdbcClient.lambda$getTableHandle$4(CachingJdbcClient.java:350)
at io.trino.cache.EmptyCache.get(EmptyCache.java:94)
at io.trino.plugin.jdbc.CachingJdbcClient.get(CachingJdbcClient.java:758)
at io.trino.plugin.jdbc.CachingJdbcClient.getTableHandle(CachingJdbcClient.java:350)
at io.trino.plugin.jdbc.CachingJdbcClient.lambda$getTableHandle$4(CachingJdbcClient.java:350)
at com.google.common.cache.LocalCache$LocalManualCache$1.load(LocalCache.java:4938)
at com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3576)
at com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2318)
at com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2191)
at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2081)
at com.google.common.cache.LocalCache.get(LocalCache.java:4019)
at com.google.common.cache.LocalCache$LocalManualCache.get(LocalCache.java:4933)
at io.trino.cache.EvictableCache.get(EvictableCache.java:112)
at io.trino.plugin.jdbc.CachingJdbcClient.get(CachingJdbcClient.java:758)
at io.trino.plugin.jdbc.CachingJdbcClient.getTableHandle(CachingJdbcClient.java:350)
at io.trino.plugin.jdbc.DefaultJdbcMetadata.getTableHandle(DefaultJdbcMetadata.java:144)
at io.trino.plugin.jdbc.DefaultJdbcMetadata.getTableHandle(DefaultJdbcMetadata.java:107)
at io.trino.spi.connector.ConnectorMetadata.getTableHandle(ConnectorMetadata.java:141)
at io.trino.plugin.base.classloader.ClassLoaderSafeConnectorMetadata.getTableHandle(ClassLoaderSafeConnectorMetadata.java:1196)
at io.trino.tracing.TracingConnectorMetadata.getTableHandle(TracingConnectorMetadata.java:149)
at io.trino.metadata.MetadataManager.lambda$getTableHandle$5(MetadataManager.java:286)
at java.base/java.util.Optional.flatMap(Optional.java:289)
at io.trino.metadata.MetadataManager.getTableHandle(MetadataManager.java:280)
at io.trino.metadata.MetadataManager.getRedirectionAwareTableHandle(MetadataManager.java:1779)
at io.trino.metadata.MetadataManager.getRedirectionAwareTableHandle(MetadataManager.java:1771)
at io.trino.tracing.TracingMetadata.getRedirectionAwareTableHandle(TracingMetadata.java:1399)
at io.trino.execution.DropTableTask.execute(DropTableTask.java:78)
at io.trino.execution.DropTableTask.execute(DropTableTask.java:36)
at io.trino.execution.DataDefinitionExecution.start(DataDefinitionExecution.java:145)
at io.trino.execution.SqlQueryManager.createQuery(SqlQueryManager.java:256)
at io.trino.dispatcher.LocalDispatchQuery.startExecution(LocalDispatchQuery.java:145)
at io.trino.dispatcher.LocalDispatchQuery.lambda$waitForMinimumWorkers$2(LocalDispatchQuery.java:129)
at io.airlift.concurrent.MoreFutures.lambda$addSuccessCallback$12(MoreFutures.java:568)
at io.airlift.concurrent.MoreFutures$3.onSuccess(MoreFutures.java:543)
at com.google.common.util.concurrent.Futures$CallbackListener.run(Futures.java:1133)
at io.trino.$gen.Trino_testversion____20231121_142743_75.run(Unknown Source)
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.sql.SQLException: java.sql.SQLException: Connection to trino-redshift-ci-cluster-8837528b77fbf267.c38hhhngrndv.us-east-2.redshift.amazonaws.com:5439 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
at io.trino.plugin.jdbc.TracingDataSource.getConnection(TracingDataSource.java:51)
at io.trino.plugin.jdbc.DriverConnectionFactory.openConnection(DriverConnectionFactory.java:78)
at io.trino.plugin.jdbc.jmx.StatisticsAwareConnectionFactory.lambda$openConnection$0(StatisticsAwareConnectionFactory.java:45)
at io.trino.plugin.jdbc.jmx.JdbcApiStats.wrap(JdbcApiStats.java:34)
at io.trino.plugin.jdbc.jmx.StatisticsAwareConnectionFactory.openConnection(StatisticsAwareConnectionFactory.java:45)
at io.trino.plugin.jdbc.RetryingConnectionFactory.lambda$openConnection$0(RetryingConnectionFactory.java:60)
at dev.failsafe.Functions.lambda$toCtxSupplier$11(Functions.java:243)
at dev.failsafe.Functions.lambda$get$0(Functions.java:46)
at dev.failsafe.internal.RetryPolicyExecutor.lambda$apply$0(RetryPolicyExecutor.java:74)
at dev.failsafe.SyncExecutionImpl.executeSync(SyncExecutionImpl.java:187)
at dev.failsafe.FailsafeExecutor.call(FailsafeExecutor.java:376)
at dev.failsafe.FailsafeExecutor.get(FailsafeExecutor.java:112)
at io.trino.plugin.jdbc.RetryingConnectionFactory.openConnection(RetryingConnectionFactory.java:60)
at io.trino.plugin.jdbc.LazyConnectionFactory.lambda$openConnection$0(LazyConnectionFactory.java:44)
at io.trino.plugin.jdbc.LazyConnectionFactory$LazyConnection.delegate(LazyConnectionFactory.java:75)
at io.trino.plugin.jdbc.ForwardingConnection.getMetaData(ForwardingConnection.java:117)
at io.trino.plugin.jdbc.ForwardingConnection.getMetaData(ForwardingConnection.java:117)
at io.trino.plugin.jdbc.BaseJdbcClient.getTables(BaseJdbcClient.java:1160)
at io.trino.plugin.jdbc.BaseJdbcClient.getTableHandle(BaseJdbcClient.java:215)
... 43 more
Suppressed: java.sql.SQLException: java.sql.SQLException: Connection to trino-redshift-ci-cluster-8837528b77fbf267.c38hhhngrndv.us-east-2.redshift.amazonaws.com:5439 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
at io.trino.plugin.jdbc.TracingDataSource.getConnection(TracingDataSource.java:51)
at io.trino.plugin.jdbc.DriverConnectionFactory.openConnection(DriverConnectionFactory.java:78)
at io.trino.plugin.jdbc.jmx.StatisticsAwareConnectionFactory.lambda$openConnection$0(StatisticsAwareConnectionFactory.java:45)
at io.trino.plugin.jdbc.jmx.JdbcApiStats.wrap(JdbcApiStats.java:34)
at io.trino.plugin.jdbc.jmx.StatisticsAwareConnectionFactory.openConnection(StatisticsAwareConnectionFactory.java:45)
at io.trino.plugin.jdbc.RetryingConnectionFactory.lambda$openConnection$0(RetryingConnectionFactory.java:60)
at dev.failsafe.Functions.lambda$toCtxSupplier$11(Functions.java:243)
at dev.failsafe.Functions.lambda$get$0(Functions.java:46)
at dev.failsafe.internal.RetryPolicyExecutor.lambda$apply$0(RetryPolicyExecutor.java:74)
at dev.failsafe.SyncExecutionImpl.executeSync(SyncExecutionImpl.java:187)
at dev.failsafe.FailsafeExecutor.call(FailsafeExecutor.java:376)
at dev.failsafe.FailsafeExecutor.get(FailsafeExecutor.java:112)
at io.trino.plugin.jdbc.RetryingConnectionFactory.openConnection(RetryingConnectionFactory.java:60)
at io.trino.plugin.jdbc.LazyConnectionFactory.lambda$openConnection$0(LazyConnectionFactory.java:44)
at io.trino.plugin.jdbc.LazyConnectionFactory$LazyConnection.delegate(LazyConnectionFactory.java:75)
at io.trino.plugin.jdbc.ForwardingConnection.isClosed(ForwardingConnection.java:110)
at io.trino.plugin.jdbc.ReusableConnectionFactory$CachedConnection.close(ReusableConnectionFactory.java:178)
at io.trino.plugin.jdbc.BaseJdbcClient.getTableHandle(BaseJdbcClient.java:210)
... 43 more
Caused by: java.sql.SQLException: Connection to trino-redshift-ci-cluster-8837528b77fbf267.c38hhhngrndv.us-east-2.redshift.amazonaws.com:5439 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
at com.amazon.redshift.util.RedshiftException.getSQLException(RedshiftException.java:56)
at com.amazon.redshift.Driver.connect(Driver.java:326)
at io.trino.plugin.jdbc.TracingDataSource$JdbcDataSource.getConnection(TracingDataSource.java:73)
at io.opentelemetry.instrumentation.jdbc.datasource.OpenTelemetryDataSource.wrapCall(OpenTelemetryDataSource.java:139)
at io.opentelemetry.instrumentation.jdbc.datasource.OpenTelemetryDataSource.getConnection(OpenTelemetryDataSource.java:77)
at io.trino.plugin.jdbc.TracingDataSource.getConnection(TracingDataSource.java:48)
... 60 more
Caused by: java.net.ConnectException: Connection refused
at java.base/sun.nio.ch.Net.pollConnect(Native Method)
at java.base/sun.nio.ch.Net.pollConnectNow(Net.java:682)
at java.base/sun.nio.ch.NioSocketImpl.timedFinishConnect(NioSocketImpl.java:549)
at java.base/sun.nio.ch.NioSocketImpl.connect(NioSocketImpl.java:592)
at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:327)
at java.base/java.net.Socket.connect(Socket.java:751)
at com.amazon.redshift.core.RedshiftStream.<init>(RedshiftStream.java:97)
at com.amazon.redshift.core.v3.ConnectionFactoryImpl.constructNewStream(ConnectionFactoryImpl.java:140)
at com.amazon.redshift.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:120)
at com.amazon.redshift.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:239)
at com.amazon.redshift.core.ConnectionFactory.openConnection(ConnectionFactory.java:51)
at com.amazon.redshift.jdbc.RedshiftConnectionImpl.<init>(RedshiftConnectionImpl.java:353)
at com.amazon.redshift.Driver.makeConnection(Driver.java:481)
at com.amazon.redshift.Driver.connect(Driver.java:302)
... 64 more
Caused by: java.sql.SQLException: Connection to trino-redshift-ci-cluster-8837528b77fbf267.c38hhhngrndv.us-east-2.redshift.amazonaws.com:5439 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
at com.amazon.redshift.util.RedshiftException.getSQLException(RedshiftException.java:56)
at com.amazon.redshift.Driver.connect(Driver.java:326)
at io.trino.plugin.jdbc.TracingDataSource$JdbcDataSource.getConnection(TracingDataSource.java:73)
at io.opentelemetry.instrumentation.jdbc.datasource.OpenTelemetryDataSource.wrapCall(OpenTelemetryDataSource.java:139)
at io.opentelemetry.instrumentation.jdbc.datasource.OpenTelemetryDataSource.getConnection(OpenTelemetryDataSource.java:77)
at io.trino.plugin.jdbc.TracingDataSource.getConnection(TracingDataSource.java:48)
... 61 more
Caused by: java.net.ConnectException: Connection refused
at java.base/sun.nio.ch.Net.pollConnect(Native Method)
at java.base/sun.nio.ch.Net.pollConnectNow(Net.java:682)
at java.base/sun.nio.ch.NioSocketImpl.timedFinishConnect(NioSocketImpl.java:549)
at java.base/sun.nio.ch.NioSocketImpl.connect(NioSocketImpl.java:592)
at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:327)
at java.base/java.net.Socket.connect(Socket.java:751)
at com.amazon.redshift.core.RedshiftStream.<init>(RedshiftStream.java:97)
at com.amazon.redshift.core.v3.ConnectionFactoryImpl.constructNewStream(ConnectionFactoryImpl.java:140)
at com.amazon.redshift.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:120)
at com.amazon.redshift.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:239)
at com.amazon.redshift.core.ConnectionFactory.openConnection(ConnectionFactory.java:51)
at com.amazon.redshift.jdbc.RedshiftConnectionImpl.<init>(RedshiftConnectionImpl.java:353)
at com.amazon.redshift.Driver.makeConnection(Driver.java:481)
at com.amazon.redshift.Driver.connect(Driver.java:302)
... 65 more
Caused by: io.trino.spi.TrinoException: An I/O error occurred while sending to the backend.
at io.trino.plugin.jdbc.BaseJdbcClient.getColumns(BaseJdbcClient.java:350)
at io.trino.plugin.jdbc.ForwardingJdbcClient.getColumns(ForwardingJdbcClient.java:106)
at io.trino.plugin.jdbc.jmx.StatisticsAwareJdbcClient.lambda$getColumns$6(StatisticsAwareJdbcClient.java:127)
at io.trino.plugin.jdbc.jmx.JdbcApiStats.wrap(JdbcApiStats.java:34)
at io.trino.plugin.jdbc.jmx.StatisticsAwareJdbcClient.getColumns(StatisticsAwareJdbcClient.java:127)
at io.trino.plugin.jdbc.CachingJdbcClient.lambda$getColumns$3(CachingJdbcClient.java:197)
at io.trino.cache.EmptyCache.get(EmptyCache.java:94)
at io.trino.plugin.jdbc.CachingJdbcClient.get(CachingJdbcClient.java:758)
at io.trino.plugin.jdbc.CachingJdbcClient.getColumns(CachingJdbcClient.java:197)
at io.trino.plugin.jdbc.CachingJdbcClient.lambda$getColumns$3(CachingJdbcClient.java:197)
at com.google.common.cache.LocalCache$LocalManualCache$1.load(LocalCache.java:4938)
at com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3576)
at com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2318)
at com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2191)
at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2081)
at com.google.common.cache.LocalCache.get(LocalCache.java:4019)
at com.google.common.cache.LocalCache$LocalManualCache.get(LocalCache.java:4933)
at io.trino.cache.EvictableCache.get(EvictableCache.java:112)
at io.trino.plugin.jdbc.CachingJdbcClient.get(CachingJdbcClient.java:758)
at io.trino.plugin.jdbc.CachingJdbcClient.getColumns(CachingJdbcClient.java:197)
at io.trino.plugin.jdbc.DefaultJdbcMetadata.getTableSchema(DefaultJdbcMetadata.java:711)
at io.trino.plugin.base.classloader.ClassLoaderSafeConnectorMetadata.getTableSchema(ClassLoaderSafeConnectorMetadata.java:269)
at io.trino.tracing.TracingConnectorMetadata.getTableSchema(TracingConnectorMetadata.java:239)
at io.trino.metadata.MetadataManager.getTableSchema(MetadataManager.java:455)
at io.trino.tracing.TracingMetadata.getTableSchema(TracingMetadata.java:289)
at io.trino.sql.analyzer.StatementAnalyzer$Visitor.visitTable(StatementAnalyzer.java:2267)
at io.trino.sql.analyzer.StatementAnalyzer$Visitor.visitTable(StatementAnalyzer.java:497)
at io.trino.sql.tree.Table.accept(Table.java:60)
at io.trino.sql.tree.AstVisitor.process(AstVisitor.java:27)
at io.trino.sql.analyzer.StatementAnalyzer$Visitor.process(StatementAnalyzer.java:516)
at io.trino.sql.analyzer.StatementAnalyzer$Visitor.analyzeFrom(StatementAnalyzer.java:4581)
at io.trino.sql.analyzer.StatementAnalyzer$Visitor.visitQuerySpecification(StatementAnalyzer.java:3038)
at io.trino.sql.analyzer.StatementAnalyzer$Visitor.visitQuerySpecification(StatementAnalyzer.java:497)
at io.trino.sql.tree.QuerySpecification.accept(QuerySpecification.java:155)
at io.trino.sql.tree.AstVisitor.process(AstVisitor.java:27)
at io.trino.sql.analyzer.StatementAnalyzer$Visitor.process(StatementAnalyzer.java:516)
at io.trino.sql.analyzer.StatementAnalyzer$Visitor.process(StatementAnalyzer.java:524)
at io.trino.sql.analyzer.StatementAnalyzer$Visitor.visitQuery(StatementAnalyzer.java:1534)
at io.trino.sql.analyzer.StatementAnalyzer$Visitor.visitQuery(StatementAnalyzer.java:497)
at io.trino.sql.tree.Query.accept(Query.java:118)
at io.trino.sql.tree.AstVisitor.process(AstVisitor.java:27)
at io.trino.sql.analyzer.StatementAnalyzer$Visitor.process(StatementAnalyzer.java:516)
at io.trino.sql.analyzer.StatementAnalyzer.analyze(StatementAnalyzer.java:476)
at io.trino.sql.analyzer.StatementAnalyzer.analyze(StatementAnalyzer.java:465)
at io.trino.sql.analyzer.StatementAnalyzer$Visitor.visitInsert(StatementAnalyzer.java:553)
at io.trino.sql.analyzer.StatementAnalyzer$Visitor.visitInsert(StatementAnalyzer.java:497)
at io.trino.sql.tree.Insert.accept(Insert.java:68)
at io.trino.sql.tree.AstVisitor.process(AstVisitor.java:27)
at io.trino.sql.analyzer.StatementAnalyzer$Visitor.process(StatementAnalyzer.java:516)
at io.trino.sql.analyzer.StatementAnalyzer.analyze(StatementAnalyzer.java:476)
at io.trino.sql.analyzer.StatementAnalyzer.analyze(StatementAnalyzer.java:465)
at io.trino.sql.analyzer.Analyzer.analyze(Analyzer.java:97)
at io.trino.sql.analyzer.Analyzer.analyze(Analyzer.java:86)
at io.trino.execution.SqlQueryExecution.analyze(SqlQueryExecution.java:274)
at io.trino.execution.SqlQueryExecution.<init>(SqlQueryExecution.java:209)
at io.trino.execution.SqlQueryExecution$SqlQueryExecutionFactory.createQueryExecution(SqlQueryExecution.java:850)
at io.trino.dispatcher.LocalDispatchQueryFactory.lambda$createDispatchQuery$0(LocalDispatchQueryFactory.java:153)
at io.trino.$gen.Trino_testversion____20231121_142743_75.call(Unknown Source)
at com.google.common.util.concurrent.TrustedListenableFutureTask$TrustedFutureInterruptibleTask.runInterruptibly(TrustedListenableFutureTask.java:131)
at com.google.common.util.concurrent.InterruptibleTask.run(InterruptibleTask.java:76)
at com.google.common.util.concurrent.TrustedListenableFutureTask.run(TrustedListenableFutureTask.java:82)
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: 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 io.trino.plugin.jdbc.BaseJdbcClient.getColumns(BaseJdbcClient.java:373)
at io.trino.plugin.jdbc.BaseJdbcClient.getColumns(BaseJdbcClient.java:301)
... 63 more
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)
... 72 more
Check failure on line 1 in io/trino/plugin/redshift/TestRedshiftQueryFailureRecoverySmokeTest
github-actions / Test Report
TestRedshiftQueryFailureRecoverySmokeTest.testExplainAnalyze
Expecting throwable message:
"java.sql.SQLException: The connection attempt failed."
to contain:
"Encountered too many errors talking to a worker node"
but did not.
Throwable that failed the check:
io.trino.testing.QueryFailedException: java.sql.SQLException: The connection attempt failed.
at io.trino.testing.AbstractTestingTrinoClient.execute(AbstractTestingTrinoClient.java:133)
at io.trino.testing.DistributedQueryRunner.executeWithQueryId(DistributedQueryRunner.java:502)
at io.trino.testing.BaseFailureRecoveryTest$FailureRecoveryAssert.execute(BaseFailureRecoveryTest.java:526)
at io.trino.testing.BaseFailureRecoveryTest$FailureRecoveryAssert.executeActual(BaseFailureRecoveryTest.java:511)
at io.trino.testing.BaseFailureRecoveryTest$FailureRecoveryAssert.executeActualNoRetries(BaseFailureRecoveryTest.java:496)
at io.trino.testing.BaseFailureRecoveryTest$FailureRecoveryAssert.lambda$failsWithoutRetries$11(BaseFailureRecoveryTest.java:700)
at org.assertj.core.api.ThrowableAssert.catchThrowable(ThrowableAssert.java:63)
at org.assertj.core.api.AssertionsForClassTypes.catchThrowable(AssertionsForClassTypes.java:892)
at org.assertj.core.api.Assertions.catchThrowable(Assertions.java:1366)
at org.assertj.core.api.Assertions.assertThatThrownBy(Assertions.java:1210)
at io.trino.testing.BaseFailureRecoveryTest$FailureRecoveryAssert.failsWithoutRetries(BaseFailureRecoveryTest.java:700)
at io.trino.testing.BaseFailureRecoveryTest.testNonSelect(BaseFailureRecoveryTest.java:355)
at io.trino.testing.BaseFailureRecoveryTest.testTableModification(BaseFailureRecoveryTest.java:306)
at io.trino.testing.BaseFailureRecoveryTest.testTableModification(BaseFailureRecoveryTest.java:301)
at io.trino.testing.BaseFailureRecoveryTest.testExplainAnalyze(BaseFailureRecoveryTest.java:278)
at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
at java.base/java.lang.reflect.Method.invoke(Method.java:580)
at org.junit.platform.commons.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:728)
at org.junit.jupiter.engine.execution.MethodInvocation.proceed(MethodInvocation.java:60)
at org.junit.jupiter.engine.execution.InvocationInterceptorChain$ValidatingInvocation.proceed(InvocationInterceptorChain.java:131)
at org.junit.jupiter.engine.extension.TimeoutExtension.intercept(TimeoutExtension.java:156)
at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestableMethod(TimeoutExtension.java:147)
at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestMethod(TimeoutExtension.java:86)
at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker$ReflectiveInterceptorCall.lambda$ofVoidMethod$0(InterceptingExecutableInvoker.java:103)
at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.lambda$invoke$0(InterceptingExecutableInvoker.java:93)
at org.junit.jupiter.engine.execution.InvocationInterceptorChain$InterceptedInvocation.proceed(InvocationInterceptorChain.java:106)
at org.junit.jupiter.engine.execution.InvocationInterceptorChain.proceed(InvocationInterceptorChain.java:64)
at org.junit.jupiter.engine.execution.InvocationInterceptorChain.chainAndInvoke(InvocationInterceptorChain.java:45)
at org.junit.jupiter.engine.execution.InvocationInterceptorChain.invoke(InvocationInterceptorChain.java:37)
at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:92)
at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:86)
at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.lambda$invokeTestMethod$7(TestMethodTestDescriptor.java:218)
at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.invokeTestMethod(TestMethodTestDescriptor.java:214)
at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:139)
at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:69)
at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$6(NodeTestTask.java:151)
at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:141)
at org.junit.platform.engine.support.hierarchical.Node.around(Node.java:137)
at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$9(NodeTestTask.java:139)
at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
at org.junit.platform.engine.support.hierarchical.NodeTestTask.executeRecursively(NodeTestTask.java:138)
at org.junit.platform.engine.support.hierarchical.NodeTestTask.execute(NodeTestTask.java:95)
at org.junit.platform.engine.support.hierarchical.ForkJoinPoolHierarchicalTestExecutorService$ExclusiveTask.compute(ForkJoinPoolHierarchicalTestExecutorService.java:202)
at java.base/java.util.concurrent.RecursiveAction.exec(RecursiveAction.java:194)
at java.base/java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:387)
at java.base/java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1312)
at java.base/java.util.concurrent.ForkJoinPool.scan(ForkJoinPool.java:1843)
at java.base/java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1808)
at java.base/java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:188)
Suppressed: java.lang.Exception: SQL: EXPLAIN ANALYZE INSERT INTO table_bxyd5y6f5r SELECT * FROM orders
at io.trino.testing.DistributedQueryRunner.executeWithQueryId(DistributedQueryRunner.java:506)
... 49 more
Suppressed: io.trino.testing.QueryFailedException: java.sql.SQLException: Connection to trino-redshift-ci-cluster-8837528b77fbf267.c38hhhngrndv.us-east-2.redshift.amazonaws.com:5439 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
at io.trino.testing.AbstractTestingTrinoClient.execute(AbstractTestingTrinoClient.java:133)
at io.trino.testing.DistributedQueryRunner.executeWithQueryId(DistributedQueryRunner.java:502)
at io.trino.testing.DistributedQueryRunner.execute(DistributedQueryRunner.java:495)
at io.trino.testing.BaseFailureRecoveryTest$FailureRecoveryAssert.lambda$execute$3(BaseFailureRecoveryTest.java:552)
at java.base/java.util.Optional.ifPresent(Optional.java:178)
at io.trino.testing.BaseFailureRecoveryTest$FailureRecoveryAssert.execute(BaseFailureRecoveryTest.java:552)
... 48 more
Suppressed: java.lang.Exception: SQL: DROP TABLE table_bxyd5y6f5r
at io.trino.testing.DistributedQueryRunner.executeWithQueryId(DistributedQueryRunner.java:506)
... 52 more
Caused by: io.trino.spi.TrinoException: java.sql.SQLException: Connection to trino-redshift-ci-cluster-8837528b77fbf267.c38hhhngrndv.us-east-2.redshift.amazonaws.com:5439 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
at io.trino.plugin.jdbc.BaseJdbcClient.getTableHandle(BaseJdbcClient.java:230)
at io.trino.plugin.jdbc.ForwardingJdbcClient.getTableHandle(ForwardingJdbcClient.java:88)
at io.trino.plugin.jdbc.jmx.StatisticsAwareJdbcClient.lambda$getTableHandle$3(StatisticsAwareJdbcClient.java:109)
at io.trino.plugin.jdbc.jmx.JdbcApiStats.wrap(JdbcApiStats.java:34)
at io.trino.plugin.jdbc.jmx.StatisticsAwareJdbcClient.getTableHandle(StatisticsAwareJdbcClient.java:109)
at io.trino.plugin.jdbc.CachingJdbcClient.lambda$getTableHandle$4(CachingJdbcClient.java:350)
at io.trino.cache.EmptyCache.get(EmptyCache.java:94)
at io.trino.plugin.jdbc.CachingJdbcClient.get(CachingJdbcClient.java:758)
at io.trino.plugin.jdbc.CachingJdbcClient.getTableHandle(CachingJdbcClient.java:350)
at io.trino.plugin.jdbc.CachingJdbcClient.lambda$getTableHandle$4(CachingJdbcClient.java:350)
at com.google.common.cache.LocalCache$LocalManualCache$1.load(LocalCache.java:4938)
at com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3576)
at com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2318)
at com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2191)
at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2081)
at com.google.common.cache.LocalCache.get(LocalCache.java:4019)
at com.google.common.cache.LocalCache$LocalManualCache.get(LocalCache.java:4933)
at io.trino.cache.EvictableCache.get(EvictableCache.java:112)
at io.trino.plugin.jdbc.CachingJdbcClient.get(CachingJdbcClient.java:758)
at io.trino.plugin.jdbc.CachingJdbcClient.getTableHandle(CachingJdbcClient.java:350)
at io.trino.plugin.jdbc.DefaultJdbcMetadata.getTableHandle(DefaultJdbcMetadata.java:144)
at io.trino.plugin.jdbc.DefaultJdbcMetadata.getTableHandle(DefaultJdbcMetadata.java:107)
at io.trino.spi.connector.ConnectorMetadata.getTableHandle(ConnectorMetadata.java:141)
at io.trino.plugin.base.classloader.ClassLoaderSafeConnectorMetadata.getTableHandle(ClassLoaderSafeConnectorMetadata.java:1196)
at io.trino.tracing.TracingConnectorMetadata.getTableHandle(TracingConnectorMetadata.java:149)
at io.trino.metadata.MetadataManager.lambda$getTableHandle$5(MetadataManager.java:286)
at java.base/java.util.Optional.flatMap(Optional.java:289)
at io.trino.metadata.MetadataManager.getTableHandle(MetadataManager.java:280)
at io.trino.metadata.MetadataManager.getRedirectionAwareTableHandle(MetadataManager.java:1779)
at io.trino.metadata.MetadataManager.getRedirectionAwareTableHandle(MetadataManager.java:1771)
at io.trino.tracing.TracingMetadata.getRedirectionAwareTableHandle(TracingMetadata.java:1399)
at io.trino.execution.DropTableTask.execute(DropTableTask.java:78)
at io.trino.execution.DropTableTask.execute(DropTableTask.java:36)
at io.trino.execution.DataDefinitionExecution.start(DataDefinitionExecution.java:145)
at io.trino.execution.SqlQueryManager.createQuery(SqlQueryManager.java:256)
at io.trino.dispatcher.LocalDispatchQuery.startExecution(LocalDispatchQuery.java:145)
at io.trino.dispatcher.LocalDispatchQuery.lambda$waitForMinimumWorkers$2(LocalDispatchQuery.java:129)
at io.airlift.concurrent.MoreFutures.lambda$addSuccessCallback$12(MoreFutures.java:568)
at io.airlift.concurrent.MoreFutures$3.onSuccess(MoreFutures.java:543)
at com.google.common.util.concurrent.Futures$CallbackListener.run(Futures.java:1133)
at io.trino.$gen.Trino_testversion____20231121_142743_75.run(Unknown Source)
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.sql.SQLException: java.sql.SQLException: Connection to trino-redshift-ci-cluster-8837528b77fbf267.c38hhhngrndv.us-east-2.redshift.amazonaws.com:5439 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
at io.trino.plugin.jdbc.TracingDataSource.getConnection(TracingDataSource.java:51)
at io.trino.plugin.jdbc.DriverConnectionFactory.openConnection(DriverConnectionFactory.java:78)
at io.trino.plugin.jdbc.jmx.StatisticsAwareConnectionFactory.lambda$openConnection$0(StatisticsAwareConnectionFactory.java:45)
at io.trino.plugin.jdbc.jmx.JdbcApiStats.wrap(JdbcApiStats.java:34)
at io.trino.plugin.jdbc.jmx.StatisticsAwareConnectionFactory.openConnection(StatisticsAwareConnectionFactory.java:45)
at io.trino.plugin.jdbc.RetryingConnectionFactory.lambda$openConnection$0(RetryingConnectionFactory.java:60)
at dev.failsafe.Functions.lambda$toCtxSupplier$11(Functions.java:243)
at dev.failsafe.Functions.lambda$get$0(Functions.java:46)
at dev.failsafe.internal.RetryPolicyExecutor.lambda$apply$0(RetryPolicyExecutor.java:74)
at dev.failsafe.SyncExecutionImpl.executeSync(SyncExecutionImpl.java:187)
at dev.failsafe.FailsafeExecutor.call(FailsafeExecutor.java:376)
at dev.failsafe.FailsafeExecutor.get(FailsafeExecutor.java:112)
at io.trino.plugin.jdbc.RetryingConnectionFactory.openConnection(RetryingConnectionFactory.java:60)
at io.trino.plugin.jdbc.LazyConnectionFactory.lambda$openConnection$0(LazyConnectionFactory.java:44)
at io.trino.plugin.jdbc.LazyConnectionFactory$LazyConnection.delegate(LazyConnectionFactory.java:75)
at io.trino.plugin.jdbc.ForwardingConnection.getMetaData(ForwardingConnection.java:117)
at io.trino.plugin.jdbc.ForwardingConnection.getMetaData(ForwardingConnection.java:117)
at io.trino.plugin.jdbc.BaseJdbcClient.getTables(BaseJdbcClient.java:1160)
at io.trino.plugin.jdbc.BaseJdbcClient.getTableHandle(BaseJdbcClient.java:215)
... 43 more
Suppressed: java.sql.SQLException: java.sql.SQLException: Connection to trino-redshift-ci-cluster-8837528b77fbf267.c38hhhngrndv.us-east-2.redshift.amazonaws.com:5439 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
at io.trino.plugin.jdbc.TracingDataSource.getConnection(TracingDataSource.java:51)
at io.trino.plugin.jdbc.DriverConnectionFactory.openConnection(DriverConnectionFactory.java:78)
at io.trino.plugin.jdbc.jmx.StatisticsAwareConnectionFactory.lambda$openConnection$0(StatisticsAwareConnectionFactory.java:45)
at io.trino.plugin.jdbc.jmx.JdbcApiStats.wrap(JdbcApiStats.java:34)
at io.trino.plugin.jdbc.jmx.StatisticsAwareConnectionFactory.openConnection(StatisticsAwareConnectionFactory.java:45)
at io.trino.plugin.jdbc.RetryingConnectionFactory.lambda$openConnection$0(RetryingConnectionFactory.java:60)
at dev.failsafe.Functions.lambda$toCtxSupplier$11(Functions.java:243)
at dev.failsafe.Functions.lambda$get$0(Functions.java:46)
at dev.failsafe.internal.RetryPolicyExecutor.lambda$apply$0(RetryPolicyExecutor.java:74)
at dev.failsafe.SyncExecutionImpl.executeSync(SyncExecutionImpl.java:187)
at dev.failsafe.FailsafeExecutor.call(FailsafeExecutor.java:376)
at dev.failsafe.FailsafeExecutor.get(FailsafeExecutor.java:112)
at io.trino.plugin.jdbc.RetryingConnectionFactory.openConnection(RetryingConnectionFactory.java:60)
at io.trino.plugin.jdbc.LazyConnectionFactory.lambda$openConnection$0(LazyConnectionFactory.java:44)
at io.trino.plugin.jdbc.LazyConnectionFactory$LazyConnection.delegate(LazyConnectionFactory.java:75)
at io.trino.plugin.jdbc.ForwardingConnection.isClosed(ForwardingConnection.java:110)
at io.trino.plugin.jdbc.ReusableConnectionFactory$CachedConnection.close(ReusableConnectionFactory.java:178)
at io.trino.plugin.jdbc.BaseJdbcClient.getTableHandle(BaseJdbcClient.java:210)
... 43 more
Caused by: java.sql.SQLException: Connection to trino-redshift-ci-cluster-8837528b77fbf267.c38hhhngrndv.us-east-2.redshift.amazonaws.com:5439 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
at com.amazon.redshift.util.RedshiftException.getSQLException(RedshiftException.java:56)
at com.amazon.redshift.Driver.connect(Driver.java:326)
at io.trino.plugin.jdbc.TracingDataSource$JdbcDataSource.getConnection(TracingDataSource.java:73)
at io.opentelemetry.instrumentation.jdbc.datasource.OpenTelemetryDataSource.wrapCall(OpenTelemetryDataSource.java:139)
at io.opentelemetry.instrumentation.jdbc.datasource.OpenTelemetryDataSource.getConnection(OpenTelemetryDataSource.java:77)
at io.trino.plugin.jdbc.TracingDataSource.getConnection(TracingDataSource.java:48)
... 60 more
Caused by: java.net.ConnectException: Connection refused
at java.base/sun.nio.ch.Net.pollConnect(Native Method)
at java.base/sun.nio.ch.Net.pollConnectNow(Net.java:682)
at java.base/sun.nio.ch.NioSocketImpl.timedFinishConnect(NioSocketImpl.java:549)
at java.base/sun.nio.ch.NioSocketImpl.connect(NioSocketImpl.java:592)
at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:327)
at java.base/java.net.Socket.connect(Socket.java:751)
at com.amazon.redshift.core.RedshiftStream.<init>(RedshiftStream.java:97)
at com.amazon.redshift.core.v3.ConnectionFactoryImpl.constructNewStream(ConnectionFactoryImpl.java:140)
at com.amazon.redshift.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:120)
at com.amazon.redshift.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:239)
at com.amazon.redshift.core.ConnectionFactory.openConnection(ConnectionFactory.java:51)
at com.amazon.redshift.jdbc.RedshiftConnectionImpl.<init>(RedshiftConnectionImpl.java:353)
at com.amazon.redshift.Driver.makeConnection(Driver.java:481)
at com.amazon.redshift.Driver.connect(Driver.java:302)
... 64 more
Caused by: java.sql.SQLException: Connection to trino-redshift-ci-cluster-8837528b77fbf267.c38hhhngrndv.us-east-2.redshift.amazonaws.com:5439 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
at com.amazon.redshift.util.RedshiftException.getSQLException(RedshiftException.java:56)
at com.amazon.redshift.Driver.connect(Driver.java:326)
at io.trino.plugin.jdbc.TracingDataSource$JdbcDataSource.getConnection(TracingDataSource.java:73)
at io.opentelemetry.instrumentation.jdbc.datasource.OpenTelemetryDataSource.wrapCall(OpenTelemetryDataSource.java:139)
at io.opentelemetry.instrumentation.jdbc.datasource.OpenTelemetryDataSource.getConnection(OpenTelemetryDataSource.java:77)
at io.trino.plugin.jdbc.TracingDataSource.getConnection(TracingDataSource.java:48)
... 61 more
Caused by: java.net.ConnectException: Connection refused
at java.base/sun.nio.ch.Net.pollConnect(Native Method)
at java.base/sun.nio.ch.Net.pollConnectNow(Net.java:682)
at java.base/sun.nio.ch.NioSocketImpl.timedFinishConnect(NioSocketImpl.java:549)
at java.base/sun.nio.ch.NioSocketImpl.connect(NioSocketImpl.java:592)
at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:327)
at java.base/java.net.Socket.connect(Socket.java:751)
at com.amazon.redshift.core.RedshiftStream.<init>(RedshiftStream.java:97)
at com.amazon.redshift.core.v3.ConnectionFactoryImpl.constructNewStream(ConnectionFactoryImpl.java:140)
at com.amazon.redshift.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:120)
at com.amazon.redshift.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:239)
at com.amazon.redshift.core.ConnectionFactory.openConnection(ConnectionFactory.java:51)
at com.amazon.redshift.jdbc.RedshiftConnectionImpl.<init>(RedshiftConnectionImpl.java:353)
at com.amazon.redshift.Driver.makeConnection(Driver.java:481)
at com.amazon.redshift.Driver.connect(Driver.java:302)
... 65 more
Caused by: io.trino.spi.TrinoException: java.sql.SQLException: The connection attempt failed.
at io.trino.plugin.jdbc.JdbcPageSink.<init>(JdbcPageSink.java:80)
at io.trino.plugin.jdbc.JdbcPageSinkProvider.createPageSink(JdbcPageSinkProvider.java:50)
at io.trino.split.PageSinkManager.createPageSink(PageSinkManager.java:56)
at io.trino.operator.TableWriterOperator$TableWriterOperatorFactory.createPageSink(TableWriterOperator.java:126)
at io.trino.operator.TableWriterOperator$TableWriterOperatorFactory.createOperator(TableWriterOperator.java:117)
at io.trino.operator.DriverFactory.createDriver(DriverFactory.java:105)
at io.trino.execution.SqlTaskExecution$DriverSplitRunnerFactory.createDriver(SqlTaskExecution.java:665)
at io.trino.execution.SqlTaskExecution$DriverSplitRunner.processFor(SqlTaskExecution.java:876)
at io.trino.execution.executor.timesharing.PrioritizedSplitRunner.process(PrioritizedSplitRunner.java:187)
at io.trino.execution.executor.timesharing.TimeSharingTaskExecutor$TaskRunner.run(TimeSharingTaskExecutor.java:565)
at io.trino.$gen.Trino_testversion____20231121_142741_1.run(Unknown Source)
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.sql.SQLException: java.sql.SQLException: The connection attempt failed.
at io.trino.plugin.jdbc.TracingDataSource.getConnection(TracingDataSource.java:51)
at io.trino.plugin.jdbc.DriverConnectionFactory.openConnection(DriverConnectionFactory.java:78)
at io.trino.plugin.jdbc.jmx.StatisticsAwareConnectionFactory.lambda$openConnection$0(StatisticsAwareConnectionFactory.java:45)
at io.trino.plugin.jdbc.jmx.JdbcApiStats.wrap(JdbcApiStats.java:34)
at io.trino.plugin.jdbc.jmx.StatisticsAwareConnectionFactory.openConnection(StatisticsAwareConnectionFactory.java:45)
at io.trino.plugin.jdbc.RetryingConnectionFactory.lambda$openConnection$0(RetryingConnectionFactory.java:60)
at dev.failsafe.Functions.lambda$toCtxSupplier$11(Functions.java:243)
at dev.failsafe.Functions.lambda$get$0(Functions.java:46)
at dev.failsafe.internal.RetryPolicyExecutor.lambda$apply$0(RetryPolicyExecutor.java:74)
at dev.failsafe.SyncExecutionImpl.executeSync(SyncExecutionImpl.java:187)
at dev.failsafe.FailsafeExecutor.call(FailsafeExecutor.java:376)
at dev.failsafe.FailsafeExecutor.get(FailsafeExecutor.java:112)
at io.trino.plugin.jdbc.RetryingConnectionFactory.openConnection(RetryingConnectionFactory.java:60)
at io.trino.plugin.jdbc.LazyConnectionFactory.lambda$openConnection$0(LazyConnectionFactory.java:44)
at io.trino.plugin.jdbc.LazyConnectionFactory$LazyConnection.delegate(LazyConnectionFactory.java:75)
at io.trino.plugin.jdbc.ForwardingConnection.setAutoCommit(ForwardingConnection.java:75)
at io.trino.plugin.jdbc.JdbcPageSink.<init>(JdbcPageSink.java:76)
... 13 more
Caused by: java.sql.SQLException: The connection attempt failed.
at com.amazon.redshift.util.RedshiftException.getSQLException(RedshiftException.java:56)
at com.amazon.redshift.Driver.connect(Driver.java:326)
at io.trino.plugin.jdbc.TracingDataSource$JdbcDataSource.getConnection(TracingDataSource.java:73)
at io.opentelemetry.instrumentation.jdbc.datasource.OpenTelemetryDataSource.wrapCall(OpenTelemetryDataSource.java:139)
at io.opentelemetry.instrumentation.jdbc.datasource.OpenTelemetryDataSource.getConnection(OpenTelemetryDataSource.java:77)
at io.trino.plugin.jdbc.TracingDataSource.getConnection(TracingDataSource.java:48)
... 29 more
Caused by: java.net.SocketException: Connection reset
at java.base/sun.nio.ch.NioSocketImpl.implRead(NioSocketImpl.java:318)
at java.base/sun.nio.ch.NioSocketImpl.read(NioSocketImpl.java:346)
at java.base/sun.nio.ch.NioSocketImpl$1.read(NioSocketImpl.java:796)
at java.base/java.net.Socket$SocketInputStream.read(Socket.java:1099)
at java.base/sun.security.ssl.SSLSocketInputRecord.read(SSLSocketInputRecord.java:489)
at java.base/sun.security.ssl.SSLSocketInputRecord.readHeader(SSLSocketInputRecord.java:483)
at java.base/sun.security.ssl.SSLSocketInputRecord.bytesInCompletePacket(SSLSocketInputRecord.java:70)
at java.base/sun.security.ssl.SSLSocketImpl.readApplicationRecord(SSLSocketImpl.java:1461)
at java.base/sun.security.ssl.SSLSocketImpl$AppInputStream.read(SSLSocketImpl.java:1066)
at com.amazon.redshift.core.CompressedInputStream.readFromNetwork(CompressedInputStream.java:336)
at com.amazon.redshift.core.CompressedInputStream.tryReadMessage(CompressedInputStream.java:166)
at com.amazon.redshift.core.CompressedInputStream.read(CompressedInputStream.java:387)
at com.amazon.redshift.core.VisibleBufferedInputStream.readMore(VisibleBufferedInputStream.java:167)
at com.amazon.redshift.core.VisibleBufferedInputStream.ensureBytes(VisibleBufferedInputStream.java:134)
at com.amazon.redshift.core.VisibleBufferedInputStream.ensureBytes(VisibleBufferedInputStream.java:119)
at com.amazon.redshift.core.VisibleBufferedInputStream.read(VisibleBufferedInputStream.java:79)
at com.amazon.redshift.core.RedshiftStream.receiveChar(RedshiftStream.java:440)
at com.amazon.redshift.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:682)
at com.amazon.redshift.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:128)
at com.amazon.redshift.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:239)
at com.amazon.redshift.core.ConnectionFactory.openConnection(ConnectionFactory.java:51)
at com.amazon.redshift.jdbc.RedshiftConnectionImpl.<init>(RedshiftConnectionImpl.java:353)
at com.amazon.redshift.Driver.makeConnection(Driver.java:481)
at com.amazon.redshift.Driver.connect(Driver.java:302)
... 33 more
Raw output
java.lang.AssertionError:
Expecting throwable message:
"java.sql.SQLException: The connection attempt failed."
to contain:
"Encountered too many errors talking to a worker node"
but did not.
Throwable that failed the check:
io.trino.testing.QueryFailedException: java.sql.SQLException: The connection attempt failed.
at io.trino.testing.AbstractTestingTrinoClient.execute(AbstractTestingTrinoClient.java:133)
at io.trino.testing.DistributedQueryRunner.executeWithQueryId(DistributedQueryRunner.java:502)
at io.trino.testing.BaseFailureRecoveryTest$FailureRecoveryAssert.execute(BaseFailureRecoveryTest.java:526)
at io.trino.testing.BaseFailureRecoveryTest$FailureRecoveryAssert.executeActual(BaseFailureRecoveryTest.java:511)
at io.trino.testing.BaseFailureRecoveryTest$FailureRecoveryAssert.executeActualNoRetries(BaseFailureRecoveryTest.java:496)
at io.trino.testing.BaseFailureRecoveryTest$FailureRecoveryAssert.lambda$failsWithoutRetries$11(BaseFailureRecoveryTest.java:700)
at org.assertj.core.api.ThrowableAssert.catchThrowable(ThrowableAssert.java:63)
at org.assertj.core.api.AssertionsForClassTypes.catchThrowable(AssertionsForClassTypes.java:892)
at org.assertj.core.api.Assertions.catchThrowable(Assertions.java:1366)
at org.assertj.core.api.Assertions.assertThatThrownBy(Assertions.java:1210)
at io.trino.testing.BaseFailureRecoveryTest$FailureRecoveryAssert.failsWithoutRetries(BaseFailureRecoveryTest.java:700)
at io.trino.testing.BaseFailureRecoveryTest.testNonSelect(BaseFailureRecoveryTest.java:355)
at io.trino.testing.BaseFailureRecoveryTest.testTableModification(BaseFailureRecoveryTest.java:306)
at io.trino.testing.BaseFailureRecoveryTest.testTableModification(BaseFailureRecoveryTest.java:301)
at io.trino.testing.BaseFailureRecoveryTest.testExplainAnalyze(BaseFailureRecoveryTest.java:278)
at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
at java.base/java.lang.reflect.Method.invoke(Method.java:580)
at org.junit.platform.commons.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:728)
at org.junit.jupiter.engine.execution.MethodInvocation.proceed(MethodInvocation.java:60)
at org.junit.jupiter.engine.execution.InvocationInterceptorChain$ValidatingInvocation.proceed(InvocationInterceptorChain.java:131)
at org.junit.jupiter.engine.extension.TimeoutExtension.intercept(TimeoutExtension.java:156)
at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestableMethod(TimeoutExtension.java:147)
at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestMethod(TimeoutExtension.java:86)
at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker$ReflectiveInterceptorCall.lambda$ofVoidMethod$0(InterceptingExecutableInvoker.java:103)
at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.lambda$invoke$0(InterceptingExecutableInvoker.java:93)
at org.junit.jupiter.engine.execution.InvocationInterceptorChain$InterceptedInvocation.proceed(InvocationInterceptorChain.java:106)
at org.junit.jupiter.engine.execution.InvocationInterceptorChain.proceed(InvocationInterceptorChain.java:64)
at org.junit.jupiter.engine.execution.InvocationInterceptorChain.chainAndInvoke(InvocationInterceptorChain.java:45)
at org.junit.jupiter.engine.execution.InvocationInterceptorChain.invoke(InvocationInterceptorChain.java:37)
at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:92)
at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:86)
at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.lambda$invokeTestMethod$7(TestMethodTestDescriptor.java:218)
at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.invokeTestMethod(TestMethodTestDescriptor.java:214)
at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:139)
at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:69)
at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$6(NodeTestTask.java:151)
at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:141)
at org.junit.platform.engine.support.hierarchical.Node.around(Node.java:137)
at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$9(NodeTestTask.java:139)
at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
at org.junit.platform.engine.support.hierarchical.NodeTestTask.executeRecursively(NodeTestTask.java:138)
at org.junit.platform.engine.support.hierarchical.NodeTestTask.execute(NodeTestTask.java:95)
at org.junit.platform.engine.support.hierarchical.ForkJoinPoolHierarchicalTestExecutorService$ExclusiveTask.compute(ForkJoinPoolHierarchicalTestExecutorService.java:202)
at java.base/java.util.concurrent.RecursiveAction.exec(RecursiveAction.java:194)
at java.base/java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:387)
at java.base/java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1312)
at java.base/java.util.concurrent.ForkJoinPool.scan(ForkJoinPool.java:1843)
at java.base/java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1808)
at java.base/java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:188)
Suppressed: java.lang.Exception: SQL: EXPLAIN ANALYZE INSERT INTO table_bxyd5y6f5r SELECT * FROM orders
at io.trino.testing.DistributedQueryRunner.executeWithQueryId(DistributedQueryRunner.java:506)
... 49 more
Suppressed: io.trino.testing.QueryFailedException: java.sql.SQLException: Connection to trino-redshift-ci-cluster-8837528b77fbf267.c38hhhngrndv.us-east-2.redshift.amazonaws.com:5439 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
at io.trino.testing.AbstractTestingTrinoClient.execute(AbstractTestingTrinoClient.java:133)
at io.trino.testing.DistributedQueryRunner.executeWithQueryId(DistributedQueryRunner.java:502)
at io.trino.testing.DistributedQueryRunner.execute(DistributedQueryRunner.java:495)
at io.trino.testing.BaseFailureRecoveryTest$FailureRecoveryAssert.lambda$execute$3(BaseFailureRecoveryTest.java:552)
at java.base/java.util.Optional.ifPresent(Optional.java:178)
at io.trino.testing.BaseFailureRecoveryTest$FailureRecoveryAssert.execute(BaseFailureRecoveryTest.java:552)
... 48 more
Suppressed: java.lang.Exception: SQL: DROP TABLE table_bxyd5y6f5r
at io.trino.testing.DistributedQueryRunner.executeWithQueryId(DistributedQueryRunner.java:506)
... 52 more
Caused by: io.trino.spi.TrinoException: java.sql.SQLException: Connection to trino-redshift-ci-cluster-8837528b77fbf267.c38hhhngrndv.us-east-2.redshift.amazonaws.com:5439 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
at io.trino.plugin.jdbc.BaseJdbcClient.getTableHandle(BaseJdbcClient.java:230)
at io.trino.plugin.jdbc.ForwardingJdbcClient.getTableHandle(ForwardingJdbcClient.java:88)
at io.trino.plugin.jdbc.jmx.StatisticsAwareJdbcClient.lambda$getTableHandle$3(StatisticsAwareJdbcClient.java:109)
at io.trino.plugin.jdbc.jmx.JdbcApiStats.wrap(JdbcApiStats.java:34)
at io.trino.plugin.jdbc.jmx.StatisticsAwareJdbcClient.getTableHandle(StatisticsAwareJdbcClient.java:109)
at io.trino.plugin.jdbc.CachingJdbcClient.lambda$getTableHandle$4(CachingJdbcClient.java:350)
at io.trino.cache.EmptyCache.get(EmptyCache.java:94)
at io.trino.plugin.jdbc.CachingJdbcClient.get(CachingJdbcClient.java:758)
at io.trino.plugin.jdbc.CachingJdbcClient.getTableHandle(CachingJdbcClient.java:350)
at io.trino.plugin.jdbc.CachingJdbcClient.lambda$getTableHandle$4(CachingJdbcClient.java:350)
at com.google.common.cache.LocalCache$LocalManualCache$1.load(LocalCache.java:4938)
at com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3576)
at com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2318)
at com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2191)
at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2081)
at com.google.common.cache.LocalCache.get(LocalCache.java:4019)
at com.google.common.cache.LocalCache$LocalManualCache.get(LocalCache.java:4933)
at io.trino.cache.EvictableCache.get(EvictableCache.java:112)
at io.trino.plugin.jdbc.CachingJdbcClient.get(CachingJdbcClient.java:758)
at io.trino.plugin.jdbc.CachingJdbcClient.getTableHandle(CachingJdbcClient.java:350)
at io.trino.plugin.jdbc.DefaultJdbcMetadata.getTableHandle(DefaultJdbcMetadata.java:144)
at io.trino.plugin.jdbc.DefaultJdbcMetadata.getTableHandle(DefaultJdbcMetadata.java:107)
at io.trino.spi.connector.ConnectorMetadata.getTableHandle(ConnectorMetadata.java:141)
at io.trino.plugin.base.classloader.ClassLoaderSafeConnectorMetadata.getTableHandle(ClassLoaderSafeConnectorMetadata.java:1196)
at io.trino.tracing.TracingConnectorMetadata.getTableHandle(TracingConnectorMetadata.java:149)
at io.trino.metadata.MetadataManager.lambda$getTableHandle$5(MetadataManager.java:286)
at java.base/java.util.Optional.flatMap(Optional.java:289)
at io.trino.metadata.MetadataManager.getTableHandle(MetadataManager.java:280)
at io.trino.metadata.MetadataManager.getRedirectionAwareTableHandle(MetadataManager.java:1779)
at io.trino.metadata.MetadataManager.getRedirectionAwareTableHandle(MetadataManager.java:1771)
at io.trino.tracing.TracingMetadata.getRedirectionAwareTableHandle(TracingMetadata.java:1399)
at io.trino.execution.DropTableTask.execute(DropTableTask.java:78)
at io.trino.execution.DropTableTask.execute(DropTableTask.java:36)
at io.trino.execution.DataDefinitionExecution.start(DataDefinitionExecution.java:145)
at io.trino.execution.SqlQueryManager.createQuery(SqlQueryManager.java:256)
at io.trino.dispatcher.LocalDispatchQuery.startExecution(LocalDispatchQuery.java:145)
at io.trino.dispatcher.LocalDispatchQuery.lambda$waitForMinimumWorkers$2(LocalDispatchQuery.java:129)
at io.airlift.concurrent.MoreFutures.lambda$addSuccessCallback$12(MoreFutures.java:568)
at io.airlift.concurrent.MoreFutures$3.onSuccess(MoreFutures.java:543)
at com.google.common.util.concurrent.Futures$CallbackListener.run(Futures.java:1133)
at io.trino.$gen.Trino_testversion____20231121_142743_75.run(Unknown Source)
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.sql.SQLException: java.sql.SQLException: Connection to trino-redshift-ci-cluster-8837528b77fbf267.c38hhhngrndv.us-east-2.redshift.amazonaws.com:5439 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
at io.trino.plugin.jdbc.TracingDataSource.getConnection(TracingDataSource.java:51)
at io.trino.plugin.jdbc.DriverConnectionFactory.openConnection(DriverConnectionFactory.java:78)
at io.trino.plugin.jdbc.jmx.StatisticsAwareConnectionFactory.lambda$openConnection$0(StatisticsAwareConnectionFactory.java:45)
at io.trino.plugin.jdbc.jmx.JdbcApiStats.wrap(JdbcApiStats.java:34)
at io.trino.plugin.jdbc.jmx.StatisticsAwareConnectionFactory.openConnection(StatisticsAwareConnectionFactory.java:45)
at io.trino.plugin.jdbc.RetryingConnectionFactory.lambda$openConnection$0(RetryingConnectionFactory.java:60)
at dev.failsafe.Functions.lambda$toCtxSupplier$11(Functions.java:243)
at dev.failsafe.Functions.lambda$get$0(Functions.java:46)
at dev.failsafe.internal.RetryPolicyExecutor.lambda$apply$0(RetryPolicyExecutor.java:74)
at dev.failsafe.SyncExecutionImpl.executeSync(SyncExecutionImpl.java:187)
at dev.failsafe.FailsafeExecutor.call(FailsafeExecutor.java:376)
at dev.failsafe.FailsafeExecutor.get(FailsafeExecutor.java:112)
at io.trino.plugin.jdbc.RetryingConnectionFactory.openConnection(RetryingConnectionFactory.java:60)
at io.trino.plugin.jdbc.LazyConnectionFactory.lambda$openConnection$0(LazyConnectionFactory.java:44)
at io.trino.plugin.jdbc.LazyConnectionFactory$LazyConnection.delegate(LazyConnectionFactory.java:75)
at io.trino.plugin.jdbc.ForwardingConnection.getMetaData(ForwardingConnection.java:117)
at io.trino.plugin.jdbc.ForwardingConnection.getMetaData(ForwardingConnection.java:117)
at io.trino.plugin.jdbc.BaseJdbcClient.getTables(BaseJdbcClient.java:1160)
at io.trino.plugin.jdbc.BaseJdbcClient.getTableHandle(BaseJdbcClient.java:215)
... 43 more
Suppressed: java.sql.SQLException: java.sql.SQLException: Connection to trino-redshift-ci-cluster-8837528b77fbf267.c38hhhngrndv.us-east-2.redshift.amazonaws.com:5439 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
at io.trino.plugin.jdbc.TracingDataSource.getConnection(TracingDataSource.java:51)
at io.trino.plugin.jdbc.DriverConnectionFactory.openConnection(DriverConnectionFactory.java:78)
at io.trino.plugin.jdbc.jmx.StatisticsAwareConnectionFactory.lambda$openConnection$0(StatisticsAwareConnectionFactory.java:45)
at io.trino.plugin.jdbc.jmx.JdbcApiStats.wrap(JdbcApiStats.java:34)
at io.trino.plugin.jdbc.jmx.StatisticsAwareConnectionFactory.openConnection(StatisticsAwareConnectionFactory.java:45)
at io.trino.plugin.jdbc.RetryingConnectionFactory.lambda$openConnection$0(RetryingConnectionFactory.java:60)
at dev.failsafe.Functions.lambda$toCtxSupplier$11(Functions.java:243)
at dev.failsafe.Functions.lambda$get$0(Functions.java:46)
at dev.failsafe.internal.RetryPolicyExecutor.lambda$apply$0(RetryPolicyExecutor.java:74)
at dev.failsafe.SyncExecutionImpl.executeSync(SyncExecutionImpl.java:187)
at dev.failsafe.FailsafeExecutor.call(FailsafeExecutor.java:376)
at dev.failsafe.FailsafeExecutor.get(FailsafeExecutor.java:112)
at io.trino.plugin.jdbc.RetryingConnectionFactory.openConnection(RetryingConnectionFactory.java:60)
at io.trino.plugin.jdbc.LazyConnectionFactory.lambda$openConnection$0(LazyConnectionFactory.java:44)
at io.trino.plugin.jdbc.LazyConnectionFactory$LazyConnection.delegate(LazyConnectionFactory.java:75)
at io.trino.plugin.jdbc.ForwardingConnection.isClosed(ForwardingConnection.java:110)
at io.trino.plugin.jdbc.ReusableConnectionFactory$CachedConnection.close(ReusableConnectionFactory.java:178)
at io.trino.plugin.jdbc.BaseJdbcClient.getTableHandle(BaseJdbcClient.java:210)
... 43 more
Caused by: java.sql.SQLException: Connection to trino-redshift-ci-cluster-8837528b77fbf267.c38hhhngrndv.us-east-2.redshift.amazonaws.com:5439 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
at com.amazon.redshift.util.RedshiftException.getSQLException(RedshiftException.java:56)
at com.amazon.redshift.Driver.connect(Driver.java:326)
at io.trino.plugin.jdbc.TracingDataSource$JdbcDataSource.getConnection(TracingDataSource.java:73)
at io.opentelemetry.instrumentation.jdbc.datasource.OpenTelemetryDataSource.wrapCall(OpenTelemetryDataSource.java:139)
at io.opentelemetry.instrumentation.jdbc.datasource.OpenTelemetryDataSource.getConnection(OpenTelemetryDataSource.java:77)
at io.trino.plugin.jdbc.TracingDataSource.getConnection(TracingDataSource.java:48)
... 60 more
Caused by: java.net.ConnectException: Connection refused
at java.base/sun.nio.ch.Net.pollConnect(Native Method)
at java.base/sun.nio.ch.Net.pollConnectNow(Net.java:682)
at java.base/sun.nio.ch.NioSocketImpl.timedFinishConnect(NioSocketImpl.java:549)
at java.base/sun.nio.ch.NioSocketImpl.connect(NioSocketImpl.java:592)
at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:327)
at java.base/java.net.Socket.connect(Socket.java:751)
at com.amazon.redshift.core.RedshiftStream.<init>(RedshiftStream.java:97)
at com.amazon.redshift.core.v3.ConnectionFactoryImpl.constructNewStream(ConnectionFactoryImpl.java:140)
at com.amazon.redshift.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:120)
at com.amazon.redshift.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:239)
at com.amazon.redshift.core.ConnectionFactory.openConnection(ConnectionFactory.java:51)
at com.amazon.redshift.jdbc.RedshiftConnectionImpl.<init>(RedshiftConnectionImpl.java:353)
at com.amazon.redshift.Driver.makeConnection(Driver.java:481)
at com.amazon.redshift.Driver.connect(Driver.java:302)
... 64 more
Caused by: java.sql.SQLException: Connection to trino-redshift-ci-cluster-8837528b77fbf267.c38hhhngrndv.us-east-2.redshift.amazonaws.com:5439 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
at com.amazon.redshift.util.RedshiftException.getSQLException(RedshiftException.java:56)
at com.amazon.redshift.Driver.connect(Driver.java:326)
at io.trino.plugin.jdbc.TracingDataSource$JdbcDataSource.getConnection(TracingDataSource.java:73)
at io.opentelemetry.instrumentation.jdbc.datasource.OpenTelemetryDataSource.wrapCall(OpenTelemetryDataSource.java:139)
at io.opentelemetry.instrumentation.jdbc.datasource.OpenTelemetryDataSource.getConnection(OpenTelemetryDataSource.java:77)
at io.trino.plugin.jdbc.TracingDataSource.getConnection(TracingDataSource.java:48)
... 61 more
Caused by: java.net.ConnectException: Connection refused
at java.base/sun.nio.ch.Net.pollConnect(Native Method)
at java.base/sun.nio.ch.Net.pollConnectNow(Net.java:682)
at java.base/sun.nio.ch.NioSocketImpl.timedFinishConnect(NioSocketImpl.java:549)
at java.base/sun.nio.ch.NioSocketImpl.connect(NioSocketImpl.java:592)
at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:327)
at java.base/java.net.Socket.connect(Socket.java:751)
at com.amazon.redshift.core.RedshiftStream.<init>(RedshiftStream.java:97)
at com.amazon.redshift.core.v3.ConnectionFactoryImpl.constructNewStream(ConnectionFactoryImpl.java:140)
at com.amazon.redshift.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:120)
at com.amazon.redshift.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:239)
at com.amazon.redshift.core.ConnectionFactory.openConnection(ConnectionFactory.java:51)
at com.amazon.redshift.jdbc.RedshiftConnectionImpl.<init>(RedshiftConnectionImpl.java:353)
at com.amazon.redshift.Driver.makeConnection(Driver.java:481)
at com.amazon.redshift.Driver.connect(Driver.java:302)
... 65 more
Caused by: io.trino.spi.TrinoException: java.sql.SQLException: The connection attempt failed.
at io.trino.plugin.jdbc.JdbcPageSink.<init>(JdbcPageSink.java:80)
at io.trino.plugin.jdbc.JdbcPageSinkProvider.createPageSink(JdbcPageSinkProvider.java:50)
at io.trino.split.PageSinkManager.createPageSink(PageSinkManager.java:56)
at io.trino.operator.TableWriterOperator$TableWriterOperatorFactory.createPageSink(TableWriterOperator.java:126)
at io.trino.operator.TableWriterOperator$TableWriterOperatorFactory.createOperator(TableWriterOperator.java:117)
at io.trino.operator.DriverFactory.createDriver(DriverFactory.java:105)
at io.trino.execution.SqlTaskExecution$DriverSplitRunnerFactory.createDriver(SqlTaskExecution.java:665)
at io.trino.execution.SqlTaskExecution$DriverSplitRunner.processFor(SqlTaskExecution.java:876)
at io.trino.execution.executor.timesharing.PrioritizedSplitRunner.process(PrioritizedSplitRunner.java:187)
at io.trino.execution.executor.timesharing.TimeSharingTaskExecutor$TaskRunner.run(TimeSharingTaskExecutor.java:565)
at io.trino.$gen.Trino_testversion____20231121_142741_1.run(Unknown Source)
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.sql.SQLException: java.sql.SQLException: The connection attempt failed.
at io.trino.plugin.jdbc.TracingDataSource.getConnection(TracingDataSource.java:51)
at io.trino.plugin.jdbc.DriverConnectionFactory.openConnection(DriverConnectionFactory.java:78)
at io.trino.plugin.jdbc.jmx.StatisticsAwareConnectionFactory.lambda$openConnection$0(StatisticsAwareConnectionFactory.java:45)
at io.trino.plugin.jdbc.jmx.JdbcApiStats.wrap(JdbcApiStats.java:34)
at io.trino.plugin.jdbc.jmx.StatisticsAwareConnectionFactory.openConnection(StatisticsAwareConnectionFactory.java:45)
at io.trino.plugin.jdbc.RetryingConnectionFactory.lambda$openConnection$0(RetryingConnectionFactory.java:60)
at dev.failsafe.Functions.lambda$toCtxSupplier$11(Functions.java:243)
at dev.failsafe.Functions.lambda$get$0(Functions.java:46)
at dev.failsafe.internal.RetryPolicyExecutor.lambda$apply$0(RetryPolicyExecutor.java:74)
at dev.failsafe.SyncExecutionImpl.executeSync(SyncExecutionImpl.java:187)
at dev.failsafe.FailsafeExecutor.call(FailsafeExecutor.java:376)
at dev.failsafe.FailsafeExecutor.get(FailsafeExecutor.java:112)
at io.trino.plugin.jdbc.RetryingConnectionFactory.openConnection(RetryingConnectionFactory.java:60)
at io.trino.plugin.jdbc.LazyConnectionFactory.lambda$openConnection$0(LazyConnectionFactory.java:44)
at io.trino.plugin.jdbc.LazyConnectionFactory$LazyConnection.delegate(LazyConnectionFactory.java:75)
at io.trino.plugin.jdbc.ForwardingConnection.setAutoCommit(ForwardingConnection.java:75)
at io.trino.plugin.jdbc.JdbcPageSink.<init>(JdbcPageSink.java:76)
... 13 more
Caused by: java.sql.SQLException: The connection attempt failed.
at com.amazon.redshift.util.RedshiftException.getSQLException(RedshiftException.java:56)
at com.amazon.redshift.Driver.connect(Driver.java:326)
at io.trino.plugin.jdbc.TracingDataSource$JdbcDataSource.getConnection(TracingDataSource.java:73)
at io.opentelemetry.instrumentation.jdbc.datasource.OpenTelemetryDataSource.wrapCall(OpenTelemetryDataSource.java:139)
at io.opentelemetry.instrumentation.jdbc.datasource.OpenTelemetryDataSource.getConnection(OpenTelemetryDataSource.java:77)
at io.trino.plugin.jdbc.TracingDataSource.getConnection(TracingDataSource.java:48)
... 29 more
Caused by: java.net.SocketException: Connection reset
at java.base/sun.nio.ch.NioSocketImpl.implRead(NioSocketImpl.java:318)
at java.base/sun.nio.ch.NioSocketImpl.read(NioSocketImpl.java:346)
at java.base/sun.nio.ch.NioSocketImpl$1.read(NioSocketImpl.java:796)
at java.base/java.net.Socket$SocketInputStream.read(Socket.java:1099)
at java.base/sun.security.ssl.SSLSocketInputRecord.read(SSLSocketInputRecord.java:489)
at java.base/sun.security.ssl.SSLSocketInputRecord.readHeader(SSLSocketInputRecord.java:483)
at java.base/sun.security.ssl.SSLSocketInputRecord.bytesInCompletePacket(SSLSocketInputRecord.java:70)
at java.base/sun.security.ssl.SSLSocketImpl.readApplicationRecord(SSLSocketImpl.java:1461)
at java.base/sun.security.ssl.SSLSocketImpl$AppInputStream.read(SSLSocketImpl.java:1066)
at com.amazon.redshift.core.CompressedInputStream.readFromNetwork(CompressedInputStream.java:336)
at com.amazon.redshift.core.CompressedInputStream.tryReadMessage(CompressedInputStream.java:166)
at com.amazon.redshift.core.CompressedInputStream.read(CompressedInputStream.java:387)
at com.amazon.redshift.core.VisibleBufferedInputStream.readMore(VisibleBufferedInputStream.java:167)
at com.amazon.redshift.core.VisibleBufferedInputStream.ensureBytes(VisibleBufferedInputStream.java:134)
at com.amazon.redshift.core.VisibleBufferedInputStream.ensureBytes(VisibleBufferedInputStream.java:119)
at com.amazon.redshift.core.VisibleBufferedInputStream.read(VisibleBufferedInputStream.java:79)
at com.amazon.redshift.core.RedshiftStream.receiveChar(RedshiftStream.java:440)
at com.amazon.redshift.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:682)
at com.amazon.redshift.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:128)
at com.amazon.redshift.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:239)
at com.amazon.redshift.core.ConnectionFactory.openConnection(ConnectionFactory.java:51)
at com.amazon.redshift.jdbc.RedshiftConnectionImpl.<init>(RedshiftConnectionImpl.java:353)
at com.amazon.redshift.Driver.makeConnection(Driver.java:481)
at com.amazon.redshift.Driver.connect(Driver.java:302)
... 33 more
at io.trino.testing.BaseFailureRecoveryTest.lambda$testNonSelect$12(BaseFailureRecoveryTest.java:355)
at io.trino.testing.BaseFailureRecoveryTest$FailureRecoveryAssert.failsWithoutRetries(BaseFailureRecoveryTest.java:700)
at io.trino.testing.BaseFailureRecoveryTest.testNonSelect(BaseFailureRecoveryTest.java:355)
at io.trino.testing.BaseFailureRecoveryTest.testTableModification(BaseFailureRecoveryTest.java:306)
at io.trino.testing.BaseFailureRecoveryTest.testTableModification(BaseFailureRecoveryTest.java:301)
at io.trino.testing.BaseFailureRecoveryTest.testExplainAnalyze(BaseFailureRecoveryTest.java:278)
at java.base/java.lang.reflect.Method.invoke(Method.java:580)
at java.base/java.util.concurrent.RecursiveAction.exec(RecursiveAction.java:194)
at java.base/java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:387)
at java.base/java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1312)
at java.base/java.util.concurrent.ForkJoinPool.scan(ForkJoinPool.java:1843)
at java.base/java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1808)
at java.base/java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:188)