• Tìm kiếm

Plesk and/or websites are inaccessible: SQLSTATE[08004] [1040] Too many connections error - Support Cases from Plesk Knowledge Base

avatar
admin
09:20 15/12/2024

Symptoms

  • The following error message appears in the Plesk interface or during Plesk migration process:

    Unable đồ sộ connect đồ sộ database: Too many connections
    SQLSTATE[08004] [1040] Too many connections

    ODBC error #HY000: [unixODBC][ma-3.0.8]Too many connections

  • Websites fail đồ sộ load with the error:

    Error Establishing a Database Connection

  • Plesk license installation fails with the error:

    Incorrect ServerInfo format (Error code: 2)

    exit status 1

Cause

The maximum number of simultaneous connections đồ sộ the MySQL databases has been reached and new connections đồ sộ the server cannot be established.

Resolution

For Plesk on Linux

Note: On Linux server with MySQL installed, the max_connections limit cannot be higher phàn nàn 214, unless the solution from this KB article is applied.

# Automatic Solution

    1. Connect đồ sộ the Plesk server via SSH.

    2. Download the script that will mix the MySQL parameter max_connections đồ sộ 300:

      # wget https://raw.githubusercontent.com/plesk/kb-scripts/master/mysql-max-connections/mysql-max-connections.sh

    3. Make the script executable:

      # chmod +x mysql-max-connections.sh

    4. Execute the script:

      # ./mysql-max-connections.sh

Note: If the automatic solution did not help, apply the manual solution below.

# Manual Solution

  1. Connect đồ sộ the Plesk server via SSH.

  2. Find the current max_connections value:

    # plesk db "SHOW VARIABLES LIKE 'max_connections'"
    +-----------------+-------+
    | Variable_name | Value |
    +-----------------+-------+
    | max_connections | 151 |
    +-----------------+-------+

  3. Open the MySQL configuration tệp tin my.cnf in a text editor. In this example, we are using the vi editor:

    • on CentOS/RHEL-based distributions

      # vi /etc/my.cnf

    • on Debian/Ubuntu-based distributions

      # vi /etc/mysql/my.cnf

  4. Increase the number of connections by adding this directive under the [MySQLD] section:

    [mysqld]
    max_connections=300

  5. Save the changes and close the tệp tin.

  6. Restart MySQL/MariaDB service đồ sộ apply the changes using one of these commands:

    # service mysql restart

    # service mariadb restart

For Plesk on Windows Server

  1. Connect đồ sộ the Plesk server via RDP.

  2. Open the MySQL configuration tệp tin %plesk_dir%DatabasesMySQLmy.ini in a text editor.

  3. Increase the number of connections by adding this directive under the [MySQLD] section (the mặc định value is 300):

    [MySQLD]
    max_connections=300

  4. Save the changes and close the tệp tin.

  5. Restart the MySQL/MariaDB service Plesk Management Service using Windows Plesk Services Monitor