[Akonadi] [Bug 422309] New: Akonadi dies after suspend to RAM

[Ariadne Conill]

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

            Bug ID: 422309
           Summary: Akonadi dies after suspend to RAM
           Product: Akonadi
           Version: unspecified
          Platform: Other
                OS: Linux
            Status: REPORTED
          Severity: normal
          Priority: NOR
         Component: server
          Assignee: kdepim-bugs at kde.org
          Reporter: ariadne at dereferenced.org
  Target Milestone: ---

After suspending to RAM, akonadi-server 20.04 falls over with MySQL errors and
crashes on Alpine Linux edge.

Monitoring the debug log yields:

org.kde.pim.akonadiserver: Database "akonadi" opened using driver "QMYSQL"
org.kde.pim.akonadicore: "QLocalSocket: Remote closed"
"/run/user/1000/akonadi/akonadiserver-cmd.socket"org.kde.pim.akonadiserver:
Database error: Cannot open database.

org.kde.pim.akonadiserver:   Last driver error: "QMYSQL: Unable to connect"
org.kde.pim.akonadiserver:   Last database error: "Lost connection to MySQL
server at 'reading authorization packet', system error: 9"
org.kde.pim.akonadicore: "QLocalSocket: Remote closed"
"/run/user/1000/akonadi/akonadiserver-cmd.socket"org.kde.pim.akonadicore:
Socket error occurred: "QLocalSocket: Remote closed"

QSocketNotifier: Invalid socket 17 and type 'Read', disabling...
org.kde.pim.akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
QSocketNotifier: Invalid socket 13 and type 'Read', disabling...
QSocketNotifier: Invalid socket 15 and type 'Read', disabling...
org.kde.pim.akonadicore: "QLocalSocket: Remote closed"
"/run/user/1000/akonadi/akonadiserver-cmd.socket"
org.kde.pim.akonadicore: "QLocalSocket: Remote closed"
"/run/user/1000/akonadi/akonadiserver-cmd.socket"
org.kde.pim.akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
org.kde.pim.akonadiserver: DATABASE ERROR while PREPARING QUERY:
org.kde.pim.akonadicore: Socket error occurred: "QLocalSocket: Remote closed"
KCrash: crashing... crashRecursionCounter = 2
KCrash: Application Name = akonadiserver path = /usr/bin pid = 7984
KCrash: Arguments: /usr/bin/akonadiserver 
KCrash: Attempting to start /usr/lib/libexec/drkonqi
org.kde.pim.akonadiserver: Database error: Cannot open database.
QSqlQuery::exec: database not open
org.kde.pim.akonadiserver: Database "akonadi" opened using driver "QMYSQL"
org.kde.pim.akonadiserver: Database error: Cannot open database.
org.kde.pim.akonadiserver:   Last driver error: "QMYSQL: Unable to connect"
org.kde.pim.akonadiserver:   Last database error: "Got packets out of order"
QSqlQuery::exec: database not open
org.kde.pim.akonadicore: "QLocalSocket: Remote closed"
"/run/user/1000/akonadi/akonadiserver-cmd.socket"QSocketNotifier: Invalid
socket 35 and type 'Read', disabling...
org.kde.pim.akonadiserver:   Last driver error: "QMYSQL: Unable to open
database 'akonadi'"
org.kde.pim.akonadiserver:   Last database error: "Lost connection to MySQL
server during query"
QSqlQuery::exec: database not open
org.kde.pim.akonadiserver: Database "akonadi" opened using driver "QMYSQL"
org.kde.pim.akonadiserver: DATABASE ERROR while PREPARING QUERY:
org.kde.pim.akonadiserver:   Error code: "2006"
org.kde.pim.akonadiserver: Database error: Cannot open database.
org.kde.pim.akonadiserver:   DB error:  "MySQL server has gone away"

The MySQL server appears to be alive:

localhost:~$ mysql -S
~/.local/share/akonadi/socket-localhost-default/mysql.socket 
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 257
Server version: 10.4.13-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> show databases;
+--------------------+
| Database           |
+--------------------+
| akonadi            |
| information_schema |
| mysql              |
| performance_schema |
| test               |
+--------------------+
5 rows in set (0.000 sec)

Restarting the service fails...

petrie:~$ akonadictl restart
org.kde.pim.akonadicontrol: Service ":1.146" owner changed from "" to ":1.146"
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_migration_agent'
exited normally...
org.kde.pim.kimap: Received BYE:  "Logging out "
org.kde.pim.kimap: close
org.kde.pim.kimap: close
org.kde.pim.akonadicontrol: ProcessControl: Application
"/usr/bin/akonadi_indexing_agent" stopped unexpectedly ( "Process crashed" )
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_indexing_agent'
crashed. No restart!
org.kde.pim.akonadicontrol: ProcessControl: Application
"/usr/bin/akonadi_archivemail_agent" stopped unexpectedly ( "Process crashed" )
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_archivemail_agent'
crashed. No restart!
org.kde.pim.akonadicontrol: ProcessControl: Application
"/usr/bin/akonadi_newmailnotifier_agent" stopped unexpectedly ( "Process
crashed" )
org.kde.pim.akonadicontrol: Application
'/usr/bin/akonadi_newmailnotifier_agent' crashed. No restart!
org.kde.pim.akonadicontrol: ProcessControl: Application
"/usr/bin/akonadi_followupreminder_agent" stopped unexpectedly ( "Process
crashed" )
org.kde.pim.akonadicontrol: Application
'/usr/bin/akonadi_followupreminder_agent' crashed. No restart!
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_maildispatcher_agent'
exited normally...
org.kde.pim.akonadicontrol: ProcessControl: Application
"/usr/bin/akonadi_imap_resource" stopped unexpectedly ( "Process crashed" )
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_imap_resource'
crashed. No restart!
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_unifiedmailbox_agent'
exited normally...
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_notes_agent' exited
normally...
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_sendlater_agent'
exited normally...
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_maildir_resource'
exited normally...
org.kde.pim.akonadicontrol: ProcessControl: Application
"/usr/bin/akonadi_mailfilter_agent" stopped unexpectedly ( "Process crashed" )
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_mailfilter_agent'
crashed. No restart!

It remains dead after restarting.  If I kill all Akonadi processes manually
(but not mysqld) and run "akonadictl start", it recovers and behaves as normal.

I'm not sure what further information I can provide.  Unfortunately I don't
have any logs for the crashed processes that I am aware of.

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