We’re seeing an issue where sometimes, we can’t load the main page of Matomo without a few refreshes.
It does not seem to impact a site when within it.
The error is always similar to:
SELECT GET_LOCK('2022-06-222022-06-28.done.Goals','60');
At a loss what could cause this as we’ve even stopped all cron processes to ensure nothing is locking a table whilst archiving etc.
Anyone seen this before (current version) and an possible fix?
From MySQL slowlog.
# Time: 220705 19:19:16
# User@Host: matomo[matomo] @ [x.x.x.x]
# Thread_id: 310068 Schema: matomo QC_hit: No
# Query_time: 60.000396 Lock_time: 0.000000 Rows_sent: 1 Rows_examined: 0
# Rows_affected: 0 Bytes_sent: 103
SET timestamp=1657045156;
SELECT GET_LOCK('2022-06-222022-06-28.done.Goals','60');
Some further info.
This appears to happen only when the overview (list of all sites) defaults to “date range” for X days.
If we select today, or the last week and click “week”, the page is instant.
Setting the user prefs to “current week” solves the issue on the default page presentation.