Cron Error

tubeman
Posts: 534
Joined: Sat Mar 02, 2013 11:33 am

Cron Error

Post by tubeman »

Hi,
I'm getting this in logs:

2019-03-15 13:16:28: Alert !!! Looks like crontab doesn't run cron.php every minute. Data file too big (0.018090009689331, 0.0084531307220459)

But when I check the cron its working fine and even script doesn't show any errors in main admin panel. Any idea how to fix this?

Regards,
admin
Site Admin
Posts: 37202
Joined: Wed Sep 10, 2008 11:43 am

Re: Cron Error

Post by admin »

Hi,

check scj/data

do you see any large files?
Don't forget to run script update
tubeman
Posts: 534
Joined: Sat Mar 02, 2013 11:33 am

Re: Cron Error

Post by tubeman »

Yes I do - hits.data and last_click.data
admin
Site Admin
Posts: 37202
Joined: Wed Sep 10, 2008 11:43 am

Re: Cron Error

Post by admin »

truncate those files
Don't forget to run script update
tubeman
Posts: 534
Joined: Sat Mar 02, 2013 11:33 am

Re: Cron Error

Post by tubeman »

How do I truncate those files exactly?
admin
Site Admin
Posts: 37202
Joined: Wed Sep 10, 2008 11:43 am

Re: Cron Error

Post by admin »

hmmm ... ok ...
edit - delete everything - save
Don't forget to run script update
tubeman
Posts: 534
Joined: Sat Mar 02, 2013 11:33 am

Re: Cron Error

Post by tubeman »

Where do I edit this exactly? Delete via FTP? Any commands in SSH that I should Run on those files?
tubeman
Posts: 534
Joined: Sat Mar 02, 2013 11:33 am

Re: Cron Error

Post by tubeman »

Hi, I checked via FTP they are only 20 MB files, weird why stats are not processing on the site
admin
Site Admin
Posts: 37202
Joined: Wed Sep 10, 2008 11:43 am

Re: Cron Error

Post by admin »

did you truncate files using any tool you can use ?
Don't forget to run script update
tubeman
Posts: 534
Joined: Sat Mar 02, 2013 11:33 am

Re: Cron Error

Post by tubeman »

Hi,
I still have this issue on 1 site which has high traffic:

2019-08-19 13:06:01: Alert !!! Looks like crontab doesn't run cron.php every minute. Data file too big (0.2136869430542, 0.20806193351746)

The weird part is that only during traffic peak hours the hourly stats get frozen, remaining hours its fine. I even tried truncating the files in scj/data via FTP but it did not help. Asked hosting to check and they said in server logs there are no errors for the crons, but in scj admin area cron.log I can see the alert. Generally during this kind of situation is there any php limit that needs to be increased on server? Please let me know.
Post Reply