rtwo_ Comments - Answer Overflow

rtwo_

•Created by rtwo_ on 1/30/2025 in #help-desk-support

Server fails to fetch all assets after recent 1.125 update

Some more interesting stuff, with the timebucket error.

/usr/src/app/node_modules/postgres/cjs/src/connection.js:250
    const x = socket.write(chunk, fn)
                     ^

TypeError: Cannot read properties of null (reading 'write')
    at Immediate.nextWrite (/usr/src/app/node_modules/postgres/cjs/src/connection.js:250:22)
    at process.processImmediate (node:internal/timers:491:21)
    at process.callbackTrampoline (node:internal/async_hooks:130:17)

Node.js v22.13.1
api worker exited with code 1

/usr/src/app/node_modules/postgres/cjs/src/connection.js:250
    const x = socket.write(chunk, fn)
                     ^

TypeError: Cannot read properties of null (reading 'write')
    at Immediate.nextWrite (/usr/src/app/node_modules/postgres/cjs/src/connection.js:250:22)
    at process.processImmediate (node:internal/timers:491:21)
    at process.callbackTrampoline (node:internal/async_hooks:130:17)

Node.js v22.13.1
api worker exited with code 1

19 replies

IImmich

•Created by rtwo_ on 1/30/2025 in #help-desk-support

Server fails to fetch all assets after recent 1.125 update

Should I just restore the database from a backup?

19 replies

IImmich

•Created by rtwo_ on 1/30/2025 in #help-desk-support

Server fails to fetch all assets after recent 1.125 update

Sorry for the delay.

19 replies

IImmich

•Created by rtwo_ on 1/30/2025 in #help-desk-support

Server fails to fetch all assets after recent 1.125 update

rtw0@raspberrypi:~/immich-app $ docker exec -it immich_postgres psql --dbname=immich --username=postgres
psql (14.10 (Debian 14.10-1.pgdg120+1))
Type "help" for help.

immich=# select a.id, a."fileCreatedAt" from assets a where a."fileCreatedAt" < '1800-01-01 00:00:00';
 id | fileCreatedAt 
----+---------------
(0 rows)

immich=# select a.id, a."fileModifiedAt" from assets a where a."fileModifiedAt" < '1800-01-01 00:00:00';
 id | fileModifiedAt 
----+----------------
(0 rows)

immich=#

rtw0@raspberrypi:~/immich-app $ docker exec -it immich_postgres psql --dbname=immich --username=postgres
psql (14.10 (Debian 14.10-1.pgdg120+1))
Type "help" for help.

immich=# select a.id, a."fileCreatedAt" from assets a where a."fileCreatedAt" < '1800-01-01 00:00:00';
 id | fileCreatedAt 
----+---------------
(0 rows)

immich=# select a.id, a."fileModifiedAt" from assets a where a."fileModifiedAt" < '1800-01-01 00:00:00';
 id | fileModifiedAt 
----+----------------
(0 rows)

immich=#

19 replies

IImmich

•Created by rtwo_ on 1/30/2025 in #help-desk-support

Server fails to fetch all assets after recent 1.125 update

Have you checked the logs? At times it returns a timebucket error of some sort (not in the logs, it's rare); the failing sql query also has something to do with time

19 replies

IImmich

•Created by rtwo_ on 1/30/2025 in #help-desk-support

Server fails to fetch all assets after recent 1.125 update

The file structure scan also doesn't return any errors

19 replies

IImmich

•Created by rtwo_ on 1/30/2025 in #help-desk-support

Server fails to fetch all assets after recent 1.125 update

DB checksums are off apparently

19 replies

IImmich

•Created by rtwo_ on 1/30/2025 in #help-desk-support

Server fails to fetch all assets after recent 1.125 update

Sorry for the wording, meant to say it's crashing the immich-server container. I'll try the tests

19 replies

IImmich

•Created by rtwo_ on 1/30/2025 in #help-desk-support

Server fails to fetch all assets after recent 1.125 update

Some more info: I am running Debian 12 with a CasaOS frontend (installed from their iso) on a Raspberry Pi 4 with 4 GB of RAM. Output of df -h:

Filesystem      Size  Used Avail Use% Mounted on
udev            1.6G     0  1.6G   0% /dev
tmpfs           380M  4.5M  375M   2% /run
/dev/mmcblk0p2  111G   65G   41G  62% /
tmpfs           1.9G     0  1.9G   0% /dev/shm
tmpfs           5.0M   16K  5.0M   1% /run/lock
/dev/mmcblk0p1  510M   65M  446M  13% /boot/firmware
/dev/sda1       1.8T  660G  1.1T  38% /media/devmon/BACKUPCASA
tmpfs           380M     0  380M   0% /run/user/1000
Filesystem      Size  Used Avail Use% Mounted on
udev            1.6G     0  1.6G   0% /dev
tmpfs           380M  4.5M  375M   2% /run
/dev/mmcblk0p2  111G   65G   41G  62% /
tmpfs           1.9G     0  1.9G   0% /dev/shm
tmpfs           5.0M   16K  5.0M   1% /run/lock
/dev/mmcblk0p1  510M   65M  446M  13% /boot/firmware
/dev/sda1       1.8T  660G  1.1T  38% /media/devmon/BACKUPCASA
tmpfs           380M     0  380M   0% /run/user/1000

Filesystem      Size  Used Avail Use% Mounted on
udev            1.6G     0  1.6G   0% /dev
tmpfs           380M  4.5M  375M   2% /run
/dev/mmcblk0p2  111G   65G   41G  62% /
tmpfs           1.9G     0  1.9G   0% /dev/shm
tmpfs           5.0M   16K  5.0M   1% /run/lock
/dev/mmcblk0p1  510M   65M  446M  13% /boot/firmware
/dev/sda1       1.8T  660G  1.1T  38% /media/devmon/BACKUPCASA
tmpfs           380M     0  380M   0% /run/user/1000
Filesystem      Size  Used Avail Use% Mounted on
udev            1.6G     0  1.6G   0% /dev
tmpfs           380M  4.5M  375M   2% /run
/dev/mmcblk0p2  111G   65G   41G  62% /
tmpfs           1.9G     0  1.9G   0% /dev/shm
tmpfs           5.0M   16K  5.0M   1% /run/lock
/dev/mmcblk0p1  510M   65M  446M  13% /boot/firmware
/dev/sda1       1.8T  660G  1.1T  38% /media/devmon/BACKUPCASA
tmpfs           380M     0  380M   0% /run/user/1000

19 replies

Gaming

Programming