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

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 10.5.9, 10.6.0
    • Fix Version/s: 10.5
    • Component/s: Galera, Tests
    • Labels:
      None
    • Environment:
      kvm-rpm-centos8-amd64, kvm-zyp-opensuse150-amd64

      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

              Assignee:
              jplindst Jan Lindström
              Reporter:
              stepan.patryshev Stepan Patryshev (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated: