You signed in with another tab or window.
Reload
to refresh your session.
You signed out in another tab or window.
Reload
to refresh your session.
You switched accounts on another tab or window.
Reload
to refresh your session.
再次启动服务,就出现Mysql 数据库连接异常
异常信息:sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (1045, "Access denied for user 'xxx'@'localhost' (using password: NO)")
然后与知识库对话,直接异常!
What you expected to happen
服务不会乱产生数据源链接!多次重启要保证正常运行
How to reproduce
拉取最新的main 分支代码,数据库配置配为MySQL,然后在Mysql 创建好库和表
conda3 创建好虚拟环境,启动服务,创建自己的知识库,然后上传文本资料
再次启动服务,就出现Mysql 数据库连接异常
异常信息:sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (1045, "Access denied for user 'xxx'@'localhost' (using password: NO)")
然后与知识库对话,直接异常!
Additional context
No response
Are you willing to submit PR?
Yes I am willing to submit a PR!
再次启动服务,就出现Mysql 数据库连接异常
异常信息:sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (1045, "Access denied for user 'xxx'@'localhost' (using password: NO)")
然后与知识库对话,直接异常!
What you expected to happen
服务不会乱产生数据源链接!多次重启要保证正常运行
How to reproduce
拉取最新的main 分支代码,数据库配置配为MySQL,然后在Mysql 创建好库和表
conda3 创建好虚拟环境,启动服务,创建自己的知识库,然后上传文本资料
再次启动服务,就出现Mysql 数据库连接异常
异常信息:sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (1045, "Access denied for user 'xxx'@'localhost' (using password: NO)")
然后与知识库对话,直接异常!
Additional context
No response
Are you willing to submit PR?
Yes I am willing to submit a PR!
后台有什么报错日志吗?能把日志截图贴下吗?
遇到了一样的问题,报错日志如下。
...skipping...
File "/root/miniconda3/envs/dbgpt/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 898, in __connect
self.dbapi_connection = connection = pool._invoke_creator(self)
File "/root/miniconda3/envs/dbgpt/lib/python3.10/site-packages/sqlalchemy/engine/create.py", line 637, in connect
return dialect.connect(*cargs, **cparams)
File "/root/miniconda3/envs/dbgpt/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 615, in connect
return self.loaded_dbapi.connect(*cargs, **cparams)
raise exc_value.with_traceback(exc_tb)
File "/root/miniconda3/envs/dbgpt/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 898, in __connect
self.dbapi_connection = connection = pool._invoke_creator(self)
File "/root/miniconda3/envs/dbgpt/lib/python3.10/site-packages/sqlalchemy/engine/create.py", line 637, in connect
return dialect.connect(*cargs, **cparams)
File "/root/miniconda3/envs/dbgpt/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 615, in connect
return self.loaded_dbapi.connect(*cargs, **cparams)
self.__connect()
File "/root/miniconda3/envs/dbgpt/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 902, in __connect
with util.safe_reraise():
File "/root/miniconda3/envs/dbgpt/lib/python3.10/site-packages/sqlalchemy/util/langhelpers.py", line 147, in
exit
raise exc_value.with_traceback(exc_tb)
File "/root/miniconda3/envs/dbgpt/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 898, in __connect
self.dbapi_connection = connection = pool._invoke_creator(self)
File "/root/miniconda3/envs/dbgpt/lib/python3.10/site-packages/sqlalchemy/engine/create.py", line 637, in connect
return dialect.connect(*cargs, **cparams)
File "/root/miniconda3/envs/dbgpt/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 615, in connect
return self.loaded_dbapi.connect(*cargs, **cparams)
File "/root/miniconda3/envs/dbgpt/lib/python3.10/site-packages/pymysql/connections.py", line 358, in
init
self.connect()
File "/root/miniconda3/envs/dbgpt/lib/python3.10/site-packages/pymysql/connections.py", line 711, in connect
raise exc
sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (2003, "Can't connect to MySQL server on 'localhost' ([Errno 99] Cannot assign requested a
ddress)")
(Background on this error at:
https://sqlalche.me/e/20/e3q8
)
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/root/miniconda3/envs/dbgpt/lib/python3.10/logging/
init
.py", line 1100, in emit
msg = self.format(record)
File "/root/miniconda3/envs/dbgpt/lib/python3.10/logging/
init
.py", line 943, in format
return fmt.format(record)
File "/root/miniconda3/envs/dbgpt/lib/python3.10/logging/
init
.py", line 678, in format
record.message = record.getMessage()
File "/root/miniconda3/envs/dbgpt/lib/python3.10/logging/
init
.py", line 368, in getMessage
msg = msg % self.args
TypeError: not all arguments converted during string formatting
Call stack:
File "/root/miniconda3/envs/dbgpt/lib/python3.10/threading.py", line 973, in _bootstrap
self._bootstrap_inner()
File "/root/miniconda3/envs/dbgpt/lib/python3.10/threading.py", line 1016, in _bootstrap_inner
self.run()
File "/root/miniconda3/envs/dbgpt/lib/python3.10/threading.py", line 953, in run
self._target(*self._args, **self._kwargs)
File "/root/DB-GPT/pilot/summary/db_summary_client.py", line 166, in init_db_summary
logger.warn(
Message: 'mysql_default_sqlite, mysql summary error!(pymysql.err.OperationalError) (2003, "Can't connect to MySQL server on 'localhost' ([Errno 99] Can
not assign requested address)")\n(Background on this error at:
https://sqlalche.me/e/20/e3q8
)'
Arguments: (OperationalError('(pymysql.err.OperationalError) (2003, "Can't connect to MySQL server on 'localhost' ([Errno 99] Cannot assign requested a
ddress)")'),)