[MDEV-29467] Galera remote node encounter "Inconsistency detected" error when CTAS DDL with transaction fragment Created: 2022-09-05  Updated: 2022-10-22

Status: Open
Project: MariaDB Server
Component/s: Galera
Affects Version/s: 10.6
Fix Version/s: 10.6

Type: Bug Priority: Major
Reporter: William Wong Assignee: Seppo Jaakola
Resolution: Unresolved Votes: 0
Labels: None
Environment:

redhat 7 on vmware

Attachments: Text File galera-transation-fragment-ctas-ddl-inconsistent.mysqld.node2.log     Text File galera-transation-fragment-ctas-ddl-inconsistent.txt    

 Description   

Hi,

We encountered node inconsistency issue in one of our Galera cluster. After checking, the problem is related to CTAS "Create Table As Select" DDL. We have Galera transaction fragment in the case.

A simple test case is prepared and no issue when transaction fragment is disabled.

We need transaction fragment enabled since vendor application need to run a large transaction (>2GB).

Test case is attached: galera-transation-fragment-ctas-ddl-inconsistent.txt

DB error log about the inconsistency: galera-transation-fragment-ctas-ddl-inconsistent.mysqld.node2.log
Generated at Thu Feb 08 10:08:49 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.