[MXS-2062] ERROR 1193: Unknown system variable 'maxscale_version' : SELECT @@maxscale_version Created: 2018-09-19 Updated: 2018-09-19 Resolved: 2018-09-19 |
|
| Status: | Closed |
| Project: | MariaDB MaxScale |
| Component/s: | N/A |
| Affects Version/s: | 2.2.14 |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Critical |
| Reporter: | Shannon | Assignee: | Unassigned |
| Resolution: | Not a Bug | Votes: | 0 |
| Labels: | galera | ||
| Environment: |
using maxscale 2.2.14 and 10.3.9-MariaDB with Galera |
||
| Description |
|
Galera is running on 3 MariaDB 10.3.9 servers successfully. Attempting to use maxscale 2.2.14 to route to the servers. All looks fine on both ends, but it is not working. This error is scrolling on the 3 MariaDB servers in the sql_error.log file: ERROR 1193: Unknown system variable 'maxscale_version' : SELECT @@maxscale_version |
| Comments |
| Comment by markus makela [ 2018-09-19 ] |
|
What monitor module are you using? Galera clusters should use the galeramon module but it does not perform the query in question. It is quite likely that you have configured the mariadbmon, intended for master-slave replication clusters, instead of the galeramon. The query you see in the error log is used by MaxScale to detect if the server is a binlogrouter server and is currently executed unconditonally. |
| Comment by Shannon [ 2018-09-19 ] |
|
thank you, yes. I just used the template the was bundled in the Redhat 7 package. I no longer see the errors. thanks very much. |
| Comment by markus makela [ 2018-09-19 ] |
|
Closing as Not a Bug since the issue was resolved with a change of monitor modules. |