[MXS-2816] Better handling for master's response (0xff) to COM_STMT_PREPARE Created: 2019-12-20  Updated: 2020-03-13  Resolved: 2020-02-28

Status: Closed
Project: MariaDB MaxScale
Component/s: galeramon, readwritesplit
Affects Version/s: 2.3.12
Fix Version/s: 2.5.0

Type: New Feature Priority: Major
Reporter: Valerii Kravchuk Assignee: markus makela
Resolution: Fixed Votes: 0
Labels: logging


 Description   

When prepared statements are routed to both master and slave by readwritesplit router, in some cases we may get warnings like this:

2019-12-18 14:07:33 warning: (62418270) Slave server 'db2': response (0x00) differs from master's response (0xff) to COM_STMT_PREPARE: `SELECT ... FROM ... WHERE (`t1`.`c1` = ?) AND ...)`. Closing slave connection due to inconsistent session state.

I suspect it may be cause by the need to re-prepare the query on master when/if ALTER was executed there.

In any case, better logging for the reasons of response 0xff from master would help.


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