xref: /sqlite-3.40.0/src/test6.c (revision 999cd08a)
1 /*
2 ** 2004 May 22
3 **
4 ** The author disclaims copyright to this source code.  In place of
5 ** a legal notice, here is a blessing:
6 **
7 **    May you do good and not evil.
8 **    May you find forgiveness for yourself and forgive others.
9 **    May you share freely, never taking more than you give.
10 **
11 ******************************************************************************
12 **
13 ** This file contains code that modified the OS layer in order to simulate
14 ** the effect on the database file of an OS crash or power failure.  This
15 ** is used to test the ability of SQLite to recover from those situations.
16 */
17 #if SQLITE_TEST          /* This file is used for testing only */
18 #include "sqliteInt.h"
19 #include "tcl.h"
20 
21 #ifndef SQLITE_OMIT_DISKIO  /* This file is a no-op if disk I/O is disabled */
22 
23 /* #define TRACE_CRASHTEST */
24 
25 typedef struct CrashFile CrashFile;
26 typedef struct CrashGlobal CrashGlobal;
27 typedef struct WriteBuffer WriteBuffer;
28 
29 /*
30 ** Method:
31 **
32 **   This layer is implemented as a wrapper around the "real"
33 **   sqlite3_file object for the host system. Each time data is
34 **   written to the file object, instead of being written to the
35 **   underlying file, the write operation is stored in an in-memory
36 **   structure (type WriteBuffer). This structure is placed at the
37 **   end of a global ordered list (the write-list).
38 **
39 **   When data is read from a file object, the requested region is
40 **   first retrieved from the real file. The write-list is then
41 **   traversed and data copied from any overlapping WriteBuffer
42 **   structures to the output buffer. i.e. a read() operation following
43 **   one or more write() operations works as expected, even if no
44 **   data has actually been written out to the real file.
45 **
46 **   When a fsync() operation is performed, an operating system crash
47 **   may be simulated, in which case exit(-1) is called (the call to
48 **   xSync() never returns). Whether or not a crash is simulated,
49 **   the data associated with a subset of the WriteBuffer structures
50 **   stored in the write-list is written to the real underlying files
51 **   and the entries removed from the write-list. If a crash is simulated,
52 **   a subset of the buffers may be corrupted before the data is written.
53 **
54 **   The exact subset of the write-list written and/or corrupted is
55 **   determined by the simulated device characteristics and sector-size.
56 **
57 ** "Normal" mode:
58 **
59 **   Normal mode is used when the simulated device has none of the
60 **   SQLITE_IOCAP_XXX flags set.
61 **
62 **   In normal mode, if the fsync() is not a simulated crash, the
63 **   write-list is traversed from beginning to end. Each WriteBuffer
64 **   structure associated with the file handle used to call xSync()
65 **   is written to the real file and removed from the write-list.
66 **
67 **   If a crash is simulated, one of the following takes place for
68 **   each WriteBuffer in the write-list, regardless of which
69 **   file-handle it is associated with:
70 **
71 **     1. The buffer is correctly written to the file, just as if
72 **        a crash were not being simulated.
73 **
74 **     2. Nothing is done.
75 **
76 **     3. Garbage data is written to all sectors of the file that
77 **        overlap the region specified by the WriteBuffer. Or garbage
78 **        data is written to some contiguous section within the
79 **        overlapped sectors.
80 **
81 ** Device Characteristic flag handling:
82 **
83 **   If the IOCAP_ATOMIC flag is set, then option (3) above is
84 **   never selected.
85 **
86 **   If the IOCAP_ATOMIC512 flag is set, and the WriteBuffer represents
87 **   an aligned write() of an integer number of 512 byte regions, then
88 **   option (3) above is never selected. Instead, each 512 byte region
89 **   is either correctly written or left completely untouched. Similar
90 **   logic governs the behavior if any of the other ATOMICXXX flags
91 **   is set.
92 **
93 **   If either the IOCAP_SAFEAPPEND or IOCAP_SEQUENTIAL flags are set
94 **   and a crash is being simulated, then an entry of the write-list is
95 **   selected at random. Everything in the list after the selected entry
96 **   is discarded before processing begins.
97 **
98 **   If IOCAP_SEQUENTIAL is set and a crash is being simulated, option
99 **   (1) is selected for all write-list entries except the last. If a
100 **   crash is not being simulated, then all entries in the write-list
101 **   that occur before at least one write() on the file-handle specified
102 **   as part of the xSync() are written to their associated real files.
103 **
104 **   If IOCAP_SAFEAPPEND is set and the first byte written by the write()
105 **   operation is one byte past the current end of the file, then option
106 **   (1) is always selected.
107 */
108 
109 /*
110 ** Each write operation in the write-list is represented by an instance
111 ** of the following structure.
112 **
113 ** If zBuf is 0, then this structure represents a call to xTruncate(),
114 ** not xWrite(). In that case, iOffset is the size that the file is
115 ** truncated to.
116 */
117 struct WriteBuffer {
118   i64 iOffset;                 /* Byte offset of the start of this write() */
119   int nBuf;                    /* Number of bytes written */
120   u8 *zBuf;                    /* Pointer to copy of written data */
121   CrashFile *pFile;            /* File this write() applies to */
122 
123   WriteBuffer *pNext;          /* Next in CrashGlobal.pWriteList */
124 };
125 
126 struct CrashFile {
127   const sqlite3_io_methods *pMethod;   /* Must be first */
128   sqlite3_file *pRealFile;             /* Underlying "real" file handle */
129   char *zName;
130   int flags;                           /* Flags the file was opened with */
131 
132   /* Cache of the entire file. This is used to speed up OsRead() and
133   ** OsFileSize() calls. Although both could be done by traversing the
134   ** write-list, in practice this is impractically slow.
135   */
136   u8 *zData;                           /* Buffer containing file contents */
137   int nData;                           /* Size of buffer allocated at zData */
138   i64 iSize;                           /* Size of file in bytes */
139 };
140 
141 struct CrashGlobal {
142   WriteBuffer *pWriteList;     /* Head of write-list */
143   WriteBuffer *pWriteListEnd;  /* End of write-list */
144 
145   int iSectorSize;             /* Value of simulated sector size */
146   int iDeviceCharacteristics;  /* Value of simulated device characteristics */
147 
148   int iCrash;                  /* Crash on the iCrash'th call to xSync() */
149   char zCrashFile[500];        /* Crash during an xSync() on this file */
150 };
151 
152 static CrashGlobal g = {0, 0, SQLITE_DEFAULT_SECTOR_SIZE, 0, 0};
153 
154 /*
155 ** Set this global variable to 1 to enable crash testing.
156 */
157 static int sqlite3CrashTestEnable = 0;
158 
159 static void *crash_malloc(int nByte){
160   return (void *)Tcl_Alloc((size_t)nByte);
161 }
162 static void crash_free(void *p){
163   Tcl_Free(p);
164 }
165 static void *crash_realloc(void *p, int n){
166   return (void *)Tcl_Realloc(p, (size_t)n);
167 }
168 
169 /*
170 ** Wrapper around the sqlite3OsWrite() function that avoids writing to the
171 ** 512 byte block begining at offset PENDING_BYTE.
172 */
173 static int writeDbFile(CrashFile *p, u8 *z, i64 iAmt, i64 iOff){
174   int rc = SQLITE_OK;
175   int iSkip = 0;
176   if( iOff==PENDING_BYTE && (p->flags&SQLITE_OPEN_MAIN_DB) ){
177     iSkip = 512;
178   }
179   if( (iAmt-iSkip)>0 ){
180     rc = sqlite3OsWrite(p->pRealFile, &z[iSkip], (int)(iAmt-iSkip), iOff+iSkip);
181   }
182   return rc;
183 }
184 
185 /*
186 ** Flush the write-list as if xSync() had been called on file handle
187 ** pFile. If isCrash is true, simulate a crash.
188 */
189 static int writeListSync(CrashFile *pFile, int isCrash){
190   int rc = SQLITE_OK;
191   int iDc = g.iDeviceCharacteristics;
192 
193   WriteBuffer *pWrite;
194   WriteBuffer **ppPtr;
195 
196   /* If this is not a crash simulation, set pFinal to point to the
197   ** last element of the write-list that is associated with file handle
198   ** pFile.
199   **
200   ** If this is a crash simulation, set pFinal to an arbitrarily selected
201   ** element of the write-list.
202   */
203   WriteBuffer *pFinal = 0;
204   if( !isCrash ){
205     for(pWrite=g.pWriteList; pWrite; pWrite=pWrite->pNext){
206       if( pWrite->pFile==pFile ){
207         pFinal = pWrite;
208       }
209     }
210   }else if( iDc&(SQLITE_IOCAP_SEQUENTIAL|SQLITE_IOCAP_SAFE_APPEND) ){
211     int nWrite = 0;
212     int iFinal;
213     for(pWrite=g.pWriteList; pWrite; pWrite=pWrite->pNext) nWrite++;
214     sqlite3_randomness(sizeof(int), &iFinal);
215     iFinal = ((iFinal<0)?-1*iFinal:iFinal)%nWrite;
216     for(pWrite=g.pWriteList; iFinal>0; pWrite=pWrite->pNext) iFinal--;
217     pFinal = pWrite;
218   }
219 
220 #ifdef TRACE_CRASHTEST
221   printf("Sync %s (is %s crash)\n", pFile->zName, (isCrash?"a":"not a"));
222 #endif
223 
224   ppPtr = &g.pWriteList;
225   for(pWrite=*ppPtr; rc==SQLITE_OK && pWrite; pWrite=*ppPtr){
226     sqlite3_file *pRealFile = pWrite->pFile->pRealFile;
227 
228     /* (eAction==1)      -> write block out normally,
229     ** (eAction==2)      -> do nothing,
230     ** (eAction==3)      -> trash sectors.
231     */
232     int eAction = 0;
233     if( !isCrash ){
234       eAction = 2;
235       if( (pWrite->pFile==pFile || iDc&SQLITE_IOCAP_SEQUENTIAL) ){
236         eAction = 1;
237       }
238     }else{
239       char random;
240       sqlite3_randomness(1, &random);
241 
242       /* Do not select option 3 (sector trashing) if the IOCAP_ATOMIC flag
243       ** is set or this is an OsTruncate(), not an Oswrite().
244       */
245       if( (iDc&SQLITE_IOCAP_ATOMIC) || (pWrite->zBuf==0) ){
246         random &= 0x01;
247       }
248 
249       /* If IOCAP_SEQUENTIAL is set and this is not the final entry
250       ** in the truncated write-list, always select option 1 (write
251       ** out correctly).
252       */
253       if( (iDc&SQLITE_IOCAP_SEQUENTIAL && pWrite!=pFinal) ){
254         random = 0;
255       }
256 
257       /* If IOCAP_SAFE_APPEND is set and this OsWrite() operation is
258       ** an append (first byte of the written region is 1 byte past the
259       ** current EOF), always select option 1 (write out correctly).
260       */
261       if( iDc&SQLITE_IOCAP_SAFE_APPEND && pWrite->zBuf ){
262         i64 iSize;
263         sqlite3OsFileSize(pRealFile, &iSize);
264         if( iSize==pWrite->iOffset ){
265           random = 0;
266         }
267       }
268 
269       if( (random&0x06)==0x06 ){
270         eAction = 3;
271       }else{
272         eAction = ((random&0x01)?2:1);
273       }
274     }
275 
276     switch( eAction ){
277       case 1: {               /* Write out correctly */
278         if( pWrite->zBuf ){
279           rc = writeDbFile(
280               pWrite->pFile, pWrite->zBuf, pWrite->nBuf, pWrite->iOffset
281           );
282         }else{
283           rc = sqlite3OsTruncate(pRealFile, pWrite->iOffset);
284         }
285         *ppPtr = pWrite->pNext;
286 #ifdef TRACE_CRASHTEST
287         if( isCrash ){
288           printf("Writing %d bytes @ %d (%s)\n",
289             pWrite->nBuf, (int)pWrite->iOffset, pWrite->pFile->zName
290           );
291         }
292 #endif
293         crash_free(pWrite);
294         break;
295       }
296       case 2: {               /* Do nothing */
297         ppPtr = &pWrite->pNext;
298 #ifdef TRACE_CRASHTEST
299         if( isCrash ){
300           printf("Omiting %d bytes @ %d (%s)\n",
301             pWrite->nBuf, (int)pWrite->iOffset, pWrite->pFile->zName
302           );
303         }
304 #endif
305         break;
306       }
307       case 3: {               /* Trash sectors */
308         u8 *zGarbage;
309         int iFirst = (int)(pWrite->iOffset/g.iSectorSize);
310         int iLast = (int)((pWrite->iOffset+pWrite->nBuf-1)/g.iSectorSize);
311 
312         assert(pWrite->zBuf);
313 
314 #ifdef TRACE_CRASHTEST
315         printf("Trashing %d sectors @ %lld (sector %d) (%s)\n",
316             1+iLast-iFirst, pWrite->iOffset, iFirst, pWrite->pFile->zName
317         );
318 #endif
319 
320         zGarbage = crash_malloc(g.iSectorSize);
321         if( zGarbage ){
322           sqlite3_int64 i;
323           for(i=iFirst; rc==SQLITE_OK && i<=iLast; i++){
324             sqlite3_randomness(g.iSectorSize, zGarbage);
325             rc = writeDbFile(
326               pWrite->pFile, zGarbage, g.iSectorSize, i*g.iSectorSize
327             );
328           }
329           crash_free(zGarbage);
330         }else{
331           rc = SQLITE_NOMEM;
332         }
333 
334         ppPtr = &pWrite->pNext;
335         break;
336       }
337 
338       default:
339         assert(!"Cannot happen");
340     }
341 
342     if( pWrite==pFinal ) break;
343   }
344 
345   if( rc==SQLITE_OK && isCrash ){
346     exit(-1);
347   }
348 
349   for(pWrite=g.pWriteList; pWrite && pWrite->pNext; pWrite=pWrite->pNext);
350   g.pWriteListEnd = pWrite;
351 
352   return rc;
353 }
354 
355 /*
356 ** Add an entry to the end of the write-list.
357 */
358 static int writeListAppend(
359   sqlite3_file *pFile,
360   sqlite3_int64 iOffset,
361   const u8 *zBuf,
362   int nBuf
363 ){
364   WriteBuffer *pNew;
365 
366   assert((zBuf && nBuf) || (!nBuf && !zBuf));
367 
368   pNew = (WriteBuffer *)crash_malloc(sizeof(WriteBuffer) + nBuf);
369   if( pNew==0 ){
370     fprintf(stderr, "out of memory in the crash simulator\n");
371   }
372   memset(pNew, 0, sizeof(WriteBuffer)+nBuf);
373   pNew->iOffset = iOffset;
374   pNew->nBuf = nBuf;
375   pNew->pFile = (CrashFile *)pFile;
376   if( zBuf ){
377     pNew->zBuf = (u8 *)&pNew[1];
378     memcpy(pNew->zBuf, zBuf, nBuf);
379   }
380 
381   if( g.pWriteList ){
382     assert(g.pWriteListEnd);
383     g.pWriteListEnd->pNext = pNew;
384   }else{
385     g.pWriteList = pNew;
386   }
387   g.pWriteListEnd = pNew;
388 
389   return SQLITE_OK;
390 }
391 
392 /*
393 ** Close a crash-file.
394 */
395 static int cfClose(sqlite3_file *pFile){
396   CrashFile *pCrash = (CrashFile *)pFile;
397   writeListSync(pCrash, 0);
398   sqlite3OsClose(pCrash->pRealFile);
399   return SQLITE_OK;
400 }
401 
402 /*
403 ** Read data from a crash-file.
404 */
405 static int cfRead(
406   sqlite3_file *pFile,
407   void *zBuf,
408   int iAmt,
409   sqlite_int64 iOfst
410 ){
411   CrashFile *pCrash = (CrashFile *)pFile;
412   int nCopy = (int)MIN((i64)iAmt, (pCrash->iSize - iOfst));
413 
414   if( nCopy>0 ){
415     memcpy(zBuf, &pCrash->zData[iOfst], nCopy);
416   }
417 
418   /* Check the file-size to see if this is a short-read */
419   if( nCopy<iAmt ){
420     return SQLITE_IOERR_SHORT_READ;
421   }
422 
423   return SQLITE_OK;
424 }
425 
426 /*
427 ** Write data to a crash-file.
428 */
429 static int cfWrite(
430   sqlite3_file *pFile,
431   const void *zBuf,
432   int iAmt,
433   sqlite_int64 iOfst
434 ){
435   CrashFile *pCrash = (CrashFile *)pFile;
436   if( iAmt+iOfst>pCrash->iSize ){
437     pCrash->iSize = (int)(iAmt+iOfst);
438   }
439   while( pCrash->iSize>pCrash->nData ){
440     u8 *zNew;
441     int nNew = (pCrash->nData*2) + 4096;
442     zNew = crash_realloc(pCrash->zData, nNew);
443     if( !zNew ){
444       return SQLITE_NOMEM;
445     }
446     memset(&zNew[pCrash->nData], 0, nNew-pCrash->nData);
447     pCrash->nData = nNew;
448     pCrash->zData = zNew;
449   }
450   memcpy(&pCrash->zData[iOfst], zBuf, iAmt);
451   return writeListAppend(pFile, iOfst, zBuf, iAmt);
452 }
453 
454 /*
455 ** Truncate a crash-file.
456 */
457 static int cfTruncate(sqlite3_file *pFile, sqlite_int64 size){
458   CrashFile *pCrash = (CrashFile *)pFile;
459   assert(size>=0);
460   if( pCrash->iSize>size ){
461     pCrash->iSize = (int)size;
462   }
463   return writeListAppend(pFile, size, 0, 0);
464 }
465 
466 /*
467 ** Sync a crash-file.
468 */
469 static int cfSync(sqlite3_file *pFile, int flags){
470   CrashFile *pCrash = (CrashFile *)pFile;
471   int isCrash = 0;
472 
473   const char *zName = pCrash->zName;
474   const char *zCrashFile = g.zCrashFile;
475   int nName = (int)strlen(zName);
476   int nCrashFile = (int)strlen(zCrashFile);
477 
478   if( nCrashFile>0 && zCrashFile[nCrashFile-1]=='*' ){
479     nCrashFile--;
480     if( nName>nCrashFile ) nName = nCrashFile;
481   }
482 
483 #ifdef TRACE_CRASHTEST
484   printf("cfSync(): nName = %d, nCrashFile = %d, zName = %s, zCrashFile = %s\n",
485          nName, nCrashFile, zName, zCrashFile);
486 #endif
487 
488   if( nName==nCrashFile && 0==memcmp(zName, zCrashFile, nName) ){
489 #ifdef TRACE_CRASHTEST
490     printf("cfSync(): name matched, g.iCrash = %d\n", g.iCrash);
491 #endif
492     if( (--g.iCrash)==0 ) isCrash = 1;
493   }
494 
495   return writeListSync(pCrash, isCrash);
496 }
497 
498 /*
499 ** Return the current file-size of the crash-file.
500 */
501 static int cfFileSize(sqlite3_file *pFile, sqlite_int64 *pSize){
502   CrashFile *pCrash = (CrashFile *)pFile;
503   *pSize = (i64)pCrash->iSize;
504   return SQLITE_OK;
505 }
506 
507 /*
508 ** Calls related to file-locks are passed on to the real file handle.
509 */
510 static int cfLock(sqlite3_file *pFile, int eLock){
511   return sqlite3OsLock(((CrashFile *)pFile)->pRealFile, eLock);
512 }
513 static int cfUnlock(sqlite3_file *pFile, int eLock){
514   return sqlite3OsUnlock(((CrashFile *)pFile)->pRealFile, eLock);
515 }
516 static int cfCheckReservedLock(sqlite3_file *pFile, int *pResOut){
517   return sqlite3OsCheckReservedLock(((CrashFile *)pFile)->pRealFile, pResOut);
518 }
519 static int cfFileControl(sqlite3_file *pFile, int op, void *pArg){
520   if( op==SQLITE_FCNTL_SIZE_HINT ){
521     CrashFile *pCrash = (CrashFile *)pFile;
522     i64 nByte = *(i64 *)pArg;
523     if( nByte>pCrash->iSize ){
524       if( SQLITE_OK==writeListAppend(pFile, nByte, 0, 0) ){
525         pCrash->iSize = (int)nByte;
526       }
527     }
528     return SQLITE_OK;
529   }
530   return sqlite3OsFileControl(((CrashFile *)pFile)->pRealFile, op, pArg);
531 }
532 
533 /*
534 ** The xSectorSize() and xDeviceCharacteristics() functions return
535 ** the global values configured by the [sqlite_crashparams] tcl
536 *  interface.
537 */
538 static int cfSectorSize(sqlite3_file *pFile){
539   return g.iSectorSize;
540 }
541 static int cfDeviceCharacteristics(sqlite3_file *pFile){
542   return g.iDeviceCharacteristics;
543 }
544 
545 /*
546 ** Pass-throughs for WAL support.
547 */
548 static int cfShmLock(sqlite3_file *pFile, int ofst, int n, int flags){
549   return sqlite3OsShmLock(((CrashFile*)pFile)->pRealFile, ofst, n, flags);
550 }
551 static void cfShmBarrier(sqlite3_file *pFile){
552   sqlite3OsShmBarrier(((CrashFile*)pFile)->pRealFile);
553 }
554 static int cfShmUnmap(sqlite3_file *pFile, int delFlag){
555   return sqlite3OsShmUnmap(((CrashFile*)pFile)->pRealFile, delFlag);
556 }
557 static int cfShmMap(
558   sqlite3_file *pFile,            /* Handle open on database file */
559   int iRegion,                    /* Region to retrieve */
560   int sz,                         /* Size of regions */
561   int w,                          /* True to extend file if necessary */
562   void volatile **pp              /* OUT: Mapped memory */
563 ){
564   return sqlite3OsShmMap(((CrashFile*)pFile)->pRealFile, iRegion, sz, w, pp);
565 }
566 
567 static const sqlite3_io_methods CrashFileVtab = {
568   2,                            /* iVersion */
569   cfClose,                      /* xClose */
570   cfRead,                       /* xRead */
571   cfWrite,                      /* xWrite */
572   cfTruncate,                   /* xTruncate */
573   cfSync,                       /* xSync */
574   cfFileSize,                   /* xFileSize */
575   cfLock,                       /* xLock */
576   cfUnlock,                     /* xUnlock */
577   cfCheckReservedLock,          /* xCheckReservedLock */
578   cfFileControl,                /* xFileControl */
579   cfSectorSize,                 /* xSectorSize */
580   cfDeviceCharacteristics,      /* xDeviceCharacteristics */
581   cfShmMap,                     /* xShmMap */
582   cfShmLock,                    /* xShmLock */
583   cfShmBarrier,                 /* xShmBarrier */
584   cfShmUnmap                    /* xShmUnmap */
585 };
586 
587 /*
588 ** Application data for the crash VFS
589 */
590 struct crashAppData {
591   sqlite3_vfs *pOrig;                   /* Wrapped vfs structure */
592 };
593 
594 /*
595 ** Open a crash-file file handle.
596 **
597 ** The caller will have allocated pVfs->szOsFile bytes of space
598 ** at pFile. This file uses this space for the CrashFile structure
599 ** and allocates space for the "real" file structure using
600 ** sqlite3_malloc(). The assumption here is (pVfs->szOsFile) is
601 ** equal or greater than sizeof(CrashFile).
602 */
603 static int cfOpen(
604   sqlite3_vfs *pCfVfs,
605   const char *zName,
606   sqlite3_file *pFile,
607   int flags,
608   int *pOutFlags
609 ){
610   sqlite3_vfs *pVfs = (sqlite3_vfs *)pCfVfs->pAppData;
611   int rc;
612   CrashFile *pWrapper = (CrashFile *)pFile;
613   sqlite3_file *pReal = (sqlite3_file*)&pWrapper[1];
614 
615   memset(pWrapper, 0, sizeof(CrashFile));
616   rc = sqlite3OsOpen(pVfs, zName, pReal, flags, pOutFlags);
617 
618   if( rc==SQLITE_OK ){
619     i64 iSize;
620     pWrapper->pMethod = &CrashFileVtab;
621     pWrapper->zName = (char *)zName;
622     pWrapper->pRealFile = pReal;
623     rc = sqlite3OsFileSize(pReal, &iSize);
624     pWrapper->iSize = (int)iSize;
625     pWrapper->flags = flags;
626   }
627   if( rc==SQLITE_OK ){
628     pWrapper->nData = (int)(4096 + pWrapper->iSize);
629     pWrapper->zData = crash_malloc(pWrapper->nData);
630     if( pWrapper->zData ){
631       /* os_unix.c contains an assert() that fails if the caller attempts
632       ** to read data from the 512-byte locking region of a file opened
633       ** with the SQLITE_OPEN_MAIN_DB flag. This region of a database file
634       ** never contains valid data anyhow. So avoid doing such a read here.
635       **
636       ** UPDATE: It also contains an assert() verifying that each call
637       ** to the xRead() method reads less than 128KB of data.
638       */
639       const int isDb = (flags&SQLITE_OPEN_MAIN_DB);
640       i64 iOff;
641 
642       memset(pWrapper->zData, 0, pWrapper->nData);
643       for(iOff=0; iOff<pWrapper->iSize; iOff += 512){
644         int nRead = (int)(pWrapper->iSize - iOff);
645         if( nRead>512 ) nRead = 512;
646         if( isDb && iOff==PENDING_BYTE ) continue;
647         rc = sqlite3OsRead(pReal, &pWrapper->zData[iOff], nRead, iOff);
648       }
649     }else{
650       rc = SQLITE_NOMEM;
651     }
652   }
653   if( rc!=SQLITE_OK && pWrapper->pMethod ){
654     sqlite3OsClose(pFile);
655   }
656   return rc;
657 }
658 
659 static int cfDelete(sqlite3_vfs *pCfVfs, const char *zPath, int dirSync){
660   sqlite3_vfs *pVfs = (sqlite3_vfs *)pCfVfs->pAppData;
661   return pVfs->xDelete(pVfs, zPath, dirSync);
662 }
663 static int cfAccess(
664   sqlite3_vfs *pCfVfs,
665   const char *zPath,
666   int flags,
667   int *pResOut
668 ){
669   sqlite3_vfs *pVfs = (sqlite3_vfs *)pCfVfs->pAppData;
670   return pVfs->xAccess(pVfs, zPath, flags, pResOut);
671 }
672 static int cfFullPathname(
673   sqlite3_vfs *pCfVfs,
674   const char *zPath,
675   int nPathOut,
676   char *zPathOut
677 ){
678   sqlite3_vfs *pVfs = (sqlite3_vfs *)pCfVfs->pAppData;
679   return pVfs->xFullPathname(pVfs, zPath, nPathOut, zPathOut);
680 }
681 static void *cfDlOpen(sqlite3_vfs *pCfVfs, const char *zPath){
682   sqlite3_vfs *pVfs = (sqlite3_vfs *)pCfVfs->pAppData;
683   return pVfs->xDlOpen(pVfs, zPath);
684 }
685 static void cfDlError(sqlite3_vfs *pCfVfs, int nByte, char *zErrMsg){
686   sqlite3_vfs *pVfs = (sqlite3_vfs *)pCfVfs->pAppData;
687   pVfs->xDlError(pVfs, nByte, zErrMsg);
688 }
689 static void (*cfDlSym(sqlite3_vfs *pCfVfs, void *pH, const char *zSym))(void){
690   sqlite3_vfs *pVfs = (sqlite3_vfs *)pCfVfs->pAppData;
691   return pVfs->xDlSym(pVfs, pH, zSym);
692 }
693 static void cfDlClose(sqlite3_vfs *pCfVfs, void *pHandle){
694   sqlite3_vfs *pVfs = (sqlite3_vfs *)pCfVfs->pAppData;
695   pVfs->xDlClose(pVfs, pHandle);
696 }
697 static int cfRandomness(sqlite3_vfs *pCfVfs, int nByte, char *zBufOut){
698   sqlite3_vfs *pVfs = (sqlite3_vfs *)pCfVfs->pAppData;
699   return pVfs->xRandomness(pVfs, nByte, zBufOut);
700 }
701 static int cfSleep(sqlite3_vfs *pCfVfs, int nMicro){
702   sqlite3_vfs *pVfs = (sqlite3_vfs *)pCfVfs->pAppData;
703   return pVfs->xSleep(pVfs, nMicro);
704 }
705 static int cfCurrentTime(sqlite3_vfs *pCfVfs, double *pTimeOut){
706   sqlite3_vfs *pVfs = (sqlite3_vfs *)pCfVfs->pAppData;
707   return pVfs->xCurrentTime(pVfs, pTimeOut);
708 }
709 
710 static int processDevSymArgs(
711   Tcl_Interp *interp,
712   int objc,
713   Tcl_Obj *CONST objv[],
714   int *piDeviceChar,
715   int *piSectorSize
716 ){
717   struct DeviceFlag {
718     char *zName;
719     int iValue;
720   } aFlag[] = {
721     { "atomic",              SQLITE_IOCAP_ATOMIC                },
722     { "atomic512",           SQLITE_IOCAP_ATOMIC512             },
723     { "atomic1k",            SQLITE_IOCAP_ATOMIC1K              },
724     { "atomic2k",            SQLITE_IOCAP_ATOMIC2K              },
725     { "atomic4k",            SQLITE_IOCAP_ATOMIC4K              },
726     { "atomic8k",            SQLITE_IOCAP_ATOMIC8K              },
727     { "atomic16k",           SQLITE_IOCAP_ATOMIC16K             },
728     { "atomic32k",           SQLITE_IOCAP_ATOMIC32K             },
729     { "atomic64k",           SQLITE_IOCAP_ATOMIC64K             },
730     { "sequential",          SQLITE_IOCAP_SEQUENTIAL            },
731     { "safe_append",         SQLITE_IOCAP_SAFE_APPEND           },
732     { "powersafe_overwrite", SQLITE_IOCAP_POWERSAFE_OVERWRITE   },
733     { 0, 0 }
734   };
735 
736   int i;
737   int iDc = 0;
738   int iSectorSize = 0;
739   int setSectorsize = 0;
740   int setDeviceChar = 0;
741 
742   for(i=0; i<objc; i+=2){
743     int nOpt;
744     char *zOpt = Tcl_GetStringFromObj(objv[i], &nOpt);
745 
746     if( (nOpt>11 || nOpt<2 || strncmp("-sectorsize", zOpt, nOpt))
747      && (nOpt>16 || nOpt<2 || strncmp("-characteristics", zOpt, nOpt))
748     ){
749       Tcl_AppendResult(interp,
750         "Bad option: \"", zOpt,
751         "\" - must be \"-characteristics\" or \"-sectorsize\"", 0
752       );
753       return TCL_ERROR;
754     }
755     if( i==objc-1 ){
756       Tcl_AppendResult(interp, "Option requires an argument: \"", zOpt, "\"",0);
757       return TCL_ERROR;
758     }
759 
760     if( zOpt[1]=='s' ){
761       if( Tcl_GetIntFromObj(interp, objv[i+1], &iSectorSize) ){
762         return TCL_ERROR;
763       }
764       setSectorsize = 1;
765     }else{
766       int j;
767       Tcl_Obj **apObj;
768       int nObj;
769       if( Tcl_ListObjGetElements(interp, objv[i+1], &nObj, &apObj) ){
770         return TCL_ERROR;
771       }
772       for(j=0; j<nObj; j++){
773         int rc;
774         int iChoice;
775         Tcl_Obj *pFlag = Tcl_DuplicateObj(apObj[j]);
776         Tcl_IncrRefCount(pFlag);
777         Tcl_UtfToLower(Tcl_GetString(pFlag));
778 
779         rc = Tcl_GetIndexFromObjStruct(
780             interp, pFlag, aFlag, sizeof(aFlag[0]), "no such flag", 0, &iChoice
781         );
782         Tcl_DecrRefCount(pFlag);
783         if( rc ){
784           return TCL_ERROR;
785         }
786 
787         iDc |= aFlag[iChoice].iValue;
788       }
789       setDeviceChar = 1;
790     }
791   }
792 
793   if( setDeviceChar ){
794     *piDeviceChar = iDc;
795   }
796   if( setSectorsize ){
797     *piSectorSize = iSectorSize;
798   }
799 
800   return TCL_OK;
801 }
802 
803 /*
804 ** tclcmd:   sqlite_crash_enable ENABLE
805 **
806 ** Parameter ENABLE must be a boolean value. If true, then the "crash"
807 ** vfs is added to the system. If false, it is removed.
808 */
809 static int crashEnableCmd(
810   void * clientData,
811   Tcl_Interp *interp,
812   int objc,
813   Tcl_Obj *CONST objv[]
814 ){
815   int isEnable;
816   static sqlite3_vfs crashVfs = {
817     2,                  /* iVersion */
818     0,                  /* szOsFile */
819     0,                  /* mxPathname */
820     0,                  /* pNext */
821     "crash",            /* zName */
822     0,                  /* pAppData */
823 
824     cfOpen,               /* xOpen */
825     cfDelete,             /* xDelete */
826     cfAccess,             /* xAccess */
827     cfFullPathname,       /* xFullPathname */
828     cfDlOpen,             /* xDlOpen */
829     cfDlError,            /* xDlError */
830     cfDlSym,              /* xDlSym */
831     cfDlClose,            /* xDlClose */
832     cfRandomness,         /* xRandomness */
833     cfSleep,              /* xSleep */
834     cfCurrentTime,        /* xCurrentTime */
835     0,                    /* xGetlastError */
836     0,                    /* xCurrentTimeInt64 */
837   };
838 
839   if( objc!=2 ){
840     Tcl_WrongNumArgs(interp, 1, objv, "ENABLE");
841     return TCL_ERROR;
842   }
843 
844   if( Tcl_GetBooleanFromObj(interp, objv[1], &isEnable) ){
845     return TCL_ERROR;
846   }
847 
848   if( (isEnable && crashVfs.pAppData) || (!isEnable && !crashVfs.pAppData) ){
849     return TCL_OK;
850   }
851 
852   if( crashVfs.pAppData==0 ){
853     sqlite3_vfs *pOriginalVfs = sqlite3_vfs_find(0);
854     crashVfs.mxPathname = pOriginalVfs->mxPathname;
855     crashVfs.pAppData = (void *)pOriginalVfs;
856     crashVfs.szOsFile = sizeof(CrashFile) + pOriginalVfs->szOsFile;
857     sqlite3_vfs_register(&crashVfs, 0);
858   }else{
859     crashVfs.pAppData = 0;
860     sqlite3_vfs_unregister(&crashVfs);
861   }
862 
863   return TCL_OK;
864 }
865 
866 /*
867 ** tclcmd:   sqlite_crashparams ?OPTIONS? DELAY CRASHFILE
868 **
869 ** This procedure implements a TCL command that enables crash testing
870 ** in testfixture.  Once enabled, crash testing cannot be disabled.
871 **
872 ** Available options are "-characteristics" and "-sectorsize". Both require
873 ** an argument. For -sectorsize, this is the simulated sector size in
874 ** bytes. For -characteristics, the argument must be a list of io-capability
875 ** flags to simulate. Valid flags are "atomic", "atomic512", "atomic1K",
876 ** "atomic2K", "atomic4K", "atomic8K", "atomic16K", "atomic32K",
877 ** "atomic64K", "sequential" and "safe_append".
878 **
879 ** Example:
880 **
881 **   sqlite_crashparams -sect 1024 -char {atomic sequential} ./test.db 1
882 **
883 */
884 static int crashParamsObjCmd(
885   void * clientData,
886   Tcl_Interp *interp,
887   int objc,
888   Tcl_Obj *CONST objv[]
889 ){
890   int iDelay;
891   const char *zCrashFile;
892   int nCrashFile, iDc, iSectorSize;
893 
894   iDc = -1;
895   iSectorSize = -1;
896 
897   if( objc<3 ){
898     Tcl_WrongNumArgs(interp, 1, objv, "?OPTIONS? DELAY CRASHFILE");
899     goto error;
900   }
901 
902   zCrashFile = Tcl_GetStringFromObj(objv[objc-1], &nCrashFile);
903   if( nCrashFile>=sizeof(g.zCrashFile) ){
904     Tcl_AppendResult(interp, "Filename is too long: \"", zCrashFile, "\"", 0);
905     goto error;
906   }
907   if( Tcl_GetIntFromObj(interp, objv[objc-2], &iDelay) ){
908     goto error;
909   }
910 
911   if( processDevSymArgs(interp, objc-3, &objv[1], &iDc, &iSectorSize) ){
912     return TCL_ERROR;
913   }
914 
915   if( iDc>=0 ){
916     g.iDeviceCharacteristics = iDc;
917   }
918   if( iSectorSize>=0 ){
919     g.iSectorSize = iSectorSize;
920   }
921 
922   g.iCrash = iDelay;
923   memcpy(g.zCrashFile, zCrashFile, nCrashFile+1);
924   sqlite3CrashTestEnable = 1;
925   return TCL_OK;
926 
927 error:
928   return TCL_ERROR;
929 }
930 
931 static int devSymObjCmd(
932   void * clientData,
933   Tcl_Interp *interp,
934   int objc,
935   Tcl_Obj *CONST objv[]
936 ){
937   void devsym_register(int iDeviceChar, int iSectorSize);
938 
939   int iDc = -1;
940   int iSectorSize = -1;
941 
942   if( processDevSymArgs(interp, objc-1, &objv[1], &iDc, &iSectorSize) ){
943     return TCL_ERROR;
944   }
945   devsym_register(iDc, iSectorSize);
946 
947   return TCL_OK;
948 }
949 
950 /*
951 ** tclcmd: register_jt_vfs ?-default? PARENT-VFS
952 */
953 static int jtObjCmd(
954   void * clientData,
955   Tcl_Interp *interp,
956   int objc,
957   Tcl_Obj *CONST objv[]
958 ){
959   int jt_register(char *, int);
960   char *zParent = 0;
961 
962   if( objc!=2 && objc!=3 ){
963     Tcl_WrongNumArgs(interp, 1, objv, "?-default? PARENT-VFS");
964     return TCL_ERROR;
965   }
966   zParent = Tcl_GetString(objv[1]);
967   if( objc==3 ){
968     if( strcmp(zParent, "-default") ){
969       Tcl_AppendResult(interp,
970           "bad option \"", zParent, "\": must be -default", 0
971       );
972       return TCL_ERROR;
973     }
974     zParent = Tcl_GetString(objv[2]);
975   }
976 
977   if( !(*zParent) ){
978     zParent = 0;
979   }
980   if( jt_register(zParent, objc==3) ){
981     Tcl_AppendResult(interp, "Error in jt_register", 0);
982     return TCL_ERROR;
983   }
984 
985   return TCL_OK;
986 }
987 
988 /*
989 ** tclcmd: unregister_jt_vfs
990 */
991 static int jtUnregisterObjCmd(
992   void * clientData,
993   Tcl_Interp *interp,
994   int objc,
995   Tcl_Obj *CONST objv[]
996 ){
997   void jt_unregister(void);
998 
999   if( objc!=1 ){
1000     Tcl_WrongNumArgs(interp, 1, objv, "");
1001     return TCL_ERROR;
1002   }
1003 
1004   jt_unregister();
1005   return TCL_OK;
1006 }
1007 
1008 #endif /* SQLITE_OMIT_DISKIO */
1009 
1010 /*
1011 ** This procedure registers the TCL procedures defined in this file.
1012 */
1013 int Sqlitetest6_Init(Tcl_Interp *interp){
1014 #ifndef SQLITE_OMIT_DISKIO
1015   Tcl_CreateObjCommand(interp, "sqlite3_crash_enable", crashEnableCmd, 0, 0);
1016   Tcl_CreateObjCommand(interp, "sqlite3_crashparams", crashParamsObjCmd, 0, 0);
1017   Tcl_CreateObjCommand(interp, "sqlite3_simulate_device", devSymObjCmd, 0, 0);
1018   Tcl_CreateObjCommand(interp, "register_jt_vfs", jtObjCmd, 0, 0);
1019   Tcl_CreateObjCommand(interp, "unregister_jt_vfs", jtUnregisterObjCmd, 0, 0);
1020 #endif
1021   return TCL_OK;
1022 }
1023 
1024 #endif /* SQLITE_TEST */
1025