[Akonadi] [Bug 456983] mysql.err.old grows too large (over 20 GB)

[ratijas]

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

--- Comment #1 from ratijas <me at ratijas.tk> ---
Created attachment 152729
  --> https://bugs.kde.org/attachment.cgi?id=152729&action=edit
Akonadi - MySQL errors

These are the prime suspects in causing my btrfs partition failure recently, so
I had to backup-reformat-recover everything. Log files just keep growing, no
matter what. I had three accounts on KMail (not anymore, migrated to
Thunderbird for now). I've never seen any errors in KMail GUI.

~/.local/share/akonadi/db_data/mysql.err file contains mostly errors from bad
DB schema migration. It keeps growing even after removing KMail accounts, so
the next thing I tried is running `akonadictl stop`. The file is full of pairs
of messages:

> 2022-10-11 23:42:45 181 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'hist_type' at position 9 to have type enum('SINGLE_PREC_HB','DOUBLE_PREC_HB','JSON_HB'), found type enum('SINGLE_PREC_HB','DOUBLE_PREC_HB').
> 2022-10-11 23:42:45 181 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'histogram' at position 10 to have type longblob, found type varbinary(255).

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