[MXS-1328] Strange behavior with routes between master / slaves Created: 2017-07-26  Updated: 2020-12-08  Resolved: 2017-07-27

Status: Closed
Project: MariaDB MaxScale
Component/s: qc_sqlite
Affects Version/s: 2.1.3
Fix Version/s: 2.1.5

Type: Bug Priority: Major
Reporter: Igor V. Lovalev Assignee: Johan Wikman
Resolution: Fixed Votes: 0
Labels: replication
Environment:

centos6 x86_64


 Description   

Hi there!
I have maxscale 2.1.3 and 3 percona56 servers with master/slave replica. When i connect to my maxscale and make a sql select request - i see strange behavior from my maxscale.
For example, if i make 

SELECT @@server_id

maxscale ALWAYS return 13 - this is id of my percona slave server - that's ok, all correct.
BUT if i make any request with 

REGEXP SELECT her FROM (SELECT @@server_id as her) as t WHERE her REGEXP '.*'

i ALWAYS get 12 - this is my master ID.
In other words, SQL REGEXP in my any requests affecting routes between slaves and master. Why this happens? How to avoid this?

 Comments   
Comment by Johan Wikman [ 2017-07-27 ]

The problem is that regexp functions were not listed among the builtin read-only functions, with the effect of any statement using a regexp function being routed to master.

Comment by Johan Wikman [ 2017-07-27 ]

Regexp functions are now listed among the builtin read-only ones.

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