[MXS-1901] Multi continues COM_STMT_SEND_LONG_DATA route to different backends Created: 2018-06-04  Updated: 2019-07-04  Resolved: 2019-07-04

Status: Closed
Project: MariaDB MaxScale
Component/s: readwritesplit
Affects Version/s: None
Fix Version/s: 2.3.10

Type: Bug Priority: Major
Reporter: dapeng huang Assignee: markus makela
Resolution: Fixed Votes: 0
Labels: None


 Description   

stmt = mysql_simple_prepare(mysql, "select ?");

mysql_stmt_send_long_data(stmt, 0, data1, datasize); // send to master

mysql_stmt_send_long_data(stmt, 0, data2, sqlsize); // send to slave

mysql_stmt_execute(stmt);

 Comments   
Comment by markus makela [ 2018-06-21 ]

This is mostly caused by the following assumption the router makes: Long data used to always be a part of prepared statements which also used to be always routed to the master.

My previous assumption was wrong, this works in 2.2 as expected and data is sent to a slave, although not necessarily the same one. This is slightly more complex to solve than originally estimated.

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