Hello Lists,

I encountered a problem with SQLite3.3.17 on Windows XP. Under certain 
situation, 
database file got seriously corrupted. 

SQLite version: 3.3.17 Windows Binary
Platform:Windows XP SP2(Japanese)
Code wrtten in: Visual C++ 6.0

Here are the procedures to reproduce the problem:

1) Run a program SQLiteCrush.exe.
   This program updates 'test.db' repeatedly. Insert data
   to work table, copy them into items table, then delete 
   records from work.

2) Open 'test.db' from sqlite3.exe.

3) Do '.read check.sql' repeatedly.
   check.sql is made from many lines of 'pragma integrity_check;'.

4) Keep doing 1 -3 for several minuites, and 'pragma integrity_check'
   starts to report something like 
   "rowid 91667 missing from index sqlite_autoindex_link_1".

So far, I didn't see the database corrupted with SQLite 3.3.7.
Also, without 3), the database was not corrupted. Instead of 
'pragma integrity_check', issueing many select statements also
make it currupted.
 
I'm ready to provide the code, the binary, the clean database and 
the corrupted database file.

Now, what can I do to fix this problem? 

Thanks in advance for any advice and suggestion.
--
tamagawa ryuji

-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------

  • [sq... 玉川 竜司<e-ソリューシ ョン事業部開発部開発課>
    • ... drh
      • ... 玉川 竜司<e-ソリューシ ョン事業部開発部開発課>

Reply via email to