Bubba Comments - Answer Overflow

Topics

Bubba

•Created by Bubba on 1/4/2025 in #help-desk-support

Unable to search location after database restore

yeah, I guess it's not formatted in a "western friendly" format. Anyway, thanks a ton @bo0tzz. I really appreciate your help - always!

18 replies

•Created by Bubba on 1/4/2025 in #help-desk-support

Unable to search location after database restore

for example, searching for "manila Philippines" doesn't come up with the right thing

18 replies

•Created by Bubba on 1/4/2025 in #help-desk-support

Unable to search location after database restore

now search delivers results, but they're kind of funky - which is a secondary problem

18 replies

•Created by Bubba on 1/4/2025 in #help-desk-support

Unable to search location after database restore

lots of log entries like this [Nest] 2 - 01/04/2025, 11:17:39 AM LOG [Microservices:MapRepository] 170000 geodata records imported

18 replies

•Created by Bubba on 1/4/2025 in #help-desk-support

Unable to search location after database restore

looks like it worked; I'll restart my pods

18 replies

•Created by Bubba on 1/4/2025 in #help-desk-support

Unable to search location after database restore

immich=# delete from system_metadata where key = 'reverse-geocoding-state';
DELETE 1

immich=# delete from system_metadata where key = 'reverse-geocoding-state';
DELETE 1

18 replies

•Created by Bubba on 1/4/2025 in #help-desk-support

Unable to search location after database restore

immich=# delete * from system_metadata where key = 'reverse-geocoding-state';
ERROR:  syntax error at or near "*"
LINE 1: delete * from system_metadata where key = 'reverse-geocoding...

immich=# delete * from system_metadata where key = 'reverse-geocoding-state';
ERROR:  syntax error at or near "*"
LINE 1: delete * from system_metadata where key = 'reverse-geocoding...

18 replies

•Created by Bubba on 1/4/2025 in #help-desk-support

Unable to search location after database restore

thx

18 replies

•Created by Bubba on 1/4/2025 in #help-desk-support

Unable to search location after database restore

The problem that I'm seeing is that when I try to "change location" of a photo and I enter some text into the "search places" text box, the circle spins for less than a second and then does nothing.

18 replies

•Created by Bubba on 12/31/2024 in #help-desk-support

[SOLVED] pg_restore immich backup into new CNPG instance

looks like my image db was restored. I haven't tested anything, but the instance comes online and I can see the photos and metadata

45 replies

•Created by Bubba on 12/31/2024 in #help-desk-support

[SOLVED] pg_restore immich backup into new CNPG instance

I don't have the "--username=immich" flag though

45 replies

•Created by Bubba on 12/31/2024 in #help-desk-support

[SOLVED] pg_restore immich backup into new CNPG instance

gunzip < "immich-db-backup-1735455600013.sql.gz"| sed "s/SELECT pg_catalog.set_config('search_path', '', false);/SELECT pg_catalog.set_config('search_path', 'public, pg_catalog', true);/g" | kubectl cnpg -n databases psql postgres-14 --

gunzip < "immich-db-backup-1735455600013.sql.gz"| sed "s/SELECT pg_catalog.set_config('search_path', '', false);/SELECT pg_catalog.set_config('search_path', 'public, pg_catalog', true);/g" | kubectl cnpg -n databases psql postgres-14 --

45 replies

•Created by Bubba on 12/31/2024 in #help-desk-support

[SOLVED] pg_restore immich backup into new CNPG instance

created a cnpg instance with the same image you use and I'm importing my backup. I think I figured out the syntax with the kubectl plugin

45 replies

•Created by Bubba on 12/31/2024 in #help-desk-support

[SOLVED] pg_restore immich backup into new CNPG instance

well, that's not working at all

45 replies

•Created by Bubba on 12/31/2024 in #help-desk-support

[SOLVED] pg_restore immich backup into new CNPG instance

postgres=*# ALTER EXTENSION vectors SET SCHEMA vectors;
ERROR:  extension "vectors" does not exist

postgres=*# ALTER EXTENSION vectors SET SCHEMA vectors;
ERROR:  extension "vectors" does not exist

45 replies

•Created by Bubba on 12/31/2024 in #help-desk-support

[SOLVED] pg_restore immich backup into new CNPG instance

looks like I gotta do this: https://github.com/immich-app/immich/releases/tag/v1.95.0

45 replies

•Created by Bubba on 12/31/2024 in #help-desk-support

[SOLVED] pg_restore immich backup into new CNPG instance

You are using image ghcr.io/tensorchord/cloudnative-pgvecto.rs:14.11-v0.2.1 and I am using image ghcr.io/tensorchord/cloudnative-pgvecto.rs:16.6-v0.4.0

45 replies

•Created by Bubba on 12/31/2024 in #help-desk-support

[SOLVED] pg_restore immich backup into new CNPG instance

➜  home-ops git:(main) ✗ kubectl -n media logs immich-server-5d4f56b9cb-q47cb
Defaulted container "immich-server" out of: immich-server, k8tz (init)
Initializing Immich v1.123.0
Detected CPU Cores: 8
Starting api worker
Starting microservices worker
(node:2) [DEP0060] DeprecationWarning: The `util._extend` API is deprecated. Please use Object.assign() instead.
(Use `node --trace-deprecation ...` to show where the warning was created)
(node:12) [DEP0060] DeprecationWarning: The `util._extend` API is deprecated. Please use Object.assign() instead.
(Use `node --trace-deprecation ...` to show where the warning was created)
(node:2) [DEP0060] DeprecationWarning: The `util._extend` API is deprecated. Please use Object.assign() instead.
(Use `node --trace-deprecation ...` to show where the warning was created)
[Nest] 2  - 12/31/2024, 11:09:23 AM     LOG [Microservices:EventRepository] Initialized websocket server
Error: The pgvecto.rs extension version is 0.1.1, but Immich only supports >=0.2 <0.4.
    Please change pgvecto.rs to a compatible version in the Postgres instance.
    at /usr/src/app/dist/services/database.service.js:79:23
    at process.processTicksAndRejections (node:internal/process/task_queues:105:5)
    at async /usr/src/app/dist/repositories/database.repository.js:197:23
microservices worker error: Error: The pgvecto.rs extension version is 0.1.1, but Immich only supports >=0.2 <0.4.
    Please change pgvecto.rs to a compatible version in the Postgres instance.
microservices worker exited with code 1
Killing api process

➜  home-ops git:(main) ✗ kubectl -n media logs immich-server-5d4f56b9cb-q47cb
Defaulted container "immich-server" out of: immich-server, k8tz (init)
Initializing Immich v1.123.0
Detected CPU Cores: 8
Starting api worker
Starting microservices worker
(node:2) [DEP0060] DeprecationWarning: The `util._extend` API is deprecated. Please use Object.assign() instead.
(Use `node --trace-deprecation ...` to show where the warning was created)
(node:12) [DEP0060] DeprecationWarning: The `util._extend` API is deprecated. Please use Object.assign() instead.
(Use `node --trace-deprecation ...` to show where the warning was created)
(node:2) [DEP0060] DeprecationWarning: The `util._extend` API is deprecated. Please use Object.assign() instead.
(Use `node --trace-deprecation ...` to show where the warning was created)
[Nest] 2  - 12/31/2024, 11:09:23 AM     LOG [Microservices:EventRepository] Initialized websocket server
Error: The pgvecto.rs extension version is 0.1.1, but Immich only supports >=0.2 <0.4.
    Please change pgvecto.rs to a compatible version in the Postgres instance.
    at /usr/src/app/dist/services/database.service.js:79:23
    at process.processTicksAndRejections (node:internal/process/task_queues:105:5)
    at async /usr/src/app/dist/repositories/database.repository.js:197:23
microservices worker error: Error: The pgvecto.rs extension version is 0.1.1, but Immich only supports >=0.2 <0.4.
    Please change pgvecto.rs to a compatible version in the Postgres instance.
microservices worker exited with code 1
Killing api process

45 replies

•Created by Bubba on 12/31/2024 in #help-desk-support

[SOLVED] pg_restore immich backup into new CNPG instance

bleh

45 replies

•Created by Bubba on 12/31/2024 in #help-desk-support

[SOLVED] pg_restore immich backup into new CNPG instance

🤞

45 replies