[MXS-4615] Partially executed multi-result queries are not treated as partial results Created: 2023-05-12  Updated: 2023-05-17  Resolved: 2023-05-17

Status: Closed
Project: MariaDB MaxScale
Component/s: readwritesplit
Affects Version/s: 2.5.25, 6.4.6, 22.08.5, 23.02.1
Fix Version/s: 2.5.26, 6.4.7, 22.08.6, 23.02.2

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


 Description   

Given the following query:

BEGIN NOT ATOMIC
  SELECT SLEEP(1);
  SELECT SLEEP(2);
  SELECT SLEEP(3);
END;

If the server on which the query is being executed is killed after the first SELECT has returned its result but the second query has not returned any parts of its result, the fact that a statement was partially executed is not detected.

In debug builds this manifests as a debug assertion inside RWSplitSession::retry_master_query but in release builds this causes an extra error to be written to the client that it does not expect.


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