[#GATE-91] Postgres/Other DBs duplicate key error

IM Gateway

Postgres/Other DBs duplicate key error

Created: 10/11/06 08:55 PM Updated: 11/06/06 06:24 PM

Component/s:

Core

Affects Version/s:

1.0 Beta 3a

Fix Version/s:

1.0 Beta 5

Time Tracking:

Not Specified

Support Plan Customer Issue:	No
Resolution Date:	11/06/06 06:24 PM
Acceptance Test - Add?:	No

Description

« Hide

Stack trace is in referring forum entry. Note that I do not know why this is occuring due to all of the groups used by the im gateway plugin (aside from Transports) being non-persistent. It's possible the Transports group create/adjust is causing problems.

All

Comments

Work Log

Change History

Subversion Commits

Sort Order:

Ascending order - Click to sort in descending order

[ Permlink | « Hide ]

Daniel Henninger - 10/22/06 07:03 PM

I'm seeing something similar periodically with MySQL:
java.sql.SQLException: Duplicate entry '31-0' for key 1
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)
at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1125)
at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:677)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1357)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1274)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1259)
at org.jivesoftware.wildfire.roster.RosterItemProvider.insertGroups(RosterItemProvider.java:355)
at org.jivesoftware.wildfire.roster.RosterItemProvider.updateItem(RosterItemProvider.java:156)
at org.jivesoftware.wildfire.roster.Roster.updateRosterItem(Roster.java:394)
at org.jivesoftware.wildfire.gateway.BaseTransport.addOrUpdateRosterItem(BaseTransport.java:850)
at org.jivesoftware.wildfire.gateway.BaseTransport.addOrUpdateRosterItem(BaseTransport.java:903)
at org.jivesoftware.wildfire.gateway.BaseTransport.addOrUpdateRosterItem(BaseTransport.java:917)
at org.jivesoftware.wildfire.gateway.BaseTransport.syncLegacyRoster(BaseTransport.java:1014)
at org.jivesoftware.wildfire.gateway.protocols.yahoo.YahooSession.syncUsers(YahooSession.java:181)
at org.jivesoftware.wildfire.gateway.protocols.yahoo.YahooSession$1.run(YahooSession.java:112)
at org.jivesoftware.wildfire.gateway.protocols.yahoo.YahooSession.logIn(YahooSession.java:95)
at org.jivesoftware.wildfire.gateway.protocols.yahoo.YahooTransport.registrationLoggedIn(YahooTransport.java:87)
at org.jivesoftware.wildfire.gateway.BaseTransport.availableSession(BaseTransport.java:1354)
at org.jivesoftware.wildfire.user.PresenceEventDispatcher.availableSession(PresenceEventDispatcher.java:71)
at org.jivesoftware.wildfire.ClientSession.setPresence(ClientSession.java:671)
at org.jivesoftware.wildfire.handler.PresenceUpdateHandler.process(PresenceUpdateHandler.java:98)
at org.jivesoftware.wildfire.handler.PresenceUpdateHandler.process(PresenceUpdateHandler.java:153)
at org.jivesoftware.wildfire.PresenceRouter.handle(PresenceRouter.java:92)
at org.jivesoftware.wildfire.PresenceRouter.route(PresenceRouter.java:61)
at org.jivesoftware.wildfire.spi.PacketRouterImpl.route(PacketRouterImpl.java:75)
at org.jivesoftware.wildfire.net.SocketReader.processPresence(SocketReader.java:299)
at org.jivesoftware.wildfire.net.ClientSocketReader.processPresence(ClientSocketReader.java:57)
at org.jivesoftware.wildfire.net.SocketReader.process(SocketReader.java:193)
at org.jivesoftware.wildfire.net.BlockingReadingMode.readStream(BlockingReadingMode.java:156)
at org.jivesoftware.wildfire.net.BlockingReadingMode.run(BlockingReadingMode.java:62)
at org.jivesoftware.wildfire.net.SocketReader.run(SocketReader.java:123)
at java.lang.Thread.run(Thread.java:613)

[ Show » ]

Daniel Henninger - 10/22/06 07:03 PM I'm seeing something similar periodically with MySQL: java.sql.SQLException: Duplicate entry '31-0' for key 1 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600) at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1125) at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:677) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1357) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1274) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1259) at org.jivesoftware.wildfire.roster.RosterItemProvider.insertGroups(RosterItemProvider.java:355) at org.jivesoftware.wildfire.roster.RosterItemProvider.updateItem(RosterItemProvider.java:156) at org.jivesoftware.wildfire.roster.Roster.updateRosterItem(Roster.java:394) at org.jivesoftware.wildfire.gateway.BaseTransport.addOrUpdateRosterItem(BaseTransport.java:850) at org.jivesoftware.wildfire.gateway.BaseTransport.addOrUpdateRosterItem(BaseTransport.java:903) at org.jivesoftware.wildfire.gateway.BaseTransport.addOrUpdateRosterItem(BaseTransport.java:917) at org.jivesoftware.wildfire.gateway.BaseTransport.syncLegacyRoster(BaseTransport.java:1014) at org.jivesoftware.wildfire.gateway.protocols.yahoo.YahooSession.syncUsers(YahooSession.java:181) at org.jivesoftware.wildfire.gateway.protocols.yahoo.YahooSession$1.run(YahooSession.java:112) at org.jivesoftware.wildfire.gateway.protocols.yahoo.YahooSession.logIn(YahooSession.java:95) at org.jivesoftware.wildfire.gateway.protocols.yahoo.YahooTransport.registrationLoggedIn(YahooTransport.java:87) at org.jivesoftware.wildfire.gateway.BaseTransport.availableSession(BaseTransport.java:1354) at org.jivesoftware.wildfire.user.PresenceEventDispatcher.availableSession(PresenceEventDispatcher.java:71) at org.jivesoftware.wildfire.ClientSession.setPresence(ClientSession.java:671) at org.jivesoftware.wildfire.handler.PresenceUpdateHandler.process(PresenceUpdateHandler.java:98) at org.jivesoftware.wildfire.handler.PresenceUpdateHandler.process(PresenceUpdateHandler.java:153) at org.jivesoftware.wildfire.PresenceRouter.handle(PresenceRouter.java:92) at org.jivesoftware.wildfire.PresenceRouter.route(PresenceRouter.java:61) at org.jivesoftware.wildfire.spi.PacketRouterImpl.route(PacketRouterImpl.java:75) at org.jivesoftware.wildfire.net.SocketReader.processPresence(SocketReader.java:299) at org.jivesoftware.wildfire.net.ClientSocketReader.processPresence(ClientSocketReader.java:57) at org.jivesoftware.wildfire.net.SocketReader.process(SocketReader.java:193) at org.jivesoftware.wildfire.net.BlockingReadingMode.readStream(BlockingReadingMode.java:156) at org.jivesoftware.wildfire.net.BlockingReadingMode.run(BlockingReadingMode.java:62) at org.jivesoftware.wildfire.net.SocketReader.run(SocketReader.java:123) at java.lang.Thread.run(Thread.java:613)