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 SET GLOBAL innodb_flush_log_at_trx_commit = 0;
4 CREATE TABLE t1 (
5 a00 CHAR(255) NOT NULL DEFAULT 'a',
6 a01 CHAR(255) NOT NULL DEFAULT 'a',
7 a02 CHAR(255) NOT NULL DEFAULT 'a',
8 b INT NOT NULL DEFAULT 0,
9 CONSTRAINT pkey PRIMARY KEY(a00, a01, a02)
10 ) charset latin1 ENGINE = InnoDB COMMENT='MERGE_THRESHOLD=45';
11 SET GLOBAL innodb_limit_optimistic_insert_debug = 3;
12 DROP PROCEDURE IF EXISTS data_load_t1;
13 Warnings:
14 Note 1305 PROCEDURE test.data_load_t1 does not exist
15 CREATE PROCEDURE data_load_t1()
16 BEGIN
17 DECLARE c1 INT DEFAULT 97;
18 DECLARE c2 INT DEFAULT 97;
19 DECLARE c3 INT DEFAULT 97;
20 WHILE c1 < 102 DO
21 WHILE c2 < 123 DO
22 WHILE c3 < 123 DO
23 INSERT INTO t1 (a00) VALUES (CHAR(c1,c2,c3));
24 SET c3 = c3 + 1;
25 END WHILE;
26 SET c3 = 97;
27 SET c2 = c2 + 1;
28 END WHILE;
29 SET c2 = 97;
30 SET c1 = c1 + 1;
31 END WHILE;
32 END |
33 call data_load_t1();
34 DROP PROCEDURE data_load_t1;
35 ANALYZE TABLE t1;
36 Table Op Msg_type Msg_text
37 test.t1 analyze status OK
38 SELECT CLUST_INDEX_SIZE FROM information_schema.INNODB_TABLESTATS WHERE NAME = 'test/t1';
39 CLUST_INDEX_SIZE
40 1856
41 SET GLOBAL innodb_limit_optimistic_insert_debug = 0;
42 DELETE FROM t1 WHERE a00 = 'cnm';
43 # Test start
44 SET DEBUG_SYNC = 'RESET';
45 SET GLOBAL innodb_purge_stop_now = ON;
46 SET GLOBAL DEBUG = "+d,pessimistic_row_purge_clust";
47 DELETE FROM t1 WHERE a00 = 'bii';
48 SET GLOBAL innodb_purge_run_now = ON;
49 SET DEBUG_SYNC = "now WAIT_FOR pessimistic_row_purge_clust_pause";
50 SET DEBUG_SYNC = 'rw_s_lock_waiting SIGNAL lockwait1';
51 SELECT a00 FROM t1 WHERE a00 = 'bcc';
52 SET DEBUG_SYNC = 'now WAIT_FOR lockwait1';
53 SET GLOBAL DEBUG = "-d,pessimistic_row_purge_clust";
54 SET DEBUG_SYNC = "now SIGNAL pessimistic_row_purge_clust_continue";
55 a00
56 bcc
57 ANALYZE TABLE t1;
58 Table Op Msg_type Msg_text
59 test.t1 analyze status OK
60 SELECT CLUST_INDEX_SIZE FROM information_schema.INNODB_TABLESTATS WHERE NAME = 'test/t1';
61 CLUST_INDEX_SIZE
62 1856
63 SET DEBUG_SYNC = 'RESET';
64 DELETE FROM t1 WHERE a00 = 'dpn';
65 ALTER TABLE t1 COMMENT='MERGE_THRESHOLD=35';
66 SET GLOBAL innodb_purge_stop_now = ON;
67 SET GLOBAL DEBUG = "+d,pessimistic_row_purge_clust";
68 DELETE FROM t1 WHERE a00 = 'cnd';
69 SET GLOBAL innodb_purge_run_now = ON;
70 SET DEBUG_SYNC = "now WAIT_FOR pessimistic_row_purge_clust_pause";
71 SELECT a00 FROM t1 WHERE a00 = 'ass';
72 a00
73 ass
74 SELECT a00 FROM t1 WHERE a00 = 'dyx';
75 a00
76 dyx
77 SET DEBUG_SYNC = 'rw_s_lock_waiting SIGNAL lockwait1';
78 SELECT a00 FROM t1 WHERE a00 = 'ast';
79 SET DEBUG_SYNC = 'rw_s_lock_waiting SIGNAL lockwait2';
80 SELECT a00 FROM t1 WHERE a00 = 'dyw';
81 SET DEBUG_SYNC = 'now WAIT_FOR lockwait1';
82 SET DEBUG_SYNC = 'now WAIT_FOR lockwait2';
83 SET GLOBAL DEBUG = "-d,pessimistic_row_purge_clust";
84 SET DEBUG_SYNC = "now SIGNAL pessimistic_row_purge_clust_continue";
85 a00
86 ast
87 a00
88 dyw
89 ANALYZE TABLE t1;
90 Table Op Msg_type Msg_text
91 test.t1 analyze status OK
92 SELECT CLUST_INDEX_SIZE FROM information_schema.INNODB_TABLESTATS WHERE NAME = 'test/t1';
93 CLUST_INDEX_SIZE
94 1856
95 SET DEBUG_SYNC = 'RESET';
96 DROP TABLE t1;