Incorrect definition of table mysql.column_stats: expected column 'histogram' at position 10 to have type longblob, found type varbinary(255)

ℹ️ Support
1

Although all seems to run fine, when I call the page /settings/admin/overview in my browser, I get these errors in my log

 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'histogram' at position 10 to have type longblob, found type varbinary(255).

 [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').

Nextcloud version : 24
Operating system and version (eg, Ubuntu 20.04): docker with mariadb and PHP 8.0.23

if I look at the table, I see the fields:

# docker exec next${D}_db_1 mysql nextcloud -p$MYSQL_ROOT_PASSWORD -e "show fields from mysql.column_stats "                                                             
Field   Type    Null    Key     Default Extra
db_name varchar(64)     NO      PRI     NULL
table_name      varchar(64)     NO      PRI     NULL
column_name     varchar(64)     NO      PRI     NULL
min_value       varbinary(255)  YES             NULL
max_value       varbinary(255)  YES             NULL
nulls_ratio     decimal(12,4)   YES             NULL
avg_length      decimal(12,4)   YES             NULL
avg_frequency   decimal(12,4)   YES             NULL
hist_size       tinyint(3) unsigned     YES             NULL
hist_type       enum('SINGLE_PREC_HB','DOUBLE_PREC_HB') YES             NULL
histogram       varbinary(255)  YES             NULL
2

fixed with:

docker exec next${D}_db_1 mysql nextcloud -p$MYSQL_ROOT_PASSWORD -e "ALTER TABLE mysql.column_stats MODIFY histogram longblob;"
docker exec next${D}_db_1 mysql nextcloud -p$MYSQL_ROOT_PASSWORD -e "ALTER TABLE mysql.column_stats MODIFY hist_type enum('SINGLE_PREC_HB','DOUBLE_PREC_HB','JSON_HB');"
3 Likes
3

same problem solved for

Incorrect definition of table mysql.event: expected column 'definer' at position 3 to have type varchar(, found type char(141).

with

docker exec next${D}_db_1 mysql nextcloud -p$MYSQL_ROOT_PASSWORD -e "ALTER TABLE mysql.event MODIFY definer varchar(255);"
4

Solved it for me after upgrade (docker compose pull + up), thanks!