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

WSREP_LAST_WRITTEN_GTID returns incorrect result

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 10.5.12
    • Fix Version/s: None
    • Component/s: Galera
    • Labels:
      None
    • Environment:
      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

            Assignee:
            Unassigned Unassigned
            Reporter:
            s.hunger@artworked.de Steve Hunger
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:

                Git Integration