[Akonadi] [Bug 439769] Akonadi fails with Mariadb 10.6.3

[Ricardo J. Barberis]

https://bugs.kde.org/show_bug.cgi?id=439769

--- Comment #3 from Ricardo J. Barberis <ricardo.barberis at gmail.com> ---
I had already done a mysql_upgrade and akonadi's mysqld wouldn't start, so in
case this helps other people with a broken akonadi, here's what I did (YMMV):


- Under "[mysqld]" in ~/.local/share/akonadi/mysql.conf I added:

"innodb_force_recovery = 2"

- Made sure it and akonadi were not running, and started mysqld with:

/usr/libexec/mysqld
--defaults-file=/home/myuser/.local/share/akonadi/mysql.conf
--datadir=/home/myuser/.local/share/akonadi/db_data/
--socket=/run/user/1000/akonadi/mysql.socket
--pid-file=/run/user/1000/akonadi/mysql.pid &

- Then I backed up akonadi's DB and deleted it after:

mysqldump -Q --socket=/run/user/1000/akonadi/mysql.socket --add-drop-table
akonadi > akonadi.sql
mysql--socket=/run/user/1000/akonadi/mysql.socket -e "DROP DATABASE akonadi"

- Stoped mysql:

mysqladmin -Q --socket=/run/user/1000/akonadi/mysql.socket shutdown

- Downgraded MariaDB 10.6.4 to 10.5.11 and started akonadi to recreate its
database:

akonadictl start

- After a few seconds I stopped akonadi and restored the SQL dump:

/usr/libexec/mysqld
--defaults-file=/home/myuser/.local/share/akonadi/mysql.conf
--datadir=/home/myuser/.local/share/akonadi/db_data/
--socket=/run/user/1000/akonadi/mysql.socket
--pid-file=/run/user/1000/akonadi/mysql.pid &

mysql --socket=/run/user/1000/akonadi/mysql.socket -e akonadi < akonadi.sql

- Shut down mysql, started akonadi again:

mysqladmin -Q --socket=/run/user/1000/akonadi/mysql.socket shutdown
akonadictl start

- Started kmail and everything looks good so far!


(Before trying all of this , out of caution, I made a backup of my mail folder
and everything related to akonadi and kmail I found under ~/.cache/, ~/.config/
and ~/.local/)

-- 
You are receiving this mail because:
You are the assignee for the bug.