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
Not showing any statistic after upgrading to 4.03 -- ./console core:archive is not working #16873
Comments
The output should actually explain the behavior:
Seems the archiving did run shortly before, so it's skipped... |
Then there might be an error while archiving. Could you look up an older run that maybe had errors? |
Where I can find the log that contains this error? Thanks |
If you don't have logs of older archiving runs you may simply trigger it manually on command line |
There is no error :( with the normal cron run. INFO [2020-12-03 09:00:01] 9742 --------------------------- But it is logging visits to the database |
Hi @valmedia we're planning to release Matomo 4.0.4 in the next 24 hours. The update might fix this issue. Let us know if that's not the case and we'll reopen and investigate further. If you could otherwise run |
INFO [2020-12-04 03:01:13] 12868 --------------------------- Thanks! |
Thanks for this. It looks like there are some "hanging" invalidations maybe. Any chance you could execute this SQL query select * from archive_invalidations where `status` != 0 You might need to replace Could you paste the returned result of the query? |
@tsteur Looking forward to it.
|
Hi @valmedia it seems you maybe created a segment and there's a longer queue to be finished before other reports will be archived again. This will quite likely be fixed in 4.0.5 when we still continue to process other archives as well even when not all other ones are processed yet fyi @diosmosis |
I notice the archive is being processed but the data is not being displayed on the dashboard. The latest report I can get is only yesterday. Could this be a timezone difference causing this? My server is saving data with GMT but my display setting is set as +8. |
I have the same problem since yesterday and the fresh update to 4.04 doesn't bring any change, but triggering archiving by browser works. This concerns only one site:
And |
Same problem here with 4.0.4. It worked with 4.0.0 (or at least a beta version). Luckily triggering archiving by browser works for us too. |
It affects all segments here including "All visits" |
@wcz-txp there is a table called @BigBerny So then nothing is being archived for you? I assumed you were having segment archiving trouble like other users. Can you post the output of running the command, |
Will do. But as I said, it works when I trigger archiving with the browser. So I don't know if archiving itself is the problem. I changed a segment from pre-processed to not-pro-processed a few days ago. Not sure if this is when it stopped working. |
Problem solved after updating to 4.05. Thanks a lot! |
Great to hear @wcz-txp cheers @diosmosis |
I checked
matomo_log_visit
.`visit_first_action_time table and it is recording entries so I think ./console core:archive is not workingINFO [2020-12-03 06:38:20] 18083 ---------------------------
INFO [2020-12-03 06:38:20] 18083 INIT
INFO [2020-12-03 06:38:20] 18083 Running Matomo 4.0.3 as Super User
INFO [2020-12-03 06:38:20] 18083 ---------------------------
INFO [2020-12-03 06:38:20] 18083 NOTES
INFO [2020-12-03 06:38:20] 18083 - Async process archiving supported, using CliMulti.
INFO [2020-12-03 06:38:20] 18083 - Reports for today will be processed at most every 600 seconds. You can change this value in Matomo UI > Settings > General Settings.
INFO [2020-12-03 06:38:20] 18083 - Archiving was last executed without error 1 min 38s ago
INFO [2020-12-03 06:38:20] 18083 ---------------------------
INFO [2020-12-03 06:38:20] 18083 START
INFO [2020-12-03 06:38:20] 18083 Starting Matomo reports archiving...
INFO [2020-12-03 06:38:20] 18083 Start processing archives for site 1.
INFO [2020-12-03 06:38:20] 18083 Finished archiving for site 1, 0 API requests, Time elapsed: 0.001s [1 / 1 done]
INFO [2020-12-03 06:38:20] 18083 Done archiving!
INFO [2020-12-03 06:38:20] 18083 ---------------------------
INFO [2020-12-03 06:38:20] 18083 SUMMARY
INFO [2020-12-03 06:38:20] 18083 Processed 0 archives.
INFO [2020-12-03 06:38:20] 18083 Total API requests: 0
INFO [2020-12-03 06:38:20] 18083 done: 0 req, 127 ms, no error
INFO [2020-12-03 06:38:20] 18083 Time elapsed: 0.127s
INFO [2020-12-03 06:38:20] 18083 ---------------------------
INFO [2020-12-03 06:38:20] 18083 SCHEDULED TASKS
INFO [2020-12-03 06:38:20] 18083 Starting Scheduled tasks...
INFO [2020-12-03 06:38:20] 18083 done
INFO [2020-12-03 06:38:20] 18083 ---------------------------
The text was updated successfully, but these errors were encountered: