We've faced an issue duplicated entries in tig_ma_jids table which caused some strange behaviour. After analysis, it turned that the DDL SQL in MySQL version doesn't create unique constraint on jid column:
This is a known issue of Tigase Message Archiving component and already is fixed in master branch of a repository for version 1.3.0 of Tigase Message Archiving Component which will be released as part of Tigase XMPP Server 7.2.0 release. In this new version, database schema of Tigase Message Archiving Component was changed and improved.
We've faced an issue duplicated entries in tig_ma_jids table which caused some strange behaviour. After analysis, it turned that the DDL SQL in MySQL version doesn't create unique constraint on jid column:
For other database types looks like you add "JIDS_JID as unique.
Here is message archiving plugin version info (extract from MANIFEST.MF):
Implementation-Version: 1.2.0-b122/dded3368
Bnd-LastModified: 1485790200209
Bundle-Version: 1.2.0
Implementation-Build: 122/dded3368 (2017-01-30/15:29:53)