Re: [sqlite] error 6410 after upgrade to 3.17.0 on android

2017-02-21 Thread Alexandre Mainville
6229 DEBUG SYSTEM_MALLOC TEMP_STORE=3 THREADSAFE=1 I'll double check everything is up to date tomorrow and try the .aar Thanks for your help *______* *ALEXANDRE MAINVILLE* Software Architect *iBwave* 7075, Robert-Joncas, Suite 95 Montreal, Quebec, H4M 2

[sqlite] error 6410 after upgrade to 3.17.0 on android

2017-02-21 Thread Alexandre Mainville
) at org.sqlite.database.sqlite.SQLiteDatabase.openDatabase(SQLiteDatabase.java:699) at org.sqlite.database.sqlite.SQLiteDatabase.openOrCreateDatabase(SQLiteDatabase.java:714) *__* *ALEXANDRE MAINVILLE* Software Architect

[sqlite] Database corruption using zipvfs on android 64 bits (x86_64)

2015-11-06 Thread Alexandre Mainville
Hi, I am experiencing database corruption using zipvfs on android 64 bits (x86_64). The same program executing on 32 bits runs without problems. The program creates a new database on every run and does a series of inserts and updates (always the same series of operations). Both programs produce

[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

[sqlite] Howto set lower pager page size when using zipvfs extension

2015-03-13 Thread Alexandre Mainville
Hi, When using the zipvfs extension, one can change the size for the upper pager using pragma page_size but how does one change the page size for the lower level pager. The zipvfs_block_size pragma does not seem to support setting the value. Thanks Alex