2025-06-03 22:02:56.107 UTC [27] LOG: checkpoint complete: wrote 6766 buffers (41.3%); 0 WAL file(s) added, 0 removed, 7 recycled; write=269.969 s, sync=0.020 s, total=270.014 s; sync files=99, longest=0.001 s, average=0.001 s; distance=122043 kB, estimate=122043 kB; lsn=C02/28B1748, redo lsn=C02/2801EF0 2025-06-03 22:03:26.138 UTC [27] LOG: checkpoint starting: time 2025-06-03 22:03:30.170 UTC [27] LOG: checkpoint complete: wrote 41 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=4.016 s, sync=0.006 s, total=4.033 s; sync files=12, longest=0.003 s, average=0.001 s; distance=717 kB, estimate=109911 kB; lsn=C02/28BACE8, redo lsn=C02/28B55B0 2025-06-03 22:08:26.257 UTC [27] LOG: checkpoint starting: time 2025-06-03 22:12:56.049 UTC [27] LOG: checkpoint complete: wrote 2291 buffers (14.0%); 0 WAL file(s) added, 0 removed, 2 recycled; write=269.756 s, sync=0.021 s, total=269.792 s; sync files=101, longest=0.001 s, average=0.001 s; distance=27140 kB, estimate=101634 kB; lsn=C02/6A56148, redo lsn=C02/4336870 2025-06-03 22:13:26.067 UTC [27] LOG: checkpoint starting: time 2025-06-03 22:17:56.023 UTC [27] LOG: checkpoint complete: wrote 3176 buffers (19.4%); 0 WAL file(s) added, 0 removed, 2 recycled; write=269.927 s, sync=0.015 s, total=269.956 s; sync files=60, longest=0.003 s, average=0.001 s; distance=40121 kB, estimate=95482 kB; lsn=C02/6ABF0B0, redo lsn=C02/6A64DD8 2025-06-03 22:18:14.717 UTC [7624] ERROR: deadlock detected 2025-06-03 22:18:14.717 UTC [7624] DETAIL: Process 7624 waits for AccessExclusiveLock on tuple (182243,19) of relation 16394 of database 13470; blocked by process 7603. #011Process 7603 waits for ShareLock on transaction 702901466; blocked by process 7599. #011Process 7599 waits for ShareLock on transaction 702901489; blocked by process 7626. #011Process 7626 waits for AccessExclusiveLock on tuple (182243,19) of relation 16394 of database 13470; blocked by process 7624. #011Process 7624: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7603: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7599: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7626: SELECT * FROM UpdateInvalidChildCounts() 2025-06-03 22:18:14.717 UTC [7624] HINT: See server log for query details. 2025-06-03 22:18:14.717 UTC [7624] CONTEXT: SQL statement "SELECT internalid FROM "resources" WHERE publicId = patient_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 14 at SQL statement 2025-06-03 22:18:14.717 UTC [7624] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-03 22:18:14.718 UTC [7628] ERROR: deadlock detected 2025-06-03 22:18:14.718 UTC [7628] DETAIL: Process 7628 waits for AccessExclusiveLock on tuple (182243,19) of relation 16394 of database 13470; blocked by process 7603. #011Process 7603 waits for ShareLock on transaction 702901466; blocked by process 7599. #011Process 7599 waits for ShareLock on transaction 702901489; blocked by process 7626. #011Process 7626 waits for AccessExclusiveLock on tuple (182243,19) of relation 16394 of database 13470; blocked by process 7628. #011Process 7628: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7603: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7599: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7626: SELECT * FROM UpdateInvalidChildCounts() 2025-06-03 22:18:14.718 UTC [7628] HINT: See server log for query details. 2025-06-03 22:18:14.718 UTC [7628] CONTEXT: SQL statement "SELECT internalid FROM "resources" WHERE publicId = patient_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 14 at SQL statement 2025-06-03 22:18:14.718 UTC [7628] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-03 22:18:14.759 UTC [7618] ERROR: deadlock detected 2025-06-03 22:18:14.759 UTC [7618] DETAIL: Process 7618 waits for AccessExclusiveLock on tuple (182243,19) of relation 16394 of database 13470; blocked by process 7603. #011Process 7603 waits for ShareLock on transaction 702901466; blocked by process 7599. #011Process 7599 waits for ShareLock on transaction 702901489; blocked by process 7626. #011Process 7626 waits for AccessExclusiveLock on tuple (182243,19) of relation 16394 of database 13470; blocked by process 7618. #011Process 7618: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7603: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7599: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7626: SELECT * FROM UpdateInvalidChildCounts() 2025-06-03 22:18:14.759 UTC [7618] HINT: See server log for query details. 2025-06-03 22:18:14.759 UTC [7618] CONTEXT: SQL statement "SELECT internalid FROM "resources" WHERE publicId = patient_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 14 at SQL statement 2025-06-03 22:18:14.759 UTC [7618] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-03 22:18:14.760 UTC [7626] ERROR: deadlock detected 2025-06-03 22:18:14.760 UTC [7626] DETAIL: Process 7626 waits for AccessExclusiveLock on tuple (182243,19) of relation 16394 of database 13470; blocked by process 7603. #011Process 7603 waits for ShareLock on transaction 702901466; blocked by process 7599. #011Process 7599 waits for ShareLock on transaction 702901489; blocked by process 7626. #011Process 7626: SELECT * FROM UpdateInvalidChildCounts() #011Process 7603: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7599: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-03 22:18:14.760 UTC [7626] HINT: See server log for query details. 2025-06-03 22:18:14.760 UTC [7626] CONTEXT: SQL statement "SELECT ARRAY(SELECT internalId #011 FROM Resources #011 WHERE internalId IN (SELECT DISTINCT id FROM InvalidChildCounts) #011 FOR UPDATE)" #011PL/pgSQL function updateinvalidchildcounts() line 8 at SQL statement 2025-06-03 22:18:14.760 UTC [7626] STATEMENT: SELECT * FROM UpdateInvalidChildCounts() 2025-06-03 22:18:26.048 UTC [27] LOG: checkpoint starting: time 2025-06-03 22:22:56.112 UTC [27] LOG: checkpoint complete: wrote 1552 buffers (9.5%); 0 WAL file(s) added, 0 removed, 1 recycled; write=270.024 s, sync=0.027 s, total=270.064 s; sync files=93, longest=0.004 s, average=0.001 s; distance=18979 kB, estimate=87832 kB; lsn=C02/C15C450, redo lsn=C02/7CEDC60 2025-06-03 22:23:26.142 UTC [27] LOG: checkpoint starting: time 2025-06-03 22:27:56.055 UTC [27] LOG: checkpoint complete: wrote 2390 buffers (14.6%); 0 WAL file(s) added, 0 removed, 5 recycled; write=269.867 s, sync=0.025 s, total=269.913 s; sync files=93, longest=0.003 s, average=0.001 s; distance=78163 kB, estimate=86865 kB; lsn=C02/12ABA218, redo lsn=C02/C942B00 2025-06-03 22:28:26.065 UTC [27] LOG: checkpoint starting: time 2025-06-03 22:32:56.142 UTC [27] LOG: checkpoint complete: wrote 2809 buffers (17.1%); 0 WAL file(s) added, 0 removed, 7 recycled; write=270.022 s, sync=0.026 s, total=270.077 s; sync files=91, longest=0.003 s, average=0.001 s; distance=107267 kB, estimate=107267 kB; lsn=C02/17F86FE8, redo lsn=C02/13203750 2025-06-03 22:33:26.171 UTC [27] LOG: checkpoint starting: time 2025-06-03 22:37:56.038 UTC [27] LOG: checkpoint complete: wrote 3447 buffers (21.0%); 0 WAL file(s) added, 0 removed, 6 recycled; write=269.820 s, sync=0.022 s, total=269.868 s; sync files=93, longest=0.003 s, average=0.001 s; distance=107729 kB, estimate=107729 kB; lsn=C02/1C1522D0, redo lsn=C02/19B37C38 2025-06-03 22:38:26.044 UTC [27] LOG: checkpoint starting: time 2025-06-03 22:42:56.088 UTC [27] LOG: checkpoint complete: wrote 3722 buffers (22.7%); 0 WAL file(s) added, 0 removed, 3 recycled; write=270.012 s, sync=0.015 s, total=270.044 s; sync files=61, longest=0.002 s, average=0.001 s; distance=39033 kB, estimate=100859 kB; lsn=C02/1C1B43B8, redo lsn=C02/1C156150 2025-06-03 22:43:26.110 UTC [27] LOG: checkpoint starting: time 2025-06-03 22:47:56.104 UTC [27] LOG: checkpoint complete: wrote 2659 buffers (16.2%); 0 WAL file(s) added, 0 removed, 1 recycled; write=269.963 s, sync=0.019 s, total=269.994 s; sync files=92, longest=0.002 s, average=0.001 s; distance=16585 kB, estimate=92432 kB; lsn=C02/1D1F5650, redo lsn=C02/1D188820 2025-06-03 22:48:26.120 UTC [27] LOG: checkpoint starting: time 2025-06-03 22:48:44.626 UTC [27] LOG: checkpoint complete: wrote 186 buffers (1.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=18.479 s, sync=0.017 s, total=18.506 s; sync files=62, longest=0.003 s, average=0.001 s; distance=757 kB, estimate=83264 kB; lsn=C02/1D25B3E8, redo lsn=C02/1D245EE0 2025-06-03 22:53:26.713 UTC [27] LOG: checkpoint starting: time 2025-06-03 22:57:47.600 UTC [27] LOG: checkpoint complete: wrote 2073 buffers (12.7%); 0 WAL file(s) added, 0 removed, 1 recycled; write=260.857 s, sync=0.018 s, total=260.888 s; sync files=69, longest=0.003 s, average=0.001 s; distance=18761 kB, estimate=76814 kB; lsn=C02/1F233428, redo lsn=C02/1E498670 2025-06-03 22:58:26.621 UTC [27] LOG: checkpoint starting: time 2025-06-03 23:01:58.586 UTC [27] LOG: checkpoint complete: wrote 2116 buffers (12.9%); 0 WAL file(s) added, 1 removed, 0 recycled; write=211.929 s, sync=0.017 s, total=211.966 s; sync files=68, longest=0.003 s, average=0.001 s; distance=14060 kB, estimate=70539 kB; lsn=C02/1F629128, redo lsn=C02/1F2536F8 2025-06-03 23:03:26.673 UTC [27] LOG: checkpoint starting: time 2025-06-03 23:04:34.346 UTC [27] LOG: checkpoint complete: wrote 677 buffers (4.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=67.655 s, sync=0.008 s, total=67.673 s; sync files=28, longest=0.003 s, average=0.001 s; distance=4426 kB, estimate=63927 kB; lsn=C02/1F720398, redo lsn=C02/1F6A6220 2025-06-03 23:08:26.444 UTC [27] LOG: checkpoint starting: time 2025-06-03 23:09:46.854 UTC [27] LOG: checkpoint complete: wrote 803 buffers (4.9%); 0 WAL file(s) added, 0 removed, 0 recycled; write=80.378 s, sync=0.022 s, total=80.411 s; sync files=71, longest=0.003 s, average=0.001 s; distance=4860 kB, estimate=58021 kB; lsn=C02/2028AB58, redo lsn=C02/1FB65248 2025-06-03 23:13:26.923 UTC [27] LOG: checkpoint starting: time 2025-06-03 23:17:56.103 UTC [27] LOG: checkpoint complete: wrote 5192 buffers (31.7%); 0 WAL file(s) added, 2 removed, 2 recycled; write=269.130 s, sync=0.022 s, total=269.180 s; sync files=92, longest=0.003 s, average=0.001 s; distance=57897 kB, estimate=58008 kB; lsn=C02/26D67818, redo lsn=C02/233EF700 2025-06-03 23:18:26.131 UTC [27] LOG: checkpoint starting: time 2025-06-03 23:22:56.147 UTC [27] LOG: checkpoint complete: wrote 4132 buffers (25.2%); 0 WAL file(s) added, 0 removed, 5 recycled; write=269.960 s, sync=0.032 s, total=270.016 s; sync files=97, longest=0.003 s, average=0.001 s; distance=89435 kB, estimate=89435 kB; lsn=C02/2F0269A8, redo lsn=C02/28B46458 2025-06-03 23:23:26.176 UTC [27] LOG: checkpoint starting: time 2025-06-03 23:27:56.051 UTC [27] LOG: checkpoint complete: wrote 3159 buffers (19.3%); 0 WAL file(s) added, 0 removed, 8 recycled; write=269.811 s, sync=0.027 s, total=269.876 s; sync files=99, longest=0.003 s, average=0.001 s; distance=131817 kB, estimate=131817 kB; lsn=C02/37474CF0, redo lsn=C02/30C00888 2025-06-03 23:28:26.079 UTC [27] LOG: checkpoint starting: time 2025-06-03 23:32:56.090 UTC [27] LOG: checkpoint complete: wrote 2516 buffers (15.4%); 0 WAL file(s) added, 0 removed, 9 recycled; write=269.949 s, sync=0.031 s, total=270.011 s; sync files=103, longest=0.003 s, average=0.001 s; distance=137293 kB, estimate=137293 kB; lsn=C02/3E68D368, redo lsn=C02/39213D80 2025-06-03 23:33:26.096 UTC [27] LOG: checkpoint starting: time 2025-06-03 23:37:56.115 UTC [27] LOG: checkpoint complete: wrote 3495 buffers (21.3%); 0 WAL file(s) added, 0 removed, 5 recycled; write=269.972 s, sync=0.024 s, total=270.020 s; sync files=82, longest=0.003 s, average=0.001 s; distance=87328 kB, estimate=132296 kB; lsn=C02/3F579B70, redo lsn=C02/3E75C050 2025-06-03 23:38:26.143 UTC [27] LOG: checkpoint starting: time 2025-06-03 23:42:56.048 UTC [27] LOG: checkpoint complete: wrote 3799 buffers (23.2%); 0 WAL file(s) added, 0 removed, 3 recycled; write=269.862 s, sync=0.025 s, total=269.905 s; sync files=95, longest=0.004 s, average=0.001 s; distance=47390 kB, estimate=123806 kB; lsn=C02/4454C898, redo lsn=C02/415A3AF8 2025-06-03 23:43:26.056 UTC [27] LOG: checkpoint starting: time 2025-06-03 23:47:56.101 UTC [27] LOG: checkpoint complete: wrote 4585 buffers (28.0%); 0 WAL file(s) added, 0 removed, 3 recycled; write=270.004 s, sync=0.022 s, total=270.045 s; sync files=94, longest=0.003 s, average=0.001 s; distance=56124 kB, estimate=117038 kB; lsn=C02/45AA0C98, redo lsn=C02/44C72DF0 2025-06-03 23:48:26.118 UTC [27] LOG: checkpoint starting: time 2025-06-03 23:52:17.710 UTC [27] LOG: checkpoint complete: wrote 1870 buffers (11.4%); 0 WAL file(s) added, 0 removed, 1 recycled; write=231.560 s, sync=0.019 s, total=231.592 s; sync files=81, longest=0.002 s, average=0.001 s; distance=17123 kB, estimate=107046 kB; lsn=C02/47AB3790, redo lsn=C02/45D2BC98 2025-06-03 23:53:26.777 UTC [27] LOG: checkpoint starting: time 2025-06-03 23:57:56.126 UTC [27] LOG: checkpoint complete: wrote 3761 buffers (23.0%); 0 WAL file(s) added, 1 removed, 1 recycled; write=269.309 s, sync=0.017 s, total=269.349 s; sync files=73, longest=0.002 s, average=0.001 s; distance=30275 kB, estimate=99369 kB; lsn=C02/47AF2210, redo lsn=C02/47ABC8E8 2025-06-03 23:58:26.143 UTC [27] LOG: checkpoint starting: time 2025-06-03 23:58:27.664 UTC [27] LOG: checkpoint complete: wrote 16 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.508 s, sync=0.005 s, total=1.522 s; sync files=10, longest=0.003 s, average=0.001 s; distance=229 kB, estimate=89455 kB; lsn=C02/47AF8480, redo lsn=C02/47AF6058 2025-06-04 00:03:26.726 UTC [27] LOG: checkpoint starting: time 2025-06-04 00:03:28.048 UTC [27] LOG: checkpoint complete: wrote 14 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.309 s, sync=0.005 s, total=1.322 s; sync files=8, longest=0.003 s, average=0.001 s; distance=223 kB, estimate=80532 kB; lsn=C02/47B2FF00, redo lsn=C02/47B2DCA0 2025-06-04 00:08:26.147 UTC [27] LOG: checkpoint starting: time 2025-06-04 00:10:36.643 UTC [27] LOG: checkpoint complete: wrote 756 buffers (4.6%); 0 WAL file(s) added, 1 removed, 0 recycled; write=130.461 s, sync=0.019 s, total=130.496 s; sync files=71, longest=0.003 s, average=0.001 s; distance=8264 kB, estimate=73305 kB; lsn=C02/49F179E0, redo lsn=C02/4833FCD0 2025-06-04 00:13:26.728 UTC [27] LOG: checkpoint starting: time 2025-06-04 00:17:56.099 UTC [27] LOG: checkpoint complete: wrote 2996 buffers (18.3%); 0 WAL file(s) added, 1 removed, 0 recycled; write=269.344 s, sync=0.008 s, total=269.372 s; sync files=27, longest=0.003 s, average=0.001 s; distance=28600 kB, estimate=68834 kB; lsn=C02/49F64B18, redo lsn=C02/49F2DD18 2025-06-04 00:18:26.104 UTC [27] LOG: checkpoint starting: time 2025-06-04 00:18:27.524 UTC [27] LOG: checkpoint complete: wrote 15 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.408 s, sync=0.005 s, total=1.421 s; sync files=8, longest=0.003 s, average=0.001 s; distance=234 kB, estimate=61974 kB; lsn=C02/49F6AA60, redo lsn=C02/49F68718 2025-06-04 00:23:26.624 UTC [27] LOG: checkpoint starting: time 2025-06-04 00:23:27.847 UTC [27] LOG: checkpoint complete: wrote 13 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.207 s, sync=0.005 s, total=1.223 s; sync files=8, longest=0.003 s, average=0.001 s; distance=210 kB, estimate=55798 kB; lsn=C02/49F9F1C0, redo lsn=C02/49F9CF70 2025-06-04 00:28:26.924 UTC [27] LOG: checkpoint starting: time 2025-06-04 00:28:28.650 UTC [27] LOG: checkpoint complete: wrote 18 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.711 s, sync=0.005 s, total=1.726 s; sync files=10, longest=0.003 s, average=0.001 s; distance=233 kB, estimate=50241 kB; lsn=C02/49FD9870, redo lsn=C02/49FD75D8 2025-06-04 00:33:26.741 UTC [27] LOG: checkpoint starting: time 2025-06-04 00:37:56.137 UTC [27] LOG: checkpoint complete: wrote 4327 buffers (26.4%); 0 WAL file(s) added, 3 removed, 0 recycled; write=269.344 s, sync=0.018 s, total=269.396 s; sync files=93, longest=0.001 s, average=0.001 s; distance=39616 kB, estimate=49179 kB; lsn=C02/4C74C880, redo lsn=C02/4C6876B0 2025-06-04 00:38:26.168 UTC [27] LOG: checkpoint starting: time 2025-06-04 00:38:30.504 UTC [27] LOG: checkpoint complete: wrote 45 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=4.319 s, sync=0.008 s, total=4.337 s; sync files=23, longest=0.004 s, average=0.001 s; distance=804 kB, estimate=44341 kB; lsn=C02/4C7577E8, redo lsn=C02/4C7506C8 2025-06-04 00:43:26.593 UTC [27] LOG: checkpoint starting: time 2025-06-04 00:43:28.016 UTC [27] LOG: checkpoint complete: wrote 15 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.408 s, sync=0.005 s, total=1.424 s; sync files=9, longest=0.003 s, average=0.001 s; distance=223 kB, estimate=39929 kB; lsn=C02/4C78A6B8, redo lsn=C02/4C788410 2025-06-04 00:48:26.103 UTC [27] LOG: checkpoint starting: time 2025-06-04 00:48:37.671 UTC [27] LOG: checkpoint complete: wrote 117 buffers (0.7%); 0 WAL file(s) added, 0 removed, 0 recycled; write=11.546 s, sync=0.014 s, total=11.569 s; sync files=61, longest=0.002 s, average=0.001 s; distance=696 kB, estimate=36006 kB; lsn=C02/4C84A8A0, redo lsn=C02/4C8366E0 2025-06-04 00:53:26.741 UTC [27] LOG: checkpoint starting: time 2025-06-04 00:53:31.875 UTC [27] LOG: checkpoint complete: wrote 52 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=5.120 s, sync=0.006 s, total=5.135 s; sync files=23, longest=0.001 s, average=0.001 s; distance=316 kB, estimate=32437 kB; lsn=C02/4C88B050, redo lsn=C02/4C885858 2025-06-04 00:58:26.974 UTC [27] LOG: checkpoint starting: time 2025-06-04 00:58:28.499 UTC [27] LOG: checkpoint complete: wrote 16 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.509 s, sync=0.006 s, total=1.525 s; sync files=10, longest=0.003 s, average=0.001 s; distance=234 kB, estimate=29217 kB; lsn=C02/4C8C2690, redo lsn=C02/4C8C0348 2025-06-04 01:03:26.573 UTC [27] LOG: checkpoint starting: time 2025-06-04 01:04:57.597 UTC [27] LOG: checkpoint complete: wrote 909 buffers (5.5%); 0 WAL file(s) added, 0 removed, 0 recycled; write=90.995 s, sync=0.019 s, total=91.025 s; sync files=86, longest=0.002 s, average=0.001 s; distance=5800 kB, estimate=26875 kB; lsn=C02/4CECF740, redo lsn=C02/4CE6A6C8 2025-06-04 01:08:26.691 UTC [27] LOG: checkpoint starting: time 2025-06-04 01:09:03.535 UTC [27] LOG: checkpoint complete: wrote 369 buffers (2.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=36.820 s, sync=0.014 s, total=36.845 s; sync files=55, longest=0.002 s, average=0.001 s; distance=821 kB, estimate=24270 kB; lsn=C02/4CF4D830, redo lsn=C02/4CF37DF0 2025-06-04 01:13:26.595 UTC [27] LOG: checkpoint starting: time 2025-06-04 01:13:34.550 UTC [27] LOG: checkpoint complete: wrote 81 buffers (0.5%); 0 WAL file(s) added, 0 removed, 0 recycled; write=7.932 s, sync=0.013 s, total=7.955 s; sync files=50, longest=0.002 s, average=0.001 s; distance=491 kB, estimate=21892 kB; lsn=C02/4CFC22C0, redo lsn=C02/4CFB2C58 2025-06-04 01:18:26.635 UTC [27] LOG: checkpoint starting: time 2025-06-04 01:18:37.510 UTC [27] LOG: checkpoint complete: wrote 110 buffers (0.7%); 0 WAL file(s) added, 1 removed, 0 recycled; write=10.842 s, sync=0.014 s, total=10.875 s; sync files=57, longest=0.002 s, average=0.001 s; distance=673 kB, estimate=19770 kB; lsn=C02/4D06D008, redo lsn=C02/4D05B428 2025-06-04 01:23:26.596 UTC [27] LOG: checkpoint starting: time 2025-06-04 01:23:48.598 UTC [27] LOG: checkpoint complete: wrote 221 buffers (1.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=21.976 s, sync=0.016 s, total=22.002 s; sync files=70, longest=0.002 s, average=0.001 s; distance=1269 kB, estimate=17920 kB; lsn=C02/4D1A92A0, redo lsn=C02/4D1988A0 2025-06-04 01:28:26.667 UTC [27] LOG: checkpoint starting: time 2025-06-04 01:28:45.858 UTC [27] LOG: checkpoint complete: wrote 194 buffers (1.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=19.166 s, sync=0.015 s, total=19.191 s; sync files=64, longest=0.003 s, average=0.001 s; distance=951 kB, estimate=16223 kB; lsn=C02/4D29B298, redo lsn=C02/4D2864D8 2025-06-04 01:33:26.221 UTC [27] LOG: checkpoint starting: time 2025-06-04 01:36:49.473 UTC [27] LOG: checkpoint complete: wrote 861 buffers (5.3%); 0 WAL file(s) added, 0 removed, 26 recycled; write=202.775 s, sync=0.388 s, total=203.252 s; sync files=126, longest=0.152 s, average=0.004 s; distance=437660 kB, estimate=437660 kB; lsn=C02/85B4F228, redo lsn=C02/67DED870 2025-06-04 01:36:59.634 UTC [27] LOG: checkpoint starting: wal 2025-06-04 01:40:11.173 UTC [27] LOG: checkpoint complete: wrote 2179 buffers (13.3%); 0 WAL file(s) added, 0 removed, 33 recycled; write=191.139 s, sync=0.092 s, total=191.540 s; sync files=116, longest=0.040 s, average=0.001 s; distance=526834 kB, estimate=526834 kB; lsn=C02/A5C3B048, redo lsn=C02/8806A0F0 2025-06-04 01:40:26.793 UTC [27] LOG: checkpoint starting: wal 2025-06-04 01:42:43.223 UTC [27] LOG: checkpoint complete: wrote 2114 buffers (12.9%); 0 WAL file(s) added, 0 removed, 33 recycled; write=136.254 s, sync=0.070 s, total=136.430 s; sync files=118, longest=0.007 s, average=0.001 s; distance=540623 kB, estimate=540623 kB; lsn=C02/C6C42340, redo lsn=C02/A905DE00 2025-06-04 01:42:55.733 UTC [27] LOG: checkpoint starting: wal 2025-06-04 01:45:15.566 UTC [27] LOG: checkpoint complete: wrote 1760 buffers (10.7%); 0 WAL file(s) added, 0 removed, 33 recycled; write=139.669 s, sync=0.071 s, total=139.834 s; sync files=115, longest=0.009 s, average=0.001 s; distance=541252 kB, estimate=541252 kB; lsn=C02/E7CCB7F8, redo lsn=C02/CA0EEEE8 2025-06-04 01:45:24.096 UTC [27] LOG: checkpoint starting: wal 2025-06-04 01:47:33.711 UTC [27] LOG: checkpoint complete: wrote 1689 buffers (10.3%); 0 WAL file(s) added, 0 removed, 33 recycled; write=129.485 s, sync=0.050 s, total=129.616 s; sync files=112, longest=0.003 s, average=0.001 s; distance=540723 kB, estimate=541199 kB; lsn=C03/8C47E10, redo lsn=C02/EB0FBB48 2025-06-04 01:47:50.876 UTC [27] LOG: checkpoint starting: wal 2025-06-04 01:49:49.942 UTC [27] LOG: checkpoint complete: wrote 1929 buffers (11.8%); 0 WAL file(s) added, 0 removed, 33 recycled; write=118.872 s, sync=0.088 s, total=119.066 s; sync files=150, longest=0.007 s, average=0.001 s; distance=540254 kB, estimate=541104 kB; lsn=C03/29CEFC48, redo lsn=C03/C093350 2025-06-04 01:50:00.129 UTC [27] LOG: checkpoint starting: wal 2025-06-04 01:51:53.221 UTC [27] LOG: checkpoint complete: wrote 1850 buffers (11.3%); 0 WAL file(s) added, 0 removed, 33 recycled; write=112.954 s, sync=0.061 s, total=113.093 s; sync files=95, longest=0.013 s, average=0.001 s; distance=540360 kB, estimate=541030 kB; lsn=C03/4AC92630, redo lsn=C03/2D0453F0 2025-06-04 01:52:06.070 UTC [27] LOG: checkpoint starting: wal 2025-06-04 01:54:05.480 UTC [27] LOG: checkpoint complete: wrote 1592 buffers (9.7%); 0 WAL file(s) added, 0 removed, 33 recycled; write=119.238 s, sync=0.087 s, total=119.411 s; sync files=83, longest=0.015 s, average=0.002 s; distance=540621 kB, estimate=540989 kB; lsn=C03/6BC2FFA0, redo lsn=C03/4E038BE0 2025-06-04 01:54:20.547 UTC [27] LOG: checkpoint starting: wal 2025-06-04 01:56:26.409 UTC [27] LOG: checkpoint complete: wrote 2159 buffers (13.2%); 0 WAL file(s) added, 0 removed, 33 recycled; write=125.658 s, sync=0.042 s, total=125.863 s; sync files=92, longest=0.003 s, average=0.001 s; distance=540824 kB, estimate=540973 kB; lsn=C03/8CC37D70, redo lsn=C03/6F05EE80 2025-06-04 01:56:38.077 UTC [27] LOG: checkpoint starting: wal 2025-06-04 01:58:38.797 UTC [27] LOG: checkpoint complete: wrote 2789 buffers (17.0%); 0 WAL file(s) added, 0 removed, 33 recycled; write=120.531 s, sync=0.087 s, total=120.720 s; sync files=87, longest=0.018 s, average=0.001 s; distance=540886 kB, estimate=540964 kB; lsn=C03/ADCC5310, redo lsn=C03/900949F8 2025-06-04 01:58:52.956 UTC [27] LOG: checkpoint starting: wal 2025-06-04 02:00:40.114 UTC [27] LOG: checkpoint complete: wrote 1295 buffers (7.9%); 0 WAL file(s) added, 0 removed, 33 recycled; write=107.009 s, sync=0.044 s, total=107.158 s; sync files=83, longest=0.009 s, average=0.001 s; distance=542213 kB, estimate=542213 kB; lsn=C03/CED96818, redo lsn=C03/B1216140 2025-06-04 02:00:51.229 UTC [27] LOG: checkpoint starting: wal 2025-06-04 02:02:40.653 UTC [27] LOG: checkpoint complete: wrote 2896 buffers (17.7%); 0 WAL file(s) added, 0 removed, 33 recycled; write=109.243 s, sync=0.080 s, total=109.425 s; sync files=88, longest=0.023 s, average=0.001 s; distance=539583 kB, estimate=541950 kB; lsn=C03/EFD24828, redo lsn=C03/D2105F48 2025-06-04 02:02:56.762 UTC [27] LOG: checkpoint starting: wal 2025-06-04 02:04:54.133 UTC [27] LOG: checkpoint complete: wrote 1660 buffers (10.1%); 0 WAL file(s) added, 0 removed, 33 recycled; write=117.158 s, sync=0.123 s, total=117.371 s; sync files=85, longest=0.038 s, average=0.002 s; distance=539928 kB, estimate=541748 kB; lsn=C04/10C47408, redo lsn=C03/F304BFB0 2025-06-04 02:05:08.591 UTC [27] LOG: checkpoint starting: wal 2025-06-04 02:09:38.107 UTC [27] LOG: checkpoint complete: wrote 6302 buffers (38.5%); 0 WAL file(s) added, 0 removed, 33 recycled; write=269.417 s, sync=0.011 s, total=269.516 s; sync files=53, longest=0.001 s, average=0.001 s; distance=540400 kB, estimate=541613 kB; lsn=C04/16C1CF38, redo lsn=C04/14007FD0 2025-06-04 02:10:08.131 UTC [27] LOG: checkpoint starting: time 2025-06-04 02:14:38.034 UTC [27] LOG: checkpoint complete: wrote 3711 buffers (22.7%); 0 WAL file(s) added, 0 removed, 2 recycled; write=269.879 s, sync=0.009 s, total=269.903 s; sync files=27, longest=0.003 s, average=0.001 s; distance=45154 kB, estimate=491967 kB; lsn=C04/16C53480, redo lsn=C04/16C20A58 2025-06-04 02:15:08.060 UTC [27] LOG: checkpoint starting: time 2025-06-04 02:15:08.980 UTC [27] LOG: checkpoint complete: wrote 11 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.906 s, sync=0.005 s, total=0.920 s; sync files=5, longest=0.003 s, average=0.001 s; distance=217 kB, estimate=442792 kB; lsn=C04/16C59908, redo lsn=C04/16C570D0 2025-06-04 02:20:09.079 UTC [27] LOG: checkpoint starting: time 2025-06-04 02:20:10.706 UTC [27] LOG: checkpoint complete: wrote 17 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.609 s, sync=0.006 s, total=1.628 s; sync files=10, longest=0.004 s, average=0.001 s; distance=233 kB, estimate=398536 kB; lsn=C04/16C98D28, redo lsn=C04/16C91550 2025-06-04 02:25:09.787 UTC [27] LOG: checkpoint starting: time 2025-06-04 02:25:11.109 UTC [27] LOG: checkpoint complete: wrote 14 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.307 s, sync=0.005 s, total=1.323 s; sync files=8, longest=0.003 s, average=0.001 s; distance=215 kB, estimate=358704 kB; lsn=C04/16CCD060, redo lsn=C04/16CC7220 2025-06-04 02:30:09.198 UTC [27] LOG: checkpoint starting: time 2025-06-04 02:30:10.721 UTC [27] LOG: checkpoint complete: wrote 16 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.508 s, sync=0.005 s, total=1.524 s; sync files=10, longest=0.003 s, average=0.001 s; distance=237 kB, estimate=322857 kB; lsn=C04/16D05510, redo lsn=C04/16D02A00 2025-06-04 02:35:09.748 UTC [27] LOG: checkpoint starting: time 2025-06-04 02:35:11.072 UTC [27] LOG: checkpoint complete: wrote 14 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.308 s, sync=0.005 s, total=1.324 s; sync files=8, longest=0.003 s, average=0.001 s; distance=212 kB, estimate=290593 kB; lsn=C04/16D3A570, redo lsn=C04/16D37C20 2025-06-04 02:40:09.103 UTC [27] LOG: checkpoint starting: time 2025-06-04 02:40:10.629 UTC [27] LOG: checkpoint complete: wrote 16 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.509 s, sync=0.006 s, total=1.526 s; sync files=10, longest=0.003 s, average=0.001 s; distance=235 kB, estimate=261557 kB; lsn=C04/16D75218, redo lsn=C04/16D728E0 2025-06-04 02:45:09.701 UTC [27] LOG: checkpoint starting: time 2025-06-04 02:45:11.027 UTC [27] LOG: checkpoint complete: wrote 15 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.310 s, sync=0.005 s, total=1.326 s; sync files=8, longest=0.003 s, average=0.001 s; distance=220 kB, estimate=235423 kB; lsn=C04/16DAC690, redo lsn=C04/16DA9C18 2025-06-04 02:50:09.123 UTC [27] LOG: checkpoint starting: time 2025-06-04 02:50:18.379 UTC [27] LOG: checkpoint complete: wrote 94 buffers (0.6%); 0 WAL file(s) added, 0 removed, 0 recycled; write=9.234 s, sync=0.012 s, total=9.257 s; sync files=51, longest=0.003 s, average=0.001 s; distance=567 kB, estimate=211938 kB; lsn=C04/16E400F8, redo lsn=C04/16E37978 2025-06-04 02:55:09.444 UTC [27] LOG: checkpoint starting: time 2025-06-04 02:55:19.011 UTC [27] LOG: checkpoint complete: wrote 97 buffers (0.6%); 0 WAL file(s) added, 0 removed, 0 recycled; write=9.543 s, sync=0.014 s, total=9.568 s; sync files=54, longest=0.003 s, average=0.001 s; distance=549 kB, estimate=190799 kB; lsn=C04/16EC7E30, redo lsn=C04/16EC0FA8 2025-06-04 03:00:09.099 UTC [27] LOG: checkpoint starting: time 2025-06-04 03:04:39.135 UTC [27] LOG: checkpoint complete: wrote 7420 buffers (45.3%); 0 WAL file(s) added, 6 removed, 0 recycled; write=269.962 s, sync=0.024 s, total=270.036 s; sync files=100, longest=0.002 s, average=0.001 s; distance=87632 kB, estimate=180482 kB; lsn=C04/1C488130, redo lsn=C04/1C455280 2025-06-04 03:05:09.156 UTC [27] LOG: checkpoint starting: time 2025-06-04 03:05:10.478 UTC [27] LOG: checkpoint complete: wrote 14 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.307 s, sync=0.004 s, total=1.323 s; sync files=8, longest=0.003 s, average=0.001 s; distance=218 kB, estimate=162456 kB; lsn=C04/1C48E648, redo lsn=C04/1C48BC20 2025-06-04 03:08:04.183 UTC [7625] ERROR: deadlock detected 2025-06-04 03:08:04.183 UTC [7625] DETAIL: Process 7625 waits for AccessExclusiveLock on tuple (198741,42) of relation 16394 of database 13470; blocked by process 7630. #011Process 7630 waits for ShareLock on transaction 703846495; blocked by process 7608. #011Process 7608 waits for ShareLock on transaction 703846497; blocked by process 7625. #011Process 7625: SELECT * FROM UpdateInvalidChildCounts() #011Process 7630: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7608: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 03:08:04.183 UTC [7625] HINT: See server log for query details. 2025-06-04 03:08:04.183 UTC [7625] CONTEXT: SQL statement "SELECT ARRAY(SELECT internalId #011 FROM Resources #011 WHERE internalId IN (SELECT DISTINCT id FROM InvalidChildCounts) #011 FOR UPDATE)" #011PL/pgSQL function updateinvalidchildcounts() line 8 at SQL statement 2025-06-04 03:08:04.183 UTC [7625] STATEMENT: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 03:10:09.569 UTC [27] LOG: checkpoint starting: time 2025-06-04 03:14:39.090 UTC [27] LOG: checkpoint complete: wrote 3719 buffers (22.7%); 0 WAL file(s) added, 3 removed, 0 recycled; write=269.468 s, sync=0.020 s, total=269.521 s; sync files=92, longest=0.002 s, average=0.001 s; distance=47279 kB, estimate=150938 kB; lsn=C04/1F3DB6F8, redo lsn=C04/1F2B7908 2025-06-04 03:15:09.121 UTC [27] LOG: checkpoint starting: time 2025-06-04 03:15:24.098 UTC [27] LOG: checkpoint complete: wrote 151 buffers (0.9%); 0 WAL file(s) added, 0 removed, 0 recycled; write=14.956 s, sync=0.012 s, total=14.978 s; sync files=45, longest=0.003 s, average=0.001 s; distance=1182 kB, estimate=135962 kB; lsn=C04/1F3E6DE0, redo lsn=C04/1F3DF380 2025-06-04 03:20:09.195 UTC [27] LOG: checkpoint starting: time 2025-06-04 03:20:10.719 UTC [27] LOG: checkpoint complete: wrote 16 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.509 s, sync=0.005 s, total=1.524 s; sync files=10, longest=0.003 s, average=0.001 s; distance=235 kB, estimate=122390 kB; lsn=C04/1F41CB00, redo lsn=C04/1F41A1B8 2025-06-04 03:25:09.793 UTC [27] LOG: checkpoint starting: time 2025-06-04 03:25:11.116 UTC [27] LOG: checkpoint complete: wrote 14 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.307 s, sync=0.006 s, total=1.323 s; sync files=8, longest=0.004 s, average=0.001 s; distance=215 kB, estimate=110172 kB; lsn=C04/1F452760, redo lsn=C04/1F44FF20 2025-06-04 03:30:09.215 UTC [27] LOG: checkpoint starting: time 2025-06-04 03:30:10.741 UTC [27] LOG: checkpoint complete: wrote 17 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.509 s, sync=0.006 s, total=1.527 s; sync files=10, longest=0.003 s, average=0.001 s; distance=238 kB, estimate=99179 kB; lsn=C04/1F48E040, redo lsn=C04/1F48B8F0 2025-06-04 03:35:09.818 UTC [27] LOG: checkpoint starting: time 2025-06-04 03:35:11.142 UTC [27] LOG: checkpoint complete: wrote 14 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.307 s, sync=0.005 s, total=1.325 s; sync files=8, longest=0.003 s, average=0.001 s; distance=217 kB, estimate=89283 kB; lsn=C04/1F4C4868, redo lsn=C04/1F4C2040 2025-06-04 03:40:09.221 UTC [27] LOG: checkpoint starting: time 2025-06-04 03:40:10.746 UTC [27] LOG: checkpoint complete: wrote 16 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.509 s, sync=0.005 s, total=1.526 s; sync files=10, longest=0.004 s, average=0.001 s; distance=235 kB, estimate=80378 kB; lsn=C04/1F504160, redo lsn=C04/1F4FCD60 2025-06-04 03:45:09.842 UTC [27] LOG: checkpoint starting: time 2025-06-04 03:47:52.590 UTC [27] LOG: checkpoint complete: wrote 908 buffers (5.5%); 0 WAL file(s) added, 0 removed, 0 recycled; write=162.719 s, sync=0.019 s, total=162.748 s; sync files=85, longest=0.001 s, average=0.001 s; distance=10696 kB, estimate=73410 kB; lsn=C04/210B8468, redo lsn=C04/1FF6EE20 2025-06-04 03:50:09.657 UTC [27] LOG: checkpoint starting: time 2025-06-04 03:54:39.082 UTC [27] LOG: checkpoint complete: wrote 4174 buffers (25.5%); 0 WAL file(s) added, 2 removed, 0 recycled; write=269.382 s, sync=0.013 s, total=269.426 s; sync files=55, longest=0.003 s, average=0.001 s; distance=17789 kB, estimate=67848 kB; lsn=C04/21101030, redo lsn=C04/210CE610 2025-06-04 03:55:09.092 UTC [27] LOG: checkpoint starting: time 2025-06-04 03:55:10.314 UTC [27] LOG: checkpoint complete: wrote 13 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.207 s, sync=0.005 s, total=1.223 s; sync files=8, longest=0.003 s, average=0.001 s; distance=217 kB, estimate=61085 kB; lsn=C04/211073B8, redo lsn=C04/21104C80 2025-06-04 04:00:09.415 UTC [27] LOG: checkpoint starting: time 2025-06-04 04:00:10.938 UTC [27] LOG: checkpoint complete: wrote 16 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.508 s, sync=0.006 s, total=1.524 s; sync files=10, longest=0.003 s, average=0.001 s; distance=240 kB, estimate=55000 kB; lsn=C04/21143868, redo lsn=C04/21141058 2025-06-04 04:05:10.036 UTC [27] LOG: checkpoint starting: time 2025-06-04 04:05:11.358 UTC [27] LOG: checkpoint complete: wrote 14 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.307 s, sync=0.005 s, total=1.322 s; sync files=8, longest=0.003 s, average=0.001 s; distance=215 kB, estimate=49522 kB; lsn=C04/211795F0, redo lsn=C04/21176CE0 2025-06-04 04:08:04.030 UTC [7603] ERROR: deadlock detected 2025-06-04 04:08:04.030 UTC [7603] DETAIL: Process 7603 waits for ShareLock on transaction 703860561; blocked by process 7606. #011Process 7606 waits for ShareLock on transaction 703860564; blocked by process 7646. #011Process 7646 waits for AccessExclusiveLock on tuple (195535,12) of relation 16394 of database 13470; blocked by process 7603. #011Process 7603: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7606: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7646: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 04:08:04.030 UTC [7603] HINT: See server log for query details. 2025-06-04 04:08:04.030 UTC [7603] CONTEXT: while locking tuple (195535,12) in relation "resources" #011SQL statement "SELECT internalid FROM "resources" WHERE publicId = patient_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 14 at SQL statement 2025-06-04 04:08:04.030 UTC [7603] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 04:08:05.030 UTC [7646] ERROR: deadlock detected 2025-06-04 04:08:05.030 UTC [7646] DETAIL: Process 7646 waits for ShareLock on transaction 703860561; blocked by process 7606. #011Process 7606 waits for ShareLock on transaction 703860564; blocked by process 7646. #011Process 7646: SELECT * FROM UpdateInvalidChildCounts() #011Process 7606: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 04:08:05.030 UTC [7646] HINT: See server log for query details. 2025-06-04 04:08:05.030 UTC [7646] CONTEXT: while locking tuple (195535,12) in relation "resources" #011SQL statement "SELECT ARRAY(SELECT internalId #011 FROM Resources #011 WHERE internalId IN (SELECT DISTINCT id FROM InvalidChildCounts) #011 FOR UPDATE)" #011PL/pgSQL function updateinvalidchildcounts() line 8 at SQL statement 2025-06-04 04:08:05.030 UTC [7646] STATEMENT: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 04:10:10.450 UTC [27] LOG: checkpoint starting: time 2025-06-04 04:14:40.067 UTC [27] LOG: checkpoint complete: wrote 4842 buffers (29.6%); 0 WAL file(s) added, 3 removed, 0 recycled; write=269.559 s, sync=0.021 s, total=269.618 s; sync files=93, longest=0.003 s, average=0.001 s; distance=48527 kB, estimate=49422 kB; lsn=C04/2410DE40, redo lsn=C04/240DA940 2025-06-04 04:15:10.078 UTC [27] LOG: checkpoint starting: time 2025-06-04 04:15:11.198 UTC [27] LOG: checkpoint complete: wrote 12 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.106 s, sync=0.004 s, total=1.120 s; sync files=7, longest=0.003 s, average=0.001 s; distance=220 kB, estimate=44502 kB; lsn=C04/24114218, redo lsn=C04/24111AC8 2025-06-04 04:20:10.284 UTC [27] LOG: checkpoint starting: time 2025-06-04 04:20:11.811 UTC [27] LOG: checkpoint complete: wrote 17 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.510 s, sync=0.006 s, total=1.527 s; sync files=10, longest=0.003 s, average=0.001 s; distance=234 kB, estimate=40075 kB; lsn=C04/2414ED80, redo lsn=C04/2414C470 2025-06-04 04:25:10.891 UTC [27] LOG: checkpoint starting: time 2025-06-04 04:25:12.016 UTC [27] LOG: checkpoint complete: wrote 12 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.109 s, sync=0.005 s, total=1.125 s; sync files=7, longest=0.004 s, average=0.001 s; distance=211 kB, estimate=36089 kB; lsn=C04/24183C38, redo lsn=C04/24181410 2025-06-04 04:30:10.108 UTC [27] LOG: checkpoint starting: time 2025-06-04 04:30:11.633 UTC [27] LOG: checkpoint complete: wrote 16 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.509 s, sync=0.006 s, total=1.526 s; sync files=10, longest=0.003 s, average=0.001 s; distance=238 kB, estimate=32504 kB; lsn=C04/241C1D60, redo lsn=C04/241BCC70 2025-06-04 04:35:10.731 UTC [27] LOG: checkpoint starting: time 2025-06-04 04:35:11.957 UTC [27] LOG: checkpoint complete: wrote 13 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.209 s, sync=0.005 s, total=1.226 s; sync files=8, longest=0.003 s, average=0.001 s; distance=209 kB, estimate=29274 kB; lsn=C04/241F6C98, redo lsn=C04/241F11C8 2025-06-04 04:40:11.044 UTC [27] LOG: checkpoint starting: time 2025-06-04 04:40:12.568 UTC [27] LOG: checkpoint complete: wrote 16 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.509 s, sync=0.005 s, total=1.525 s; sync files=10, longest=0.003 s, average=0.001 s; distance=240 kB, estimate=26371 kB; lsn=C04/24232660, redo lsn=C04/2422D578 2025-06-04 04:43:03.920 UTC [7611] ERROR: deadlock detected 2025-06-04 04:43:03.920 UTC [7611] DETAIL: Process 7611 waits for ShareLock on transaction 703870627; blocked by process 7647. #011Process 7647 waits for ShareLock on transaction 703870629; blocked by process 7611. #011Process 7611: SELECT * FROM UpdateInvalidChildCounts() #011Process 7647: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 04:43:03.920 UTC [7611] HINT: See server log for query details. 2025-06-04 04:43:03.920 UTC [7611] CONTEXT: while locking tuple (195876,25) in relation "resources" #011SQL statement "SELECT ARRAY(SELECT internalId #011 FROM Resources #011 WHERE internalId IN (SELECT DISTINCT id FROM InvalidChildCounts) #011 FOR UPDATE)" #011PL/pgSQL function updateinvalidchildcounts() line 8 at SQL statement 2025-06-04 04:43:03.920 UTC [7611] STATEMENT: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 04:45:11.662 UTC [27] LOG: checkpoint starting: time 2025-06-04 04:49:41.146 UTC [27] LOG: checkpoint complete: wrote 6437 buffers (39.3%); 0 WAL file(s) added, 4 removed, 0 recycled; write=269.418 s, sync=0.022 s, total=269.485 s; sync files=98, longest=0.002 s, average=0.001 s; distance=70984 kB, estimate=70984 kB; lsn=C04/28862FA8, redo lsn=C04/2877F788 2025-06-04 04:50:11.175 UTC [27] LOG: checkpoint starting: time 2025-06-04 04:50:23.039 UTC [27] LOG: checkpoint complete: wrote 120 buffers (0.7%); 0 WAL file(s) added, 0 removed, 0 recycled; write=11.843 s, sync=0.011 s, total=11.864 s; sync files=42, longest=0.002 s, average=0.001 s; distance=925 kB, estimate=63978 kB; lsn=C04/2886F780, redo lsn=C04/28866C68 2025-06-04 04:53:03.786 UTC [7615] ERROR: deadlock detected 2025-06-04 04:53:03.786 UTC [7615] DETAIL: Process 7615 waits for ShareLock on transaction 703880604; blocked by process 7628. #011Process 7628 waits for ShareLock on transaction 703880606; blocked by process 7615. #011Process 7615: SELECT * FROM UpdateInvalidChildCounts() #011Process 7628: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 04:53:03.786 UTC [7615] HINT: See server log for query details. 2025-06-04 04:53:03.786 UTC [7615] CONTEXT: while locking tuple (199505,61) in relation "resources" #011SQL statement "SELECT ARRAY(SELECT internalId #011 FROM Resources #011 WHERE internalId IN (SELECT DISTINCT id FROM InvalidChildCounts) #011 FOR UPDATE)" #011PL/pgSQL function updateinvalidchildcounts() line 8 at SQL statement 2025-06-04 04:53:03.786 UTC [7615] STATEMENT: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 04:55:11.138 UTC [27] LOG: checkpoint starting: time 2025-06-04 04:59:41.129 UTC [27] LOG: checkpoint complete: wrote 6131 buffers (37.4%); 0 WAL file(s) added, 4 removed, 0 recycled; write=269.923 s, sync=0.022 s, total=269.992 s; sync files=97, longest=0.002 s, average=0.001 s; distance=71650 kB, estimate=71650 kB; lsn=C04/2CE97B38, redo lsn=C04/2CE5F5F8 2025-06-04 05:00:11.159 UTC [27] LOG: checkpoint starting: time 2025-06-04 05:00:12.681 UTC [27] LOG: checkpoint complete: wrote 16 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.508 s, sync=0.005 s, total=1.523 s; sync files=9, longest=0.003 s, average=0.001 s; distance=240 kB, estimate=64509 kB; lsn=C04/2CE9E070, redo lsn=C04/2CE9B830 2025-06-04 05:05:11.762 UTC [27] LOG: checkpoint starting: time 2025-06-04 05:05:13.086 UTC [27] LOG: checkpoint complete: wrote 14 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.307 s, sync=0.006 s, total=1.325 s; sync files=8, longest=0.004 s, average=0.001 s; distance=214 kB, estimate=58079 kB; lsn=C04/2CED3B08, redo lsn=C04/2CED12D0 2025-06-04 05:10:11.134 UTC [27] LOG: checkpoint starting: time 2025-06-04 05:10:12.662 UTC [27] LOG: checkpoint complete: wrote 18 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.511 s, sync=0.007 s, total=1.529 s; sync files=10, longest=0.003 s, average=0.001 s; distance=231 kB, estimate=52295 kB; lsn=C04/2CF0DAC8, redo lsn=C04/2CF0B1B8 2025-06-04 05:15:11.760 UTC [27] LOG: checkpoint starting: time 2025-06-04 05:16:11.473 UTC [27] LOG: checkpoint complete: wrote 597 buffers (3.6%); 0 WAL file(s) added, 1 removed, 0 recycled; write=59.688 s, sync=0.004 s, total=59.714 s; sync files=10, longest=0.003 s, average=0.001 s; distance=4645 kB, estimate=47530 kB; lsn=C04/2D3A7FA8, redo lsn=C04/2D3947D0 2025-06-04 05:20:11.570 UTC [27] LOG: checkpoint starting: time 2025-06-04 05:20:27.638 UTC [27] LOG: checkpoint complete: wrote 161 buffers (1.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=16.053 s, sync=0.006 s, total=16.069 s; sync files=14, longest=0.003 s, average=0.001 s; distance=904 kB, estimate=42867 kB; lsn=C04/2D47D9F8, redo lsn=C04/2D476928 2025-06-04 05:25:11.717 UTC [27] LOG: checkpoint starting: time 2025-06-04 05:25:12.839 UTC [27] LOG: checkpoint complete: wrote 12 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.107 s, sync=0.005 s, total=1.123 s; sync files=7, longest=0.003 s, average=0.001 s; distance=205 kB, estimate=38601 kB; lsn=C04/2D4AC6C8, redo lsn=C04/2D4A9F78 2025-06-04 05:30:11.937 UTC [27] LOG: checkpoint starting: time 2025-06-04 05:30:13.459 UTC [27] LOG: checkpoint complete: wrote 16 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.507 s, sync=0.005 s, total=1.522 s; sync files=10, longest=0.003 s, average=0.001 s; distance=238 kB, estimate=34765 kB; lsn=C04/2D4E82C0, redo lsn=C04/2D4E5A70 2025-06-04 05:35:11.501 UTC [27] LOG: checkpoint starting: time 2025-06-04 05:35:12.823 UTC [27] LOG: checkpoint complete: wrote 14 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.308 s, sync=0.005 s, total=1.323 s; sync files=8, longest=0.003 s, average=0.001 s; distance=213 kB, estimate=31309 kB; lsn=C04/2D520988, redo lsn=C04/2D51AEE8 2025-06-04 05:40:11.910 UTC [27] LOG: checkpoint starting: time 2025-06-04 05:40:13.437 UTC [27] LOG: checkpoint complete: wrote 17 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.510 s, sync=0.006 s, total=1.527 s; sync files=10, longest=0.003 s, average=0.001 s; distance=234 kB, estimate=28202 kB; lsn=C04/2D5583F8, redo lsn=C04/2D5559E0 2025-06-04 05:43:03.147 UTC [7640] ERROR: deadlock detected 2025-06-04 05:43:03.147 UTC [7640] DETAIL: Process 7640 waits for AccessExclusiveLock on tuple (349393,65) of relation 16394 of database 13470; blocked by process 7612. #011Process 7612 waits for ShareLock on transaction 703891937; blocked by process 7644. #011Process 7644 waits for ShareLock on transaction 703891980; blocked by process 7635. #011Process 7635 waits for AccessExclusiveLock on tuple (349393,65) of relation 16394 of database 13470; blocked by process 7640. #011Process 7640: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7612: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7644: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7635: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 05:43:03.147 UTC [7640] HINT: See server log for query details. 2025-06-04 05:43:03.147 UTC [7640] CONTEXT: SQL statement "SELECT internalid FROM "resources" WHERE publicId = patient_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 14 at SQL statement 2025-06-04 05:43:03.147 UTC [7640] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 05:43:03.277 UTC [7635] ERROR: deadlock detected 2025-06-04 05:43:03.277 UTC [7635] DETAIL: Process 7635 waits for AccessExclusiveLock on tuple (349393,65) of relation 16394 of database 13470; blocked by process 7612. #011Process 7612 waits for ShareLock on transaction 703891937; blocked by process 7644. #011Process 7644 waits for ShareLock on transaction 703891980; blocked by process 7635. #011Process 7635: SELECT * FROM UpdateInvalidChildCounts() #011Process 7612: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7644: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 05:43:03.277 UTC [7635] HINT: See server log for query details. 2025-06-04 05:43:03.277 UTC [7635] CONTEXT: SQL statement "SELECT ARRAY(SELECT internalId #011 FROM Resources #011 WHERE internalId IN (SELECT DISTINCT id FROM InvalidChildCounts) #011 FOR UPDATE)" #011PL/pgSQL function updateinvalidchildcounts() line 8 at SQL statement 2025-06-04 05:43:03.277 UTC [7635] STATEMENT: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 05:45:11.515 UTC [27] LOG: checkpoint starting: time 2025-06-04 05:49:41.083 UTC [27] LOG: checkpoint complete: wrote 4579 buffers (27.9%); 0 WAL file(s) added, 2 removed, 0 recycled; write=269.523 s, sync=0.020 s, total=269.569 s; sync files=95, longest=0.002 s, average=0.001 s; distance=38966 kB, estimate=38966 kB; lsn=C04/2FB99528, redo lsn=C04/2FB63300 2025-06-04 05:50:11.092 UTC [27] LOG: checkpoint starting: time 2025-06-04 05:50:12.317 UTC [27] LOG: checkpoint complete: wrote 13 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.207 s, sync=0.006 s, total=1.226 s; sync files=8, longest=0.003 s, average=0.001 s; distance=231 kB, estimate=35092 kB; lsn=C04/2FB9F8B0, redo lsn=C04/2FB9D178 2025-06-04 05:55:11.410 UTC [27] LOG: checkpoint starting: time 2025-06-04 05:56:50.138 UTC [27] LOG: checkpoint complete: wrote 987 buffers (6.0%); 0 WAL file(s) added, 1 removed, 0 recycled; write=98.702 s, sync=0.015 s, total=98.728 s; sync files=60, longest=0.003 s, average=0.001 s; distance=6627 kB, estimate=32246 kB; lsn=C04/30237DC0, redo lsn=C04/30216108 2025-06-04 06:00:11.211 UTC [27] LOG: checkpoint starting: time 2025-06-04 06:00:12.740 UTC [27] LOG: checkpoint complete: wrote 16 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.509 s, sync=0.009 s, total=1.530 s; sync files=10, longest=0.004 s, average=0.001 s; distance=242 kB, estimate=29045 kB; lsn=C04/30255068, redo lsn=C04/30252930 2025-06-04 06:05:11.812 UTC [27] LOG: checkpoint starting: time 2025-06-04 06:07:08.818 UTC [27] LOG: checkpoint complete: wrote 1171 buffers (7.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=116.974 s, sync=0.023 s, total=117.006 s; sync files=92, longest=0.002 s, average=0.001 s; distance=8045 kB, estimate=26945 kB; lsn=C04/30A51278, redo lsn=C04/30A2DE10 2025-06-04 06:10:11.908 UTC [27] LOG: checkpoint starting: time 2025-06-04 06:10:13.432 UTC [27] LOG: checkpoint complete: wrote 16 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.508 s, sync=0.006 s, total=1.524 s; sync files=10, longest=0.003 s, average=0.001 s; distance=238 kB, estimate=24275 kB; lsn=C04/30A6BF70, redo lsn=C04/30A69748 2025-06-04 06:15:11.491 UTC [27] LOG: checkpoint starting: time 2025-06-04 06:15:12.714 UTC [27] LOG: checkpoint complete: wrote 14 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.209 s, sync=0.004 s, total=1.223 s; sync files=8, longest=0.003 s, average=0.001 s; distance=208 kB, estimate=21868 kB; lsn=C04/30AA0338, redo lsn=C04/30A9DA20 2025-06-04 06:20:11.800 UTC [27] LOG: checkpoint starting: time 2025-06-04 06:24:41.125 UTC [27] LOG: checkpoint complete: wrote 6287 buffers (38.4%); 0 WAL file(s) added, 7 removed, 0 recycled; write=269.244 s, sync=0.026 s, total=269.325 s; sync files=104, longest=0.003 s, average=0.001 s; distance=105032 kB, estimate=105032 kB; lsn=C04/38EE7E18, redo lsn=C04/3712FD70 2025-06-04 06:25:11.152 UTC [27] LOG: checkpoint starting: time 2025-06-04 06:29:05.456 UTC [27] LOG: checkpoint complete: wrote 2263 buffers (13.8%); 0 WAL file(s) added, 1 removed, 0 recycled; write=234.267 s, sync=0.016 s, total=234.305 s; sync files=73, longest=0.002 s, average=0.001 s; distance=30447 kB, estimate=97574 kB; lsn=C04/3AFF8A98, redo lsn=C04/38EEBAA0 2025-06-04 06:30:11.521 UTC [27] LOG: checkpoint starting: time 2025-06-04 06:34:41.072 UTC [27] LOG: checkpoint complete: wrote 3581 buffers (21.9%); 0 WAL file(s) added, 3 removed, 0 recycled; write=269.500 s, sync=0.019 s, total=269.551 s; sync files=85, longest=0.003 s, average=0.001 s; distance=34232 kB, estimate=91240 kB; lsn=C04/3B0AE708, redo lsn=C04/3B059C78 2025-06-04 06:35:11.103 UTC [27] LOG: checkpoint starting: time 2025-06-04 06:35:13.729 UTC [27] LOG: checkpoint complete: wrote 27 buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=2.612 s, sync=0.006 s, total=2.626 s; sync files=12, longest=0.003 s, average=0.001 s; distance=353 kB, estimate=82151 kB; lsn=C04/3B0B4DD0, redo lsn=C04/3B0B23B0 2025-06-04 06:40:11.736 UTC [27] LOG: checkpoint starting: time 2025-06-04 06:40:40.660 UTC [27] LOG: checkpoint complete: wrote 290 buffers (1.8%); 0 WAL file(s) added, 0 removed, 0 recycled; write=28.900 s, sync=0.016 s, total=28.925 s; sync files=72, longest=0.002 s, average=0.001 s; distance=1700 kB, estimate=74106 kB; lsn=C04/3B268B90, redo lsn=C04/3B25B4A8 2025-06-04 06:45:11.348 UTC [27] LOG: checkpoint starting: time 2025-06-04 06:49:41.151 UTC [27] LOG: checkpoint complete: wrote 1507 buffers (9.2%); 0 WAL file(s) added, 0 removed, 12 recycled; write=269.734 s, sync=0.027 s, total=269.804 s; sync files=109, longest=0.003 s, average=0.001 s; distance=197241 kB, estimate=197241 kB; lsn=C04/4D339670, redo lsn=C04/472F9A48 2025-06-04 06:50:11.182 UTC [27] LOG: checkpoint starting: time 2025-06-04 06:54:41.135 UTC [27] LOG: checkpoint complete: wrote 3361 buffers (20.5%); 0 WAL file(s) added, 0 removed, 6 recycled; write=269.908 s, sync=0.022 s, total=269.954 s; sync files=91, longest=0.003 s, average=0.001 s; distance=98670 kB, estimate=187384 kB; lsn=C04/4E667EC0, redo lsn=C04/4D355410 2025-06-04 06:55:11.163 UTC [27] LOG: checkpoint starting: time 2025-06-04 06:57:39.845 UTC [7640] ERROR: deadlock detected 2025-06-04 06:57:39.845 UTC [7640] DETAIL: Process 7640 waits for AccessExclusiveLock on tuple (386183,20) of relation 16394 of database 13470; blocked by process 7619. #011Process 7619 waits for ShareLock on transaction 703967533; blocked by process 7626. #011Process 7626 waits for ShareLock on transaction 703967545; blocked by process 7640. #011Process 7640: SELECT * FROM UpdateInvalidChildCounts() #011Process 7619: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7626: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 06:57:39.845 UTC [7640] HINT: See server log for query details. 2025-06-04 06:57:39.845 UTC [7640] CONTEXT: SQL statement "SELECT ARRAY(SELECT internalId #011 FROM Resources #011 WHERE internalId IN (SELECT DISTINCT id FROM InvalidChildCounts) #011 FOR UPDATE)" #011PL/pgSQL function updateinvalidchildcounts() line 8 at SQL statement 2025-06-04 06:57:39.845 UTC [7640] STATEMENT: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 06:58:24.860 UTC [27] LOG: checkpoint complete: wrote 93 buffers (0.6%); 0 WAL file(s) added, 1 removed, 0 recycled; write=192.908 s, sync=0.773 s, total=193.697 s; sync files=100, longest=0.490 s, average=0.008 s; distance=22159 kB, estimate=170861 kB; lsn=C04/5B7842A0, redo lsn=C04/4E8F92A8 2025-06-04 06:59:09.268 UTC [27] LOG: checkpoint starting: wal 2025-06-04 07:03:39.512 UTC [27] LOG: checkpoint complete: wrote 1367 buffers (8.3%); 0 WAL file(s) added, 0 removed, 33 recycled; write=269.745 s, sync=0.384 s, total=270.242 s; sync files=141, longest=0.320 s, average=0.003 s; distance=533441 kB, estimate=533441 kB; lsn=C04/790C1510, redo lsn=C04/6F1E9A88 2025-06-04 07:04:09.559 UTC [27] LOG: checkpoint starting: time 2025-06-04 07:07:58.212 UTC [27] LOG: checkpoint complete: wrote 4246 buffers (25.9%); 0 WAL file(s) added, 0 removed, 11 recycled; write=228.545 s, sync=0.053 s, total=228.652 s; sync files=126, longest=0.021 s, average=0.001 s; distance=187667 kB, estimate=498864 kB; lsn=C04/988D5CE0, redo lsn=C04/7A92E8A8 2025-06-04 07:07:59.082 UTC [27] LOG: checkpoint starting: wal 2025-06-04 07:08:32.266 UTC [27] LOG: checkpoint complete: wrote 41 buffers (0.3%); 0 WAL file(s) added, 0 removed, 33 recycled; write=32.941 s, sync=0.118 s, total=33.186 s; sync files=78, longest=0.038 s, average=0.002 s; distance=531297 kB, estimate=531297 kB; lsn=C04/B8D32160, redo lsn=C04/9B007080 2025-06-04 07:08:33.999 UTC [27] LOG: checkpoint starting: wal 2025-06-04 07:11:27.494 UTC [27] LOG: checkpoint complete: wrote 1553 buffers (9.5%); 0 WAL file(s) added, 0 removed, 33 recycled; write=173.112 s, sync=0.284 s, total=173.496 s; sync files=118, longest=0.112 s, average=0.003 s; distance=540710 kB, estimate=540710 kB; lsn=C04/D9BB3498, redo lsn=C04/BC010988 2025-06-04 07:11:44.807 UTC [27] LOG: checkpoint starting: wal 2025-06-04 07:16:14.181 UTC [27] LOG: checkpoint complete: wrote 886 buffers (5.4%); 0 WAL file(s) added, 0 removed, 33 recycled; write=269.188 s, sync=0.050 s, total=269.373 s; sync files=111, longest=0.003 s, average=0.001 s; distance=543385 kB, estimate=543385 kB; lsn=C04/E8BD7BB8, redo lsn=C04/DD2B7120 2025-06-04 07:16:44.212 UTC [27] LOG: checkpoint starting: time 2025-06-04 07:19:25.606 UTC [27] LOG: checkpoint complete: wrote 484 buffers (3.0%); 0 WAL file(s) added, 0 removed, 13 recycled; write=161.268 s, sync=0.059 s, total=161.395 s; sync files=113, longest=0.005 s, average=0.001 s; distance=211763 kB, estimate=510223 kB; lsn=C04/FB2E6E50, redo lsn=C04/EA183F68 2025-06-04 07:21:44.134 UTC [27] LOG: checkpoint starting: time 2025-06-04 07:25:40.801 UTC [27] LOG: checkpoint complete: wrote 309 buffers (1.9%); 0 WAL file(s) added, 0 removed, 19 recycled; write=236.559 s, sync=0.041 s, total=236.666 s; sync files=118, longest=0.003 s, average=0.001 s; distance=323412 kB, estimate=491542 kB; lsn=C05/57BCEE0, redo lsn=C04/FDD59320 2025-06-04 07:26:44.866 UTC [27] LOG: checkpoint starting: time 2025-06-04 07:31:14.083 UTC [27] LOG: checkpoint complete: wrote 2249 buffers (13.7%); 0 WAL file(s) added, 3 removed, 5 recycled; write=269.147 s, sync=0.032 s, total=269.217 s; sync files=115, longest=0.003 s, average=0.001 s; distance=125941 kB, estimate=454982 kB; lsn=C05/854DF78, redo lsn=C05/58568D8 2025-06-04 07:31:44.100 UTC [27] LOG: checkpoint starting: time 2025-06-04 07:34:27.191 UTC [27] LOG: checkpoint complete: wrote 942 buffers (5.7%); 0 WAL file(s) added, 3 removed, 0 recycled; write=163.027 s, sync=0.039 s, total=163.092 s; sync files=92, longest=0.004 s, average=0.001 s; distance=48455 kB, estimate=414329 kB; lsn=C05/12DE7F70, redo lsn=C05/87A85B8 2025-06-04 07:36:44.713 UTC [27] LOG: checkpoint starting: time 2025-06-04 07:41:14.170 UTC [27] LOG: checkpoint complete: wrote 1965 buffers (12.0%); 0 WAL file(s) added, 4 removed, 11 recycled; write=269.356 s, sync=0.038 s, total=269.458 s; sync files=120, longest=0.003 s, average=0.001 s; distance=248727 kB, estimate=397769 kB; lsn=C05/23D89D40, redo lsn=C05/17A8E598 2025-06-04 07:41:44.193 UTC [27] LOG: checkpoint starting: time 2025-06-04 07:43:03.651 UTC [7622] ERROR: deadlock detected 2025-06-04 07:43:03.651 UTC [7622] DETAIL: Process 7622 waits for AccessExclusiveLock on tuple (214205,21) of relation 16394 of database 13470; blocked by process 7603. #011Process 7603 waits for ShareLock on transaction 704189929; blocked by process 7637. #011Process 7637 waits for ShareLock on transaction 704189931; blocked by process 7622. #011Process 7622: SELECT * FROM UpdateInvalidChildCounts() #011Process 7603: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7637: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 07:43:03.651 UTC [7622] HINT: See server log for query details. 2025-06-04 07:43:03.651 UTC [7622] CONTEXT: SQL statement "SELECT ARRAY(SELECT internalId #011 FROM Resources #011 WHERE internalId IN (SELECT DISTINCT id FROM InvalidChildCounts) #011 FOR UPDATE)" #011PL/pgSQL function updateinvalidchildcounts() line 8 at SQL statement 2025-06-04 07:43:03.651 UTC [7622] STATEMENT: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 07:43:05.666 UTC [7618] ERROR: deadlock detected 2025-06-04 07:43:05.666 UTC [7618] DETAIL: Process 7618 waits for ShareLock on transaction 704190240; blocked by process 7639. #011Process 7639 waits for AccessExclusiveLock on tuple (214171,64) of relation 16394 of database 13470; blocked by process 7640. #011Process 7640 waits for ShareLock on transaction 704190227; blocked by process 7618. #011Process 7618: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7639: SELECT * FROM UpdateInvalidChildCounts() #011Process 7640: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 07:43:05.666 UTC [7618] HINT: See server log for query details. 2025-06-04 07:43:05.666 UTC [7618] CONTEXT: while locking tuple (214171,65) in relation "resources" #011SQL statement "SELECT internalid FROM "resources" WHERE publicId = study_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 22 at SQL statement 2025-06-04 07:43:05.666 UTC [7618] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 07:43:06.667 UTC [7639] ERROR: deadlock detected 2025-06-04 07:43:06.667 UTC [7639] DETAIL: Process 7639 waits for ShareLock on transaction 704190237; blocked by process 7640. #011Process 7640 waits for ShareLock on transaction 704190240; blocked by process 7639. #011Process 7639: SELECT * FROM UpdateInvalidChildCounts() #011Process 7640: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 07:43:06.667 UTC [7639] HINT: See server log for query details. 2025-06-04 07:43:06.667 UTC [7639] CONTEXT: while locking tuple (214171,64) in relation "resources" #011SQL statement "SELECT ARRAY(SELECT internalId #011 FROM Resources #011 WHERE internalId IN (SELECT DISTINCT id FROM InvalidChildCounts) #011 FOR UPDATE)" #011PL/pgSQL function updateinvalidchildcounts() line 8 at SQL statement 2025-06-04 07:43:06.667 UTC [7639] STATEMENT: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 07:43:27.139 UTC [7618] ERROR: deadlock detected 2025-06-04 07:43:27.139 UTC [7618] DETAIL: Process 7618 waits for ShareLock on transaction 704197627; blocked by process 7642. #011Process 7642 waits for ShareLock on transaction 704197648; blocked by process 7618. #011Process 7618: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7642: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 07:43:27.139 UTC [7618] HINT: See server log for query details. 2025-06-04 07:43:27.139 UTC [7618] CONTEXT: while locking tuple (208542,23) in relation "resources" #011SQL statement "SELECT internalid FROM "resources" WHERE publicId = study_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 22 at SQL statement 2025-06-04 07:43:27.139 UTC [7618] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 07:46:14.173 UTC [27] LOG: checkpoint complete: wrote 2006 buffers (12.2%); 0 WAL file(s) added, 2 removed, 10 recycled; write=269.898 s, sync=0.029 s, total=269.981 s; sync files=120, longest=0.003 s, average=0.001 s; distance=199717 kB, estimate=377964 kB; lsn=C05/31235B80, redo lsn=C05/23D97C28 2025-06-04 07:46:44.203 UTC [27] LOG: checkpoint starting: time 2025-06-04 07:50:57.073 UTC [7644] ERROR: deadlock detected 2025-06-04 07:50:57.073 UTC [7644] DETAIL: Process 7644 waits for AccessExclusiveLock on tuple (212240,55) of relation 16394 of database 13470; blocked by process 7635. #011Process 7635 waits for ShareLock on transaction 704254506; blocked by process 7637. #011Process 7637 waits for ShareLock on transaction 704254514; blocked by process 7644. #011Process 7644: SELECT * FROM UpdateInvalidChildCounts() #011Process 7635: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7637: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 07:50:57.073 UTC [7644] HINT: See server log for query details. 2025-06-04 07:50:57.073 UTC [7644] CONTEXT: SQL statement "SELECT ARRAY(SELECT internalId #011 FROM Resources #011 WHERE internalId IN (SELECT DISTINCT id FROM InvalidChildCounts) #011 FOR UPDATE)" #011PL/pgSQL function updateinvalidchildcounts() line 8 at SQL statement 2025-06-04 07:50:57.073 UTC [7644] STATEMENT: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 07:51:01.044 UTC [27] LOG: checkpoint complete: wrote 1270 buffers (7.8%); 0 WAL file(s) added, 3 removed, 11 recycled; write=256.744 s, sync=0.037 s, total=256.841 s; sync files=89, longest=0.004 s, average=0.001 s; distance=217805 kB, estimate=361948 kB; lsn=C05/3B34C520, redo lsn=C05/3124B2C0 2025-06-04 07:51:44.068 UTC [27] LOG: checkpoint starting: time 2025-06-04 07:56:14.174 UTC [27] LOG: checkpoint complete: wrote 2091 buffers (12.8%); 0 WAL file(s) added, 3 removed, 8 recycled; write=270.000 s, sync=0.047 s, total=270.107 s; sync files=115, longest=0.003 s, average=0.001 s; distance=179961 kB, estimate=343749 kB; lsn=C05/4904FF68, redo lsn=C05/3C2097B8 2025-06-04 07:56:44.201 UTC [27] LOG: checkpoint starting: time 2025-06-04 08:01:14.169 UTC [27] LOG: checkpoint complete: wrote 2170 buffers (13.2%); 0 WAL file(s) added, 1 removed, 12 recycled; write=269.877 s, sync=0.048 s, total=269.968 s; sync files=112, longest=0.004 s, average=0.001 s; distance=211285 kB, estimate=330503 kB; lsn=C05/52BA0E60, redo lsn=C05/4905EF78 2025-06-04 08:01:44.194 UTC [27] LOG: checkpoint starting: time 2025-06-04 08:03:05.223 UTC [7631] ERROR: deadlock detected 2025-06-04 08:03:05.223 UTC [7631] DETAIL: Process 7631 waits for ShareLock on transaction 704322035; blocked by process 7605. #011Process 7605 waits for ShareLock on transaction 704322024; blocked by process 7631. #011Process 7631: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7605: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 08:03:05.223 UTC [7631] HINT: See server log for query details. 2025-06-04 08:03:05.223 UTC [7631] CONTEXT: while locking tuple (216969,73) in relation "resources" #011SQL statement "SELECT internalid FROM "resources" WHERE publicId = series_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 30 at SQL statement 2025-06-04 08:03:05.223 UTC [7631] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 08:06:14.152 UTC [27] LOG: checkpoint complete: wrote 1404 buffers (8.6%); 0 WAL file(s) added, 2 removed, 7 recycled; write=269.897 s, sync=0.025 s, total=269.958 s; sync files=109, longest=0.003 s, average=0.001 s; distance=159074 kB, estimate=313360 kB; lsn=C05/570024C8, redo lsn=C05/52BB7940 2025-06-04 08:06:44.179 UTC [27] LOG: checkpoint starting: time 2025-06-04 08:11:14.094 UTC [27] LOG: checkpoint complete: wrote 1894 buffers (11.6%); 0 WAL file(s) added, 4 removed, 1 recycled; write=269.842 s, sync=0.023 s, total=269.915 s; sync files=101, longest=0.001 s, average=0.001 s; distance=69964 kB, estimate=289020 kB; lsn=C05/5EE9F450, redo lsn=C05/5700AB38 2025-06-04 08:11:44.099 UTC [27] LOG: checkpoint starting: time 2025-06-04 08:13:02.785 UTC [7622] ERROR: deadlock detected 2025-06-04 08:13:02.785 UTC [7622] DETAIL: Process 7622 waits for AccessExclusiveLock on tuple (217686,2) of relation 16394 of database 13470; blocked by process 7606. #011Process 7606 waits for ShareLock on transaction 704356275; blocked by process 7613. #011Process 7613 waits for ShareLock on transaction 704356313; blocked by process 7637. #011Process 7637 waits for AccessExclusiveLock on tuple (217686,2) of relation 16394 of database 13470; blocked by process 7622. #011Process 7622: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7606: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7613: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7637: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 08:13:02.785 UTC [7622] HINT: See server log for query details. 2025-06-04 08:13:02.785 UTC [7622] CONTEXT: SQL statement "SELECT internalid FROM "resources" WHERE publicId = patient_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 14 at SQL statement 2025-06-04 08:13:02.785 UTC [7622] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 08:13:02.799 UTC [7610] ERROR: deadlock detected 2025-06-04 08:13:02.799 UTC [7610] DETAIL: Process 7610 waits for AccessExclusiveLock on tuple (217686,2) of relation 16394 of database 13470; blocked by process 7606. #011Process 7606 waits for ShareLock on transaction 704356275; blocked by process 7613. #011Process 7613 waits for ShareLock on transaction 704356313; blocked by process 7637. #011Process 7637 waits for AccessExclusiveLock on tuple (217686,2) of relation 16394 of database 13470; blocked by process 7610. #011Process 7610: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7606: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7613: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7637: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 08:13:02.799 UTC [7610] HINT: See server log for query details. 2025-06-04 08:13:02.799 UTC [7610] CONTEXT: SQL statement "SELECT internalid FROM "resources" WHERE publicId = patient_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 14 at SQL statement 2025-06-04 08:13:02.799 UTC [7610] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 08:13:02.810 UTC [7631] ERROR: deadlock detected 2025-06-04 08:13:02.810 UTC [7631] DETAIL: Process 7631 waits for AccessExclusiveLock on tuple (217686,2) of relation 16394 of database 13470; blocked by process 7606. #011Process 7606 waits for ShareLock on transaction 704356275; blocked by process 7613. #011Process 7613 waits for ShareLock on transaction 704356313; blocked by process 7637. #011Process 7637 waits for AccessExclusiveLock on tuple (217686,2) of relation 16394 of database 13470; blocked by process 7631. #011Process 7631: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7606: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7613: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7637: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 08:13:02.810 UTC [7631] HINT: See server log for query details. 2025-06-04 08:13:02.810 UTC [7631] CONTEXT: SQL statement "SELECT internalid FROM "resources" WHERE publicId = patient_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 14 at SQL statement 2025-06-04 08:13:02.810 UTC [7631] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 08:13:02.824 UTC [7628] ERROR: deadlock detected 2025-06-04 08:13:02.824 UTC [7628] DETAIL: Process 7628 waits for AccessExclusiveLock on tuple (217686,2) of relation 16394 of database 13470; blocked by process 7606. #011Process 7606 waits for ShareLock on transaction 704356275; blocked by process 7613. #011Process 7613 waits for ShareLock on transaction 704356313; blocked by process 7637. #011Process 7637 waits for AccessExclusiveLock on tuple (217686,2) of relation 16394 of database 13470; blocked by process 7628. #011Process 7628: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7606: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7613: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7637: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 08:13:02.824 UTC [7628] HINT: See server log for query details. 2025-06-04 08:13:02.824 UTC [7628] CONTEXT: SQL statement "SELECT internalid FROM "resources" WHERE publicId = patient_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 14 at SQL statement 2025-06-04 08:13:02.824 UTC [7628] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 08:13:02.841 UTC [7611] ERROR: deadlock detected 2025-06-04 08:13:02.841 UTC [7611] DETAIL: Process 7611 waits for AccessExclusiveLock on tuple (217686,2) of relation 16394 of database 13470; blocked by process 7606. #011Process 7606 waits for ShareLock on transaction 704356275; blocked by process 7613. #011Process 7613 waits for ShareLock on transaction 704356313; blocked by process 7637. #011Process 7637 waits for AccessExclusiveLock on tuple (217686,2) of relation 16394 of database 13470; blocked by process 7611. #011Process 7611: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7606: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7613: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7637: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 08:13:02.841 UTC [7611] HINT: See server log for query details. 2025-06-04 08:13:02.841 UTC [7611] CONTEXT: SQL statement "SELECT internalid FROM "resources" WHERE publicId = patient_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 14 at SQL statement 2025-06-04 08:13:02.841 UTC [7611] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 08:13:02.865 UTC [7637] ERROR: deadlock detected 2025-06-04 08:13:02.865 UTC [7637] DETAIL: Process 7637 waits for AccessExclusiveLock on tuple (217686,2) of relation 16394 of database 13470; blocked by process 7606. #011Process 7606 waits for ShareLock on transaction 704356275; blocked by process 7613. #011Process 7613 waits for ShareLock on transaction 704356313; blocked by process 7637. #011Process 7637: SELECT * FROM UpdateInvalidChildCounts() #011Process 7606: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7613: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 08:13:02.865 UTC [7637] HINT: See server log for query details. 2025-06-04 08:13:02.865 UTC [7637] CONTEXT: SQL statement "SELECT ARRAY(SELECT internalId #011 FROM Resources #011 WHERE internalId IN (SELECT DISTINCT id FROM InvalidChildCounts) #011 FOR UPDATE)" #011PL/pgSQL function updateinvalidchildcounts() line 8 at SQL statement 2025-06-04 08:13:02.865 UTC [7637] STATEMENT: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 08:13:35.061 UTC [7628] ERROR: deadlock detected 2025-06-04 08:13:35.061 UTC [7628] DETAIL: Process 7628 waits for ShareLock on transaction 704372852; blocked by process 7639. #011Process 7639 waits for ShareLock on transaction 704372855; blocked by process 7628. #011Process 7628: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7639: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 08:13:35.061 UTC [7628] HINT: See server log for query details. 2025-06-04 08:13:35.061 UTC [7628] CONTEXT: while locking tuple (218083,38) in relation "resources" #011SQL statement "SELECT internalid FROM "resources" WHERE publicId = series_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 30 at SQL statement 2025-06-04 08:13:35.061 UTC [7628] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 08:16:14.128 UTC [27] LOG: checkpoint complete: wrote 1537 buffers (9.4%); 0 WAL file(s) added, 1 removed, 6 recycled; write=269.958 s, sync=0.032 s, total=270.030 s; sync files=116, longest=0.003 s, average=0.001 s; distance=129679 kB, estimate=273086 kB; lsn=C05/6ADADE08, redo lsn=C05/5EEAE958 2025-06-04 08:16:44.160 UTC [27] LOG: checkpoint starting: time 2025-06-04 08:18:03.250 UTC [7615] ERROR: deadlock detected 2025-06-04 08:18:03.250 UTC [7615] DETAIL: Process 7615 waits for AccessExclusiveLock on tuple (218843,56) of relation 16394 of database 13470; blocked by process 7623. #011Process 7623 waits for ShareLock on transaction 704407810; blocked by process 7640. #011Process 7640 waits for ShareLock on transaction 704407825; blocked by process 7628. #011Process 7628 waits for AccessExclusiveLock on tuple (218843,56) of relation 16394 of database 13470; blocked by process 7615. #011Process 7615: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7623: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7640: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7628: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 08:18:03.250 UTC [7615] HINT: See server log for query details. 2025-06-04 08:18:03.250 UTC [7615] CONTEXT: SQL statement "SELECT internalid FROM "resources" WHERE publicId = patient_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 14 at SQL statement 2025-06-04 08:18:03.250 UTC [7615] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 08:18:03.266 UTC [7638] ERROR: deadlock detected 2025-06-04 08:18:03.266 UTC [7638] DETAIL: Process 7638 waits for AccessExclusiveLock on tuple (218843,56) of relation 16394 of database 13470; blocked by process 7623. #011Process 7623 waits for ShareLock on transaction 704407810; blocked by process 7640. #011Process 7640 waits for ShareLock on transaction 704407825; blocked by process 7628. #011Process 7628 waits for AccessExclusiveLock on tuple (218843,56) of relation 16394 of database 13470; blocked by process 7638. #011Process 7638: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7623: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7640: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7628: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 08:18:03.266 UTC [7638] HINT: See server log for query details. 2025-06-04 08:18:03.266 UTC [7638] CONTEXT: SQL statement "SELECT internalid FROM "resources" WHERE publicId = patient_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 14 at SQL statement 2025-06-04 08:18:03.266 UTC [7638] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 08:18:03.274 UTC [7628] ERROR: deadlock detected 2025-06-04 08:18:03.274 UTC [7628] DETAIL: Process 7628 waits for AccessExclusiveLock on tuple (218843,56) of relation 16394 of database 13470; blocked by process 7623. #011Process 7623 waits for ShareLock on transaction 704407810; blocked by process 7640. #011Process 7640 waits for ShareLock on transaction 704407825; blocked by process 7628. #011Process 7628: SELECT * FROM UpdateInvalidChildCounts() #011Process 7623: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7640: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 08:18:03.274 UTC [7628] HINT: See server log for query details. 2025-06-04 08:18:03.274 UTC [7628] CONTEXT: SQL statement "SELECT ARRAY(SELECT internalId #011 FROM Resources #011 WHERE internalId IN (SELECT DISTINCT id FROM InvalidChildCounts) #011 FOR UPDATE)" #011PL/pgSQL function updateinvalidchildcounts() line 8 at SQL statement 2025-06-04 08:18:03.274 UTC [7628] STATEMENT: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 08:21:14.118 UTC [27] LOG: checkpoint complete: wrote 780 buffers (4.8%); 0 WAL file(s) added, 0 removed, 14 recycled; write=269.877 s, sync=0.033 s, total=269.958 s; sync files=112, longest=0.002 s, average=0.001 s; distance=229951 kB, estimate=268773 kB; lsn=C05/81AB6198, redo lsn=C05/6CF3E940 2025-06-04 08:21:44.149 UTC [27] LOG: checkpoint starting: time 2025-06-04 08:26:14.203 UTC [27] LOG: checkpoint complete: wrote 1372 buffers (8.4%); 0 WAL file(s) added, 0 removed, 23 recycled; write=269.937 s, sync=0.042 s, total=270.055 s; sync files=114, longest=0.003 s, average=0.001 s; distance=376258 kB, estimate=376258 kB; lsn=C05/95960FA8, redo lsn=C05/83EAF4B0 2025-06-04 08:26:44.232 UTC [27] LOG: checkpoint starting: time 2025-06-04 08:28:05.562 UTC [7636] ERROR: deadlock detected 2025-06-04 08:28:05.562 UTC [7636] DETAIL: Process 7636 waits for ShareLock on transaction 704541314; blocked by process 7628. #011Process 7628 waits for ShareLock on transaction 704541303; blocked by process 7636. #011Process 7636: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7628: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 08:28:05.562 UTC [7636] HINT: See server log for query details. 2025-06-04 08:28:05.562 UTC [7636] CONTEXT: while locking tuple (220983,40) in relation "resources" #011SQL statement "SELECT internalid FROM "resources" WHERE publicId = series_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 30 at SQL statement 2025-06-04 08:28:05.562 UTC [7636] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 08:28:32.443 UTC [7617] ERROR: deadlock detected 2025-06-04 08:28:32.443 UTC [7617] DETAIL: Process 7617 waits for ShareLock on transaction 704551489; blocked by process 7619. #011Process 7619 waits for ShareLock on transaction 704551449; blocked by process 7617. #011Process 7617: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7619: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 08:28:32.443 UTC [7617] HINT: See server log for query details. 2025-06-04 08:28:32.443 UTC [7617] CONTEXT: while locking tuple (221305,67) in relation "resources" #011SQL statement "SELECT internalid FROM "resources" WHERE publicId = series_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 30 at SQL statement 2025-06-04 08:28:32.443 UTC [7617] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 08:28:32.453 UTC [7622] ERROR: deadlock detected 2025-06-04 08:28:32.453 UTC [7622] DETAIL: Process 7622 waits for ShareLock on transaction 704551489; blocked by process 7619. #011Process 7619 waits for ShareLock on transaction 704551487; blocked by process 7622. #011Process 7622: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7619: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 08:28:32.453 UTC [7622] HINT: See server log for query details. 2025-06-04 08:28:32.453 UTC [7622] CONTEXT: while locking tuple (221350,4) in relation "resources" #011SQL statement "SELECT internalid FROM "resources" WHERE publicId = series_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 30 at SQL statement 2025-06-04 08:28:32.453 UTC [7622] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 08:31:14.112 UTC [27] LOG: checkpoint complete: wrote 1169 buffers (7.1%); 0 WAL file(s) added, 0 removed, 20 recycled; write=269.786 s, sync=0.030 s, total=269.881 s; sync files=112, longest=0.003 s, average=0.001 s; distance=315965 kB, estimate=370229 kB; lsn=C05/A8F52D18, redo lsn=C05/9733EAD8 2025-06-04 08:31:44.143 UTC [27] LOG: checkpoint starting: time 2025-06-04 08:33:03.673 UTC [7641] ERROR: deadlock detected 2025-06-04 08:33:03.673 UTC [7641] DETAIL: Process 7641 waits for ShareLock on transaction 704587534; blocked by process 7628. #011Process 7628 waits for ShareLock on transaction 704587533; blocked by process 7641. #011Process 7641: SELECT * FROM UpdateInvalidChildCounts() #011Process 7628: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 08:33:03.673 UTC [7641] HINT: See server log for query details. 2025-06-04 08:33:03.673 UTC [7641] CONTEXT: while locking tuple (222110,22) in relation "resources" #011SQL statement "SELECT ARRAY(SELECT internalId #011 FROM Resources #011 WHERE internalId IN (SELECT DISTINCT id FROM InvalidChildCounts) #011 FOR UPDATE)" #011PL/pgSQL function updateinvalidchildcounts() line 8 at SQL statement 2025-06-04 08:33:03.673 UTC [7641] STATEMENT: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 08:33:06.714 UTC [7606] ERROR: deadlock detected 2025-06-04 08:33:06.714 UTC [7606] DETAIL: Process 7606 waits for ShareLock on transaction 704588555; blocked by process 7609. #011Process 7609 waits for ShareLock on transaction 704588553; blocked by process 7606. #011Process 7606: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7609: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 08:33:06.714 UTC [7606] HINT: See server log for query details. 2025-06-04 08:33:06.714 UTC [7606] CONTEXT: while locking tuple (222166,35) in relation "resources" #011SQL statement "SELECT internalid FROM "resources" WHERE publicId = series_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 30 at SQL statement 2025-06-04 08:33:06.714 UTC [7606] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 08:36:14.150 UTC [27] LOG: checkpoint complete: wrote 1057 buffers (6.5%); 0 WAL file(s) added, 0 removed, 17 recycled; write=269.926 s, sync=0.027 s, total=270.007 s; sync files=113, longest=0.003 s, average=0.001 s; distance=291330 kB, estimate=362339 kB; lsn=C05/B9EEB640, redo lsn=C05/A8FBF300 2025-06-04 08:36:44.171 UTC [27] LOG: checkpoint starting: time 2025-06-04 08:38:03.201 UTC [7599] ERROR: deadlock detected 2025-06-04 08:38:03.201 UTC [7599] DETAIL: Process 7599 waits for AccessExclusiveLock on tuple (510880,78) of relation 16394 of database 13470; blocked by process 7636. #011Process 7636 waits for ShareLock on transaction 704627769; blocked by process 7617. #011Process 7617 waits for ShareLock on transaction 704627800; blocked by process 7607. #011Process 7607 waits for AccessExclusiveLock on tuple (510880,78) of relation 16394 of database 13470; blocked by process 7599. #011Process 7599: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7636: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7617: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7607: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 08:38:03.201 UTC [7599] HINT: See server log for query details. 2025-06-04 08:38:03.201 UTC [7599] CONTEXT: SQL statement "SELECT internalid FROM "resources" WHERE publicId = patient_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 14 at SQL statement 2025-06-04 08:38:03.201 UTC [7599] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 08:38:03.279 UTC [7643] ERROR: deadlock detected 2025-06-04 08:38:03.279 UTC [7643] DETAIL: Process 7643 waits for AccessExclusiveLock on tuple (510880,78) of relation 16394 of database 13470; blocked by process 7636. #011Process 7636 waits for ShareLock on transaction 704627769; blocked by process 7617. #011Process 7617 waits for ShareLock on transaction 704627800; blocked by process 7607. #011Process 7607 waits for AccessExclusiveLock on tuple (510880,78) of relation 16394 of database 13470; blocked by process 7643. #011Process 7643: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7636: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7617: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7607: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 08:38:03.279 UTC [7643] HINT: See server log for query details. 2025-06-04 08:38:03.279 UTC [7643] CONTEXT: SQL statement "SELECT internalid FROM "resources" WHERE publicId = patient_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 14 at SQL statement 2025-06-04 08:38:03.279 UTC [7643] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 08:38:03.305 UTC [7607] ERROR: deadlock detected 2025-06-04 08:38:03.305 UTC [7607] DETAIL: Process 7607 waits for AccessExclusiveLock on tuple (510880,78) of relation 16394 of database 13470; blocked by process 7636. #011Process 7636 waits for ShareLock on transaction 704627769; blocked by process 7617. #011Process 7617 waits for ShareLock on transaction 704627800; blocked by process 7607. #011Process 7607: SELECT * FROM UpdateInvalidChildCounts() #011Process 7636: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7617: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 08:38:03.305 UTC [7607] HINT: See server log for query details. 2025-06-04 08:38:03.305 UTC [7607] CONTEXT: SQL statement "SELECT ARRAY(SELECT internalId #011 FROM Resources #011 WHERE internalId IN (SELECT DISTINCT id FROM InvalidChildCounts) #011 FOR UPDATE)" #011PL/pgSQL function updateinvalidchildcounts() line 8 at SQL statement 2025-06-04 08:38:03.305 UTC [7607] STATEMENT: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 08:41:14.098 UTC [27] LOG: checkpoint complete: wrote 1411 buffers (8.6%); 0 WAL file(s) added, 0 removed, 17 recycled; write=269.852 s, sync=0.025 s, total=269.927 s; sync files=93, longest=0.001 s, average=0.001 s; distance=277726 kB, estimate=353878 kB; lsn=C05/C6D7D938, redo lsn=C05/B9EF6D00 2025-06-04 08:41:44.112 UTC [27] LOG: checkpoint starting: time 2025-06-04 08:46:14.142 UTC [27] LOG: checkpoint complete: wrote 2261 buffers (13.8%); 0 WAL file(s) added, 0 removed, 13 recycled; write=269.969 s, sync=0.023 s, total=270.030 s; sync files=109, longest=0.002 s, average=0.001 s; distance=211586 kB, estimate=339649 kB; lsn=C05/CE6EB1A8, redo lsn=C05/C6D976F8 2025-06-04 08:46:44.171 UTC [27] LOG: checkpoint starting: time 2025-06-04 08:51:14.139 UTC [27] LOG: checkpoint complete: wrote 2421 buffers (14.8%); 0 WAL file(s) added, 0 removed, 8 recycled; write=269.905 s, sync=0.030 s, total=269.968 s; sync files=89, longest=0.004 s, average=0.001 s; distance=124273 kB, estimate=318111 kB; lsn=C05/D74D2568, redo lsn=C05/CE6F3E50 2025-06-04 08:51:44.167 UTC [27] LOG: checkpoint starting: time 2025-06-04 08:53:03.191 UTC [7637] ERROR: deadlock detected 2025-06-04 08:53:03.191 UTC [7637] DETAIL: Process 7637 waits for ShareLock on transaction 704728259; blocked by process 7605. #011Process 7605 waits for ShareLock on transaction 704728261; blocked by process 7637. #011Process 7637: SELECT * FROM UpdateInvalidChildCounts() #011Process 7605: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 08:53:03.191 UTC [7637] HINT: See server log for query details. 2025-06-04 08:53:03.191 UTC [7637] CONTEXT: while locking tuple (290244,27) in relation "resources" #011SQL statement "SELECT ARRAY(SELECT internalId #011 FROM Resources #011 WHERE internalId IN (SELECT DISTINCT id FROM InvalidChildCounts) #011 FOR UPDATE)" #011PL/pgSQL function updateinvalidchildcounts() line 8 at SQL statement 2025-06-04 08:53:03.191 UTC [7637] STATEMENT: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 08:56:14.129 UTC [27] LOG: checkpoint complete: wrote 719 buffers (4.4%); 0 WAL file(s) added, 1 removed, 9 recycled; write=269.891 s, sync=0.027 s, total=269.962 s; sync files=112, longest=0.002 s, average=0.001 s; distance=172481 kB, estimate=303548 kB; lsn=C05/E98CC080, redo lsn=C05/D8F64498 2025-06-04 08:56:44.159 UTC [27] LOG: checkpoint starting: time 2025-06-04 09:01:14.217 UTC [27] LOG: checkpoint complete: wrote 1276 buffers (7.8%); 0 WAL file(s) added, 1 removed, 17 recycled; write=269.933 s, sync=0.077 s, total=270.058 s; sync files=103, longest=0.006 s, average=0.001 s; distance=281577 kB, estimate=301351 kB; lsn=C05/F7AB2840, redo lsn=C05/EA25EA80 2025-06-04 09:01:44.248 UTC [27] LOG: checkpoint starting: time 2025-06-04 09:06:14.161 UTC [27] LOG: checkpoint complete: wrote 1652 buffers (10.1%); 0 WAL file(s) added, 0 removed, 13 recycled; write=269.832 s, sync=0.034 s, total=269.914 s; sync files=109, longest=0.004 s, average=0.001 s; distance=221619 kB, estimate=293378 kB; lsn=C06/81158A8, redo lsn=C05/F7ACB708 2025-06-04 09:06:44.192 UTC [27] LOG: checkpoint starting: time 2025-06-04 09:08:03.178 UTC [7629] ERROR: deadlock detected 2025-06-04 09:08:03.178 UTC [7629] DETAIL: Process 7629 waits for AccessExclusiveLock on tuple (228853,19) of relation 16394 of database 13470; blocked by process 7605. #011Process 7605 waits for ShareLock on transaction 704858129; blocked by process 7625. #011Process 7625 waits for ShareLock on transaction 704858162; blocked by process 7636. #011Process 7636 waits for AccessExclusiveLock on tuple (228853,19) of relation 16394 of database 13470; blocked by process 7629. #011Process 7629: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7605: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7625: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7636: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 09:08:03.178 UTC [7629] HINT: See server log for query details. 2025-06-04 09:08:03.178 UTC [7629] CONTEXT: SQL statement "SELECT internalid FROM "resources" WHERE publicId = patient_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 14 at SQL statement 2025-06-04 09:08:03.178 UTC [7629] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 09:08:03.240 UTC [7606] ERROR: deadlock detected 2025-06-04 09:08:03.240 UTC [7606] DETAIL: Process 7606 waits for AccessExclusiveLock on tuple (228853,19) of relation 16394 of database 13470; blocked by process 7605. #011Process 7605 waits for ShareLock on transaction 704858129; blocked by process 7625. #011Process 7625 waits for ShareLock on transaction 704858162; blocked by process 7636. #011Process 7636 waits for AccessExclusiveLock on tuple (228853,19) of relation 16394 of database 13470; blocked by process 7606. #011Process 7606: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7605: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7625: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7636: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 09:08:03.240 UTC [7606] HINT: See server log for query details. 2025-06-04 09:08:03.240 UTC [7606] CONTEXT: SQL statement "SELECT internalid FROM "resources" WHERE publicId = patient_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 14 at SQL statement 2025-06-04 09:08:03.240 UTC [7606] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 09:08:03.245 UTC [7628] ERROR: deadlock detected 2025-06-04 09:08:03.245 UTC [7628] DETAIL: Process 7628 waits for AccessExclusiveLock on tuple (228853,19) of relation 16394 of database 13470; blocked by process 7605. #011Process 7605 waits for ShareLock on transaction 704858129; blocked by process 7625. #011Process 7625 waits for ShareLock on transaction 704858162; blocked by process 7636. #011Process 7636 waits for AccessExclusiveLock on tuple (228853,19) of relation 16394 of database 13470; blocked by process 7628. #011Process 7628: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7605: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7625: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7636: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 09:08:03.245 UTC [7628] HINT: See server log for query details. 2025-06-04 09:08:03.245 UTC [7628] CONTEXT: SQL statement "SELECT internalid FROM "resources" WHERE publicId = patient_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 14 at SQL statement 2025-06-04 09:08:03.245 UTC [7628] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 09:08:03.262 UTC [7636] ERROR: deadlock detected 2025-06-04 09:08:03.262 UTC [7636] DETAIL: Process 7636 waits for AccessExclusiveLock on tuple (228853,19) of relation 16394 of database 13470; blocked by process 7605. #011Process 7605 waits for ShareLock on transaction 704858129; blocked by process 7625. #011Process 7625 waits for ShareLock on transaction 704858162; blocked by process 7636. #011Process 7636: SELECT * FROM UpdateInvalidChildCounts() #011Process 7605: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7625: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 09:08:03.262 UTC [7636] HINT: See server log for query details. 2025-06-04 09:08:03.262 UTC [7636] CONTEXT: SQL statement "SELECT ARRAY(SELECT internalId #011 FROM Resources #011 WHERE internalId IN (SELECT DISTINCT id FROM InvalidChildCounts) #011 FOR UPDATE)" #011PL/pgSQL function updateinvalidchildcounts() line 8 at SQL statement 2025-06-04 09:08:03.262 UTC [7636] STATEMENT: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 09:11:14.128 UTC [27] LOG: checkpoint complete: wrote 1830 buffers (11.2%); 0 WAL file(s) added, 1 removed, 16 recycled; write=269.853 s, sync=0.030 s, total=269.937 s; sync files=107, longest=0.003 s, average=0.001 s; distance=268643 kB, estimate=290904 kB; lsn=C06/164A9E60, redo lsn=C06/8124648 2025-06-04 09:11:44.138 UTC [27] LOG: checkpoint starting: time 2025-06-04 09:13:04.312 UTC [7606] ERROR: deadlock detected 2025-06-04 09:13:04.312 UTC [7606] DETAIL: Process 7606 waits for ShareLock on transaction 704900423; blocked by process 7640. #011Process 7640 waits for ShareLock on transaction 704900430; blocked by process 7606. #011Process 7606: SELECT * FROM UpdateInvalidChildCounts() #011Process 7640: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 09:13:04.312 UTC [7606] HINT: See server log for query details. 2025-06-04 09:13:04.312 UTC [7606] CONTEXT: while locking tuple (229992,13) in relation "resources" #011SQL statement "SELECT ARRAY(SELECT internalId #011 FROM Resources #011 WHERE internalId IN (SELECT DISTINCT id FROM InvalidChildCounts) #011 FOR UPDATE)" #011PL/pgSQL function updateinvalidchildcounts() line 8 at SQL statement 2025-06-04 09:13:04.312 UTC [7606] STATEMENT: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 09:16:14.064 UTC [27] LOG: checkpoint complete: wrote 1355 buffers (8.3%); 0 WAL file(s) added, 1 removed, 13 recycled; write=269.858 s, sync=0.020 s, total=269.927 s; sync files=84, longest=0.003 s, average=0.001 s; distance=233030 kB, estimate=285117 kB; lsn=C06/1C808660, redo lsn=C06/164B5FF8 2025-06-04 09:16:44.089 UTC [27] LOG: checkpoint starting: time 2025-06-04 09:18:04.117 UTC [7599] ERROR: deadlock detected 2025-06-04 09:18:04.117 UTC [7599] DETAIL: Process 7599 waits for ShareLock on transaction 704917965; blocked by process 7618. #011Process 7618 waits for ShareLock on transaction 704917968; blocked by process 7599. #011Process 7599: SELECT * FROM UpdateInvalidChildCounts() #011Process 7618: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 09:18:04.117 UTC [7599] HINT: See server log for query details. 2025-06-04 09:18:04.117 UTC [7599] CONTEXT: while locking tuple (230753,70) in relation "resources" #011SQL statement "SELECT ARRAY(SELECT internalId #011 FROM Resources #011 WHERE internalId IN (SELECT DISTINCT id FROM InvalidChildCounts) #011 FOR UPDATE)" #011PL/pgSQL function updateinvalidchildcounts() line 8 at SQL statement 2025-06-04 09:18:04.117 UTC [7599] STATEMENT: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 09:18:06.134 UTC [7645] ERROR: deadlock detected 2025-06-04 09:18:06.134 UTC [7645] DETAIL: Process 7645 waits for ShareLock on transaction 704918489; blocked by process 7647. #011Process 7647 waits for ShareLock on transaction 704918491; blocked by process 7645. #011Process 7645: SELECT * FROM UpdateInvalidChildCounts() #011Process 7647: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 09:18:06.134 UTC [7645] HINT: See server log for query details. 2025-06-04 09:18:06.134 UTC [7645] CONTEXT: while locking tuple (230753,70) in relation "resources" #011SQL statement "SELECT ARRAY(SELECT internalId #011 FROM Resources #011 WHERE internalId IN (SELECT DISTINCT id FROM InvalidChildCounts) #011 FOR UPDATE)" #011PL/pgSQL function updateinvalidchildcounts() line 8 at SQL statement 2025-06-04 09:18:06.134 UTC [7645] STATEMENT: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 09:20:51.433 UTC [7601] ERROR: deadlock detected 2025-06-04 09:20:51.433 UTC [7601] DETAIL: Process 7601 waits for ShareLock on transaction 704932851; blocked by process 7604. #011Process 7604 waits for ShareLock on transaction 704932853; blocked by process 7601. #011Process 7601: SELECT * FROM UpdateInvalidChildCounts() #011Process 7604: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 09:20:51.433 UTC [7601] HINT: See server log for query details. 2025-06-04 09:20:51.433 UTC [7601] CONTEXT: while locking tuple (231016,61) in relation "resources" #011SQL statement "SELECT ARRAY(SELECT internalId #011 FROM Resources #011 WHERE internalId IN (SELECT DISTINCT id FROM InvalidChildCounts) #011 FOR UPDATE)" #011PL/pgSQL function updateinvalidchildcounts() line 8 at SQL statement 2025-06-04 09:20:51.433 UTC [7601] STATEMENT: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 09:20:53.440 UTC [7601] ERROR: deadlock detected 2025-06-04 09:20:53.440 UTC [7601] DETAIL: Process 7601 waits for ShareLock on transaction 704933029; blocked by process 7639. #011Process 7639 waits for ShareLock on transaction 704933037; blocked by process 7604. #011Process 7604 waits for AccessExclusiveLock on tuple (231016,61) of relation 16394 of database 13470; blocked by process 7601. #011Process 7601: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7639: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7604: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 09:20:53.440 UTC [7601] HINT: See server log for query details. 2025-06-04 09:20:53.440 UTC [7601] CONTEXT: while locking tuple (231016,61) in relation "resources" #011SQL statement "SELECT internalid FROM "resources" WHERE publicId = patient_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 14 at SQL statement 2025-06-04 09:20:53.440 UTC [7601] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 09:20:54.440 UTC [7604] ERROR: deadlock detected 2025-06-04 09:20:54.440 UTC [7604] DETAIL: Process 7604 waits for ShareLock on transaction 704933029; blocked by process 7639. #011Process 7639 waits for ShareLock on transaction 704933037; blocked by process 7604. #011Process 7604: SELECT * FROM UpdateInvalidChildCounts() #011Process 7639: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 09:20:54.440 UTC [7604] HINT: See server log for query details. 2025-06-04 09:20:54.440 UTC [7604] CONTEXT: while locking tuple (231016,61) in relation "resources" #011SQL statement "SELECT ARRAY(SELECT internalId #011 FROM Resources #011 WHERE internalId IN (SELECT DISTINCT id FROM InvalidChildCounts) #011 FOR UPDATE)" #011PL/pgSQL function updateinvalidchildcounts() line 8 at SQL statement 2025-06-04 09:20:54.440 UTC [7604] STATEMENT: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 09:20:56.456 UTC [7608] ERROR: deadlock detected 2025-06-04 09:20:56.456 UTC [7608] DETAIL: Process 7608 waits for ShareLock on transaction 704933237; blocked by process 7610. #011Process 7610 waits for ShareLock on transaction 704933240; blocked by process 7608. #011Process 7608: SELECT * FROM UpdateInvalidChildCounts() #011Process 7610: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 09:20:56.456 UTC [7608] HINT: See server log for query details. 2025-06-04 09:20:56.456 UTC [7608] CONTEXT: while locking tuple (231016,61) in relation "resources" #011SQL statement "SELECT ARRAY(SELECT internalId #011 FROM Resources #011 WHERE internalId IN (SELECT DISTINCT id FROM InvalidChildCounts) #011 FOR UPDATE)" #011PL/pgSQL function updateinvalidchildcounts() line 8 at SQL statement 2025-06-04 09:20:56.456 UTC [7608] STATEMENT: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 09:21:14.098 UTC [27] LOG: checkpoint complete: wrote 2396 buffers (14.6%); 0 WAL file(s) added, 2 removed, 4 recycled; write=269.929 s, sync=0.041 s, total=270.010 s; sync files=99, longest=0.004 s, average=0.001 s; distance=101742 kB, estimate=266779 kB; lsn=C06/213533E0, redo lsn=C06/1C811870 2025-06-04 09:21:44.112 UTC [27] LOG: checkpoint starting: time 2025-06-04 09:23:04.733 UTC [7606] ERROR: deadlock detected 2025-06-04 09:23:04.733 UTC [7606] DETAIL: Process 7606 waits for ShareLock on transaction 704943209; blocked by process 7619. #011Process 7619 waits for ShareLock on transaction 704943203; blocked by process 7606. #011Process 7606: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7619: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 09:23:04.733 UTC [7606] HINT: See server log for query details. 2025-06-04 09:23:04.733 UTC [7606] CONTEXT: while locking tuple (231202,65) in relation "resources" #011SQL statement "SELECT internalid FROM "resources" WHERE publicId = series_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 30 at SQL statement 2025-06-04 09:23:04.733 UTC [7606] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 09:23:04.779 UTC [7615] ERROR: deadlock detected 2025-06-04 09:23:04.779 UTC [7615] DETAIL: Process 7615 waits for ShareLock on transaction 704943209; blocked by process 7619. #011Process 7619 waits for ShareLock on transaction 704943191; blocked by process 7615. #011Process 7615: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7619: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 09:23:04.779 UTC [7615] HINT: See server log for query details. 2025-06-04 09:23:04.779 UTC [7615] CONTEXT: while locking tuple (231247,10) in relation "resources" #011SQL statement "SELECT internalid FROM "resources" WHERE publicId = series_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 30 at SQL statement 2025-06-04 09:23:04.779 UTC [7615] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 09:23:04.824 UTC [7630] ERROR: deadlock detected 2025-06-04 09:23:04.824 UTC [7630] DETAIL: Process 7630 waits for AccessExclusiveLock on tuple (231202,63) of relation 16394 of database 13470; blocked by process 7633. #011Process 7633 waits for ShareLock on transaction 704943205; blocked by process 7628. #011Process 7628 waits for ShareLock on transaction 704943209; blocked by process 7619. #011Process 7619 waits for AccessExclusiveLock on tuple (231202,63) of relation 16394 of database 13470; blocked by process 7630. #011Process 7630: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7633: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7628: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7619: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 09:23:04.824 UTC [7630] HINT: See server log for query details. 2025-06-04 09:23:04.824 UTC [7630] CONTEXT: SQL statement "SELECT internalid FROM "resources" WHERE publicId = patient_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 14 at SQL statement 2025-06-04 09:23:04.824 UTC [7630] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 09:23:04.827 UTC [7643] ERROR: deadlock detected 2025-06-04 09:23:04.827 UTC [7643] DETAIL: Process 7643 waits for AccessExclusiveLock on tuple (231202,63) of relation 16394 of database 13470; blocked by process 7633. #011Process 7633 waits for ShareLock on transaction 704943205; blocked by process 7628. #011Process 7628 waits for ShareLock on transaction 704943209; blocked by process 7619. #011Process 7619 waits for AccessExclusiveLock on tuple (231202,63) of relation 16394 of database 13470; blocked by process 7643. #011Process 7643: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7633: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7628: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7619: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 09:23:04.827 UTC [7643] HINT: See server log for query details. 2025-06-04 09:23:04.827 UTC [7643] CONTEXT: SQL statement "SELECT internalid FROM "resources" WHERE publicId = patient_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 14 at SQL statement 2025-06-04 09:23:04.827 UTC [7643] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 09:23:04.830 UTC [7598] ERROR: deadlock detected 2025-06-04 09:23:04.830 UTC [7598] DETAIL: Process 7598 waits for AccessExclusiveLock on tuple (231202,63) of relation 16394 of database 13470; blocked by process 7633. #011Process 7633 waits for ShareLock on transaction 704943205; blocked by process 7628. #011Process 7628 waits for ShareLock on transaction 704943209; blocked by process 7619. #011Process 7619 waits for AccessExclusiveLock on tuple (231202,63) of relation 16394 of database 13470; blocked by process 7598. #011Process 7598: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7633: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7628: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7619: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 09:23:04.830 UTC [7598] HINT: See server log for query details. 2025-06-04 09:23:04.830 UTC [7598] CONTEXT: SQL statement "SELECT internalid FROM "resources" WHERE publicId = patient_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 14 at SQL statement 2025-06-04 09:23:04.830 UTC [7598] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 09:23:04.842 UTC [7626] ERROR: deadlock detected 2025-06-04 09:23:04.842 UTC [7626] DETAIL: Process 7626 waits for AccessExclusiveLock on tuple (231202,63) of relation 16394 of database 13470; blocked by process 7633. #011Process 7633 waits for ShareLock on transaction 704943205; blocked by process 7628. #011Process 7628 waits for ShareLock on transaction 704943209; blocked by process 7619. #011Process 7619 waits for AccessExclusiveLock on tuple (231202,63) of relation 16394 of database 13470; blocked by process 7626. #011Process 7626: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7633: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7628: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7619: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 09:23:04.842 UTC [7626] HINT: See server log for query details. 2025-06-04 09:23:04.842 UTC [7626] CONTEXT: SQL statement "SELECT internalid FROM "resources" WHERE publicId = patient_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 14 at SQL statement 2025-06-04 09:23:04.842 UTC [7626] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 09:23:05.544 UTC [7607] ERROR: deadlock detected 2025-06-04 09:23:05.544 UTC [7607] DETAIL: Process 7607 waits for AccessExclusiveLock on tuple (231202,63) of relation 16394 of database 13470; blocked by process 7633. #011Process 7633 waits for ShareLock on transaction 704943205; blocked by process 7628. #011Process 7628 waits for ShareLock on transaction 704943209; blocked by process 7619. #011Process 7619 waits for AccessExclusiveLock on tuple (231202,63) of relation 16394 of database 13470; blocked by process 7607. #011Process 7607: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7633: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7628: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7619: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 09:23:05.544 UTC [7607] HINT: See server log for query details. 2025-06-04 09:23:05.544 UTC [7607] CONTEXT: SQL statement "SELECT internalid FROM "resources" WHERE publicId = patient_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 14 at SQL statement 2025-06-04 09:23:05.544 UTC [7607] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 09:23:05.734 UTC [7633] ERROR: deadlock detected 2025-06-04 09:23:05.734 UTC [7633] DETAIL: Process 7633 waits for ShareLock on transaction 704943205; blocked by process 7628. #011Process 7628 waits for ShareLock on transaction 704943209; blocked by process 7619. #011Process 7619 waits for AccessExclusiveLock on tuple (231202,63) of relation 16394 of database 13470; blocked by process 7633. #011Process 7633: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7628: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7619: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 09:23:05.734 UTC [7633] HINT: See server log for query details. 2025-06-04 09:23:05.734 UTC [7633] CONTEXT: while locking tuple (231202,63) in relation "resources" #011SQL statement "SELECT internalid FROM "resources" WHERE publicId = patient_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 14 at SQL statement 2025-06-04 09:23:05.734 UTC [7633] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 09:23:05.734 UTC [7628] ERROR: deadlock detected 2025-06-04 09:23:05.734 UTC [7628] DETAIL: Process 7628 waits for ShareLock on transaction 704943209; blocked by process 7619. #011Process 7619 waits for ShareLock on transaction 704943205; blocked by process 7628. #011Process 7628: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7619: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 09:23:05.734 UTC [7628] HINT: See server log for query details. 2025-06-04 09:23:05.734 UTC [7628] CONTEXT: while locking tuple (231202,64) in relation "resources" #011SQL statement "SELECT internalid FROM "resources" WHERE publicId = study_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 22 at SQL statement 2025-06-04 09:23:05.734 UTC [7628] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 09:23:07.772 UTC [7635] ERROR: deadlock detected 2025-06-04 09:23:07.772 UTC [7635] DETAIL: Process 7635 waits for ShareLock on transaction 704943678; blocked by process 7646. #011Process 7646 waits for ShareLock on transaction 704943663; blocked by process 7635. #011Process 7635: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7646: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 09:23:07.772 UTC [7635] HINT: See server log for query details. 2025-06-04 09:23:07.772 UTC [7635] CONTEXT: while locking tuple (231242,42) in relation "resources" #011SQL statement "SELECT internalid FROM "resources" WHERE publicId = series_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 30 at SQL statement 2025-06-04 09:23:07.772 UTC [7635] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 09:26:14.146 UTC [27] LOG: checkpoint complete: wrote 2145 buffers (13.1%); 0 WAL file(s) added, 2 removed, 4 recycled; write=269.961 s, sync=0.026 s, total=270.035 s; sync files=108, longest=0.003 s, average=0.001 s; distance=101929 kB, estimate=250294 kB; lsn=C06/29218C38, redo lsn=C06/22B9BD88 2025-06-04 09:26:44.161 UTC [27] LOG: checkpoint starting: time 2025-06-04 09:28:03.277 UTC [7629] ERROR: deadlock detected 2025-06-04 09:28:03.277 UTC [7629] DETAIL: Process 7629 waits for AccessExclusiveLock on tuple (231704,41) of relation 16394 of database 13470; blocked by process 7599. #011Process 7599 waits for ShareLock on transaction 704961354; blocked by process 7601. #011Process 7601 waits for ShareLock on transaction 704961360; blocked by process 7638. #011Process 7638 waits for AccessExclusiveLock on tuple (231704,41) of relation 16394 of database 13470; blocked by process 7629. #011Process 7629: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7599: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7601: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7638: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 09:28:03.277 UTC [7629] HINT: See server log for query details. 2025-06-04 09:28:03.277 UTC [7629] CONTEXT: SQL statement "SELECT internalid FROM "resources" WHERE publicId = patient_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 14 at SQL statement 2025-06-04 09:28:03.277 UTC [7629] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 09:28:03.281 UTC [7638] ERROR: deadlock detected 2025-06-04 09:28:03.281 UTC [7638] DETAIL: Process 7638 waits for AccessExclusiveLock on tuple (231704,41) of relation 16394 of database 13470; blocked by process 7599. #011Process 7599 waits for ShareLock on transaction 704961354; blocked by process 7601. #011Process 7601 waits for ShareLock on transaction 704961360; blocked by process 7638. #011Process 7638: SELECT * FROM UpdateInvalidChildCounts() #011Process 7599: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7601: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 09:28:03.281 UTC [7638] HINT: See server log for query details. 2025-06-04 09:28:03.281 UTC [7638] CONTEXT: SQL statement "SELECT ARRAY(SELECT internalId #011 FROM Resources #011 WHERE internalId IN (SELECT DISTINCT id FROM InvalidChildCounts) #011 FOR UPDATE)" #011PL/pgSQL function updateinvalidchildcounts() line 8 at SQL statement 2025-06-04 09:28:03.281 UTC [7638] STATEMENT: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 09:31:14.112 UTC [27] LOG: checkpoint complete: wrote 1704 buffers (10.4%); 0 WAL file(s) added, 2 removed, 5 recycled; write=269.894 s, sync=0.018 s, total=269.952 s; sync files=82, longest=0.001 s, average=0.001 s; distance=104978 kB, estimate=235763 kB; lsn=C06/2D034550, redo lsn=C06/29220810 2025-06-04 09:31:44.139 UTC [27] LOG: checkpoint starting: time 2025-06-04 09:33:03.126 UTC [7647] ERROR: deadlock detected 2025-06-04 09:33:03.126 UTC [7647] DETAIL: Process 7647 waits for AccessExclusiveLock on tuple (227992,15) of relation 16394 of database 13470; blocked by process 7643. #011Process 7643 waits for ShareLock on transaction 704971990; blocked by process 7601. #011Process 7601 waits for ShareLock on transaction 704972000; blocked by process 7609. #011Process 7609 waits for AccessExclusiveLock on tuple (227992,15) of relation 16394 of database 13470; blocked by process 7647. #011Process 7647: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7643: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7601: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7609: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 09:33:03.126 UTC [7647] HINT: See server log for query details. 2025-06-04 09:33:03.126 UTC [7647] CONTEXT: SQL statement "SELECT internalid FROM "resources" WHERE publicId = patient_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 14 at SQL statement 2025-06-04 09:33:03.126 UTC [7647] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 09:33:03.128 UTC [7643] ERROR: deadlock detected 2025-06-04 09:33:03.128 UTC [7643] DETAIL: Process 7643 waits for ShareLock on transaction 704971990; blocked by process 7601. #011Process 7601 waits for ShareLock on transaction 704972000; blocked by process 7609. #011Process 7609 waits for AccessExclusiveLock on tuple (227992,15) of relation 16394 of database 13470; blocked by process 7643. #011Process 7643: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7601: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7609: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 09:33:03.128 UTC [7643] HINT: See server log for query details. 2025-06-04 09:33:03.128 UTC [7643] CONTEXT: while locking tuple (227992,15) in relation "resources" #011SQL statement "SELECT internalid FROM "resources" WHERE publicId = patient_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 14 at SQL statement 2025-06-04 09:33:03.128 UTC [7643] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 09:33:03.128 UTC [7601] ERROR: deadlock detected 2025-06-04 09:33:03.128 UTC [7601] DETAIL: Process 7601 waits for ShareLock on transaction 704972000; blocked by process 7609. #011Process 7609 waits for ShareLock on transaction 704971990; blocked by process 7601. #011Process 7601: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7609: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 09:33:03.128 UTC [7601] HINT: See server log for query details. 2025-06-04 09:33:03.128 UTC [7601] CONTEXT: while locking tuple (227992,17) in relation "resources" #011SQL statement "SELECT internalid FROM "resources" WHERE publicId = study_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 22 at SQL statement 2025-06-04 09:33:03.128 UTC [7601] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 09:33:34.680 UTC [7603] ERROR: deadlock detected 2025-06-04 09:33:34.680 UTC [7603] DETAIL: Process 7603 waits for ShareLock on transaction 704983114; blocked by process 7612. #011Process 7612 waits for ShareLock on transaction 704983117; blocked by process 7603. #011Process 7603: SELECT * FROM UpdateInvalidChildCounts() #011Process 7612: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 09:33:34.680 UTC [7603] HINT: See server log for query details. 2025-06-04 09:33:34.680 UTC [7603] CONTEXT: while locking tuple (227992,145) in relation "resources" #011SQL statement "SELECT ARRAY(SELECT internalId #011 FROM Resources #011 WHERE internalId IN (SELECT DISTINCT id FROM InvalidChildCounts) #011 FOR UPDATE)" #011PL/pgSQL function updateinvalidchildcounts() line 8 at SQL statement 2025-06-04 09:33:34.680 UTC [7603] STATEMENT: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 09:33:48.021 UTC [7612] ERROR: deadlock detected 2025-06-04 09:33:48.021 UTC [7612] DETAIL: Process 7612 waits for ShareLock on transaction 704987062; blocked by process 7633. #011Process 7633 waits for ShareLock on transaction 704987057; blocked by process 7612. #011Process 7612: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7633: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 09:33:48.021 UTC [7612] HINT: See server log for query details. 2025-06-04 09:33:48.021 UTC [7612] CONTEXT: while locking tuple (228343,66) in relation "resources" #011SQL statement "SELECT internalid FROM "resources" WHERE publicId = series_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 30 at SQL statement 2025-06-04 09:33:48.021 UTC [7612] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 09:36:14.164 UTC [27] LOG: checkpoint complete: wrote 3046 buffers (18.6%); 0 WAL file(s) added, 3 removed, 1 recycled; write=269.952 s, sync=0.031 s, total=270.026 s; sync files=103, longest=0.003 s, average=0.001 s; distance=63615 kB, estimate=218548 kB; lsn=C06/3AE0C9E8, redo lsn=C06/2D0406A8 2025-06-04 09:36:44.185 UTC [27] LOG: checkpoint starting: time 2025-06-04 09:37:22.557 UTC [7621] ERROR: deadlock detected 2025-06-04 09:37:22.557 UTC [7621] DETAIL: Process 7621 waits for AccessExclusiveLock on tuple (236001,16) of relation 16394 of database 13470; blocked by process 7600. #011Process 7600 waits for ShareLock on transaction 705014606; blocked by process 7636. #011Process 7636 waits for ShareLock on transaction 705014617; blocked by process 7629. #011Process 7629 waits for AccessExclusiveLock on tuple (236001,16) of relation 16394 of database 13470; blocked by process 7621. #011Process 7621: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7600: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7636: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7629: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 09:37:22.557 UTC [7621] HINT: See server log for query details. 2025-06-04 09:37:22.557 UTC [7621] CONTEXT: SQL statement "SELECT internalid FROM "resources" WHERE publicId = patient_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 14 at SQL statement 2025-06-04 09:37:22.557 UTC [7621] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 09:37:22.557 UTC [7639] ERROR: deadlock detected 2025-06-04 09:37:22.557 UTC [7639] DETAIL: Process 7639 waits for AccessExclusiveLock on tuple (236001,16) of relation 16394 of database 13470; blocked by process 7600. #011Process 7600 waits for ShareLock on transaction 705014606; blocked by process 7636. #011Process 7636 waits for ShareLock on transaction 705014617; blocked by process 7629. #011Process 7629 waits for AccessExclusiveLock on tuple (236001,16) of relation 16394 of database 13470; blocked by process 7639. #011Process 7639: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7600: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7636: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7629: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 09:37:22.557 UTC [7639] HINT: See server log for query details. 2025-06-04 09:37:22.557 UTC [7639] CONTEXT: SQL statement "SELECT internalid FROM "resources" WHERE publicId = patient_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 14 at SQL statement 2025-06-04 09:37:22.557 UTC [7639] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 09:37:22.560 UTC [7618] ERROR: deadlock detected 2025-06-04 09:37:22.560 UTC [7618] DETAIL: Process 7618 waits for AccessExclusiveLock on tuple (236001,16) of relation 16394 of database 13470; blocked by process 7600. #011Process 7600 waits for ShareLock on transaction 705014606; blocked by process 7636. #011Process 7636 waits for ShareLock on transaction 705014617; blocked by process 7629. #011Process 7629 waits for AccessExclusiveLock on tuple (236001,16) of relation 16394 of database 13470; blocked by process 7618. #011Process 7618: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7600: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7636: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7629: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 09:37:22.560 UTC [7618] HINT: See server log for query details. 2025-06-04 09:37:22.560 UTC [7618] CONTEXT: SQL statement "SELECT internalid FROM "resources" WHERE publicId = patient_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 14 at SQL statement 2025-06-04 09:37:22.560 UTC [7618] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 09:37:22.578 UTC [7629] ERROR: deadlock detected 2025-06-04 09:37:22.578 UTC [7629] DETAIL: Process 7629 waits for AccessExclusiveLock on tuple (236001,16) of relation 16394 of database 13470; blocked by process 7600. #011Process 7600 waits for ShareLock on transaction 705014606; blocked by process 7636. #011Process 7636 waits for ShareLock on transaction 705014617; blocked by process 7629. #011Process 7629: SELECT * FROM UpdateInvalidChildCounts() #011Process 7600: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7636: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 09:37:22.578 UTC [7629] HINT: See server log for query details. 2025-06-04 09:37:22.578 UTC [7629] CONTEXT: SQL statement "SELECT ARRAY(SELECT internalId #011 FROM Resources #011 WHERE internalId IN (SELECT DISTINCT id FROM InvalidChildCounts) #011 FOR UPDATE)" #011PL/pgSQL function updateinvalidchildcounts() line 8 at SQL statement 2025-06-04 09:37:22.578 UTC [7629] STATEMENT: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 09:38:02.957 UTC [7611] ERROR: deadlock detected 2025-06-04 09:38:02.957 UTC [7611] DETAIL: Process 7611 waits for ShareLock on transaction 705018718; blocked by process 7616. #011Process 7616 waits for ShareLock on transaction 705018720; blocked by process 7611. #011Process 7611: SELECT * FROM UpdateInvalidChildCounts() #011Process 7616: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 09:38:02.957 UTC [7611] HINT: See server log for query details. 2025-06-04 09:38:02.957 UTC [7611] CONTEXT: while locking tuple (232069,3) in relation "resources" #011SQL statement "SELECT ARRAY(SELECT internalId #011 FROM Resources #011 WHERE internalId IN (SELECT DISTINCT id FROM InvalidChildCounts) #011 FOR UPDATE)" #011PL/pgSQL function updateinvalidchildcounts() line 8 at SQL statement 2025-06-04 09:38:02.957 UTC [7611] STATEMENT: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 09:38:04.978 UTC [7617] ERROR: deadlock detected 2025-06-04 09:38:04.978 UTC [7617] DETAIL: Process 7617 waits for ShareLock on transaction 705019334; blocked by process 7640. #011Process 7640 waits for ShareLock on transaction 705019344; blocked by process 7617. #011Process 7617: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7640: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 09:38:04.978 UTC [7617] HINT: See server log for query details. 2025-06-04 09:38:04.978 UTC [7617] CONTEXT: while locking tuple (232059,34) in relation "resources" #011SQL statement "SELECT internalid FROM "resources" WHERE publicId = series_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 30 at SQL statement 2025-06-04 09:38:04.978 UTC [7617] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 09:38:04.980 UTC [7602] ERROR: deadlock detected 2025-06-04 09:38:04.980 UTC [7602] DETAIL: Process 7602 waits for ShareLock on transaction 705019334; blocked by process 7640. #011Process 7640 waits for ShareLock on transaction 705019324; blocked by process 7602. #011Process 7602: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7640: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 09:38:04.980 UTC [7602] HINT: See server log for query details. 2025-06-04 09:38:04.980 UTC [7602] CONTEXT: while locking tuple (232070,6) in relation "resources" #011SQL statement "SELECT internalid FROM "resources" WHERE publicId = series_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 30 at SQL statement 2025-06-04 09:38:04.980 UTC [7602] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 09:38:05.023 UTC [7636] ERROR: deadlock detected 2025-06-04 09:38:05.023 UTC [7636] DETAIL: Process 7636 waits for AccessExclusiveLock on tuple (232069,3) of relation 16394 of database 13470; blocked by process 7643. #011Process 7643 waits for ShareLock on transaction 705019366; blocked by process 7598. #011Process 7598 waits for ShareLock on transaction 705019334; blocked by process 7640. #011Process 7640 waits for AccessExclusiveLock on tuple (232069,3) of relation 16394 of database 13470; blocked by process 7636. #011Process 7636: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7643: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7598: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7640: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 09:38:05.023 UTC [7636] HINT: See server log for query details. 2025-06-04 09:38:05.023 UTC [7636] CONTEXT: SQL statement "SELECT internalid FROM "resources" WHERE publicId = patient_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 14 at SQL statement 2025-06-04 09:38:05.023 UTC [7636] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 09:38:05.034 UTC [7618] ERROR: deadlock detected 2025-06-04 09:38:05.034 UTC [7618] DETAIL: Process 7618 waits for AccessExclusiveLock on tuple (232069,3) of relation 16394 of database 13470; blocked by process 7643. #011Process 7643 waits for ShareLock on transaction 705019366; blocked by process 7598. #011Process 7598 waits for ShareLock on transaction 705019334; blocked by process 7640. #011Process 7640 waits for AccessExclusiveLock on tuple (232069,3) of relation 16394 of database 13470; blocked by process 7618. #011Process 7618: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7643: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7598: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7640: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 09:38:05.034 UTC [7618] HINT: See server log for query details. 2025-06-04 09:38:05.034 UTC [7618] CONTEXT: SQL statement "SELECT internalid FROM "resources" WHERE publicId = patient_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 14 at SQL statement 2025-06-04 09:38:05.034 UTC [7618] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 09:38:05.037 UTC [7629] ERROR: deadlock detected 2025-06-04 09:38:05.037 UTC [7629] DETAIL: Process 7629 waits for AccessExclusiveLock on tuple (232069,3) of relation 16394 of database 13470; blocked by process 7643. #011Process 7643 waits for ShareLock on transaction 705019366; blocked by process 7598. #011Process 7598 waits for ShareLock on transaction 705019334; blocked by process 7640. #011Process 7640 waits for AccessExclusiveLock on tuple (232069,3) of relation 16394 of database 13470; blocked by process 7629. #011Process 7629: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7643: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7598: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7640: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 09:38:05.037 UTC [7629] HINT: See server log for query details. 2025-06-04 09:38:05.037 UTC [7629] CONTEXT: SQL statement "SELECT internalid FROM "resources" WHERE publicId = patient_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 14 at SQL statement 2025-06-04 09:38:05.037 UTC [7629] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 09:38:05.064 UTC [7630] ERROR: deadlock detected 2025-06-04 09:38:05.064 UTC [7630] DETAIL: Process 7630 waits for AccessExclusiveLock on tuple (232069,3) of relation 16394 of database 13470; blocked by process 7643. #011Process 7643 waits for ShareLock on transaction 705019366; blocked by process 7598. #011Process 7598 waits for ShareLock on transaction 705019334; blocked by process 7640. #011Process 7640 waits for AccessExclusiveLock on tuple (232069,3) of relation 16394 of database 13470; blocked by process 7630. #011Process 7630: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7643: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7598: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7640: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 09:38:05.064 UTC [7630] HINT: See server log for query details. 2025-06-04 09:38:05.064 UTC [7630] CONTEXT: SQL statement "SELECT internalid FROM "resources" WHERE publicId = patient_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 14 at SQL statement 2025-06-04 09:38:05.064 UTC [7630] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 09:38:05.691 UTC [7621] ERROR: deadlock detected 2025-06-04 09:38:05.691 UTC [7621] DETAIL: Process 7621 waits for AccessExclusiveLock on tuple (232069,3) of relation 16394 of database 13470; blocked by process 7643. #011Process 7643 waits for ShareLock on transaction 705019366; blocked by process 7598. #011Process 7598 waits for ShareLock on transaction 705019334; blocked by process 7640. #011Process 7640 waits for AccessExclusiveLock on tuple (232069,3) of relation 16394 of database 13470; blocked by process 7621. #011Process 7621: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7643: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7598: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7640: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 09:38:05.691 UTC [7621] HINT: See server log for query details. 2025-06-04 09:38:05.691 UTC [7621] CONTEXT: SQL statement "SELECT internalid FROM "resources" WHERE publicId = patient_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 14 at SQL statement 2025-06-04 09:38:05.691 UTC [7621] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 09:38:05.979 UTC [7643] ERROR: deadlock detected 2025-06-04 09:38:05.979 UTC [7643] DETAIL: Process 7643 waits for ShareLock on transaction 705019366; blocked by process 7598. #011Process 7598 waits for ShareLock on transaction 705019334; blocked by process 7640. #011Process 7640 waits for AccessExclusiveLock on tuple (232069,3) of relation 16394 of database 13470; blocked by process 7643. #011Process 7643: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7598: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7640: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 09:38:05.979 UTC [7643] HINT: See server log for query details. 2025-06-04 09:38:05.979 UTC [7643] CONTEXT: while locking tuple (232069,3) in relation "resources" #011SQL statement "SELECT internalid FROM "resources" WHERE publicId = patient_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 14 at SQL statement 2025-06-04 09:38:05.979 UTC [7643] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 09:38:05.979 UTC [7598] ERROR: deadlock detected 2025-06-04 09:38:05.979 UTC [7598] DETAIL: Process 7598 waits for ShareLock on transaction 705019334; blocked by process 7640. #011Process 7640 waits for ShareLock on transaction 705019366; blocked by process 7598. #011Process 7598: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7640: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 09:38:05.979 UTC [7598] HINT: See server log for query details. 2025-06-04 09:38:05.979 UTC [7598] CONTEXT: while locking tuple (232069,4) in relation "resources" #011SQL statement "SELECT internalid FROM "resources" WHERE publicId = study_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 22 at SQL statement 2025-06-04 09:38:05.979 UTC [7598] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 09:38:05.981 UTC [7616] ERROR: deadlock detected 2025-06-04 09:38:05.981 UTC [7616] DETAIL: Process 7616 waits for ShareLock on transaction 705019331; blocked by process 7613. #011Process 7613 waits for ShareLock on transaction 705019334; blocked by process 7640. #011Process 7640 waits for AccessExclusiveLock on tuple (232070,3) of relation 16394 of database 13470; blocked by process 7616. #011Process 7616: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7613: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7640: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 09:38:05.981 UTC [7616] HINT: See server log for query details. 2025-06-04 09:38:05.981 UTC [7616] CONTEXT: while locking tuple (232070,3) in relation "resources" #011SQL statement "SELECT internalid FROM "resources" WHERE publicId = patient_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 14 at SQL statement 2025-06-04 09:38:05.981 UTC [7616] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 09:38:05.981 UTC [7613] ERROR: deadlock detected 2025-06-04 09:38:05.981 UTC [7613] DETAIL: Process 7613 waits for ShareLock on transaction 705019334; blocked by process 7640. #011Process 7640 waits for AccessExclusiveLock on tuple (232070,3) of relation 16394 of database 13470; blocked by process 7614. #011Process 7614 waits for ShareLock on transaction 705019331; blocked by process 7613. #011Process 7613: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7640: SELECT * FROM UpdateInvalidChildCounts() #011Process 7614: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 09:38:05.981 UTC [7613] HINT: See server log for query details. 2025-06-04 09:38:05.981 UTC [7613] CONTEXT: while locking tuple (232070,5) in relation "resources" #011SQL statement "SELECT internalid FROM "resources" WHERE publicId = study_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 22 at SQL statement 2025-06-04 09:38:05.981 UTC [7613] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 09:38:06.103 UTC [7615] ERROR: deadlock detected 2025-06-04 09:38:06.103 UTC [7615] DETAIL: Process 7615 waits for AccessExclusiveLock on tuple (232070,3) of relation 16394 of database 13470; blocked by process 7599. #011Process 7599 waits for ShareLock on transaction 705019342; blocked by process 7614. #011Process 7614 waits for ShareLock on transaction 705019334; blocked by process 7640. #011Process 7640 waits for AccessExclusiveLock on tuple (232070,3) of relation 16394 of database 13470; blocked by process 7615. #011Process 7615: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7599: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7614: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7640: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 09:38:06.103 UTC [7615] HINT: See server log for query details. 2025-06-04 09:38:06.103 UTC [7615] CONTEXT: SQL statement "SELECT internalid FROM "resources" WHERE publicId = patient_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 14 at SQL statement 2025-06-04 09:38:06.103 UTC [7615] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 09:38:06.980 UTC [7640] ERROR: deadlock detected 2025-06-04 09:38:06.980 UTC [7640] DETAIL: Process 7640 waits for AccessExclusiveLock on tuple (232070,3) of relation 16394 of database 13470; blocked by process 7599. #011Process 7599 waits for ShareLock on transaction 705019342; blocked by process 7614. #011Process 7614 waits for ShareLock on transaction 705019334; blocked by process 7640. #011Process 7640: SELECT * FROM UpdateInvalidChildCounts() #011Process 7599: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7614: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 09:38:06.980 UTC [7640] HINT: See server log for query details. 2025-06-04 09:38:06.980 UTC [7640] CONTEXT: SQL statement "SELECT ARRAY(SELECT internalId #011 FROM Resources #011 WHERE internalId IN (SELECT DISTINCT id FROM InvalidChildCounts) #011 FOR UPDATE)" #011PL/pgSQL function updateinvalidchildcounts() line 8 at SQL statement 2025-06-04 09:38:06.980 UTC [7640] STATEMENT: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 09:41:14.084 UTC [27] LOG: checkpoint complete: wrote 1151 buffers (7.0%); 0 WAL file(s) added, 0 removed, 13 recycled; write=269.829 s, sync=0.030 s, total=269.900 s; sync files=105, longest=0.003 s, average=0.001 s; distance=227187 kB, estimate=227187 kB; lsn=C06/475F8DF0, redo lsn=C06/3AE1D4C8 2025-06-04 09:41:44.109 UTC [27] LOG: checkpoint starting: time 2025-06-04 09:46:14.101 UTC [27] LOG: checkpoint complete: wrote 1038 buffers (6.3%); 0 WAL file(s) added, 0 removed, 13 recycled; write=269.912 s, sync=0.018 s, total=269.992 s; sync files=88, longest=0.003 s, average=0.001 s; distance=211720 kB, estimate=225640 kB; lsn=C06/503F3000, redo lsn=C06/47CDF768 2025-06-04 09:46:44.131 UTC [27] LOG: checkpoint starting: time 2025-06-04 09:48:03.541 UTC [7647] ERROR: deadlock detected 2025-06-04 09:48:03.541 UTC [7647] DETAIL: Process 7647 waits for ShareLock on transaction 705091488; blocked by process 7616. #011Process 7616 waits for ShareLock on transaction 705091480; blocked by process 7647. #011Process 7647: SELECT * FROM UpdateInvalidChildCounts() #011Process 7616: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 09:48:03.541 UTC [7647] HINT: See server log for query details. 2025-06-04 09:48:03.541 UTC [7647] CONTEXT: while locking tuple (527309,2) in relation "resources" #011SQL statement "SELECT ARRAY(SELECT internalId #011 FROM Resources #011 WHERE internalId IN (SELECT DISTINCT id FROM InvalidChildCounts) #011 FOR UPDATE)" #011PL/pgSQL function updateinvalidchildcounts() line 8 at SQL statement 2025-06-04 09:48:03.541 UTC [7647] STATEMENT: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 09:48:05.552 UTC [7608] ERROR: deadlock detected 2025-06-04 09:48:05.552 UTC [7608] DETAIL: Process 7608 waits for ShareLock on transaction 705091884; blocked by process 7607. #011Process 7607 waits for AccessExclusiveLock on tuple (233895,106) of relation 16394 of database 13470; blocked by process 7626. #011Process 7626 waits for ShareLock on transaction 705091873; blocked by process 7608. #011Process 7608: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7607: SELECT * FROM UpdateInvalidChildCounts() #011Process 7626: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 09:48:05.552 UTC [7608] HINT: See server log for query details. 2025-06-04 09:48:05.552 UTC [7608] CONTEXT: while locking tuple (233947,1) in relation "resources" #011SQL statement "SELECT internalid FROM "resources" WHERE publicId = study_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 22 at SQL statement 2025-06-04 09:48:05.552 UTC [7608] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 09:48:05.565 UTC [7607] ERROR: deadlock detected 2025-06-04 09:48:05.565 UTC [7607] DETAIL: Process 7607 waits for AccessExclusiveLock on tuple (233895,106) of relation 16394 of database 13470; blocked by process 7646. #011Process 7646 waits for ShareLock on transaction 705091886; blocked by process 7626. #011Process 7626 waits for ShareLock on transaction 705091884; blocked by process 7607. #011Process 7607: SELECT * FROM UpdateInvalidChildCounts() #011Process 7646: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7626: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 09:48:05.565 UTC [7607] HINT: See server log for query details. 2025-06-04 09:48:05.565 UTC [7607] CONTEXT: SQL statement "SELECT ARRAY(SELECT internalId #011 FROM Resources #011 WHERE internalId IN (SELECT DISTINCT id FROM InvalidChildCounts) #011 FOR UPDATE)" #011PL/pgSQL function updateinvalidchildcounts() line 8 at SQL statement 2025-06-04 09:48:05.565 UTC [7607] STATEMENT: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 09:48:07.624 UTC [7599] ERROR: deadlock detected 2025-06-04 09:48:07.624 UTC [7599] DETAIL: Process 7599 waits for ShareLock on transaction 705092257; blocked by process 7635. #011Process 7635 waits for ShareLock on transaction 705092263; blocked by process 7599. #011Process 7599: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7635: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 09:48:07.624 UTC [7599] HINT: See server log for query details. 2025-06-04 09:48:07.624 UTC [7599] CONTEXT: while locking tuple (233926,57) in relation "resources" #011SQL statement "SELECT internalid FROM "resources" WHERE publicId = study_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 22 at SQL statement 2025-06-04 09:48:07.624 UTC [7599] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 09:48:36.715 UTC [7626] ERROR: deadlock detected 2025-06-04 09:48:36.715 UTC [7626] DETAIL: Process 7626 waits for ShareLock on transaction 705104738; blocked by process 7632. #011Process 7632 waits for ShareLock on transaction 705104709; blocked by process 7626. #011Process 7626: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7632: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 09:48:36.715 UTC [7626] HINT: See server log for query details. 2025-06-04 09:48:36.715 UTC [7626] CONTEXT: while locking tuple (234142,74) in relation "resources" #011SQL statement "SELECT internalid FROM "resources" WHERE publicId = series_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 30 at SQL statement 2025-06-04 09:48:36.715 UTC [7626] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 09:48:57.102 UTC [7640] ERROR: deadlock detected 2025-06-04 09:48:57.102 UTC [7640] DETAIL: Process 7640 waits for ShareLock on transaction 705112704; blocked by process 7639. #011Process 7639 waits for ShareLock on transaction 705112705; blocked by process 7640. #011Process 7640: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7639: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 09:48:57.102 UTC [7640] HINT: See server log for query details. 2025-06-04 09:48:57.102 UTC [7640] CONTEXT: while locking tuple (233954,120) in relation "resources" #011SQL statement "SELECT internalid FROM "resources" WHERE publicId = series_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 30 at SQL statement 2025-06-04 09:48:57.102 UTC [7640] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 09:51:14.101 UTC [27] LOG: checkpoint complete: wrote 2378 buffers (14.5%); 0 WAL file(s) added, 0 removed, 10 recycled; write=269.899 s, sync=0.032 s, total=269.970 s; sync files=112, longest=0.003 s, average=0.001 s; distance=162971 kB, estimate=219373 kB; lsn=C06/5F1BE178, redo lsn=C06/51C063F8 2025-06-04 09:51:44.119 UTC [27] LOG: checkpoint starting: time 2025-06-04 09:56:14.082 UTC [27] LOG: checkpoint complete: wrote 1933 buffers (11.8%); 0 WAL file(s) added, 0 removed, 14 recycled; write=269.879 s, sync=0.027 s, total=269.964 s; sync files=106, longest=0.003 s, average=0.001 s; distance=219282 kB, estimate=219364 kB; lsn=C06/6C4C12D8, redo lsn=C06/5F22AE58 2025-06-04 09:56:44.103 UTC [27] LOG: checkpoint starting: time 2025-06-04 09:58:05.637 UTC [7612] ERROR: deadlock detected 2025-06-04 09:58:05.637 UTC [7612] DETAIL: Process 7612 waits for ShareLock on transaction 705178714; blocked by process 7601. #011Process 7601 waits for ShareLock on transaction 705178715; blocked by process 7612. #011Process 7612: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7601: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 09:58:05.637 UTC [7612] HINT: See server log for query details. 2025-06-04 09:58:05.637 UTC [7612] CONTEXT: while locking tuple (237955,35) in relation "resources" #011SQL statement "SELECT internalid FROM "resources" WHERE publicId = series_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 30 at SQL statement 2025-06-04 09:58:05.637 UTC [7612] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 09:58:06.639 UTC [7646] ERROR: deadlock detected 2025-06-04 09:58:06.639 UTC [7646] DETAIL: Process 7646 waits for ShareLock on transaction 705178714; blocked by process 7601. #011Process 7601 waits for ShareLock on transaction 705178725; blocked by process 7646. #011Process 7646: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7601: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 09:58:06.639 UTC [7646] HINT: See server log for query details. 2025-06-04 09:58:06.639 UTC [7646] CONTEXT: while locking tuple (237955,35) in relation "resources" #011SQL statement "SELECT internalid FROM "resources" WHERE publicId = series_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 30 at SQL statement 2025-06-04 09:58:06.639 UTC [7646] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 09:58:10.708 UTC [7620] ERROR: deadlock detected 2025-06-04 09:58:10.708 UTC [7620] DETAIL: Process 7620 waits for ShareLock on transaction 705180231; blocked by process 7645. #011Process 7645 waits for ShareLock on transaction 705180232; blocked by process 7620. #011Process 7620: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7645: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 09:58:10.708 UTC [7620] HINT: See server log for query details. 2025-06-04 09:58:10.708 UTC [7620] CONTEXT: while locking tuple (237952,82) in relation "resources" #011SQL statement "SELECT internalid FROM "resources" WHERE publicId = series_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 30 at SQL statement 2025-06-04 09:58:10.708 UTC [7620] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 09:58:16.794 UTC [7625] ERROR: deadlock detected 2025-06-04 09:58:16.794 UTC [7625] DETAIL: Process 7625 waits for ShareLock on transaction 705182908; blocked by process 7603. #011Process 7603 waits for ShareLock on transaction 705182911; blocked by process 7625. #011Process 7625: SELECT * FROM UpdateInvalidChildCounts() #011Process 7603: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 09:58:16.794 UTC [7625] HINT: See server log for query details. 2025-06-04 09:58:16.794 UTC [7625] CONTEXT: while locking tuple (237899,126) in relation "resources" #011SQL statement "SELECT ARRAY(SELECT internalId #011 FROM Resources #011 WHERE internalId IN (SELECT DISTINCT id FROM InvalidChildCounts) #011 FOR UPDATE)" #011PL/pgSQL function updateinvalidchildcounts() line 8 at SQL statement 2025-06-04 09:58:16.794 UTC [7625] STATEMENT: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 09:58:27.297 UTC [7625] ERROR: deadlock detected 2025-06-04 09:58:27.297 UTC [7625] DETAIL: Process 7625 waits for ShareLock on transaction 705187397; blocked by process 7605. #011Process 7605 waits for ShareLock on transaction 705187386; blocked by process 7625. #011Process 7625: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7605: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 09:58:27.297 UTC [7625] HINT: See server log for query details. 2025-06-04 09:58:27.297 UTC [7625] CONTEXT: while locking tuple (238243,23) in relation "resources" #011SQL statement "SELECT internalid FROM "resources" WHERE publicId = series_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 30 at SQL statement 2025-06-04 09:58:27.297 UTC [7625] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 10:01:14.126 UTC [27] LOG: checkpoint complete: wrote 1528 buffers (9.3%); 0 WAL file(s) added, 4 removed, 10 recycled; write=269.928 s, sync=0.039 s, total=270.023 s; sync files=107, longest=0.005 s, average=0.001 s; distance=227556 kB, estimate=227556 kB; lsn=C06/8104FD08, redo lsn=C06/6D063E58 2025-06-04 10:01:44.143 UTC [27] LOG: checkpoint starting: time 2025-06-04 10:06:14.141 UTC [27] LOG: checkpoint complete: wrote 1076 buffers (6.6%); 0 WAL file(s) added, 0 removed, 20 recycled; write=269.913 s, sync=0.034 s, total=269.998 s; sync files=108, longest=0.003 s, average=0.001 s; distance=328809 kB, estimate=328809 kB; lsn=C06/8AEA9230, redo lsn=C06/8117E530 2025-06-04 10:06:44.158 UTC [27] LOG: checkpoint starting: time 2025-06-04 10:11:14.136 UTC [27] LOG: checkpoint complete: wrote 1413 buffers (8.6%); 0 WAL file(s) added, 0 removed, 9 recycled; write=269.914 s, sync=0.032 s, total=269.979 s; sync files=101, longest=0.004 s, average=0.001 s; distance=160970 kB, estimate=312025 kB; lsn=C06/91186060, redo lsn=C06/8AEB10F0 2025-06-04 10:11:44.150 UTC [27] LOG: checkpoint starting: time 2025-06-04 10:13:03.381 UTC [7616] ERROR: deadlock detected 2025-06-04 10:13:03.381 UTC [7616] DETAIL: Process 7616 waits for AccessExclusiveLock on tuple (236255,48) of relation 16394 of database 13470; blocked by process 7626. #011Process 7626 waits for ShareLock on transaction 705281786; blocked by process 7644. #011Process 7644 waits for ShareLock on transaction 705281826; blocked by process 7627. #011Process 7627 waits for AccessExclusiveLock on tuple (236255,48) of relation 16394 of database 13470; blocked by process 7616. #011Process 7616: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7626: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7644: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7627: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 10:13:03.381 UTC [7616] HINT: See server log for query details. 2025-06-04 10:13:03.381 UTC [7616] CONTEXT: SQL statement "SELECT internalid FROM "resources" WHERE publicId = patient_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 14 at SQL statement 2025-06-04 10:13:03.381 UTC [7616] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 10:13:03.387 UTC [7599] ERROR: deadlock detected 2025-06-04 10:13:03.387 UTC [7599] DETAIL: Process 7599 waits for AccessExclusiveLock on tuple (236255,48) of relation 16394 of database 13470; blocked by process 7626. #011Process 7626 waits for ShareLock on transaction 705281786; blocked by process 7644. #011Process 7644 waits for ShareLock on transaction 705281826; blocked by process 7627. #011Process 7627 waits for AccessExclusiveLock on tuple (236255,48) of relation 16394 of database 13470; blocked by process 7599. #011Process 7599: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7626: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7644: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7627: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 10:13:03.387 UTC [7599] HINT: See server log for query details. 2025-06-04 10:13:03.387 UTC [7599] CONTEXT: SQL statement "SELECT internalid FROM "resources" WHERE publicId = patient_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 14 at SQL statement 2025-06-04 10:13:03.387 UTC [7599] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 10:13:03.429 UTC [7627] ERROR: deadlock detected 2025-06-04 10:13:03.429 UTC [7627] DETAIL: Process 7627 waits for AccessExclusiveLock on tuple (236255,48) of relation 16394 of database 13470; blocked by process 7626. #011Process 7626 waits for ShareLock on transaction 705281786; blocked by process 7644. #011Process 7644 waits for ShareLock on transaction 705281826; blocked by process 7627. #011Process 7627: SELECT * FROM UpdateInvalidChildCounts() #011Process 7626: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7644: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 10:13:03.429 UTC [7627] HINT: See server log for query details. 2025-06-04 10:13:03.429 UTC [7627] CONTEXT: SQL statement "SELECT ARRAY(SELECT internalId #011 FROM Resources #011 WHERE internalId IN (SELECT DISTINCT id FROM InvalidChildCounts) #011 FOR UPDATE)" #011PL/pgSQL function updateinvalidchildcounts() line 8 at SQL statement 2025-06-04 10:13:03.429 UTC [7627] STATEMENT: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 10:13:05.448 UTC [7606] ERROR: deadlock detected 2025-06-04 10:13:05.448 UTC [7606] DETAIL: Process 7606 waits for ShareLock on transaction 705282428; blocked by process 7613. #011Process 7613 waits for ShareLock on transaction 705282434; blocked by process 7632. #011Process 7632 waits for AccessExclusiveLock on tuple (236233,83) of relation 16394 of database 13470; blocked by process 7606. #011Process 7606: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7613: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7632: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 10:13:05.448 UTC [7606] HINT: See server log for query details. 2025-06-04 10:13:05.448 UTC [7606] CONTEXT: while locking tuple (236233,83) in relation "resources" #011SQL statement "SELECT internalid FROM "resources" WHERE publicId = patient_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 14 at SQL statement 2025-06-04 10:13:05.448 UTC [7606] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 10:13:06.449 UTC [7632] ERROR: deadlock detected 2025-06-04 10:13:06.449 UTC [7632] DETAIL: Process 7632 waits for ShareLock on transaction 705282428; blocked by process 7613. #011Process 7613 waits for ShareLock on transaction 705282434; blocked by process 7632. #011Process 7632: SELECT * FROM UpdateInvalidChildCounts() #011Process 7613: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 10:13:06.449 UTC [7632] HINT: See server log for query details. 2025-06-04 10:13:06.449 UTC [7632] CONTEXT: while locking tuple (236233,83) in relation "resources" #011SQL statement "SELECT ARRAY(SELECT internalId #011 FROM Resources #011 WHERE internalId IN (SELECT DISTINCT id FROM InvalidChildCounts) #011 FOR UPDATE)" #011PL/pgSQL function updateinvalidchildcounts() line 8 at SQL statement 2025-06-04 10:13:06.449 UTC [7632] STATEMENT: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 10:13:14.596 UTC [7642] ERROR: deadlock detected 2025-06-04 10:13:14.596 UTC [7642] DETAIL: Process 7642 waits for ShareLock on transaction 705285117; blocked by process 7634. #011Process 7634 waits for ShareLock on transaction 705285128; blocked by process 7642. #011Process 7642: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7634: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 10:13:14.596 UTC [7642] HINT: See server log for query details. 2025-06-04 10:13:14.596 UTC [7642] CONTEXT: while locking tuple (236313,7) in relation "resources" #011SQL statement "SELECT internalid FROM "resources" WHERE publicId = series_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 30 at SQL statement 2025-06-04 10:13:14.596 UTC [7642] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 10:13:42.032 UTC [7622] ERROR: deadlock detected 2025-06-04 10:13:42.032 UTC [7622] DETAIL: Process 7622 waits for ShareLock on transaction 705295087; blocked by process 7606. #011Process 7606 waits for ShareLock on transaction 705295090; blocked by process 7622. #011Process 7622: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7606: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 10:13:42.032 UTC [7622] HINT: See server log for query details. 2025-06-04 10:13:42.032 UTC [7622] CONTEXT: while locking tuple (236570,41) in relation "resources" #011SQL statement "SELECT internalid FROM "resources" WHERE publicId = series_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 30 at SQL statement 2025-06-04 10:13:42.032 UTC [7622] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 10:16:14.104 UTC [27] LOG: checkpoint complete: wrote 1165 buffers (7.1%); 0 WAL file(s) added, 0 removed, 7 recycled; write=269.899 s, sync=0.028 s, total=269.954 s; sync files=96, longest=0.003 s, average=0.001 s; distance=101230 kB, estimate=290946 kB; lsn=C06/A1054748, redo lsn=C06/9118CB90 2025-06-04 10:16:44.132 UTC [27] LOG: checkpoint starting: time 2025-06-04 10:18:03.306 UTC [7611] ERROR: deadlock detected 2025-06-04 10:18:03.306 UTC [7611] DETAIL: Process 7611 waits for AccessExclusiveLock on tuple (519552,61) of relation 16394 of database 13470; blocked by process 7612. #011Process 7612 waits for ShareLock on transaction 705326963; blocked by process 7640. #011Process 7640 waits for ShareLock on transaction 705326967; blocked by process 7611. #011Process 7611: SELECT * FROM UpdateInvalidChildCounts() #011Process 7612: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7640: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 10:18:03.306 UTC [7611] HINT: See server log for query details. 2025-06-04 10:18:03.306 UTC [7611] CONTEXT: SQL statement "SELECT ARRAY(SELECT internalId #011 FROM Resources #011 WHERE internalId IN (SELECT DISTINCT id FROM InvalidChildCounts) #011 FOR UPDATE)" #011PL/pgSQL function updateinvalidchildcounts() line 8 at SQL statement 2025-06-04 10:18:03.306 UTC [7611] STATEMENT: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 10:18:05.340 UTC [7623] ERROR: deadlock detected 2025-06-04 10:18:05.340 UTC [7623] DETAIL: Process 7623 waits for ShareLock on transaction 705327397; blocked by process 7641. #011Process 7641 waits for ShareLock on transaction 705327400; blocked by process 7623. #011Process 7623: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7641: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 10:18:05.340 UTC [7623] HINT: See server log for query details. 2025-06-04 10:18:05.340 UTC [7623] CONTEXT: while locking tuple (237276,67) in relation "resources" #011SQL statement "SELECT internalid FROM "resources" WHERE publicId = series_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 30 at SQL statement 2025-06-04 10:18:05.340 UTC [7623] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 10:18:07.439 UTC [7611] ERROR: deadlock detected 2025-06-04 10:18:07.439 UTC [7611] DETAIL: Process 7611 waits for ShareLock on transaction 705327778; blocked by process 7621. #011Process 7621 waits for ShareLock on transaction 705327782; blocked by process 7611. #011Process 7611: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7621: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 10:18:07.439 UTC [7611] HINT: See server log for query details. 2025-06-04 10:18:07.439 UTC [7611] CONTEXT: while locking tuple (237276,80) in relation "resources" #011SQL statement "SELECT internalid FROM "resources" WHERE publicId = series_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 30 at SQL statement 2025-06-04 10:18:07.439 UTC [7611] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 10:18:11.510 UTC [7613] ERROR: deadlock detected 2025-06-04 10:18:11.510 UTC [7613] DETAIL: Process 7613 waits for ShareLock on transaction 705328939; blocked by process 7601. #011Process 7601 waits for ShareLock on transaction 705328937; blocked by process 7613. #011Process 7613: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7601: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 10:18:11.510 UTC [7613] HINT: See server log for query details. 2025-06-04 10:18:11.510 UTC [7613] CONTEXT: while locking tuple (237297,95) in relation "resources" #011SQL statement "SELECT internalid FROM "resources" WHERE publicId = series_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 30 at SQL statement 2025-06-04 10:18:11.510 UTC [7613] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 10:21:14.086 UTC [27] LOG: checkpoint complete: wrote 1191 buffers (7.3%); 0 WAL file(s) added, 0 removed, 16 recycled; write=269.878 s, sync=0.023 s, total=269.955 s; sync files=97, longest=0.003 s, average=0.001 s; distance=260948 kB, estimate=287946 kB; lsn=C06/A60D2C88, redo lsn=C06/A1061EF8 2025-06-04 10:21:44.107 UTC [27] LOG: checkpoint starting: time 2025-06-04 10:23:03.639 UTC [7632] ERROR: deadlock detected 2025-06-04 10:23:03.639 UTC [7632] DETAIL: Process 7632 waits for AccessExclusiveLock on tuple (237419,78) of relation 16394 of database 13470; blocked by process 7598. #011Process 7598 waits for ShareLock on transaction 705338809; blocked by process 7620. #011Process 7620 waits for ShareLock on transaction 705338808; blocked by process 7624. #011Process 7624 waits for AccessExclusiveLock on tuple (237419,78) of relation 16394 of database 13470; blocked by process 7632. #011Process 7632: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7598: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7620: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7624: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 10:23:03.639 UTC [7632] HINT: See server log for query details. 2025-06-04 10:23:03.639 UTC [7632] CONTEXT: SQL statement "SELECT internalid FROM "resources" WHERE publicId = patient_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 14 at SQL statement 2025-06-04 10:23:03.639 UTC [7632] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 10:23:03.649 UTC [7598] ERROR: deadlock detected 2025-06-04 10:23:03.649 UTC [7598] DETAIL: Process 7598 waits for ShareLock on transaction 705338809; blocked by process 7620. #011Process 7620 waits for ShareLock on transaction 705338808; blocked by process 7624. #011Process 7624 waits for AccessExclusiveLock on tuple (237419,78) of relation 16394 of database 13470; blocked by process 7598. #011Process 7598: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7620: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7624: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 10:23:03.649 UTC [7598] HINT: See server log for query details. 2025-06-04 10:23:03.649 UTC [7598] CONTEXT: while locking tuple (237419,78) in relation "resources" #011SQL statement "SELECT internalid FROM "resources" WHERE publicId = patient_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 14 at SQL statement 2025-06-04 10:23:03.649 UTC [7598] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 10:23:04.650 UTC [7624] ERROR: deadlock detected 2025-06-04 10:23:04.650 UTC [7624] DETAIL: Process 7624 waits for ShareLock on transaction 705338809; blocked by process 7620. #011Process 7620 waits for ShareLock on transaction 705338808; blocked by process 7624. #011Process 7624: SELECT * FROM UpdateInvalidChildCounts() #011Process 7620: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 10:23:04.650 UTC [7624] HINT: See server log for query details. 2025-06-04 10:23:04.650 UTC [7624] CONTEXT: while locking tuple (237419,78) in relation "resources" #011SQL statement "SELECT ARRAY(SELECT internalId #011 FROM Resources #011 WHERE internalId IN (SELECT DISTINCT id FROM InvalidChildCounts) #011 FOR UPDATE)" #011PL/pgSQL function updateinvalidchildcounts() line 8 at SQL statement 2025-06-04 10:23:04.650 UTC [7624] STATEMENT: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 10:23:06.680 UTC [7610] ERROR: deadlock detected 2025-06-04 10:23:06.680 UTC [7610] DETAIL: Process 7610 waits for ShareLock on transaction 705339306; blocked by process 7609. #011Process 7609 waits for AccessExclusiveLock on tuple (237419,78) of relation 16394 of database 13470; blocked by process 7604. #011Process 7604 waits for ShareLock on transaction 705339310; blocked by process 7610. #011Process 7610: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7609: SELECT * FROM UpdateInvalidChildCounts() #011Process 7604: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 10:23:06.680 UTC [7610] HINT: See server log for query details. 2025-06-04 10:23:06.680 UTC [7610] CONTEXT: while locking tuple (237419,80) in relation "resources" #011SQL statement "SELECT internalid FROM "resources" WHERE publicId = study_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 22 at SQL statement 2025-06-04 10:23:06.680 UTC [7610] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 10:23:06.690 UTC [7609] ERROR: deadlock detected 2025-06-04 10:23:06.690 UTC [7609] DETAIL: Process 7609 waits for AccessExclusiveLock on tuple (237419,78) of relation 16394 of database 13470; blocked by process 7624. #011Process 7624 waits for ShareLock on transaction 705339318; blocked by process 7604. #011Process 7604 waits for ShareLock on transaction 705339306; blocked by process 7609. #011Process 7609: SELECT * FROM UpdateInvalidChildCounts() #011Process 7624: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7604: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 10:23:06.690 UTC [7609] HINT: See server log for query details. 2025-06-04 10:23:06.690 UTC [7609] CONTEXT: SQL statement "SELECT ARRAY(SELECT internalId #011 FROM Resources #011 WHERE internalId IN (SELECT DISTINCT id FROM InvalidChildCounts) #011 FOR UPDATE)" #011PL/pgSQL function updateinvalidchildcounts() line 8 at SQL statement 2025-06-04 10:23:06.690 UTC [7609] STATEMENT: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 10:23:56.017 UTC [7623] ERROR: deadlock detected 2025-06-04 10:23:56.017 UTC [7623] DETAIL: Process 7623 waits for ShareLock on transaction 705358242; blocked by process 7622. #011Process 7622 waits for ShareLock on transaction 705358217; blocked by process 7623. #011Process 7623: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7622: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 10:23:56.017 UTC [7623] HINT: See server log for query details. 2025-06-04 10:23:56.017 UTC [7623] CONTEXT: while locking tuple (242384,51) in relation "resources" #011SQL statement "SELECT internalid FROM "resources" WHERE publicId = series_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 30 at SQL statement 2025-06-04 10:23:56.017 UTC [7623] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 10:26:14.142 UTC [27] LOG: checkpoint complete: wrote 1531 buffers (9.3%); 0 WAL file(s) added, 0 removed, 5 recycled; write=269.968 s, sync=0.035 s, total=270.035 s; sync files=111, longest=0.003 s, average=0.001 s; distance=82398 kB, estimate=267391 kB; lsn=C06/B9098D00, redo lsn=C06/A60D9930 2025-06-04 10:26:44.167 UTC [27] LOG: checkpoint starting: time 2025-06-04 10:28:06.236 UTC [7615] ERROR: deadlock detected 2025-06-04 10:28:06.236 UTC [7615] DETAIL: Process 7615 waits for ShareLock on transaction 705395260; blocked by process 7643. #011Process 7643 waits for ShareLock on transaction 705395266; blocked by process 7615. #011Process 7615: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7643: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 10:28:06.236 UTC [7615] HINT: See server log for query details. 2025-06-04 10:28:06.236 UTC [7615] CONTEXT: while locking tuple (243319,33) in relation "resources" #011SQL statement "SELECT internalid FROM "resources" WHERE publicId = series_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 30 at SQL statement 2025-06-04 10:28:06.236 UTC [7615] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 10:28:13.315 UTC [7616] ERROR: deadlock detected 2025-06-04 10:28:13.315 UTC [7616] DETAIL: Process 7616 waits for ShareLock on transaction 705397933; blocked by process 7610. #011Process 7610 waits for ShareLock on transaction 705397934; blocked by process 7616. #011Process 7616: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7610: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 10:28:13.315 UTC [7616] HINT: See server log for query details. 2025-06-04 10:28:13.315 UTC [7616] CONTEXT: while locking tuple (243363,58) in relation "resources" #011SQL statement "SELECT internalid FROM "resources" WHERE publicId = series_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 30 at SQL statement 2025-06-04 10:28:13.315 UTC [7616] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 10:31:14.172 UTC [27] LOG: checkpoint complete: wrote 1408 buffers (8.6%); 0 WAL file(s) added, 0 removed, 20 recycled; write=269.923 s, sync=0.030 s, total=270.006 s; sync files=109, longest=0.003 s, average=0.001 s; distance=331454 kB, estimate=331454 kB; lsn=C06/C7117810, redo lsn=C06/BA489200 2025-06-04 10:31:44.196 UTC [27] LOG: checkpoint starting: time 2025-06-04 10:33:06.422 UTC [7634] ERROR: deadlock detected 2025-06-04 10:33:06.422 UTC [7634] DETAIL: Process 7634 waits for ShareLock on transaction 705425442; blocked by process 7604. #011Process 7604 waits for ShareLock on transaction 705425421; blocked by process 7634. #011Process 7634: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7604: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 10:33:06.422 UTC [7634] HINT: See server log for query details. 2025-06-04 10:33:06.422 UTC [7634] CONTEXT: while locking tuple (243970,31) in relation "resources" #011SQL statement "SELECT internalid FROM "resources" WHERE publicId = series_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 30 at SQL statement 2025-06-04 10:33:06.422 UTC [7634] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 10:33:13.577 UTC [7615] ERROR: deadlock detected 2025-06-04 10:33:13.577 UTC [7615] DETAIL: Process 7615 waits for ShareLock on transaction 705428018; blocked by process 7635. #011Process 7635 waits for ShareLock on transaction 705428019; blocked by process 7615. #011Process 7615: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7635: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 10:33:13.577 UTC [7615] HINT: See server log for query details. 2025-06-04 10:33:13.577 UTC [7615] CONTEXT: while locking tuple (243997,68) in relation "resources" #011SQL statement "SELECT internalid FROM "resources" WHERE publicId = series_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 30 at SQL statement 2025-06-04 10:33:13.577 UTC [7615] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 10:33:16.614 UTC [7603] ERROR: deadlock detected 2025-06-04 10:33:16.614 UTC [7603] DETAIL: Process 7603 waits for ShareLock on transaction 705428953; blocked by process 7638. #011Process 7638 waits for ShareLock on transaction 705428942; blocked by process 7603. #011Process 7603: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7638: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 10:33:16.614 UTC [7603] HINT: See server log for query details. 2025-06-04 10:33:16.614 UTC [7603] CONTEXT: while locking tuple (243927,156) in relation "resources" #011SQL statement "SELECT internalid FROM "resources" WHERE publicId = series_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 30 at SQL statement 2025-06-04 10:33:16.614 UTC [7603] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 10:36:14.118 UTC [27] LOG: checkpoint complete: wrote 2291 buffers (14.0%); 0 WAL file(s) added, 0 removed, 13 recycled; write=269.854 s, sync=0.028 s, total=269.923 s; sync files=98, longest=0.003 s, average=0.001 s; distance=209495 kB, estimate=319258 kB; lsn=C06/DDEC9758, redo lsn=C06/C711F168 2025-06-04 10:36:44.147 UTC [27] LOG: checkpoint starting: time 2025-06-04 10:38:06.547 UTC [7636] ERROR: deadlock detected 2025-06-04 10:38:06.547 UTC [7636] DETAIL: Process 7636 waits for ShareLock on transaction 705488869; blocked by process 7618. #011Process 7618 waits for ShareLock on transaction 705488870; blocked by process 7636. #011Process 7636: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7618: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 10:38:06.547 UTC [7636] HINT: See server log for query details. 2025-06-04 10:38:06.547 UTC [7636] CONTEXT: while locking tuple (241509,49) in relation "resources" #011SQL statement "SELECT internalid FROM "resources" WHERE publicId = series_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 30 at SQL statement 2025-06-04 10:38:06.547 UTC [7636] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 10:41:14.177 UTC [27] LOG: checkpoint complete: wrote 1291 buffers (7.9%); 0 WAL file(s) added, 0 removed, 22 recycled; write=269.937 s, sync=0.033 s, total=270.030 s; sync files=105, longest=0.004 s, average=0.001 s; distance=374494 kB, estimate=374494 kB; lsn=C06/E6DCB620, redo lsn=C06/DDED6A20 2025-06-04 10:41:44.200 UTC [27] LOG: checkpoint starting: time 2025-06-04 10:43:03.685 UTC [7606] ERROR: deadlock detected 2025-06-04 10:43:03.685 UTC [7606] DETAIL: Process 7606 waits for AccessExclusiveLock on tuple (246976,57) of relation 16394 of database 13470; blocked by process 7608. #011Process 7608 waits for ShareLock on transaction 705514442; blocked by process 7629. #011Process 7629 waits for ShareLock on transaction 705514444; blocked by process 7598. #011Process 7598 waits for AccessExclusiveLock on tuple (246976,57) of relation 16394 of database 13470; blocked by process 7606. #011Process 7606: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7608: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7629: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7598: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 10:43:03.685 UTC [7606] HINT: See server log for query details. 2025-06-04 10:43:03.685 UTC [7606] CONTEXT: SQL statement "SELECT internalid FROM "resources" WHERE publicId = patient_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 14 at SQL statement 2025-06-04 10:43:03.685 UTC [7606] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 10:43:03.695 UTC [7608] ERROR: deadlock detected 2025-06-04 10:43:03.695 UTC [7608] DETAIL: Process 7608 waits for ShareLock on transaction 705514442; blocked by process 7629. #011Process 7629 waits for ShareLock on transaction 705514444; blocked by process 7598. #011Process 7598 waits for AccessExclusiveLock on tuple (246976,57) of relation 16394 of database 13470; blocked by process 7608. #011Process 7608: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7629: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7598: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 10:43:03.695 UTC [7608] HINT: See server log for query details. 2025-06-04 10:43:03.695 UTC [7608] CONTEXT: while locking tuple (246976,57) in relation "resources" #011SQL statement "SELECT internalid FROM "resources" WHERE publicId = patient_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 14 at SQL statement 2025-06-04 10:43:03.695 UTC [7608] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 10:43:03.695 UTC [7629] ERROR: deadlock detected 2025-06-04 10:43:03.695 UTC [7629] DETAIL: Process 7629 waits for ShareLock on transaction 705514444; blocked by process 7598. #011Process 7598 waits for ShareLock on transaction 705514442; blocked by process 7629. #011Process 7629: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7598: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 10:43:03.695 UTC [7629] HINT: See server log for query details. 2025-06-04 10:43:03.695 UTC [7629] CONTEXT: while locking tuple (246976,58) in relation "resources" #011SQL statement "SELECT internalid FROM "resources" WHERE publicId = study_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 22 at SQL statement 2025-06-04 10:43:03.695 UTC [7629] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 10:43:03.699 UTC [7603] ERROR: deadlock detected 2025-06-04 10:43:03.699 UTC [7603] DETAIL: Process 7603 waits for ShareLock on transaction 705514452; blocked by process 7599. #011Process 7599 waits for ShareLock on transaction 705514444; blocked by process 7598. #011Process 7598 waits for AccessExclusiveLock on tuple (246997,47) of relation 16394 of database 13470; blocked by process 7603. #011Process 7603: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7599: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7598: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 10:43:03.699 UTC [7603] HINT: See server log for query details. 2025-06-04 10:43:03.699 UTC [7603] CONTEXT: while locking tuple (246997,47) in relation "resources" #011SQL statement "SELECT internalid FROM "resources" WHERE publicId = patient_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 14 at SQL statement 2025-06-04 10:43:03.699 UTC [7603] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 10:43:03.746 UTC [7618] ERROR: deadlock detected 2025-06-04 10:43:03.746 UTC [7618] DETAIL: Process 7618 waits for AccessExclusiveLock on tuple (246997,47) of relation 16394 of database 13470; blocked by process 7623. #011Process 7623 waits for ShareLock on transaction 705514452; blocked by process 7599. #011Process 7599 waits for ShareLock on transaction 705514444; blocked by process 7598. #011Process 7598 waits for AccessExclusiveLock on tuple (246997,47) of relation 16394 of database 13470; blocked by process 7618. #011Process 7618: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7623: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7599: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7598: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 10:43:03.746 UTC [7618] HINT: See server log for query details. 2025-06-04 10:43:03.746 UTC [7618] CONTEXT: SQL statement "SELECT internalid FROM "resources" WHERE publicId = patient_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 14 at SQL statement 2025-06-04 10:43:03.746 UTC [7618] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 10:43:03.761 UTC [7619] ERROR: deadlock detected 2025-06-04 10:43:03.761 UTC [7619] DETAIL: Process 7619 waits for AccessExclusiveLock on tuple (246997,47) of relation 16394 of database 13470; blocked by process 7623. #011Process 7623 waits for ShareLock on transaction 705514452; blocked by process 7599. #011Process 7599 waits for ShareLock on transaction 705514444; blocked by process 7598. #011Process 7598 waits for AccessExclusiveLock on tuple (246997,47) of relation 16394 of database 13470; blocked by process 7619. #011Process 7619: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7623: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7599: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7598: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 10:43:03.761 UTC [7619] HINT: See server log for query details. 2025-06-04 10:43:03.761 UTC [7619] CONTEXT: SQL statement "SELECT internalid FROM "resources" WHERE publicId = patient_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 14 at SQL statement 2025-06-04 10:43:03.761 UTC [7619] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 10:43:04.272 UTC [7612] ERROR: deadlock detected 2025-06-04 10:43:04.272 UTC [7612] DETAIL: Process 7612 waits for AccessExclusiveLock on tuple (246997,47) of relation 16394 of database 13470; blocked by process 7623. #011Process 7623 waits for ShareLock on transaction 705514452; blocked by process 7599. #011Process 7599 waits for ShareLock on transaction 705514444; blocked by process 7598. #011Process 7598 waits for AccessExclusiveLock on tuple (246997,47) of relation 16394 of database 13470; blocked by process 7612. #011Process 7612: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7623: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7599: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7598: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 10:43:04.272 UTC [7612] HINT: See server log for query details. 2025-06-04 10:43:04.272 UTC [7612] CONTEXT: SQL statement "SELECT internalid FROM "resources" WHERE publicId = patient_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 14 at SQL statement 2025-06-04 10:43:04.272 UTC [7612] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 10:43:04.696 UTC [7598] ERROR: deadlock detected 2025-06-04 10:43:04.696 UTC [7598] DETAIL: Process 7598 waits for AccessExclusiveLock on tuple (246997,47) of relation 16394 of database 13470; blocked by process 7623. #011Process 7623 waits for ShareLock on transaction 705514452; blocked by process 7599. #011Process 7599 waits for ShareLock on transaction 705514444; blocked by process 7598. #011Process 7598: SELECT * FROM UpdateInvalidChildCounts() #011Process 7623: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7599: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 10:43:04.696 UTC [7598] HINT: See server log for query details. 2025-06-04 10:43:04.696 UTC [7598] CONTEXT: SQL statement "SELECT ARRAY(SELECT internalId #011 FROM Resources #011 WHERE internalId IN (SELECT DISTINCT id FROM InvalidChildCounts) #011 FOR UPDATE)" #011PL/pgSQL function updateinvalidchildcounts() line 8 at SQL statement 2025-06-04 10:43:04.696 UTC [7598] STATEMENT: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 10:43:06.714 UTC [7647] ERROR: deadlock detected 2025-06-04 10:43:06.714 UTC [7647] DETAIL: Process 7647 waits for ShareLock on transaction 705514954; blocked by process 7618. #011Process 7618 waits for AccessExclusiveLock on tuple (246997,47) of relation 16394 of database 13470; blocked by process 7625. #011Process 7625 waits for ShareLock on transaction 705514927; blocked by process 7647. #011Process 7647: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7618: SELECT * FROM UpdateInvalidChildCounts() #011Process 7625: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 10:43:06.714 UTC [7647] HINT: See server log for query details. 2025-06-04 10:43:06.714 UTC [7647] CONTEXT: while locking tuple (246997,50) in relation "resources" #011SQL statement "SELECT internalid FROM "resources" WHERE publicId = study_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 22 at SQL statement 2025-06-04 10:43:06.714 UTC [7647] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 10:43:06.771 UTC [7618] ERROR: deadlock detected 2025-06-04 10:43:06.771 UTC [7618] DETAIL: Process 7618 waits for AccessExclusiveLock on tuple (246997,47) of relation 16394 of database 13470; blocked by process 7612. #011Process 7612 waits for ShareLock on transaction 705514940; blocked by process 7625. #011Process 7625 waits for ShareLock on transaction 705514954; blocked by process 7618. #011Process 7618: SELECT * FROM UpdateInvalidChildCounts() #011Process 7612: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7625: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 10:43:06.771 UTC [7618] HINT: See server log for query details. 2025-06-04 10:43:06.771 UTC [7618] CONTEXT: SQL statement "SELECT ARRAY(SELECT internalId #011 FROM Resources #011 WHERE internalId IN (SELECT DISTINCT id FROM InvalidChildCounts) #011 FOR UPDATE)" #011PL/pgSQL function updateinvalidchildcounts() line 8 at SQL statement 2025-06-04 10:43:06.771 UTC [7618] STATEMENT: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 10:43:09.161 UTC [7621] ERROR: deadlock detected 2025-06-04 10:43:09.161 UTC [7621] DETAIL: Process 7621 waits for ShareLock on transaction 705515509; blocked by process 7646. #011Process 7646 waits for ShareLock on transaction 705515533; blocked by process 7623. #011Process 7623 waits for AccessExclusiveLock on tuple (246997,47) of relation 16394 of database 13470; blocked by process 7621. #011Process 7621: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7646: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7623: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 10:43:09.161 UTC [7621] HINT: See server log for query details. 2025-06-04 10:43:09.161 UTC [7621] CONTEXT: while locking tuple (246997,47) in relation "resources" #011SQL statement "SELECT internalid FROM "resources" WHERE publicId = patient_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 14 at SQL statement 2025-06-04 10:43:09.161 UTC [7621] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 10:43:09.225 UTC [7623] ERROR: deadlock detected 2025-06-04 10:43:09.225 UTC [7623] DETAIL: Process 7623 waits for AccessExclusiveLock on tuple (246997,47) of relation 16394 of database 13470; blocked by process 7640. #011Process 7640 waits for ShareLock on transaction 705515509; blocked by process 7646. #011Process 7646 waits for ShareLock on transaction 705515533; blocked by process 7623. #011Process 7623: SELECT * FROM UpdateInvalidChildCounts() #011Process 7640: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7646: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 10:43:09.225 UTC [7623] HINT: See server log for query details. 2025-06-04 10:43:09.225 UTC [7623] CONTEXT: SQL statement "SELECT ARRAY(SELECT internalId #011 FROM Resources #011 WHERE internalId IN (SELECT DISTINCT id FROM InvalidChildCounts) #011 FOR UPDATE)" #011PL/pgSQL function updateinvalidchildcounts() line 8 at SQL statement 2025-06-04 10:43:09.225 UTC [7623] STATEMENT: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 10:43:11.239 UTC [7645] ERROR: deadlock detected 2025-06-04 10:43:11.239 UTC [7645] DETAIL: Process 7645 waits for ShareLock on transaction 705516102; blocked by process 7638. #011Process 7638 waits for AccessExclusiveLock on tuple (246997,47) of relation 16394 of database 13470; blocked by process 7611. #011Process 7611 waits for ShareLock on transaction 705516086; blocked by process 7645. #011Process 7645: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7638: SELECT * FROM UpdateInvalidChildCounts() #011Process 7611: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 10:43:11.239 UTC [7645] HINT: See server log for query details. 2025-06-04 10:43:11.239 UTC [7645] CONTEXT: while locking tuple (246997,50) in relation "resources" #011SQL statement "SELECT internalid FROM "resources" WHERE publicId = study_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 22 at SQL statement 2025-06-04 10:43:11.239 UTC [7645] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 10:43:11.267 UTC [7638] ERROR: deadlock detected 2025-06-04 10:43:11.267 UTC [7638] DETAIL: Process 7638 waits for AccessExclusiveLock on tuple (246997,47) of relation 16394 of database 13470; blocked by process 7643. #011Process 7643 waits for ShareLock on transaction 705516095; blocked by process 7611. #011Process 7611 waits for ShareLock on transaction 705516102; blocked by process 7638. #011Process 7638: SELECT * FROM UpdateInvalidChildCounts() #011Process 7643: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7611: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 10:43:11.267 UTC [7638] HINT: See server log for query details. 2025-06-04 10:43:11.267 UTC [7638] CONTEXT: SQL statement "SELECT ARRAY(SELECT internalId #011 FROM Resources #011 WHERE internalId IN (SELECT DISTINCT id FROM InvalidChildCounts) #011 FOR UPDATE)" #011PL/pgSQL function updateinvalidchildcounts() line 8 at SQL statement 2025-06-04 10:43:11.267 UTC [7638] STATEMENT: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 10:43:13.281 UTC [7606] ERROR: deadlock detected 2025-06-04 10:43:13.281 UTC [7606] DETAIL: Process 7606 waits for ShareLock on transaction 705516645; blocked by process 7598. #011Process 7598 waits for ShareLock on transaction 705516646; blocked by process 7606. #011Process 7606: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7598: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 10:43:13.281 UTC [7606] HINT: See server log for query details. 2025-06-04 10:43:13.281 UTC [7606] CONTEXT: while locking tuple (246997,50) in relation "resources" #011SQL statement "SELECT internalid FROM "resources" WHERE publicId = study_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 22 at SQL statement 2025-06-04 10:43:13.281 UTC [7606] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 10:43:21.516 UTC [7616] ERROR: deadlock detected 2025-06-04 10:43:21.516 UTC [7616] DETAIL: Process 7616 waits for ShareLock on transaction 705520492; blocked by process 7607. #011Process 7607 waits for ShareLock on transaction 705520482; blocked by process 7616. #011Process 7616: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7607: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 10:43:21.516 UTC [7616] HINT: See server log for query details. 2025-06-04 10:43:21.516 UTC [7616] CONTEXT: while locking tuple (247205,12) in relation "resources" #011SQL statement "SELECT internalid FROM "resources" WHERE publicId = series_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 30 at SQL statement 2025-06-04 10:43:21.516 UTC [7616] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 10:46:14.078 UTC [27] LOG: checkpoint complete: wrote 2383 buffers (14.5%); 0 WAL file(s) added, 0 removed, 9 recycled; write=269.812 s, sync=0.032 s, total=269.879 s; sync files=103, longest=0.003 s, average=0.001 s; distance=147055 kB, estimate=351750 kB; lsn=C06/ED997B58, redo lsn=C06/E6E72680 2025-06-04 10:46:44.107 UTC [27] LOG: checkpoint starting: time 2025-06-04 10:48:03.468 UTC [7635] ERROR: deadlock detected 2025-06-04 10:48:03.468 UTC [7635] DETAIL: Process 7635 waits for AccessExclusiveLock on tuple (247305,87) of relation 16394 of database 13470; blocked by process 7633. #011Process 7633 waits for ShareLock on transaction 705529645; blocked by process 7642. #011Process 7642 waits for ShareLock on transaction 705529650; blocked by process 7635. #011Process 7635: SELECT * FROM UpdateInvalidChildCounts() #011Process 7633: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7642: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 10:48:03.468 UTC [7635] HINT: See server log for query details. 2025-06-04 10:48:03.468 UTC [7635] CONTEXT: SQL statement "SELECT ARRAY(SELECT internalId #011 FROM Resources #011 WHERE internalId IN (SELECT DISTINCT id FROM InvalidChildCounts) #011 FOR UPDATE)" #011PL/pgSQL function updateinvalidchildcounts() line 8 at SQL statement 2025-06-04 10:48:03.468 UTC [7635] STATEMENT: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 10:51:14.073 UTC [27] LOG: checkpoint complete: wrote 3366 buffers (20.5%); 0 WAL file(s) added, 0 removed, 8 recycled; write=269.914 s, sync=0.023 s, total=269.966 s; sync files=109, longest=0.002 s, average=0.001 s; distance=118671 kB, estimate=328442 kB; lsn=C06/F3E5C150, redo lsn=C06/EE256388 2025-06-04 10:51:44.104 UTC [27] LOG: checkpoint starting: time 2025-06-04 10:56:14.099 UTC [27] LOG: checkpoint complete: wrote 3464 buffers (21.1%); 0 WAL file(s) added, 0 removed, 5 recycled; write=269.952 s, sync=0.023 s, total=269.996 s; sync files=87, longest=0.004 s, average=0.001 s; distance=94260 kB, estimate=305024 kB; lsn=C06/F9E0EE98, redo lsn=C06/F3E63550 2025-06-04 10:56:44.130 UTC [27] LOG: checkpoint starting: time 2025-06-04 10:58:03.726 UTC [7635] ERROR: deadlock detected 2025-06-04 10:58:03.726 UTC [7635] DETAIL: Process 7635 waits for ShareLock on transaction 705560165; blocked by process 7624. #011Process 7624 waits for ShareLock on transaction 705560164; blocked by process 7635. #011Process 7635: SELECT * FROM UpdateInvalidChildCounts() #011Process 7624: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 10:58:03.726 UTC [7635] HINT: See server log for query details. 2025-06-04 10:58:03.726 UTC [7635] CONTEXT: while locking tuple (247810,32) in relation "resources" #011SQL statement "SELECT ARRAY(SELECT internalId #011 FROM Resources #011 WHERE internalId IN (SELECT DISTINCT id FROM InvalidChildCounts) #011 FOR UPDATE)" #011PL/pgSQL function updateinvalidchildcounts() line 8 at SQL statement 2025-06-04 10:58:03.726 UTC [7635] STATEMENT: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 10:58:05.741 UTC [7609] ERROR: deadlock detected 2025-06-04 10:58:05.741 UTC [7609] DETAIL: Process 7609 waits for ShareLock on transaction 705560604; blocked by process 7646. #011Process 7646 waits for ShareLock on transaction 705560606; blocked by process 7609. #011Process 7609: SELECT * FROM UpdateInvalidChildCounts() #011Process 7646: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 10:58:05.741 UTC [7609] HINT: See server log for query details. 2025-06-04 10:58:05.741 UTC [7609] CONTEXT: while locking tuple (493995,82) in relation "resources" #011SQL statement "SELECT ARRAY(SELECT internalId #011 FROM Resources #011 WHERE internalId IN (SELECT DISTINCT id FROM InvalidChildCounts) #011 FOR UPDATE)" #011PL/pgSQL function updateinvalidchildcounts() line 8 at SQL statement 2025-06-04 10:58:05.741 UTC [7609] STATEMENT: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 10:58:07.760 UTC [7636] ERROR: deadlock detected 2025-06-04 10:58:07.760 UTC [7636] DETAIL: Process 7636 waits for AccessExclusiveLock on tuple (493995,82) of relation 16394 of database 13470; blocked by process 7633. #011Process 7633 waits for ShareLock on transaction 705561138; blocked by process 7624. #011Process 7624 waits for ShareLock on transaction 705561137; blocked by process 7636. #011Process 7636: SELECT * FROM UpdateInvalidChildCounts() #011Process 7633: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7624: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 10:58:07.760 UTC [7636] HINT: See server log for query details. 2025-06-04 10:58:07.760 UTC [7636] CONTEXT: SQL statement "SELECT ARRAY(SELECT internalId #011 FROM Resources #011 WHERE internalId IN (SELECT DISTINCT id FROM InvalidChildCounts) #011 FOR UPDATE)" #011PL/pgSQL function updateinvalidchildcounts() line 8 at SQL statement 2025-06-04 10:58:07.760 UTC [7636] STATEMENT: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 11:01:14.143 UTC [27] LOG: checkpoint complete: wrote 3931 buffers (24.0%); 0 WAL file(s) added, 0 removed, 8 recycled; write=269.956 s, sync=0.027 s, total=270.014 s; sync files=118, longest=0.003 s, average=0.001 s; distance=120559 kB, estimate=286577 kB; lsn=C07/26B79E8, redo lsn=C06/FB41F410 2025-06-04 11:01:44.167 UTC [27] LOG: checkpoint starting: time 2025-06-04 11:06:14.081 UTC [27] LOG: checkpoint complete: wrote 2684 buffers (16.4%); 0 WAL file(s) added, 0 removed, 7 recycled; write=269.868 s, sync=0.020 s, total=269.914 s; sync files=90, longest=0.001 s, average=0.001 s; distance=117374 kB, estimate=269657 kB; lsn=C07/9B87F98, redo lsn=C07/26BED68 2025-06-04 11:06:44.108 UTC [27] LOG: checkpoint starting: time 2025-06-04 11:10:36.434 UTC [7629] ERROR: deadlock detected 2025-06-04 11:10:36.434 UTC [7629] DETAIL: Process 7629 waits for ShareLock on transaction 705609860; blocked by process 7633. #011Process 7633 waits for ShareLock on transaction 705609859; blocked by process 7629. #011Process 7629: SELECT * FROM UpdateInvalidChildCounts() #011Process 7633: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 11:10:36.434 UTC [7629] HINT: See server log for query details. 2025-06-04 11:10:36.434 UTC [7629] CONTEXT: while locking tuple (244469,55) in relation "resources" #011SQL statement "SELECT ARRAY(SELECT internalId #011 FROM Resources #011 WHERE internalId IN (SELECT DISTINCT id FROM InvalidChildCounts) #011 FOR UPDATE)" #011PL/pgSQL function updateinvalidchildcounts() line 8 at SQL statement 2025-06-04 11:10:36.434 UTC [7629] STATEMENT: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 11:10:38.449 UTC [7607] ERROR: deadlock detected 2025-06-04 11:10:38.449 UTC [7607] DETAIL: Process 7607 waits for ShareLock on transaction 705610355; blocked by process 7646. #011Process 7646 waits for ShareLock on transaction 705610364; blocked by process 7607. #011Process 7607: SELECT * FROM UpdateInvalidChildCounts() #011Process 7646: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 11:10:38.449 UTC [7607] HINT: See server log for query details. 2025-06-04 11:10:38.449 UTC [7607] CONTEXT: while locking tuple (244469,55) in relation "resources" #011SQL statement "SELECT ARRAY(SELECT internalId #011 FROM Resources #011 WHERE internalId IN (SELECT DISTINCT id FROM InvalidChildCounts) #011 FOR UPDATE)" #011PL/pgSQL function updateinvalidchildcounts() line 8 at SQL statement 2025-06-04 11:10:38.449 UTC [7607] STATEMENT: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 11:11:14.112 UTC [27] LOG: checkpoint complete: wrote 3210 buffers (19.6%); 0 WAL file(s) added, 1 removed, 6 recycled; write=269.925 s, sync=0.040 s, total=270.004 s; sync files=113, longest=0.002 s, average=0.001 s; distance=119627 kB, estimate=254654 kB; lsn=C07/112A1E00, redo lsn=C07/9B91B80 2025-06-04 11:11:44.121 UTC [27] LOG: checkpoint starting: time 2025-06-04 11:13:03.666 UTC [7628] ERROR: deadlock detected 2025-06-04 11:13:03.666 UTC [7628] DETAIL: Process 7628 waits for AccessExclusiveLock on tuple (244662,57) of relation 16394 of database 13470; blocked by process 7634. #011Process 7634 waits for ShareLock on transaction 705620496; blocked by process 7643. #011Process 7643 waits for ShareLock on transaction 705620509; blocked by process 7623. #011Process 7623 waits for AccessExclusiveLock on tuple (244662,57) of relation 16394 of database 13470; blocked by process 7628. #011Process 7628: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7634: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7643: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7623: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 11:13:03.666 UTC [7628] HINT: See server log for query details. 2025-06-04 11:13:03.666 UTC [7628] CONTEXT: SQL statement "SELECT internalid FROM "resources" WHERE publicId = patient_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 14 at SQL statement 2025-06-04 11:13:03.666 UTC [7628] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 11:13:03.682 UTC [7634] ERROR: deadlock detected 2025-06-04 11:13:03.682 UTC [7634] DETAIL: Process 7634 waits for ShareLock on transaction 705620496; blocked by process 7643. #011Process 7643 waits for ShareLock on transaction 705620509; blocked by process 7623. #011Process 7623 waits for AccessExclusiveLock on tuple (244662,57) of relation 16394 of database 13470; blocked by process 7634. #011Process 7634: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7643: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7623: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 11:13:03.682 UTC [7634] HINT: See server log for query details. 2025-06-04 11:13:03.682 UTC [7634] CONTEXT: while locking tuple (244662,57) in relation "resources" #011SQL statement "SELECT internalid FROM "resources" WHERE publicId = patient_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 14 at SQL statement 2025-06-04 11:13:03.682 UTC [7634] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 11:13:03.683 UTC [7643] ERROR: deadlock detected 2025-06-04 11:13:03.683 UTC [7643] DETAIL: Process 7643 waits for ShareLock on transaction 705620509; blocked by process 7623. #011Process 7623 waits for ShareLock on transaction 705620496; blocked by process 7643. #011Process 7643: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7623: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 11:13:03.683 UTC [7643] HINT: See server log for query details. 2025-06-04 11:13:03.683 UTC [7643] CONTEXT: while locking tuple (244662,60) in relation "resources" #011SQL statement "SELECT internalid FROM "resources" WHERE publicId = series_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 30 at SQL statement 2025-06-04 11:13:03.683 UTC [7643] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 11:13:26.609 UTC [7598] ERROR: deadlock detected 2025-06-04 11:13:26.609 UTC [7598] DETAIL: Process 7598 waits for ShareLock on transaction 705631617; blocked by process 7604. #011Process 7604 waits for ShareLock on transaction 705631618; blocked by process 7598. #011Process 7598: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7604: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 11:13:26.609 UTC [7598] HINT: See server log for query details. 2025-06-04 11:13:26.609 UTC [7598] CONTEXT: while locking tuple (244880,14) in relation "resources" #011SQL statement "SELECT internalid FROM "resources" WHERE publicId = series_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 30 at SQL statement 2025-06-04 11:13:26.609 UTC [7598] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 11:13:29.649 UTC [7610] ERROR: deadlock detected 2025-06-04 11:13:29.649 UTC [7610] DETAIL: Process 7610 waits for ShareLock on transaction 705632575; blocked by process 7619. #011Process 7619 waits for ShareLock on transaction 705632578; blocked by process 7610. #011Process 7610: SELECT * FROM UpdateInvalidChildCounts() #011Process 7619: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 11:13:29.649 UTC [7610] HINT: See server log for query details. 2025-06-04 11:13:29.649 UTC [7610] CONTEXT: while locking tuple (244875,45) in relation "resources" #011SQL statement "SELECT ARRAY(SELECT internalId #011 FROM Resources #011 WHERE internalId IN (SELECT DISTINCT id FROM InvalidChildCounts) #011 FOR UPDATE)" #011PL/pgSQL function updateinvalidchildcounts() line 8 at SQL statement 2025-06-04 11:13:29.649 UTC [7610] STATEMENT: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 11:16:14.086 UTC [27] LOG: checkpoint complete: wrote 1865 buffers (11.4%); 0 WAL file(s) added, 2 removed, 6 recycled; write=269.902 s, sync=0.026 s, total=269.966 s; sync files=114, longest=0.002 s, average=0.001 s; distance=128983 kB, estimate=242087 kB; lsn=C07/1FD9E4F0, redo lsn=C07/11987B08 2025-06-04 11:16:44.107 UTC [27] LOG: checkpoint starting: time 2025-06-04 11:21:14.210 UTC [27] LOG: checkpoint complete: wrote 2008 buffers (12.3%); 0 WAL file(s) added, 0 removed, 14 recycled; write=269.967 s, sync=0.037 s, total=270.103 s; sync files=98, longest=0.005 s, average=0.001 s; distance=233635 kB, estimate=241242 kB; lsn=C07/2E5C6970, redo lsn=C07/1FDB0A30 2025-06-04 11:21:44.240 UTC [27] LOG: checkpoint starting: time 2025-06-04 11:26:14.097 UTC [27] LOG: checkpoint complete: wrote 1981 buffers (12.1%); 0 WAL file(s) added, 0 removed, 17 recycled; write=269.789 s, sync=0.023 s, total=269.858 s; sync files=108, longest=0.002 s, average=0.001 s; distance=266358 kB, estimate=266358 kB; lsn=C07/34792F90, redo lsn=C07/301CE3B0 2025-06-04 11:26:44.098 UTC [27] LOG: checkpoint starting: time 2025-06-04 11:28:05.353 UTC [7613] ERROR: deadlock detected 2025-06-04 11:28:05.353 UTC [7613] DETAIL: Process 7613 waits for ShareLock on transaction 705720627; blocked by process 7617. #011Process 7617 waits for ShareLock on transaction 705720620; blocked by process 7613. #011Process 7613: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7617: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 11:28:05.353 UTC [7613] HINT: See server log for query details. 2025-06-04 11:28:05.353 UTC [7613] CONTEXT: while locking tuple (246850,7) in relation "resources" #011SQL statement "SELECT internalid FROM "resources" WHERE publicId = series_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 30 at SQL statement 2025-06-04 11:28:05.353 UTC [7613] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 11:28:27.765 UTC [7645] ERROR: deadlock detected 2025-06-04 11:28:27.765 UTC [7645] DETAIL: Process 7645 waits for ShareLock on transaction 705729468; blocked by process 7627. #011Process 7627 waits for ShareLock on transaction 705729451; blocked by process 7645. #011Process 7645: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7627: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 11:28:27.765 UTC [7645] HINT: See server log for query details. 2025-06-04 11:28:27.765 UTC [7645] CONTEXT: while locking tuple (246960,108) in relation "resources" #011SQL statement "SELECT internalid FROM "resources" WHERE publicId = series_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 30 at SQL statement 2025-06-04 11:28:27.765 UTC [7645] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 11:31:14.111 UTC [27] LOG: checkpoint complete: wrote 2009 buffers (12.3%); 0 WAL file(s) added, 0 removed, 4 recycled; write=269.967 s, sync=0.024 s, total=270.013 s; sync files=112, longest=0.001 s, average=0.001 s; distance=71472 kB, estimate=246869 kB; lsn=C07/3FC2D4F8, redo lsn=C07/3479A450 2025-06-04 11:31:44.131 UTC [27] LOG: checkpoint starting: time 2025-06-04 11:36:14.158 UTC [27] LOG: checkpoint complete: wrote 903 buffers (5.5%); 0 WAL file(s) added, 0 removed, 11 recycled; write=269.952 s, sync=0.040 s, total=270.027 s; sync files=117, longest=0.004 s, average=0.001 s; distance=184938 kB, estimate=240676 kB; lsn=C07/53CFE498, redo lsn=C07/3FC34D00 2025-06-04 11:36:44.171 UTC [27] LOG: checkpoint starting: time 2025-06-04 11:38:03.120 UTC [7615] ERROR: deadlock detected 2025-06-04 11:38:03.120 UTC [7615] DETAIL: Process 7615 waits for AccessExclusiveLock on tuple (235362,65) of relation 16394 of database 13470; blocked by process 7613. #011Process 7613 waits for ShareLock on transaction 705808893; blocked by process 7616. #011Process 7616 waits for ShareLock on transaction 705808922; blocked by process 7636. #011Process 7636 waits for AccessExclusiveLock on tuple (235362,65) of relation 16394 of database 13470; blocked by process 7615. #011Process 7615: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7613: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7616: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7636: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 11:38:03.120 UTC [7615] HINT: See server log for query details. 2025-06-04 11:38:03.120 UTC [7615] CONTEXT: SQL statement "SELECT internalid FROM "resources" WHERE publicId = patient_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 14 at SQL statement 2025-06-04 11:38:03.120 UTC [7615] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 11:38:03.144 UTC [7635] ERROR: deadlock detected 2025-06-04 11:38:03.144 UTC [7635] DETAIL: Process 7635 waits for AccessExclusiveLock on tuple (235362,65) of relation 16394 of database 13470; blocked by process 7613. #011Process 7613 waits for ShareLock on transaction 705808893; blocked by process 7616. #011Process 7616 waits for ShareLock on transaction 705808922; blocked by process 7636. #011Process 7636 waits for AccessExclusiveLock on tuple (235362,65) of relation 16394 of database 13470; blocked by process 7635. #011Process 7635: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7613: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7616: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7636: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 11:38:03.144 UTC [7635] HINT: See server log for query details. 2025-06-04 11:38:03.144 UTC [7635] CONTEXT: SQL statement "SELECT internalid FROM "resources" WHERE publicId = patient_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 14 at SQL statement 2025-06-04 11:38:03.144 UTC [7635] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 11:38:03.146 UTC [7637] ERROR: deadlock detected 2025-06-04 11:38:03.146 UTC [7637] DETAIL: Process 7637 waits for AccessExclusiveLock on tuple (235362,65) of relation 16394 of database 13470; blocked by process 7613. #011Process 7613 waits for ShareLock on transaction 705808893; blocked by process 7616. #011Process 7616 waits for ShareLock on transaction 705808922; blocked by process 7636. #011Process 7636 waits for AccessExclusiveLock on tuple (235362,65) of relation 16394 of database 13470; blocked by process 7637. #011Process 7637: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7613: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7616: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7636: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 11:38:03.146 UTC [7637] HINT: See server log for query details. 2025-06-04 11:38:03.146 UTC [7637] CONTEXT: SQL statement "SELECT internalid FROM "resources" WHERE publicId = patient_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 14 at SQL statement 2025-06-04 11:38:03.146 UTC [7637] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 11:38:03.170 UTC [7636] ERROR: deadlock detected 2025-06-04 11:38:03.170 UTC [7636] DETAIL: Process 7636 waits for AccessExclusiveLock on tuple (235362,65) of relation 16394 of database 13470; blocked by process 7613. #011Process 7613 waits for ShareLock on transaction 705808893; blocked by process 7616. #011Process 7616 waits for ShareLock on transaction 705808922; blocked by process 7636. #011Process 7636: SELECT * FROM UpdateInvalidChildCounts() #011Process 7613: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7616: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 11:38:03.170 UTC [7636] HINT: See server log for query details. 2025-06-04 11:38:03.170 UTC [7636] CONTEXT: SQL statement "SELECT ARRAY(SELECT internalId #011 FROM Resources #011 WHERE internalId IN (SELECT DISTINCT id FROM InvalidChildCounts) #011 FOR UPDATE)" #011PL/pgSQL function updateinvalidchildcounts() line 8 at SQL statement 2025-06-04 11:38:03.170 UTC [7636] STATEMENT: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 11:38:07.201 UTC [7633] ERROR: deadlock detected 2025-06-04 11:38:07.201 UTC [7633] DETAIL: Process 7633 waits for ShareLock on transaction 705810097; blocked by process 7625. #011Process 7625 waits for ShareLock on transaction 705810088; blocked by process 7633. #011Process 7633: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7625: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 11:38:07.201 UTC [7633] HINT: See server log for query details. 2025-06-04 11:38:07.201 UTC [7633] CONTEXT: while locking tuple (250609,37) in relation "resources" #011SQL statement "SELECT internalid FROM "resources" WHERE publicId = series_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 30 at SQL statement 2025-06-04 11:38:07.201 UTC [7633] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 11:38:11.230 UTC [7629] ERROR: deadlock detected 2025-06-04 11:38:11.230 UTC [7629] DETAIL: Process 7629 waits for ShareLock on transaction 705811224; blocked by process 7600. #011Process 7600 waits for ShareLock on transaction 705811225; blocked by process 7629. #011Process 7629: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7600: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 11:38:11.230 UTC [7629] HINT: See server log for query details. 2025-06-04 11:38:11.230 UTC [7629] CONTEXT: while locking tuple (250647,28) in relation "resources" #011SQL statement "SELECT internalid FROM "resources" WHERE publicId = series_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 30 at SQL statement 2025-06-04 11:38:11.230 UTC [7629] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 11:41:14.129 UTC [27] LOG: checkpoint complete: wrote 820 buffers (5.0%); 0 WAL file(s) added, 0 removed, 20 recycled; write=269.879 s, sync=0.023 s, total=269.959 s; sync files=88, longest=0.003 s, average=0.001 s; distance=328527 kB, estimate=328527 kB; lsn=C07/5AA279A0, redo lsn=C07/53D08A38 2025-06-04 11:41:44.151 UTC [27] LOG: checkpoint starting: time 2025-06-04 11:46:14.138 UTC [27] LOG: checkpoint complete: wrote 1741 buffers (10.6%); 0 WAL file(s) added, 0 removed, 7 recycled; write=269.893 s, sync=0.068 s, total=269.988 s; sync files=115, longest=0.037 s, average=0.001 s; distance=111777 kB, estimate=306852 kB; lsn=C07/698F00E0, redo lsn=C07/5AA31040 2025-06-04 11:46:44.167 UTC [27] LOG: checkpoint starting: time 2025-06-04 11:51:14.116 UTC [27] LOG: checkpoint complete: wrote 1721 buffers (10.5%); 0 WAL file(s) added, 0 removed, 15 recycled; write=269.884 s, sync=0.019 s, total=269.949 s; sync files=79, longest=0.002 s, average=0.001 s; distance=244519 kB, estimate=300619 kB; lsn=C07/7216C910, redo lsn=C07/698FAE80 2025-06-04 11:51:44.129 UTC [27] LOG: checkpoint starting: time 2025-06-04 11:53:12.992 UTC [7640] ERROR: deadlock detected 2025-06-04 11:53:12.992 UTC [7640] DETAIL: Process 7640 waits for ShareLock on transaction 705894638; blocked by process 7647. #011Process 7647 waits for ShareLock on transaction 705894644; blocked by process 7640. #011Process 7640: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7647: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 11:53:12.992 UTC [7640] HINT: See server log for query details. 2025-06-04 11:53:12.992 UTC [7640] CONTEXT: while locking tuple (248437,79) in relation "resources" #011SQL statement "SELECT internalid FROM "resources" WHERE publicId = series_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 30 at SQL statement 2025-06-04 11:53:12.992 UTC [7640] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 11:53:13.033 UTC [7604] ERROR: deadlock detected 2025-06-04 11:53:13.033 UTC [7604] DETAIL: Process 7604 waits for ShareLock on transaction 705894638; blocked by process 7647. #011Process 7647 waits for ShareLock on transaction 705894658; blocked by process 7604. #011Process 7604: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7647: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 11:53:13.033 UTC [7604] HINT: See server log for query details. 2025-06-04 11:53:13.033 UTC [7604] CONTEXT: while locking tuple (248442,13) in relation "resources" #011SQL statement "SELECT internalid FROM "resources" WHERE publicId = series_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 30 at SQL statement 2025-06-04 11:53:13.033 UTC [7604] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 11:53:32.444 UTC [7640] ERROR: deadlock detected 2025-06-04 11:53:32.444 UTC [7640] DETAIL: Process 7640 waits for ShareLock on transaction 705902649; blocked by process 7627. #011Process 7627 waits for ShareLock on transaction 705902650; blocked by process 7640. #011Process 7640: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7627: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 11:53:32.444 UTC [7640] HINT: See server log for query details. 2025-06-04 11:53:32.444 UTC [7640] CONTEXT: while locking tuple (248561,89) in relation "resources" #011SQL statement "SELECT internalid FROM "resources" WHERE publicId = series_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 30 at SQL statement 2025-06-04 11:53:32.444 UTC [7640] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 11:56:14.131 UTC [27] LOG: checkpoint complete: wrote 2281 buffers (13.9%); 0 WAL file(s) added, 0 removed, 9 recycled; write=269.945 s, sync=0.029 s, total=270.002 s; sync files=112, longest=0.002 s, average=0.001 s; distance=139767 kB, estimate=284533 kB; lsn=C07/7A7A7B18, redo lsn=C07/72178D40 2025-06-04 11:56:44.146 UTC [27] LOG: checkpoint starting: time 2025-06-04 11:58:04.450 UTC [7620] ERROR: deadlock detected 2025-06-04 11:58:04.450 UTC [7620] DETAIL: Process 7620 waits for ShareLock on transaction 705915837; blocked by process 7631. #011Process 7631 waits for ShareLock on transaction 705915844; blocked by process 7620. #011Process 7620: SELECT * FROM UpdateInvalidChildCounts() #011Process 7631: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 11:58:04.450 UTC [7620] HINT: See server log for query details. 2025-06-04 11:58:04.450 UTC [7620] CONTEXT: while locking tuple (255888,29) in relation "resources" #011SQL statement "SELECT ARRAY(SELECT internalId #011 FROM Resources #011 WHERE internalId IN (SELECT DISTINCT id FROM InvalidChildCounts) #011 FOR UPDATE)" #011PL/pgSQL function updateinvalidchildcounts() line 8 at SQL statement 2025-06-04 11:58:04.450 UTC [7620] STATEMENT: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 11:58:06.467 UTC [7610] ERROR: deadlock detected 2025-06-04 11:58:06.467 UTC [7610] DETAIL: Process 7610 waits for ShareLock on transaction 705916490; blocked by process 7635. #011Process 7635 waits for ShareLock on transaction 705916489; blocked by process 7610. #011Process 7610: SELECT * FROM UpdateInvalidChildCounts() #011Process 7635: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 11:58:06.467 UTC [7610] HINT: See server log for query details. 2025-06-04 11:58:06.467 UTC [7610] CONTEXT: while locking tuple (255895,19) in relation "resources" #011SQL statement "SELECT ARRAY(SELECT internalId #011 FROM Resources #011 WHERE internalId IN (SELECT DISTINCT id FROM InvalidChildCounts) #011 FOR UPDATE)" #011PL/pgSQL function updateinvalidchildcounts() line 8 at SQL statement 2025-06-04 11:58:06.467 UTC [7610] STATEMENT: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 12:01:14.147 UTC [27] LOG: checkpoint complete: wrote 2309 buffers (14.1%); 0 WAL file(s) added, 0 removed, 8 recycled; write=269.943 s, sync=0.031 s, total=270.001 s; sync files=86, longest=0.003 s, average=0.001 s; distance=137434 kB, estimate=269823 kB; lsn=C07/82AEFB80, redo lsn=C07/7A7AF6A0 2025-06-04 12:01:44.171 UTC [27] LOG: checkpoint starting: time 2025-06-04 12:06:14.080 UTC [27] LOG: checkpoint complete: wrote 4881 buffers (29.8%); 0 WAL file(s) added, 0 removed, 8 recycled; write=269.859 s, sync=0.022 s, total=269.909 s; sync files=97, longest=0.002 s, average=0.001 s; distance=134456 kB, estimate=256287 kB; lsn=C07/82E7CD88, redo lsn=C07/82AFD980 2025-06-04 12:06:44.092 UTC [27] LOG: checkpoint starting: time 2025-06-04 12:07:28.753 UTC [27] LOG: checkpoint complete: wrote 346 buffers (2.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=44.631 s, sync=0.019 s, total=44.661 s; sync files=66, longest=0.003 s, average=0.001 s; distance=3623 kB, estimate=231020 kB; lsn=C07/82E956B0, redo lsn=C07/82E878E0 2025-06-04 12:08:06.047 UTC [7626] ERROR: deadlock detected 2025-06-04 12:08:06.047 UTC [7626] DETAIL: Process 7626 waits for AccessExclusiveLock on tuple (252832,5) of relation 16394 of database 13470; blocked by process 7613. #011Process 7613 waits for ShareLock on transaction 705948592; blocked by process 7645. #011Process 7645 waits for ShareLock on transaction 705948623; blocked by process 7599. #011Process 7599 waits for AccessExclusiveLock on tuple (252832,5) of relation 16394 of database 13470; blocked by process 7626. #011Process 7626: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7613: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7645: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7599: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 12:08:06.047 UTC [7626] HINT: See server log for query details. 2025-06-04 12:08:06.047 UTC [7626] CONTEXT: SQL statement "SELECT internalid FROM "resources" WHERE publicId = patient_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 14 at SQL statement 2025-06-04 12:08:06.047 UTC [7626] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 12:08:06.052 UTC [7609] ERROR: deadlock detected 2025-06-04 12:08:06.052 UTC [7609] DETAIL: Process 7609 waits for AccessExclusiveLock on tuple (252832,5) of relation 16394 of database 13470; blocked by process 7613. #011Process 7613 waits for ShareLock on transaction 705948592; blocked by process 7645. #011Process 7645 waits for ShareLock on transaction 705948623; blocked by process 7599. #011Process 7599 waits for AccessExclusiveLock on tuple (252832,5) of relation 16394 of database 13470; blocked by process 7609. #011Process 7609: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7613: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7645: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7599: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 12:08:06.052 UTC [7609] HINT: See server log for query details. 2025-06-04 12:08:06.052 UTC [7609] CONTEXT: SQL statement "SELECT internalid FROM "resources" WHERE publicId = patient_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 14 at SQL statement 2025-06-04 12:08:06.052 UTC [7609] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 12:08:06.056 UTC [7647] ERROR: deadlock detected 2025-06-04 12:08:06.056 UTC [7647] DETAIL: Process 7647 waits for AccessExclusiveLock on tuple (252832,5) of relation 16394 of database 13470; blocked by process 7613. #011Process 7613 waits for ShareLock on transaction 705948592; blocked by process 7645. #011Process 7645 waits for ShareLock on transaction 705948623; blocked by process 7599. #011Process 7599 waits for AccessExclusiveLock on tuple (252832,5) of relation 16394 of database 13470; blocked by process 7647. #011Process 7647: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7613: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7645: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7599: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 12:08:06.056 UTC [7647] HINT: See server log for query details. 2025-06-04 12:08:06.056 UTC [7647] CONTEXT: SQL statement "SELECT internalid FROM "resources" WHERE publicId = patient_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 14 at SQL statement 2025-06-04 12:08:06.056 UTC [7647] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 12:08:06.058 UTC [7602] ERROR: deadlock detected 2025-06-04 12:08:06.058 UTC [7602] DETAIL: Process 7602 waits for AccessExclusiveLock on tuple (252832,5) of relation 16394 of database 13470; blocked by process 7613. #011Process 7613 waits for ShareLock on transaction 705948592; blocked by process 7645. #011Process 7645 waits for ShareLock on transaction 705948623; blocked by process 7599. #011Process 7599 waits for AccessExclusiveLock on tuple (252832,5) of relation 16394 of database 13470; blocked by process 7602. #011Process 7602: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7613: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7645: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7599: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 12:08:06.058 UTC [7602] HINT: See server log for query details. 2025-06-04 12:08:06.058 UTC [7602] CONTEXT: SQL statement "SELECT internalid FROM "resources" WHERE publicId = patient_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 14 at SQL statement 2025-06-04 12:08:06.058 UTC [7602] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 12:08:06.472 UTC [7599] ERROR: deadlock detected 2025-06-04 12:08:06.472 UTC [7599] DETAIL: Process 7599 waits for AccessExclusiveLock on tuple (252832,5) of relation 16394 of database 13470; blocked by process 7613. #011Process 7613 waits for ShareLock on transaction 705948592; blocked by process 7645. #011Process 7645 waits for ShareLock on transaction 705948623; blocked by process 7599. #011Process 7599: SELECT * FROM UpdateInvalidChildCounts() #011Process 7613: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7645: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 12:08:06.472 UTC [7599] HINT: See server log for query details. 2025-06-04 12:08:06.472 UTC [7599] CONTEXT: SQL statement "SELECT ARRAY(SELECT internalId #011 FROM Resources #011 WHERE internalId IN (SELECT DISTINCT id FROM InvalidChildCounts) #011 FOR UPDATE)" #011PL/pgSQL function updateinvalidchildcounts() line 8 at SQL statement 2025-06-04 12:08:06.472 UTC [7599] STATEMENT: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 12:11:45.012 UTC [27] LOG: checkpoint starting: time 2025-06-04 12:13:03.393 UTC [7609] ERROR: deadlock detected 2025-06-04 12:13:03.393 UTC [7609] DETAIL: Process 7609 waits for ShareLock on transaction 705987654; blocked by process 7602. #011Process 7602 waits for ShareLock on transaction 705987653; blocked by process 7609. #011Process 7609: SELECT * FROM UpdateInvalidChildCounts() #011Process 7602: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 12:13:03.393 UTC [7609] HINT: See server log for query details. 2025-06-04 12:13:03.393 UTC [7609] CONTEXT: while locking tuple (253396,68) in relation "resources" #011SQL statement "SELECT ARRAY(SELECT internalId #011 FROM Resources #011 WHERE internalId IN (SELECT DISTINCT id FROM InvalidChildCounts) #011 FOR UPDATE)" #011PL/pgSQL function updateinvalidchildcounts() line 8 at SQL statement 2025-06-04 12:13:03.393 UTC [7609] STATEMENT: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 12:13:05.415 UTC [7624] ERROR: deadlock detected 2025-06-04 12:13:05.415 UTC [7624] DETAIL: Process 7624 waits for ShareLock on transaction 705988102; blocked by process 7604. #011Process 7604 waits for ShareLock on transaction 705988101; blocked by process 7624. #011Process 7624: SELECT * FROM UpdateInvalidChildCounts() #011Process 7604: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 12:13:05.415 UTC [7624] HINT: See server log for query details. 2025-06-04 12:13:05.415 UTC [7624] CONTEXT: while locking tuple (253396,68) in relation "resources" #011SQL statement "SELECT ARRAY(SELECT internalId #011 FROM Resources #011 WHERE internalId IN (SELECT DISTINCT id FROM InvalidChildCounts) #011 FOR UPDATE)" #011PL/pgSQL function updateinvalidchildcounts() line 8 at SQL statement 2025-06-04 12:13:05.415 UTC [7624] STATEMENT: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 12:16:15.078 UTC [27] LOG: checkpoint complete: wrote 1003 buffers (6.1%); 0 WAL file(s) added, 2 removed, 10 recycled; write=269.993 s, sync=0.031 s, total=270.067 s; sync files=114, longest=0.003 s, average=0.001 s; distance=192892 kB, estimate=227208 kB; lsn=C07/9EEEF4D8, redo lsn=C07/8EAE6C40 2025-06-04 12:16:45.106 UTC [27] LOG: checkpoint starting: time 2025-06-04 12:21:15.134 UTC [27] LOG: checkpoint complete: wrote 2196 buffers (13.4%); 0 WAL file(s) added, 0 removed, 18 recycled; write=269.952 s, sync=0.022 s, total=270.029 s; sync files=103, longest=0.001 s, average=0.001 s; distance=289140 kB, estimate=289140 kB; lsn=C07/A4382328, redo lsn=C07/A0543CC8 2025-06-04 12:21:45.163 UTC [27] LOG: checkpoint starting: time 2025-06-04 12:21:49.496 UTC [7616] ERROR: deadlock detected 2025-06-04 12:21:49.496 UTC [7616] DETAIL: Process 7616 waits for ShareLock on transaction 706064817; blocked by process 7642. #011Process 7642 waits for ShareLock on transaction 706064847; blocked by process 7616. #011Process 7616: SELECT * FROM UpdateInvalidChildCounts() #011Process 7642: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 12:21:49.496 UTC [7616] HINT: See server log for query details. 2025-06-04 12:21:49.496 UTC [7616] CONTEXT: while locking tuple (252009,137) in relation "resources" #011SQL statement "SELECT ARRAY(SELECT internalId #011 FROM Resources #011 WHERE internalId IN (SELECT DISTINCT id FROM InvalidChildCounts) #011 FOR UPDATE)" #011PL/pgSQL function updateinvalidchildcounts() line 8 at SQL statement 2025-06-04 12:21:49.496 UTC [7616] STATEMENT: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 12:26:15.119 UTC [27] LOG: checkpoint complete: wrote 1269 buffers (7.7%); 0 WAL file(s) added, 0 removed, 6 recycled; write=269.905 s, sync=0.028 s, total=269.956 s; sync files=125, longest=0.002 s, average=0.001 s; distance=97392 kB, estimate=269965 kB; lsn=C07/AD928930, redo lsn=C07/A645FF78 2025-06-04 12:26:45.126 UTC [27] LOG: checkpoint starting: time 2025-06-04 12:27:47.610 UTC [7638] ERROR: deadlock detected 2025-06-04 12:27:47.610 UTC [7638] DETAIL: Process 7638 waits for ShareLock on transaction 706091751; blocked by process 7609. #011Process 7609 waits for ShareLock on transaction 706091754; blocked by process 7638. #011Process 7638: SELECT * FROM UpdateInvalidChildCounts() #011Process 7609: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 12:27:47.610 UTC [7638] HINT: See server log for query details. 2025-06-04 12:27:47.610 UTC [7638] CONTEXT: while locking tuple (255512,53) in relation "resources" #011SQL statement "SELECT ARRAY(SELECT internalId #011 FROM Resources #011 WHERE internalId IN (SELECT DISTINCT id FROM InvalidChildCounts) #011 FOR UPDATE)" #011PL/pgSQL function updateinvalidchildcounts() line 8 at SQL statement 2025-06-04 12:27:47.610 UTC [7638] STATEMENT: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 12:28:02.938 UTC [7628] ERROR: deadlock detected 2025-06-04 12:28:02.938 UTC [7628] DETAIL: Process 7628 waits for AccessExclusiveLock on tuple (255605,26) of relation 16394 of database 13470; blocked by process 7604. #011Process 7604 waits for ShareLock on transaction 706094654; blocked by process 7617. #011Process 7617 waits for ShareLock on transaction 706094661; blocked by process 7612. #011Process 7612 waits for AccessExclusiveLock on tuple (255605,26) of relation 16394 of database 13470; blocked by process 7628. #011Process 7628: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7604: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7617: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7612: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 12:28:02.938 UTC [7628] HINT: See server log for query details. 2025-06-04 12:28:02.938 UTC [7628] CONTEXT: SQL statement "SELECT internalid FROM "resources" WHERE publicId = patient_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 14 at SQL statement 2025-06-04 12:28:02.938 UTC [7628] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 12:28:02.940 UTC [7647] ERROR: deadlock detected 2025-06-04 12:28:02.940 UTC [7647] DETAIL: Process 7647 waits for AccessExclusiveLock on tuple (255605,26) of relation 16394 of database 13470; blocked by process 7604. #011Process 7604 waits for ShareLock on transaction 706094654; blocked by process 7617. #011Process 7617 waits for ShareLock on transaction 706094661; blocked by process 7612. #011Process 7612 waits for AccessExclusiveLock on tuple (255605,26) of relation 16394 of database 13470; blocked by process 7647. #011Process 7647: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7604: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7617: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7612: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 12:28:02.940 UTC [7647] HINT: See server log for query details. 2025-06-04 12:28:02.940 UTC [7647] CONTEXT: SQL statement "SELECT internalid FROM "resources" WHERE publicId = patient_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 14 at SQL statement 2025-06-04 12:28:02.940 UTC [7647] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 12:28:02.954 UTC [7612] ERROR: deadlock detected 2025-06-04 12:28:02.954 UTC [7612] DETAIL: Process 7612 waits for AccessExclusiveLock on tuple (255605,26) of relation 16394 of database 13470; blocked by process 7604. #011Process 7604 waits for ShareLock on transaction 706094654; blocked by process 7617. #011Process 7617 waits for ShareLock on transaction 706094661; blocked by process 7612. #011Process 7612: SELECT * FROM UpdateInvalidChildCounts() #011Process 7604: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7617: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 12:28:02.954 UTC [7612] HINT: See server log for query details. 2025-06-04 12:28:02.954 UTC [7612] CONTEXT: SQL statement "SELECT ARRAY(SELECT internalId #011 FROM Resources #011 WHERE internalId IN (SELECT DISTINCT id FROM InvalidChildCounts) #011 FOR UPDATE)" #011PL/pgSQL function updateinvalidchildcounts() line 8 at SQL statement 2025-06-04 12:28:02.954 UTC [7612] STATEMENT: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 12:31:15.047 UTC [27] LOG: checkpoint complete: wrote 819 buffers (5.0%); 0 WAL file(s) added, 0 removed, 7 recycled; write=269.872 s, sync=0.021 s, total=269.921 s; sync files=106, longest=0.001 s, average=0.001 s; distance=119611 kB, estimate=254929 kB; lsn=C07/B5F042C0, redo lsn=C07/AD92EC98 2025-06-04 12:31:45.077 UTC [27] LOG: checkpoint starting: time 2025-06-04 12:36:15.139 UTC [27] LOG: checkpoint complete: wrote 2068 buffers (12.6%); 0 WAL file(s) added, 0 removed, 8 recycled; write=270.001 s, sync=0.030 s, total=270.062 s; sync files=110, longest=0.003 s, average=0.001 s; distance=137074 kB, estimate=243144 kB; lsn=C07/BC09CBC0, redo lsn=C07/B5F0B5D8 2025-06-04 12:36:45.148 UTC [27] LOG: checkpoint starting: time 2025-06-04 12:37:24.501 UTC [7627] ERROR: deadlock detected 2025-06-04 12:37:24.501 UTC [7627] DETAIL: Process 7627 waits for ShareLock on transaction 706147706; blocked by process 7621. #011Process 7621 waits for ShareLock on transaction 706147707; blocked by process 7627. #011Process 7627: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7621: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 12:37:24.501 UTC [7627] HINT: See server log for query details. 2025-06-04 12:37:24.501 UTC [7627] CONTEXT: while locking tuple (258074,72) in relation "resources" #011SQL statement "SELECT internalid FROM "resources" WHERE publicId = series_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 30 at SQL statement 2025-06-04 12:37:24.501 UTC [7627] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 12:37:34.647 UTC [7602] ERROR: deadlock detected 2025-06-04 12:37:34.647 UTC [7602] DETAIL: Process 7602 waits for ShareLock on transaction 706151911; blocked by process 7646. #011Process 7646 waits for ShareLock on transaction 706151919; blocked by process 7602. #011Process 7602: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7646: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 12:37:34.647 UTC [7602] HINT: See server log for query details. 2025-06-04 12:37:34.647 UTC [7602] CONTEXT: while locking tuple (258226,32) in relation "resources" #011SQL statement "SELECT internalid FROM "resources" WHERE publicId = series_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 30 at SQL statement 2025-06-04 12:37:34.647 UTC [7602] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 12:37:35.648 UTC [7643] ERROR: deadlock detected 2025-06-04 12:37:35.648 UTC [7643] DETAIL: Process 7643 waits for ShareLock on transaction 706151911; blocked by process 7646. #011Process 7646 waits for ShareLock on transaction 706151948; blocked by process 7643. #011Process 7643: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7646: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 12:37:35.648 UTC [7643] HINT: See server log for query details. 2025-06-04 12:37:35.648 UTC [7643] CONTEXT: while locking tuple (258226,32) in relation "resources" #011SQL statement "SELECT internalid FROM "resources" WHERE publicId = series_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 30 at SQL statement 2025-06-04 12:37:35.648 UTC [7643] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 12:37:36.649 UTC [7613] ERROR: deadlock detected 2025-06-04 12:37:36.649 UTC [7613] DETAIL: Process 7613 waits for ShareLock on transaction 706151911; blocked by process 7646. #011Process 7646 waits for ShareLock on transaction 706151954; blocked by process 7613. #011Process 7613: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7646: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 12:37:36.649 UTC [7613] HINT: See server log for query details. 2025-06-04 12:37:36.649 UTC [7613] CONTEXT: while locking tuple (258226,32) in relation "resources" #011SQL statement "SELECT internalid FROM "resources" WHERE publicId = series_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 30 at SQL statement 2025-06-04 12:37:36.649 UTC [7613] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 12:41:15.113 UTC [27] LOG: checkpoint complete: wrote 531 buffers (3.2%); 0 WAL file(s) added, 0 removed, 7 recycled; write=269.912 s, sync=0.022 s, total=269.965 s; sync files=104, longest=0.001 s, average=0.001 s; distance=100049 kB, estimate=228834 kB; lsn=C07/C75D49C0, redo lsn=C07/BC0BFD40 2025-06-04 12:41:45.135 UTC [27] LOG: checkpoint starting: time 2025-06-04 12:46:15.195 UTC [27] LOG: checkpoint complete: wrote 2418 buffers (14.8%); 0 WAL file(s) added, 0 removed, 11 recycled; write=269.948 s, sync=0.065 s, total=270.060 s; sync files=100, longest=0.004 s, average=0.001 s; distance=185458 kB, estimate=224497 kB; lsn=C07/CC0A9F08, redo lsn=C07/C75DC5D8 2025-06-04 12:46:45.212 UTC [27] LOG: checkpoint starting: time 2025-06-04 12:48:04.094 UTC [7632] ERROR: deadlock detected 2025-06-04 12:48:04.094 UTC [7632] DETAIL: Process 7632 waits for ShareLock on transaction 706186734; blocked by process 7628. #011Process 7628 waits for ShareLock on transaction 706186738; blocked by process 7632. #011Process 7632: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7628: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 12:48:04.094 UTC [7632] HINT: See server log for query details. 2025-06-04 12:48:04.094 UTC [7632] CONTEXT: while locking tuple (259140,29) in relation "resources" #011SQL statement "SELECT internalid FROM "resources" WHERE publicId = study_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 22 at SQL statement 2025-06-04 12:48:04.094 UTC [7632] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 12:48:04.536 UTC [7609] ERROR: deadlock detected 2025-06-04 12:48:04.536 UTC [7609] DETAIL: Process 7609 waits for ShareLock on transaction 706186734; blocked by process 7628. #011Process 7628 waits for AccessExclusiveLock on tuple (259129,37) of relation 16394 of database 13470; blocked by process 7619. #011Process 7619 waits for ShareLock on transaction 706186768; blocked by process 7609. #011Process 7609: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7628: SELECT * FROM UpdateInvalidChildCounts() #011Process 7619: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 12:48:04.536 UTC [7609] HINT: See server log for query details. 2025-06-04 12:48:04.536 UTC [7609] CONTEXT: while locking tuple (259129,40) in relation "resources" #011SQL statement "SELECT internalid FROM "resources" WHERE publicId = study_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 22 at SQL statement 2025-06-04 12:48:04.536 UTC [7609] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 12:48:05.537 UTC [7628] ERROR: deadlock detected 2025-06-04 12:48:05.537 UTC [7628] DETAIL: Process 7628 waits for ShareLock on transaction 706186771; blocked by process 7619. #011Process 7619 waits for ShareLock on transaction 706186734; blocked by process 7628. #011Process 7628: SELECT * FROM UpdateInvalidChildCounts() #011Process 7619: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 12:48:05.537 UTC [7628] HINT: See server log for query details. 2025-06-04 12:48:05.537 UTC [7628] CONTEXT: while locking tuple (259129,37) in relation "resources" #011SQL statement "SELECT ARRAY(SELECT internalId #011 FROM Resources #011 WHERE internalId IN (SELECT DISTINCT id FROM InvalidChildCounts) #011 FOR UPDATE)" #011PL/pgSQL function updateinvalidchildcounts() line 8 at SQL statement 2025-06-04 12:48:05.537 UTC [7628] STATEMENT: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 12:48:07.551 UTC [7641] ERROR: deadlock detected 2025-06-04 12:48:07.551 UTC [7641] DETAIL: Process 7641 waits for ShareLock on transaction 706187123; blocked by process 7631. #011Process 7631 waits for ShareLock on transaction 706187121; blocked by process 7641. #011Process 7641: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7631: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 12:48:07.551 UTC [7641] HINT: See server log for query details. 2025-06-04 12:48:07.551 UTC [7641] CONTEXT: while locking tuple (259140,29) in relation "resources" #011SQL statement "SELECT internalid FROM "resources" WHERE publicId = study_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 22 at SQL statement 2025-06-04 12:48:07.551 UTC [7641] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 12:48:23.722 UTC [7600] ERROR: deadlock detected 2025-06-04 12:48:23.722 UTC [7600] DETAIL: Process 7600 waits for ShareLock on transaction 706190430; blocked by process 7632. #011Process 7632 waits for ShareLock on transaction 706190433; blocked by process 7600. #011Process 7600: SELECT * FROM UpdateInvalidChildCounts() #011Process 7632: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 12:48:23.722 UTC [7600] HINT: See server log for query details. 2025-06-04 12:48:23.722 UTC [7600] CONTEXT: while locking tuple (259164,72) in relation "resources" #011SQL statement "SELECT ARRAY(SELECT internalId #011 FROM Resources #011 WHERE internalId IN (SELECT DISTINCT id FROM InvalidChildCounts) #011 FOR UPDATE)" #011PL/pgSQL function updateinvalidchildcounts() line 8 at SQL statement 2025-06-04 12:48:23.722 UTC [7600] STATEMENT: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 12:51:15.074 UTC [27] LOG: checkpoint complete: wrote 4301 buffers (26.3%); 0 WAL file(s) added, 2 removed, 3 recycled; write=269.803 s, sync=0.024 s, total=269.862 s; sync files=110, longest=0.002 s, average=0.001 s; distance=89678 kB, estimate=211015 kB; lsn=C07/D07F9B40, redo lsn=C07/CCD70050 2025-06-04 12:51:45.105 UTC [27] LOG: checkpoint starting: time 2025-06-04 12:53:05.269 UTC [7598] ERROR: deadlock detected 2025-06-04 12:53:05.269 UTC [7598] DETAIL: Process 7598 waits for ShareLock on transaction 706199120; blocked by process 7626. #011Process 7626 waits for ShareLock on transaction 706199122; blocked by process 7598. #011Process 7598: SELECT * FROM UpdateInvalidChildCounts() #011Process 7626: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 12:53:05.269 UTC [7598] HINT: See server log for query details. 2025-06-04 12:53:05.269 UTC [7598] CONTEXT: while locking tuple (259277,100) in relation "resources" #011SQL statement "SELECT ARRAY(SELECT internalId #011 FROM Resources #011 WHERE internalId IN (SELECT DISTINCT id FROM InvalidChildCounts) #011 FOR UPDATE)" #011PL/pgSQL function updateinvalidchildcounts() line 8 at SQL statement 2025-06-04 12:53:05.269 UTC [7598] STATEMENT: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 12:56:15.077 UTC [27] LOG: checkpoint complete: wrote 3044 buffers (18.6%); 0 WAL file(s) added, 2 removed, 2 recycled; write=269.904 s, sync=0.030 s, total=269.972 s; sync files=92, longest=0.003 s, average=0.001 s; distance=59971 kB, estimate=195911 kB; lsn=C07/D19E15C8, redo lsn=C07/D0800E08 2025-06-04 12:56:45.107 UTC [27] LOG: checkpoint starting: time 2025-06-04 13:00:08.868 UTC [27] LOG: checkpoint complete: wrote 944 buffers (5.8%); 0 WAL file(s) added, 1 removed, 0 recycled; write=203.713 s, sync=0.027 s, total=203.761 s; sync files=98, longest=0.003 s, average=0.001 s; distance=20829 kB, estimate=178402 kB; lsn=C07/D7789238, redo lsn=C07/D1C58278 2025-06-04 13:01:45.958 UTC [27] LOG: checkpoint starting: time 2025-06-04 13:06:15.103 UTC [27] LOG: checkpoint complete: wrote 2513 buffers (15.3%); 0 WAL file(s) added, 2 removed, 4 recycled; write=269.076 s, sync=0.032 s, total=269.146 s; sync files=88, longest=0.004 s, average=0.001 s; distance=93510 kB, estimate=169913 kB; lsn=C07/D8F27900, redo lsn=C07/D77A9B38 2025-06-04 13:06:45.131 UTC [27] LOG: checkpoint starting: time 2025-06-04 13:08:05.091 UTC [7626] ERROR: deadlock detected 2025-06-04 13:08:05.091 UTC [7626] DETAIL: Process 7626 waits for ShareLock on transaction 706237007; blocked by process 7624. #011Process 7624 waits for ShareLock on transaction 706237010; blocked by process 7626. #011Process 7626: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7624: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 13:08:05.091 UTC [7626] HINT: See server log for query details. 2025-06-04 13:08:05.091 UTC [7626] CONTEXT: while locking tuple (256618,11) in relation "resources" #011SQL statement "SELECT internalid FROM "resources" WHERE publicId = series_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 30 at SQL statement 2025-06-04 13:08:05.091 UTC [7626] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 13:11:15.130 UTC [27] LOG: checkpoint complete: wrote 2861 buffers (17.5%); 0 WAL file(s) added, 2 removed, 2 recycled; write=269.944 s, sync=0.026 s, total=269.999 s; sync files=103, longest=0.003 s, average=0.001 s; distance=60464 kB, estimate=158968 kB; lsn=C07/E24A80B0, redo lsn=C07/DB2B5DF8 2025-06-04 13:11:45.161 UTC [27] LOG: checkpoint starting: time 2025-06-04 13:13:03.479 UTC [7635] ERROR: deadlock detected 2025-06-04 13:13:03.479 UTC [7635] DETAIL: Process 7635 waits for AccessExclusiveLock on tuple (528847,1) of relation 16394 of database 13470; blocked by process 7605. #011Process 7605 waits for ShareLock on transaction 706251059; blocked by process 7646. #011Process 7646 waits for ShareLock on transaction 706251069; blocked by process 7617. #011Process 7617 waits for AccessExclusiveLock on tuple (528847,1) of relation 16394 of database 13470; blocked by process 7635. #011Process 7635: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7605: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7646: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7617: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 13:13:03.479 UTC [7635] HINT: See server log for query details. 2025-06-04 13:13:03.479 UTC [7635] CONTEXT: SQL statement "SELECT internalid FROM "resources" WHERE publicId = patient_public_id FOR UPDATE" #011PL/pgSQL function createinstance(text,text,text,text) line 14 at SQL statement 2025-06-04 13:13:03.479 UTC [7635] STATEMENT: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 13:13:03.491 UTC [7617] ERROR: deadlock detected 2025-06-04 13:13:03.491 UTC [7617] DETAIL: Process 7617 waits for AccessExclusiveLock on tuple (528847,1) of relation 16394 of database 13470; blocked by process 7605. #011Process 7605 waits for ShareLock on transaction 706251059; blocked by process 7646. #011Process 7646 waits for ShareLock on transaction 706251069; blocked by process 7617. #011Process 7617: SELECT * FROM UpdateInvalidChildCounts() #011Process 7605: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7646: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 13:13:03.491 UTC [7617] HINT: See server log for query details. 2025-06-04 13:13:03.491 UTC [7617] CONTEXT: SQL statement "SELECT ARRAY(SELECT internalId #011 FROM Resources #011 WHERE internalId IN (SELECT DISTINCT id FROM InvalidChildCounts) #011 FOR UPDATE)" #011PL/pgSQL function updateinvalidchildcounts() line 8 at SQL statement 2025-06-04 13:13:03.491 UTC [7617] STATEMENT: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 13:13:05.500 UTC [7608] ERROR: deadlock detected 2025-06-04 13:13:05.500 UTC [7608] DETAIL: Process 7608 waits for ShareLock on transaction 706251681; blocked by process 7610. #011Process 7610 waits for ShareLock on transaction 706251684; blocked by process 7608. #011Process 7608: SELECT * FROM UpdateInvalidChildCounts() #011Process 7610: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 13:13:05.500 UTC [7608] HINT: See server log for query details. 2025-06-04 13:13:05.500 UTC [7608] CONTEXT: while locking tuple (528847,1) in relation "resources" #011SQL statement "SELECT ARRAY(SELECT internalId #011 FROM Resources #011 WHERE internalId IN (SELECT DISTINCT id FROM InvalidChildCounts) #011 FOR UPDATE)" #011PL/pgSQL function updateinvalidchildcounts() line 8 at SQL statement 2025-06-04 13:13:05.500 UTC [7608] STATEMENT: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 13:13:07.515 UTC [7623] ERROR: deadlock detected 2025-06-04 13:13:07.515 UTC [7623] DETAIL: Process 7623 waits for AccessExclusiveLock on tuple (528847,1) of relation 16394 of database 13470; blocked by process 7616. #011Process 7616 waits for ShareLock on transaction 706252362; blocked by process 7606. #011Process 7606 waits for ShareLock on transaction 706252369; blocked by process 7623. #011Process 7623: SELECT * FROM UpdateInvalidChildCounts() #011Process 7616: SELECT * FROM CreateInstance($1, $2, $3, $4) #011Process 7606: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 13:13:07.515 UTC [7623] HINT: See server log for query details. 2025-06-04 13:13:07.515 UTC [7623] CONTEXT: SQL statement "SELECT ARRAY(SELECT internalId #011 FROM Resources #011 WHERE internalId IN (SELECT DISTINCT id FROM InvalidChildCounts) #011 FOR UPDATE)" #011PL/pgSQL function updateinvalidchildcounts() line 8 at SQL statement 2025-06-04 13:13:07.515 UTC [7623] STATEMENT: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 13:16:15.066 UTC [27] LOG: checkpoint complete: wrote 2321 buffers (14.2%); 0 WAL file(s) added, 0 removed, 7 recycled; write=269.860 s, sync=0.019 s, total=269.906 s; sync files=84, longest=0.003 s, average=0.001 s; distance=116697 kB, estimate=154741 kB; lsn=C07/E4BFBB18, redo lsn=C07/E24AC2D8 2025-06-04 13:16:45.067 UTC [27] LOG: checkpoint starting: time 2025-06-04 13:21:15.059 UTC [27] LOG: checkpoint complete: wrote 2746 buffers (16.8%); 0 WAL file(s) added, 1 removed, 1 recycled; write=269.951 s, sync=0.020 s, total=269.993 s; sync files=92, longest=0.003 s, average=0.001 s; distance=40270 kB, estimate=143294 kB; lsn=C07/E8E51788, redo lsn=C07/E4BFFC78 2025-06-04 13:21:45.067 UTC [27] LOG: checkpoint starting: time 2025-06-04 13:26:15.086 UTC [27] LOG: checkpoint complete: wrote 3092 buffers (18.9%); 0 WAL file(s) added, 1 removed, 3 recycled; write=269.977 s, sync=0.019 s, total=270.020 s; sync files=88, longest=0.002 s, average=0.001 s; distance=67926 kB, estimate=135757 kB; lsn=C07/EC05EBB0, redo lsn=C07/E8E55770 2025-06-04 13:26:45.116 UTC [27] LOG: checkpoint starting: time 2025-06-04 13:31:15.096 UTC [27] LOG: checkpoint complete: wrote 4086 buffers (24.9%); 0 WAL file(s) added, 2 removed, 2 recycled; write=269.927 s, sync=0.021 s, total=269.980 s; sync files=86, longest=0.003 s, average=0.001 s; distance=51253 kB, estimate=127307 kB; lsn=C07/EC686F40, redo lsn=C07/EC062BF0 2025-06-04 13:31:45.127 UTC [27] LOG: checkpoint starting: time 2025-06-04 13:33:06.932 UTC [27] LOG: checkpoint complete: wrote 792 buffers (4.8%); 0 WAL file(s) added, 0 removed, 0 recycled; write=81.776 s, sync=0.017 s, total=81.805 s; sync files=76, longest=0.003 s, average=0.001 s; distance=6401 kB, estimate=115216 kB; lsn=C07/EC74D418, redo lsn=C07/EC6A3320 2025-06-04 13:36:46.028 UTC [27] LOG: checkpoint starting: time 2025-06-04 13:41:16.051 UTC [27] LOG: checkpoint complete: wrote 4468 buffers (27.3%); 0 WAL file(s) added, 2 removed, 2 recycled; write=269.972 s, sync=0.025 s, total=270.023 s; sync files=110, longest=0.002 s, average=0.001 s; distance=71001 kB, estimate=110795 kB; lsn=C07/F2617368, redo lsn=C07/F0BF99C8 2025-06-04 13:41:46.067 UTC [27] LOG: checkpoint starting: time 2025-06-04 13:43:03.252 UTC [7611] ERROR: deadlock detected 2025-06-04 13:43:03.252 UTC [7611] DETAIL: Process 7611 waits for ShareLock on transaction 706303795; blocked by process 7604. #011Process 7604 waits for ShareLock on transaction 706303798; blocked by process 7611. #011Process 7611: SELECT * FROM UpdateInvalidChildCounts() #011Process 7604: SELECT * FROM CreateInstance($1, $2, $3, $4) 2025-06-04 13:43:03.252 UTC [7611] HINT: See server log for query details. 2025-06-04 13:43:03.252 UTC [7611] CONTEXT: while locking tuple (261876,45) in relation "resources" #011SQL statement "SELECT ARRAY(SELECT internalId #011 FROM Resources #011 WHERE internalId IN (SELECT DISTINCT id FROM InvalidChildCounts) #011 FOR UPDATE)" #011PL/pgSQL function updateinvalidchildcounts() line 8 at SQL statement 2025-06-04 13:43:03.252 UTC [7611] STATEMENT: SELECT * FROM UpdateInvalidChildCounts() 2025-06-04 13:44:55.857 UTC [27] LOG: checkpoint complete: wrote 1396 buffers (8.5%); 0 WAL file(s) added, 1 removed, 1 recycled; write=189.746 s, sync=0.026 s, total=189.791 s; sync files=95, longest=0.004 s, average=0.001 s; distance=26762 kB, estimate=102391 kB; lsn=C07/F48D96A8, redo lsn=C07/F261C1F0