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

[Christoph Feck]

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

Christoph Feck  changed:

   What|Removed |Added

 Status|REOPENED|RESOLVED
 Resolution|--- |FIXED

--- Comment #138 from Christoph Feck  ---
David, commit from comment 132 was released with KDEPIM version 5.12.0. The fix
is not in older versions, such as version 5.7.3.

Closing according to comment 135; no new reports appeared for recent versions.

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Christoph Feck]

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

Christoph Feck  changed:

   What|Removed |Added

   Version Fixed In|5.4.1   |5.12.0

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[davidblunkett]

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

--- Comment #137 from davidblunkett  ---
It's still here - just had this on v 5.7.3

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Raúl]

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

Raúl  changed:

   What|Removed |Added

 CC||rasas...@gmail.com

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Aron Heinecke]

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

Aron Heinecke  changed:

   What|Removed |Added

 CC||aron.heine...@t-online.de

--- Comment #136 from Aron Heinecke  ---
For anyone stepping by (probably on KUbuntu 18.04)

https://docs.kde.org/trunk5/en/pim/kmail2/clean-start-after-a-failed-migration.html
- Kmail->Tools->Impoexrt/Export => Export backup
- close kmail
- akonadictl stop
- rm -rf ~/.local/share/akonadi ~/.config/akonadi
- akonadictl start
- imported data*

problems:
- * you can't import filters & account etc at once
  you have to first add all email accounts back, then import your data
partially
- mailfilters file in backup is empty, dialogs question for unknown identities
& folders as import is done before syncing imap accounts -> non-existing
folders
- if you end up with tons of empty Identities, that take 100% CPU to remove and
re-appear on kmail restart, edit ~/.config/emailidentities by hand
  my regex for this is \[Identity #\d+\]\nDefault Domain=ah\-laptop\nDisable
Fcc=false\nIdentity=Unnamed\nImage Location=\nInline Signature=\nSignature
Enabled=false\nuoid=\d+\n in Kate

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Søren Holm]

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

--- Comment #135 from Søren Holm  ---
I have had no problems for the last 3 months - so the recovery method seems to
work for me!

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Sandro Knauß]

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

--- Comment #134 from Sandro Knauß  ---
Git commit 8332cf8a5aa39df6fb665cdbff1a48286d5698f5 by Sandro Knauß, on behalf
of Daniel Vrátil.
Committed on 30/08/2019 at 08:48.
Pushed by knauss into branch 'Applications/18.08'.

Automatic recovery from Multiple Merge Candidates error

Summary:
Introduce a recovery codepath when Multiple Merge Candidates error
occurs during Item merging. Since clients generally do not use
merging, this really only happens during ItemSync. In such case we
quitely delete all the conflicting items from the database and reschedule
the collection sync. The next sync should then succeed and bring the
collection into a consistent state.

Note that this does not fix the Multiple Merge Candidates bug - it can
still happen (and we still don't know how), but Akonadi should now be
able to recover from it automatically without user intervention, thus
making this issue less of a PITA.

Test Plan: Successfuly auto-recovered a broken collection on my setup.

Reviewers: #kde_pim, dfaure

Reviewed By: dfaure

Subscribers: vkrause, dfaure, ngraham, asturmlechner, kde-pim

Tags: #kde_pim

Differential Revision: https://phabricator.kde.org/D21455

(cherry picked from commit 8f230d7d7f8a4e2b97273585374a68902b5ef6cf)

M  +3-3autotests/server/fakedatastore.cpp
M  +1-1autotests/server/fakedatastore.h
M  +67   -5src/server/handler/akappend.cpp
M  +4-0src/server/handler/akappend.h
M  +18   -16   src/server/storage/datastore.cpp
M  +3-1src/server/storage/datastore.h

https://commits.kde.org/akonadi/8332cf8a5aa39df6fb665cdbff1a48286d5698f5

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Søren Holm]

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

--- Comment #133 from Søren Holm  ---
Great work Daniel. I switched from kmail to thunderbird some months ago and I
hate it. I look forward to this automatic repair getting into my distribution
:)

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Daniel Vrátil]

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

--- Comment #132 from Daniel Vrátil  ---
Git commit 8f230d7d7f8a4e2b97273585374a68902b5ef6cf by Daniel Vrátil.
Committed on 31/05/2019 at 11:21.
Pushed by dvratil into branch 'master'.

Automatic recovery from Multiple Merge Candidates error

Summary:
Introduce a recovery codepath when Multiple Merge Candidates error
occurs during Item merging. Since clients generally do not use
merging, this really only happens during ItemSync. In such case we
quitely delete all the conflicting items from the database and reschedule
the collection sync. The next sync should then succeed and bring the
collection into a consistent state.

Note that this does not fix the Multiple Merge Candidates bug - it can
still happen (and we still don't know how), but Akonadi should now be
able to recover from it automatically without user intervention, thus
making this issue less of a PITA.

Test Plan: Successfuly auto-recovered a broken collection on my setup.

Reviewers: #kde_pim, dfaure

Reviewed By: dfaure

Subscribers: vkrause, dfaure, ngraham, asturmlechner, kde-pim

Tags: #kde_pim

Differential Revision: https://phabricator.kde.org/D21455

M  +3-3autotests/server/fakedatastore.cpp
M  +1-1autotests/server/fakedatastore.h
M  +65   -4src/server/handler/itemcreatehandler.cpp
M  +4-0src/server/handler/itemcreatehandler.h
M  +18   -16   src/server/storage/datastore.cpp
M  +3-1src/server/storage/datastore.h

https://commits.kde.org/akonadi/8f230d7d7f8a4e2b97273585374a68902b5ef6cf

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[davidblunkett]

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

--- Comment #131 from davidblunkett  ---
Could someone just add a watchdog timer to it so it just restarts if it gets
stuck? I've tried scripting an akonadictl function to do this but akonadictl
insists on spamming up the desktop with irrelevant error messages.

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Rafael Kitover]

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

--- Comment #130 from Rafael Kitover  ---
I switched to Geary, it's beautiful and modern and works perfectly with gmail.
It's GTK but it works perfectly in KDE :D

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Søren Holm]

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

--- Comment #129 from Søren Holm  ---
I don't think that *anyone* knows what the problem is. This "mail in
database"-system should never have been done in the first place. I still use
kmail/kontact but tt has been functioning suboptimal all the years.

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[davidblunkett]

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

--- Comment #128 from davidblunkett  ---
Its back - this went away for a few months but its back and its so annoying -
akonadi restarts 5 times today - akonadi just hangs.

anyone got a simple way to restart the imap part I can us in a script? it would
be so helpful.

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Kevin Funk]

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

Kevin Funk  changed:

   What|Removed |Added

 CC||kf...@kde.org

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Christian Boltz]

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

Christian Boltz  changed:

   What|Removed |Added

 CC||kde-b...@cboltz.de

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Matthias Kretz]

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

--- Comment #127 from Matthias Kretz  ---
The fact that I can have an inconsistent state stored in my Akonadi DB is
telling. Apparently, while clients interact with Akonadi, the DB goes through
inconsistent states. Those appear to be open to races, and unfortunate
interrupts (crash, system hang, power loss).

What I'd do (and I'm guessing from a far away distance in the hopes it helps
inspire a real fix, hoping not to step on any toes):

1. Update the DB schema to enforce consistent state. In particular all foreign
keys need to be defined so that it's impossible to DELETE FROM parttable while
something in pimitemtable still holds a key to it.

2. Presumably this will break clients which rely on the DB to allow
inconsistent intermediate states. DB updates therefore need to be fixed to
atomically go from one consistent state to the next. E.g. use DELETE together
with INNER JOIN.

3. Races like "unread -> read -> unread" need to be guarded against via
compare-exchange atomic operations using some modification counter. E.g.
mailcheck create id=X, state=unread
kmail read id=X, state=unread
kmail write state=read WHERE id=X
mailcheck update id=X, state=unread (why would this happen anyway, can the IMAP
server indicate some update of metadata?)

If we add a version the UPDATE could be predicated on the version column still
storing the same value as when it was SELECTED before. E.g. the mail client
does
`UPDATE foo SET state=read WHERE id=X AND version=1` instead of `UPDATE foo SET
state=read WHERE id=X`. I actually expect Akonadi already has such a facility
and Allans guess is incorrect.

I have another guess from looking at my logs. I have lots of:

org.kde.pim.akonadiserver:   DB error:  "Lock wait timeout exceeded; try
restarting transaction"
org.kde.pim.akonadiserver:   Error text: "Lock wait timeout exceeded; try
restarting transaction QMYSQL3: Unable to execute statement"

I.e. KMail updates the UI to read state, tries to reflect the state change with
Akonadi, but the DB is locked up. The UPDATE fails, and the KMail UI reverts to
the state stored in Akonadi.

These locks might also be the reason why inconsistent entries in tables remain.
A first DELETE goes through, the second (to make it consistent again) times
out.

I have no clue where the locks come from though. One data point: After my
DELETE FROM statement above I've not seen a single DB error message about lock
timeouts again. Before I had lots.

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Boudewijn Rempt]

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

--- Comment #126 from Boudewijn Rempt  ---
That sounds very likely -- I see the read-unread flip all the time as well.

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Allan Sandfeld]

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

--- Comment #125 from Allan Sandfeld  ---
Btw. I believe the underlying cause is the same that causes emails you are
currently reading to be marked unread again while you are reading it. A sync is
often started in parallel with other actions, so for instance you click on a
folder it starts syncing, and you are reading an email and it is marked read.
You mark it read, but the sync then marks it unread (race condition). 

The same can happen when moving emails, it might be moved, only to be recreated
by the parallel sync, and then moved again, causing two exact copies to exist
in the target folder.

The transactional atomicy of Akonadi is somewhat questionable with several jobs
that consists of multiple database transactions, or is combined with syncing
remote servers.

I tried looking at the move job, but it is pretty messy.

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Allan Sandfeld]

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

--- Comment #124 from Allan Sandfeld  ---
(In reply to Matthias Kretz from comment #123)
> (In reply to Allan Sandfeld from comment #122)
> > With my patch in place the duplicates can be removed by simply calling
> > "remove duplicates" from KMail.
> 
> "Folder -> Remove Duplicates"? If that removes stales in the pimitemtable
> it's somewhat misleadingly named. I was expecting it to search for copies of
> the same mail (i.e. different local & remote ID but equal payload data).

It is not what it is supposed to do, but those exact copies of a single remote
entry also match as if they are just normal copies of the same email.

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Matthias Kretz]

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

--- Comment #123 from Matthias Kretz  ---
(In reply to Allan Sandfeld from comment #122)
> With my patch in place the duplicates can be removed by simply calling
> "remove duplicates" from KMail.

"Folder -> Remove Duplicates"? If that removes stales in the pimitemtable it's
somewhat misleadingly named. I was expecting it to search for copies of the
same mail (i.e. different local & remote ID but equal payload data).

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Allan Sandfeld]

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

--- Comment #122 from Allan Sandfeld  ---
With my patch in place the duplicates can be removed by simply calling "remove
duplicates" from KMail.

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Matthias Kretz]

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

Matthias Kretz  changed:

   What|Removed |Added

 CC||kr...@kde.org

--- Comment #121 from Matthias Kretz  ---
I'm fed up with wiping my Akonadi data every other month so I'm trying to once
again to understand the cause or find a workaround.

Anyway, I was following the SQL hints on debugging the state of my Akonadi data
and found three instances of duplicated (well, rather "multiplicated")
pimitemtable.remoteIds, on the order of hundreds of different pimitemtable.ids.
I then tried to find the corresponding data in parttable via INNER JOIN
parttable ON pimitemtable.id = parttable.pimItemId. Interestingly enough
there's a single pimitemtable.id per pimitemtable.remoteId left (with three
different parttable.id per pimitemtable.id, which seems to be correct for
normal entries). So it seems there are stale entries in pimitemtable. The query

SELECT pimitemtable.*, collectiontable.name FROM pimitemtable
INNER JOIN collectiontable ON pimitemtable.collectionId = collectiontable.id
LEFT JOIN parttable ON pimitemtable.id = parttable.pimItemId
WHERE parttable.id IS NULL

lists the same remoteIds that the query looking for dups found, minus the ones
that have a match in parttable. Useful information: there are no additional
stale entries in pimitemtable than the dups.

Next step, I tried to remove the stale entries in pimitemtable with the
following query:

DELETE pimitemtable FROM pimitemtable
LEFT JOIN parttable ON pimitemtable.id = parttable.pimItemId
WHERE parttable.id IS NULL

However, the query hangs akonadiconsole for ~1 minute and then returns "Lock
wait timeout exceeded; try restarting transaction QMYSQL: Unable to execute
query". An `akonadictl restart` in this case did the trick and the query then
got through. All dups gone. In any case the hangs on reading mails in KMail
that I experienced since yesterday are gone. Let's see whether it helps.

Maybe the DELETE query is a useful addition to `akonadictl fsck` until the root
cause can be fixed?

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Søren Holm]

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

Søren Holm  changed:

   What|Removed |Added

 CC||s...@sgh.dk

--- Comment #120 from Søren Holm  ---
This still happens in KDE 5.54 every one og two months. The only real solution
is to recreate the mail account. I use dovecot as imap server.

While this is still a problem, could'nt you a a functionality that just
recreates the account. Just so we are not forced to enter the credentials and
setup folders and such?

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Allan Sandfeld]

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

--- Comment #119 from Allan Sandfeld  ---
I pushed my patch for review. One side effect I have noticed though, is that
affected folders ends up being redownloaded frequently as the number of
messages doesn't match upstream, but the duplicates are not deleted during the
sync, so it happens again and again. That should probably be fixed, at least a
full sync from remote should get rid of the duplicate.

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Andreas K . Huettel]

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

Andreas K. Huettel  changed:

   What|Removed |Added

 CC|dilfri...@gentoo.org|

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[m . eik michalke]

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

m.eik michalke  changed:

   What|Removed |Added

 CC||m...@reaktanz.de

--- Comment #118 from m.eik michalke  ---
i too am affected by this. i have to restart akonadi at least once a day. right
now one of the configured IMAP resources hangs with a subfolder being fetched
at 116% (guess it would also confuse me if i tried to fetch more than there
is).

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Boudewijn Rempt]

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

--- Comment #117 from Boudewijn Rempt  ---
Well, that's important too. I mean... Releasing a mail client that without any
message to the user just stops working is a bit problematic. Better keep it
working, while the underlying bug gets fixed.

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Christoph]

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

Christoph  changed:

   What|Removed |Added

 CC|ilove...@mojo.cc|

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Allan Sandfeld]

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

--- Comment #115 from Allan Sandfeld  ---
I think it is a safe and it works, but it doesn't solve the underlying issue,
it just makes kmail keep working when the data is wrong.

--- Comment #116 from Allan Sandfeld  ---
I think it is a safe and it works, but it doesn't solve the underlying issue,
it just makes kmail keep working when the data is wrong.

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Allan Sandfeld]

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

--- Comment #115 from Allan Sandfeld  ---
I think it is a safe and it works, but it doesn't solve the underlying issue,
it just makes kmail keep working when the data is wrong.

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Boudewijn Rempt]

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

--- Comment #114 from Boudewijn Rempt  ---
I'm not building akonadi myself, so I cannot test the patch, but if you've been
using it for months... It probably should be good, shouldn't it?

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Allan Sandfeld]

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

--- Comment #113 from Allan Sandfeld  ---
Created attachment 115298
  --> https://bugs.kde.org/attachment.cgi?id=115298=edit
experimental patch

I have been using this patch for months to keep akonadi working on my machine.

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Boudewijn Rempt]

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

--- Comment #112 from Boudewijn Rempt  ---
And this happened again today, and yesterday, all in all about five or six
times this week. Except that running Stephan's sql statement still doesn't make
kmail download mail on this laptop. Maybe we should just spam this bug report
every singe time this happens? That might might show how _bad_ the situation.

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Aaron Williams]

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

Aaron Williams  changed:

   What|Removed |Added

 CC||aar...@doofus.org

--- Comment #111 from Aaron Williams  ---
I too am still experiencing this problem with 17.12.3 in OpenSuSE 15.0, both
with my home IMAP server (Cyrus) and work (Office365). I configured it to use
Postgresql.

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[davidblunkett]

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

--- Comment #110 from davidblunkett  ---
I doubt my problem was ever this bug but, FWIW it appears to be working again
in 5.7.3

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Rafael Kitover]

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

--- Comment #109 from Rafael Kitover  ---
*** Bug 397755 has been marked as a duplicate of this bug. ***

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Rafael Kitover]

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

Rafael Kitover  changed:

   What|Removed |Added

 CC||rkito...@gmail.com

--- Comment #108 from Rafael Kitover  ---
*** Bug 397756 has been marked as a duplicate of this bug. ***

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Christophe Giboudeaux]

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

--- Comment #107 from Christophe Giboudeaux  ---
*** Bug 382253 has been marked as a duplicate of this bug. ***

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[davidblunkett]

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

--- Comment #106 from davidblunkett  ---
FWIW I've tried the suggestions that this is related to kmail filters by
deleting all my filters and I can report that this has _not_ fixed the problem
because an hour later kmail has stopped (yet again) collecting mail.

This is a ridiculous state of affairs - a major flavour of linux's flagship
email system cannot receive email, numerous bug reports and apparently SFA
going on.

What I do know is older versions of kmail do not have this problem even now. So
I suspect that the recent duplicates added here are not duplicates of the
original problem.

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Steven Haigh]

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

--- Comment #105 from Steven Haigh  ---
Probably the same issue. Its been around for ever and I'm not sure anyone
cares...

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Michel]

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

--- Comment #104 from Michel  ---
Hello, 

Is it the same PB I opened  : Bug 395417 - I've to restart akonadi several
times during day for get Google IMAP access refreshing

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[davidblunkett]

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

davidblunkett  changed:

   What|Removed |Added

 CC||dav1dblunk...@hotmail.com

--- Comment #103 from davidblunkett  ---
Is there a way to change the number of akonadi_imap restarts allowed? 

org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_imap_resource'
crashed! 1 restarts left.

I'd just like to run a cronjob to kill akonadi_imap silently every hour so I
wasn't bugged with this problem.

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Lari Natri]

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

Lari Natri  changed:

   What|Removed |Added

 CC||lari.na...@gmail.com

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Matěj Laitl]

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

Matěj Laitl  changed:

   What|Removed |Added

 CC|ma...@laitl.cz  |

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Allan Sandfeld]

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

--- Comment #102 from Allan Sandfeld  ---
I also see this on a regular basis, though it doesn't always completely stall
imap account, or at least didn't with my last version, but now does so again.

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Allan Sandfeld]

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

Allan Sandfeld  changed:

   What|Removed |Added

 CC||k...@carewolf.com

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Michel]

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

Michel  changed:

   What|Removed |Added

 CC||dubois.mic...@gmail.com

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Rolf Eike Beer]

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

Rolf Eike Beer  changed:

   What|Removed |Added

 CC||b...@valdyas.org

--- Comment #101 from Rolf Eike Beer  ---
*** Bug 393795 has been marked as a duplicate of this bug. ***

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Rolf Eike Beer]

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

Rolf Eike Beer  changed:

   What|Removed |Added

 CC||christian.saem...@gmx.de

--- Comment #99 from Rolf Eike Beer  ---
*** Bug 376808 has been marked as a duplicate of this bug. ***

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Rolf Eike Beer]

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

Rolf Eike Beer  changed:

   What|Removed |Added

 CC||thatskinnywhiteguy+kde@gmai
   ||l.com

--- Comment #100 from Rolf Eike Beer  ---
*** Bug 382253 has been marked as a duplicate of this bug. ***

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Gunter Ohrner]

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

Gunter Ohrner  changed:

   What|Removed |Added

 CC||kdeb...@customcdrom.de

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Steven Haigh]

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

--- Comment #98 from Steven Haigh  ---
Thanks for the link.

@Daniel Vrátil - Can you please advise on the thoughts to resolve this?

Seems to be a long standing / high impact issue with no progress.

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Joshua Clayton]

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

--- Comment #97 from Joshua Clayton  ---
I looked really hard for it and didn't find it yesterday... but somehow when I
looked again this morning it is the second result.
My patch was attached to 

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

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Steven Haigh]

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

--- Comment #96 from Steven Haigh  ---
Thanks for the additional info - would it be too much to ask to find the
previous patch?

I guess the idea was along the lines of a LIMIT 1 in scenarios where more than
one result would kill the world.

Ideally, this could be a runtime fix - and the fsck ability of akondactl could
remove duplicate entries.

I still use this code in the SQL tab of akonadiconsole:
DELETE FROM pimitemtable WHERE pimitemtable.id in (
SELECT id FROM (
SELECT id FROM pimitemtable
LEFT OUTER JOIN (
SELECT MIN(pimitemtable.id) as RowId, pimitemtable.remoteId,
pimitemtable.collectionId FROM pimitemtable GROUP by pimitemtable.remoteId,
pimitemtable.collectionId
)
as KeepRows ON pimitemtable.id = KeepRows.RowId
WHERE KeepRows.RowId IS NULL
) AS foo
)

Source:
https://wiki.meurisse.org/wiki/Workarounds#Kmail:_Multiple_merge_candidates.2C_aborting

This seems to resurrect things until it occurs again.

Still annoying and really needs to be fixed.

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Joshua Clayton]

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

--- Comment #95 from Joshua Clayton  ---
The bug is this:
emails contain an ID field in the header, usually a combination of a
timestamp + source ip or email address
kmail assumes that this ID is unique, but does a query that can return
multiple results.
It pukes every time duplicate emails are returned and it never recovers
from this status.

I proposed a fairly simple patch to fix this, just select the first result
from the query, and be done with it.
Sadly, the maintainer was unwilling to accept it, and the bug remains open

Usually these duplicates are multiple references to the same email, via
filters, or similar things.
(I have accidentally generated different emails with the same id, while
messing with git-send-email, but that is
an extremely rare edge case and I was doing wrong things out of ignorance
at the time)


I can no longer find which bug report my was attached to. It has been too
long, Sorry.

On Sun, Mar 18, 2018 at 11:56 PM, Steven Haigh 
wrote:

> https://bugs.kde.org/show_bug.cgi?id=338658
>
> --- Comment #94 from Steven Haigh  ---
> Interestingly, I disabled the local filters on my gmail account today from
> within Kmail and haven't had to restart akonadi all day.
>
> Maybe there is something within the local filters that causes things to
> die?
>
> --
> You are receiving this mail because:
> You are on the CC list for the bug.
>

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Steven Haigh]

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

--- Comment #94 from Steven Haigh  ---
Interestingly, I disabled the local filters on my gmail account today from
within Kmail and haven't had to restart akonadi all day.

Maybe there is something within the local filters that causes things to die?

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Steven Haigh]

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

--- Comment #93 from Steven Haigh  ---
I use kmail with Dovecot + Sieve at home - and I never seem to have an issue.

I use kmail with Gmail at work with local filters, and it dies multiple times a
day. Every time it requires the documented (in this report anyway) SQL query to
fix and a restart of the akonadi services via akonadictl restart.

Same distro, same kmail / framework versions.

I'm in the middle of setting up a local set of folders and syncing the gmail
account with offlineimap to see if that suffers the same problem - but I think
this is going to be the only workaround that is somewhat reliable...

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Dennis Schridde]

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

--- Comment #92 from Dennis Schridde  ---
(In reply to Francis Herne from comment #91)
> FWIW, I removed all local filters from the affected account (in favour of
> Sieve) and so far the issue hasn't recurred using Dovecot. Given that it
> previously happened multiple times per day, filters are clearly one possible
> cause of this.
> 
> 
> (Some people above reported problems even without filters, so perhaps
> there's more than one trigger with similar symptoms.  Debugging could be
> "fun"...)

I also use Dovecot + Sieve and am running into the issue occasionally.

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Francis Herne]

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

--- Comment #91 from Francis Herne  ---
FWIW, I removed all local filters from the affected account (in favour of
Sieve) and so far the issue hasn't recurred using Dovecot. Given that it
previously happened multiple times per day, filters are clearly one possible
cause of this.


(Some people above reported problems even without filters, so perhaps there's
more than one trigger with similar symptoms.  Debugging could be "fun"...)

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Steven Haigh]

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

--- Comment #90 from Steven Haigh  ---
So as we're now looking at nearly 4 years on with this issue, are we any closer
to looking for a final resolution?

I see new commits on the kmail git repo, but it looks like there's only one
person looking after it?

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Steven Haigh]

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

--- Comment #89 from Steven Haigh  ---
Well, me being a sucker for punishment - with a new laptop - I set up kmail on
a fresh install of Fedora 27.

Sync'ed my gmail account to it.

The very next day, hit by this problem.

>From the console:
org.kde.pim.akonadicore: Creating/updating items from the akonadi database
failed: "Unknown error."
org.kde.pim.akonadicore: Creating/updating items from the akonadi database
failed: "Unknown error."
org.kde.pim.akonadicore: Creating/updating items from the akonadi database
failed: "Unknown error."
org.kde.pim.akonadicore: Creating/updating items from the akonadi database
failed: "Unknown error."
org.kde.pim.akonadicore: Creating/updating items from the akonadi database
failed: "Multiple merge candidates, aborting"

So yeah - this is still an issue.

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Dennis Schridde]

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

--- Comment #88 from Dennis Schridde  ---
(In reply to Steven Haigh from comment #87)
> In fact, thinking out loud, I wonder if the mail filters have any
> contribution to this?

I hit the same with no local filters -- all my filter is a server-side Sieve
script.

My mailserver is running Dovecot 2.2.33.2, but given the various reports about
other providers, I doubt that's related.

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Steven Haigh]

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

--- Comment #87 from Steven Haigh  ---
I never had problems sending - only receiving...

I've often wondered if the 'IMAP' connection to gmail goes away unexpectedly
that it causes this problem - but have had no real way to prove this.

Just leaving kmail open for a couple of hours with the auto-check for every
10-15 minutes is enough to cause the problem. It seems to get worse when using
mail filters - as I have quite a few.

In fact, thinking out loud, I wonder if the mail filters have any contribution
to this?

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[avlas]

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

--- Comment #86 from avlas  ---
mmm, gmail works fine in my system (up-t-date KDE neon User Edition), so I
guess it's not an entirely general issue with gmail.

do you have problems in receiving, in sending or both?

for the case it helps:

my settings for receiving emails are set automatically (I guess this is sth
that changed recently, it wasn't like that before).

my sending settings are: TLS 587 LOGIN

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Steven Haigh]

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

--- Comment #85 from Steven Haigh  ---
That is interesting.

I am currently using Fedora 27 - which includes dovecot 2.2.33 without issues.
In fact, I'm not sure I have ever seen this issue with dovecot as the IMAP
server.

My problems are purely with the gmail integration. I was assuming that this
problem only affects gmail.

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Francis Herne]

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

--- Comment #84 from Francis Herne  ---
That's odd, the problematic account in my case is on a Dovecot server (2.2.7
now).

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Steven Haigh]

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

--- Comment #83 from Steven Haigh  ---
Heh - funny you should mention this - I've recently had to do the same for my
work gmail based mail. Thunderbird is s slow by comparison - kmail is
clearly better - but having mail break a dozen times a day isn't usable.

I still use kmail for my home dovecot IMAP mail - and its perfect - but akonadi
really doesn't like gmail at all.

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Francis Herne]

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

Francis Herne  changed:

   What|Removed |Added

Version|5.6.1   |5.7.2

--- Comment #82 from Francis Herne  ---
This is still broken in 5.7.2.

I have had to move away from KMail for normal use due to this bug; silently
failing to recieve emails (until I manually poke the database, no less) every
few hours isn't a behaviour I can cope with.

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Dennis Schridde]

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

--- Comment #81 from Dennis Schridde  ---
(In reply to andreas.sturmlechner from comment #53)
I am trying to execute the following query:
DELETE FROM pimitemtable
WHERE pimitemtable.id in (
  SELECT id FROM (
SELECT id
FROM pimitemtable
LEFT OUTER JOIN (
  SELECT MIN(pimitemtable.id) as RowId, pimitemtable.remoteId,
pimitemtable.collectionId
  FROM pimitemtable
  GROUP by pimitemtable.remoteId, pimitemtable.collectionId)
AS KeepRows ON pimitemtable.id = KeepRows.RowId
WHERE KeepRows.RowId IS NULL)
  AS _)

But I get this error:
Lock wait timeout exceeded; try restarting transaction QMYSQL: Unable to
execute query

I am using KDE Applications 17.12.1, KDE Frameworks 5.42.0, Qt 5.9.3, MariaDB
10.2.12.

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Tomas]

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

Tomas  changed:

   What|Removed |Added

 CC||thur...@gmail.com

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Alex Hermann]

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

Alex Hermann  changed:

   What|Removed |Added

 CC||g...@gmx.net

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Steven Haigh]

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

--- Comment #80 from Steven Haigh  ---
Just to give this a nudge, I still see this with 17.12 on Fedora 27.

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Rex Dieter]

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

Rex Dieter  changed:

   What|Removed |Added

 CC||rdie...@gmail.com

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[bugzilla_noreply]

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

harbin...@gmail.com changed:

   What|Removed |Added

 CC|harbin...@gmail.com |

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Francis Herne]

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

Francis Herne  changed:

   What|Removed |Added

Version|5.5.1   |5.6.1
 CC||m...@flherne.uk

--- Comment #79 from Francis Herne  ---
Still reproducible on Arch with KMail 5.6.1 and Akonadi 17.08.

Akonadi hangs after each "Check Mail" and must be restarted to receive any more
mail. The steps described here
https://www.dvratil.cz/2017/01/kmail-multiple-merge-candidates-error-and-how-to-fix-it/
don't permanently fix the problem, it recurs soon after.

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[bugzilla_noreply]

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

gra...@howlingfrog.com changed:

   What|Removed |Added

 CC||gra...@howlingfrog.com

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Robert G . Siebeck]

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

Robert G. Siebeck  changed:

   What|Removed |Added

 CC|kde.bugzilla.2...@r123.de   |

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Piotr Keplicz]

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

--- Comment #78 from Piotr Keplicz  ---
It happens in KMail 5.5.3 (KDE Neon) on a regular basis in a local folder for a
mailing list. The mails are moved to this folder using a standard mailing list
filter on incoming mail from a POP3 account.

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Piotr Keplicz]

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

Piotr Keplicz  changed:

   What|Removed |Added

 CC||kepl...@cmc.pl

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Marcus]

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

Marcus  changed:

   What|Removed |Added

 CC||wellend...@posteo.de

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Sebastien Renard]

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

Sebastien Renard  changed:

   What|Removed |Added

 CC||ren...@kde.org

--- Comment #77 from Sebastien Renard  ---
I confirmed this issue with kmail 5.5.2 (openuse 42.3). It also happened with
local folders (maildir). Akonadi restart does not work. 
Two workarounds works :
- clear akonadi cache on the folder and restart akonadi and kmail
- connect to mysql to delete items (see comment 75)

It happened multiple times per day and make kmail amost unusable...

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[bugzilla_noreply]

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

k...@douglasmcmillan.com changed:

   What|Removed |Added

 CC||k...@douglasmcmillan.com

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Denis Kurz]

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

Denis Kurz  changed:

   What|Removed |Added

Version|1.13.0  |5.5.1

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Steven Haigh]

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

Steven Haigh  changed:

   What|Removed |Added

 CC||net...@crc.id.au

--- Comment #76 from Steven Haigh  ---
For what its worth, I still see this with Fedora 26.

 rpm -qa | grep kmail | sort
kf5-kmailtransport-17.04.1-1.fc26.x86_64
kf5-kmailtransport-akonadi-17.04.1-1.fc26.x86_64
kmail-17.04.1-3.fc26.x86_64
kmail-account-wizard-17.04.1-1.fc26.x86_64
kmail-libs-17.04.1-3.fc26.x86_64

$ rpm -qa | grep akonadi | sort
akonadi-calendar-tools-17.04.1-1.fc26.x86_64
akonadiconsole-17.04.1-1.fc26.x86_64
akonadi-import-wizard-17.04.1-1.fc26.x86_64
kf5-akonadi-calendar-17.04.1-1.fc26.x86_64
kf5-akonadi-contacts-17.04.1-1.fc26.x86_64
kf5-akonadi-mime-17.04.1-1.fc26.x86_64
kf5-akonadi-notes-17.04.1-1.fc26.x86_64
kf5-akonadi-search-17.04.1-1.fc26.x86_64
kf5-akonadi-server-17.04.1-3.fc26.x86_64
kf5-akonadi-server-mysql-17.04.1-3.fc26.x86_64
kf5-kmailtransport-akonadi-17.04.1-1.fc26.x86_64
kf5-libkdepim-akonadi-17.04.1-1.fc26.x86_64
kf5-mailimporter-akonadi-17.04.1-1.fc26.x86_64
kf5-pimcommon-akonadi-17.04.1-1.fc26.x86_64

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Michal]

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

Michal  changed:

   What|Removed |Added

 CC|mik...@outlook.com  |

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Dennis Schridde]

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

--- Comment #75 from Dennis Schridde  ---
(In reply to Dennis Schridde from comment #74)

The workaround still works:
https://wiki.meurisse.org/wiki/Workarounds#Kmail:_Multiple_merge_candidates.2C_aborting

Could this please be automated?

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Dennis Schridde]

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

--- Comment #74 from Dennis Schridde  ---
I am at KDE Applications 17.04.2 now and the problem appeared again:
```
akonadi_imap_resource[12572]: org.kde.pim.akonadicore: Creating/updating items 
from the akonadi database failed: "Unknown error."
akonadi_imap_resource[12572]: org.kde.pim.akonadicore: Creating/updating items 
from the akonadi database failed: "Unknown error."
akonadi_imap_resource[12572]: org.kde.pim.akonadicore: Creating/updating items 
from the akonadi database failed: "Unknown error."
akonadi_imap_resource[12572]: org.kde.pim.akonadicore: Creating/updating items 
from the akonadi database failed: "Unknown error."
akonadi_imap_resource[12572]: org.kde.pim.akonadicore: Creating/updating items 
from the akonadi database failed: "Unknown error."
akonadi_imap_resource[12572]: org.kde.pim.akonadicore: Creating/updating items 
from the akonadi database failed: "Unknown error."
akonadi_imap_resource[12572]: org.kde.pim.akonadicore: Creating/updating items 
from the akonadi database failed: "Unknown error."
akonadi_imap_resource[12572]: org.kde.pim.akonadicore: Creating/updating items 
from the akonadi database failed: "Unknown error."
akonadi_imap_resource[12572]: org.kde.pim.akonadicore: Creating/updating items 
from the akonadi database failed: "Unknown error."
akonadi_imap_resource[12572]: org.kde.pim.akonadicore: Creating/updating items 
from the akonadi database failed: "Unknown error."
akonadi_imap_resource[12572]: org.kde.pim.akonadicore: Creating/updating items 
from the akonadi database failed: "Multiple merge candidates, aborting"
akonadi_imap_resource[12572]: org.kde.pim.akonadicore: Error during ItemSync:  
"Multiple merge candidates, aborting"
```
(All messages appear in the log within the same second.)

I also see this a little bit later, but it is probably not related?
```
kmail[5475]: org.kde.pim.kmanagersieve: void
KManageSieve::SessionThread::slotSocketError() "Unknown error"  
kmail[5475]: org.kde.pim.kmanagersieve: "session3" No job for reporting this
error message! "Could not connect to host Unknown error."   
```

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Dennis Schridde]

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

--- Comment #73 from Dennis Schridde  ---
(In reply to Dennis Schridde from comment #72)
> (In reply to Christoph Feck from comment #71)
> > Are there certain steps or specific setups needed to reproduce?

If that's of any help: While writing comment #72, mail was syncing fine. But
when I returned to my computer just now, it had stopped and I had to run
"akonadictl restart" again. Already the mail emitted by bugzilla for comment
#72 did not arrive at my client anymore.

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Dennis Schridde]

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

--- Comment #72 from Dennis Schridde  ---
(In reply to Christoph Feck from comment #71)
> Are there certain steps or specific setups needed to reproduce?

I have no clue how to gather additional information about the issue. I don't
even know what messages or folders cause the error, because there is no error
message.

I will recap my setup and symptoms, though:

Setup:
* Server
  - Gentoo Linux
  - Dovecot 2.2.27
- dbox mailboxes
  - Dovecot Pigeonhole 0.4.16
- Heavy use of Sieve scripts to sort mailing lists and spam
  - Dovecot Antispam 2.0_pre20130429
- My spam and ham folders should be monitored and acted upon by this
plugin, but it appears to not do anything at all.
* Client 1
  - Gentoo Linux
  - KMail 5.4.2
  - KDE Apps 16.12.2
  - KDE Frameworks 5.31.0
  - KDE Plasma 5.9.2
  - No client side filtering. I use Sieve exclusively.
  - The error appears here.
  - I use this client on a daily basis, when I am at home.
* Client 2
  - Arch Linux
  - KMail 5.4.2
  - KDE Apps 16.12.2
  - KDE Frameworks 5.31.0
  - KDE Plasma 5.9.2
  - No client side filtering. I use Sieve exclusively.
  - The error does not appear here.
  - I use this client only very very seldomly. The machine mostly stays powered
off.
* Client 3
  - Roundcube 1.2.3
  - No client side filtering. I use Sieve exclusively.
  - I use this client on a daily basis, when I am not at home.
* Client 4
  - Android 6.0.1 / Cyanogenmod 13
  - Whatever the default mail client is there...
  - I use this client on a daily basis, throughout the whole day.

The mail account itself consists of a lot of (ca. 200 [1]) nested mailboxes (up
to 4 levels: /1/2/3/4). Some of these are rather large (10 contain >5k mails,
the largest being at 25k [2]).

The following was observed on "Client 1":

* KMail syncs the "sent" folder (7k mails) every time, which takes a few
seconds. All other folders just flash by so quickly I can barely read their
name.
* After the multiple-merge-candidates error appeared, KMail sometimes continues
working (i.e. further clicks on "Check Mail" start a sync), but sometimes this
account will not appear on the sync details list (behind up-arrow at bottom
right of screen) again, until I run "akonadictl restart".
* There is no visible error message (not counting the one displayed in the sync
details list, because it is hidden behind a button, only displayed very briefly
and without an indication that it is an error).
* There is no hint what mail or mailbox is causing this.
* KMail never recovers from this error. I.e. it does not merge the mails
automatically or ask me for help.

[1]: doveadm -f flow fetch -u $USER mailbox-guid all | sort -u | wc -l
[2]: doveadm -f flow fetch -u $USER mailbox-guid all | sort | uniq -c | sort -n

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Christoph Feck]

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

Christoph Feck  changed:

   What|Removed |Added

 Status|RESOLVED|REOPENED
 Resolution|FIXED   |---

--- Comment #71 from Christoph Feck  ---
Reopening.

Are there certain steps or specific setups needed to reproduce?

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Dennis Schridde]

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

--- Comment #70 from Dennis Schridde  ---
Then I request to reopen this, please.

I saw the message "Multiple merge candidates, aborting" while using KMail 5.4.1
(KDE Applications 16.12.1) as mentioned before (comment #65) and I still see it
in KMail 5.4.2 (KDE Applications 16.12.2). KMail also regularly refused to sync
the IMAP account where this happens until I restart Akonadi.

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Achim Bohnet]

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

--- Comment #69 from Achim Bohnet  ---
On Donnerstag, 9. Februar 2017 18:28:10 CET you wrote:
> https://bugs.kde.org/show_bug.cgi?id=338658
> 
> I'm on Gentoo and have kde-apps/libkdepim-16.12.1 installed. There is no
> version 5.4.1 available.

Don't confuse the KDE Applications Release version with the  Program
version.  It's often the same but not always.

kde applications 16.12.1 release contains 5.4.1: Kmail -> Help -> About Kmail,
or

$ kmail --version
kmail2 5.4.1

$ dpkg -l kmail\* | tail -1
ii  kmail  4:16.12.1-0neon+16.04+build7 amd64full featured
graphical email client


Some (most?) PIM maintainers don't want to set the version of their Program
to the same version as the KDE Applications Release.  IMHO confusing for users.

Achim

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Dennis Schridde]

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

--- Comment #68 from Dennis Schridde  ---
(In reply to Ovidiu-Florin BOGDAN from comment #66)
> (In reply to Dennis Schridde from comment #65)
> > I also see this with KDE Applications 16.12.1 and KDE Frameworks 5.30.1 (and
> > KDE Plasma 5.9.1, but that should be unrelated).
> > 
> > In this bug it says "Version Fixed In: 5.4.1" - version 5.4.1 of what
> > exactly? I would think that I am well beyond 5.4.1 in both areas...
> 
> Of KDE PIM. AFAIK it has its own versioning besides the KDE applications.

I'm on Gentoo and have kde-apps/libkdepim-16.12.1 installed. There is no
version 5.4.1 available.

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Dennis Schridde]

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

--- Comment #67 from Dennis Schridde  ---
The workaround is also documented here:
https://wiki.meurisse.org/wiki/Workarounds#Kmail:_Multiple_merge_candidates.2C_aborting

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Ovidiu-Florin BOGDAN]

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

--- Comment #66 from Ovidiu-Florin BOGDAN  ---
(In reply to Dennis Schridde from comment #65)
> I also see this with KDE Applications 16.12.1 and KDE Frameworks 5.30.1 (and
> KDE Plasma 5.9.1, but that should be unrelated).
> 
> In this bug it says "Version Fixed In: 5.4.1" - version 5.4.1 of what
> exactly? I would think that I am well beyond 5.4.1 in both areas...

Of KDE PIM. AFAIK it has its own versioning besides the KDE applications.

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Dennis Schridde]

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

--- Comment #65 from Dennis Schridde  ---
I also see this with KDE Applications 16.12.1 and KDE Frameworks 5.30.1 (and
KDE Plasma 5.9.1, but that should be unrelated).

In this bug it says "Version Fixed In: 5.4.1" - version 5.4.1 of what exactly?
I would think that I am well beyond 5.4.1 in both areas...

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[Dennis Schridde]

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

Dennis Schridde  changed:

   What|Removed |Added

 CC||devuran...@gmx.net

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[bugzilla_noreply]

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

--- Comment #64 from jsta...@gmx.net ---
Created attachment 103395
  --> https://bugs.kde.org/attachment.cgi?id=103395=edit
Backtrace shown in Konsole for akonadi no longer showing mails from within
maildir

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[bugzilla_noreply]

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

--- Comment #63 from jsta...@gmx.net ---
Today the 5.4.1 arrived for my ARCH installation. The problem is not gone
unfortunately - at least the one that my mail contents/folder contents do no
longer show up after some deletion(s). Symptoms seem to have changed a little
bit as it no longer happens immediately after each deletion. But after doing
some more I still have to restart the akonadi server to get mails displayed
again.

The Debugger tab of the Akonadi Console shows in the lower part some error
messages, that arised after last re-start of the akonadi server until kmail
being blocked:

AgentBase(akonadi_maildir_resource_0): Multiple merge candidates, aborting
AgentBase(akonadi_maildir_resource_0): Multiple merge candidates, aborting

The Konsole window having restarted the akonadi server from the last time ()
shows backtrace that I will attach in a moment.

-- 
You are receiving this mail because:
You are watching all bug changes.

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

[bugzilla_noreply]

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

jsta...@gmx.net changed:

   What|Removed |Added

 CC||jsta...@gmx.net

--- Comment #62 from jsta...@gmx.net ---
For me this does not happen for IMAP folders but for local, maildir, ones.
Actually again after each deletion of an email.

Does this sound related?

Running an up-to-date ARCH installation actually containing akonadi 16.12.0-1.

Some more details can be found here:
https://bbs.archlinux.org/viewtopic.php?pid=1682923#p1682923

-- 
You are receiving this mail because:
You are watching all bug changes.