pleskbackup failing

[Highland]

I'm having a major problem with pleskbackup. I cannot get it to run no matter what

pleskbackup --server

07:00:04 INFO ------------------------------------------------------------
07:00:04 INFO Migration status reporting initialized.
07:00:04 INFO Status file: /usr/local/psa/PMM/sessions/2009-07-07-020003.110/dump-status.xml
07:00:04 INFO ------------------------------------------------------------
07:05:09 ERROR Unable to execute SQL: MySQL server has gone away
07:06:46 ERROR Unable to execute SQL: MySQL server has gone away
07:14:34 ERROR Unable to execute SQL: MySQL server has gone away
07:17:35 ERROR Unable to execute SQL: MySQL server has gone away
07:21:39 ERROR Unable to execute SQL: MySQL server has gone away
07:25:23 ERROR The dump have been invalidated by check-dump operation
07:25:23 ERROR Runtime error: The check dump failed with code '1'. The dump can contain invalid data! at /usr/local/psa/admin/bin/plesk_agent_manager line 638.


== STDERR ====================
DBD::mysql::st execute failed: MySQL server has gone away at /usr/local/psa/PMM/agents/shared/Db/DbiBackend.pm line 66.
[repeats 4 more times]
/bin/tar: tmp/.chroot_admincmlXq0/ admin.unix: socket ignored
[repeats at least 2 dozen times]
Runtime error: The check dump failed with code '1'. The dump can contain invalid data! at /usr/local/psa/admin/bin/plesk_agent_manager line 638.

pleskbackup --client-name "Clientname"

13:35:33 INFO ------------------------------------------------------------
13:35:33 INFO Migration status reporting initialized.
13:35:33 INFO Status file: /usr/local/psa/PMM/sessions/2009-07-07-083532.995/dump-status.xml
13:35:33 INFO ------------------------------------------------------------
13:35:33 ERROR The following clients were not found on the host: Clientname
13:35:33 ERROR Runtime error: Unable to create dump: No objects to dump found


== STDERR ====================
The following clients were not found on the host: Clientname
Runtime error: Unable to create dump: No objects to dump found

Now I found this thread but the fix doesn't apply. I checked psa.misc and found no such parameter.

What else can I do?

 

[danliker]

check server load and i/o wait

maybe some services goes done on the heavy load of pleskbackup in plesk 9.2.1

 

[Highland]

It's not a load issue. The server is under no load when this is done.

 

[Highland]

Any other ideas? I tried removing and reinstalling the backaup manager and still no go.

 

[EduardoSilvestre]

Hello Highland,

as i can see in log the mysql server stop responding.

07:05:09 ERROR Unable to execute SQL: MySQL server has gone away
07:06:46 ERROR Unable to execute SQL: MySQL server has gone away
07:14:34 ERROR Unable to execute SQL: MySQL server has gone away
07:17:35 ERROR Unable to execute SQL: MySQL server has gone away
07:21:39 ERROR Unable to execute SQL: MySQL server has gone away

Try setting the wait_timeout in mysql configuration.

mysql -uadmin -p`cat /etc/psa/.psa.shadow`
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 577
Server version: 5.0.45 Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show variables;

wait_timeout | 10 (This is default value)

Try increased this value to 3600 or higher and try to perform the operation again.

Regards,

 

[Highland]

Mine is set to 28800 so no go. Thanks for trying tho.

 

[Highland]

So nobody at Parallels has any answers as to why this is happening? No backup system is working at present since going to 9.2.1