Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
2.5, 6
-
RHEL 7.4, MaxScale 2.5 and higher
Description
Customer could no longer connect to mariadb databases (galera cluster) after upgrading from MaxScale 2.4 to 2.5.
*Workaround/fix *: After numerous tries with different versions >2.5.x incl. 6.3 of maxscale, I was able to reproduce the customers issue and resolve the issue by removing/commenting the following from their maxscale.cnf: max_slave_replication_lag=1s. No matter what value was set, if max_slave_replication_lag was set it failed.
Note: this only fails with: module=galeramon, there are no errors with the mariadb client to connect and execute a query with module=mariadbmon.
Client error:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 1
Server version: 10.3.34-MariaDB-log
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> show databases;
ERROR 2006 (HY000): Server has gone away
No connection. Trying to reconnect...
Connection id: 2
Current database: *** NONE ***
ERROR 2013 (HY000): Lost connection to server during query
MaxScale Error:
Jun 6 20:47:14 localhost maxscale[1834880]: Could not find valid server for target type TARGET_SLAVE (COM_QUERY: show databases), closing connection.#012#012name: [Node1] status: [Slave, Synced, Running] state: [NOT_IN_USE] last opened at: [not opened] last closed at: [not closed] last close reason: [] #012name: [Node2] status: [Slave, Synced, Running] state: [NOT_IN_USE] last opened at: [not opened] last closed at: [not closed] last close reason: [] #012name: [Node3] status: [Master, Synced, Running] state: [IN_USE] last opened at: [Mon Jun 6 17:47:14 2022] last closed at: [not closed] last close reason: []
Jun 6 20:47:14 localhost maxscale[1834880]: Routing the query failed. Session will be closed.