dataelement
bisheng-mysql start fail
[root@controller-61 docker]# docker-compose up -d
[+] Running 7/7
✔ Container milvus-etcd Running 0.0s
✔ Container bisheng-es Running 0.0s
✔ Container bisheng-office Running 0.0s
✔ Container milvus-minio Running 0.0s
✘ Container bisheng-mysql Error 1.6s
✔ Container bisheng-redis Healthy 1.1s
✔ Container milvus-standalone Running 0.0s
dependency failed to start: container bisheng-mysql is unhealthy
[root@controller-61 docker]# docker logs -f bisheng-mysql
2025-05-15 20:44:31+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.42-1.el9 started.
2025-05-15 20:44:31+08:00 [Note] [Entrypoint]: Initializing database files
2025-05-15T12:44:31.501540Z 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.
2025-05-15T12:44:31.501633Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.42) initializing of server in progress as process 41
2025-05-15T12:44:31.506681Z 0 [Warning] [MY-010001] [Server] Can't create thread to handle bootstrap (errno: 1)
2025-05-15T12:44:31.506714Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2025-05-15T12:44:31.506723Z 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.
2025-05-15T12:44:31.506731Z 0 [ERROR] [MY-010119] [Server] Aborting
2025-05-15T12:44:31.507061Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.42) MySQL Community Server - GPL.
2025-05-15 20:44:32+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.42-1.el9 started.
2025-05-15 20:44:32+08:00 [Note] [Entrypoint]: Initializing database files
2025-05-15T12:44:32.254959Z 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.
2025-05-15T12:44:32.255064Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.42) initializing of server in progress as process 41
2025-05-15T12:44:32.256638Z 0 [ERROR] [MY-010457] [Server] --initialize specified but the data directory has files in it. Aborting.
2025-05-15T12:44:32.256645Z 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.
2025-05-15T12:44:32.256682Z 0 [ERROR] [MY-010119] [Server] Aborting
2025-05-15T12:44:32.256787Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.42) MySQL Community Server - GPL.
2025-05-15 20:44:32+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.42-1.el9 started.
2025-05-15 20:44:33+08:00 [Note] [Entrypoint]: Initializing database files
2025-05-15T12:44:33.060449Z 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.
2025-05-15T12:44:33.060545Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.42) initializing of server in progress as process 41
2025-05-15T12:44:33.062157Z 0 [ERROR] [MY-010457] [Server] --initialize specified but the data directory has files in it. Aborting.
2025-05-15T12:44:33.062164Z 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.
2025-05-15T12:44:33.062208Z 0 [ERROR] [MY-010119] [Server] Aborting
2025-05-15T12:44:33.062322Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.42) MySQL Community Server - GPL.
2025-05-15 20:44:33+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.42-1.el9 started.
2025-05-15 20:44:34+08:00 [Note] [Entrypoint]: Initializing database files
2025-05-15T12:44:34.068962Z 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.
2025-05-15T12:44:34.069067Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.42) initializing of server in progress as process 41
2025-05-15T12:44:34.070521Z 0 [ERROR] [MY-010457] [Server] --initialize specified but the data directory has files in it. Aborting.
2025-05-15T12:44:34.070527Z 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.
2025-05-15T12:44:34.070569Z 0 [ERROR] [MY-010119] [Server] Aborting
2025-05-15T12:44:34.070666Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.42) MySQL Community Server - GPL.
2025-05-15 20:44:35+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.42-1.el9 started.
2025-05-15 20:44:35+08:00 [Note] [Entrypoint]: Initializing database files
2025-05-15T12:44:35.514608Z 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.
2025-05-15T12:44:35.514700Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.42) initializing of server in progress as process 41
2025-05-15T12:44:35.516277Z 0 [ERROR] [MY-010457] [Server] --initialize specified but the data directory has files in it. Aborting.
2025-05-15T12:44:35.516283Z 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.
2025-05-15T12:44:35.516321Z 0 [ERROR] [MY-010119] [Server] Aborting
2025-05-15T12:44:35.516424Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.42) MySQL Community Server - GPL.
@lizcao 即使我使用了v1.1.0 的版本，还是会有这个问题； [root@controller-61 docker]# pwd /mnt/openebs/bisheng-1.1.0/docker [root@controller-61 docker]# docker-compose up -d [+] Running 7/7 ✔ Container bisheng-redis Healthy 0.5s ✔ Container bisheng-es Running 0.0s ✔ Container milvus-etcd Running 0.0s ✔ Container bisheng-office Running 0.0s ✔ Container milvus-minio Running 0.0s ✔ Container milvus-standalone Running 0.0s ✘ Container bisheng-mysql Error 0.5s dependency failed to start: container bisheng-mysql is unhealthy [root@controller-61 docker]# docker logs -f bisheng-mysql 2025-05-16 16:24:33+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.42-1.el9 started. 2025-05-16 16:24:34+08:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql' 2025-05-16 16:24:34+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.42-1.el9 started. 2025-05-16 16:24:34+08:00 [Note] [Entrypoint]: Initializing database files 2025-05-16T08:24:34.223836Z 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. 2025-05-16T08:24:34.223950Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.42) initializing of server in progress as process 81 2025-05-16T08:24:34.253884Z 0 [Warning] [MY-010001] [Server] Can't create thread to handle bootstrap (errno: 1) 2025-05-16T08:24:34.253923Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed. 2025-05-16T08:24:34.253931Z 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. 2025-05-16T08:24:34.253937Z 0 [ERROR] [MY-010119] [Server] Aborting 2025-05-16T08:24:34.254320Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.42) MySQL Community Server - GPL. 2025-05-16 16:24:34+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.42-1.el9 started. 2025-05-16 16:24:35+08:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql' 2025-05-16 16:24:35+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.42-1.el9 started. 2025-05-16 16:24:35+08:00 [Note] [Entrypoint]: Initializing database files 2025-05-16T08:24:35.225736Z 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. 2025-05-16T08:24:35.225868Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.42) initializing of server in progress as process 80 2025-05-16T08:24:35.227566Z 0 [ERROR] [MY-010457] [Server] --initialize specified but the data directory has files in it. Aborting. 2025-05-16T08:24:35.227575Z 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. 2025-05-16T08:24:35.227628Z 0 [ERROR] [MY-010119] [Server] Aborting 2025-05-16T08:24:35.227775Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.42) MySQL Community Server - GPL. 2025-05-16 16:24:35+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.42-1.el9 started. 2025-05-16 16:24:36+08:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql' 2025-05-16 16:24:36+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.42-1.el9 started. 2025-05-16 16:24:36+08:00 [Note] [Entrypoint]: Initializing database files 2025-05-16T08:24:36.187100Z 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. 2025-05-16T08:24:36.187193Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.42) initializing of server in progress as process 80 2025-05-16T08:24:36.188642Z 0 [ERROR] [MY-010457] [Server] --initialize specified but the data directory has files in it. Aborting. 2025-05-16T08:24:36.188647Z 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. 2025-05-16T08:24:36.188685Z 0 [ERROR] [MY-010119] [Server] Aborting 2025-05-16T08:24:36.188784Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.42) MySQL Community Server - GPL. 2025-05-16 16:24:37+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.42-1.el9 started. 2025-05-16 16:24:37+08:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql' 2025-05-16 16:24:37+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.42-1.el9 started. 2025-05-16 16:24:37+08:00 [Note] [Entrypoint]: Initializing database files 2025-05-16T08:24:37.427219Z 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. 2025-05-16T08:24:37.427331Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.42) initializing of server in progress as process 80 2025-05-16T08:24:37.429015Z 0 [ERROR] [MY-010457] [Server] --initialize specified but the data directory has files in it. Aborting. 2025-05-16T08:24:37.429023Z 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. 2025-05-16T08:24:37.429070Z 0 [ERROR] [MY-010119] [Server] Aborting 2025-05-16T08:24:37.429204Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.42) MySQL Community Server - GPL.
还会出现这个问题； [root@controller-61 docker]# docker-compose up -d [+] Running 9/10 ✔ Network docker_default Created 0.0s ✔ Container milvus-etcd Started 0.7s ⠧ Container bisheng-mysql Starting 1.0s ✔ Container milvus-minio Started 1.0s ✔ Container bisheng-redis Started 1.0s ✔ Container bisheng-es Started 0.7s ✔ Container bisheng-office Started 0.8s ✔ Container milvus-standalone Created 0.0s ✔ Container bisheng-backend Created 0.0s ✔ Container bisheng-frontend Created 0.0s Error response from daemon: driver failed programming external connectivity on endpoint bisheng-mysql (b72e7cf597d6a75d759d1b718b75730b81383b314de9430dfc2b6bc36305b92f): Bind for 0.0.0.0:3306 failed: port is already allocated [root@controller-61 docker]# netstat -ntlp|grep 3306
