0

java.sql.SQLException: Database lock acquisition failure: lockFile: org.hsqldb.persist.LockFile@9c3ca816[file =C:\Users\user\Documents\Mendix\ECommerce-main\deployment\data\database\hsqldb\default\default.lck, exists=true, locked=false, valid=false, ] method: checkHeartbeat read: 2023-11-23 10:04:43 heartbeat - read: -9589 ms.    at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)    at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)    at org.hsqldb.jdbc.JDBCConnection.<init>(Unknown Source)    at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source)    at org.hsqldb.jdbc.JDBCDataSource.getConnection(Unknown Source)    at org.hsqldb.jdbc.JDBCDataSource.getConnection(Unknown Source)    at com.mendix.connectionbus.connections.jdbc.implementations.hsqldb.HsqldbDataStoreConfigurator.shutdown(HsqldbDataStoreConfigurator.scala:113)    at com.mendix.connectionbus.connections.jdbc.ConnectionManager.shutdown(ConnectionManager.scala:101)    at com.mendix.connectionbus.ConnectionBusImpl.$anonfun$shutdown$2(ConnectionBusImpl.scala:325)    at com.mendix.connectionbus.ConnectionBusImpl.$anonfun$shutdown$2$adapted(ConnectionBusImpl.scala:325)    at scala.Option.foreach(Option.scala:437)    at com.mendix.connectionbus.ConnectionBusImpl.shutdown(ConnectionBusImpl.scala:325)    at com.mendix.basis.impl.MxRuntimeImpl.shutDownConnectionBus(MxRuntimeImpl.scala:472)    at com.mendix.basis.impl.MxRuntimeImpl.shutdown(MxRuntimeImpl.scala:368)    at com.mendix.m2ee.appcontainer.AppContainer.$anonfun$shutDown$1(AppContainer.scala:192)    at com.mendix.m2ee.appcontainer.AppContainer.$anonfun$shutDown$1$adapted(AppContainer.scala:186)    at scala.Option.foreach(Option.scala:437)    at com.mendix.m2ee.appcontainer.AppContainer.shutDown(AppContainer.scala:186)    at com.mendix.m2ee.appcontainer.actions.ShutdownAction.execute(ShutdownAction.scala:30)    at com.mendix.m2ee.appcontainer.server.handler.HttpAdminHandlerBase.service(HttpAdminHandlerBase.java:128)    at javax.servlet.http.HttpServlet.service(HttpServlet.java:750)    at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:764)    at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:529)    at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:221)    at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1384)    at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:176)    at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:484)    at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:174)    at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1306)    at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:129)    at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:122)    at org.eclipse.jetty.server.Server.handle(Server.java:563)    at org.eclipse.jetty.server.HttpChannel.lambda$handle$0(HttpChannel.java:505)    at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:762)    at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:497)    at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:282)    at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:314)    at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:100)    at org.eclipse.jetty.io.SelectableChannelEndPoint$1.run(SelectableChannelEndPoint.java:53)    at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.runTask(AdaptiveExecutionStrategy.java:416)    at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.consumeTask(AdaptiveExecutionStrategy.java:385)    at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.tryProduce(AdaptiveExecutionStrategy.java:272)    at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.lambda$new$0(AdaptiveExecutionStrategy.java:140)    at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:411)    at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:969)    at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.doRunJob(QueuedThreadPool.java:1194)    at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1149)    at java.base/java.lang.Thread.run(Thread.java:829) Caused by: org.hsqldb.HsqlException: Database lock acquisition failure: lockFile: org.hsqldb.persist.LockFile@9c3ca816[file =C:\Users\user\Documents\Mendix\ECommerce-main\deployment\data\database\hsqldb\default\default.lck, exists=true, locked=false, valid=false, ] method: checkHeartbeat read: 2023-11-23 10:04:43 heartbeat - read: -9589 ms.    at org.hsqldb.error.Error.error(Unknown Source)    at org.hsqldb.persist.LockFile.newLockFileLock(Unknown Source)    at org.hsqldb.persist.Logger.acquireLock(Unknown Source)    at org.hsqldb.persist.Logger.open(Unknown Source)    at org.hsqldb.Database.reopen(Unknown Source)    at org.hsqldb.Database.open(Unknown Source)    at org.hsqldb.DatabaseManager.getDatabase(Unknown Source)    at org.hsqldb.DatabaseManager.newSession(Unknown Source)    at org.hsqldb.jdbc.JDBCConnection.<init>(Unknown Source)    at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source)    at org.hsqldb.jdbc.JDBCDataSource.getConnection(Unknown Source)    at org.hsqldb.jdbc.JDBCDataSource.getConnection(Unknown Source)    at com.mendix.connectionbus.connections.jdbc.implementations.hsqldb.HsqldbDataStoreConfigurator.shutdown(HsqldbDataStoreConfigurator.scala:113)    at com.mendix.connectionbus.connections.jdbc.ConnectionManager.shutdown(ConnectionManager.scala:101)    at com.mendix.connectionbus.ConnectionBusImpl.$anonfun$shutdown$2(ConnectionBusImpl.scala:325)    at com.mendix.connectionbus.ConnectionBusImpl.$anonfun$shutdown$2$adapted(ConnectionBusImpl.scala:325)    at scala.Option.foreach(Option.scala:437)    at com.mendix.connectionbus.ConnectionBusImpl.shutdown(ConnectionBusImpl.scala:325)    at com.mendix.basis.impl.MxRuntimeImpl.shutDownConnectionBus(MxRuntimeImpl.scala:472)    at com.mendix.basis.impl.MxRuntimeImpl.shutdown(MxRuntimeImpl.scala:368)    at com.mendix.m2ee.appcontainer.AppContainer.$anonfun$shutDown$1(AppContainer.scala:192)    at com.mendix.m2ee.appcontainer.AppContainer.$anonfun$shutDown$1$adapted(AppContainer.scala:186)    at scala.Option.foreach(Option.scala:437)    at com.mendix.m2ee.appcontainer.AppContainer.shutDown(AppContainer.scala:186)    at com.mendix.m2ee.appcontainer.actions.ShutdownAction.execute(ShutdownAction.scala:30)    at com.mendix.m2ee.appcontainer.server.handler.HttpAdminHandlerBase.service(HttpAdminHandlerBase.java:128)    at javax.servlet.http.HttpServlet.service(HttpServlet.java:750)    at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:764)    at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:529)    at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:221)    at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1384)    at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:176)    at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:484)    at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:174)    at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1306)    at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:129)    at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:122)    at org.eclipse.jetty.server.Server.handle(Server.java:563)    at org.eclipse.jetty.server.HttpChannel.lambda$handle$0(HttpChannel.java:505)    at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:762)    at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:497)    at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:282)    at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:314)    at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:100)    at org.eclipse.jetty.io.SelectableChannelEndPoint$1.run(SelectableChannelEndPoint.java:53)    at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.runTask(AdaptiveExecutionStrategy.java:416)    at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.consumeTask(AdaptiveExecutionStrategy.java:385)    at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.tryProduce(AdaptiveExecutionStrategy.java:272)    at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.lambda$new$0(AdaptiveExecutionStrategy.java:140)    at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:411)    at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:969)    at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.doRunJob(QueuedThreadPool.java:1194)    at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1149)    at java.base/java.lang.Thread.run(Thread.java:829) Caused by: org.hsqldb.persist.LockFile$LockHeldExternallyException: lockFile: org.hsqldb.persist.LockFile@9c3ca816[file =C:\Users\user\Documents\Mendix\ECommerce-main\deployment\data\database\hsqldb\default\default.lck, exists=true, locked=false, valid=false, ] method: checkHeartbeat read: 2023-11-23 10:04:43 heartbeat - read: -9589 ms.    at org.hsqldb.persist.LockFile.checkHeartbeat(Unknown Source)    at org.hsqldb.persist.LockFile.pollHeartbeat(Unknown Source)    at org.hsqldb.persist.LockFile.tryLock(Unknown Source)    at org.hsqldb.persist.LockFile.newLockFileLock(Unknown Source)    at org.hsqldb.persist.Logger.acquireLock(Unknown Source)    at org.hsqldb.persist.Logger.open(Unknown Source)    at org.hsqldb.Database.reopen(Unknown Source)    at org.hsqldb.Database.open(Unknown Source)    at org.hsqldb.DatabaseManager.getDatabase(Unknown Source)    at org.hsqldb.DatabaseManager.newSession(Unknown Source)    at org.hsqldb.jdbc.JDBCConnection.<init>(Unknown Source)    at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source)    at org.hsqldb.jdbc.JDBCDataSource.getConnection(Unknown Source)    at org.hsqldb.jdbc.JDBCDataSource.getConnection(Unknown Source)    at com.mendix.connectionbus.connections.jdbc.implementations.hsqldb.HsqldbDataStoreConfigurator.shutdown(HsqldbDataStoreConfigurator.scala:113)    at com.mendix.connectionbus.connections.jdbc.ConnectionManager.shutdown(ConnectionManager.scala:101)    at com.mendix.connectionbus.ConnectionBusImpl.$anonfun$shutdown$2(ConnectionBusImpl.scala:325)    at com.mendix.connectionbus.ConnectionBusImpl.$anonfun$shutdown$2$adapted(ConnectionBusImpl.scala:325)    at scala.Option.foreach(Option.scala:437)    at com.mendix.connectionbus.ConnectionBusImpl.shutdown(ConnectionBusImpl.scala:325)    at com.mendix.basis.impl.MxRuntimeImpl.shutDownConnectionBus(MxRuntimeImpl.scala:472)    at com.mendix.basis.impl.MxRuntimeImpl.shutdown(MxRuntimeImpl.scala:368)    at com.mendix.m2ee.appcontainer.AppContainer.$anonfun$shutDown$1(AppContainer.scala:192)    at com.mendix.m2ee.appcontainer.AppContainer.$anonfun$shutDown$1$adapted(AppContainer.scala:186)    at scala.Option.foreach(Option.scala:437)    at com.mendix.m2ee.appcontainer.AppContainer.shutDown(AppContainer.scala:186)    at com.mendix.m2ee.appcontainer.actions.ShutdownAction.execute(ShutdownAction.scala:30)    at com.mendix.m2ee.appcontainer.server.handler.HttpAdminHandlerBase.service(HttpAdminHandlerBase.java:128)    at javax.servlet.http.HttpServlet.service(HttpServlet.java:750)    at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:764)    at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:529)    at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:221)    at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1384)    at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:176)    at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:484)    at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:174)    at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1306)    at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:129)    at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:122)    at org.eclipse.jetty.server.Server.handle(Server.java:563)    at org.eclipse.jetty.server.HttpChannel.lambda$handle$0(HttpChannel.java:505)    at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:762)    at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:497)    at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:282)    at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:314)    at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:100)    at org.eclipse.jetty.io.SelectableChannelEndPoint$1.run(SelectableChannelEndPoint.java:53)    at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.runTask(AdaptiveExecutionStrategy.java:416)    at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.consumeTask(AdaptiveExecutionStrategy.java:385)    at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.tryProduce(AdaptiveExecutionStrategy.java:272)    at org.eclipse.jetty.util.thread.strategy.AdaptiveExecutionStrategy.lambda$new$0(AdaptiveExecutionStrategy.java:140)    at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:411)    at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:969)    at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.doRunJob(QueuedThreadPool.java:1194)    at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1149)    at java.base/java.lang.Thread.run(Thread.java:829)

asked 2023-11-23

1 answers