[MDEV-31272] statement rollback causing empty write set replication Created: 2023-05-15  Updated: 2023-12-20  Resolved: 2023-12-20

Status: Closed
Project: MariaDB Server
Component/s: Galera
Affects Version/s: 10.4.32, 10.5.23, 10.6.16
Fix Version/s: 10.4.33, 10.5.24, 10.6.17, 10.11.7, 11.0.5, 11.1.4, 11.2.3

Type: Bug Priority: Major
Reporter: Seppo Jaakola Assignee: Julius Goryavsky
Resolution: Fixed Votes: 2
Labels: None

Issue Links:
Relates
relates to MDEV-30217 Assertion `mode_ == m_local || transa... Closed

 Description   

If statement rollback wipes out all changes of the transaction, it can still happen that in commit processing an empty write set will be replicated.
A simple test to verify:

create table t (I int primary key);
 
insert into t values (1);
 
begin;
 
insert into t values (2),(1);
 
commit;



 Comments   
Comment by Julien Fritsch [ 2023-12-05 ]

Automated message:
----------------------------
Since this issue has not been updated since 6 weeks, it's time to move it back to Stalled.

Comment by JiraAutomate [ 2023-12-05 ]

Automated message:
----------------------------
Since this issue has not been updated since 6 weeks, it's time to move it back to Stalled.

Comment by Julius Goryavsky [ 2023-12-20 ]

Fix merged with head revision: https://github.com/MariaDB/server/pull/2788/commits/aaaa819c1b6014ab184ceba3529426b456a14172

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