Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.5.25
-
None
Description
Cluster goes to hang mode when running multi master on 10.5.25 build.
Server/WSREP provider version
node1:root@localhost> show status like 'wsrep_provider_version'; |
+------------------------+-------------------+ |
| Variable_name | Value |
|
+------------------------+-------------------+ |
| wsrep_provider_version | 26.4.18(ra96793f) |
|
+------------------------+-------------------+ |
1 row in set (0.078 sec) |
|
|
node1:root@localhost> show variables like 'version'; |
+---------------+---------------------+ |
| Variable_name | Value |
|
+---------------+---------------------+ |
| version | 10.5.25-MariaDB-log |
|
+---------------+---------------------+ |
1 row in set (0.001 sec) |
|
|
node1:root@localhost>
|
RQG and cnf files are attached.
RQG test case
perl gendata.pl --dsn=dbi:mysql:host=127.0.0.1:port=12039:user=root:database=test --spec=conf/transactions/transactions.zz
|
perl gentest.pl --dsn=dbi:mysql:host=127.0.0.1:port=12039:user=root:database=test --grammar=conf/transactions/transactions.yy --threads=32 --duration=60 --queries=10000 &
|
perl gentest.pl --dsn=dbi:mysql:host=127.0.0.1:port=10461:user=root:database=test --grammar=conf/transactions/transactions.yy --threads=32 --duration=60 --queries=10000 &
|
perl gentest.pl --dsn=dbi:mysql:host=127.0.0.1:port=10671:user=root:database=test --grammar=conf/transactions/transactions.yy --threads=32 --duration=60 --queries=10000 &
|
processlist
node1:root@localhost> show processlist;
|
+----+-------------+-----------------+------+---------+-------+---------------------------------+------------------------------------------------------------------------------------------------------+----------+
|
| Id | User | Host | db | Command | Time | State | Info | Progress |
|
+----+-------------+-----------------+------+---------+-------+---------------------------------+------------------------------------------------------------------------------------------------------+----------+
|
| 1 | system user | | NULL | Sleep | 33503 | wsrep aborter idle | NULL | 0.000 |
|
| 2 | system user | | NULL | Sleep | 33154 | wsrep applier committed | NULL | 0.000 |
|
| 6 | system user | | NULL | Sleep | 33154 | After apply log event | NULL | 0.000 |
|
| 7 | system user | | NULL | Sleep | 33154 | After apply log event | NULL | 0.000 |
|
| 8 | system user | | NULL | Sleep | 33154 | After apply log event | NULL | 0.000 |
|
| 9 | system user | | NULL | Sleep | 33154 | committing | NULL | 0.000 |
|
| 10 | system user | | NULL | Sleep | 33154 | committing | NULL | 0.000 |
|
| 11 | system user | | NULL | Sleep | 33154 | wsrep applier committed | NULL | 0.000 |
|
| 12 | system user | | NULL | Sleep | 33154 | wsrep applier committed | NULL | 0.000 |
|
| 13 | system user | | NULL | Sleep | 33154 | committing | NULL | 0.000 |
|
| 14 | system user | | NULL | Sleep | 33154 | wsrep applier committed | NULL | 0.000 |
|
| 15 | system user | | NULL | Sleep | 33154 | committing | NULL | 0.000 |
|
| 16 | system user | | NULL | Sleep | 33155 | wsrep applier committed | NULL | 0.000 |
|
| 17 | system user | | NULL | Sleep | 33154 | After apply log event | NULL | 0.000 |
|
| 18 | system user | | NULL | Sleep | 33154 | committing | NULL | 0.000 |
|
| 19 | system user | | NULL | Sleep | 33154 | committing | NULL | 0.000 |
|
| 20 | system user | | test | Sleep | 33154 | Waiting for table metadata lock | ALTER TABLE `table1_key_pk_parts_10_int_autoinc` ADD KEY idx ( col_int ) /* QNO 338 CON_ID 31 */ | 0.000 |
|
| 31 | root | localhost:54360 | test | Query | 33154 | starting | COMMIT /* QNO 236 CON_ID 31 */ | 0.000 |
|
| 32 | root | localhost:54366 | test | Query | 33154 | starting | COMMIT /* QNO 96 CON_ID 32 */ | 0.000 |
|
| 33 | root | localhost:54372 | test | Query | 33154 | starting | START TRANSACTION /* QNO 109 CON_ID 33 */ | 0.000 |
|
| 34 | root | localhost:54378 | test | Query | 33154 | starting | COMMIT /* QNO 160 CON_ID 34 */ | 0.000 |
|
| 35 | root | localhost:54386 | test | Query | 33154 | acquiring total order isolation | ALTER TABLE `table300_key_pk_parts_10_int_autoinc` DROP KEY ftidx, DROP KEY idx /* QNO 60 CON_ID 35 | 0.000 |
|
| 36 | root | localhost:54390 | test | Query | 33052 | starting | START TRANSACTION /* QNO 78 CON_ID 36 */ | 0.000 |
|
| 37 | root | localhost:54396 | test | Query | 33154 | starting | COMMIT /* QNO 61 CON_ID 37 */ | 0.000 |
|
| 38 | root | localhost:54402 | test | Query | 33154 | starting | COMMIT /* QNO 79 CON_ID 38 */ | 0.000 |
|
| 39 | root | localhost:54408 | test | Query | 33154 | starting | COMMIT /* QNO 95 CON_ID 39 */ | 0.000 |
|
| 40 | root | localhost:54418 | test | Query | 33154 | wsrep replaying trx | START TRANSACTION /* QNO 91 CON_ID 40 */ | 0.000 |
|
| 41 | root | localhost:54422 | test | Killed | 33154 | acquiring total order isolation | INSERT INTO `table1_key_pk_parts_10_int_autoinc` ( `col_int_key`, `col_int` ) SELECT `col_int`, `col | 0.000 |
|
| 42 | root | localhost:54428 | test | Query | 33052 | starting | START TRANSACTION /* QNO 55 CON_ID 42 */ | 0.000 |
|
| 43 | root | localhost:54434 | test | Query | 33155 | starting | START TRANSACTION /* QNO 42 CON_ID 43 */ | 0.000 |
|
| 44 | root | localhost:54440 | test | Query | 33155 | starting | COMMIT /* QNO 21 CON_ID 44 */ | 0.000 |
|
| 45 | root | localhost:54446 | test | Query | 33155 | wsrep replaying trx | START TRANSACTION /* QNO 17 CON_ID 45 */ | 0.000 |
|
| 46 | root | localhost:54452 | test | Query | 33155 | wsrep replaying trx | START TRANSACTION /* QNO 25 CON_ID 46 */ | 0.000 |
|
| 47 | root | localhost:54458 | test | Query | 33154 | acquiring total order isolation | INSERT INTO `table20_key_pk_parts_10_int_autoinc` ( `col_int_key`, `col_int` ) SELECT `col_int`, `co | 0.000 |
|
| 48 | root | localhost:54464 | test | Query | 33103 | starting | COMMIT /* QNO 26 CON_ID 48 */ | 0.000 |
|
| 49 | root | localhost:54472 | test | Query | 33103 | acquiring total order isolation | ALTER TABLE `table200_int_autoinc` ADD COLUMN extra INT /* QNO 39 CON_ID 49 */ | 0.000 |
|
| 50 | root | localhost:54478 | test | Query | 33154 | acquiring total order isolation | ALTER TABLE `table500_key_pk_parts_10_int_autoinc` DROP PRIMARY KEY /* QNO 15 CON_ID 50 */ | 0.000 |
|
| 51 | root | localhost:54486 | test | Query | 33052 | acquiring total order isolation | ALTER TABLE `table40_int_autoinc` ADD UNIQUE KEY uidx ( col_char_64_utf8_key(10) ) /* QNO 33 CON_ID | 0.000 |
|
| 52 | root | localhost:54492 | test | Query | 33154 | acquiring total order isolation | ALTER TABLE `table20_key_pk_parts_10_int_autoinc` DROP PRIMARY KEY /* QNO 18 CON_ID 52 */ | 0.000 |
|
| 53 | root | localhost:54500 | test | Query | 33154 | starting | START TRANSACTION /* QNO 7 CON_ID 53 */ | 0.000 |
|
| 54 | root | localhost:54506 | test | Query | 33154 | acquiring total order isolation | ALTER TABLE `table20_key_pk_parts_10_int_autoinc` ADD KEY idx ( col_int_key ) /* QNO 8 CON_ID 54 */ | 0.000 |
|
| 55 | root | localhost:54512 | test | Query | 33154 | acquiring total order isolation | INSERT INTO `table30_key_pk_parts_10_int_autoinc` ( `col_int_key`, `col_int` ) SELECT `col_int`, `co | 0.000 |
|
| 56 | root | localhost:54518 | test | Query | 33154 | Waiting for table metadata lock | INSERT INTO `table1100_int_autoinc` ( `col_int_key`, `col_int` ) SELECT `col_int`, `col_int_key` FRO | 0.000 |
|
| 57 | root | localhost:54524 | test | Query | 33154 | starting | COMMIT /* QNO 12 CON_ID 57 */ | 0.000 |
|
| 58 | root | localhost:54530 | test | Query | 33154 | starting | COMMIT /* QNO 6 CON_ID 58 */ | 0.000 |
|
| 59 | root | localhost:54536 | test | Query | 33153 | starting | START TRANSACTION /* QNO 33 CON_ID 59 */ | 0.000 |
|
| 60 | root | localhost:54542 | test | Query | 33153 | starting | COMMIT /* QNO 14 CON_ID 60 */ | 0.000 |
|
| 61 | root | localhost:54548 | test | Query | 33153 | acquiring total order isolation | ALTER TABLE `table20_int_autoinc` ADD COLUMN extra INT /* QNO 5 CON_ID 61 */ | 0.000 |
|
| 62 | root | localhost:54552 | test | Query | 33153 | starting | START TRANSACTION /* QNO 14 CON_ID 62 */ | 0.000 |
|
| 65 | root | localhost | test | Query | 131 | acquiring total order isolation | create table t1(id int) | 0.000 |
|
| 66 | root | localhost | test | Query | 0 | starting | show processlist | 0.000 |
|
+----+-------------+-----------------+------+---------+-------+---------------------------------+------------------------------------------------------------------------------------------------------+----------+
|
51 rows in set (0.001 sec)
|
|
|
node1:root@localhost>
|