Projects tigase _server server-core Issues #465
MS SQL schema, Violation of UNIQUE KEY constraint 'IX_tig_users_sha1_user_id' (#465)
Closed
wojciech.kapcia@tigase.net opened 9 years ago
Due Date
2015-05-21

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

issue 1 of 1
Type
Bug
Priority
Normal
Assignee
RedmineID
3060
Spent time
4h 30m
Issue Votes (0)
Watchers (0)
Reference
tigase/_server/server-core#465
Please wait...
Page is in error, reload to recover