[sqlite] empty page corrupt

2016-02-15 Thread sanhua.zh
at mailinglists.sqlite.org :2016?2?15?(??)?20:03 ??:Re: [sqlite] empty page corrupt On 15 Feb 2016, at 11:59am, sanhua.zh sanhua.zh at foxmail.com wrote: I did it on iOS. I already checked the howtocorrupt.html, but I can?t find anything helpful. This is almost always a result of hardware failure

[sqlite] empty page corrupt

2016-02-15 Thread sanhua.zh
I did it on iOS. I already checked the howtocorrupt.html, but I can?t find anything helpful. ???:Clemens Ladischclemens at ladisch.de ???:sqlite-userssqlite-users at mailinglists.sqlite.org :2016?2?15?(??)?18:42 ??:Re: [sqlite] empty page corrupt sanhua.zh wrote: I find some db

[sqlite] empty page corrupt

2016-02-15 Thread sanhua.zh
I find some db corrupted and try to find out the reason. After a simple analysis, I found that many of the db pages are empty, which means all bits in this page is zero. This is the reason causing sqlite report db corrupt. I don?t know why this happen, does someone have the same problem ever?

[sqlite] empty page corrupt

2016-02-15 Thread Simon Slavin
On 15 Feb 2016, at 11:59am, sanhua.zh wrote: > I did it on iOS. > I already checked the howtocorrupt.html, but I can?t find anything helpful. This is almost always a result of hardware failure or programming error. SQLite does not corrupt databases that way. What language are you

[sqlite] empty page corrupt

2016-02-15 Thread Clemens Ladisch
sanhua.zh wrote: > I find some db corrupted and try to find out the reason. Are you using a network file system or virtual machine? What type of disk? http://www.sqlite.org/howtocorrupt.html Regards, Clemens