Details
Critical 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.
Attachments
Activity
| Field | Original Value | New Value |
|---|---|---|
| Fix Version/s | 10.4 [ 22408 ] | |
| Fix Version/s | 10.5 [ 23123 ] | |
| Fix Version/s | 10.6 [ 24028 ] |
| Fix Version/s | 10.4 [ 22408 ] | |
| Fix Version/s | 10.5 [ 23123 ] |
| Assignee | Andrei Elkin [ elkin ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Priority | Major [ 3 ] | Critical [ 2 ] |
| Attachment | my_gdb.batch [ 70694 ] |
| Status | In Progress [ 3 ] | Needs Feedback [ 10501 ] |
| Attachment | rpl_parallel_seq_alter.test [ 70695 ] |
| Attachment | rpl_parallel_seq_alter.test [ 70695 ] |
| Attachment | rpl_parallel_seq_alter.test [ 70701 ] |
| Attachment | my_gdb.batch [ 70694 ] |
| Attachment | my_gdb.batch [ 70704 ] |
| Attachment | my_gdb-1.batch [ 70720 ] |
| Attachment | my_gdb.batch [ 70704 ] |
| Attachment | my_gdb-1.batch [ 70720 ] |
| Attachment | my_gdb-2.gdb [ 70747 ] |
| Attachment | my_gdb-3.txt [ 70751 ] |
| Attachment | my_gdb-3.txt [ 70751 ] |
| Attachment | my_gdb-3.txt [ 70754 ] |
| Attachment | my_gdb-4.txt [ 70802 ] |
| Attachment | my_gdb-5.txt [ 70809 ] |
| Fix Version/s | N/A [ 14700 ] | |
| Fix Version/s | 10.6 [ 24028 ] | |
| Resolution | Incomplete [ 4 ] | |
| Status | Needs Feedback [ 10501 ] | Closed [ 6 ] |
| Resolution | Incomplete [ 4 ] | |
| Status | Closed [ 6 ] | Stalled [ 10000 ] |
| Assignee | Andrei Elkin [ elkin ] | Brandon Nesterenko [ JIRAUSER48702 ] |
| Status | Stalled [ 10000 ] | In Review [ 10002 ] |
| Link | This issue blocks TODO-4054 [ TODO-4054 ] |
| Assignee | Brandon Nesterenko [ JIRAUSER48702 ] | Andrei Elkin [ elkin ] |
| Status | In Review [ 10002 ] | Stalled [ 10000 ] |
| Fix Version/s | 10.4.31 [ 29010 ] | |
| Fix Version/s | 10.5.22 [ 29011 ] | |
| Fix Version/s | 10.6.15 [ 29013 ] | |
| Fix Version/s | 10.9.8 [ 29015 ] | |
| Fix Version/s | 10.10.6 [ 29017 ] | |
| Fix Version/s | 10.11.5 [ 29019 ] | |
| Fix Version/s | 11.0.3 [ 28920 ] | |
| Fix Version/s | 11.1.2 [ 28921 ] | |
| Fix Version/s | 10.8.8 [ 28518 ] | |
| Fix Version/s | N/A [ 14700 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | Stalled [ 10000 ] | Closed [ 6 ] |
| Description |
Customer is still facing this issue.
{code:java} 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 {code} Earlier bug: https://jira.mariadb.org/browse/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. |
Customer is still facing this issue.
{code:java} 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 {code} Earlier bug: 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. |
| Attachment | Screenshot 2023-09-07 at 5.34.55 PM.png [ 71885 ] |
| Zendesk Related Tickets | 109716 |
A gdb script and an mtr test are attached to facilitate to the bug analysis and reproduction.