[sqlite] Assert on pager state when using zipvfs

2015-03-27 Thread Dan Kennedy 
On 03/27/2015 08:19 PM, Alexandre Mainville wrote:
> Hi,
>
> Were are getting the following assert inside the
> sqlite3PagerWalFramesize when using zipvfs:
> assert( pPager->eState==PAGER_READER );
>
> Is this expected?
>
> Here are the steps to reproduce:
> begin transaction;
> create table test(id int, name text);
> insert into test values(, ); (I inserted a 100 rows like this)
> commit;
> delete from test where name like 'whatever';
>
> I attached the resulting file.

Hi Alex,

It's not expected. We will need more details to debug it though.

Can you post a stack trace at the assert() failure?

Which versions of SQLite and zipvfs are you using?

Are you able to reproduce this outside of a large application? Do you 
have example code?

Thanks,
Dan Kennedy.






>
> Thanks
>
> Alex
>
>
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Assert on pager state when using zipvfs

2015-03-27 Thread Alexandre Mainville 
Hi,

Were are getting the following assert inside the
sqlite3PagerWalFramesize when using zipvfs:
assert( pPager->eState==PAGER_READER );

Is this expected?

Here are the steps to reproduce:
begin transaction;
create table test(id int, name text);
insert into test values(, ); (I inserted a 100 rows like this)
commit;
delete from test where name like 'whatever';

I attached the resulting file.

Thanks

Alex