[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 <devurandom at gmx.net> ---
(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 on the CC list for the bug.
You are the assignee for the bug.