OpenBMB / XAgent

An Autonomous LLM Agent for Complex Task Solving
https://blog.x-agent.net/blog/xagent/
Apache License 2.0
8.19k stars 845 forks source link

## Issue Description / 问题描述在多台机器上尝试执行docker compose up 容器出现mysql问题,然后执行docker compose build也出现问题 #402

Open SOMMTA opened 6 months ago

SOMMTA commented 6 months ago

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: version is 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的报错信息#################### ################################################################


[ToolServerNode 8/12] RUN pip install --no-cache-dir -r requirements.txt: 0.774 Looking in indexes: https://pypi.tuna.tsinghua.edu.cn/simple 1.322 Collecting beautifulsoup4 1.407 Downloading https://pypi.tuna.tsinghua.edu.cn/packages/b1/fe/e8c672695b37eecc5cbf43e1d0638d88d66ba3a44c4d321c796f4e59167f/beautifulsoup4-4.12.3-py3-none-any.whl (147 kB) .......................... 365.4 Getting requirements to build wheel: started 367.3 Getting requirements to build wheel: finished with status 'error' 367.3 error: subprocess-exited-with-error 367.3
367.3 × Getting requirements to build wheel did not run successfully. 367.3 │ exit code: 1 367.3 ╰─> [164 lines of output] 367.3
367.3 Error compiling Cython file: 367.3 ------------------------------------------------------------ 367.3 ... 367.3 int length 367.3
367.3
367.3 cdef class Vocab: 367.3 cdef Pool mem 367.3 cpdef readonly StringStore strings 367.3 ^ 367.3 ------------------------------------------------------------ 367.3
367.3 spacy/vocab.pxd:28:10: Variables cannot be declared with 'cpdef'. Use 'cdef' instead. 367.3
367.3 Error compiling Cython file: 367.3 ------------------------------------------------------------ 367.3 ... 367.3
367.3
367.3 cdef class Vocab: 367.3 cdef Pool mem 367.3 cpdef readonly StringStore strings 367.3 cpdef public Morphology morphology 367.3 ^ 367.3 ------------------------------------------------------------ 367.3
367.3 spacy/vocab.pxd:29:10: Variables cannot be declared with 'cpdef'. Use 'cdef' instead. 367.3
367.3 Error compiling Cython file: 367.3 ------------------------------------------------------------ 367.3 ... 367.3
367.3 cdef class Vocab: 367.3 cdef Pool mem 367.3 cpdef readonly StringStore strings 367.3 cpdef public Morphology morphology 367.3 cpdef public object vectors 367.3 ^ 367.3 ------------------------------------------------------------ 367.3
367.3 spacy/vocab.pxd:30:10: Variables cannot be declared with 'cpdef'. Use 'cdef' instead. 367.3
367.3 Error compiling Cython file: 367.3 ------------------------------------------------------------ 367.3 ... 367.3 cdef class Vocab: 367.3 cdef Pool mem 367.3 cpdef readonly StringStore strings 367.3 cpdef public Morphology morphology 367.3 cpdef public object vectors 367.3 cpdef public object _lookups 367.3 ^ 367.3 ------------------------------------------------------------ 367.3
367.3 spacy/vocab.pxd:31:10: Variables cannot be declared with 'cpdef'. Use 'cdef' instead. 367.3
367.3 Error compiling Cython file: 367.3 ------------------------------------------------------------ 367.3 ... 367.3 cdef Pool mem 367.3 cpdef readonly StringStore strings 367.3 cpdef public Morphology morphology 367.3 cpdef public object vectors 367.3 cpdef public object _lookups 367.3 cpdef public object writing_system 367.3 ^ 367.3 ------------------------------------------------------------ 367.3
367.3 spacy/vocab.pxd:32:10: Variables cannot be declared with 'cpdef'. Use 'cdef' instead. 367.3
367.3 Error compiling Cython file: 367.3 ------------------------------------------------------------ 367.3 ... 367.3 cpdef readonly StringStore strings 367.3 cpdef public Morphology morphology 367.3 cpdef public object vectors 367.3 cpdef public object _lookups 367.3 cpdef public object writing_system 367.3 cpdef public object get_noun_chunks 367.3 ^ 367.3 ------------------------------------------------------------ 367.3
367.3 spacy/vocab.pxd:33:10: Variables cannot be declared with 'cpdef'. Use 'cdef' instead. 367.3
367.3 Error compiling Cython file: 367.3 ------------------------------------------------------------ 367.3 ... 367.3 cdef float prior_prob 367.3
367.3
367.3 cdef class KnowledgeBase: 367.3 cdef Pool mem 367.3 cpdef readonly Vocab vocab 367.3 ^ 367.3 ------------------------------------------------------------ 367.3
367.3 spacy/kb.pxd:31:10: Variables cannot be declared with 'cpdef'. Use 'cdef' instead. 367.3 Copied /tmp/pip-install-q414cc85/spacy_19984bb9ac3c42c49405af990c39df57/setup.cfg -> /tmp/pip-install-q414cc85/spacy_19984bb9ac3c42c49405af990c39df57/spacy/tests/package 367.3 Copied /tmp/pip-install-q414cc85/spacy_19984bb9ac3c42c49405af990c39df57/pyproject.toml -> /tmp/pip-install-q414cc85/spacy_19984bb9ac3c42c49405af990c39df57/spacy/tests/package 367.3 Cythonizing sources 367.3 Compiling spacy/training/example.pyx because it changed. 367.3 Compiling spacy/parts_of_speech.pyx because it changed. 367.3 Compiling spacy/strings.pyx because it changed. 367.3 Compiling spacy/lexeme.pyx because it changed. 367.3 Compiling spacy/vocab.pyx because it changed. 367.3 Compiling spacy/attrs.pyx because it changed. 367.3 Compiling spacy/kb.pyx because it changed. 367.3 Compiling spacy/ml/parser_model.pyx because it changed. 367.3 Compiling spacy/morphology.pyx because it changed. 367.3 Compiling spacy/pipeline/dep_parser.pyx because it changed. 367.3 Compiling spacy/pipeline/morphologizer.pyx because it changed. 367.3 Compiling spacy/pipeline/multitask.pyx because it changed. 367.3 Compiling spacy/pipeline/ner.pyx because it changed. 367.3 Compiling spacy/pipeline/pipe.pyx because it changed. 367.3 Compiling spacy/pipeline/trainable_pipe.pyx because it changed. 367.3 Compiling spacy/pipeline/sentencizer.pyx because it changed. 367.3 Compiling spacy/pipeline/senter.pyx because it changed. 367.3 Compiling spacy/pipeline/tagger.pyx because it changed. 367.3 Compiling spacy/pipeline/transition_parser.pyx because it changed. 367.3 Compiling spacy/pipeline/_parser_internals/arc_eager.pyx because it changed. 367.3 Compiling spacy/pipeline/_parser_internals/ner.pyx because it changed. 367.3 Compiling spacy/pipeline/_parser_internals/nonproj.pyx because it changed. 367.3 Compiling spacy/pipeline/_parser_internals/_state.pyx because it changed. 367.3 Compiling spacy/pipeline/_parser_internals/stateclass.pyx because it changed. 367.3 Compiling spacy/pipeline/_parser_internals/transition_system.pyx because it changed. 367.3 Compiling spacy/pipeline/_parser_internals/_beam_utils.pyx because it changed. 367.3 Compiling spacy/tokenizer.pyx because it changed. 367.3 Compiling spacy/training/align.pyx because it changed. 367.3 Compiling spacy/training/gold_io.pyx because it changed. 367.3 Compiling spacy/tokens/doc.pyx because it changed. 367.3 Compiling spacy/tokens/span.pyx because it changed. 367.3 Compiling spacy/tokens/token.pyx because it changed. 367.3 Compiling spacy/tokens/span_group.pyx because it changed. 367.3 Compiling spacy/tokens/graph.pyx because it changed. 367.3 Compiling spacy/tokens/morphanalysis.pyx because it changed. 367.3 Compiling spacy/tokens/_retokenize.pyx because it changed. 367.3 Compiling spacy/matcher/matcher.pyx because it changed. 367.3 Compiling spacy/matcher/phrasematcher.pyx because it changed. 367.3 Compiling spacy/matcher/dependencymatcher.pyx because it changed. 367.3 Compiling spacy/symbols.pyx because it changed. 367.3 Compiling spacy/vectors.pyx because it changed. 367.3 [ 1/41] Cythonizing spacy/attrs.pyx 367.3 [ 2/41] Cythonizing spacy/kb.pyx 367.3 Traceback (most recent call last): 367.3 File "/usr/local/lib/python3.10/site-packages/pip/_vendor/pyproject_hooks/_in_process/_in_process.py", line 353, in 367.3 main() 367.3 File "/usr/local/lib/python3.10/site-packages/pip/_vendor/pyproject_hooks/_in_process/_in_process.py", line 335, in main 367.3 json_out['return_val'] = hook(*hook_input['kwargs']) 367.3 File "/usr/local/lib/python3.10/site-packages/pip/_vendor/pyproject_hooks/_in_process/_in_process.py", line 118, in get_requires_for_build_wheel 367.3 return hook(config_settings) 367.3 File "/tmp/pip-build-env-q8cpsmpk/overlay/lib/python3.10/site-packages/setuptools/build_meta.py", line 325, in get_requires_for_build_wheel 367.3 return self._get_build_requires(config_settings, requirements=['wheel']) 367.3 File "/tmp/pip-build-env-q8cpsmpk/overlay/lib/python3.10/site-packages/setuptools/build_meta.py", line 295, in _get_build_requires 367.3 self.run_setup() 367.3 File "/tmp/pip-build-env-q8cpsmpk/overlay/lib/python3.10/site-packages/setuptools/build_meta.py", line 311, in run_setup 367.3 exec(code, locals()) 367.3 File "", line 224, in 367.3 File "", line 211, in setup_package 367.3 File "/tmp/pip-build-env-q8cpsmpk/overlay/lib/python3.10/site-packages/Cython/Build/Dependencies.py", line 1154, in cythonize 367.3 cythonize_one(args) 367.3 File "/tmp/pip-build-env-q8cpsmpk/overlay/lib/python3.10/site-packages/Cython/Build/Dependencies.py", line 1321, in cythonize_one 367.3 raise CompileError(None, pyx_file) 367.3 Cython.Compiler.Errors.CompileError: spacy/kb.pyx 367.3 [end of output] 367.3
367.3 note: This error originates from a subprocess, and is likely not a problem with pip. 367.3 error: subprocess-exited-with-error 367.3 367.3 × Getting requirements to build wheel did not run successfully. 367.3 │ exit code: 1 367.3 ╰─> See above for output. 367.3 367.3 note: This error originates from a subprocess, and is likely not a problem with pip. 368.2 368.2 [notice] A new release of pip is available: 23.0.1 -> 24.0 368.2 [notice] To update, run: pip install --upgrade pip

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. / 如果有其他补充信息,请在此处添加。

AuroraCovariance commented 6 months ago

我遇到了相同问题,这是我的成功方法,手动建数据库 PS C:\Users\JackyFeng\Desktop\ai scene\XAgent> conda activate xagent PS C:\Users\JackyFeng\Desktop\ai scene\XAgent> docker-compose down

time="2024-05-19T09:59:03+08:00" level=warning msg="C:\Users\JackyFeng\Desktop\ai scene\XAgent\docker-compose.yml: version is obsolete" PS C:\Users\JackyFeng\Desktop\ai scene\XAgent> Remove-Item -Recurse -Force .\mysql_data\

Remove-Item : 找不到路径“C:\Users\JackyFeng\Desktop\ai scene\XAgent\mysql_data\”,因为该路径不存在。 所在位置 行:1 字符: 1

  • Remove-Item -Recurse -Force .\mysql_data\
  • CategoryInfo : ObjectNotFound: (C:\Users\JackyF...ent\mysql_data\:String) [Remove-Item], ItemNotFoundEx ception
  • FullyQualifiedErrorId : PathNotFound,Microsoft.PowerShell.Commands.RemoveItemCommand

PS C:\Users\JackyFeng\Desktop\ai scene\XAgent> docker volume ls

DRIVER VOLUME NAME local 0c2ed82733bee71e7f3e4f86ec2321484177190c2a1492767a6017b347360737 local 0d140ab15df9f36031bc696304fc2ce001765de5dd37feecb887ba9b47b670ec local 1acc89e3a221da5c3f90677a722bfb78f5de9278ef2061d5a2b28eba5cca2a71 local 04b9351d4f00743d4ca4237fd3570eed21b50db866a2c03f4f2b9664d25af128 local 6c56a5f342024811ac61e5afe8538e5577c82a383962653a8a3283ebb3b35200 local 8b92d257346495458227518ef3e7f7be935301fdafa9aae2349b842abb426e46 local 882d3c4683256762a5458f3cfa597c2356007d58e7c1236ad0303efa5e76f110 local cbd9b51b92cbad3f7e773af9b8840fed1979f2f56d1a80dc6c7f62eb95cb502e local cc2e30a13219908c76040468e4f40c63c4937f20831431ada18a7533a9d3f0bf local d30f9b21fae523f3367754dccedb545e8d3ef76039edc14a12fff6c6e5e7ab49 local de39f6bbc26b35d188edc2e617daf38adcddcab9ff2aaf1ef7b26ad3c7fe9070 local e310ca9107d2c7417f8d23881a062ee53702907087ce090617c6a90f09dec181 local toolserverconfig local xagent_xagentmongodb PS C:\Users\JackyFeng\Desktop\ai scene\XAgent> docker-compose down

time="2024-05-19T10:03:23+08:00" level=warning msg="C:\Users\JackyFeng\Desktop\ai scene\XAgent\docker-compose.yml: version is obsolete" PS C:\Users\JackyFeng\Desktop\ai scene\XAgent> docker volume ls DRIVER VOLUME NAME local 0c2ed82733bee71e7f3e4f86ec2321484177190c2a1492767a6017b347360737 local 0d140ab15df9f36031bc696304fc2ce001765de5dd37feecb887ba9b47b670ec local 1acc89e3a221da5c3f90677a722bfb78f5de9278ef2061d5a2b28eba5cca2a71 local 04b9351d4f00743d4ca4237fd3570eed21b50db866a2c03f4f2b9664d25af128 local 6c56a5f342024811ac61e5afe8538e5577c82a383962653a8a3283ebb3b35200 local 8b92d257346495458227518ef3e7f7be935301fdafa9aae2349b842abb426e46 local 882d3c4683256762a5458f3cfa597c2356007d58e7c1236ad0303efa5e76f110 local cbd9b51b92cbad3f7e773af9b8840fed1979f2f56d1a80dc6c7f62eb95cb502e local cc2e30a13219908c76040468e4f40c63c4937f20831431ada18a7533a9d3f0bf local d30f9b21fae523f3367754dccedb545e8d3ef76039edc14a12fff6c6e5e7ab49 local de39f6bbc26b35d188edc2e617daf38adcddcab9ff2aaf1ef7b26ad3c7fe9070 local e310ca9107d2c7417f8d23881a062ee53702907087ce090617c6a90f09dec181 local toolserverconfig local xagent_xagentmongodb PS C:\Users\JackyFeng\Desktop\ai scene\XAgent> docker-compose up -d xagent-mysql

time="2024-05-19T10:09:33+08:00" level=warning msg="C:\Users\JackyFeng\Desktop\ai scene\XAgent\docker-compose.yml: version is obsolete" [+] Running 2/2 ✔ Network tool-server-network Created 0.0s ✔ Container xagent-xagent-mysql-1 Started 0.0s PS C:\Users\JackyFeng\Desktop\ai scene\XAgent> docker inspect xagent-mysql

[] Error: No such object: xagent-mysql PS C:\Users\JackyFeng\Desktop\ai scene\XAgent> docker inspect xagent-mysql

[] Error: No such object: xagent-mysql PS C:\Users\JackyFeng\Desktop\ai scene\XAgent> docker ps CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES 0bf77f180109 mysql "docker-entrypoint.s…" About a minute ago Up About a minute (healthy) 0.0.0.0:3306->3306/tcp, 33060/tcp xagent-xagent-mysql-1 PS C:\Users\JackyFeng\Desktop\ai scene\XAgent> docker inspect xagent-xagent-mysql-1

[ { "Id": "0bf77f180109942d920dec069595051eaa970f3bec588dcfff78bed31585d1de", "Created": "2024-05-19T02:09:33.174607121Z", "Path": "docker-entrypoint.sh", "Args": [ "--character-set-server=utf8mb4", "--collation-server=utf8mb4_unicode_ci" ], "State": { "Status": "running", "Running": true, "Paused": false, "Restarting": false, "OOMKilled": false, "Dead": false, "Pid": 4935, "ExitCode": 0, "Error": "", "StartedAt": "2024-05-19T02:09:33.421017477Z", "FinishedAt": "0001-01-01T00:00:00Z", "Health": { "Status": "healthy", "FailingStreak": 0, "Log": [ { "Start": "2024-05-19T02:10:03.423928142Z", "End": "2024-05-19T02:10:03.452810947Z", "ExitCode": 0, "Output": "mysql: [Warning] Using a password on the command line interface can be insecure.\n1\n1\n" }, { "Start": "2024-05-19T02:10:33.453706007Z", "End": "2024-05-19T02:10:33.493433484Z", "ExitCode": 0, "Output": "mysql: [Warning] Using a password on the command line interface can be insecure.\n1\n1\n" }, { "Start": "2024-05-19T02:11:03.49278982Z", "End": "2024-05-19T02:11:03.510926459Z", "ExitCode": 0, "Output": "mysql: [Warning] Using a password on the command line interface can be insecure.\n1\n1\n" }, { "Start": "2024-05-19T02:11:33.510268459Z", "End": "2024-05-19T02:11:33.538416127Z", "ExitCode": 0, "Output": "mysql: [Warning] Using a password on the command line interface can be insecure.\n1\n1\n" } ] } }, "Image": "sha256:e9387c13ed83ab7915ed1cf73d505c6604c1f237b9f059ca26000ea70fa9dafb", "ResolvConfPath": "/var/lib/docker/containers/0bf77f180109942d920dec069595051eaa970f3bec588dcfff78bed31585d1de/resolv.conf", "HostnamePath": "/var/lib/docker/containers/0bf77f180109942d920dec069595051eaa970f3bec588dcfff78bed31585d1de/hostname", "HostsPath": "/var/lib/docker/containers/0bf77f180109942d920dec069595051eaa970f3bec588dcfff78bed31585d1de/hosts", "LogPath": "/var/lib/docker/containers/0bf77f180109942d920dec069595051eaa970f3bec588dcfff78bed31585d1de/0bf77f180109942d920dec069595051eaa970f3bec588dcfff78bed31585d1de-json.log", "Name": "/xagent-xagent-mysql-1", "RestartCount": 0, "Driver": "overlay2", "Platform": "linux", "MountLabel": "", "ProcessLabel": "", "AppArmorProfile": "", "ExecIDs": null, "HostConfig": { "Binds": [ "C:\Users\JackyFeng\Desktop\ai scene\XAgent\XAgentServer\database\sql:/docker-entrypoint-initdb.d:rw" ], "ContainerIDFile": "", "LogConfig": { "Type": "json-file", "Config": {} }, "NetworkMode": "tool-server-network", "PortBindings": { "3306/tcp": [ { "HostIp": "", "HostPort": "3306" } ] }, "RestartPolicy": { "Name": "no", "MaximumRetryCount": 0 }, "AutoRemove": false, "VolumeDriver": "", "VolumesFrom": null, "ConsoleSize": [ 0, 0 ], "CapAdd": null, "CapDrop": null, "CgroupnsMode": "host", "Dns": null, "DnsOptions": null, "DnsSearch": null, "ExtraHosts": [], "GroupAdd": null, "IpcMode": "private", "Cgroup": "", "Links": null, "OomScoreAdj": 0, "PidMode": "", "Privileged": false, "PublishAllPorts": false, "ReadonlyRootfs": false, "SecurityOpt": null, "UTSMode": "", "UsernsMode": "", "ShmSize": 67108864, "Runtime": "runc", "Isolation": "", "CpuShares": 0, "Memory": 0, "NanoCpus": 0, "CgroupParent": "", "BlkioWeight": 0, "BlkioWeightDevice": null, "BlkioDeviceReadBps": null, "BlkioDeviceWriteBps": null, "BlkioDeviceReadIOps": null, "BlkioDeviceWriteIOps": null, "CpuPeriod": 0, "CpuQuota": 0, "CpuRealtimePeriod": 0, "CpuRealtimeRuntime": 0, "CpusetCpus": "", "CpusetMems": "", "Devices": null, "DeviceCgroupRules": null, "DeviceRequests": null, "MemoryReservation": 0, "MemorySwap": 0, "MemorySwappiness": null, "OomKillDisable": false, "PidsLimit": null, "Ulimits": null, "CpuCount": 0, "CpuPercent": 0, "IOMaximumIOps": 0, "IOMaximumBandwidth": 0, "MaskedPaths": [ "/proc/asound", "/proc/acpi", "/proc/kcore", "/proc/keys", "/proc/latency_stats", "/proc/timer_list", "/proc/timer_stats", "/proc/sched_debug", "/proc/scsi", "/sys/firmware", "/sys/devices/virtual/powercap" ], "ReadonlyPaths": [ "/proc/bus", "/proc/fs", "/proc/irq", "/proc/sys", "/proc/sysrq-trigger" ] }, "GraphDriver": { "Data": { "LowerDir": "/var/lib/docker/overlay2/89d71af4887af129aaac1a6f5bbc1bf8c3dba0f2088446f00b157bc2e556ccc4-init/diff:/var/lib/docker/overlay2/0b86c143ff0f92a2832a0301892094bb492223ebc42d1dc03327e3a5f13bbbe4/diff:/var/lib/docker/overlay2/169d459f932329e6256528993ca23d84186142f0f8587364500c7d1df0fdc6af/diff:/var/lib/docker/overlay2/72321388c3769bc8f4fb78fed7c8ef377243f0e7fed9ba70d057e56b15d508d1/diff:/var/lib/docker/overlay2/8e3e19440d5ce383b9e3c943ed9973da21bf273ae316d18792b7fc0c0a86a782/diff:/var/lib/docker/overlay2/4415eac5896f23c760a78363f80de2b9c8bf455bcdf3344a8e778740b3042275/diff:/var/lib/docker/overlay2/6b04e380372eee7bac6e912c72bb58c9dff5d5b176616d56308447c0f7219379/diff:/var/lib/docker/overlay2/18d2e7e43ace6a947c6a31dbd46d4019a525e7ddd8875434d97ad675ecf63431/diff:/var/lib/docker/overlay2/feaac4895bfe13308b437f0f80a62d9d7d3d5367a277f25a4a14064c3f951299/diff:/var/lib/docker/overlay2/e237b47515b6a62e4899d99061b5a2685b4b7be7711b5196c8d9f80952190877/diff:/var/lib/docker/overlay2/d769ea734fd6d865ab80ba1f6374694c20f22ea29cddeb7c759d9a38d8ef6941/diff", "MergedDir": "/var/lib/docker/overlay2/89d71af4887af129aaac1a6f5bbc1bf8c3dba0f2088446f00b157bc2e556ccc4/merged", "UpperDir": "/var/lib/docker/overlay2/89d71af4887af129aaac1a6f5bbc1bf8c3dba0f2088446f00b157bc2e556ccc4/diff", "WorkDir": "/var/lib/docker/overlay2/89d71af4887af129aaac1a6f5bbc1bf8c3dba0f2088446f00b157bc2e556ccc4/work" }, "Name": "overlay2" }, "Mounts": [ { "Type": "bind", "Source": "C:\Users\JackyFeng\Desktop\ai scene\XAgent\XAgentServer\database\sql", "Destination": "/docker-entrypoint-initdb.d", "Mode": "rw", "RW": true, "Propagation": "rprivate" }, { "Type": "volume", "Name": "f28feb673ef2f2f33bfc54ff89aa9366141cbf0675b0362bb9da42e2a06f37bd", "Source": "/var/lib/docker/volumes/f28feb673ef2f2f33bfc54ff89aa9366141cbf0675b0362bb9da42e2a06f37bd/_data", "Destination": "/var/lib/mysql", "Driver": "local", "Mode": "", "RW": true, "Propagation": "" } ], "Config": { "Hostname": "0bf77f180109", "Domainname": "", "User": "", "AttachStdin": false, "AttachStdout": true, "AttachStderr": true, "ExposedPorts": { "3306/tcp": {}, "33060/tcp": {} }, "Tty": false, "OpenStdin": false, "StdinOnce": false, "Env": [ "MYSQL_ROOT_PASSWORD=xagent", "PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin", "GOSU_VERSION=1.17", "MYSQL_MAJOR=8.4", "MYSQL_VERSION=8.4.0-1.el9", "MYSQL_SHELL_VERSION=8.4.0-1.el9" ], "Cmd": [ "--character-set-server=utf8mb4", "--collation-server=utf8mb4_unicode_ci" ], "Healthcheck": { "Test": [ "CMD-SHELL", "mysql -h localhost -u root -pxagent -e 'SELECT 1'" ], "Timeout": 20000000000, "Retries": 20 }, "Image": "mysql", "Volumes": { "/var/lib/mysql": {} }, "WorkingDir": "", "Entrypoint": [ "docker-entrypoint.sh" ], "OnBuild": null, "Labels": { "com.docker.compose.config-hash": "0463f096e584fda5c839b2d8d4848a2bc5b45c939c0aeb569d85b2e1f4bd5ce8", "com.docker.compose.container-number": "1", "com.docker.compose.depends_on": "", "com.docker.compose.image": "sha256:e9387c13ed83ab7915ed1cf73d505c6604c1f237b9f059ca26000ea70fa9dafb", "com.docker.compose.oneoff": "False", "com.docker.compose.project": "xagent", "com.docker.compose.project.config_files": "C:\Users\JackyFeng\Desktop\ai scene\XAgent\docker-compose.yml", "com.docker.compose.project.working_dir": "C:\Users\JackyFeng\Desktop\ai scene\XAgent", "com.docker.compose.service": "xagent-mysql", "com.docker.compose.version": "2.26.1" } }, "NetworkSettings": { "Bridge": "", "SandboxID": "3bc0246414e9262848c9b0d26d0db6d99f98b3e57c51045ae977cc6107e2cf01", "SandboxKey": "/var/run/docker/netns/3bc0246414e9", "Ports": { "3306/tcp": [ { "HostIp": "0.0.0.0", "HostPort": "3306" } ], "33060/tcp": null }, "HairpinMode": false, "LinkLocalIPv6Address": "", "LinkLocalIPv6PrefixLen": 0, "SecondaryIPAddresses": null, "SecondaryIPv6Addresses": null, "EndpointID": "", "Gateway": "", "GlobalIPv6Address": "", "GlobalIPv6PrefixLen": 0, "IPAddress": "", "IPPrefixLen": 0, "IPv6Gateway": "", "MacAddress": "", "Networks": { "tool-server-network": { "IPAMConfig": null, "Links": null, "Aliases": [ "xagent-xagent-mysql-1", "xagent-mysql" ], "MacAddress": "02:42:ac:13:00:02", "NetworkID": "e39d22a1b4c3637b329af87d2098bbb11c1439199c17bee3a416dd94d89f9ce7", "EndpointID": "ce336951d6a231728491bfa01a4fdd251d28d08cab6abf0705edba2d19a57c9f", "Gateway": "172.19.0.1", "IPAddress": "172.19.0.2", "IPPrefixLen": 16, "IPv6Gateway": "", "GlobalIPv6Address": "", "GlobalIPv6PrefixLen": 0, "DriverOpts": null, "DNSNames": [ "xagent-xagent-mysql-1", "xagent-mysql", "0bf77f180109" ] } } } } ] PS C:\Users\JackyFeng\Desktop\ai scene\XAgent> docker inspect xagent-xagent-mysql-1 docker exec -it xagent-xagent-mysql-1 bash

[ { "Id": "0bf77f180109942d920dec069595051eaa970f3bec588dcfff78bed31585d1de", "Created": "2024-05-19T02:09:33.174607121Z", "Path": "docker-entrypoint.sh", "Args": [ "--character-set-server=utf8mb4", "--collation-server=utf8mb4_unicode_ci" ], "State": { "Status": "running", "Running": true, "Paused": false, "Restarting": false, "OOMKilled": false, "Dead": false, "Pid": 4935, "ExitCode": 0, "Error": "", "StartedAt": "2024-05-19T02:09:33.421017477Z", "FinishedAt": "0001-01-01T00:00:00Z", "Health": { "Status": "healthy", "FailingStreak": 0, "Log": [ { "Start": "2024-05-19T02:11:33.510268459Z", "End": "2024-05-19T02:11:33.538416127Z", "ExitCode": 0, "Output": "mysql: [Warning] Using a password on the command line interface can be insecure.\n1\n1\n" }, { "Start": "2024-05-19T02:12:03.537504192Z", "End": "2024-05-19T02:12:03.56948356Z", "ExitCode": 0, "Output": "mysql: [Warning] Using a password on the command line interface can be insecure.\n1\n1\n" }, { "Start": "2024-05-19T02:12:33.568584834Z", "End": "2024-05-19T02:12:33.593335733Z", "ExitCode": 0, "Output": "mysql: [Warning] Using a password on the command line interface can be insecure.\n1\n1\n" }, { "Start": "2024-05-19T02:13:03.592853417Z", "End": "2024-05-19T02:13:03.618024915Z", "ExitCode": 0, "Output": "mysql: [Warning] Using a password on the command line interface can be insecure.\n1\n1\n" }, { "Start": "2024-05-19T02:13:33.618259105Z", "End": "2024-05-19T02:13:33.671411386Z", "ExitCode": 0, "Output": "mysql: [Warning] Using a password on the command line interface can be insecure.\n1\n1\n" } ] } }, "Image": "sha256:e9387c13ed83ab7915ed1cf73d505c6604c1f237b9f059ca26000ea70fa9dafb", "ResolvConfPath": "/var/lib/docker/containers/0bf77f180109942d920dec069595051eaa970f3bec588dcfff78bed31585d1de/resolv.conf", "HostnamePath": "/var/lib/docker/containers/0bf77f180109942d920dec069595051eaa970f3bec588dcfff78bed31585d1de/hostname", "HostsPath": "/var/lib/docker/containers/0bf77f180109942d920dec069595051eaa970f3bec588dcfff78bed31585d1de/hosts", "LogPath": "/var/lib/docker/containers/0bf77f180109942d920dec069595051eaa970f3bec588dcfff78bed31585d1de/0bf77f180109942d920dec069595051eaa970f3bec588dcfff78bed31585d1de-json.log", "Name": "/xagent-xagent-mysql-1", "RestartCount": 0, "Driver": "overlay2", "Platform": "linux", "MountLabel": "", "ProcessLabel": "", "AppArmorProfile": "", "ExecIDs": null, "HostConfig": { "Binds": [ "C:\Users\JackyFeng\Desktop\ai scene\XAgent\XAgentServer\database\sql:/docker-entrypoint-initdb.d:rw" ], "ContainerIDFile": "", "LogConfig": { "Type": "json-file", "Config": {} }, "NetworkMode": "tool-server-network", "PortBindings": { "3306/tcp": [ { "HostIp": "", "HostPort": "3306" } ] }, "RestartPolicy": { "Name": "no", "MaximumRetryCount": 0 }, "AutoRemove": false, "VolumeDriver": "", "VolumesFrom": null, "ConsoleSize": [ 0, 0 ], "CapAdd": null, "CapDrop": null, "CgroupnsMode": "host", "Dns": null, "DnsOptions": null, "DnsSearch": null, "ExtraHosts": [], "GroupAdd": null, "IpcMode": "private", "Cgroup": "", "Links": null, "OomScoreAdj": 0, "PidMode": "", "Privileged": false, "PublishAllPorts": false, "ReadonlyRootfs": false, "SecurityOpt": null, "UTSMode": "", "UsernsMode": "", "ShmSize": 67108864, "Runtime": "runc", "Isolation": "", "CpuShares": 0, "Memory": 0, "NanoCpus": 0, "CgroupParent": "", "BlkioWeight": 0, "BlkioWeightDevice": null, "BlkioDeviceReadBps": null, "BlkioDeviceWriteBps": null, "BlkioDeviceReadIOps": null, "BlkioDeviceWriteIOps": null, "CpuPeriod": 0, "CpuQuota": 0, "CpuRealtimePeriod": 0, "CpuRealtimeRuntime": 0, "CpusetCpus": "", "CpusetMems": "", "Devices": null, "DeviceCgroupRules": null, "DeviceRequests": null, "MemoryReservation": 0, "MemorySwap": 0, "MemorySwappiness": null, "OomKillDisable": false, "PidsLimit": null, "Ulimits": null, "CpuCount": 0, "CpuPercent": 0, "IOMaximumIOps": 0, "IOMaximumBandwidth": 0, "MaskedPaths": [ "/proc/asound", "/proc/acpi", "/proc/kcore", "/proc/keys", "/proc/latency_stats", "/proc/timer_list", "/proc/timer_stats", "/proc/sched_debug", "/proc/scsi", "/sys/firmware", "/sys/devices/virtual/powercap" ], "ReadonlyPaths": [ "/proc/bus", "/proc/fs", "/proc/irq", "/proc/sys", "/proc/sysrq-trigger" ] }, "GraphDriver": { "Data": { "LowerDir": "/var/lib/docker/overlay2/89d71af4887af129aaac1a6f5bbc1bf8c3dba0f2088446f00b157bc2e556ccc4-init/diff:/var/lib/docker/overlay2/0b86c143ff0f92a2832a0301892094bb492223ebc42d1dc03327e3a5f13bbbe4/diff:/var/lib/docker/overlay2/169d459f932329e6256528993ca23d84186142f0f8587364500c7d1df0fdc6af/diff:/var/lib/docker/overlay2/72321388c3769bc8f4fb78fed7c8ef377243f0e7fed9ba70d057e56b15d508d1/diff:/var/lib/docker/overlay2/8e3e19440d5ce383b9e3c943ed9973da21bf273ae316d18792b7fc0c0a86a782/diff:/var/lib/docker/overlay2/4415eac5896f23c760a78363f80de2b9c8bf455bcdf3344a8e778740b3042275/diff:/var/lib/docker/overlay2/6b04e380372eee7bac6e912c72bb58c9dff5d5b176616d56308447c0f7219379/diff:/var/lib/docker/overlay2/18d2e7e43ace6a947c6a31dbd46d4019a525e7ddd8875434d97ad675ecf63431/diff:/var/lib/docker/overlay2/feaac4895bfe13308b437f0f80a62d9d7d3d5367a277f25a4a14064c3f951299/diff:/var/lib/docker/overlay2/e237b47515b6a62e4899d99061b5a2685b4b7be7711b5196c8d9f80952190877/diff:/var/lib/docker/overlay2/d769ea734fd6d865ab80ba1f6374694c20f22ea29cddeb7c759d9a38d8ef6941/diff", "MergedDir": "/var/lib/docker/overlay2/89d71af4887af129aaac1a6f5bbc1bf8c3dba0f2088446f00b157bc2e556ccc4/merged", "UpperDir": "/var/lib/docker/overlay2/89d71af4887af129aaac1a6f5bbc1bf8c3dba0f2088446f00b157bc2e556ccc4/diff", "WorkDir": "/var/lib/docker/overlay2/89d71af4887af129aaac1a6f5bbc1bf8c3dba0f2088446f00b157bc2e556ccc4/work" }, "Name": "overlay2" }, "Mounts": [ { "Type": "bind", "Source": "C:\Users\JackyFeng\Desktop\ai scene\XAgent\XAgentServer\database\sql", "Destination": "/docker-entrypoint-initdb.d", "Mode": "rw", "RW": true, "Propagation": "rprivate" }, { "Type": "volume", "Name": "f28feb673ef2f2f33bfc54ff89aa9366141cbf0675b0362bb9da42e2a06f37bd", "Source": "/var/lib/docker/volumes/f28feb673ef2f2f33bfc54ff89aa9366141cbf0675b0362bb9da42e2a06f37bd/_data", "Destination": "/var/lib/mysql", "Driver": "local", "Mode": "", "RW": true, "Propagation": "" } ], "Config": { "Hostname": "0bf77f180109", "Domainname": "", "User": "", "AttachStdin": false, "AttachStdout": true, "AttachStderr": true, "ExposedPorts": { "3306/tcp": {}, "33060/tcp": {} }, "Tty": false, "OpenStdin": false, "StdinOnce": false, "Env": [ "MYSQL_ROOT_PASSWORD=xagent", "PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin", "GOSU_VERSION=1.17", "MYSQL_MAJOR=8.4", "MYSQL_VERSION=8.4.0-1.el9", "MYSQL_SHELL_VERSION=8.4.0-1.el9" ], "Cmd": [ "--character-set-server=utf8mb4", "--collation-server=utf8mb4_unicode_ci" ], "Healthcheck": { "Test": [ "CMD-SHELL", "mysql -h localhost -u root -pxagent -e 'SELECT 1'" ], "Timeout": 20000000000, "Retries": 20 }, "Image": "mysql", "Volumes": { "/var/lib/mysql": {} }, "WorkingDir": "", "Entrypoint": [ "docker-entrypoint.sh" ], "OnBuild": null, "Labels": { "com.docker.compose.config-hash": "0463f096e584fda5c839b2d8d4848a2bc5b45c939c0aeb569d85b2e1f4bd5ce8", "com.docker.compose.container-number": "1", "com.docker.compose.depends_on": "", "com.docker.compose.image": "sha256:e9387c13ed83ab7915ed1cf73d505c6604c1f237b9f059ca26000ea70fa9dafb", "com.docker.compose.oneoff": "False", "com.docker.compose.project": "xagent", "com.docker.compose.project.config_files": "C:\Users\JackyFeng\Desktop\ai scene\XAgent\docker-compose.yml", "com.docker.compose.project.working_dir": "C:\Users\JackyFeng\Desktop\ai scene\XAgent", "com.docker.compose.service": "xagent-mysql", "com.docker.compose.version": "2.26.1" } }, "NetworkSettings": { "Bridge": "", "SandboxID": "3bc0246414e9262848c9b0d26d0db6d99f98b3e57c51045ae977cc6107e2cf01", "SandboxKey": "/var/run/docker/netns/3bc0246414e9", "Ports": { "3306/tcp": [ { "HostIp": "0.0.0.0", "HostPort": "3306" } ], "33060/tcp": null }, "HairpinMode": false, "LinkLocalIPv6Address": "", "LinkLocalIPv6PrefixLen": 0, "SecondaryIPAddresses": null, "SecondaryIPv6Addresses": null, "EndpointID": "", "Gateway": "", "GlobalIPv6Address": "", "GlobalIPv6PrefixLen": 0, "IPAddress": "", "IPPrefixLen": 0, "IPv6Gateway": "", "MacAddress": "", "Networks": { "tool-server-network": { "IPAMConfig": null, "Links": null, "Aliases": [ "xagent-xagent-mysql-1", "xagent-mysql" ], "MacAddress": "02:42:ac:13:00:02", "NetworkID": "e39d22a1b4c3637b329af87d2098bbb11c1439199c17bee3a416dd94d89f9ce7", "EndpointID": "ce336951d6a231728491bfa01a4fdd251d28d08cab6abf0705edba2d19a57c9f", "Gateway": "172.19.0.1", "IPAddress": "172.19.0.2", "IPPrefixLen": 16, "IPv6Gateway": "", "GlobalIPv6Address": "", "GlobalIPv6PrefixLen": 0, "DriverOpts": null, "DNSNames": [ "xagent-xagent-mysql-1", "xagent-mysql", "0bf77f180109" ] } } } } ] bash-5.1# s\

      ^C

bash-5.1# ^C bash-5.1# ^C bash-5.1# cd var/lib/mysql bash-5.1# ex^C bash-5.1# ^C bash-5.1# ^C bash-5.1# exit()

^C bash-5.1# exit() ^C bash-5.1# clear bash: clear: command not found bash-5.1# clear() ^C bash-5.1# cd /var/lib/mysql bash-5.1# ls -la total 112548 -rw-r----- 1 mysql mysql 6291456 May 19 02:11 '#ib_16384_0.dblwr' -rw-r----- 1 mysql mysql 14680064 May 19 02:09 '#ib_16384_1.dblwr' drwxr-x--- 2 mysql mysql 4096 May 19 02:09 '#innodb_redo' drwxr-x--- 2 mysql mysql 4096 May 19 02:09 '#innodb_temp' drwxrwxrwt 8 mysql mysql 4096 May 19 02:09 . drwxr-xr-x 1 root root 4096 May 9 23:52 .. -rw-r----- 1 mysql mysql 56 May 19 02:09 auto.cnf -rw-r----- 1 mysql mysql 2953730 May 19 02:09 binlog.000001 -rw-r----- 1 mysql mysql 158 May 19 02:09 binlog.000002 -rw-r----- 1 mysql mysql 32 May 19 02:09 binlog.index -rw------- 1 mysql mysql 1705 May 19 02:09 ca-key.pem -rw-r--r-- 1 mysql mysql 1108 May 19 02:09 ca.pem -rw-r--r-- 1 mysql mysql 1108 May 19 02:09 client-cert.pem -rw------- 1 mysql mysql 1705 May 19 02:09 client-key.pem -rw-r----- 1 mysql mysql 5436 May 19 02:09 ib_buffer_pool -rw-r----- 1 mysql mysql 12582912 May 19 02:09 ibdata1 -rw-r----- 1 mysql mysql 12582912 May 19 02:09 ibtmp1 drwxr-x--- 2 mysql mysql 4096 May 19 02:09 mysql -rw-r----- 1 mysql mysql 32505856 May 19 02:09 mysql.ibd lrwxrwxrwx 1 mysql mysql 27 May 19 02:09 mysql.sock -> /var/run/mysqld/mysqld.sock -rw-r----- 1 mysql mysql 124 May 19 02:09 mysql_upgrade_history drwxr-x--- 2 mysql mysql 4096 May 19 02:09 performance_schema -rw------- 1 mysql mysql 1705 May 19 02:09 private_key.pem -rw-r--r-- 1 mysql mysql 452 May 19 02:09 public_key.pem -rw-r--r-- 1 mysql mysql 1108 May 19 02:09 server-cert.pem -rw------- 1 mysql mysql 1705 May 19 02:09 server-key.pem drwxr-x--- 2 mysql mysql 4096 May 19 02:09 sys -rw-r----- 1 mysql mysql 16777216 May 19 02:11 undo_001 -rw-r----- 1 mysql mysql 16777216 May 19 02:11 undo_002 drwxr-x--- 2 mysql mysql 4096 May 19 02:09 xagent bash-5.1# mysql -u root -pxagent mysql: [Warning] Using a password on the command line interface can be insecure. Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 29 Server version: 8.4.0 MySQL Community Server - GPL

Copyright (c) 2000, 2024, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> SHOW DATABASES; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | performance_schema | | sys | | xagent | +--------------------+ 5 rows in set (0.01 sec)

mysql> USE mysql; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A

Database changed mysql> SHOW TABLES; +------------------------------------------------------+ | Tables_in_mysql | +------------------------------------------------------+ | columns_priv | | component | | db | | default_roles | | engine_cost | | func | | general_log | | global_grants | | gtid_executed | | help_category | | help_keyword | | help_relation | | help_topic | | innodb_index_stats | | innodb_table_stats | | ndb_binlog_index | | password_history | | plugin | | procs_priv | | proxies_priv | | replication_asynchronous_connection_failover | | replication_asynchronous_connection_failover_managed | | replication_group_configuration_version | | replication_group_member_actions | | role_edges | | server_cost | | servers | | slave_master_info | | slave_relay_log_info | | slave_worker_info | | slow_log | | tables_priv | | time_zone | | time_zone_leap_second | | time_zone_name | | time_zone_transition | | time_zone_transition_type | | user | +------------------------------------------------------+ 38 rows in set (0.00 sec)

mysql> exit Bye bash-5.1# exit exit

What's next? Try Docker Debug for seamless, persistent debugging tools in any container or image → docker debug xagent-xagent-mysql-1 Learn more at https://docs.docker.com/go/debug-cli/ PS C:\Users\JackyFeng\Desktop\ai scene\XAgent> docker-compose up -d

tecworks-dev commented 6 months ago

change docker-compose.yaml to xagent-mysql: image: mysql:8.3