Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-27927

row_sel_try_search_shortcut_for_mysql() does not latch a page, violating read view isolation

    XMLWordPrintable

Details

    Description

      We have been testing Galera-MariaDB on data consistency models. We (together with the Galera contributor) found REPEATABLE READ anomalies with Galera disabled. Hence, there might be something wrong with MariaDB. We used the default REPEATABLE READ isolation in our testing.

      The collected data (or histories of transaction executions):
      https://gist.github.com/sciascid/aae12c130bdcfe1930601f19ce0f29d5/archive/6b214d707fdf0fb72b2505955c0e23d38717db6d.zip

      The specific anomaly was shown at https://github.com/codership/galera/issues/609#issuecomment-1036096287 Also see the table attached.

      Notation: w/r(key, value, client_id, txn_id); operations of a txn (denoted by a column) are listed from top down.

      Anomaly: txn393 read value 3328 on key 0 (red cell, column 1) in between the reads of value 33324 on key 0 (yellow cells).

      Setup: 3 server nodes and 3 client nodes. Galera Version: 26.4.9. MariaDB Version: 10.4.22.

      Attachments

        Issue Links

          Activity

            People

              vlad.lesin Vladislav Lesin
              nobiplusplus Si Liu
              Votes:
              0 Vote for this issue
              Watchers:
              9 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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