Container keeps Restaring

[f908]

2023-11-01T03:48:44.104653Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.35) starting as process 1
2023-11-01T03:48:44.132753Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-11-01T03:48:44.900288Z 1 [ERROR] [MY-014061] [InnoDB] Invalid MySQL server downgrade: Cannot downgrade from 80200 to 80035. Downgrade is only permitted between patch releases.
mysqld: Can't open file: 'mysql.ibd' (errno: 0 - )
2023-11-01T03:48:45.221705Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2023-11-01T03:48:45.222491Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2023-11-01T03:48:45.222596Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-11-01T03:48:45.223613Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.35)  MySQL Community Server - GPL.
2023-11-01 03:48:46+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.35-1.el8 started.
2023-11-01 03:48:47+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2023-11-01 03:48:47+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.35-1.el8 started.
'/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
2023-11-01T03:48:48.478140Z 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.
2023-11-01T03:48:48.481542Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.35) starting as process 1
2023-11-01T03:48:48.499976Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-11-01T03:48:49.228992Z 1 [ERROR] [MY-014061] [InnoDB] Invalid MySQL server downgrade: Cannot downgrade from 80200 to 80035. Downgrade is only permitted between patch releases.
mysqld: Can't open file: 'mysql.ibd' (errno: 0 - )
2023-11-01T03:48:49.583114Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2023-11-01T03:48:49.583758Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2023-11-01T03:48:49.584107Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-11-01T03:48:49.585252Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.35)  MySQL Community Server - GPL.
2023-11-01 03:48:51+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.35-1.el8 started.
2023-11-01 03:48:51+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2023-11-01 03:48:52+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.35-1.el8 started.
'/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
2023-11-01T03:48:52.948560Z 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.
2023-11-01T03:48:52.951963Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.35) starting as process 1
2023-11-01T03:48:52.972128Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-11-01T03:48:53.591062Z 1 [ERROR] [MY-014061] [InnoDB] Invalid MySQL server downgrade: Cannot downgrade from 80200 to 80035. Downgrade is only permitted between patch releases.
mysqld: Can't open file: 'mysql.ibd' (errno: 0 - )
2023-11-01T03:48:54.065923Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2023-11-01T03:48:54.066408Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2023-11-01T03:48:54.066473Z 0 [ERROR] [MY-010119] [Server] Aborting
2023-11-01T03:48:54.067494Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.35)  MySQL Community Server - GPL.
2023-11-01 03:48:56+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.35-1.el8 started.
2023-11-01 03:48:57+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2023-11-01 03:48:57+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.35-1.el8 started.
'/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
2023-11-01T03:48:58.775531Z 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.
2023-11-01T03:48:58.779041Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.35) starting as process 1
2023-11-01T03:48:58.802998Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.

[yosifkit]

Invalid MySQL server downgrade: Cannot downgrade from 80200 to 80035

It looks like you ran your database files with mysql:8.2.0 (currently also tagged as 8.2, 8, innovation, latest, 8.2.0-oracle, 8.2-oracle, 8-oracle, innovation-oracle, oracle) and then tried to run them with mysql:8.0.35 (tagged as 8.0, 8.0.35-oracle, 8.0-oracle). From the mysqld error and the release notes this isn't a supported direction:

Downgrade from MySQL 8.2 to MySQL 8.1, or from a MySQL 8.2 release to a previous MySQL 8.2 release, is not supported. The only supported alternative is to restore a backup taken before upgrading. It is therefore imperative that you back up your data before starting the upgrade process.

- https://dev.mysql.com/doc/relnotes/mysql/8.2/en/

If you have important data and want to go back to MySQL 8.0, then you'll might be able to dump it while running 8.2 and then restore to a fresh 8.0 instance (not sure if that works). Alternatively, you could just stay on 8.2 and update your docker run line or docker-compose.yml file to a specific MySQL version.

[f908]

Invalid MySQL server downgrade: Cannot downgrade from 80200 to 80035

It looks like you ran your database files with mysql:8.2.0 (currently also tagged as 8.2, 8, innovation, latest, 8.2.0-oracle, 8.2-oracle, 8-oracle, innovation-oracle, oracle) and then tried to run them with mysql:8.0.35 (tagged as 8.0, 8.0.35-oracle, 8.0-oracle). From the mysqld error and the release notes this isn't a supported direction:

Downgrade from MySQL 8.2 to MySQL 8.1, or from a MySQL 8.2 release to a previous MySQL 8.2 release, is not supported. The only supported alternative is to restore a backup taken before upgrading. It is therefore imperative that you back up your data before starting the upgrade process.

• https://dev.mysql.com/doc/relnotes/mysql/8.2/en/

If you have important data and want to go back to MySQL 8.0, then you'll might be able to dump it while running 8.2 and then restore to a fresh 8.0 instance (not sure if that works). Alternatively, you could just stay on 8.2 and update your docker run line or docker-compose.yml file to a specific MySQL version.

Thanks, closing now