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

          Activity

            People

            Assignee:
            vlad.lesin Vladislav Lesin
            Reporter:
            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.