[Akonadi] [Bug 452958] akonadi's mysql locked with an extraneous SELECT query after resuming from sleep

[Martin van Es]

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

--- Comment #6 from Martin van Es <bugs at mrvanes.com> ---
So, my akonadi was unresponse this morning after resuming from sleep and I see
these unresponsive processes/queries in mysqld:

UPDATE PimItemTable SET rev = ?, remoteId = ?, remoteRevision = ?, gid = ?,
collectionId = ?, mimeTypeId = ?, datetime = ?, atime = ?, dirty = ?, size = ?
WHERE ( id = ? )

SELECT PimItemTable.id, PimItemTable.rev, PimItemTable.remoteId,
PimItemTable.remoteRevision, PimItemTable.gid, PimItemTable.collectionId,
PimItemTable.mimeTypeId, PimItemTable.datetime, PimItemTable.atime,
PimItemTable.dirty, PimItemTable.size FROM PimItemTable WHERE ( collectionId =
? AND ( ( remoteId = ? ) ) ) FOR UPDATE

UPDATE PimItemTable SET remoteId = ? WHERE ( ( PimItemTable.id = ? OR
PimItemTable.id = ? OR PimItemTable.id = ? OR PimItemTable.id = ? OR
PimItemTable.id = ? ) )

UPDATE PimItemTable SET atime = ? WHERE ( ( ( PimItemTable.id >= ? AND
PimItemTable.id <= ? ) OR PimItemTable.id = ? ) )

On a sidenote: I disabled apparmor, so it's not likely to interfere in my
setup.

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