ERROR 1203 (42000): User ivr already has more than 'max_user_connections' active connections
来源:互联网 发布:像素软件 编辑:程序博客网 时间:2024/04/30 03:04
接到通知说mysql的连接数不够用了,让看看什么原因。
用root登录进去一看,当前的连接数远远没有达到max_connections 的连接限制。
让同事把错误信息发给我:
C:\Users\e1082>mysql -udev_ivr -pdev_ivr -h 192.168.1.150
ERROR 1203 (42000): User dev_ivr already has more than 'max_user_connections' active connections
原来是超出了max_user_connections的限制。
mysql> show variables like'max_user_connections';
+----------------------+-------+
| Variable_name | Value |
+----------------------+-------+
| max_user_connections | 100 |
+----------------------+-------+
1 row in set (0.00 sec)
正常情况下开发环境不应该出现这个情况,查看processlist后发现有一同事在进行测试,连接未及时释放导致。
- ERROR 1203 (42000): User ivr already has more than 'max_user_connections' active connections
- ERROR 1203 (42000): User root already has more than 'max_user_connections' active connections
- ERROR 1203 (42000): User root already has more than 'max_user_connections' active connections
- ERROR 1203 (42000): User root already has more than 'max_user_connections' active connections
- User perf_inventory already has more than 'max_user_connections' active connections
- SQLSTATE[HY000] [1203] User xxx already has more than 'max_user_connections' active co
- [MySQL]记录一次线上故障处理过程--> has more than 'max_user_connections' active connections
- [MySQL]记录一次线上故障处理过程--> has more than 'max_user_connections' active connections
- lua has more than 60 upvalues 解决办法
- ERROR 1172 (42000): Result consisted of more than one row
- error: more than one device and emulator
- error: more than one device and emulator .
- error: more than one device and emulator
- error: more than one device and emulator
- error: more than one device and emulator .
- error: more than one device/emulator
- Adb error: more than one device/emulator
- ADB error: more than one device/emulator
- toad for oracle 导入/导出 (Pump) 大数据(备忘贴)
- JavaScript常用浏览器对象总结
- poi的常用api .
- git 命令自动完成
- 并查集
- ERROR 1203 (42000): User ivr already has more than 'max_user_connections' active connections
- HTML&CSS学习总结
- 08-数据结构_线性结构-离散存储-链表_1
- ipseccmd
- 多声道音频数据和 WAVE 文件
- do while(FLASE)的妙用【转】
- hdu 4602题解
- 针对乐视网的主页无法打开的解决办法
- HDU--杭电--2191--悼念512汶川大地震遇难同胞——珍惜现在,感恩生活--背包