powered by Jive Software

Just upgraded to 4.1.3 but problems now

Here is the error from the end of the log file, how can I resolve this? Service is running but it’s not working

"

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: 2017-03-29 14:41:07 heartbeat - read: -7629 ms.

at org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager .java:156)
at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:690)
… 16 more

Server halted

are you running the server, and trying to launch the launcher? if so, thats likely your issue. its one or the other.

I am running it on our server.

Actually it seems to be working but one user is getting the “Cannot communicate with the server” error. Are there logs on the windows client I can check to see what’s causing that?

but are you running it as a service?

Yes it’s running as a service. Here is the entire error. User can login (except for one with the can’t connect to server error)

Database setup or configuration errorEr:Pr lease verfio ysr oyaurrti ndgat th eastbaees settrevnir.P gs an lcehadceeskt h hce lose/cekgrrr o.lgto fil hfeo reo gd eftlieal ifloerds o rem reniofr omrrmaitsosneg.e

sa

.

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@c69e02e3[file =C:\Program Files (x86)\Openfire\embedded-db\openfire.lck, exists=true, locked=false, valid=false, ] method: checkHeartbeat read: 2017-03-29 15:01:20 heartbeat - read: -6757 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: 2017-03-29 15:01:20 heartbeat - read: -6757 ms.

at org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager .java:156)

at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:690)

… 16 more

Server halted

that error usually means that that database is locked because of another process. It likely has nothing to do with your single user not being able to sign in. I would review the logs on that persons workstation to see if there is any insight as to way. likely its a network issue of some sort.

Thanks !!

Anyway to clear that locked error on the server?

stop the serivce and make sure openfire is not running…then manually delete openfire.lck