Terrible errors with Pleskbackup on Plesk 9.3

[JadeW]

I am getting some errors when running Pleskbackup from shell, on Plesk 9.3 using this command:
/usr/local/psa/bin/pleskbackup --server -vvv --output-file="/var/backuptemp/pleskbackup"

The backup seems to run ok, apart from repeating lines like:

Accounts [147/148], Domains [361/361]
Accounts [147/148], Domains [361/361]
Accounts [147/148], Domains [361/361]
Accounts [147/148], Domains [361/361]
Accounts [147/148], Domains [361/361]

I have no idea why it repeats it is backing up domains, why on earth it doesn't just create one entry per domain I will have no idea.

The concerning part comes at the end of the backup, example:

-------------- Start print backup log hire --------------
<?xml version="1.0" encoding="UTF-8"?>
<execution-result status="warnings">
<object name="domain.com" type="domain">
<message severity="error" code="msgtext">Unable to execute SQL: MySQL server has gone away</message>
</object>
<object name="domain.com" type="domain">
<message severity="error" code="msgtext">Unable to execute SQL: MySQL server has gone away</message>
</object>
<object name="domain.com" type="domain">
<message severity="error" code="msgtext">Unable to execute SQL: MySQL server has gone away</message>
</object>
<object name="domain.com" type="domain">
<message severity="error" code="msgtext">Unable to execute SQL: MySQL server has gone away</message>
</object>
</object>
<object name="domain.com" type="domain">
<message severity="warning" code="msgtext">Timeout occured during mysql query. Reconnecting.</message>
</object>
<object name="domain.com" type="domain">
<message severity="warning" code="msgtext">Timeout occured during mysql query. Reconnecting.</message>
</object>
<object name="domain.com" type="domain">
<message severity="warning" code="msgtext">Timeout occured during mysql query. Reconnecting.</message>
</object>
<object name="domain.com" type="domain">
<message severity="warning" code="msgtext">Timeout occured during mysql query. Reconnecting.</message>
</object>
</execution-result>
-------------- End print backup log hire --------------

You can view additional information in the log file located in /usr/local/psa/PMM/sessions/2010-02-16-223012.638 directory. This directory will be removed automatically after 30 days

The backup finished with status 'warnings' and had some problems. Look at log file for detailed information.

The other problem is that the backup file does not seem to be outputting correctly. It should save as one archive in the /var/backuptemp directory but this is not occuring.

Can anyone help with this issue?

 

[IgorG]

Try to increase wait_timeout in my.cnf

 

[JadeW]

I followed your suggestion and increased wait_timeout in my.cnf to 300. Still the same problem.

Please provide assistance regarding this issue. I don't know why Swsoft is making simple things so difficult to work.

 

[IgorG]

It is not enough. Try 36000 there.
And please remember our company name - Parallels. But not SWSoft.

 

[JadeW]

Solved

Thank you, increasing the value to 36000 solved the backup error issue.