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

WSREP_LAST_WRITTEN_GTID returns incorrect result

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.5.12
    • 10.5
    • Galera
    • None
    • Galera cluster consisting of 3 nodes running MariaDB 10.5.12 on Debian Buster

    Description

      Querying "SELECT WSREP_LAST_WRITTEN_GTID()" at the same time with different connections on one single node yields different results.

      The GTIDs returned are way of from each other:
      Connection 1: 0-1-3311413119
      Connection 2: 0-1-3311399223
      Connection 3: 0-1-3311430041
      Connection 4: 0-1-3311374352

      Lowest GTID returned was from about 10 minutes before.

      Even 15 minutes later WSREP_LAST_WRITTEN_GTID returned the GTID 0-1-3311401500 on a fresh new connection with one single write, which is still way lower then those from earlier.

      To reproduce:
      1. Create 2 or more connections
      2. Run a simple write query
      3. SELECT WSREP_LAST_WRITTEN_GTID()
      4. Compare the results

      Expected behaviour should be a steady increasing GTID.

      Attachments

        Activity

          People

            seppo Seppo Jaakola
            s.hunger@artworked.de Steve Hunger
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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