#API results not matching whats in database

1 messages · Page 1 of 1 (latest)

trim stratus
#

Does anyone have any idea while I see two rows when querying the database directly as per below:

FROM asset
WHERE "originalFileName" = '20220216_143303_79FC8348.mov';```

But when performing an API call to https://immich/api/search/metadata with:

```{
    "originalFileName": "20220216_143303_79FC8348.mov"
}```


I am getting 0 results:

```{
    "albums": {
        "total": 0,
        "count": 0,
        "items": [],
        "facets": []
    },
    "assets": {
        "total": 0,
        "count": 0,
        "items": [],
        "facets": [],
        "nextPage": null
    }
}```
wary rivetBOT
#

:wave: Hey @trim stratus,

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

References

#

Checklist

I have...

  1. :ballot_box_with_check: verified I'm on the latest release(note that mobile app releases may take some time).
  2. :ballot_box_with_check: read applicable release notes.
  3. :ballot_box_with_check: reviewed the FAQs for known issues.
  4. :blue_square: reviewed Github for known issues.
  5. :ballot_box_with_check: tried accessing Immich via local ip (without a custom reverse proxy).
  6. :blue_square: uploaded the relevant information (see below).
  7. :ballot_box_with_check: 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)

Information

In order to be able to effectively help you, we need you to provide clear information to show what the problem is. The exact details needed vary per case, but here is a list of things to consider:

  • Your docker-compose.yml and .env files.
  • Logs from all the containers and their status (see above).
  • All the troubleshooting steps you've tried so far.
  • Any recent changes you've made to Immich or your system.
  • Details about your system (both software/OS and hardware).
  • Details about your storage (filesystems, type of disks, output of commands like fdisk -l and df -h).
  • The version of the Immich server, mobile app, and other relevant pieces.
  • Any other information that you think might be relevant.

Please paste files and logs with proper code formatting, and especially avoid blurry screenshots.
Without the right information we can't work out what the problem is. Help us help you ;)

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

stuck tree
#

please show the full database output of those two rows you get

#

also please show the output of SELECT * from public.user;

#

also what permissions did you give your API key?

trim stratus
#

in database visibility = hidden, could that be it?

stuck tree
#

yep

trim stratus
#

what would cause that?

stuck tree
#

could be the video of a live photo

#

you should share all the queries I asked about if you want more info

trim stratus
#

To give more context of how I run into / found this issue:

  1. I have existing Immich instance with external library only, I want to change from 'external' to normal / default / internal library.
  2. To achieve this I navigated to folder of my external library and used immich cli import command
  3. Once everything had been imported I then wanted to ensure I didn't lose all my immich albums when I removed my external library
  4. I wrote a script that looped through all assets in albums, searched for the new asset and add new asset Id to album
  5. End result should be that all albums have an asset count of DOUBLE the original, effectively each asset in album would be duplicated, one from external library and one internal.
  6. A few albums had a couple of assets missing....the first one I found was for asset with file name '20220216_143303_79FC8348.heic'
  7. I used database and could only find 1 asset with file name '20220216_143303_79FC8348.mov' which was external library
  8. On my ubuntu instance I manually tried to import the file again but got the below:
Crawling for assets...
Hashing files           | ████████████████████████████████████████ | 100% | ETA: 0s | 1/1 assets
Checking for duplicates | ████████████████████████████████████████ | 100% | ETA: 0s | 1/1 assets
Found 0 new files and 1 duplicate
All assets were already uploaded, nothing to do.
{
    "newFiles": [],
    "duplicates": [
        {
            "id": "5e9710a9-6460-433b-8cef-80c8d4d515e6",
            "filepath": "/mnt/chamber/photoprism/originals/2022/02/20220216_143303_79FC8348.heic"
        }
    ],
    "newAssets": []
}```
9) I then got down this rabbit hole of fidning the file had been renamed to '.mov' and trying to figure out why......but maybe this isn't the case?
stuck tree
#

most likely a live photo based on what you said

#

they should have a heic + a mov for the motion

#

usually the same name

trim stratus
#

yes i have both

20220216_143303_79FC8348.heic  20220216_143303_79FC8348.mov   ```
#

when I run SELECT * FROM asset WHERE "originalFileName" = '20220216_143303_79FC8348.heic';

I only see the file from external library.....immich import CLI doesn't seem to import the .heic, I think because the checksum matches the same as .mov so it's seeing as duplicate

stuck tree
#

those two files should not have the same checksum, but tbh I do not know how we handle external live photos. I think they are only really supported via the app

#

anyway, that's definitely related to what is going on here just not sure how to piece it apart properly

trim stratus
# 
59cfd3535967471d07a53b5e9a8e6c0e08bf5cf1  20220216_143303_79FC8348.heic

jack@truenas-ubuntu-vm:/mnt/chamber/photoprism/originals/2022/02$ sha1sum 20220216_143303_79FC8348.mov
59cfd3535967471d07a53b5e9a8e6c0e08bf5cf1  20220216_143303_79FC8348.mov```
stuck tree
#

well that's just an issue with your source data sorry to say, that does not make any sense to me