Every hosting plan has its own limits and restrictions, which are designed to ensure stable server operation and protect it from excessive load. However, sometimes a user may encounter various errors when working with the SQL database. Such errors may indicate an incorrectly selected plan or too intensive work with the site, such as content updates, price changes, or other content population.

By paying attention to these errors, you can understand that certain plan limits have been exceeded, and you may want to consider upgrading the plan or optimizing the work with the database. We will look at some of the most common errors, as well as provide examples of such errors for better understanding.

Here’s the translation into English:

Possible Errors and Recommendations

MySQL Database Errors

• MySQL Queries (max_questions).

  • Description: This error occurs when a user exceeds the maximum allowed number of queries to the database server in a short period of time.
    Error Example

    PHP Warning: WordPress database error User 'testuser' has exceeded the 'max_questions' resource (current value: 275000) for query SHOW TABLES LIKE 'wp\_users' made by display_setup_form, referer: https://example.com/wp-admin/install.php
    

  • Explanation: This means that the number of database queries has exceeded the allowed limit. Consider optimizing Your queries or upgrading to a higher tier plan.

• MySQL Inserts (max_updates).

  • Description: This error occurs when a user exceeds the maximum allowed number of update operations (INSERT, UPDATE, DELETE) in a certain period of time.
    Error Example

    PHP Warning: Uncaught exception 'Exception' with message 'Error: User 'testuser' has exceeded the 'max_updates' resource (current value: 1300000)
    

  • Explanation: The error means that the limit on the number of database updates per hour has been exceeded (in this case - 1,300,000). This can happen due to uploading a large dump where each record is added with a separate query. The max_updates counter automatically resets every hour, so if You see such an error, You just need to wait a bit or upgrade to a more performant plan.

• MySQL Connections (max_connections_per_hour).

  • Description: This error occurs when a user exceeds the maximum allowed number of connections to the MySQL server in one hour. If a user exceeds this limit, new connections will not be allowed until the hour ends.
    Error Example

    PHP Warning: Uncaught mysqli_sql_exception: User 'testuser' has exceeded the 'max_connections_per_hour' resource (current value: 10000)
    

  • Explanation: This means that the number of database connections has exceeded the set limit. You might want to reduce the number of simultaneous connections or upgrade to a higher tier where the limit will have a greater value.

• MySQL Connections (max_user_connections).

  • Description: This error occurs when a user exceeds the maximum allowed number of simultaneous connections to the MySQL server.
    Error Example

    PHP Warning: mysql_connect() User 'testuser' has exceeded the 'max_user_connections' resource (current value: 15) in /var/www/example/data/www/example.com/l/login.inc.php on line 10
    

    Error Example

    PHP Warning: mysqli::mysqli(): (08004/1040): Too many connections in /var/www/example/data/www/example.com/wp-content/themes/point/functions.php on line 71, referer: https://example.com/
    

  • Explanation: This means that the number of simultaneous database connections has exceeded the allowed limit. Check the number of simultaneously connected users or applications and consider reducing them.

PHP Errors

• PHP Allocated Memory Limit (memory_limit).

  • Description: This error occurs when a PHP script exceeds the allocated memory limit set by the memory_limit directive in the PHP configuration.
    Error Example

    [error] [client 127.0.0.1] mmap() failed: [12] Cannot allocate memory, referer: https://example.com/wp-admin/post.php?post=1931&action=edit
    

  • Explanation: Increase the memory_limit value in PHP settings or optimize the script to consume less memory.

• PHP Script Execution Time (execution_time).

  • Description: This error occurs when the execution of a PHP script takes longer than set by the max_execution_time directive in the PHP configuration.
    Error Example

    [client 127.0.0.1] Timeout waiting for output from CGI script /var/www/example/php-bin/script.php, referer: http://example.com/
    [error] [client 127.0.0.1] Script timed out before returning headers: php,
    
    

  • Explanation: Increase the max_execution_time value or optimize the script to run faster.

• User Processes.

  • Description: This error occurs when the limit on the number of simultaneously running user processes, such as PHP scripts, FTP/SSH/IMAP sessions, etc., is exceeded.

    Error Examples

    [error] [client 127.0.0.1] (11)Resource temporarily unavailable: couldn't spawn child process: /var/www/example/php-bin/script.php
    [client 127.0.0.1] (11)Resource temporarily unavailable: couldn't create child process: 11: php
    [error] [client 127.0.0.1] (11)Resource temporarily unavailable: couldn't spawn child process: /var/www/example/php-bin/script.php
    

    Error Examples

    [error] [client 127.0.0.1] sh: 1: Cannot fork
    2018-09-09 15:41:15 - PHP Warning: mail(): Could not execute mail delivery program '/usr/sbin/sendmail -t -i -f example@example.com' in /var/www/example/data/www/example.com/system/library/mail/mail.php on line 77
    

  • Explanation: Reduce the number of simultaneously running processes or consider upgrading to a higher tier plan.

Email Sending Errors

• Email Sending Limit.

  • Description: This error occurs when the limit on the number of emails sent per hour is exceeded.
    Error Example

    2024-05-29 18:33:57 H=([127.0.0.1]) [201.131.246.243] Warning: Sender rate overlimit - 50.3 / 1h / user@example.com
    

  • Explanation: Reduce the number of emails sent per hour or consider upgrading to a higher tier plan.

• If emails are not being sent using the built-in email client or external email service.

  • Description: Such an error can occur when the space set in the mailbox properties has been exceeded.

  

  • Explanation: Change the mailbox size if it was full. For the changes to take effect, You’ll need to turn off and then turn on the mailbox. Alternatively, You can reassign the password.