2025-11-19 04:50:03.013 CET [4124] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-19 04:50:03.013 CET [4124] 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-19 04:50:03.405 CET [2324] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-19 04:50:03.405 CET [2324] 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-19 04:50:12.126 CET [4788] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-19 04:50:12.126 CET [4788] 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-19 04:51:19.008 CET [4124] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-19 04:51:19.009 CET [4788] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-19 04:51:40.104 CET [4732] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-19 04:51:40.104 CET [4732] 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-19 04:51:40.449 CET [704] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-19 04:51:40.449 CET [704] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2025-11-19 04:51:40.593 CET [2796] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-19 04:51:40.593 CET [2796] 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-19 04:51:41.246 CET [4508] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-19 04:51:41.246 CET [4508] 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-19 04:52:00.721 CET [4356] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-19 04:52:00.721 CET [4356] 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-19 04:52:01.326 CET [7112] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-19 04:52:01.326 CET [7112] 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-19 04:52:01.344 CET [6944] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-19 04:52:01.344 CET [6944] 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-19 04:52:04.268 CET [5716] LOG: checkpoint starting: time 2025-11-19 04:52:07.782 CET [5716] LOG: checkpoint complete: wrote 32 buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=3.381 s, sync=0.074 s, total=3.515 s; sync files=10, longest=0.020 s, average=0.008 s; distance=213 kB, estimate=213 kB; lsn=7/AA111220, redo lsn=7/AA1111C8 2025-11-19 04:53:01.327 CET [6472] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-19 04:53:01.327 CET [6472] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2025-11-19 04:55:22.839 CET [6944] ERROR: syntax error at or near "p_1" at character 5721 2025-11-19 04:55:22.839 CET [6944] STATEMENT: CREATE OR REPLACE VIEW sonex.v_shipbk_source AS SELECT p.jobid, p.n1 AS rownr, p.n3 AS seq, p.a27 AS conumber, p.a28 AS palnumber, p.a32 AS palid, p.a29 AS bkpalnumber, p.a39 AS collobarcode, p.a30 AS expdaydock, p.a36 AS roaclassification, recip_data.name AS recipientname, recip_data.street AS recipientstreet, recip_data.housenr AS recipienthousenr, recip_data.att AS recipientatt, recip_data.town AS recipienttown, recip_data.pcode AS recipientzipcode, recip_data.country AS recipientcountry, recip_data.tel AS recipienttel, recip_data.email AS recipientemail, p.a11 AS sendername, p.a12 AS senderstreet, p.a13 AS senderhousenr, p.a16 AS senderown, p.a15 AS senderzipcode, p.a14 AS sendercountry, COALESCE(c.items, e.items, '[]'::jsonb) AS items FROM ( SELECT p_1.jobid, p_1.d, p_1.line, p_1.n1, p_1.n2, p_1.n3, p_1.n4, p_1.n5, p_1.n6, p_1.n7, p_1.n8, p_1.n9, p_1.n10, p_1.n11, p_1.n12, p_1.n13, p_1.n14, p_1.n15, p_1.n16, p_1.n17, p_1.n18, p_1.n19, p_1.n20, p_1.n21, p_1.n22, p_1.n23, p_1.n24, p_1.n25, p_1.n26, p_1.n27, p_1.n28, p_1.n29, p_1.n30, p_1.n31, p_1.n32, p_1.n33, p_1.n34, p_1.n35, p_1.n36, p_1.n37, p_1.n38, p_1.n39, p_1.n40, p_1.n41, p_1.n42, p_1.n43, p_1.n44, p_1.n45, p_1.n46, p_1.n47, p_1.n48, p_1.n49, p_1.n50, p_1.n51, p_1.n52, p_1.n53, p_1.n54, p_1.n55, p_1.n56, p_1.n57, p_1.n58, p_1.n59, p_1.n60, p_1.n61, p_1.n62, p_1.n63, p_1.n64, p_1.n65, p_1.n66, p_1.n67, p_1.n68, p_1.n69, p_1.n70, p_1.n71, p_1.n72, p_1.n73, p_1.n74, p_1.n75, p_1.a1, p_1.a2, p_1.a3, p_1.a4, p_1.a5, p_1.a6, p_1.a7, p_1.a8, p_1.a9, p_1.a10, p_1.a11, p_1.a12, p_1.a13, p_1.a14, p_1.a15, p_1.a16, p_1.a17, p_1.a18, p_1.a19, p_1.a20, p_1.a21, p_1.a22, p_1.a23, p_1.a24, p_1.a25, p_1.a26, p_1.a27, p_1.a28, p_1.a29, p_1.a30, p_1.a31, p_1.a32, p_1.a33, p_1.a34, p_1.a35, p_1.a36, p_1.a37, p_1.a38, p_1.a39, p_1.a40, p_1.a41, p_1.a42, p_1.a43, p_1.a44, p_1.a45, p_1.a46, p_1.a47, p_1.a48, p_1.a49, p_1.a50, p_1.a51, p_1.a52, p_1.a53, p_1.a54, p_1.a55, p_1.a56, p_1.a57, p_1.a58, p_1.a59, p_1.a60, p_1.a61, p_1.a62, p_1.a63, p_1.a64, p_1.a65, p_1.a66, p_1.a67, p_1.a68, p_1.a69, p_1.a70, p_1.a71, p_1.a72, p_1.a73, p_1.a74, p_1.a75, p_1.d1, p_1.d2, p_1.d3, p_1.d4, p_1.d5, p_1.d6, p_1.d7, p_1.d8, p_1.d9, p_1.d10, p_1.d11, p_1.d12, p_1.d13, p_1.d14, p_1.d15, p_1.d16, p_1.d17, p_1.d18, p_1.d19, p_1.d20, p_1.d21, p_1.d22, p_1.d23, p_1.d24, p_1.d25, p_1.d26, p_1.d27, p_1.d28, p_1.d29, p_1.d30, p_1.d31, p_1.d32, p_1.d33, p_1.d34, p_1.d35, p_1.d36, p_1.d37, p_1.d38, p_1.d39, p_1.d40, p_1.d41, p_1.d42, p_1.d43, p_1.d44, p_1.d45, p_1.d46, p_1.d47, p_1.d48, p_1.d49, p_1.d50, p_1.a76, p_1.a77, p_1.a78, p_1.a79, p_1.a80, p_1.a81, p_1.a82, p_1.a83, p_1.a84, p_1.a85, p_1.a86, p_1.a87, p_1.a88, p_1.a89, p_1.a90, p_1.a91, p_1.a92, p_1.a93, p_1.a94, p_1.a95, p_1.a96, p_1.a97, p_1.a98, p_1.a99, p_1.a100 FROM wms.pqueuesqldata p_1 WHERE p_1.a38::text = 'SHIPBK'::text p_1.a36::text = 'NO_SHIP_U'::text AND NOT (EXISTS ( SELECT 1 FROM sonex.shipbk_print_jobs j WHERE j.job_id = p_1.jobid))) p LEFT JOIN LATERAL ( SELECT rcp.name, rcp.att, rcp.town, rcp.pcode, rcp.country, rcp.email, rcp.tel, CASE WHEN rcp.address::text ~ '\s+\d'::text THEN regexp_replace(rcp.address::text, '\s+\d.*$'::text, ''::text)::character varying ELSE rcp.address END AS street, CASE WHEN rcp.address::text ~ '\s+\d'::text THEN regexp_replace(rcp.address::text, '^.*\s(\d.*)$'::text, '\1'::text) ELSE NULL::text END AS housenr FROM wms.recip rcp WHERE rcp.code::text = replace(p.a27::text, 'BK'::text, 'W'::text) LIMIT 1) recip_data ON true LEFT JOIN LATERAL ( SELECT jsonb_agg(jsonb_build_object('art', x.artnr, 'qty', x.qy, 'width', x.width, 'height', x.height, 'length', x.length, 'gweight', x.gweight)) AS items FROM ( SELECT ct.artnr, sum(ct.quantity) AS qy, max(s.width) AS width, max(s.height) AS height, max(s.length) AS length, max(s.weight) AS gweight FROM wms.cont ct LEFT JOIN sonex.shipbk_package_size s ON s.article_number = ct.artnr::text AND s.part_number = CASE WHEN "right"(p.a29::text, 2) = '_2'::text THEN 2 WHEN "right"(p.a29::text, 2) = '_3'::text THEN 3 ELSE 1 END WHERE ct.collobarcode::text = p.a39::text GROUP BY ct.artnr) x) c ON true LEFT JOIN LATERAL ( SELECT jsonb_agg(jsonb_build_object('art', x.artnr, 'qty', x.qy, 'width', x.width, 'height', x.height, 'length', x.length, 'gweight', x.gweight)) AS items FROM ( SELECT ct.artnr, sum(ct.qty) AS qy, max(s.width) AS width, max(s.height) AS height, max(s.length) AS length, max(s.weight) AS gweight FROM ltt.expedvw ct LEFT JOIN sonex.shipbk_package_size s ON s.article_number = ct.artnr::text AND s.part_number = CASE WHEN "right"(p.a29::text, 2) = '_2'::text THEN 2 WHEN "right"(p.a29::text, 2) = '_3'::text THEN 3 ELSE 1 END WHERE ct.collobarcode::text = p.a39::text GROUP BY ct.artnr) x) e ON true; 2025-11-19 04:56:27.579 CET [6444] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-19 04:56:27.579 CET [6444] 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-19 04:57:04.787 CET [5716] LOG: checkpoint starting: time 2025-11-19 04:57:13.023 CET [5716] LOG: checkpoint complete: wrote 75 buffers (0.5%); 0 WAL file(s) added, 0 removed, 0 recycled; write=8.095 s, sync=0.093 s, total=8.237 s; sync files=15, longest=0.012 s, average=0.007 s; distance=299 kB, estimate=299 kB; lsn=7/AA15BEE0, redo lsn=7/AA15BE50 2025-11-19 04:58:24.342 CET [4560] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-19 04:58:24.342 CET [4560] 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-19 04:59:30.737 CET [6656] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-19 04:59:30.737 CET [6656] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2025-11-19 04:59:45.386 CET [3508] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-19 04:59:45.386 CET [3508] 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-19 05:02:04.033 CET [5716] LOG: checkpoint starting: time 2025-11-19 05:02:05.213 CET [5716] LOG: checkpoint complete: wrote 11 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.092 s, sync=0.043 s, total=1.181 s; sync files=6, longest=0.015 s, average=0.008 s; distance=37 kB, estimate=272 kB; lsn=7/AA165328, redo lsn=7/AA1652D0 2025-11-19 05:07:04.216 CET [5716] LOG: checkpoint starting: time 2025-11-19 05:07:04.732 CET [5716] LOG: checkpoint complete: wrote 5 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.433 s, sync=0.033 s, total=0.516 s; sync files=4, longest=0.014 s, average=0.009 s; distance=15 kB, estimate=247 kB; lsn=7/AA168FD0, redo lsn=7/AA168F78 2025-11-19 05:32:04.739 CET [5716] LOG: checkpoint starting: time 2025-11-19 05:32:04.925 CET [5716] LOG: checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.098 s, sync=0.017 s, total=0.186 s; sync files=2, longest=0.010 s, average=0.009 s; distance=1 kB, estimate=222 kB; lsn=7/AA169618, redo lsn=7/AA1695C0 2025-11-19 05:47:04.915 CET [5716] LOG: checkpoint starting: time 2025-11-19 05:47:05.089 CET [5716] LOG: checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.108 s, sync=0.013 s, total=0.175 s; sync files=2, longest=0.008 s, average=0.007 s; distance=2 kB, estimate=200 kB; lsn=7/AA169EF0, redo lsn=7/AA169E60 2025-11-19 05:52:04.077 CET [5716] LOG: checkpoint starting: time 2025-11-19 05:52:04.246 CET [5716] LOG: checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.107 s, sync=0.015 s, total=0.169 s; sync files=2, longest=0.009 s, average=0.008 s; distance=3 kB, estimate=180 kB; lsn=7/AA16AB90, redo lsn=7/AA16AB38 2025-11-19 06:06:35.583 CET [6752] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-19 06:06:35.583 CET [6752] 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-19 06:07:04.243 CET [5716] LOG: checkpoint starting: time 2025-11-19 06:07:04.639 CET [5716] LOG: checkpoint complete: wrote 4 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.320 s, sync=0.024 s, total=0.396 s; sync files=3, longest=0.013 s, average=0.008 s; distance=15 kB, estimate=164 kB; lsn=7/AA16EAF8, redo lsn=7/AA16EAA0 2025-11-19 06:12:04.639 CET [5716] LOG: checkpoint starting: time 2025-11-19 06:12:05.603 CET [5716] LOG: checkpoint complete: wrote 9 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.878 s, sync=0.035 s, total=0.965 s; sync files=5, longest=0.015 s, average=0.007 s; distance=50 kB, estimate=152 kB; lsn=7/AA17B6E0, redo lsn=7/AA17B688 2025-11-19 06:17:04.609 CET [5716] LOG: checkpoint starting: time 2025-11-19 06:17:05.021 CET [5716] LOG: checkpoint complete: wrote 4 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.326 s, sync=0.034 s, total=0.413 s; sync files=4, longest=0.011 s, average=0.009 s; distance=21 kB, estimate=139 kB; lsn=7/AA180EA8, redo lsn=7/AA180E50 2025-11-19 06:22:04.008 CET [5716] LOG: checkpoint starting: time 2025-11-19 06:22:04.302 CET [5716] LOG: checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.224 s, sync=0.025 s, total=0.294 s; sync files=3, longest=0.013 s, average=0.009 s; distance=12 kB, estimate=127 kB; lsn=7/AA183F10, redo lsn=7/AA183EB8 2025-11-19 06:27:04.301 CET [5716] LOG: checkpoint starting: time 2025-11-19 06:27:08.364 CET [5716] LOG: checkpoint complete: wrote 37 buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=3.943 s, sync=0.075 s, total=4.064 s; sync files=11, longest=0.012 s, average=0.007 s; distance=194 kB, estimate=194 kB; lsn=7/AA1B4918, redo lsn=7/AA1B4888 2025-11-19 06:32:04.356 CET [5716] LOG: checkpoint starting: time 2025-11-19 06:32:05.078 CET [5716] LOG: checkpoint complete: wrote 7 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.658 s, sync=0.019 s, total=0.723 s; sync files=3, longest=0.009 s, average=0.007 s; distance=28 kB, estimate=177 kB; lsn=7/AA1BBB48, redo lsn=7/AA1BBAF0 2025-11-19 06:47:04.098 CET [5716] LOG: checkpoint starting: time 2025-11-19 06:47:04.291 CET [5716] LOG: checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.112 s, sync=0.019 s, total=0.193 s; sync files=2, longest=0.011 s, average=0.010 s; distance=7 kB, estimate=160 kB; lsn=7/AA1BD910, redo lsn=7/AA1BD8B8 2025-11-19 06:52:04.290 CET [5716] LOG: checkpoint starting: time 2025-11-19 06:52:05.133 CET [5716] LOG: checkpoint complete: wrote 8 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.752 s, sync=0.037 s, total=0.843 s; sync files=7, longest=0.009 s, average=0.006 s; distance=3 kB, estimate=145 kB; lsn=7/AA1BE868, redo lsn=7/AA1BE810 2025-11-19 06:57:04.134 CET [5716] LOG: checkpoint starting: time 2025-11-19 06:57:04.870 CET [5716] LOG: checkpoint complete: wrote 7 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.649 s, sync=0.031 s, total=0.736 s; sync files=6, longest=0.008 s, average=0.006 s; distance=4 kB, estimate=131 kB; lsn=7/AA1BFAA0, redo lsn=7/AA1BFA48 2025-11-19 06:59:36.597 CET [4356] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-19 06:59:57.345 CET [3508] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-19 07:12:04.869 CET [5716] LOG: checkpoint starting: time 2025-11-19 07:12:05.045 CET [5716] LOG: checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.105 s, sync=0.020 s, total=0.176 s; sync files=2, longest=0.013 s, average=0.010 s; distance=3 kB, estimate=118 kB; lsn=7/AA1C07E0, redo lsn=7/AA1C0788 2025-11-19 07:43:24.490 CET [2792] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-19 07:43:24.490 CET [2792] 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-19 07:43:24.508 CET [76] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-19 07:43:24.508 CET [76] 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-19 07:43:24.855 CET [3652] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-19 07:43:24.855 CET [3652] 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-19 07:44:03.531 CET [6944] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-19 07:44:03.765 CET [4560] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-19 08:01:29.409 CET [400] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-19 08:01:29.409 CET [400] 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-19 08:01:29.470 CET [400] ERROR: relation "wms.RcpOrd" does not exist at character 55 2025-11-19 08:01:29.470 CET [400] STATEMENT: SELECT DISTINCT TRIM(val) AS classification_part FROM wms."RcpOrd", unnest(string_to_array(classification, ':')) AS val ORDER BY classification_part; 2025-11-19 08:01:39.060 CET [400] ERROR: column "classification" does not exist at character 95 2025-11-19 08:01:39.060 CET [400] STATEMENT: SELECT DISTINCT TRIM(val) AS classification_part FROM wms.RcpOrd, unnest(string_to_array(classification, ':')) AS val ORDER BY classification_part; 2025-11-19 08:02:10.140 CET [400] ERROR: relation "wms.RcpOrd" does not exist at character 55 2025-11-19 08:02:10.140 CET [400] STATEMENT: SELECT DISTINCT TRIM(val) AS classification_part FROM wms."RcpOrd", unnest(string_to_array("Classification", ':')) AS val ORDER BY classification_part; 2025-11-19 08:02:31.727 CET [400] ERROR: column "Classification" does not exist at character 95 2025-11-19 08:02:31.727 CET [400] STATEMENT: SELECT DISTINCT TRIM(val) AS classification_part FROM wms.rcpord, unnest(string_to_array("Classification", ':')) AS val ORDER BY classification_part; 2025-11-19 08:02:38.254 CET [400] ERROR: column "classification" does not exist at character 95 2025-11-19 08:02:38.254 CET [400] STATEMENT: SELECT DISTINCT TRIM(val) AS classification_part FROM wms.rcpord, unnest(string_to_array("classification", ':')) AS val ORDER BY classification_part; 2025-11-19 08:02:43.199 CET [400] ERROR: column "classification" does not exist at character 95 2025-11-19 08:02:43.199 CET [400] STATEMENT: SELECT DISTINCT TRIM(val) AS classification_part FROM wms.rcpord, unnest(string_to_array(classification, ':')) AS val ORDER BY classification_part; 2025-11-19 08:06:47.142 CET [6752] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-19 08:15:40.692 CET [3652] ERROR: syntax error at or near "ALL" at character 333 2025-11-19 08:15:40.692 CET [3652] STATEMENT: SELECT COUNT(ROA.conumber) AS orders, ROA.artnr, MAX(ROA.packlistdescr) AS description, MAX(ROA.classification) AS classification, SUM(ROA.qordered) AS ordered FROM wms.RcpOrd RO JOIN wms.RcpOrdArt ROA ON RO.Conumber = ROA.Conumber WHERE RO.OrdType = 'WEB' AND RO.State = 'A' AND ROA.dspwaveid IS NULL AND ILIKE ALL (ARRAY['%SHIP_UNIT%', '%BK%'] AND NOT ILIKE ALL (ARRAY['%PACK%']) AND (ROA.classification LIKE 'SHIP_UNIT%' AND ROA.classification LIKE '%BK%') GROUP BY ROA.artnr ORDER BY ROA.artnr DESC; 2025-11-19 08:16:20.775 CET [3652] ERROR: syntax error at or near "GROUP" at character 519 2025-11-19 08:16:20.775 CET [3652] STATEMENT: SELECT COUNT(ROA.conumber) AS orders, ROA.artnr, MAX(ROA.packlistdescr) AS description, MAX(ROA.classification) AS classification, SUM(ROA.qordered) AS ordered FROM wms.RcpOrd RO JOIN wms.RcpOrdArt ROA ON RO.Conumber = ROA.Conumber WHERE RO.OrdType = 'WEB' AND RO.State = 'A' AND ROA.dspwaveid IS NULL AND ROA.classification ILIKE ALL (ARRAY['%SHIP_UNIT%', '%BK%'] AND ROA.classification NOT ILIKE ALL (ARRAY['%PACK%']) AND (ROA.classification LIKE 'SHIP_UNIT%' AND ROA.classification LIKE '%BK%') GROUP BY ROA.artnr ORDER BY ROA.artnr DESC; 2025-11-19 08:16:33.498 CET [3652] ERROR: syntax error at or near "GROUP" at character 441 2025-11-19 08:16:33.498 CET [3652] STATEMENT: SELECT COUNT(ROA.conumber) AS orders, ROA.artnr, MAX(ROA.packlistdescr) AS description, MAX(ROA.classification) AS classification, SUM(ROA.qordered) AS ordered FROM wms.RcpOrd RO JOIN wms.RcpOrdArt ROA ON RO.Conumber = ROA.Conumber WHERE RO.OrdType = 'WEB' AND RO.State = 'A' AND ROA.dspwaveid IS NULL AND ROA.classification ILIKE ALL (ARRAY['%SHIP_UNIT%', '%BK%'] AND ROA.classification NOT ILIKE ALL (ARRAY['%PACK%']) GROUP BY ROA.artnr ORDER BY ROA.artnr DESC; 2025-11-19 08:16:34.425 CET [3652] ERROR: syntax error at or near "GROUP" at character 441 2025-11-19 08:16:34.425 CET [3652] STATEMENT: SELECT COUNT(ROA.conumber) AS orders, ROA.artnr, MAX(ROA.packlistdescr) AS description, MAX(ROA.classification) AS classification, SUM(ROA.qordered) AS ordered FROM wms.RcpOrd RO JOIN wms.RcpOrdArt ROA ON RO.Conumber = ROA.Conumber WHERE RO.OrdType = 'WEB' AND RO.State = 'A' AND ROA.dspwaveid IS NULL AND ROA.classification ILIKE ALL (ARRAY['%SHIP_UNIT%', '%BK%'] AND ROA.classification NOT ILIKE ALL (ARRAY['%PACK%']) GROUP BY ROA.artnr ORDER BY ROA.artnr DESC; 2025-11-19 09:47:04.122 CET [5716] LOG: checkpoint starting: time 2025-11-19 09:47:04.286 CET [5716] LOG: checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.108 s, sync=0.013 s, total=0.164 s; sync files=2, longest=0.007 s, average=0.007 s; distance=7 kB, estimate=107 kB; lsn=7/AA1C2780, redo lsn=7/AA1C2728 2025-11-19 09:47:34.252 CET [6300] ERROR: syntax error at or near "NULLAND" at character 382 2025-11-19 09:47:34.252 CET [6300] STATEMENT: SELECT COUNT(ROA.conumber) AS orders, ROA.artnr, MAX(ROA.packlistdescr) AS description, MAX(ROA.classification) AS classification, SUM(ROA.qordered) AS ordered FROM wms.RcpOrd RO JOIN wms.RcpOrdArt ROA ON RO.Conumber = ROA.Conumber WHERE RO.OrdType = 'WEB' AND RO.State = 'A' AND ROA.dspwaveid IS NULLAND ROA.classification ILIKE ALL ($1) AND ROA.classification NOT ILIKE ALL ($2) GROUP BY ROA.artnr ORDER BY ROA.artnr DESC 2025-11-19 09:50:28.033 CET [4144] ERROR: syntax error at or near "NULLAND" at character 382 2025-11-19 09:50:28.033 CET [4144] STATEMENT: SELECT COUNT(ROA.conumber) AS orders, ROA.artnr, MAX(ROA.packlistdescr) AS description, MAX(ROA.classification) AS classification, SUM(ROA.qordered) AS ordered FROM wms.RcpOrd RO JOIN wms.RcpOrdArt ROA ON RO.Conumber = ROA.Conumber WHERE RO.OrdType = 'WEB' AND RO.State = 'A' AND ROA.dspwaveid IS NULLAND ROA.classification ILIKE ALL ($1) AND ROA.classification NOT ILIKE ALL ($2) GROUP BY ROA.artnr ORDER BY ROA.artnr DESC 2025-11-19 09:51:36.884 CET [6004] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-19 09:52:04.288 CET [5716] LOG: checkpoint starting: time 2025-11-19 09:52:06.386 CET [5716] LOG: checkpoint complete: wrote 19 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.955 s, sync=0.094 s, total=2.099 s; sync files=11, longest=0.021 s, average=0.009 s; distance=81 kB, estimate=104 kB; lsn=7/AA1D6F18, redo lsn=7/AA1D6EC0 2025-11-19 09:53:06.913 CET [2512] ERROR: syntax error at or near "NULLAND" at character 382 2025-11-19 09:53:06.913 CET [2512] STATEMENT: SELECT COUNT(ROA.conumber) AS orders, ROA.artnr, MAX(ROA.packlistdescr) AS description, MAX(ROA.classification) AS classification, SUM(ROA.qordered) AS ordered FROM wms.RcpOrd RO JOIN wms.RcpOrdArt ROA ON RO.Conumber = ROA.Conumber WHERE RO.OrdType = 'WEB' AND RO.State = 'A' AND ROA.dspwaveid IS NULLAND ROA.classification ILIKE ALL ($1) AND ROA.classification NOT ILIKE ALL ($2) GROUP BY ROA.artnr ORDER BY ROA.artnr DESC 2025-11-19 09:57:04.378 CET [5716] LOG: checkpoint starting: time 2025-11-19 09:57:04.545 CET [5716] LOG: checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.108 s, sync=0.015 s, total=0.167 s; sync files=2, longest=0.010 s, average=0.008 s; distance=2 kB, estimate=94 kB; lsn=7/AA1D7A00, redo lsn=7/AA1D79A8 2025-11-19 09:57:48.145 CET [7008] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-19 09:57:48.145 CET [7008] 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-19 09:59:20.936 CET [6052] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-19 09:59:20.936 CET [6052] 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-19 09:59:58.981 CET [1852] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-19 09:59:58.981 CET [1852] 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-19 10:01:15.269 CET [3228] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-19 10:01:15.270 CET [4880] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-19 10:01:39.134 CET [76] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-19 10:03:26.047 CET [400] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-19 10:07:04.551 CET [5716] LOG: checkpoint starting: time 2025-11-19 10:07:04.717 CET [5716] LOG: checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.105 s, sync=0.013 s, total=0.167 s; sync files=2, longest=0.007 s, average=0.007 s; distance=3 kB, estimate=85 kB; lsn=7/AA1D8820, redo lsn=7/AA1D87C8 2025-11-19 10:12:04.707 CET [5716] LOG: checkpoint starting: time 2025-11-19 10:12:05.120 CET [5716] LOG: checkpoint complete: wrote 4 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.339 s, sync=0.027 s, total=0.413 s; sync files=4, longest=0.008 s, average=0.007 s; distance=11 kB, estimate=78 kB; lsn=7/AA1DB768, redo lsn=7/AA1DB710 2025-11-19 10:17:04.120 CET [5716] LOG: checkpoint starting: time 2025-11-19 10:17:04.286 CET [5716] LOG: checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.107 s, sync=0.014 s, total=0.167 s; sync files=2, longest=0.009 s, average=0.007 s; distance=4 kB, estimate=70 kB; lsn=7/AA1DCA38, redo lsn=7/AA1DC9E0 2025-11-19 10:24:08.707 CET [5096] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-19 10:25:41.738 CET [652] ERROR: syntax error at or near "%" at character 406 2025-11-19 10:25:41.738 CET [652] STATEMENT: SELECT COUNT(ROA.conumber) AS orders, ROA.artnr, MAX(ROA.packlistdescr) AS description, MAX(ROA.classification) AS classification, SUM(ROA.qordered) AS ordered FROM wms.RcpOrd RO JOIN wms.RcpOrdArt ROA ON RO.Conumber = ROA.Conumber WHERE RO.OrdType = 'WEB' AND RO.State = 'A' AND ROA.dspwaveid IS NULL AND ROA.artnr LIKE %$1% AND ROA.classification ILIKE ALL($2) GROUP BY ROA.artnr ORDER BY ROA.artnr DESC 2025-11-19 10:27:04.291 CET [5716] LOG: checkpoint starting: time 2025-11-19 10:27:04.461 CET [5716] LOG: checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.107 s, sync=0.013 s, total=0.171 s; sync files=2, longest=0.008 s, average=0.007 s; distance=5 kB, estimate=64 kB; lsn=7/AA1DE128, redo lsn=7/AA1DE098 2025-11-19 10:32:36.933 CET [4520] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-19 10:32:36.933 CET [5728] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-19 10:42:04.463 CET [5716] LOG: checkpoint starting: time 2025-11-19 10:42:04.634 CET [5716] LOG: checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.102 s, sync=0.017 s, total=0.171 s; sync files=2, longest=0.009 s, average=0.009 s; distance=6 kB, estimate=58 kB; lsn=7/AA1DFAE8, redo lsn=7/AA1DFA90 2025-11-19 10:42:33.175 CET [3652] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-19 10:45:05.109 CET [1876] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-19 10:45:05.110 CET [1872] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-19 10:47:04.625 CET [5716] LOG: checkpoint starting: time 2025-11-19 10:47:04.789 CET [5716] LOG: checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.110 s, sync=0.013 s, total=0.165 s; sync files=2, longest=0.007 s, average=0.006 s; distance=7 kB, estimate=53 kB; lsn=7/AA1E1718, redo lsn=7/AA1E16C0 2025-11-19 10:56:34.027 CET [3544] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-19 10:57:04.787 CET [5716] LOG: checkpoint starting: time 2025-11-19 10:57:04.953 CET [5716] LOG: checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.106 s, sync=0.012 s, total=0.166 s; sync files=2, longest=0.007 s, average=0.006 s; distance=7 kB, estimate=48 kB; lsn=7/AA1E3628, redo lsn=7/AA1E35D0 2025-11-19 10:57:36.666 CET [7132] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-19 10:57:36.667 CET [2312] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-19 11:07:04.946 CET [5716] LOG: checkpoint starting: time 2025-11-19 11:07:05.113 CET [5716] LOG: checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.105 s, sync=0.014 s, total=0.168 s; sync files=2, longest=0.008 s, average=0.007 s; distance=1 kB, estimate=44 kB; lsn=7/AA1E3D20, redo lsn=7/AA1E3CC8 2025-11-19 11:10:43.696 CET [5712] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-19 11:10:43.697 CET [6444] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-19 11:10:43.698 CET [4568] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-19 11:12:04.107 CET [5716] LOG: checkpoint starting: time 2025-11-19 11:12:04.266 CET [5716] LOG: checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.092 s, sync=0.015 s, total=0.160 s; sync files=2, longest=0.009 s, average=0.008 s; distance=2 kB, estimate=39 kB; lsn=7/AA1E4688, redo lsn=7/AA1E4630 2025-11-19 11:15:43.080 CET [6376] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-19 11:16:34.772 CET [7132] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-19 11:16:34.773 CET [5720] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-19 11:16:34.774 CET [6132] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-19 11:17:04.257 CET [5716] LOG: checkpoint starting: time 2025-11-19 11:17:04.986 CET [5716] LOG: checkpoint complete: wrote 7 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.657 s, sync=0.024 s, total=0.730 s; sync files=3, longest=0.012 s, average=0.008 s; distance=37 kB, estimate=39 kB; lsn=7/AA1EDD30, redo lsn=7/AA1EDCD8 2025-11-19 11:22:04.981 CET [5716] LOG: checkpoint starting: time 2025-11-19 11:22:05.147 CET [5716] LOG: checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.107 s, sync=0.014 s, total=0.167 s; sync files=2, longest=0.009 s, average=0.007 s; distance=3 kB, estimate=36 kB; lsn=7/AA1EECD8, redo lsn=7/AA1EEC80 2025-11-19 11:27:04.133 CET [5716] LOG: checkpoint starting: time 2025-11-19 11:27:04.307 CET [5716] LOG: checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.110 s, sync=0.014 s, total=0.175 s; sync files=2, longest=0.009 s, average=0.007 s; distance=4 kB, estimate=32 kB; lsn=7/AA1EFF88, redo lsn=7/AA1EFF30 2025-11-19 11:32:04.301 CET [5716] LOG: checkpoint starting: time 2025-11-19 11:32:04.470 CET [5716] LOG: checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.104 s, sync=0.017 s, total=0.170 s; sync files=2, longest=0.009 s, average=0.009 s; distance=5 kB, estimate=30 kB; lsn=7/AA1F14A8, redo lsn=7/AA1F1450 2025-11-19 11:32:06.429 CET [6204] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-19 11:32:06.430 CET [6444] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-19 11:33:43.389 CET [6316] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-19 11:33:43.390 CET [6060] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-19 11:34:21.830 CET [5512] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-19 11:34:21.831 CET [6796] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-19 11:37:04.460 CET [5716] LOG: checkpoint starting: time 2025-11-19 11:37:04.626 CET [5716] LOG: checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.109 s, sync=0.012 s, total=0.167 s; sync files=2, longest=0.007 s, average=0.006 s; distance=6 kB, estimate=27 kB; lsn=7/AA1F2F40, redo lsn=7/AA1F2EE8 2025-11-19 11:37:09.222 CET [6400] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-19 11:37:09.223 CET [7000] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-19 11:42:04.616 CET [5716] LOG: checkpoint starting: time 2025-11-19 11:42:04.789 CET [5716] LOG: checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.102 s, sync=0.014 s, total=0.173 s; sync files=2, longest=0.009 s, average=0.007 s; distance=7 kB, estimate=25 kB; lsn=7/AA1F4E50, redo lsn=7/AA1F4DF8 2025-11-19 11:59:31.484 CET [7008] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-19 12:00:08.734 CET [6052] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-19 12:27:43.872 CET [7040] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-19 12:27:43.873 CET [5264] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-19 12:27:43.874 CET [6060] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-19 12:31:20.382 CET [6508] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-19 12:31:20.383 CET [4880] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-19 12:32:04.833 CET [5716] LOG: checkpoint starting: time 2025-11-19 12:32:05.461 CET [5716] LOG: checkpoint complete: wrote 6 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.543 s, sync=0.037 s, total=0.628 s; sync files=6, longest=0.015 s, average=0.007 s; distance=19 kB, estimate=25 kB; lsn=7/AA1F9DA8, redo lsn=7/AA1F9D50 2025-11-19 12:37:04.449 CET [5716] LOG: checkpoint starting: time 2025-11-19 12:37:04.617 CET [5716] LOG: checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.109 s, sync=0.012 s, total=0.169 s; sync files=2, longest=0.007 s, average=0.006 s; distance=2 kB, estimate=22 kB; lsn=7/AA1FA718, redo lsn=7/AA1FA6C0 2025-11-19 12:39:35.884 CET [556] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-19 12:39:35.885 CET [6776] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-19 12:42:04.606 CET [5716] LOG: checkpoint starting: time 2025-11-19 12:42:05.014 CET [5716] LOG: checkpoint complete: wrote 4 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.322 s, sync=0.036 s, total=0.409 s; sync files=4, longest=0.013 s, average=0.009 s; distance=12 kB, estimate=21 kB; lsn=7/AA1FD730, redo lsn=7/AA1FD6D8 2025-11-19 12:44:19.848 CET [3000] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-19 12:44:19.848 CET [3000] 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-19 12:44:20.194 CET [2244] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-19 12:44:20.194 CET [2244] 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-19 12:51:07.537 CET [1852] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-19 12:52:04.019 CET [5716] LOG: checkpoint starting: time 2025-11-19 12:52:04.753 CET [5716] LOG: checkpoint complete: wrote 7 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.649 s, sync=0.038 s, total=0.734 s; sync files=3, longest=0.021 s, average=0.013 s; distance=20 kB, estimate=21 kB; lsn=7/AA2028A0, redo lsn=7/AA202848 2025-11-19 12:59:58.918 CET [1448] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-19 12:59:58.919 CET [2400] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-19 12:59:58.920 CET [3252] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-19 13:02:04.759 CET [5716] LOG: checkpoint starting: time 2025-11-19 13:02:04.926 CET [5716] LOG: checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.108 s, sync=0.014 s, total=0.168 s; sync files=2, longest=0.009 s, average=0.007 s; distance=3 kB, estimate=19 kB; lsn=7/AA2037F8, redo lsn=7/AA2037A0 2025-11-19 13:07:04.928 CET [5716] LOG: checkpoint starting: time 2025-11-19 13:07:05.094 CET [5716] LOG: checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.107 s, sync=0.013 s, total=0.167 s; sync files=2, longest=0.008 s, average=0.007 s; distance=4 kB, estimate=18 kB; lsn=7/AA2049C0, redo lsn=7/AA204968 2025-11-19 13:08:10.297 CET [1984] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-19 13:08:10.298 CET [5992] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-19 13:31:37.961 CET [4728] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-19 13:31:37.962 CET [2112] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-19 13:32:04.123 CET [5716] LOG: checkpoint starting: time 2025-11-19 13:32:04.290 CET [5716] LOG: checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.108 s, sync=0.014 s, total=0.168 s; sync files=2, longest=0.008 s, average=0.007 s; distance=5 kB, estimate=17 kB; lsn=7/AA205F28, redo lsn=7/AA205ED0 2025-11-19 13:35:21.104 CET [3000] FATAL: terminating connection due to administrator command 2025-11-19 13:35:21.104 CET [2244] FATAL: terminating connection due to administrator command 2025-11-19 13:35:21.167 CET [5716] LOG: shutting down 2025-11-19 13:35:21.175 CET [5716] LOG: checkpoint starting: shutdown immediate 2025-11-19 13:35:21.227 CET [5716] LOG: checkpoint complete: wrote 0 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.002 s, sync=0.001 s, total=0.060 s; sync files=0, longest=0.000 s, average=0.000 s; distance=0 kB, estimate=15 kB; lsn=7/AA205FD8, redo lsn=7/AA205FD8