Just upgraded to 4.1.3 but problems now

Openfire Openfire Support
1

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

2

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

3

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?

4

but are you running it as a service?

5

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

6

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.

7

Thanks !!

8

Anyway to clear that locked error on the server?

9

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