Percona XtraDB and Locks: SQLSTATE[HY000]: General error: 1105 Percona-XtraDB-Cluster prohibits use of GET_LOCK with pxc_strict_mode = ENFORCING

Support & Bugs
1

Hi,

is there any option in the configuration file to prevent matomo to use locks on backend querys?
I always get this message

SQLSTATE[HY000]: General error: 1105 Percona-XtraDB-Cluster prohibits use of GET_LOCK with pxc_strict_mode = ENFORCING

when looking for some graphs. I would live with the problem that graph is not 100% accurate, if i could save my cluster replication for potential problems. Even if i setted up a explizit other db-server just for the interface.

Or is there any good reason to do this locking?

2

Hi,

Googling, I found:

As a lot of data can be received by Matomo at the same time, I presume Matomo must lock in order to prevent data inconsistency…