RAGFlow报错：peewee.OperationalError: (2013, ‘Lost connection to MySQL server during query‘)

于 2025-05-03 00:00:00 发布
阅读量123 收藏 1
点赞数 3
分类专栏： RAG 文章标签： rag ragflow
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_42672685/article/details/147474908
版权

环境：

Ragflowv0.17.2

问题描述：

RAGFlow报错：peewee.OperationalError: (2013, ‘Lost connection to MySQL server during query‘)

(ragflow) root@VM-16-4-debian:/home/www/ragflow/ragflow# bash docker/launch_backend_service.sh
Loading environment variables from: /home/www/ragflow/ragflow/docker/.env
Starting task_executor.py for task 0 (Attempt 1)
Starting ragflow_server.py (Attempt 1)
2025-04-24 11:06:17,853 INFO     2753895 ragflow_server log path: /home/www/ragflow/ragflow/logs/ragflow_server.log, log levels: {'peewee': 'WARNING', 'pdfminer': 'WARNING', 'root': 'INFO'}
2025-04-24 11:06:19,468 INFO     2753895 found 0 gpus
2025-04-24 11:06:21,454 INFO     2753895 init database on cluster mode successfully
2025-04-24 11:06:22,954 INFO     2753895 load_model /home/www/ragflow/ragflow/rag/res/deepdoc/det.onnx uses CPU
2025-04-24 11:06:23,018 INFO     2753895 load_model /home/www/ragflow/ragflow/rag/res/deepdoc/rec.onnx uses CPU
2025-04-24 11:06:28,480 INFO     2753895 
        ____   ___    ______ ______ __               
       / __ \ /   |  / ____// ____// /____  _      __
      / /_/ // /| | / / __ / /_   / // __ \| | /| / /
     / _, _// ___ |/ /_/ // __/  / // /_/ /| |/ |/ / 
    /_/ |_|/_/  |_|\____//_/    /_/ \____/ |__/|__/                             

    
2025-04-24 11:06:28,498 INFO     2753895 RAGFlow version: v0.17.2-316-g1e913184 full
2025-04-24 11:06:28,498 INFO     2753895 project base: /home/www/ragflow/ragflow
2025-04-24 11:06:28,498 INFO     2753895 Current configs, from /home/www/ragflow/ragflow/conf/service_conf.yaml:
        
2025-04-24 11:06:28,499 INFO     2753895 Use Elasticsearch http://localhost:1200 as the doc engine.
2025-04-24 11:06:28,579 INFO     2753895 GET http://localhost:1200/ [status:200 duration:0.079s]
2025-04-24 11:06:28,581 INFO     2753895 HEAD http://localhost:1200/ [status:200 duration:0.002s]
2025-04-24 11:06:28,581 INFO     2753895 Elasticsearch http://localhost:1200 is healthy.
2025-04-24 11:06:28,585 WARNING  2753895 Load term.freq FAIL!
2025-04-24 11:06:28,588 WARNING  2753895 Realtime synonym is disabled, since no redis connection.
2025-04-24 11:06:28,591 WARNING  2753895 Load term.freq FAIL!
2025-04-24 11:06:28,594 WARNING  2753895 Realtime synonym is disabled, since no redis connection.
2025-04-24 11:06:28,594 INFO     2753895 MAX_CONTENT_LENGTH: 134217728
2025-04-24 11:06:28,594 INFO     2753895 MAX_FILE_COUNT_PER_USER: 0
Traceback (most recent call last):
  File "/home/www/ragflow/ragflow/.venv/lib/python3.10/site-packages/peewee.py", line 3232, in connect
    self._state.set_connection(self._connect())
  File "/home/www/ragflow/ragflow/.venv/lib/python3.10/site-packages/playhouse/pool.py", line 76, in inner
    return fn(self, *args, **kwargs)
  File "/home/www/ragflow/ragflow/.venv/lib/python3.10/site-packages/playhouse/pool.py", line 169, in _connect
    conn = super(PooledDatabase, self)._connect()
  File "/home/www/ragflow/ragflow/.venv/lib/python3.10/site-packages/peewee.py", line 4201, in _connect
    conn = mysql.connect(db=self.database, autocommit=True,
  File "/home/www/ragflow/ragflow/.venv/lib/python3.10/site-packages/pymysql/connections.py", line 361, in __init__
    self.connect()
  File "/home/www/ragflow/ragflow/.venv/lib/python3.10/site-packages/pymysql/connections.py", line 668, in connect
    self._get_server_information()
  File "/home/www/ragflow/ragflow/.venv/lib/python3.10/site-packages/pymysql/connections.py", line 1098, in _get_server_information
    packet = self._read_packet()
  File "/home/www/ragflow/ragflow/.venv/lib/python3.10/site-packages/pymysql/connections.py", line 744, in _read_packet
    packet_header = self._read_bytes(4)
  File "/home/www/ragflow/ragflow/.venv/lib/python3.10/site-packages/pymysql/connections.py", line 798, in _read_bytes
    raise err.OperationalError(
pymysql.err.OperationalError: (2013, 'Lost connection to MySQL server during query')

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/home/www/ragflow/ragflow/api/ragflow_server.py", line 98, in <module>
    init_web_db()
  File "/home/www/ragflow/ragflow/.venv/lib/python3.10/site-packages/peewee.py", line 3127, in inner
    with ConnectionContext(self.db):
  File "/home/www/ragflow/ragflow/.venv/lib/python3.10/site-packages/peewee.py", line 3122, in __enter__
    self.db.connect()
  File "/home/www/ragflow/ragflow/.venv/lib/python3.10/site-packages/playhouse/pool.py", line 121, in connect
    return super(PooledDatabase, self).connect(reuse_if_open)
  File "/home/www/ragflow/ragflow/.venv/lib/python3.10/site-packages/peewee.py", line 3231, in connect
    with __exception_wrapper__:
  File "/home/www/ragflow/ragflow/.venv/lib/python3.10/site-packages/peewee.py", line 3059, in __exit__
    reraise(new_type, new_type(exc_value, *exc_args), traceback)
  File "/home/www/ragflow/ragflow/.venv/lib/python3.10/site-packages/peewee.py", line 192, in reraise
    raise value.with_traceback(tb)
  File "/home/www/ragflow/ragflow/.venv/lib/python3.10/site-packages/peewee.py", line 3232, in connect
    self._state.set_connection(self._connect())
  File "/home/www/ragflow/ragflow/.venv/lib/python3.10/site-packages/playhouse/pool.py", line 76, in inner
    return fn(self, *args, **kwargs)
  File "/home/www/ragflow/ragflow/.venv/lib/python3.10/site-packages/playhouse/pool.py", line 169, in _connect
    conn = super(PooledDatabase, self)._connect()
  File "/home/www/ragflow/ragflow/.venv/lib/python3.10/site-packages/peewee.py", line 4201, in _connect
    conn = mysql.connect(db=self.database, autocommit=True,
  File "/home/www/ragflow/ragflow/.venv/lib/python3.10/site-packages/pymysql/connections.py", line 361, in __init__
    self.connect()
  File "/home/www/ragflow/ragflow/.venv/lib/python3.10/site-packages/pymysql/connections.py", line 668, in connect
    self._get_server_information()
  File "/home/www/ragflow/ragflow/.venv/lib/python3.10/site-packages/pymysql/connections.py", line 1098, in _get_server_information
    packet = self._read_packet()
  File "/home/www/ragflow/ragflow/.venv/lib/python3.10/site-packages/pymysql/connections.py", line 744, in _read_packet
    packet_header = self._read_bytes(4)
  File "/home/www/ragflow/ragflow/.venv/lib/python3.10/site-packages/pymysql/connections.py", line 798, in _read_bytes
    raise err.OperationalError(
peewee.OperationalError: (2013, 'Lost connection to MySQL server during query')
2025-04-24 11:06:32,430 INFO     2753894 task_executor_0 log path: /home/www/ragflow/ragflow/logs/task_executor_0.log, log levels: {'peewee': 'WARNING', 'pdfminer': 'WARNING', 'root': 'INFO'}
2025-04-24 11:06:32,430 INFO     2753894 
  ______           __      ______                     __
 /_  __/___ ______/ /__   / ____/  _____  _______  __/ /_____  _____
  / / / __ `/ ___/ //_/  / __/ | |/_/ _ \/ ___/ / / / __/ __ \/ ___/
 / / / /_/ (__  ) ,<    / /____>  </  __/ /__/ /_/ / /_/ /_/ / /
/_/  \__,_/____/_/|_|  /_____/_/|_|\___/\___/\__,_/\__/\____/_/
    
2025-04-24 11:06:32,450 INFO     2753894 TaskExecutor: RAGFlow version: v0.17.2-316-g1e913184 full
2025-04-24 11:06:32,452 INFO     2753894 Use Elasticsearch http://localhost:1200 as the doc engine.
2025-04-24 11:06:32,456 INFO     2753894 GET http://localhost:1200/ [status:200 duration:0.002s]
2025-04-24 11:06:32,457 INFO     2753894 HEAD http://localhost:1200/ [status:200 duration:0.001s]
2025-04-24 11:06:32,457 INFO     2753894 Elasticsearch http://localhost:1200 is healthy.
2025-04-24 11:06:32,463 WARNING  2753894 Load term.freq FAIL!
2025-04-24 11:06:32,466 WARNING  2753894 Realtime synonym is disabled, since no redis connection.
2025-04-24 11:06:32,471 WARNING  2753894 Load term.freq FAIL!
2025-04-24 11:06:32,475 WARNING  2753894 Realtime synonym is disabled, since no redis connection.
2025-04-24 11:06:32,475 INFO     2753894 MAX_CONTENT_LENGTH: 134217728
2025-04-24 11:06:32,475 INFO     2753894 MAX_FILE_COUNT_PER_USER: 0
2025-04-24 11:06:32,477 WARNING  2753894 RedisDB.queue_info rag_flow_svr_queue got exception: no such key
2025-04-24 11:06:32,478 INFO     2753894 task_executor_0 reported heartbeat: {"name": "task_executor_0", "now": "2025-04-24T11:06:32.477+08:00", "boot_at": "2025-04-24T11:06:32.429+08:00", "pending": 0, "lag": 0, "done": 0, "failed": 0, "current": {}}
2025-04-24 11:06:32,479 WARNING  2753894 RedisDB.get_unacked_iterator queue rag_flow_svr_queue_1 doesn't exist
2025-04-24 11:06:32,479 WARNING  2753894 RedisDB.get_unacked_iterator queue rag_flow_svr_queue doesn't exist

解决方案：

后台详细日志分析：

(ragflow) root@VM-16-4-debian:/home/www/ragflow/ragflow# docker logs ragflow-mysql
2025-04-23 14:42:25+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.39-1.el9 started.
2025-04-23 14:42:25+08:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2025-04-23 14:42:25+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.39-1.el9 started.
'/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
2025-04-23T06:42:26.291788Z 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-04-23T06:42:26.292590Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
2025-04-23T06:42:26.292608Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.39) starting as process 1
2025-04-23T06:42:26.297891Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2025-04-23T06:42:26.422032Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2025-04-23T06:42:26.572884Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2025-04-23T06:42:26.572918Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2025-04-23T06:42:26.576037Z 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.
2025-04-23T06:42:26.591054Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock
2025-04-23T06:42:26.591152Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.39'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  MySQL Community Server - GPL.
2025-04-23T06:42:35.874393Z 9 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2025-04-23T10:37:10.316150Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>. Shutting down mysqld (Version: 8.0.39).
2025-04-23T10:37:11.228195Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.39)  MySQL Community Server - GPL.
2025-04-23 18:37:11+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.39-1.el9 started.
2025-04-23 18:37:11+08:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2025-04-23 18:37:11+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.39-1.el9 started.
'/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
2025-04-23T10:37:12.212791Z 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-04-23T10:37:12.214470Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
2025-04-23T10:37:12.214489Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.39) starting as process 1
2025-04-23T10:37:12.219766Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2025-04-23T10:37:12.334887Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2025-04-23T10:37:12.487151Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2025-04-23T10:37:12.487185Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2025-04-23T10:37:12.490244Z 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.
2025-04-23T10:37:12.505550Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock
2025-04-23T10:37:12.505623Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.39'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  MySQL Community Server - GPL.
2025-04-23T10:37:21.774723Z 9 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2025-04-24T03:32:36.363743Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>. Shutting down mysqld (Version: 8.0.39).
2025-04-24T03:32:37.498968Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.39)  MySQL Community Server - GPL.
2025-04-24 11:32:37+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.39-1.el9 started.
2025-04-24 11:32:38+08:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2025-04-24 11:32:38+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.39-1.el9 started.
'/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
2025-04-24T03:32:38.486345Z 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-04-24T03:32:38.488097Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
2025-04-24T03:32:38.488118Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.39) starting as process 1
2025-04-24T03:32:38.493547Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2025-04-24T03:32:38.612655Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2025-04-24T03:32:38.761578Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2025-04-24T03:32:38.761611Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2025-04-24T03:32:38.764615Z 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.
2025-04-24T03:32:38.779569Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock
2025-04-24T03:32:38.779627Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.39'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  MySQL Community Server - GPL.
2025-04-24T03:32:48.034286Z 9 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2025-04-24T03:34:02.303652Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>. Shutting down mysqld (Version: 8.0.39).
2025-04-24T03:34:03.199426Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.39)  MySQL Community Server - GPL.
2025-04-24 11:34:03+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.39-1.el9 started.
2025-04-24 11:34:04+08:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2025-04-24 11:34:04+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.39-1.el9 started.
'/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
2025-04-24T03:34:04.353987Z 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-04-24T03:34:04.355795Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
2025-04-24T03:34:04.355813Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.39) starting as process 1
2025-04-24T03:34:04.361075Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2025-04-24T03:34:04.519067Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2025-04-24T03:34:04.669016Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2025-04-24T03:34:04.669049Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2025-04-24T03:34:04.672033Z 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.
2025-04-24T03:34:04.687030Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock
2025-04-24T03:34:04.687116Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.39'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  MySQL Community Server - GPL.
2025-04-24T03:34:13.918498Z 9 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
(ragflow) root@VM-16-4-debian:/home/www/ragflow/ragflow# docker logs ragflow-mysql
2025-04-23 14:42:25+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.39-1.el9 started.
2025-04-23 14:42:25+08:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2025-04-23 14:42:25+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.39-1.el9 started.
'/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
2025-04-23T06:42:26.291788Z 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-04-23T06:42:26.292590Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
2025-04-23T06:42:26.292608Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.39) starting as process 1
2025-04-23T06:42:26.297891Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2025-04-23T06:42:26.422032Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2025-04-23T06:42:26.572884Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2025-04-23T06:42:26.572918Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2025-04-23T06:42:26.576037Z 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.
2025-04-23T06:42:26.591054Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock
2025-04-23T06:42:26.591152Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.39'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  MySQL Community Server - GPL.
2025-04-23T06:42:35.874393Z 9 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2025-04-23T10:37:10.316150Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>. Shutting down mysqld (Version: 8.0.39).
2025-04-23T10:37:11.228195Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.39)  MySQL Community Server - GPL.
2025-04-23 18:37:11+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.39-1.el9 started.
2025-04-23 18:37:11+08:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2025-04-23 18:37:11+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.39-1.el9 started.
'/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
2025-04-23T10:37:12.212791Z 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-04-23T10:37:12.214470Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
2025-04-23T10:37:12.214489Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.39) starting as process 1
2025-04-23T10:37:12.219766Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2025-04-23T10:37:12.334887Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2025-04-23T10:37:12.487151Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2025-04-23T10:37:12.487185Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2025-04-23T10:37:12.490244Z 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.
2025-04-23T10:37:12.505550Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock
2025-04-23T10:37:12.505623Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.39'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  MySQL Community Server - GPL.
2025-04-23T10:37:21.774723Z 9 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2025-04-24T03:32:36.363743Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>. Shutting down mysqld (Version: 8.0.39).
2025-04-24T03:32:37.498968Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.39)  MySQL Community Server - GPL.
2025-04-24 11:32:37+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.39-1.el9 started.
2025-04-24 11:32:38+08:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2025-04-24 11:32:38+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.39-1.el9 started.
'/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
2025-04-24T03:32:38.486345Z 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-04-24T03:32:38.488097Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
2025-04-24T03:32:38.488118Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.39) starting as process 1
2025-04-24T03:32:38.493547Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2025-04-24T03:32:38.612655Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2025-04-24T03:32:38.761578Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2025-04-24T03:32:38.761611Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2025-04-24T03:32:38.764615Z 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.
2025-04-24T03:32:38.779569Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock
2025-04-24T03:32:38.779627Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.39'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  MySQL Community Server - GPL.
2025-04-24T03:32:48.034286Z 9 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2025-04-24T03:34:02.303652Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>. Shutting down mysqld (Version: 8.0.39).
2025-04-24T03:34:03.199426Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.39)  MySQL Community Server - GPL.
2025-04-24 11:34:03+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.39-1.el9 started.
2025-04-24 11:34:04+08:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2025-04-24 11:34:04+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.39-1.el9 started.
'/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'
2025-04-24T03:34:04.353987Z 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-04-24T03:34:04.355795Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
2025-04-24T03:34:04.355813Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.39) starting as process 1
2025-04-24T03:34:04.361075Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2025-04-24T03:34:04.519067Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2025-04-24T03:34:04.669016Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2025-04-24T03:34:04.669049Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2025-04-24T03:34:04.672033Z 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.
2025-04-24T03:34:04.687030Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock
2025-04-24T03:34:04.687116Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.39'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  MySQL Community Server - GPL.
2025-04-24T03:34:13.918498Z 9 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
(ragflow) root@VM-16-4-debian:/home/www/ragflow/ragflow#

1.检查后是之前mysql端口没改好导致
在这里插入图片描述
2.重启mysql

docker compose -f docker/docker-compose-base.yml up -d --force-recreate mysql

在这里插入图片描述

3.恢复正常
在这里插入图片描述

评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

玩人工智能的辣条哥

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付：¥1
获取中
扫码支付

您的余额不足，请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值