Magento Forums
Help
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Cron Schedule filled with duplicates

‎08-30-2018 01:43 AM
‎08-30-2018 01:43 AM

Cron Schedule filled with duplicates

Hi,

is it a feature or a bug that the cron_schedule table is bloated with duplicate jobs?
For example:

 

SELECT job_code, scheduled_at FROM cron_schedule LIMIT 100;

Returns:

+-----------------------------------------------+---------------------+
| job_code                                      | scheduled_at        |
+-----------------------------------------------+---------------------+
| smart_price_pricing_import                    | 2018-08-30 08:30:00 |
| smart_price_pricing_import                    | 2018-08-30 08:40:00 |
| catalog_product_outdated_price_values_cleanup | 2018-08-30 08:27:00 |
| catalog_product_outdated_price_values_cleanup | 2018-08-30 08:28:00 |
| catalog_product_outdated_price_values_cleanup | 2018-08-30 08:29:00 |
| catalog_product_outdated_price_values_cleanup | 2018-08-30 08:30:00 |
| catalog_product_outdated_price_values_cleanup | 2018-08-30 08:31:00 |
| catalog_product_outdated_price_values_cleanup | 2018-08-30 08:32:00 |
| catalog_product_outdated_price_values_cleanup | 2018-08-30 08:33:00 |
| catalog_product_outdated_price_values_cleanup | 2018-08-30 08:34:00 |
| catalog_product_outdated_price_values_cleanup | 2018-08-30 08:35:00 |
| catalog_product_outdated_price_values_cleanup | 2018-08-30 08:36:00 |
| catalog_product_outdated_price_values_cleanup | 2018-08-30 08:37:00 |
| catalog_product_outdated_price_values_cleanup | 2018-08-30 08:38:00 |
| catalog_product_outdated_price_values_cleanup | 2018-08-30 08:39:00 |
| catalog_product_outdated_price_values_cleanup | 2018-08-30 08:40:00 |
| catalog_product_outdated_price_values_cleanup | 2018-08-30 08:41:00 |
| catalog_product_outdated_price_values_cleanup | 2018-08-30 08:42:00 |
| catalog_product_outdated_price_values_cleanup | 2018-08-30 08:43:00 |
| catalog_product_outdated_price_values_cleanup | 2018-08-30 08:44:00 |
| catalog_product_outdated_price_values_cleanup | 2018-08-30 08:45:00 |
| catalog_product_outdated_price_values_cleanup | 2018-08-30 08:46:00 |
| catalog_product_frontend_actions_flush        | 2018-08-30 08:27:00 |
| catalog_product_frontend_actions_flush        | 2018-08-30 08:28:00 |
| catalog_product_frontend_actions_flush        | 2018-08-30 08:29:00 |
| catalog_product_frontend_actions_flush        | 2018-08-30 08:30:00 |
| catalog_product_frontend_actions_flush        | 2018-08-30 08:31:00 |
| catalog_product_frontend_actions_flush        | 2018-08-30 08:32:00 |
| catalog_product_frontend_actions_flush        | 2018-08-30 08:33:00 |
| catalog_product_frontend_actions_flush        | 2018-08-30 08:34:00 |
| catalog_product_frontend_actions_flush        | 2018-08-30 08:35:00 |
| catalog_product_frontend_actions_flush        | 2018-08-30 08:36:00 |
| catalog_product_frontend_actions_flush        | 2018-08-30 08:37:00 |
| catalog_product_frontend_actions_flush        | 2018-08-30 08:38:00 |
| catalog_product_frontend_actions_flush        | 2018-08-30 08:39:00 |
| catalog_product_frontend_actions_flush        | 2018-08-30 08:40:00 |
| catalog_product_frontend_actions_flush        | 2018-08-30 08:41:00 |
| catalog_product_frontend_actions_flush        | 2018-08-30 08:42:00 |
| catalog_product_frontend_actions_flush        | 2018-08-30 08:43:00 |
| catalog_product_frontend_actions_flush        | 2018-08-30 08:44:00 |
| catalog_product_frontend_actions_flush        | 2018-08-30 08:45:00 |
| catalog_product_frontend_actions_flush        | 2018-08-30 08:46:00 |
| catalog_product_attribute_value_synchronize   | 2018-08-30 08:30:00 |
| catalog_product_attribute_value_synchronize   | 2018-08-30 08:35:00 |
| catalog_product_attribute_value_synchronize   | 2018-08-30 08:40:00 |
| catalog_product_attribute_value_synchronize   | 2018-08-30 08:45:00 |
| sales_grid_order_async_insert                 | 2018-08-30 08:27:00 |
| sales_grid_order_async_insert                 | 2018-08-30 08:28:00 |
| sales_grid_order_async_insert                 | 2018-08-30 08:29:00 |
| sales_grid_order_async_insert                 | 2018-08-30 08:30:00 |
| sales_grid_order_async_insert                 | 2018-08-30 08:31:00 |
| sales_grid_order_async_insert                 | 2018-08-30 08:32:00 |
| sales_grid_order_async_insert                 | 2018-08-30 08:33:00 |
| sales_grid_order_async_insert                 | 2018-08-30 08:34:00 |
| sales_grid_order_async_insert                 | 2018-08-30 08:35:00 |
| sales_grid_order_async_insert                 | 2018-08-30 08:36:00 |
| sales_grid_order_async_insert                 | 2018-08-30 08:37:00 |
| sales_grid_order_async_insert                 | 2018-08-30 08:38:00 |
| sales_grid_order_async_insert                 | 2018-08-30 08:39:00 |
| sales_grid_order_async_insert                 | 2018-08-30 08:40:00 |
| sales_grid_order_async_insert                 | 2018-08-30 08:41:00 |
| sales_grid_order_async_insert                 | 2018-08-30 08:42:00 |
| sales_grid_order_async_insert                 | 2018-08-30 08:43:00 |
| sales_grid_order_async_insert                 | 2018-08-30 08:44:00 |
| sales_grid_order_async_insert                 | 2018-08-30 08:45:00 |
| sales_grid_order_async_insert                 | 2018-08-30 08:46:00 |
| sales_grid_order_invoice_async_insert         | 2018-08-30 08:27:00 |
| sales_grid_order_invoice_async_insert         | 2018-08-30 08:28:00 |
| sales_grid_order_invoice_async_insert         | 2018-08-30 08:29:00 |
| sales_grid_order_invoice_async_insert         | 2018-08-30 08:30:00 |
| sales_grid_order_invoice_async_insert         | 2018-08-30 08:31:00 |
| sales_grid_order_invoice_async_insert         | 2018-08-30 08:32:00 |
| sales_grid_order_invoice_async_insert         | 2018-08-30 08:33:00 |
| sales_grid_order_invoice_async_insert         | 2018-08-30 08:34:00 |
| sales_grid_order_invoice_async_insert         | 2018-08-30 08:35:00 |
| sales_grid_order_invoice_async_insert         | 2018-08-30 08:36:00 |
| sales_grid_order_invoice_async_insert         | 2018-08-30 08:37:00 |
| sales_grid_order_invoice_async_insert         | 2018-08-30 08:38:00 |
| sales_grid_order_invoice_async_insert         | 2018-08-30 08:39:00 |
| sales_grid_order_invoice_async_insert         | 2018-08-30 08:40:00 |
| sales_grid_order_invoice_async_insert         | 2018-08-30 08:41:00 |
| sales_grid_order_invoice_async_insert         | 2018-08-30 08:42:00 |
| sales_grid_order_invoice_async_insert         | 2018-08-30 08:43:00 |
| sales_grid_order_invoice_async_insert         | 2018-08-30 08:44:00 |
| sales_grid_order_invoice_async_insert         | 2018-08-30 08:45:00 |
| sales_grid_order_invoice_async_insert         | 2018-08-30 08:46:00 |
| sales_grid_order_shipment_async_insert        | 2018-08-30 08:27:00 |
| sales_grid_order_shipment_async_insert        | 2018-08-30 08:28:00 |
| sales_grid_order_shipment_async_insert        | 2018-08-30 08:29:00 |
| sales_grid_order_shipment_async_insert        | 2018-08-30 08:30:00 |
| sales_grid_order_shipment_async_insert        | 2018-08-30 08:31:00 |
| sales_grid_order_shipment_async_insert        | 2018-08-30 08:32:00 |
| sales_grid_order_shipment_async_insert        | 2018-08-30 08:33:00 |
| sales_grid_order_shipment_async_insert        | 2018-08-30 08:34:00 |
| sales_grid_order_shipment_async_insert        | 2018-08-30 08:35:00 |
| sales_grid_order_shipment_async_insert        | 2018-08-30 08:36:00 |
| sales_grid_order_shipment_async_insert        | 2018-08-30 08:37:00 |
| sales_grid_order_shipment_async_insert        | 2018-08-30 08:38:00 |
| sales_grid_order_shipment_async_insert        | 2018-08-30 08:39:00 |
| sales_grid_order_shipment_async_insert        | 2018-08-30 08:40:00 |
+-----------------------------------------------+---------------------+


Which seems to not be correct.

Why is each job created every minute?

Labels:
0 Kudos
Reply
4 REPLIES 4
‎08-30-2018 02:15 AM
‎08-30-2018 02:15 AM

Re: Cron Schedule filled with duplicates

Hello @Crtl,

 

Cronjob gets any error that's the way it's created multiple jobs. Can you please install below extension to check more detail about the error. 

 

https://kiwicommerce.co.uk/extensions/magento2-cron-scheduler/

 

--
If my answer is useful, please Accept as Solution & give Kudos

0 Kudos
Reply
‎09-04-2018 12:35 AM
‎09-04-2018 12:35 AM

Re: Cron Schedule filled with duplicates

No it does not, if status is scheduled as pending it hasnt been executed yet.

0 Kudos
Reply
‎03-09-2019 05:29 PM
‎03-09-2019 05:29 PM

Re: Cron Schedule filled with duplicates

Did you find a solution to this? I am having the same issue on 2.2.7

0 Kudos
Reply
‎09-12-2019 06:08 AM
‎09-12-2019 06:08 AM

Re: Cron Schedule filled with duplicates

Hi Guys,

I was also confused with this issue where magento is creatin multiple entries for same jobcode and I am able to fix it.

I have created the job schedule for 15 min on server 
https://prnt.sc/p57rci

and made these setting in admin
https://prnt.sc/p57rml

 

After making this setting I get all records success without any pending or missed.
https://prnt.sc/p57qm3

 

Please like if it works

Reply