immich-app/immich
1
0
Fork 0
mirror of https://github.com/immich-app/immich.git synced 2026-02-05 00:30:57 +03:00
Code Issues 26 Packages Projects Releases 10 Wiki Activity

Upgrade from 1.97.0 to 1.98.0 failing #2450

New Issue
Closed
opened 2026-02-05 06:05:24 +03:00 by OVERLORD · 0 comments
OVERLORD commented 2026-02-05 06:05:24 +03:00
Owner
Copy Link

Originally created by @szinn on GitHub (Mar 8, 2024).

The bug

Migration "AddExtensionToOriginalFileName1709763765506" failed, error: could not read block 55 in file "base/18136/18358": read only 0 of 8192 bytes
/usr/src/app/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:219
            throw new QueryFailedError_1.QueryFailedError(query, parameters, err);
                  ^

QueryFailedError: could not read block 55 in file "base/18136/18358": read only 0 of 8192 bytes
    at PostgresQueryRunner.query (/usr/src/app/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:219:19)
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async AddExtensionToOriginalFileName1709763765506.up (/usr/src/app/dist/infra/migrations/1709763765506-AddExtensionToOriginalFileName.js:6:9)
    at async MigrationExecutor.executePendingMigrations (/usr/src/app/node_modules/typeorm/migration/MigrationExecutor.js:225:17)
    at async DataSource.runMigrations (/usr/src/app/node_modules/typeorm/data-source/DataSource.js:265:35)
    at async DatabaseRepository.runMigrations (/usr/src/app/dist/infra/repositories/database.repository.js:177:9)
    at async /usr/src/app/dist/domain/database/database.service.js:52:13
    at async /usr/src/app/dist/infra/repositories/database.repository.js:185:23 {
  query: '\n' +
    `      WITH extension AS (WITH cte AS (SELECT a.id, STRING_TO_ARRAY(a."originalPath", '.')::TEXT[] AS arr\n` +
    '      FROM assets a)\n' +
    '      SELECT cte.id, cte.arr[ARRAY_UPPER(cte.arr, 1)] AS "ext"\n' +
    '      FROM cte)\n' +
    '      UPDATE assets\n' +
    `      SET "originalFileName" = assets."originalFileName" || '.' || extension."ext"\n` +
    '      FROM extension\n' +
    '      WHERE assets.id = extension.id;\n' +
    '      ',
  parameters: undefined,

The OS that Immich Server is running on

Talos/kubernetes

Version of Immich Server

v1.98.0

Version of Immich Mobile App

v n/a

Platform with the issue

  • Server
  • Web
  • Mobile

Your docker-compose.yml content

https://github.com/szinn/k8s-homelab/tree/main/kubernetes/main/apps/media/immich/app

Your .env content

https://github.com/szinn/k8s-homelab/tree/main/kubernetes/main/apps/media/immich/app

Reproduction steps

1. upgrading from 1.97.0 to 1.98.0
2. both microservice and server pods reporting issue
3.
...

Additional information

No response

Originally created by @szinn on GitHub (Mar 8, 2024). ### The bug ``` Migration "AddExtensionToOriginalFileName1709763765506" failed, error: could not read block 55 in file "base/18136/18358": read only 0 of 8192 bytes /usr/src/app/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:219 throw new QueryFailedError_1.QueryFailedError(query, parameters, err); ^ QueryFailedError: could not read block 55 in file "base/18136/18358": read only 0 of 8192 bytes at PostgresQueryRunner.query (/usr/src/app/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:219:19) at process.processTicksAndRejections (node:internal/process/task_queues:95:5) at async AddExtensionToOriginalFileName1709763765506.up (/usr/src/app/dist/infra/migrations/1709763765506-AddExtensionToOriginalFileName.js:6:9) at async MigrationExecutor.executePendingMigrations (/usr/src/app/node_modules/typeorm/migration/MigrationExecutor.js:225:17) at async DataSource.runMigrations (/usr/src/app/node_modules/typeorm/data-source/DataSource.js:265:35) at async DatabaseRepository.runMigrations (/usr/src/app/dist/infra/repositories/database.repository.js:177:9) at async /usr/src/app/dist/domain/database/database.service.js:52:13 at async /usr/src/app/dist/infra/repositories/database.repository.js:185:23 { query: '\n' + ` WITH extension AS (WITH cte AS (SELECT a.id, STRING_TO_ARRAY(a."originalPath", '.')::TEXT[] AS arr\n` + ' FROM assets a)\n' + ' SELECT cte.id, cte.arr[ARRAY_UPPER(cte.arr, 1)] AS "ext"\n' + ' FROM cte)\n' + ' UPDATE assets\n' + ` SET "originalFileName" = assets."originalFileName" || '.' || extension."ext"\n` + ' FROM extension\n' + ' WHERE assets.id = extension.id;\n' + ' ', parameters: undefined, ``` ### The OS that Immich Server is running on Talos/kubernetes ### Version of Immich Server v1.98.0 ### Version of Immich Mobile App v n/a ### Platform with the issue - [X] Server - [ ] Web - [ ] Mobile ### Your docker-compose.yml content ```YAML https://github.com/szinn/k8s-homelab/tree/main/kubernetes/main/apps/media/immich/app ``` ### Your .env content ```Shell https://github.com/szinn/k8s-homelab/tree/main/kubernetes/main/apps/media/immich/app ``` ### Reproduction steps ```bash 1. upgrading from 1.97.0 to 1.98.0 2. both microservice and server pods reporting issue 3. ... ``` ### Additional information _No response_
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
accessibility
changelog:enhancement
changelog:security
changelog:skip
changelog:translation
cli
date-time
documentation
external-library
format
good first issue
needs-answer
nice to have
sharing
tech-debt
📱mobile
🖥️web
🗄️server
🧠machine-learning
No Label
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
OVERLORD
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: immich-app/immich#2450
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?