Postgres crash in the middle of indexing since 1.133.1 version of immich
Hello,
Having problems with new "breaking changes". The main problem is being stupid: 1) not making backups 2) other small errors.
At this stage I ask for further steps just to not lose postgres DB. Which is already >75GB (because of crashes)
Here is log from docker compose:
Having problems with new "breaking changes". The main problem is being stupid: 1) not making backups 2) other small errors.
At this stage I ask for further steps just to not lose postgres DB. Which is already >75GB (because of crashes)
Here is log from docker compose:
immich-server:
...
database:
[1] LOG: server process (PID 114) was terminated by signal 9: Killed
[1] DETAIL: Failed process was running:
CREATE INDEX IF NOT EXISTS clip_index ON smart_search USING vchordrq (embedding vector_cosine_ops) WITH (options = $$
residual_quantization = false
[build.internal]
lists = [1024]
spherical_centroids = true
build_threads = 4
sampling_factor = 1024
$$)
[1] LOG: terminating any other active server processes
immich-server:
Postgres notice: {
severity_local: 'WARNING',
severity: 'WARNING',
code: '57P02',
message: 'terminating connection because of crash of another server process',
file: 'postgres.c',
line: '2916',
routine: 'quickdie'
}
Query failed : {
durationMs: 37559.63190200005,
error: Error: write CONNECTION_CLOSED database:5432
at Socket.closed (/usr/src/app/node_modules/postgres/cjs/src/connection.js:440:57)
at Socket.emit (node:events:518:28)
at TCP.<anonymous> (node:net:351:12) {
code: 'CONNECTION_CLOSED',
errno: 'CONNECTION_CLOSED',
address: [ 'database' ],
port: [ 5432 ]
},
sql: '\n' +
' CREATE INDEX IF NOT EXISTS clip_index ON smart_search USING vchordrq (embedding vector_cosine_ops) WITH (options = $$\n' +
' residual_quantization = false\n' +
' [build.internal]\n' +
' lists = [1024]\n' +
' spherical_centroids = true\n' +
' build_threads = 4\n' +
' sampling_factor = 1024\n' +
' $$)',
params: []
}
...
/usr/src/app/node_modules/postgres/cjs/src/connection.js:250
const x = socket.write(chunk, fn)
^
...
database:
[1] LOG: all server processes terminated; reinitializing
...immich-server:
...
database:
[1] LOG: server process (PID 114) was terminated by signal 9: Killed
[1] DETAIL: Failed process was running:
CREATE INDEX IF NOT EXISTS clip_index ON smart_search USING vchordrq (embedding vector_cosine_ops) WITH (options = $$
residual_quantization = false
[build.internal]
lists = [1024]
spherical_centroids = true
build_threads = 4
sampling_factor = 1024
$$)
[1] LOG: terminating any other active server processes
immich-server:
Postgres notice: {
severity_local: 'WARNING',
severity: 'WARNING',
code: '57P02',
message: 'terminating connection because of crash of another server process',
file: 'postgres.c',
line: '2916',
routine: 'quickdie'
}
Query failed : {
durationMs: 37559.63190200005,
error: Error: write CONNECTION_CLOSED database:5432
at Socket.closed (/usr/src/app/node_modules/postgres/cjs/src/connection.js:440:57)
at Socket.emit (node:events:518:28)
at TCP.<anonymous> (node:net:351:12) {
code: 'CONNECTION_CLOSED',
errno: 'CONNECTION_CLOSED',
address: [ 'database' ],
port: [ 5432 ]
},
sql: '\n' +
' CREATE INDEX IF NOT EXISTS clip_index ON smart_search USING vchordrq (embedding vector_cosine_ops) WITH (options = $$\n' +
' residual_quantization = false\n' +
' [build.internal]\n' +
' lists = [1024]\n' +
' spherical_centroids = true\n' +
' build_threads = 4\n' +
' sampling_factor = 1024\n' +
' $$)',
params: []
}
...
/usr/src/app/node_modules/postgres/cjs/src/connection.js:250
const x = socket.write(chunk, fn)
^
...
database:
[1] LOG: all server processes terminated; reinitializing
...