debug.log报出检查点事务日志的错误,neo4j会经常挂掉,以下是错误信息
发布于 5 年前 作者 wan970127 3069 次浏览 来自 问答

2019-12-24 05:45:31.051+0000 ERROR [o.n.b.v.r.ErrorReporter] Client triggered an unexpected error [TransactionStartFailed]: The database has encountered a critical error, and needs to be restarted. Please see database logs for more details., reference 060fb04f-e385-4037-8c6a-e816a3df055e. The database has encountered a critical error, and needs to be restarted. Please see database logs for more details. org.neo4j.graphdb.TransactionFailureException: The database has encountered a critical error, and needs to be restarted. Please see database logs for more details. at org.neo4j.kernel.impl.factory.ClassicCoreSPI.beginTransaction(ClassicCoreSPI.java:198) at org.neo4j.kernel.impl.factory.GraphDatabaseFacade.beginTransactionInternal(GraphDatabaseFacade.java:612) at org.neo4j.kernel.impl.factory.GraphDatabaseFacade.beginTransaction(GraphDatabaseFacade.java:405) at org.neo4j.bolt.v1.runtime.TransactionStateMachineSPI.beginTransaction(TransactionStateMachineSPI.java:103) at org.neo4j.bolt.v1.runtime.TransactionStateMachine$State$1.run(TransactionStateMachine.java:244) at org.neo4j.bolt.v1.runtime.TransactionStateMachine.run(TransactionStateMachine.java:82) at org.neo4j.bolt.v1.runtime.BoltStateMachine$State$2.run(BoltStateMachine.java:408) at org.neo4j.bolt.v1.runtime.BoltStateMachine.run(BoltStateMachine.java:200) at org.neo4j.bolt.v1.messaging.BoltMessageRouter.lambda$onRun$3(BoltMessageRouter.java:93) at org.neo4j.bolt.v1.messaging.BoltMessageRouter$$Lambda$351/769458032.perform(Unknown Source) at org.neo4j.bolt.v1.runtime.concurrent.RunnableBoltWorker.execute(RunnableBoltWorker.java:152) at org.neo4j.bolt.v1.runtime.concurrent.RunnableBoltWorker.run(RunnableBoltWorker.java:104) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) at org.neo4j.helpers.NamedThreadFactory$2.run(NamedThreadFactory.java:109) Caused by: org.neo4j.kernel.api.exceptions.TransactionFailureException: The database has encountered a critical error, and needs to be restarted. Please see database logs for more details. at sun.reflect.GeneratedConstructorAccessor35.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:422) at org.neo4j.kernel.internal.DatabaseHealth.assertHealthy(DatabaseHealth.java:63) at org.neo4j.kernel.impl.api.Kernel.newTransaction(Kernel.java:94) at org.neo4j.kernel.impl.factory.ClassicCoreSPI.beginTransaction(ClassicCoreSPI.java:190) … 17 more Caused by: org.neo4j.kernel.impl.store.UnderlyingStorageException: Error performing check point at org.neo4j.kernel.impl.transaction.log.checkpoint.CheckPointScheduler$1.constructCombinedFailure(CheckPointScheduler.java:100) at org.neo4j.kernel.impl.transaction.log.checkpoint.CheckPointScheduler$1.run(CheckPointScheduler.java:81) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) … 4 more Suppressed: org.neo4j.kernel.impl.store.kvstore.RotationTimeoutException: Failed to rotate logs. Expected version: 25633, actual version: 5, wait timeout (ms): 600077 at org.neo4j.kernel.impl.store.kvstore.RotationState$Rotation.rotate(RotationState.java:79) at org.neo4j.kernel.impl.store.kvstore.RotationState$Rotation.rotate(RotationState.java:52) at org.neo4j.kernel.impl.store.kvstore.AbstractKeyValueStore$RotationTask.rotate(AbstractKeyValueStore.java:309) at org.neo4j.kernel.impl.store.kvstore.AbstractKeyValueStore$RotationTask.rotate(AbstractKeyValueStore.java:286) at org.neo4j.kernel.impl.store.counts.CountsTracker.rotate(CountsTracker.java:127) at org.neo4j.kernel.impl.store.NeoStores.flush(NeoStores.java:246) at org.neo4j.kernel.impl.storageengine.impl.recordstorage.RecordStorageEngine.flushAndForce(RecordStorageEngine.java:468) at org.neo4j.kernel.impl.transaction.log.checkpoint.CheckPointerImpl.doCheckPoint(CheckPointerImpl.java:160) at org.neo4j.kernel.impl.transaction.log.checkpoint.CheckPointerImpl.checkPointIfNeeded(CheckPointerImpl.java:134) at org.neo4j.kernel.impl.transaction.log.checkpoint.CheckPointScheduler$1.run(CheckPointScheduler.java:64) … 8 more Suppressed: org.neo4j.kernel.impl.store.kvstore.RotationTimeoutException: Failed to rotate logs. Expected version: 25633, actual version: 5, wait timeout (ms): 600078 at org.neo4j.kernel.impl.store.kvstore.RotationState$Rotation.rotate(RotationState.java:79) at org.neo4j.kernel.impl.store.kvstore.RotationState$Rotation.rotate(RotationState.java:52) at org.neo4j.kernel.impl.store.kvstore.AbstractKeyValueStore$RotationTask.rotate(AbstractKeyValueStore.java:309) at org.neo4j.kernel.impl.store.kvstore.AbstractKeyValueStore$RotationTask.rotate(AbstractKeyValueStore.java:286) at org.neo4j.kernel.impl.store.counts.CountsTracker.rotate(CountsTracker.java:127) at org.neo4j.kernel.impl.store.NeoStores.flush(NeoStores.java:246) at org.neo4j.kernel.impl.storageengine.impl.recordstorage.RecordStorageEngine.flushAndForce(RecordStorageEngine.java:468) at org.neo4j.kernel.impl.transaction.log.checkpoint.CheckPointerImpl.doCheckPoint(CheckPointerImpl.java:160) at org.neo4j.kernel.impl.transaction.log.checkpoint.CheckPointerImpl.checkPointIfNeeded(CheckPointerImpl.java:134) at org.neo4j.kernel.impl.transaction.log.checkpoint.CheckPointScheduler$1.run(CheckPointScheduler.java:64) … 8 more Suppressed: org.neo4j.kernel.impl.store.kvstore.RotationTimeoutException: Failed to rotate logs. Expected version: 25634, actual version: 5, wait timeout (ms): 600070 at org.neo4j.kernel.impl.store.kvstore.RotationState$Rotation.rotate(RotationState.java:79) at org.neo4j.kernel.impl.store.kvstore.RotationState$Rotation.rotate(RotationState.java:52) at org.neo4j.kernel.impl.store.kvstore.AbstractKeyValueStore$RotationTask.rotate(AbstractKeyValueStore.java:309) at org.neo4j.kernel.impl.store.kvstore.AbstractKeyValueStore$RotationTask.rotate(AbstractKeyValueStore.java:286) at org.neo4j.kernel.impl.store.counts.CountsTracker.rotate(CountsTracker.java:127) at org.neo4j.kernel.impl.store.NeoStores.flush(NeoStores.java:246) at org.neo4j.kernel.impl.storageengine.impl.recordstorage.RecordStorageEngine.flushAndForce(RecordStorageEngine.java:468) at org.neo4j.kernel.impl.transaction.log.checkpoint.CheckPointerImpl.doCheckPoint(CheckPointerImpl.java:160) at org.neo4j.kernel.impl.transaction.log.checkpoint.CheckPointerImpl.checkPointIfNeeded(CheckPointerImpl.java:134) at org.neo4j.kernel.impl.transaction.log.checkpoint.CheckPointScheduler$1.run(CheckPointScheduler.java:64) … 8 more Suppressed: org.neo4j.kernel.impl.store.kvstore.RotationTimeoutException: Failed to rotate logs. Expected version: 25634, actual version: 5, wait timeout (ms): 600093 at org.neo4j.kernel.impl.store.kvstore.RotationState$Rotation.rotate(RotationState.java:79) at org.neo4j.kernel.impl.store.kvstore.RotationState$Rotation.rotate(RotationState.java:52) at org.neo4j.kernel.impl.store.kvstore.AbstractKeyValueStore$RotationTask.rotate(AbstractKeyValueStore.java:309) at org.neo4j.kernel.impl.store.kvstore.AbstractKeyValueStore$RotationTask.rotate(AbstractKeyValueStore.java:286) at org.neo4j.kernel.impl.store.counts.CountsTracker.rotate(CountsTracker.java:127) at org.neo4j.kernel.impl.store.NeoStores.flush(NeoStores.java:246) at org.neo4j.kernel.impl.storageengine.impl.recordstorage.RecordStorageEngine.flushAndForce(RecordStorageEngine.java:468) at org.neo4j.kernel.impl.transaction.log.checkpoint.CheckPointerImpl.doCheckPoint(CheckPointerImpl.java:160) at org.neo4j.kernel.impl.transaction.log.checkpoint.CheckPointerImpl.checkPointIfNeeded(CheckPointerImpl.java:134) at org.neo4j.kernel.impl.transaction.log.checkpoint.CheckPointScheduler$1.run(CheckPointScheduler.java:64) … 8 more Suppressed: org.neo4j.kernel.impl.store.kvstore.RotationTimeoutException: Failed to rotate logs. Expected version: 25634, actual version: 5, wait timeout (ms): 600074 at org.neo4j.kernel.impl.store.kvstore.RotationState$Rotation.rotate(RotationState.java:79) at org.neo4j.kernel.impl.store.kvstore.RotationState$Rotation.rotate(RotationState.java:52) at org.neo4j.kernel.impl.store.kvstore.AbstractKeyValueStore$RotationTask.rotate(AbstractKeyValueStore.java:309) at org.neo4j.kernel.impl.store.kvstore.AbstractKeyValueStore$RotationTask.rotate(AbstractKeyValueStore.java:286) at org.neo4j.kernel.impl.store.counts.CountsTracker.rotate(CountsTracker.java:127) at org.neo4j.kernel.impl.store.NeoStores.flush(NeoStores.java:246) at org.neo4j.kernel.impl.storageengine.impl.recordstorage.RecordStorageEngine.flushAndForce(RecordStorageEngine.java:468) at org.neo4j.kernel.impl.transaction.log.checkpoint.CheckPointerImpl.doCheckPoint(CheckPointerImpl.java:160) at org.neo4j.kernel.impl.transaction.log.checkpoint.CheckPointerImpl.checkPointIfNeeded(CheckPointerImpl.java:134) at org.neo4j.kernel.impl.transaction.log.checkpoint.CheckPointScheduler$1.run(CheckPointScheduler.java:64) … 8 more Suppressed: org.neo4j.kernel.impl.store.kvstore.RotationTimeoutException: Failed to rotate logs. Expected version: 25634, actual version: 5, wait timeout (ms): 600078 at org.neo4j.kernel.impl.store.kvstore.RotationState$Rotation.rotate(RotationState.java:79) at org.neo4j.kernel.impl.store.kvstore.RotationState$Rotation.rotate(RotationState.java:52) at org.neo4j.kernel.impl.store.kvstore.AbstractKeyValueStore$RotationTask.rotate(AbstractKeyValueStore.java:309) at org.neo4j.kernel.impl.store.kvstore.AbstractKeyValueStore$RotationTask.rotate(AbstractKeyValueStore.java:286) at org.neo4j.kernel.impl.store.counts.CountsTracker.rotate(CountsTracker.java:127) at org.neo4j.kernel.impl.store.NeoStores.flush(NeoStores.java:246) at org.neo4j.kernel.impl.storageengine.impl.recordstorage.RecordStorageEngine.flushAndForce(RecordStorageEngine.java:468) at org.neo4j.kernel.impl.transaction.log.checkpoint.CheckPointerImpl.doCheckPoint(CheckPointerImpl.java:160) at org.neo4j.kernel.impl.transaction.log.checkpoint.CheckPointerImpl.checkPointIfNeeded(CheckPointerImpl.java:134) at org.neo4j.kernel.impl.transaction.log.checkpoint.CheckPointScheduler$1.run(CheckPointScheduler.java:64) … 8 more Suppressed: org.neo4j.kernel.impl.store.kvstore.RotationTimeoutException: Failed to rotate logs. Expected version: 25634, actual version: 5, wait timeout (ms): 600061 at org.neo4j.kernel.impl.store.kvstore.RotationState$Rotation.rotate(RotationState.java:79) at org.neo4j.kernel.impl.store.kvstore.RotationState$Rotation.rotate(RotationState.java:52) at org.neo4j.kernel.impl.store.kvstore.AbstractKeyValueStore$RotationTask.rotate(AbstractKeyValueStore.java:309) at org.neo4j.kernel.impl.store.kvstore.AbstractKeyValueStore$RotationTask.rotate(AbstractKeyValueStore.java:286) at org.neo4j.kernel.impl.store.counts.CountsTracker.rotate(CountsTracker.java:127) at org.neo4j.kernel.impl.store.NeoStores.flush(NeoStores.java:246) at org.neo4j.kernel.impl.storageengine.impl.recordstorage.RecordStorageEngine.flushAndForce(RecordStorageEngine.java:468) at org.neo4j.kernel.impl.transaction.log.checkpoint.CheckPointerImpl.doCheckPoint(CheckPointerImpl.java:160) at org.neo4j.kernel.impl.transaction.log.checkpoint.CheckPointerImpl.checkPointIfNeeded(CheckPointerImpl.java:134) at org.neo4j.kernel.impl.transaction.log.checkpoint.CheckPointScheduler$1.run(CheckPointScheduler.java:64) … 8 more Suppressed: org.neo4j.kernel.impl.store.kvstore.RotationTimeoutException: Failed to rotate logs. Expected version: 25634, actual version: 5, wait timeout (ms): 600083 at org.neo4j.kernel.impl.store.kvstore.RotationState$Rotation.rotate(RotationState.java:79) at org.neo4j.kernel.impl.store.kvstore.RotationState$Rotation.rotate(RotationState.java:52) at org.neo4j.kernel.impl.store.kvstore.AbstractKeyValueStore$RotationTask.rotate(AbstractKeyValueStore.java:309) at org.neo4j.kernel.impl.store.kvstore.AbstractKeyValueStore$RotationTask.rotate(AbstractKeyValueStore.java:286) at org.neo4j.kernel.impl.store.counts.CountsTracker.rotate(CountsTracker.java:127) at org.neo4j.kernel.impl.store.NeoStores.flush(NeoStores.java:246) at org.neo4j.kernel.impl.storageengine.impl.recordstorage.RecordStorageEngine.flushAndForce(RecordStorageEngine.java:468) at org.neo4j.kernel.impl.transaction.log.checkpoint.CheckPointerImpl.doCheckPoint(CheckPointerImpl.java:160) at org.neo4j.kernel.impl.transaction.log.checkpoint.CheckPointerImpl.checkPointIfNeeded(CheckPointerImpl.java:134) at org.neo4j.kernel.impl.transaction.log.checkpoint.CheckPointScheduler$1.run(CheckPointScheduler.java:64) … 8 more Suppressed: org.neo4j.kernel.impl.store.kvstore.RotationTimeoutException: Failed to rotate logs. Expected version: 25634, actual version: 5, wait timeout (ms): 600073 at org.neo4j.kernel.impl.store.kvstore.RotationState$Rotation.rotate(RotationState.java:79) at org.neo4j.kernel.impl.store.kvstore.RotationState$Rotation.rotate(RotationState.java:52) at org.neo4j.kernel.impl.store.kvstore.AbstractKeyValueStore$RotationTask.rotate(AbstractKeyValueStore.java:309) at org.neo4j.kernel.impl.store.kvstore.AbstractKeyValueStore$RotationTask.rotate(AbstractKeyValueStore.java:286) at org.neo4j.kernel.impl.store.counts.CountsTracker.rotate(CountsTracker.java:127) at org.neo4j.kernel.impl.store.NeoStores.flush(NeoStores.java:246) at org.neo4j.kernel.impl.storageengine.impl.recordstorage.RecordStorageEngine.flushAndForce(RecordStorageEngine.java:468) at org.neo4j.kernel.impl.transaction.log.checkpoint.CheckPointerImpl.doCheckPoint(CheckPointerImpl.java:160) at org.neo4j.kernel.impl.transaction.log.checkpoint.CheckPointerImpl.checkPointIfNeeded(CheckPointerImpl.java:134) at org.neo4j.kernel.impl.transaction.log.checkpoint.CheckPointScheduler$1.run(CheckPointScheduler.java:64) … 8 more Suppressed: org.neo4j.kernel.impl.store.kvstore.RotationTimeoutException: Failed to rotate logs. Expected version: 25634, actual version: 5, wait timeout (ms): 600058 at org.neo4j.kernel.impl.store.kvstore.RotationState$Rotation.rotate(RotationState.java:79) at org.neo4j.kernel.impl.store.kvstore.RotationState$Rotation.rotate(RotationState.java:52) at org.neo4j.kernel.impl.store.kvstore.AbstractKeyValueStore$RotationTask.rotate(AbstractKeyValueStore.java:309) at org.neo4j.kernel.impl.store.kvstore.AbstractKeyValueStore$RotationTask.rotate(AbstractKeyValueStore.java:286) at org.neo4j.kernel.impl.store.counts.CountsTracker.rotate(CountsTracker.java:127) at org.neo4j.kernel.impl.store.NeoStores.flush(NeoStores.java:246) at org.neo4j.kernel.impl.storageengine.impl.recordstorage.RecordStorageEngine.flushAndForce(RecordStorageEngine.java:468) at org.neo4j.kernel.impl.transaction.log.checkpoint.CheckPointerImpl.doCheckPoint(CheckPointerImpl.java:160) at org.neo4j.kernel.impl.transaction.log.checkpoint.CheckPointerImpl.checkPointIfNeeded(CheckPointerImpl.java:134) at org.neo4j.kernel.impl.transaction.log.checkpoint.CheckPointScheduler$1.run(CheckPointScheduler.java:64) … 8 more

5 回复

求助,有没有解决方案

@goodwater 你好,谢谢你的帮助,这确实是有效的解决方案,我想请教一下这个问题的发生的原因,因为我发现这个问题在换到了3.5的版本之后仍然有发生

@wan970127 抱歉,我也不太清楚。

Neo4j试图执行checkpoint将内存中的更新写入磁盘,但是遇到事务日志rotation timeout error(超过10分钟),即事务日志已满,但是未能创建新的日志文件。可能原因有很多,例如文件句柄超额。需要得到 stacktrace 看看更多错误信息。

回到顶部