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

Galera node shutdown fails in non-Primary

Details

    Description

      Galera node refuses to shut down when in non-Primary. Reproducible with the following MTR test:

      --source include/galera_cluster.inc
      --source include/have_innodb.inc
       
      --let $node_1 = node_1
      --let $node_2 = node_2
      --source include/auto_increment_offset_save.inc
       
      --connection node_1
      # Set higher weight for node_1 to keep it in primary
      # while node_2 is isolated.
      SET GLOBAL wsrep_provider_options = 'pc.weight=2';
       
      --connection node_2
      # Isolate node_2 from the group and wait until wsrep_ready becomes OFF.
      SET GLOBAL wsrep_provider_options = 'gmcast.isolate = 1';
      SET SESSION wsrep_sync_wait = 0;
      --let $wait_condition = SELECT VARIABLE_VALUE = 'OFF' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready'
      --source include/wait_condition.inc
       
      # Verify that graceful shutdown succeeds.
      --source include/shutdown_mysqld.inc
      --source include/start_mysqld.inc
       
      --let $wait_condition = SELECT VARIABLE_VALUE = 2 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
      --source include/wait_condition.inc
       
      --connection node_1
      --source include/wait_condition.inc
       
      # Restore original settings.
      SET GLOBAL wsrep_provider_options = 'pc.weight = 1';
      --source include/auto_increment_offset_restore.inc
      

      The test fails with

      CURRENT_TEST: galera.galera_shutdown_nonprim
      mysqltest: In included file "/home/teemu/work/git/mariadb-server/mysql-test/suite/galera/include/shutdown_mysqld.inc": 
      included from /home/teemu/work/git/mariadb-server/mysql-test/suite/galera/t/galera_shutdown_nonprim.test at line 26:
      At line 16: mysql_shutdown failed
      

      Attachments

        Activity

          teemu.ollakka Teemu Ollakka created issue -
          teemu.ollakka Teemu Ollakka made changes -
          Field Original Value New Value
          Affects Version/s 10.3.17 [ 23411 ]
          teemu.ollakka Teemu Ollakka made changes -
          Summary Galera node shutdown fail in non-Primary Galera node shutdown fails in non-Primary
          teemu.ollakka Teemu Ollakka made changes -
          Affects Version/s 10.4.7 [ 23720 ]
          elenst Elena Stepanova made changes -
          Component/s Galera [ 10124 ]
          Fix Version/s 10.2 [ 14601 ]
          Fix Version/s 10.3 [ 22126 ]
          Fix Version/s 10.4 [ 22408 ]
          Assignee Jan Lindström [ jplindst ]
          jplindst Jan Lindström (Inactive) made changes -
          issue.field.resolutiondate 2019-09-13 06:18:53.0 2019-09-13 06:18:53.689
          jplindst Jan Lindström (Inactive) made changes -
          Fix Version/s 10.2.28 [ 23910 ]
          Fix Version/s 10.3.19 [ 23908 ]
          Fix Version/s 10.4.9 [ 23906 ]
          Fix Version/s 10.2 [ 14601 ]
          Fix Version/s 10.3 [ 22126 ]
          Fix Version/s 10.4 [ 22408 ]
          Resolution Fixed [ 1 ]
          Status Open [ 1 ] Closed [ 6 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 99584 ] MariaDB v4 [ 156727 ]

          People

            jplindst Jan Lindström (Inactive)
            teemu.ollakka Teemu Ollakka
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.