Debian Codegraph @

mysql-test/suite/innodb_zip/r/innochecksum_3.result

raw
1 # Set the environmental variables
2 call mtr.add_suppression("InnoDB: Unable to read tablespace .* page no .* into the buffer pool after 100 attempts");
3 call mtr.add_suppression("InnoDB: innodb_checksum_algorithm is set to.*");
4 CREATE TABLE tab1 (pk INTEGER NOT NULL PRIMARY KEY,
5 linestring_key GEOMETRY NOT NULL,
6 linestring_nokey GEOMETRY NOT NULL)
7 ENGINE=InnoDB ;
8 INSERT INTO tab1 (pk, linestring_key, linestring_nokey)
9 VALUES (1, ST_GeomFromText('POINT(10 10) '), ST_GeomFromText('POINT(10 10) '));
10 CREATE INDEX linestring_index ON tab1(linestring_nokey(5));
11 ALTER TABLE tab1 ADD KEY (linestring_key(5));
12 # create a compressed table
13 CREATE TABLE tab2(col_1 CHAR (255) ,
14 col_2 VARCHAR (255), col_3 longtext,
15 col_4 longtext,col_5 longtext,
16 col_6 longtext , col_7 int )
17 engine = innodb row_format=compressed key_block_size=4;
18 CREATE INDEX idx1 ON tab2(col_3(10));
19 CREATE INDEX idx2 ON tab2(col_4(10));
20 CREATE INDEX idx3 ON tab2(col_5(10));
21 SET @col_1 = repeat('a', 5);
22 SET @col_2 = repeat('b', 20);
23 SET @col_3 = repeat('c', 100);
24 SET @col_4 = repeat('d', 100);
25 SET @col_5 = repeat('e', 100);
26 SET @col_6 = repeat('f', 100);
27 INSERT INTO tab2(col_1,col_2,col_3,col_4,col_5,col_6,col_7)
28 VALUES (@col_1,@col_2,@col_3,@col_4,@cl_5,@col_6,5);
29 INSERT INTO tab2(col_1,col_2,col_3,col_4,col_5,col_6,col_7)
30 VALUES (@col_1,@col_2,@col_3,@col_4,@cl_5,@col_6,4);
31 INSERT INTO tab2(col_1,col_2,col_3,col_4,col_5,col_6,col_7)
32 VALUES (@col_1,@col_2,@col_3,@col_4,@cl_5,@col_6,3);
33 INSERT INTO tab2(col_1,col_2,col_3,col_4,col_5,col_6,col_7)
34 VALUES (@col_1,@col_2,@col_3,@col_4,@cl_5,@col_6,2);
35 INSERT INTO tab2(col_1,col_2,col_3,col_4,col_5,col_6,col_7)
36 VALUES (@col_1,@col_2,@col_3,@col_4,@cl_5,@col_6,1);
37 # stop the server
38 [2]: Check the page type summary with shortform for tab1.ibd
39
40 File::tab#.ibd
41 ================PAGE TYPE SUMMARY==============
42 #PAGE_COUNT PAGE_TYPE
43 ===============================================
44 # Index page
45 # Undo log page
46 # Inode page
47 # Insert buffer free list page
48 # Freshly allocated page
49 # Insert buffer bitmap
50 # System page
51 # Transaction system page
52 # File Space Header
53 # Extent descriptor page
54 # BLOB page
55 # Compressed BLOB page
56 # Page compressed page
57 # Page compressed encrypted page
58 # Other type of page
59
60 ===============================================
61 Additional information:
62 Undo page type: #
63 Undo page state: # active, # cached, # to_purge, # prepared, # other
64 index_id #pages #leaf_pages #recs_per_page #bytes_per_page
65 # # # # #
66 # # # # #
67 # # # # #
68
69 index_id page_data_bytes_histgram(empty,...,oversized)
70 # # # # # # # # # # # # #
71 # # # # # # # # # # # # #
72 # # # # # # # # # # # # #
73 [3]: Check the page type summary with longform for tab1.ibd
74
75 File::tab#.ibd
76 ================PAGE TYPE SUMMARY==============
77 #PAGE_COUNT PAGE_TYPE
78 ===============================================
79 # Index page
80 # Undo log page
81 # Inode page
82 # Insert buffer free list page
83 # Freshly allocated page
84 # Insert buffer bitmap
85 # System page
86 # Transaction system page
87 # File Space Header
88 # Extent descriptor page
89 # BLOB page
90 # Compressed BLOB page
91 # Page compressed page
92 # Page compressed encrypted page
93 # Other type of page
94
95 ===============================================
96 Additional information:
97 Undo page type: #
98 Undo page state: # active, # cached, # to_purge, # prepared, # other
99 index_id #pages #leaf_pages #recs_per_page #bytes_per_page
100 # # # # #
101 # # # # #
102 # # # # #
103
104 index_id page_data_bytes_histgram(empty,...,oversized)
105 # # # # # # # # # # # # #
106 # # # # # # # # # # # # #
107 # # # # # # # # # # # # #
108 [4]: Page type dump for with longform for tab1.ibd
109 # Print the contents stored in dump.txt
110
111
112 Filename::tab#.ibd
113 ==============================================================================
114 PAGE_NO | PAGE_TYPE | EXTRA INFO
115 ==============================================================================
116 #::# | File Space Header | -
117 #::# | Insert Buffer Bitmap | -
118 #::# | Inode page | -
119 #::# | Index page | index id=#, page level=#, No. of records=#, garbage=#, -
120 #::# | Index page | index id=#, page level=#, No. of records=#, garbage=#, -
121 #::# | Index page | index id=#, page level=#, No. of records=#, garbage=#, -
122 #::# | Freshly allocated page | -
123 # Variables used by page type dump for ibdata1
124
125 Variables (--variable-name=value)
126 and boolean options {FALSE|TRUE} Value (after reading options)
127 --------------------------------- ----------------------------------------
128 verbose TRUE
129 count FALSE
130 start-page 0
131 end-page 0
132 page 0
133 no-check FALSE
134 allow-mismatches 0
135 write FALSE
136 page-type-summary FALSE
137 page-type-dump MYSQLTEST_VARDIR/tmp/dump.txt
138 per-page-details FALSE
139 log (No default value)
140 leaf FALSE
141 merge 0
142 skip-freed-pages FALSE
143 tablespace-flags 4294967295
144 [5]: Page type dump for with shortform for tab1.ibd
145
146
147 Filename::tab#.ibd
148 ==============================================================================
149 PAGE_NO | PAGE_TYPE | EXTRA INFO
150 ==============================================================================
151 #::# | File Space Header | -
152 #::# | Insert Buffer Bitmap | -
153 #::# | Inode page | -
154 #::# | Index page | index id=#, page level=#, No. of records=#, garbage=#, -
155 #::# | Index page | index id=#, page level=#, No. of records=#, garbage=#, -
156 #::# | Index page | index id=#, page level=#, No. of records=#, garbage=#, -
157 #::# | Freshly allocated page | -
158 [6]: check the valid lower bound values for option
159 # allow-mismatches,page,start-page,end-page
160 [9]: check the both short and long options "page" and "start-page" when
161 # seek value is larger than file size.
162 FOUND 1 /Error: Unable to seek to necessary offset/ in my_restart.err
163 FOUND 1 /Error: Unable to seek to necessary offset/ in my_restart.err
164 FOUND 1 /Error: Unable to seek to necessary offset/ in my_restart.err
165 FOUND 1 /Error: Unable to seek to necessary offset/ in my_restart.err
166 [34]: check the invalid upper bound values for options, allow-mismatches, end-page, start-page and page.
167 # innochecksum will fail with error code: 1
168 NOT FOUND /Incorrect unsigned integer value: '18446744073709551616'/ in my_restart.err
169 NOT FOUND /Incorrect unsigned integer value: '18446744073709551616'/ in my_restart.err
170 NOT FOUND /Incorrect unsigned integer value: '18446744073709551616'/ in my_restart.err
171 NOT FOUND /Incorrect unsigned integer value: '18446744073709551616'/ in my_restart.err
172 NOT FOUND /Incorrect unsigned integer value: '18446744073709551616'/ in my_restart.err
173 NOT FOUND /Incorrect unsigned integer value: '18446744073709551616'/ in my_restart.err
174 NOT FOUND /Incorrect unsigned integer value: '18446744073709551616'/ in my_restart.err
175 NOT FOUND /Incorrect unsigned integer value: '18446744073709551616'/ in my_restart.err
176 # restart
177 DROP TABLE tab1,tab2;