2011/11/14 Alexandr Němec <a.ne...@atlas.cz> > Dear Filip, > > thanks for your reply. I thought that small attachments will go trough. If > I run > > sqlite3 data.db > pragma integrity_check; > > I receive this message only: > > Error: database disk image is malformed. > > Anyway, you can download the database here: http://www.u-consult.cz/db/** > server.db <http://www.u-consult.cz/db/server.db> >
This database file has been truncated. The last 6 pages (6144 bytes) are missing. > > No, WAL mode is not used. > > Thanks very much for your help. > > Alex > > ______________________________**______________________________**__ > >> Od: "Filip Navara" Komu: General Discussion of SQLite Database Datum: >> 14.11.2011 11:17 >> Předmět: Re: [sqlite] 3.7.7.1 database corruption >> >> Hi Alexandr, > > the mailing list doesn't allow attachments. Please send us the output > of "pragma integrity_check;" on the corrupted database file. Also, is > the database used in WAL mode? > > Best regards, > Filip Navara > > 2011/11/14 Alexandr Němec : > > Dear all, >> >> we are using SQLite in our projects. We are using the 3.7.7.1 version >> compiled on Windows platform from the amalgamation file. One of our >> servers >> crashed badly (power outage) and after the server restarted, we saw that >> the >> database was corrupt (all queries we tried return SQLITE_CORRUPT). We had >> a >> look at >> http://www.sqlite.org/**howtocorrupt.html<http://www.sqlite.org/howtocorrupt.html>and >> verified, that the >> hardware (disk, memory) of the server should be ok - we used some hardware >> tools to check. In the past we already had some crash situations and >> SQLite >> could recover from the crash nicely, so we were surprised that after this >> crash the database was corrupt. In fact, we cant create a repro, because >> we >> do not know, what the server was exactly doing, so it might be difficult >> to >> find the reason, but we saved the corrupted database in the hope, that >> somebody from the develpers (maybe) could put some light on this problem. >> Because the database is rather small and is used to save some >> configuration >> data only, I have att >> ached it to this message. >> >> Thanks for any suggestions. >> >> Alex >> >> >> >> ______________________________**_________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users<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<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
