Bug#1032240: akonadi server fails to start since it cannot connect to mysql database
Control: tags -1 +moreinfo Control: severity -1 serious On Thursday, April 27, 2023 8:05:50 AM CEST Didier 'OdyX' Raboud wrote: > Le vendredi, 10 mars 2023, 21.04:56 h CEST Patrick Franz a écrit : > > the issue is connected to MariaDB when upgrading after the shutdown was > > not clean, see https://bugs.debian.org/cgi-bin/bugreport.cgi? > > bug=1032047#40 > > > > We are trying to find a solution for this. > > Enrique; the mentionned bug is now fixed; do you still experience your > issue? To me it looks like 1032047 has been fixed with a solution that makes this more likely to happen rather than list. If I understand the fix correctly in that bug, it is ignoring all runnig mariadb's that is not from specific users and just upgrading anyways. That is, to my understanding, the easiest way to hit this is exactly to upgrade mariadb while it is not cleanly shutdown. /Sune -- I didn’t stop pretending when I became an adult, it’s just that when I was a kid I was pretending that I fit into the rules and structures of this world. And now that I’m an adult, I pretend that those rules and structures exist. - zefrank
Bug#1032240: akonadi server fails to start since it cannot connect to mysql database
Control: tags -1 +moreinfo Control: severity -1 important Le vendredi, 10 mars 2023, 21.04:56 h CEST Patrick Franz a écrit : > the issue is connected to MariaDB when upgrading after the shutdown was > not clean, see https://bugs.debian.org/cgi-bin/bugreport.cgi? > bug=1032047#40 > > We are trying to find a solution for this. Enrique; the mentionned bug is now fixed; do you still experience your issue? Best, OdyX signature.asc Description: This is a digitally signed message part.
Bug#1032240: akonadi server fails to start since it cannot connect to mysql database
Hi, the issue is connected to MariaDB when upgrading after the shutdown was not clean, see https://bugs.debian.org/cgi-bin/bugreport.cgi? bug=1032047#40 We are trying to find a solution for this. -- Med vänliga hälsningar Patrick Franz
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: cqu...@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-core1.1.0
ii default-mysql-server-core1.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
