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

Error on processing a date range on actions/pages on high traffic site (2.16.0) #9851

Closed
patriiiiiiiiiick opened this issue Feb 25, 2016 · 6 comments
Assignees
Labels
worksforme The issue cannot be reproduced and things work as intended.
Milestone

Comments

@patriiiiiiiiiick
Copy link

When loading the following page with a high traffic site:

/piwik/index.php?module=CoreHome&action=index&idSite=37&period=range&date=2015-09-01,2016-02-24#?module=Actions&action=menuGetPageUrls&idSite=37&period=range&date=2015-09-01,2016-02-24

I get an error in the form "Oops… there was a problem during the request.".

I will enquire if there is an error in the log files.

@gaumondp
Copy link

Define "High traffic".

One of my user got such "Oops" when using date range but I never got them myself, even with his account so in my case it looks suspiciously related to the client computer sometimes.

BTW, 3 millions pageviews/month is my "high traffic" Piwik installation.

@tsteur
Copy link
Member

tsteur commented Feb 25, 2016

I will enquire if there is an error in the log files.

That would be good. Most likely it's due to not having enough memory. Increasing the memory will likely help.

@gaumondp
Copy link

@tsteur , which memory are you asking ? PHP ? MySQL ?

I'm at roughly 1GB/4GB used for my Apache/PHP/Piwik server. And on my MySQL Server it's currently 6GB used over 12 GB.

I'm interfering in the discussion because I've seen the error only on few "normal" users computers (querying same server of course) but I never as Super Admin and with a different computer got such "Oops".

I'm still wondering why such bizarre difference would happen...Ajax related? Network related ? Virus-free computer? ;) Win 8.1 versus Windows 7 ?

@tsteur
Copy link
Member

tsteur commented Feb 25, 2016

I asked re PHP memory.

There shouldn't be a difference between users I'd say. Maybe on other computers a different kind of segment was used or a larger date range? Or maybe it's just "by accident" in case it has only happened a few times that it happens on other computers but not on yours. There should be no difference between operating systems etc. It is hard to reproduce it as you would need to send the same request from two different computers. Problem is: Likely when the error occurred the first time on a computer some data got maybe already archived and when you try it on another computer the problem is not there anymore since some data was already archived meanwhile (if browser archiving is enabled)

@patriiiiiiiiiick
Copy link
Author

It is on a site with about a million visits and page views.

I didn't spot any memory capacity issue.

I had the report that there was a "Maximum execution time of 30 seconds exceeded" and that it was extended to 90s and that it now works. Indeed it now works but I believe it’s something else (DB restart?) that made it work. It was most probably a temporary load issue. As far as I am concerned, I would just close the issue.

@tsteur
Copy link
Member

tsteur commented Feb 26, 2016

Thanks for letting us know. I will close the issue.

@tsteur tsteur closed this as completed Feb 26, 2016
@tsteur tsteur added the worksforme The issue cannot be reproduced and things work as intended. label Feb 26, 2016
@tsteur tsteur added this to the 2.16.1 milestone Feb 26, 2016
@tsteur tsteur self-assigned this Feb 26, 2016
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
worksforme The issue cannot be reproduced and things work as intended.
Projects
None yet
Development

No branches or pull requests

3 participants