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

            ramesh Ramesh Sivaraman created issue -
            ramesh Ramesh Sivaraman made changes -
            Field Original Value New Value
            ramesh Ramesh Sivaraman made changes -
            ramesh Ramesh Sivaraman made changes -
            ramesh Ramesh Sivaraman made changes -
            Component/s Galera [ 10124 ]
            ramesh Ramesh Sivaraman made changes -
            Description *[stdio.log|http://buildbot.askmonty.org/buildbot/builders/kvm-deb-bionic-ppc64le/builds/6451/steps/mtr-galera/logs/stdio|http://example.com]*
            {code:title=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
            {code}
            *[stdio.log|http://buildbot.askmonty.org/buildbot/builders/kvm-deb-bionic-ppc64le/builds/6451/steps/mtr-galera/logs/stdio]*
            {code:title=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
            {code}
            jplindst Jan Lindström (Inactive) made changes -
            Assignee Jan Lindström [ jplindst ] Julius Goryavsky [ sysprg ]
            sysprg Julius Goryavsky made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 124644 ] MariaDB v4 [ 144611 ]
            sysprg Julius Goryavsky made changes -
            Status In Progress [ 3 ] Stalled [ 10000 ]

            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 made changes -
            sysprg Julius Goryavsky made changes -
            sysprg Julius Goryavsky made changes -
            Status Stalled [ 10000 ] In Progress [ 3 ]
            sysprg Julius Goryavsky made changes -
            Affects Version/s 10.4.33 [ 29516 ]
            sysprg Julius Goryavsky added a comment - Fixed merged with head revision: https://github.com/MariaDB/server/commit/c71dc395292f41685530c0fa92c5ce4d78eabfa0
            sysprg Julius Goryavsky made changes -
            Fix Version/s 10.4.34 [ 29625 ]
            Fix Version/s 10.6 [ 24028 ]
            Resolution Fixed [ 1 ]
            Status In Progress [ 3 ] Closed [ 6 ]
            JIraAutomate JiraAutomate made changes -
            Fix Version/s 10.5.25 [ 29626 ]
            Fix Version/s 10.6.18 [ 29627 ]
            Fix Version/s 10.11.8 [ 29630 ]
            Fix Version/s 11.0.6 [ 29628 ]
            Fix Version/s 11.1.5 [ 29629 ]
            Fix Version/s 11.2.4 [ 29631 ]
            JIraAutomate JiraAutomate made changes -

            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.