5052 ERROR_LOCALDB_UNAVAILABLE

[Donald Sehlako]

Hello guys,

SSPR cannot restart.

Upon startup, we see the following problem

DEBUG, localdb.LocalDBFactory, initializing password.pwm.util.localdb.Derby_LocalDB localDBProvider instance
2021-10-06T06:07:07Z, ERROR, localdb.Derby_LocalDB, unable to open LocalDB, the LocalDB is already opened in a different instance: Another instance of Derby may have already booted the database /home/user/sspr-data/LocalDB/derby-db. (stacktrace follows)
java.sql.SQLException: Failed to start database '/home/user/sspr-data/LocalDB/derby-db' with class loader WebappClassLoader
  context: oldsspr
  delegate: false
----------> Parent Classloader:
java.net.URLClassLoader@31befd9f
, see the next exception for details.
    at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
    at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
    at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source)
    at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknown Source)
    at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)
    at org.apache.derby.jdbc.InternalDriver$1.run(Unknown Source)
    at org.apache.derby.jdbc.InternalDriver$1.run(Unknown Source)
    at java.security.AccessController.doPrivileged(Native Method)
    at org.apache.derby.jdbc.InternalDriver.getNewEmbedConnection(Unknown Source)
    at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
    at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
    at org.apache.derby.jdbc.EmbeddedDriver.connect(Unknown Source)
    at password.pwm.util.localdb.Derby_LocalDB.openConnection(Derby_LocalDB.java:110)
    at password.pwm.util.localdb.AbstractJDBC_LocalDB.init(AbstractJDBC_LocalDB.java:226)
    at password.pwm.util.localdb.LocalDBFactory.initInstance(LocalDBFactory.java:149)
    at password.pwm.util.localdb.LocalDBFactory.getInstance(LocalDBFactory.java:86)
    at password.pwm.PwmApplication$Initializer.initializeLocalDB(PwmApplication.java:664)
    at password.pwm.PwmApplication.initialize(PwmApplication.java:205)
    at password.pwm.PwmApplication.<init>(PwmApplication.java:145)
    at password.pwm.http.ContextManager.initialize(ContextManager.java:190)
    at password.pwm.http.HttpEventManager.contextInitialized(HttpEventManager.java:100)
    at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4811)
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5251)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:147)
    at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:725)
    at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:701)
    at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717)
    at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1092)
    at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1834)
    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)
Caused by: ERROR XJ040: Failed to start database '/home/user/sspr-data/LocalDB/derby-db' with class loader WebappClassLoader
  context: oldsspr
  delegate: false
----------> Parent Classloader:
java.net.URLClassLoader@31befd9f
, see the next exception for details.
    at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
    at org.apache.derby.impl.jdbc.SQLExceptionFactory.wrapArgsForTransportAcrossDRDA(Unknown Source)
    ... 34 more
Caused by: ERROR XSDB6: Another instance of Derby may have already booted the database /home/user/sspr-data/LocalDB/derby-db.
    at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
    at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
    at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.privGetJBMSLockOnDB(Unknown Source)
    at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.run(Unknown Source)
    at java.security.AccessController.doPrivileged(Native Method)
    at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.getJBMSLockOnDB(Unknown Source)
    at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.boot(Unknown Source)
    at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source)
    at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source)
    at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown Source)
    at org.apache.derby.impl.services.monitor.FileMonitor.startModule(Unknown Source)
    at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown Source)
    at org.apache.derby.impl.store.raw.RawStore$6.run(Unknown Source)
    at java.security.AccessController.doPrivileged(Native Method)
    at org.apache.derby.impl.store.raw.RawStore.bootServiceModule(Unknown Source)
    at org.apache.derby.impl.store.raw.RawStore.boot(Unknown Source)
    at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source)
    at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source)
    at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown Source)
    at org.apache.derby.impl.services.monitor.FileMonitor.startModule(Unknown Source)
    at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown Source)
    at org.apache.derby.impl.store.access.RAMAccessManager$5.run(Unknown Source)
    at java.security.AccessController.doPrivileged(Native Method)
    at org.apache.derby.impl.store.access.RAMAccessManager.bootServiceModule(Unknown Source)
    at org.apache.derby.impl.store.access.RAMAccessManager.boot(Unknown Source)
    at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source)
    at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source)
    at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown Source)
    at org.apache.derby.impl.services.monitor.FileMonitor.startModule(Unknown Source)
    at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown Source)
    at org.apache.derby.impl.db.BasicDatabase$5.run(Unknown Source)
    at java.security.AccessController.doPrivileged(Native Method)
    at org.apache.derby.impl.db.BasicDatabase.bootServiceModule(Unknown Source)
    at org.apache.derby.impl.db.BasicDatabase.bootStore(Unknown Source)
    at org.apache.derby.impl.db.BasicDatabase.boot(Unknown Source)
    at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source)
    at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source)
    at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(Unknown Source)
    at org.apache.derby.impl.services.monitor.BaseMonitor.startProviderService(Unknown Source)
    at org.apache.derby.impl.services.monitor.BaseMonitor.findProviderAndStartService(Unknown Source)
    at org.apache.derby.impl.services.monitor.BaseMonitor.startPersistentService(Unknown Source)
    at org.apache.derby.iapi.services.monitor.Monitor.startPersistentService(Unknown Source)
    at org.apache.derby.impl.jdbc.EmbedConnection$4.run(Unknown Source)
    at org.apache.derby.impl.jdbc.EmbedConnection$4.run(Unknown Source)
    at java.security.AccessController.doPrivileged(Native Method)
    at org.apache.derby.impl.jdbc.EmbedConnection.startPersistentService(Unknown Source)
    ... 31 more

java.sql.SQLException: Failed to start database '/home/user/sspr-data/LocalDB/derby-db' with class loader WebappClassLoader
  context: oldsspr
  delegate: false
----------> Parent Classloader:
java.net.URLClassLoader@31befd9f
, see the next exception for details.
    at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
    at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
    at org.apache.derby.impl.jdbc.Util.seeNextException(Unknown Source)
    at org.apache.derby.impl.jdbc.EmbedConnection.bootDatabase(Unknown Source)
    at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)
    at org.apache.derby.jdbc.InternalDriver$1.run(Unknown Source)
    at org.apache.derby.jdbc.InternalDriver$1.run(Unknown Source)
    at java.security.AccessController.doPrivileged(Native Method)
    at org.apache.derby.jdbc.InternalDriver.getNewEmbedConnection(Unknown Source)
    at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
    at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
    at org.apache.derby.jdbc.EmbeddedDriver.connect(Unknown Source)
    at password.pwm.util.localdb.Derby_LocalDB.openConnection(Derby_LocalDB.java:110)
    at password.pwm.util.localdb.AbstractJDBC_LocalDB.init(AbstractJDBC_LocalDB.java:226)
    at password.pwm.util.localdb.LocalDBFactory.initInstance(LocalDBFactory.java:149)
    at password.pwm.util.localdb.LocalDBFactory.getInstance(LocalDBFactory.java:86)
    at password.pwm.PwmApplication$Initializer.initializeLocalDB(PwmApplication.java:664)
    at password.pwm.PwmApplication.initialize(PwmApplication.java:205)
    at password.pwm.PwmApplication.<init>(PwmApplication.java:145)
    at password.pwm.http.ContextManager.initialize(ContextManager.java:190)
    at password.pwm.http.HttpEventManager.contextInitialized(HttpEventManager.java:100)
    at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4811)
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5251)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:147)
    at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:725)
    at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:701)
    at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717)
    at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1092)
    at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1834)
    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)
Caused by: ERROR XJ040: Failed to start database '/home/user/sspr-data/LocalDB/derby-db' with class loader WebappClassLoader
  context: oldsspr
  delegate: false
----------> Parent Classloader:
java.net.URLClassLoader@31befd9f
, see the next exception for details.
    at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
    at org.apache.derby.impl.jdbc.SQLExceptionFactory.wrapArgsForTransportAcrossDRDA(Unknown Source)
    ... 34 more
Caused by: ERROR XSDB6: Another instance of Derby may have already booted the database /home/user/sspr-data/LocalDB/derby-db.
    at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
    at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
    at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.privGetJBMSLockOnDB(Unknown Source)
    at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.run(Unknown Source)
    at java.security.AccessController.doPrivileged(Native Method)
    at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.getJBMSLockOnDB(Unknown Source)
    at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.boot(Unknown Source)
    at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source)
    at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source)
    at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown Source)
    at org.apache.derby.impl.services.monitor.FileMonitor.startModule(Unknown Source)
    at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown Source)
    at org.apache.derby.impl.store.raw.RawStore$6.run(Unknown Source)
    at java.security.AccessController.doPrivileged(Native Method)
    at org.apache.derby.impl.store.raw.RawStore.bootServiceModule(Unknown Source)
    at org.apache.derby.impl.store.raw.RawStore.boot(Unknown Source)
    at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source)
    at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source)
    at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown Source)
    at org.apache.derby.impl.services.monitor.FileMonitor.startModule(Unknown Source)
    at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown Source)
    at org.apache.derby.impl.store.access.RAMAccessManager$5.run(Unknown Source)
    at java.security.AccessController.doPrivileged(Native Method)
    at org.apache.derby.impl.store.access.RAMAccessManager.bootServiceModule(Unknown Source)
    at org.apache.derby.impl.store.access.RAMAccessManager.boot(Unknown Source)
    at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source)
    at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source)
    at org.apache.derby.impl.services.monitor.BaseMonitor.startModule(Unknown Source)
    at org.apache.derby.impl.services.monitor.FileMonitor.startModule(Unknown Source)
    at org.apache.derby.iapi.services.monitor.Monitor.bootServiceModule(Unknown Source)
    at org.apache.derby.impl.db.BasicDatabase$5.run(Unknown Source)
    at java.security.AccessController.doPrivileged(Native Method)
    at org.apache.derby.impl.db.BasicDatabase.bootServiceModule(Unknown Source)
    at org.apache.derby.impl.db.BasicDatabase.bootStore(Unknown Source)
    at org.apache.derby.impl.db.BasicDatabase.boot(Unknown Source)
    at org.apache.derby.impl.services.monitor.BaseMonitor.boot(Unknown Source)
    at org.apache.derby.impl.services.monitor.TopService.bootModule(Unknown Source)
    at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(Unknown Source)
    at org.apache.derby.impl.services.monitor.BaseMonitor.startProviderService(Unknown Source)
    at org.apache.derby.impl.services.monitor.BaseMonitor.findProviderAndStartService(Unknown Source)
    at org.apache.derby.impl.services.monitor.BaseMonitor.startPersistentService(Unknown Source)
    at org.apache.derby.iapi.services.monitor.Monitor.startPersistentService(Unknown Source)
    at org.apache.derby.impl.jdbc.EmbedConnection$4.run(Unknown Source)
    at org.apache.derby.impl.jdbc.EmbedConnection$4.run(Unknown Source)
    at java.security.AccessController.doPrivileged(Native Method)
    at org.apache.derby.impl.jdbc.EmbedConnection.startPersistentService(Unknown Source)
    ... 31 more
2021-10-06T06:07:07Z, ERROR, localdb.LocalDBFactory, error creating new LocalDB instance: password.pwm.util.localdb.LocalDBException:5052 ERROR_LOCALDB_UNAVAILABLE (unable to open LocalDB, the LocalDB is already opened in a different instance: Another instance of Derby may have already booted the database /home/user/sspr-data/LocalDB/derby-db.) (stacktrace follows)
password.pwm.util.localdb.LocalDBException: 5052 ERROR_LOCALDB_UNAVAILABLE (unable to open LocalDB, the LocalDB is already opened in a different instance: Another instance of Derby may have already booted the database /home/user/sspr-data/LocalDB/derby-db.)
    at password.pwm.util.localdb.Derby_LocalDB.openConnection(Derby_LocalDB.java:136)
    at password.pwm.util.localdb.AbstractJDBC_LocalDB.init(AbstractJDBC_LocalDB.java:226)
    at password.pwm.util.localdb.LocalDBFactory.initInstance(LocalDBFactory.java:149)
    at password.pwm.util.localdb.LocalDBFactory.getInstance(LocalDBFactory.java:86)
    at password.pwm.PwmApplication$Initializer.initializeLocalDB(PwmApplication.java:664)
    at password.pwm.PwmApplication.initialize(PwmApplication.java:205)
    at password.pwm.PwmApplication.<init>(PwmApplication.java:145)
    at password.pwm.http.ContextManager.initialize(ContextManager.java:190)
    at password.pwm.http.HttpEventManager.contextInitialized(HttpEventManager.java:100)
    at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4811)
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5251)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:147)
    at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:725)
    at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:701)
    at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717)
    at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1092)
    at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1834)
    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)

password.pwm.util.localdb.LocalDBException: 5052 ERROR_LOCALDB_UNAVAILABLE (unable to open LocalDB, the LocalDB is already opened in a different instance: Another instance of Derby may have already booted the database /home/user/sspr-data/LocalDB/derby-db.)
    at password.pwm.util.localdb.Derby_LocalDB.openConnection(Derby_LocalDB.java:136)
    at password.pwm.util.localdb.AbstractJDBC_LocalDB.init(AbstractJDBC_LocalDB.java:226)
    at password.pwm.util.localdb.LocalDBFactory.initInstance(LocalDBFactory.java:149)
    at password.pwm.util.localdb.LocalDBFactory.getInstance(LocalDBFactory.java:86)
    at password.pwm.PwmApplication$Initializer.initializeLocalDB(PwmApplication.java:664)
    at password.pwm.PwmApplication.initialize(PwmApplication.java:205)
    at password.pwm.PwmApplication.<init>(PwmApplication.java:145)
    at password.pwm.http.ContextManager.initialize(ContextManager.java:190)
    at password.pwm.http.HttpEventManager.contextInitialized(HttpEventManager.java:100)
    at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4811)
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5251)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:147)
    at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:725)
    at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:701)
    at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717)
    at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1092)
    at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1834)
    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)
2021-10-06T06:07:07Z, WARN , pwm.PwmApplication, 5052 ERROR_LOCALDB_UNAVAILABLE (unable to initialize LocalDB: 5052 ERROR_LOCALDB_UNAVAILABLE (error creating new LocalDB instance: password.pwm.util.localdb.LocalDBException:5052 ERROR_LOCALDB_UNAVAILABLE (unable to open LocalDB, the LocalDB is already opened in a different instance: Another instance of Derby may have already booted the database /home/user/sspr-data/LocalDB/derby-db.)))
2021-10-06T06:07:07Z, FATAL, pwm.PwmApplication, 5052 ERROR_LOCALDB_UNAVAILABLE (unable to initialize LocalDB: 5052 ERROR_LOCALDB_UNAVAILABLE (error creating new LocalDB instance: password.pwm.util.localdb.LocalDBException:5052 ERROR_LOCALDB_UNAVAILABLE (unable to open LocalDB, the LocalDB is already opened in a different instance: Another instance of Derby may have already booted the database /home/user/sspr-data/LocalDB/derby-db.)))

Any idea on how to fix this issue??

Regards

[Jason Rivard]

Looks like you have a second context named 'oldsspr' trying to run a localdb instance that is already running.   I'm guessing you renamed an old instance of pwm/sspr in a tomcat/webapps folder that has the same applicationPath folder.  Try removing/moving the webapps/oldsspr folder.

[Donald Sehlako]

Hi

Thanks for replying.

I moved the oldsspr folder and now i'm not seeing any error on the logs. However for some reason I cannot access the portal.  When i type the url. i just get connection has timed out.

[Donald Sehlako]

Thanks for your assistant i managed to fix it . it tends out it was a permission issue: