8 Replies Latest reply on Mar 30, 2017 9:16 AM by speedy

    Just upgraded to 4.1.3 but problems now

    Paul Storic

      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

        • Re: Just upgraded to 4.1.3 but problems now
          speedy

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

          • Re: Just upgraded to 4.1.3 but problems now
            speedy

            but are you running it as a service?

              • Re: Just upgraded to 4.1.3 but problems now
                Paul Storic

                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.<init>(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