查询界面偶尔报2005, "Unknown MySQL server host

[czxin788]

1、现象

2、查看日志
docker log -f archery

[2023-01-07 00:26:22 +0800] [47] [INFO] Booting worker with pid: 47
[2023-01-07 00:26:22 +0800] [48] [INFO] Booting worker with pid: 48
[2023-01-07 12:10:28,828][MainThread:139747651802944][task_id:default][mysql.py:304][WARNING]- MySQL语句执行报错，语句：show databases，错误信息Traceback (most recent call last):
  File "/opt/archery/sql/engines/mysql.py", line 286, in query
    conn = self.get_connection(db_name=db_name)
  File "/opt/archery/sql/engines/mysql.py", line 49, in get_connection
    self.conn = MySQLdb.connect(
  File "/opt/venv4archery/lib/python3.9/site-packages/MySQLdb/__init__.py", line 130, in Connect
    return Connection(*args, **kwargs)
  File "/opt/venv4archery/lib/python3.9/site-packages/MySQLdb/connections.py", line 185, in __init__
    super().__init__(*args, **kwargs2)
MySQLdb._exceptions.OperationalError: (2005, "Unknown MySQL server host 'rm-xxxxxx2.mysql.rds.aliyuncs.com' (2)")

3、在服务上，ping 数据库地址，telnet 数据库端口都是通的；

4、使用的archery版本是 docker版本的archery 1.9.0；

5、这个问题是偶尔发生，很多情况都是正常的；

6、有人遇到过这个问题吗，是什么原因

[wangshili123]

我也不知道原因，但我发现去实例管理里面点一下右边的“测试“连接后，就正常了，已经出现很多次了，都是这个方式解决的

[czxin788]

谢谢