Bug#1032240: akonadi server fails to start since it cannot connect to mysql database
Package: akonadi-backend-mysql
Version: 4:22.12.2-1
Severity: grave
X-Debbugs-Cc: cquike@arcor.de
I cannot use my kmail email client due to akonadi server not being started. To
debug it I have tried the following:
# akonadictl start
org.kde.pim.akonadictl: Starting Akonadi Server...
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/sbin/mysqld"
org.kde.pim.akonadiserver: arguments: ("--defaults-
file=/home/cgarcia/.local/share/akonadi/mysql.conf", "--
datadir=/home/cgarcia/.local/share/akonadi/db_data/", "--
socket=/run/user/4876/akonadi/mysql.socket", "--pid-
file=/run/user/4876/akonadi/mysql.pid")
org.kde.pim.akonadiserver: stdout: ""
org.kde.pim.akonadiserver: stderr: ""
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...
So apparently mysql cannot be started. I have tried to manually start mysql but
I get the following message:
# /usr/sbin/mysqld --verbose --defaults-
file=/home/cgarcia/.local/share/akonadi/mysql.conf
--datadir=/home/cgarcia/.local/share/akonadi/db_data/
--socket=/run/user/4876/akonadi/mysql.socket --pid-
file=/run/user/4876/akonadi/mysql.pid
2023-03-02 9:21:47 0 [Note] Starting MariaDB 10.11.2-MariaDB-1 source revision
as process 13921
2023-03-02 9:21:48 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
2023-03-02 9:21:48 0 [Note] InnoDB: Number of transaction pools: 1
2023-03-02 9:21:48 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2023-03-02 9:21:48 0 [Note] InnoDB: Using liburing
2023-03-02 9:21:48 0 [Note] InnoDB: Initializing buffer pool, total size =
128.000MiB, chunk size = 2.000MiB
2023-03-02 9:21:48 0 [Note] InnoDB: Completed initialization of buffer pool
2023-03-02 9:21:48 0 [Note] InnoDB: File system buffers for log disabled
(block size=512 bytes)
2023-03-02 9:21:48 0 [ERROR] InnoDB: Upgrade after a crash is not supported.
The redo log was created with MariaDB 10.6.11. You must start up and shut down
MariaDB 10.7 or earlier.
2023-03-02 9:21:48 0 [ERROR] InnoDB: Plugin initialization aborted with error
Generic error
2023-03-02 9:21:48 0 [Note] InnoDB: Starting shutdown...
2023-03-02 9:21:48 0 [ERROR] Plugin 'InnoDB' init function returned error.
2023-03-02 9:21:48 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE
failed.
2023-03-02 9:21:48 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-03-02 9:21:48 0 [ERROR] Could not open mysql.plugin table: "Table
'mysql.plugin' doesn't exist". Some plugins may be not loaded
2023-03-02 9:21:48 0 [ERROR] /usr/sbin/mysqld: unknown variable 'defaults-
file=/home/cgarcia/.local/share/akonadi/mysql.conf'
2023-03-02 9:21:48 0 [ERROR] Aborting
That renders all KDE PIM applications unusable in Debian Bookworm.
-- System Information:
Debian Release: bookworm/sid
APT prefers testing
APT policy: (500, 'testing')
Architecture: amd64 (x86_64)
Kernel: Linux 6.1.0-5-amd64 (SMP w/8 CPU threads; PREEMPT)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8), LANGUAGE=en_US:en
Shell: /bin/sh linked to /usr/bin/dash
Init: systemd (via /run/systemd/system)
LSM: AppArmor: enabled
Versions of packages akonadi-backend-mysql depends on:
ii default-mysql-client-core 1.1.0
ii default-mysql-server-core 1.1.0
ii libqt5sql5-mysql 5.15.8+dfsg-2
ii mariadb-client-core [virtual-mysql-client-core] 1:10.11.2-1
ii mariadb-server-core [virtual-mysql-server-core] 1:10.11.2-1
Versions of packages akonadi-backend-mysql recommends:
ii akonadi-server 4:22.12.2-1
akonadi-backend-mysql suggests no packages.
-- no debconf information
Reply to: