Jump to content

daily cron stop on Executing System Queue


Go to solution Solved by WHMCS JimmyW,

Recommended Posts

hi dear 

my cron stop and my site crash after daily cron run 

after i turn on debug and test it by comandline  

php -q /home/panelips/public_html/crons/cron.php all -F -vvv

out put is :

WHMCS Automation Task Utility: all
==================================

 Daily Cron Automation Mode

Queuing Tasks
-------------

 Force run any tasks: ignore "in progress" and "is due"
 Task queues ready

Executing Application Queue
---------------------------

  0/33 [░░░░░░░░░░░░░░░░░░░░░░░░░░░░]   0% < 1 sec/< 1 sec 30.0 MiB
 Currency Exchange Rates
  1/33 [░░░░░░░░░░░░░░░░░░░░░░░░░░░░]   3% < 1 sec/< 1 sec 30.0 MiB
 Product Pricing Updates
  2/33 [▓░░░░░░░░░░░░░░░░░░░░░░░░░░░]   6% < 1 sec/< 1 sec 30.0 MiB
 Tenant Usage Metrics
  3/33 [▓▓░░░░░░░░░░░░░░░░░░░░░░░░░░]   9% < 1 sec/< 1 sec 30.0 MiB
 Invoices
  4/33 [▓▓▓░░░░░░░░░░░░░░░░░░░░░░░░░]  12% 8 secs/1 min  34.0 MiB
 Late Fees
  5/33 [▓▓▓▓░░░░░░░░░░░░░░░░░░░░░░░░]  15% 10 secs/1 min  34.0 MiB
 Credit Card Charges
  6/33 [▓▓▓▓▓░░░░░░░░░░░░░░░░░░░░░░░]  18% 10 secs/55 secs 34.0 MiB
 Invoice & Overdue Reminders

  7/33 [▓▓▓▓▓░░░░░░░░░░░░░░░░░░░░░░░]  21%  1 min/7 mins 48.5 MiB
 Domain Renewal Notices
  8/33 [▓▓▓▓▓▓░░░░░░░░░░░░░░░░░░░░░░]  24%  1 min/6 mins 48.5 MiB
 Cancellation Requests
  9/33 [▓▓▓▓▓▓▓░░░░░░░░░░░░░░░░░░░░░]  27%  1 min/6 mins 48.5 MiB
 Overdue Suspensions
 10/33 [▓▓▓▓▓▓▓▓░░░░░░░░░░░░░░░░░░░░]  30%  1 min/5 mins 48.5 MiB
 Overdue Terminations
 11/33 [▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░░░░░░░░]  33%  1 min/5 mins 48.5 MiB
 Fixed Term Terminations
 12/33 [▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░░░░░░░]  36%  1 min/4 mins 48.5 MiB
 Inactive Tickets
 13/33 [▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░░░░░░]  39%  1 min/4 mins 50.5 MiB
 Prune Ticket Attachments
 14/33 [▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░░░░░░]  42%  1 min/3 mins 50.5 MiB
 Delayed Affiliate Commissions
 15/33 [▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░░░░░]  45%  1 min/3 mins 50.5 MiB
 Affiliate Reports
 16/33 [▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░░░░]  48%  1 min/3 mins 50.5 MiB
 Process Email Campaigns
 17/33 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░░░]  51%  1 min/3 mins 50.5 MiB
 Process Email Queue
 18/33 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░░]  54%  1 min/3 mins 50.5 MiB
 Email Marketer Rules
 19/33 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░]  57%  1 min/2 mins 50.5 MiB
  SSL Sync
 20/33 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░]  60%  1 min/2 mins 50.5 MiB
 Credit Card Expiry Notices
 21/33 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░░]  63%  1 min/2 mins 50.5 MiB
 Server Usage Stats
 22/33 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░]  66%  1 min/2 mins 50.5 MiB
 Overage Billing Charges
 23/33 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░]  69%  1 min/2 mins 50.5 MiB
 Client Status Update
 24/33 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░]  72%  1 min/2 mins 50.5 MiB
 Domain Expiry
 25/33 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░]  75%  1 min/2 mins 50.5 MiB
 Ticket Escalation Rules
 26/33 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░]  78%  1 min/2 mins 50.5 MiB
 Data Retention Pruning
 27/33 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░]  81%  1 min/2 mins 50.5 MiB
 Update Server Usage
 28/33 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░]  84%  1 min/1 min  50.5 MiB
 Update Server Meta Data
 29/33 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░]  87%  1 min/1 min  50.5 MiB
 Run Jobs Queue
 30/33 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░]  90%  1 min/1 min  52.5 MiB
 WHMCS Updates
 31/33 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░]  93%  1 min/1 min  56.5 MiB
 Domain Transfer Status Synchronisation
 32/33 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░]  96%  1 min/1 min  56.5 MiB
 Domain Status Synchronisation
 33/33 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓] 100%  1 min/1 min  56.5 MiB


 Sending Daily Cron Digest email

Executing System Queue
----------------------

 3/4 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░]  75% < 1 sec/< 1 sec 58.5 MiB


and it stop and my site crash again and it didnt compleate 

and i should reboot my main server

Link to comment
Share on other sites

On 4/4/2022 at 5:53 PM, masoodsajedi said:

hi dear 

my cron stop and my site crash after daily cron run 

after i turn on debug and test it by comandline  


php -q /home/panelips/public_html/crons/cron.php all -F -vvv

out put is :


WHMCS Automation Task Utility: all
==================================

 Daily Cron Automation Mode

Queuing Tasks
-------------

 Force run any tasks: ignore "in progress" and "is due"
 Task queues ready

Executing Application Queue
---------------------------

  0/33 [░░░░░░░░░░░░░░░░░░░░░░░░░░░░]   0% < 1 sec/< 1 sec 30.0 MiB
 Currency Exchange Rates
  1/33 [░░░░░░░░░░░░░░░░░░░░░░░░░░░░]   3% < 1 sec/< 1 sec 30.0 MiB
 Product Pricing Updates
  2/33 [▓░░░░░░░░░░░░░░░░░░░░░░░░░░░]   6% < 1 sec/< 1 sec 30.0 MiB
 Tenant Usage Metrics
  3/33 [▓▓░░░░░░░░░░░░░░░░░░░░░░░░░░]   9% < 1 sec/< 1 sec 30.0 MiB
 Invoices
  4/33 [▓▓▓░░░░░░░░░░░░░░░░░░░░░░░░░]  12% 8 secs/1 min  34.0 MiB
 Late Fees
  5/33 [▓▓▓▓░░░░░░░░░░░░░░░░░░░░░░░░]  15% 10 secs/1 min  34.0 MiB
 Credit Card Charges
  6/33 [▓▓▓▓▓░░░░░░░░░░░░░░░░░░░░░░░]  18% 10 secs/55 secs 34.0 MiB
 Invoice & Overdue Reminders

  7/33 [▓▓▓▓▓░░░░░░░░░░░░░░░░░░░░░░░]  21%  1 min/7 mins 48.5 MiB
 Domain Renewal Notices
  8/33 [▓▓▓▓▓▓░░░░░░░░░░░░░░░░░░░░░░]  24%  1 min/6 mins 48.5 MiB
 Cancellation Requests
  9/33 [▓▓▓▓▓▓▓░░░░░░░░░░░░░░░░░░░░░]  27%  1 min/6 mins 48.5 MiB
 Overdue Suspensions
 10/33 [▓▓▓▓▓▓▓▓░░░░░░░░░░░░░░░░░░░░]  30%  1 min/5 mins 48.5 MiB
 Overdue Terminations
 11/33 [▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░░░░░░░░]  33%  1 min/5 mins 48.5 MiB
 Fixed Term Terminations
 12/33 [▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░░░░░░░]  36%  1 min/4 mins 48.5 MiB
 Inactive Tickets
 13/33 [▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░░░░░░]  39%  1 min/4 mins 50.5 MiB
 Prune Ticket Attachments
 14/33 [▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░░░░░░]  42%  1 min/3 mins 50.5 MiB
 Delayed Affiliate Commissions
 15/33 [▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░░░░░]  45%  1 min/3 mins 50.5 MiB
 Affiliate Reports
 16/33 [▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░░░░]  48%  1 min/3 mins 50.5 MiB
 Process Email Campaigns
 17/33 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░░░]  51%  1 min/3 mins 50.5 MiB
 Process Email Queue
 18/33 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░░]  54%  1 min/3 mins 50.5 MiB
 Email Marketer Rules
 19/33 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░]  57%  1 min/2 mins 50.5 MiB
  SSL Sync
 20/33 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░]  60%  1 min/2 mins 50.5 MiB
 Credit Card Expiry Notices
 21/33 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░░]  63%  1 min/2 mins 50.5 MiB
 Server Usage Stats
 22/33 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░]  66%  1 min/2 mins 50.5 MiB
 Overage Billing Charges
 23/33 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░]  69%  1 min/2 mins 50.5 MiB
 Client Status Update
 24/33 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░]  72%  1 min/2 mins 50.5 MiB
 Domain Expiry
 25/33 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░]  75%  1 min/2 mins 50.5 MiB
 Ticket Escalation Rules
 26/33 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░]  78%  1 min/2 mins 50.5 MiB
 Data Retention Pruning
 27/33 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░]  81%  1 min/2 mins 50.5 MiB
 Update Server Usage
 28/33 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░]  84%  1 min/1 min  50.5 MiB
 Update Server Meta Data
 29/33 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░]  87%  1 min/1 min  50.5 MiB
 Run Jobs Queue
 30/33 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░]  90%  1 min/1 min  52.5 MiB
 WHMCS Updates
 31/33 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░]  93%  1 min/1 min  56.5 MiB
 Domain Transfer Status Synchronisation
 32/33 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░]  96%  1 min/1 min  56.5 MiB
 Domain Status Synchronisation
 33/33 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓] 100%  1 min/1 min  56.5 MiB


 Sending Daily Cron Digest email

Executing System Queue
----------------------

 3/4 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░]  75% < 1 sec/< 1 sec 58.5 MiB


and it stop and my site crash again and it didnt compleate 

and i should reboot my main server

What error do you get when your site crashes? It could be its running out of memory when the cron job runs. There is no need to reboot the server if a PHP script crashes unless your whole server is frozen which would in most cases mean its a memory issue.

Link to comment
Share on other sites

  • WHMCS Technical Analyst
  • Solution

HI masoodsajedi,

Cron Tasks that hang at this step are typically caused by a large database backups. 

I would recommend checking  your backup process and changing to an alternative backup method.

Once you have changed the backup method, re-attempting the same terminal command, should hopefully allow this to complete successfully.

Regards

Link to comment
Share on other sites

  • 1 month later...
On 4/7/2022 at 5:01 AM, WHMCS JimmyW said:

HI masoodsajedi,

Cron Tasks that hang at this step are typically caused by a large database backups. 

I would recommend checking  your backup process and changing to an alternative backup method.

Once you have changed the backup method, re-attempting the same terminal command, should hopefully allow this to complete successfully.

Regards

this was the solution for me, disable database backup and use alternative method to extract my mysql backup and this solved my problem.

Thank you very much!

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use & Guidelines and understand your posts will initially be pre-moderated