mysql docker Invalid MySQL server downgrade: Cannot downgrade from ... Downgrade is only permitted between patch Ошибка
Primary tabs
Общая идея
Ниже речь идет о проблемах, которые, похоже, вызваны именно переключениями с одной версией mysql на другую, а также возм. чем-то в хостовой ОС
Подробности
Выясняя почему контейнер завершается после запуска через docker compose в режиме без -d, получили ошибку:
[System] [MY-013576] [InnoDB] InnoDB initialization has started. [ERROR] [MY-014061] [InnoDB] Invalid MySQL server downgrade: Cannot downgrade from 80400 to 80300. Downgrade is only permitted between patch releases. mysqld: Can't open file: 'mysql.ibd' (errno: 0 - ) [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
-- это для 8.3
если же переключить на mysql:latest
то получим:
[System] [MY-015015] [Server] MySQL Server - start. [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.4.0) starting as process 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. [System] [MY-013577] [InnoDB] InnoDB initialization has ended. ktu-migrate_db_mysql | mysqld: Table 'mysql.plugin' doesn't exist [ERROR] [MY-010735] [Server] Could not open the mysql.plugin table. Please perform the MySQL upgrade procedure. [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables...... .............. [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel. [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory. [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables [ERROR] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-001146 - Table 'mysql.component' doesn't exist [Warning] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-003543 - The mysql.component table is missing or has an incorrect definition. [ERROR] [MY-000067] [Server] unknown variable 'default-authentication-plugin=mysql_native_password'. [ERROR] [MY-010119] [Server] Aborting
-- последняя ошибка тут в логе выше:
[ERROR] [MY-000067] [Server] unknown variable 'default-authentication-plugin=mysql_native_password'.
она вызвана судя по всему нашим кофигом:
mysql_old: image: mysql:latest container_name: db_mysql command: --default-authentication-plugin=mysql_native_password volumes: - '../input:/var/www/input'
- Log in to post comments
- 580 reads
vedro-compota
Wed, 06/05/2024 - 00:43
Permalink
mysql docker container exited with code 1
Падаем с сообщением:
-- именно в проекте с несколькими контейнерами, там где один - все нормально,
Причем с флагом -d вроде бы docker compose тоже запускает нормально, контейнер не падает
_____________
матфак вгу и остальная классика =)