## Issue Description / 问题描述在多台机器上尝试执行docker compose up 容器出现mysql问题，然后执行docker compose build也出现问题 #402
Comments
SOMMTA
changed the title
|
我遇到了相同问题，这是我的成功方法，手动建数据库 time="2024-05-19T09:59:03+08:00" level=warning msg="C:\Users\JackyFeng\Desktop\ai scene\XAgent\docker-compose.yml: Remove-Item : 找不到路径“C:\Users\JackyFeng\Desktop\ai scene\XAgent\mysql_data\”，因为该路径不存在。
PS C:\Users\JackyFeng\Desktop\ai scene\XAgent> docker volume ls DRIVER VOLUME NAME time="2024-05-19T10:03:23+08:00" level=warning msg="C:\Users\JackyFeng\Desktop\ai scene\XAgent\docker-compose.yml: time="2024-05-19T10:09:33+08:00" level=warning msg="C:\Users\JackyFeng\Desktop\ai scene\XAgent\docker-compose.yml: [] [] [
[ bash-5.1# ^C
Copyright (c) 2000, 2024, Oracle and/or its affiliates. Oracle is a registered trademark of Oracle Corporation and/or its Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> SHOW DATABASES; mysql> USE mysql; Database changed mysql> exit What's next? |
|
change docker-compose.yaml to |
Environment / 环境信息
Docker version 24.0.9-1, build 293681613032e6d1a39cc88115847d3984195c24
Docker Compose version v2.26.1
Error Screenshots or Logs / 错误截图或日志
###############################################################
############以下是docker compose up的报错信息####################
################################################################
WARN[0000] /workspaces/XAgent/docker-compose.yml:
versionis obsolete[+] Running 4/6
✔ Container xagent-xagent-redis-1 Running 0.0s
✔ Container xagent-ToolServerNode-1 Running 0.0s
✔ Container xagent-db-1 Running 0.0s
⠼ Container xagent-ToolServerManager-1 Recreated 2.5s
✔ Container xagent-xagent-mysql-1 Created 0.0s
⠼ Container XAgent-Server Recreated 2.5s
Attaching to XAgent-Server, ToolServerManager-1, ToolServerNode-1, db-1, xagent-mysql-1, xagent-redis-1
xagent-mysql-1 | 2024-05-10 05:43:22+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.4.0-1.el9 started.
ToolServerManager-1 | [2024-05-10 05:43:23 +0000] [1] [INFO] Starting gunicorn 22.0.0
ToolServerManager-1 | [2024-05-10 05:43:23 +0000] [1] [INFO] Listening at: http://0.0.0.0:8080 (1)
ToolServerManager-1 | [2024-05-10 05:43:23 +0000] [1] [INFO] Using worker: uvicorn.workers.UvicornWorker
ToolServerManager-1 | [2024-05-10 05:43:23 +0000] [7] [INFO] Booting worker with pid: 7
ToolServerManager-1 | [2024-05-10 05:43:23 +0000] [8] [INFO] Booting worker with pid: 8
xagent-mysql-1 | 2024-05-10 05:43:24+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
xagent-mysql-1 | 2024-05-10 05:43:24+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.4.0-1.el9 started.
xagent-mysql-1 | '/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
xagent-mysql-1 | 2024-05-10T05:43:25.201119Z 0 [System] [MY-015015] [Server] MySQL Server - start.
xagent-mysql-1 | 2024-05-10T05:43:25.474311Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.4.0) starting as process 1
xagent-mysql-1 | 2024-05-10T05:43:25.502911Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
ToolServerManager-1 | [2024-05-10 05:43:27 +0000] [8] [INFO] Database connected
ToolServerManager-1 | [2024-05-10 05:43:27 +0000] [7] [INFO] Database connected
ToolServerManager-1 | [2024-05-10 05:43:27 +0000] [8] [INFO] Docker client connected
ToolServerManager-1 | [2024-05-10 05:43:27 +0000] [7] [INFO] Docker client connected
ToolServerManager-1 | [2024-05-10 05:43:27 +0000] [8] [INFO] Started server process [8]
ToolServerManager-1 | [2024-05-10 05:43:27 +0000] [7] [INFO] Started server process [7]
ToolServerManager-1 | [2024-05-10 05:43:27 +0000] [7] [INFO] Waiting for application startup.
ToolServerManager-1 | [2024-05-10 05:43:27 +0000] [8] [INFO] Waiting for application startup.
db-1 | {"t":{"$date":"2024-05-10T05:43:27.840+00:00"},"s":"I", "c":"NETWORK", "id":22943, "ctx":"listener","msg":"Connection accepted","attr":{"remote":"172.18.0.4:60504","uuid":{"uuid":{"$uuid":"9091e1d6-951b-4891-a995-1e58e115461c"}},"connectionId":7,"connectionCount":1}}
db-1 | {"t":{"$date":"2024-05-10T05:43:27.840+00:00"},"s":"I", "c":"NETWORK", "id":22943, "ctx":"listener","msg":"Connection accepted","attr":{"remote":"172.18.0.4:60506","uuid":{"uuid":{"$uuid":"58f947ad-141a-4e59-ba56-a9de4d2a0fa3"}},"connectionId":8,"connectionCount":2}}
db-1 | {"t":{"$date":"2024-05-10T05:43:27.841+00:00"},"s":"I", "c":"NETWORK", "id":51800, "ctx":"conn7","msg":"client metadata","attr":{"remote":"172.18.0.4:60504","client":"conn7","negotiatedCompressors":[],"doc":{"driver":{"name":"PyMongo|Motor","version":"4.7.2|3.4.0"},"os":{"type":"Linux","name":"Linux","architecture":"x86_64","version":"6.5.0-1018-azure"},"platform":"CPython 3.10.14.final.0|asyncio","env":{"container":{"runtime":"docker"}}}}}
db-1 | {"t":{"$date":"2024-05-10T05:43:27.841+00:00"},"s":"I", "c":"NETWORK", "id":51800, "ctx":"conn8","msg":"client metadata","attr":{"remote":"172.18.0.4:60506","client":"conn8","negotiatedCompressors":[],"doc":{"driver":{"name":"PyMongo|Motor","version":"4.7.2|3.4.0"},"os":{"type":"Linux","name":"Linux","architecture":"x86_64","version":"6.5.0-1018-azure"},"platform":"CPython 3.10.14.final.0|asyncio","env":{"container":{"runtime":"docker"}}}}}
db-1 | {"t":{"$date":"2024-05-10T05:43:27.842+00:00"},"s":"I", "c":"NETWORK", "id":22943, "ctx":"listener","msg":"Connection accepted","attr":{"remote":"172.18.0.4:60528","uuid":{"uuid":{"$uuid":"2ece37b1-63cb-4a69-8484-70640f4bd379"}},"connectionId":9,"connectionCount":3}}
db-1 | {"t":{"$date":"2024-05-10T05:43:27.843+00:00"},"s":"I", "c":"NETWORK", "id":51800, "ctx":"conn9","msg":"client metadata","attr":{"remote":"172.18.0.4:60528","client":"conn9","negotiatedCompressors":[],"doc":{"driver":{"name":"PyMongo|Motor","version":"4.7.2|3.4.0"},"os":{"type":"Linux","name":"Linux","architecture":"x86_64","version":"6.5.0-1018-azure"},"platform":"CPython 3.10.14.final.0|asyncio","env":{"container":{"runtime":"docker"}}}}}
db-1 | {"t":{"$date":"2024-05-10T05:43:27.843+00:00"},"s":"I", "c":"ACCESS", "id":6788604, "ctx":"conn9","msg":"Auth metrics report","attr":{"metric":"acquireUser","micros":0}}
db-1 | {"t":{"$date":"2024-05-10T05:43:27.843+00:00"},"s":"I", "c":"NETWORK", "id":22943, "ctx":"listener","msg":"Connection accepted","attr":{"remote":"172.18.0.4:60538","uuid":{"uuid":{"$uuid":"1a132fe8-2008-43ab-b783-b4727e39adf0"}},"connectionId":10,"connectionCount":4}}
db-1 | {"t":{"$date":"2024-05-10T05:43:27.844+00:00"},"s":"I", "c":"NETWORK", "id":51800, "ctx":"conn10","msg":"client metadata","attr":{"remote":"172.18.0.4:60538","client":"conn10","negotiatedCompressors":[],"doc":{"driver":{"name":"PyMongo|Motor","version":"4.7.2|3.4.0"},"os":{"type":"Linux","name":"Linux","architecture":"x86_64","version":"6.5.0-1018-azure"},"platform":"CPython 3.10.14.final.0|asyncio","env":{"container":{"runtime":"docker"}}}}}
db-1 | {"t":{"$date":"2024-05-10T05:43:27.845+00:00"},"s":"I", "c":"NETWORK", "id":22943, "ctx":"listener","msg":"Connection accepted","attr":{"remote":"172.18.0.4:60542","uuid":{"uuid":{"$uuid":"773d663c-77e8-4b9c-afa8-ca86bc2a86e3"}},"connectionId":11,"connectionCount":5}}
db-1 | {"t":{"$date":"2024-05-10T05:43:27.845+00:00"},"s":"I", "c":"NETWORK", "id":51800, "ctx":"conn11","msg":"client metadata","attr":{"remote":"172.18.0.4:60542","client":"conn11","negotiatedCompressors":[],"doc":{"driver":{"name":"PyMongo|Motor","version":"4.7.2|3.4.0"},"os":{"type":"Linux","name":"Linux","architecture":"x86_64","version":"6.5.0-1018-azure"},"platform":"CPython 3.10.14.final.0|asyncio","env":{"container":{"runtime":"docker"}}}}}
db-1 | {"t":{"$date":"2024-05-10T05:43:27.845+00:00"},"s":"I", "c":"ACCESS", "id":6788604, "ctx":"conn11","msg":"Auth metrics report","attr":{"metric":"acquireUser","micros":0}}
db-1 | {"t":{"$date":"2024-05-10T05:43:27.861+00:00"},"s":"I", "c":"NETWORK", "id":22943, "ctx":"listener","msg":"Connection accepted","attr":{"remote":"172.18.0.4:60556","uuid":{"uuid":{"$uuid":"c4a239bd-bb90-4fc8-afa5-8adde2ff5bda"}},"connectionId":12,"connectionCount":6}}
db-1 | {"t":{"$date":"2024-05-10T05:43:27.862+00:00"},"s":"I", "c":"NETWORK", "id":51800, "ctx":"conn12","msg":"client metadata","attr":{"remote":"172.18.0.4:60556","client":"conn12","negotiatedCompressors":[],"doc":{"driver":{"name":"PyMongo|Motor","version":"4.7.2|3.4.0"},"os":{"type":"Linux","name":"Linux","architecture":"x86_64","version":"6.5.0-1018-azure"},"platform":"CPython 3.10.14.final.0|asyncio","env":{"container":{"runtime":"docker"}}}}}
db-1 | {"t":{"$date":"2024-05-10T05:43:27.865+00:00"},"s":"I", "c":"ACCESS", "id":5286306, "ctx":"conn9","msg":"Successfully authenticated","attr":{"client":"172.18.0.4:60528","isSpeculative":true,"isClusterMember":false,"mechanism":"SCRAM-SHA-256","user":"admin","db":"admin","result":0,"metrics":{"conversation_duration":{"micros":22038,"summary":{"0":{"step":1,"step_total":2,"duration_micros":588},"1":{"step":2,"step_total":2,"duration_micros":24}}}},"extraInfo":{}}}
db-1 | {"t":{"$date":"2024-05-10T05:43:27.866+00:00"},"s":"I", "c":"ACCESS", "id":5286306, "ctx":"conn11","msg":"Successfully authenticated","attr":{"client":"172.18.0.4:60542","isSpeculative":true,"isClusterMember":false,"mechanism":"SCRAM-SHA-256","user":"admin","db":"admin","result":0,"metrics":{"conversation_duration":{"micros":20283,"summary":{"0":{"step":1,"step_total":2,"duration_micros":295},"1":{"step":2,"step_total":2,"duration_micros":13}}}},"extraInfo":{}}}
db-1 | {"t":{"$date":"2024-05-10T05:43:27.866+00:00"},"s":"I", "c":"NETWORK", "id":6788700, "ctx":"conn9","msg":"Received first command on ingress connection since session start or auth handshake","attr":{"elapsedMillis":0}}
db-1 | {"t":{"$date":"2024-05-10T05:43:27.867+00:00"},"s":"I", "c":"NETWORK", "id":6788700, "ctx":"conn11","msg":"Received first command on ingress connection since session start or auth handshake","attr":{"elapsedMillis":1}}
ToolServerManager-1 | [2024-05-10 05:43:27 +0000] [8] [INFO] Nodes status checker started.
ToolServerManager-1 | [2024-05-10 05:43:27 +0000] [8] [INFO] Application startup complete.
ToolServerManager-1 | [2024-05-10 05:43:27 +0000] [7] [INFO] Nodes status checker started.
ToolServerManager-1 | [2024-05-10 05:43:27 +0000] [7] [INFO] Application startup complete.
xagent-mysql-1 | 2024-05-10T05:43:28.123293Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
xagent-mysql-1 | mysqld: Table 'mysql.plugin' doesn't exist
xagent-mysql-1 | 2024-05-10T05:43:28.557119Z 0 [ERROR] [MY-010735] [Server] Could not open the mysql.plugin table. Please perform the MySQL upgrade procedure.
xagent-mysql-1 | 2024-05-10T05:43:28.557416Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
xagent-mysql-1 | 2024-05-10T05:43:28.557691Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
xagent-mysql-1 | 2024-05-10T05:43:28.557877Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
xagent-mysql-1 | 2024-05-10T05:43:28.558289Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
xagent-mysql-1 | 2024-05-10T05:43:28.558495Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
xagent-mysql-1 | 2024-05-10T05:43:28.558715Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
xagent-mysql-1 | 2024-05-10T05:43:28.558930Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
xagent-mysql-1 | 2024-05-10T05:43:28.633293Z 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
xagent-mysql-1 | 2024-05-10T05:43:28.772470Z 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
xagent-mysql-1 | 2024-05-10T05:43:28.803121Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
xagent-mysql-1 | 2024-05-10T05:43:28.803473Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
xagent-mysql-1 | 2024-05-10T05:43:28.819347Z 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.
xagent-mysql-1 | 2024-05-10T05:43:28.820318Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
xagent-mysql-1 | 2024-05-10T05:43:28.820766Z 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
xagent-mysql-1 | 2024-05-10T05:43:28.821632Z 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.
xagent-mysql-1 | 2024-05-10T05:43:28.822097Z 0 [ERROR] [MY-000067] [Server] unknown variable 'default-authentication-plugin=caching_sha2_password'.
xagent-mysql-1 | 2024-05-10T05:43:28.832677Z 0 [ERROR] [MY-010119] [Server] Aborting
xagent-mysql-1 | 2024-05-10T05:43:30.280382Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.4.0) MySQL Community Server - GPL.
xagent-mysql-1 | 2024-05-10T05:43:30.280403Z 0 [System] [MY-015016] [Server] MySQL Server - end.
dependency failed to start: container xagent-xagent-mysql-1 exited (1)
###############################################################
############以下是docker compose build的报错信息####################
################################################################
failed to solve: process "/bin/sh -c pip install --no-cache-dir -r requirements.txt" did not complete successfully: exit code: 1
Additional Notes / 其他备注
If you have any additional information or notes, please add them here. / 如果有其他补充信息，请在此处添加。
The text was updated successfully, but these errors were encountered: