[Akonadi] [Bug 338658] GMail, Novell Groupwise, other IMAP: "Multiple merge candidates, aborting"

[Paul Eggleton]

https://bugs.kde.org/show_bug.cgi?id=338658

--- Comment #22 from Paul Eggleton <bluelightning at bluelightning.org> ---
I have at least figured out how to fix the database in order to get directories
syncing again using the Akonadi Console. (Disclaimer: this worked for me, may
not work for you, you might lose data if you aren't careful, etc.)

First I searched to find the duplicate keys using the "DB Console" tab with the
following query:

SELECT pimitemtable.*, collectiontable.name FROM pimitemtable
INNER JOIN pimitemtable dup ON pimitemtable.id != dup.id and
pimitemtable.remoteId = dup.remoteId and pimitemtable.collectionId =
dup.collectionId
INNER JOIN collectiontable ON pimitemtable.collectionId = collectiontable.id
ORDER by pimitemtable.remoteId

Then I looked for the items specifically in the folders that I knew were
failing to sync with the "Multiple merge candidates, aborting" error, then used
the Id to track down one of the duplicate items in the "Browser" tab and then
deleted it there from the context menu. (There are still others with duplicate
ids, but I have not deleted those since they don't appear to be causing any
problems.) I then restarted the akonadi server, and then reloaded the folder in
KMail and voila, the folder now synchronises successfully.

-- 
You are receiving this mail because:
You are on the CC list for the bug.