Akonadi floods its mysql.err with an error message

English Applications
1

Since a few days Akonadi 22.08-1 fills ~/.local/share/akonadi/db_data/mysql.err with the error message

Incorrect definition of table mysql.column_stats: expected column ‘histogram’ at position 10 to have type longblob, found type varbinary(255)

How to fix that problem ?

I assume there was some change of the akonadi database format and I missed the conversion of the old database to the new format due to some unknown reason

2

Assuming username and user id are

Username: username
User ID: 1000


mysql_upgrade --defaults-file=/home/username/.local/share/akonadi/mysql.conf --socket=/run/user/1000/akonadi/mysql.socket
3

Thanks, that solved the problem.

4

Upstream fix just appeared: Run mysql_upgrade on akonadi startup (!130) · Merge requests · PIM / Akonadi · GitLab