Re: Core Data SQLite store appears corrupted only when using migratePersistentStore

FROM : Jim Correia
DATE : Sun Jan 06 20:10:32 2008

On Jan 6, 2008, at 1:45 PM, Dave Fernandes wrote:

> I am trying to migrate a persistent store from SQLite to binary 
> type. The SQLite store seems to be working OK -- I can read, edit 
> and write files -- however, when I try to migrate a know "good" 
> file, I get an error.


[...]

> Can anyone shed some light on why the file only appears to be 
> corrupted when I try to migrate it?


If the file is corrupt (as opposed to a misleading error message), 
migrating would be more likely to expose the problem since it reads 
every nook and cranny of the file whereas your typical fetch/insert/
update does not.

You can use the sqlite3 command line tool with "pragma 
integrity_check;" to find out whether sqlite thinks the file is 
corrupt or not.

Jim