You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "ASF GitHub Bot (Jira)" <ji...@apache.org> on 2020/06/09 16:13:01 UTC

[jira] [Work logged] (HIVE-23630) TestTxnHandler#allocateNextWriteIdRetriesAfterDetectingConflictingConcurrentInsert is unstable

     [ https://issues.apache.org/jira/browse/HIVE-23630?focusedWorklogId=442923&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-442923 ]

ASF GitHub Bot logged work on HIVE-23630:
-----------------------------------------

                Author: ASF GitHub Bot
            Created on: 09/Jun/20 16:12
            Start Date: 09/Jun/20 16:12
    Worklog Time Spent: 10m 
      Work Description: marton-bod opened a new pull request #1074:
URL: https://github.com/apache/hive/pull/1074


   …asing the retry limit


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


Issue Time Tracking
-------------------

            Worklog Id:     (was: 442923)
    Remaining Estimate: 0h
            Time Spent: 10m

> TestTxnHandler#allocateNextWriteIdRetriesAfterDetectingConflictingConcurrentInsert is unstable
> ----------------------------------------------------------------------------------------------
>
>                 Key: HIVE-23630
>                 URL: https://issues.apache.org/jira/browse/HIVE-23630
>             Project: Hive
>          Issue Type: Sub-task
>            Reporter: Zoltan Haindrich
>            Assignee: Marton Bod
>            Priority: Major
>         Attachments: HIVE-23630.1.patch
>
>          Time Spent: 10m
>  Remaining Estimate: 0h
>
> I think I've seen this exception but it seems to be coming from this testcase more frequently
> {code}
> java.lang.RuntimeException: MetaException(message:Unable to update transaction database org.apache.derby.shared.common.error.DerbySQLIntegrityConstraintViolationException: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'NEXT_WRITE_ID_IDX' defined on 'NEXT_WRITE_ID'.
>  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.EmbedPreparedStatement.executeStatement(Unknown Source)
>  at org.apache.derby.impl.jdbc.EmbedPreparedStatement.execute(Unknown Source)
>  at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
>  at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
>  at org.apache.hadoop.hive.metastore.txn.TxnHandler.allocateTableWriteIds(TxnHandler.java:2074)
>  at org.apache.hadoop.hive.metastore.txn.TestTxnHandler.lambda$allocateNextWriteIdRetriesAfterDetectingConflictingConcurrentInsert$1(TestTxnHandler.java:1780)
>  at java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1604)
>  at java.util.concurrent.CompletableFuture$AsyncSupply.exec(CompletableFuture.java:1596)
>  at java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:289)
>  at java.util.concurrent.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1056)
>  at java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1692)
>  at java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:157)
> Caused by: ERROR 23505: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'NEXT_WRITE_ID_IDX' defined on 'NEXT_WRITE_ID'.
>  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.sql.execute.IndexChanger.insertAndCheckDups(Unknown Source)
>  at org.apache.derby.impl.sql.execute.IndexChanger.doInsert(Unknown Source)
>  at org.apache.derby.impl.sql.execute.IndexChanger.insert(Unknown Source)
>  at org.apache.derby.impl.sql.execute.IndexSetChanger.insert(Unknown Source)
>  at org.apache.derby.impl.sql.execute.RowChangerImpl.insertRow(Unknown Source)
>  at org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore(Unknown Source)
>  at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown Source)
>  at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source)
>  at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)
>  ... 13 more
> {code}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)