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

Altering a table with more rows than wsrep_max_ws_rows causes cluster to break when running Galera cluster in TOI mode

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.1.20
    • 10.1.22
    • Galera
    • Ubuntu Trusty. Galera 25.3.17
    • 10.2.4-1, 10.2.4-2

    Description

      Reproduce steps:
      1. Create a 3 node galera cluster
      2. Set wsrep_max_ws_rows to a non-zero value
      3. Create a table with more than wsrep_max_ws_rows in it
      4. Perform an alter table statement on that table. It will get rejected with:
      ERROR 1180 (HY000): wsrep_max_ws_rows exceeded done
      5. The node you were connected to will still have the old table schema, but the other nodes have successfully applied the alter table changes.

      At that point any data written to that table will cause the other nodes to terminate due to inconsistency.

      Codership was able to verify the issue, but say it is a MariaDB specific bug:
      https://groups.google.com/forum/#!topic/codership-team/TDscBC_oAk4

      Attachments

        Issue Links

          Activity

            People

              nirbhay_c Nirbhay Choubey (Inactive)
              jpalermo Joseph Palermo
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.