Plesk 11 Upgrade Scheduled Backup not working

[abdi]

Well you know you can achieve that through cron ...

 

[BalvinderR]

ok, that means additional overhead. Don't you think it'll make the GUI Backup Manager useless.
We can anyhow take the backup through scripts. Parallels should make some way out for this.

 

[Alexander Bechtold]

Hi there,

so we have the problem, that we migrate from 10.4 to 11.0.9 and after it, no backups will be done. We make a post in another threat and no answers. Now i found this and yes, after put in the script from IgorG it works now, but only localy. We want to put them to ftp and they don´t make them, only local. Please help, so why it doesn`t work after update?

 

[scunnyutd]

Like BalvinderR says, does this script need to be run everytime we want to do a back up? Or, once run does it fix the problem and backups return to normal schedule? Does it need to be re-run after a system restart?

Please put some proper explanations up, this king of bug / error is critical to many panel users.

Just another warning that running the script causes the entire cron jobs to be run instantly, this ended up re-running tasks that were meant to run only on server reboot and crashed 7 online game servers by running them again even though they were already online. Great....

Still, at least i've got all the data backed up through scheduled backups... Oh wait.

 

[Josep Carreras]

Hi Igor,

THe script installed correctly, but when trying to schedule a backup, still fails with error " MySQL query failed: Unknown column 'backup_time' in 'field list'.

Any idea?
Running updated plesk 11.09 with Centos 5.8

Regards,

Josep

 

[IgorG]

Hi Igor,

THe script installed correctly, but when trying to schedule a backup, still fails with error " MySQL query failed: Unknown column 'backup_time' in 'field list'.

Any idea?
Running updated plesk 11.09 with Centos 5.8

Regards,

Josep

backup_time is field in BackupsScheduled table of psa database. I can assume only that database was not correctly upgraded. Try to do it with bootstrapper repair procedure.

 

[Josep Carreras]

Using ' /usr/local/psa/bootstrapper/pp11.0.9-bootstrapper/bootstrapper.sh repair' unfortunately did not fix the database (strange, because the sql files were present in the corresponding db folder.

So, I applied manually the sql string I found in the /usr/local/psa/bootstrapper/pp11.0.9-bootstrapper/db/pbm_db.sql file for the affected table and now it works.

 

[DragomirE]

How to fix this issue??? Automated backups still not working on latest version.

 

[ErwanG]

Hi there,

so we have the problem, that we migrate from 10.4 to 11.0.9 and after it, no backups will be done. We make a post in another threat and no answers. Now i found this and yes, after put in the script from IgorG it works now, but only localy. We want to put them to ftp and they don´t make them, only local. Please help, so why it doesn`t work after update?

We have the same problem.
The backup is on the server but not in the personnal ftp...

 

[ErwanG]

Igor ?

We have the problem on our ten servers with Plesk 11.
All the backup stay on the server.

 

[IgorG]

What exactly doesn't work? Details, logs, steps to reproduce? How you tried to troubleshoot it?

 

[ErwanG]

Before this script, the backup tasks was stopped since the Plesk 11 Upgrade.
After the script, the backup tasks are ok.

The backup task is activate with : store backup = Personal FTP repository.
But the backup stay in "Server repository".

The "Personal FTP Repository Settings" are ok.

 

[IgorG]

Any errors from backup logs?

 

[ErwanG]

In migration.log :

[04:18:10|INFO: 4934.log] pmm-ras finished. Exit code: 0

In pmmcli.log :

...
7127: 2012-09-28 02:14:04,757 DEBUG --> <pmmcli.MakeDumpAction object at 0xb76d59ac>
7127: 2012-09-28 02:14:04,757 INFO stdin: <backup-task-description><misc backup-profile-name="sauv_systeme_plesk" owner-guid="8fd222dc-15d3-4be5-be79-69039a1f83ed"/><dumps-storage-credentials storage-type="foreign-ftp" use-passive-ftp-mode="true"><login>w369694</login><password>PU5acedx</password><hostname>**********</hostname><root-dir>/</root-dir><file-name/></dumps-storage-credentials><backup-specification><backup-options type="full" compression-level="standard" suspend="false" rotation="3" mail-to="**********"/><object-to-backup type="server" all="true"/></backup-specification></backup-task-description>
7127: 2012-09-28 02:14:04,760 INFO Packet succesfully validated.
7127: 2012-09-28 02:14:04,762 DEBUG <pmmcli.ActionRunner object at 0xb76d0b8c>: doActivity
7127: 2012-09-28 02:14:04,842 INFO Executing asynchronously <subprocess[7129] '/usr/bin/perl /usr/local/psa/admin/bin/plesk_agent_manager server --owner-uid=8fd222dc-15d3-4be5-be79-69039a1f83ed --dump-rotation=3 --backup-profile-name=sauv_systeme_plesk --session-path=/usr/local/psa/PMM/sessions/2012-09-28-021404.436 --output-file=ftp://**********// --ftp-passive-mode'>
7127: 2012-09-28 02:14:04,842 DEBUG Acquired session mutex: MainThread
7127: 2012-09-28 02:14:04,849 DEBUG detecting running pmmcli daemon...
7127: 2012-09-28 02:14:04,871 DEBUG pmmcli daemon is running
7127: 2012-09-28 02:14:04,887 DEBUG Released session mutex: MainThread
7127: 2012-09-28 02:14:04,887 DEBUG Acquired session mutex: MainThread
7127: 2012-09-28 02:14:04,981 DEBUG Released session mutex: MainThread
7127: 2012-09-28 02:14:04,981 DEBUG <pmmcli.MakeDumpAction object at 0xb76d59ac>: response
7127: 2012-09-28 02:14:04,982 INFO Outgoing packet:
<?xml version="1.0" encoding="UTF-8"?>
<response>
<errcode>0</errcode>
<data>
<task-id>7129</task-id>
</data>
</response>
...

...
26452: 2012-09-28 03:36:23,456 DEBUG --> <pmmcli.GetTaskStatusAction object at 0xb77099cc>
26452: 2012-09-28 03:36:23,456 INFO parameters: ['7129']
26452: 2012-09-28 03:36:23,470 DEBUG <pmmcli.ActionRunner object at 0xb7704bac>: doActivity
26452: 2012-09-28 03:36:23,470 DEBUG Acquired session mutex: MainThread
26452: 2012-09-28 03:36:23,488 DEBUG Released session mutex: MainThread
26452: 2012-09-28 03:36:23,488 DEBUG <pmmcli.GetTaskStatusAction object at 0xb77099cc>: response
26452: 2012-09-28 03:36:23,489 INFO Outgoing packet:
<?xml version="1.0" encoding="UTF-8"?>
<response>
<errcode>0</errcode>
<data>
<task-status task-id="7129">
<working>
<dumping total-accounts="41" completed-domains="98" completed-accounts="41" total-domains="98">
</dumping>
</working>
</task-status>
</data>
</response>
...
26588: 2012-09-28 03:37:23,749 DEBUG Session path (/usr/local/psa/PMM/sessions/2012-09-28-021404.436)
26588: 2012-09-28 03:37:23,750 DEBUG Execution result file /usr/local/psa/PMM/sessions/2012-09-28-021404.436/migration.result exists but has wrong format. The task 7129 will be marked as finished with success.
26588: 2012-09-28 03:37:23,794 DEBUG Remove task 7129
26588: 2012-09-28 03:37:23,803 DEBUG Released session mutex: MainThread
26588: 2012-09-28 03:37:23,803 DEBUG <pmmcli.RemoveTaskDataAction object at 0xb76a69cc>: response
26588: 2012-09-28 03:37:23,804 INFO Outgoing packet:
<?xml version="1.0" encoding="UTF-8"?>
<response>
<errcode>0</errcode>
</response>
...

 

[IgorG]

I see no any errors in this log. Need more details and investigation directly on your server. Have you tried contact support team?

 

[Jay Versluis]

Here's a step by step article on how to install the script:

http://wpguru.co.uk/2012/09/how-to-bring-back-scheduled-backups-in-plesk-11/

Hope this helps! I've tested it on several systems and it works like a breeze. Thanks, Igor!

 

[RyannD]

Tha same problem here. Thanks for the help.

____________________________

Orange County SEO is a reputable SEO Company Based in Orange County, Ca. with proven results, dedicated to providing turn-key internet marketing solutions for large and small business owners who wish to gain more customers and viewership from the internet.

____________________________

 

[DragomirE]

Scheduled backups

.. I tried to apply the fix in this thread, backup was running but the file was not uploaded to remote host. I hope that the fix from http://wpguru.co.uk/2012/09/how-to-bring-back-scheduled-backups-in-plesk-11/ is going to help.

 

[ErwanG]

Igor, another information about the problem with remote host (Personal FTP repository).

I have made a backup (not a schedule) with theses parameters : Store backup in "Personal FTP repository", Back up : "Server configuration".
RESULT : OK. The file is on the "Personal FTP repository".

Another test vith a backup (not a schedule) with theses parameters : Store backup in "Personal FTP repository", Back up : "Server configuration and content".
RESULT : Backup ok but the file isn"t in the remote FTP ("Personal FTP repository") but in the "Server repository".

 

[DragomirE]

Remote repository upload problem

ErwanG, same problem here.