duplicate key value violates unique constraint "tig_ma_msgs_owner_id_ts_buddy_id_stanza_hash

duplicate key value violates unique constraint "tig_ma_msgs_owner_id_ts_buddy_id_stanza_hash_index" (#23)

Activities

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.

Type	Bug
Priority	Normal
Assignee	Artur Hefczyc
RedmineID	3548

#22 Closed

PreparedStatements optimization

Issue Votes (0)

Watchers (0)

Reference

tigase/_server/tigase-message-archiving#23