Upgrade error pgvecto.rs 0.3.0 | Immich | Page 1

pliant moat Nov 5, 2024, 2:52 PM

#

Hello,

I am getting following error:

  column: undefined,
  dataType: undefined,
  constraint: undefined,
  file: 'typecmds.c',
  line: '247',
  routine: 'DefineType'
}
api worker exited with code 1
Starting api worker
[Nest] 2655  - 11/05/2024, 9:50:49 AM     LOG [Api:EventRepository] Initialized websocket server
[Nest] 2655  - 11/05/2024, 9:50:49 AM     LOG [Api:DatabaseService] Updating pgvecto.rs extension to 0.3.0
[Nest] 2655  - 11/05/2024, 9:50:49 AM    WARN [Api:DatabaseService] The pgvecto.rs extension can be updated to 0.3.0.
    Immich attempted to update the extension, but failed to do so.
    This may be because Immich does not have the necessary permissions to update the extension.

    Please run 'ALTER EXTENSION vectors UPDATE' manually as a superuser.
    See https://immich.app/docs/guides/database-queries for how to query the database.
QueryFailedError: type "svector" already exists
    at PostgresQueryRunner.query (/app/immich/server/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:219:19)
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async DataSource.query (/app/immich/server/node_modules/typeorm/data-source/DataSource.js:350:20)
    at async /app/immich/server/dist/repositories/database.repository.js:93:13
    at async EntityManager.transaction (/app/immich/server/node_modules/typeorm/entity-manager/EntityManager.js:73:28)
    at async DatabaseRepository.updateVectorExtension (/app/immich/server/dist/repositories/database.repository.js:84:9)
    at async DatabaseService.updateExtension (/app/immich/server/dist/services/database.service.js:131:41)
    at async /app/immich/server/dist/services/database.service.js:84:17
    at async /app/immich/server/dist/repositories/database.repository.js:197:23 {
  query: "ALTER EXTENSION vectors UPDATE TO '0.3.0'",
  parameters: undefined,
  driverError: error: type "svector" already exists
      at /app/immich/server/node_modules/pg/lib/client.js:535:17
      at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
      at async PostgresQueryRunner.query (/app/immich/server/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:184:25)
      at async DataSource.query (/app/immich/server/node_modules/typeorm/data-source/DataSource.js:350:20)
      at async /app/immich/server/dist/repositories/database.repository.js:93:13
      at async EntityManager.transaction (/app/immich/server/node_modules/typeorm/entity-manager/EntityManager.js:73:28)
      at async DatabaseRepository.updateVectorExtension (/app/immich/server/dist/repositories/database.repository.js:84:9)
      at async DatabaseService.updateExtension (/app/immich/server/dist/services/database.service.js:131:41)
      at async /app/immich/server/dist/services/database.service.js:84:17
      at async /app/immich/server/dist/repositories/database.repository.js:197:23 {
    length: 86,
    severity: 'ERROR',
    code: '42710',
    detail: undefined,

torpid pikeBOT Nov 5, 2024, 2:52 PM

#

:wave: Hey @pliant moat,

Thanks for reaching out to us. Please follow the recommended actions below; 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 compose ps docs
Reverse Proxy: https://immich.app/docs/administration/reverse-proxy

Checklist

:ballot_box_with_check: I have verified I'm on the latest release(note that mobile app releases may take some time).
:ballot_box_with_check: I have read applicable release notes.
:ballot_box_with_check: I have reviewed the FAQs for known issues.
:ballot_box_with_check: I have reviewed Github for known issues.
:ballot_box_with_check: I have tried accessing Immich via local ip (without a custom reverse proxy).
:ballot_box_with_check: I have uploaded the relevant logs, docker compose, and .env files, making sure to use code formatting.
:ballot_box_with_check: I have 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)

If this ticket can be closed you can use the /close command, and re-open it later if needed.

torpid pikeBOT Nov 5, 2024, 2:52 PM

#

torpid pike :wave: Hey <@116601289869099011>, Thanks for reaching out to us. Please follow ...

Successfully submitted, a tag has been added to inform contributors. :white_check_mark:

pliant moat Nov 5, 2024, 2:53 PM

#

Upgrade help pgvecto.rs 0.3.0

#

Upgrade error pgvecto.rs 0.3.0

uneven river Nov 5, 2024, 3:56 PM

#

It sounds like you are running your own version of postgres, so have you tried running that command?

#

you also haven't posted any of the things the bot asked for

pliant moat Nov 5, 2024, 4:34 PM

#

Hello yes. That is the docker compose logs.

#

Rest is standard docker: ghcr.io/imagegenius/immich:cuda

#

tensorchord/pgvecto-rs:pg16-v0.3.0

#

#

uneven river Nov 5, 2024, 4:42 PM

#

#7310 this is about the update to 0.2.0 but might be applicable to your situation

torpid pikeBOT Nov 5, 2024, 4:42 PM

#

uneven river #7310 this is about the update to 0.2.0 but might be applicable to your situatio...

[Discussion] (immich-app/immich#7310)

uneven river Nov 5, 2024, 4:42 PM

#

odds are it has already been updated to 0.3.0

#

however you are using an unsupported deployment and we have not tested this fully yet so might be limited in our ability to help

#

it might be easier to restore from a backup back to 0.2.0

pliant moat Nov 5, 2024, 4:43 PM

#

Yes, i just saw https://github.com/tensorchord/pgvecto.rs/issues/371

#

UPDATE pg_catalog.pg_extension SET extversion = '0.3.0' where extname = 'vectors';

#

Nope seems like something broke: [Nest] 1147 - 11/05/2024, 11:44:47 AM WARN [Api:DatabaseService] Could not run vector reindexing checks. If the extension was updated, please restart the Postgres instance. QueryFailedError: pgvecto.rs: The extension is upgraded so all index files are outdated. ADVICE: Delete all index files. Please read `https://docs.pgvecto.rs/admin/upgrading.html` at PostgresQueryRunner.query (/app/immich/server/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:219:19) at process.processTicksAndRejections (node:internal/process/task_queues:95:5) at async DataSource.query (/app/immich/server/node_modules/typeorm/data-source/DataSource.js:350:20) at async DatabaseRepository.shouldReindex (/app/immich/server/dist/repositories/database.repository.js:136:25) at async DatabaseService.checkReindexing (/app/immich/server/dist/services/database.service.js:143:17) at async /app/immich/server/dist/services/database.service.js:92:13 at async /app/immich/server/dist/repositories/database.repository.js:197:23 { query: 'SELECT idx_status FROM pg_vector_index_stat WHERE indexname = $1', parameters: [ 'clip_index' ], driverError: error: pgvecto.rs: The extension is upgraded so all index files are outdated. ADVICE: Delete all index files. Please read `https://docs.pgvecto.rs/admin/upgrading.html` at /app/immich/server/node_modules/pg/lib/client.js:535:17 at process.processTicksAndRejections (node:internal/process/task_queues:95:5) at async PostgresQueryRunner.query (/app/immich/server/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:184:25) at async DataSource.query (/app/immich/server/node_modules/typeorm/data-source/DataSource.js:350:20) at async DatabaseRepository.shouldReindex (/app/immich/server/dist/repositories/database.repository.js:136:25) at async DatabaseService.checkReindexing (/app/immich/server/dist/services/database.service.js:143:17) at async /app/immich/server/dist/services/database.service.js:92:13 at async /app/immich/server/dist/repositories/database.repository.js:197:23 { length: 234, severity: 'ERROR', code: 'XX000', detail: undefined, hint: undefined, position: undefined, internalPosition: undefined, internalQuery: undefined, where: undefined, schema: undefined, table: undefined, column: undefined, dataType: undefined, constraint: undefined, file: 'error.rs', line: '125', routine: 'vectors::error::check_client' }, length: 234, severity: 'ERROR', code: 'XX000', detail: undefined, hint: undefined, position: undefined, internalPosition: undefined, internalQuery: undefined, where: undefined, schema: undefined, table: undefined, column: undefined, dataType: undefined, constraint: undefined, file: 'error.rs', line: '125', routine: 'vectors::error::check_client' } api worker exited with code 1 Starting api worker

uneven river Nov 5, 2024, 4:50 PM

#

driverError: error: pgvecto.rs: The extension is upgraded so all index files are outdated. ADVICE: Delete all index files. Please readhttps://docs.pgvecto.rs/admin/upgrading.html`
`

did you try this..?

Upgrading | pgvecto.rs

Scalable Vector Search in Postgres

pliant moat Nov 5, 2024, 5:08 PM

#

Yes something is botched. Might need to open a ticket on pgvecto

#

Error in query: ERROR: type "svector" already exists

#

blissful solstice Nov 5, 2024, 5:13 PM

#

Did you run SELECT pgvectors_upgrade(); as instructed in that docs page?

pliant moat Nov 5, 2024, 5:13 PM

#

#

blissful solstice Nov 5, 2024, 5:30 PM

#

@dark sable any idea?

dark sable Nov 5, 2024, 5:35 PM

#

Is the search path set to include vectors? Does vectors.pgvectors_upgrade() work?

pliant moat Nov 5, 2024, 5:39 PM

#

blissful solstice Nov 5, 2024, 5:43 PM

#

Looks like that worked

#

What does Immich do now?

dark sable Nov 5, 2024, 5:51 PM

#

Nice, you should restart postgres after that

pliant moat Nov 5, 2024, 5:56 PM

#

Yes seems like that did the magic restarted both postgress and immich. Thanks again

#Upgrade error pgvecto.rs 0.3.0

References

Checklist