Zarafa: SQL error: Duplicate entry in indexedproperties

[helmut]

We have the same issue like in this post with our zarafa mail-server on ClearOS 7.7.1:
https://freedomsponsors.org/issue/446/sql-error-duplicate-entry-in-indexedproperties
I follow the instructions, but the error still exists. Sometimes the email-client thunderbird is not able to store mails on imap directories.
I know, it’s a long time ago and support for zarafa is actually discontinued. But maybe the is somebody to give me advice how to fix this without go to kopano now.

Thanks
helmut

Zarafa Product version: 7,2,0,48204

[LedZeppe1in]

@helmut If duplicates are caused by key ‘bin’ then it could a problem with source_key_auto_increment in ‘settings’ table which somehow got zeroed (or decreased significantly). For some unknown reason there is nothing in the code to handle this situation. So you can increase source_key_auto_increment manually or just check if it’s increasing automatically over time (with every error) and wait till it goes away. Took me like 6 hours to figure it out and yes, this problem IS in kopano also.