Unable to open a table in phpMyAdmin or restore a snapshot in Web Presence Builder for Plesk: Allowed memory size of X bytes exhausted

Symptoms

• When opening a large table in phpMyAdmin, the operation fails with the error message:

  CONFIG_TEXT: Error in processing request
  Error code: 500
  Error text: Internal Server Error

• When restoring a snapshot in Web Presence Builder, the operation fails with the error message:

  PLESK_INFO: Unable to connect to Web Presence Builder server. Please contact the server administrator.

• When trying to open Tools & Settings > Mail Queue page which lists a big number of email messages in the queue:

  PLESK_ERROR: Request failed with status code 500

• The following error message is logged in /var/log/plesk/panel.log:

  CONFIG_TEXT: PHP Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 401128 bytes) in /opt/psa/admin/htdocs/domains/databases/phpMyAdmin/libraries/DisplayResults.php on line 2852

  ---

  CONFIG_TEXT: PHP Fatal error: Out of memory (allocated 1279262720) (tried to allocate 1272971296 bytes) in /usr/local/psa/admin/plib/Service/Agent/Transport/Util.php on line 139

Cause

The size of PHP memory limit is insufficient to upload the object.

Resolution

1. Connect to the Plesk server via SSH.

2. Open the php.ini file in a text editor. In this example, we are using the vi editor:

   # vi /usr/local/psa/admin/conf/php.ini

3. Increase the value of memory_limit to a value higher than the uploaded object:

   CONFIG_TEXT: memory_limit = 4096M

4. Save the changes and close the file.

5. Restart the Plesk services to apply the changes:

   # service sw-cp-server restart && service sw-engine restart