search

jc21 / docker-mariadb-aria

Docker extension of the mariadb image that forces aria storage engine
30 stars 10 forks source link

Incorrect definition of table mysql.column_stats: expected 'hist_type' 'histogram' #13

Closed HomelabHaven closed 10 months ago

HomelabHaven commented 10 months ago

Hello there,

I am not sure if it has to do with the 262c780 commit but I've been seeing the following errors in the docker logs the past day:

2023-11-27 20:37:31 4 [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').

2023-11-27 20:37:31 4 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'histogram' at position 10 to have type longblob, found type varbinary(255).

Is this anything of note or can it be ignored? The nginxproxymanager docker container that relies on the docker-mariadb-aria container is working normally as far as I can tell.

jc21 commented 10 months ago

From this search result, you might try these solutions:

docker exec -ti <name_of_your_docker_container> mysql_upgrade --user=root --password=<root_pwd>

or add this to your docker-compose environment section:

MARIADB_AUTO_UPGRADE: "1"
HomelabHaven commented 10 months ago

The first suggestions worked, thanks.