ERROR 1203 (42000): User IVR already has more than ' max_user_connections ' active connections

Source: Internet
Author: User

Received a notice that the number of MySQL connection is not enough, let's see what the reason.

Log in with Root to see that the current number of connections is far from the max_connections connection limit.

Ask my colleagues to send me the wrong message:

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

The original is beyond the max_user_connections limit.

Mysql> Show variables like ' max_user_connections ';

+----------------------+-------+

| variable_name | Value |

+----------------------+-------+

| max_user_connections | 100 |

+----------------------+-------+

1 row in Set (0.00 sec)

Under normal circumstances, the development environment should not be the case, after viewing Processlist found a colleague in the test, the connection was not released in time caused.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.