Posted by IgD on July 6, 2007 at 6:56pm
I'm have a multi-side Drupal configuration with 3 websites. On one of the websites, Cron will not run. In the logs section here is the error I am receiving: "Attempting to re-run cron while it is already running."
I deleted the cron_semaphore and cron_last fields from the variable table but that didn't help.
Is there any way to get a more verbose error? I'm stumped.
Comments
Let me get the "dumb
Let me get the "dumb quesiton" out of the way first: Are you certain that the crontab commands specify the correct sites?
Are you running the three cron jobs at the same time? I would try find out how long it takes to run the cron jobs for each of the sites. A BFI way would be to run the cron tasks from the command line one by one and time them. I suppose that you ought to be able to run the cron jobs simultaneously, but it seems to me a good idea to spread them out a bit.
Try adjusting the times of the cron task for each site like this:
0 * * * * curl --silent --compressed http://www.domain1.com/cron.php
20 * * * * curl --silent --compressed http://www.domain2.com/cron.php
40 * * * * curl --silent --compressed http://www.domain3.com/cron.php
Cron problem with Filter module
Hi,
Sorry but as I don't know where to get some help I try here also.
I get the "Cron has been running for too long" error and I've found that Cron job stops on FILTER which is a core required module, so I wonder what I can do to investigate more about causes of the problem with this module.
Thanks a lot.
is contab configured correctly?
Let me get the "dumb question" out of the way first: Are you certain that the crontab commands specify the correct sites?
Are you running the three cron jobs at the same time? I would try find out how long it takes to run the cron jobs for each of the sites. A BFI way would be to run the cron tasks from the command line one by one and time them. I suppose that you ought to be able to run the cron jobs simultaneously, but it seems to me a good idea to spread them out a bit.
Try adjusting the times of the cron task for each site like this:
0 * * * * curl --silent --compressed http://www.domain1.com/cron.php
20 * * * * curl --silent --compressed http://www.domain2.com/cron.php
40 * * * * curl --silent --compressed http://www.domain3.com/cron.php
Here is what my crontab -l
Here is what my crontab -l returns:
[root@mywebsite root]# crontab -l
45 * * * * /usr/bin/wget -O - -q http://www.mywebsite1.com/cron.php
30 * * * * /usr/bin/wget -O - -q http://www.mywebsite2.com/cron.php
15 * * * * /usr/bin/wget -O - -q http://www.mywebsite3.com/cron.php
[root@mywebsite root]#
The site in question has hardly any content on it. I think there must be something hanging when cron runs.
I got it working.
I got it working. Apparently there were some remnants of uninstalled modules. When I went to admin / modules / uninstall and cleaned them out cron started working again!
Clearing old Logs
I run cron jobs using mysite.com/cron.php
sometimes I run it manually just to be sure
Log says it was successfully run.
But the logs are not getting flushed and now I have a log that goes into 1000's of pages....
Occasionally it gives following error:
location: http://mysite.com/cron.phpYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 query: UPDATE node SET status = 1, changed = 1207879674 WHERE nid IN() in /homepages/29/d90958518/htdocs/drupal-5.7/includes/database.mysqli.inc on line 151.
Any idea what is the problem. My apologies, if I pasted this issue at a wrong place.
I am using linux 1and1 host.
Linux infong579 2.6.16.33-20070131a-areca-filemon-3ware-e1000 #1 SMP Wed Jan 31 02:48:22 CET 2007 i686 GNU/LinuxThanks