Cron run fails when attempting to create a schedueld backup

kionae - March 31, 2009 - 15:30
Project:Backup and Migrate
Version:6.x-1.2
Component:Code
Category:support request
Priority:normal
Assigned:Unassigned
Status:active
Description

For about two weeks now, cron has been failing to run on my site (watchdog shows the message "Cron run exceeded the time limit and was aborted."). I finally managed to track down where it was failing using the suggestion in this post:
http://drupal.org/node/123269#comment-644012

As it turned out, cron.php was getting stuck when it hit the scheduled backups in Backup and Migrate, and timing out. I disabled the module and cron now runs normally. I have a feeling that the problem is the sheer size of my database (30,000+ nodes, 1.6 GB total size, and still nearly a gig even after excluding some of the less important tables) and the amount of time it takes to dump it all.

I've tried increasing PHP's max execution time, with no luck. Is there anything I can do to get Backup and Migrate to work with such a large setup? I'd really like to continue using it.

#1

ronan - April 4, 2009 - 05:07

I'm not really sure there's any more you can do other than upping your max execution time. That's a big db and is probably beyond what you can reasonably expect to be able to backup using a php based solution. I should maybe add some code to the module to check for timeouts so other people don't have to go to all that trouble to figure out why their cron is failing.

 
 

Drupal is a registered trademark of Dries Buytaert.