On 9 Jun 2010, at 9:48am, Wei Kai wrote:

> I have a problem here. As we know sqlite creates a journal every time a
> write transaction happens. On a flash file system, when a write to database
> failed because of the lack of enough disk spac

Sorry, but if your program crashes because you ran out of disk space, you're 
out of luck.  There's no way to have a program recover from the situation 
because you have no space to put the recovered information in.  You need an 
intelligent human to decide what can be deleted.

If you are concerned about this situation, make a file called 'wasteofspace' 
which takes up 10 kilobytes of space.  When you need emergency space to recover 
from a crash, delete this file.

Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to