On Thu, Mar 31, 2011 at 3:48 PM, Richard Hipp <d...@sqlite.org> wrote:
> On Thu, Mar 31, 2011 at 4:44 PM, Dave White <dwh...@companioncorp.com>wrote:
>> Any ideas why this would happen?
>
> You have a read transaction being held open. The checkpoint cannot run to
> completion when there is a read transaction open. (It does as much as it
> can and quits.) The reason is that if it were to run to completion, it
> would delete content out from under the read transaction.
Maybe SQLite3 could track all the open read transactions (and zero or
one write transactions) so that their {PID, thread ID, hostname} can
be accessed via a pragma for checkpoint (and other) diagnostic
purposes?
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
