Wildfire DB Suddenly Corrupt - Can''t access system

Openfire Openfire Support
1

Hi All

Hope someone can help with this. Recently set up Wildfire, what a great package, however i had to restart my server the other day, and couldn’'t get back into Wildfire. I think it is a DB problem. Here is my error log: Ps - sorry for the long error log!!!

2006.01.26 12:28:42 [org.jivesoftware.database.ConnectionPool.(XMPPServer.java:134)

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.wildfire.starter.ServerStarter.start(ServerStarter.java:82)

at org.jivesoftware.wildfire.starter.ServerStarter.main(ServerStarter.java:46)

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.lang.NullPointerException

at org.jivesoftware.wildfire.XMPPServer.verifyDataSource(XMPPServer.java:568)

… 16 more

2

Hi,

I assume that you are using the embedded database. It is stored in wildfire.script - a plain text file in the embedded-db directory. I can’'t give you a solution but maybe you can fix it if something is broken. Wildfire must be stopped before accessing this file, so maybe you see some bogus sql entries there, you can remove.

Using trial&error should also work, you may remove some or in worst case all “INSERT INTO” lines but maybe it is easier to use a fresh installation.

Doing a fresh installation after backing up everything, especially the embedded-db directory could be an option, maybe something else and not the database is broken.

LG