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

Cluster fails: Downstream hosts crashing, leaving the surviving host in a non-Primary cluster

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 10.4.17
    • N/A
    • Galera
    • None
    • CentOS release 6.10 (Final)
      MariaDB-server-10.4.17-1.el6.x86_64
      galera-4-26.4.6-1.el6.x86_64

    Description

      Our application deletes old records from 2 tables, which have a foreign key shared between them. The queries apparently run in succession on our primary host, but deadlock on the down stream servers. The downstreams crash, leave the cluster such that the remaining host starts looping, trying to reconnect. The survivor downgrades to non-Cluster, so it is useless to our applications until it is rebooted. Restarting the downstreams is arduous – SST fails, and have to be recovered manually (only to fail again at 02:00 the next night, when the deletes are repeated).

      I've attached the mysql-error.log from one of the downstream hosts, which reflects what happens on each of them, and survivor-mysql-error , which shows how our primary host logs the events.

      Attachments

        Activity

          People

            jplindst Jan Lindström (Inactive)
            khoov Kent Hoover
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.