Skip to content

Instantly share code, notes, and snippets.

@gamerson

gamerson/gist:f80c0fe43482bb6816437f50270b38fe

Created December 5, 2025 21:29
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save gamerson/f80c0fe43482bb6816437f50270b38fe to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save gamerson/f80c0fe43482bb6816437f50270b38fe to your computer and use it in GitHub Desktop.
Download ZIP
batch startup exception
Raw
gistfile1.txt
2025-12-05 20:36:39.750 ERROR [default-2][SqlExceptionHelper:142] (conn=3) Lock wait timeout exceeded; try restarting transaction
2025-12-05 20:36:39.765 ERROR [default-2][BatchEngineImportTaskExecutorImpl:170] Unable to update batch engine import task {"mvccVersion": 2, "uuid": "a67cb4bb-16d5-2409-6597-29f5a831a46d", "externalReferenceCode": "a67cb4bb-16d5-2409-6597-29f5a831a46d", "batchEngineImportTaskId": 101, "companyId":
87215626323870, "userId": 33605, "createDate": "2025-12-05 19:36:13.38", "modifiedDate": "Fri Dec 05 20:35:49 GMT 2025", "batchSize": 100, "callbackURL": "", "className": "com.liferay.object.admin.rest.dto.v1_0.ObjectDefinition", "contentType": "JSON", "endTime": "null", "errorMessage": "", "execute
Status": "STARTED", "fieldNameMapping": "null", "importStrategy": 2, "operation": "CREATE", "parameters": "{containsHeaders=true, updateStrategy=UPDATE, createStrategy=UPSERT, importStrategy=ON_ERROR_FAIL}", "processedItemsCount": 0, "startTime": "Fri Dec 05 20:35:49 GMT 2025", "taskItemDelegateName
": "DEFAULT", "totalItemsCount": 4}
com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: jakarta.persistence.PessimisticLockException: could not execute batch
at com.liferay.portal.kernel.service.persistence.impl.BasePersistenceImpl.processException(BasePersistenceImpl.java:657) ~[portal-kernel.jar:?]
at com.liferay.batch.engine.service.persistence.impl.BatchEngineImportTaskPersistenceImpl.updateImpl(BatchEngineImportTaskPersistenceImpl.java:2879) ~[?:?]
at com.liferay.batch.engine.service.persistence.impl.BatchEngineImportTaskPersistenceImpl.updateImpl(BatchEngineImportTaskPersistenceImpl.java:76) ~[?:?]
at com.liferay.portal.kernel.service.persistence.impl.BasePersistenceImpl.update(BasePersistenceImpl.java:807) ~[portal-kernel.jar:?]
at com.liferay.batch.engine.service.base.BatchEngineImportTaskLocalServiceBaseImpl.updateBatchEngineImportTask(BatchEngineImportTaskLocalServiceBaseImpl.java:534) ~[?:?]
at jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103) ~[?:?]
at java.lang.reflect.Method.invoke(Method.java:580) ~[?:?]
at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:41) ~[portal-impl.jar:?]
at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:68) ~[portal-impl.jar:?]
at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:48) ~[portal-impl.jar:?]
at com.liferay.portal.kernel.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:55) ~[portal-kernel.jar:?]
at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:48) ~[portal-impl.jar:?]
at com.liferay.portal.spring.aop.AopInvocationHandler.invoke(AopInvocationHandler.java:40) ~[portal-impl.jar:?]
at jdk.proxy286.$Proxy908.updateBatchEngineImportTask(Unknown Source) ~[?:?]
at com.liferay.batch.engine.internal.BatchEngineImportTaskExecutorImpl.execute(BatchEngineImportTaskExecutorImpl.java:152) ~[?:?]
at com.liferay.batch.engine.internal.BatchEngineImportTaskExecutorImpl.execute(BatchEngineImportTaskExecutorImpl.java:90) ~[?:?]
at com.liferay.batch.engine.internal.scheduler.BatchEngineTaskOrphanScannerSchedulerJobConfiguration.lambda$getJobExecutorUnsafeRunnable$1(BatchEngineTaskOrphanScannerSchedulerJobConfiguration.java:77) ~[?:?]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:572) ~[?:?]
at java.util.concurrent.FutureTask.run(FutureTask.java:317) ~[?:?]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144) ~[?:?]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642) ~[?:?]
at java.lang.Thread.run(Thread.java:1583) [?:?]
Caused by: com.liferay.portal.kernel.dao.orm.ORMException: jakarta.persistence.PessimisticLockException: could not execute batch
at com.liferay.portal.dao.orm.hibernate.ExceptionTranslator.translate(ExceptionTranslator.java:30) ~[portal-impl.jar:?]
at com.liferay.portal.dao.orm.hibernate.SessionImpl.flush(SessionImpl.java:272) ~[portal-impl.jar:?]
at com.liferay.batch.engine.service.persistence.impl.BatchEngineImportTaskPersistenceImpl.updateImpl(BatchEngineImportTaskPersistenceImpl.java:2875) ~[?:?]
... 20 more
Caused by: jakarta.persistence.PessimisticLockException: could not execute batch
at org.hibernate.internal.ExceptionConverterImpl.wrapLockException(ExceptionConverterImpl.java:273) ~[hibernate-core.jar:5.6.7.Final]
at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:108) ~[hibernate-core.jar:5.6.7.Final]
at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:181) ~[hibernate-core.jar:5.6.7.Final]
at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:188) ~[hibernate-core.jar:5.6.7.Final]
at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1411) ~[hibernate-core.jar:5.6.7.Final]
at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1394) ~[hibernate-core.jar:5.6.7.Final]
at com.liferay.portal.dao.orm.hibernate.SessionImpl.flush(SessionImpl.java:269) ~[portal-impl.jar:?]
at com.liferay.batch.engine.service.persistence.impl.BatchEngineImportTaskPersistenceImpl.updateImpl(BatchEngineImportTaskPersistenceImpl.java:2875) ~[?:?]
... 20 more
Caused by: org.hibernate.PessimisticLockException: could not execute batch
at org.hibernate.dialect.MySQLDialect$3.convert(MySQLDialect.java:547) ~[hibernate-core.jar:5.6.7.Final]
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:37) ~[hibernate-core.jar:5.6.7.Final]
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113) ~[hibernate-core.jar:5.6.7.Final]
at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:135) ~[hibernate-core.jar:5.6.7.Final]
at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.doExecuteBatch(BatchingBatch.java:110) ~[hibernate-core.jar:5.6.7.Final]
at org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl.execute(AbstractBatchImpl.java:153) ~[hibernate-core.jar:5.6.7.Final]
at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.executeBatch(JdbcCoordinatorImpl.java:198) ~[hibernate-core.jar:5.6.7.Final]
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:633) ~[hibernate-core.jar:5.6.7.Final]
at org.hibernate.engine.spi.ActionQueue.lambda$executeActions$1(ActionQueue.java:478) ~[hibernate-core.jar:5.6.7.Final]
at java.util.LinkedHashMap.forEach(LinkedHashMap.java:986) ~[?:?]
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:475) ~[hibernate-core.jar:5.6.7.Final]
at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:344) ~[hibernate-core.jar:5.6.7.Final]
at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:40) ~[hibernate-core.jar:5.6.7.Final]
at org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:107) ~[hibernate-core.jar:5.6.7.Final]
at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1407) ~[hibernate-core.jar:5.6.7.Final]
at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1394) ~[hibernate-core.jar:5.6.7.Final]
at com.liferay.portal.dao.orm.hibernate.SessionImpl.flush(SessionImpl.java:269) ~[portal-impl.jar:?]
at com.liferay.batch.engine.service.persistence.impl.BatchEngineImportTaskPersistenceImpl.updateImpl(BatchEngineImportTaskPersistenceImpl.java:2875) ~[?:?]
... 20 more
Caused by: java.sql.BatchUpdateException: (conn=3) Lock wait timeout exceeded; try restarting transaction
at org.mariadb.jdbc.export.ExceptionFactory.createBatchUpdate(ExceptionFactory.java:215) ~[mariadb.jar:?]
at org.mariadb.jdbc.client.impl.StandardClient.executePipeline(StandardClient.java:648) ~[mariadb.jar:?]
at org.mariadb.jdbc.ClientPreparedStatement.executeBatchPipeline(ClientPreparedStatement.java:199) ~[mariadb.jar:?]
at org.mariadb.jdbc.ClientPreparedStatement.executeInternalPreparedBatch(ClientPreparedStatement.java:130) ~[mariadb.jar:?]
at org.mariadb.jdbc.ClientPreparedStatement.executeBatch(ClientPreparedStatement.java:469) ~[mariadb.jar:?]
at com.zaxxer.hikari.pool.ProxyStatement.executeBatch(ProxyStatement.java:127) ~[hikaricp.jar:?]
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeBatch(HikariProxyPreparedStatement.java) ~[hikaricp.jar:?]
at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:125) ~[hibernate-core.jar:5.6.7.Final]
at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.doExecuteBatch(BatchingBatch.java:110) ~[hibernate-core.jar:5.6.7.Final]
at org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl.execute(AbstractBatchImpl.java:153) ~[hibernate-core.jar:5.6.7.Final]
at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.executeBatch(JdbcCoordinatorImpl.java:198) ~[hibernate-core.jar:5.6.7.Final]
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:633) ~[hibernate-core.jar:5.6.7.Final]
at org.hibernate.engine.spi.ActionQueue.lambda$executeActions$1(ActionQueue.java:478) ~[hibernate-core.jar:5.6.7.Final]
at java.util.LinkedHashMap.forEach(LinkedHashMap.java:986) ~[?:?]
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:475) ~[hibernate-core.jar:5.6.7.Final]
at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:344) ~[hibernate-core.jar:5.6.7.Final]
at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:40) ~[hibernate-core.jar:5.6.7.Final]
at org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:107) ~[hibernate-core.jar:5.6.7.Final]
at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1407) ~[hibernate-core.jar:5.6.7.Final]
at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1394) ~[hibernate-core.jar:5.6.7.Final]
at com.liferay.portal.dao.orm.hibernate.SessionImpl.flush(SessionImpl.java:269) ~[portal-impl.jar:?]
at com.liferay.batch.engine.service.persistence.impl.BatchEngineImportTaskPersistenceImpl.updateImpl(BatchEngineImportTaskPersistenceImpl.java:2875) ~[?:?]
... 20 more
Caused by: java.sql.SQLException: (conn=3) Lock wait timeout exceeded; try restarting transaction
at org.mariadb.jdbc.export.ExceptionFactory.createException(ExceptionFactory.java:299) ~[mariadb.jar:?]
at org.mariadb.jdbc.export.ExceptionFactory.create(ExceptionFactory.java:370) ~[mariadb.jar:?]
at org.mariadb.jdbc.message.ClientMessage.readPacket(ClientMessage.java:134) ~[mariadb.jar:?]
at org.mariadb.jdbc.client.impl.StandardClient.readPacket(StandardClient.java:883) ~[mariadb.jar:?]
at org.mariadb.jdbc.client.impl.StandardClient.readResults(StandardClient.java:822) ~[mariadb.jar:?]
at org.mariadb.jdbc.client.impl.StandardClient.readResponse(StandardClient.java:741) ~[mariadb.jar:?]
at org.mariadb.jdbc.client.impl.StandardClient.executePipeline(StandardClient.java:582) ~[mariadb.jar:?]
at org.mariadb.jdbc.ClientPreparedStatement.executeBatchPipeline(ClientPreparedStatement.java:199) ~[mariadb.jar:?]
at org.mariadb.jdbc.ClientPreparedStatement.executeInternalPreparedBatch(ClientPreparedStatement.java:130) ~[mariadb.jar:?]
at org.mariadb.jdbc.ClientPreparedStatement.executeBatch(ClientPreparedStatement.java:469) ~[mariadb.jar:?]
at com.zaxxer.hikari.pool.ProxyStatement.executeBatch(ProxyStatement.java:127) ~[hikaricp.jar:?]
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeBatch(HikariProxyPreparedStatement.java) ~[hikaricp.jar:?]
at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:125) ~[hibernate-core.jar:5.6.7.Final]
at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.doExecuteBatch(BatchingBatch.java:110) ~[hibernate-core.jar:5.6.7.Final]
at org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl.execute(AbstractBatchImpl.java:153) ~[hibernate-core.jar:5.6.7.Final]
at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.executeBatch(JdbcCoordinatorImpl.java:198) ~[hibernate-core.jar:5.6.7.Final]
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:633) ~[hibernate-core.jar:5.6.7.Final]
at org.hibernate.engine.spi.ActionQueue.lambda$executeActions$1(ActionQueue.java:478) ~[hibernate-core.jar:5.6.7.Final]
at java.util.LinkedHashMap.forEach(LinkedHashMap.java:986) ~[?:?]
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:475) ~[hibernate-core.jar:5.6.7.Final]
at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:344) ~[hibernate-core.jar:5.6.7.Final]
at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:40) ~[hibernate-core.jar:5.6.7.Final]
at org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:107) ~[hibernate-core.jar:5.6.7.Final]
at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1407) ~[hibernate-core.jar:5.6.7.Final]
at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1394) ~[hibernate-core.jar:5.6.7.Final]
at com.liferay.portal.dao.orm.hibernate.SessionImpl.flush(SessionImpl.java:269) ~[portal-impl.jar:?]
at com.liferay.batch.engine.service.persistence.impl.BatchEngineImportTaskPersistenceImpl.updateImpl(BatchEngineImportTaskPersistenceImpl.java:2875) ~[?:?]
... 20 more
2025-12-05 20:37:29.782 ERROR [default-2][SqlExceptionHelper:142] (conn=3) Lock wait timeout exceeded; try restarting transaction
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment