docs
docs copied to clipboard
Incorrect definition of table mysql.column_stats: after upgrade from 10.6.5 to 10.8.3 with docker container
After upgrading the mariadb docker-container from 10.6.5 to 10.8.3 I am getting the following errors and the container crashes within a few seconds:
sqb_mariadb | 2022-06-18 13:59:13 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').
sqb_mariadb | 2022-06-18 13:59:13 4 [ERROR] Incorrect definition of table
mysql.column_stats: expected column 'histogram' at
position 10 to have type longblob, found type varbinary(255).
...
sqb_mariadb | 2022-06-18 13:59:13+00:00 [Note] [Entrypoint]: Backing up complete
sqb_mariadb | 2022-06-18 13:59:13+00:00 [Note] [Entrypoint]: Starting mariadb-upgrade
sqb_mariadb | Reading datadir from the MariaDB server failed. Got the following error when executing the 'mysql' command line client
sqb_mariadb | ERROR 2002 (HY000): Can't connect to server on 'sqb_mariadb' (115)
sqb_mariadb | FATAL ERROR: Upgrade failed
The container is started through docker-compose:
version: '3'
services:
sqb_mariadb:
image: mariadb:latest
container_name: sqb_mariadb
command: --transaction-isolation=READ-COMMITTED --binlog-format=ROW --innodb_read_only_compressed=OFF
restart: unless-stopped
volumes:
- mariadb:/var/lib/mysql
environment:
- MYSQL_ROOT_PASSWORD=${MYSQL_ROOT_PASSWORD}
- MYSQL_PASSWORD=${MYSQL_PASSWORD}
- MYSQL_DATABASE=sqb_nextcloud
- MYSQL_ROOT_USER=root
- MYSQL_HOST=sqb_mariadb
- MYSQL_USER=sqb_admin
- MARIADB_AUTO_UPGRADE=1
- MARIADB_INITDB_SKIP_TZINFO=1
Repairing this like mentioned here: https://github.com/photoprism/photoprism/issues/2382 or here: https://community.home-assistant.io/t/mariadb-errors-after-update/424731/4 doesn't work due to the immediate crashing of the container.
Any hint on how to resolve the issue is appreciated!!!
Setting the version back to 10.6.5 leaves me with another error:
sqb_mariadb | 2022-06-18 14:17:05 0 [ERROR] InnoDB: Unsupported redo log format. The redo log was created with MariaDB 10.8.3.
sqb_mariadb | 2022-06-18 14:17:05 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
sqb_mariadb | 2022-06-18 14:17:05 0 [Note] InnoDB: Starting shutdown...
sqb_mariadb | 2022-06-18 14:17:06 0 [ERROR] Plugin 'InnoDB' init function returned error.
sqb_mariadb | 2022-06-18 14:17:06 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
sqb_mariadb | 2022-06-18 14:17:06 0 [Note] Plugin 'FEEDBACK' is disabled.
sqb_mariadb | 2022-06-18 14:17:06 0 [ERROR] Unknown/unsupported storage engine: InnoDB
sqb_mariadb | 2022-06-18 14:17:06 0 [ERROR] Aborting
https://jira.mariadb.org/browse/MDEV-28866 is the issue.
https://github.com/MariaDB/mariadb-docker/issues/439 or the JIRA above is a better place to report MariaDB issues.
https://jira.mariadb.org/browse/MDEV-28866 is the issue.
MariaDB/mariadb-docker#439 or the JIRA above is a better place to report MariaDB issues.
Thank you for your fast response. The solution mentioned in (MariaDB/mariadb-docker/issues/439)[https://github.com/MariaDB/mariadb-docker/issues/439] unfortunately doesn't work for me. MARIADB_AUTO_UPGRADE=1
is already set.
Did I miss something in the links?
Sorry for loosing track. The "other error" is downgrades aren't supported, you can't start up a 10.8 server shutdown and downgrade to 10.6.