Duplicate entry for key 'jid

Duplicate entry for key 'jid_sha' (#792)

Activities

Tue Topholm opened 8 years ago

Due Date
2017-04-03

We are running a cluster of 3 nodes which uses mysql as db. But sometimes we see Duplicate entry for key 'jid_sha' especially on one of the machines. We are using 7.0.4.

Here is the error:

JDBCMsgRepository.storeMessage()   WARNING:  Problem adding new entry to DB: 
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry 'af658014bd3fd2543fe45d497c5ef4cc61f13e48' for key 'jid_sha'
	at sun.reflect.GeneratedConstructorAccessor99.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
	at com.mysql.jdbc.Util.getInstance(Util.java:381)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1038)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3563)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3495)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2693)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2102)
	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2395)
	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2313)
	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2298)
	at tigase.server.amp.JDBCMsgRepository.addUserJID(JDBCMsgRepository.java:937)
	at tigase.server.amp.JDBCMsgRepository.storeMessage(JDBCMsgRepository.java:706)
	at tigase.xmpp.impl.OfflineMessages.savePacketForOffLineUser(OfflineMessages.java:300)
	at tigase.xmpp.impl.MessageAmp.postProcess(MessageAmp.java:174)
	at tigase.server.xmppsession.SessionManager.processPacket(SessionManager.java:1829)
	at tigase.cluster.SessionManagerClustered.processPacket(SessionManagerClustered.java:252)
	at tigase.cluster.SessionManagerClustered.processPacket(SessionManagerClustered.java:238)
	at tigase.server.AbstractMessageReceiver$QueueListener.run(AbstractMessageReceiver.java:1424)

wojciech.kapcia@tigase.net commented 8 years ago

It's a known issue and it was fixed over a year ago: https://projects.tigase.org/projects/tigase-server/repository/revisions/ee8760a006956f883358bc1da403a89f5e98b85f

Tue Topholm commented 8 years ago

Okay, but we are using 7.0.4, which was released 11 months ago, why is the fix not in that release?

Wojciech Kapcia wrote:

It's a known issue and it was fixed over a year ago: https://projects.tigase.org/projects/tigase-server/repository/revisions/ee8760a006956f883358bc1da403a89f5e98b85f

wojciech.kapcia@tigase.net commented 8 years ago

Tue Topholm wrote:

Okay, but we are using 7.0.4, which was released 11 months ago, why is the fix not in that release?

Version 7.0.4 is a maintenance release of 7.0.x series, which originally was released over 2 years ago (2015-02-23) hence this fix was only included in 7.1.x release.

Artur Hefczyc commented 8 years ago

Bg fixed in new version

Type	Bug
Priority	Normal
Assignee	Tue Topholm
RedmineID	5169
Version	tigase-server-8.0.0
Spent time	1h 15m

Issue Votes (0)

Watchers (0)

Reference

tigase/_server/server-core#792