Re: [sqlite] SQLITE_IOERR and strange rollback when db is busy

2004-12-26 Thread Rolf Schaeuble
D. Richard Hipp wrote: Rolf Schaeuble wrote: There are other places in sqlite3pager_get where SQLITE_IOERR are returned; I've not checked whether these can also be triggered by the db being locked or if they indicate serious problem. If someone is interested, I can send a test case for this

Re: [sqlite] SQLITE_IOERR and strange rollback when db is busy

2004-12-26 Thread D. Richard Hipp
Rolf Schaeuble wrote: There are other places in sqlite3pager_get where SQLITE_IOERR are returned; I've not checked whether these can also be triggered by the db being locked or if they indicate serious problem. If someone is interested, I can send a test case for this problem. Please go to

[sqlite] SQLITE_IOERR and strange rollback when db is busy

2004-12-25 Thread Rolf Schaeuble
Hello, I stumbled over some quite strange case. Here's the easiest test case that triggers the behaviour: One process performs very long reads from a db (multiple joins, so the cartesian product is *very* large, and the reader needs a while to complete). Another process performs a "BEGIN