[MDEV-7126] replication slave - deadlock in terminate_slave_thread with stop slave and show variables of replication filters and show global status - Jira

XML

Word

Printable

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:
- verified
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

relates to

MDEV-8527 show slave status, show global status deadlock

Closed

MDEV-7667 aborting stop slave doesn't recover

Closed

MDEV-8039 parallel replication slave - indefinate lock wait in rpl_parallel::wait_for_done when terminate_slave_thread with stop slave while show global status/show slave status was running

Closed

links to

Applied Patch

Activity

People

Assignee:: Sergei Golubchik

Reporter:: Daniel Black

Votes:: 1 Vote for this issue

Watchers:: 6 Start watching this issue

Dates

Created:: 2014-11-18 09:37

Updated:: 2015-07-23 06:07

Resolved:: 2015-04-27 13:48

Git Integration

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