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

Galera remote node encounter "Inconsistency detected" error when CTAS DDL with transaction fragment

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 10.6
    • Fix Version/s: 10.6
    • Component/s: Galera
    • Labels:
      None
    • Environment:
      redhat 7 on vmware

      Description

      Hi,

      We encountered node inconsistency issue in one of our Galera cluster. After checking, the problem is related to CTAS "Create Table As Select" DDL. We have Galera transaction fragment in the case.

      A simple test case is prepared and no issue when transaction fragment is disabled.

      We need transaction fragment enabled since vendor application need to run a large transaction (>2GB).

      Test case is attached: galera-transation-fragment-ctas-ddl-inconsistent.txt

      DB error log about the inconsistency: galera-transation-fragment-ctas-ddl-inconsistent.mysqld.node2.log

        Attachments

          Activity

            People

            Assignee:
            seppo Seppo Jaakola
            Reporter:
            frelist William Wong
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.