Hello,
I have got some error messages on my Matotmo instance. It is installed on shared host, I monitor four low traffic website (less than 50 visits per day).
Apache server
Matomo version: 4.0.5
MySQL version: 10.5.13-MariaDB
PHP verzió: 7.4.33
On my dashboard I see this on place of Last visits graph and Channel types:
“SQLSTATE[HY000]: General error: 1637 Too many active concurrent transactions - in plugin Goals.” even I didn’t defined any Goals."
Movers and shakers and Overview of visitors shows this:
“Oops… there was a problem during the request. Maybe the server had a temporary issue, or maybe you requested a report with too much data. Please try again. If this error occurs repeatedly please contact your Matomo administrator for assistance.”
On system check page I’ve got the followings:
Database abilities:
✓ UTF8mb4 charset
! LOAD DATA INFILE
Using LOAD DATA INFILE will greatly speed Matomo’s archiving process up. To make it available to Matomo, try updating your PHP & MySQL software and make sure your database user has the FILE privilege.
If your Matomo server tracks high traffic websites (eg. > 100,000 pages per month), we recommend trying to fix this problem.
Hiba: LOAD DATA INFILE failed… Error was:
Try #1: LOAD DATA INFILE : SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user ‘xyz’@‘localhost’ (using password: YES)[28000],
Try #2: LOAD DATA LOCAL INFILE : SQLSTATE[HY000]: General error: 4166 The used command is not allowed because the MariaDB server or client has disabled the local infile capability
Troubleshooting: FAQ on matomo.org
✓ CREATE TEMPORARY TABLES
✓ Changing transaction isolation level
I contacted the hosting company and admin says: the problem comes from 10 MYSQL connection, what can be okay, but the 40+ AJAX query in the same time is too high. Reducing that numbers or just delay 100ms using settime can help.
So my question is: how can I reduce (if possible) that 40+ AJAX queries?
I tried to install old version of Piwik/Matomo, even the latest, before I contacted the hosting company, but no luck. So the current installation is fresh, databese size is small. And lastly, I’m not an expert on PHP or MYSQL…