[MDEV-31503] ALTER SEQUENCE ends up in optimistic parallel slave binlog out-of-order Created: 2023-06-20  Updated: 2023-09-08  Resolved: 2023-07-14

Status: Closed
Project: MariaDB Server
Component/s: Replication
Affects Version/s: 10.6.12
Fix Version/s: 10.8.8, 10.4.31, 10.5.22, 10.6.15, 10.9.8, 10.10.6, 10.11.5, 11.0.3, 11.1.2

Type: Bug Priority: Critical
Reporter: Susmeet Khaire Assignee: Andrei Elkin
Resolution: Fixed Votes: 2
Labels: None

Attachments: PNG File Screenshot 2023-09-07 at 5.34.55 PM.png     File my_gdb-2.gdb     Text File my_gdb-3.txt     Text File my_gdb-4.txt     Text File my_gdb-5.txt     File rpl_parallel_seq_alter.test    
Issue Links:
Blocks

 Description   

Customer is still facing this issue.

2023-06-01  0:00:00 9 [ERROR] Slave SQL: Error 'An attempt was made to binlog GTID 1-1-213122284 which would create an out-of-order sequence number with existing GTID 1-1-213122286, and gtid strict mode is enabled' on query. Default database: 'xxxx'. Query: 'Alter Sequence seq_xxxx Restart With 1', Gtid 1-1-213122284, Internal MariaDB error code: 1950
 
2023-06-01  0:00:00 9 [Warning] Slave: An attempt was made to binlog GTID 1-1-213122284 which would create an out-of-order sequence number with existing GTID 1-1-213122286, and gtid strict mode is enabled Error_code: 1950
 
2023-06-01  0:00:00 10 [ERROR] Slave (additional info): Commit failed due to failure of an earlier commit on which this one depends Error_code: 1964

Earlier bug: MDEV-31077

This bug was supposed to be fixed in the intermediate MariaDB ES release 10.6.12-8.
But seems like the customer is still facing the issue.



 Comments   
Comment by Andrei Elkin [ 2023-06-23 ]

A gdb script and an mtr test are attached to facilitate to the bug analysis and reproduction.

Comment by Andrei Elkin [ 2023-07-05 ]

(closed by mistake)

Comment by Andrei Elkin [ 2023-07-05 ]

The patch is in bb-10.4-andrei.

Comment by Brandon Nesterenko [ 2023-07-07 ]

Reviewed and discussed over Zoom

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