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

[Ricardo J. Barberis]

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-bugs at kde.org
          Reporter: ricardo.barberis at 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 the assignee for the bug.