Both fail:
rearchive_reports_in_past_last_n_months = last0
and
rearchive_reports_in_past_last_n_months = 0
I’m currently using rearchive_reports_in_past_last_n_months = last1, which triggers past reports generation since February 1st as expected, but we are still facing the infinite loop.
Moreover, I realized that updating an existing Funnel will invalidate all existing reports. Thus, I definitely need to use last1 or maybe even last2 if I don’t want to impact the experience of my users.
Concerning the infinite loop, we have been deploying performance insight on AWS RDS to try to monitor the queries (most of them are the log_link_visit_action queries I posted in the first message of this topic). There is actually no query that takes more than 1 second, they are all very fast. But the process is still on-going after more than 25 hours… It seems to me that Matomo keeps doing the same queries forever.
FYI, for my Funnel, each day report since February 1st took only a couple of minutes to generate successfully, and each week took around 10 minutes. But it seems that the month of February is taking ages, and is still not done (25 hours and counting…).
Could we please keep this current topic to discuss the infinite loop, and discuss anything related to rearchive_reports_in_past_last_n_months in New Funnel triggers past report generation