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

runtime adjustment of wsrep_slave_threads creates threads but never removes them

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 5.5.37-galera
    • Fix Version/s: 5.5.38-galera, 10.0.12-galera
    • Component/s: None
    • Labels:
    • Environment:
      Ubuntu 12.04.4 LTS (GNU/Linux 2.6.32-28-server x86_64)

      Description

      select @@wsrep_slave_threads

      64

      MariaDB [(none)]> set global wsrep_slave_threads=1;  
      Query OK, 0 rows affected (0.00 sec)
       
      MariaDB [(none)]> show processlist;
      | Id   | User        | Host      | db   | Command | Time    | State              | Info             | Progress |
      |    4 | system user |           | NULL | Sleep   | 2443658 | wsrep aborter idle | NULL             |    0.000 |
      |    5 | system user |           | NULL | Sleep   |     164 | committed 13294138 | NULL             |    0.000 |
      |    6 | system user |           | NULL | Sleep   |     213 | committed 13294127 | NULL             |    0.000 |
      |    7 | system user |           | NULL | Sleep   |     119 | committed 13294154 | NULL             |    0.000 |
      |    8 | system user |           | NULL | Sleep   |     213 | committed 13294122 | NULL             |    0.000 |
      |    9 | system user |           | NULL | Sleep   |      65 | committed 13294165 | NULL             |    0.000 |
      |   10 | system user |           | NULL | Sleep   |      68 | committed 13294162 | NULL             |    0.000 |
      |   11 | system user |           | NULL | Sleep   |     213 | committed 13294121 | NULL             |    0.000 |
      |   12 | system user |           | NULL | Sleep   |     214 | committed 13294111 | NULL             |    0.000 |
      |   13 | system user |           | NULL | Sleep   |     213 | committed 13294117 | NULL             |    0.000 |
      |   14 | system user |           | NULL | Sleep   |      77 | committed 13294160 | NULL             |    0.000 |
      |   15 | system user |           | NULL | Sleep   |      77 | committed 13294156 | NULL             |    0.000 |
      |   16 | system user |           | NULL | Sleep   |     214 | committed 13294114 | NULL             |    0.000 |
      |   17 | system user |           | NULL | Sleep   |     213 | committed 13294120 | NULL             |    0.000 |
      |   18 | system user |           | NULL | Sleep   |      77 | committed 13294157 | NULL             |    0.000 |
      |   19 | system user |           | NULL | Sleep   |     208 | committed 13294129 | NULL             |    0.000 |
      |   20 | system user |           | NULL | Sleep   |     189 | committed 13294133 | NULL             |    0.000 |
      |   21 | system user |           | NULL | Sleep   |     137 | committed 13294142 | NULL             |    0.000 |
      |   22 | system user |           | NULL | Sleep   |      55 | committed 13294170 | NULL             |    0.000 |
      |   23 | system user |           | NULL | Sleep   |      68 | committed 13294163 | NULL             |    0.000 |
      |   24 | system user |           | NULL | Sleep   |     137 | committed 13294140 | NULL             |    0.000 |
      |   25 | system user |           | NULL | Sleep   |     213 | committed 13294118 | NULL             |    0.000 |
      |   26 | system user |           | NULL | Sleep   |     191 | committed 13294131 | NULL             |    0.000 |
      |   27 | system user |           | NULL | Sleep   |     121 | committed 13294151 | NULL             |    0.000 |
      |   28 | system user |           | NULL | Sleep   |      74 | committed 13294161 | NULL             |    0.000 |
      |   29 | system user |           | NULL | Sleep   |     137 | committed 13294143 | NULL             |    0.000 |
      |   30 | system user |           | NULL | Sleep   |     119 | committed 13294153 | NULL             |    0.000 |
      |   31 | system user |           | NULL | Sleep   |     214 | committed 13294115 | NULL             |    0.000 |
      |   32 | system user |           | NULL | Sleep   |     213 | committed 13294125 | NULL             |    0.000 |
      |   33 | system user |           | NULL | Sleep   |     201 | committed 13294130 | NULL             |    0.000 |
      |   34 | system user |           | NULL | Sleep   |     187 | committed 13294135 | NULL             |    0.000 |
      |   35 | system user |           | NULL | Sleep   |     133 | committed 13294150 | NULL             |    0.000 |
      |   36 | system user |           | NULL | Sleep   |     220 | committed 13294108 | NULL             |    0.000 |
      |   37 | system user |           | NULL | Sleep   |     213 | committed 13294128 | NULL             |    0.000 |
      |   38 | system user |           | NULL | Sleep   |     221 | committed 13294107 | NULL             |    0.000 |
      |   39 | system user |           | NULL | Sleep   |     133 | committed 13294146 | NULL             |    0.000 |
      |   40 | system user |           | NULL | Sleep   |     133 | committed 13294148 | NULL             |    0.000 |
      |   41 | system user |           | NULL | Sleep   |     137 | committed 13294141 | NULL             |    0.000 |
      |   42 | system user |           | NULL | Sleep   |     214 | committed 13294113 | NULL             |    0.000 |
      |   43 | system user |           | NULL | Sleep   |      57 | committed 13294169 | NULL             |    0.000 |
      |   44 | system user |           | NULL | Sleep   |     213 | committed 13294126 | NULL             |    0.000 |
      |   45 | system user |           | NULL | Sleep   |     213 | committed 13294123 | NULL             |    0.000 |
      |   46 | system user |           | NULL | Sleep   |      66 | committed 13294164 | NULL             |    0.000 |
      |   47 | system user |           | NULL | Sleep   |     214 | committed 13294112 | NULL             |    0.000 |
      |   48 | system user |           | NULL | Sleep   |     214 | committed 13294110 | NULL             |    0.000 |
      |   49 | system user |           | NULL | Sleep   |     185 | committed 13294137 | NULL             |    0.000 |
      |   50 | system user |           | NULL | Sleep   |     135 | committed 13294145 | NULL             |    0.000 |
      |   51 | system user |           | NULL | Sleep   |      63 | committed 13294166 | NULL             |    0.000 |
      |   52 | system user |           | NULL | Sleep   |     137 | committed 13294139 | NULL             |    0.000 |
      |   53 | system user |           | NULL | Sleep   |      58 | committed 13294168 | NULL             |    0.000 |
      |   54 | system user |           | NULL | Sleep   |     188 | committed 13294134 | NULL             |    0.000 |
      |   55 | system user |           | NULL | Sleep   |     213 | committed 13294124 | NULL             |    0.000 |
      |   56 | system user |           | NULL | Sleep   |     214 | committed 13294109 | NULL             |    0.000 |
      |   57 | system user |           | NULL | Sleep   |     213 | committed 13294116 | NULL             |    0.000 |
      |   58 | system user |           | NULL | Sleep   |     136 | committed 13294144 | NULL             |    0.000 |
      |   59 | system user |           | NULL | Sleep   |     187 | committed 13294136 | NULL             |    0.000 |
      |   60 | system user |           | NULL | Sleep   |     133 | committed 13294149 | NULL             |    0.000 |
      |   61 | system user |           | NULL | Sleep   |      63 | committed 13294167 | NULL             |    0.000 |
      |   62 | system user |           | NULL | Sleep   |     119 | committed 13294152 | NULL             |    0.000 |
      |   63 | system user |           | NULL | Sleep   |     213 | committed 13294119 | NULL             |    0.000 |
      |   64 | system user |           | NULL | Sleep   |      77 | committed 13294158 | NULL             |    0.000 |
      |   65 | system user |           | NULL | Sleep   |     190 | committed 13294132 | NULL             |    0.000 |
      |   66 | system user |           | NULL | Sleep   |      91 | committed 13294155 | NULL             |    0.000 |
      |   67 | system user |           | NULL | Sleep   |     133 | committed 13294147 | NULL             |    0.000 |
      |   68 | system user |           | NULL | Sleep   |      77 | committed 13294159 | NULL             |    0.000 |
      | 9660 | root        | localhost | NULL | Query   |       0 | sleeping           | show processlist |    0.000 |
      +------+-------------+-----------+------+---------+---------+--------------------+------------------+----------+
      66 rows in set (0.04 sec)

      none deleted.

      oh well. lets set back to 64.

      MariaDB [(none)]> set global wsrep_slave_threads=64;
      Query OK, 0 rows affected (0.67 sec)
       
      MariaDB [(none)]> show processlist;                 
      +------+-------------+-----------+------+---------+---------+--------------------+------------------+----------+
      | Id   | User        | Host      | db   | Command | Time    | State              | Info             | Progress |
      +------+-------------+-----------+------+---------+---------+--------------------+------------------+----------+
      |    4 | system user |           | NULL | Sleep   | 2443728 | wsrep aborter idle | NULL             |    0.000 |
      |    5 | system user |           | NULL | Sleep   |     234 | committed 13294138 | NULL             |    0.000 |
      |    6 | system user |           | NULL | Sleep   |     283 | committed 13294127 | NULL             |    0.000 |
      |    7 | system user |           | NULL | Sleep   |     189 | committed 13294154 | NULL             |    0.000 |
      |    8 | system user |           | NULL | Sleep   |     283 | committed 13294122 | NULL             |    0.000 |
      |    9 | system user |           | NULL | Sleep   |     135 | committed 13294165 | NULL             |    0.000 |
      |   10 | system user |           | NULL | Sleep   |     138 | committed 13294162 | NULL             |    0.000 |
      |   11 | system user |           | NULL | Sleep   |     283 | committed 13294121 | NULL             |    0.000 |
      |   13 | system user |           | NULL | Sleep   |     283 | committed 13294117 | NULL             |    0.000 |
      |   14 | system user |           | NULL | Sleep   |     147 | committed 13294160 | NULL             |    0.000 |
      |   15 | system user |           | NULL | Sleep   |     147 | committed 13294156 | NULL             |    0.000 |
      |   17 | system user |           | NULL | Sleep   |     283 | committed 13294120 | NULL             |    0.000 |
      |   18 | system user |           | NULL | Sleep   |     147 | committed 13294157 | NULL             |    0.000 |
      |   19 | system user |           | NULL | Sleep   |     278 | committed 13294129 | NULL             |    0.000 |
      |   20 | system user |           | NULL | Sleep   |     259 | committed 13294133 | NULL             |    0.000 |
      |   21 | system user |           | NULL | Sleep   |     207 | committed 13294142 | NULL             |    0.000 |
      |   22 | system user |           | NULL | Sleep   |     125 | committed 13294170 | NULL             |    0.000 |
      |   23 | system user |           | NULL | Sleep   |     138 | committed 13294163 | NULL             |    0.000 |
      |   24 | system user |           | NULL | Sleep   |     207 | committed 13294140 | NULL             |    0.000 |
      |   25 | system user |           | NULL | Sleep   |     283 | committed 13294118 | NULL             |    0.000 |
      |   26 | system user |           | NULL | Sleep   |     261 | committed 13294131 | NULL             |    0.000 |
      |   27 | system user |           | NULL | Sleep   |     191 | committed 13294151 | NULL             |    0.000 |
      |   28 | system user |           | NULL | Sleep   |     144 | committed 13294161 | NULL             |    0.000 |
      |   29 | system user |           | NULL | Sleep   |     207 | committed 13294143 | NULL             |    0.000 |
      |   30 | system user |           | NULL | Sleep   |     189 | committed 13294153 | NULL             |    0.000 |
      |   32 | system user |           | NULL | Sleep   |     283 | committed 13294125 | NULL             |    0.000 |
      |   33 | system user |           | NULL | Sleep   |     271 | committed 13294130 | NULL             |    0.000 |
      |   34 | system user |           | NULL | Sleep   |     257 | committed 13294135 | NULL             |    0.000 |
      |   35 | system user |           | NULL | Sleep   |     203 | committed 13294150 | NULL             |    0.000 |
      |   37 | system user |           | NULL | Sleep   |     283 | committed 13294128 | NULL             |    0.000 |
      |   39 | system user |           | NULL | Sleep   |     203 | committed 13294146 | NULL             |    0.000 |
      |   40 | system user |           | NULL | Sleep   |     203 | committed 13294148 | NULL             |    0.000 |
      |   41 | system user |           | NULL | Sleep   |     207 | committed 13294141 | NULL             |    0.000 |
      |   43 | system user |           | NULL | Sleep   |     127 | committed 13294169 | NULL             |    0.000 |
      |   44 | system user |           | NULL | Sleep   |     283 | committed 13294126 | NULL             |    0.000 |
      |   45 | system user |           | NULL | Sleep   |     283 | committed 13294123 | NULL             |    0.000 |
      |   46 | system user |           | NULL | Sleep   |     136 | committed 13294164 | NULL             |    0.000 |
      |   49 | system user |           | NULL | Sleep   |     255 | committed 13294137 | NULL             |    0.000 |
      |   50 | system user |           | NULL | Sleep   |     205 | committed 13294145 | NULL             |    0.000 |
      |   51 | system user |           | NULL | Sleep   |     133 | committed 13294166 | NULL             |    0.000 |
      |   52 | system user |           | NULL | Sleep   |     207 | committed 13294139 | NULL             |    0.000 |
      |   53 | system user |           | NULL | Sleep   |     128 | committed 13294168 | NULL             |    0.000 |
      |   54 | system user |           | NULL | Sleep   |     258 | committed 13294134 | NULL             |    0.000 |
      |   55 | system user |           | NULL | Sleep   |     283 | committed 13294124 | NULL             |    0.000 |
      |   57 | system user |           | NULL | Sleep   |     283 | committed 13294116 | NULL             |    0.000 |
      |   58 | system user |           | NULL | Sleep   |     206 | committed 13294144 | NULL             |    0.000 |
      |   59 | system user |           | NULL | Sleep   |     257 | committed 13294136 | NULL             |    0.000 |
      |   60 | system user |           | NULL | Sleep   |     203 | committed 13294149 | NULL             |    0.000 |
      |   61 | system user |           | NULL | Sleep   |     133 | committed 13294167 | NULL             |    0.000 |
      |   62 | system user |           | NULL | Sleep   |     189 | committed 13294152 | NULL             |    0.000 |
      |   63 | system user |           | NULL | Sleep   |     283 | committed 13294119 | NULL             |    0.000 |
      |   64 | system user |           | NULL | Sleep   |     147 | committed 13294158 | NULL             |    0.000 |
      |   65 | system user |           | NULL | Sleep   |     260 | committed 13294132 | NULL             |    0.000 |
      |   66 | system user |           | NULL | Sleep   |     161 | committed 13294155 | NULL             |    0.000 |
      |   67 | system user |           | NULL | Sleep   |     203 | committed 13294147 | NULL             |    0.000 |
      |   68 | system user |           | NULL | Sleep   |     147 | committed 13294159 | NULL             |    0.000 |
      | 9660 | root        | localhost | NULL | Query   |       0 | sleeping           | show processlist |    0.000 |
      | 9670 | system user |           | NULL | Sleep   |       3 | NULL               | NULL             |    0.000 |
      | 9671 | system user |           | NULL | Sleep   |       3 | NULL               | NULL             |    0.000 |
      | 9672 | system user |           | NULL | Sleep   |       3 | NULL               | NULL             |    0.000 |
      | 9673 | system user |           | NULL | Sleep   |       3 | NULL               | NULL             |    0.000 |
      | 9674 | system user |           | NULL | Sleep   |       3 | NULL               | NULL             |    0.000 |
      | 9675 | system user |           | NULL | Sleep   |       3 | NULL               | NULL             |    0.000 |
      | 9676 | system user |           | NULL | Sleep   |       3 | NULL               | NULL             |    0.000 |
      | 9677 | system user |           | NULL | Sleep   |       3 | NULL               | NULL             |    0.000 |
      | 9678 | system user |           | NULL | Sleep   |       3 | NULL               | NULL             |    0.000 |
      | 9679 | system user |           | NULL | Sleep   |       3 | NULL               | NULL             |    0.000 |
      | 9680 | system user |           | NULL | Sleep   |       3 | NULL               | NULL             |    0.000 |
      | 9681 | system user |           | NULL | Sleep   |       3 | NULL               | NULL             |    0.000 |
      | 9682 | system user |           | NULL | Sleep   |       3 | NULL               | NULL             |    0.000 |
      | 9683 | system user |           | NULL | Sleep   |       3 | NULL               | NULL             |    0.000 |
      | 9684 | system user |           | NULL | Sleep   |       3 | NULL               | NULL             |    0.000 |
      | 9685 | system user |           | NULL | Sleep   |       3 | NULL               | NULL             |    0.000 |
      | 9686 | system user |           | NULL | Sleep   |       3 | NULL               | NULL             |    0.000 |
      | 9687 | system user |           | NULL | Sleep   |       3 | NULL               | NULL             |    0.000 |
      | 9688 | system user |           | NULL | Sleep   |       3 | NULL               | NULL             |    0.000 |
      | 9689 | system user |           | NULL | Sleep   |       3 | NULL               | NULL             |    0.000 |
      | 9690 | system user |           | NULL | Sleep   |       3 | NULL               | NULL             |    0.000 |
      | 9691 | system user |           | NULL | Sleep   |       3 | NULL               | NULL             |    0.000 |
      | 9692 | system user |           | NULL | Sleep   |       3 | NULL               | NULL             |    0.000 |
      | 9693 | system user |           | NULL | Sleep   |       3 | NULL               | NULL             |    0.000 |
      | 9694 | system user |           | NULL | Sleep   |       3 | NULL               | NULL             |    0.000 |
      | 9695 | system user |           | NULL | Sleep   |       3 | NULL               | NULL             |    0.000 |
      | 9696 | system user |           | NULL | Sleep   |       3 | NULL               | NULL             |    0.000 |
      | 9697 | system user |           | NULL | Sleep   |       3 | NULL               | NULL             |    0.000 |
      | 9698 | system user |           | NULL | Sleep   |       3 | NULL               | NULL             |    0.000 |
      | 9699 | system user |           | NULL | Sleep   |       3 | NULL               | NULL             |    0.000 |
      | 9700 | system user |           | NULL | Sleep   |       3 | NULL               | NULL             |    0.000 |
      | 9701 | system user |           | NULL | Sleep   |       3 | NULL               | NULL             |    0.000 |
      | 9702 | system user |           | NULL | Sleep   |       3 | NULL               | NULL             |    0.000 |
      | 9703 | system user |           | NULL | Sleep   |       3 | NULL               | NULL             |    0.000 |
      | 9704 | system user |           | NULL | Sleep   |       3 | NULL               | NULL             |    0.000 |
      | 9705 | system user |           | NULL | Sleep   |       3 | NULL               | NULL             |    0.000 |
      | 9706 | system user |           | NULL | Sleep   |       3 | NULL               | NULL             |    0.000 |
      | 9707 | system user |           | NULL | Sleep   |       3 | NULL               | NULL             |    0.000 |
      | 9708 | system user |           | NULL | Sleep   |       3 | NULL               | NULL             |    0.000 |
      | 9709 | system user |           | NULL | Sleep   |       3 | NULL               | NULL             |    0.000 |
      | 9710 | system user |           | NULL | Sleep   |       3 | NULL               | NULL             |    0.000 |
      | 9711 | system user |           | NULL | Sleep   |       3 | NULL               | NULL             |    0.000 |
      | 9712 | system user |           | NULL | Sleep   |       3 | NULL               | NULL             |    0.000 |
      | 9713 | system user |           | NULL | Sleep   |       3 | NULL               | NULL             |    0.000 |
      | 9714 | system user |           | NULL | Sleep   |       3 | NULL               | NULL             |    0.000 |
      | 9715 | system user |           | NULL | Sleep   |       3 | NULL               | NULL             |    0.000 |
      | 9716 | system user |           | NULL | Sleep   |       3 | NULL               | NULL             |    0.000 |
      | 9717 | system user |           | NULL | Sleep   |       3 | NULL               | NULL             |    0.000 |
      | 9718 | system user |           | NULL | Sleep   |       3 | NULL               | NULL             |    0.000 |
      | 9719 | system user |           | NULL | Sleep   |       3 | NULL               | NULL             |    0.000 |
      | 9720 | system user |           | NULL | Sleep   |       3 | NULL               | NULL             |    0.000 |
      | 9721 | system user |           | NULL | Sleep   |       3 | NULL               | NULL             |    0.000 |
      | 9722 | system user |           | NULL | Sleep   |       3 | NULL               | NULL             |    0.000 |
      | 9723 | system user |           | NULL | Sleep   |       3 | NULL               | NULL             |    0.000 |
      | 9724 | system user |           | NULL | Sleep   |       3 | NULL               | NULL             |    0.000 |
      | 9725 | system user |           | NULL | Sleep   |       3 | NULL               | NULL             |    0.000 |
      | 9726 | system user |           | NULL | Sleep   |       3 | NULL               | NULL             |    0.000 |
      | 9727 | system user |           | NULL | Sleep   |       3 | NULL               | NULL             |    0.000 |
      | 9728 | system user |           | NULL | Sleep   |       3 | NULL               | NULL             |    0.000 |
      | 9729 | system user |           | NULL | Sleep   |       3 | NULL               | NULL             |    0.000 |
      | 9730 | system user |           | NULL | Sleep   |       3 | NULL               | NULL             |    0.000 |
      | 9731 | system user |           | NULL | Sleep   |       3 | NULL               | NULL             |    0.000 |
      | 9732 | system user |           | NULL | Sleep   |       3 | NULL               | NULL             |    0.000 |
      +------+-------------+-----------+------+---------+---------+--------------------+------------------+----------+
      120 rows in set (0.03 sec)

      another 64 threads? Is that what I said.

        Attachments

          Activity

            People

            • Assignee:
              nirbhay_c Nirbhay Choubey (Inactive)
              Reporter:
              danblack Daniel Black
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: