Retrieval of user data often fails with Violation of UNIQUE KEY constraint 'IX_tig_users_sha1_user_id'. Cannot insert duplicate key in object 'dbo.tig_users'. The duplicate key value is (0x5f7cbb0482e4e50110e38f710ec734d24e209368). error.
2015-05-13 00:36:53.343 [disco Queue Worker 0] ExtendedPrivacyList$1.getDefaultList() WARNING: Can't read default privacy list groups
tigase.db.TigaseDBException: Error getting user data for: user-search_2xdg760001.np-test.xmpp-test.net/privacy/default-list
at tigase.db.jdbc.JDBCRepository.getData(JDBCRepository.java:273)
at nextplane.db.Repository.getData(Repository.java:85)
at nextplane.xmpp.impl.ExtendedPrivacyList$1.getDefaultListName(ExtendedPrivacyList.java:339)
at nextplane.xmpp.impl.ExtendedPrivacyList$1.getDefaultList(ExtendedPrivacyList.java:326)
at nextplane.xmpp.impl.ExtendedPrivacyList.allowed(ExtendedPrivacyList.java:85)
at nextplane.xmpp.impl.ExtendedPrivacyList.filter(ExtendedPrivacyList.java:243)
at tigase.server.xmppsession.SessionManager.addOutPackets(SessionManager.java:984)
at tigase.server.xmppsession.SessionManager$ProcessorWorkerThread.process(SessionManager.java:2461)
at tigase.util.WorkerThread.run(WorkerThread.java:128)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Violation of UNIQUE KEY constraint 'IX_tig_users_sha1_user_id'. Cannot insert duplicate key in object 'dbo.tig_users'. The duplicate key value is (0x5f7cbb0482e4e50110e38f710ec734d24e209368).
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:285)
at tigase.db.jdbc.JDBCRepository.addUserRepo(JDBCRepository.java:956)
at tigase.db.jdbc.JDBCRepository.getUserUID(JDBCRepository.java:1184)
at tigase.db.jdbc.JDBCRepository.getNodeNID(JDBCRepository.java:1162)
at tigase.db.jdbc.JDBCRepository.getData(JDBCRepository.java:239)
at nextplane.db.Repository.getData(Repository.java:85)
at nextplane.xmpp.impl.ExtendedPrivacyList$1.getDefaultListName(ExtendedPrivacyList.java:339)
at nextplane.xmpp.impl.ExtendedPrivacyList$1.getDefaultList(ExtendedPrivacyList.java:326)
at nextplane.xmpp.impl.ExtendedPrivacyList.allowed(ExtendedPrivacyList.java:85)
at nextplane.xmpp.impl.ExtendedPrivacyList.filter(ExtendedPrivacyList.java:243)
at tigase.server.xmppsession.SessionManager.addOutPackets(SessionManager.java:984)
at tigase.server.xmppsession.SessionManager$ProcessorWorkerThread.process(SessionManager.java:2461)
at tigase.util.WorkerThread.run(WorkerThread.java:128)
wojciech.kapcia@tigase.net commented 9 years ago
It was specific issue related to Extended Privacy plugin
Retrieval of user data often fails with
Violation of UNIQUE KEY constraint 'IX_tig_users_sha1_user_id'. Cannot insert duplicate key in object 'dbo.tig_users'. The duplicate key value is (0x5f7cbb0482e4e50110e38f710ec734d24e209368).
error.