Exception on startup in 3.0.1

Openfire Openfire Support
1

Hello all,

My 3.0.1 install throws this exception on startup:

2006.08.25 14:51:57 org.jivesoftware.wildfire.XMPPServer.startModules(XMPPServer.java:511) Internal server error

java.lang.NumberFormatException: For input string: “”

at java.lang.NumberFormatException.forInputString(Unknown Source)

at java.lang.Long.parseLong(Unknown Source)

at java.lang.Long.parseLong(Unknown Source)

at org.jivesoftware.wildfire.muc.spi.MUCPersistenceManager.loadRoomsFromDB(MUCPers istenceManager.java:436)

at org.jivesoftware.wildfire.muc.spi.MultiUserChatServerImpl.start(MultiUserChatSe rverImpl.java:816)

at org.jivesoftware.wildfire.XMPPServer.startModules(XMPPServer.java:504)

at org.jivesoftware.wildfire.XMPPServer.start(XMPPServer.java:374)

at org.jivesoftware.wildfire.XMPPServer.<init>(XMPPServer.java:145)

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:88)

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

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.install4j.runtime.Launcher.main(Unknown Source)

Any advice on how to address this and (hopefully) make it go away?

Thanks,

Andrew

2

Hi,

use sql and look in your database for the mucRoom table and the lockedDate value. It should be numeric and not null (as defined in the table definitions) so I wonder if you find something ugly there.

Which database are you using?

LG

3

it2000 wrote:

Hi,

use sql and look in your database for the mucRoom table and the lockedDate value. It should be numeric and not null (as defined in the table definitions) so I wonder if you find something ugly there.

There’'s only one record in mucRoom, and its lockedDate value is . Did I have a database upgrade go awry somewhere along the line?

Which database are you using?

MySQL 4.1.20, but I started on 3.something.

Thanks,

Andrew

4

Hi,

I don’'t know about MySQL but can you check there whether null is allowed or not? It should help to either delete the room or set this value to a random, positive integer value, eg 0 or 1156717660 (the current unix “date +%s”).

It seems that this column was added early (in upgrade/1/wildfire_mysql.sql) to Wildfire and always a “NOT NULL” column, so I wonder how this can happen or if this is a MySQL “feature”.

LG

5

The record was created/modified in April. I haven’‘t officially deployed yet, so I removed it. Thanks for the tip. I’‘ll leave the thread open until I determine whether it’'s fixed.