[Bug][ChatData] Chat Error Exception during reset or similar TimeoutErro

[fuLinHu]

Search before asking

• [X] I had searched in the issues and found no similar issues.

Operating system information

Linux

Python version information

3.10

DB-GPT version

latest release

Related scenes

• [X] Chat Data
• [ ] Chat Excel
• [X] Chat DB
• [ ] Chat Knowledge
• [ ] Model Management
• [ ] Dashboard
• [ ] Plugins

Installation Information

• [X] Installation From Source

• [ ] Docker Installation

• [ ] Docker Compose Installation

• [ ] Cluster Installation

• [ ] AutoDL Image

• [ ] Other

Device information

GPU -2 40G

Models information

vicuna-13b-v1.5 m3e-base

What happened

再进行数据问答得时候，系统突然卡死，任何接口都访问超时，大概20分钟以后报错 [2024-03-25 17:51:18] base | _finalize_fairy line:1008 [ERROR] : Exception during reset or similar Traceback (most recent call last): File "/home/bmsmart/conda/envs/flh_dbgpt_com_env/lib/python3.10/site-packages/pymysql/connections.py", line 779, in _read_bytes data = self._rfile.read(num_bytes) File "/home/bmsmart/conda/envs/flh_dbgpt_com_env/lib/python3.10/socket.py", line 705, in readinto return self._sock.recv_into(b) TimeoutError: [Errno 110] Connection timed out

During handling of the above exception, another exception occurred:

Traceback (most recent call last): File "/home/bmsmart/conda/envs/flh_dbgpt_com_env/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 986, in _finalize_fairy fairy._reset( File "/home/bmsmart/conda/envs/flh_dbgpt_com_env/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 1432, in _reset pool._dialect.do_rollback(self) File "/home/bmsmart/conda/envs/flh_dbgpt_com_env/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 692, in do_rollback dbapi_connection.rollback() File "/home/bmsmart/conda/envs/flh_dbgpt_com_env/lib/python3.10/site-packages/pymysql/connections.py", line 488, in rollback self._read_ok_packet() File "/home/bmsmart/conda/envs/flh_dbgpt_com_env/lib/python3.10/site-packages/pymysql/connections.py", line 448, in _read_ok_packet pkt = self._read_packet() File "/home/bmsmart/conda/envs/flh_dbgpt_com_env/lib/python3.10/site-packages/pymysql/connections.py", line 739, in _read_packet packet_header = self._read_bytes(4) File "/home/bmsmart/conda/envs/flh_dbgpt_com_env/lib/python3.10/site-packages/pymysql/connections.py", line 785, in _read_bytes raise err.OperationalError( pymysql.err.OperationalError: (2013, 'Lost connection to MySQL server during query ([Errno 110] Connection timed out)') [2024-03-25 18:06:56] base | _finalize_fairy line:1008 [ERROR] : Exception during reset or similar Traceback (most recent call last): File "/home/bmsmart/conda/envs/flh_dbgpt_com_env/lib/python3.10/site-packages/pymysql/connections.py", line 779, in _read_bytes data = self._rfile.read(num_bytes) File "/home/bmsmart/conda/envs/flh_dbgpt_com_env/lib/python3.10/socket.py", line 705, in readinto return self._sock.recv_into(b) TimeoutError: [Errno 110] Connection timed out

During handling of the above exception, another exception occurred:

Traceback (most recent call last): File "/home/bmsmart/conda/envs/flh_dbgpt_com_env/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 986, in _finalize_fairy fairy._reset( File "/home/bmsmart/conda/envs/flh_dbgpt_com_env/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 1432, in _reset pool._dialect.do_rollback(self) File "/home/bmsmart/conda/envs/flh_dbgpt_com_env/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 692, in do_rollback dbapi_connection.rollback() File "/home/bmsmart/conda/envs/flh_dbgpt_com_env/lib/python3.10/site-packages/pymysql/connections.py", line 488, in rollback self._read_ok_packet() File "/home/bmsmart/conda/envs/flh_dbgpt_com_env/lib/python3.10/site-packages/pymysql/connections.py", line 448, in _read_ok_packet pkt = self._read_packet() File "/home/bmsmart/conda/envs/flh_dbgpt_com_env/lib/python3.10/site-packages/pymysql/connections.py", line 739, in _read_packet packet_header = self._read_bytes(4) File "/home/bmsmart/conda/envs/flh_dbgpt_com_env/lib/python3.10/site-packages/pymysql/connections.py", line 785, in _read_bytes raise err.OperationalError( pymysql.err.OperationalError: (2013, 'Lost connection to MySQL server during query ([Errno 110] Connection timed out)') [2024-03-25 18:22:34] base | _finalize_fairy line:1008 [ERROR] : Exception during reset or similar Traceback (most recent call last): File "/home/bmsmart/conda/envs/flh_dbgpt_com_env/lib/python3.10/site-packages/pymysql/connections.py", line 779, in _read_bytes data = self._rfile.read(num_bytes) File "/home/bmsmart/conda/envs/flh_dbgpt_com_env/lib/python3.10/socket.py", line 705, in readinto return self._sock.recv_into(b) TimeoutError: [Errno 110] Connection timed out

During handling of the above exception, another exception occurred:

Traceback (most recent call last): File "/home/bmsmart/conda/envs/flh_dbgpt_com_env/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 986, in _finalize_fairy fairy._reset( File "/home/bmsmart/conda/envs/flh_dbgpt_com_env/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 1432, in _reset pool._dialect.do_rollback(self) File "/home/bmsmart/conda/envs/flh_dbgpt_com_env/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 692, in do_rollback dbapi_connection.rollback() File "/home/bmsmart/conda/envs/flh_dbgpt_com_env/lib/python3.10/site-packages/pymysql/connections.py", line 488, in rollback self._read_ok_packet() File "/home/bmsmart/conda/envs/flh_dbgpt_com_env/lib/python3.10/site-packages/pymysql/connections.py", line 448, in _read_ok_packet pkt = self._read_packet() File "/home/bmsmart/conda/envs/flh_dbgpt_com_env/lib/python3.10/site-packages/pymysql/connections.py", line 739, in _read_packet packet_header = self._read_bytes(4) File "/home/bmsmart/conda/envs/flh_dbgpt_com_env/lib/python3.10/site-packages/pymysql/connections.py", line 785, in _read_bytes raise err.OperationalError( pymysql.err.OperationalError: (2013, 'Lost connection to MySQL server during query ([Errno 110] Connection timed out)') [2024-03-25 18:38:12] base | _finalize_fairy line:1008 [ERROR] : Exception during reset or similar Traceback (most recent call last): File "/home/bmsmart/conda/envs/flh_dbgpt_com_env/lib/python3.10/site-packages/pymysql/connections.py", line 779, in _read_bytes data = self._rfile.read(num_bytes) File "/home/bmsmart/conda/envs/flh_dbgpt_com_env/lib/python3.10/socket.py", line 705, in readinto return self._sock.recv_into(b) TimeoutError: [Errno 110] Connection timed out

During handling of the above exception, another exception occurred:

Traceback (most recent call last): File "/home/bmsmart/conda/envs/flh_dbgpt_com_env/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 986, in _finalize_fairy fairy._reset( File "/home/bmsmart/conda/envs/flh_dbgpt_com_env/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 1432, in _reset pool._dialect.do_rollback(self) File "/home/bmsmart/conda/envs/flh_dbgpt_com_env/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 692, in do_rollback dbapi_connection.rollback() File "/home/bmsmart/conda/envs/flh_dbgpt_com_env/lib/python3.10/site-packages/pymysql/connections.py", line 488, in rollback self._read_ok_packet() File "/home/bmsmart/conda/envs/flh_dbgpt_com_env/lib/python3.10/site-packages/pymysql/connections.py", line 448, in _read_ok_packet pkt = self._read_packet() File "/home/bmsmart/conda/envs/flh_dbgpt_com_env/lib/python3.10/site-packages/pymysql/connections.py", line 739, in _read_packet packet_header = self._read_bytes(4) File "/home/bmsmart/conda/envs/flh_dbgpt_com_env/lib/python3.10/site-packages/pymysql/connections.py", line 785, in _read_bytes raise err.OperationalError( pymysql.err.OperationalError: (2013, 'Lost connection to MySQL server during query ([Errno 110] Connection timed out)') [2024-03-25 18:53:50] base | _finalize_fairy line:1008 [ERROR] : Exception during reset or similar Traceback (most recent call last): File "/home/bmsmart/conda/envs/flh_dbgpt_com_env/lib/python3.10/site-packages/pymysql/connections.py", line 779, in _read_bytes data = self._rfile.read(num_bytes) File "/home/bmsmart/conda/envs/flh_dbgpt_com_env/lib/python3.10/socket.py", line 705, in readinto return self._sock.recv_into(b) TimeoutError: [Errno 110] Connection timed out

During handling of the above exception, another exception occurred:

Traceback (most recent call last): File "/home/bmsmart/conda/envs/flh_dbgpt_com_env/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 986, in _finalize_fairy fairy._reset( File "/home/bmsmart/conda/envs/flh_dbgpt_com_env/lib/python3.10/site-packages/sqlalchemy/pool/base.py", line 1432, in _reset pool._dialect.do_rollback(self) File "/home/bmsmart/conda/envs/flh_dbgpt_com_env/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 692, in do_rollback dbapi_connection.rollback() File "/home/bmsmart/conda/envs/flh_dbgpt_com_env/lib/python3.10/site-packages/pymysql/connections.py", line 488, in rollback self._read_ok_packet() File "/home/bmsmart/conda/envs/flh_dbgpt_com_env/lib/python3.10/site-packages/pymysql/connections.py", line 448, in _read_ok_packet pkt = self._read_packet() File "/home/bmsmart/conda/envs/flh_dbgpt_com_env/lib/python3.10/site-packages/pymysql/connections.py", line 739, in _read_packet packet_header = self._read_bytes(4) File "/home/bmsmart/conda/envs/flh_dbgpt_com_env/lib/python3.10/site-packages/pymysql/connections.py", line 785, in _read_bytes raise err.OperationalError( pymysql.err.OperationalError: (2013, 'Lost connection to MySQL server during query ([Errno 110] Connection timed out)')

What you expected to happen

1.认为mysql数据链接sqlalchemy出现错误超时引起

How to reproduce

env，中修改数据库链接为mysql，数据问答用得也是mysql数据库，进行数据问答得时候，过一段时间就报错。

Additional context

No response

Are you willing to submit PR?

• [X] Yes I am willing to submit a PR!

[github-actions[bot]]

This issue has been marked as stale, because it has been over 30 days without any activity.

[github-actions[bot]]

This issue bas been closed, because it has been marked as stale and there has been no activity for over 7 days.