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

FROM : Dave Fernandes
DATE : Sun Jan 06 20:40:12 2008

sqlite3 integrity_check says the file is "ok". I also tried vacuuming 
the file for good measure, but Core Data still can't migrate it. 
(Same error message as before.)


On Jan 6, 2008, at 2:10 PM, Jim Correia wrote:

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