MariaDB Galera Cluster with MaxScale "SQLSTATE Syntax error"


(Martin Baumert) #1

Hi everybody,

i am using Piwik/Matomo with a MariaDB 10.3.13 Galera Cluster with MariaDB MaxScale (Read/Write Splitter between Master & Slave nodes).

When i execute the core:archive command via CLI, i get an “SQLSTATE Syntax error or access violation”

ERROR [2019-03-19 14:58:46] 17845  Got invalid response from API request: ?module=API&method=API.get&idSite=52&period=day&date=last52&format=php&trigger=archivephp. Response was 'a:2:{s:6:"result";s:5:"error";s:7:"message";s:427:"SQLSTATE[42000]: Syntax error or access violation: 1064 Routing query to backend failed. See the error log for further details. - in plugin Actions, caused by: SQLSTATE[42000]: Syntax error or access violation: 1064 Routing query to backend failed. See the error log for further details., caused by: SQLSTATE[42000]: Syntax error or access violation: 1064 Routing query to backend failed. See the error log for further details.";}'

I temporary migrate to a MariaDB 10.3.13 standalone instance, everything works fine.
It also works when i connect to the MariaDB Cluster Master node directly via IP and Port without using MaxScale.

Big contra without MaxScale: i have no loadbalancing and no high availability.

Someone knows a bugfix or workaround for that?

Thanks!

Martin