Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
2.1.7
-
None
-
linux ubntu 14.04 n.a.
Description
MaxScale> list services
Services.
--------------------------------------------------------------------------------
Service Name | Router Module | #Users | Total Sessions | Backend databases
--------------------------------------------------------------------------------
MarGal101 | readconnroute | 2 | 35 | nodeA, nodeB, nodeC
MaxAdmin Service | cli | 2 | 2 |
--------------------------------------------------------------------------------
MaxScale> remove server nodeA MarGal101
Removed server 'nodeA' from 'MarGal101'
MaxScale> list services
Services.
--------------------------------------------------------------------------------
Service Name | Router Module | #Users | Total Sessions | Backend databases
--------------------------------------------------------------------------------
MarGal101 | readconnroute | 2 | 35 | nodeB, nodeC
MaxAdmin Service | cli | 2 | 2 |
--------------------------------------------------------------------------------
root@mariadb-10.2 [(none)] SQL> SELECT @@hostname, @@wsrep_node_name;
-----------------------------+
| @@hostname | @@wsrep_node_name |
-----------------------------+
| chef | Node A |
-----------------------------+
1 row in set (0.00 sec)
root@mariadb-10.2 [(none)] SQL> SELECT @@hostname, @@wsrep_node_name;
ERROR 2003 (HY000): Routing failed. Session is closed.
root@mariadb-10.2 [(none)] SQL> SELECT @@hostname, @@wsrep_node_name;
ERROR 2013 (HY000): Lost connection to MySQL server during query
root@mariadb-10.2 [(none)] SQL> SELECT @@hostname, @@wsrep_node_name;
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 24163
Current database: *** NONE ***
-----------------------------+
| @@hostname | @@wsrep_node_name |
-----------------------------+
| chef | Node B |
-----------------------------+
1 row in set (0.00 sec)