Unable to lock global revision table

Hi,
Recently we are facing issue to save console changes.
org.apache.jackrabbit.core.state.ItemStateException: Unable to create log entry: Unable to lock global revision table

Thanks.

error log:

ERROR 03.10.2022 10:37:56 BU=, SERVER_ID=, SES_ID=, REQ_ID=, CUST_EMAIL=, CART_ID= [Hippo JCR Quartz Job Scheduler_Worker-2] [org.hippoecm.repository.quartz.JCRJobStore.triggeredJobComplete():691] Failed to finalize job: d9b9b27a-08e5-41aa-8a11-80e1d9d1dfd8
javax.jcr.RepositoryException: Unable to update item: item.save()
	at org.apache.jackrabbit.core.ItemSaveOperation.perform(ItemSaveOperation.java:265) ~[jackrabbit-core-2.21.6-h3.jar:14.7.7]
	at org.apache.jackrabbit.core.session.SessionState.perform(SessionState.java:216) ~[jackrabbit-core-2.21.6-h3.jar:2.21.6-h3]
	at org.apache.jackrabbit.core.ItemImpl.perform(ItemImpl.java:91) ~[jackrabbit-core-2.21.6-h3.jar:14.7.7]
	at org.apache.jackrabbit.core.ItemImpl.save(ItemImpl.java:329) ~[jackrabbit-core-2.21.6-h3.jar:14.7.7]
	at org.apache.jackrabbit.core.session.SessionSaveOperation.perform(SessionSaveOperation.java:65) ~[jackrabbit-core-2.21.6-h3.jar:2.21.6-h3]
	at org.apache.jackrabbit.core.session.SessionState.perform(SessionState.java:216) ~[jackrabbit-core-2.21.6-h3.jar:2.21.6-h3]
	at org.apache.jackrabbit.core.SessionImpl.perform(SessionImpl.java:367) ~[jackrabbit-core-2.21.6-h3.jar:14.7.7]
	at org.apache.jackrabbit.core.SessionImpl.save(SessionImpl.java:856) ~[jackrabbit-core-2.21.6-h3.jar:14.7.7]
	at org.hippoecm.repository.impl.SessionDecorator.save(SessionDecorator.java:279) ~[hippo-repository-engine-14.7.7.jar:14.7.7]
	at org.hippoecm.repository.quartz.JCRJobStore.triggeredJobComplete(JCRJobStore.java:671) [hippo-repository-engine-14.7.7.jar:14.7.7]
	at org.quartz.core.QuartzScheduler.notifyJobStoreJobComplete(QuartzScheduler.java:1786) [quartz-2.3.2.jar:?]
	at org.quartz.core.JobRunShell.run(JobRunShell.java:269) [quartz-2.3.2.jar:?]
	at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573) [quartz-2.3.2.jar:?]
Caused by: org.apache.jackrabbit.core.state.ItemStateException: Unable to create log entry: Unable to lock global revision table.
	at org.apache.jackrabbit.core.state.SharedItemStateManager$Update.begin(SharedItemStateManager.java:610) ~[jackrabbit-core-2.21.6-h3.jar:2.21.6-h3]
	at org.apache.jackrabbit.core.state.SharedItemStateManager.beginUpdate(SharedItemStateManager.java:1545) ~[jackrabbit-core-2.21.6-h3.jar:2.21.6-h3]
	at org.apache.jackrabbit.core.state.SharedItemStateManager.update(SharedItemStateManager.java:1577) ~[jackrabbit-core-2.21.6-h3.jar:2.21.6-h3]
	at org.apache.jackrabbit.core.state.LocalItemStateManager.update(LocalItemStateManager.java:400) ~[jackrabbit-core-2.21.6-h3.jar:2.21.6-h3]
	at org.apache.jackrabbit.core.state.XAItemStateManager.update(XAItemStateManager.java:354) ~[jackrabbit-core-2.21.6-h3.jar:2.21.6-h3]
	at org.hippoecm.repository.jackrabbit.HippoLocalItemStateManager.update(HippoLocalItemStateManager.java:289) ~[hippo-repository-engine-14.7.7.jar:14.7.7]
	at org.apache.jackrabbit.core.state.LocalItemStateManager.update(LocalItemStateManager.java:375) ~[jackrabbit-core-2.21.6-h3.jar:2.21.6-h3]
	at org.hippoecm.repository.jackrabbit.HippoLocalItemStateManager.update(HippoLocalItemStateManager.java:298) ~[hippo-repository-engine-14.7.7.jar:14.7.7]
	at org.apache.jackrabbit.core.state.SessionItemStateManager.update(SessionItemStateManager.java:275) ~[jackrabbit-core-2.21.6-h3.jar:2.21.6-h3]
	at org.apache.jackrabbit.core.ItemSaveOperation.perform(ItemSaveOperation.java:258) ~[jackrabbit-core-2.21.6-h3.jar:14.7.7]
	... 12 more
Caused by: org.apache.jackrabbit.core.cluster.ClusterException: Unable to create log entry: Unable to lock global revision table.
	at org.apache.jackrabbit.core.cluster.ClusterNode$WorkspaceUpdateChannel.updateCreated(ClusterNode.java:639) ~[jackrabbit-core-2.21.6-h3.jar:2.21.6-h3]
	at org.hippoecm.repository.jackrabbit.HippoSharedItemStateManager$DocumentChangeNotifyingEventChannelDecorator.updateCreated(HippoSharedItemStateManager.java:279) ~[hippo-repository-engine-14.7.7.jar:14.7.7]
	at org.apache.jackrabbit.core.state.SharedItemStateManager$Update.begin(SharedItemStateManager.java:608) ~[jackrabbit-core-2.21.6-h3.jar:2.21.6-h3]
	at org.apache.jackrabbit.core.state.SharedItemStateManager.beginUpdate(SharedItemStateManager.java:1545) ~[jackrabbit-core-2.21.6-h3.jar:2.21.6-h3]
	at org.apache.jackrabbit.core.state.SharedItemStateManager.update(SharedItemStateManager.java:1577) ~[jackrabbit-core-2.21.6-h3.jar:2.21.6-h3]
	at org.apache.jackrabbit.core.state.LocalItemStateManager.update(LocalItemStateManager.java:400) ~[jackrabbit-core-2.21.6-h3.jar:2.21.6-h3]
	at org.apache.jackrabbit.core.state.XAItemStateManager.update(XAItemStateManager.java:354) ~[jackrabbit-core-2.21.6-h3.jar:2.21.6-h3]
	at org.hippoecm.repository.jackrabbit.HippoLocalItemStateManager.update(HippoLocalItemStateManager.java:289) ~[hippo-repository-engine-14.7.7.jar:14.7.7]
	at org.apache.jackrabbit.core.state.LocalItemStateManager.update(LocalItemStateManager.java:375) ~[jackrabbit-core-2.21.6-h3.jar:2.21.6-h3]
	at org.hippoecm.repository.jackrabbit.HippoLocalItemStateManager.update(HippoLocalItemStateManager.java:298) ~[hippo-repository-engine-14.7.7.jar:14.7.7]
	at org.apache.jackrabbit.core.state.SessionItemStateManager.update(SessionItemStateManager.java:275) ~[jackrabbit-core-2.21.6-h3.jar:2.21.6-h3]
	at org.apache.jackrabbit.core.ItemSaveOperation.perform(ItemSaveOperation.java:258) ~[jackrabbit-core-2.21.6-h3.jar:14.7.7]
	... 12 more
Caused by: org.apache.jackrabbit.core.journal.JournalException: Unable to lock global revision table.
	at org.apache.jackrabbit.core.journal.DatabaseJournal.doLock(DatabaseJournal.java:484) ~[jackrabbit-core-2.21.6-h3.jar:2.21.6-h3]
	at org.apache.jackrabbit.core.journal.AbstractJournal.internalLockAndSync(AbstractJournal.java:321) ~[jackrabbit-core-2.21.6-h3.jar:2.21.6-h3]
	at org.apache.jackrabbit.core.journal.AbstractJournal.lockAndSync(AbstractJournal.java:299) ~[jackrabbit-core-2.21.6-h3.jar:2.21.6-h3]
	at org.apache.jackrabbit.core.journal.DefaultRecordProducer.append(DefaultRecordProducer.java:51) ~[jackrabbit-core-2.21.6-h3.jar:2.21.6-h3]
	at org.apache.jackrabbit.core.cluster.ClusterNode$WorkspaceUpdateChannel.updateCreated(ClusterNode.java:635) ~[jackrabbit-core-2.21.6-h3.jar:2.21.6-h3]
	at org.hippoecm.repository.jackrabbit.HippoSharedItemStateManager$DocumentChangeNotifyingEventChannelDecorator.updateCreated(HippoSharedItemStateManager.java:279) ~[hippo-repository-engine-14.7.7.jar:14.7.7]
	at org.apache.jackrabbit.core.state.SharedItemStateManager$Update.begin(SharedItemStateManager.java:608) ~[jackrabbit-core-2.21.6-h3.jar:2.21.6-h3]
	at org.apache.jackrabbit.core.state.SharedItemStateManager.beginUpdate(SharedItemStateManager.java:1545) ~[jackrabbit-core-2.21.6-h3.jar:2.21.6-h3]
	at org.apache.jackrabbit.core.state.SharedItemStateManager.update(SharedItemStateManager.java:1577) ~[jackrabbit-core-2.21.6-h3.jar:2.21.6-h3]
	at org.apache.jackrabbit.core.state.LocalItemStateManager.update(LocalItemStateManager.java:400) ~[jackrabbit-core-2.21.6-h3.jar:2.21.6-h3]
	at org.apache.jackrabbit.core.state.XAItemStateManager.update(XAItemStateManager.java:354) ~[jackrabbit-core-2.21.6-h3.jar:2.21.6-h3]
	at org.hippoecm.repository.jackrabbit.HippoLocalItemStateManager.update(HippoLocalItemStateManager.java:289) ~[hippo-repository-engine-14.7.7.jar:14.7.7]
	at org.apache.jackrabbit.core.state.LocalItemStateManager.update(LocalItemStateManager.java:375) ~[jackrabbit-core-2.21.6-h3.jar:2.21.6-h3]
	at org.hippoecm.repository.jackrabbit.HippoLocalItemStateManager.update(HippoLocalItemStateManager.java:298) ~[hippo-repository-engine-14.7.7.jar:14.7.7]
	at org.apache.jackrabbit.core.state.SessionItemStateManager.update(SessionItemStateManager.java:275) ~[jackrabbit-core-2.21.6-h3.jar:2.21.6-h3]
	at org.apache.jackrabbit.core.ItemSaveOperation.perform(ItemSaveOperation.java:258) ~[jackrabbit-core-2.21.6-h3.jar:14.7.7]
	... 12 more
Caused by: com.mysql.cj.jdbc.exceptions.MySQLTransactionRollbackException: Lock wait timeout exceeded; try restarting transaction
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:123) ~[mysql-connector-java-8.0.21.jar:8.0.21]
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[mysql-connector-java-8.0.21.jar:8.0.21]
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql-connector-java-8.0.21.jar:8.0.21]
	at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:764) ~[mysql-connector-java-8.0.21.jar:8.0.21]
	at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:648) ~[mysql-connector-java-8.0.21.jar:8.0.21]
	at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:193) ~[tomcat-dbcp.jar:9.0.62]
	at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:193) ~[tomcat-dbcp.jar:9.0.62]
	at org.apache.jackrabbit.core.util.db.ConnectionHelper.reallyExec(ConnectionHelper.java:309) ~[jackrabbit-data-2.21.6-h3.jar:2.21.6-h3]
	at org.apache.jackrabbit.core.util.db.ConnectionHelper$1.call(ConnectionHelper.java:293) ~[jackrabbit-data-2.21.6-h3.jar:2.21.6-h3]
	at org.apache.jackrabbit.core.util.db.ConnectionHelper$1.call(ConnectionHelper.java:289) ~[jackrabbit-data-2.21.6-h3.jar:2.21.6-h3]
	at org.apache.jackrabbit.core.util.db.ConnectionHelper$RetryManager.doTry(ConnectionHelper.java:545) ~[jackrabbit-data-2.21.6-h3.jar:2.21.6-h3]
	at org.apache.jackrabbit.core.util.db.ConnectionHelper.exec(ConnectionHelper.java:297) ~[jackrabbit-data-2.21.6-h3.jar:2.21.6-h3]
	at org.apache.jackrabbit.core.journal.DatabaseJournal.doLock(DatabaseJournal.java:476) ~[jackrabbit-core-2.21.6-h3.jar:2.21.6-h3]
	at org.apache.jackrabbit.core.journal.AbstractJournal.internalLockAndSync(AbstractJournal.java:321) ~[jackrabbit-core-2.21.6-h3.jar:2.21.6-h3]
	at org.apache.jackrabbit.core.journal.AbstractJournal.lockAndSync(AbstractJournal.java:299) ~[jackrabbit-core-2.21.6-h3.jar:2.21.6-h3]
	at org.apache.jackrabbit.core.journal.DefaultRecordProducer.append(DefaultRecordProducer.java:51) ~[jackrabbit-core-2.21.6-h3.jar:2.21.6-h3]
	at org.apache.jackrabbit.core.cluster.ClusterNode$WorkspaceUpdateChannel.updateCreated(ClusterNode.java:635) ~[jackrabbit-core-2.21.6-h3.jar:2.21.6-h3]
	at org.hippoecm.repository.jackrabbit.HippoSharedItemStateManager$DocumentChangeNotifyingEventChannelDecorator.updateCreated(HippoSharedItemStateManager.java:279) ~[hippo-repository-engine-14.7.7.jar:14.7.7]
	at org.apache.jackrabbit.core.state.SharedItemStateManager$Update.begin(SharedItemStateManager.java:608) ~[jackrabbit-core-2.21.6-h3.jar:2.21.6-h3]
	at org.apache.jackrabbit.core.state.SharedItemStateManager.beginUpdate(SharedItemStateManager.java:1545) ~[jackrabbit-core-2.21.6-h3.jar:2.21.6-h3]
	at org.apache.jackrabbit.core.state.SharedItemStateManager.update(SharedItemStateManager.java:1577) ~[jackrabbit-core-2.21.6-h3.jar:2.21.6-h3]
	at org.apache.jackrabbit.core.state.LocalItemStateManager.update(LocalItemStateManager.java:400) ~[jackrabbit-core-2.21.6-h3.jar:2.21.6-h3]
	at org.apache.jackrabbit.core.state.XAItemStateManager.update(XAItemStateManager.java:354) ~[jackrabbit-core-2.21.6-h3.jar:2.21.6-h3]
	at org.hippoecm.repository.jackrabbit.HippoLocalItemStateManager.update(HippoLocalItemStateManager.java:289) ~[hippo-repository-engine-14.7.7.jar:14.7.7]
	at org.apache.jackrabbit.core.state.LocalItemStateManager.update(LocalItemStateManager.java:375) ~[jackrabbit-core-2.21.6-h3.jar:2.21.6-h3]
	at org.hippoecm.repository.jackrabbit.HippoLocalItemStateManager.update(HippoLocalItemStateManager.java:298) ~[hippo-repository-engine-14.7.7.jar:14.7.7]
	at org.apache.jackrabbit.core.state.SessionItemStateManager.update(SessionItemStateManager.java:275) ~[jackrabbit-core-2.21.6-h3.jar:2.21.6-h3]
	at org.apache.jackrabbit.core.ItemSaveOperation.perform(ItemSaveOperation.java:258) ~[jackrabbit-core-2.21.6-h3.jar:14.7.7]
	... 12 more
.
	at org.quartz.core.JobRunShell.run(JobRunShell.java:213) [quartz-2.3.2.jar:?]
	at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573) [quartz-2.3.2.jar:?]
Caused by: java.lang.IllegalStateException: closed
	at com.squareup.okhttp.internal.http.Http1xStream$FixedLengthSource.read(Http1xStream.java:390) ~[okhttp-2.7.5.jar:?]
	at okio.Buffer.writeAll(Buffer.java:956) ~[okio-1.6.0.jar:?]
	at okio.RealBufferedSource.readByteArray(RealBufferedSource.java:92) ~[okio-1.6.0.jar:?]
	at com.squareup.okhttp.ResponseBody.bytes(ResponseBody.java:57) ~[okhttp-2.7.5.jar:?]
	at com.squareup.okhttp.ResponseBody.string(ResponseBody.java:83) ~[okhttp-2.7.5.jar:?]
	at com.osudio.commercelayer.ApiClient.handleResponse(ApiClient.java:920) ~[commercelayer-api-client-2.0.1-SNAPSHOT.jar:?]
	at com.osudio.commercelayer.ApiClient.execute(ApiClient.java:841) ~[commercelayer-api-client-2.0.1-SNAPSHOT.jar:?]
	at com.osudio.commercelayer.api.ProductSearchControllerApi.searchWithHttpInfo(ProductSearchControllerApi.java:154) ~[commercelayer-api-client-2.0.1-SNAPSHOT.jar:?]
	at com.osudio.commercelayer.api.ProductSearchControllerApi.search(ProductSearchControllerApi.java:138) ~[commercelayer-api-client-2.0.1-SNAPSHOT.jar:?]
	at com.bsgroup.cms.common.integration.commercetools.changenotification.processors.CapiProductCTSynchronization.search(CapiProductCTSynchronization.java:101) ~[classes/:52056fe_20221003_0621]
	at com.bsgroup.cms.common.integration.commercetools.changenotification.processors.CapiProductCTSynchronization.syncAll(CapiProductCTSynchronization.java:82) ~[classes/:52056fe_20221003_0621]
	at com.bsgroup.cms.common.integration.commercetools.changenotification.CapiProductCTSynchronizationJob.execute(CapiProductCTSynchronizationJob.java:55) ~[classes/:52056fe_20221003_0621]
	at org.hippoecm.repository.quartz.RepositoryJobJob.execute(RepositoryJobJob.java:50) ~[hippo-repository-engine-14.7.7.jar:14.7.7]
	at org.quartz.core.JobRunShell.run(JobRunShell.java:202) ~[quartz-2.3.2.jar:?]
	... 1 more

Hi,

I don’t have any insights for you. If you have a support contract I urge you to contact them.

@jasper.floor Thanks for your input on this.