duplicate key value violates unique constraint "tig_ma_msgs_owner_id_ts_buddy_id_stanza_hash_index" (#23)
Closed
Andrzej Wójcik (Tigase) opened 9 years ago
Due Date
2016-02-22

When user is connected to two or more cluster nodes at once then each of cluster nodes try to log message to database. This results in constraint violation on database level and exception is thrown.

While this do not cause any issues as one of nodes properly stores message, it would be good to handle this in better way as this may cause a lot of entries in log with ERROR level.

Andrzej Wójcik (Tigase) commented 9 years ago

I marked this as related to #3543 as this is related to database schema and may require (I suppose it will require) fix on database level, so access to database may need to be changed.

%kobit - I suppose that this task and #3543, #3542 should be done for Tigase XMPP Server 7.1.0, right?

Andrzej Wójcik (Tigase) commented 9 years ago

Done in #3543. Changes are rather severe so new version is now in master branch prepared for 7.2.0-SNAPSHOT, however there is no strict dependency on 7.2.0-SNAPSHOT.

Project version was bumped due to severe changes of repository and DB schema

wojciech.kapcia@tigase.net commented 9 years ago

Given that the problem is hard to replicate I've checked the changes and they should resolve the issue. In a couple of quick attempts I was not able to replicate it.

issue 1 of 1
Type
Bug
Priority
Normal
Assignee
RedmineID
3548
Issue Votes (0)
Watchers (0)
Reference
tigase/_server/tigase-message-archiving#23
Please wait...
Page is in error, reload to recover