Symptoms
-
Unable to copy a database in Plesk > Domains > example.com > Databases > the Copy button with the error:
PLESK_ERROR: Errors occurred while executing: mysqldump: Got errno 32 on write
-
There is the following error message at
/var/log/plesk/panel.log
:DEBUG [panel] Db_Clone_Exception: Unable to clone database.
file: /usr/local/psa/admin/plib/Db/Clone/Task.php
line: 48
code: 0
trace: #0 /usr/local/psa/admin/plib/Db/Table/Broker/LongTasks.php(262): Db_Clone_Task->run()
#1 /usr/local/psa/admin/plib/Db/Table/Broker/LongTasks.php(180): Db_Table_Broker_LongTasks->_syncStart(object of type Db_Table_Row_LongTask)
#2 /usr/local/psa/admin/plib/Db/Table/Broker/LongTasks.php(112): Db_Table_Broker_LongTasks->_startQueue(object of type Db_Table_Row_LongTask, boolean true)
#3 /usr/local/psa/admin/plib/Task/Async/Executor.php(52): Db_Table_Broker_LongTasks->start(object of type Db_Table_Row_LongTask, string 'synchronously')
#4 /usr/local/psa/admin/plib/scripts/task-async-executor.php(12): Task_Async_Executor->execute()
Conditions
The value of the parameter max_allowed_packet
in the MySQL configuration is low.
Resolution
Increase the value of the parameter max_allowed_packet
as described in the following article:
How to set the value of max_allowed_packet or wait_timeout for MySQL on a Plesk server?