https://bugs.kde.org/show_bug.cgi?id=452958
Bug ID: 452958
Summary: akonadi's mysql locked with an extraneous SELECT query
after resuming from sleep
Product: Akonadi
Version: 5.20.0
Platform: Slackware Packages
OS: Linux
Status: REPORTED
Severity: normal
Priority: NOR
Component: server
Assignee: kdepim-b...@kde.org
Reporter: ricardo.barbe...@gmail.com
Target Milestone: ---
SUMMARY
Hello all,
A few seconds after resuming from sleep I see an SQL query running in akonadi's
mysql that locks any other operation, e.g.: kmail won't show emails, I can't
backup akonadi's DB with mysqldump, etc.
This happens everyday after waking my laptop from sleep.
If I stop akonadi the mysql server eventually stops accepting connections but a
`ps faxu | grep -v grep | grep akonadi` shows it's still running and the only
way to stop it is to `kill -9` said process.
After that akonadi can be started and everything is OK untill the next
sleep/resume cycle.
In the mysql log I see lines like these when the stop fails because of this
query:
2022-04-23 12:03:46 0 [Note] /usr/libexec/mysqld (initiated by: unknown):
Normal shutdown
2022-04-23 12:04:06 0 [Warning] /usr/libexec/mysqld: Thread 6 (user :
'<USERNAME>') did not exit
BTW, if instead of stoping akonadi I issue a shutdown to mysql directly (e.g.
mysqladmin --socket=/run/user/$(id -u)/akonadi/mysql.socket shutdown), the
mysql server still has to be forcibly killed, so I'm not sure if this is
akonadi's fault for sending that SELECT query or a mariadb bug.
BTW 2, I don't have the exact SQL query right now and ATM I can't suspend my
laptop but I'll update this bug report as soon as I can (later today o tomorrow
morning).
STEPS TO REPRODUCE
1. With akonadi running, put the laptop to sleep
2. Wake up the laptop and monitor akonadi's mysql processes list (e.g.
mysqladmin --socket=/run/user/$(id -u)/akonadi/mysql.socket processlist)
OBSERVED RESULT
There's a SELECT query which never ends and is unkillable
EXPECTED RESULT
No extraneous SELECT and akonadi/kmail working properly
SOFTWARE/OS VERSIONS
Operating System: Slackware 15.0+ (-current)
KDE Plasma Version: 5.24.4
KDE Frameworks Version: 5.93.0
Qt Version: 5.15.3 (qt5-5.15.3_20220407_9b1efa0e-x86_64-1)
Kernel Version: 5.17.4 (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
akonadictl -v: akonadictl 5.20.0 (22.04.0)
mysql --version: mysql Ver 15.1 Distrib 10.6.7-MariaDB, for Linux (x86_64)
using readline 5.1
ADDITIONAL INFORMATION
Similar bug involving an akonadi crash. Not my case but possibly related?
https://bugs.kde.org/show_bug.cgi?id=422309
--
You are receiving this mail because:
You are watching all bug changes.
