Transitions popover sometimes fails to load - XHR request canceled

matomo-org / matomo

Empowering People Ethically with the leading open source alternative to Google Analytics that gives you full control over your data. Matomo lets you easily collect data from websites & apps and visualise this data and extract insights. Privacy is built-in. Liberating Web Analytics. Star us on Github? +1. And we love Pull Requests!

https://matomo.org/

GNU General Public License v3.0

19.83k stars 2.64k forks source link

Transitions popover sometimes fails to load - XHR request canceled #14935

Open mfb opened 5 years ago

mfb commented 5 years ago

I've noticed that the transitions popover sometimes fails to load. The XHR request loading the transitions data shows up in Chrome as status "canceled" or in Firefox the request just doesn't have a status.

Not sure what causes this sporadic failure - perhaps it's something like if the underlying page loads faster than the popover, then something in the page causes the popover data request to be canceled?

This can be seen sporadically at URLs like /index.php?module=CoreHome&action=index&idSite=1&period=day&date=2019-09-29#?idSite=1&period=week&date=2019-09-29&category=Dashboard_Dashboard&subcategory=1&popover=RowAction$3ATransitions$3Aurl$3Ahttps$3A$2F$2Fwww.eff.org$2Fdeeplinks$2F2018$2F08$2Ftelling-truth-about-defects-technology-should-never-ever-ever-be-illegal-ever

mattab commented 4 years ago

@mfb Thanks for the report. When this happens, can you check your web server error log for the error message? Probably PHP is timing out, or exhausting memory, or something similar.

mfb commented 4 years ago

I didn't (yet) find evidence of a PHP fatal error, thus my hypothesis that the issue is on the client side, related to the page loading at the same time that the XHR request should be sent (which would not be the "normal" situation when using the matomo UI, since the page would already be loaded). However I will reverify this.

mfb commented 4 years ago

@mattab I reverified this. There is no error on the PHP side. The request loads from the server just fine. The problem is on client side. See screenshot of canceled XHR request: Screenshot from 2020-01-22 13-07-26

Jaimeapo commented 2 years ago

Hello, any advances in this issue?? I just want to add some more info regarding this Issue. Reviewing the logs I´m getting the following error: Uncaught exception in API: /var/www/html/libs/Zend/Db/Statement/Mysqli.php(214): Mysqli statement execute error : Query execution was interrupted (max_statement_time exceeded) [Query: ?

tsteur commented 2 years ago

@mfb check out this FAQ https://matomo.org/faq/how-to/faq_161/ . This should fix that error.