powered by Jive Software

I upgraded from Openfire 4.0 to 4.1.33 ro 4.1.6


#1

I am receiving this error after updating:

Database setup or configuration error: Please verify your database settings and check the logs/error.log file for detailed error messages.
jError starting the server. Please check the log files for more information
a.
va.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@c69e02e3[file =C:\Program Files (x86)\Openfire\embedded-db\openfire.lck, exists=true, locked=false, valid=false, ] method: checkHeartbeat read: 2018-07-10 11:32:58 heartbeat - read: -7138 ms.
at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:700)
at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:423)
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:105)
at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:56)
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:65)
at com.exe4j.runtime.WinLauncher.main(WinLauncher.java:101)
at com.install4j.runtime.launcher.WinLauncher.main(WinLauncher.java:26)
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@c69e02e3[file =C:\Program Files (x86)\Openfire\embedded-db\openfire.lck, exists=true, locked=false, valid=false, ] method: checkHeartbeat read: 2018-07-10 11:32:58 heartbeat - read: -7138 ms.
at org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager.java:156)
at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:690)
… 16 more
Server halted


#2

New Openfire version installs and runs a service, so you shouldn’t use Launcher to run it anymore. Openfire is already running as a service, you start the launcher and create a conflict when two Openfire processes try to use same database file. When Openfire is running as a service you can access Admin Console by opening a browser and going to http://localhost:9090 or https://localhost:9091


#3

Great! Thanks so much for your help.