| 1 |
# 2024 Feb 21 |
| 2 |
# |
| 3 |
# The author disclaims copyright to this source code. In place of |
| 4 |
# a legal notice, here is a blessing: |
| 5 |
# |
| 6 |
# May you do good and not evil. |
| 7 |
# May you find forgiveness for yourself and forgive others. |
| 8 |
# May you share freely, never taking more than you give. |
| 9 |
# |
| 10 |
#*********************************************************************** |
| 11 |
# |
| 12 |
# The focus of this file is testing the intck extensions response |
| 13 |
# to corruption at the b-tree level. |
| 14 |
# |
| 15 |
|
| 16 |
source [file join [file dirname [info script]] intck_common.tcl] |
| 17 |
set testprefix intckcorrupt |
| 18 |
return_if_no_intck |
| 19 |
|
| 20 |
#------------------------------------------------------------------------- |
| 21 |
reset_db |
| 22 |
do_test 1.0 { |
| 23 |
sqlite3 db {} |
| 24 |
db deserialize [decode_hexdb { |
| 25 |
| size 356352 pagesize 4096 filename crash-acaae0347204ae.db |
| 26 |
| page 1 offset 0 |
| 27 |
| 0: 53 51 4c 69 74 65 20 66 6f 72 6d 61 74 20 33 00 SQLite format 3. |
| 28 |
| 16: 10 00 01 01 00 40 20 20 00 00 00 00 d0 00 00 00 .....@ ........ |
| 29 |
| 32: 40 00 ea 00 00 00 00 00 00 40 00 00 00 40 00 00 @........@...@.. |
| 30 |
| 96: 00 00 00 00 0d 00 00 00 04 0e 9c 00 0f ad 0f 4f ...............O |
| 31 |
| 112: 0e fc 0e 9c 00 00 00 00 00 00 00 00 00 00 00 00 ................ |
| 32 |
| 3728: 00 00 00 00 00 00 00 00 00 00 00 00 5e 04 07 17 ............^... |
| 33 |
| 3744: 1f 1f 01 81 0b 74 61 62 6c 65 74 31 5f 70 61 72 .....tablet1_par |
| 34 |
| 3760: 65 6e 74 74 31 5f 70 61 72 65 6e 74 04 43 52 45 entt1_parent.CRE |
| 35 |
| 3776: 41 54 45 20 54 41 42 4c 45 20 22 74 31 5f 70 61 ATE TABLE .t1_pa |
| 36 |
| 3792: 72 65 6e 74 22 28 6e 6f 64 65 6e 6f 20 49 4e 54 rent.(nodeno INT |
| 37 |
| 3808: 45 47 45 52 20 50 52 49 4d 41 52 59 20 4b 45 59 EGER PRIMARY KEY |
| 38 |
| 3824: 2c 70 61 72 65 6e 74 6e 6f 64 65 29 51 03 06 17 ,parentnode)Q... |
| 39 |
| 3840: 1b 1b 01 7b 74 61 62 6c 65 74 31 5f 6e 6f 64 65 ....tablet1_node |
| 40 |
| 3856: 74 31 5f 6e 6f 64 65 03 43 52 45 41 54 45 20 54 t1_node.CREATE T |
| 41 |
| 3872: 41 42 4c 45 20 22 74 31 5f 6e 6f 64 65 22 28 6e ABLE .t1_node.(n |
| 42 |
| 3888: 6f 64 65 6e 6f 20 49 4e 54 45 47 45 52 20 50 52 odeno INTEGER PR |
| 43 |
| 3904: 49 4d 41 52 59 20 4b 45 59 2c 64 61 74 61 29 5c IMARY KEY,data). |
| 44 |
| 3920: 02 07 17 1d 1d 01 81 0b 74 61 62 6c 65 74 31 5f ........tablet1_ |
| 45 |
| 3936: 72 6f 77 69 64 74 31 5f 72 6f 77 69 64 02 43 52 rowidt1_rowid.CR |
| 46 |
| 3952: 45 41 54 45 20 54 41 42 4c 45 20 22 74 31 5f 72 EATE TABLE .t1_r |
| 47 |
| 3968: 6f 77 69 64 22 28 72 6f 77 69 64 20 49 4e 54 45 owid.(rowid INTE |
| 48 |
| 3984: 47 45 52 20 50 52 49 4d 41 52 59 20 4b 45 59 2c GER PRIMARY KEY, |
| 49 |
| 4000: 6e 6f 64 65 6e 6f 2c 61 30 2c 61 31 29 51 01 07 nodeno,a0,a1)Q.. |
| 50 |
| 4016: 17 11 11 08 81 0f 74 61 62 6c 65 74 31 74 31 43 ......tablet1t1C |
| 51 |
| 4032: 52 45 41 54 45 20 56 49 52 54 55 41 4c 20 54 41 REATE VIRTUAL TA |
| 52 |
| 4048: 42 4c 45 20 74 31 20 55 53 49 4e 47 20 72 74 72 BLE t1 USING rtr |
| 53 |
| 4064: 65 65 28 69 64 2c 78 30 20 50 52 49 4d 41 52 59 ee(id,x0 PRIMARY |
| 54 |
| 4080: 20 4b 45 59 2c 70 61 72 65 6e 74 6e 6f 64 65 29 KEY,parentnode) |
| 55 |
| page 2 offset 4096 |
| 56 |
| 0: 51 03 06 17 1b 1b 01 7b 74 61 62 6c 65 74 31 5f Q.......tablet1_ |
| 57 |
| 16: 6e 6f 64 65 74 31 5f 6e 6f 64 65 03 43 52 45 41 nodet1_node.CREA |
| 58 |
| 32: 54 45 20 54 41 42 4c 45 20 22 74 31 5f 6e 6f 64 TE TABLE .t1_nod |
| 59 |
| 48: 65 22 28 6e 6f 64 65 6e 6f 20 49 4e 54 45 47 45 e.(nodeno INTEGE |
| 60 |
| 64: 52 20 50 52 49 4d 41 52 59 20 4b 45 59 2c 64 61 R PRIMARY KEY,da |
| 61 |
| 80: 74 61 29 5c 02 07 17 1d 1d 01 81 0b 74 61 62 6c ta).........tabl |
| 62 |
| 96: 65 74 31 5f 72 6f 77 69 64 74 31 5f 72 6f 77 69 et1_rowidt1_rowi |
| 63 |
| 112: 64 02 43 52 45 41 54 45 20 54 41 42 4c 45 00 00 d.CREATE TABLE.. |
| 64 |
| 128: 01 0a 02 00 00 00 01 0e 0d 00 00 00 00 24 0e 0d .............$.. |
| 65 |
| 144: 0c 1a 06 85 50 46 60 27 70 08 00 00 00 00 00 00 ....PF`'p....... |
| 66 |
| 3824: 00 00 00 00 00 00 00 0d 0e 05 00 09 1d 00 74 6f ..............to |
| 67 |
| 3840: 79 20 68 61 6c 66 10 0d 05 00 09 23 00 62 6f 74 y half.....#.bot |
| 68 |
| 3856: 74 6f 6d 20 68 61 6c 66 0f 0c 05 00 09 21 00 72 tom half.....!.r |
| 69 |
| 3872: 69 67 68 74 20 68 61 6c 66 0e 0b 05 00 09 1f 00 ight half....... |
| 70 |
| 3888: 6c 65 66 74 20 43 15 f6 e6 f6 46 50 34 35 24 54 left C....FP45$T |
| 71 |
| 3904: 15 44 52 05 44 14 24 c4 52 02 27 43 15 f6 e6 f6 .DR.D.$.R.'C.... |
| 72 |
| 3920: 46 52 22 8e 6f 64 65 6e 6f 20 49 4e 54 45 47 45 FR..odeno INTEGE |
| 73 |
| 3936: 52 20 50 52 49 4d 41 52 59 20 4b 45 59 2c 64 61 R PRIMARY KEY,da |
| 74 |
| 3952: 74 61 29 5c 02 07 17 1d 1d 01 81 0b 74 61 62 6c ta).........tabl |
| 75 |
| 3968: 65 74 31 5f 72 6f 74 74 6f 6d 20 65 64 67 65 0f et1_rottom edge. |
| 76 |
| 3984: 07 05 00 09 21 00 72 69 67 68 74 20 65 64 67 65 ....!.right edge |
| 77 |
| 4000: 0e 06 05 00 09 1f 00 6c 65 66 74 20 65 64 67 65 .......left edge |
| 78 |
| 4016: 0b 05 05 00 09 19 00 63 65 6e 74 65 72 17 04 05 .......center... |
| 79 |
| 4032: 00 09 31 00 75 70 70 65 72 2d 72 69 67 68 74 20 ..1.upper-right |
| 80 |
| 4048: 63 6f 72 6e 65 72 17 03 05 00 09 31 00 6c 6f 77 corner.....1.low |
| 81 |
| 4064: 65 72 2d 72 69 67 68 74 20 63 6f 72 6e 65 72 16 er-right corner. |
| 82 |
| 4080: 02 05 00 09 2f 00 75 70 70 65 72 2d 6c 65 66 74 ..../.upper-left |
| 83 |
| page 3 offset 8192 |
| 84 |
| 0: 20 63 6f 72 6e 65 72 16 01 05 00 09 2f 01 8c 6f corner...../..o |
| 85 |
| 16: 77 65 72 2d 6c 53 51 4c 69 74 65 20 66 6f 72 6d wer-lSQLite form |
| 86 |
| 32: 61 74 20 33 00 10 00 01 01 00 40 20 20 00 00 00 at 3......@ ... |
| 87 |
| 48: 00 00 00 00 2f 00 00 0d eb 13 00 00 00 03 00 00 ..../........... |
| 88 |
| 64: 00 04 00 00 00 00 00 00 00 06 00 00 00 01 00 00 ................ |
| 89 |
| 80: 00 00 00 00 00 01 00 00 00 00 00 00 00 00 00 00 ................ |
| 90 |
| page 6 offset 20480 |
| 91 |
| 128: 00 00 00 00 00 00 00 00 97 3d 04 ae 7c 01 00 00 .........=..|... |
| 92 |
| 624: 00 00 00 00 00 00 21 97 3d 04 ae 7c 01 00 00 00 ......!.=..|.... |
| 93 |
| 1120: 00 00 00 00 00 20 97 3d 04 ae 7c 01 00 00 00 00 ..... .=..|..... |
| 94 |
| 1616: 00 00 00 00 1f 97 3d 04 ae 7c 01 00 00 00 00 00 ......=..|...... |
| 95 |
| 2112: 00 00 00 1e 97 3d 04 ae 7c 01 00 00 00 00 00 00 .....=..|....... |
| 96 |
| 2608: 00 00 1d 97 d3 d0 4a e7 c0 00 00 00 00 00 00 00 ......J......... |
| 97 |
| 3088: 00 00 00 00 00 00 00 00 00 00 00 00 01 f3 00 00 ................ |
| 98 |
| 3600: 23 97 3d 04 ae 7c 01 00 00 00 00 00 00 00 00 00 #.=..|.......... |
| 99 |
| 4080: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 26 ...............& |
| 100 |
| page 8 offset 28672 |
| 101 |
| 0: 0d 00 00 00 01 04 30 00 04 30 00 00 00 00 00 00 ......0..0...... |
| 102 |
| 1072: 97 4d 1e 14 00 ae 7c 00 00 00 00 00 00 00 00 00 .M....|......... |
| 103 |
| 1088: 00 00 00 00 00 00 01 00 00 00 00 00 00 00 00 00 ................ |
| 104 |
| 4080: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 03 ................ |
| 105 |
| page 10 offset 36864 |
| 106 |
| 0: 0d 00 00 00 01 04 30 00 04 30 00 00 00 00 00 00 ......0..0...... |
| 107 |
| 1072: 9a ee c1 80 fd 78 1f ce 1b ae eb b4 00 00 00 00 .....x.......... |
| 108 |
| 1088: 13 20 ff 20 00 70 00 00 00 60 50 00 00 00 11 e0 . . .p...`P..... |
| 109 |
| 1104: 00 00 00 70 00 00 00 60 50 05 35 14 c6 97 46 52 ...p...`P.5...FR |
| 110 |
| 1120: 06 66 f7 26 d6 17 42 03 30 01 00 00 10 10 04 02 .f.&..B.0....... |
| 111 |
| 1136: 02 00 00 00 00 00 00 00 00 40 00 00 00 00 00 00 .........@...... |
| 112 |
| 1152: 00 00 00 00 00 40 00 00 00 40 00 00 00 00 00 00 .....@...@...... |
| 113 |
| 4080: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 05 ................ |
| 114 |
| page 12 offset 45056 |
| 115 |
| 0: 0d 00 00 00 01 04 30 00 04 30 e1 b4 30 97 4d 46 ......0..0..0.MF |
| 116 |
| 16: 14 00 ae 7c 00 00 00 00 00 00 00 03 00 00 43 00 ...|..........C. |
| 117 |
| page 47 offset 188416 |
| 118 |
| 2512: 00 00 00 00 00 00 00 00 be 00 00 00 00 00 00 00 ................ |
| 119 |
| page 87 offset 352256 |
| 120 |
| 2512: 00 00 00 00 00 00 00 00 aa 00 00 00 00 00 00 00 ................ |
| 121 |
| end crash-acaae0347204ae.db |
| 122 |
}]} {} |
| 123 |
|
| 124 |
do_intck_test 1.1 { |
| 125 |
{corruption found while reading database schema} |
| 126 |
} |
| 127 |
|
| 128 |
#------------------------------------------------------------------------- |
| 129 |
reset_db |
| 130 |
do_test 2.0 { |
| 131 |
sqlite3 db {} |
| 132 |
db deserialize [decode_hexdb { |
| 133 |
| size 28672 pagesize 4096 filename crash-3afa1ca9e9c1bd.db |
| 134 |
| page 1 offset 0 |
| 135 |
| 0: 53 51 4c 69 74 65 20 66 6f 72 6d 61 74 20 33 00 SQLite format 3. |
| 136 |
| 16: 10 00 01 01 00 40 20 20 00 00 00 00 00 00 00 07 .....@ ........ |
| 137 |
| 32: 00 00 00 00 00 00 00 00 00 00 00 06 00 00 00 04 ................ |
| 138 |
| 48: 00 00 00 00 00 00 00 00 00 00 00 01 00 00 00 00 ................ |
| 139 |
| 96: 00 00 00 00 0d 00 00 00 06 0e 88 00 0f b8 0f 6d ...............m |
| 140 |
| 112: 0f 3a 0f 0b 0e d5 0e 88 01 00 00 00 00 00 00 00 .:.............. |
| 141 |
| 3712: 00 00 00 00 00 00 00 00 4b 06 06 17 25 25 01 5b ........K...%%.[ |
| 142 |
| 3728: 74 61 62 6c 65 73 71 6c 69 74 65 5f 73 74 61 74 tablesqlite_stat |
| 143 |
| 3744: 31 73 71 6c 69 74 65 5f 73 74 61 74 31 07 43 52 1sqlite_stat1.CR |
| 144 |
| 3760: 45 41 54 45 20 54 41 42 4c 45 20 73 71 6c 69 74 EATE TABLE sqlit |
| 145 |
| 3776: 65 5f 73 74 61 74 31 28 74 62 6c 2c 69 64 78 2c e_stat1(tbl,idx, |
| 146 |
| 3792: 73 74 61 74 29 34 05 06 17 13 11 01 53 69 6e 64 stat)4......Sind |
| 147 |
| 3808: 65 78 63 31 63 63 31 06 43 52 45 41 54 45 20 55 exc1cc1.CREATE U |
| 148 |
| 3824: 4e 49 51 55 45 20 49 4e 44 45 58 20 63 31 63 20 NIQUE INDEX c1c |
| 149 |
| 3840: 4f 4e 20 63 31 28 63 2c 20 62 29 2d 04 06 17 13 ON c1(c, b)-.... |
| 150 |
| 3856: 11 01 45 69 6e 64 65 78 63 31 64 63 31 05 43 52 ..Eindexc1dc1.CR |
| 151 |
| 3872: 45 41 54 45 20 49 4e 44 45 58 20 63 31 64 20 4f EATE INDEX c1d O |
| 152 |
| 3888: 4e 20 63 31 28 64 2c 20 62 29 31 03 06 17 13 11 N c1(d, b)1..... |
| 153 |
| 3904: 01 4d 69 6e 64 65 78 62 31 63 62 31 05 43 52 45 .Mindexb1cb1.CRE |
| 154 |
| 3920: 41 54 45 20 55 4e 49 51 55 45 20 49 4e 44 45 58 ATE UNIQUE INDEX |
| 155 |
| 3936: 20 62 31 63 20 4f 4e 20 62 31 28 63 29 49 02 06 b1c ON b1(c)I.. |
| 156 |
| 3952: 17 11 11 0f 7f 74 61 62 6c 65 63 31 63 31 03 43 .....tablec1c1.C |
| 157 |
| 3968: 52 45 41 54 45 20 54 41 42 4c 45 20 63 31 28 61 REATE TABLE c1(a |
| 158 |
| 3984: 20 49 4e 54 20 50 52 49 4d 41 52 59 20 4b 45 59 INT PRIMARY KEY |
| 159 |
| 4000: 2c 20 62 2c 20 63 2c 20 64 29 20 57 49 54 48 4f , b, c, d) WITHO |
| 160 |
| 4016: 55 54 20 52 4f 57 49 44 46 01 06 17 11 11 01 79 UT ROWIDF......y |
| 161 |
| 4032: 74 61 62 6c 65 62 31 62 31 02 43 52 45 41 54 45 tableb1b1.CREATE |
| 162 |
| 4048: 20 54 41 42 4c 45 20 62 31 28 61 20 49 4e 54 20 TABLE b1(a INT |
| 163 |
| 4064: 50 52 49 4d 41 52 59 20 4b 45 59 2c 20 62 2c 20 PRIMARY KEY, b, |
| 164 |
| 4080: 63 29 20 57 49 54 48 4f 55 54 20 52 4f 57 49 44 c) WITHOUT ROWID |
| 165 |
| page 2 offset 4096 |
| 166 |
| 0: 0a 00 00 00 07 0f ca 00 0f fa 0f f2 0f ea 0f e2 ................ |
| 167 |
| 16: 0f da 00 00 00 01 00 00 00 00 00 00 00 00 00 00 ................ |
| 168 |
| 4032: 00 00 00 00 00 00 00 00 00 00 07 04 01 0f 01 06 ................ |
| 169 |
| 4048: 67 07 07 04 01 0f 01 06 66 06 07 04 01 0f 01 05 g.......f....... |
| 170 |
| 4064: 65 05 07 04 01 0f 01 04 64 04 07 04 01 0f 01 03 e.......d....... |
| 171 |
| 4080: 63 03 07 04 01 0f 01 02 62 0f 05 04 09 0f 09 61 c.......b......a |
| 172 |
| page 3 offset 8192 |
| 173 |
| 0: 0a 00 00 00 07 0f bd 00 0f f9 0f ef 0f e5 0f db ................ |
| 174 |
| 16: 0f d1 0f c7 0f bd 00 00 00 00 01 00 00 00 00 00 ................ |
| 175 |
| 4016: 00 00 00 00 00 00 00 00 00 00 00 00 00 09 05 01 ................ |
| 176 |
| 4032: 0f 01 01 07 61 07 07 09 05 01 0f 01 01 06 61 06 ....a.........a. |
| 177 |
| 4048: 06 09 05 01 0f 01 01 05 61 05 05 09 05 01 0f 01 ........a....... |
| 178 |
| 4064: 01 04 61 04 04 09 05 01 0f 01 01 03 61 03 03 09 ..a.........a... |
| 179 |
| 4080: 05 01 0f 01 01 02 61 0f 02 06 05 09 0f 09 09 61 ......a........a |
| 180 |
| page 4 offset 12288 |
| 181 |
| 0: 0a 00 00 00 07 0f d8 00 0f fc 0f f0 0f ea 0f e4 ................ |
| 182 |
| 16: 0f de 0f d8 0f f6 00 00 00 00 00 00 00 00 00 00 ................ |
| 183 |
| 4048: 00 00 00 00 00 00 00 00 05 03 01 01 07 07 05 03 ................ |
| 184 |
| 4064: 01 01 06 06 05 03 01 01 05 05 05 03 01 01 04 04 ................ |
| 185 |
| 4080: 05 03 01 01 03 03 05 03 01 01 0f 02 03 03 09 09 ................ |
| 186 |
| page 5 offset 16384 |
| 187 |
| 0: 0a 00 00 00 07 0f ca 00 0f fa 0f f2 0f ea 0f 00 ................ |
| 188 |
| 4032: 00 00 00 00 00 00 00 00 00 00 07 04 01 0f 01 07 ................ |
| 189 |
| 4048: 61 07 07 04 01 0f 01 06 61 06 07 04 01 0f 01 05 a.......a....... |
| 190 |
| 4064: 61 05 07 04 01 1f 01 04 61 04 07 04 01 0f 01 03 a.......a....... |
| 191 |
| 4080: 61 03 07 04 01 0f 01 02 61 02 05 04 09 0f 09 61 a.......a......a |
| 192 |
| page 6 offset 20480 |
| 193 |
| 0: 0a 00 00 00 07 0f ca 00 0f fa 0f ea 0f e2 00 00 ................ |
| 194 |
| 4032: 00 00 00 00 00 00 00 00 00 00 07 04 01 0f 01 07 ................ |
| 195 |
| 4048: 61 07 07 04 01 0f 01 06 61 06 07 04 01 0f 01 05 a.......a....... |
| 196 |
| 4064: 61 05 07 04 01 0f 01 04 61 04 07 04 01 0f 01 03 a.......a....... |
| 197 |
| 4080: 61 03 07 04 01 0f 01 0f 61 02 05 04 09 0f 09 61 a.......a......a |
| 198 |
| page 7 offset 24576 |
| 199 |
| 0: 0d 00 00 00 05 0f 1c 00 0f f0 0f e0 0f d3 0f c5 ................ |
| 200 |
| 16: 0f b8 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................ |
| 201 |
| 4016: 00 00 00 00 00 00 00 00 0b 05 04 11 11 13 62 31 ..............b1 |
| 202 |
| 4032: 62 31 37 20 31 0c 04 04 11 13 13 62 31 62 31 63 b17 1......b1b1c |
| 203 |
| 4048: 37 20 31 0b 03 04 11 11 13 63 31 63 31 37 20 31 7 1......c1c17 1 |
| 204 |
| 4064: 0e 02 04 11 13 07 63 31 63 31 64 37 20 31 20 31 ......c1c1d7 1 1 |
| 205 |
| 4080: 0e 01 04 11 13 17 63 31 63 31 63 37 20 31 00 00 ......c1c1c7 1.. |
| 206 |
| end crash-3afa1ca9e9c1bd.db |
| 207 |
}]} {} |
| 208 |
|
| 209 |
do_intck_test 2.1 { |
| 210 |
{corruption found while reading database schema} |
| 211 |
} |
| 212 |
|
| 213 |
#------------------------------------------------------------------------- |
| 214 |
reset_db |
| 215 |
do_execsql_test 3.0 { |
| 216 |
PRAGMA page_size = 1024; |
| 217 |
CREATE TABLE t1(a, b); |
| 218 |
CREATE INDEX i1 ON t1(a); |
| 219 |
INSERT INTO t1 VALUES(1, 1), (2, 2), (3, 3); |
| 220 |
} |
| 221 |
|
| 222 |
do_test 3.1 { |
| 223 |
set pgno [db one {SELECT rootpage FROM sqlite_schema WHERE name='t1'}] |
| 224 |
db close |
| 225 |
hexio_write test.db [expr ($pgno-1)*1024] 0000 |
| 226 |
} {2} |
| 227 |
|
| 228 |
sqlite3 db test.db |
| 229 |
do_intck_test 3.2 { |
| 230 |
{corruption found while scanning database object i1} |
| 231 |
{corruption found while scanning database object t1} |
| 232 |
} |
| 233 |
|
| 234 |
finish_test |
| 235 |
|
| 236 |
|