Filling disks with gobs of gigabytes of Mariadb log messages

[ad_1]

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

  • This topic was modified 4 hours, 32 minutes ago by gregscott.

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

 

This site will teach you how to build a WordPress website for beginners. We will cover everything from installing WordPress to adding pages, posts, and images to your site. You will learn how to customize your site with themes and plugins, as well as how to market your site online.

Buy WordPress Transfer