Is it possible to repair the asset_job_status table?
Hi, unfortunately I have data corruption on this table. It's my fault for not paying attention to the notifications of failed database backups. I noticed the problem yesterday (10/20/25) and the problem started on (08/27/25). I have a proper database backup of that date, but I am wondering if there is a way to repair the databse so that I don't have to figure out which assets need to be uploaded.
About the issue: the handlers AssetDetectFaces, AssetExtractMetadata and AssetGenerateThumbnails raise Postgres notices with
message
message
key with a text like this: 'page verification failed, calculated checksum 4212 but expected 27694'
Since this table seems to be a collection of timestamps for each asset, I honestly don't mind re-running face detection, metadata extraction and thumbnail generation for everything on my library.