Docker upgrade 4.0.2 to 4.0.3 error

[real]

Hi,

after the upgrade, the cms does not want to restart.
A priori the mysql is no longer up to date.
Do you have an idea to fix this?

Thanks

2023-09-28T00:59:52.934021Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.34) starting as process 1
cms-db_1          | 2023-09-28T00:59:52.941415Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
cms-db_1          | 2023-09-28T00:59:53.320389Z 1 [ERROR] [MY-013171] [InnoDB] Cannot boot server version 80034 on data directory built by version 80100. Downgrade is not supported
cms-db_1          | mysqld: Can't open file: 'mysql.ibd' (errno: 0 - )
cms-db_1          | 2023-09-28T00:59:53.641981Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
cms-db_1          | 2023-09-28T00:59:53.642597Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
cms-db_1          | 2023-09-28T00:59:53.642711Z 0 [ERROR] [MY-010119] [Server] Aborting
cms-db_1          | 2023-09-28T00:59:53.644356Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.34)  MySQL Community Server - GPL.
cms-db_1          | 2023-09-28 01:00:54+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.34-1.el8 started.
cms-db_1          | 2023-09-28 01:00:54+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
cms-db_1          | 2023-09-28 01:00:54+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.34-1.el8 started.
cms-db_1          | '/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
cms-db_1          | 2023-09-28T01:00:55.346373Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.

uname -a

Linux xibo 6.1.0-12-amd64 #1 SMP PREEMPT_DYNAMIC Debian 6.1.52-1 (2023-09-07) x86_64 GNU/Linux

[natasha]

You are seeing this error as you have previously used MySQL 8.1 and the 4.0.0 release containers onwards specify MySQL 8.0 as that is what we support.

If you want to use MySQL 8 you can edit the docker compose file for 8.1:

• Start the MySQL server up
• Dump the data to a file with mysqldump --hex-blob --quick --single-transaction
• Edit it back to 8.0
• Down the containers
• Delete shared/db
• Put the backup as shared/backup/import.sql and then up the containers again

You would probably be OK changing the docker-compose file to use MySQL 8.1, but just to note its literally a few weeks old and we have not tested it.