On Fri, 2005-02-11 at 06:11 -0500, D. Richard Hipp wrote: > On Fri, 2005-02-11 at 10:29 +0200, Cariotoglou Mike wrote: > > 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 ? > > > > That seems possible. I just checked the code and it > looks like the schema cookie is not being incremented > after a VACUUM. I have to go get on an airplane now > so I don't have time to confirm this problem or fix > it right this moment, but I will look into it.
While on the airplane, I was able to reproduce the problem and confirm that it is possible to corrupt a database as described above. I've just checked in a tentative fix. After some more testing, I will do a new release, probably 3.1.2 (stable). -- D. Richard Hipp <[EMAIL PROTECTED]>