Immich for Android doesn't stop syncing, Postgres errors

Immich Version: v1.132.3 Reverse Proxy - Traefik v3.4.0 Hi, I've recently setup Immich (using docker compose method), it seems to work overall. I've connected the Android App to it, and it synced fine until it was almost over, then something weird started happening. Despite Remainder counter being 0, Immich is still uploading files, specifically videos, and each time it does that, the counter for Total decreases. Also, each time it finishes uploading these videos, a postgres error (from immich-server container) pops up (see log output from compose in the attached file). small snippet of the error:
error: PostgresError: duplicate key value violates unique constraint "UQ_assets_owner_checksum"
error: PostgresError: duplicate key value violates unique constraint "UQ_assets_owner_checksum"
Weirdly enough, servers stats don't match up: web admin interface says that 4834 photos and 196 videos are uploaded, when the phone says there 3375 in total (see screenshot). I am afraid I've triggered some obscure bug, because I had a weird situation - due to switching my phone to a different vendor that have different directory topology for storing photos and videos, I didn't realize that I had 2 Camera folders, one being inside another one (DCIM/Camera and DCIM/Camera/Camera, with duplicate contents (the outside Camera folder had photos from both the old and new phone, and the second Camera folder inside of it had only photos from the old phone). I initially configured Immich to back up from both, not realizing until it backed-up half of the photos library that DCIM/Camera folder had the same photos as the DCIM/Camera/Camera folder. So I moved DCIM/Camera/Camera into a different folder, it's no longer inside DCIM/Camera. I then returned to Immich, I selected the bigger Camera library (DCIM/Camera) for backup again, it did a re-evaluation and continued to back stuff up, up until I've encountered the issue I am currently facing. Let me know if I can provide any more information or whether it's worth opening a Github issue for this.
No description
No description
No description
13 Replies
Immich
Immich4w ago
:wave: Hey @Tannis Root, 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 - Container Logs: docker compose logs docs - Container Status: docker ps -a docs - Reverse Proxy: https://immich.app/docs/administration/reverse-proxy - Code Formatting https://support.discord.com/hc/en-us/articles/210298617-Markdown-Text-101-Chat-Formatting-Bold-Italic-Underline#h_01GY0DAKGXDEHE263BCAYEGFJA Checklist I have... 1. :blue_square: verified I'm on the latest release(note that mobile app releases may take some time). 2. :blue_square: read applicable release notes. 3. :blue_square: reviewed the FAQs for known issues. 4. :blue_square: reviewed Github for known issues. 5. :blue_square: tried accessing Immich via local ip (without a custom reverse proxy). 6. :blue_square: uploaded the relevant information (see below). 7. :blue_square: 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.
Tannis Root
Tannis RootOP4w ago
log file, discord didn't want to attach to the first message
schuhbacca
schuhbacca4w ago
Are you connected directly via IP:PORT to the server from the mobile app?
Tannis Root
Tannis RootOP4w ago
machine learning log
Tannis Root
Tannis RootOP4w ago
oh, forgot to include, I'm using a reverse proxy, traefik specifically (it's not internet facing atm)
schuhbacca
schuhbacca4w ago
Try connecting directly. It looks like it's timing out on the large video files. Also the counter in the mobile app is kind of broken right now
Tannis Root
Tannis RootOP4w ago
Oh, also, the library now has a bunch of exclamation point items now, just noticed:
No description
schuhbacca
schuhbacca4w ago
May need to sign in and out to fix that, mobile app sync is under heavy rework right now
Tannis Root
Tannis RootOP4w ago
unfortunately that did not help
schuhbacca
schuhbacca4w ago
Oh, the jobs are probably processing for those items. Can check progress on the website
Tannis Root
Tannis RootOP4w ago
it seems like only the photos from the old phone have these exclamation point duplicates nope, all are at 0 and none are active
schuhbacca
schuhbacca4w ago
Can you try pulling down twice on the timeline to rebuild the timeline? The issue with videos not upload is definitley your reverse proxy though. If an upload stalls, it will not just skip it and go to the next currenly
Tannis Root
Tannis RootOP4w ago
i'll try, thanks! pulling down a few times helped with the exclamation point ones Found the reason for dropped videos https://github.com/immich-app/immich/discussions/8872

Did you find this page helpful?