Uploaded image for project: 'Percona XtraDB Cluster'
  1. Percona XtraDB Cluster
  2. PXC-2592

PXC restarting automatically on data inconsistency

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: High
    • Resolution: Fixed
    • Affects Version/s: 5.7.x, Not 5.6.x
    • Fix Version/s: 5.7.27-31.39
    • Component/s: None
    • Labels:
      None

      Description

      PXC is automatically starting after it shutdown itself due to data inconsistency

       

      How to reproduce:

      Node1:

      mysql -psekret -e "CREATE DATABASE IF NOT EXISTS test; CREATE TABLE test.tb (ID INT PRIMARY KEY); INSERT INTO test.tb VALUES (1)" 

      Node2:

      mysql -psekret -e "set sql_log_bin=off; DELETE FROM test.tb WHERE ID = 1" 

      Node1:

       mysql -psekret -e "DELETE FROM test.tb WHERE ID = 1"

       

      MySQL will stop and mysqld_safe will start the cluster.

       

      This issue doesn't happens on 5.6

        Smart Checklist

          Attachments

            Issue Links

              Activity

                People

                Assignee:
                evgeniy.patlan Evgeniy Patlan
                Reporter:
                marcelo.altmann Marcelo Altmann
                Votes:
                1 Vote for this issue
                Watchers:
                4 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved:

                    Time Tracking

                    Estimated:
                    Original Estimate - Not Specified
                    Not Specified
                    Remaining:
                    Remaining Estimate - Not Specified
                    Not Specified
                    Logged:
                    Time Spent - 1 day, 2 hours, 55 minutes
                    1d 2h 55m