![]() ![]() ![]() ![]() I don’t get this exception everytime, looks like it is happening only when we have lot of requests that performs the delete operation.ĭetailed Exception log : could not execute statement SQL nested exception is : could not execute statementĪt .(HibernateJpaDialect.java:267)Īt .(HibernateJpaDialect.java:233)Īt .anslateExceptionIfPossible(AbstractEntityManagerFactoryBean.java:551)Īt .anslateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:61)Īt .anslateIfNecessary(DataAccessUtils.java:242)Īt .PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:152)Īt .ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)Īt .$CrudMethodMetadataPopulatingMethodInterceptor.invoke(CrudMethodMetadataPostProcessor.java:145)Ĭaused by: : could not execute statementĪt $3.convert(MySQLDialect.java:557)Īt .nvert(StandardSQLExceptionConverter.java:42)Īt .(SqlExceptionHelper.java:113)Īt .(SqlExceptionHelper.java:99)Īt .(ResultSetReturnImpl.java:200)Īt .(BasicExecutor.java:80)Īt .(BasicExecutor.java:50)Īt .(DeleteExecutor.java:177)Īt .(QueryTranslatorImpl.java:458)Īt .(HQLQueryPlan.java:377)Īt .executeUpdate(SessionImpl.java:1438)Īt .AbstractProducedQuery.doExecuteUpdate(AbstractProducedQuery.java:1690)Īt .AbstractProducedQuery.executeUpdate(AbstractProducedQuery.java:1672)Īt .$ModifyingExecution.doExecute(JpaQueryExecution.java:238)Īt .(JpaQueryExecution.java:88)Īt .(AbstractJpaQuery.java:155)Īt .(AbstractJpaQuery.java:143)Īt .(RepositoryMethodInvoker.java:137)Īt .(RepositoryMethodInvoker.java:121)Īt .(QueryExecutorMethodInterceptor.java:152)Īt .(QueryExecutorMethodInterceptor.java:131)Īt .DefaultMethodInvokingMethodInterceptor.invoke(DefaultMethodInvokingMethodInterceptor.java:80)Īt .TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123)Īt .TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:388)Īt .TransactionInterceptor.invoke(TransactionInterceptor.java:119)Īt .PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137)Ĭaused by: : (conn=161649) Deadlock found when trying to get lock try restarting transactionĪt .(ExceptionFactory.java:76)Īt .(ExceptionFactory.java:153)Īt .executeExceptionEpilogue(MariaDbStatement.java:274)Īt .executeInternal(ClientSidePreparedStatement.java:229)Īt .execute(ClientSidePreparedStatement.java:149)Īt .executeUpdate(ClientSidePreparedStatement.java:181)Īt .ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61)Īt .HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java)Īt .(ResultSetReturnImpl.java:197)Ĭaused by: .: Deadlock found when trying to get lock try restarting transactionĪt .(MariaDbSqlException.java:34)Īt .(AbstractQueryProtocol.java:194)Īt .(AbstractQueryProtocol.java:177)Īt .(AbstractQueryProtocol.java:321)Īt .executeInternal(ClientSidePreparedStatement.java:220)Ĭaused by: : Deadlock found when trying to get lock try restarting transactionĪt .(AbstractQueryProtocol.java:1683)Īt .(AbstractQueryProtocol.java:1545)Īt .(AbstractQueryProtocol.java:1508)Īt .(AbstractQueryProtocol.java:318)ĬleteOldCollection(collectionId, botRef) - line causing the error When I try to perform some delete operation using NativeQuery on a table I’m getting : Deadlock found when trying to get lock try restarting transaction this exception. I’ve a spring app with hibernate which is connected to MariaDb. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |