Araika Singh created HIVE-29158:
-----------------------------------

             Summary: Fix flaky test 
TestCrudCompactorOnTez#testRebalanceCompactionWithParallelDeleteAsSecondPessimisticLock()
                 Key: HIVE-29158
                 URL: https://issues.apache.org/jira/browse/HIVE-29158
             Project: Hive
          Issue Type: Bug
            Reporter: Araika Singh


Stack trace:
{code:java}
org.junit.ComparisonFailure: expected:<[Transaction manager has aborted the 
transaction txnid:19.  Reason: Aborting [txnid:19,19] due to a write conflict 
on default/rebalance_test committed by [txnid:18,19] d/u]> but was:<[Lock 
acquisition for LockRequest(component:[LockComponent(type:SHARED_WRITE, 
level:TABLE, dbname:default, tablename:rebalance_test, operationType:DELETE, 
isTransactional:true, isDynamicPartitionWrite:false)], txnid:19, user:jenkins, 
hostname:hive-precommit-pr-5779-10-zdrxz-91v6p-vz7rd, 
agentInfo:jenkins_20250812122250_b3c54ce1-4ee1-47c2-a558-a33b4305e7f3, 
zeroWaitReadEnabled:true, exclusiveCTAS:false) timed out after 6343883ms.  
LockResponse(lockid:19, state:WAITING)]>        at 
org.junit.Assert.assertEquals(Assert.java:117)       at 
org.junit.Assert.assertEquals(Assert.java:146)       at 
org.apache.hadoop.hive.ql.txn.compactor.TestCrudCompactorOnTez.testRebalanceCompactionWithParallelDeleteAsSecond(TestCrudCompactorOnTez.java:156)
    at 
org.apache.hadoop.hive.ql.txn.compactor.TestCrudCompactorOnTez.testRebalanceCompactionWithParallelDeleteAsSecondPessimisticLock(TestCrudCompactorOnTez.java:108)
     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.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:59)
 at 
org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
  at 
org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:56)
   at 
org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
    at 
org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)   
     at 
org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27)  at 
org.junit.runners.ParentRunner$3.evaluate(ParentRunner.java:306)     at 
org.junit.runners.BlockJUnit4ClassRunner$1.evaluate(BlockJUnit4ClassRunner.java:100)
 at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:366)        at 
org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:103)
   at 
org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:63)
    at org.junit.runners.ParentRunner$4.run(ParentRunner.java:331)  at 
org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:79)      at 
org.junit.runners.ParentRunner.runChildren(ParentRunner.java:329)    at 
org.junit.runners.ParentRunner.access$100(ParentRunner.java:66)      at 
org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:293)     at 
org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)   
     at org.junit.rules.ExternalResource$1.evaluate(ExternalResource.java:54)   
     at org.junit.rules.RunRules.evaluate(RunRules.java:20)  at 
org.junit.runners.ParentRunner$3.evaluate(ParentRunner.java:306)     at 
org.junit.runners.ParentRunner.run(ParentRunner.java:413)    at 
org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:316)
     at 
org.apache.maven.surefire.junit4.JUnit4Provider.executeWithRerun(JUnit4Provider.java:240)
    at 
org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:214)
      at 
org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:155) 
     at 
org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:385)
      at 
org.apache.maven.surefire.booter.ForkedBooter.execute(ForkedBooter.java:162) at 
org.apache.maven.surefire.booter.ForkedBooter.run(ForkedBooter.java:507)     at 
org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:495) {code}
StackTrace of the probable part of the error:
{code:java}
org.springframework.dao.CannotAcquireLockException: PreparedStatementCallback; 
SQL [SELECT MAX("TXN_ID") FROM "TXNS"]; A lock could not be obtained within the 
time requested; nested exception is java.sql.SQLTransactionRollbackException: A 
lock could not be obtained within the time requested     at 
org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:264)
 ~[spring-jdbc-5.3.39.jar:5.3.39]        at 
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
 ~[spring-jdbc-5.3.39.jar:5.3.39]   at 
org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1575)
 ~[spring-jdbc-5.3.39.jar:5.3.39]       at 
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:667) 
~[spring-jdbc-5.3.39.jar:5.3.39]   at 
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:713) 
~[spring-jdbc-5.3.39.jar:5.3.39]     at 
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:738) 
~[spring-jdbc-5.3.39.jar:5.3.39]     at 
org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.query(NamedParameterJdbcTemplate.java:172)
 ~[spring-jdbc-5.3.39.jar:5.3.39]      at 
org.apache.hadoop.hive.metastore.txn.jdbc.MultiDataSourceJdbcResource.execute(MultiDataSourceJdbcResource.java:321)
 ~[hive-exec-4.2.0-SNAPSHOT.jar:4.2.0-SNAPSHOT]   at 
org.apache.hadoop.hive.metastore.txn.jdbc.functions.CommitTxnFunction.execute(CommitTxnFunction.java:205)
 ~[hive-exec-4.2.0-SNAPSHOT.jar:4.2.0-SNAPSHOT]     at 
org.apache.hadoop.hive.metastore.txn.TxnHandler.commitTxn(TxnHandler.java:640) 
~[hive-exec-4.2.0-SNAPSHOT.jar:4.2.0-SNAPSHOT]        at 
java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
 ~[?:?] at java.base/java.lang.reflect.Method.invoke(Method.java:580) ~[?:?]    
at 
org.apache.hadoop.hive.metastore.txn.TransactionalRetryProxy.lambda$invoke$0(TransactionalRetryProxy.java:100)
 ~[hive-exec-4.2.0-SNAPSHOT.jar:4.2.0-SNAPSHOT]        at 
org.apache.hadoop.hive.metastore.txn.TransactionalRetryProxy.lambda$invoke$5(TransactionalRetryProxy.java:114)
 ~[hive-exec-4.2.0-SNAPSHOT.jar:4.2.0-SNAPSHOT]        at 
org.apache.hadoop.hive.metastore.txn.TransactionalRetryProxy.lambda$invoke$6(TransactionalRetryProxy.java:163)
 ~[hive-exec-4.2.0-SNAPSHOT.jar:4.2.0-SNAPSHOT]        at 
org.apache.hadoop.hive.metastore.txn.retry.SqlRetryHandler.executeWithRetryInternal(SqlRetryHandler.java:136)
 ~[hive-exec-4.2.0-SNAPSHOT.jar:4.2.0-SNAPSHOT] at 
org.apache.hadoop.hive.metastore.txn.retry.SqlRetryHandler.executeWithRetryInternal(SqlRetryHandler.java:147)
 ~[hive-exec-4.2.0-SNAPSHOT.jar:4.2.0-SNAPSHOT] at 
org.apache.hadoop.hive.metastore.txn.retry.SqlRetryHandler.executeWithRetryInternal(SqlRetryHandler.java:147)
 ~[hive-exec-4.2.0-SNAPSHOT.jar:4.2.0-SNAPSHOT] at 
org.apache.hadoop.hive.metastore.txn.retry.SqlRetryHandler.executeWithRetryInternal(SqlRetryHandler.java:147)
 ~[hive-exec-4.2.0-SNAPSHOT.jar:4.2.0-SNAPSHOT] at 
org.apache.hadoop.hive.metastore.txn.retry.SqlRetryHandler.executeWithRetryInternal(SqlRetryHandler.java:147)
 ~[hive-exec-4.2.0-SNAPSHOT.jar:4.2.0-SNAPSHOT] at 
org.apache.hadoop.hive.metastore.txn.retry.SqlRetryHandler.executeWithRetryInternal(SqlRetryHandler.java:147)
 ~[hive-exec-4.2.0-SNAPSHOT.jar:4.2.0-SNAPSHOT] at 
org.apache.hadoop.hive.metastore.txn.retry.SqlRetryHandler.executeWithRetryInternal(SqlRetryHandler.java:147)
 ~[hive-exec-4.2.0-SNAPSHOT.jar:4.2.0-SNAPSHOT] at 
org.apache.hadoop.hive.metastore.txn.retry.SqlRetryHandler.executeWithRetryInternal(SqlRetryHandler.java:147)
 ~[hive-exec-4.2.0-SNAPSHOT.jar:4.2.0-SNAPSHOT] at 
org.apache.hadoop.hive.metastore.txn.retry.SqlRetryHandler.executeWithRetryInternal(SqlRetryHandler.java:147)
 ~[hive-exec-4.2.0-SNAPSHOT.jar:4.2.0-SNAPSHOT] at 
org.apache.hadoop.hive.metastore.txn.retry.SqlRetryHandler.executeWithRetryInternal(SqlRetryHandler.java:147)
 ~[hive-exec-4.2.0-SNAPSHOT.jar:4.2.0-SNAPSHOT] at 
org.apache.hadoop.hive.metastore.txn.retry.SqlRetryHandler.executeWithRetryInternal(SqlRetryHandler.java:147)
 ~[hive-exec-4.2.0-SNAPSHOT.jar:4.2.0-SNAPSHOT] at 
org.apache.hadoop.hive.metastore.txn.retry.SqlRetryHandler.executeWithRetry(SqlRetryHandler.java:122)
 ~[hive-exec-4.2.0-SNAPSHOT.jar:4.2.0-SNAPSHOT] at 
org.apache.hadoop.hive.metastore.txn.TransactionalRetryProxy.invoke(TransactionalRetryProxy.java:186)
 ~[hive-exec-4.2.0-SNAPSHOT.jar:4.2.0-SNAPSHOT] at 
jdk.proxy2/jdk.proxy2.$Proxy47.commitTxn(Unknown Source) ~[?:?]      at 
org.apache.hadoop.hive.metastore.HMSHandler.commit_txn(HMSHandler.java:9071) 
~[hive-exec-4.2.0-SNAPSHOT.jar:4.2.0-SNAPSHOT]  at 
java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
 ~[?:?] at java.base/java.lang.reflect.Method.invoke(Method.java:580) ~[?:?]    
at 
org.apache.hadoop.hive.metastore.RetryingHMSHandler.invokeInternal(RetryingHMSHandler.java:91)
 ~[hive-exec-4.2.0-SNAPSHOT.jar:4.2.0-SNAPSHOT]        at 
org.apache.hadoop.hive.metastore.AbstractHMSHandlerProxy.invoke(AbstractHMSHandlerProxy.java:82)
 ~[hive-exec-4.2.0-SNAPSHOT.jar:4.2.0-SNAPSHOT]      at 
jdk.proxy2/jdk.proxy2.$Proxy32.commit_txn(Unknown Source) ~[?:?]     at 
org.apache.hadoop.hive.metastore.client.ThriftHiveMetaStoreClient.commitTxn(ThriftHiveMetaStoreClient.java:3069)
 ~[hive-exec-4.2.0-SNAPSHOT.jar:4.2.0-SNAPSHOT]      at 
org.apache.hadoop.hive.metastore.client.MetaStoreClientWrapper.commitTxn(MetaStoreClientWrapper.java:851)
 ~[hive-exec-4.2.0-SNAPSHOT.jar:4.2.0-SNAPSHOT]     at 
java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
 ~[?:?] at java.base/java.lang.reflect.Method.invoke(Method.java:580) ~[?:?]    
at 
org.apache.hadoop.hive.metastore.client.SynchronizedMetaStoreClient$SynchronizedHandler.invoke(SynchronizedMetaStoreClient.java:69)
 ~[hive-exec-4.2.0-SNAPSHOT.jar:4.2.0-SNAPSHOT]   at 
jdk.proxy2/jdk.proxy2.$Proxy33.commitTxn(Unknown Source) ~[?:?]      at 
org.apache.hadoop.hive.metastore.client.MetaStoreClientWrapper.commitTxn(MetaStoreClientWrapper.java:851)
 ~[hive-exec-4.2.0-SNAPSHOT.jar:4.2.0-SNAPSHOT]     at 
org.apache.hadoop.hive.metastore.client.MetaStoreClientWrapper.commitTxn(MetaStoreClientWrapper.java:851)
 ~[hive-exec-4.2.0-SNAPSHOT.jar:4.2.0-SNAPSHOT]     at 
org.apache.hadoop.hive.metastore.client.BaseMetaStoreClient.commitTxn(BaseMetaStoreClient.java:710)
 ~[hive-exec-4.2.0-SNAPSHOT.jar:4.2.0-SNAPSHOT]   at 
java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
 ~[?:?] at java.base/java.lang.reflect.Method.invoke(Method.java:580) ~[?:?]    
at 
org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.invoke(RetryingMetaStoreClient.java:228)
 ~[hive-exec-4.2.0-SNAPSHOT.jar:4.2.0-SNAPSHOT]     at 
jdk.proxy2/jdk.proxy2.$Proxy137.commitTxn(Unknown Source) ~[?:?]     at 
org.apache.hadoop.hive.ql.txn.compactor.service.AcidCompactionService$CompactionTxn.commit(AcidCompactionService.java:417)
 ~[hive-exec-4.2.0-SNAPSHOT.jar:4.2.0-SNAPSHOT]    at 
org.apache.hadoop.hive.ql.txn.compactor.service.AcidCompactionService$CompactionTxn.close(AcidCompactionService.java:397)
 ~[hive-exec-4.2.0-SNAPSHOT.jar:4.2.0-SNAPSHOT]     at 
org.apache.hadoop.hive.ql.txn.compactor.service.AcidCompactionService.compact(AcidCompactionService.java:272)
 ~[hive-exec-4.2.0-SNAPSHOT.jar:4.2.0-SNAPSHOT] at 
org.apache.hadoop.hive.ql.txn.compactor.Worker.findNextCompactionAndExecute(Worker.java:245)
 ~[hive-exec-4.2.0-SNAPSHOT.jar:?]       at 
org.apache.hadoop.hive.ql.txn.compactor.Worker.lambda$run$0(Worker.java:91) 
~[hive-exec-4.2.0-SNAPSHOT.jar:?]        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) [?:?]Caused by: 
java.sql.SQLTransactionRollbackException: A lock could not be obtained within 
the time requested    at 
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) 
~[derby-10.14.2.0.jar:?]      at 
org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) 
~[derby-10.14.2.0.jar:?]      at 
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown 
Source) ~[derby-10.14.2.0.jar:?]       at 
org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown 
Source) ~[derby-10.14.2.0.jar:?]  at 
org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) 
~[derby-10.14.2.0.jar:?]  at 
org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) 
~[derby-10.14.2.0.jar:?]  at 
org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) 
~[derby-10.14.2.0.jar:?]  at 
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown 
Source) ~[derby-10.14.2.0.jar:?]  at 
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeQuery(Unknown Source) 
~[derby-10.14.2.0.jar:?]      at 
org.apache.hive.com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
 ~[hive-exec-4.2.0-SNAPSHOT.jar:4.2.0-SNAPSHOT]    at 
org.apache.hive.com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
 ~[hive-exec-4.2.0-SNAPSHOT.jar:4.2.0-SNAPSHOT]   at 
org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:722)
 ~[spring-jdbc-5.3.39.jar:5.3.39]   at 
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:648) 
~[spring-jdbc-5.3.39.jar:5.3.39]   ... 53 moreCaused by: 
org.apache.derby.iapi.error.StandardException: A lock could not be obtained 
within the time requested     at 
org.apache.derby.iapi.error.StandardException.newException(Unknown Source) 
~[derby-10.14.2.0.jar:?]  at 
org.apache.derby.iapi.error.StandardException.newException(Unknown Source) 
~[derby-10.14.2.0.jar:?]  at 
org.apache.derby.impl.services.locks.ConcurrentLockSet.lockObject(Unknown 
Source) ~[derby-10.14.2.0.jar:?]   at 
org.apache.derby.impl.services.locks.ConcurrentLockSet.zeroDurationLockObject(Unknown
 Source) ~[derby-10.14.2.0.jar:?]       at 
org.apache.derby.impl.services.locks.AbstractPool.zeroDurationlockObject(Unknown
 Source) ~[derby-10.14.2.0.jar:?]    at 
org.apache.derby.impl.services.locks.ConcurrentPool.zeroDurationlockObject(Unknown
 Source) ~[derby-10.14.2.0.jar:?]  at 
org.apache.derby.impl.store.raw.xact.RowLocking2nohold.lockRecordForRead(Unknown
 Source) ~[derby-10.14.2.0.jar:?]    at 
org.apache.derby.impl.store.access.heap.HeapController.lockRow(Unknown Source) 
~[derby-10.14.2.0.jar:?]      at 
org.apache.derby.impl.store.access.heap.HeapController.lockRow(Unknown Source) 
~[derby-10.14.2.0.jar:?]      at 
org.apache.derby.impl.store.access.btree.index.B2IRowLocking3.lockRowOnPage(Unknown
 Source) ~[derby-10.14.2.0.jar:?] at 
org.apache.derby.impl.store.access.btree.index.B2IRowLocking3._lockScanRow(Unknown
 Source) ~[derby-10.14.2.0.jar:?]  at 
org.apache.derby.impl.store.access.btree.index.B2IRowLockingRR.lockScanRow(Unknown
 Source) ~[derby-10.14.2.0.jar:?]  at 
org.apache.derby.impl.store.access.btree.BTreeMaxScan.positionAtStartPosition(Unknown
 Source) ~[derby-10.14.2.0.jar:?]       at 
org.apache.derby.impl.store.access.btree.BTreeMaxScan.fetchMax(Unknown Source) 
~[derby-10.14.2.0.jar:?]      at 
org.apache.derby.impl.store.access.btree.index.B2I.fetchMaxOnBTree(Unknown 
Source) ~[derby-10.14.2.0.jar:?]  at 
org.apache.derby.impl.store.access.RAMTransaction.fetchMaxOnBtree(Unknown 
Source) ~[derby-10.14.2.0.jar:?]   at 
org.apache.derby.impl.sql.execute.LastIndexKeyResultSet.openCore(Unknown 
Source) ~[derby-10.14.2.0.jar:?]    at 
org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.openCore(Unknown 
Source) ~[derby-10.14.2.0.jar:?] at 
org.apache.derby.impl.sql.execute.ScalarAggregateResultSet.openCore(Unknown 
Source) ~[derby-10.14.2.0.jar:?] at 
org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.openCore(Unknown 
Source) ~[derby-10.14.2.0.jar:?] at 
org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.open(Unknown Source) 
~[derby-10.14.2.0.jar:?]      at 
org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source) 
~[derby-10.14.2.0.jar:?]      at 
org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source) 
~[derby-10.14.2.0.jar:?]  at 
org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) 
~[derby-10.14.2.0.jar:?]  at 
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown 
Source) ~[derby-10.14.2.0.jar:?]  at 
org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeQuery(Unknown Source) 
~[derby-10.14.2.0.jar:?]      at 
org.apache.hive.com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
 ~[hive-exec-4.2.0-SNAPSHOT.jar:4.2.0-SNAPSHOT]    at 
org.apache.hive.com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
 ~[hive-exec-4.2.0-SNAPSHOT.jar:4.2.0-SNAPSHOT]   at 
org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:722)
 ~[spring-jdbc-5.3.39.jar:5.3.39]   at 
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:648) 
~[spring-jdbc-5.3.39.jar:5.3.39]   ... 53 more2025-08-12T12:37:53,401 ERROR 
[hive-precommit-pr-5779-10-zdrxz-91v6p-vz7rd-1527_timeout_executor] 
metastore.RetryingHMSHandler: MetaException(message:Failed to execute function: 
commitTxn(CommitTxnRequest(txnid:18)), details:PreparedStatementCallback; SQL 
[SELECT MAX("TXN_ID") FROM "TXNS"]; A lock could not be obtained within the 
time requested; nested exception is java.sql.SQLTransactionRollbackException: A 
lock could not be obtained within the time requested)    at 
org.apache.hadoop.hive.metastore.txn.retry.SqlRetryHandler.executeWithRetryInternal(SqlRetryHandler.java:155)
        at 
org.apache.hadoop.hive.metastore.txn.retry.SqlRetryHandler.executeWithRetryInternal(SqlRetryHandler.java:147)
        at 
org.apache.hadoop.hive.metastore.txn.retry.SqlRetryHandler.executeWithRetryInternal(SqlRetryHandler.java:147)
        at 
org.apache.hadoop.hive.metastore.txn.retry.SqlRetryHandler.executeWithRetryInternal(SqlRetryHandler.java:147)
        at 
org.apache.hadoop.hive.metastore.txn.retry.SqlRetryHandler.executeWithRetryInternal(SqlRetryHandler.java:147)
        at 
org.apache.hadoop.hive.metastore.txn.retry.SqlRetryHandler.executeWithRetryInternal(SqlRetryHandler.java:147)
        at 
org.apache.hadoop.hive.metastore.txn.retry.SqlRetryHandler.executeWithRetryInternal(SqlRetryHandler.java:147)
        at 
org.apache.hadoop.hive.metastore.txn.retry.SqlRetryHandler.executeWithRetryInternal(SqlRetryHandler.java:147)
        at 
org.apache.hadoop.hive.metastore.txn.retry.SqlRetryHandler.executeWithRetryInternal(SqlRetryHandler.java:147)
        at 
org.apache.hadoop.hive.metastore.txn.retry.SqlRetryHandler.executeWithRetryInternal(SqlRetryHandler.java:147)
        at 
org.apache.hadoop.hive.metastore.txn.retry.SqlRetryHandler.executeWithRetryInternal(SqlRetryHandler.java:147)
        at 
org.apache.hadoop.hive.metastore.txn.retry.SqlRetryHandler.executeWithRetry(SqlRetryHandler.java:122)
        at 
org.apache.hadoop.hive.metastore.txn.TransactionalRetryProxy.invoke(TransactionalRetryProxy.java:186)
        at jdk.proxy2/jdk.proxy2.$Proxy47.commitTxn(Unknown Source)     at 
org.apache.hadoop.hive.metastore.HMSHandler.commit_txn(HMSHandler.java:9071) at 
java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
        at java.base/java.lang.reflect.Method.invoke(Method.java:580)   at 
org.apache.hadoop.hive.metastore.RetryingHMSHandler.invokeInternal(RetryingHMSHandler.java:91)
       at 
org.apache.hadoop.hive.metastore.AbstractHMSHandlerProxy.invoke(AbstractHMSHandlerProxy.java:82)
     at jdk.proxy2/jdk.proxy2.$Proxy32.commit_txn(Unknown Source)    at 
org.apache.hadoop.hive.metastore.client.ThriftHiveMetaStoreClient.commitTxn(ThriftHiveMetaStoreClient.java:3069)
     at 
org.apache.hadoop.hive.metastore.client.MetaStoreClientWrapper.commitTxn(MetaStoreClientWrapper.java:851)
    at 
java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
        at java.base/java.lang.reflect.Method.invoke(Method.java:580)   at 
org.apache.hadoop.hive.metastore.client.SynchronizedMetaStoreClient$SynchronizedHandler.invoke(SynchronizedMetaStoreClient.java:69)
  at jdk.proxy2/jdk.proxy2.$Proxy33.commitTxn(Unknown Source)     at 
org.apache.hadoop.hive.metastore.client.MetaStoreClientWrapper.commitTxn(MetaStoreClientWrapper.java:851)
    at 
org.apache.hadoop.hive.metastore.client.MetaStoreClientWrapper.commitTxn(MetaStoreClientWrapper.java:851)
    at 
org.apache.hadoop.hive.metastore.client.BaseMetaStoreClient.commitTxn(BaseMetaStoreClient.java:710)
  at 
java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
        at java.base/java.lang.reflect.Method.invoke(Method.java:580)   at 
org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.invoke(RetryingMetaStoreClient.java:228)
    at jdk.proxy2/jdk.proxy2.$Proxy137.commitTxn(Unknown Source)    at 
org.apache.hadoop.hive.ql.txn.compactor.service.AcidCompactionService$CompactionTxn.commit(AcidCompactionService.java:417)
   at 
org.apache.hadoop.hive.ql.txn.compactor.service.AcidCompactionService$CompactionTxn.close(AcidCompactionService.java:397)
    at 
org.apache.hadoop.hive.ql.txn.compactor.service.AcidCompactionService.compact(AcidCompactionService.java:272)
        at 
org.apache.hadoop.hive.ql.txn.compactor.Worker.findNextCompactionAndExecute(Worker.java:245)
 at org.apache.hadoop.hive.ql.txn.compactor.Worker.lambda$run$0(Worker.java:91) 
 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) {code}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to