1# 2007 May 05 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# This file contains common code used by many different malloc tests 13# within the test suite. 14# 15# $Id: malloc_common.tcl,v 1.22 2008/09/23 16:41:30 danielk1977 Exp $ 16 17# If we did not compile with malloc testing enabled, then do nothing. 18# 19ifcapable builtin_test { 20 set MEMDEBUG 1 21} else { 22 set MEMDEBUG 0 23 return 0 24} 25 26# Transient and persistent OOM errors: 27# 28set FAULTSIM(oom-transient) [list \ 29 -injectstart {oom_injectstart 0} \ 30 -injectstop oom_injectstop \ 31 -injecterrlist {{1 {out of memory}}} \ 32] 33set FAULTSIM(oom-persistent) [list \ 34 -injectstart {oom_injectstart 1000000} \ 35 -injectstop oom_injectstop \ 36 -injecterrlist {{1 {out of memory}}} \ 37] 38 39# Transient and persistent IO errors: 40# 41set FAULTSIM(ioerr-transient) [list \ 42 -injectstart {ioerr_injectstart 0} \ 43 -injectstop ioerr_injectstop \ 44 -injecterrlist {{1 {disk I/O error}}} \ 45] 46set FAULTSIM(ioerr-persistent) [list \ 47 -injectstart {ioerr_injectstart 1} \ 48 -injectstop ioerr_injectstop \ 49 -injecterrlist {{1 {disk I/O error}}} \ 50] 51 52# SQLITE_FULL errors (always persistent): 53# 54set FAULTSIM(full) [list \ 55 -injectinstall fullerr_injectinstall \ 56 -injectstart fullerr_injectstart \ 57 -injectstop fullerr_injectstop \ 58 -injecterrlist {{1 {database or disk is full}}} \ 59 -injectuninstall fullerr_injectuninstall \ 60] 61 62# Transient and persistent SHM errors: 63# 64set FAULTSIM(shmerr-transient) [list \ 65 -injectinstall shmerr_injectinstall \ 66 -injectstart {shmerr_injectstart 0} \ 67 -injectstop shmerr_injectstop \ 68 -injecterrlist {{1 {disk I/O error}}} \ 69 -injectuninstall shmerr_injectuninstall \ 70] 71set FAULTSIM(shmerr-persistent) [list \ 72 -injectinstall shmerr_injectinstall \ 73 -injectstart {shmerr_injectstart 1} \ 74 -injectstop shmerr_injectstop \ 75 -injecterrlist {{1 {disk I/O error}}} \ 76 -injectuninstall shmerr_injectuninstall \ 77] 78 79# Transient and persistent CANTOPEN errors: 80# 81set FAULTSIM(cantopen-transient) [list \ 82 -injectinstall cantopen_injectinstall \ 83 -injectstart {cantopen_injectstart 0} \ 84 -injectstop cantopen_injectstop \ 85 -injecterrlist {{1 {unable to open database file}}} \ 86 -injectuninstall cantopen_injectuninstall \ 87] 88set FAULTSIM(cantopen-persistent) [list \ 89 -injectinstall cantopen_injectinstall \ 90 -injectstart {cantopen_injectstart 1} \ 91 -injectstop cantopen_injectstop \ 92 -injecterrlist {{1 {unable to open database file}}} \ 93 -injectuninstall cantopen_injectuninstall \ 94] 95 96 97 98#-------------------------------------------------------------------------- 99# Usage do_faultsim_test NAME ?OPTIONS...? 100# 101# -faults List of fault types to simulate. 102# 103# -prep Script to execute before -body. 104# 105# -body Script to execute (with fault injection). 106# 107# -test Script to execute after -body. 108# 109# -install Script to execute after faultsim -injectinstall 110# 111# -uninstall Script to execute after faultsim -uninjectinstall 112# 113proc do_faultsim_test {name args} { 114 global FAULTSIM 115 116 set DEFAULT(-faults) [array names FAULTSIM] 117 set DEFAULT(-prep) "" 118 set DEFAULT(-body) "" 119 set DEFAULT(-test) "" 120 set DEFAULT(-install) "" 121 set DEFAULT(-uninstall) "" 122 123 fix_testname name 124 125 array set O [array get DEFAULT] 126 array set O $args 127 foreach o [array names O] { 128 if {[info exists DEFAULT($o)]==0} { error "unknown option: $o" } 129 } 130 131 set faultlist [list] 132 foreach f $O(-faults) { 133 set flist [array names FAULTSIM $f] 134 if {[llength $flist]==0} { error "unknown fault: $f" } 135 set faultlist [concat $faultlist $flist] 136 } 137 138 set testspec [list -prep $O(-prep) -body $O(-body) \ 139 -test $O(-test) -install $O(-install) -uninstall $O(-uninstall) 140 ] 141 foreach f [lsort -unique $faultlist] { 142 eval do_one_faultsim_test "$name-$f" $FAULTSIM($f) $testspec 143 } 144} 145 146 147#------------------------------------------------------------------------- 148# Procedures to save and restore the current file-system state: 149# 150# faultsim_save 151# faultsim_restore 152# faultsim_save_and_close 153# faultsim_restore_and_reopen 154# faultsim_delete_and_reopen 155# 156proc faultsim_save {args} { uplevel db_save $args } 157proc faultsim_save_and_close {args} { uplevel db_save_and_close $args } 158proc faultsim_restore {args} { uplevel db_restore $args } 159proc faultsim_restore_and_reopen {args} { 160 uplevel db_restore_and_reopen $args 161 sqlite3_extended_result_codes db 1 162 sqlite3_db_config_lookaside db 0 0 0 163} 164proc faultsim_delete_and_reopen {args} { 165 uplevel db_delete_and_reopen $args 166 sqlite3_extended_result_codes db 1 167 sqlite3_db_config_lookaside db 0 0 0 168} 169 170proc faultsim_integrity_check {{db db}} { 171 set ic [$db eval { PRAGMA integrity_check }] 172 if {$ic != "ok"} { error "Integrity check: $ic" } 173} 174 175 176# The following procs are used as [do_one_faultsim_test] callbacks when 177# injecting OOM faults into test cases. 178# 179proc oom_injectstart {nRepeat iFail} { 180 sqlite3_memdebug_fail [expr $iFail-1] -repeat $nRepeat 181} 182proc oom_injectstop {} { 183 sqlite3_memdebug_fail -1 184} 185 186# The following procs are used as [do_one_faultsim_test] callbacks when 187# injecting IO error faults into test cases. 188# 189proc ioerr_injectstart {persist iFail} { 190 set ::sqlite_io_error_persist $persist 191 set ::sqlite_io_error_pending $iFail 192} 193proc ioerr_injectstop {} { 194 set sv $::sqlite_io_error_hit 195 set ::sqlite_io_error_persist 0 196 set ::sqlite_io_error_pending 0 197 set ::sqlite_io_error_hardhit 0 198 set ::sqlite_io_error_hit 0 199 set ::sqlite_io_error_pending 0 200 return $sv 201} 202 203# The following procs are used as [do_one_faultsim_test] callbacks when 204# injecting shared-memory related error faults into test cases. 205# 206proc shmerr_injectinstall {} { 207 testvfs shmfault -default true 208 shmfault filter {xShmOpen xShmMap xShmLock} 209} 210proc shmerr_injectuninstall {} { 211 catch {db close} 212 catch {db2 close} 213 shmfault delete 214} 215proc shmerr_injectstart {persist iFail} { 216 shmfault ioerr $iFail $persist 217} 218proc shmerr_injectstop {} { 219 shmfault ioerr 220} 221 222# The following procs are used as [do_one_faultsim_test] callbacks when 223# injecting SQLITE_FULL error faults into test cases. 224# 225proc fullerr_injectinstall {} { 226 testvfs shmfault -default true 227} 228proc fullerr_injectuninstall {} { 229 catch {db close} 230 catch {db2 close} 231 shmfault delete 232} 233proc fullerr_injectstart {iFail} { 234 shmfault full $iFail 1 235} 236proc fullerr_injectstop {} { 237 shmfault full 238} 239 240# The following procs are used as [do_one_faultsim_test] callbacks when 241# injecting SQLITE_CANTOPEN error faults into test cases. 242# 243proc cantopen_injectinstall {} { 244 testvfs shmfault -default true 245} 246proc cantopen_injectuninstall {} { 247 catch {db close} 248 catch {db2 close} 249 shmfault delete 250} 251proc cantopen_injectstart {persist iFail} { 252 shmfault cantopen $iFail $persist 253} 254proc cantopen_injectstop {} { 255 shmfault cantopen 256} 257 258# This command is not called directly. It is used by the 259# [faultsim_test_result] command created by [do_faultsim_test] and used 260# by -test scripts. 261# 262proc faultsim_test_result_int {args} { 263 upvar testrc testrc testresult testresult testnfail testnfail 264 set t [list $testrc $testresult] 265 set r $args 266 if { ($testnfail==0 && $t != [lindex $r 0]) || [lsearch $r $t]<0 } { 267 error "nfail=$testnfail rc=$testrc result=$testresult" 268 } 269} 270 271#-------------------------------------------------------------------------- 272# Usage do_one_faultsim_test NAME ?OPTIONS...? 273# 274# The first argument, <test number>, is used as a prefix of the test names 275# taken by tests executed by this command. Options are as follows. All 276# options take a single argument. 277# 278# -injectstart Script to enable fault-injection. 279# 280# -injectstop Script to disable fault-injection. 281# 282# -injecterrlist List of generally acceptable test results (i.e. error 283# messages). Example: [list {1 {out of memory}}] 284# 285# -injectinstall 286# 287# -injectuninstall 288# 289# -prep Script to execute before -body. 290# 291# -body Script to execute (with fault injection). 292# 293# -test Script to execute after -body. 294# 295proc do_one_faultsim_test {testname args} { 296 297 set DEFAULT(-injectstart) "expr" 298 set DEFAULT(-injectstop) "expr 0" 299 set DEFAULT(-injecterrlist) [list] 300 set DEFAULT(-injectinstall) "" 301 set DEFAULT(-injectuninstall) "" 302 set DEFAULT(-prep) "" 303 set DEFAULT(-body) "" 304 set DEFAULT(-test) "" 305 set DEFAULT(-install) "" 306 set DEFAULT(-uninstall) "" 307 308 array set O [array get DEFAULT] 309 array set O $args 310 foreach o [array names O] { 311 if {[info exists DEFAULT($o)]==0} { error "unknown option: $o" } 312 } 313 314 proc faultsim_test_proc {testrc testresult testnfail} $O(-test) 315 proc faultsim_test_result {args} " 316 uplevel faultsim_test_result_int \$args [list $O(-injecterrlist)] 317 " 318 319 eval $O(-injectinstall) 320 eval $O(-install) 321 322 set stop 0 323 for {set iFail 1} {!$stop} {incr iFail} { 324 325 # Evaluate the -prep script. 326 # 327 eval $O(-prep) 328 329 # Start the fault-injection. Run the -body script. Stop the fault 330 # injection. Local var $nfail is set to the total number of faults 331 # injected into the system this trial. 332 # 333 eval $O(-injectstart) $iFail 334 set rc [catch $O(-body) res] 335 set nfail [eval $O(-injectstop)] 336 337 # Run the -test script. If it throws no error, consider this trial 338 # sucessful. If it does throw an error, cause a [do_test] test to 339 # fail (and print out the unexpected exception thrown by the -test 340 # script at the same time). 341 # 342 set rc [catch [list faultsim_test_proc $rc $res $nfail] res] 343 if {$rc == 0} {set res ok} 344 do_test $testname.$iFail [list list $rc $res] {0 ok} 345 346 # If no faults where injected this trial, don't bother running 347 # any more. This test is finished. 348 # 349 if {$nfail==0} { set stop 1 } 350 } 351 352 eval $O(-uninstall) 353 eval $O(-injectuninstall) 354} 355 356# Usage: do_malloc_test <test number> <options...> 357# 358# The first argument, <test number>, is an integer used to name the 359# tests executed by this proc. Options are as follows: 360# 361# -tclprep TCL script to run to prepare test. 362# -sqlprep SQL script to run to prepare test. 363# -tclbody TCL script to run with malloc failure simulation. 364# -sqlbody TCL script to run with malloc failure simulation. 365# -cleanup TCL script to run after the test. 366# 367# This command runs a series of tests to verify SQLite's ability 368# to handle an out-of-memory condition gracefully. It is assumed 369# that if this condition occurs a malloc() call will return a 370# NULL pointer. Linux, for example, doesn't do that by default. See 371# the "BUGS" section of malloc(3). 372# 373# Each iteration of a loop, the TCL commands in any argument passed 374# to the -tclbody switch, followed by the SQL commands in any argument 375# passed to the -sqlbody switch are executed. Each iteration the 376# Nth call to sqliteMalloc() is made to fail, where N is increased 377# each time the loop runs starting from 1. When all commands execute 378# successfully, the loop ends. 379# 380proc do_malloc_test {tn args} { 381 array unset ::mallocopts 382 array set ::mallocopts $args 383 384 if {[string is integer $tn]} { 385 set tn malloc-$tn 386 } 387 if {[info exists ::mallocopts(-start)]} { 388 set start $::mallocopts(-start) 389 } else { 390 set start 0 391 } 392 if {[info exists ::mallocopts(-end)]} { 393 set end $::mallocopts(-end) 394 } else { 395 set end 50000 396 } 397 save_prng_state 398 399 foreach ::iRepeat {0 10000000} { 400 set ::go 1 401 for {set ::n $start} {$::go && $::n <= $end} {incr ::n} { 402 403 # If $::iRepeat is 0, then the malloc() failure is transient - it 404 # fails and then subsequent calls succeed. If $::iRepeat is 1, 405 # then the failure is persistent - once malloc() fails it keeps 406 # failing. 407 # 408 set zRepeat "transient" 409 if {$::iRepeat} {set zRepeat "persistent"} 410 restore_prng_state 411 foreach file [glob -nocomplain test.db-mj*] {file delete -force $file} 412 413 do_test ${tn}.${zRepeat}.${::n} { 414 415 # Remove all traces of database files test.db and test2.db 416 # from the file-system. Then open (empty database) "test.db" 417 # with the handle [db]. 418 # 419 catch {db close} 420 catch {db2 close} 421 forcedelete test.db 422 forcedelete test.db-journal 423 forcedelete test.db-wal 424 forcedelete test2.db 425 forcedelete test2.db-journal 426 forcedelete test2.db-wal 427 if {[info exists ::mallocopts(-testdb)]} { 428 file copy $::mallocopts(-testdb) test.db 429 } 430 catch { sqlite3 db test.db } 431 if {[info commands db] ne ""} { 432 sqlite3_extended_result_codes db 1 433 } 434 sqlite3_db_config_lookaside db 0 0 0 435 436 # Execute any -tclprep and -sqlprep scripts. 437 # 438 if {[info exists ::mallocopts(-tclprep)]} { 439 eval $::mallocopts(-tclprep) 440 } 441 if {[info exists ::mallocopts(-sqlprep)]} { 442 execsql $::mallocopts(-sqlprep) 443 } 444 445 # Now set the ${::n}th malloc() to fail and execute the -tclbody 446 # and -sqlbody scripts. 447 # 448 sqlite3_memdebug_fail $::n -repeat $::iRepeat 449 set ::mallocbody {} 450 if {[info exists ::mallocopts(-tclbody)]} { 451 append ::mallocbody "$::mallocopts(-tclbody)\n" 452 } 453 if {[info exists ::mallocopts(-sqlbody)]} { 454 append ::mallocbody "db eval {$::mallocopts(-sqlbody)}" 455 } 456 457 # The following block sets local variables as follows: 458 # 459 # isFail - True if an error (any error) was reported by sqlite. 460 # nFail - The total number of simulated malloc() failures. 461 # nBenign - The number of benign simulated malloc() failures. 462 # 463 set isFail [catch $::mallocbody msg] 464 set nFail [sqlite3_memdebug_fail -1 -benigncnt nBenign] 465 # puts -nonewline " (isFail=$isFail nFail=$nFail nBenign=$nBenign) " 466 467 # If one or more mallocs failed, run this loop body again. 468 # 469 set go [expr {$nFail>0}] 470 471 if {($nFail-$nBenign)==0} { 472 if {$isFail} { 473 set v2 $msg 474 } else { 475 set isFail 1 476 set v2 1 477 } 478 } elseif {!$isFail} { 479 set v2 $msg 480 } elseif { 481 [info command db]=="" || 482 [db errorcode]==7 || 483 $msg=="out of memory" 484 } { 485 set v2 1 486 } else { 487 set v2 $msg 488 puts [db errorcode] 489 } 490 lappend isFail $v2 491 } {1 1} 492 493 if {[info exists ::mallocopts(-cleanup)]} { 494 catch [list uplevel #0 $::mallocopts(-cleanup)] msg 495 } 496 } 497 } 498 unset ::mallocopts 499 sqlite3_memdebug_fail -1 500} 501 502 503#------------------------------------------------------------------------- 504# This proc is used to test a single SELECT statement. Parameter $name is 505# passed a name for the test case (i.e. "fts3_malloc-1.4.1") and parameter 506# $sql is passed the text of the SELECT statement. Parameter $result is 507# set to the expected output if the SELECT statement is successfully 508# executed using [db eval]. 509# 510# Example: 511# 512# do_select_test testcase-1.1 "SELECT 1+1, 1+2" {1 2} 513# 514# If global variable DO_MALLOC_TEST is set to a non-zero value, or if 515# it is not defined at all, then OOM testing is performed on the SELECT 516# statement. Each OOM test case is said to pass if either (a) executing 517# the SELECT statement succeeds and the results match those specified 518# by parameter $result, or (b) TCL throws an "out of memory" error. 519# 520# If DO_MALLOC_TEST is defined and set to zero, then the SELECT statement 521# is executed just once. In this case the test case passes if the results 522# match the expected results passed via parameter $result. 523# 524proc do_select_test {name sql result} { 525 uplevel [list doPassiveTest 0 $name $sql [list 0 [list {*}$result]]] 526} 527 528proc do_restart_select_test {name sql result} { 529 uplevel [list doPassiveTest 1 $name $sql [list 0 $result]] 530} 531 532proc do_error_test {name sql error} { 533 uplevel [list doPassiveTest 0 $name $sql [list 1 $error]] 534} 535 536proc doPassiveTest {isRestart name sql catchres} { 537 if {![info exists ::DO_MALLOC_TEST]} { set ::DO_MALLOC_TEST 1 } 538 539 if {[info exists ::testprefix] 540 && [string is integer [string range $name 0 0]] 541 } { 542 set name $::testprefix.$name 543 } 544 545 switch $::DO_MALLOC_TEST { 546 0 { # No malloc failures. 547 do_test $name [list set {} [uplevel [list catchsql $sql]]] $catchres 548 return 549 } 550 1 { # Simulate transient failures. 551 set nRepeat 1 552 set zName "transient" 553 set nStartLimit 100000 554 set nBackup 1 555 } 556 2 { # Simulate persistent failures. 557 set nRepeat 1 558 set zName "persistent" 559 set nStartLimit 100000 560 set nBackup 1 561 } 562 3 { # Simulate transient failures with extra brute force. 563 set nRepeat 100000 564 set zName "ridiculous" 565 set nStartLimit 1 566 set nBackup 10 567 } 568 } 569 570 # The set of acceptable results from running [catchsql $sql]. 571 # 572 set answers [list {1 {out of memory}} $catchres] 573 set str [join $answers " OR "] 574 575 set nFail 1 576 for {set iLimit $nStartLimit} {$nFail} {incr iLimit} { 577 for {set iFail 1} {$nFail && $iFail<=$iLimit} {incr iFail} { 578 for {set iTest 0} {$iTest<$nBackup && ($iFail-$iTest)>0} {incr iTest} { 579 580 if {$isRestart} { sqlite3 db test.db } 581 582 sqlite3_memdebug_fail [expr $iFail-$iTest] -repeat $nRepeat 583 set res [uplevel [list catchsql $sql]] 584 if {[lsearch -exact $answers $res]>=0} { set res $str } 585 set testname "$name.$zName.$iFail" 586 do_test "$name.$zName.$iLimit.$iFail" [list set {} $res] $str 587 588 set nFail [sqlite3_memdebug_fail -1 -benigncnt nBenign] 589 } 590 } 591 } 592} 593 594 595#------------------------------------------------------------------------- 596# Test a single write to the database. In this case a "write" is a 597# DELETE, UPDATE or INSERT statement. 598# 599# If OOM testing is performed, there are several acceptable outcomes: 600# 601# 1) The write succeeds. No error is returned. 602# 603# 2) An "out of memory" exception is thrown and: 604# 605# a) The statement has no effect, OR 606# b) The current transaction is rolled back, OR 607# c) The statement succeeds. This can only happen if the connection 608# is in auto-commit mode (after the statement is executed, so this 609# includes COMMIT statements). 610# 611# If the write operation eventually succeeds, zero is returned. If a 612# transaction is rolled back, non-zero is returned. 613# 614# Parameter $name is the name to use for the test case (or test cases). 615# The second parameter, $tbl, should be the name of the database table 616# being modified. Parameter $sql contains the SQL statement to test. 617# 618proc do_write_test {name tbl sql} { 619 if {![info exists ::DO_MALLOC_TEST]} { set ::DO_MALLOC_TEST 1 } 620 621 # Figure out an statement to get a checksum for table $tbl. 622 db eval "SELECT * FROM $tbl" V break 623 set cksumsql "SELECT md5sum([join [concat rowid $V(*)] ,]) FROM $tbl" 624 625 # Calculate the initial table checksum. 626 set cksum1 [db one $cksumsql] 627 628 if {$::DO_MALLOC_TEST } { 629 set answers [list {1 {out of memory}} {0 {}}] 630 if {$::DO_MALLOC_TEST==1} { 631 set modes {100000 persistent} 632 } else { 633 set modes {1 transient} 634 } 635 } else { 636 set answers [list {0 {}}] 637 set modes [list 0 nofail] 638 } 639 set str [join $answers " OR "] 640 641 foreach {nRepeat zName} $modes { 642 for {set iFail 1} 1 {incr iFail} { 643 if {$::DO_MALLOC_TEST} {sqlite3_memdebug_fail $iFail -repeat $nRepeat} 644 645 set res [uplevel [list catchsql $sql]] 646 set nFail [sqlite3_memdebug_fail -1 -benigncnt nBenign] 647 if {$nFail==0} { 648 do_test $name.$zName.$iFail [list set {} $res] {0 {}} 649 return 650 } else { 651 if {[lsearch $answers $res]>=0} { 652 set res $str 653 } 654 do_test $name.$zName.$iFail [list set {} $res] $str 655 set cksum2 [db one $cksumsql] 656 if {$cksum1 != $cksum2} return 657 } 658 } 659 } 660} 661