Thread-8 15:52:32,995 WARN [JDBCExceptionReporter] SQL Error: 50200, SQLState: HYT00 Thread-8 15:52:32,995 ERROR [JDBCExceptionReporter] Timeout trying to lock table ; SQL statement: update NXP_UIDSEQ set SEQ_INDEX=?, SEQ_KEY=? where SEQ_ID=? [50200-177] Thread-8 15:52:32,995 WARN [JDBCExceptionReporter] SQL Error: 50200, SQLState: HYT00 Thread-8 15:52:32,995 ERROR [JDBCExceptionReporter] Timeout trying to lock table ; SQL statement: update NXP_UIDSEQ set SEQ_INDEX=?, SEQ_KEY=? where SEQ_ID=? [50200-177] Thread-8 15:52:32,995 ERROR [AbstractFlushingEventListener] Could not synchronize database state with session org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:126) at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:114) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:168) at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321) at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50) at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1028) at org.hibernate.ejb.AbstractEntityManagerImpl.flush(AbstractEntityManagerImpl.java:304) at org.nuxeo.ecm.core.persistence.PersistenceProvider.doCommit(PersistenceProvider.java:100) at org.nuxeo.ecm.core.persistence.PersistenceProvider.releaseEntityManager(PersistenceProvider.java:129) at org.nuxeo.ecm.core.persistence.PersistenceProvider.run(PersistenceProvider.java:167) at org.nuxeo.ecm.platform.uidgen.service.UIDSequencerImpl.getNext(UIDSequencerImpl.java:86) at org.nuxeo.ecm.platform.uidgen.AbstractUIDGenerator.getNext(AbstractUIDGenerator.java:56) at com.solocal.rcc.generators.CodeEtablissementGenerator.createUID(CodeEtablissementGenerator.java:38) at org.nuxeo.ecm.platform.uidgen.AbstractUIDGenerator.setUID(AbstractUIDGenerator.java:108) at org.nuxeo.ecm.platform.uidgen.service.UIDGeneratorService.setUID(UIDGeneratorService.java:168) at org.nuxeo.ecm.platform.uidgen.corelistener.DocUIDGeneratorListener.addUIDtoDoc(DocUIDGeneratorListener.java:72) at org.nuxeo.ecm.platform.uidgen.corelistener.DocUIDGeneratorListener.handleEvent(DocUIDGeneratorListener.java:58) at org.nuxeo.ecm.core.event.impl.EventServiceImpl.fireEvent(EventServiceImpl.java:191) at org.nuxeo.ecm.core.api.AbstractSession.notifyEvent(AbstractSession.java:271) at org.nuxeo.ecm.core.api.AbstractSession.createDocument(AbstractSession.java:732) at com.solocal.rcc.impl.adapters.AbstractDocAdapter.create(AbstractDocAdapter.java:44) at com.solocal.importer.SolocalDocumentFactory.createEtablissement(SolocalDocumentFactory.java:81) at com.solocal.importer.SolocalDocumentFactory.createFolderishNode(SolocalDocumentFactory.java:283) at com.solocal.importer.SolocalConsumer.process(SolocalConsumer.java:40) at org.nuxeo.ecm.platform.importer.queue.consumer.AbstractConsumer$1.run(AbstractConsumer.java:63) at org.nuxeo.ecm.core.api.UnrestrictedSessionRunner.runUnrestricted(UnrestrictedSessionRunner.java:139) at org.nuxeo.ecm.platform.importer.queue.consumer.AbstractConsumer.run(AbstractConsumer.java:83) at java.lang.Thread.run(Thread.java:745) Caused by: org.h2.jdbc.JdbcBatchUpdateException: Timeout trying to lock table ; SQL statement: update NXP_UIDSEQ set SEQ_INDEX=?, SEQ_KEY=? where SEQ_ID=? [50200-177] at org.h2.jdbc.JdbcPreparedStatement.executeBatch(JdbcPreparedStatement.java:1199) at org.tranql.connector.jdbc.StatementHandle.executeBatch(StatementHandle.java:155) at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70) at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268) ... 27 more Thread-8 15:52:32,996 ERROR [EventServiceImpl] Exception during uidlistener sync listener execution, continuing to run other listeners javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:614) at org.hibernate.ejb.AbstractEntityManagerImpl.flush(AbstractEntityManagerImpl.java:307) at org.nuxeo.ecm.core.persistence.PersistenceProvider.doCommit(PersistenceProvider.java:100) at org.nuxeo.ecm.core.persistence.PersistenceProvider.releaseEntityManager(PersistenceProvider.java:129) at org.nuxeo.ecm.core.persistence.PersistenceProvider.run(PersistenceProvider.java:167) at org.nuxeo.ecm.platform.uidgen.service.UIDSequencerImpl.getNext(UIDSequencerImpl.java:86) at org.nuxeo.ecm.platform.uidgen.AbstractUIDGenerator.getNext(AbstractUIDGenerator.java:56) at com.solocal.rcc.generators.CodeEtablissementGenerator.createUID(CodeEtablissementGenerator.java:38) at org.nuxeo.ecm.platform.uidgen.AbstractUIDGenerator.setUID(AbstractUIDGenerator.java:108) at org.nuxeo.ecm.platform.uidgen.service.UIDGeneratorService.setUID(UIDGeneratorService.java:168) at org.nuxeo.ecm.platform.uidgen.corelistener.DocUIDGeneratorListener.addUIDtoDoc(DocUIDGeneratorListener.java:72) at org.nuxeo.ecm.platform.uidgen.corelistener.DocUIDGeneratorListener.handleEvent(DocUIDGeneratorListener.java:58) at org.nuxeo.ecm.core.event.impl.EventServiceImpl.fireEvent(EventServiceImpl.java:191) at org.nuxeo.ecm.core.api.AbstractSession.notifyEvent(AbstractSession.java:271) at org.nuxeo.ecm.core.api.AbstractSession.createDocument(AbstractSession.java:732) at com.solocal.rcc.impl.adapters.AbstractDocAdapter.create(AbstractDocAdapter.java:44) at com.solocal.importer.SolocalDocumentFactory.createEtablissement(SolocalDocumentFactory.java:81) at com.solocal.importer.SolocalDocumentFactory.createFolderishNode(SolocalDocumentFactory.java:283) at com.solocal.importer.SolocalConsumer.process(SolocalConsumer.java:40) at org.nuxeo.ecm.platform.importer.queue.consumer.AbstractConsumer$1.run(AbstractConsumer.java:63) at org.nuxeo.ecm.core.api.UnrestrictedSessionRunner.runUnrestricted(UnrestrictedSessionRunner.java:139) at org.nuxeo.ecm.platform.importer.queue.consumer.AbstractConsumer.run(AbstractConsumer.java:83) at java.lang.Thread.run(Thread.java:745) Caused by: org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:126) at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:114) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:168) at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321) at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50) at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1028) at org.hibernate.ejb.AbstractEntityManagerImpl.flush(AbstractEntityManagerImpl.java:304) ... 21 more Caused by: org.h2.jdbc.JdbcBatchUpdateException: Timeout trying to lock table ; SQL statement: update NXP_UIDSEQ set SEQ_INDEX=?, SEQ_KEY=? where SEQ_ID=? [50200-177] at org.h2.jdbc.JdbcPreparedStatement.executeBatch(JdbcPreparedStatement.java:1199) at org.tranql.connector.jdbc.StatementHandle.executeBatch(StatementHandle.java:155) at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70) at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268) ... 27 more