2026-03-18 05:39:59.085 CET [3248] LOG: checkpoint starting: time 2026-03-18 05:39:59.500 CET [3248] LOG: checkpoint complete: wrote 4 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.320 s, sync=0.055 s, total=0.416 s; sync files=4, longest=0.037 s, average=0.014 s; distance=21 kB, estimate=21 kB; lsn=19/6B922310, redo lsn=19/6B9204C0 2026-03-18 05:44:59.502 CET [3248] LOG: checkpoint starting: time 2026-03-18 05:45:00.101 CET [3248] LOG: checkpoint complete: wrote 6 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.541 s, sync=0.024 s, total=0.599 s; sync files=5, longest=0.007 s, average=0.005 s; distance=21 kB, estimate=21 kB; lsn=19/6B925BA0, redo lsn=19/6B925B48 2026-03-18 05:49:59.097 CET [3248] LOG: checkpoint starting: time 2026-03-18 05:49:59.932 CET [3248] LOG: checkpoint complete: wrote 8 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.769 s, sync=0.021 s, total=0.835 s; sync files=5, longest=0.006 s, average=0.005 s; distance=34 kB, estimate=34 kB; lsn=19/6B930110, redo lsn=19/6B92E558 2026-03-18 05:54:59.934 CET [3248] LOG: checkpoint starting: time 2026-03-18 05:55:01.420 CET [3248] LOG: checkpoint complete: wrote 14 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.418 s, sync=0.025 s, total=1.487 s; sync files=5, longest=0.008 s, average=0.005 s; distance=65 kB, estimate=65 kB; lsn=19/6B943EA0, redo lsn=19/6B93EB00 2026-03-18 05:59:59.411 CET [3248] LOG: checkpoint starting: time 2026-03-18 06:00:00.246 CET [3248] LOG: checkpoint complete: wrote 8 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.767 s, sync=0.025 s, total=0.836 s; sync files=5, longest=0.006 s, average=0.005 s; distance=48 kB, estimate=63 kB; lsn=19/6B94AEE8, redo lsn=19/6B94AE90 2026-03-18 06:04:59.245 CET [3248] LOG: checkpoint starting: time 2026-03-18 06:05:00.398 CET [3248] LOG: checkpoint complete: wrote 11 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.090 s, sync=0.021 s, total=1.153 s; sync files=5, longest=0.006 s, average=0.005 s; distance=50 kB, estimate=62 kB; lsn=19/6B9579C0, redo lsn=19/6B957968 2026-03-18 06:09:59.408 CET [3248] LOG: checkpoint starting: time 2026-03-18 06:10:00.798 CET [3248] LOG: checkpoint complete: wrote 13 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.318 s, sync=0.029 s, total=1.391 s; sync files=5, longest=0.014 s, average=0.006 s; distance=63 kB, estimate=63 kB; lsn=19/6B96B0E0, redo lsn=19/6B967820 2026-03-18 06:14:59.792 CET [3248] LOG: checkpoint starting: time 2026-03-18 06:15:00.624 CET [3248] LOG: checkpoint complete: wrote 8 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.766 s, sync=0.022 s, total=0.833 s; sync files=5, longest=0.007 s, average=0.005 s; distance=38 kB, estimate=61 kB; lsn=19/6B971410, redo lsn=19/6B9713B8 2026-03-18 06:19:59.629 CET [3248] LOG: checkpoint starting: time 2026-03-18 06:20:07.260 CET [3248] LOG: checkpoint complete: wrote 70 buffers (0.4%); 0 WAL file(s) added, 0 removed, 0 recycled; write=7.534 s, sync=0.056 s, total=7.632 s; sync files=13, longest=0.009 s, average=0.005 s; distance=355 kB, estimate=355 kB; lsn=19/6B9CFD40, redo lsn=19/6B9C9FD8 2026-03-18 06:24:59.251 CET [3248] LOG: checkpoint starting: time 2026-03-18 06:25:00.631 CET [3248] LOG: checkpoint complete: wrote 13 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.311 s, sync=0.028 s, total=1.381 s; sync files=5, longest=0.008 s, average=0.006 s; distance=56 kB, estimate=325 kB; lsn=19/6B9DE438, redo lsn=19/6B9D8200 2026-03-18 06:27:27.823 CET [596] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2026-03-18 06:27:27.823 CET [596] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2026-03-18 06:27:27.878 CET [3224] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2026-03-18 06:27:27.878 CET [3224] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2026-03-18 06:27:27.897 CET [7052] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2026-03-18 06:27:27.897 CET [7052] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2026-03-18 06:27:28.007 CET [3520] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2026-03-18 06:27:28.007 CET [3520] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2026-03-18 06:27:28.055 CET [3012] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2026-03-18 06:27:28.055 CET [3012] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2026-03-18 06:27:28.124 CET [6516] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2026-03-18 06:27:28.124 CET [6516] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2026-03-18 06:27:28.164 CET [2980] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2026-03-18 06:27:28.164 CET [2980] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2026-03-18 06:27:28.213 CET [3164] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2026-03-18 06:27:28.213 CET [3164] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2026-03-18 06:27:28.249 CET [6672] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2026-03-18 06:27:28.249 CET [6672] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2026-03-18 06:27:28.322 CET [2932] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2026-03-18 06:27:28.322 CET [2932] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2026-03-18 06:29:59.623 CET [3248] LOG: checkpoint starting: time 2026-03-18 06:30:01.805 CET [3248] LOG: checkpoint complete: wrote 20 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=2.080 s, sync=0.059 s, total=2.182 s; sync files=16, longest=0.006 s, average=0.004 s; distance=62 kB, estimate=298 kB; lsn=19/6B9EC0F0, redo lsn=19/6B9E7D58 2026-03-18 06:30:03.457 CET [5196] FATAL: password authentication failed for user "user_sje" 2026-03-18 06:30:03.457 CET [5196] DETAIL: Role "user_sje" does not exist. Connection matched file "C:/Program Files/PostgreSQL/17/data/pg_hba.conf" line 119: "host all all 0.0.0.0/0 scram-sha-256" 2026-03-18 06:30:03.689 CET [6240] FATAL: password authentication failed for user "user_sje" 2026-03-18 06:30:03.689 CET [6240] DETAIL: Role "user_sje" does not exist. Connection matched file "C:/Program Files/PostgreSQL/17/data/pg_hba.conf" line 119: "host all all 0.0.0.0/0 scram-sha-256" 2026-03-18 06:34:59.803 CET [3248] LOG: checkpoint starting: time 2026-03-18 06:35:00.635 CET [3248] LOG: checkpoint complete: wrote 8 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.765 s, sync=0.026 s, total=0.833 s; sync files=7, longest=0.006 s, average=0.004 s; distance=22 kB, estimate=271 kB; lsn=19/6B9ED760, redo lsn=19/6B9ED708 2026-03-18 06:52:45.361 CET [3728] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2026-03-18 06:52:45.361 CET [3728] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2026-03-18 07:09:59.660 CET [3248] LOG: checkpoint starting: time 2026-03-18 07:10:00.401 CET [3248] LOG: checkpoint complete: wrote 7 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.659 s, sync=0.036 s, total=0.741 s; sync files=6, longest=0.011 s, average=0.006 s; distance=24 kB, estimate=246 kB; lsn=19/6B9F3AA0, redo lsn=19/6B9F3A48 2026-03-18 07:14:59.401 CET [3248] LOG: checkpoint starting: time 2026-03-18 07:14:59.795 CET [3248] LOG: checkpoint complete: wrote 4 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.334 s, sync=0.020 s, total=0.395 s; sync files=4, longest=0.007 s, average=0.005 s; distance=15 kB, estimate=223 kB; lsn=19/6B9F78F8, redo lsn=19/6B9F78A0 2026-03-18 07:19:59.795 CET [3248] LOG: checkpoint starting: time 2026-03-18 07:20:00.195 CET [3248] LOG: checkpoint complete: wrote 4 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.332 s, sync=0.027 s, total=0.401 s; sync files=4, longest=0.008 s, average=0.007 s; distance=17 kB, estimate=202 kB; lsn=19/6B9FBEE8, redo lsn=19/6B9FBE90 2026-03-18 07:24:59.194 CET [3248] LOG: checkpoint starting: time 2026-03-18 07:24:59.571 CET [3248] LOG: checkpoint complete: wrote 4 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.318 s, sync=0.020 s, total=0.378 s; sync files=4, longest=0.007 s, average=0.005 s; distance=18 kB, estimate=184 kB; lsn=19/6BA00858, redo lsn=19/6BA00800 2026-03-18 07:29:59.574 CET [3248] LOG: checkpoint starting: time 2026-03-18 07:30:00.283 CET [3248] LOG: checkpoint complete: wrote 7 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.652 s, sync=0.018 s, total=0.709 s; sync files=5, longest=0.004 s, average=0.004 s; distance=23 kB, estimate=168 kB; lsn=19/6BA065E0, redo lsn=19/6BA06588 2026-03-18 07:34:59.280 CET [3248] LOG: checkpoint starting: time 2026-03-18 07:34:59.775 CET [3248] LOG: checkpoint complete: wrote 5 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.433 s, sync=0.019 s, total=0.495 s; sync files=4, longest=0.007 s, average=0.005 s; distance=21 kB, estimate=153 kB; lsn=19/6BA0BBD8, redo lsn=19/6BA0BB80 2026-03-18 07:39:59.786 CET [3248] LOG: checkpoint starting: time 2026-03-18 07:40:00.174 CET [3248] LOG: checkpoint complete: wrote 4 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.330 s, sync=0.015 s, total=0.388 s; sync files=4, longest=0.005 s, average=0.004 s; distance=19 kB, estimate=140 kB; lsn=19/6BA10A80, redo lsn=19/6BA10A28 2026-03-18 07:44:59.171 CET [3248] LOG: checkpoint starting: time 2026-03-18 07:44:59.559 CET [3248] LOG: checkpoint complete: wrote 4 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.334 s, sync=0.017 s, total=0.388 s; sync files=4, longest=0.005 s, average=0.005 s; distance=20 kB, estimate=128 kB; lsn=19/6BA15E48, redo lsn=19/6BA15DF0 2026-03-18 07:49:59.543 CET [3248] LOG: checkpoint starting: time 2026-03-18 07:49:59.916 CET [3248] LOG: checkpoint complete: wrote 4 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.323 s, sync=0.018 s, total=0.373 s; sync files=4, longest=0.006 s, average=0.005 s; distance=19 kB, estimate=117 kB; lsn=19/6BA1ACB8, redo lsn=19/6BA1AC28 2026-03-18 07:54:59.911 CET [3248] LOG: checkpoint starting: time 2026-03-18 07:55:00.410 CET [3248] LOG: checkpoint complete: wrote 5 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.437 s, sync=0.020 s, total=0.499 s; sync files=4, longest=0.008 s, average=0.005 s; distance=22 kB, estimate=108 kB; lsn=19/6BA20838, redo lsn=19/6BA207E0 2026-03-18 07:59:59.403 CET [3248] LOG: checkpoint starting: time 2026-03-18 07:59:59.802 CET [3248] LOG: checkpoint complete: wrote 4 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.332 s, sync=0.026 s, total=0.400 s; sync files=4, longest=0.010 s, average=0.007 s; distance=13 kB, estimate=98 kB; lsn=19/6BA23F38, redo lsn=19/6BA23EE0 2026-03-18 08:14:59.803 CET [3248] LOG: checkpoint starting: time 2026-03-18 08:15:00.199 CET [3248] LOG: checkpoint complete: wrote 4 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.332 s, sync=0.023 s, total=0.397 s; sync files=4, longest=0.009 s, average=0.006 s; distance=14 kB, estimate=90 kB; lsn=19/6BA27AB8, redo lsn=19/6BA27A60 2026-03-18 08:19:59.194 CET [3248] LOG: checkpoint starting: time 2026-03-18 08:20:00.034 CET [3248] LOG: checkpoint complete: wrote 8 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.771 s, sync=0.027 s, total=0.841 s; sync files=5, longest=0.010 s, average=0.006 s; distance=33 kB, estimate=84 kB; lsn=19/6BA2FF60, redo lsn=19/6BA2FF08 2026-03-18 08:24:59.028 CET [3248] LOG: checkpoint starting: time 2026-03-18 08:24:59.511 CET [3248] LOG: checkpoint complete: wrote 5 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.428 s, sync=0.015 s, total=0.483 s; sync files=4, longest=0.005 s, average=0.004 s; distance=23 kB, estimate=78 kB; lsn=19/6BA35CE0, redo lsn=19/6BA35C88 2026-03-18 08:27:37.992 CET [596] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2026-03-18 08:27:38.273 CET [2980] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2026-03-18 08:27:38.304 CET [3164] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2026-03-18 08:27:38.429 CET [2932] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2026-03-18 08:27:39.055 CET [6672] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2026-03-18 08:30:33.901 CET [3520] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2026-03-18 08:34:59.498 CET [3248] LOG: checkpoint starting: time 2026-03-18 08:34:59.890 CET [3248] LOG: checkpoint complete: wrote 4 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.332 s, sync=0.018 s, total=0.393 s; sync files=4, longest=0.006 s, average=0.005 s; distance=25 kB, estimate=73 kB; lsn=19/6BA3C4D0, redo lsn=19/6BA3C478 2026-03-18 08:41:32.708 CET [5620] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2026-03-18 08:41:32.708 CET [5620] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2026-03-18 08:41:46.084 CET [3100] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2026-03-18 08:41:46.084 CET [3100] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2026-03-18 08:41:46.153 CET [5124] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2026-03-18 08:41:46.153 CET [5124] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2026-03-18 08:41:51.698 CET [7092] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2026-03-18 08:41:51.698 CET [7092] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2026-03-18 08:42:01.876 CET [6056] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2026-03-18 08:42:01.876 CET [6056] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2026-03-18 08:44:59.903 CET [3248] LOG: checkpoint starting: time 2026-03-18 08:45:00.733 CET [3248] LOG: checkpoint complete: wrote 8 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.764 s, sync=0.025 s, total=0.831 s; sync files=4, longest=0.013 s, average=0.007 s; distance=49 kB, estimate=70 kB; lsn=19/6BA48C68, redo lsn=19/6BA48C10 2026-03-18 08:49:59.724 CET [3248] LOG: checkpoint starting: time 2026-03-18 08:50:00.445 CET [3248] LOG: checkpoint complete: wrote 7 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.657 s, sync=0.021 s, total=0.722 s; sync files=4, longest=0.007 s, average=0.006 s; distance=42 kB, estimate=67 kB; lsn=19/6BA534A0, redo lsn=19/6BA53448 2026-03-18 08:52:55.658 CET [6516] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2026-03-18 08:52:55.846 CET [3728] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2026-03-18 08:54:59.455 CET [3248] LOG: checkpoint starting: time 2026-03-18 08:55:00.067 CET [3248] LOG: checkpoint complete: wrote 6 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.547 s, sync=0.021 s, total=0.613 s; sync files=4, longest=0.007 s, average=0.005 s; distance=31 kB, estimate=64 kB; lsn=19/6BA5B3F0, redo lsn=19/6BA5B398 2026-03-18 08:56:48.469 CET [2692] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2026-03-18 08:56:48.469 CET [2692] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2026-03-18 08:59:59.069 CET [3248] LOG: checkpoint starting: time 2026-03-18 09:00:03.518 CET [3248] LOG: checkpoint complete: wrote 40 buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=4.264 s, sync=0.144 s, total=4.449 s; sync files=38, longest=0.012 s, average=0.004 s; distance=201 kB, estimate=201 kB; lsn=19/6BA8DA98, redo lsn=19/6BA8DA40 2026-03-18 09:09:59.539 CET [3248] LOG: checkpoint starting: time 2026-03-18 09:09:59.931 CET [3248] LOG: checkpoint complete: wrote 4 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.331 s, sync=0.020 s, total=0.393 s; sync files=4, longest=0.008 s, average=0.005 s; distance=19 kB, estimate=183 kB; lsn=19/6BA926F8, redo lsn=19/6BA926A0 2026-03-18 09:45:56.604 CET [1780] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2026-03-18 09:45:56.604 CET [1780] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2026-03-18 09:49:59.972 CET [3248] LOG: checkpoint starting: time 2026-03-18 09:50:02.054 CET [3248] LOG: checkpoint complete: wrote 19 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.970 s, sync=0.071 s, total=2.082 s; sync files=17, longest=0.009 s, average=0.005 s; distance=60 kB, estimate=171 kB; lsn=19/6BAA19B8, redo lsn=19/6BAA1960 2026-03-18 09:50:08.084 CET [1780] ERROR: role "administrator_users_create_owner" cannot be dropped because some objects depend on it 2026-03-18 09:50:08.084 CET [1780] DETAIL: 1 object in database sonex 2026-03-18 09:50:08.084 CET [1780] STATEMENT: DROP ROLE administrator_users_create_owner; 2026-03-18 09:50:14.750 CET [1780] ERROR: role "administrator_users_create" cannot be dropped because some objects depend on it 2026-03-18 09:50:14.750 CET [1780] DETAIL: 1 object in database sonex 2026-03-18 09:50:14.750 CET [1780] STATEMENT: DROP ROLE administrator_users_create; 2026-03-18 09:50:48.655 CET [1780] ERROR: role "administrator_users_create" cannot be dropped because some objects depend on it 2026-03-18 09:50:48.655 CET [1780] DETAIL: 1 object in database sonex 2026-03-18 09:50:48.655 CET [1780] STATEMENT: DROP ROLE administrator_users_create; 2026-03-18 09:54:36.922 CET [1780] ERROR: role "administrator_users_create" cannot be dropped because some objects depend on it 2026-03-18 09:54:36.922 CET [1780] DETAIL: 1 object in database sonex 2026-03-18 09:54:36.922 CET [1780] STATEMENT: DROP ROLE administrator_users_create; 2026-03-18 09:54:59.059 CET [3248] LOG: checkpoint starting: time 2026-03-18 09:55:01.012 CET [3248] LOG: checkpoint complete: wrote 18 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.852 s, sync=0.060 s, total=1.953 s; sync files=15, longest=0.008 s, average=0.004 s; distance=55 kB, estimate=159 kB; lsn=19/6BAAF660, redo lsn=19/6BAAF608 2026-03-18 09:56:17.117 CET [2692] ERROR: invalid value for parameter "createrole_self_grant": "off" 2026-03-18 09:56:17.117 CET [2692] DETAIL: Unrecognized key word: "off". 2026-03-18 09:56:17.117 CET [2692] STATEMENT: BEGIN; CREATE SCHEMA IF NOT EXISTS sonex; DO $$ BEGIN IF NOT EXISTS ( SELECT 1 FROM pg_catalog.pg_roles WHERE rolname = 'permission_administrator_users_create' ) THEN CREATE ROLE permission_administrator_users_create NOLOGIN; END IF; IF NOT EXISTS ( SELECT 1 FROM pg_catalog.pg_roles WHERE rolname = 'system_administrator_users_create' ) THEN CREATE ROLE system_administrator_users_create NOLOGIN CREATEROLE; END IF; END $$; CREATE TABLE IF NOT EXISTS sonex.db_users ( id integer GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY, -- nazwa widoczna w Sonex username character varying(58) NOT NULL, first_name character varying(100) NOT NULL, last_name character varying(100) NOT NULL, initials character varying(3), email character varying(255), phone_number character varying(30), department character varying(100), job_title character varying(100), native_language character varying(50), other_languages text, account_locus_wms character varying(100), account_locus_terminal character varying(100), account_orp character varying(100), account_bk character varying(100), account_dpd character varying(100), account_xenos character varying(100), tags text[] NOT NULL DEFAULT '{}'::text[], notes text, created_at timestamp without time zone NOT NULL DEFAULT now(), updated_at timestamp without time zone NOT NULL DEFAULT now(), CONSTRAINT db_users_username_upk UNIQUE (username), CONSTRAINT db_users_username_chk CHECK (username ~ '^[a-z][a-z0-9_]{0,57}$') ); ALTER TABLE sonex.db_users OWNER TO sonex; GRANT USAGE ON SCHEMA sonex TO permission_administrator_users_create; GRANT USAGE, CREATE ON SCHEMA sonex TO system_administrator_users_create; GRANT SELECT, INSERT, UPDATE ON TABLE sonex.db_users TO system_administrator_users_create; GRANT USAGE, SELECT ON SEQUENCE sonex.db_users_id_seq TO system_administrator_users_create; CREATE OR REPLACE FUNCTION sonex.db_users_set_updated_at() RETURNS trigger LANGUAGE plpgsql AS $$ BEGIN NEW.updated_at := now(); RETURN NEW; END; $$; DROP TRIGGER IF EXISTS trg_db_users_set_updated_at ON sonex.db_users; CREATE TRIGGER trg_db_users_set_updated_at BEFORE UPDATE ON sonex.db_users FOR EACH ROW EXECUTE FUNCTION sonex.db_users_set_updated_at(); CREATE OR REPLACE FUNCTION sonex.db_users_prevent_username_change() RETURNS trigger LANGUAGE plpgsql AS $$ BEGIN IF NEW.username IS DISTINCT FROM OLD.username THEN RAISE EXCEPTION 'username cannot be changed'; END IF; RETURN NEW; END; $$; DROP TRIGGER IF EXISTS trg_db_users_prevent_username_change ON sonex.db_users; CREATE TRIGGER trg_db_users_prevent_username_change BEFORE UPDATE ON sonex.db_users FOR EACH ROW EXECUTE FUNCTION sonex.db_users_prevent_username_change(); CREATE OR REPLACE FUNCTION sonex.administrator_users_create( p_username text, p_password text, p_first_name text, p_last_name text ) RETURNS integer LANGUAGE plpgsql SECURITY DEFINER SET search_path = sonex, pg_temp SET createrole_self_grant = off AS $$ DECLARE v_id integer; v_role_name text; BEGIN p_username := btrim(p_username); p_password := coalesce(p_password, ''); p_first_name := btrim(p_first_name); p_last_name := btrim(p_last_name); IF p_username = '' OR p_username !~ '^[a-z][a-z0-9_]{0,57}$' THEN RAISE EXCEPTION 'Invalid username'; END IF; IF p_password = '' THEN RAISE EXCEPTION 'Password cannot be empty'; END IF; IF p_first_name = '' THEN RAISE EXCEPTION 'First name cannot be empty'; END IF; IF p_last_name = '' THEN RAISE EXCEPTION 'Last name cannot be empty'; END IF; IF EXISTS ( SELECT 1 FROM sonex.db_users WHERE username = p_username ) THEN RAISE EXCEPTION 'User "%" already exists in sonex.db_users', p_username; END IF; v_role_name := 'user_' || p_username; IF EXISTS ( SELECT 1 FROM pg_catalog.pg_roles WHERE rolname = v_role_name ) THEN RAISE EXCEPTION 'PostgreSQL role "%" already exists', v_role_name; END IF; EXECUTE format( 'CREATE ROLE %I LOGIN PASSWORD %L', v_role_name, p_password ); INSERT INTO sonex.db_users ( username, first_name, last_name ) VALUES ( p_username, p_first_name, p_last_name ) RETURNING id INTO v_id; RETURN v_id; END; $$; ALTER FUNCTION sonex.administrator_users_create(text, text, text, text) OWNER TO system_administrator_users_create; REVOKE ALL ON FUNCTION sonex.administrator_users_create(text, text, text, text) FROM PUBLIC; GRANT EXECUTE ON FUNCTION sonex.administrator_users_create(text, text, text, text) TO permission_administrator_users_create; COMMIT; 2026-03-18 09:57:13.566 CET [2692] ERROR: current transaction is aborted, commands ignored until end of transaction block 2026-03-18 09:57:13.566 CET [2692] STATEMENT: SELECT n.nspname AS schema_name, p.proname AS function_name FROM pg_proc p JOIN pg_namespace n ON n.oid = p.pronamespace WHERE p.proowner = 'administrator_users_create'::regrole UNION ALL SELECT n.nspname AS schema_name, c.relname AS object_name FROM pg_class c JOIN pg_namespace n ON n.oid = c.relnamespace WHERE c.relowner = 'administrator_users_create'::regrole; 2026-03-18 09:57:30.029 CET [2692] ERROR: current transaction is aborted, commands ignored until end of transaction block 2026-03-18 09:57:30.029 CET [2692] STATEMENT: SELECT n.nspname AS schema_name, p.proname AS function_name FROM pg_proc p JOIN pg_namespace n ON n.oid = p.pronamespace WHERE p.proowner = 'administrator_users_create'::regrole UNION ALL SELECT n.nspname AS schema_name, c.relname AS object_name FROM pg_class c JOIN pg_namespace n ON n.oid = c.relnamespace WHERE c.relowner = 'administrator_users_create'::regrole; 2026-03-18 09:58:32.504 CET [2692] ERROR: current transaction is aborted, commands ignored until end of transaction block 2026-03-18 09:58:32.504 CET [2692] STATEMENT: ALTER FUNCTION public.administrator_users_create(text, text, text, text) OWNER TO postgres; DROP ROLE administrator_users_create; 2026-03-18 09:58:47.460 CET [2692] ERROR: current transaction is aborted, commands ignored until end of transaction block 2026-03-18 09:58:47.460 CET [2692] STATEMENT: ALTER FUNCTION sonex.administrator_users_create(text, text, text, text) OWNER TO postgres; DROP ROLE administrator_users_create; 2026-03-18 09:58:53.518 CET [1780] ERROR: role "administrator_users_create" cannot be dropped because some objects depend on it 2026-03-18 09:58:53.518 CET [1780] DETAIL: 1 object in database sonex 2026-03-18 09:58:53.518 CET [1780] STATEMENT: DROP ROLE administrator_users_create; 2026-03-18 09:59:55.210 CET [6112] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2026-03-18 09:59:55.210 CET [6112] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2026-03-18 09:59:59.014 CET [3248] LOG: checkpoint starting: time 2026-03-18 10:00:01.897 CET [3248] LOG: checkpoint complete: wrote 26 buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=2.754 s, sync=0.087 s, total=2.883 s; sync files=23, longest=0.006 s, average=0.004 s; distance=101 kB, estimate=153 kB; lsn=19/6BAC8E20, redo lsn=19/6BAC8DC8 2026-03-18 10:00:24.219 CET [2692] ERROR: function sonex.administrator_users_create(text, text, text, text) does not exist 2026-03-18 10:00:24.219 CET [2692] STATEMENT: ROLLBACK; ALTER FUNCTION sonex.administrator_users_create(text, text, text, text) OWNER TO postgres; DROP ROLE administrator_users_create; 2026-03-18 10:00:43.681 CET [2692] ERROR: syntax error at or near "\" at character 12 2026-03-18 10:00:43.681 CET [2692] STATEMENT: ROLLBACK; \c sonex SELECT n.nspname, p.proname, 'function' AS object_type FROM pg_proc p JOIN pg_namespace n ON n.oid = p.pronamespace WHERE p.proowner = 'administrator_users_create'::regrole UNION ALL SELECT n.nspname, c.relname, c.relkind::text AS object_type FROM pg_class c JOIN pg_namespace n ON n.oid = c.relnamespace WHERE c.relowner = 'administrator_users_create'::regrole; 2026-03-18 10:00:47.985 CET [2692] WARNING: there is no transaction in progress 2026-03-18 10:00:56.877 CET [1780] ERROR: role "administrator_users_create" cannot be dropped because some objects depend on it 2026-03-18 10:00:56.877 CET [1780] DETAIL: 1 object in database sonex 2026-03-18 10:00:56.877 CET [1780] STATEMENT: DROP ROLE administrator_users_create; 2026-03-18 10:01:00.221 CET [1780] ERROR: role "administrator_users_create_owner" cannot be dropped because some objects depend on it 2026-03-18 10:01:00.221 CET [1780] DETAIL: 1 object in database sonex 2026-03-18 10:01:00.221 CET [1780] STATEMENT: DROP ROLE administrator_users_create_owner; 2026-03-18 10:02:48.445 CET [2692] WARNING: there is no transaction in progress 2026-03-18 10:03:38.142 CET [704] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2026-03-18 10:03:38.142 CET [704] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2026-03-18 10:03:38.548 CET [6412] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2026-03-18 10:03:38.548 CET [6412] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2026-03-18 10:04:25.515 CET [1780] ERROR: role "administrator_users_create" cannot be dropped because some objects depend on it 2026-03-18 10:04:25.515 CET [1780] DETAIL: 1 object in database sonex 2026-03-18 10:04:25.515 CET [1780] STATEMENT: DROP ROLE administrator_users_create; 2026-03-18 10:04:30.446 CET [1780] ERROR: role "administrator_users_create_owner" cannot be dropped because some objects depend on it 2026-03-18 10:04:30.446 CET [1780] DETAIL: 1 object in database sonex 2026-03-18 10:04:30.446 CET [1780] STATEMENT: DROP ROLE administrator_users_create_owner; 2026-03-18 10:04:59.902 CET [3248] LOG: checkpoint starting: time 2026-03-18 10:05:00.301 CET [3248] LOG: checkpoint complete: wrote 4 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.330 s, sync=0.027 s, total=0.400 s; sync files=4, longest=0.012 s, average=0.007 s; distance=9 kB, estimate=139 kB; lsn=19/6BACB4F0, redo lsn=19/6BACB498 2026-03-18 10:08:45.823 CET [6288] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2026-03-18 10:08:45.823 CET [6288] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2026-03-18 10:09:59.301 CET [3248] LOG: checkpoint starting: time 2026-03-18 10:10:00.708 CET [4480] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2026-03-18 10:10:00.708 CET [4480] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2026-03-18 10:10:04.501 CET [3248] LOG: checkpoint complete: wrote 47 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=5.027 s, sync=0.132 s, total=5.201 s; sync files=37, longest=0.008 s, average=0.004 s; distance=150 kB, estimate=150 kB; lsn=19/6BAF0F60, redo lsn=19/6BAF0ED0 2026-03-18 10:14:59.512 CET [3248] LOG: checkpoint starting: time 2026-03-18 10:15:05.305 CET [3248] LOG: checkpoint complete: wrote 52 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=5.570 s, sync=0.183 s, total=5.793 s; sync files=49, longest=0.008 s, average=0.004 s; distance=252 kB, estimate=252 kB; lsn=19/6BB2FF30, redo lsn=19/6BB2FED8 2026-03-18 10:16:16.534 CET [6412] ERROR: invalid value for parameter "createrole_self_grant": "off" 2026-03-18 10:16:16.534 CET [6412] DETAIL: Unrecognized key word: "off". 2026-03-18 10:16:16.534 CET [6412] STATEMENT: CREATE OR REPLACE FUNCTION sonex.administrator_users_create(IN p_username text,IN p_password text,IN p_first_name text,IN p_last_name text) RETURNS integer LANGUAGE 'plpgsql' VOLATILE SECURITY DEFINER PARALLEL UNSAFE COST 100 SET createrole_self_grant='off' SET search_path=sonex, pg_temp AS $BODY$ DECLARE v_id integer; v_role_name text; BEGIN p_username := btrim(p_username); p_password := coalesce(p_password, ''); p_first_name := btrim(p_first_name); p_last_name := btrim(p_last_name); IF p_username = '' OR p_username !~ '^[a-z][a-z0-9_]{0,57}$' THEN RAISE EXCEPTION 'Invalid username'; END IF; IF p_password = '' THEN RAISE EXCEPTION 'Password cannot be empty'; END IF; IF p_first_name = '' THEN RAISE EXCEPTION 'First name cannot be empty'; END IF; IF p_last_name = '' THEN RAISE EXCEPTION 'Last name cannot be empty'; END IF; IF EXISTS ( SELECT 1 FROM sonex.db_users WHERE username = p_username ) THEN RAISE EXCEPTION 'User "%" already exists in sonex.db_users', p_username; END IF; v_role_name := 'user_' || p_username; IF EXISTS ( SELECT 1 FROM pg_catalog.pg_roles WHERE rolname = v_role_name ) THEN RAISE EXCEPTION 'PostgreSQL role "%" already exists', v_role_name; END IF; EXECUTE format( 'CREATE ROLE %I LOGIN PASSWORD %L', v_role_name, p_password ); INSERT INTO sonex.db_users ( username, first_name, last_name ) VALUES ( p_username, p_first_name, p_last_name ) RETURNING id INTO v_id; PERFORM sonex.system_logs_add( 'users', 'create', 'db_user', v_id, p_username, jsonb_build_object( 'pg_role_name', v_role_name, 'first_name', p_first_name, 'last_name', p_last_name ), 'info' ); RETURN v_id; END; $BODY$; 2026-03-18 10:16:23.318 CET [6412] ERROR: invalid value for parameter "createrole_self_grant": "'off'" 2026-03-18 10:16:23.318 CET [6412] DETAIL: Unrecognized key word: "'off'". 2026-03-18 10:16:23.318 CET [6412] STATEMENT: CREATE OR REPLACE FUNCTION sonex.administrator_users_create(IN p_username text,IN p_password text,IN p_first_name text,IN p_last_name text) RETURNS integer LANGUAGE 'plpgsql' VOLATILE SECURITY DEFINER PARALLEL UNSAFE COST 100 SET createrole_self_grant='''off''' SET search_path=sonex, pg_temp AS $BODY$ DECLARE v_id integer; v_role_name text; BEGIN p_username := btrim(p_username); p_password := coalesce(p_password, ''); p_first_name := btrim(p_first_name); p_last_name := btrim(p_last_name); IF p_username = '' OR p_username !~ '^[a-z][a-z0-9_]{0,57}$' THEN RAISE EXCEPTION 'Invalid username'; END IF; IF p_password = '' THEN RAISE EXCEPTION 'Password cannot be empty'; END IF; IF p_first_name = '' THEN RAISE EXCEPTION 'First name cannot be empty'; END IF; IF p_last_name = '' THEN RAISE EXCEPTION 'Last name cannot be empty'; END IF; IF EXISTS ( SELECT 1 FROM sonex.db_users WHERE username = p_username ) THEN RAISE EXCEPTION 'User "%" already exists in sonex.db_users', p_username; END IF; v_role_name := 'user_' || p_username; IF EXISTS ( SELECT 1 FROM pg_catalog.pg_roles WHERE rolname = v_role_name ) THEN RAISE EXCEPTION 'PostgreSQL role "%" already exists', v_role_name; END IF; EXECUTE format( 'CREATE ROLE %I LOGIN PASSWORD %L', v_role_name, p_password ); INSERT INTO sonex.db_users ( username, first_name, last_name ) VALUES ( p_username, p_first_name, p_last_name ) RETURNING id INTO v_id; PERFORM sonex.system_logs_add( 'users', 'create', 'db_user', v_id, p_username, jsonb_build_object( 'pg_role_name', v_role_name, 'first_name', p_first_name, 'last_name', p_last_name ), 'info' ); RETURN v_id; END; $BODY$; 2026-03-18 10:17:07.881 CET [6412] ERROR: invalid value for parameter "createrole_self_grant": "off" 2026-03-18 10:17:07.881 CET [6412] DETAIL: Unrecognized key word: "off". 2026-03-18 10:17:07.881 CET [6412] STATEMENT: CREATE OR REPLACE FUNCTION sonex.administrator_users_create(IN p_username text,IN p_password text,IN p_first_name text,IN p_last_name text) RETURNS integer LANGUAGE 'plpgsql' VOLATILE SECURITY DEFINER PARALLEL UNSAFE COST 100 SET createrole_self_grant='off' SET search_path=sonex, pg_temp AS $BODY$ DECLARE v_id integer; v_role_name text; BEGIN p_username := btrim(p_username); p_password := coalesce(p_password, ''); p_first_name := btrim(p_first_name); p_last_name := btrim(p_last_name); IF p_username = '' OR p_username !~ '^[a-z][a-z0-9_]{0,57}$' THEN RAISE EXCEPTION 'Invalid username'; END IF; IF p_password = '' THEN RAISE EXCEPTION 'Password cannot be empty'; END IF; IF p_first_name = '' THEN RAISE EXCEPTION 'First name cannot be empty'; END IF; IF p_last_name = '' THEN RAISE EXCEPTION 'Last name cannot be empty'; END IF; IF EXISTS ( SELECT 1 FROM sonex.db_users WHERE username = p_username ) THEN RAISE EXCEPTION 'User "%" already exists in sonex.db_users', p_username; END IF; v_role_name := 'user_' || p_username; IF EXISTS ( SELECT 1 FROM pg_catalog.pg_roles WHERE rolname = v_role_name ) THEN RAISE EXCEPTION 'PostgreSQL role "%" already exists', v_role_name; END IF; EXECUTE format( 'CREATE ROLE %I LOGIN PASSWORD %L', v_role_name, p_password ); INSERT INTO sonex.db_users ( username, first_name, last_name ) VALUES ( p_username, p_first_name, p_last_name ) RETURNING id INTO v_id; PERFORM sonex.system_logs_add( 'users', 'create', 'db_user', v_id, p_username, jsonb_build_object( 'pg_role_name', v_role_name, 'first_name', p_first_name, 'last_name', p_last_name ), 'info' ); RETURN v_id; END; $BODY$; 2026-03-18 10:17:19.103 CET [6412] ERROR: invalid value for parameter "createrole_self_grant": "false" 2026-03-18 10:17:19.103 CET [6412] DETAIL: Unrecognized key word: "false". 2026-03-18 10:17:19.103 CET [6412] STATEMENT: CREATE OR REPLACE FUNCTION sonex.administrator_users_create(IN p_username text,IN p_password text,IN p_first_name text,IN p_last_name text) RETURNS integer LANGUAGE 'plpgsql' VOLATILE SECURITY DEFINER PARALLEL UNSAFE COST 100 SET createrole_self_grant='false' SET search_path=sonex, pg_temp AS $BODY$ DECLARE v_id integer; v_role_name text; BEGIN p_username := btrim(p_username); p_password := coalesce(p_password, ''); p_first_name := btrim(p_first_name); p_last_name := btrim(p_last_name); IF p_username = '' OR p_username !~ '^[a-z][a-z0-9_]{0,57}$' THEN RAISE EXCEPTION 'Invalid username'; END IF; IF p_password = '' THEN RAISE EXCEPTION 'Password cannot be empty'; END IF; IF p_first_name = '' THEN RAISE EXCEPTION 'First name cannot be empty'; END IF; IF p_last_name = '' THEN RAISE EXCEPTION 'Last name cannot be empty'; END IF; IF EXISTS ( SELECT 1 FROM sonex.db_users WHERE username = p_username ) THEN RAISE EXCEPTION 'User "%" already exists in sonex.db_users', p_username; END IF; v_role_name := 'user_' || p_username; IF EXISTS ( SELECT 1 FROM pg_catalog.pg_roles WHERE rolname = v_role_name ) THEN RAISE EXCEPTION 'PostgreSQL role "%" already exists', v_role_name; END IF; EXECUTE format( 'CREATE ROLE %I LOGIN PASSWORD %L', v_role_name, p_password ); INSERT INTO sonex.db_users ( username, first_name, last_name ) VALUES ( p_username, p_first_name, p_last_name ) RETURNING id INTO v_id; PERFORM sonex.system_logs_add( 'users', 'create', 'db_user', v_id, p_username, jsonb_build_object( 'pg_role_name', v_role_name, 'first_name', p_first_name, 'last_name', p_last_name ), 'info' ); RETURN v_id; END; $BODY$; 2026-03-18 10:17:33.468 CET [6412] ERROR: invalid value for parameter "createrole_self_grant": "''" 2026-03-18 10:17:33.468 CET [6412] DETAIL: Unrecognized key word: "''". 2026-03-18 10:17:33.468 CET [6412] STATEMENT: CREATE OR REPLACE FUNCTION sonex.administrator_users_create(IN p_username text,IN p_password text,IN p_first_name text,IN p_last_name text) RETURNS integer LANGUAGE 'plpgsql' VOLATILE SECURITY DEFINER PARALLEL UNSAFE COST 100 SET createrole_self_grant='''''' SET search_path=sonex, pg_temp AS $BODY$ DECLARE v_id integer; v_role_name text; BEGIN p_username := btrim(p_username); p_password := coalesce(p_password, ''); p_first_name := btrim(p_first_name); p_last_name := btrim(p_last_name); IF p_username = '' OR p_username !~ '^[a-z][a-z0-9_]{0,57}$' THEN RAISE EXCEPTION 'Invalid username'; END IF; IF p_password = '' THEN RAISE EXCEPTION 'Password cannot be empty'; END IF; IF p_first_name = '' THEN RAISE EXCEPTION 'First name cannot be empty'; END IF; IF p_last_name = '' THEN RAISE EXCEPTION 'Last name cannot be empty'; END IF; IF EXISTS ( SELECT 1 FROM sonex.db_users WHERE username = p_username ) THEN RAISE EXCEPTION 'User "%" already exists in sonex.db_users', p_username; END IF; v_role_name := 'user_' || p_username; IF EXISTS ( SELECT 1 FROM pg_catalog.pg_roles WHERE rolname = v_role_name ) THEN RAISE EXCEPTION 'PostgreSQL role "%" already exists', v_role_name; END IF; EXECUTE format( 'CREATE ROLE %I LOGIN PASSWORD %L', v_role_name, p_password ); INSERT INTO sonex.db_users ( username, first_name, last_name ) VALUES ( p_username, p_first_name, p_last_name ) RETURNING id INTO v_id; PERFORM sonex.system_logs_add( 'users', 'create', 'db_user', v_id, p_username, jsonb_build_object( 'pg_role_name', v_role_name, 'first_name', p_first_name, 'last_name', p_last_name ), 'info' ); RETURN v_id; END; $BODY$; 2026-03-18 10:18:01.908 CET [6412] ERROR: invalid value for parameter "createrole_self_grant": "null" 2026-03-18 10:18:01.908 CET [6412] DETAIL: Unrecognized key word: "null". 2026-03-18 10:18:01.908 CET [6412] STATEMENT: CREATE OR REPLACE FUNCTION sonex.administrator_users_create(IN p_username text,IN p_password text,IN p_first_name text,IN p_last_name text) RETURNS integer LANGUAGE 'plpgsql' VOLATILE SECURITY DEFINER PARALLEL UNSAFE COST 100 SET createrole_self_grant='null' SET search_path=sonex, pg_temp AS $BODY$ DECLARE v_id integer; v_role_name text; BEGIN p_username := btrim(p_username); p_password := coalesce(p_password, ''); p_first_name := btrim(p_first_name); p_last_name := btrim(p_last_name); IF p_username = '' OR p_username !~ '^[a-z][a-z0-9_]{0,57}$' THEN RAISE EXCEPTION 'Invalid username'; END IF; IF p_password = '' THEN RAISE EXCEPTION 'Password cannot be empty'; END IF; IF p_first_name = '' THEN RAISE EXCEPTION 'First name cannot be empty'; END IF; IF p_last_name = '' THEN RAISE EXCEPTION 'Last name cannot be empty'; END IF; IF EXISTS ( SELECT 1 FROM sonex.db_users WHERE username = p_username ) THEN RAISE EXCEPTION 'User "%" already exists in sonex.db_users', p_username; END IF; v_role_name := 'user_' || p_username; IF EXISTS ( SELECT 1 FROM pg_catalog.pg_roles WHERE rolname = v_role_name ) THEN RAISE EXCEPTION 'PostgreSQL role "%" already exists', v_role_name; END IF; EXECUTE format( 'CREATE ROLE %I LOGIN PASSWORD %L', v_role_name, p_password ); INSERT INTO sonex.db_users ( username, first_name, last_name ) VALUES ( p_username, p_first_name, p_last_name ) RETURNING id INTO v_id; PERFORM sonex.system_logs_add( 'users', 'create', 'db_user', v_id, p_username, jsonb_build_object( 'pg_role_name', v_role_name, 'first_name', p_first_name, 'last_name', p_last_name ), 'info' ); RETURN v_id; END; $BODY$; 2026-03-18 10:18:54.586 CET [6412] ERROR: invalid value for parameter "createrole_self_grant": "CURRENT" 2026-03-18 10:18:54.586 CET [6412] DETAIL: Unrecognized key word: "current". 2026-03-18 10:18:54.586 CET [6412] STATEMENT: CREATE OR REPLACE FUNCTION sonex.administrator_users_create(IN p_username text,IN p_password text,IN p_first_name text,IN p_last_name text) RETURNS integer LANGUAGE 'plpgsql' VOLATILE SECURITY DEFINER PARALLEL UNSAFE COST 100 SET createrole_self_grant='CURRENT' SET search_path=sonex, pg_temp AS $BODY$ DECLARE v_id integer; v_role_name text; BEGIN p_username := btrim(p_username); p_password := coalesce(p_password, ''); p_first_name := btrim(p_first_name); p_last_name := btrim(p_last_name); IF p_username = '' OR p_username !~ '^[a-z][a-z0-9_]{0,57}$' THEN RAISE EXCEPTION 'Invalid username'; END IF; IF p_password = '' THEN RAISE EXCEPTION 'Password cannot be empty'; END IF; IF p_first_name = '' THEN RAISE EXCEPTION 'First name cannot be empty'; END IF; IF p_last_name = '' THEN RAISE EXCEPTION 'Last name cannot be empty'; END IF; IF EXISTS ( SELECT 1 FROM sonex.db_users WHERE username = p_username ) THEN RAISE EXCEPTION 'User "%" already exists in sonex.db_users', p_username; END IF; v_role_name := 'user_' || p_username; IF EXISTS ( SELECT 1 FROM pg_catalog.pg_roles WHERE rolname = v_role_name ) THEN RAISE EXCEPTION 'PostgreSQL role "%" already exists', v_role_name; END IF; EXECUTE format( 'CREATE ROLE %I LOGIN PASSWORD %L', v_role_name, p_password ); INSERT INTO sonex.db_users ( username, first_name, last_name ) VALUES ( p_username, p_first_name, p_last_name ) RETURNING id INTO v_id; PERFORM sonex.system_logs_add( 'users', 'create', 'db_user', v_id, p_username, jsonb_build_object( 'pg_role_name', v_role_name, 'first_name', p_first_name, 'last_name', p_last_name ), 'info' ); RETURN v_id; END; $BODY$; 2026-03-18 10:19:59.295 CET [3248] LOG: checkpoint starting: time 2026-03-18 10:19:59.676 CET [3248] LOG: checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.326 s, sync=0.013 s, total=0.382 s; sync files=3, longest=0.005 s, average=0.005 s; distance=7 kB, estimate=227 kB; lsn=19/6BB31CA0, redo lsn=19/6BB31C48 2026-03-18 10:20:30.922 CET [2992] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2026-03-18 10:20:30.922 CET [2992] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2026-03-18 10:24:59.670 CET [3248] LOG: checkpoint starting: time 2026-03-18 10:25:04.522 CET [3248] LOG: checkpoint complete: wrote 44 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=4.682 s, sync=0.131 s, total=4.853 s; sync files=35, longest=0.008 s, average=0.004 s; distance=54 kB, estimate=210 kB; lsn=19/6BB3F7B8, redo lsn=19/6BB3F728 2026-03-18 10:26:02.318 CET [2992] ERROR: User "samuel" does not exist in sonex.db_users 2026-03-18 10:26:02.318 CET [2992] CONTEXT: PL/pgSQL function administrator_users_disable(text) line 16 at RAISE 2026-03-18 10:26:02.318 CET [2992] STATEMENT: SELECT sonex.administrator_users_disable('samuel'); 2026-03-18 10:26:20.726 CET [6472] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2026-03-18 10:26:20.726 CET [6472] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2026-03-18 10:26:54.744 CET [7160] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2026-03-18 10:26:54.744 CET [7160] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2026-03-18 10:29:59.523 CET [3248] LOG: checkpoint starting: time 2026-03-18 10:30:02.816 CET [3248] LOG: checkpoint complete: wrote 30 buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=3.153 s, sync=0.100 s, total=3.294 s; sync files=27, longest=0.008 s, average=0.004 s; distance=90 kB, estimate=198 kB; lsn=19/6BB56320, redo lsn=19/6BB562C8 2026-03-18 10:31:38.538 CET [7160] ERROR: role "permission_administrator_users_edit" already exists 2026-03-18 10:31:38.538 CET [7160] STATEMENT: CREATE ROLE permission_administrator_users_edit NOLOGIN; GRANT USAGE ON SCHEMA sonex TO permission_administrator_users_edit; GRANT EXECUTE ON FUNCTION sonex.administrator_users_disable(text) TO permission_administrator_users_edit; GRANT EXECUTE ON FUNCTION sonex.administrator_users_enable(text) TO permission_administrator_users_edit; 2026-03-18 10:33:01.478 CET [7160] ERROR: syntax error at or near "IF" at character 11 2026-03-18 10:33:01.478 CET [7160] STATEMENT: BEGIN IF NOT EXISTS ( SELECT 1 FROM pg_catalog.pg_roles WHERE rolname = 'permission_administrator_users_create' ) THEN CREATE ROLE permission_administrator_users_create NOLOGIN; END IF; IF NOT EXISTS ( SELECT 1 FROM pg_catalog.pg_roles WHERE rolname = 'system_administrator_users_create' ) THEN CREATE ROLE system_administrator_users_create NOLOGIN CREATEROLE; END IF; IF NOT EXISTS ( SELECT 1 FROM pg_catalog.pg_roles WHERE rolname = 'permission_administrator_users_edit' ) THEN CREATE ROLE permission_administrator_users_edit NOLOGIN; END IF; END 2026-03-18 10:34:59.820 CET [3248] LOG: checkpoint starting: time 2026-03-18 10:35:01.575 CET [3248] LOG: checkpoint complete: wrote 16 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.660 s, sync=0.054 s, total=1.755 s; sync files=14, longest=0.006 s, average=0.004 s; distance=26 kB, estimate=181 kB; lsn=19/6BB5CE30, redo lsn=19/6BB5CDD8 2026-03-18 10:35:20.044 CET [6164] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2026-03-18 10:35:20.044 CET [6164] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2026-03-18 10:39:59.570 CET [3248] LOG: checkpoint starting: time 2026-03-18 10:40:02.552 CET [3248] LOG: checkpoint complete: wrote 27 buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=2.841 s, sync=0.095 s, total=2.982 s; sync files=21, longest=0.008 s, average=0.005 s; distance=135 kB, estimate=176 kB; lsn=19/6BB7ED68, redo lsn=19/6BB7ED10 2026-03-18 10:41:56.239 CET [5124] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2026-03-18 10:42:11.979 CET [6056] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2026-03-18 10:44:59.550 CET [3248] LOG: checkpoint starting: time 2026-03-18 10:45:00.937 CET [3248] LOG: checkpoint complete: wrote 13 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.307 s, sync=0.046 s, total=1.387 s; sync files=11, longest=0.005 s, average=0.005 s; distance=56 kB, estimate=164 kB; lsn=19/6BB8D010, redo lsn=19/6BB8CFB8 2026-03-18 10:49:41.762 CET [6596] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2026-03-18 10:49:41.762 CET [6596] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2026-03-18 10:49:59.924 CET [3248] LOG: checkpoint starting: time 2026-03-18 10:50:03.787 CET [3248] LOG: checkpoint complete: wrote 35 buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=3.698 s, sync=0.117 s, total=3.863 s; sync files=28, longest=0.009 s, average=0.005 s; distance=119 kB, estimate=160 kB; lsn=19/6BBAAF90, redo lsn=19/6BBAAF00 2026-03-18 10:54:59.793 CET [3248] LOG: checkpoint starting: time 2026-03-18 10:55:00.521 CET [3248] LOG: checkpoint complete: wrote 7 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.659 s, sync=0.027 s, total=0.729 s; sync files=7, longest=0.006 s, average=0.004 s; distance=41 kB, estimate=148 kB; lsn=19/6BBBAE30, redo lsn=19/6BBB5420 2026-03-18 10:59:59.523 CET [3248] LOG: checkpoint starting: time 2026-03-18 11:00:00.134 CET [3248] LOG: checkpoint complete: wrote 6 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.549 s, sync=0.018 s, total=0.612 s; sync files=4, longest=0.006 s, average=0.005 s; distance=28 kB, estimate=136 kB; lsn=19/6BBBC738, redo lsn=19/6BBBC6E0 2026-03-18 11:14:59.166 CET [3248] LOG: checkpoint starting: time 2026-03-18 11:15:02.889 CET [3248] LOG: checkpoint complete: wrote 34 buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=3.597 s, sync=0.085 s, total=3.724 s; sync files=15, longest=0.011 s, average=0.006 s; distance=175 kB, estimate=175 kB; lsn=19/6BBE83E8, redo lsn=19/6BBE8390 2026-03-18 11:19:59.894 CET [3248] LOG: checkpoint starting: time 2026-03-18 11:20:00.628 CET [3248] LOG: checkpoint complete: wrote 7 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.656 s, sync=0.030 s, total=0.734 s; sync files=7, longest=0.009 s, average=0.005 s; distance=5 kB, estimate=158 kB; lsn=19/6BBE98E8, redo lsn=19/6BBE9890 2026-03-18 11:29:59.644 CET [3248] LOG: checkpoint starting: time 2026-03-18 11:30:02.641 CET [3248] LOG: checkpoint complete: wrote 27 buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=2.873 s, sync=0.083 s, total=2.997 s; sync files=18, longest=0.014 s, average=0.005 s; distance=88 kB, estimate=151 kB; lsn=19/6BBFF9B0, redo lsn=19/6BBFF920 2026-03-18 11:34:59.640 CET [3248] LOG: checkpoint starting: time 2026-03-18 11:35:00.490 CET [3248] LOG: checkpoint complete: wrote 8 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.769 s, sync=0.035 s, total=0.850 s; sync files=5, longest=0.011 s, average=0.007 s; distance=28 kB, estimate=138 kB; lsn=19/6BC06B40, redo lsn=19/6BC06AE8 2026-03-18 11:54:59.493 CET [3248] LOG: checkpoint starting: time 2026-03-18 11:54:59.664 CET [3248] LOG: checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.111 s, sync=0.015 s, total=0.172 s; sync files=2, longest=0.008 s, average=0.008 s; distance=7 kB, estimate=125 kB; lsn=19/6BC08AD0, redo lsn=19/6BC08A78 2026-03-18 12:13:48.387 CET [1940] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2026-03-18 12:13:48.387 CET [1940] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2026-03-18 12:22:56.897 CET [5012] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2026-03-18 12:22:56.897 CET [5012] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2026-03-18 12:23:07.303 CET [4308] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2026-03-18 12:23:07.303 CET [4308] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2026-03-18 12:24:59.678 CET [3248] LOG: checkpoint starting: time 2026-03-18 12:25:00.403 CET [3248] LOG: checkpoint complete: wrote 7 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.657 s, sync=0.022 s, total=0.726 s; sync files=5, longest=0.009 s, average=0.005 s; distance=21 kB, estimate=115 kB; lsn=19/6BC0DF30, redo lsn=19/6BC0DED8 2026-03-18 12:26:31.327 CET [6472] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2026-03-18 12:33:20.420 CET [7160] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2026-03-18 12:34:02.529 CET [228] ERROR: permission denied for table db_users 2026-03-18 12:34:02.529 CET [228] STATEMENT: SELECT id, username, first_name, last_name, initials, email, department, job_title, tags created_at FROM sonex.db_users 2026-03-18 12:34:53.154 CET [3968] ERROR: permission denied for table db_users 2026-03-18 12:34:53.154 CET [3968] STATEMENT: SELECT id, username, first_name, last_name, initials, email, department, job_title, tags created_at FROM sonex.db_users 2026-03-18 12:39:59.406 CET [3248] LOG: checkpoint starting: time 2026-03-18 12:40:00.250 CET [3248] LOG: checkpoint complete: wrote 8 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.762 s, sync=0.036 s, total=0.845 s; sync files=5, longest=0.013 s, average=0.008 s; distance=31 kB, estimate=106 kB; lsn=19/6BC15B50, redo lsn=19/6BC15AF8 2026-03-18 12:44:59.253 CET [3248] LOG: checkpoint starting: time 2026-03-18 12:44:59.767 CET [3248] LOG: checkpoint complete: wrote 5 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.438 s, sync=0.032 s, total=0.515 s; sync files=4, longest=0.011 s, average=0.008 s; distance=25 kB, estimate=98 kB; lsn=19/6BC1BF78, redo lsn=19/6BC1BF20 2026-03-18 12:45:30.518 CET [2992] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2026-03-18 12:47:39.875 CET [6208] ERROR: permission denied for table db_users 2026-03-18 12:47:39.875 CET [6208] STATEMENT: SELECT id, username, first_name, last_name, initials, email, department, job_title, tags created_at FROM sonex.db_users 2026-03-18 12:47:46.867 CET [6208] ERROR: permission denied for table db_users 2026-03-18 12:47:46.867 CET [6208] STATEMENT: SELECT id, username, first_name, last_name, initials, email, department, job_title, tags created_at FROM sonex.db_users 2026-03-18 12:48:24.172 CET [6208] ERROR: permission denied for table db_users 2026-03-18 12:48:24.172 CET [6208] STATEMENT: SELECT id, username, first_name, last_name, initials, email, department, job_title, tags created_at FROM sonex.db_users 2026-03-18 12:48:26.594 CET [6208] ERROR: permission denied for table db_users 2026-03-18 12:48:26.594 CET [6208] STATEMENT: SELECT id, username, first_name, last_name, initials, email, department, job_title, tags created_at FROM sonex.db_users 2026-03-18 12:49:59.779 CET [3248] LOG: checkpoint starting: time 2026-03-18 12:50:00.509 CET [3248] LOG: checkpoint complete: wrote 7 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.657 s, sync=0.028 s, total=0.730 s; sync files=7, longest=0.006 s, average=0.004 s; distance=2 kB, estimate=89 kB; lsn=19/6BC1C798, redo lsn=19/6BC1C740 2026-03-18 12:54:59.501 CET [3248] LOG: checkpoint starting: time 2026-03-18 12:55:00.235 CET [3248] LOG: checkpoint complete: wrote 7 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.659 s, sync=0.031 s, total=0.735 s; sync files=7, longest=0.006 s, average=0.005 s; distance=9 kB, estimate=81 kB; lsn=19/6BC1ED00, redo lsn=19/6BC1ECA8 2026-03-18 12:59:59.243 CET [3248] LOG: checkpoint starting: time 2026-03-18 13:00:00.075 CET [3248] LOG: checkpoint complete: wrote 8 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.758 s, sync=0.034 s, total=0.832 s; sync files=7, longest=0.009 s, average=0.005 s; distance=1 kB, estimate=73 kB; lsn=19/6BC1F3A0, redo lsn=19/6BC1F310 2026-03-18 13:09:59.074 CET [3248] LOG: checkpoint starting: time 2026-03-18 13:09:59.924 CET [3248] LOG: checkpoint complete: wrote 8 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.760 s, sync=0.038 s, total=0.850 s; sync files=8, longest=0.007 s, average=0.005 s; distance=7 kB, estimate=66 kB; lsn=19/6BC21290, redo lsn=19/6BC21238 2026-03-18 13:11:59.679 CET [5924] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2026-03-18 13:11:59.679 CET [5924] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2026-03-18 13:14:59.922 CET [3248] LOG: checkpoint starting: time 2026-03-18 13:15:01.228 CET [3248] LOG: checkpoint complete: wrote 12 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.203 s, sync=0.046 s, total=1.307 s; sync files=9, longest=0.011 s, average=0.006 s; distance=42 kB, estimate=64 kB; lsn=19/6BC2BB88, redo lsn=19/6BC2BB30 2026-03-18 13:15:39.001 CET [5124] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2026-03-18 13:15:39.001 CET [5124] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2026-03-18 13:18:00.736 CET [5124] ERROR: cannot change name of input parameter "p_username" 2026-03-18 13:18:00.736 CET [5124] HINT: Use DROP FUNCTION sonex.administrator_accounts_create(text,text,text,text) first. 2026-03-18 13:18:00.736 CET [5124] STATEMENT: CREATE OR REPLACE FUNCTION sonex.administrator_accounts_create( p_account_name text, p_password text, p_first_name text, p_last_name text ) RETURNS integer LANGUAGE plpgsql SECURITY DEFINER SET search_path = sonex, pg_temp AS $BODY$ DECLARE v_id integer; BEGIN p_account_name := btrim(p_account_name); p_password := coalesce(p_password, ''); p_first_name := btrim(p_first_name); p_last_name := btrim(p_last_name); IF p_account_name = '' OR p_account_name !~ '^[a-z][a-z0-9_]{0,57}$' THEN RAISE EXCEPTION 'Invalid account name'; END IF; IF p_password = '' THEN RAISE EXCEPTION 'Password cannot be empty'; END IF; IF p_first_name = '' THEN RAISE EXCEPTION 'First name cannot be empty'; END IF; IF p_last_name = '' THEN RAISE EXCEPTION 'Last name cannot be empty'; END IF; IF EXISTS ( SELECT 1 FROM sonex.accounts WHERE account_name = p_account_name ) THEN RAISE EXCEPTION 'Account "%" already exists in sonex.accounts', p_account_name; END IF; IF EXISTS ( SELECT 1 FROM pg_catalog.pg_roles WHERE rolname = p_account_name ) THEN RAISE EXCEPTION 'PostgreSQL role "%" already exists', p_account_name; END IF; EXECUTE format( 'CREATE ROLE %I LOGIN PASSWORD %L', p_account_name, p_password ); EXECUTE format( 'GRANT account TO %I', p_account_name ); EXECUTE format( 'GRANT permission_current_accounts_password_edit TO %I', p_account_name ); INSERT INTO sonex.accounts ( account_name, first_name, last_name ) VALUES ( p_account_name, p_first_name, p_last_name ) RETURNING id INTO v_id; PERFORM sonex.system_logs_add( 'accounts', 'create', 'account', v_id, p_account_name, jsonb_build_object( 'first_name', p_first_name, 'last_name', p_last_name ), 'info', 'permission_administrator_accounts_create' ); RETURN v_id; END; $BODY$; 2026-03-18 13:18:36.841 CET [6676] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2026-03-18 13:18:36.841 CET [6676] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2026-03-18 13:19:33.321 CET [6676] ERROR: cannot change name of input parameter "p_username" 2026-03-18 13:19:33.321 CET [6676] HINT: Use DROP FUNCTION sonex.administrator_accounts_disable(text) first. 2026-03-18 13:19:33.321 CET [6676] STATEMENT: CREATE OR REPLACE FUNCTION sonex.administrator_accounts_disable( p_account_name text ) RETURNS boolean LANGUAGE plpgsql SECURITY DEFINER SET search_path = sonex, pg_temp AS $BODY$ BEGIN p_account_name := btrim(coalesce(p_account_name, '')); IF p_account_name = '' OR p_account_name !~ '^[a-z][a-z0-9_]{0,57}$' THEN RAISE EXCEPTION 'Invalid account name'; END IF; IF NOT EXISTS ( SELECT 1 FROM sonex.accounts WHERE account_name = p_account_name ) THEN RAISE EXCEPTION 'Account "%" does not exist in sonex.accounts', p_account_name; END IF; IF NOT EXISTS ( SELECT 1 FROM pg_catalog.pg_roles WHERE rolname = p_account_name ) THEN RAISE EXCEPTION 'PostgreSQL role "%" does not exist', p_account_name; END IF; EXECUTE format( 'ALTER ROLE %I NOLOGIN', p_account_name ); PERFORM sonex.system_logs_add( 'accounts', 'disable', 'account', NULL, p_account_name, jsonb_build_object( 'pg_role_name', p_account_name ), 'info', 'permission_administrator_accounts_edit' ); RETURN true; END; $BODY$; ALTER FUNCTION sonex.administrator_accounts_disable(text) OWNER TO postgres; REVOKE ALL ON FUNCTION sonex.administrator_accounts_disable(text) FROM PUBLIC; GRANT EXECUTE ON FUNCTION sonex.administrator_accounts_disable(text) TO permission_administrator_accounts_edit; 2026-03-18 13:19:59.229 CET [3248] LOG: checkpoint starting: time 2026-03-18 13:20:01.070 CET [3248] LOG: checkpoint complete: wrote 17 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.747 s, sync=0.048 s, total=1.841 s; sync files=11, longest=0.009 s, average=0.005 s; distance=63 kB, estimate=64 kB; lsn=19/6BC3BAD0, redo lsn=19/6BC3BA78 2026-03-18 13:20:02.010 CET [3372] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2026-03-18 13:20:02.010 CET [3372] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2026-03-18 13:20:41.537 CET [3372] ERROR: cannot change name of input parameter "p_username" 2026-03-18 13:20:41.537 CET [3372] HINT: Use DROP FUNCTION sonex.administrator_accounts_enable(text) first. 2026-03-18 13:20:41.537 CET [3372] STATEMENT: CREATE OR REPLACE FUNCTION sonex.administrator_accounts_enable( p_account_name text ) RETURNS boolean LANGUAGE plpgsql SECURITY DEFINER SET search_path = sonex, pg_temp AS $BODY$ BEGIN p_account_name := btrim(coalesce(p_account_name, '')); IF p_account_name = '' OR p_account_name !~ '^[a-z][a-z0-9_]{0,57}$' THEN RAISE EXCEPTION 'Invalid account name'; END IF; IF NOT EXISTS ( SELECT 1 FROM sonex.accounts WHERE account_name = p_account_name ) THEN RAISE EXCEPTION 'Account "%" does not exist in sonex.accounts', p_account_name; END IF; IF NOT EXISTS ( SELECT 1 FROM pg_catalog.pg_roles WHERE rolname = p_account_name ) THEN RAISE EXCEPTION 'PostgreSQL role "%" does not exist', p_account_name; END IF; EXECUTE format( 'ALTER ROLE %I LOGIN', p_account_name ); PERFORM sonex.system_logs_add( 'accounts', 'enable', 'account', NULL, p_account_name, jsonb_build_object( 'pg_role_name', p_account_name ), 'info', 'permission_administrator_accounts_edit' ); RETURN true; END; $BODY$; ALTER FUNCTION sonex.administrator_accounts_enable(text) OWNER TO postgres; REVOKE ALL ON FUNCTION sonex.administrator_accounts_enable(text) FROM PUBLIC; GRANT EXECUTE ON FUNCTION sonex.administrator_accounts_enable(text) TO permission_administrator_accounts_edit; 2026-03-18 13:20:59.615 CET [3736] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2026-03-18 13:20:59.615 CET [3736] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2026-03-18 13:21:50.052 CET [3736] ERROR: cannot change name of input parameter "p_username" 2026-03-18 13:21:50.052 CET [3736] HINT: Use DROP FUNCTION sonex.administrator_accounts_password_change(text,text) first. 2026-03-18 13:21:50.052 CET [3736] STATEMENT: CREATE OR REPLACE FUNCTION sonex.administrator_accounts_password_change( p_account_name text, p_new_password text ) RETURNS boolean LANGUAGE plpgsql SECURITY DEFINER SET search_path = sonex, pg_temp AS $BODY$ BEGIN p_account_name := btrim(coalesce(p_account_name, '')); p_new_password := coalesce(p_new_password, ''); IF p_account_name = '' OR p_account_name !~ '^[a-z][a-z0-9_]{0,57}$' THEN RAISE EXCEPTION 'Invalid account name'; END IF; IF length(trim(p_new_password)) = 0 THEN RAISE EXCEPTION 'Password cannot be empty'; END IF; IF NOT EXISTS ( SELECT 1 FROM sonex.accounts WHERE account_name = p_account_name ) THEN RAISE EXCEPTION 'Account "%" does not exist in sonex.accounts', p_account_name; END IF; IF NOT EXISTS ( SELECT 1 FROM pg_catalog.pg_roles WHERE rolname = p_account_name ) THEN RAISE EXCEPTION 'PostgreSQL role "%" does not exist', p_account_name; END IF; EXECUTE format( 'ALTER ROLE %I PASSWORD %L', p_account_name, p_new_password ); PERFORM sonex.system_logs_add( 'accounts', 'password_change_admin', 'account', NULL, p_account_name, jsonb_build_object( 'pg_role_name', p_account_name ), 'info', 'permission_administrator_accounts_edit' ); RETURN true; END; $BODY$; ALTER FUNCTION sonex.administrator_accounts_password_change(text, text) OWNER TO postgres; REVOKE ALL ON FUNCTION sonex.administrator_accounts_password_change(text, text) FROM PUBLIC; GRANT EXECUTE ON FUNCTION sonex.administrator_accounts_password_change(text, text) TO permission_administrator_accounts_edit; 2026-03-18 13:22:09.042 CET [6656] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2026-03-18 13:22:09.042 CET [6656] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2026-03-18 13:23:39.731 CET [4348] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2026-03-18 13:23:39.731 CET [4348] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2026-03-18 13:24:59.067 CET [3248] LOG: checkpoint starting: time 2026-03-18 13:25:00.702 CET [3248] LOG: checkpoint complete: wrote 15 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.541 s, sync=0.048 s, total=1.635 s; sync files=11, longest=0.007 s, average=0.005 s; distance=72 kB, estimate=72 kB; lsn=19/6BC4DC58, redo lsn=19/6BC4DC00 2026-03-18 13:27:26.723 CET [6164] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2026-03-18 13:29:59.702 CET [3248] LOG: checkpoint starting: time 2026-03-18 13:30:05.712 CET [3248] LOG: checkpoint complete: wrote 54 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=5.810 s, sync=0.150 s, total=6.011 s; sync files=41, longest=0.011 s, average=0.004 s; distance=277 kB, estimate=277 kB; lsn=19/6BC93388, redo lsn=19/6BC93330 2026-03-18 13:39:59.718 CET [3248] LOG: checkpoint starting: time 2026-03-18 13:40:03.570 CET [3248] LOG: checkpoint complete: wrote 35 buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=3.702 s, sync=0.105 s, total=3.852 s; sync files=28, longest=0.009 s, average=0.004 s; distance=21 kB, estimate=252 kB; lsn=19/6BC9B288, redo lsn=19/6BC988B8 2026-03-18 13:44:59.563 CET [3248] LOG: checkpoint starting: time 2026-03-18 13:45:01.530 CET [3248] LOG: checkpoint complete: wrote 18 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.859 s, sync=0.066 s, total=1.968 s; sync files=17, longest=0.005 s, average=0.004 s; distance=27 kB, estimate=229 kB; lsn=19/6BCA3BF0, redo lsn=19/6BC9F788 2026-03-18 13:49:59.525 CET [3248] LOG: checkpoint starting: time 2026-03-18 13:49:59.919 CET [3248] LOG: checkpoint complete: wrote 4 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.331 s, sync=0.020 s, total=0.395 s; sync files=4, longest=0.007 s, average=0.005 s; distance=24 kB, estimate=209 kB; lsn=19/6BCA5A18, redo lsn=19/6BCA59C0 2026-03-18 13:54:59.921 CET [3248] LOG: checkpoint starting: time 2026-03-18 13:55:00.536 CET [3248] LOG: checkpoint complete: wrote 6 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.543 s, sync=0.028 s, total=0.616 s; sync files=5, longest=0.009 s, average=0.006 s; distance=18 kB, estimate=190 kB; lsn=19/6BCAA3D0, redo lsn=19/6BCAA378 2026-03-18 14:13:58.491 CET [1940] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2026-03-18 14:14:59.546 CET [3248] LOG: checkpoint starting: time 2026-03-18 14:15:00.499 CET [3248] LOG: checkpoint complete: wrote 9 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.867 s, sync=0.035 s, total=0.954 s; sync files=8, longest=0.008 s, average=0.005 s; distance=45 kB, estimate=175 kB; lsn=19/6BCB5A80, redo lsn=19/6BCB59F0 2026-03-18 14:16:34.815 CET [2868] WARNING: PID 6672 is not a PostgreSQL backend process 2026-03-18 14:16:35.201 CET [3904] WARNING: PID 3728 is not a PostgreSQL backend process 2026-03-18 14:16:36.306 CET [6272] WARNING: PID 2992 is not a PostgreSQL backend process 2026-03-18 14:16:36.569 CET [616] WARNING: PID 6472 is not a PostgreSQL backend process 2026-03-18 14:16:36.957 CET [1924] WARNING: PID 7160 is not a PostgreSQL backend process 2026-03-18 14:16:37.209 CET [6228] WARNING: PID 6164 is not a PostgreSQL backend process 2026-03-18 14:16:37.517 CET [7044] WARNING: PID 1940 is not a PostgreSQL backend process 2026-03-18 14:16:45.026 CET [6388] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2026-03-18 14:16:45.026 CET [6388] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2026-03-18 14:17:16.593 CET [6852] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2026-03-18 14:17:16.593 CET [6852] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2026-03-18 14:19:59.505 CET [3248] LOG: checkpoint starting: time 2026-03-18 14:20:03.734 CET [3248] LOG: checkpoint complete: wrote 38 buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=4.053 s, sync=0.125 s, total=4.229 s; sync files=34, longest=0.007 s, average=0.004 s; distance=64 kB, estimate=164 kB; lsn=19/6BCC5AD0, redo lsn=19/6BCC5A78 2026-03-18 14:22:56.082 CET [2524] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2026-03-18 14:22:56.082 CET [2524] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2026-03-18 14:24:59.736 CET [3248] LOG: checkpoint starting: time 2026-03-18 14:25:00.015 CET [3248] LOG: checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.222 s, sync=0.014 s, total=0.279 s; sync files=3, longest=0.008 s, average=0.005 s; distance=0 kB, estimate=148 kB; lsn=19/6BCC5D50, redo lsn=19/6BCC5CF8 2026-03-18 14:26:49.250 CET [6212] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2026-03-18 14:26:49.250 CET [6212] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2026-03-18 14:27:33.659 CET [760] ERROR: relation "sonex.db_users" does not exist at character 106 2026-03-18 14:27:33.659 CET [760] STATEMENT: SELECT id, username, first_name, last_name, initials, email, department, job_title, tags created_at FROM sonex.db_users 2026-03-18 14:28:46.595 CET [3960] ERROR: permission denied for table accounts 2026-03-18 14:28:46.595 CET [3960] STATEMENT: SELECT id, account_name, first_name, last_name, initials, email, department, job_title, tags created_at FROM sonex.accounts 2026-03-18 14:29:59.011 CET [3248] LOG: checkpoint starting: time 2026-03-18 14:30:02.124 CET [3248] LOG: checkpoint complete: wrote 28 buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=2.969 s, sync=0.104 s, total=3.113 s; sync files=26, longest=0.015 s, average=0.004 s; distance=24 kB, estimate=135 kB; lsn=19/6BCCBD90, redo lsn=19/6BCCBD38 2026-03-18 14:39:59.125 CET [3248] LOG: checkpoint starting: time 2026-03-18 14:40:01.880 CET [3248] LOG: checkpoint complete: wrote 25 buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=2.622 s, sync=0.088 s, total=2.756 s; sync files=23, longest=0.006 s, average=0.004 s; distance=72 kB, estimate=129 kB; lsn=19/6BCDDDD8, redo lsn=19/6BCDDD48 2026-03-18 14:44:11.757 CET [6212] ERROR: Group "group_accounts_admin" does not exist 2026-03-18 14:44:11.757 CET [6212] CONTEXT: PL/pgSQL function administrator_groups_permissions_add(text,text) line 42 at RAISE 2026-03-18 14:44:11.757 CET [6212] STATEMENT: SELECT sonex.administrator_groups_permissions_add( 'accounts_admin', 'administrator_accounts_create' ); 2026-03-18 14:44:59.884 CET [3248] LOG: checkpoint starting: time 2026-03-18 14:45:03.191 CET [3248] LOG: checkpoint complete: wrote 30 buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=3.156 s, sync=0.110 s, total=3.307 s; sync files=28, longest=0.009 s, average=0.004 s; distance=77 kB, estimate=124 kB; lsn=19/6BCF1480, redo lsn=19/6BCF1428 2026-03-18 14:49:59.177 CET [3248] LOG: checkpoint starting: time 2026-03-18 14:50:02.275 CET [3248] LOG: checkpoint complete: wrote 28 buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=2.956 s, sync=0.093 s, total=3.099 s; sync files=25, longest=0.006 s, average=0.004 s; distance=80 kB, estimate=119 kB; lsn=19/6BD05660, redo lsn=19/6BD05608 2026-03-18 14:51:43.175 CET [6212] ERROR: syntax error at or near "groups_administrator" at character 1 2026-03-18 14:51:43.175 CET [6212] STATEMENT: groups_administrator 2026-03-18 14:54:20.671 CET [6212] ERROR: Group "group_accounts_administrator" already has permission "permission_administrator_accounts_view" 2026-03-18 14:54:20.671 CET [6212] CONTEXT: PL/pgSQL function administrator_groups_permissions_add(text,text) line 54 at RAISE 2026-03-18 14:54:20.671 CET [6212] STATEMENT: SELECT sonex.administrator_groups_permissions_add( 'accounts_administrator', 'permission_administrator_accounts_view' ); 2026-03-18 14:54:29.085 CET [6212] ERROR: Group "group_accounts_administrator" already has permission "permission_administrator_accounts_view" 2026-03-18 14:54:29.085 CET [6212] CONTEXT: PL/pgSQL function administrator_groups_permissions_add(text,text) line 54 at RAISE 2026-03-18 14:54:29.085 CET [6212] STATEMENT: SELECT sonex.administrator_groups_permissions_add( 'accounts_administrator', 'administrator_accounts_view' ); 2026-03-18 14:54:59.274 CET [3248] LOG: checkpoint starting: time 2026-03-18 14:55:01.460 CET [3248] LOG: checkpoint complete: wrote 20 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=2.056 s, sync=0.089 s, total=2.187 s; sync files=19, longest=0.011 s, average=0.005 s; distance=35 kB, estimate=111 kB; lsn=19/6BD0E4D0, redo lsn=19/6BD0E478 2026-03-18 14:57:35.470 CET [2524] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2026-03-18 14:57:35.470 CET [6412] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2026-03-18 14:57:35.470 CET [1780] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2026-03-18 14:57:35.470 CET [4348] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2026-03-18 14:57:35.470 CET [6212] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2026-03-18 15:09:17.281 CET [4308] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2026-03-18 15:09:59.463 CET [3248] LOG: checkpoint starting: time 2026-03-18 15:09:59.859 CET [3248] LOG: checkpoint complete: wrote 4 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.330 s, sync=0.021 s, total=0.396 s; sync files=4, longest=0.008 s, average=0.006 s; distance=15 kB, estimate=101 kB; lsn=19/6BD122D8, redo lsn=19/6BD12280 2026-03-18 15:14:59.851 CET [3248] LOG: checkpoint starting: time 2026-03-18 15:15:00.464 CET [3248] LOG: checkpoint complete: wrote 6 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.546 s, sync=0.025 s, total=0.614 s; sync files=5, longest=0.008 s, average=0.005 s; distance=22 kB, estimate=93 kB; lsn=19/6BD17CB0, redo lsn=19/6BD17C58 2026-03-18 15:19:59.458 CET [3248] LOG: checkpoint starting: time 2026-03-18 15:20:00.102 CET [3248] LOG: checkpoint complete: wrote 6 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.562 s, sync=0.032 s, total=0.645 s; sync files=5, longest=0.007 s, average=0.007 s; distance=21 kB, estimate=86 kB; lsn=19/6BD1D288, redo lsn=19/6BD1D230 2026-03-18 15:34:59.110 CET [3248] LOG: checkpoint starting: time 2026-03-18 15:35:04.827 CET [3248] LOG: checkpoint complete: wrote 53 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=5.656 s, sync=0.023 s, total=5.718 s; sync files=5, longest=0.007 s, average=0.005 s; distance=441 kB, estimate=441 kB; lsn=19/6BD8FB10, redo lsn=19/6BD8B910 2026-03-18 15:39:59.831 CET [3248] LOG: checkpoint starting: time 2026-03-18 15:40:00.440 CET [3248] LOG: checkpoint complete: wrote 6 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.547 s, sync=0.015 s, total=0.609 s; sync files=3, longest=0.009 s, average=0.005 s; distance=32 kB, estimate=400 kB; lsn=19/6BD93B30, redo lsn=19/6BD93AD8