Facial Recognition Failing - Postgres error
Very new install, less than a few weeks old, running on Kubernetes. From initial install I've been unable to run the facial recognition and receiving this error:
```
[Nest] 7 - 09/09/2025, 3:17:02 PM ERROR [Microservices:{"id":"81bbaba6-5adf-42ff-aa31-19c682fcb250"}] Unable to run job handler (AssetDetectFaces): PostgresError: pgvecto.rs: The index is not existing in the background worker.
ADVICE: Drop or rebuild the index.
PostgresError: pgvecto.rs: The index is not existing in the background worker.
ADVICE: Drop or rebuild the index.
at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26)
at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6)
at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9)
at Socket.emit (node:events:519:28)
at addChunk (node:internal/streams/readable:561:12)
at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
at Readable.push (node:internal/streams/readable:392:5)
at TCP.onStreamRead (node:internal/stream_base_commons:189:23)
Query failed : {
durationMs: 1.3347509987652302,
error: PostgresError: pgvecto.rs: The index is not existing in the background worker.
ADVICE: Drop or rebuild the index.
at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26)
at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6)
at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9)
at Socket.emit (node:events:519:28)
at addChunk (node:internal/streams/readable:561:12)
at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
at Readable.push (node:internal/streams/readable:392:5)
at TCP.onStreamRead (node:internal/stream_base_commons:189:23) {
severity_local: 'ERROR',
severity: 'ERROR',
code: 'XX000',
file: 'error.rs',
line: '7'
},
```
[Nest] 7 - 09/09/2025, 3:17:02 PM ERROR [Microservices:{"id":"81bbaba6-5adf-42ff-aa31-19c682fcb250"}] Unable to run job handler (AssetDetectFaces): PostgresError: pgvecto.rs: The index is not existing in the background worker.
ADVICE: Drop or rebuild the index.
PostgresError: pgvecto.rs: The index is not existing in the background worker.
ADVICE: Drop or rebuild the index.
at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26)
at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6)
at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9)
at Socket.emit (node:events:519:28)
at addChunk (node:internal/streams/readable:561:12)
at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
at Readable.push (node:internal/streams/readable:392:5)
at TCP.onStreamRead (node:internal/stream_base_commons:189:23)
Query failed : {
durationMs: 1.3347509987652302,
error: PostgresError: pgvecto.rs: The index is not existing in the background worker.
ADVICE: Drop or rebuild the index.
at ErrorResponse (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:794:26)
at handle (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:480:6)
at Socket.data (/usr/src/app/server/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/cjs/src/connection.js:315:9)
at Socket.emit (node:events:519:28)
at addChunk (node:internal/streams/readable:561:12)
at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
at Readable.push (node:internal/streams/readable:392:5)
at TCP.onStreamRead (node:internal/stream_base_commons:189:23) {
severity_local: 'ERROR',
severity: 'ERROR',
code: 'XX000',
file: 'error.rs',
line: '7'
},
