Categories
CentOS Linux Plesk

MySQL 5.5 update breaks scheduled backups

Found that a recent update of our Plesk 9.5.4 server had broken the scheduled backups although manual backups were still working fine. Its seems that after updating PHP to 5.3 and MySQL to version 5.5 the Plesk Backup Manager was erroring with :

backupmng: Unable to fetch backup tasks from database: BIGINT UNSIGNED value is out of range in '(-(weekday(`psa`.`BackupsScheduled`.`last`)) + `psa`.`BackupsScheduled`.`backup_day`)'
backupmng: Unable to fetch backup tasks from database: BIGINT UNSIGNED value is out of range in '(-(weekday(`psa`.`BackupsScheduled`.`last`)) + `psa`.`BackupsScheduled`.`backup_day`)' 

IgorG at the Parallels forums, highlighted that it was caused by incompatibility between backupmng and MySQL 5.5. To prevent unsigned int overflow following MySQL query he suggested the below command would help correct this issue:

mysql -u admin -p`cat /etc/psa/.psa.shadow`
use psa
ALTER TABLE BackupsScheduled MODIFY COLUMN backup_day INTEGER;

So far so good – it seems that scheduled backups are working again, and no other issues to report!

By Mik Canavan

I'm a tech obsessed and self-confessed geek. As the Technical Director at Fivenines UK, I'm lucky that I get to faf with gadgets, design websites and fix servers...

Leave a Reply

Your email address will not be published. Required fields are marked *