- Plesk for Linux
'Check and Repair' task in Subscriptions > example.com > Databases fails with the error:
PLESK_ERROR: Unable to check the database_name database for errors.
/var/log/plesk/panel.logcontains the following entries:
CONFIG_TEXT: ERR  PHP Warning: Error while sending QUERY packet. PID=22685; File: /opt/psa/admin/externals/Zend/Db/Statement/Pdo.php, Line: 228
ERR [panel] Task failed: id=596, pid=22685, type=database-check, error=MySQL server has gone away
is lower than required.
Increase the limits.
To increase the limit
max_allowed_packet, follow the guide from this article: How to set max_allowed_packet size for MySQL
If the first does not help, even with high values, increase the
Connect to the server via SSH ;
Connect to mysql:
# plesk db
Run the following query in MySQL console:
MYSQL_LIN: mysql> SET @@GLOBAL.wait_timeout=300;