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

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.6
    • 10.6
    • Galera
    • None
    • 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

            seppo Seppo Jaakola
            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.