| 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 |