MariaDB spamming syslog (GBs per day)

[Justin_Zobel]

The Basics

• Nextcloud Server version (e.g., 29.x.x):
  • 30.0.2
• Operating system and version (e.g., Ubuntu 24.04):
  • Ubuntu 24.04.1
• Is this the first time you’ve seen this error? (Yes / No):
  • Yes
• When did this problem seem to first start?
  • In the last few days
• Installation method (e.g. AIO, NCP, Bare Metal/Archive, etc.)
  • Archive
• Are you using Cloudflare, mod_security, or similar? (Yes / No)
  • No

Summary of the issue you are facing:

MariaDB is hammering the logs with issues about the database

Log entries

2024-12-09T23:56:40.988354+00:00 hostname mariadbd[25354]: 2024-12-09 23:56:40 24758596 [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').

[Sanook]

Did you update Nextcloud and not disable unsupported apps before?

[Justin_Zobel]

Not that I recall. I usually wait for all apps to be compatible before upgrading.

[jtr]

Not a Nextcloud matter. The gist is that it sounds like you upgraded MariaDB at some point without running mariadb-upgrade. See:

MariaDB: mariadb-upgrade

and

MariaDB: Upgrading Between Major MariaDB Versions

In the MariaDB Docker image, the parameter is MARIADB_AUTO_UPGRADE.