2025-11-13 00:16:08.859 CET [224] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 00:16:08.861 CET [1140] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 00:16:08.862 CET [5152] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 00:16:08.863 CET [4560] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 00:17:33.644 CET [2848] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 00:17:34.163 CET [3040] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 00:17:37.056 CET [2628] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 00:17:37.181 CET [2592] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 00:17:37.587 CET [3704] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 00:17:41.532 CET [2152] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 00:21:45.113 CET [5744] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 00:21:45.114 CET [6468] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 00:21:45.115 CET [5768] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 00:21:45.117 CET [6012] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 00:21:45.121 CET [1540] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 00:21:45.124 CET [6452] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 00:21:45.125 CET [4656] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 00:25:52.325 CET [6024] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 00:25:52.326 CET [3252] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 00:25:52.327 CET [576] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 00:25:52.328 CET [6068] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 00:25:52.330 CET [2756] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 00:25:52.334 CET [6108] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 00:29:03.342 CET [6816] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 00:29:03.343 CET [4884] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 00:29:03.344 CET [6804] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 00:29:03.349 CET [1804] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 00:29:03.349 CET [6180] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 00:29:03.352 CET [1660] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 00:39:25.209 CET [1724] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 00:39:25.210 CET [1572] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 00:39:25.211 CET [3580] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 00:39:25.212 CET [6660] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 00:39:25.216 CET [6184] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 00:39:25.220 CET [6028] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 00:43:42.585 CET [6728] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 00:43:42.586 CET [6744] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 00:43:42.587 CET [2352] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 00:43:42.589 CET [6240] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 00:43:42.593 CET [3724] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 00:43:42.595 CET [3916] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 00:56:06.282 CET [6428] WARNING: PID 4120 is not a PostgreSQL backend process 2025-11-13 00:56:06.625 CET [3116] WARNING: PID 2300 is not a PostgreSQL backend process 2025-11-13 00:56:06.940 CET [1824] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-13 00:56:06.940 CET [1824] 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'; 2025-11-13 00:56:07.343 CET [6560] WARNING: PID 5772 is not a PostgreSQL backend process 2025-11-13 00:56:07.975 CET [2032] WARNING: PID 2244 is not a PostgreSQL backend process 2025-11-13 00:56:23.628 CET [1824] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 00:56:42.053 CET [4992] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-13 00:56:42.053 CET [4992] 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'; 2025-11-13 00:56:42.194 CET [1984] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-13 00:56:42.194 CET [1984] 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'; 2025-11-13 00:56:42.312 CET [6520] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-13 00:56:42.312 CET [6520] 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'; 2025-11-13 00:56:42.398 CET [2892] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-13 00:56:42.398 CET [2892] 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'; 2025-11-13 00:56:42.439 CET [3724] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-13 00:56:42.439 CET [3724] 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'; 2025-11-13 00:56:42.513 CET [1408] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-13 00:56:42.513 CET [1408] 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'; 2025-11-13 00:56:42.569 CET [5416] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-13 00:56:42.569 CET [5416] 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'; 2025-11-13 00:56:51.177 CET [1392] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-13 00:56:51.177 CET [1392] 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'; 2025-11-13 00:56:51.936 CET [5400] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-13 00:56:51.936 CET [5400] 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'; 2025-11-13 00:56:51.954 CET [5768] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-13 00:56:51.954 CET [5768] 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'; 2025-11-13 01:03:58.032 CET [5836] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-13 01:03:58.032 CET [5836] 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'; 2025-11-13 01:04:04.822 CET [7140] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-13 01:04:04.822 CET [7140] 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'; 2025-11-13 01:11:57.880 CET [5716] LOG: checkpoint starting: time 2025-11-13 01:11:59.079 CET [5716] LOG: checkpoint complete: wrote 11 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.084 s, sync=0.069 s, total=1.200 s; sync files=9, longest=0.017 s, average=0.008 s; distance=30 kB, estimate=549 kB; lsn=7/A8BA88D0, redo lsn=7/A8BA8840 2025-11-13 01:16:57.087 CET [5716] LOG: checkpoint starting: time 2025-11-13 01:16:57.471 CET [5716] LOG: checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.313 s, sync=0.016 s, total=0.384 s; sync files=2, longest=0.010 s, average=0.008 s; distance=8 kB, estimate=495 kB; lsn=7/A8BAA9B0, redo lsn=7/A8BAA958 2025-11-13 01:21:15.983 CET [6360] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 01:21:16.483 CET [5128] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 01:41:57.483 CET [5716] LOG: checkpoint starting: time 2025-11-13 01:41:58.010 CET [5716] LOG: checkpoint complete: wrote 5 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.436 s, sync=0.042 s, total=0.527 s; sync files=4, longest=0.020 s, average=0.011 s; distance=23 kB, estimate=447 kB; lsn=7/A8BB0710, redo lsn=7/A8BB06B8 2025-11-13 01:42:57.544 CET [5768] ERROR: column "bk_quantity" of relation "shipbk_print_jobs" contains null values 2025-11-13 01:42:57.544 CET [5768] STATEMENT: ALTER TABLE IF EXISTS sonex.shipbk_print_jobs ALTER COLUMN bk_quantity SET DEFAULT 1; ALTER TABLE IF EXISTS sonex.shipbk_print_jobs ALTER COLUMN bk_quantity SET NOT NULL; 2025-11-13 01:46:16.560 CET [2392] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 01:46:17.164 CET [2440] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 01:46:57.008 CET [5716] LOG: checkpoint starting: time 2025-11-13 01:47:00.019 CET [5716] LOG: checkpoint complete: wrote 27 buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=2.843 s, sync=0.122 s, total=3.012 s; sync files=18, longest=0.017 s, average=0.007 s; distance=146 kB, estimate=417 kB; lsn=7/A8BD5190, redo lsn=7/A8BD5138 2025-11-13 01:53:58.434 CET [3736] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-13 01:53:58.434 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'; 2025-11-13 01:55:09.166 CET [3736] ERROR: relation "artpackgvw" does not exist at character 15 2025-11-13 01:55:09.166 CET [3736] STATEMENT: SELECT * FROM ArtPackGVW WHERE ArtNr = "609251" 2025-11-13 01:55:17.928 CET [3736] ERROR: column "609251" does not exist at character 44 2025-11-13 01:55:17.928 CET [3736] STATEMENT: SELECT * FROM wms.ArtPackGVW WHERE ArtNr = "609251" 2025-11-13 01:56:57.020 CET [5716] LOG: checkpoint starting: time 2025-11-13 01:56:57.298 CET [5716] LOG: checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.217 s, sync=0.016 s, total=0.279 s; sync files=2, longest=0.009 s, average=0.008 s; distance=14 kB, estimate=377 kB; lsn=7/A8BD8BA8, redo lsn=7/A8BD8B50 2025-11-13 02:03:04.549 CET [3048] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-13 02:03:04.549 CET [3048] 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'; 2025-11-13 02:06:57.303 CET [5716] LOG: checkpoint starting: time 2025-11-13 02:06:57.909 CET [5716] LOG: checkpoint complete: wrote 5 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.545 s, sync=0.016 s, total=0.607 s; sync files=2, longest=0.010 s, average=0.008 s; distance=7 kB, estimate=340 kB; lsn=7/A8BDAB70, redo lsn=7/A8BDAAE0 2025-11-13 02:17:16.137 CET [3736] ERROR: syntax error at or near "+" at character 3037 2025-11-13 02:17:16.137 CET [3736] STATEMENT: -- (opcjonalnie) brakujące kolumny ALTER TABLE sonex.shipbk_print_jobs ADD COLUMN IF NOT EXISTS bk_status varchar(50), ADD COLUMN IF NOT EXISTS error text; CREATE OR REPLACE FUNCTION sonex.fill_missing_bk_fields() RETURNS TABLE(new_rows int, error_rows int) LANGUAGE plpgsql AS $$ DECLARE v_new int := 0; v_err int := 0; BEGIN -- 1) Uzupełnij bk_details z contentdescr dla rekordów bez statusu WITH upd AS ( UPDATE sonex.shipbk_print_jobs t SET bk_details = t.contentdescr WHERE t.bk_status IS NULL RETURNING t.jobid, t.seq, t.bk_details ), parsed AS ( SELECT u.jobid, u.seq, u.bk_details, CASE WHEN u.bk_details IS NULL THEN NULL WHEN right(u.bk_details, 6) ~ '^\d{6}$' THEN right(u.bk_details, 6) ELSE NULL END AS art6 FROM upd u ) -- 2a) SUKCES: dane istnieją i wszystkie > 0, ustaw pola + NEW UPDATE sonex.shipbk_print_jobs t SET bk_height = ap.height, bk_width = ap.width, bk_depth = ap.length, -- length = głębokość bk_weight = ap.gweight, bk_status = 'NEW', error = NULL FROM ( SELECT p.jobid, p.seq, ap.length, ap.height, ap.width, ap.gweight FROM parsed p JOIN wms.artpackgvw ap ON ap.artnr = p.art6 AND ap.iunitqyf = 'SU' WHERE ap.length > 0 AND ap.height > 0 AND ap.width > 0 AND ap.gweight > 0 ) ap WHERE t.jobid = ap.jobid AND t.seq = ap.seq; GET DIAGNOSTICS v_new = ROW_COUNT; -- 2b) DANE ZNALEZIONE, ALE BRAKI/ZERA → ERROR (z komunikatem); mimo to wpisz wartości UPDATE sonex.shipbk_print_jobs t SET bk_height = ap.height, bk_width = ap.width, bk_depth = ap.length, bk_weight = ap.gweight, bk_status = 'ART_ERROR', error = CONCAT( 'Invalid pack data for article ', ap.art6, ' (unit=SU). ', CASE WHEN ap.length IS NULL OR ap.length = 0 THEN 'Length is missing or zero. ' ELSE '' END, CASE WHEN ap.height IS NULL OR ap.height = 0 THEN 'Height is missing or zero. ' ELSE '' END, CASE WHEN ap.width IS NULL OR ap.width = 0 THEN 'Width is missing or zero. ' ELSE '' END, CASE WHEN ap.gweight IS NULL OR ap.gweight = 0 THEN 'Gross weight is missing or zero. ' ELSE '' END ) FROM ( SELECT p.jobid, p.seq, p.art6, ap.length, ap.height, ap.width, ap.gweight FROM parsed p JOIN wms.artpackgvw ap ON ap.artnr = p.art6 AND ap.iunitqyf = 'SU' WHERE (ap.length IS NULL OR ap.length = 0) OR (ap.height IS NULL OR ap.height = 0) OR (ap.width IS NULL OR ap.width = 0) OR (ap.gweight IS NULL OR ap.gweight = 0) ) ap WHERE t.jobid = ap.jobid AND t.seq = ap.seq AND COALESCE(t.bk_status,'') <> 'NEW'; GET DIAGNOSTICS v_err = ROW_COUNT + v_err; -- 2c) 6 cyfr nie występuje → ERROR UPDATE sonex.shipbk_print_jobs t SET bk_status = 'ART_ERROR', error = 'The last 6 characters of bk_details are not digits or bk_details is empty.' FROM parsed p WHERE p.art6 IS NULL AND t.jobid = p.jobid AND t.seq = p.seq AND t.bk_status IS NULL; GET DIAGNOSTICS v_err = ROW_COUNT + v_err; -- 2d) Brak rekordu w artpackgvw → ERROR UPDATE sonex.shipbk_print_jobs t SET bk_status = 'ART_ERROR', error = CONCAT('No pack data found in wms.artpackgvw for article ', p.art6, ' with unit SU.') FROM parsed p LEFT JOIN wms.artpackgvw ap ON ap.artnr = p.art6 AND ap.iunitqyf = 'SU' WHERE p.art6 IS NOT NULL AND ap.artnr IS NULL AND t.jobid = p.jobid AND t.seq = p.seq AND t.bk_status IS NULL; GET DIAGNOSTICS v_err = ROW_COUNT + v_err; RETURN QUERY SELECT v_new, v_err; END; $$; -- uruchomienie SELECT * FROM sonex.fill_missing_bk_fields(); 2025-11-13 02:21:57.921 CET [5716] LOG: checkpoint starting: time 2025-11-13 02:21:59.261 CET [5716] LOG: checkpoint complete: wrote 12 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.192 s, sync=0.096 s, total=1.340 s; sync files=12, longest=0.016 s, average=0.008 s; distance=49 kB, estimate=311 kB; lsn=7/A8BE7000, redo lsn=7/A8BE6FA8 2025-11-13 02:24:48.328 CET [3736] ERROR: value too long for type character varying(30) 2025-11-13 02:24:48.328 CET [3736] CONTEXT: SQL statement "WITH upd AS ( UPDATE sonex.shipbk_print_jobs t SET bk_details = t.contentdescr WHERE (t.bk_details IS NULL OR TRIM(t.bk_details) = '') RETURNING t.jobid, t.seq, t.bk_details ), parsed AS ( SELECT u.jobid, u.seq, u.bk_details, CASE WHEN u.bk_details IS NULL THEN NULL WHEN RIGHT(u.bk_details, 6) ~ '^\d{6}$' THEN RIGHT(u.bk_details, 6) ELSE NULL END AS art6 FROM sonex.shipbk_print_jobs u WHERE (u.bk_status IS NULL OR u.bk_status = 'ART_ERROR') ) -- 2a) SUKCES – dane poprawne → NEW UPDATE sonex.shipbk_print_jobs t SET bk_height = ap.height, bk_width = ap.width, bk_depth = ap.length, bk_weight = ap.gweight, bk_status = 'NEW', error = NULL FROM ( SELECT p.jobid, p.seq, ap.length, ap.height, ap.width, ap.gweight FROM parsed p JOIN wms.artpackgvw ap ON ap.artnr = p.art6 AND ap.iunitqyf = 'SU' WHERE ap.length > 0 AND ap.height > 0 AND ap.width > 0 AND ap.gweight > 0 ) ap WHERE t.jobid = ap.jobid AND t.seq = ap.seq" PL/pgSQL function sonex.fill_missing_bk_fields() line 8 at SQL statement 2025-11-13 02:24:48.328 CET [3736] STATEMENT: -- upewnienie się, że kolumny istnieją ALTER TABLE sonex.shipbk_print_jobs ADD COLUMN IF NOT EXISTS bk_status varchar(50), ADD COLUMN IF NOT EXISTS error text; CREATE OR REPLACE FUNCTION sonex.fill_missing_bk_fields() RETURNS TABLE(new_rows int, error_rows int) LANGUAGE plpgsql AS $$ DECLARE v_new int := 0; v_err int := 0; v_aff int := 0; BEGIN -- 1) Uzupełnij bk_details tylko jeśli puste WITH upd AS ( UPDATE sonex.shipbk_print_jobs t SET bk_details = t.contentdescr WHERE (t.bk_details IS NULL OR TRIM(t.bk_details) = '') RETURNING t.jobid, t.seq, t.bk_details ), parsed AS ( SELECT u.jobid, u.seq, u.bk_details, CASE WHEN u.bk_details IS NULL THEN NULL WHEN RIGHT(u.bk_details, 6) ~ '^\d{6}$' THEN RIGHT(u.bk_details, 6) ELSE NULL END AS art6 FROM sonex.shipbk_print_jobs u WHERE (u.bk_status IS NULL OR u.bk_status = 'ART_ERROR') ) -- 2a) SUKCES – dane poprawne → NEW UPDATE sonex.shipbk_print_jobs t SET bk_height = ap.height, bk_width = ap.width, bk_depth = ap.length, bk_weight = ap.gweight, bk_status = 'NEW', error = NULL FROM ( SELECT p.jobid, p.seq, ap.length, ap.height, ap.width, ap.gweight FROM parsed p JOIN wms.artpackgvw ap ON ap.artnr = p.art6 AND ap.iunitqyf = 'SU' WHERE ap.length > 0 AND ap.height > 0 AND ap.width > 0 AND ap.gweight > 0 ) ap WHERE t.jobid = ap.jobid AND t.seq = ap.seq; GET DIAGNOSTICS v_aff = ROW_COUNT; v_new := v_new + v_aff; -- 2b) Dane błędne (zero/null) → ART_ERROR UPDATE sonex.shipbk_print_jobs t SET bk_height = ap.height, bk_width = ap.width, bk_depth = ap.length, bk_weight = ap.gweight, bk_status = 'ART_ERROR', error = CONCAT( 'Invalid pack data for article ', ap.art6, ' (unit=SU). ', CASE WHEN ap.length IS NULL OR ap.length = 0 THEN 'Length is missing or zero. ' ELSE '' END, CASE WHEN ap.height IS NULL OR ap.height = 0 THEN 'Height is missing or zero. ' ELSE '' END, CASE WHEN ap.width IS NULL OR ap.width = 0 THEN 'Width is missing or zero. ' ELSE '' END, CASE WHEN ap.gweight IS NULL OR ap.gweight = 0 THEN 'Gross weight is missing or zero. ' ELSE '' END ) FROM ( SELECT p.jobid, p.seq, p.art6, ap.length, ap.height, ap.width, ap.gweight FROM parsed p JOIN wms.artpackgvw ap ON ap.artnr = p.art6 AND ap.iunitqyf = 'SU' WHERE (ap.length IS NULL OR ap.length = 0) OR (ap.height IS NULL OR ap.height = 0) OR (ap.width IS NULL OR ap.width = 0) OR (ap.gweight IS NULL OR ap.gweight = 0) ) ap WHERE t.jobid = ap.jobid AND t.seq = ap.seq AND (t.bk_status IS NULL OR t.bk_status = 'ART_ERROR') AND COALESCE(t.bk_status,'') <> 'NEW'; GET DIAGNOSTICS v_aff = ROW_COUNT; v_err := v_err + v_aff; -- 2c) Brak 6 cyfr → ART_ERROR UPDATE sonex.shipbk_print_jobs t SET bk_status = 'ART_ERROR', error = 'The last 6 characters of bk_details are not digits or bk_details is empty.' WHERE (t.bk_status IS NULL OR t.bk_status = 'ART_ERROR') AND (t.bk_details IS NULL OR RIGHT(t.bk_details, 6) !~ '^\d{6}$'); GET DIAGNOSTICS v_aff = ROW_COUNT; v_err := v_err + v_aff; -- 2d) Brak rekordu w artpackgvw → ART_ERROR WITH candidates AS ( SELECT t.jobid, t.seq, RIGHT(t.bk_details, 6) AS art6 FROM sonex.shipbk_print_jobs t WHERE (t.bk_status IS NULL OR t.bk_status = 'ART_ERROR') AND t.bk_details IS NOT NULL AND RIGHT(t.bk_details, 6) ~ '^\d{6}$' ) UPDATE sonex.shipbk_print_jobs t SET bk_status = 'ART_ERROR', error = CONCAT('No pack data found in wms.artpackgvw for article ', c.art6, ' with unit SU.') FROM candidates c LEFT JOIN wms.artpackgvw ap ON ap.artnr = c.art6 AND ap.iunitqyf = 'SU' WHERE t.jobid = c.jobid AND t.seq = c.seq AND ap.artnr IS NULL AND (t.bk_status IS NULL OR t.bk_status = 'ART_ERROR'); GET DIAGNOSTICS v_aff = ROW_COUNT; v_err := v_err + v_aff; RETURN QUERY SELECT v_new, v_err; END; $$; -- uruchomienie: SELECT * FROM sonex.fill_missing_bk_fields(); 2025-11-13 02:26:57.268 CET [5716] LOG: checkpoint starting: time 2025-11-13 02:26:58.605 CET [5716] LOG: checkpoint complete: wrote 12 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.197 s, sync=0.091 s, total=1.338 s; sync files=12, longest=0.015 s, average=0.008 s; distance=47 kB, estimate=285 kB; lsn=7/A8BF2F68, redo lsn=7/A8BF2F10 2025-11-13 02:28:23.144 CET [3736] ERROR: relation "parsed" does not exist at character 861 2025-11-13 02:28:23.144 CET [3736] QUERY: UPDATE sonex.shipbk_print_jobs t SET bk_height = ap.height, bk_width = ap.width, bk_depth = ap.length, bk_weight = ap.gweight, bk_status = 'ART_ERROR', error = CONCAT( 'Invalid pack data for article ', ap.art6, ' (unit=SU). ', CASE WHEN ap.length IS NULL OR ap.length = 0 THEN 'Length is missing or zero. ' ELSE '' END, CASE WHEN ap.height IS NULL OR ap.height = 0 THEN 'Height is missing or zero. ' ELSE '' END, CASE WHEN ap.width IS NULL OR ap.width = 0 THEN 'Width is missing or zero. ' ELSE '' END, CASE WHEN ap.gweight IS NULL OR ap.gweight = 0 THEN 'Gross weight is missing or zero. ' ELSE '' END ) FROM ( SELECT p.jobid, p.seq, p.art6, ap.length, ap.height, ap.width, ap.gweight FROM parsed p JOIN wms.artpackgvw ap ON ap.artnr = p.art6 AND ap.iunitqyf = 'SU' WHERE (ap.length IS NULL OR ap.length = 0) OR (ap.height IS NULL OR ap.height = 0) OR (ap.width IS NULL OR ap.width = 0) OR (ap.gweight IS NULL OR ap.gweight = 0) ) ap WHERE t.jobid = ap.jobid AND t.seq = ap.seq AND (t.bk_status IS NULL OR t.bk_status = 'ART_ERROR') AND COALESCE(t.bk_status,'') <> 'NEW' 2025-11-13 02:28:23.144 CET [3736] CONTEXT: PL/pgSQL function sonex.fill_missing_bk_fields() line 60 at SQL statement 2025-11-13 02:28:23.144 CET [3736] STATEMENT: ALTER TABLE sonex.shipbk_print_jobs ADD COLUMN IF NOT EXISTS bk_status varchar(50), ADD COLUMN IF NOT EXISTS error text; CREATE OR REPLACE FUNCTION sonex.fill_missing_bk_fields() RETURNS TABLE(new_rows int, error_rows int) LANGUAGE plpgsql AS $$ DECLARE v_new int := 0; v_err int := 0; v_aff int := 0; BEGIN -- 1) Uzupełnij bk_details tylko jeśli puste WITH upd AS ( UPDATE sonex.shipbk_print_jobs t SET bk_details = CASE WHEN RIGHT(TRIM(t.contentdescr), 6) ~ '^\d{6}$' THEN LEFT(RIGHT(TRIM(t.contentdescr), 6) || ' ' || LEFT(TRIM(t.contentdescr), LENGTH(TRIM(t.contentdescr)) - 6), 30) ELSE LEFT(TRIM(t.contentdescr), 30) END WHERE (t.bk_details IS NULL OR TRIM(t.bk_details) = '') RETURNING t.jobid, t.seq, t.bk_details ), parsed AS ( SELECT u.jobid, u.seq, u.bk_details, CASE WHEN u.bk_details IS NULL THEN NULL WHEN LEFT(u.bk_details, 6) ~ '^\d{6}$' THEN LEFT(u.bk_details, 6) WHEN RIGHT(u.bk_details, 6) ~ '^\d{6}$' THEN RIGHT(u.bk_details, 6) ELSE NULL END AS art6 FROM sonex.shipbk_print_jobs u WHERE (u.bk_status IS NULL OR u.bk_status = 'ART_ERROR') ) -- 2a) SUKCES – dane poprawne → NEW UPDATE sonex.shipbk_print_jobs t SET bk_height = ap.height, bk_width = ap.width, bk_depth = ap.length, bk_weight = ap.gweight, bk_status = 'NEW', error = NULL FROM ( SELECT p.jobid, p.seq, ap.length, ap.height, ap.width, ap.gweight FROM parsed p JOIN wms.artpackgvw ap ON ap.artnr = p.art6 AND ap.iunitqyf = 'SU' WHERE ap.length > 0 AND ap.height > 0 AND ap.width > 0 AND ap.gweight > 0 ) ap WHERE t.jobid = ap.jobid AND t.seq = ap.seq; GET DIAGNOSTICS v_aff = ROW_COUNT; v_new := v_new + v_aff; -- 2b) Dane błędne (zero/null) → ART_ERROR UPDATE sonex.shipbk_print_jobs t SET bk_height = ap.height, bk_width = ap.width, bk_depth = ap.length, bk_weight = ap.gweight, bk_status = 'ART_ERROR', error = CONCAT( 'Invalid pack data for article ', ap.art6, ' (unit=SU). ', CASE WHEN ap.length IS NULL OR ap.length = 0 THEN 'Length is missing or zero. ' ELSE '' END, CASE WHEN ap.height IS NULL OR ap.height = 0 THEN 'Height is missing or zero. ' ELSE '' END, CASE WHEN ap.width IS NULL OR ap.width = 0 THEN 'Width is missing or zero. ' ELSE '' END, CASE WHEN ap.gweight IS NULL OR ap.gweight = 0 THEN 'Gross weight is missing or zero. ' ELSE '' END ) FROM ( SELECT p.jobid, p.seq, p.art6, ap.length, ap.height, ap.width, ap.gweight FROM parsed p JOIN wms.artpackgvw ap ON ap.artnr = p.art6 AND ap.iunitqyf = 'SU' WHERE (ap.length IS NULL OR ap.length = 0) OR (ap.height IS NULL OR ap.height = 0) OR (ap.width IS NULL OR ap.width = 0) OR (ap.gweight IS NULL OR ap.gweight = 0) ) ap WHERE t.jobid = ap.jobid AND t.seq = ap.seq AND (t.bk_status IS NULL OR t.bk_status = 'ART_ERROR') AND COALESCE(t.bk_status,'') <> 'NEW'; GET DIAGNOSTICS v_aff = ROW_COUNT; v_err := v_err + v_aff; -- 2c) Brak 6 cyfr → ART_ERROR UPDATE sonex.shipbk_print_jobs t SET bk_status = 'ART_ERROR', error = 'The last 6 characters of bk_details are not digits or bk_details is empty.' WHERE (t.bk_status IS NULL OR t.bk_status = 'ART_ERROR') AND (t.bk_details IS NULL OR RIGHT(t.bk_details, 6) !~ '^\d{6}$'); GET DIAGNOSTICS v_aff = ROW_COUNT; v_err := v_err + v_aff; -- 2d) Brak rekordu w artpackgvw → ART_ERROR WITH candidates AS ( SELECT t.jobid, t.seq, RIGHT(t.bk_details, 6) AS art6 FROM sonex.shipbk_print_jobs t WHERE (t.bk_status IS NULL OR t.bk_status = 'ART_ERROR') AND t.bk_details IS NOT NULL AND RIGHT(t.bk_details, 6) ~ '^\d{6}$' ) UPDATE sonex.shipbk_print_jobs t SET bk_status = 'ART_ERROR', error = CONCAT('No pack data found in wms.artpackgvw for article ', c.art6, ' with unit SU.') FROM candidates c LEFT JOIN wms.artpackgvw ap ON ap.artnr = c.art6 AND ap.iunitqyf = 'SU' WHERE t.jobid = c.jobid AND t.seq = c.seq AND ap.artnr IS NULL AND (t.bk_status IS NULL OR t.bk_status = 'ART_ERROR'); GET DIAGNOSTICS v_aff = ROW_COUNT; v_err := v_err + v_aff; RETURN QUERY SELECT v_new, v_err; END; $$; -- uruchomienie: SELECT * FROM sonex.fill_missing_bk_fields(); 2025-11-13 02:31:57.597 CET [5716] LOG: checkpoint starting: time 2025-11-13 02:32:05.190 CET [5716] LOG: checkpoint complete: wrote 69 buffers (0.4%); 0 WAL file(s) added, 0 removed, 0 recycled; write=7.408 s, sync=0.133 s, total=7.594 s; sync files=23, longest=0.018 s, average=0.006 s; distance=348 kB, estimate=348 kB; lsn=7/A8C4A358, redo lsn=7/A8C4A2C8 2025-11-13 02:36:02.132 CET [6028] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-13 02:36:02.132 CET [6028] 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'; 2025-11-13 02:36:57.188 CET [5716] LOG: checkpoint starting: time 2025-11-13 02:36:58.926 CET [5716] LOG: checkpoint complete: wrote 16 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.635 s, sync=0.057 s, total=1.738 s; sync files=10, longest=0.011 s, average=0.006 s; distance=58 kB, estimate=319 kB; lsn=7/A8C58DF0, redo lsn=7/A8C58D98 2025-11-13 02:46:57.930 CET [5716] LOG: checkpoint starting: time 2025-11-13 02:47:01.762 CET [5716] LOG: checkpoint complete: wrote 35 buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=3.694 s, sync=0.089 s, total=3.832 s; sync files=15, longest=0.011 s, average=0.006 s; distance=183 kB, estimate=306 kB; lsn=7/A8C86CE0, redo lsn=7/A8C86C88 2025-11-13 02:51:57.761 CET [5716] LOG: checkpoint starting: time 2025-11-13 02:52:01.365 CET [5716] LOG: checkpoint complete: wrote 33 buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=3.491 s, sync=0.068 s, total=3.605 s; sync files=12, longest=0.009 s, average=0.006 s; distance=176 kB, estimate=293 kB; lsn=7/A8CB2E30, redo lsn=7/A8CB2DD8 2025-11-13 02:56:57.373 CET [5716] LOG: checkpoint starting: time 2025-11-13 02:57:01.014 CET [5716] LOG: checkpoint complete: wrote 33 buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=3.495 s, sync=0.091 s, total=3.642 s; sync files=14, longest=0.012 s, average=0.007 s; distance=136 kB, estimate=277 kB; lsn=7/A8CD4F90, redo lsn=7/A8CD4F38 2025-11-13 03:01:57.014 CET [5716] LOG: checkpoint starting: time 2025-11-13 03:02:02.522 CET [5716] LOG: checkpoint complete: wrote 50 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=5.344 s, sync=0.113 s, total=5.509 s; sync files=18, longest=0.013 s, average=0.007 s; distance=278 kB, estimate=278 kB; lsn=7/A8D1AB28, redo lsn=7/A8D1AA98 2025-11-13 03:04:14.955 CET [7140] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 04:36:11.843 CET [1392] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 04:58:47.145 CET [3736] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 04:59:51.863 CET [6028] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 04:59:55.820 CET [5768] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 04:59:55.945 CET [3048] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 06:04:29.698 CET [3688] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-13 06:04:29.698 CET [3688] 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'; 2025-11-13 06:04:30.488 CET [3268] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-13 06:04:30.488 CET [3268] 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'; 2025-11-13 06:06:57.720 CET [5716] LOG: checkpoint starting: time 2025-11-13 06:06:57.993 CET [5716] LOG: checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.215 s, sync=0.009 s, total=0.274 s; sync files=1, longest=0.009 s, average=0.009 s; distance=15 kB, estimate=252 kB; lsn=7/A8D1E918, redo lsn=7/A8D1E8C0 2025-11-13 06:10:13.830 CET [2320] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-13 06:10:13.830 CET [2320] 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'; 2025-11-13 06:10:34.188 CET [5220] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-13 06:10:34.188 CET [5220] 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'; 2025-11-13 06:10:51.465 CET [7036] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-13 06:10:51.465 CET [7036] 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'; 2025-11-13 06:11:57.995 CET [5716] LOG: checkpoint starting: time 2025-11-13 06:12:02.951 CET [5716] LOG: checkpoint complete: wrote 45 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=4.790 s, sync=0.119 s, total=4.957 s; sync files=19, longest=0.016 s, average=0.007 s; distance=236 kB, estimate=250 kB; lsn=7/A8D59B28, redo lsn=7/A8D59AD0 2025-11-13 06:31:23.458 CET [6728] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 06:31:23.459 CET [4228] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 06:31:23.460 CET [2628] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 06:31:23.461 CET [5392] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 06:31:23.466 CET [3524] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 06:31:23.467 CET [7124] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 06:31:23.474 CET [7072] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 06:31:23.476 CET [3048] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 06:31:57.968 CET [5716] LOG: checkpoint starting: time 2025-11-13 06:32:00.054 CET [5716] LOG: checkpoint complete: wrote 19 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.970 s, sync=0.066 s, total=2.086 s; sync files=7, longest=0.019 s, average=0.010 s; distance=71 kB, estimate=233 kB; lsn=7/A8D6BB40, redo lsn=7/A8D6BAB0 2025-11-13 06:35:03.087 CET [4236] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 06:35:03.087 CET [2500] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 06:35:03.089 CET [3324] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 06:35:03.094 CET [6420] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 06:35:03.096 CET [2964] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 06:35:03.097 CET [5000] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 06:35:03.099 CET [6292] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 06:35:03.100 CET [4388] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 06:35:03.100 CET [2700] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 06:35:03.104 CET [5128] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 06:35:03.105 CET [5044] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 06:36:57.054 CET [5716] LOG: checkpoint starting: time 2025-11-13 06:37:00.669 CET [5716] LOG: checkpoint complete: wrote 33 buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=3.485 s, sync=0.080 s, total=3.616 s; sync files=15, longest=0.009 s, average=0.006 s; distance=219 kB, estimate=231 kB; lsn=7/A8DA2848, redo lsn=7/A8DA27F0 2025-11-13 06:38:00.819 CET [6044] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 06:38:00.820 CET [4544] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 06:38:00.821 CET [6360] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 06:38:00.823 CET [4704] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 06:38:00.833 CET [6468] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 06:38:00.834 CET [2908] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 06:38:00.835 CET [3900] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 06:38:00.839 CET [6604] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 06:38:00.841 CET [6832] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 06:38:00.842 CET [584] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 06:38:00.847 CET [4992] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 06:38:00.849 CET [3668] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 06:38:00.854 CET [1704] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 06:41:57.682 CET [5716] LOG: checkpoint starting: time 2025-11-13 06:41:59.387 CET [5716] LOG: checkpoint complete: wrote 15 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.629 s, sync=0.022 s, total=1.706 s; sync files=2, longest=0.011 s, average=0.011 s; distance=50 kB, estimate=213 kB; lsn=7/A8DAF260, redo lsn=7/A8DAF208 2025-11-13 06:42:54.523 CET [5620] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 06:42:54.524 CET [5364] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 06:42:54.525 CET [7156] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 06:42:54.527 CET [6784] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 06:42:54.532 CET [6108] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 06:42:54.534 CET [1932] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 06:42:54.534 CET [4340] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 06:42:54.536 CET [5780] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 06:44:14.422 CET [3956] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 06:44:14.423 CET [6292] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 06:44:14.424 CET [6472] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 06:44:14.426 CET [6448] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 06:44:14.429 CET [6232] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 06:44:14.430 CET [860] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 06:44:14.436 CET [4492] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 06:44:14.439 CET [6396] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 06:48:17.020 CET [2932] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 06:48:17.020 CET [5336] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 06:48:17.022 CET [2740] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 06:48:17.022 CET [4532] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 06:48:17.023 CET [4148] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 06:48:17.029 CET [944] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 06:48:17.032 CET [6832] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 06:48:17.040 CET [6468] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 06:50:07.462 CET [6580] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 06:50:07.463 CET [3392] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 06:50:07.464 CET [992] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 06:50:07.465 CET [3388] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 06:50:07.472 CET [6932] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 06:50:07.473 CET [3284] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 06:50:07.474 CET [1336] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 06:50:07.477 CET [5608] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 06:50:07.477 CET [5888] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 06:50:07.486 CET [1344] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 06:56:57.397 CET [5716] LOG: checkpoint starting: time 2025-11-13 06:56:57.911 CET [5716] LOG: checkpoint complete: wrote 5 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.431 s, sync=0.036 s, total=0.514 s; sync files=5, longest=0.010 s, average=0.008 s; distance=20 kB, estimate=194 kB; lsn=7/A8DB45C0, redo lsn=7/A8DB4568 2025-11-13 07:01:42.497 CET [6108] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:01:42.501 CET [5756] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:01:42.503 CET [5608] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:01:42.510 CET [4236] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:01:42.513 CET [1932] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:01:42.516 CET [4880] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:01:42.519 CET [5816] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:01:42.523 CET [1964] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:09:15.782 CET [6948] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:09:15.782 CET [112] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:09:15.784 CET [3584] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:09:15.786 CET [116] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:09:15.788 CET [4416] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:09:15.789 CET [6448] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:09:15.790 CET [3128] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:09:15.791 CET [2324] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:09:15.792 CET [5072] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:11:35.349 CET [4312] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-13 07:11:35.349 CET [4312] 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'; 2025-11-13 07:11:35.684 CET [6096] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-13 07:11:35.684 CET [6096] 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'; 2025-11-13 07:11:57.924 CET [5716] LOG: checkpoint starting: time 2025-11-13 07:11:59.889 CET [5716] LOG: checkpoint complete: wrote 18 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.848 s, sync=0.066 s, total=1.966 s; sync files=10, longest=0.012 s, average=0.007 s; distance=73 kB, estimate=182 kB; lsn=7/A8DC6DB8, redo lsn=7/A8DC6D28 2025-11-13 07:13:57.593 CET [6508] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:13:57.593 CET [6116] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:13:57.594 CET [6864] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:13:57.596 CET [5264] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:13:57.600 CET [340] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:13:57.606 CET [3664] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:13:57.612 CET [4144] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:13:57.613 CET [2900] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:13:57.613 CET [4996] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:13:57.614 CET [2668] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:13:57.622 CET [2992] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:13:57.632 CET [5148] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:13:57.637 CET [6932] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:13:57.643 CET [2112] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:16:23.864 CET [6800] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:16:23.866 CET [4476] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:16:23.868 CET [4336] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:16:23.872 CET [6548] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:16:23.880 CET [432] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:16:23.888 CET [2988] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:16:57.895 CET [5716] LOG: checkpoint starting: time 2025-11-13 07:16:58.987 CET [5716] LOG: checkpoint complete: wrote 10 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.986 s, sync=0.058 s, total=1.093 s; sync files=11, longest=0.011 s, average=0.006 s; distance=54 kB, estimate=169 kB; lsn=7/A8DD4838, redo lsn=7/A8DD47E0 2025-11-13 07:21:57.988 CET [5716] LOG: checkpoint starting: time 2025-11-13 07:22:00.296 CET [5716] LOG: checkpoint complete: wrote 21 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=2.191 s, sync=0.072 s, total=2.308 s; sync files=14, longest=0.011 s, average=0.006 s; distance=98 kB, estimate=162 kB; lsn=7/A8DED3B0, redo lsn=7/A8DED320 2025-11-13 07:22:57.320 CET [2700] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:22:57.321 CET [3000] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:22:57.324 CET [2612] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:22:57.324 CET [116] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:22:57.325 CET [5608] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:22:57.326 CET [2740] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:22:57.328 CET [2684] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:22:57.340 CET [4884] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:22:57.341 CET [6860] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:22:57.361 CET [4236] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:22:57.365 CET [2952] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:22:57.366 CET [5340] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:22:57.371 CET [4340] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:22:57.372 CET [4568] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:22:57.372 CET [4156] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:22:57.373 CET [3916] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:22:57.373 CET [3284] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:22:57.374 CET [5164] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:22:57.374 CET [5792] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:22:57.372 CET [5124] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:22:57.374 CET [5036] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:22:57.374 CET [4228] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:22:57.378 CET [6948] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:22:57.381 CET [7072] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:22:57.383 CET [6872] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:22:57.384 CET [6540] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:22:57.386 CET [2668] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:22:57.386 CET [4052] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:25:02.840 CET [5800] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:25:02.841 CET [4160] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:25:02.845 CET [6876] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:25:02.845 CET [3652] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:25:02.849 CET [7136] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:25:02.853 CET [2112] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:25:02.854 CET [3252] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:26:57.295 CET [5716] LOG: checkpoint starting: time 2025-11-13 07:27:01.012 CET [5716] LOG: checkpoint complete: wrote 34 buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=3.594 s, sync=0.072 s, total=3.717 s; sync files=12, longest=0.011 s, average=0.006 s; distance=133 kB, estimate=159 kB; lsn=7/A8E0E778, redo lsn=7/A8E0E720 2025-11-13 07:30:26.626 CET [5640] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:30:26.627 CET [3460] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:30:26.627 CET [2356] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:30:26.628 CET [3224] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:30:26.633 CET [4172] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:30:26.635 CET [6700] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:30:26.638 CET [6664] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:31:57.018 CET [5716] LOG: checkpoint starting: time 2025-11-13 07:31:57.748 CET [5716] LOG: checkpoint complete: wrote 7 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.656 s, sync=0.031 s, total=0.730 s; sync files=5, longest=0.010 s, average=0.007 s; distance=23 kB, estimate=145 kB; lsn=7/A8E14758, redo lsn=7/A8E14700 2025-11-13 07:35:00.610 CET [460] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-13 07:35:00.610 CET [460] 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'; 2025-11-13 07:35:11.545 CET [4396] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-13 07:35:11.545 CET [4396] 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'; 2025-11-13 07:41:57.743 CET [5716] LOG: checkpoint starting: time 2025-11-13 07:42:01.156 CET [5716] LOG: checkpoint complete: wrote 31 buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=3.283 s, sync=0.081 s, total=3.414 s; sync files=14, longest=0.012 s, average=0.006 s; distance=152 kB, estimate=152 kB; lsn=7/A8E3A9D8, redo lsn=7/A8E3A980 2025-11-13 07:43:35.747 CET [5740] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-13 07:43:35.747 CET [5740] 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'; 2025-11-13 07:44:36.845 CET [4252] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:44:36.847 CET [4552] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:44:36.851 CET [3608] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:44:36.851 CET [388] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:44:36.854 CET [6860] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:44:36.855 CET [4196] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:44:36.856 CET [4608] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:44:36.862 CET [4016] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:44:36.863 CET [560] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:44:36.870 CET [5556] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:44:36.875 CET [6252] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:44:36.876 CET [6512] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:44:36.877 CET [5172] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:44:36.877 CET [4880] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:44:36.878 CET [7040] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:44:36.882 CET [6332] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:44:36.891 CET [928] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:44:36.893 CET [6196] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:44:36.898 CET [5580] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:44:36.899 CET [5640] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:44:36.905 CET [6168] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:44:36.915 CET [5888] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:44:36.937 CET [7080] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:44:36.938 CET [6620] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:44:36.938 CET [656] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:44:36.939 CET [5068] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:44:36.943 CET [6132] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:44:36.961 CET [6744] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:44:36.964 CET [4776] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:44:36.964 CET [3124] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:44:36.968 CET [6976] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:44:36.973 CET [2512] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:44:36.974 CET [6832] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:46:23.937 CET [4864] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:46:23.939 CET [5416] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:46:23.941 CET [4372] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:46:23.942 CET [3368] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:46:23.947 CET [6000] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:46:23.949 CET [2988] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:46:23.950 CET [2756] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 07:46:57.167 CET [5716] LOG: checkpoint starting: time 2025-11-13 07:47:00.006 CET [5716] LOG: checkpoint complete: wrote 26 buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=2.725 s, sync=0.068 s, total=2.839 s; sync files=12, longest=0.010 s, average=0.006 s; distance=143 kB, estimate=151 kB; lsn=7/A8E5E6C8, redo lsn=7/A8E5E670 2025-11-13 08:10:34.272 CET [2320] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 08:10:43.920 CET [3688] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 08:10:48.180 CET [5220] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 08:22:50.217 CET [5412] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 08:22:50.218 CET [6104] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 08:22:50.220 CET [5720] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 08:22:50.222 CET [6000] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 08:22:50.228 CET [6872] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 08:22:50.228 CET [6352] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 08:22:50.230 CET [4124] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 08:22:50.231 CET [2612] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 08:26:25.772 CET [236] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 08:26:25.773 CET [4136] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 08:26:25.774 CET [6116] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 08:26:25.775 CET [5536] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 08:26:25.781 CET [1608] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 08:26:25.781 CET [5584] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 08:29:33.015 CET [4880] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 08:29:33.016 CET [2628] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 08:29:33.017 CET [5808] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 08:29:33.017 CET [1032] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 08:29:33.019 CET [6420] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 08:29:33.023 CET [4004] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 08:36:57.043 CET [5716] LOG: checkpoint starting: time 2025-11-13 08:36:57.679 CET [5716] LOG: checkpoint complete: wrote 6 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.540 s, sync=0.043 s, total=0.636 s; sync files=5, longest=0.015 s, average=0.009 s; distance=21 kB, estimate=138 kB; lsn=7/A8E63D60, redo lsn=7/A8E63D08 2025-11-13 08:39:56.628 CET [4124] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 08:39:56.629 CET [2996] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 08:39:56.631 CET [6852] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 08:39:56.632 CET [6468] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 08:39:56.637 CET [5760] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 08:39:56.639 CET [5336] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 08:39:56.640 CET [6244] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 08:39:56.645 CET [4216] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 08:53:08.077 CET [3644] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-13 08:53:08.077 CET [3644] 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'; 2025-11-13 08:53:27.016 CET [1616] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-13 08:53:27.016 CET [1616] 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'; 2025-11-13 08:53:28.316 CET [6360] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-13 08:53:28.316 CET [6360] 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'; 2025-11-13 08:53:35.513 CET [6776] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-13 08:53:35.513 CET [6776] 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'; 2025-11-13 09:10:17.277 CET [4228] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-13 09:10:17.277 CET [4228] 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'; 2025-11-13 09:11:49.890 CET [6096] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 09:11:57.698 CET [5716] LOG: checkpoint starting: time 2025-11-13 09:12:21.788 CET [5716] LOG: checkpoint complete: wrote 219 buffers (1.3%); 0 WAL file(s) added, 1 removed, 0 recycled; write=23.793 s, sync=0.228 s, total=24.091 s; sync files=52, longest=0.012 s, average=0.005 s; distance=1784 kB, estimate=1784 kB; lsn=7/A9022170, redo lsn=7/A90220E0 2025-11-13 09:15:34.431 CET [5932] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 09:15:34.432 CET [1896] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 09:15:34.438 CET [5112] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 09:15:34.440 CET [4160] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 09:15:34.448 CET [3528] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 09:15:34.448 CET [4188] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 09:15:34.449 CET [5992] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 09:15:34.449 CET [6624] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 09:15:34.450 CET [6800] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 09:15:34.450 CET [3000] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 09:15:34.450 CET [4620] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 09:16:57.780 CET [5716] LOG: checkpoint starting: time 2025-11-13 09:17:03.713 CET [5716] LOG: checkpoint complete: wrote 54 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=5.780 s, sync=0.106 s, total=5.933 s; sync files=17, longest=0.017 s, average=0.007 s; distance=330 kB, estimate=1639 kB; lsn=7/A9074978, redo lsn=7/A90748E8 2025-11-13 09:21:57.715 CET [5716] LOG: checkpoint starting: time 2025-11-13 09:21:58.450 CET [5716] LOG: checkpoint complete: wrote 7 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.655 s, sync=0.034 s, total=0.735 s; sync files=5, longest=0.009 s, average=0.007 s; distance=18 kB, estimate=1477 kB; lsn=7/A9079180, redo lsn=7/A9079128 2025-11-13 09:22:48.791 CET [6240] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 09:22:48.792 CET [1980] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 09:22:48.796 CET [2836] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 09:22:48.796 CET [5496] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 09:22:48.799 CET [7004] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 09:22:48.800 CET [5028] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 09:22:48.800 CET [6064] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 09:22:48.798 CET [4800] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 09:22:48.807 CET [2684] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 09:22:48.809 CET [5516] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 09:22:48.810 CET [5856] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 09:22:48.813 CET [4296] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 09:22:48.816 CET [6296] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 09:22:48.819 CET [1408] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 09:22:48.822 CET [2984] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 09:22:48.834 CET [4628] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 09:22:48.842 CET [3580] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 09:24:42.418 CET [2996] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 09:24:42.419 CET [2440] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 09:24:42.419 CET [5720] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 09:24:42.420 CET [2908] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 09:24:42.428 CET [1112] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 09:24:42.428 CET [6700] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 09:24:42.431 CET [5596] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 09:35:10.877 CET [460] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 09:39:32.960 CET [4396] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 09:43:45.493 CET [4312] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 09:44:41.832 CET [5740] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 09:50:10.354 CET [3268] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 09:50:10.479 CET [7036] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 10:02:11.797 CET [2352] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 10:02:11.804 CET [6168] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 10:02:11.809 CET [6200] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 10:02:11.810 CET [5496] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 10:02:11.811 CET [5728] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 10:02:11.817 CET [1032] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 10:02:11.819 CET [4560] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 10:02:11.821 CET [4916] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 10:02:11.821 CET [6560] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 10:02:11.827 CET [7064] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 10:02:11.828 CET [6436] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 10:02:11.831 CET [5820] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 10:02:11.835 CET [1096] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 10:02:11.837 CET [4984] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 10:02:11.839 CET [400] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 10:02:11.842 CET [7072] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 10:02:11.865 CET [5632] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 10:02:11.865 CET [2300] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 10:02:11.886 CET [2476] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 10:02:11.886 CET [5228] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 10:02:11.897 CET [5176] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 10:02:11.900 CET [576] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 10:02:11.907 CET [2796] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 10:02:11.912 CET [6116] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 10:02:11.913 CET [4248] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 10:03:10.379 CET [6084] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 10:03:10.380 CET [5832] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 10:03:10.382 CET [5956] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 10:03:10.386 CET [2468] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 10:03:10.387 CET [6816] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 10:03:10.387 CET [5588] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 10:03:10.387 CET [3108] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 10:16:49.351 CET [4840] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 10:16:49.352 CET [4668] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 10:16:49.353 CET [5556] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 10:16:49.355 CET [7120] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 10:16:49.355 CET [6592] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 10:16:49.362 CET [2360] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 10:16:49.363 CET [924] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 10:16:49.364 CET [6796] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 10:17:45.758 CET [7012] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 10:17:45.759 CET [432] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 10:17:45.760 CET [5188] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 10:17:45.762 CET [5280] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 10:17:45.767 CET [5908] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 10:17:45.771 CET [2172] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 10:17:45.776 CET [2892] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 10:21:51.907 CET [5000] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 10:21:51.909 CET [4800] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 10:21:51.910 CET [6700] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 10:21:51.915 CET [4492] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 10:21:51.918 CET [5112] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 10:21:51.918 CET [5156] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 10:21:51.919 CET [4336] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 10:21:51.926 CET [1884] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 10:21:51.933 CET [4520] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 10:45:13.215 CET [1080] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 10:45:13.216 CET [3404] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 10:45:13.217 CET [6688] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 10:45:13.217 CET [5364] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 10:45:13.226 CET [4252] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 10:45:13.227 CET [6652] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 10:45:13.228 CET [448] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 10:45:13.230 CET [4836] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 10:45:13.236 CET [2208] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 10:45:13.239 CET [4984] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 10:46:18.419 CET [5848] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 10:46:18.420 CET [1620] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 10:46:18.421 CET [5756] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 10:46:18.422 CET [4620] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 10:46:18.424 CET [3984] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 10:46:18.427 CET [2836] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 10:53:38.401 CET [6360] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 10:53:45.613 CET [6776] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 11:12:06.571 CET [1616] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 11:13:03.230 CET [4228] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 11:26:57.572 CET [5716] LOG: checkpoint starting: time 2025-11-13 11:26:58.908 CET [5716] LOG: checkpoint complete: wrote 12 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.206 s, sync=0.068 s, total=1.337 s; sync files=9, longest=0.014 s, average=0.008 s; distance=46 kB, estimate=1334 kB; lsn=7/A9084AF0, redo lsn=7/A9084A98 2025-11-13 12:20:49.369 CET [6944] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 12:20:49.370 CET [6252] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 12:20:49.372 CET [5288] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 12:20:49.373 CET [5336] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 12:20:49.374 CET [7076] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 12:20:49.381 CET [5892] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 12:20:49.385 CET [6972] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 12:20:49.386 CET [6392] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 12:20:49.388 CET [6276] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 12:20:49.401 CET [4820] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 12:20:49.401 CET [5260] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 12:20:49.405 CET [4388] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 12:56:57.988 CET [5716] LOG: checkpoint starting: time 2025-11-13 12:56:58.516 CET [5716] LOG: checkpoint complete: wrote 5 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.436 s, sync=0.043 s, total=0.529 s; sync files=5, longest=0.012 s, average=0.009 s; distance=4 kB, estimate=1201 kB; lsn=7/A9085E30, redo lsn=7/A9085DD8 2025-11-13 13:01:52.205 CET [4980] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-13 13:01:52.205 CET [4980] 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'; 2025-11-13 13:01:52.207 CET [6464] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-13 13:01:52.207 CET [6464] 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'; 2025-11-13 13:01:57.510 CET [5716] LOG: checkpoint starting: time 2025-11-13 13:01:59.596 CET [5716] LOG: checkpoint complete: wrote 19 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.957 s, sync=0.079 s, total=2.087 s; sync files=12, longest=0.011 s, average=0.007 s; distance=90 kB, estimate=1090 kB; lsn=7/A909C8D8, redo lsn=7/A909C880 2025-11-13 13:02:25.707 CET [2372] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-13 13:02:25.707 CET [2372] 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'; 2025-11-13 13:06:46.895 CET [1544] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 13:06:57.586 CET [5716] LOG: checkpoint starting: time 2025-11-13 13:06:57.756 CET [5716] LOG: checkpoint complete: wrote 1 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.112 s, sync=0.010 s, total=0.170 s; sync files=1, longest=0.010 s, average=0.010 s; distance=8 kB, estimate=982 kB; lsn=7/A909E9B0, redo lsn=7/A909E958 2025-11-13 13:15:45.637 CET [4756] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 13:15:45.734 CET [5040] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 13:15:46.031 CET [6976] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 13:15:46.694 CET [2592] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 13:15:52.047 CET [116] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 13:15:52.664 CET [5692] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 13:15:59.804 CET [5556] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 13:17:06.035 CET [4932] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 13:17:06.036 CET [7136] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 13:17:06.037 CET [4356] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 13:17:06.049 CET [6756] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 13:17:06.049 CET [4844] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 13:17:06.049 CET [4592] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 13:17:06.050 CET [6988] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 13:17:06.051 CET [6212] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 13:17:06.049 CET [5068] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 13:21:57.760 CET [5716] LOG: checkpoint starting: time 2025-11-13 13:21:58.036 CET [5716] LOG: checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.217 s, sync=0.014 s, total=0.277 s; sync files=2, longest=0.009 s, average=0.007 s; distance=8 kB, estimate=884 kB; lsn=7/A90A0AF8, redo lsn=7/A90A0AA0 2025-11-13 13:46:22.506 CET [2372] ERROR: syntax error at or near "contnr" at character 1 2025-11-13 13:46:22.506 CET [2372] STATEMENT: contnr 2025-11-13 13:46:29.643 CET [2372] ERROR: syntax error at or near "palid" at character 1 2025-11-13 13:46:29.643 CET [2372] STATEMENT: palid 2025-11-13 13:46:32.620 CET [2372] ERROR: syntax error at or near "0068076153" at character 1 2025-11-13 13:46:32.620 CET [2372] STATEMENT: 0068076153 2025-11-13 13:50:21.863 CET [1028] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-13 13:50:21.863 CET [1028] 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'; 2025-11-13 13:50:42.904 CET [4500] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-13 13:50:42.904 CET [4500] 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'; 2025-11-13 13:50:43.027 CET [6604] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-13 13:50:43.027 CET [6604] 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'; 2025-11-13 13:50:43.345 CET [1128] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-13 13:50:43.345 CET [1128] 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'; 2025-11-13 13:50:43.414 CET [1128] ERROR: function wmst.containerstackingresult() does not exist at character 15 2025-11-13 13:50:43.414 CET [1128] HINT: No function matches the given name and argument types. You might need to add explicit type casts. 2025-11-13 13:50:43.414 CET [1128] STATEMENT: SELECT * FROM wmst.containerstackingresult(); 2025-11-13 13:51:04.725 CET [1128] ERROR: cross-database references are not implemented: "wmst.wmst.containerstackingtarget" at character 15 2025-11-13 13:51:04.725 CET [1128] STATEMENT: SELECT * FROM wmst.wmst.containerstackingtarget Limit 10; 2025-11-13 13:51:57.062 CET [5716] LOG: checkpoint starting: time 2025-11-13 13:51:57.336 CET [5716] LOG: checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.215 s, sync=0.009 s, total=0.275 s; sync files=1, longest=0.009 s, average=0.009 s; distance=15 kB, estimate=797 kB; lsn=7/A90A4800, redo lsn=7/A90A47A8 2025-11-13 13:52:35.794 CET [6544] WARNING: PID 6360 is not a PostgreSQL backend process 2025-11-13 13:52:40.492 CET [2668] WARNING: PID 4228 is not a PostgreSQL backend process 2025-11-13 14:44:52.146 CET [3416] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 14:44:52.147 CET [6300] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 14:44:52.148 CET [4992] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 14:44:52.150 CET [4388] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 14:44:52.152 CET [4252] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 14:44:52.162 CET [6484] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 14:44:52.163 CET [412] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 14:44:52.167 CET [6472] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 14:44:52.168 CET [5140] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 14:44:52.168 CET [4884] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 14:44:52.169 CET [2952] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 15:11:57.423 CET [5716] LOG: checkpoint starting: time 2025-11-13 15:12:00.837 CET [5716] LOG: checkpoint complete: wrote 31 buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=3.287 s, sync=0.076 s, total=3.415 s; sync files=9, longest=0.020 s, average=0.009 s; distance=160 kB, estimate=733 kB; lsn=7/A90CC8D8, redo lsn=7/A90CC880 2025-11-13 15:16:57.828 CET [5716] LOG: checkpoint starting: time 2025-11-13 15:17:00.536 CET [5716] LOG: checkpoint complete: wrote 25 buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=2.619 s, sync=0.048 s, total=2.709 s; sync files=8, longest=0.012 s, average=0.006 s; distance=164 kB, estimate=676 kB; lsn=7/A90F58D8, redo lsn=7/A90F5880 2025-11-13 15:18:22.990 CET [6020] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 15:18:23.512 CET [6764] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 15:18:34.339 CET [5344] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 15:18:34.463 CET [4652] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 15:18:34.791 CET [2868] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 15:18:39.064 CET [7132] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 15:18:41.712 CET [388] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 15:50:31.969 CET [6464] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 15:51:52.910 CET [1128] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 15:52:45.853 CET [6604] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 16:01:57.549 CET [5716] LOG: checkpoint starting: time 2025-11-13 16:01:59.477 CET [5716] LOG: checkpoint complete: wrote 17 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.851 s, sync=0.025 s, total=1.929 s; sync files=2, longest=0.018 s, average=0.013 s; distance=59 kB, estimate=615 kB; lsn=7/A91045E0, redo lsn=7/A9104588 2025-11-13 16:28:52.285 CET [2372] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 16:36:57.477 CET [5716] LOG: checkpoint starting: time 2025-11-13 16:36:57.989 CET [5716] LOG: checkpoint complete: wrote 5 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.431 s, sync=0.031 s, total=0.513 s; sync files=5, longest=0.008 s, average=0.007 s; distance=6 kB, estimate=554 kB; lsn=7/A9105EF8, redo lsn=7/A9105EA0 2025-11-13 16:41:57.983 CET [5716] LOG: checkpoint starting: time 2025-11-13 16:41:59.820 CET [5716] LOG: checkpoint complete: wrote 17 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.741 s, sync=0.043 s, total=1.838 s; sync files=7, longest=0.009 s, average=0.007 s; distance=50 kB, estimate=503 kB; lsn=7/A9112708, redo lsn=7/A91126B0 2025-11-13 16:46:57.814 CET [5716] LOG: checkpoint starting: time 2025-11-13 16:46:59.729 CET [5716] LOG: checkpoint complete: wrote 18 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.846 s, sync=0.022 s, total=1.915 s; sync files=3, longest=0.013 s, average=0.008 s; distance=125 kB, estimate=466 kB; lsn=7/A9131C40, redo lsn=7/A9131BE8 2025-11-13 16:49:33.413 CET [6856] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 16:49:34.170 CET [6864] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-13 16:49:34.170 CET [6864] 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'; 2025-11-13 16:49:34.696 CET [1360] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-13 16:49:34.696 CET [1360] 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'; 2025-11-13 16:49:35.042 CET [6244] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-13 16:49:35.042 CET [6244] 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'; 2025-11-13 16:50:42.688 CET [6244] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 16:50:42.688 CET [1360] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 16:51:57.734 CET [5716] LOG: checkpoint starting: time 2025-11-13 16:51:58.109 CET [5716] LOG: checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.315 s, sync=0.008 s, total=0.375 s; sync files=1, longest=0.008 s, average=0.008 s; distance=19 kB, estimate=421 kB; lsn=7/A9136C38, redo lsn=7/A9136BE0 2025-11-13 17:07:16.746 CET [1884] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 17:07:17.325 CET [2976] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 17:10:57.205 CET [3796] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 17:10:57.380 CET [5192] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 17:10:57.684 CET [5624] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 17:11:01.258 CET [5340] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 17:11:05.030 CET [2920] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 17:11:14.922 CET [5992] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-13 17:12:02.636 CET [6328] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host.