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

galera_3nodes.galera_ipv6_mysqldump MTR failed: mysql_shutdown failed

Details

    Description

      stdio.log

      10.6.5 7271cf48d62196abc0c578d00ab3ca09b56aae77

      galera_3nodes.galera_ipv6_mysqldump 'innodb' w1 [ fail ]
              Test ended at 2021-08-29 06:12:51
       
      CURRENT_TEST: galera_3nodes.galera_ipv6_mysqldump
      mysqltest: In included file "./include/shutdown_mysqld.inc": 
      included from ./include/restart_mysqld.inc at line 10:
      included from /usr/share/mysql/mysql-test/suite/galera_3nodes/t/galera_ipv6_mysqldump.test at line 85:
      At line 50: mysql_shutdown failed
      

      Attachments

        Issue Links

          Activity

            I found an issue and a test case that causes mysql_shutdown in mysqltest client to fail as described in this ticket.
            The MTR test to reproduce:

            --source include/galera_cluster.inc                      
            --source include/have_debug_sync.inc                     
                                                                     
            --let $node_1=node_1                                     
            --let $node_2=node_2                                     
            --source include/auto_increment_offset_save.inc          
                                                                     
            --connection node_2                                      
            SET GLOBAL debug_dbug="+d,simulate_shutdown_client_slow";
            --source include/restart_mysqld.inc                      
                                                                     
            --source include/auto_increment_offset_restore.inc       
            

            and this DBUG_EXECUTE_IF in sql_parse.cc:

            diff --git a/sql/sql_parse.cc b/sql/sql_parse.cc
            index 0261e7480f1..71d228f3338 100644
            --- a/sql/sql_parse.cc
            +++ b/sql/sql_parse.cc
            @@ -2206,6 +2206,7 @@ bool dispatch_command(enum enum_server_command command, THD *thd,
                 my_eof(thd);
                 kill_mysql(thd);
                 error=TRUE;
            +    DBUG_EXECUTE_IF("simulate_shutdown_client_slow", my_sleep(1000000););
                 break;
               }
             #endif
            

            I tested this in 10.4, but I presume it's the same issue. I could take this ticket over, since it is stalled and I have a tentative fix.

            sciascid Daniele Sciascia added a comment - I found an issue and a test case that causes mysql_shutdown in mysqltest client to fail as described in this ticket. The MTR test to reproduce: --source include/galera_cluster.inc --source include/have_debug_sync.inc --let $node_1=node_1 --let $node_2=node_2 --source include/auto_increment_offset_save.inc --connection node_2 SET GLOBAL debug_dbug="+d,simulate_shutdown_client_slow"; --source include/restart_mysqld.inc --source include/auto_increment_offset_restore.inc and this DBUG_EXECUTE_IF in sql_parse.cc: diff --git a/sql/sql_parse.cc b/sql/sql_parse.cc index 0261e7480f1..71d228f3338 100644 --- a/sql/sql_parse.cc +++ b/sql/sql_parse.cc @@ -2206,6 +2206,7 @@ bool dispatch_command(enum enum_server_command command, THD *thd, my_eof(thd); kill_mysql(thd); error=TRUE; + DBUG_EXECUTE_IF("simulate_shutdown_client_slow", my_sleep(1000000);); break; } #endif I tested this in 10.4, but I presume it's the same issue. I could take this ticket over, since it is stalled and I have a tentative fix.
            sysprg Julius Goryavsky added a comment - Fixed merged with head revision: https://github.com/MariaDB/server/commit/c71dc395292f41685530c0fa92c5ce4d78eabfa0

            People

              sysprg Julius Goryavsky
              ramesh Ramesh Sivaraman
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.