1# 2010 June 15 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 tests in this file test the pager modules response to various 13# fault conditions (OOM, IO error, disk full etc.). They are similar 14# to those in file pagerfault1.test. 15# 16# More specifically, the tests in this file are those deemed too slow to 17# run as part of pagerfault1.test. 18# 19 20set testdir [file dirname $argv0] 21source $testdir/tester.tcl 22source $testdir/lock_common.tcl 23source $testdir/malloc_common.tcl 24 25if {[permutation] == "inmemory_journal"} { 26 finish_test 27 return 28} 29 30sqlite3_memdebug_vfs_oom_test 0 31 32set a_string_counter 1 33proc a_string {n} { 34 global a_string_counter 35 incr a_string_counter 36 string range [string repeat "${a_string_counter}." $n] 1 $n 37} 38db func a_string a_string 39 40do_test pagerfault2-1-pre1 { 41 faultsim_delete_and_reopen 42 db func a_string a_string 43 execsql { 44 PRAGMA auto_vacuum = 0; 45 PRAGMA journal_mode = DELETE; 46 PRAGMA page_size = 1024; 47 CREATE TABLE t1(a, b); 48 INSERT INTO t1 VALUES(a_string(401), a_string(402)); 49 } 50 for {set ii 0} {$ii < 13} {incr ii} { 51 execsql { INSERT INTO t1 SELECT a_string(401), a_string(402) FROM t1 } 52 } 53 faultsim_save_and_close 54 file size test.db 55} [expr 1024 * 8268] 56 57do_faultsim_test pagerfault2-1 -faults oom-transient -prep { 58 faultsim_restore_and_reopen 59 sqlite3_db_config_lookaside db 0 256 4096 60 execsql { 61 BEGIN; 62 SELECT * FROM t1; 63 INSERT INTO t1 VALUES(5, 6); 64 SAVEPOINT abc; 65 UPDATE t1 SET a = a||'x' WHERE rowid<3700; 66 } 67} -body { 68 execsql { UPDATE t1 SET a = a||'x' WHERE rowid>=3700 AND rowid<=4200 } 69 execsql { ROLLBACK TO abc } 70} -test { 71 faultsim_test_result {0 {}} 72} 73 74do_test pagerfault2-2-pre1 { 75 faultsim_restore_and_reopen 76 execsql { DELETE FROM t1 } 77 faultsim_save_and_close 78} {} 79 80do_faultsim_test pagerfault2-2 -faults oom-transient -prep { 81 faultsim_restore_and_reopen 82 sqlite3_db_config_lookaside db 0 256 4096 83 db func a_string a_string 84 85 execsql { 86 PRAGMA cache_size = 20; 87 BEGIN; 88 INSERT INTO t1 VALUES(a_string(401), a_string(402)); 89 SAVEPOINT abc; 90 } 91} -body { 92 execsql { INSERT INTO t1 VALUES (a_string(2000000), a_string(2500000)) } 93} -test { 94 faultsim_test_result {0 {}} 95} 96 97sqlite3_memdebug_vfs_oom_test 1 98finish_test 99 100