Akonadi Server for KOrganizer does not start for me since last update

[whatthe]

Hi, akonadiserver for KOrganizer does not start for me since last update. I think the problem is related to mariadb?

akonadictl status

Akonadi Control: stopped
Akonadi Server: stopped
Akonadi Server Search Support: available (Remote Search, Akonadi Search Plugin)
Available Agent Types: akonadi_akonotes_resource, akonadi_birthdays_resource, akonadi_contacts_resource, akonadi_davgroupware_resource, akonadi_etesync_resource, akonadi_ews_resource, akonadi_ewsmta_resource, akonadi_google_resource, akonadi_ical_resource, akonadi_icaldir_resource, akonadi_imap_resource, akonadi_indexing_agent, akonadi_knut_resource, akonadi_kolab_resource, akonadi_maildir_resource, akonadi_maildispatcher_agent, akonadi_mbox_resource, akonadi_migration_agent, akonadi_mixedmaildir_resource, akonadi_newmailnotifier_agent, akonadi_notes_resource, akonadi_openxchange_resource, akonadi_pop3_resource, akonadi_tomboynotes_resource, akonadi_vcard_resource, akonadi_vcarddir_resource

org.kde.pim.akonadiserver: Starting up the Akonadi Server...
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/bin/mysqld"
org.kde.pim.akonadiserver: arguments: ("--defaults-file=/home/user/.local/share/akonadi/mysql.conf", "--datadir=/home/user/.local/share/akonadi/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: "2022-06-18 11:21:42 0 [Note] /usr/bin/mysqld (server 10.8.3-MariaDB) starting as process 10 ...\n"
org.kde.pim.akonadiserver: exit code: 1
org.kde.pim.akonadiserver: process error: "Unknown error"
org.kde.pim.akonadiserver: Shutting down AkonadiServer...
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadiserver' exited normally...

Parent is shutting down, bye...

I tried:

sudo aa-complain akonadiserver && akonadictl start && akonadictl restart

and

akonadictl stop
rm -rf ~/.local/share/akonadi
akonadictl start
touch ~/.local/share/akonadi/db_data/ib_logfile0

With no luck

this solution mentioned in this thread does not work for me:
touch ~/.local/share/akonadi/db_data/ib_logfile0

After update on June 12 2022 akonadi will not start

After doing a system update on 6-12-2022 Kontact/Kmail will not display my email. It looks like the problem is with the akonadi server. If I try to start Kontact in a termal I get the following output: Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString) org.kde.pim.akonadiserver: Starting up the Akonadi Server... org.kde.pim.akonadiserver: database server stopped unexpectedly org.kde.pim.akonadiserver: Database process exited unexpectedly durin…

[Aragorn]

First you have to close all applications that use akonadi, i.e. KMail, KOrganizer, Kalendar, et al. Then you must issue the commands…

touch ~/.local/share/akonadi/db_data/ib_logfile0
akonadictl start &

After that, you should be able to use all of your PIM applications again.

[whatthe]

$ killall korganizer
$ akonadictl stop
$ touch ~/.local/share/akonadi/db_data/ib_logfile0
$ akonadictl start &
[1] 3343469
$ org.kde.pim.akonadictl: Starting Akonadi Server...
Reading profile /etc/firejail/akonadi_control.profile
Reading profile /etc/firejail/disable-common.inc
Reading profile /etc/firejail/disable-devel.inc
Reading profile /etc/firejail/disable-exec.inc
Reading profile /etc/firejail/disable-interpreters.inc
Reading profile /etc/firejail/disable-programs.inc
Reading profile /etc/firejail/whitelist-run-common.inc
Reading profile /etc/firejail/whitelist-var-common.inc
Parent pid 3343472, child pid 3343473
Warning: not remounting /run/user/1000/gvfs
Warning: not remounting /run/user/1000/doc
Blacklist violations are logged to syslog
Warning: cleaning all supplementary groups
Child process initialized in 909.53 ms
org.kde.pim.akonadictl:    done.
Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
org.kde.pim.akonadiserver: Starting up the Akonadi Server...
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/bin/mysqld"
org.kde.pim.akonadiserver: arguments: ("--defaults-file=/home/user/.local/share/akonadi/mysql.conf", "--datadir=/home/user/.local/share/akonadi/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: "2022-06-18 11:35:59 0 [Note] /usr/bin/mysqld (server 10.8.3-MariaDB) starting as process 10 ...\n"
org.kde.pim.akonadiserver: exit code: 1
org.kde.pim.akonadiserver: process error: "Unknown error"
org.kde.pim.akonadiserver: Shutting down AkonadiServer...
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadiserver' exited normally...

Parent is shutting down, bye...

[maycne.sonahoz]

Some people also had more trouble.

Akonadi issue after last update

No luck here, I’ve tried the following touch ~/.local/share/akonadi/db_data/ib_logfile0 (this created the file) removing akonadi config folder: mv ~/.local/share/akonadi ~/.local/share/akonadi_BACKUP reinstall akonadi But nothing worked. I always end up with this message: konadictl start  org.kde.pim.akonadictl: Starting Akonadi Server... org.kde.pim.akonadictl: done. Connecting to deprecated…

[whatthe]

Last akonadi update fixed it for me and then

akonadictl stop
rm -rf ~/.local/share/akonadi
akonadictl start