powered by Jive Software

Monitoring plugin fault after online upgrade to version 1.4

Hi!

Recently I made upgrade all used plugins.

Monitoring to 1.4 and get stop archiving due to duplicating of key:

org.jivesoftware.openfire.archive.Conversation - Unique constraint violation: SYS_IDX_78 in statement [INSERT INTO ofConversation(conversationID, room, isExternal, startDate, lastActivity, messageCount) VALUES (?,?,?,?,?,0)]

java.sql.SQLException: Unique constraint violation: SYS_IDX_78 in statement [INSERT INTO ofConversation(conversationID, room, isExternal, startDate, lastActivity, messageCount) VALUES (?,?,?,?,?,0)]

openfile 3.9.1

HSQL Database Engine 1.8.0

Obviously, conversationID calculated wrong. How can I correct this?