[sqlite] empty page corrupt

2016-02-15 Thread sanhua.zh 
Yeah, but I don?t know how to debug it. I follow the howtocorrupt.html 
suggestion but nothing helpful.
I write in Objective-C. all sqlite relative operation isencapsulated by 
Objective-C and thread mutex.



???:Simon Slavinslavins at bigfraud.org
???:SQLite mailing listsqlite-users 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 or programming 
error. SQLite does not corrupt databases that way. What language are you 
programming in ? Simon. ___ 
sqlite-users mailing list sqlite-users at mailinglists.sqlite.org 
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[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 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 
___ sqlite-users mailing list 
sqlite-users at mailinglists.sqlite.org 
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[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?


Here is some info,
1. this db is in WAL mode
2. 4% cause corrupt ( from the online data)
3. this db is used for fts
4. I think all db relative operation is locked well

[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 programming 
in ?

Simon.

[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