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