Wildfire server locks up

I have been having problems with my Wildfire installation. I posted about this a couple of months ago and was asked to upgrade my mysql db to the latest which I did - I’'m now running 5.0.21. I also moved the database to the same server as the Wildire install. But now the problems have returned. All will work well for a few days, sometimes less, and then users will not be able to login. Exodus says password wrong or user already logged in. The database seems to be fine, I have logged into it via several tools and looked around in the Wildfire tables with no trouble. Here are the last few entries from my error log. I am using LDAP btw. Any ideas would be greatly appreciated.

2006.07.27 08:31:01 [org.jivesoftware.wildfire.privacy.PrivacyListProvider.loadDefaultPrivacyList(P rivacyListProvider.java:168)

] Error loading default privacy list of username: myj

com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:

  • BEGIN NESTED EXCEPTION **

java.net.SocketException

MESSAGE: Software caused connection abort: socket write error

STACKTRACE:

java.net.SocketException: Software caused connection abort: socket write error

at java.net.SocketOutputStream.socketWrite0(Native Method)

at java.net.SocketOutputStream.socketWrite(Unknown Source)

at java.net.SocketOutputStream.write(Unknown Source)

at java.io.BufferedOutputStream.flushBuffer(Unknown Source)

at java.io.BufferedOutputStream.flush(Unknown Source)

at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2692)

at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2621)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1552)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)

at com.mysql.jdbc.Connection.execSQL(Connection.java:2994)

at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936)

at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1030)

at org.jivesoftware.wildfire.privacy.PrivacyListProvider.loadDefaultPrivacyList(Pr ivacyListProvider.java:159)

at org.jivesoftware.wildfire.privacy.PrivacyListManager.getDefaultPrivacyList(Priv acyListManager.java:106)

at org.jivesoftware.wildfire.roster.Roster.broadcastPresence(Roster.java:521)

at org.jivesoftware.wildfire.handler.PresenceUpdateHandler.broadcastUpdate(Presenc eUpdateHandler.java:258)

at org.jivesoftware.wildfire.handler.PresenceUpdateHandler.process(PresenceUpdateH andler.java:96)

at org.jivesoftware.wildfire.handler.PresenceUpdateHandler.process(PresenceUpdateH andler.java:153)

at org.jivesoftware.wildfire.PresenceRouter.handle(PresenceRouter.java:92)

at org.jivesoftware.wildfire.PresenceRouter.route(PresenceRouter.java:61)

at org.jivesoftware.wildfire.PacketRouter.route(PacketRouter.java:73)

at org.jivesoftware.wildfire.net.SocketReader.processPresence(SocketReader.java:44 5)

at org.jivesoftware.wildfire.net.ClientSocketReader.processPresence(ClientSocketRe ader.java:56)

at org.jivesoftware.wildfire.net.SocketReader.readStream(SocketReader.java:242)

at org.jivesoftware.wildfire.net.SocketReader.run(SocketReader.java:119)

at java.lang.Thread.run(Unknown Source)

  • END NESTED EXCEPTION **

Last packet sent to the server was 15 ms ago.

at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2710)

at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2621)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1552)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)

at com.mysql.jdbc.Connection.execSQL(Connection.java:2994)

at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936)

at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1030)

at org.jivesoftware.wildfire.privacy.PrivacyListProvider.loadDefaultPrivacyList(Pr ivacyListProvider.java:159)

at org.jivesoftware.wildfire.privacy.PrivacyListManager.getDefaultPrivacyList(Priv acyListManager.java:106)

at org.jivesoftware.wildfire.roster.Roster.broadcastPresence(Roster.java:521)

at org.jivesoftware.wildfire.handler.PresenceUpdateHandler.broadcastUpdate(Presenc eUpdateHandler.java:258)

at org.jivesoftware.wildfire.handler.PresenceUpdateHandler.process(PresenceUpdateH andler.java:96)

at org.jivesoftware.wildfire.handler.PresenceUpdateHandler.process(PresenceUpdateH andler.java:153)

at org.jivesoftware.wildfire.PresenceRouter.handle(PresenceRouter.java:92)

at org.jivesoftware.wildfire.PresenceRouter.route(PresenceRouter.java:61)

at org.jivesoftware.wildfire.PacketRouter.route(PacketRouter.java:73)

at org.jivesoftware.wildfire.net.SocketReader.processPresence(SocketReader.java:44 5)

at org.jivesoftware.wildfire.net.ClientSocketReader.processPresence(ClientSocketRe ader.java:56)

at org.jivesoftware.wildfire.net.SocketReader.readStream(SocketReader.java:242)

at org.jivesoftware.wildfire.net.SocketReader.run(SocketReader.java:119)

at java.lang.Thread.run(Unknown Source)

Message was edited by: zepzep

If more information is needed please let me know.

thanks

Hi,

maybe the steps described here http://www.websina.com/bugzero/faq/exception-mysql-timeout.html help. I don’‘t use mysql so I can’'t tell.

LG

Thanks for the reply IT2000. I added the autoReconnect parameter to the connection string. Not sure of a good way to test this other than wait. I did restart mySql a couple of times while connected and no problems. I’'ll let you know.

Thanks again for the response.

BTW, IT2000, what db do you prefer to use with Wildfire?

Message was edited by: zepzep

Hi,

for my small test server it is the embedded one and for every thing else Oracle as I know it best. It should be anyhow independant which database one use as Wildfire does not use database specific options.

Some databases have limitations for index columns or the size of combined constraints I did not see with Oracle.

Oracle does also offer a free version called OracleXE (Wildfire runs fine with it) one could use but it uses a lot of disc space for installation (350 MB) and for the system tablespace (500 MB) so you may not really want to install it unless you know what you are doing.

LG