Not Able to Start OpenFire

Openfire Openfire Support
1

Hello,

Running latest version of OpenFire on a Windows 2003 box using the embedded db … the client’s server was locked when they arrived this morning, so they did a forced shutdown / restart … after the restart OpenFire fails to start with the following error:

2010.03.05 11:11:42 [org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:457)
]
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: File input/output error: java.io.IOException: org.hsqldb.HsqlException: Unexpected token:
at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:710)
at org.jivesoftware.openfire.XMPPServer.start(XMPPServer.java:427)
at org.jivesoftware.openfire.XMPPServer.(XMPPServer.java:161)
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.newInstance0(Unknown Source)
at java.lang.Class.newInstance(Unknown Source)
at org.jivesoftware.openfire.starter.ServerStarter.start(ServerStarter.java:106)
at org.jivesoftware.openfire.starter.ServerStarter.main(ServerStarter.java:51)
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(Unknown Source)
at com.exe4j.runtime.WinLauncher.main(Unknown Source)
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: File input/output error: java.io.IOException: org.hsqldb.HsqlException: Unexpected token:
at org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager .java:124)
at org.jivesoftware.openfire.XMPPServer.verifyDataSource(XMPPServer.java:698)
… 16 more

Any assistance would be appreciated.

Thank you,

DevotedDad

2

Hi,

make a backup/copy of the embedded-db directory. Maybe your database was damaged. You could try to use the HSQLDB viewer to access the database, see http://www.igniterealtime.org/community/docs/DOC-1540.

If this fails then you may try to delete the openfire.log file - then the startup should succeed. Anyhow all changes since the last startup or checkpoint are lost. Stop the viewer and restore the openfire.log file. Use an editor and look for broken lines in it. Fix them and start the viewer again, it should start fine now and -recreate the “openfire.script” which contains now all changes. With this openfire.script file and no openfire.log file Openfire should startup fine.

You may also want to review the hsqldb.log_size value in openfire.properties, I did set it to 20 (20 MB) to make sure that checkpoints occur more often.

LG