Navigation

    Kopano
    • Register
    • Login
    • Search
    • Categories
    • Get Official Kopano Support
    • Recent
    Statement regarding the closure of the Kopano community forum and the end of the community edition

    Zarafa: SQL error: Duplicate entry in indexedproperties

    Legacy software
    2
    2
    1370
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • helmut
      helmut last edited by

      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 1 Reply Last reply Reply Quote 0
      • LedZeppe1in
        LedZeppe1in @helmut last edited by

        @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.

        1 Reply Last reply Reply Quote 0
        • First post
          Last post