Re: [sqlite] When is corruption acceptable?

2010-11-19 Thread Dustin Sallings
On Nov 19, 2010, at 12:17, Pavel Ivanov wrote: >>1. When is it acceptable for sqlite to leave a corrupt database that >> can't be used? > > It's never acceptable. SQLite specifically written and tested to > manager "out of disk space" errors appropriately without database > corruption.

Re: [sqlite] When is corruption acceptable?

2010-11-19 Thread Pavel Ivanov
>        1. When is it acceptable for sqlite to leave a corrupt database that > can't be used? It's never acceptable. SQLite specifically written and tested to manager "out of disk space" errors appropriately without database corruption. >        I've got the data moved off to the side after it

Re: [sqlite] When is corruption acceptable?

2010-11-19 Thread Black, Michael (IS)
: Fri 11/19/2010 2:12 PM To: General Discussion of SQLite Database Subject: EXTERNAL:[sqlite] When is corruption acceptable? I have an application that was writing to a sqlite db until we ran out of disk space. The app failed to store data, commit, etc... and then was killed

[sqlite] When is corruption acceptable?

2010-11-19 Thread Dustin Sallings
I have an application that was writing to a sqlite db until we ran out of disk space. The app failed to store data, commit, etc... and then was killed. I've got the data moved off to the side after it broke. integrity check says this: *** in database main *** Main freelist: