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

replication slave - deadlock in terminate_slave_thread with stop slave and show variables of replication filters and show global status

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 5.5.37, 10.0.17
    • Fix Version/s: 5.5.43
    • Component/s: Replication
    • Labels:
    • Environment:
      rhel

      Description

      On a new 5.5.40 server the replication didn't even start. Databases where created. No replication could start. Identically configured server at same time was created and is replicating ok.

      SHOW STATUS of any portion of it fails to return. Show global variables like (any replication filter variable) fails to return.

      configuration:

      replicate_ignore_table as set to a list of tables. No other replication filters where set.

      results from queries:

      MariaDB [(none)]> show master status;
      +------------------------------+----------+--------------+------------------+
      | File                         | Position | Binlog_Do_DB | Binlog_Ignore_DB |
      +------------------------------+----------+--------------+------------------+
      | tulwaurp009-mysql-bin.000001 |      575 |              |                  |
      +------------------------------+----------+--------------+------------------+
      1 row in set (0.00 sec)
       
      MariaDB [(none)]> show binlog events in 'tulwaurp009-mysql-bin.000001'
          -> ;
      +------------------------------+-----+-------------+-----------+-------------+---------------------------------------------------------------------------+
      | Log_name                     | Pos | Event_type  | Server_id | End_log_pos | Info                                                                      |
      +------------------------------+-----+-------------+-----------+-------------+---------------------------------------------------------------------------+
      | tulwaurp009-mysql-bin.000001 |   4 | Format_desc |        15 |         245 | Server ver: 5.5.40-MariaDB-log, Binlog ver: 4                             |
      | tulwaurp009-mysql-bin.000001 | 245 | Query       |        15 |         369 | use `test`; create table  test ( x int unsigned not null, y varchar(300)) |
      | tulwaurp009-mysql-bin.000001 | 369 | Query       |        15 |         437 | BEGIN                                                                     |
      | tulwaurp009-mysql-bin.000001 | 437 | Query       |        15 |         548 | use `test`; insert into test values (3,'banana'), (4,'pear')              |
      | tulwaurp009-mysql-bin.000001 | 548 | Xid         |        15 |         575 | COMMIT /* xid=66401467 */                                                 |
      +------------------------------+-----+-------------+-----------+-------------+---------------------------------------------------------------------------+

      Above create table and insert was made after the replication was started as a test.

      SHOW PROCESSLIST

      +-------+-------------+---------------------+--------------------+---------+---------+----------------------------------+--------------------------------+----------+
      | Id    | User        | Host                | db                 | Command | Time    | State                            | Info                           | Progress |
      +-------+-------------+---------------------+--------------------+---------+---------+----------------------------------+--------------------------------+----------+
      |     1 | system user |                     | NULL               | Connect | 2171672 | Waiting for master to send event | NULL                           |    0.000 |
      |     2 | system user |                     | NULL               | Connect | 2044491 | closing tables                   | NULL                           |    0.000 |
      |  6122 | mysql       | localhost           | NULL               | Query   | 2044491 | Filling schema table             | show /*!50002 GLOBAL */ status |    0.000 |
      |  6123 | mysql       | localhost           | NULL               | Killed  | 2044491 | Killing slave                    | STOP SLAVE                     |    0.000 |
      |  6124 | mysql       | 172.16.66.21:49108  | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      |  6125 | mysql       | 172.16.66.21:49117  | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      |  6126 | mysql       | localhost           | NULL               | Killed  | 2044431 | Filling schema table             | show /*!50002 GLOBAL */ status |    0.000 |
      |  6127 | mysql       | 172.16.66.21:49124  | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      |  6128 | mysql       | localhost           | NULL               | Query   | 2044371 | Filling schema table             | show /*!50002 GLOBAL */ status |    0.000 |
      |  6129 | mysql       | localhost           | NULL               | Query   | 2044311 | Filling schema table             | show /*!50002 GLOBAL */ status |    0.000 |
      |  6130 | mysql       | 172.16.66.21:49142  | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      |  6131 | mysql       | 172.16.66.21:49189  | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      |  6132 | mysql       | localhost           | NULL               | Query   | 2044251 | Filling schema table             | show /*!50002 GLOBAL */ status |    0.000 |
      |  6133 | mysql       | localhost           | NULL               | Query   | 2044191 | Filling schema table             | show /*!50002 GLOBAL */ status |    0.000 |
      |  6134 | mysql       | 172.16.66.21:49304  | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      |  6135 | mysql       | 172.16.66.21:49311  | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      |  6136 | mysql       | localhost           | NULL               | Query   | 2044131 | Filling schema table             | show /*!50002 GLOBAL */ status |    0.000 |
      |  6137 | mysql       | 172.16.66.21:49318  | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      |  6138 | mysql       | localhost           | NULL               | Query   | 2044071 | Filling schema table             | show /*!50002 GLOBAL */ status |    0.000 |
      |  6139 | mysql       | 172.16.66.21:49328  | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      |  6140 | mysql       | localhost           | NULL               | Query   | 2044011 | Filling schema table             | show /*!50002 GLOBAL */ status |    0.000 |
      |  6141 | mysql       | 172.16.66.21:49385  | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      |  6142 | mysql       | localhost           | NULL               | Query   | 2043951 | Filling schema table             | show /*!50002 GLOBAL */ status |    0.000 |
      |  6143 | mysql       | localhost           | NULL               | Query   | 2043891 | Filling schema table             | show /*!50002 GLOBAL */ status |    0.000 |
      |  6144 | mysql       | 172.16.66.21:49392  | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      |  6145 | mysql       | 172.16.66.21:49401  | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      |  6146 | mysql       | localhost           | NULL               | Query   | 2043831 | Filling schema table             | show /*!50002 GLOBAL */ status |    0.000 |
      |  6147 | mysql       | localhost           | NULL               | Query   | 2043771 | Filling schema table             | show /*!50002 GLOBAL */ status |    0.000 |
      |  6148 | mysql       | 172.16.66.21:49408  | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      |  6149 | mysql       | 172.16.66.21:49418  | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      |  6150 | mysql       | localhost           | NULL               | Query   | 2043711 | Filling schema table             | show /*!50002 GLOBAL */ status |    0.000 |
      |  6151 | mysql       | 172.16.66.21:49473  | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      |  6152 | mysql       | localhost           | NULL               | Query   | 2043651 | Filling schema table             | show /*!50002 GLOBAL */ status |    0.000 |
      |  6153 | mysql       | 172.16.66.21:49480  | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      |  6154 | mysql       | localhost           | NULL               | Query   | 2043591 | Filling schema table             | show /*!50002 GLOBAL */ status |    0.000 |
      |  6155 | mysql       | localhost           | NULL               | Query   | 2043531 | Filling schema table             | show /*!50002 GLOBAL */ status |    0.000 |
      |  6156 | mysql       | 172.16.66.21:49487  | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      |  6157 | mysql       | 172.16.66.21:49602  | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      |  6158 | mysql       | localhost           | NULL               | Query   | 2043471 | Filling schema table             | show /*!50002 GLOBAL */ status |    0.000 |
      |  6159 | mysql       | localhost           | NULL               | Query   | 2043411 | Filling schema table             | show /*!50002 GLOBAL */ status |    0.000 |
      |  6160 | mysql       | 172.16.66.21:49621  | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      |  6161 | mysql       | 172.16.66.21:49669  | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      |  6162 | mysql       | localhost           | NULL               | Query   | 2043351 | Filling schema table             | show /*!50002 GLOBAL */ status |    0.000 |
      |  6163 | mysql       | 172.16.66.21:49676  | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      |  6164 | mysql       | localhost           | NULL               | Query   | 2043291 | Filling schema table             | show /*!50002 GLOBAL */ status |    0.000 |
      |  6165 | mysql       | localhost           | NULL               | Query   | 2043231 | Filling schema table             | show /*!50002 GLOBAL */ status |    0.000 |
      |  6166 | mysql       | 172.16.66.21:49685  | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      |  6167 | mysql       | 172.16.66.21:49692  | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      |  6168 | mysql       | localhost           | NULL               | Query   | 2043171 | Filling schema table             | show /*!50002 GLOBAL */ status |    0.000 |
      |  6169 | mysql       | 172.16.66.21:49707  | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      |  6170 | mysql       | localhost           | NULL               | Query   | 2043111 | Filling schema table             | show /*!50002 GLOBAL */ status |    0.000 |
      |  6171 | mysql       | 172.16.66.21:49757  | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      |  6172 | mysql       | localhost           | NULL               | Query   | 2043051 | Filling schema table             | show /*!50002 GLOBAL */ status |    0.000 |
      |  6173 | mysql       | 172.16.66.21:49764  | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      |  6174 | mysql       | localhost           | NULL               | Query   | 2042991 | Filling schema table             | show /*!50002 GLOBAL */ status |    0.000 |
      |  6175 | mysql       | 172.16.66.21:49771  | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      |  6176 | mysql       | localhost           | NULL               | Query   | 2042931 | Filling schema table             | show /*!50002 GLOBAL */ status |    0.000 |
      |  6177 | mysql       | 172.16.66.21:49778  | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      |  6178 | mysql       | localhost           | NULL               | Query   | 2042871 | Filling schema table             | show /*!50002 GLOBAL */ status |    0.000 |
      |  6179 | mysql       | 172.16.66.21:49793  | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      |  6180 | mysql       | localhost           | NULL               | Query   | 2042811 | Filling schema table             | show /*!50002 GLOBAL */ status |    0.000 |
      |  6181 | mysql       | 172.16.66.21:49845  | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      |  6182 | mysql       | localhost           | NULL               | Query   | 2042751 | Filling schema table             | show /*!50002 GLOBAL */ status |    0.000 |
      |  6183 | mysql       | localhost           | NULL               | Query   | 2042691 | Filling schema table             | show /*!50002 GLOBAL */ status |    0.000 |
      |  6184 | mysql       | 172.16.66.21:49854  | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      |  6185 | mysql       | 172.16.66.21:49969  | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      |  6186 | mysql       | localhost           | NULL               | Query   | 2042631 | Filling schema table             | show /*!50002 GLOBAL */ status |    0.000 |
      |  6187 | mysql       | 172.16.66.21:49976  | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      |  6188 | mysql       | localhost           | NULL               | Query   | 2042571 | Filling schema table             | show /*!50002 GLOBAL */ status |    0.000 |
      |  6189 | mysql       | localhost           | NULL               | Query   | 2042511 | Filling schema table             | show /*!50002 GLOBAL */ status |    0.000 |
      |  6190 | mysql       | 172.16.66.21:49993  | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      |  6191 | mysql       | 172.16.66.21:50042  | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      |  6192 | mysql       | localhost           | NULL               | Query   | 2042451 | Filling schema table             | show /*!50002 GLOBAL */ status |    0.000 |
      |  6193 | mysql       | localhost           | NULL               | Query   | 2042391 | Filling schema table             | show /*!50002 GLOBAL */ status |    0.000 |
      |  6194 | mysql       | 172.16.66.21:50049  | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      |  6195 | mysql       | localhost           | NULL               | Query   | 2042331 | Filling schema table             | show /*!50002 GLOBAL */ status |    0.000 |
      |  6196 | mysql       | 172.16.66.21:50060  | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      |  6197 | mysql       | localhost           | NULL               | Query   | 2042271 | Filling schema table             | show /*!50002 GLOBAL */ status |    0.000 |
      |  6198 | mysql       | 172.16.66.21:50171  | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      |  6199 | mysql       | localhost           | NULL               | Query   | 2042211 | Filling schema table             | show /*!50002 GLOBAL */ status |    0.000 |
      |  6200 | mysql       | 172.16.66.21:50190  | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      |  6201 | mysql       | localhost           | NULL               | Query   | 2042151 | Filling schema table             | show /*!50002 GLOBAL */ status |    0.000 |
      |  6202 | mysql       | 172.16.66.21:50238  | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      |  6203 | mysql       | localhost           | NULL               | Query   | 2042091 | Filling schema table             | show /*!50002 GLOBAL */ status |    0.000 |
      |  6204 | mysql       | 172.16.66.21:50245  | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      |  6205 | mysql       | localhost           | NULL               | Query   | 2042031 | Filling schema table             | show /*!50002 GLOBAL */ status |    0.000 |
      |  6206 | mysql       | 172.16.66.21:50254  | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      |  6207 | mysql       | localhost           | NULL               | Query   | 2041971 | Filling schema table             | show /*!50002 GLOBAL */ status |    0.000 |
      |  6208 | mysql       | 172.16.66.21:50261  | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      |  6209 | mysql       | localhost           | NULL               | Query   | 2041911 | Filling schema table             | show /*!50002 GLOBAL */ status |    0.000 |
      |  6210 | mysql       | 172.16.66.21:50273  | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      |  6211 | mysql       | localhost           | NULL               | Query   | 2041851 | Filling schema table             | show /*!50002 GLOBAL */ status |    0.000 |
      |  6212 | mysql       | 172.16.66.21:50338  | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      |  6213 | mysql       | localhost           | NULL               | Query   | 2041791 | Filling schema table             | show /*!50002 GLOBAL */ status |    0.000 |
      |  6214 | mysql       | 172.16.66.21:50441  | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      |  6215 | mysql       | localhost           | NULL               | Query   | 2041731 | Filling schema table             | show /*!50002 GLOBAL */ status |    0.000 |
      |  6216 | mysql       | 172.16.66.21:50448  | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      |  6217 | mysql       | localhost           | NULL               | Query   | 2041671 | Filling schema table             | show /*!50002 GLOBAL */ status |    0.000 |
      |  6218 | mysql       | 172.16.66.21:50455  | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      |  6219 | mysql       | localhost           | NULL               | Query   | 2041611 | Filling schema table             | show /*!50002 GLOBAL */ status |    0.000 |
      |  6220 | mysql       | 172.16.66.21:50471  | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      |  6221 | mysql       | localhost           | NULL               | Query   | 2041551 | Filling schema table             | show /*!50002 GLOBAL */ status |    0.000 |
      |  6222 | mysql       | 172.16.66.21:50522  | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      |  6223 | mysql       | localhost           | NULL               | Query   | 2041491 | Filling schema table             | show /*!50002 GLOBAL */ status |    0.000 |
      |  6224 | mysql       | 172.16.66.21:50529  | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      |  6225 | mysql       | localhost           | NULL               | Query   | 2041431 | Filling schema table             | show /*!50002 GLOBAL */ status |    0.000 |
      |  6226 | mysql       | 172.16.66.21:50538  | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      |  6227 | mysql       | localhost           | NULL               | Query   | 2041371 | Filling schema table             | show /*!50002 GLOBAL */ status |    0.000 |
      |  6228 | mysql       | 172.16.66.21:50545  | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      |  6229 | mysql       | localhost           | NULL               | Query   | 2041311 | Filling schema table             | show /*!50002 GLOBAL */ status |    0.000 |
      |  6230 | mysql       | 172.16.66.21:50558  | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      |  6231 | mysql       | localhost           | NULL               | Query   | 2041251 | Filling schema table             | show /*!50002 GLOBAL */ status |    0.000 |
      |  6232 | mysql       | 172.16.66.21:50610  | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      |  6233 | mysql       | localhost           | NULL               | Query   | 2041191 | Filling schema table             | show /*!50002 GLOBAL */ status |    0.000 |
      |  6234 | mysql       | 172.16.66.21:50617  | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      |  6235 | mysql       | localhost           | NULL               | Query   | 2041131 | Filling schema table             | show /*!50002 GLOBAL */ status |    0.000 |
      |  6236 | mysql       | 172.16.66.21:50630  | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      |  6237 | mysql       | localhost           | NULL               | Query   | 2041071 | Filling schema table             | show /*!50002 GLOBAL */ status |    0.000 |
      |  6238 | mysql       | 172.16.66.21:50739  | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      |  6239 | mysql       | localhost           | NULL               | Query   | 2041011 | Filling schema table             | show /*!50002 GLOBAL */ status |    0.000 |
      |  6240 | mysql       | 172.16.66.21:50761  | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      |  6241 | mysql       | localhost           | NULL               | Query   | 2040951 | Filling schema table             | show /*!50002 GLOBAL */ status |    0.000 |
      |  6242 | mysql       | 172.16.66.21:50804  | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      |  6243 | mysql       | localhost           | NULL               | Query   | 2040891 | Filling schema table             | show /*!50002 GLOBAL */ status |    0.000 |
      |  6244 | mysql       | localhost           | NULL               | Query   | 2040891 | Filling schema table             | show status                    |    0.000 |
      |  6245 | mysql       | 172.16.66.21:50811  | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      |  6246 | mysql       | localhost           | NULL               | Query   | 2040831 | Filling schema table             | show /*!50002 GLOBAL */ status |    0.000 |
      |  6247 | mysql       | 172.16.66.21:50823  | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      |  6248 | mysql       | localhost           | NULL               | Query   | 2040771 | Filling schema table             | show /*!50002 GLOBAL */ status |    0.000 |
      |  6249 | mysql       | 172.16.66.21:50830  | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      |  6250 | mysql       | localhost           | NULL               | Query   | 2040711 | Filling schema table             | show /*!50002 GLOBAL */ status |    0.000 |
      |  6251 | mysql       | 172.16.66.21:50845  | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      |  6252 | mysql       | localhost           | NULL               | Query   | 2040651 | Filling schema table             | show /*!50002 GLOBAL */ status |    0.000 |
      |  6253 | mysql       | 172.16.66.21:50913  | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      |  6254 | mysql       | 172.16.66.21:51010  | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      |  6255 | mysql       | localhost           | NULL               | Query   | 2040591 | Filling schema table             | show /*!50002 GLOBAL */ status |    0.000 |
      |  6256 | mysql       | localhost           | NULL               | Query   | 2040531 | Filling schema table             | show /*!50002 GLOBAL */ status |    0.000 |
      |  6257 | mysql       | 172.16.66.21:51017  | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      |  6258 | mysql       | localhost           | NULL               | Query   | 2040471 | Filling schema table             | show /*!50002 GLOBAL */ status |    0.000 |
      |  6259 | mysql       | 172.16.66.21:51024  | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      |  6260 | mysql       | 172.16.66.21:51039  | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      |  6261 | mysql       | localhost           | NULL               | Query   | 2040411 | Filling schema table             | show /*!50002 GLOBAL */ status |    0.000 |
      |  6262 | mysql       | localhost           | NULL               | Query   | 2040351 | Filling schema table             | show /*!50002 GLOBAL */ status |    0.000 |
      |  6263 | mysql       | 172.16.66.21:51089  | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      |  6264 | mysql       | 172.16.66.21:51096  | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      |  6265 | mysql       | localhost           | NULL               | Query   | 2040291 | Filling schema table             | show /*!50002 GLOBAL */ status |    0.000 |
      |  6266 | mysql       | localhost           | NULL               | Query   | 2040231 | Filling schema table             | show /*!50002 GLOBAL */ status |    0.000 |
      |  6267 | mysql       | 172.16.66.21:51105  | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      |  6268 | mysql       | localhost           | NULL               | Query   | 2040171 | Filling schema table             | show /*!50002 GLOBAL */ status |    0.000 |
      |  6269 | mysql       | 172.16.66.21:51112  | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      | 14881 | mysql       | 172.16.66.21:39304  | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      | 14882 | percona     | 172.17.100.40:49399 | NULL               | Killed  | 1402484 | NULL                             | SHOW SLAVE STATUS              |    0.000 |
      | 14883 | root        | localhost           | NULL               | Killed  |  465087 | NULL                             | show slave status              |    0.000 |
      | 14884 | root        | localhost           | NULL               | Killed  |  465043 | NULL                             | NULL                           |    0.000 |
      | 14885 | root        | localhost           | NULL               | Killed  |  465037 | NULL                             | NULL                           |    0.000 |
      | 14886 | root        | localhost           | NULL               | Killed  |  465028 | NULL                             | NULL                           |    0.000 |
      | 14887 | root        | localhost           | NULL               | Killed  |  464998 | NULL                             | show slave status              |    0.000 |
      | 14888 | root        | localhost           | NULL               | Killed  |  464976 | NULL                             | NULL                           |    0.000 |
      | 14889 | root        | localhost           | NULL               | Killed  |  464971 | NULL                             | NULL                           |    0.000 |
      | 14890 | root        | localhost           | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      | 14891 | root        | localhost           | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      | 14892 | root        | localhost           | NULL               | Killed  |    NULL | login                            | NULL                           |    0.000 |
      | 14893 | root        | localhost           | NULL               | Killed  |  357241 | NULL                             | show slave status              |    0.000 |
      | 14894 | root        | 172.16.66.21:47981  | NULL               | Killed  |    3529 | NULL                             | show slave status              |    0.000 |
      | 14895 | root        | 172.16.66.21:48146  | NULL               | Killed  |    3370 | NULL                             | NULL                           |    0.000 |
      | 14896 | root        | 172.16.66.21:48147  | NULL               | Killed  |    3368 | NULL                             | NULL                           |    0.000 |
      | 14897 | root        | 172.16.66.21:48148  | NULL               | Killed  |    3082 | Filling schema table             | show global variables          |    0.000 |
      | 14898 | root        | 172.16.66.21:48207  | NULL               | Killed  |    3080 | NULL                             | NULL                           |    0.000 |
      | 14899 | root        | 172.16.66.21:48208  | NULL               | Killed  |    3079 | NULL                             | NULL                           |    0.000 |
      | 14900 | root        | 172.16.66.21:48209  | NULL               | Killed  |    3075 | Filling schema table             | show variables                 |    0.000 |
      | 14901 | root        | 172.16.66.21:48319  | NULL               | Killed  |    3029 | NULL                             | NULL                           |    0.000 |
      | 14902 | root        | 172.16.66.21:48320  | NULL               | Killed  |    3028 | NULL                             | NULL                           |    0.000 |
      | 14903 | root        | 172.16.66.21:48321  | NULL               | Killed  |    2948 | Filling schema table             | show status                    |    0.000 |
      | 14904 | root        | 172.16.66.21:48324  | NULL               | Killed  |    2877 | NULL                             | NULL                           |    0.000 |
      | 14905 | root        | 172.16.66.21:48327  | NULL               | Killed  |    2872 | NULL                             | NULL                           |    0.000 |
      | 14906 | root        | 172.16.66.21:48329  | information_schema | Killed  |    2423 | NULL                             | NULL                           |    0.000 |
      | 14907 | root        | 172.16.66.21:48441  | NULL               | Killed  |    1746 | NULL                             | show slave status              |    0.000 |
      | 14908 | root        | 172.16.66.21:48667  | NULL               | Killed  |    1745 | NULL                             | NULL                           |    0.000 |
      | 14909 | root        | 172.16.66.21:48669  | NULL               | Killed  |    1727 | NULL                             | NULL                           |    0.000 |
      | 14910 | root        | 172.16.66.21:48670  | NULL               | Killed  |    1715 | NULL                             | NULL                           |    0.000 |
      | 14911 | root        | 172.16.66.21:48671  | mysql              | Killed  |     199 | NULL                             | NULL                           |    0.000 |
      | 14912 | root        | 172.16.66.21:49289  | NULL               | Killed  |     174 | NULL                             | NULL                           |    0.000 |
      | 14913 | root        | 172.16.66.21:49291  | NULL               | Query   |       0 | NULL                             | show processlist               |    0.000 |

      (several 1000 killed login and duplicate processes in same status removed)

      show databases worked.

      I am able to query databases including mysql database.

      All of these queries returned results:

      MariaDB [information_schema]> select * from KEY_CACHES;
      +----------------+----------+----------------+-----------+------------+-------------+---------------+--------------+---------------+-------+----------------+--------+
      | KEY_CACHE_NAME | SEGMENTS | SEGMENT_NUMBER | FULL_SIZE | BLOCK_SIZE | USED_BLOCKS | UNUSED_BLOCKS | DIRTY_BLOCKS | READ_REQUESTS | READS | WRITE_REQUESTS | WRITES |
      +----------------+----------+----------------+-----------+------------+-------------+---------------+--------------+---------------+-------+----------------+--------+
      | default        |     NULL |           NULL | 209715200 |       1024 |         177 |        166470 |            0 |          7253 |   171 |           1745 |   1734 |
      +----------------+----------+----------------+-----------+------------+-------------+---------------+--------------+---------------+-------+----------------+--------+
      1 row in set (0.00 sec)
       
      MariaDB [information_schema]> select * from VIEWS;
      Empty set (0.03 sec)
       
       
      MariaDB [information_schema]> select @@max_connections;
      +-------------------+
      | @@max_connections |
      +-------------------+
      |              3200 |
      +-------------------+

      MariaDB [information_schema]> show variables like '%conn%';
      Current database: information_schema
       
      +--------------------------+-----------------+
      | Variable_name            | Value           |
      +--------------------------+-----------------+
      | character_set_connection | utf8            |
      | collation_connection     | utf8_general_ci |
      | connect_timeout          | 10              |
      | extra_max_connections    | 1               |
      | init_connect             |                 |
      | max_connect_errors       | 10              |
      | max_connections          | 3200            |
      | max_user_connections     | 0               |
      +--------------------------+-----------------+
      8 rows in set (0.00 sec)
       
      MariaDB [information_schema]> show variables like '%binlog%';
      | binlog_annotate_row_events              | ON                   |
      | binlog_cache_size                       | 32768                |
      | binlog_checksum                         | NONE                 |
      | binlog_direct_non_transactional_updates | OFF                  |
      | binlog_format                           | MIXED                |
      | binlog_optimize_thread_scheduling       | ON                   |
      | binlog_stmt_cache_size                  | 32768                |
      | innodb_locks_unsafe_for_binlog          | OFF                  |
      | max_binlog_cache_size                   | 18446744073709547520 |
      | max_binlog_size                         | 1073741824           |
      | max_binlog_stmt_cache_size              | 18446744073709547520 |
      | sync_binlog                             | 0                    |
       
       
      MariaDB [(none)]> show global variables like 'Aria%';
      ...
      MariaDB [(none)]> show global variables like 'auto%';
      ...
       
      MariaDB [(none)]> show global variables like 'back%';
      +---------------+-------+
      | Variable_name | Value |
      +---------------+-------+
      | back_log      | 50    |
      +---------------+-------+
       
      MariaDB [(none)]> show global variables like 'character%';
      ...
      MariaDB [(none)]> show global variables like 'col%';
      .
       
      MariaDB [(none)]> show global variables like 'con%';
      ...
       
      MariaDB [(none)]> show global variables like 'da%';
       
       
      MariaDB [(none)]> show global variables like 'de%';
       
      show global variables like 'd%';
      ..
      show global variables like 'e%';
      .....
      show global variables like 'q%';
       
      show global variables like 'ra%';
       
      +------------------------+-------+
      | Variable_name          | Value |
      +------------------------+-------+
      | range_alloc_block_size | 4096  |
       
      show global variables like 'read%';
       
      MariaDB [(none)]> show global variables like 'relay%';
      +-----------------------+-----------------------+
      | Variable_name         | Value                 |
      +-----------------------+-----------------------+
      | relay_log             | tulwaurp009-relay-bin |
      | relay_log_index       |                       |
      | relay_log_info_file   | relay-log.info        |
      | relay_log_purge       | ON                    |
      | relay_log_recovery    | OFF                   |
      | relay_log_space_limit | 0                     |
      +-----------------------+-----------------------+
       
      MariaDB [(none)]> show global variables like 'replicate_a%';
       
      +-------------------------------+-------+
      | Variable_name                 | Value |
      +-------------------------------+-------+
      | replicate_annotate_row_events | ON    |
      +-------------------------------+-------+
      1 row in set (0.00 sec)
       
      show global variables like 'report%';
      | Variable_name   | Value       |
      +-----------------+-------------+
      | report_host     | tulwaurp009 |
      | report_password |             |
      | report_port     | 3306        |
      | report_user     |             |
       
      show global variables like 'ro%';
      show global variables like 's%';
      show global variables like 't%';
      ....
      show global variables like 'z%';

      no response:

      • show variables like '%table%';
      • show global variables like 'r%';
      • show global variables like 're%';
      • show global variables like 'repl%';
      • show global variables like 'replicate_d%';
      • show global variables like 'replicate_do_db';
      • show global variables like 'replicate_do_table;
      • show global variables like 'replicate_i%';
      • show global status like 'Aria%';
      • show global status like 'Aria_pagecache%';
      • show global status like 'Aria_trans%';
      • show global status like 'Com_%';
      • show global status like 'Bytes_%';
      • show global status like 'Busy_%';
      • show global status like 'x%';
      • show status
      • show global status
      • show variables
      • show global variables
      • select * from information_schema.session_status;
      • select * from information_schema.session_status limit 3;

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                serg Sergei Golubchik
                Reporter:
                danblack Daniel Black
              • Votes:
                1 Vote for this issue
                Watchers:
                6 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: