netease-youdao / QAnything

Question and Answer based on Anything.
https://qanything.ai
GNU Affero General Public License v3.0
11.54k stars 1.12k forks source link

mysql.connector.errors.DatabaseError: 1040 (HY000): Too many connections #246

Open zhiquanl opened 5 months ago

zhiquanl commented 5 months ago

是否已有关于该错误的issue或讨论? | Is there an existing issue / discussion for this?

该问题是否在FAQ中有解答? | Is there an existing answer for this in FAQ?

当前行为 | Current Behavior

RTX 2080T with

期望行为 | Expected Behavior

No response

运行环境 | Environment

- OS:
- NVIDIA Driver:
- CUDA:
- docker:
- docker-compose:
- NVIDIA GPU:
- NVIDIA GPU Memory:

QAnything日志 | QAnything logs

No response

复现方法 | Steps To Reproduce

No response

备注 | Anything else?

No response

zhiquanl commented 5 months ago

Supplement for Current Behavior: RTX2080T with Qwen1.5-1.8B-Chat model. run with command:$ bash ./run.sh -c local -i 0 -b hf -m Qwen1.5-1.8B-Chat -t qwen-7b-chat , increase max_connections by edit volumes/mysql.conf from 1000 to 2000, still no luck. checked mysql used max connections is about 153 in mysql container internal shell.

zhiquanl commented 5 months ago

mysql> show global status like 'Max_used_connections'; +----------------------+-------+ | Variable_name | Value | +----------------------+-------+ | Max_used_connections | 152 | +----------------------+-------+ 1 row in set (0.01 sec)

mysql> show variables like '%max_connections%'; +------------------------+-------+ | Variable_name | Value | +------------------------+-------+ | max_connections | 151 | | mysqlx_max_connections | 100 | +------------------------+-------+ 2 rows in set (0.00 sec)

zhiquanl commented 5 months ago

looks like it not due to max_connections exceeded.

Saltsmart commented 5 months ago

Same problem. 遇到了同样的问题。 Here are two sanic api logs: sanic_api.log sanic_api.log

HelloTDK commented 5 months ago

Same problem. 遇到了同样的问题。 Here are two sanic api logs:

smartjx commented 5 months ago

image Same problem. 同样的问题。

smartjx commented 5 months ago

image mysql.conf里改10000没有用,还是在docker-compose-windows.yaml里面加上这句管用了 command: --max-connections=10000