Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Lots of Cron entries in DB
 
chrisdarl
Member
 
Total Posts:  45
Joined:  2008-07-17
 

Hi there,

I’m currently setting up my crontab but running into a few problems.. one thing I noticed is that I seem to get alot of multiple entries in the database table “cron_schedule”

here’s a dump from my DB showing this as a example..

schedule_id Descending     job_code     status     messages     created_at     scheduled_at     executed_at     finished_at
    Edit     Delete     2958     newsletter_send_all     pending     NULL     2009
-08-10 10:28:01     2009-08-10 10:47:00     0000-00-00 00:00:00     0000-00-00 00:00:00
    Edit     Delete     2957     newsletter_send_all     pending     NULL     2009
-08-10 10:28:01     2009-08-10 10:46:00     0000-00-00 00:00:00     0000-00-00 00:00:00
    Edit     Delete     2956     newsletter_send_all     pending     NULL     2009
-08-10 10:28:01     2009-08-10 10:45:00     0000-00-00 00:00:00     0000-00-00 00:00:00
    Edit     Delete     2955     newsletter_send_all     pending     NULL     2009
-08-10 10:28:01     2009-08-10 10:44:00     0000-00-00 00:00:00     0000-00-00 00:00:00
    Edit     Delete     2954     newsletter_send_all     pending     NULL     2009
-08-10 10:28:01     2009-08-10 10:43:00     0000-00-00 00:00:00     0000-00-00 00:00:00
    Edit     Delete     2953     newsletter_send_all     pending     NULL     2009
-08-10 10:28:01     2009-08-10 10:42:00     0000-00-00 00:00:00     0000-00-00 00:00:00
    Edit     Delete     2952     newsletter_send_all     pending     NULL     2009
-08-10 10:28:01     2009-08-10 10:41:00     0000-00-00 00:00:00     0000-00-00 00:00:00
    Edit     Delete     2951     newsletter_send_all     pending     NULL     2009
-08-10 10:28:01     2009-08-10 10:40:00     0000-00-00 00:00:00     0000-00-00 00:00:00
    Edit     Delete     2950     newsletter_send_all     pending     NULL     2009
-08-10 10:28:01     2009-08-10 10:39:00     0000-00-00 00:00:00     0000-00-00 00:00:00
    Edit     Delete     2949     newsletter_send_all     pending     NULL     2009
-08-10 10:28:01     2009-08-10 10:38:00     0000-00-00 00:00:00     0000-00-00 00:00:00
    Edit     Delete     2948     newsletter_send_all     pending     NULL     2009
-08-10 10:28:01     2009-08-10 10:37:00     0000-00-00 00:00:00     0000-00-00 00:00:00
    Edit     Delete     2947     newsletter_send_all     pending     NULL     2009
-08-10 10:28:01     2009-08-10 10:36:00     0000-00-00 00:00:00     0000-00-00 00:00:00
    Edit     Delete     2946     newsletter_send_all     pending     NULL     2009
-08-10 10:28:01     2009-08-10 10:35:00     0000-00-00 00:00:00     0000-00-00 00:00:00
    Edit     Delete     2945     newsletter_send_all     pending     NULL     2009
-08-10 10:28:01     2009-08-10 10:34:00     0000-00-00 00:00:00     0000-00-00 00:00:00
    Edit     Delete     2944     newsletter_send_all     pending     NULL     2009
-08-10 10:28:01     2009-08-10 10:33:00     0000-00-00 00:00:00     0000-00-00 00:00:00
    Edit     Delete     2943     newsletter_send_all     pending     NULL     2009
-08-10 10:28:01     2009-08-10 10:32:00     0000-00-00 00:00:00     0000-00-00 00:00:00
    Edit     Delete     2942     newsletter_send_all     pending     NULL     2009
-08-10 10:28:01     2009-08-10 10:31:00     0000-00-00 00:00:00     0000-00-00 00:00:00
    Edit     Delete     2941     newsletter_send_all     pending     NULL     2009
-08-10 10:28:01     2009-08-10 10:30:00     0000-00-00 00:00:00     0000-00-00 00:00:00
    Edit     Delete     2940     newsletter_send_all     pending     NULL     2009
-08-10 10:28:01     2009-08-10 10:29:00     0000-00-00 00:00:00     0000-00-00 00:00:00
    Edit     Delete     2939     newsletter_send_all     pending     NULL     2009
-08-10 10:28:01     2009-08-10 10:28:00     0000-00-00 00:00:00     0000-00-00 00:00:00
    Edit     Delete     2938     catalogindex_run_queued     pending     NULL     2009
-08-10 10:28:01     2009-08-10 10:47:00     0000-00-00 00:00:00     0000-00-00 00:00:00
    Edit     Delete     2937     catalogindex_run_queued     pending     NULL     2009
-08-10 10:28:01     2009-08-10 10:46:00     0000-00-00 00:00:00     0000-00-00 00:00:00
    Edit     Delete     2936     catalogindex_run_queued     pending     NULL     2009
-08-10 10:28:01     2009-08-10 10:45:00     0000-00-00 00:00:00     0000-00-00 00:00:00
    Edit     Delete     2935     catalogindex_run_queued     pending     NULL     2009
-08-10 10:28:01     2009-08-10 10:44:00     0000-00-00 00:00:00     0000-00-00 00:00:00
    Edit     Delete     2934     catalogindex_run_queued     pending     NULL     2009
-08-10 10:28:01     2009-08-10 10:43:00     0000-00-00 00:00:00     0000-00-00 00:00:00
    Edit     Delete     2933     catalogindex_run_queued     pending     NULL     2009
-08-10 10:28:01     2009-08-10 10:42:00     0000-00-00 00:00:00     0000-00-00 00:00:00
    Edit     Delete     2932     catalogindex_run_queued     pending     NULL     2009
-08-10 10:28:01     2009-08-10 10:41:00     0000-00-00 00:00:00     0000-00-00 00:00:00
    Edit     Delete     2931     catalogindex_run_queued     pending     NULL     2009
-08-10 10:28:01     2009-08-10 10:40:00     0000-00-00 00:00:00     0000-00-00 00:00:00
    Edit     Delete     2930     catalogindex_run_queued     pending     NULL     2009
-08-10 10:28:01     2009-08-10 10:39:00     0000-00-00 00:00:00     0000-00-00 00:00:00
    Edit     Delete     2929     catalogindex_run_queued     pending     NULL     2009
-08-10 10:28:01     2009-08-10 10:38:00     0000-00-00 00:00:00     0000-00-00 00:00:00
    Edit     Delete     2928     catalogindex_run_queued     pending     NULL     2009
-08-10 10:28:01     2009-08-10 10:37:00     0000-00-00 00:00:00     0000-00-00 00:00:00
    Edit     Delete     2927     catalogindex_run_queued     pending     NULL     2009
-08-10 10:28:01     2009-08-10 10:36:00     0000-00-00 00:00:00     0000-00-00 00:00:00
    Edit     Delete     2926     catalogindex_run_queued     pending     NULL     2009
-08-10 10:28:01     2009-08-10 10:35:00     0000-00-00 00:00:00     0000-00-00 00:00:00
    Edit     Delete     2925     catalogindex_run_queued     pending     NULL     2009
-08-10 10:28:01     2009-08-10 10:34:00     0000-00-00 00:00:00     0000-00-00 00:00:00
    Edit     Delete     2924     catalogindex_run_queued     pending     NULL     2009
-08-10 10:28:01     2009-08-10 10:33:00     0000-00-00 00:00:00     0000-00-00 00:00:00
    Edit     Delete     2923     catalogindex_run_queued     pending     NULL     2009
-08-10 10:28:01     2009-08-10 10:32:00     0000-00-00 00:00:00     0000-00-00 00:00:00
    Edit     Delete     2922     catalogindex_run_queued     pending     NULL     2009
-08-10 10:28:01     2009-08-10 10:31:00     0000-00-00 00:00:00     0000-00-00 00:00:00
    Edit     Delete     2921     catalogindex_run_queued     pending     NULL     2009
-08-10 10:28:01     2009-08-10 10:30:00     0000-00-00 00:00:00     0000-00-00 00:00:00
    Edit     Delete     2920     catalogindex_run_queued     pending     NULL     2009
-08-10 10:28:01     2009-08-10 10:29:00     0000-00-00 00:00:00     0000-00-00 00:00:00
    Edit     Delete     2919     catalogindex_run_queued     pending     NULL     2009
-08-10 10:28:01     2009-08-10 10:28:00     0000-00-00 00:00:00     0000-00-00 00:00:00
    Edit     Delete     2878     newsletter_send_all     success     NULL     2009
-08-10 09:08:01     2009-08-10 09:27:00     2009-08-10 09:28:01     2009-08-10 09:28:01
    Edit     Delete     2877     newsletter_send_all     success     NULL     2009
-08-10 09:08:01     2009-08-10 09:26:00     2009-08-10 09:28:01     2009-08-10 09:28:01
    Edit     Delete     2876     newsletter_send_all     success     NULL     2009
-08-10 09:08:01     2009-08-10 09:25:00     2009-08-10 09:28:01     2009-08-10 09:28:01
    Edit     Delete     2875     newsletter_send_all     success     NULL     2009
-08-10 09:08:01     2009-08-10 09:24:00     2009-08-10 09:28:01     2009-08-10 09:28:01
    Edit     Delete     2874     newsletter_send_all     success     NULL     2009
-08-10 09:08:01     2009-08-10 09:23:00     2009-08-10 09:28:01     2009-08-10 09:28:01

Does anyone have any ideas why I have so many entries for the same task?

thanks,
Chris

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top