I got an error exactly same as this post described.
Followed the hint, sqlite3 open database,
command will echo a table named Z_PRIMARYKEY
- .schema Z_PRIMARYKEY
there is a column called Z_MAX with type INTEGER
- select * from Z_PRIMARYKEY;
remember this value.
- select max(Z_PK) from ZSTORE;
I got different max value, because I did some operation outside of iOS.
- update Z_PRIMARYKEY set Z_MAX=…;
Problem solved. My concern is, will this kind of error happen in production enviroment?