[MXS-1516] existing connection don't change routing, even if master switched Created: 2017-11-09  Updated: 2020-08-25  Resolved: 2018-01-02

Status: Closed
Project: MariaDB MaxScale
Component/s: readconnroute
Affects Version/s: 2.0
Fix Version/s: 2.1.13

Type: Bug Priority: Major
Reporter: Richard Stracke Assignee: markus makela
Resolution: Fixed Votes: 0
Labels: replication


 Description   

Config:
router = readconroute
router_option=master

It seems, that the type check will ony be done on connection time,
it should be done also at runtime.

 info: [readconnroute] Routed [MYSQL_COM_QUERY] to 'DB3': select count(*) from table
: Server changed state: DB3[192.168.0.3:3306]: new_slave. [Master, Running] -> [Slave, Running]
 error : [mysqlmon] No Master can be determined. Last known was 192.168.0.3:3306
 
info : [readconnroute] Routed [MYSQL_COM_QUERY] to 'DB3': select count(*) from table
 info : [readconnroute] Routed [MYSQL_COM_QUERY] to 'DB3': select count(*) from table
 info : [readconnroute] Routed [MYSQL_COM_QUERY] to 'DB3': select count(*) from table
 info : [readconnroute] Routed [MYSQL_COM_QUERY] to 'DB3': select count(*) from table
 notice : Server changed state: DB1[192.168.0.3:3306]: new_master. [Master, Slave, Running] -> [Master, Running]
 notice : [mysqlmon] A Master Server is now available: 192.168.0.3:3306
 info : [readconnroute] Routed [MYSQL_COM_QUERY] to 'DB3': select count(*) from table
 info : [readconnroute] Routed [MYSQL_COM_QUERY] to 'DB3': select count(*) from table
 info : [readconnroute] Routed [MYSQL_COM_QUERY] to 'DB3': select count(*) from table


Generated at Thu Feb 08 04:07:20 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.