2025-10-23 00:13:16.061 UTC [1] LOG:  listening on IPv6 address "::", port 5432
2025-10-23 00:13:16.066 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2025-10-23 00:13:16.098 UTC [32] LOG:  database system was shut down at 2025-10-23 00:11:56 UTC
2025-10-23 00:13:16.258 UTC [1] LOG:  database system is ready to accept connections
2025-10-25 01:42:47.458 UTC [17160] ERROR:  duplicate key value violates unique constraint "UQ_assets_owner_checksum"
2025-10-25 01:42:47.458 UTC [17160] DETAIL:  Key ("ownerId", checksum)=(e40b2413-7749-4849-ab7f-dac34d79ee51, \xd5a3895048a73d1db466a2e315e37043d6ef5088) already exists.
2025-10-25 01:42:47.458 UTC [17160] STATEMENT:  insert into "asset" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning *
2025-10-25 22:31:35.892 UTC [24808] ERROR:  duplicate key value violates unique constraint "UQ_assets_owner_checksum"
2025-10-25 22:31:35.892 UTC [24808] DETAIL:  Key ("ownerId", checksum)=(e40b2413-7749-4849-ab7f-dac34d79ee51, \xd5a3895048a73d1db466a2e315e37043d6ef5088) already exists.
2025-10-25 22:31:35.892 UTC [24808] STATEMENT:  insert into "asset" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning *
2025-10-27 04:42:08.662 UTC [35393] ERROR:  duplicate key value violates unique constraint "UQ_assets_owner_checksum"
2025-10-27 04:42:08.662 UTC [35393] DETAIL:  Key ("ownerId", checksum)=(e40b2413-7749-4849-ab7f-dac34d79ee51, \xd5a3895048a73d1db466a2e315e37043d6ef5088) already exists.
2025-10-27 04:42:08.662 UTC [35393] STATEMENT:  insert into "asset" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning *
2025-10-30 10:23:11.729 UTC [62775] ERROR:  duplicate key value violates unique constraint "UQ_assets_owner_checksum"
2025-10-30 10:23:11.729 UTC [62775] DETAIL:  Key ("ownerId", checksum)=(e40b2413-7749-4849-ab7f-dac34d79ee51, \x9ca54af4c467cf20873b7031a998362bf876ec25) already exists.
2025-10-30 10:23:11.729 UTC [62775] STATEMENT:  insert into "asset" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning *
2025-11-01 20:07:39.799 UTC [1] LOG:  received fast shutdown request
2025-11-01 20:07:43.752 UTC [1] LOG:  aborting any active transactions
2025-11-01 20:07:44.253 UTC [1] LOG:  background worker "logical replication launcher" (PID 41) exited with exit code 1
2025-11-01 20:07:44.487 UTC [82831] FATAL:  terminating connection due to administrator command
2025-11-01 20:07:44.487 UTC [82832] FATAL:  terminating connection due to administrator command
2025-11-01 20:07:44.806 UTC [36] LOG:  shutting down
Using SSD storage
PostgreSQL Database directory appears to contain a database; Skipping initialization
2025-11-01 20:11:50.269 GMT [1] LOG:  skipping missing configuration file "/var/lib/postgresql/data/postgresql.override.conf"
2025-11-01 20:11:50.269 GMT [1] LOG:  skipping missing configuration file "/var/lib/postgresql/data/postgresql.override.conf"
2025-11-01 20:11:51.480 UTC [1] LOG:  starting PostgreSQL 14.19 (Debian 14.19-1.pgdg12+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14+deb12u1) 12.2.0, 64-bit
2025-11-01 20:11:51.490 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
2025-11-01 20:11:51.490 UTC [1] LOG:  listening on IPv6 address "::", port 5432
2025-11-01 20:11:51.495 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2025-11-01 20:11:51.506 UTC [43] LOG:  database system shutdown was interrupted; last known up at 2025-11-01 20:07:44 UTC
2025-11-01 20:11:51.613 UTC [43] LOG:  database system was not properly shut down; automatic recovery in progress
2025-11-01 20:11:51.725 UTC [43] LOG:  redo starts at 0/7DF43B58
2025-11-01 20:11:51.725 UTC [43] LOG:  invalid record length at 0/7DF43C40: wanted 24, got 0
2025-11-01 20:11:51.725 UTC [43] LOG:  redo done at 0/7DF43C08 system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s
2025-11-01 20:11:52.222 UTC [1] LOG:  database system is ready to accept connections
2025-11-02 15:49:49.839 UTC [6197] ERROR:  duplicate key value violates unique constraint "UQ_assets_owner_checksum"
2025-11-02 15:49:49.839 UTC [6197] DETAIL:  Key ("ownerId", checksum)=(e40b2413-7749-4849-ab7f-dac34d79ee51, \xb9c61933eddbe0442a9248794778052d7b5af13f) already exists.
2025-11-02 15:49:49.839 UTC [6197] STATEMENT:  insert into "asset" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning *
2025-11-02 16:20:00.606 UTC [6196] ERROR:  duplicate key value violates unique constraint "UQ_assets_owner_checksum"
2025-11-02 16:20:00.606 UTC [6196] DETAIL:  Key ("ownerId", checksum)=(e40b2413-7749-4849-ab7f-dac34d79ee51, \xb9c61933eddbe0442a9248794778052d7b5af13f) already exists.
2025-11-02 16:20:00.606 UTC [6196] STATEMENT:  insert into "asset" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning *
2025-11-02 16:20:00.639 UTC [6196] ERROR:  duplicate key value violates unique constraint "UQ_assets_owner_checksum"
2025-11-02 16:20:00.639 UTC [6196] DETAIL:  Key ("ownerId", checksum)=(e40b2413-7749-4849-ab7f-dac34d79ee51, \xd3c8489fd03eabb6a7020f9c8493d32214795825) already exists.
2025-11-02 16:20:00.639 UTC [6196] STATEMENT:  insert into "asset" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning *
2025-11-03 00:57:34.994 UTC [9469] ERROR:  duplicate key value violates unique constraint "UQ_assets_owner_checksum"
2025-11-03 00:57:34.994 UTC [9469] DETAIL:  Key ("ownerId", checksum)=(e40b2413-7749-4849-ab7f-dac34d79ee51, \xd3c8489fd03eabb6a7020f9c8493d32214795825) already exists.
2025-11-03 00:57:34.994 UTC [9469] STATEMENT:  insert into "asset" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning *
2025-11-03 07:43:41.874 UTC [11708] ERROR:  duplicate key value violates unique constraint "UQ_assets_owner_checksum"
2025-11-03 07:43:41.874 UTC [11708] DETAIL:  Key ("ownerId", checksum)=(e40b2413-7749-4849-ab7f-dac34d79ee51, \xd3c8489fd03eabb6a7020f9c8493d32214795825) already exists.
2025-11-03 07:43:41.874 UTC [11708] STATEMENT:  insert into "asset" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning *
2025-11-04 04:38:15.450 UTC [1] LOG:  received fast shutdown request
2025-11-04 04:38:16.619 UTC [1] LOG:  aborting any active transactions
2025-11-04 04:38:16.623 UTC [1] LOG:  background worker "logical replication launcher" (PID 52) exited with exit code 1
2025-11-04 04:38:16.654 UTC [47] LOG:  shutting down
2025-11-04 04:38:19.443 UTC [1] LOG:  database system is shut down
Using SSD storage
PostgreSQL Database directory appears to contain a database; Skipping initialization
2025-11-04 04:41:33.788 GMT [1] LOG:  skipping missing configuration file "/var/lib/postgresql/data/postgresql.override.conf"
2025-11-04 04:41:33.789 GMT [1] LOG:  skipping missing configuration file "/var/lib/postgresql/data/postgresql.override.conf"
2025-11-04 04:41:35.990 UTC [1] LOG:  starting PostgreSQL 14.19 (Debian 14.19-1.pgdg12+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14+deb12u1) 12.2.0, 64-bit
2025-11-04 04:41:36.001 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
2025-11-04 04:41:36.001 UTC [1] LOG:  listening on IPv6 address "::", port 5432
2025-11-04 04:41:36.017 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2025-11-04 04:41:36.064 UTC [43] LOG:  database system was shut down at 2025-11-04 04:38:19 UTC
2025-11-04 04:41:37.486 UTC [1] LOG:  database system is ready to accept connections
2025-11-06 04:44:14.607 UTC [16852] ERROR:  duplicate key value violates unique constraint "UQ_assets_owner_checksum"
2025-11-06 04:44:14.607 UTC [16852] DETAIL:  Key ("ownerId", checksum)=(e40b2413-7749-4849-ab7f-dac34d79ee51, \x7855d0df38891ce096c600f9fbd119f1e572b75c) already exists.
2025-11-06 04:44:14.607 UTC [16852] STATEMENT:  insert into "asset" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning *
2025-11-06 04:44:14.773 UTC [16759] ERROR:  duplicate key value violates unique constraint "UQ_assets_owner_checksum"
2025-11-06 04:44:14.773 UTC [16759] DETAIL:  Key ("ownerId", checksum)=(e40b2413-7749-4849-ab7f-dac34d79ee51, \x0ad1b0bec6eb2d24f26c4bcfcda18ef555dbf595) already exists.
2025-11-06 04:44:14.773 UTC [16759] STATEMENT:  insert into "asset" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning *
2025-11-06 04:44:14.786 UTC [16881] ERROR:  duplicate key value violates unique constraint "UQ_assets_owner_checksum"
2025-11-06 04:44:14.786 UTC [16881] DETAIL:  Key ("ownerId", checksum)=(e40b2413-7749-4849-ab7f-dac34d79ee51, \xc201f3bb021e313e4521bcb6a411fab2d4e087ef) already exists.
2025-11-06 04:44:14.786 UTC [16881] STATEMENT:  insert into "asset" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning *
2025-11-11 04:06:00.671 UTC [58713] ERROR:  duplicate key value violates unique constraint "UQ_assets_owner_checksum"
2025-11-11 04:06:00.671 UTC [58713] DETAIL:  Key ("ownerId", checksum)=(e40b2413-7749-4849-ab7f-dac34d79ee51, \xc64a77d67d08a49da5d0562253a80fd97e9610f7) already exists.
2025-11-11 04:06:00.671 UTC [58713] STATEMENT:  insert into "asset" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning *
2025-11-13 08:58:46.508 UTC [77489] ERROR:  duplicate key value violates unique constraint "UQ_assets_owner_checksum"
2025-11-13 08:58:46.508 UTC [77489] DETAIL:  Key ("ownerId", checksum)=(e40b2413-7749-4849-ab7f-dac34d79ee51, \x6891fb2ac80c958ccd89ab3708f90bbc8caeb1b0) already exists.
2025-11-13 08:58:46.508 UTC [77489] STATEMENT:  insert into "asset" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning *
2025-11-13 09:33:25.407 UTC [77489] ERROR:  duplicate key value violates unique constraint "UQ_assets_owner_checksum"
2025-11-13 09:33:25.407 UTC [77489] DETAIL:  Key ("ownerId", checksum)=(e40b2413-7749-4849-ab7f-dac34d79ee51, \x201ac4fe23470f7e1282126171e971c413f5a543) already exists.
2025-11-13 09:33:25.407 UTC [77489] STATEMENT:  insert into "asset" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning *
2025-11-13 09:33:25.701 UTC [77489] ERROR:  duplicate key value violates unique constraint "UQ_assets_owner_checksum"
2025-11-13 09:33:25.701 UTC [77489] DETAIL:  Key ("ownerId", checksum)=(e40b2413-7749-4849-ab7f-dac34d79ee51, \x6891fb2ac80c958ccd89ab3708f90bbc8caeb1b0) already exists.
2025-11-13 09:33:25.701 UTC [77489] STATEMENT:  insert into "asset" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning *
2025-11-13 10:03:48.484 UTC [77871] ERROR:  duplicate key value violates unique constraint "UQ_assets_owner_checksum"
2025-11-13 10:03:48.484 UTC [77871] DETAIL:  Key ("ownerId", checksum)=(e40b2413-7749-4849-ab7f-dac34d79ee51, \x201ac4fe23470f7e1282126171e971c413f5a543) already exists.
2025-11-13 10:03:48.484 UTC [77871] STATEMENT:  insert into "asset" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning *
2025-11-13 10:03:49.239 UTC [77872] ERROR:  duplicate key value violates unique constraint "UQ_assets_owner_checksum"
2025-11-13 10:03:49.239 UTC [77872] DETAIL:  Key ("ownerId", checksum)=(e40b2413-7749-4849-ab7f-dac34d79ee51, \x6891fb2ac80c958ccd89ab3708f90bbc8caeb1b0) already exists.
2025-11-13 10:03:49.239 UTC [77872] STATEMENT:  insert into "asset" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning *
2025-11-13 10:34:40.317 UTC [77872] ERROR:  duplicate key value violates unique constraint "UQ_assets_owner_checksum"
2025-11-13 10:34:40.317 UTC [77872] DETAIL:  Key ("ownerId", checksum)=(e40b2413-7749-4849-ab7f-dac34d79ee51, \x6891fb2ac80c958ccd89ab3708f90bbc8caeb1b0) already exists.
2025-11-13 10:34:40.317 UTC [77872] STATEMENT:  insert into "asset" ("ownerId", "libraryId", "checksum", "originalPath", "deviceAssetId", "deviceId", "fileCreatedAt", "fileModifiedAt", "localDateTime", "type", "isFavorite", "duration", "visibility", "originalFileName") values ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14) returning *