16adab7a1Sdrh/* 26adab7a1Sdrh** This script is called from crash01.test and config02.test and perhaps other 36adab7a1Sdrh** script. After the database file has been set up, make a big rollback 46adab7a1Sdrh** journal in client 1, then crash client 1. 56adab7a1Sdrh** Then in the other clients, do an integrity check. 66adab7a1Sdrh*/ 7*4c5298f3Sdrh--task 1 leave-hot-journal 86adab7a1Sdrh --sleep 5 96adab7a1Sdrh --finish 106adab7a1Sdrh PRAGMA cache_size=10; 116adab7a1Sdrh BEGIN; 126adab7a1Sdrh UPDATE t1 SET b=randomblob(20000); 136adab7a1Sdrh UPDATE t2 SET b=randomblob(20000); 146adab7a1Sdrh UPDATE t3 SET b=randomblob(20000); 156adab7a1Sdrh UPDATE t4 SET b=randomblob(20000); 166adab7a1Sdrh UPDATE t5 SET b=randomblob(20000); 176adab7a1Sdrh UPDATE t1 SET b=NULL; 186adab7a1Sdrh UPDATE t2 SET b=NULL; 196adab7a1Sdrh UPDATE t3 SET b=NULL; 206adab7a1Sdrh UPDATE t4 SET b=NULL; 216adab7a1Sdrh UPDATE t5 SET b=NULL; 226adab7a1Sdrh --print Task one crashing an incomplete transaction 236adab7a1Sdrh --exit 1 246adab7a1Sdrh--end 25*4c5298f3Sdrh--task 2 integrity_check-2 266adab7a1Sdrh SELECT count(*) FROM t1; 276adab7a1Sdrh --match 64 286adab7a1Sdrh --sleep 100 297de96f7fSdrh PRAGMA integrity_check(10); 306adab7a1Sdrh --match ok 316adab7a1Sdrh--end 32*4c5298f3Sdrh--task 3 integrity_check-3 336adab7a1Sdrh SELECT count(*) FROM t1; 346adab7a1Sdrh --match 64 356adab7a1Sdrh --sleep 100 367de96f7fSdrh PRAGMA integrity_check(10); 376adab7a1Sdrh --match ok 386adab7a1Sdrh--end 39*4c5298f3Sdrh--task 4 integrity_check-4 406adab7a1Sdrh SELECT count(*) FROM t1; 416adab7a1Sdrh --match 64 426adab7a1Sdrh --sleep 100 437de96f7fSdrh PRAGMA integrity_check(10); 446adab7a1Sdrh --match ok 456adab7a1Sdrh--end 46*4c5298f3Sdrh--task 5 integrity_check-5 476adab7a1Sdrh SELECT count(*) FROM t1; 486adab7a1Sdrh --match 64 496adab7a1Sdrh --sleep 100 507de96f7fSdrh PRAGMA integrity_check(10); 516adab7a1Sdrh --match ok 526adab7a1Sdrh--end 536adab7a1Sdrh--wait all 54