[
https://issues.apache.org/jira/browse/BEAM-10300?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17174402#comment-17174402
]
Brian Hulette commented on BEAM-10300:
--------------------------------------
>From duplicate BEAM-10513:
Failure:
{code}
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)
{code}
And in the logs we see:
{code}
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)
{code}
> Test failure: JdbcIOTest.testCustomFluentBackOffConfiguration
> -------------------------------------------------------------
>
> Key: BEAM-10300
> URL: https://issues.apache.org/jira/browse/BEAM-10300
> Project: Beam
> Issue Type: Bug
> Components: io-java-jdbc, test-failures
> Reporter: Kenneth Knowles
> Priority: P1
> Labels: flake
>
> https://ci-beam.apache.org/job/beam_PreCommit_Java_Phrase/2339/testReport/junit/org.apache.beam.sdk.io.jdbc/JdbcIOTest/testCustomFluentBackOffConfiguration/
> {code}
> java.sql.SQLTransactionRollbackException: A lock could not be obtained within
> the time requested
> at
> org.apache.derby.client.am.SQLExceptionFactory.getSQLException(Unknown Source)
> at org.apache.derby.client.am.SqlException.getSQLException(Unknown
> Source)
> at org.apache.derby.client.am.ClientStatement.executeQuery(Unknown
> Source)
> at
> org.apache.beam.sdk.io.jdbc.JdbcIOTest.assertRowCount(JdbcIOTest.java:490)
> at
> org.apache.beam.sdk.io.jdbc.JdbcIOTest.testCustomFluentBackOffConfiguration(JdbcIOTest.java:1033)
> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
