Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Flaky TestRedshiftUnload #24631

Closed
ebyhr opened this issue Jan 6, 2025 · 1 comment · Fixed by #24669
Closed

Flaky TestRedshiftUnload #24631

ebyhr opened this issue Jan 6, 2025 · 1 comment · Fixed by #24669
Assignees

Comments

@ebyhr
Copy link
Member

ebyhr commented Jan 6, 2025

https://github.com/trinodb/trino/actions/runs/12627786329/job/35182951110

Error:  Tests run: 8, Failures: 0, Errors: 1, Skipped: 0, Time elapsed: 42.43 s <<< FAILURE! -- in io.trino.plugin.redshift.TestRedshiftUnload
Error:  io.trino.plugin.redshift.TestRedshiftUnload -- Time elapsed: 42.43 s <<< ERROR!
org.jdbi.v3.core.statement.UnableToExecuteStatementException: com.amazon.redshift.util.RedshiftException: ERROR: could not open relation with OID 107338 [statement:"GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA test_schema TO alice", arguments:{}]
	at org.jdbi.v3.core.statement.SqlStatement.internalExecute(SqlStatement.java:1823)
	at org.jdbi.v3.core.result.ResultProducers.lambda$returningUpdateCount$0(ResultProducers.java:50)
	at org.jdbi.v3.core.statement.Update.execute(Update.java:69)
	at org.jdbi.v3.core.statement.Update.execute(Update.java:57)
	at org.jdbi.v3.core.Handle.execute(Handle.java:354)
	at org.jdbi.v3.core.Handle.execute(Handle.java:367)
	at io.trino.plugin.redshift.TestingRedshiftServer.lambda$executeInRedshift$2(TestingRedshiftServer.java:51)
	at org.jdbi.v3.core.HandleConsumer.lambda$asCallback$0(HandleConsumer.java:32)
	at org.jdbi.v3.core.Jdbi.withHandle(Jdbi.java:422)
	at io.trino.plugin.redshift.TestingRedshiftServer.executeWithRedshift(TestingRedshiftServer.java:63)
	at io.trino.plugin.redshift.TestingRedshiftServer.executeInRedshift(TestingRedshiftServer.java:57)
	at io.trino.plugin.redshift.TestingRedshiftServer.executeInRedshift(TestingRedshiftServer.java:51)
	at io.trino.plugin.redshift.TestingRedshiftServer.lambda$executeInRedshiftWithRetry$1(TestingRedshiftServer.java:46)
	at dev.failsafe.Functions.lambda$toCtxSupplier$9(Functions.java:228)
	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.run(FailsafeExecutor.java:220)
	at io.trino.plugin.redshift.TestingRedshiftServer.executeInRedshiftWithRetry(TestingRedshiftServer.java:46)
	at io.trino.plugin.redshift.RedshiftQueryRunner$Builder.build(RedshiftQueryRunner.java:128)
	at io.trino.plugin.redshift.TestRedshiftUnload.createQueryRunner(TestRedshiftUnload.java:72)
	at io.trino.testing.AbstractTestQueryFramework.init(AbstractTestQueryFramework.java:119)
	at java.base/java.lang.reflect.Method.invoke(Method.java:580)
	at java.base/java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:507)
	at java.base/java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1458)
	at java.base/java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:2034)
	at java.base/java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:189)
Caused by: com.amazon.redshift.util.RedshiftException: ERROR: could not open relation with OID 107338
	at com.amazon.redshift.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2648)
	at com.amazon.redshift.core.v3.QueryExecutorImpl.processResultsOnThread(QueryExecutorImpl.java:2295)
	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)
	at com.amazon.redshift.jdbc.RedshiftStatementImpl.executeInternal(RedshiftStatementImpl.java:519)
	at com.amazon.redshift.jdbc.RedshiftStatementImpl.execute(RedshiftStatementImpl.java:440)
	at com.amazon.redshift.jdbc.RedshiftPreparedStatement.executeWithFlags(RedshiftPreparedStatement.java:202)
	at com.amazon.redshift.jdbc.RedshiftPreparedStatement.execute(RedshiftPreparedStatement.java:186)
	at org.jdbi.v3.core.statement.SqlLoggerUtil.wrap(SqlLoggerUtil.java:32)
	at org.jdbi.v3.core.statement.SqlStatement.internalExecute(SqlStatement.java:[182](https://github.com/trinodb/trino/actions/runs/12627786329/job/35182951110#step:19:183)1)
	... 27 more
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Development

Successfully merging a pull request may close this issue.

2 participants