powered by Jive Software

Openfire Crashing and no longer usable


#1

I have openfire configured on a domain controller for a product on a secure private network. The server has crashed and will not come back up with the following error. I am thinking I will need to reinstall, which isn’t a huge deal as the users are in active directory, but I will lose the group configuration. Any idea how to fix before I do that?

Database setup or configuration error: Please verify your database settings and check the logs/error.log file for detailed errorE messages.

java.lang.IllegalArgumentException: java.sql.SQLException: ConnectionManager.getConnection() failed to obtain a connection after 11r rror starting the server. Please check the log files for more information.
etries. The exception from the last attempt is as follows: java.sql.SQLException: Database lock acquisition failure: lockFile: org.hsqldb.persist.LockFile@7e8a15b2[file =C:\XMPP\Openfire\Openfire\embedded-db\openfire.lck, exists=true, locked=false, valid=false, ] method: checkHeartbeat read: 2018-12-10 16:00:45 heartbeat - read: -8363 ms.
at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:820)
at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:543)
at org.jivesoftware.openfire.XMPPServer.(XMPPServer.java:163)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at java.lang.Class.newInstance(Unknown Source)
at org.jivesoftware.openfire.starter.ServerStarter.start(ServerStarter.java:102)
at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:53)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.exe4j.runtime.LauncherEngine.launch(LauncherEngine.java:81)
at com.exe4j.runtime.WinLauncher.main(WinLauncher.java:94)
at com.install4j.runtime.launcher.WinLauncher.main(WinLauncher.java:25)
Caused by: java.sql.SQLException: ConnectionManager.getConnection() failed to obtain a connection after 11 retries. The exception from the last attempt is as follows: java.sql.SQLException: Database lock acquisition failure: lockFile: org.hsqldb.persist.LockFile@7e8a15b2[file =C:\XMPP\Openfire\Openfire\embedded-db\openfire.lck, exists=true, locked=false, valid=false, ] method: checkHeartbeat read: 2018-12-10 16:00:45 heartbeat - read: -8363 ms.
at org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager.java:152)
at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:810)
… 16 more
Server haltedstrong text


#2

It says there might be a lock file left after the crash, which stops database from being accessed again by Openfire. Stop Openfire ant delete that lck file, then start again.