I
Immich•3d ago
Chaos

Unable to run job handler (AssetFileMigration): Error: write CONNECTION_DESTROYED 192.168.1.158:5432

I'm running v1.138.1 as addon in Home Assistant. I've noticed these errors in the log from time to time. Seems related to asset migration, but not sure why it fails or how to fix it.

message.txt

8 Replies
Immich
Immich•3d ago
:wave: Hey @Chaos, 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. :ballot_box_with_check: read applicable release notes. 3. :ballot_box_with_check: reviewed the FAQs for known issues. 4. :ballot_box_with_check: reviewed Github for known issues. 5. :ballot_box_with_check: tried accessing Immich via local ip (without a custom reverse proxy). 6. :ballot_box_with_check: 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.
Zeus
Zeus•3d ago
please post the database logs this does not look good
Chaos
ChaosOP•3d ago
no errors in the db. Nothing relevant: 
2025-08-23 13:44:21.010 BST [276] LOG:  checkpoint starting: time
2025-08-23 13:45:07.450 BST [276] LOG:  checkpoint complete: wrote 463 buffers (0.7%); 0 WAL file(s) added, 0 removed, 0 recycled; write=46.346 s, sync=0.031 s, total=46.440 s; sync files=31, longest=0.014 s, average=0.001 s; distance=4176 kB, estimate=69836 kB; lsn=0/87F641B8, redo lsn=0/87E7ABD8
2025-08-23 13:49:21.550 BST [276] LOG:  checkpoint starting: time
2025-08-23 13:50:15.458 BST [276] LOG:  checkpoint complete: wrote 539 buffers (0.8%); 0 WAL file(s) added, 1 removed, 0 recycled; write=53.851 s, sync=0.022 s, total=53.909 s; sync files=41, longest=0.006 s, average=0.001 s; distance=4462 kB, estimate=63298 kB; lsn=0/883DB870, redo lsn=0/882D6638
2025-08-23 13:54:21.559 BST [276] LOG:  checkpoint starting: time
2025-08-23 13:55:37.536 BST [276] LOG:  checkpoint complete: wrote 760 buffers (1.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=75.887 s, sync=0.021 s, total=75.977 s; sync files=43, longest=0.010 s, average=0.001 s; distance=5180 kB, estimate=57487 kB; lsn=0/887E5A70, redo lsn=0/887E59E0
2025-08-23 14:14:21.935 BST [276] LOG:  checkpoint starting: time
2025-08-23 14:14:22.463 BST [276] LOG:  checkpoint complete: wrote 5 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.504 s, sync=0.004 s, total=0.528 s; sync files=2, longest=0.004 s, average=0.002 s; distance=17 kB, estimate=51740 kB; lsn=0/887EA160, redo lsn=0/887EA0D0
2025-08-23 13:44:21.010 BST [276] LOG:  checkpoint starting: time
2025-08-23 13:45:07.450 BST [276] LOG:  checkpoint complete: wrote 463 buffers (0.7%); 0 WAL file(s) added, 0 removed, 0 recycled; write=46.346 s, sync=0.031 s, total=46.440 s; sync files=31, longest=0.014 s, average=0.001 s; distance=4176 kB, estimate=69836 kB; lsn=0/87F641B8, redo lsn=0/87E7ABD8
2025-08-23 13:49:21.550 BST [276] LOG:  checkpoint starting: time
2025-08-23 13:50:15.458 BST [276] LOG:  checkpoint complete: wrote 539 buffers (0.8%); 0 WAL file(s) added, 1 removed, 0 recycled; write=53.851 s, sync=0.022 s, total=53.909 s; sync files=41, longest=0.006 s, average=0.001 s; distance=4462 kB, estimate=63298 kB; lsn=0/883DB870, redo lsn=0/882D6638
2025-08-23 13:54:21.559 BST [276] LOG:  checkpoint starting: time
2025-08-23 13:55:37.536 BST [276] LOG:  checkpoint complete: wrote 760 buffers (1.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=75.887 s, sync=0.021 s, total=75.977 s; sync files=43, longest=0.010 s, average=0.001 s; distance=5180 kB, estimate=57487 kB; lsn=0/887E5A70, redo lsn=0/887E59E0
2025-08-23 14:14:21.935 BST [276] LOG:  checkpoint starting: time
2025-08-23 14:14:22.463 BST [276] LOG:  checkpoint complete: wrote 5 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.504 s, sync=0.004 s, total=0.528 s; sync files=2, longest=0.004 s, average=0.002 s; distance=17 kB, estimate=51740 kB; lsn=0/887EA160, redo lsn=0/887EA0D0
Zeus
Zeus•3d ago
looks like a networking issue then not normal though
Chaos
ChaosOP•3d ago
hmm about immich - db, or immich - files?
Zeus
Zeus•3d ago
the problem is the server talking to the database
Chaos
ChaosOP•3d ago
it works fine for most other tasks :S any clue of how to dig deeper?
Zeus
Zeus•3d ago
Sorry, I don't know anything about the home assistant addon setup so not really I assume your networking is damaged or timing out or something

Did you find this page helpful?