RE: [sqlite] Database malformed with SQLite3.3.17 on WindowsXP

[玉川 竜司＜e-ソリューシ ョン事業部開発部開発課＞]

Hi, Richard. Thank you for your very quick response.

>> 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.

>Does SQLiteCrush.exe continue running in the background
>while you are doing steps 2 and 3?  Or does SQLiteCrush.exe
>run to completion, then you do steps 2 and 3 separately?

It continue running in the background.


>The code for SQLiteCrush.exe and a clean database would be helpful.
>Binaries for SQLiteCrush.exe and a corruption database, not so much.
>
>Perhaps you can open a new ticket and include the code and database
>as an attachment.

I'm grad to do that.
--
tamagawa ryuji

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

[sqlite] Database malformed with SQLite3.3.17 on WindowsXP

[玉川 竜司＜e-ソリューシ ョン事業部開発部開発課＞]

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]
-