Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Regressed: Scheduled reports should be sent automatically by webcron, when cron is not setup #4612

Closed
mattab opened this issue Feb 3, 2014 · 11 comments
Assignees
Labels
Milestone

Comments

@mattab
Copy link
Member

@mattab mattab commented Feb 3, 2014

It used to work this way:

  • If cron is setup, then cron will send email reports and execute other scheduled tasks
  • When cron is not setup, then the piwik.php requests will act as a webcron, and trigger archiving and scheduled tasks automatically when visitors visit the website.

This seems to have regressed in 2.0 as we got several reports by users that this stopped working.

Let's investigate the webcron and fix. Hopefully we can add integration test for this feature?

@hpvd
Copy link

@hpvd hpvd commented Feb 3, 2014

maybe this is also the reason why piwik auto update is not working?

#4263

@hpvd
Copy link

@hpvd hpvd commented Feb 3, 2014

shouldn't it be possible to check in each installation if this is working fine via the TasksTimetable Plugin?

=> if there are only negative times to next scheduled task - so all cron jobs are in the past- no cron (standart nor webcron) is working

if so this problem is also in my installation because - otherwise I should have never seen/found this problem
#4540

@hpvd
Copy link

@hpvd hpvd commented Feb 3, 2014

if this influences also all standard task: delete, archive, optimize etc which could be seen in the TaskTimetable Plugin

Prio and Version to fix should be set as high as /near as possible...

what do you think?

@hpvd
Copy link

@hpvd hpvd commented Feb 3, 2014

Since I check for piwik update on our testing site at least once per week to latest version/beta, one could calculate from the entries in TaskTimetable Pluging when / in which version the problem starts...

please see attachement


Scheduled Tasks

The following tasks are scheduled to be executed based on the current server time Monday 3 February 2014 13:18:18.
Name Date (Server time)
Piwik_PrivacyManager.deleteLogData Tuesday 15 October 2013 00:00:51
(in -111 days 13 hours)
Piwik_PrivacyManager.deleteReportData Tuesday 15 October 2013 00:00:51
(in -111 days 13 hours)
Piwik_CoreAdminHome.purgeOutdatedArchives Tuesday 15 October 2013 00:00:51
(in -111 days 13 hours)
Piwik_CoreAdminHome.optimizeArchiveTable Tuesday 15 October 2013 00:00:53
(in -111 days 13 hours)
Piwik_UserCountry_GeoIPAutoUpdater.update Wednesday 16 October 2013 00:00:21
(in -110 days 13 hours)
GeoIPAutoUpdater.update Wednesday 18 December 2013 00:00:46
(in -47 days 13 hours)


@hpvd
Copy link

@hpvd hpvd commented Feb 3, 2014

@tsteur
Copy link
Member

@tsteur tsteur commented Feb 5, 2014

In d9f08bd: fixes #4612 do not bootstrap complete CronArchive when we just want to run scheduled tasks

@hpvd
Copy link

@hpvd hpvd commented Feb 5, 2014

thanks for the fix.
Just installed latest piwik master from github.

Since there is no change in list of tasks visible within TaskTimetable Plugin:

do we have to restart the webcron jobs with standard setting / standard tasks?
How to do so?
Or should the fix do this?

@tsteur
Copy link
Member

@tsteur tsteur commented Feb 5, 2014

It should be triggered at some point when visits are tracked.

@hpvd
Copy link

@hpvd hpvd commented Feb 7, 2014

@hpvd
Copy link

@hpvd hpvd commented Feb 7, 2014

sorry looks still the same - no new tasks :-(

@mattab
Copy link
Member Author

@mattab mattab commented Feb 8, 2014

I think it's a different bug @hpvd. Do you mind opening new one with this particular case of "tasks scheduled in the past are not running as expected".

@mattab mattab added this to the 2.1 - Piwik 2.1 milestone Jul 8, 2014
@mattab mattab added T: Bug labels Jul 8, 2014
@tsteur tsteur modified the milestones: 2.4.0 - Piwik 2.4.0, 2.1 - Piwik 2.1 Jul 11, 2014
sabl0r pushed a commit to sabl0r/piwik that referenced this issue Sep 23, 2014
…wser archiving is enabled. Also fixes lots of errors that happened when the actual tasks were executed. For instance Twig was not found, some DB methods were missing because TrackerDB is slightly different and so on. Therefore we reuse the CronArchive logic to trigger scheduled tasks via HTTP which makes sure they are executed the same way and not in a limited Tracker mode way
sabl0r pushed a commit to sabl0r/piwik that referenced this issue Sep 23, 2014
This issue was closed.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
3 participants