kmail fails to start after upgrade

[tomchiverton1]

$ akonadictl --verbose start
org.kde.pim.akonadictl: Starting Akonadi Server...
org.kde.pim.akonadictl: done.
Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QStr ing,QString,QString)
falken@wopr:~$ org.kde.pim.akonadiserver: Starting up the Akonadi Server...
org.kde.pim.akonadiserver: Found mysql_install_db: ""
org.kde.pim.akonadiserver: Found mysqlcheck: ""
org.kde.pim.akonadiserver: Using mysqld: ""
org.kde.pim.akonadiserver: Did not find MySQL server default configuration (mysql-global.conf)
org.kde.pim.akonadiserver: terminating connection threads
org.kde.pim.akonadiserver: terminating service threads
org.kde.pim.akonadiserver: stopping db process
org.kde.pim.akonadiserver: Shutting down AkonadiServer...
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadiserver' exited normally...

$ kmail
Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QStr ing,QString,QString)
org.kde.pim.akonadiserver: Starting up the Akonadi Server...
org.kde.pim.akonadiserver: Did not find MySQL server default configuration (mysql-global.conf)
org.kde.pim.akonadiserver: Shutting down AkonadiServer...
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadiserver' exited normally...

Sometimes the KMail window will appear, and say a message about Akonadi "not operation", but pressing "details" on the error does nothing

[tomchiverton1]

Adding backports hasn't helped

[tomchiverton1]

falken@wopr:~$ find /etc -iname mysql-global.conf
find: ‘/etc/keybase’: Permission denied
find: ‘/etc/polkit-1/localauthority’: Permission denied
find: ‘/etc/ssl/private’: Permission denied
find: ‘/etc/cups/ssl’: Permission denied
falken@wopr:~$ find ~/ -iname mysql-global.conf
find: ‘/home/falken/.cache/dconf’: Permission denied
falken@wopr:~$ find /usr -iname mysql-global.conf
find: ‘/usr/lib/chromium-browser/extensions’: Permission denied
falken@wopr:~$ find /var -iname mysql-global.conf

...just permission denied from things...

[tomchiverton1]

apt-get install --reinstall akonadi-server

completes without error, no effect

[tomchiverton1]

cp /home/falken/.local/share/akonadi/mysql.conf /home/falken/.config/akonadi/mysql-global.conf (based on strace -f akonadictl start)

sudo apt install mariadb-server-core-10.5 (based on error after running above saying mysqld was missing)

akonadictl start now OK, and akonadictl status says running.

looks like a buggered dependency as well as some sort of failure in a migration script ?

[GreyGeek]

If it can't find mysql-global.conf then try adding it. You can copy it from here and change its ownership to root and its permissions to 0644

https://www.apt-browse.org/browse/ub...ql-global.conf

[tomchiverton1]

Oh, handy, I'll do that and remove my hacked in file. There is nothing in that folder !

[tomchiverton1]

Didn't work, removed my own copied file, added those two, and

$ akonadictl --verbose start
org.kde.pim.akonadictl: Starting Akonadi Server...
org.kde.pim.akonadictl: done.
Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QStr ing,QString,QString)
falken@wopr:~$ org.kde.pim.akonadiserver: Starting up the Akonadi Server...
org.kde.pim.akonadiserver: Found mysql_install_db: "/usr/bin/mysql_install_db"
org.kde.pim.akonadiserver: Found mysqlcheck: ""
org.kde.pim.akonadiserver: Using mysqld: "/usr/sbin/mysqld"
org.kde.pim.akonadiserver: Did not find MySQL server default configuration (mysql-global.conf)
org.kde.pim.akonadiserver: terminating connection threads
org.kde.pim.akonadiserver: terminating service threads
org.kde.pim.akonadiserver: stopping db process
org.kde.pim.akonadiserver: Failed to remove runtime connection config file
org.kde.pim.akonadiserver: Shutting down AkonadiServer...

Sigh.

[tomchiverton1]

Copied the /etc/akonadi files to /etc/xdg/akonadi (as indicated by strace, again) and it starts now.

But a few seconds later :

org.kde.pim.akonadiserver: database server stopped unexpectedly
org.kde.pim.akonadiserver: Database process exited unexpectedly during initial connection!
org.kde.pim.akonadiserver: executable: "/usr/sbin/mysqld"
org.kde.pim.akonadiserver: arguments: ("--defaults-file=/home/falken/.local/share/akonadi/mysql.conf", "--datadir=/home/falken/.local/share/akonad
i/db_data/", "--socket=/run/user/1000/akonadi/mysql.socket", "--pid-file=/run/user/1000/akonadi/mysql.pid")
org.kde.pim.akonadiserver: stdout: ""
org.kde.pim.akonadiserver: stderr: "2021-04-30 19:47:52 0 [Note] /usr/sbin/mysqld (mysqld 10.5.9-MariaDB-1) starting as process 17292 ...\n"

tail /home/falken/.local/share/akonadi/db_data/mysql.err says


2021-04-30 19:51:15 0 [ERROR] /usr/sbin/mysqld: unknown variable 'innodb_additional_mem_pool_size=1M'
2021-04-30 19:51:15 0 [ERROR] Aborting

So the cfg files are wrong. Looking at them, their for Trusty ? Not Hirsuite ?

[tomchiverton1]

But gave me a hint. akonadi-backend-mysql isn't installed !

Remove the manual files, install it, and it gives the same entry in mysql.err

Something is very wrong. Raising a real bug now.

[tomchiverton1]

(workaround) manually removed the line referencing innodb_additional_mempool from /home/falken/.local/share/akonadi/mysql.conf and it sprung to life

[VincentvdBergh]

This kind of troubles is the reason why I trew KMail (and in fact, Kontact) out of my installation and switched to Thunderbird. Akonadi just gives so much troubles every other update that I ended up with a totally frozen system a few times.