This discussion is locked
dixiesk
Level 1 (0 points)

Q: Aperture 3 rebuild library - SQLITE MISUSE

I'm trying to rebuild my Aperture 3 library that became corrupt when I accidentally unplugged external drive.

Rebuild library database hangs at 'Rebuild Library: Restoring Keywords'. After a day of running I forced-quit Aperture and now I'm trying again.. stuck at the same screen

I'm getting plenty of messages in Console - Database Searches:
Sender[PID]: Aperture
Message: NsExceptionHandler has recorded the following exception: SQLITE_MISUSE -- sqlite3_step

Does anybody have a fix for this?

Mid 2009 15" Macbook Pro, 2.53 GHz, 4GB, Mac OS X (10.6.3), it's 10.6.4 - you don't have it in your options above..

Posted on Jun 16, 2010 2:37 PM

Close
dixiesk

Q: Aperture 3 rebuild library - SQLITE MISUSE

  • All replies
  • Helpful answers

  • by dixiesk,

    dixiesk dixiesk Jun 16, 2010 3:12 PM in response to dixiesk
    Level 1 (0 points)
    Jun 16, 2010 3:12 PM in response to dixiesk
    error details:
    Jun 16 23:10:44 Macintosh Aperture[469]: NSExceptionHandler has recorded the following exception:\nSQLITE_MISUSE -- sqlite3_step\nStack trace: 0x7fff85ef9a2c 0x7fff805e80f3 0x7fff85b0fae7 0x7fff85b0fa74 0x10042fa7b 0x10026ce22 0x10047f472 0x100476e36 0x10047935c 0x100237e11 0x100454b1a 0x1004550e8 0x100460344 0x1004554a9 0x100063d60 0x100064b62 0x7fff85c8684e 0x7fff85ab7a90 0x7fff85aa4008 0x7fff85c7d7b8 0x7fff86637832 0x7fff86637767 0x7fff86835ddc 0x7fff86702421 0x7fff85cb514a 0x7fff85cb4f7a 0x7fff824bd323 0x7fff824bd21c 0x7fff824bd123 0x7fff85ffb741 0x7fff86607481 0x7fff86606bed 0x1002ab22e 0x7fff865cc8d3 0x1019668a6 0x100002494 0x2
    Jun 16 23:11:14: --- last message repeated 81 times ---
    Jun 16 23:11:14 Macintosh Aperture[469]: NSExceptionHandler has recorded the following exception:\nSQLITE_MISUSE -- sqlite3_step\nStack trace: 0x7fff85ef9a2c 0x7fff805e80f3 0x7fff85b0fae7 0x7fff85b0fa74 0x10042fa7b 0x10026ce22 0x10047f472 0x100476e36 0x10047935c 0x100237e11 0x100454b1a 0x1004550e8 0x100460344 0x1004554a9 0x100063d60 0x100064b62 0x7fff85c8684e 0x7fff85ab7a90 0x7fff85aa4008 0x7fff85c7d7b8 0x7fff86637832 0x7fff86637767 0x7fff86835ddc 0x7fff86702421 0x7fff85cb514a 0x7fff85cb4f7a 0x7fff824bd323 0x7fff824bd21c 0x7fff824bd123 0x7fff85ffb741 0x7fff86607481 0x7fff86606bed 0x1002ab22e 0x7fff865cc8d3 0x1019668a6 0x100002494 0x2

  • by sizzling badger,

    sizzling badger sizzling badger Jun 17, 2010 12:41 AM in response to dixiesk
    Level 1 (95 points)
    Jun 17, 2010 12:41 AM in response to dixiesk
    restoring from your backup is probably the best option.

  • by Wes W.,

    Wes W. Wes W. Jun 17, 2010 4:13 AM in response to sizzling badger
    Level 2 (255 points)
    Jun 17, 2010 4:13 AM in response to sizzling badger
    ditto.

  • by dixiesk,

    dixiesk dixiesk Jun 17, 2010 12:27 PM in response to sizzling badger
    Level 1 (0 points)
    Jun 17, 2010 12:27 PM in response to sizzling badger
    I gave the Aperture rebuild 1 more day and when I got home I forced-quit it, moved Database/*.appdb, deleted Previews & Thumbnails and started another rebuild. Got a progress indicator '1/xy' and my library was restored in 10 minutes!

    Now I'll try to re-add faces & places ... perhaps I'll recover something

  • by Jeffrey Mays,

    Jeffrey Mays Jeffrey Mays Jun 19, 2010 4:51 AM in response to dixiesk
    Level 1 (0 points)
    Jun 19, 2010 4:51 AM in response to dixiesk
    I'm having the same problem. can you give me more details on your fix ?

  • by dixiesk,

    dixiesk dixiesk Jun 19, 2010 10:02 AM in response to Jeffrey Mays
    Level 1 (0 points)
    Jun 19, 2010 10:02 AM in response to Jeffrey Mays
    1/ locate your aperture library
    2/ right click it & choose 'show package contents'
    3/ open database/ folder
    4/ backup everything you see there (e.g. by copying to desktop/aperture-backup)
    5/ delete *.appdb and *.db (I've also seen people deleting previews / thumbnails)
    6/ cmd+option click on your library and choose rebuild library... if it's successful, you should see progress like 'x out of y' after few minutes. If not, kill it
    7/ copy your database part back (e.g. faces.db) to see if it works with your new library

    hope this helps

    good luck!

  • by Dag75,

    Dag75 Dag75 Jun 26, 2010 2:15 PM in response to dixiesk
    Level 1 (0 points)
    Jun 26, 2010 2:15 PM in response to dixiesk
    THANK YOU! This solved it (or at least it seems so, 15000+ versions restored so far)

  • by mreslow,

    mreslow mreslow Jul 16, 2010 12:58 PM in response to dixiesk
    Level 1 (0 points)
    Jul 16, 2010 12:58 PM in response to dixiesk
    Thanks. It worked. But it was a scary moment :=. Anyway thinking of Lightroom which works without building all images into a database

  • by sizzling badger,

    sizzling badger sizzling badger Jul 16, 2010 1:28 PM in response to mreslow
    Level 1 (95 points)
    Jul 16, 2010 1:28 PM in response to mreslow
    After making these manual changes to your library I would recommend you run a Repair Database to check that you have not caused any inconsistencies. Press and hold the Option and Command keys as you start Aperture. The Aperture Library First Aid dialog will appear.

  • by micmac79,

    micmac79 micmac79 Jul 20, 2010 2:18 AM in response to dixiesk
    Level 1 (0 points)
    Jul 20, 2010 2:18 AM in response to dixiesk
    This is the first time I've felt compelled to write into a forum. Just thought I should let you know that you are a bloody legend. I have been really struggling to get aperture up and running (this is the first, and hopefully last time it has collapsed). Thanks once again.

  • by dixiesk,

    dixiesk dixiesk Jul 29, 2010 1:21 PM in response to dixiesk
    Level 1 (0 points)
    Jul 29, 2010 1:21 PM in response to dixiesk
    glad I could help I was struggling myself..

    I'm really hoping Apple will fix all of these issues (and faces, places) in aperture.next

    lessons learnt: back up to more than 1 device, and buy crashplan / time machine