Debian Codegraph @

mysql-test/suite/innodb/r/innodb_bug30113362.result

raw
1 SET GLOBAL innodb_adaptive_hash_index = false;
2 SET GLOBAL innodb_stats_persistent = false;
3 connect purge_control,localhost,root,,;
4 START TRANSACTION WITH CONSISTENT SNAPSHOT;
5 connect con2,localhost,root,,;
6 CREATE TABLE t1 (
7 a00 CHAR(255) NOT NULL DEFAULT 'a',
8 a01 CHAR(255) NOT NULL DEFAULT 'a',
9 a02 CHAR(255) NOT NULL DEFAULT 'a',
10 b INT NOT NULL DEFAULT 0,
11 PRIMARY KEY(a00, a01, a02)
12 ) charset latin1 ENGINE = InnoDB COMMENT='MERGE_THRESHOLD=45';
13 SET GLOBAL innodb_limit_optimistic_insert_debug = 3;
14 CREATE PROCEDURE data_load_t1()
15 BEGIN
16 DECLARE c1 INT DEFAULT 97;
17 DECLARE c2 INT DEFAULT 97;
18 DECLARE c3 INT DEFAULT 97;
19 WHILE c1 < 102 DO
20 WHILE c2 < 123 DO
21 WHILE c3 < 123 DO
22 INSERT INTO t1 (a00) VALUES (CHAR(c1,c2,c3));
23 SET c3 = c3 + 1;
24 END WHILE;
25 SET c3 = 97;
26 SET c2 = c2 + 1;
27 END WHILE;
28 SET c2 = 97;
29 SET c1 = c1 + 1;
30 END WHILE;
31 END |
32 call data_load_t1();
33 DROP PROCEDURE data_load_t1;
34 ANALYZE TABLE t1;
35 Table Op Msg_type Msg_text
36 test.t1 analyze status Engine-independent statistics collected
37 test.t1 analyze status OK
38 SELECT CLUST_INDEX_SIZE FROM information_schema.INNODB_SYS_TABLESTATS WHERE NAME = 'test/t1';
39 CLUST_INDEX_SIZE
40 1792
41 connection con2;
42 DELETE FROM t1 WHERE a00 = 'cnm';
43 COMMIT;
44 BEGIN;
45 INSERT INTO t1 SET a00 = 'cnm';
46 connection purge_control;
47 COMMIT;
48 connection con2;
49 SET GLOBAL innodb_limit_optimistic_insert_debug = 0;
50 ROLLBACK;
51 # Test start
52 connection purge_control;
53 START TRANSACTION WITH CONSISTENT SNAPSHOT;
54 connection con2;
55 DELETE FROM t1 WHERE a00 = 'bii';
56 COMMIT;
57 BEGIN;
58 INSERT INTO t1 SET a00 = 'bii';
59 SET DEBUG_SYNC = 'rollback_undo_pk SIGNAL roll1_wait WAIT_FOR roll2';
60 SET DEBUG_SYNC = 'rollback_purge_clust SIGNAL rollback_waiting WAIT_FOR resume';
61 ROLLBACK;
62 connection purge_control;
63 SET DEBUG_SYNC = 'now WAIT_FOR roll1_wait';
64 COMMIT;
65 SET DEBUG_SYNC = 'now SIGNAL roll2';
66 connect con1,localhost,root,,;
67 SET DEBUG_SYNC = 'now WAIT_FOR rollback_waiting TIMEOUT 1';
68 SET DEBUG_SYNC = 'rw_s_lock_waiting SIGNAL lockwait1';
69 SELECT a00 FROM t1 WHERE a00 = 'bii';
70 connection default;
71 SET DEBUG_SYNC = 'now WAIT_FOR lockwait1 TIMEOUT 1';
72 SET DEBUG_SYNC = 'now SIGNAL resume';
73 connection con1;
74 a00
75 connection con2;
76 connection default;
77 ANALYZE TABLE t1;
78 Table Op Msg_type Msg_text
79 test.t1 analyze status Engine-independent statistics collected
80 test.t1 analyze status OK
81 SELECT CLUST_INDEX_SIZE FROM information_schema.INNODB_SYS_TABLESTATS WHERE NAME = 'test/t1';
82 CLUST_INDEX_SIZE
83 1792
84 DELETE FROM t1 WHERE a00 = 'dpn';
85 COMMIT;
86 INSERT INTO t1 SET a00 = 'dpn';
87 ROLLBACK;
88 ALTER TABLE t1 COMMENT='MERGE_THRESHOLD=35';
89 connection purge_control;
90 START TRANSACTION WITH CONSISTENT SNAPSHOT;
91 connection con2;
92 DELETE FROM t1 WHERE a00 = 'cnd';
93 COMMIT;
94 BEGIN;
95 INSERT INTO t1 SET a00 = 'cnd';
96 SET DEBUG_SYNC = 'rollback_undo_pk SIGNAL roll1_wait WAIT_FOR roll2';
97 SET DEBUG_SYNC = 'rollback_purge_clust SIGNAL rollback_waiting WAIT_FOR resume EXECUTE 2';
98 ROLLBACK;
99 connection purge_control;
100 SET DEBUG_SYNC = 'now WAIT_FOR roll1_wait';
101 START TRANSACTION WITH CONSISTENT SNAPSHOT;
102 SET DEBUG_SYNC = 'now SIGNAL roll2';
103 connection con1;
104 SET DEBUG_SYNC = 'now WAIT_FOR rollback_waiting TIMEOUT 1';
105 SET DEBUG_SYNC = 'now SIGNAL resume';
106 SET DEBUG_SYNC = 'now WAIT_FOR rollback_waiting TIMEOUT 1';
107 disconnect purge_control;
108 connection default;
109 SET DEBUG_SYNC = 'now SIGNAL resume';
110 disconnect con1;
111 connection con2;
112 disconnect con2;
113 connection default;
114 ANALYZE TABLE t1;
115 Table Op Msg_type Msg_text
116 test.t1 analyze status Engine-independent statistics collected
117 test.t1 analyze status OK
118 SELECT CLUST_INDEX_SIZE FROM information_schema.INNODB_SYS_TABLESTATS WHERE NAME = 'test/t1';
119 CLUST_INDEX_SIZE
120 1792
121 SET DEBUG_SYNC = 'RESET';
122 DROP TABLE t1;