[MDEV-31833] replication breaks when using optimistic replication and replica is a galera node - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Critical
Resolution: Fixed
Affects Version/s: None
Fix Version/s: 10.5.23, 10.6.16, 10.10.7, 10.11.6, 11.0.4, 11.1.3
Component/s: Galera, Replication
Labels:
- triage

Description

When a galera node is a replica of an upstream cluster it is impossible to enable optimistic replication, because the expected conflicts that stem from this replication mode will cause galera code to immediately abort replication.

2023-05-17 13:57:20 6930586 [Note] WSREP: ha_rollback_trans(6930586) rolled back: Deadlock found when trying to get lock; try restarting transaction; is_real 0

2023-05-17 13:57:20 6930586 [Note] WSREP: ha_rollback_trans(6930586) rolled back: Deadlock found when trying to get lock; try restarting transaction; is_real 1

2023-05-17 13:57:20 6930586 [Note] WSREP: SQL apply failed, res 149 conflict state: aborted

2023-05-17 13:57:20 6930586 [ERROR] Slave SQL: Node has dropped from cluster, Gtid 0-8174-126467367555, Internal MariaDB error code: 1047

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

master1_n1.cnf
1 kB
2023-05-25 07:22
master1_n2.cnf
1 kB
2023-05-25 07:22
master2_n1.cnf
1 kB
2023-05-25 07:22
master2_n2.cnf
1 kB
2023-05-25 07:22
transactions.yy
4 kB
2023-05-25 07:22
transactions.zz
1.0 kB
2023-05-25 07:22

Issue Links

relates to

MDEV-10962 Deadlock with 3 concurrent DELETEs by unique key

Closed

Activity

People

Assignee:: Julius Goryavsky

Reporter:: Rick Pizzi

Votes:: 7 Vote for this issue

Watchers:: 15 Start watching this issue

Dates

Created:: 2023-05-17 08:16

Updated:: 2023-09-28 08:10

Resolved:: 2023-09-12 11:46

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.