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

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.

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 >

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

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.

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

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

[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)