@kaerer opened this Issue on March 16th 2020

Hi, we are using matomo version 3.12.0.
We have recently divide our database into master-slave type clusters.

When we defined database_reader configurations with slave information as below, we got SQLSTATE[HY000]: General error: 1290 The MariaDB server is running with the --read-only option so it cannot execute this statement error message.

[database]

[database_reader]

To make things work we define master for both of it.
We can not deactivate readonly option from slave, it wont sync the information with master.

Is there any extra configurations or misconfiguration ?

@tsteur commented on March 16th 2020 Member

I can only suppose it fails to create temporary tables on the reader. Not sure how your particular MariaDB version handles this. Maybe there is a setting or maybe it needs upgrading to a different version or so.

For now I would recommend you upgrade to the latest Matomo version and see if it works there maybe. This is recommended anyway to be compatible with recent browser changes in case you are using JavaScript tracking.

Powered by GitHub Issue Mirror