Aperture 3 rebuild library - SQLITE MISUSE

Question

Level 1

0 points

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

Reply

Answer 1

dixiesk Author

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

Reply

Answer 2

Jun 17, 2010 12:41 AM in response to dixiesk

restoring from your backup is probably the best option.

Reply

Answer 3

Wes W.

Level 2

255 points

Jun 17, 2010 4:13 AM in response to sizzling badger

ditto.

Reply

Answer 4

dixiesk Author

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

Reply

Answer 5

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 ?

Reply

Answer 6

dixiesk Author

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!

Reply

Answer 7

Dag75

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)

Reply

Answer 8

mreslow

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

Reply

Answer 9

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.

Reply

Answer 10

micmac79

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.

Reply

Answer 11

dixiesk Author

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

Reply