Roster loading problem

Openfire Openfire Support
1

I have a Jive 2.2 server and Exodus 0.9.1.0 as clients in windows.

One of the users had the problem today to load her roster. She has an empty roster though all her contacts can see her online.

She tried manually to add the contacts again but the contacts do not receive any notification therefore all her contacts are pending.

I looked at the error log and I found out that indeed there was an error today about roster:

2005.09.06 08:24:36 [org.jivesoftware.messenger.roster.RosterItemProvider.getItems(RosterItemProvid er.java:313)

] Internal server error

java.sql.SQLException: Communication link failure: java.io.EOFException, underlying cause: null

  • BEGIN NESTED EXCEPTION **

java.io.EOFException

STACKTRACE:

java.io.EOFException

at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1394)

at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:1538)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1929)

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

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

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

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

at org.jivesoftware.messenger.roster.RosterItemProvider.getItems(RosterItemProvide r.java:298)

at org.jivesoftware.messenger.roster.Roster.(Roster.java:94)

at org.jivesoftware.messenger.roster.RosterManager.getRoster(RosterManager.java:69 )

at org.jivesoftware.messenger.user.User.getRoster(User.java:243)

at org.jivesoftware.messenger.handler.IQRosterHandler.manageRoster(IQRosterHandler .java:173)

at org.jivesoftware.messenger.handler.IQRosterHandler.handleIQ(IQRosterHandler.jav a:103)

at org.jivesoftware.messenger.handler.IQHandler.process(IQHandler.java:48)

at org.jivesoftware.messenger.IQRouter.handle(IQRouter.java:213)

at org.jivesoftware.messenger.IQRouter.route(IQRouter.java:73)

at org.jivesoftware.messenger.PacketRouter.route(PacketRouter.java:65)

at org.jivesoftware.messenger.net.SocketReader.processIQ(SocketReader.java:258)

at org.jivesoftware.messenger.net.ClientSocketReader.processIQ(ClientSocketReader. java:43)

at org.jivesoftware.messenger.net.SocketReader.readStream(SocketReader.java:230)

at org.jivesoftware.messenger.net.SocketReader.run(SocketReader.java:111)

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

  • END NESTED EXCEPTION **

at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:1713)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1929)

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

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

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

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

at org.jivesoftware.messenger.roster.RosterItemProvider.getItems(RosterItemProvide r.java:298)

at org.jivesoftware.messenger.roster.Roster.(Roster.java:94)

at org.jivesoftware.messenger.roster.RosterManager.getRoster(RosterManager.java:69 )

at org.jivesoftware.messenger.user.User.getRoster(User.java:243)

at org.jivesoftware.messenger.handler.IQRosterHandler.manageRoster(IQRosterHandler .java:173)

at org.jivesoftware.messenger.handler.IQRosterHandler.handleIQ(IQRosterHandler.jav a:103)

at org.jivesoftware.messenger.handler.IQHandler.process(IQHandler.java:48)

at org.jivesoftware.messenger.IQRouter.handle(IQRouter.java:213)

at org.jivesoftware.messenger.IQRouter.route(IQRouter.java:73)

at org.jivesoftware.messenger.PacketRouter.route(PacketRouter.java:65)

at org.jivesoftware.messenger.net.SocketReader.processIQ(SocketReader.java:258)

at org.jivesoftware.messenger.net.ClientSocketReader.processIQ(ClientSocketReader. java:43)

at org.jivesoftware.messenger.net.SocketReader.readStream(SocketReader.java:230)

at org.jivesoftware.messenger.net.SocketReader.run(SocketReader.java:111)

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

I also looked at the database (MySql) and can see in the table jiveroster that she has twice the contacts:

351 hielke angelique@myserver 3 -1 -1 angelique

355 hielke iris@myserver 3 -1 -1 iris

357 hielke janneke@myserver 3 -1 -1 janneke

412 hielke heleen@myserver 3 -1 -1 heleen

414 hielke iris@myserver 0 0 -1 iris

415 hielke angelique@myserver 0 0 -1 angelique

416 hielke janneke@myserver 0 0 -1 janneke

Will it solve the problem if I edit the last 3 items (from 0 to 3)?

thanks

2

Hi Nata,

Looks like you have a couple of problems.

With regards to the errors you’'re seeing, a similiar problem was reported url=http://www.jivesoftware.org/forums/message.jspa?threadID=15458here[/url]. The solution was to shutdown Messenger, look for and kill any stray Java processes and then startup Messenger again.

As for the roster issue, you wouldn’‘t want to change those three records since you’‘d just end up duplicating them. What you’‘ll probably want to do is delete those records, but you need to look to see how angelique, iris, janneke and heleen have hielke’'s status set to in the jiveroster table. As an example, angelique should have a record that looks something like the following:

angelique hielke@myserver 3 -1 -1 hielke

/code

If you’'re working directly with the database be sure to do it while Messenger in not running.

Hope that helps,

Ryan

3

Thanks!!

I have deleted the 0 0 -1 items and now the user can see her roster perfectly.

4

Thanks!!

I have deleted the 0 0 -1 items and now the user can

see her roster perfectly.

Good to hear.

Cheers,

Ryan