Filling disks with gobs of gigabytes of Mariadb log messages

Hi – after pouring time into finding out why my website virtual disk ran out of space, I found the culprit. It’s /var/log/mariadb/mariadb.log. Every time anyone accesses my website, it logs errors like these:

2024-08-09 12:45:26 88090 [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’).
2024-08-09 12:45:26 88090 [ERROR] Incorrect definition of table mysql.column_stats: expected column ‘histogram’ at position 10 to have type longblob, found type varbinary(255).
2024-08-09 12:45:26 88090 [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’).
2024-08-09 12:45:26 88090 [ERROR] Incorrect definition of table mysql.column_stats: expected column ‘histogram’ at position 10 to have type longblob, found type varbinary(255).

This happens on multiple websites with multiple themes, all running 6.6.1, which makes it feel like a WordPress bug. How do we fix it?

(Edited later) Forgot to add versions. Hosted on a Fedora 40 VM with mariadb-server-10.11.8-3.fc40.x86_64

thanks

• Greg Scott

• This topic was modified 7 months, 2 weeks ago by gregscott.

The page I need help with: [log in to see the link]