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

galera_3nodes.galera_vote_rejoin_mysqldump MTR failed: mysql_shutdown failed

    XMLWordPrintable

Details

    Description

      galera_3nodes.galera_vote_rejoin_mysqldump failed on BB 10.5 CS and BB 10.6 CS: "mysql_shutdown failed".
      It seems to be a sporadic issue.

      [stdio.log|url2log]:

      10.5.9, 8677c14e65f436db00be5aedb1f644fcffc70f7e, kvm-zyp-opensuse150-amd64

      galera_3nodes.galera_vote_rejoin_mysqldump 'innodb' w1 [ fail ]
              Test ended at 2020-12-11 17:06:52
       
      CURRENT_TEST: galera_3nodes.galera_vote_rejoin_mysqldump
      mysqltest: In included file "./include/shutdown_mysqld.inc": 
      included from ./include/restart_mysqld.inc at line 10:
      included from /usr/share/mysql-test/suite/galera_3nodes/t/galera_vote_rejoin_mysqldump.test at line 78:
      At line 50: mysql_shutdown failed
       
      The result from queries just before the failure was:
      < snip >
      expect_Primary
      Primary
      connection node_2;
      SET SESSION wsrep_on=OFF;
      SELECT VARIABLE_VALUE AS expect_Disconnected FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_status';
      expect_Disconnected
      Disconnected
      SET SESSION wsrep_on=ON;
      SELECT VARIABLE_VALUE AS expect_Primary FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_status';
      expect_Primary
      Primary
      connection node_1;
      SHOW CREATE TABLE t1;
      Table	Create Table
      t1	CREATE TABLE `t1` (
        `f1` int(11) DEFAULT NULL
      ) ENGINE=InnoDB DEFAULT CHARSET=latin1
      connection node_2;
      SET SESSION wsrep_on=OFF;
      SET SESSION wsrep_on=ON;
       
      More results from queries before failure can be found in /dev/shm/var/1/log/galera_vote_rejoin_mysqldump.log
       
       - saving '/dev/shm/var/1/log/galera_3nodes.galera_vote_rejoin_mysqldump-innodb/' to '/dev/shm/var/log/galera_3nodes.galera_vote_rejoin_mysqldump-innodb/'
       
      Retrying test galera_3nodes.galera_vote_rejoin_mysqldump, attempt(2/3)...
       
      worker[1] > Restart  - not started
      worker[1] > Restart  - not started
      worker[1] > Restart  - not started
      ***Warnings generated in error logs during shutdown after running tests: galera_3nodes.galera_vote_rejoin_mysqldump
       
      2020-12-11 17:06:48 2 [ERROR] WSREP: Vote 0 (success) on 3a0023f3-3bd3-11eb-827e-fb59270527e2:7 is inconsistent with group. Leaving cluster.
      
      

      Server logs.

      Attachments

        Issue Links

          Activity

            People

              sysprg Julius Goryavsky
              stepan.patryshev Stepan Patryshev (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.