{"level":"info","ts":"2025-05-06T21:31:35.39686133Z","logger":"postgres","msg":"record","logging_pod":"immich-pg-2","record":{"log_time":"2025-05-06 21:31:35.396 UTC","user_name":"immich","database_name":"immich","process_id":"20150","connection_from":"fd00:cafe:1::2a25:49670","session_id":"681a7dbe.4eb6","session_line_num":"15","command_tag":"PARSE","session_start_time":"2025-05-06 21:23:10 UTC","virtual_transaction_id":"11/1319","transaction_id":"0","error_severity":"ERROR","sql_state_code":"42883","message":"operator does not exist: vectors.vector <=> unknown","hint":"No operator matches the given name and argument types. You might need to add explicit type casts.","query":"with \"cte\" as (select \"asset_faces\".\"id\", \"asset_faces\".\"personId\", face_search.embedding <=> $1 as \"distance\" from \"asset_faces\" inner join \"assets\" on \"assets\".\"id\" = \"asset_faces\".\"assetId\" inner join \"face_search\" on \"face_search\".\"faceId\" = \"asset_faces\".\"id\" left join \"person\" on \"person\".\"id\" = \"asset_faces\".\"personId\" where \"assets\".\"ownerId\" = any($2::uuid[]) and \"assets\".\"deletedAt\" is null and (\"person\".\"birthDate\" is null or \"person\".\"birthDate\" <= $3) order by face_search.embedding <=> $4 limit $5) select * from \"cte\" where \"cte\".\"distance\" <= $6","query_pos":"91","application_name":"postgres.js","backend_type":"client backend","query_id":"0"}}
{"level":"info","ts":"2025-05-06T21:35:54.110498811Z","logger":"postgres","msg":"record","logging_pod":"immich-pg-2","record":{"log_time":"2025-05-06 21:35:54.106 UTC","process_id":"27","session_id":"6819c0af.1b","session_line_num":"60","session_start_time":"2025-05-06 07:56:31 UTC","transaction_id":"0","error_severity":"LOG","sql_state_code":"00000","message":"checkpoint starting: time","backend_type":"checkpointer","query_id":"0"}}

{"level":"info","ts":"2025-05-06T21:31:35.39686133Z","logger":"postgres","msg":"record","logging_pod":"immich-pg-2","record":{"log_time":"2025-05-06 21:31:35.396 UTC","user_name":"immich","database_name":"immich","process_id":"20150","connection_from":"fd00:cafe:1::2a25:49670","session_id":"681a7dbe.4eb6","session_line_num":"15","command_tag":"PARSE","session_start_time":"2025-05-06 21:23:10 UTC","virtual_transaction_id":"11/1319","transaction_id":"0","error_severity":"ERROR","sql_state_code":"42883","message":"operator does not exist: vectors.vector <=> unknown","hint":"No operator matches the given name and argument types. You might need to add explicit type casts.","query":"with \"cte\" as (select \"asset_faces\".\"id\", \"asset_faces\".\"personId\", face_search.embedding <=> $1 as \"distance\" from \"asset_faces\" inner join \"assets\" on \"assets\".\"id\" = \"asset_faces\".\"assetId\" inner join \"face_search\" on \"face_search\".\"faceId\" = \"asset_faces\".\"id\" left join \"person\" on \"person\".\"id\" = \"asset_faces\".\"personId\" where \"assets\".\"ownerId\" = any($2::uuid[]) and \"assets\".\"deletedAt\" is null and (\"person\".\"birthDate\" is null or \"person\".\"birthDate\" <= $3) order by face_search.embedding <=> $4 limit $5) select * from \"cte\" where \"cte\".\"distance\" <= $6","query_pos":"91","application_name":"postgres.js","backend_type":"client backend","query_id":"0"}}
{"level":"info","ts":"2025-05-06T21:35:54.110498811Z","logger":"postgres","msg":"record","logging_pod":"immich-pg-2","record":{"log_time":"2025-05-06 21:35:54.106 UTC","process_id":"27","session_id":"6819c0af.1b","session_line_num":"60","session_start_time":"2025-05-06 07:56:31 UTC","transaction_id":"0","error_severity":"LOG","sql_state_code":"00000","message":"checkpoint starting: time","backend_type":"checkpointer","query_id":"0"}}

[...]
[05/06/25 21:36:34] INFO     Shutting down due to inactivity.
[05/06/25 21:36:34] INFO     Shutting down
[05/06/25 21:36:34] INFO     Waiting for application shutdown.
[05/06/25 21:36:34] INFO     Application shutdown complete.
[05/06/25 21:36:34] INFO     Finished server process [365]
[05/06/25 21:36:34] ERROR    Worker (pid:365) was sent SIGINT!
[05/06/25 21:36:34] INFO     Booting worker with pid: 414
[05/06/25 21:36:37] INFO     Started server process [414]
[05/06/25 21:36:37] INFO     Waiting for application startup.
[05/06/25 21:36:37] INFO     Created in-memory cache with unloading after 300s
                             of inactivity.
[05/06/25 21:36:37] INFO     Initialized request thread pool with 8 threads.
[05/06/25 21:36:37] INFO     Application startup complete.

[...]
[05/06/25 21:36:34] INFO     Shutting down due to inactivity.
[05/06/25 21:36:34] INFO     Shutting down
[05/06/25 21:36:34] INFO     Waiting for application shutdown.
[05/06/25 21:36:34] INFO     Application shutdown complete.
[05/06/25 21:36:34] INFO     Finished server process [365]
[05/06/25 21:36:34] ERROR    Worker (pid:365) was sent SIGINT!
[05/06/25 21:36:34] INFO     Booting worker with pid: 414
[05/06/25 21:36:37] INFO     Started server process [414]
[05/06/25 21:36:37] INFO     Waiting for application startup.
[05/06/25 21:36:37] INFO     Created in-memory cache with unloading after 300s
                             of inactivity.
[05/06/25 21:36:37] INFO     Initialized request thread pool with 8 threads.
[05/06/25 21:36:37] INFO     Application startup complete.