Details
-
Bug
-
Status: Resolved
-
P1
-
Resolution: Fixed
-
None
Description
Failure:
java.sql.SQLTransactionRollbackException: A lock could not be obtained within the time requested at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source) at org.apache.derby.impl.jdbc.EmbedStatement.executeQuery(Unknown Source) at org.apache.commons.dbcp2.DelegatingStatement.executeQuery(DelegatingStatement.java:310) at org.apache.commons.dbcp2.DelegatingStatement.executeQuery(DelegatingStatement.java:310) at org.apache.beam.sdk.io.jdbc.JdbcIOTest.assertRowCount(JdbcIOTest.java:399) at org.apache.beam.sdk.io.jdbc.JdbcIOTest.testCustomFluentBackOffConfiguration(JdbcIOTest.java:908) ... Caused by: ERROR 40XL1: A lock could not be obtained within the time requested at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) at org.apache.derby.impl.services.locks.ConcurrentLockSet.lockObject(Unknown Source) at org.apache.derby.impl.services.locks.AbstractPool.lockObject(Unknown Source) at org.apache.derby.impl.services.locks.ConcurrentPool.lockObject(Unknown Source) at org.apache.derby.impl.store.raw.xact.ContainerLocking2.lockContainer(Unknown Source) at org.apache.derby.impl.store.raw.data.BaseContainerHandle.useContainer(Unknown Source) at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContainer(Unknown Source) at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContainer(Unknown Source) at org.apache.derby.impl.store.raw.xact.Xact.openContainer(Unknown Source)
And in the logs we see:
Jul 16, 2020 10:39:11 AM org.apache.beam.sdk.io.jdbc.JdbcIO$WriteVoid$WriteFn executeBatch WARNING: Deadlock detected, retrying java.sql.BatchUpdateException: A lock could not be obtained within the time requested at org.apache.derby.impl.jdbc.EmbedStatement.executeLargeBatch(Unknown Source) at org.apache.derby.impl.jdbc.EmbedStatement.executeBatch(Unknown Source) at org.apache.commons.dbcp2.DelegatingStatement.executeBatch(DelegatingStatement.java:223) at org.apache.commons.dbcp2.DelegatingStatement.executeBatch(DelegatingStatement.java:223) at org.apache.beam.sdk.io.jdbc.JdbcIO$WriteVoid$WriteFn.executeBatch(JdbcIO.java:1467) at org.apache.beam.sdk.io.jdbc.JdbcIO$WriteVoid$WriteFn.finishBundle(JdbcIO.java:1417) at org.apache.beam.sdk.io.jdbc.JdbcIO$WriteVoid$WriteFn$DoFnInvoker.invokeFinishBundle(Unknown Source) at org.apache.beam.repackaged.direct_java.runners.core.SimpleDoFnRunner.finishBundle(SimpleDoFnRunner.java:237) at org.apache.beam.repackaged.direct_java.runners.core.SimplePushbackSideInputDoFnRunner.finishBundle(SimplePushbackSideInputDoFnRunner.java:124) at org.apache.beam.runners.direct.ParDoEvaluator.finishBundle(ParDoEvaluator.java:265) at org.apache.beam.runners.direct.DoFnLifecycleManagerRemovingTransformEvaluator.finishBundle(DoFnLifecycleManagerRemovingTransformEvaluator.java:73) at org.apache.beam.runners.direct.DirectTransformExecutor.finishBundle(DirectTransformExecutor.java:188) at org.apache.beam.runners.direct.DirectTransformExecutor.run(DirectTransformExecutor.java:126)
Attachments
Issue Links
- duplicates
-
BEAM-10300 Test failure: JdbcIOTest.testCustomFluentBackOffConfiguration
- Resolved