It has been my experience that, when two processes have the same db open, and one of them does a VACUUM, and the other tries to update, The database gets corrupted. Not easy to simulate, but has happened at least twice, in fact it has been the only way I managed to corrupt a database. Comments, DRH ?
> -----Original Message----- > From: D. Richard Hipp [mailto:[EMAIL PROTECTED] > Sent: Thursday, February 10, 2005 12:14 AM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] VACUUM question > > On Wed, 2005-02-09 at 14:56 -0500, Luc Vandal wrote: > > if my app has a sqlite3* pointer to the database and > another app does > > a VACUUM on the same database, will the pointer still be valid? > > Yes. > > > > > > Also, what if, while doing a VACUUM, a query executes on > the database? > > Will it just fail? > > You will get SQLITE_BUSY. > -- > D. Richard Hipp <[EMAIL PROTECTED]> > > >
