https://bugs.kde.org/show_bug.cgi?id=338658
--- Comment #81 from Dennis Schridde <devuran...@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 watching all bug changes.
