SELECT GET_LOCK('2022-06-222022-06-28.done.Goals','60');

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.