docker compose 1.18.1 启动失败

[liukaifei]

docker compose 1.18.1 启动失败，看是mysql 启动失败，日志如下：
2024-07-10 15:17:57+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.4.1-1.el9 started.
2024-07-10 15:17:58+08:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2024-07-10 15:17:58+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.4.1-1.el9 started.
2024-07-10 15:17:58+08:00 [Note] [Entrypoint]: Initializing database files
2024-07-10T07:17:58.813034Z 0 [System] [MY-015017] [Server] MySQL Server Initialization - start.
2024-07-10T07:17:58.816797Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.4.1) initializing of server in progress as process 79
2024-07-10T07:17:58.832019Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-07-10T07:17:59.284793Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-07-10T07:18:03.376642Z 0 [ERROR] [MY-000068] [Server] unknown option '--skip-character-set-client-handshake'.
2024-07-10T07:18:03.378044Z 0 [ERROR] [MY-013236] [Server] The designated data directory /var/lib/mysql/ is unusable. You can remove all files that the server added to it.
2024-07-10T07:18:03.378078Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-07-10T07:18:04.984443Z 0 [System] [MY-015018] [Server] MySQL Server Initialization - end.
2024-07-10 15:18:06+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.4.1-1.el9 started.
2024-07-10 15:18:06+08:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2024-07-10 15:18:06+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.4.1-1.el9 started.
'/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
2024-07-10T07:18:07.555235Z 0 [System] [MY-015015] [Server] MySQL Server - start.
2024-07-10T07:18:07.897888Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.4.1) starting as process 1
2024-07-10T07:18:07.913952Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-07-10T07:18:08.492206Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
mysqld: Table 'mysql.plugin' doesn't exist
2024-07-10T07:18:08.758246Z 0 [ERROR] [MY-010735] [Server] Could not open the mysql.plugin table. Please perform the MySQL upgrade procedure.
2024-07-10T07:18:08.758646Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2024-07-10T07:18:08.758860Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2024-07-10T07:18:08.759025Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2024-07-10T07:18:08.759323Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2024-07-10T07:18:08.759505Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2024-07-10T07:18:08.760103Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2024-07-10T07:18:08.762578Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2024-07-10T07:18:08.889167Z 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2024-07-10T07:18:08.951524Z 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2024-07-10T07:18:08.958642Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2024-07-10T07:18:08.959284Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2024-07-10T07:18:08.964696Z 0 [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.
2024-07-10T07:18:08.966143Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2024-07-10T07:18:08.966820Z 0 [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
2024-07-10T07:18:08.966887Z 0 [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.
2024-07-10T07:18:08.967110Z 0 [ERROR] [MY-000068] [Server] unknown option '--skip-character-set-client-handshake'.
2024-07-10T07:18:08.968390Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-07-10T07:18:10.266373Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.4.1) MySQL Community Server - GPL.
2024-07-10T07:18:10.266399Z 0 [System] [MY-015016] [Server] MySQL Server - end.

[chuntaojun]

这个会在下一版本修复，当前 mysql 的 docker-compose 文件可以看下最新的 main 分支下的

[chuntaojun]

https://github.com/polarismesh/polaris/tree/main/release/standalone/docker-compose/mysql

[liukaifei]

https://github.com/polarismesh/polaris/tree/main/release/standalone/docker-compose/mysql

明白，谢谢！

[StringKe]

替换后单机启动出现这个错误

2024-08-29 10:49:00+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.4.2-1.el9 started.
2024-08-29 10:49:01+08:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2024-08-29 10:49:01+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.4.2-1.el9 started.
'/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
2024-08-29T02:49:02.716432Z 0 [System] [MY-015015] [Server] MySQL Server - start.
2024-08-29T02:49:02.901647Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.4.2) starting as process 1
2024-08-29T02:49:02.945161Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-08-29T02:49:03.109855Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
mysqld: Table 'mysql.plugin' doesn't exist
2024-08-29T02:49:03.241204Z 0 [ERROR] [MY-010735] [Server] Could not open the mysql.plugin table. Please perform the MySQL upgrade procedure.
2024-08-29T02:49:03.242992Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2024-08-29T02:49:03.243465Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2024-08-29T02:49:03.243837Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2024-08-29T02:49:03.244080Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2024-08-29T02:49:03.244186Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2024-08-29T02:49:03.244298Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2024-08-29T02:49:03.244431Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2024-08-29T02:49:03.282109Z 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2024-08-29T02:49:03.361039Z 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2024-08-29T02:49:03.396854Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2024-08-29T02:49:03.396911Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2024-08-29T02:49:03.403255Z 0 [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.
2024-08-29T02:49:03.404668Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2024-08-29T02:49:03.405301Z 0 [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
2024-08-29T02:49:03.405335Z 0 [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.
2024-08-29T02:49:03.405687Z 0 [ERROR] [MY-000067] [Server] unknown variable 'default-authentication-plugin=mysql_native_password'.
2024-08-29T02:49:03.406645Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-08-29T02:49:04.956958Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.4.2)  MySQL Community Server - GPL.
2024-08-29T02:49:04.956990Z 0 [System] [MY-015016] [Server] MySQL Server - end.

[chuntaojun]

可以参考下main分支的mysql的镜像版本，手段设置为 8.0.23:https://github.com/polarismesh/polaris/tree/main/release/standalone/docker-compose/mysql