Some assets are orphans

[spiral cradle]

Hi, so I had some corruption in my library, mainly the photos named Full size render(it's an IOS thing), and I managed to clear most of the issues(deleted assets or corrupted files)
Now in admin panel, the repair section shows three assets that are offline. I checked and there is no sign of the files in the directory, and they aren't in the library too.
I just want to clean it, but I don't really know how. I'm guessing the next step is removing them from DB?
Here is a JSON export of missing assets:

[
    {
        "entityId": "67898113-3088-4a00-9f0c-e8245a31fb2f",
        "entityType": "asset",
        "checksum": "mxL6Ejg7FKGRxBIZwmBjF+P+fEM=",
        "pathType": "original",
        "pathValue": "/usr/src/app/upload/library/1e0404d7-12c0-4dcf-8fcc-b4b739828176/2023/2023-02-12/FullSizeRender+1.mov"
    },
    {
        "entityId": "acf60cb0-2471-4abd-8dae-06dcae862a6d",
        "entityType": "asset",
        "checksum": "kV72W/QJpb7Oz7W+ID4oL2Fsvz8=",
        "pathType": "original",
        "pathValue": "/usr/src/app/upload/library/1e0404d7-12c0-4dcf-8fcc-b4b739828176/2023/2023-02-10/FullSizeRender+5.mov"
    },
    {
        "entityId": "4023e1d8-ec05-4942-9fb0-267e88c49b1b",
        "entityType": "asset",
        "checksum": "l5KiXKINY/hJMOTddLY7JsdM7Dc=",
        "pathType": "original",
        "pathValue": "/usr/src/app/upload/library/1e0404d7-12c0-4dcf-8fcc-b4b739828176/2023/2023-02-09/FullSizeRender+3.mov"
    }
]

[wide rapids]

:wave: Hey @spiral cradle,

Thanks for reaching out to us. Please follow the recommended actions below; this will help us be more effective in our support effort and leave more time for building Immich :immich:.

References

• Container Logs: docker compose logs docs
• Container Status: docker compose ps docs
• Reverse Proxy: https://immich.app/docs/administration/reverse-proxy

Checklist

1. :ballot_box_with_check: I have verified I'm on the latest release(note that mobile app releases may take some time).
2. :ballot_box_with_check: I have read applicable release notes.
3. :ballot_box_with_check: I have reviewed the FAQs for known issues.
4. :ballot_box_with_check: I have reviewed Github for known issues.
5. :ballot_box_with_check: I have tried accessing Immich via local ip (without a custom reverse proxy).
6. :ballot_box_with_check: I have uploaded the relevant logs, docker compose, and .env files using the buttons below or the /upload command.
7. :ballot_box_with_check: I have tried an incognito window, disabled extensions, cleared mobile app cache, logged out and back in, different browsers, etc. as applicable

(an item can be marked as "complete" by reacting with the appropriate number)

If this ticket can be closed you can use the /close command, and re-open it later if needed.

[slow pivot]

I assume you have had Immich running for a while?

[spiral cradle]

Yes, as I remember there was a fix regarding FullSizeRender recently,
but I've been using it for some time now

[wide rapids]

Successfully submitted, a tag has been added to inform contributors. :white_check_mark:

[slow pivot]

Yeah the fix was some months ago

[spiral cradle]

It was in October 2023, I was definitely using Immich before that

[slow pivot]

The only way to clear them now is to find those assets in the asset table in the database and remove those entries

[spiral cradle]

is it in assets table perhaps?

[slow pivot]

Yes it is

Search for originalPath

[spiral cradle]

Alright, that did it

Thanks!