On Wed, Jan 11, 2012 at 2:12 PM, Jos Groot Lipman <donts...@home.nl> wrote:
> Interesting, I have got a database on a (cheap) thumbdrive that gets > corrupted as well. It has happened three times to me now. > > It is a tiny database (< 200 kB) behind a website and it is under very > little stress: perhaps 10 insert/update statements *per day*. > The website is running on a router with DD-WRT firmware installed and is > accessing the database through PHP with a SQLite modules (version 3.7.0 I > believe, slightly old). Other than the occacional crash it is running > perfectly. > I have backups of before (clean) and after the 10 inserts (corrupt) but > have > not been able to reproduce the problem no matter how hard I try. > Have you read the http://www.sqlite.org/howtocorrupt.html document? The second paragraph of section 3.1 in particular might be relevant to your situation. > -- > Jos Groot Lipman > > -----Original Message----- > From: sqlite-users-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Folkert van Heusden > Sent: woensdag 4 januari 2012 15:21 > To: sqlite-users@sqlite.org > Subject: [sqlite] /**** ERROR: (11) database disk image is malformed *****/ > > Hi, > > Occasionally my sqlite database (which recides on a jffs2 filesystem on a > nor flash) gets corrupt. Of course, I would like to fix that. > > While debugging such a corrupt database, I found the following: > Pgno: 2 > btreeInitPage: corrupt flag byte is: 01 > database corruption at line 49445 of [c7c6050ef0] line 49445 is: return > SQLITE_CORRUPT_BKPT (in decodeFlags) the line number is a little bit > offsetted due to added debug code I used version 3.7.9 to debug the > problem. > the program using sqlite is using 3.6.18. no triggers used. > I checked that the pagesize is 1024 bytes (with PRAGMA page_size;). > > What could be the cause of this? > - the system writing garbage to the flash disk? > - not all data being flushed correctly? (e.g. a partial write) > - bug in 3.6.18? > > If it helps I can give a hexdump of the first 3KB of the databasefile. > > > Thanks, > > Folkert van Heusden > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
