3.8.1 Hosting errors are possible

Banner 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.

Reminder: Hosting plan limits are set to ensure stable server operation and protection from excessive load.

You can view all available limits for each plan on our website. Under each plan, there is a Details button that allows you to get more information.

The limits are in effect for one hour. If you have just exceeded one of the limits, you just need to wait an hour, and everything will automatically renew. To avoid repeated errors, we recommend considering the following options:

  • Site configuration: site optimization, database optimization.
  • Work planning: divide the work into parts that can be done over several hours.
  • Plan upgrade: consider upgrading to a more powerful plan. The change is possible once a day and at no additional cost. The validity period will be recalculated proportionally to the cost. In the future, you will be able to return to the previous plan.

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.

    Mailbox

    • 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.