Unable to open catalog

[SAMouzon]

I've been getting an "unable to open catalog" error with the following description:

open_catalog failed: ["open_catalog: CILA::PROTO::RPCException/catalog_open_db failed: [\"catalog_open_db: Sequel::DatabaseError/SQLite3::CorruptException: database disk image is malformed\"]"]

Under Catalog Management I can click the down arrow and Maintenance is red at the bottom of the box, but all options within it are greyed out. When I Locate Existing Catalog, it's where it should be... nothing has changed about its location.

What should I do?

[Kirk Baker]

I've been getting an "unable to open catalog" error with the following description:

open_catalog failed: ["open_catalog: CILA::PROTO::RPCException/catalog_open_db failed: [\"catalog_open_db: Sequel::DatabaseError/SQLite3::CorruptException: database disk image is malformed\"]"]

Under Catalog Management I can click the down arrow and Maintenance is red at the bottom of the box, but all options within it are greyed out. When I Locate Existing Catalog, it's where it should be... nothing has changed about its location.

What should I do?

If you have a backup, restore it.  If not, there's likely not much that can be done to fix a corrupted database.

-Kirk

[SAMouzon]

I do have a Time Machine backup, and tried first to restore the entire folder, but it said some of the items had permissions issues. With a quarter million images, there's no realistic way to check them all, so then I wondered whether just restoring the catalog.pmdb file might work. At this point, it seems like maybe it has, but I'm waiting to let all the backed-up tasks run and then do a sync and see what I get. Will report back.

BTW, is there any realistic limit for number of images in a single catalog?

[Kirk Baker]

I do have a Time Machine backup, and tried first to restore the entire folder, but it said some of the items had permissions issues. With a quarter million images, there's no realistic way to check them all, so then I wondered whether just restoring the catalog.pmdb file might work. At this point, it seems like maybe it has, but I'm waiting to let all the backed-up tasks run and then do a sync and see what I get. Will report back.

BTW, is there any realistic limit for number of images in a single catalog?

No, no hard limits, though indexing gets slower as the catalog increases in number of images.  We developed with a target of one million images per catalog, but I've heard of a few users well over that number.

-Kirk