Aggarwal-Raghav commented on PR #6604:
URL: https://github.com/apache/hive/pull/6604#issuecomment-4972298403
@deniskuzZ , will it cause this stacktrace :-)
```
2026-07-14T16:45:08,491 ERROR [Metastore Scheduled Worker 13]
service.AcidTxnCleanerService: Unexpected exception in thread: Metastore
Scheduled Worker 13, message: Unable to lock TxnCleaner due to:
PreparedStatementCallback; SQL [INSERT INTO "AUX_TABLE" ("MT_KEY1", "MT_KEY2")
VALUES(?, 0)]; Deadlock found when trying to get lock; try restarting
transaction; nested exception is
com.mysql.cj.jdbc.exceptions.MySQLTransactionRollbackException: Deadlock found
when trying to get lock; try restarting transaction
java.lang.RuntimeException: Unable to lock TxnCleaner due to:
PreparedStatementCallback; SQL [INSERT INTO "AUX_TABLE" ("MT_KEY1", "MT_KEY2")
VALUES(?, 0)]; Deadlock found when trying to get lock; try restarting
transaction; nested exception is
com.mysql.cj.jdbc.exceptions.MySQLTransactionRollbackException: Deadlock found
when trying to get lock; try restarting transaction
at
org.apache.hadoop.hive.metastore.txn.TxnStoreMutex.acquireLock(TxnStoreMutex.java:85)
~[hive-exec-4.0.1.jar:4.0.1]
at
org.apache.hadoop.hive.metastore.txn.service.AcidTxnCleanerService.run(AcidTxnCleanerService.java:62)
~[hive-exec-4.0.1.jar:4.0.1]
at
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539) ~[?:?]
at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:305)
~[?:?]
at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:305)
~[?:?]
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
~[?:?]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
~[?:?]
at java.lang.Thread.run(Thread.java:840) ~[?:?]
Caused by: org.springframework.dao.DeadlockLoserDataAccessException:
PreparedStatementCallback; SQL [INSERT INTO "AUX_TABLE" ("MT_KEY1", "MT_KEY2")
VALUES(?, 0)]; Deadlock found when trying to get lock; try restarting
transaction; nested exception is
com.mysql.cj.jdbc.exceptions.MySQLTransactionRollbackException: Deadlock found
when trying to get lock; try restarting transaction
at
org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:268)
~[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.update(JdbcTemplate.java:960)
~[spring-jdbc-5.3.39.jar:5.3.39]
at
org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:981)
~[spring-jdbc-5.3.39.jar:5.3.39]
at
org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.update(NamedParameterJdbcTemplate.java:331)
~[spring-jdbc-5.3.39.jar:5.3.39]
at
org.apache.hadoop.hive.metastore.txn.TxnStoreMutex.acquireLock(TxnStoreMutex.java:81)
~[hive-exec-4.0.1.jar:4.0.1]
... 7 more
Caused by: com.mysql.cj.jdbc.exceptions.MySQLTransactionRollbackException:
Deadlock found when trying to get lock; try restarting transaction
at
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:123)
~[mysql-jdbc-driver.jar:8.0.30]
at
com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
~[mysql-jdbc-driver.jar:8.0.30]
at
com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916)
~[mysql-jdbc-driver.jar:8.0.30]
at
com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1061)
~[mysql-jdbc-driver.jar:8.0.30]
at
com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1009)
~[mysql-jdbc-driver.jar:8.0.30]
at
com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1320)
~[mysql-jdbc-driver.jar:8.0.30]
at
com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:994)
~[mysql-jdbc-driver.jar:8.0.30]
at
org.apache.hive.com.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61)
~[hive-exec-4.0.1.jar:4.0.1]
at
org.apache.hive.com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java)
~[hive-exec-4.0.1.jar:4.0.1]
at
org.springframework.jdbc.core.JdbcTemplate.lambda$update$2(JdbcTemplate.java:965)
~[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]
at
org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:960)
~[spring-jdbc-5.3.39.jar:5.3.39]
at
org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:981)
~[spring-jdbc-5.3.39.jar:5.3.39]
at
org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.update(NamedParameterJdbcTemplate.java:331)
~[spring-jdbc-5.3.39.jar:5.3.39]
at
org.apache.hadoop.hive.metastore.txn.TxnStoreMutex.acquireLock(TxnStoreMutex.java:81)
~[hive-exec-4.0.1.jar:4.0.1]
... 7 more
```
--
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.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
