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

Setting wsrep_slave_threads causes thread hang

Details

    Description

      SET GLOBAL wsrep_cluster_address=AUTO;
      SET GLOBAL wsrep_slave_threads=12;
      

      Leads to a thread hang. Another connection will show the hanging statement:

      11.0.1 b075191ba8598af6aff5549e6e19f6255aef258a (Optimized)

      11.0.1-opt>SHOW PROCESSLIST;
      +----+------+-----------+------+---------+------+----------+-----------------------------------+----------+
      | Id | User | Host      | db   | Command | Time | State    | Info                              | Progress |
      +----+------+-----------+------+---------+------+----------+-----------------------------------+----------+
      |  4 | root | localhost | test | Query   | 7972 | NULL     | SET GLOBAL wsrep_slave_threads=12 |    0.000 |
      |  5 | root | localhost | test | Query   |    0 | starting | SHOW PROCESSLIST                  |    0.000 |
      +----+------+-----------+------+---------+------+----------+-----------------------------------+----------+
      2 rows in set (0.000 sec)
      

      Attachments

        Issue Links

          Activity

            Could this be the cause for MDEV-27689?

            Roel Roel Van de Paar added a comment - Could this be the cause for MDEV-27689 ?
            Roel Roel Van de Paar added a comment - - edited

            A build from 22/10/22 (10.11, 50c5743adc87e1cdec1431a02558f6540fe5a6d5) hangs also.
            However, a build from 22/09/22 (10.11, 49cee4e21a8e3cc0eccff3a6f9e493247344e24f) does not.
            And another build from 11/10/22 (10.7, b6ebadaa66ee68b1880c0e10669543d1ba058c18) also doesn't.

            As such, the issue seems to have been introduced between the 11th and 22nd of October 2022.

            It is a regression, but not recent.

            Roel Roel Van de Paar added a comment - - edited A build from 22/10/22 (10.11, 50c5743adc87e1cdec1431a02558f6540fe5a6d5) hangs also. However, a build from 22/09/22 (10.11, 49cee4e21a8e3cc0eccff3a6f9e493247344e24f) does not. And another build from 11/10/22 (10.7, b6ebadaa66ee68b1880c0e10669543d1ba058c18) also doesn't. As such, the issue seems to have been introduced between the 11th and 22nd of October 2022. It is a regression, but not recent.
            janlindstrom Jan Lindström added a comment - https://github.com/MariaDB/server/pull/3205
            Roel Roel Van de Paar added a comment - - edited

            Same result for (please also test):

            SET GLOBAL wsrep_cluster_address=ON;
            SET GLOBAL wsrep_slave_threads=0;
            

            And

            SET GLOBAL wsrep_cluster_address='a';
            SET GLOBAL wsrep_slave_threads=2;
            

            Roel Roel Van de Paar added a comment - - edited Same result for (please also test): SET GLOBAL wsrep_cluster_address= ON ; SET GLOBAL wsrep_slave_threads=0; And SET GLOBAL wsrep_cluster_address= 'a' ; SET GLOBAL wsrep_slave_threads=2;

            sysprg Hi! Is the patch good to be pushed? This affect testing as it causes test trials to hang. Thank you

            Roel Roel Van de Paar added a comment - sysprg Hi! Is the patch good to be pushed? This affect testing as it causes test trials to hang. Thank you

            People

              sysprg Julius Goryavsky
              Roel Roel Van de Paar
              Votes:
              1 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.