[MDEV-24327] wsrep XID checkpointing order compromised in multi-master work loads - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.5.8, 10.4(EOL)
Fix Version/s: 10.2.37, 10.3.28, 10.4.18, 10.5.9, 10.6.0
Component/s: Galera
Labels:
None

Description

wsrep XID is checkpointed in innodb rollback segment during transaction commit, and this checkpointing is supposed to happen in strict GTID sequence order.

While troubleshooting ~~MDEV-23851~~ under highly conflicting multi-master work loads, it was observed that Xid checkpointing order can be violated in two scenarios:

if MariaDB is configured with binlogging enabled but with log_slave_updates = OFF, fairly frequent Xid checkpoint ordering violating happens
write sets, which failed in certification can perform Xid checkpointing too early in receiving nodes

These Xid checkpointing failures do not cause the issue with ~~MDEV-23851~~, but they make troubleshooting ~~MDEV-23851~~ harder by hiding the underlying issue

Attachments

Activity

People

Assignee:: Jan Lindström (Inactive)

Reporter:: Seppo Jaakola

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 2020-12-01 21:14

Updated:: 2021-06-03 09:26

Resolved:: 2020-12-17 10:49

Git Integration

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