添加链接
link管理
链接快照平台
  • 输入网页链接,自动生成快照
  • 标签化管理网页链接

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement . We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account
  • 再次启动服务,就出现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)")'),)

    值得一提的是,localhost并不是我配置文件中的数据库配置