#Accidentally updated to pgvecto-rs:pg14-v0.2.1 but should be v0.2.0 and it's causing issues

1 messages · Page 1 of 1 (latest)

dense orchid
#

I upgraded my immich_postgres
docker.io/tensorchord/pgvecto-rs:pg14-v0.2.0 - to v0.2.1 manually (dont ask me why). and now it's giving the below error. Any updates how to proceed? I'm thinking the docker-compose file can be adjusted to 0.2.1 instead of 0.2.0 but i dont know what the SHA is - or is there another fix?

2024-06-13 00:56:57 immich_server | [Nest] 7 - 06/12/2024, 3:26:57 PM ERROR [Microservices:DatabaseService] QueryFailedError: extension "vectors" has no update path from version "0.2.1" to version "0.2.0"

when docker is starting up it tries to update to 0.2.0 but then fails.

frigid zodiacBOT
#

:wave: Hey @dense orchid,

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

Checklist

  1. :blue_square: I have verified I'm on the latest release(note that mobile app releases may take some time).
  2. :blue_square: I have read applicable release notes.
  3. :blue_square: I have reviewed the FAQs for known issues.
  4. :blue_square: I have reviewed Github for known issues.
  5. :blue_square: I have tried accessing Immich via local ip (without a custom reverse proxy).
  6. :blue_square: I have uploaded the relevant logs, docker compose, and .env files using the buttons below or the /upload command.
  7. :blue_square: 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.

dense orchid
#

a bit more information - I upgraded my immich_postgres
docker.io/tensorchord/pgvecto-rs:pg14-v0.2.0 - to v0.2.1 manually (dont ask me why). and now it's giving the below error. Any updates how to proceed? I'm thinking the docker-compose file can be adjusted to 0.2.1 instead of 0.2.0 but i dont know what the SHA is - or is there another fix?

2024-06-13 00:56:57 immich_server | [Nest] 7 - 06/12/2024, 3:26:57 PM ERROR [Microservices:DatabaseService] QueryFailedError: extension "vectors" has no update path from version "0.2.1" to version "0.2.0"

pulsar epoch
#

Hmm, why is it trying to downgrade? That’s silly

dense orchid
#

its trying to update to 0.2.0 however i have 0.2.1 installed. Is there a fix as this adds 5 minutes to the deployment of the container.

2024-06-13 10:24:26 immich_server | [Nest] 19 - 06/13/2024, 12:54:26 AM LOG [Api:DatabaseService] Updating pgvecto.rs extension to 0.2.0
2024-06-13 10:24:26 immich_server | [Nest] 19 - 06/13/2024, 12:54:26 AM WARN [Api:DatabaseService]
2024-06-13 10:24:26 immich_server | The pgvecto.rs extension can be updated to 0.2.0.
2024-06-13 10:24:26 immich_server | Immich attempted to update the extension, but failed to do so.
2024-06-13 10:24:26 immich_server | This may be because Immich does not have the necessary permissions to update the extension.
2024-06-13 10:24:26 immich_server |
2024-06-13 10:24:26 immich_server | Please run 'ALTER EXTENSION vectors UPDATE' manually as a superuser.
2024-06-13 10:24:26 immich_server | See https://immich.app/docs/guides/database-queries for how to query the database.
2024-06-13 10:24:26 immich_server | [Nest] 19 - 06/13/2024, 12:54:26 AM ERROR [Api:DatabaseService] QueryFailedError: extension "vectors" has no update path from version "0.2.1" to version "0.2.0"

dense orchid
#

Accidentally updated to pgvecto-rs:pg14-v0.2.1 but should be v0.2.0 and it's causing issues