OLD | NEW |
| (Empty) |
1 /* | |
2 ** This script is called from crash01.test and config02.test and perhaps other | |
3 ** script. After the database file has been set up, make a big rollback | |
4 ** journal in client 1, then crash client 1. | |
5 ** Then in the other clients, do an integrity check. | |
6 */ | |
7 --task 1 leave-hot-journal | |
8 --sleep 5 | |
9 --finish | |
10 PRAGMA cache_size=10; | |
11 BEGIN; | |
12 UPDATE t1 SET b=randomblob(20000); | |
13 UPDATE t2 SET b=randomblob(20000); | |
14 UPDATE t3 SET b=randomblob(20000); | |
15 UPDATE t4 SET b=randomblob(20000); | |
16 UPDATE t5 SET b=randomblob(20000); | |
17 UPDATE t1 SET b=NULL; | |
18 UPDATE t2 SET b=NULL; | |
19 UPDATE t3 SET b=NULL; | |
20 UPDATE t4 SET b=NULL; | |
21 UPDATE t5 SET b=NULL; | |
22 --print Task one crashing an incomplete transaction | |
23 --exit 1 | |
24 --end | |
25 --task 2 integrity_check-2 | |
26 SELECT count(*) FROM t1; | |
27 --match 64 | |
28 --sleep 100 | |
29 PRAGMA integrity_check(10); | |
30 --match ok | |
31 --end | |
32 --task 3 integrity_check-3 | |
33 SELECT count(*) FROM t1; | |
34 --match 64 | |
35 --sleep 100 | |
36 PRAGMA integrity_check(10); | |
37 --match ok | |
38 --end | |
39 --task 4 integrity_check-4 | |
40 SELECT count(*) FROM t1; | |
41 --match 64 | |
42 --sleep 100 | |
43 PRAGMA integrity_check(10); | |
44 --match ok | |
45 --end | |
46 --task 5 integrity_check-5 | |
47 SELECT count(*) FROM t1; | |
48 --match 64 | |
49 --sleep 100 | |
50 PRAGMA integrity_check(10); | |
51 --match ok | |
52 --end | |
53 --wait all | |
OLD | NEW |