[Akonadi] [Bug 452958] akonadi's mysql locked with an extraneous SELECT query after resuming from sleep
https://bugs.kde.org/show_bug.cgi?id=452958 Ricardo J. Barberis changed: What|Removed |Added Resolution|--- |FIXED Status|REPORTED|RESOLVED --- Comment #12 from Ricardo J. Barberis --- Thanks for everyboby's feedback, I'm closing this issue as solved. -- You are receiving this mail because: You are the assignee for the bug.
[Akonadi] [Bug 452958] akonadi's mysql locked with an extraneous SELECT query after resuming from sleep
https://bugs.kde.org/show_bug.cgi?id=452958 --- Comment #11 from Daniel Roschka --- I'm also not experiencing this problem anymore. Similar to Ricardo I'm not sure if an Akonadi update (21.12.3 to 22.04.3) or a MariaDB update (10.6.8 to 10.6.10) fixed it. -- You are receiving this mail because: You are the assignee for the bug.
[Akonadi] [Bug 452958] akonadi's mysql locked with an extraneous SELECT query after resuming from sleep
https://bugs.kde.org/show_bug.cgi?id=452958 --- Comment #10 from Martin van Es --- I moved my configuration to a Postgres based one and have yet to see the problem. -- You are receiving this mail because: You are the assignee for the bug.
[Akonadi] [Bug 452958] akonadi's mysql locked with an extraneous SELECT query after resuming from sleep
https://bugs.kde.org/show_bug.cgi?id=452958 --- Comment #9 from Ricardo J. Barberis --- A couple days ago I received an update to mariadb version: $ mysql -V mysql Ver 15.1 Distrib 10.6.10-MariaDB, for Linux (x86_64) using readline 5.1 So far I haven't noticed any more stuck queries fomr akonadi (cross my fingers, knock on wood, etc). akonadi was also updated e few days erlier but I think the maruadb upgrade is what fixed this: $ akonadictl -v akonadictl 5.21.1 (22.08.1) I'll monitor it for a few more days but let's hope this issue has been resolved. -- You are receiving this mail because: You are the assignee for the bug.
[Akonadi] [Bug 452958] akonadi's mysql locked with an extraneous SELECT query after resuming from sleep
https://bugs.kde.org/show_bug.cgi?id=452958 --- Comment #8 from Ricardo J. Barberis --- Forgot to add: $ akonadictl -v akonadictl 5.21.0 (22.08.0) -- You are receiving this mail because: You are the assignee for the bug.
[Akonadi] [Bug 452958] akonadi's mysql locked with an extraneous SELECT query after resuming from sleep
https://bugs.kde.org/show_bug.cgi?id=452958 --- Comment #7 from Ricardo J. Barberis --- Still happening :( Operating System: Slackware64 15.0 (-current) KDE Plasma Version: 5.25.4 KDE Frameworks Version: 5.97.0 Qt Version: 5.15.5 Kernel Version: 5.19.2 (64-bit) Graphics Platform: X11 Processors: 8 × Intel® Core™ i5-1035G1 CPU @ 1.00GHz Memory: 15.2 GiB of RAM Graphics Processor: Mesa Intel® UHD Graphics mysql Ver 15.1 Distrib 10.6.9-MariaDB, for Linux (x86_64) using readline 5.1 -- You are receiving this mail because: You are the assignee for the bug.
[Akonadi] [Bug 452958] akonadi's mysql locked with an extraneous SELECT query after resuming from sleep
https://bugs.kde.org/show_bug.cgi?id=452958 --- Comment #6 from Martin van Es --- 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.
[Akonadi] [Bug 452958] akonadi's mysql locked with an extraneous SELECT query after resuming from sleep
https://bugs.kde.org/show_bug.cgi?id=452958 Martin van Es changed: What|Removed |Added CC||b...@mrvanes.com --- Comment #5 from Martin van Es --- For what it's worth: I'm seeing the same symptoms, although the problem does not seem as reproducable as with the reporter, but it does happen and always after resume from suspend. The mysqld-akonadi process is unkillable (except for -9) and the worst part is, it doesn't really show in kmail so sometimes I notice real late. I don't have a mysql processlist to show (yet). For me akonadi-server is 4:22.04.3-0ubuntu1~ubuntu22.04~ppa1 (Kubuntu 22.04 with backports enabled). -- You are receiving this mail because: You are the assignee for the bug.
[Akonadi] [Bug 452958] akonadi's mysql locked with an extraneous SELECT query after resuming from sleep
https://bugs.kde.org/show_bug.cgi?id=452958 Daniel Roschka changed: What|Removed |Added CC||danielroschka@phoenitydawn. ||de --- Comment #4 from Daniel Roschka --- I've got the same problem using Debian/sid with Akonadi 21.12.3 and MariaDB 10.6.8. -- You are receiving this mail because: You are the assignee for the bug.
[Akonadi] [Bug 452958] akonadi's mysql locked with an extraneous SELECT query after resuming from sleep
https://bugs.kde.org/show_bug.cgi?id=452958 --- Comment #3 from Ricardo J. Barberis --- Workaroud: right after resuming, restart akonadi. I tried that fot several days and it seems to work so far. Maybe it could be scripted? -- You are receiving this mail because: You are the assignee for the bug.
[Akonadi] [Bug 452958] akonadi's mysql locked with an extraneous SELECT query after resuming from sleep
https://bugs.kde.org/show_bug.cgi?id=452958 --- Comment #2 from Ricardo J. Barberis --- Trying to stop akonadi: $ akonadictl stop $ akonadictl status Akonadi Control: running Akonadi Server: running Akonadi Server Search Support: available (Remote Search, Akonadi Search Plugin) Available Agent Types: akonadi_akonotes_resource, akonadi_archivemail_agent, akonadi_birthdays_resource, akonadi_contacts_resource, akonadi_davgroupware_resource, akonadi_ews_resource, akonadi_ewsmta_resource, akonadi_followupreminder_agent, akonadi_google_resource, akonadi_ical_resource, akonadi_icaldir_resource, akonadi_imap_resource, akonadi_indexing_agent, akonadi_knut_resource, akonadi_maildir_resource, akonadi_maildispatcher_agent, akonadi_mailfilter_agent, akonadi_mailmerge_agent, akonadi_mbox_resource, akonadi_migration_agent, akonadi_mixedmaildir_resource, akonadi_newmailnotifier_agent, akonadi_notes_agent, akonadi_notes_resource, akonadi_openxchange_resource, akonadi_pop3_resource, akonadi_sendlater_agent, akonadi_tomboynotes_resource, akonadi_unifiedmailbox_agent, akonadi_vcard_resource, akonadi_vcarddir_resource $ akonadictl status Akonadi Control: stopped Akonadi Server: stopped Akonadi Server Search Support: available (Remote Search, Akonadi Search Plugin) Available Agent Types: akonadi_akonotes_resource, akonadi_archivemail_agent, akonadi_birthdays_resource, akonadi_contacts_resource, akonadi_davgroupware_resource, akonadi_ews_resource, akonadi_ewsmta_resource, akonadi_followupreminder_agent, akonadi_google_resource, akonadi_ical_resource, akonadi_icaldir_resource, akonadi_imap_resource, akonadi_indexing_agent, akonadi_knut_resource, akonadi_maildir_resource, akonadi_maildispatcher_agent, akonadi_mailfilter_agent, akonadi_mailmerge_agent, akonadi_mbox_resource, akonadi_migration_agent, akonadi_mixedmaildir_resource, akonadi_newmailnotifier_agent, akonadi_notes_agent, akonadi_notes_resource, akonadi_openxchange_resource, akonadi_pop3_resource, akonadi_sendlater_agent, akonadi_tomboynotes_resource, akonadi_unifiedmailbox_agent, akonadi_vcard_resource, akonadi_vcarddir_resource $ mysqladmin --socket=/run/user/1000/akonadi/mysql.socket processlist -v mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local server through socket '/run/user/1000/akonadi/mysql.socket' (2)' Check that mariadbd is running and that the socket: '/run/user/1000/akonadi/mysql.socket' exists! $ ps faxu | grep -v grep | grep akonadi 2518 0.9 1.3 4192940 217156 ? Sl abr24 10:07 /usr/libexec/mysqld --defaults-file=/home//.local/share/akonadi/mysql.conf --datadir=/home//.local/share/akonadi/db_data/ --socket=/run/user/1000/akonadi/mysql.socket --pid-file=/run/user/1000/akonadi/mysql.pid $ kill -9 2518 -- You are receiving this mail because: You are the assignee for the bug.
[Akonadi] [Bug 452958] akonadi's mysql locked with an extraneous SELECT query after resuming from sleep
https://bugs.kde.org/show_bug.cgi?id=452958 --- Comment #1 from Ricardo J. Barberis --- Process list after resume from sleep: $ mysqladmin --socket=/run/user/1000/akonadi/mysql.socket processlist -v ++---+---+-+-+--+--+--+--+ | Id | User | Host | db | Command | Time | State| Info | Progress | ++---+---+-+-+--+--+--+--+ | 5 | | localhost | akonadi | Sleep | 1207 | | | 0.000| | 6 | | localhost | akonadi | Execute | 290 | Sending data | SELECT PartTable.id, PartTable.pimItemId, PartTable.partTypeId, PartTable.data, PartTable.datasize, PartTable.version, PartTable.storage FROM PartTable INNER JOIN PimItemTable ON ( pimItemId = PimItemTable.id ) INNER JOIN PartTypeTable ON ( PartTable.partTypeId = PartTypeTable.id ) WHERE ( PimItemTable.collectionId = ? AND PimItemTable.atime < ? AND PartTable.data IS NOT NULL AND PartTypeTable.ns = ? AND PimItemTable.dirty = ? AND PartTypeTable.name <> ? ) | 0.000| | 7 | | localhost | akonadi | Sleep | 1204 | | | 0.000| | 8 | | localhost | akonadi | Sleep | 1204 | | | 0.000| | 62 | root | localhost | | Query | 0| starting | show full processlist | 0.000|
