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

Visitor log report timing out for superusers #17741

Open
tomper00 opened this issue Jul 7, 2021 · 1 comment
Open

Visitor log report timing out for superusers #17741

tomper00 opened this issue Jul 7, 2021 · 1 comment
Labels
Waiting for user feedback Indicates the Matomo team is waiting for feedback from the author or other users.

Comments

@tomper00
Copy link

tomper00 commented Jul 7, 2021

We have an issue in 2 different Matomo environments where the visitor log view is timing out, but only for users with the super user role.
The error the user get is:
"Oops… there was a problem during the request. ...."

For users with less access it works fine.

Context

Both of these environments have quite a lot of data in them but the it happens for any website in the instans (event for the ones with almost no data in them).

For installations with the same codebase (and set up) with less data in them we do not see the issue, so it seems to be ralated to the overall size of the databases.

For some size references for the database (number of rows in one of the databases)
matomo_log_link_visit_action 840,903,526
matomo_log_visit 74,036,264

The total DB size is 514 GB

We are running Matomo 4.3.1

@tomper00 tomper00 added the Potential Bug Something that might be a bug, but needs validation and confirmation it can be reproduced. label Jul 7, 2021
@sgiehl
Copy link
Member

sgiehl commented Jul 8, 2021

Hi @tomper00
Did your super user maybe change the display limit at some point and Matomo tries to load a lot more data?
You could check if there is an entry in the option table where the option_name is viewDataTableParameters_user_Live.getLastVisitsDetails (you need to replace user with the users login).
If there is an higher filter_limit stored you can simply remove the record to reset it to the default.

@sgiehl sgiehl added Waiting for user feedback Indicates the Matomo team is waiting for feedback from the author or other users. and removed Potential Bug Something that might be a bug, but needs validation and confirmation it can be reproduced. labels Sep 3, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Waiting for user feedback Indicates the Matomo team is waiting for feedback from the author or other users.
Projects
None yet
Development

No branches or pull requests

3 participants