On Wed, Apr 28, 2010 at 11:20 AM, Guillaume Duranceau < [email protected]> wrote:
> Hello all, > > I'm wondering why the EXCLUSIVE lock is not downgraded to a RESERVED lock > right after writing the dirty page into the DB. This doesn't seem to me as > an undoable task (the transition EXCLUSIVE->RESERVED would simply need to > be managed by xUnlock functions), but there might be technical/conceptual > reasons preventing to do so. What are your views on this ? > Doing so (downgrading the EXCLUSIVE lock) would allow other processes to see a partially committed transaction that could easily contain and inconsistent file structure, and would at the very least contain uncommitted data. > > Regards - Guillaume > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- --------------------- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
