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

KILL QUERY maintains nodes data consistency but breaks GTID sequence

    XMLWordPrintable

Details

    Description

      GTID sequence drifts between Write node and appliers node by issueing some KILL QUERY statements on a Galera node which is operating user's transactions.
      Data consistency is maintained and wsrep_last_committed is in sync.

      NOTE: It's not always sufficient to issue one single KILL QUERY, I should do more fine grained research to determine what are the specific circumstances, in my current tests I reproduced it by killing some random mysqlslap queries.

      GTID sequence de-alignment breaks among others maxscale auto-failover.
      To make things more complicated in the current attached pictures test Writer is behind but in other tests Writer went ahead(see attached txt for 2nd test)

      Attachments

        Issue Links

          Activity

            People

              janlindstrom Jan Lindström
              claudio.nanni Claudio Nanni
              Votes:
              0 Vote for this issue
              Watchers:
              5 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.