• Home
  • Line#
  • Scopes#
  • Navigate#
  • Raw
  • Download
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