powered by Jive Software

Openfire 4.2.3 Java Errors

A little while ago I upgraded from Openfire 4.x.x to 4.2.3. Everything seems to work ok, but I have a lot of java errors. Openfire is installed on one of my Windows 2012 servers. We are using the embedded database. I have pasted the errors that show up in the Openfire program window on our server desktop. Any help will be appreciated. As stated earlier, all seems to be working ok…

java.lang.IllegalArgumentException: 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@a090bba9[file =C:\Openfire\embedded-db\openfire.lck, exists=true, locked=false, valid=false, ] method: checkHeartbeat read: 2018-07-17 12:43:40 heartbeat - read: -2611 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@a090bba9[file =C:\Openfire\embedded-db\openfire.lck, exists=true, locked=false, valid=false, ] method: checkHeartbeat read: 2018-07-17 12:43:40 heartbeat - read: -2611 ms.
at org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager.java:152)
at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:810)
… 16 more
Error starting the server. Please check the log files for more information.

I figured it out. I did not realize I no longer needed the launcher as the Openfire service was running.
Problem solved.

Kudos for figuring this out on your own :wink: We have updated the documentation and mentioned this in release blog posts. But who reads manuals? :smiley: