Mariadb : Incorrect definition of table mysql.column_stats

[marcolefo]

Hi

Since 3 days I have this error in /var/log/mysql/error.log 3 times by second :

2025-04-03 12:11:38 5 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'histogram' at position 10 to have type longblob, found type varbinary(255).
2025-04-03 12:11:38 5 [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').

I have done what I have written here :
https://forums.fogproject.org/topic/17849/fogtaskscheduler-100-cpu

Do you think there is a link ?

Other symptom, after clone a system to the server, the image stays in /images/dev/<@mac> and doesn’t go to /images/.

Thanks

[marcolefo]

@marcolefo

Okay nothing to do with FOG

ALTER TABLE mysql.column_stats MODIFY histogram longblob;
ALTER TABLE mysql.column_stats MODIFY hist_type enum('SINGLE_PREC_HB','DOUBLE_PREC_HB','JSON_HB');

Sorry for the noise

[marcolefo]

@marcolefo said in Mariadb : Incorrect definition of table mysql.column_stats:

Incorrect definition of table mysql.column_stats

Oh ! There was an update of Mariadb

2025-04-03 12:28:20 status installed mariadb-server-10.5:amd64 1:10.11.11-0+deb12u1
2025-04-03 12:28:20 remove mariadb-server-10.5:amd64 1:10.11.11-0+deb12u1 <none>
2025-04-03 12:28:20 status half-configured mariadb-server-10.5:amd64 1:10.11.11-0+deb12u1
2025-04-03 12:28:20 status half-installed mariadb-server-10.5:amd64 1:10.11.11-0+deb12u1
2025-04-03 12:28:20 status config-files mariadb-server-10.5:amd64 1:10.11.11-0+deb12u1

I will check that

[marcolefo]

@marcolefo

Okay nothing to do with FOG

ALTER TABLE mysql.column_stats MODIFY histogram longblob;
ALTER TABLE mysql.column_stats MODIFY hist_type enum('SINGLE_PREC_HB','DOUBLE_PREC_HB','JSON_HB');

Sorry for the noise