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

[Chris via KDE Bugzilla]

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

Chris <crglasoe at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |crglasoe at gmail.com

--- Comment #48 from Chris <crglasoe at gmail.com> ---
(In reply to Paul Eggleton from comment #22)
> 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.

This does work in Kmail5.  Has anyone tried the remove duplicate email option
in the folder?

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