satmandu
satmandu
PostsComments
IImmich
Created by Mistox on 2/7/2025 in #help-desk-support
FFMPEG Unrecognized option 'cq:v'
See also https://github.com/jellyfin/jellyfin-ffmpeg/issues/533#issuecomment-2633169902
15 replies
IImmich
Created by Mistox on 2/7/2025 in #help-desk-support
FFMPEG Unrecognized option 'cq:v'
Note that they're constantly improving jellyfin-ffmpeg to add different sorts of hardware encoding/decoding support. See https://github.com/jellyfin/jellyfin-ffmpeg/pull/536
15 replies
IImmich
Created by satmandu on 2/7/2025 in #help-desk-support
Android: newest pictures from web view not showing up in view
So this is a data point: once I enabled the syncing of some local folders on the device, more recent photos (since my last import from Google Takeout) started showing up on the device.
60 replies
IImmich
Created by satmandu on 2/7/2025 in #help-desk-support
Android: newest pictures from web view not showing up in view
Would you suggest using pg_stat_statements at all to help debug this? (DB operations are not my forte... my dad spent his career on that. 😅 I think I recall some postgresql swag in the 1990s...)
60 replies
IImmich
Created by satmandu on 2/7/2025 in #help-desk-support
Android: newest pictures from web view not showing up in view
fired everything back up. android reconnected, and postgres is hitting 100% of a core. (The android is a Pixel 6 Pro with 12 gb of ram, so hopefully that is not a bottleneck?)
60 replies
IImmich
Created by satmandu on 2/7/2025 in #help-desk-support
Android: newest pictures from web view not showing up in view
The next thing I will try is adjusting the recordsize from the 128k default to 8k.
60 replies
IImmich
Created by satmandu on 2/7/2025 in #help-desk-support
Android: newest pictures from web view not showing up in view
(That's all local, and not on a network share.)
60 replies
IImmich
Created by satmandu on 2/7/2025 in #help-desk-support
Android: newest pictures from web view not showing up in view
my photos are all on external SSD at a separate path
60 replies
IImmich
Created by satmandu on 2/7/2025 in #help-desk-support
Android: newest pictures from web view not showing up in view
And using systemd to start things up thus: 
Description=Immich Server
After=network-online.target zfs.target docker.service gpu-manager.service
Requires=docker.service

[Service]
Restart=always
Type=simple
# Following is to avoid Redis errors. See https://stackoverflow.com/questions/43843197/how-to-fix-the-warnings-when-running-the-redisalpine-docker-image
ExecStartPre=sysctl vm.overcommit_memory=1
# ExecStartPre=docker pull ghcr.io/immich-app/immich-server:release
ExecStartPre=/bin/bash -c "cd /home/immich/non-root-immich && docker compose pull"
ExecStartPre=/bin/bash -c "docker compose -f /home/immich/non-root-immich/docker-compose.yml down --remove-orphans"
ExecStartPre=/bin/bash -c "docker compose -f /home/immich/non-root-immich/docker-compose.yml up -d --force-recreate"
ExecStart=/bin/bash -c "docker compose -f /home/immich/non-root-immich/docker-compose.yml up"
ExecStop=/bin/bash -c "docker compose -f /home/immich/non-root-immich/docker-compose.yml stop"

[Install]
WantedBy=multi-user.target
Description=Immich Server
After=network-online.target zfs.target docker.service gpu-manager.service
Requires=docker.service

[Service]
Restart=always
Type=simple
# Following is to avoid Redis errors. See https://stackoverflow.com/questions/43843197/how-to-fix-the-warnings-when-running-the-redisalpine-docker-image
ExecStartPre=sysctl vm.overcommit_memory=1
# ExecStartPre=docker pull ghcr.io/immich-app/immich-server:release
ExecStartPre=/bin/bash -c "cd /home/immich/non-root-immich && docker compose pull"
ExecStartPre=/bin/bash -c "docker compose -f /home/immich/non-root-immich/docker-compose.yml down --remove-orphans"
ExecStartPre=/bin/bash -c "docker compose -f /home/immich/non-root-immich/docker-compose.yml up -d --force-recreate"
ExecStart=/bin/bash -c "docker compose -f /home/immich/non-root-immich/docker-compose.yml up"
ExecStop=/bin/bash -c "docker compose -f /home/immich/non-root-immich/docker-compose.yml stop"

[Install]
WantedBy=multi-user.target
60 replies
IImmich
Created by satmandu on 2/7/2025 in #help-desk-support
Android: newest pictures from web view not showing up in view
I am using the aforementioned docker-compose.yml file
60 replies
IImmich
Created by satmandu on 2/7/2025 in #help-desk-support
Android: newest pictures from web view not showing up in view
at least starting as root
60 replies
IImmich
Created by satmandu on 2/7/2025 in #help-desk-support
Android: newest pictures from web view not showing up in view
(postgres is running as root, obviously)
60 replies
IImmich
Created by satmandu on 2/7/2025 in #help-desk-support
Android: newest pictures from web view not showing up in view
from zfs list: 
rpool/non-root-immich                             7.43G   638G  7.43G  /home/immich/non-root-immich
rpool/non-root-immich                             7.43G   638G  7.43G  /home/immich/non-root-immich
60 replies
IImmich
Created by satmandu on 2/7/2025 in #help-desk-support
Android: newest pictures from web view not showing up in view
(when I have the android app open)
60 replies
IImmich
Created by satmandu on 2/7/2025 in #help-desk-support
Android: newest pictures from web view not showing up in view
postgres is still pegging a cpu core.
60 replies
IImmich
Created by satmandu on 2/7/2025 in #help-desk-support
Android: newest pictures from web view not showing up in view
just a few minutes
60 replies
IImmich
Created by satmandu on 2/7/2025 in #help-desk-support
Android: newest pictures from web view not showing up in view
started everything up again without changing the zfs recordsize on the pool with the db.
60 replies
IImmich
Created by satmandu on 2/7/2025 in #help-desk-support
Android: newest pictures from web view not showing up in view
Trying it: 
psql -U postgres -h localhost -d immich
psql (14.10 (Debian 14.10-1.pgdg120+1))
Type "help" for help.

immich=# VACUUM (FULL, ANALYZE);
psql -U postgres -h localhost -d immich
psql (14.10 (Debian 14.10-1.pgdg120+1))
Type "help" for help.

immich=# VACUUM (FULL, ANALYZE);
60 replies
IImmich
Created by satmandu on 2/7/2025 in #help-desk-support
Android: newest pictures from web view not showing up in view
this is the weirdest I see: 2025-02-07 15:20:46.211 UTC [1] LOG: starting PostgreSQL 14.10 (Debian 14.10-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit 2025-02-07 15:20:46.211 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432 2025-02-07 15:20:46.211 UTC [1] LOG: listening on IPv6 address "::", port 5432 2025-02-07 15:20:46.215 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432" 2025-02-07 15:20:46.220 UTC [28] LOG: database system was shut down at 2025-02-07 15:20:43 UTC 2025-02-07 15:20:46.227 UTC [1] LOG: database system is ready to accept connections 2025-02-07 15:32:12.436 UTC [1] LOG: received fast shutdown request 2025-02-07 15:32:12.438 UTC [1] LOG: aborting any active transactions 2025-02-07 15:32:12.438 UTC [65] FATAL: terminating connection due to administrator command 2025-02-07 15:32:12.438 UTC [65] STATEMENT: select "assets"., to_json("exif") as "exifInfo", to_json("stacked_assets") as "stack" from "assets" left join "exif" on "assets"."id" = "exif"."assetId" left join "asset_stack" on "asset_stack"."id" = "assets"."stackId" left join lateral (select "asset_stack"., count("stacked") as "assetCount" from "assets" as "stacked" where "stacked"."stackId" = "asset_stack"."id" group by "asset_stack"."id") as "stacked_assets" on "asset_stack"."id" is not null where "assets"."ownerId" = $1::uuid and "isVisible" = $2 and "updatedAt" <= $3 and "assets"."id" > $4 order by "assets"."id" limit $5 2025-02-07 15:32:12.439 UTC [1] LOG: background worker "logical replication launcher" (PID 37) exited with exit code 1 2025-02-07 15:32:12.446 UTC [32] LOG: shutting down 2025-02-07 15:32:12.478 UTC [1] LOG: database system is shut down
60 replies
IImmich
Created by satmandu on 2/7/2025 in #help-desk-support
Android: newest pictures from web view not showing up in view
Not seeing anything weird in the logs...
60 replies