[debian-mysql] Bug#993219: Bug#993219: mariadb-server-core: Akonadi database - mysql_upgrade fails always with "FATAL ERROR: Can't execute 'mysqlcheck'"

[Ulrich Beckmann]

The user in the forum has already  recovered his mails and data, so he won't 
risk the test.

My point is, that in 2 of my 3 debian installations there are errors in the 
MariaDB system tables (see mysql.err). Only the fresh Bullseye installation is 
without errors. Akonadi/Contact/KMail works in any case.

Any attempt to check and correct the tables with mysql_upgrade fails, see the 
attached files. I tested other distributions, ie openSUSE 15.3 e Fedora 34. 
There you can invoke mysql_upgrade as a user without any problem.

Btw. a successful migration should also take care of  the redo logs. The user 
normally does not know, whether the database was shut down correctly or not.

Regards,
Ulrich
-------------- next part --------------
A non-text attachment was scrubbed...
Name: deb#993219_bookworm.log
Type: text/x-log
Size: 5061 bytes
Desc: not available
URL: <http://alioth-lists.debian.net/pipermail/pkg-mysql-maint/attachments/20210903/fd8bc449/attachment.bin>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: deb#993219_bullseye.log
Type: text/x-log
Size: 9847 bytes
Desc: not available
URL: <http://alioth-lists.debian.net/pipermail/pkg-mysql-maint/attachments/20210903/fd8bc449/attachment-0001.bin>