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
Rustu Goker
1 answers
0
Have you opened the local database in another tool that may have placed a lock on it?
I believe restarting the computer should free up any locks that may be in place.