Re: [sqlite] PATCH ATTACHED: Re: sqlite assert failure in 2.8.15

2004-11-10 Thread Derrell . Lipman
"D. Richard Hipp" <[EMAIL PROTECTED]> writes: > [EMAIL PROTECTED] wrote: >> This presented itself with the following scenario: >> - sqlite_open() some unimportant database file >> - set PRAGMA SYNCHRONOUS=OFF >> - do some things that cause pPg->needSync to be true for some set of pages. >>t

Re: [sqlite] PATCH ATTACHED: Re: sqlite assert failure in 2.8.15

2004-11-09 Thread D. Richard Hipp
[EMAIL PROTECTED] wrote: This presented itself with the following scenario: - sqlite_open() some unimportant database file - set PRAGMA SYNCHRONOUS=OFF - do some things that cause pPg->needSync to be true for some set of pages. this will also have set pPager->needSync to be true. - ATTACH so

[sqlite] PATCH ATTACHED: Re: sqlite assert failure in 2.8.15

2004-11-09 Thread Derrell . Lipman
[EMAIL PROTECTED] writes: > I'm trying to track down an intermittent problem where the pager's needSync > flag is clear but one or more of the pages it points to have needSync==1. > The assert on pager.c:1237 is failing. This presented itself with the following scenario: - sqlite_open() some un