[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

[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

[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] [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

[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 = ?,

[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

[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.

[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

[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

[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