Photos Database Corruption

I’ve also already attempted a second database repair, but to no avail.

How do the missing photos appear:

They don’t. That’s the problem; the first indication that the photos were ever there is their appearances in albums on my iPad and old iPhone, which were synced immediately prior to my having performed the repair. The other, as previously mentioned, happens when I attempt to add them back into the library and get the “duplicate photos” dialog box and appropriate thumbnail.

Otherwise, no other indication of their existence appears within the Photos app. They do not appear; there’s no placeholder.

Where is you library located?

This behavior is consistent whether the library is in the standard location (~/Pictures/) or on an attached Thunderbolt RAID. I know this because I repaired the same library on two different machines (the first attempt being the former).

Are you running a "managed" or "reference" library?

Its configuration is the standard, recommended managed library.

How is your PHotos/iCloud preference pane configured?

I’m not using iCloud/Photo Stream at all for my photos.

This is the Masters directory within my Photos library.

If I look for images on that date, none of the ones in this directory (in fact, none of the ones in Masters/2016/10/) are there. If I search the Photos app for “IMG_0705,” it returns a number of similarly-named files, but not this specific one. If, however, I drop this file to import it into Photos, it asks me if I want to import a duplicate file, and it will show me an identical pair of thumbnails of this image.

…but it was there immediately before the database repair. Because I synced it to a couple of different iDevices before the repair, at least I know exactly which photos are missing from synced albums (if not the rest of the library).

1. Quit "Photos"
2. Back up your Photos Library
3. Control Click on your Photos library and delete the folder located at <library_bundle>/resources/recovery
4. Close the Photos Library bundle and double-click it to launch Photos
5. A new recovery folder will be created

Doing that—and rebuilding the database afterwards—garners the same result.