[Bug] Funnels Plugin #23078
Comments
wiseguy1394
added
Potential Bug
|
Hey @wiseguy1394, |
|
@sgiehl I checked the logs again and now it has some new entries: Is it normal that it takes over 24h to calculate these reports for one day? |
|
If I run the archive command manually it is not hanging anymore... |
|
@sgiehl We have restarted our cron yesterday with -vvv option applied. This is the log output since restart: We have no clue whats the problem. 
Our database has no load either: 
So with these stats we would say that the cron is doing nothing, it's not going anywhere. |
|
Hm... Did you already create a couple of Funnels? Might be possible that the cron takes a while to create proper invalidations for those Funnels then. This might happen after the |
|
Hi @sgiehl, Here is some more information about our problems: The cron job has been running in debug mode for over 2 days now (see below for log output). There are thousands of DEBUG log entries before the next INFO entry is made. The last INFO entry was made 53 hours ago: There seems to be no parallel processing and the actual preparation of the reports is extremely delayed or does not happen at all. This is also shown by the graphs on the utilization of our systems above. More resources would therefore probably not solve the problem. These problems have only occurred since the “Funnels” plugin was installed and activated. We therefore assume a direct connection. What do we need to do to ensure that our reports are displayed correctly again? Cron log output: |
|
Thanks for the additional information. I'm actually not familiar enough with the Funnels plugins in order to say if that one could cause such problems. I would assume it might have triggered rearchiving of a lot of Funnels reports possibly. There is a "known" issue that slows down archiving if there are too many invalidations queued. Could you check your |
|
Oh, yes. There are a lot of records: The table has 3,801,869 records. 3,800,610 of these records have “Funnels” in their name. |
|
@AltamashShaikh are there any known issues with Funnels plugin creating so many invalidations? |
|
@sgiehl When a new Funnel is created, it will try to archive for older dates based on @dieisraels What is the value of |
|
The option |
|
We also use a lot of segments. Could it also help to activate the following option? Just to be sure: These options do not affect the creation of reports that have been explicitly invalidated? |
|
@dieisraels As far as I know that option should only have an affect on reports that are automatically invalidated by the system. You should then still be able to manually invalidate such reports using console command. You could try removing the Funnel invalidations that are for dates/segments you may not need. |
What happened?
We have bought and activated the funnels plugin. On last friday we started to use this plugin. Now all our stats are deprecated, because the archive cron is hanging with following logs:
There are no errors logged but it is hanging.
What should happen?
Archive cron should run as always.
How can this be reproduced?
We have activated the plugin and created some funnels and now the archive cron hangs.
Matomo version
5.2.2
PHP version
8.2.27
Server operating system
No response
What browsers are you seeing the problem on?
No response
Computer operating system
No response
Relevant log output
Validations
The text was updated successfully, but these errors were encountered: