Re: [sqlite] Database malformed with SQLite3.3.17 on WindowsXP
I sure am glad I converted all SQL to use a BEGIN EXCLUSIVE. For some reason it struck me as odd that a SQL select could get a SQLITE_BUSY or even after you perform a single insert operation that a SQLITE_BUSY could later be thrown. Is it the delayed mechanism of the Pager Layer that provides locking upon a cache spill that causes this? I still think it should be possible to implement, multi readers and a single concurrent writer. I just don't see how though given the requirement that a reader can get sqlite_busy for a select statement. Will the new version 3.4.0 resolve this problem? Thanks Ken
Re: [sqlite] Database malformed with SQLite3.3.17 on WindowsXP
Hello drh and lists, Thank you for the information provided at the ticket page at http://www.sqlite.org/cvstrac/tktview?tn=2409 Now I successfully worked around the problem. -- tamagawa ryuji [EMAIL PROTECTED] : > "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: >> I've opened a new ticket 2409. >> >> http://www.sqlite.org/cvstrac/tktview?tn=2409,38 >> > > I am so far unable to reproduce the problem. Please send > me an example corrupt database and the binaries for > SQLiteCrush.exe. Tnx. > > You can send them to me by direct email if you want. > -- > D. Richard Hipp <[EMAIL PROTECTED]> > > > - > To unsubscribe, send email to [EMAIL PROTECTED] > - > > - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Database malformed with SQLite3.3.17 on WindowsXP
[EMAIL PROTECTED] wrote: > "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > > I've opened a new ticket 2409. > > > > http://www.sqlite.org/cvstrac/tktview?tn=2409,38 > > > > I am so far unable to reproduce the problem. Please send > me an example corrupt database and the binaries for > SQLiteCrush.exe. Tnx. > Never mind. We are able to reproduce the problem now -- D. Richard Hipp <[EMAIL PROTECTED]> - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Database malformed with SQLite3.3.17 on WindowsXP
"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > I've opened a new ticket 2409. > > http://www.sqlite.org/cvstrac/tktview?tn=2409,38 > I am so far unable to reproduce the problem. Please send me an example corrupt database and the binaries for SQLiteCrush.exe. Tnx. You can send them to me by direct email if you want. -- D. Richard Hipp <[EMAIL PROTECTED]> - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Database malformed with SQLite3.3.17 on WindowsXP
I've opened a new ticket 2409. http://www.sqlite.org/cvstrac/tktview?tn=2409,38 Also I found that it happenes from SQLite 3.3.9. -- tamagawa ryuji > 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] > - > > - To unsubscribe, send email to [EMAIL PROTECTED] -
RE: [sqlite] Database malformed with SQLite3.3.17 on WindowsXP
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] -
Re: [sqlite] Database malformed with SQLite3.3.17 on WindowsXP
=?iso-2022-jp?B?GyRCNkxAbhsoQiAbJEJONTtKIWMbKEJlLRskQiU9JWolZSE8JTcbKEI=?= =?iso-2022-jp?B?GyRCJWclczt2NkhJdDMrSC9JdDMrSC8yXSFkGyhC?= <[EMAIL PROTECTED]> wrote: > > 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. 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? > > 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". > [...] > > I'm ready to provide the code, the binary, the clean database and > the corrupted database file. > 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. -- D. Richard Hipp <[EMAIL PROTECTED]> - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] Database malformed with SQLite3.3.17 on WindowsXP
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] -