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.
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 ?
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.