Skip to content

This issue was moved to a discussion.

You can continue the conversation there. Go to discussion →

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Web UI timebucket error and incorrect library count after updating #8904

Closed
3 tasks
snakepu opened this issue Apr 18, 2024 · 0 comments
Closed
3 tasks

Web UI timebucket error and incorrect library count after updating #8904

snakepu opened this issue Apr 18, 2024 · 0 comments

Comments

@snakepu
Copy link

snakepu commented Apr 18, 2024

The bug

After updating from around 0.93 (I think) to 1.101, when accessing the web UI a little red box appears in the top right which says:

Failed to get timebucket [immich server error]

Visually, I can no longer see anything from the internal library on my timeline. There is a huge gap of empty space as if the timeline goes on for ages but with nothing there, going back to January 2024 (which is when the internal library starts from).

Everything before that (which is an external library I added) shows up. Although it's also decided that lots of my older photos in the external library are from 2018. Also in the settings it shows the external library as containing just over 500,000 items, when in reality it contains around 30,000.

For the past 2 days it's been running the CPU at 100% doing facial recognition processing for around 300,000 items (which don't exist) and thumbnail processing etc for around 50,000 items.

I guess something's gone wrong with the database? But I have no idea how to proceed. The timeline in the mobile app is ok, everything shows up as it should where it should. All albums that I've added show up fine as well in the mobile app and the web ui.

However, if I try to view specific people in the explore section, nothing shows up in the mobile app for that person, and on the web ui it shows the same timebucket error.

Also in the logs there are strange errors for Postgresql saying no space left on device, even though there's lots of space.

The OS that Immich Server is running on

Docker, Portainer stack, Synology DSM 6.2.4-25556 Update 7

Version of Immich Server

v1.101.0

Version of Immich Mobile App

v1.101.0 build.131

Platform with the issue

  • Server
  • Web
  • Mobile

Your docker-compose.yml content

THIS IS A PORTAINER STACK

version: "3.9"
services:
  immich-redis:
    image: redis
    container_name: Immich-REDIS
    hostname: immich-redis
    security_opt:
      - no-new-privileges:true
    healthcheck:
      test: ["CMD-SHELL", "redis-cli ping || exit 1"]
    user: 1026:100
    environment:
      - TZ=Europe/London
    volumes:
      - /volume2/docker2/immich/redis:/data
    restart: on-failure:5

  immich-db:
    image: tensorchord/pgvecto-rs:pg16-v0.2.0
    container_name: Immich-DB
    hostname: immich-db
    security_opt:
      - no-new-privileges:true
    healthcheck:
      test: ["CMD", "pg_isready", "-q", "-d", "immich", "-U", "immichuser"]
      interval: 10s
      timeout: 5s
      retries: 5
    volumes:
      - /volume2/docker2/immich/db:/var/lib/postgresql/data
    environment:
      - TZ=Europe/London
      - POSTGRES_DB=immich
      - POSTGRES_USER=immichuser
      - POSTGRES_PASSWORD=*
    restart: on-failure:5

  immich-server:
    image: ghcr.io/immich-app/immich-server:release
    command: ["start-server.sh"]
    container_name: Immich-SERVER
    hostname: immich-server
    user: 1026:100
    security_opt:
      - no-new-privileges:true
    env_file:
      - stack.env
    ports:
      - 8212:3001
    volumes:
      - /volume1/docker/immich/upload:/usr/src/app/upload
      - /volume1/docker/immich/Dropboxupto2023:/usr/src/app/external
    restart: on-failure:5
    depends_on:
      immich-redis:
        condition: service_healthy
      immich-db:
        condition: service_started

  immich-microservices:
    image: ghcr.io/immich-app/immich-server:release
    command: ["start-microservices.sh"]
    container_name: Immich-MICROSERVICES
    hostname: immich-microservices
    user: 1026:100
    security_opt:
      - no-new-privileges:true
    env_file:
      - stack.env
    volumes:
      - /volume1/docker/immich/upload:/usr/src/app/upload
      - /volume2/docker2/immich/micro:/usr/src/app/.reverse-geocoding-dump
      - /volume1/docker/immich/Dropboxupto2023:/usr/src/app/external
    restart: on-failure:5
    depends_on:
      immich-redis:
        condition: service_healthy
      immich-db:
        condition: service_started

  immich-machine-learning:
    image: ghcr.io/immich-app/immich-machine-learning:release
    container_name: Immich-LEARNING
    hostname: immich-machine-learning
    user: 1026:100
    security_opt:
      - no-new-privileges:true
    env_file:
      - stack.env
    volumes:
      - /volume1/docker/immich/upload:/usr/src/app/upload
      - /volume2/docker2/immich/cache:/cache
    restart: on-failure:5
    depends_on:
      immich-db:
        condition: service_started

Your .env content

NODE_ENV
production

TZ
Europe/London

TYPESENSE_API_KEY
MariushostingMariushostingMari13

DB_HOSTNAME
immich-db

DB_USERNAME
immichuser

DB_PASSWORD
*

DB_DATABASE_NAME
immich

REDIS_HOSTNAME
immich-redis

LOG_LEVEL
log

JWT_SECRET
*

DISABLE_REVERSE_GEOCODING
false

REVERSE_GEOCODING_PRECISION
3

PUBLIC_LOGIN_PAGE_MESSAGE

IMMICH_WEB_URL
http://immich-web:3000

IMMICH_SERVER_URL
http://immich-server:3001

IMMICH_MACHINE_LEARNING_URL
http://immich-machine-learning:3003
EXTERNAL_PATH=
/volume1/docker/immich/Dropboxupto2023

Reproduction steps

1. Update Immich stack in Portainer.
2. Launch stack.
3. Open web ui.

Relevant log output

Immich-SERVER					
date	stream	content			
2024-04-18 13:38:28	stdout	�[32m[Nest] 9  - �[39m04/18/2024, 2:38:28 PM �[32m    LOG�[39m �[38;5;3m[EventRepository] �[39m�[32mWebsocket Connect:    VRYJE_Shff9OrwKvAAAc�[39m 			
2024-04-18 13:38:27	stdout	�[32m[Nest] 9  - �[39m04/18/2024, 2:38:27 PM �[32m    LOG�[39m �[38;5;3m[EventRepository] �[39m�[32mWebsocket Connect:    Mum1l1dxiCXul23ZAAAa�[39m 			
2024-04-18 13:38:27	stdout	�[32m[Nest] 9  - �[39m04/18/2024, 2:38:27 PM �[32m    LOG�[39m �[38;5;3m[EventRepository] �[39m�[32mWebsocket Disconnect: hfg8ZB48aviN_qRmAAAT�[39m 			
2024-04-18 13:38:27	stdout	�[32m[Nest] 9  - �[39m04/18/2024, 2:38:27 PM �[32m    LOG�[39m �[38;5;3m[EventRepository] �[39m�[32mWebsocket Disconnect: 4NKJ0aCf_H-5JH1VAAAW�[39m 			
2024-04-18 13:38:27	stderr	    at async /usr/src/app/node_modules/@nestjs/core/router/router-proxy.js:9:17			
					
2024-04-18 13:38:27	stderr	    at async /usr/src/app/node_modules/@nestjs/core/router/router-execution-context.js:47:13			
					
2024-04-18 13:38:27	stderr	    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)			
					
2024-04-18 13:38:27	stderr	    at /usr/src/app/node_modules/@nestjs/core/router/router-execution-context.js:176:48			
					
2024-04-18 13:38:27	stderr	    at RouterResponseController.apply (/usr/src/app/node_modules/@nestjs/core/router/router-response-controller.js:15:36)			
					
2024-04-18 13:38:27	stderr	    at ExpressAdapter.reply (/usr/src/app/node_modules/@nestjs/platform-express/adapters/express-adapter.js:62:62)			
					
2024-04-18 13:38:27	stderr	    at ServerResponse.json (/usr/src/app/node_modules/express/lib/response.js:272:14)			
					
2024-04-18 13:38:27	stderr	    at stringify (/usr/src/app/node_modules/express/lib/response.js:1159:12)			
					
2024-04-18 13:38:27	stderr	    at JSON.stringify (<anonymous>)			
					
2024-04-18 13:38:27	stderr	RangeError: Invalid string length			
					
2024-04-18 13:38:27	stderr	�[31m[Nest] 9  - �[39m04/18/2024, 2:38:27 PM �[31m  ERROR�[39m �[38;5;3m[ExceptionsHandler] �[39m�[31mInvalid string length�[39m 			
2024-04-18 13:37:16	stdout	�[32m[Nest] 9  - �[39m04/18/2024, 2:37:16 PM �[32m    LOG�[39m �[38;5;3m[EventRepository] �[39m�[32mWebsocket Connect:    4NKJ0aCf_H-5JH1VAAAW�[39m 			
2024-04-18 13:36:39	stderr	    at async TimelineService.getTimeBucket (/usr/src/app/dist/services/timeline.service.js:39:24)] �[39m�[31mQueryFailedError: could not resize shared memory segment "/PostgreSQL.2954289834" to 33554432 bytes: No space left on device�[39m			
					
2024-04-18 13:36:39	stderr	    at async SelectQueryBuilder.getMany (/usr/src/app/node_modules/typeorm/query-builder/SelectQueryBuilder.js:750:25)			
					
2024-04-18 13:36:39	stderr	    at async SelectQueryBuilder.getRawAndEntities (/usr/src/app/node_modules/typeorm/query-builder/SelectQueryBuilder.js:684:29)			
					
2024-04-18 13:36:39	stderr	    at async SelectQueryBuilder.executeEntitiesAndRawResults (/usr/src/app/node_modules/typeorm/query-builder/SelectQueryBuilder.js:2040:26)			
					
2024-04-18 13:36:39	stderr	    at async SelectQueryBuilder.loadRawResults (/usr/src/app/node_modules/typeorm/query-builder/SelectQueryBuilder.js:2192:25)			
					
2024-04-18 13:36:39	stderr	    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)			
					
2024-04-18 13:36:39	stderr	    at PostgresQueryRunner.query (/usr/src/app/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:219:19)			
					
2024-04-18 13:36:39	stderr	"�[31m[Nest] 9  - �[39m04/18/2024	 2:36:39 PM �[31m  ERROR�[39m �[38	5	3m[QueryFailedError: could not resize shared memory segment \"/PostgreSQL.2954289834\" to 33554432 bytes: No space left on device
"					
2024-04-18 13:36:39	stderr	    at async TimelineService.getTimeBucket (/usr/src/app/dist/services/timeline.service.js:39:24)] �[39m�[31mFailed to get time bucket�[39m			
					
2024-04-18 13:36:39	stderr	    at async SelectQueryBuilder.getMany (/usr/src/app/node_modules/typeorm/query-builder/SelectQueryBuilder.js:750:25)			
					
2024-04-18 13:36:39	stderr	    at async SelectQueryBuilder.getRawAndEntities (/usr/src/app/node_modules/typeorm/query-builder/SelectQueryBuilder.js:684:29)			
					
2024-04-18 13:36:39	stderr	    at async SelectQueryBuilder.executeEntitiesAndRawResults (/usr/src/app/node_modules/typeorm/query-builder/SelectQueryBuilder.js:2040:26)			
					
2024-04-18 13:36:39	stderr	    at async SelectQueryBuilder.loadRawResults (/usr/src/app/node_modules/typeorm/query-builder/SelectQueryBuilder.js:2192:25)			
					
2024-04-18 13:36:39	stderr	    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)			
					
2024-04-18 13:36:39	stderr	    at PostgresQueryRunner.query (/usr/src/app/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:219:19)			
					
2024-04-18 13:36:39	stderr	"�[31m[Nest] 9  - �[39m04/18/2024	 2:36:39 PM �[31m  ERROR�[39m �[38	5	3m[QueryFailedError: could not resize shared memory segment \"/PostgreSQL.2954289834\" to 33554432 bytes: No space left on device
"					
2024-04-18 13:36:31	stdout	�[33m[Nest] 9  - �[39m04/18/2024, 2:36:31 PM �[33m   WARN�[39m �[38;5;3m[ExpressAdapter] �[39m�[33mContent-Type doesn't match Reply body, you might need a custom ExceptionFilter for non-JSON responses�[39m

Additional information

No response
@immich-app immich-app locked and limited conversation to collaborators Apr 18, 2024
@bo0tzz bo0tzz converted this issue into discussion #8905 Apr 18, 2024

This issue was moved to a discussion.

You can continue the conversation there. Go to discussion →

Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@snakepu