Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Incomplete
-
10.6
-
None
Description
Testcase
Start 3 node cluster
|
-- Node1
|
CREATE TABLE test.tbl (
|
id int NOT NULL AUTO_INCREMENT,
|
t_id varchar(10) NOT NULL,
|
dt timestamp DEFAULT current_timestamp(),
|
a_id int DEFAULT 0,
|
PRIMARY KEY (id),
|
INDEX ix_dt (dt)
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 DEFAULT COLLATE=latin1_swedish_ci;
|
|
-- Node3
|
Run mysqlslap test on node3
|
sudo mysqlslap -uroot -i 50000 -c 5 --create-schema=test --no-drop --delimiter=";" --query="insert into test.tbl (t_id, a_id) values('100100',1);insert into test.tbl (t_id) values('200200');" &
|
|
Node3 goes into hang mode with a commit state of "Waiting for prior transaction to commit".
|
|
| 48 | root | localhost | NULL | Sleep | 19 | | NULL | 0.000 |
|
| 844 | root | localhost | test | Query | 18 | Commit | insert into test.tbl (t_id, a_id) values('100100',1) | 0.000 |
|
| 845 | root | localhost | test | Query | 18 | Commit | insert into test.tbl (t_id) values('200200') | 0.000 |
|
| 846 | root | localhost | test | Query | 18 | Commit | insert into test.tbl (t_id, a_id) values('100100',1) | 0.000 |
|
| 847 | root | localhost | test | Query | 18 | Waiting for prior transaction to commit | insert into test.tbl (t_id, a_id) values('100100',1) | 0.000 |
|
| 848 | root | localhost | test | Query | 18 | Commit | insert into test.tbl (t_id, a_id) values('100100',1) | 0.000 |
|
| 849 | root | localhost | NULL | Query | 0 | starting | show processlist | 0.000 |
|
+-----+-------------+-----------+---------+---------+------+-----------------------------------------+----------------------------------------------------------------------------+----------+
|
48 rows in set (0.001 sec)
|
|