• Home
  • Line#
  • Scopes#
  • Navigate#
  • Raw
  • Download
1 /*
2 ** 2009 January 28
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 ** This file contains the implementation of the sqlite3_backup_XXX()
13 ** API functions and the related features.
14 */
15 #include "sqliteInt.h"
16 #include "btreeInt.h"
17 
18 /* Macro to find the minimum of two numeric values.
19 */
20 #ifndef MIN
21 # define MIN(x,y) ((x)<(y)?(x):(y))
22 #endif
23 
24 /*
25 ** Structure allocated for each backup operation.
26 */
27 struct sqlite3_backup {
28   sqlite3* pDestDb;        /* Destination database handle */
29   Btree *pDest;            /* Destination b-tree file */
30   u32 iDestSchema;         /* Original schema cookie in destination */
31   int bDestLocked;         /* True once a write-transaction is open on pDest */
32 
33   Pgno iNext;              /* Page number of the next source page to copy */
34   sqlite3* pSrcDb;         /* Source database handle */
35   Btree *pSrc;             /* Source b-tree file */
36 
37   int rc;                  /* Backup process error code */
38 
39   /* These two variables are set by every call to backup_step(). They are
40   ** read by calls to backup_remaining() and backup_pagecount().
41   */
42   Pgno nRemaining;         /* Number of pages left to copy */
43   Pgno nPagecount;         /* Total number of pages to copy */
44 
45   int isAttached;          /* True once backup has been registered with pager */
46   sqlite3_backup *pNext;   /* Next backup associated with source pager */
47 };
48 
49 /*
50 ** THREAD SAFETY NOTES:
51 **
52 **   Once it has been created using backup_init(), a single sqlite3_backup
53 **   structure may be accessed via two groups of thread-safe entry points:
54 **
55 **     * Via the sqlite3_backup_XXX() API function backup_step() and
56 **       backup_finish(). Both these functions obtain the source database
57 **       handle mutex and the mutex associated with the source BtShared
58 **       structure, in that order.
59 **
60 **     * Via the BackupUpdate() and BackupRestart() functions, which are
61 **       invoked by the pager layer to report various state changes in
62 **       the page cache associated with the source database. The mutex
63 **       associated with the source database BtShared structure will always
64 **       be held when either of these functions are invoked.
65 **
66 **   The other sqlite3_backup_XXX() API functions, backup_remaining() and
67 **   backup_pagecount() are not thread-safe functions. If they are called
68 **   while some other thread is calling backup_step() or backup_finish(),
69 **   the values returned may be invalid. There is no way for a call to
70 **   BackupUpdate() or BackupRestart() to interfere with backup_remaining()
71 **   or backup_pagecount().
72 **
73 **   Depending on the SQLite configuration, the database handles and/or
74 **   the Btree objects may have their own mutexes that require locking.
75 **   Non-sharable Btrees (in-memory databases for example), do not have
76 **   associated mutexes.
77 */
78 
79 /*
80 ** Return a pointer corresponding to database zDb (i.e. "main", "temp")
81 ** in connection handle pDb. If such a database cannot be found, return
82 ** a NULL pointer and write an error message to pErrorDb.
83 **
84 ** If the "temp" database is requested, it may need to be opened by this
85 ** function. If an error occurs while doing so, return 0 and write an
86 ** error message to pErrorDb.
87 */
findBtree(sqlite3 * pErrorDb,sqlite3 * pDb,const char * zDb)88 static Btree *findBtree(sqlite3 *pErrorDb, sqlite3 *pDb, const char *zDb){
89   int i = sqlite3FindDbName(pDb, zDb);
90 
91   if( i==1 ){
92     Parse *pParse;
93     int rc = 0;
94     pParse = sqlite3StackAllocZero(pErrorDb, sizeof(*pParse));
95     if( pParse==0 ){
96       sqlite3Error(pErrorDb, SQLITE_NOMEM, "out of memory");
97       rc = SQLITE_NOMEM;
98     }else{
99       pParse->db = pDb;
100       if( sqlite3OpenTempDatabase(pParse) ){
101         sqlite3Error(pErrorDb, pParse->rc, "%s", pParse->zErrMsg);
102         rc = SQLITE_ERROR;
103       }
104       sqlite3DbFree(pErrorDb, pParse->zErrMsg);
105       sqlite3StackFree(pErrorDb, pParse);
106     }
107     if( rc ){
108       return 0;
109     }
110   }
111 
112   if( i<0 ){
113     sqlite3Error(pErrorDb, SQLITE_ERROR, "unknown database %s", zDb);
114     return 0;
115   }
116 
117   return pDb->aDb[i].pBt;
118 }
119 
120 /*
121 ** Attempt to set the page size of the destination to match the page size
122 ** of the source.
123 */
setDestPgsz(sqlite3_backup * p)124 static int setDestPgsz(sqlite3_backup *p){
125   int rc;
126   rc = sqlite3BtreeSetPageSize(p->pDest,sqlite3BtreeGetPageSize(p->pSrc),-1,0);
127   return rc;
128 }
129 
130 /*
131 ** Create an sqlite3_backup process to copy the contents of zSrcDb from
132 ** connection handle pSrcDb to zDestDb in pDestDb. If successful, return
133 ** a pointer to the new sqlite3_backup object.
134 **
135 ** If an error occurs, NULL is returned and an error code and error message
136 ** stored in database handle pDestDb.
137 */
sqlite3_backup_init(sqlite3 * pDestDb,const char * zDestDb,sqlite3 * pSrcDb,const char * zSrcDb)138 sqlite3_backup *sqlite3_backup_init(
139   sqlite3* pDestDb,                     /* Database to write to */
140   const char *zDestDb,                  /* Name of database within pDestDb */
141   sqlite3* pSrcDb,                      /* Database connection to read from */
142   const char *zSrcDb                    /* Name of database within pSrcDb */
143 ){
144   sqlite3_backup *p;                    /* Value to return */
145 
146   /* Lock the source database handle. The destination database
147   ** handle is not locked in this routine, but it is locked in
148   ** sqlite3_backup_step(). The user is required to ensure that no
149   ** other thread accesses the destination handle for the duration
150   ** of the backup operation.  Any attempt to use the destination
151   ** database connection while a backup is in progress may cause
152   ** a malfunction or a deadlock.
153   */
154   sqlite3_mutex_enter(pSrcDb->mutex);
155   sqlite3_mutex_enter(pDestDb->mutex);
156 
157   if( pSrcDb==pDestDb ){
158     sqlite3Error(
159         pDestDb, SQLITE_ERROR, "source and destination must be distinct"
160     );
161     p = 0;
162   }else {
163     /* Allocate space for a new sqlite3_backup object...
164     ** EVIDENCE-OF: R-64852-21591 The sqlite3_backup object is created by a
165     ** call to sqlite3_backup_init() and is destroyed by a call to
166     ** sqlite3_backup_finish(). */
167     p = (sqlite3_backup *)sqlite3_malloc(sizeof(sqlite3_backup));
168     if( !p ){
169       sqlite3Error(pDestDb, SQLITE_NOMEM, 0);
170     }
171   }
172 
173   /* If the allocation succeeded, populate the new object. */
174   if( p ){
175     memset(p, 0, sizeof(sqlite3_backup));
176     p->pSrc = findBtree(pDestDb, pSrcDb, zSrcDb);
177     p->pDest = findBtree(pDestDb, pDestDb, zDestDb);
178     p->pDestDb = pDestDb;
179     p->pSrcDb = pSrcDb;
180     p->iNext = 1;
181     p->isAttached = 0;
182 
183     if( 0==p->pSrc || 0==p->pDest || setDestPgsz(p)==SQLITE_NOMEM ){
184       /* One (or both) of the named databases did not exist or an OOM
185       ** error was hit.  The error has already been written into the
186       ** pDestDb handle.  All that is left to do here is free the
187       ** sqlite3_backup structure.
188       */
189       sqlite3_free(p);
190       p = 0;
191     }
192   }
193   if( p ){
194     p->pSrc->nBackup++;
195   }
196 
197   sqlite3_mutex_leave(pDestDb->mutex);
198   sqlite3_mutex_leave(pSrcDb->mutex);
199   return p;
200 }
201 
202 /*
203 ** Argument rc is an SQLite error code. Return true if this error is
204 ** considered fatal if encountered during a backup operation. All errors
205 ** are considered fatal except for SQLITE_BUSY and SQLITE_LOCKED.
206 */
isFatalError(int rc)207 static int isFatalError(int rc){
208   return (rc!=SQLITE_OK && rc!=SQLITE_BUSY && ALWAYS(rc!=SQLITE_LOCKED));
209 }
210 
211 /*
212 ** Parameter zSrcData points to a buffer containing the data for
213 ** page iSrcPg from the source database. Copy this data into the
214 ** destination database.
215 */
backupOnePage(sqlite3_backup * p,Pgno iSrcPg,const u8 * zSrcData)216 static int backupOnePage(sqlite3_backup *p, Pgno iSrcPg, const u8 *zSrcData){
217   Pager * const pDestPager = sqlite3BtreePager(p->pDest);
218   const int nSrcPgsz = sqlite3BtreeGetPageSize(p->pSrc);
219   int nDestPgsz = sqlite3BtreeGetPageSize(p->pDest);
220   const int nCopy = MIN(nSrcPgsz, nDestPgsz);
221   const i64 iEnd = (i64)iSrcPg*(i64)nSrcPgsz;
222 #ifdef SQLITE_HAS_CODEC
223   int nSrcReserve = sqlite3BtreeGetReserve(p->pSrc);
224   int nDestReserve = sqlite3BtreeGetReserve(p->pDest);
225 #endif
226 
227   int rc = SQLITE_OK;
228   i64 iOff;
229 
230   assert( p->bDestLocked );
231   assert( !isFatalError(p->rc) );
232   assert( iSrcPg!=PENDING_BYTE_PAGE(p->pSrc->pBt) );
233   assert( zSrcData );
234 
235   /* Catch the case where the destination is an in-memory database and the
236   ** page sizes of the source and destination differ.
237   */
238   if( nSrcPgsz!=nDestPgsz && sqlite3PagerIsMemdb(pDestPager) ){
239     rc = SQLITE_READONLY;
240   }
241 
242 #ifdef SQLITE_HAS_CODEC
243   /* Backup is not possible if the page size of the destination is changing
244   ** and a codec is in use.
245   */
246   if( nSrcPgsz!=nDestPgsz && sqlite3PagerGetCodec(pDestPager)!=0 ){
247     rc = SQLITE_READONLY;
248   }
249 
250   /* Backup is not possible if the number of bytes of reserve space differ
251   ** between source and destination.  If there is a difference, try to
252   ** fix the destination to agree with the source.  If that is not possible,
253   ** then the backup cannot proceed.
254   */
255   if( nSrcReserve!=nDestReserve ){
256     u32 newPgsz = nSrcPgsz;
257     rc = sqlite3PagerSetPagesize(pDestPager, &newPgsz, nSrcReserve);
258     if( rc==SQLITE_OK && newPgsz!=nSrcPgsz ) rc = SQLITE_READONLY;
259   }
260 #endif
261 
262   /* This loop runs once for each destination page spanned by the source
263   ** page. For each iteration, variable iOff is set to the byte offset
264   ** of the destination page.
265   */
266   for(iOff=iEnd-(i64)nSrcPgsz; rc==SQLITE_OK && iOff<iEnd; iOff+=nDestPgsz){
267     DbPage *pDestPg = 0;
268     Pgno iDest = (Pgno)(iOff/nDestPgsz)+1;
269     if( iDest==PENDING_BYTE_PAGE(p->pDest->pBt) ) continue;
270     if( SQLITE_OK==(rc = sqlite3PagerGet(pDestPager, iDest, &pDestPg))
271      && SQLITE_OK==(rc = sqlite3PagerWrite(pDestPg))
272     ){
273       const u8 *zIn = &zSrcData[iOff%nSrcPgsz];
274       u8 *zDestData = sqlite3PagerGetData(pDestPg);
275       u8 *zOut = &zDestData[iOff%nDestPgsz];
276 
277       /* Copy the data from the source page into the destination page.
278       ** Then clear the Btree layer MemPage.isInit flag. Both this module
279       ** and the pager code use this trick (clearing the first byte
280       ** of the page 'extra' space to invalidate the Btree layers
281       ** cached parse of the page). MemPage.isInit is marked
282       ** "MUST BE FIRST" for this purpose.
283       */
284       memcpy(zOut, zIn, nCopy);
285       ((u8 *)sqlite3PagerGetExtra(pDestPg))[0] = 0;
286     }
287     sqlite3PagerUnref(pDestPg);
288   }
289 
290   return rc;
291 }
292 
293 /*
294 ** If pFile is currently larger than iSize bytes, then truncate it to
295 ** exactly iSize bytes. If pFile is not larger than iSize bytes, then
296 ** this function is a no-op.
297 **
298 ** Return SQLITE_OK if everything is successful, or an SQLite error
299 ** code if an error occurs.
300 */
backupTruncateFile(sqlite3_file * pFile,i64 iSize)301 static int backupTruncateFile(sqlite3_file *pFile, i64 iSize){
302   i64 iCurrent;
303   int rc = sqlite3OsFileSize(pFile, &iCurrent);
304   if( rc==SQLITE_OK && iCurrent>iSize ){
305     rc = sqlite3OsTruncate(pFile, iSize);
306   }
307   return rc;
308 }
309 
310 /*
311 ** Register this backup object with the associated source pager for
312 ** callbacks when pages are changed or the cache invalidated.
313 */
attachBackupObject(sqlite3_backup * p)314 static void attachBackupObject(sqlite3_backup *p){
315   sqlite3_backup **pp;
316   assert( sqlite3BtreeHoldsMutex(p->pSrc) );
317   pp = sqlite3PagerBackupPtr(sqlite3BtreePager(p->pSrc));
318   p->pNext = *pp;
319   *pp = p;
320   p->isAttached = 1;
321 }
322 
323 /*
324 ** Copy nPage pages from the source b-tree to the destination.
325 */
sqlite3_backup_step(sqlite3_backup * p,int nPage)326 int sqlite3_backup_step(sqlite3_backup *p, int nPage){
327   int rc;
328   int destMode;       /* Destination journal mode */
329   int pgszSrc = 0;    /* Source page size */
330   int pgszDest = 0;   /* Destination page size */
331 
332   sqlite3_mutex_enter(p->pSrcDb->mutex);
333   sqlite3BtreeEnter(p->pSrc);
334   if( p->pDestDb ){
335     sqlite3_mutex_enter(p->pDestDb->mutex);
336   }
337 
338   rc = p->rc;
339   if( !isFatalError(rc) ){
340     Pager * const pSrcPager = sqlite3BtreePager(p->pSrc);     /* Source pager */
341     Pager * const pDestPager = sqlite3BtreePager(p->pDest);   /* Dest pager */
342     int ii;                            /* Iterator variable */
343     int nSrcPage = -1;                 /* Size of source db in pages */
344     int bCloseTrans = 0;               /* True if src db requires unlocking */
345 
346     /* If the source pager is currently in a write-transaction, return
347     ** SQLITE_BUSY immediately.
348     */
349     if( p->pDestDb && p->pSrc->pBt->inTransaction==TRANS_WRITE ){
350       rc = SQLITE_BUSY;
351     }else{
352       rc = SQLITE_OK;
353     }
354 
355     /* Lock the destination database, if it is not locked already. */
356     if( SQLITE_OK==rc && p->bDestLocked==0
357      && SQLITE_OK==(rc = sqlite3BtreeBeginTrans(p->pDest, 2))
358     ){
359       p->bDestLocked = 1;
360       sqlite3BtreeGetMeta(p->pDest, BTREE_SCHEMA_VERSION, &p->iDestSchema);
361     }
362 
363     /* If there is no open read-transaction on the source database, open
364     ** one now. If a transaction is opened here, then it will be closed
365     ** before this function exits.
366     */
367     if( rc==SQLITE_OK && 0==sqlite3BtreeIsInReadTrans(p->pSrc) ){
368       rc = sqlite3BtreeBeginTrans(p->pSrc, 0);
369       bCloseTrans = 1;
370     }
371 
372     /* Do not allow backup if the destination database is in WAL mode
373     ** and the page sizes are different between source and destination */
374     pgszSrc = sqlite3BtreeGetPageSize(p->pSrc);
375     pgszDest = sqlite3BtreeGetPageSize(p->pDest);
376     destMode = sqlite3PagerGetJournalMode(sqlite3BtreePager(p->pDest));
377     if( SQLITE_OK==rc && destMode==PAGER_JOURNALMODE_WAL && pgszSrc!=pgszDest ){
378       rc = SQLITE_READONLY;
379     }
380 
381     /* Now that there is a read-lock on the source database, query the
382     ** source pager for the number of pages in the database.
383     */
384     nSrcPage = (int)sqlite3BtreeLastPage(p->pSrc);
385     assert( nSrcPage>=0 );
386     for(ii=0; (nPage<0 || ii<nPage) && p->iNext<=(Pgno)nSrcPage && !rc; ii++){
387       const Pgno iSrcPg = p->iNext;                 /* Source page number */
388       if( iSrcPg!=PENDING_BYTE_PAGE(p->pSrc->pBt) ){
389         DbPage *pSrcPg;                             /* Source page object */
390         rc = sqlite3PagerGet(pSrcPager, iSrcPg, &pSrcPg);
391         if( rc==SQLITE_OK ){
392           rc = backupOnePage(p, iSrcPg, sqlite3PagerGetData(pSrcPg));
393           sqlite3PagerUnref(pSrcPg);
394         }
395       }
396       p->iNext++;
397     }
398     if( rc==SQLITE_OK ){
399       p->nPagecount = nSrcPage;
400       p->nRemaining = nSrcPage+1-p->iNext;
401       if( p->iNext>(Pgno)nSrcPage ){
402         rc = SQLITE_DONE;
403       }else if( !p->isAttached ){
404         attachBackupObject(p);
405       }
406     }
407 
408     /* Update the schema version field in the destination database. This
409     ** is to make sure that the schema-version really does change in
410     ** the case where the source and destination databases have the
411     ** same schema version.
412     */
413     if( rc==SQLITE_DONE
414      && (rc = sqlite3BtreeUpdateMeta(p->pDest,1,p->iDestSchema+1))==SQLITE_OK
415     ){
416       int nDestTruncate;
417 
418       if( p->pDestDb ){
419         sqlite3ResetInternalSchema(p->pDestDb, -1);
420       }
421 
422       /* Set nDestTruncate to the final number of pages in the destination
423       ** database. The complication here is that the destination page
424       ** size may be different to the source page size.
425       **
426       ** If the source page size is smaller than the destination page size,
427       ** round up. In this case the call to sqlite3OsTruncate() below will
428       ** fix the size of the file. However it is important to call
429       ** sqlite3PagerTruncateImage() here so that any pages in the
430       ** destination file that lie beyond the nDestTruncate page mark are
431       ** journalled by PagerCommitPhaseOne() before they are destroyed
432       ** by the file truncation.
433       */
434       assert( pgszSrc==sqlite3BtreeGetPageSize(p->pSrc) );
435       assert( pgszDest==sqlite3BtreeGetPageSize(p->pDest) );
436       if( pgszSrc<pgszDest ){
437         int ratio = pgszDest/pgszSrc;
438         nDestTruncate = (nSrcPage+ratio-1)/ratio;
439         if( nDestTruncate==(int)PENDING_BYTE_PAGE(p->pDest->pBt) ){
440           nDestTruncate--;
441         }
442       }else{
443         nDestTruncate = nSrcPage * (pgszSrc/pgszDest);
444       }
445       sqlite3PagerTruncateImage(pDestPager, nDestTruncate);
446 
447       if( pgszSrc<pgszDest ){
448         /* If the source page-size is smaller than the destination page-size,
449         ** two extra things may need to happen:
450         **
451         **   * The destination may need to be truncated, and
452         **
453         **   * Data stored on the pages immediately following the
454         **     pending-byte page in the source database may need to be
455         **     copied into the destination database.
456         */
457         const i64 iSize = (i64)pgszSrc * (i64)nSrcPage;
458         sqlite3_file * const pFile = sqlite3PagerFile(pDestPager);
459         i64 iOff;
460         i64 iEnd;
461 
462         assert( pFile );
463         assert( (i64)nDestTruncate*(i64)pgszDest >= iSize || (
464               nDestTruncate==(int)(PENDING_BYTE_PAGE(p->pDest->pBt)-1)
465            && iSize>=PENDING_BYTE && iSize<=PENDING_BYTE+pgszDest
466         ));
467 
468         /* This call ensures that all data required to recreate the original
469         ** database has been stored in the journal for pDestPager and the
470         ** journal synced to disk. So at this point we may safely modify
471         ** the database file in any way, knowing that if a power failure
472         ** occurs, the original database will be reconstructed from the
473         ** journal file.  */
474         rc = sqlite3PagerCommitPhaseOne(pDestPager, 0, 1);
475 
476         /* Write the extra pages and truncate the database file as required. */
477         iEnd = MIN(PENDING_BYTE + pgszDest, iSize);
478         for(
479           iOff=PENDING_BYTE+pgszSrc;
480           rc==SQLITE_OK && iOff<iEnd;
481           iOff+=pgszSrc
482         ){
483           PgHdr *pSrcPg = 0;
484           const Pgno iSrcPg = (Pgno)((iOff/pgszSrc)+1);
485           rc = sqlite3PagerGet(pSrcPager, iSrcPg, &pSrcPg);
486           if( rc==SQLITE_OK ){
487             u8 *zData = sqlite3PagerGetData(pSrcPg);
488             rc = sqlite3OsWrite(pFile, zData, pgszSrc, iOff);
489           }
490           sqlite3PagerUnref(pSrcPg);
491         }
492         if( rc==SQLITE_OK ){
493           rc = backupTruncateFile(pFile, iSize);
494         }
495 
496         /* Sync the database file to disk. */
497         if( rc==SQLITE_OK ){
498           rc = sqlite3PagerSync(pDestPager);
499         }
500       }else{
501         rc = sqlite3PagerCommitPhaseOne(pDestPager, 0, 0);
502       }
503 
504       /* Finish committing the transaction to the destination database. */
505       if( SQLITE_OK==rc
506        && SQLITE_OK==(rc = sqlite3BtreeCommitPhaseTwo(p->pDest, 0))
507       ){
508         rc = SQLITE_DONE;
509       }
510     }
511 
512     /* If bCloseTrans is true, then this function opened a read transaction
513     ** on the source database. Close the read transaction here. There is
514     ** no need to check the return values of the btree methods here, as
515     ** "committing" a read-only transaction cannot fail.
516     */
517     if( bCloseTrans ){
518       TESTONLY( int rc2 );
519       TESTONLY( rc2  = ) sqlite3BtreeCommitPhaseOne(p->pSrc, 0);
520       TESTONLY( rc2 |= ) sqlite3BtreeCommitPhaseTwo(p->pSrc, 0);
521       assert( rc2==SQLITE_OK );
522     }
523 
524     if( rc==SQLITE_IOERR_NOMEM ){
525       rc = SQLITE_NOMEM;
526     }
527     p->rc = rc;
528   }
529   if( p->pDestDb ){
530     sqlite3_mutex_leave(p->pDestDb->mutex);
531   }
532   sqlite3BtreeLeave(p->pSrc);
533   sqlite3_mutex_leave(p->pSrcDb->mutex);
534   return rc;
535 }
536 
537 /*
538 ** Release all resources associated with an sqlite3_backup* handle.
539 */
sqlite3_backup_finish(sqlite3_backup * p)540 int sqlite3_backup_finish(sqlite3_backup *p){
541   sqlite3_backup **pp;                 /* Ptr to head of pagers backup list */
542   sqlite3_mutex *mutex;                /* Mutex to protect source database */
543   int rc;                              /* Value to return */
544 
545   /* Enter the mutexes */
546   if( p==0 ) return SQLITE_OK;
547   sqlite3_mutex_enter(p->pSrcDb->mutex);
548   sqlite3BtreeEnter(p->pSrc);
549   mutex = p->pSrcDb->mutex;
550   if( p->pDestDb ){
551     sqlite3_mutex_enter(p->pDestDb->mutex);
552   }
553 
554   /* Detach this backup from the source pager. */
555   if( p->pDestDb ){
556     p->pSrc->nBackup--;
557   }
558   if( p->isAttached ){
559     pp = sqlite3PagerBackupPtr(sqlite3BtreePager(p->pSrc));
560     while( *pp!=p ){
561       pp = &(*pp)->pNext;
562     }
563     *pp = p->pNext;
564   }
565 
566   /* If a transaction is still open on the Btree, roll it back. */
567   sqlite3BtreeRollback(p->pDest);
568 
569   /* Set the error code of the destination database handle. */
570   rc = (p->rc==SQLITE_DONE) ? SQLITE_OK : p->rc;
571   sqlite3Error(p->pDestDb, rc, 0);
572 
573   /* Exit the mutexes and free the backup context structure. */
574   if( p->pDestDb ){
575     sqlite3_mutex_leave(p->pDestDb->mutex);
576   }
577   sqlite3BtreeLeave(p->pSrc);
578   if( p->pDestDb ){
579     /* EVIDENCE-OF: R-64852-21591 The sqlite3_backup object is created by a
580     ** call to sqlite3_backup_init() and is destroyed by a call to
581     ** sqlite3_backup_finish(). */
582     sqlite3_free(p);
583   }
584   sqlite3_mutex_leave(mutex);
585   return rc;
586 }
587 
588 /*
589 ** Return the number of pages still to be backed up as of the most recent
590 ** call to sqlite3_backup_step().
591 */
sqlite3_backup_remaining(sqlite3_backup * p)592 int sqlite3_backup_remaining(sqlite3_backup *p){
593   return p->nRemaining;
594 }
595 
596 /*
597 ** Return the total number of pages in the source database as of the most
598 ** recent call to sqlite3_backup_step().
599 */
sqlite3_backup_pagecount(sqlite3_backup * p)600 int sqlite3_backup_pagecount(sqlite3_backup *p){
601   return p->nPagecount;
602 }
603 
604 /*
605 ** This function is called after the contents of page iPage of the
606 ** source database have been modified. If page iPage has already been
607 ** copied into the destination database, then the data written to the
608 ** destination is now invalidated. The destination copy of iPage needs
609 ** to be updated with the new data before the backup operation is
610 ** complete.
611 **
612 ** It is assumed that the mutex associated with the BtShared object
613 ** corresponding to the source database is held when this function is
614 ** called.
615 */
sqlite3BackupUpdate(sqlite3_backup * pBackup,Pgno iPage,const u8 * aData)616 void sqlite3BackupUpdate(sqlite3_backup *pBackup, Pgno iPage, const u8 *aData){
617   sqlite3_backup *p;                   /* Iterator variable */
618   for(p=pBackup; p; p=p->pNext){
619     assert( sqlite3_mutex_held(p->pSrc->pBt->mutex) );
620     if( !isFatalError(p->rc) && iPage<p->iNext ){
621       /* The backup process p has already copied page iPage. But now it
622       ** has been modified by a transaction on the source pager. Copy
623       ** the new data into the backup.
624       */
625       int rc;
626       assert( p->pDestDb );
627       sqlite3_mutex_enter(p->pDestDb->mutex);
628       rc = backupOnePage(p, iPage, aData);
629       sqlite3_mutex_leave(p->pDestDb->mutex);
630       assert( rc!=SQLITE_BUSY && rc!=SQLITE_LOCKED );
631       if( rc!=SQLITE_OK ){
632         p->rc = rc;
633       }
634     }
635   }
636 }
637 
638 /*
639 ** Restart the backup process. This is called when the pager layer
640 ** detects that the database has been modified by an external database
641 ** connection. In this case there is no way of knowing which of the
642 ** pages that have been copied into the destination database are still
643 ** valid and which are not, so the entire process needs to be restarted.
644 **
645 ** It is assumed that the mutex associated with the BtShared object
646 ** corresponding to the source database is held when this function is
647 ** called.
648 */
sqlite3BackupRestart(sqlite3_backup * pBackup)649 void sqlite3BackupRestart(sqlite3_backup *pBackup){
650   sqlite3_backup *p;                   /* Iterator variable */
651   for(p=pBackup; p; p=p->pNext){
652     assert( sqlite3_mutex_held(p->pSrc->pBt->mutex) );
653     p->iNext = 1;
654   }
655 }
656 
657 #ifndef SQLITE_OMIT_VACUUM
658 /*
659 ** Copy the complete content of pBtFrom into pBtTo.  A transaction
660 ** must be active for both files.
661 **
662 ** The size of file pTo may be reduced by this operation. If anything
663 ** goes wrong, the transaction on pTo is rolled back. If successful, the
664 ** transaction is committed before returning.
665 */
sqlite3BtreeCopyFile(Btree * pTo,Btree * pFrom)666 int sqlite3BtreeCopyFile(Btree *pTo, Btree *pFrom){
667   int rc;
668   sqlite3_backup b;
669   sqlite3BtreeEnter(pTo);
670   sqlite3BtreeEnter(pFrom);
671 
672   /* Set up an sqlite3_backup object. sqlite3_backup.pDestDb must be set
673   ** to 0. This is used by the implementations of sqlite3_backup_step()
674   ** and sqlite3_backup_finish() to detect that they are being called
675   ** from this function, not directly by the user.
676   */
677   memset(&b, 0, sizeof(b));
678   b.pSrcDb = pFrom->db;
679   b.pSrc = pFrom;
680   b.pDest = pTo;
681   b.iNext = 1;
682 
683   /* 0x7FFFFFFF is the hard limit for the number of pages in a database
684   ** file. By passing this as the number of pages to copy to
685   ** sqlite3_backup_step(), we can guarantee that the copy finishes
686   ** within a single call (unless an error occurs). The assert() statement
687   ** checks this assumption - (p->rc) should be set to either SQLITE_DONE
688   ** or an error code.
689   */
690   sqlite3_backup_step(&b, 0x7FFFFFFF);
691   assert( b.rc!=SQLITE_OK );
692   rc = sqlite3_backup_finish(&b);
693   if( rc==SQLITE_OK ){
694     pTo->pBt->pageSizeFixed = 0;
695   }
696 
697   sqlite3BtreeLeave(pFrom);
698   sqlite3BtreeLeave(pTo);
699   return rc;
700 }
701 #endif /* SQLITE_OMIT_VACUUM */
702