On Oct 1, 2010, at 2:20 PM, Raj, Praveen wrote: > Hi, > > I'm validating SQLite test suite version 3.7.2 on QNX operating > system. I have built the testfixture using SQLite amalgation file > and other related files/libraries. > > I ran the full test suite and most of the test cases are passing, > except some run in journal_mode = WAL. Test cases whose > autocheckpoint is turned off and large amount of > data is being inserted without checkpointing are failing. Other WAL > tests are passing. I tried increasing the stack size of the > testfixture process, but that didn't help. > > If i reduce the number of inserts or increase the WAL page size, > test cases are passing. I believe there is some corruption happening > with the WAL index while > inserting large number of rows. Here is an example (from SQLite test > suite) of the failure > (Purposefully added "PRAGMA integrity_check" at end of wal3-1.0)
How large are the "test.db", "test.db-wal" and "test.db-shm" files on your system after the transaction in wal3-1.0? i.e. stick puts [file size test.db] puts [file size test.db-wal] puts [file size test.db-shm] or similar after the test case. Here the files are 1024, 4333512 and 65536 bytes. From what you are saying it sounds like the problem is occurring when the -shm file grows from 32KB to 64KB. Dan. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
