2025-11-17 00:13:52.923 CET [5856] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 00:58:04.635 CET [7036] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 00:58:07.426 CET [1100] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 08:52:02.604 CET [5716] LOG: checkpoint starting: time 2025-11-17 08:52:04.341 CET [5716] LOG: checkpoint complete: wrote 16 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.648 s, sync=0.039 s, total=1.737 s; sync files=5, longest=0.014 s, average=0.008 s; distance=79 kB, estimate=170 kB; lsn=7/A9818EC8, redo lsn=7/A9818E70 2025-11-17 08:53:28.672 CET [5420] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-17 08:53:28.672 CET [5420] 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-17 08:53:29.103 CET [6220] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-17 08:53:29.103 CET [6220] 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-17 09:10:35.547 CET [1236] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-17 09:10:35.547 CET [1236] 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-17 09:10:48.773 CET [4248] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-17 09:10:48.773 CET [4248] 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-17 09:10:48.833 CET [3724] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-17 09:10:48.833 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-17 09:10:58.952 CET [6932] WARNING: PID 2792 is not a PostgreSQL backend process 2025-11-17 09:12:50.294 CET [2772] WARNING: PID 2512 is not a PostgreSQL backend process 2025-11-17 09:12:50.637 CET [6676] WARNING: PID 3956 is not a PostgreSQL backend process 2025-11-17 09:12:54.026 CET [3724] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 09:12:54.027 CET [6220] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 09:13:15.377 CET [5696] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-17 09:13:15.377 CET [5696] 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-17 09:13:15.543 CET [2740] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-17 09:13:15.543 CET [2740] 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-17 09:13:15.606 CET [7092] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-17 09:13:15.606 CET [7092] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2025-11-17 09:13:15.691 CET [1932] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-17 09:13:15.691 CET [1932] 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-17 09:13:15.768 CET [4780] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-17 09:13:15.768 CET [4780] 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-17 09:13:21.750 CET [6284] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-17 09:13:21.750 CET [6284] 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-17 09:13:22.526 CET [6196] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-17 09:13:22.526 CET [6196] 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-17 09:13:22.542 CET [4544] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-17 09:13:22.542 CET [4544] 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-17 09:13:55.834 CET [3780] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-17 09:13:55.834 CET [3780] 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-17 09:14:39.399 CET [3780] ERROR: column "XE0071499421" does not exist at character 45 2025-11-17 09:14:39.399 CET [3780] STATEMENT: SELECT * FROM wms.cont WHERE collobarcode = "XE0071499421" LIMIT 100 2025-11-17 09:15:55.566 CET [5504] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-17 09:15:55.566 CET [5504] 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-17 09:18:56.184 CET [3196] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-17 09:18:56.184 CET [3196] 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-17 09:19:09.014 CET [5968] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-17 09:19:09.014 CET [5968] 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-17 09:19:38.782 CET [4644] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-17 09:19:38.782 CET [4644] 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-17 09:22:02.367 CET [5716] LOG: checkpoint starting: time 2025-11-17 09:22:02.651 CET [5716] LOG: checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.214 s, sync=0.021 s, total=0.284 s; sync files=2, longest=0.013 s, average=0.011 s; distance=4 kB, estimate=154 kB; lsn=7/A9819F78, redo lsn=7/A9819F20 2025-11-17 09:22:55.917 CET [4204] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-17 09:22:55.917 CET [4204] 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-17 09:24:46.030 CET [6728] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-17 09:24:46.030 CET [6728] 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-17 09:25:02.044 CET [6540] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-17 09:25:02.044 CET [6540] 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-17 09:27:02.654 CET [5716] LOG: checkpoint starting: time 2025-11-17 09:27:02.908 CET [5716] LOG: checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.210 s, sync=0.012 s, total=0.254 s; sync files=1, longest=0.012 s, average=0.012 s; distance=9 kB, estimate=139 kB; lsn=7/A981C6F0, redo lsn=7/A981C698 2025-11-17 09:31:14.157 CET [2948] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-17 09:31:14.157 CET [2948] 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-17 09:32:02.905 CET [5716] LOG: checkpoint starting: time 2025-11-17 09:32:08.789 CET [5716] LOG: checkpoint complete: wrote 53 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=5.657 s, sync=0.178 s, total=5.885 s; sync files=25, longest=0.014 s, average=0.008 s; distance=295 kB, estimate=295 kB; lsn=7/A98663C0, redo lsn=7/A9866330 2025-11-17 09:42:02.788 CET [5716] LOG: checkpoint starting: time 2025-11-17 09:42:06.729 CET [5716] LOG: checkpoint complete: wrote 36 buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=3.818 s, sync=0.076 s, total=3.942 s; sync files=12, longest=0.012 s, average=0.007 s; distance=183 kB, estimate=284 kB; lsn=7/A98942E0, redo lsn=7/A9894288 2025-11-17 09:56:34.215 CET [4544] ERROR: column ct.quantity does not exist at character 3154 2025-11-17 09:56:34.215 CET [4544] STATEMENT: DROP VIEW sonex.v_shipbk_source; 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 wms.pqueuesqldata 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)::varchar 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('%'::text || p.a27::text, 'BK'::text, ''::text) LIMIT 1 ) recip_data ON true -- 1) główne źródło: wms.cont 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' THEN 2 WHEN right(p.a29::text, 2) = '_3' THEN 3 ELSE 1 END WHERE ct.collobarcode::text = p.a39::text GROUP BY ct.artnr ) x ) c ON true -- 2) fallback: ltt.expedvw (kopia cont) 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 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' THEN 2 WHEN right(p.a29::text, 2) = '_3' THEN 3 ELSE 1 END WHERE ct.collobarcode::text = p.a39::text GROUP BY ct.artnr ) x ) e ON true WHERE p.a38::text = 'SHIPBK'::text AND NOT EXISTS ( SELECT 1 FROM sonex.shipbk_print_jobs j WHERE j.job_id = p.jobid ); ; ALTER TABLE sonex.v_shipbk_source OWNER TO postgres; GRANT ALL ON TABLE sonex.v_shipbk_source TO postgres; GRANT INSERT, DELETE, SELECT, UPDATE ON TABLE sonex.v_shipbk_source TO sonex; 2025-11-17 09:57:02.714 CET [5716] LOG: checkpoint starting: time 2025-11-17 09:57:04.650 CET [5716] LOG: checkpoint complete: wrote 18 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.841 s, sync=0.047 s, total=1.936 s; sync files=8, longest=0.009 s, average=0.006 s; distance=112 kB, estimate=266 kB; lsn=7/A98B05A0, redo lsn=7/A98B0548 2025-11-17 09:58:39.536 CET [4652] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-17 09:58:39.536 CET [4652] 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-17 09:59:27.933 CET [7080] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-17 09:59:27.933 CET [7080] 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-17 10:02:02.646 CET [5716] LOG: checkpoint starting: time 2025-11-17 10:02:07.450 CET [5716] LOG: checkpoint complete: wrote 44 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=4.691 s, sync=0.066 s, total=4.805 s; sync files=10, longest=0.013 s, average=0.007 s; distance=164 kB, estimate=256 kB; lsn=7/A98D9978, redo lsn=7/A98D98E8 2025-11-17 10:08:28.436 CET [6724] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-17 10:08:28.436 CET [6724] 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-17 10:22:16.379 CET [4652] ERROR: error executing query: OCIStmtExecute failed to execute remote query 2025-11-17 10:22:16.379 CET [4652] DETAIL: ORA-00932: inconsistent datatypes: expected CHAR got NUMBER Help: https://docs.oracle.com/error-help/db/ora-00932/ 2025-11-17 10:22:16.379 CET [4652] STATEMENT: 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 * FROM wms.pqueuesqldata p WHERE p.a38::text = 'SHIPBK'::text AND p.jobid > COALESCE( (SELECT MAX(j.job_id) FROM sonex.shipbk_print_jobs j), 0 ) ) p -- dane odbiorcy 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)::varchar 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('%'::text || p.a27::text, 'BK'::text, ''::text) LIMIT 1 ) recip_data ON true -- 1) główne źródło: wms.cont 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' THEN 2 WHEN right(p.a29::text, 2) = '_3' THEN 3 ELSE 1 END WHERE ct.collobarcode::text = p.a39::text GROUP BY ct.artnr ) x ) c ON true -- 2) fallback: ltt.expedvw (kopia cont) 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' THEN 2 WHEN right(p.a29::text, 2) = '_3' THEN 3 ELSE 1 END WHERE ct.collobarcode::text = p.a39::text GROUP BY ct.artnr ) x ) e ON true; 2025-11-17 10:27:02.458 CET [5716] LOG: checkpoint starting: time 2025-11-17 10:27:04.516 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.058 s, total=2.059 s; sync files=9, longest=0.011 s, average=0.007 s; distance=57 kB, estimate=236 kB; lsn=7/A98E7ED8, redo lsn=7/A98E7E80 2025-11-17 10:28:01.897 CET [1972] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-17 10:28:01.897 CET [1972] 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-17 10:28:17.590 CET [3748] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 10:28:18.240 CET [7128] LOG: could not send data to client: An existing connection was forcibly closed by the remote host. 2025-11-17 10:28:18.241 CET [7128] FATAL: connection to client lost 2025-11-17 10:32:02.506 CET [5716] LOG: checkpoint starting: time 2025-11-17 10:32:05.424 CET [5716] LOG: checkpoint complete: wrote 27 buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=2.822 s, sync=0.052 s, total=2.919 s; sync files=10, longest=0.010 s, average=0.006 s; distance=216 kB, estimate=234 kB; lsn=7/A991DF58, redo lsn=7/A991DEC8 2025-11-17 10:52:02.429 CET [5716] LOG: checkpoint starting: time 2025-11-17 10:52:11.948 CET [5716] LOG: checkpoint complete: wrote 86 buffers (0.5%); 0 WAL file(s) added, 0 removed, 0 recycled; write=9.286 s, sync=0.167 s, total=9.520 s; sync files=32, longest=0.014 s, average=0.006 s; distance=536 kB, estimate=536 kB; lsn=7/A99A41A0, redo lsn=7/A99A4148 2025-11-17 11:11:18.525 CET [5884] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-17 11:11:18.525 CET [5884] 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-17 11:12:02.957 CET [5716] LOG: checkpoint starting: time 2025-11-17 11:12:03.224 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.008 s, total=0.267 s; sync files=1, longest=0.008 s, average=0.008 s; distance=14 kB, estimate=484 kB; lsn=7/A99A7BC0, redo lsn=7/A99A7B68 2025-11-17 11:15:00.935 CET [3780] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 11:15:20.158 CET [5564] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-17 11:15:20.158 CET [5564] 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-17 11:17:02.228 CET [5716] LOG: checkpoint starting: time 2025-11-17 11:17:02.717 CET [5716] LOG: checkpoint complete: wrote 4 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.437 s, sync=0.008 s, total=0.490 s; sync files=1, longest=0.008 s, average=0.008 s; distance=23 kB, estimate=438 kB; lsn=7/A99AD980, redo lsn=7/A99AD928 2025-11-17 11:19:49.251 CET [4644] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 11:22:02.722 CET [5716] LOG: checkpoint starting: time 2025-11-17 11:22:02.898 CET [5716] LOG: checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.115 s, sync=0.016 s, total=0.176 s; sync files=2, longest=0.010 s, average=0.008 s; distance=1 kB, estimate=394 kB; lsn=7/A99ADFC8, redo lsn=7/A99ADF70 2025-11-17 11:24:56.500 CET [6728] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 11:25:52.970 CET [6540] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 11:31:35.643 CET [2948] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 11:37:46.166 CET [5564] ERROR: null value in column "part_number" of relation "shipbk_package_size" violates not-null constraint 2025-11-17 11:37:46.166 CET [5564] DETAIL: Failing row contains (154171, null, 153, 56, 43, 20, Hangbank Knoet - zwa, 12). 2025-11-17 11:37:46.166 CET [5564] STATEMENT: INSERT INTO sonex.shipbk_package_size (article_number, part_name, width, height, length, weight ) VALUES ('154171', 'Hangbank Knoet - zwa', 153, 56, 43, 20); 2025-11-17 11:39:53.878 CET [5564] ERROR: duplicate key value violates unique constraint "shipbk_package_size_article_part_uq" 2025-11-17 11:39:53.878 CET [5564] DETAIL: Key (article_number, part_number)=(154171, 1) already exists. 2025-11-17 11:39:53.878 CET [5564] STATEMENT: INSERT INTO sonex.shipbk_package_size (article_number,part_number, part_name, width, height, length, weight ) VALUES ('154171', 1, 'Hangbank Knoet - zwa', 153, 56, 43, 20) 2025-11-17 11:40:15.903 CET [4136] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-17 11:40:15.903 CET [4136] 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-17 11:40:52.964 CET [5564] ERROR: duplicate key value violates unique constraint "shipbk_package_size_article_part_uq" 2025-11-17 11:40:52.964 CET [5564] DETAIL: Key (article_number, part_number)=(178701, 1) already exists. 2025-11-17 11:40:52.964 CET [5564] STATEMENT: INSERT INTO sonex.shipbk_package_size (article_number,part_number, part_name, width, height, length, weight ) VALUES ('154171', 1, 'Hangbank Knoet - zwa', 153, 56, 43, 20), ('154172', 1, 'Hangbank Knoet - gri', 153, 56, 43, 20), ('175006', 1, 'Bamboe rolgordijn - ', 182, 10, 6, 3), ('175105', 1, 'Bamboe rolgordijn - ', 182, 10, 6, 3), ('175130', 1, 'Rolgordijn bamboe sm', 182, 10, 6, 3), ('175199', 1, 'Bamboe rolgordijn - ', 181, 10, 6, 3), ('178008', 1, 'Passpiegel metaal - ', 153, 40, 4, 7), ('178074', 1, 'Spiegel XL met golfr', 171, 56, 8, 10), ('178084', 1, 'Passpiegel XL - goud', 163, 47, 10, 8), ('178085', 1, 'Passpiegel XL - zwar', 163, 47, 10, 8), ('178105', 1, 'STAANDE PASSPIEGEL NATUREL 155X35 CM GLAS/MDF', 163, 7, 40, 6), ('178291', 1, 'Passpiegel industria', 163, 47, 10, 10), ('178386', 1, 'Ronde spiegel - 120', 129, 129, 12, 10), ('178387', 1, 'Ronde spiegel - 120', 129, 129, 12, 10), ('178408', 1, 'Passpiegel wave tedd', 173, 75, 6, 16), ('178480', 1, 'Passpiegel wave luip', 170, 75, 6, 16), ('178481', 1, 'Passpiegel wave tedd', 170, 75, 6, 16), ('178482', 1, 'Passpiegel wave tedd', 170, 75, 6, 16), ('178635', 1, 'Passpiegel Basix - z', 163, 47, 10, 8), ('178700', 1, 'Passpiegel wave acac', 176, 75, 8, 18), ('178701', 1, 'SPIEGEL XL HOUTEN LIJST NATUREL H168X60X2 CM ACACIA/GLAS', 66, 7, 175, 14), ('178701', 1, 'SPIEGEL XL HOUTEN LIJST NATUREL H168X60X2 CM ACACIA/GLAS', 175, 7, 66, 14), ('178702', 1, 'SPIEGEL XL METALEN LIJST BEIGE H168X60X2,5 CM ALUMINIUM/GLAS', 168, 60, 2, 9), ('178702', 1, 'SPIEGEL XL METALEN LIJST BEIGE H168X60X2,5 CM ALUMINIUM/GLAS', 168, 60, 2, 9), ('228162', 1, 'BANANEN BOOM 160CM GROEN 17,5X160CM PLASTIC SS25', 174, 24, 24, 6), ('375055', 1, 'Schildersdoek canvas', 123, 95, 17, 2), ('545435', 1, 'Vuurschaal - metaal ', 84, 82, 20, 11), ('547005', 1, 'Stapelbare tuinstoel', 79, 70, 56, 4), ('547006', 1, 'Tuinstoel Sara - gro', 79, 70, 56, 4), ('547007', 1, 'Tuinstoel Sara - oke', 79, 70, 56, 4), ('547008', 1, 'Tuinstoel Sara - roo', 79, 70, 56, 4), ('547011', 1, 'Stapelbare tuinstoel', 79, 70, 56, 3), ('547015', 1, 'Stapelbare tuinstoel', 79, 70, 56, 3), ('547016', 1, 'Stapelbare tuinstoel', 79, 70, 56, 3), ('547017', 1, 'Stapelbare tuinstoel', 79, 70, 56, 3), ('547018', 1, 'Stapelbare tuinstoel', 79, 70, 56, 3), ('547019', 1, 'Stapelbare tuinstoel', 79, 70, 56, 3), ('547020', 1, 'Stapelbare tuinstoel', 79, 70, 56, 4), ('547021', 1, 'Stapelbare tuinstoel', 79, 70, 56, 4), ('547022', 1, 'Tuinstoel Daimy - br', 79, 70, 56, 8), ('547030', 1, 'Stapelbare tuinstoel', 79, 70, 56, 5), ('547031', 1, 'Stapelbare tuinstoel', 79, 70, 56, 5), ('547032', 1, 'Stapelbare tuinstoel', 79, 70, 56, 5), ('547040', 1, 'Stapelbare tuinstoel', 79, 70, 56, 4), ('547043', 1, 'Stapelbare tuinstoel', 79, 70, 56, 3), ('547044', 1, 'Tuinstoel Daimy - gr', 81, 80, 44, 9), ('547056', 1, 'Inklapbare bistroban', 100, 92, 13, 9), ('547057', 1, 'Inklapbare bistroban', 100, 92, 14, 9), ('547058', 1, 'Inklapbare bistroban', 100, 92, 14, 9), ('547122', 1, 'Tuinbank met opbergr', 121, 81, 17, 15), ('547210', 1, 'Tuintafel Elisa rond', 101, 99, 8, 14), ('547226', 1, 'Bistrotafel rechthoe', 97, 92, 6, 9), ('547248', 1, 'Tuinset Loes - groen', 143, 85, 49, 30), ('547249', 1, 'Tuinset Ronda - groe', 129, 95, 37, 49), ('547250', 1, 'Tuinbank Hawaii - zw', 135, 95, 45, 9), ('547252', 1, 'Tuinbank Hawaii - gr', 135, 95, 45, 9), ('547260', 1, 'Tuinstoel Hawaii - z', 85, 71, 20, 4), ('547261', 1, 'Tuinstoel Hawaii - w', 90, 73, 68, 4), ('547262', 1, 'Tuinstoel Hawaii - g', 90, 73, 68, 4), ('547263', 1, 'Tuinstoel Hawaii - t', 90, 73, 68, 4), ('547271', 1, 'Bamboe tafel - inkla', 117, 95, 16, 7), ('547272', 1, 'Bamboe bank 3-zits -', 170, 75, 30, 20), ('547275', 1, 'Ligbed met kussen - ', 204, 72, 21, 18), ('547282', 1, 'Bamboe bank Padang -', 170, 65, 20, 23), ('547284', 1, 'Bamboe fauteuil pada', 78, 78, 50, 15), ('547320', 1, 'Tuinset Mallorca - 4', 142, 73, 50, 41), ('547326', 1, 'Tuinset Mallorca - z', 140, 74, 48, 40), ('547360', 1, 'Tuinset Lorraine - n', 100, 82, 74, 37), ('547361', 1, 'Tuinset Lorraine - z', 100, 90, 90, 50), ('547370', 1, 'Tuinset Donna - natu', 93, 84, 75, 32), ('547371', 1, 'Tuinset Donna - zwar', 100, 90, 90, 50), ('547380', 1, 'Tuinbank Donna - zwa', 195, 74, 48, 36), ('547400', 1, 'Tuintafel vierkant -', 82, 82, 9, 15), ('547401', 1, 'Tuintafel rond - aca', 114, 112, 10, 21), ('547402', 1, 'Tuintafel rechthoeki', 173, 93, 10, 28), ('547420', 1, 'Loungebank acacia - ', 116, 90, 35, 25), ('547421', 1, 'Loungebank acacia - ', 115, 90, 35, 25), ('547427', 1, 'Tuinbank Tenerife me', 149, 68, 35, 21), ('547430', 1, 'Tuinset Costa - zwar', 85, 73, 70, 10), ('547431', 1, 'Tuinset Marbella - 3', 72, 62, 52, 17), ('547432', 1, 'Tuinbank Riviera - t', 120, 60, 37, 24), ('547435', 1, 'Tuinset Malaga - 4-d', 136, 86, 40, 24), ('547436', 1, 'Tuinstoel Malaga - 8', 85, 60, 57, 12), ('547437', 1, 'Loungeset Algarve - ', 168, 73, 41, 55), ('547438', 1, 'Tuinset Rhodos met k', 137, 70, 53, 39), ('547441', 1, 'Bistro set Rhodos -', 102, 88, 20, 27), ('547442', 1, 'Ligbed Sevilla - zwa', 193, 73, 10, 12), ('547443', 1, 'Ligbed Sevilla - gri', 193, 73, 10, 12), ('547710', 1, 'Tuinset Kreta met ku', 95, 80, 16, 16), ('594461', 1, 'Clipbox black - 80 l', 79, 70, 56, 3), ('594532', 1, 'Clipbox met wieltjes', 79, 70, 56, 3), ('594533', 1, 'Opbergbox met wieltj', 79, 70, 56, 5), ('608604', 1, 'Hangstoel zit', 125, 80, 70, 7), ('608605', 1, 'Hangstoel zit', 125, 80, 70, 7), ('608606', 1, 'Hangstoel zit', 125, 80, 70, 7), ('608608', 1, 'Hangstoel zit', 112, 108, 66, 13), ('608617', 1, 'Hangstoel Aqua - nat', 129, 79, 65, 10), ('608618', 1, 'Schommel ligbed - br', 160, 60, 56, 10), ('608629', 1, 'Bank met kussen Shan', 94, 91, 78, 10), ('608640', 1, 'Schommelstoel Rocky ', 120, 97, 51, 19), ('608645', 1, 'Hangstoel Ibiza met ', 170, 115, 75, 25), ('608646', 1, 'Hangstoel Ibiza met ', 170, 115, 75, 25), ('608647', 1, 'Hangstoel Ibiza met ', 170, 115, 75, 25), ('608648', 1, 'Hangstoel zit', 123, 82, 69, 10), ('608650', 1, 'Egg chair naturel - ', 94, 70, 67, 17), ('608651', 1, 'Egg chair zwart - 15', 94, 70, 66, 17), ('608652', 1, 'Hangstoel Hawaii zit', 125, 80, 70, 7), ('608653', 1, 'Hangstoel zit', 125, 80, 70, 7), ('608654', 1, 'Hangstoel zit', 110, 110, 66, 7), ('608655', 1, 'Hangstoel zit', 110, 110, 66, 7), ('609007', 1, '6 vakkenkast Zaha or', 140, 74, 25, 14), ('609009', 1, 'Dressoir Bali met 2 ', 105, 72, 46, 15), ('609014', 1, 'Webbing Java boekenk', 158, 78, 39, 27), ('609021', 1, 'Webbing Java dressoi', 126, 66, 47, 23), ('609022', 1, 'Webbing Java vakkenk', 118, 70, 47, 23), ('609026', 1, '5 vakkenkast Zaha or', 126, 55, 36, 14), ('609039', 1, 'SALONTAFEL UPPSALA NATUREL 120X60X40 CM MDF', 120, 60, 40, 21), ('609040', 1, 'VAKKENKAST UPPSALA 2DEUR BRUIN BRUIN H157X80X40 CM MDF', 78, 46, 160, 29), ('609060', 1, 'Vakkenkast Java met ', 157, 76, 38, 34), ('609061', 1, 'Kast Java met deurtj', 148, 76, 38, 28), ('609183', 1, 'Webbing kast Bandung', 146, 76, 44, 17), ('609184', 1, 'Webbing kast Bandung', 80, 72, 39, 13), ('609185', 1, 'Webbing dressoir Ban', 127, 80, 45, 21), ('609187', 1, 'Webbing kast smal Ba', 165, 49, 46, 16), ('609188', 1, 'Kast webbing Lombok ', 168, 43, 28, 23), ('609190', 1, 'Webbing Sumatra kast', 116, 76, 47, 23), ('609191', 1, 'Webbing Sumatra dres', 126, 49, 39, 16), ('609193', 1, 'Webbing Sumatra dres', 164, 53, 47, 26), ('609201', 1, 'Kast Tokyo met 2 deu', 128, 68, 43, 16), ('609208', 1, 'Webbing kast smal Ba', 160, 45, 40, 16), ('609210', 1, 'Webbing kast Bandung', 147, 76, 45, 21), ('609211', 1, 'Webbing kast Bandung', 85, 77, 44, 13), ('609212', 1, 'Webbing dressoir Ban', 126, 79, 46, 20), ('609214', 1, 'Webbing sidetable Ba', 88, 80, 45, 13), ('609221', 1, 'Webbing tv meubel Ba', 126, 48, 46, 16), ('609245', 1, 'Wandkast Memphis - 1', 109, 76, 45, 27), ('609246', 1, 'Dressoir Memphis - 9', 116, 60, 51, 27), ('609247', 1, 'Dressoir Memphis - 6', 125, 49, 46, 25), ('609250', 1, 'Webbing kast Bandung', 148, 76, 44, 22), ('609254', 1, 'Webbing kast Bandung', 147, 77, 45, 22), ('609301', 1, 'Kast vintage met sch', 85, 76, 44, 18), ('609303', 1, 'Tv kast vintage - br', 125, 46, 45, 16), ('609314', 1, 'Dressoir Memphis - 2', 86, 86, 45, 22), ('609321', 1, 'Hoge kast Luca met d', 165, 48, 46, 23), ('609400', 1, 'Vakkenkast Charlie m', 172, 72, 20, 22), ('609401', 1, 'Vakkenkast Charlie m', 173, 76, 9, 23), ('609406', 1, 'Kast Charlie met 5 l', 113, 73, 45, 27), ('609407', 1, 'Dressoir Charlie met', 130, 77, 44, 24), ('609409', 1, 'Vakkenkast Charlie -', 172, 62, 7, 12), ('609413', 1, 'Vakkenkast Charlie -', 172, 75, 7, 14), ('609414', 1, 'Vakkenkast Charlie X', 183, 124, 10, 32), ('609417', 1, 'Vakkenkast Charlie X', 182, 125, 11, 32), ('610249', 1, 'Ladekast Boston - 4 ', 84, 73, 37, 12), ('610250', 1, 'Ladekast Boston - 9 ', 93, 77, 37, 19), ('610251', 1, 'Ladekast Boston - 12', 124, 77, 37, 25), ('610267', 1, 'Apothekerskast - 15 ', 142, 82, 46, 42), ('610268', 1, 'Apothekerskast - 15 ', 141, 80, 46, 31), ('610270', 1, 'Apothekerskast - 15 ', 141, 81, 46, 30), ('610280', 1, 'Wijnkast Vino - hout', 122, 68, 37, 20), ('610282', 1, 'Wijnrekkast Elzas - ', 152, 59, 40, 22), ('614391', 1, 'Vakkenkast Liam - 12', 121, 80, 7, 16), ('614393', 1, 'Vakkenkast Mason XL ', 183, 123, 10, 33), ('614396', 1, 'Boekenkast Duncan - ', 171, 73, 7, 16), ('614446', 1, 'Vakkenkast zigzag - ', 150, 126, 8, 15), ('615401', 1, 'Bankje recycle Ubud ', 124, 59, 37, 18), ('615650', 1, 'Dressoir met cijfers', 124, 71, 46, 32), ('617261', 1, 'Lotus bed hoofdbord ', 160, 115, 4, 8), ('617262', 1, 'Lotus bed hoofdbord ', 180, 140, 4, 9), ('617316', 1, 'Bamboe bijzettafel r', 85, 60, 57, 6), ('617360', 1, 'Rotan pauwentroon - ', 147, 127, 80, 10), ('617370', 1, 'Eetkamerstoel Tegal ', 66, 66, 54, 15), ('617399', 1, 'Rotan lotus kuipstoe', 100, 90, 70, 6), ('617402', 1, 'Lotus kuipstoel - ro', 100, 90, 70, 6), ('617404', 1, 'Rotan fauteuil Bandu', 100, 64, 60, 5), ('617405', 1, 'Rotan fauteuil bandu', 86, 83, 69, 5), ('617406', 1, 'Rotan kuipstoel Sema', 77, 73, 66, 4), ('617407', 1, 'Kuipstoel Semarang -', 78, 72, 62, 5), ('617408', 1, 'Rotan bank bandung -', 126, 87, 80, 9), ('617410', 1, 'Rotan schommelstoel ', 105, 94, 56, 7), ('617420', 1, 'Rotan kuipstoel Rinj', 70, 70, 54, 4), ('617479', 1, 'Papasan Zit', 110, 110, 32, 6), ('617480', 1, 'Papasan Zit', 110, 110, 32, 6), ('617481', 1, 'Rotan loungebank Mam', 175, 117, 80, 15), ('617710', 1, 'Bank bahama - rotan ', 116, 75, 73, 6), ('623047', 1, 'Eetkamertafel Nova -', 96, 93, 19, 19), ('623050', 1, 'Teddy bankje/poef ba', 120, 62, 39, 11), ('623055', 1, 'Teddy loveseat faute', 121, 75, 74, 19), ('623056', 1, 'Teddy fauteuil - wit', 77, 75, 73, 13), ('623058', 1, 'Eetkamerbank Teddy -', 130, 95, 65, 33), ('623065', 1, 'Teddy loveseat faute', 120, 75, 74, 18), ('623066', 1, 'Teddy loveseat faute', 121, 74, 73, 18), ('623067', 1, 'Teddy fauteuil - zwa', 78, 74, 73, 14), ('623068', 1, 'Teddy fauteuil - amb', 77, 75, 73, 14), ('623074', 1, '2-zits bankje Didi c', 148, 75, 54, 22), ('623075', 1, '2-zits bankje Didi c', 148, 75, 52, 22), ('623330', 1, 'BANK BOUQUET MULTI 120X45X44 CM POLYESTER/MDF', 120, 45, 44, 13), ('623371', 1, 'Eetkamerstoel Yogya ', 85, 60, 57, 7), ('623510', 1, 'Armfauteuil Frida - ', 77, 71, 49, 14), ('623511', 1, 'Armfauteuil Frida - ', 77, 71, 49, 14), ('623512', 1, 'Armfauteuil Frida - ', 77, 69, 49, 14), ('623513', 1, 'Armfauteuil Frida - ', 78, 69, 49, 14), ('623514', 1, 'Armfauteuil Frida - ', 76, 72, 51, 14), ('623580', 1, 'Sofa Marilyn - beige', 80, 70, 43, 19), ('623581', 1, 'Sofa Marilyn - blauw', 80, 70, 44, 19), ('623582', 1, 'Sofa Marilyn - groen', 80, 70, 43, 19), ('623590', 1, 'Inklapbaar bureau Le', 6, 84, 114, 10), ('623591', 1, 'BUREAUSTOEL LEON ZWART ZWART 55,5X62,5X77 CM PP', 62, 55, 55, 6), ('623615', 1, 'Draaifauteuil - taupe - 74x68x66 cm', 74, 66, 68, 16), ('623700', 1, 'Eetkamertafel Olivia', 124, 123, 10, 20), ('623701', 1, 'Eetkamertafel Olivia', 124, 124, 12, 20), ('623702', 1, 'Eettafel Olivia ovaa', 190, 98, 12, 23), ('623704', 1, 'Eettafel Olivia vier', 87, 86, 13, 11), ('630366', 1, 'Vloerkleed riet - na', 153, 56, 43, 5), ('630368', 1, 'Vloerkleed riet - br', 153, 56, 43, 4); 2025-11-17 11:41:18.279 CET [5564] ERROR: duplicate key value violates unique constraint "shipbk_package_size_article_part_uq" 2025-11-17 11:41:18.279 CET [5564] DETAIL: Key (article_number, part_number)=(178701, 1) already exists. 2025-11-17 11:41:18.279 CET [5564] STATEMENT: INSERT INTO sonex.shipbk_package_size (article_number,part_number, part_name, width, height, length, weight ) VALUES ('154171', 1, 'Hangbank Knoet - zwa', 153, 56, 43, 20), ('154172', 1, 'Hangbank Knoet - gri', 153, 56, 43, 20), ('175006', 1, 'Bamboe rolgordijn - ', 182, 10, 6, 3), ('175105', 1, 'Bamboe rolgordijn - ', 182, 10, 6, 3), ('175130', 1, 'Rolgordijn bamboe sm', 182, 10, 6, 3), ('175199', 1, 'Bamboe rolgordijn - ', 181, 10, 6, 3), ('178008', 1, 'Passpiegel metaal - ', 153, 40, 4, 7), ('178074', 1, 'Spiegel XL met golfr', 171, 56, 8, 10), ('178084', 1, 'Passpiegel XL - goud', 163, 47, 10, 8), ('178085', 1, 'Passpiegel XL - zwar', 163, 47, 10, 8), ('178105', 1, 'STAANDE PASSPIEGEL NATUREL 155X35 CM GLAS/MDF', 163, 7, 40, 6), ('178291', 1, 'Passpiegel industria', 163, 47, 10, 10), ('178386', 1, 'Ronde spiegel - 120', 129, 129, 12, 10), ('178387', 1, 'Ronde spiegel - 120', 129, 129, 12, 10), ('178408', 1, 'Passpiegel wave tedd', 173, 75, 6, 16), ('178480', 1, 'Passpiegel wave luip', 170, 75, 6, 16), ('178481', 1, 'Passpiegel wave tedd', 170, 75, 6, 16), ('178482', 1, 'Passpiegel wave tedd', 170, 75, 6, 16), ('178635', 1, 'Passpiegel Basix - z', 163, 47, 10, 8), ('178700', 1, 'Passpiegel wave acac', 176, 75, 8, 18), ('178701', 1, 'SPIEGEL XL HOUTEN LIJST NATUREL H168X60X2 CM ACACIA/GLAS', 66, 7, 175, 14), ('178701', 1, 'SPIEGEL XL HOUTEN LIJST NATUREL H168X60X2 CM ACACIA/GLAS', 175, 7, 66, 14), ('178702', 1, 'SPIEGEL XL METALEN LIJST BEIGE H168X60X2,5 CM ALUMINIUM/GLAS', 168, 60, 2, 9), ('178702', 1, 'SPIEGEL XL METALEN LIJST BEIGE H168X60X2,5 CM ALUMINIUM/GLAS', 168, 60, 2, 9), ('228162', 1, 'BANANEN BOOM 160CM GROEN 17,5X160CM PLASTIC SS25', 174, 24, 24, 6), ('375055', 1, 'Schildersdoek canvas', 123, 95, 17, 2), ('545435', 1, 'Vuurschaal - metaal ', 84, 82, 20, 11), ('547005', 1, 'Stapelbare tuinstoel', 79, 70, 56, 4), ('547006', 1, 'Tuinstoel Sara - gro', 79, 70, 56, 4), ('547007', 1, 'Tuinstoel Sara - oke', 79, 70, 56, 4), ('547008', 1, 'Tuinstoel Sara - roo', 79, 70, 56, 4), ('547011', 1, 'Stapelbare tuinstoel', 79, 70, 56, 3), ('547015', 1, 'Stapelbare tuinstoel', 79, 70, 56, 3), ('547016', 1, 'Stapelbare tuinstoel', 79, 70, 56, 3), ('547017', 1, 'Stapelbare tuinstoel', 79, 70, 56, 3), ('547018', 1, 'Stapelbare tuinstoel', 79, 70, 56, 3), ('547019', 1, 'Stapelbare tuinstoel', 79, 70, 56, 3), ('547020', 1, 'Stapelbare tuinstoel', 79, 70, 56, 4), ('547021', 1, 'Stapelbare tuinstoel', 79, 70, 56, 4), ('547022', 1, 'Tuinstoel Daimy - br', 79, 70, 56, 8), ('547030', 1, 'Stapelbare tuinstoel', 79, 70, 56, 5), ('547031', 1, 'Stapelbare tuinstoel', 79, 70, 56, 5), ('547032', 1, 'Stapelbare tuinstoel', 79, 70, 56, 5), ('547040', 1, 'Stapelbare tuinstoel', 79, 70, 56, 4), ('547043', 1, 'Stapelbare tuinstoel', 79, 70, 56, 3), ('547044', 1, 'Tuinstoel Daimy - gr', 81, 80, 44, 9), ('547056', 1, 'Inklapbare bistroban', 100, 92, 13, 9), ('547057', 1, 'Inklapbare bistroban', 100, 92, 14, 9), ('547058', 1, 'Inklapbare bistroban', 100, 92, 14, 9), ('547122', 1, 'Tuinbank met opbergr', 121, 81, 17, 15), ('547210', 1, 'Tuintafel Elisa rond', 101, 99, 8, 14), ('547226', 1, 'Bistrotafel rechthoe', 97, 92, 6, 9), ('547248', 1, 'Tuinset Loes - groen', 143, 85, 49, 30), ('547249', 1, 'Tuinset Ronda - groe', 129, 95, 37, 49), ('547250', 1, 'Tuinbank Hawaii - zw', 135, 95, 45, 9), ('547252', 1, 'Tuinbank Hawaii - gr', 135, 95, 45, 9), ('547260', 1, 'Tuinstoel Hawaii - z', 85, 71, 20, 4), ('547261', 1, 'Tuinstoel Hawaii - w', 90, 73, 68, 4), ('547262', 1, 'Tuinstoel Hawaii - g', 90, 73, 68, 4), ('547263', 1, 'Tuinstoel Hawaii - t', 90, 73, 68, 4), ('547271', 1, 'Bamboe tafel - inkla', 117, 95, 16, 7), ('547272', 1, 'Bamboe bank 3-zits -', 170, 75, 30, 20), ('547275', 1, 'Ligbed met kussen - ', 204, 72, 21, 18), ('547282', 1, 'Bamboe bank Padang -', 170, 65, 20, 23), ('547284', 1, 'Bamboe fauteuil pada', 78, 78, 50, 15), ('547320', 1, 'Tuinset Mallorca - 4', 142, 73, 50, 41), ('547326', 1, 'Tuinset Mallorca - z', 140, 74, 48, 40), ('547360', 1, 'Tuinset Lorraine - n', 100, 82, 74, 37), ('547361', 1, 'Tuinset Lorraine - z', 100, 90, 90, 50), ('547370', 1, 'Tuinset Donna - natu', 93, 84, 75, 32), ('547371', 1, 'Tuinset Donna - zwar', 100, 90, 90, 50), ('547380', 1, 'Tuinbank Donna - zwa', 195, 74, 48, 36), ('547400', 1, 'Tuintafel vierkant -', 82, 82, 9, 15), ('547401', 1, 'Tuintafel rond - aca', 114, 112, 10, 21), ('547402', 1, 'Tuintafel rechthoeki', 173, 93, 10, 28), ('547420', 1, 'Loungebank acacia - ', 116, 90, 35, 25), ('547421', 1, 'Loungebank acacia - ', 115, 90, 35, 25), ('547427', 1, 'Tuinbank Tenerife me', 149, 68, 35, 21), ('547430', 1, 'Tuinset Costa - zwar', 85, 73, 70, 10), ('547431', 1, 'Tuinset Marbella - 3', 72, 62, 52, 17), ('547432', 1, 'Tuinbank Riviera - t', 120, 60, 37, 24), ('547435', 1, 'Tuinset Malaga - 4-d', 136, 86, 40, 24), ('547436', 1, 'Tuinstoel Malaga - 8', 85, 60, 57, 12), ('547437', 1, 'Loungeset Algarve - ', 168, 73, 41, 55), ('547438', 1, 'Tuinset Rhodos met k', 137, 70, 53, 39), ('547441', 1, 'Bistro set Rhodos -', 102, 88, 20, 27), ('547442', 1, 'Ligbed Sevilla - zwa', 193, 73, 10, 12), ('547443', 1, 'Ligbed Sevilla - gri', 193, 73, 10, 12), ('547710', 1, 'Tuinset Kreta met ku', 95, 80, 16, 16), ('594461', 1, 'Clipbox black - 80 l', 79, 70, 56, 3), ('594532', 1, 'Clipbox met wieltjes', 79, 70, 56, 3), ('594533', 1, 'Opbergbox met wieltj', 79, 70, 56, 5), ('608604', 1, 'Hangstoel zit', 125, 80, 70, 7), ('608605', 1, 'Hangstoel zit', 125, 80, 70, 7), ('608606', 1, 'Hangstoel zit', 125, 80, 70, 7), ('608608', 1, 'Hangstoel zit', 112, 108, 66, 13), ('608617', 1, 'Hangstoel Aqua - nat', 129, 79, 65, 10), ('608618', 1, 'Schommel ligbed - br', 160, 60, 56, 10), ('608629', 1, 'Bank met kussen Shan', 94, 91, 78, 10), ('608640', 1, 'Schommelstoel Rocky ', 120, 97, 51, 19), ('608645', 1, 'Hangstoel Ibiza met ', 170, 115, 75, 25), ('608646', 1, 'Hangstoel Ibiza met ', 170, 115, 75, 25), ('608647', 1, 'Hangstoel Ibiza met ', 170, 115, 75, 25), ('608648', 1, 'Hangstoel zit', 123, 82, 69, 10), ('608650', 1, 'Egg chair naturel - ', 94, 70, 67, 17), ('608651', 1, 'Egg chair zwart - 15', 94, 70, 66, 17), ('608652', 1, 'Hangstoel Hawaii zit', 125, 80, 70, 7), ('608653', 1, 'Hangstoel zit', 125, 80, 70, 7), ('608654', 1, 'Hangstoel zit', 110, 110, 66, 7), ('608655', 1, 'Hangstoel zit', 110, 110, 66, 7), ('609007', 1, '6 vakkenkast Zaha or', 140, 74, 25, 14), ('609009', 1, 'Dressoir Bali met 2 ', 105, 72, 46, 15), ('609014', 1, 'Webbing Java boekenk', 158, 78, 39, 27), ('609021', 1, 'Webbing Java dressoi', 126, 66, 47, 23), ('609022', 1, 'Webbing Java vakkenk', 118, 70, 47, 23), ('609026', 1, '5 vakkenkast Zaha or', 126, 55, 36, 14), ('609039', 1, 'SALONTAFEL UPPSALA NATUREL 120X60X40 CM MDF', 120, 60, 40, 21), ('609040', 1, 'VAKKENKAST UPPSALA 2DEUR BRUIN BRUIN H157X80X40 CM MDF', 78, 46, 160, 29), ('609060', 1, 'Vakkenkast Java met ', 157, 76, 38, 34), ('609061', 1, 'Kast Java met deurtj', 148, 76, 38, 28), ('609183', 1, 'Webbing kast Bandung', 146, 76, 44, 17), ('609184', 1, 'Webbing kast Bandung', 80, 72, 39, 13), ('609185', 1, 'Webbing dressoir Ban', 127, 80, 45, 21), ('609187', 1, 'Webbing kast smal Ba', 165, 49, 46, 16), ('609188', 1, 'Kast webbing Lombok ', 168, 43, 28, 23), ('609190', 1, 'Webbing Sumatra kast', 116, 76, 47, 23), ('609191', 1, 'Webbing Sumatra dres', 126, 49, 39, 16), ('609193', 1, 'Webbing Sumatra dres', 164, 53, 47, 26), ('609201', 1, 'Kast Tokyo met 2 deu', 128, 68, 43, 16), ('609208', 1, 'Webbing kast smal Ba', 160, 45, 40, 16), ('609210', 1, 'Webbing kast Bandung', 147, 76, 45, 21), ('609211', 1, 'Webbing kast Bandung', 85, 77, 44, 13), ('609212', 1, 'Webbing dressoir Ban', 126, 79, 46, 20), ('609214', 1, 'Webbing sidetable Ba', 88, 80, 45, 13), ('609221', 1, 'Webbing tv meubel Ba', 126, 48, 46, 16), ('609245', 1, 'Wandkast Memphis - 1', 109, 76, 45, 27), ('609246', 1, 'Dressoir Memphis - 9', 116, 60, 51, 27), ('609247', 1, 'Dressoir Memphis - 6', 125, 49, 46, 25), ('609250', 1, 'Webbing kast Bandung', 148, 76, 44, 22), ('609254', 1, 'Webbing kast Bandung', 147, 77, 45, 22), ('609301', 1, 'Kast vintage met sch', 85, 76, 44, 18), ('609303', 1, 'Tv kast vintage - br', 125, 46, 45, 16), ('609314', 1, 'Dressoir Memphis - 2', 86, 86, 45, 22), ('609321', 1, 'Hoge kast Luca met d', 165, 48, 46, 23), ('609400', 1, 'Vakkenkast Charlie m', 172, 72, 20, 22), ('609401', 1, 'Vakkenkast Charlie m', 173, 76, 9, 23), ('609406', 1, 'Kast Charlie met 5 l', 113, 73, 45, 27), ('609407', 1, 'Dressoir Charlie met', 130, 77, 44, 24), ('609409', 1, 'Vakkenkast Charlie -', 172, 62, 7, 12), ('609413', 1, 'Vakkenkast Charlie -', 172, 75, 7, 14), ('609414', 1, 'Vakkenkast Charlie X', 183, 124, 10, 32), ('609417', 1, 'Vakkenkast Charlie X', 182, 125, 11, 32), ('610249', 1, 'Ladekast Boston - 4 ', 84, 73, 37, 12), ('610250', 1, 'Ladekast Boston - 9 ', 93, 77, 37, 19), ('610251', 1, 'Ladekast Boston - 12', 124, 77, 37, 25), ('610267', 1, 'Apothekerskast - 15 ', 142, 82, 46, 42), ('610268', 1, 'Apothekerskast - 15 ', 141, 80, 46, 31), ('610270', 1, 'Apothekerskast - 15 ', 141, 81, 46, 30), ('610280', 1, 'Wijnkast Vino - hout', 122, 68, 37, 20), ('610282', 1, 'Wijnrekkast Elzas - ', 152, 59, 40, 22), ('614391', 1, 'Vakkenkast Liam - 12', 121, 80, 7, 16), ('614393', 1, 'Vakkenkast Mason XL ', 183, 123, 10, 33), ('614396', 1, 'Boekenkast Duncan - ', 171, 73, 7, 16), ('614446', 1, 'Vakkenkast zigzag - ', 150, 126, 8, 15), ('615401', 1, 'Bankje recycle Ubud ', 124, 59, 37, 18), ('615650', 1, 'Dressoir met cijfers', 124, 71, 46, 32), ('617261', 1, 'Lotus bed hoofdbord ', 160, 115, 4, 8), ('617262', 1, 'Lotus bed hoofdbord ', 180, 140, 4, 9), ('617316', 1, 'Bamboe bijzettafel r', 85, 60, 57, 6), ('617360', 1, 'Rotan pauwentroon - ', 147, 127, 80, 10), ('617370', 1, 'Eetkamerstoel Tegal ', 66, 66, 54, 15), ('617399', 1, 'Rotan lotus kuipstoe', 100, 90, 70, 6), ('617402', 1, 'Lotus kuipstoel - ro', 100, 90, 70, 6), ('617404', 1, 'Rotan fauteuil Bandu', 100, 64, 60, 5), ('617405', 1, 'Rotan fauteuil bandu', 86, 83, 69, 5), ('617406', 1, 'Rotan kuipstoel Sema', 77, 73, 66, 4), ('617407', 1, 'Kuipstoel Semarang -', 78, 72, 62, 5), ('617408', 1, 'Rotan bank bandung -', 126, 87, 80, 9), ('617410', 1, 'Rotan schommelstoel ', 105, 94, 56, 7), ('617420', 1, 'Rotan kuipstoel Rinj', 70, 70, 54, 4), ('617479', 1, 'Papasan Zit', 110, 110, 32, 6), ('617480', 1, 'Papasan Zit', 110, 110, 32, 6), ('617481', 1, 'Rotan loungebank Mam', 175, 117, 80, 15), ('617710', 1, 'Bank bahama - rotan ', 116, 75, 73, 6), ('623047', 1, 'Eetkamertafel Nova -', 96, 93, 19, 19), ('623050', 1, 'Teddy bankje/poef ba', 120, 62, 39, 11), ('623055', 1, 'Teddy loveseat faute', 121, 75, 74, 19), ('623056', 1, 'Teddy fauteuil - wit', 77, 75, 73, 13), ('623058', 1, 'Eetkamerbank Teddy -', 130, 95, 65, 33), ('623065', 1, 'Teddy loveseat faute', 120, 75, 74, 18), ('623066', 1, 'Teddy loveseat faute', 121, 74, 73, 18), ('623067', 1, 'Teddy fauteuil - zwa', 78, 74, 73, 14), ('623068', 1, 'Teddy fauteuil - amb', 77, 75, 73, 14), ('623074', 1, '2-zits bankje Didi c', 148, 75, 54, 22), ('623075', 1, '2-zits bankje Didi c', 148, 75, 52, 22), ('623330', 1, 'BANK BOUQUET MULTI 120X45X44 CM POLYESTER/MDF', 120, 45, 44, 13), ('623371', 1, 'Eetkamerstoel Yogya ', 85, 60, 57, 7), ('623510', 1, 'Armfauteuil Frida - ', 77, 71, 49, 14), ('623511', 1, 'Armfauteuil Frida - ', 77, 71, 49, 14), ('623512', 1, 'Armfauteuil Frida - ', 77, 69, 49, 14), ('623513', 1, 'Armfauteuil Frida - ', 78, 69, 49, 14), ('623514', 1, 'Armfauteuil Frida - ', 76, 72, 51, 14), ('623580', 1, 'Sofa Marilyn - beige', 80, 70, 43, 19), ('623581', 1, 'Sofa Marilyn - blauw', 80, 70, 44, 19), ('623582', 1, 'Sofa Marilyn - groen', 80, 70, 43, 19), ('623590', 1, 'Inklapbaar bureau Le', 6, 84, 114, 10), ('623591', 1, 'BUREAUSTOEL LEON ZWART ZWART 55,5X62,5X77 CM PP', 62, 55, 55, 6), ('623615', 1, 'Draaifauteuil - taupe - 74x68x66 cm', 74, 66, 68, 16), ('623700', 1, 'Eetkamertafel Olivia', 124, 123, 10, 20), ('623701', 1, 'Eetkamertafel Olivia', 124, 124, 12, 20), ('623702', 1, 'Eettafel Olivia ovaa', 190, 98, 12, 23), ('623704', 1, 'Eettafel Olivia vier', 87, 86, 13, 11), ('630366', 1, 'Vloerkleed riet - na', 153, 56, 43, 5), ('630368', 1, 'Vloerkleed riet - br', 153, 56, 43, 4); 2025-11-17 11:42:02.897 CET [5716] LOG: checkpoint starting: time 2025-11-17 11:42:03.751 CET [5716] LOG: checkpoint complete: wrote 8 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.761 s, sync=0.045 s, total=0.854 s; sync files=8, longest=0.011 s, average=0.006 s; distance=27 kB, estimate=357 kB; lsn=7/A99B4D60, redo lsn=7/A99B4D08 2025-11-17 11:46:34.413 CET [3396] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 11:47:02.739 CET [5716] LOG: checkpoint starting: time 2025-11-17 11:47:04.180 CET [5716] LOG: checkpoint complete: wrote 13 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.316 s, sync=0.080 s, total=1.441 s; sync files=11, longest=0.014 s, average=0.008 s; distance=79 kB, estimate=330 kB; lsn=7/A99C8C90, redo lsn=7/A99C8C38 2025-11-17 11:56:09.754 CET [1360] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 12:01:40.286 CET [2812] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-17 12:01:40.286 CET [2812] 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-17 12:07:02.187 CET [5716] LOG: checkpoint starting: time 2025-11-17 12:07:06.332 CET [5716] LOG: checkpoint complete: wrote 38 buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=4.040 s, sync=0.059 s, total=4.146 s; sync files=12, longest=0.008 s, average=0.005 s; distance=164 kB, estimate=313 kB; lsn=7/A99F1EC0, redo lsn=7/A99F1E68 2025-11-17 12:12:02.328 CET [5716] LOG: checkpoint starting: time 2025-11-17 12:12:03.614 CET [5716] LOG: checkpoint complete: wrote 12 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.191 s, sync=0.049 s, total=1.287 s; sync files=7, longest=0.013 s, average=0.007 s; distance=62 kB, estimate=288 kB; lsn=7/A9A018C8, redo lsn=7/A9A01870 2025-11-17 12:17:24.750 CET [7112] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-17 12:17:24.750 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-17 12:17:34.518 CET [3376] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-17 12:17:34.518 CET [3376] 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-17 12:18:05.539 CET [6028] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-17 12:18:05.539 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-17 12:22:02.603 CET [5716] LOG: checkpoint starting: time 2025-11-17 12:22:03.343 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.040 s, total=0.740 s; sync files=7, longest=0.010 s, average=0.006 s; distance=92 kB, estimate=268 kB; lsn=7/A9A18CB8, redo lsn=7/A9A18C60 2025-11-17 12:25:41.154 CET [4652] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 12:31:17.882 CET [4932] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 12:31:17.883 CET [6276] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 12:32:02.345 CET [5716] LOG: checkpoint starting: time 2025-11-17 12:32:06.919 CET [5716] LOG: checkpoint complete: wrote 42 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=4.477 s, sync=0.051 s, total=4.574 s; sync files=10, longest=0.007 s, average=0.006 s; distance=247 kB, estimate=266 kB; lsn=7/A9A56A90, redo lsn=7/A9A56A38 2025-11-17 12:36:19.500 CET [3568] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 12:36:19.501 CET [3804] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 12:37:02.930 CET [5716] LOG: checkpoint starting: time 2025-11-17 12:37:03.784 CET [5716] LOG: checkpoint complete: wrote 8 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.765 s, sync=0.044 s, total=0.854 s; sync files=7, longest=0.012 s, average=0.007 s; distance=28 kB, estimate=242 kB; lsn=7/A9A5DE60, redo lsn=7/A9A5DE08 2025-11-17 12:42:02.777 CET [5716] LOG: checkpoint starting: time 2025-11-17 12:42:03.295 CET [5716] LOG: checkpoint complete: wrote 5 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.440 s, sync=0.033 s, total=0.518 s; sync files=5, longest=0.010 s, average=0.007 s; distance=12 kB, estimate=219 kB; lsn=7/A9A610A0, redo lsn=7/A9A61048 2025-11-17 12:47:02.287 CET [5716] LOG: checkpoint starting: time 2025-11-17 12:47:03.032 CET [5716] LOG: checkpoint complete: wrote 7 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.662 s, sync=0.039 s, total=0.745 s; sync files=6, longest=0.011 s, average=0.007 s; distance=27 kB, estimate=200 kB; lsn=7/A9A67CC0, redo lsn=7/A9A67C68 2025-11-17 12:48:47.367 CET [1972] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 12:52:02.030 CET [5716] LOG: checkpoint starting: time 2025-11-17 12:52:03.799 CET [5716] LOG: checkpoint complete: wrote 16 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.640 s, sync=0.081 s, total=1.770 s; sync files=12, longest=0.015 s, average=0.007 s; distance=82 kB, estimate=188 kB; lsn=7/A9A7C818, redo lsn=7/A9A7C788 2025-11-17 12:52:56.523 CET [2992] LOG: could not send data to client: An existing connection was forcibly closed by the remote host. 2025-11-17 12:52:56.523 CET [2992] FATAL: connection to client lost 2025-11-17 12:53:06.794 CET [4480] WARNING: PID 3780 is not a PostgreSQL backend process 2025-11-17 12:53:17.705 CET [5816] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-17 12:53:17.705 CET [5816] 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-17 12:57:02.805 CET [5716] LOG: checkpoint starting: time 2025-11-17 12:57:08.921 CET [5716] LOG: checkpoint complete: wrote 56 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=5.991 s, sync=0.077 s, total=6.116 s; sync files=14, longest=0.009 s, average=0.006 s; distance=327 kB, estimate=327 kB; lsn=7/A9ACE598, redo lsn=7/A9ACE540 2025-11-17 12:57:44.271 CET [5672] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 12:57:44.272 CET [2892] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 12:57:44.273 CET [584] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 13:02:02.919 CET [5716] LOG: checkpoint starting: time 2025-11-17 13:02:05.160 CET [5716] LOG: checkpoint complete: wrote 20 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=2.181 s, sync=0.011 s, total=2.241 s; sync files=1, longest=0.011 s, average=0.011 s; distance=42 kB, estimate=298 kB; lsn=7/A9AD8DE0, redo lsn=7/A9AD8D88 2025-11-17 13:06:19.125 CET [6964] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 13:07:02.158 CET [5716] LOG: checkpoint starting: time 2025-11-17 13:07:02.669 CET [5716] LOG: checkpoint complete: wrote 5 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.435 s, sync=0.030 s, total=0.512 s; sync files=6, longest=0.009 s, average=0.005 s; distance=82 kB, estimate=277 kB; lsn=7/A9AED9A8, redo lsn=7/A9AED950 2025-11-17 13:11:03.881 CET [6284] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 13:11:33.351 CET [5884] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 13:12:02.663 CET [5716] LOG: checkpoint starting: time 2025-11-17 13:12:07.356 CET [5716] LOG: checkpoint complete: wrote 43 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=4.577 s, sync=0.070 s, total=4.694 s; sync files=14, longest=0.007 s, average=0.005 s; distance=256 kB, estimate=275 kB; lsn=7/A9B2DB20, redo lsn=7/A9B2DA90 2025-11-17 13:34:15.825 CET [5240] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 14:06:50.852 CET [5316] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 14:06:50.853 CET [5432] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 14:07:02.382 CET [5716] LOG: checkpoint starting: time 2025-11-17 14:07:02.996 CET [5716] LOG: checkpoint complete: wrote 6 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.546 s, sync=0.025 s, total=0.615 s; sync files=4, longest=0.007 s, average=0.007 s; distance=15 kB, estimate=249 kB; lsn=7/A9B31A30, redo lsn=7/A9B319D8 2025-11-17 14:08:07.013 CET [6832] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 14:08:07.014 CET [2028] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 14:09:49.435 CET [2064] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 14:09:49.436 CET [5632] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 14:12:03.003 CET [5716] LOG: checkpoint starting: time 2025-11-17 14:12:03.528 CET [5716] LOG: checkpoint complete: wrote 5 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.432 s, sync=0.032 s, total=0.525 s; sync files=5, longest=0.011 s, average=0.007 s; distance=14 kB, estimate=225 kB; lsn=7/A9B35540, redo lsn=7/A9B354E8 2025-11-17 14:17:21.106 CET [4136] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 14:17:50.188 CET [3376] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 14:34:00.411 CET [1656] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-17 14:34:00.411 CET [1656] 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-17 14:34:21.444 CET [5140] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-17 14:34:21.444 CET [5140] 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-17 14:37:03.569 CET [5716] LOG: checkpoint starting: time 2025-11-17 14:37:11.894 CET [5716] LOG: checkpoint complete: wrote 76 buffers (0.5%); 0 WAL file(s) added, 0 removed, 0 recycled; write=8.181 s, sync=0.093 s, total=8.326 s; sync files=14, longest=0.015 s, average=0.007 s; distance=385 kB, estimate=385 kB; lsn=7/A9B9CBD8, redo lsn=7/A9B959C0 2025-11-17 14:38:02.815 CET [2460] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 14:38:02.815 CET [404] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 14:42:03.901 CET [5716] LOG: checkpoint starting: time 2025-11-17 14:42:10.259 CET [5716] LOG: checkpoint complete: wrote 58 buffers (0.4%); 0 WAL file(s) added, 0 removed, 0 recycled; write=6.214 s, sync=0.094 s, total=6.358 s; sync files=17, longest=0.017 s, average=0.006 s; distance=423 kB, estimate=423 kB; lsn=7/A9BFF940, redo lsn=7/A9BFF8B0 2025-11-17 14:45:56.409 CET [4872] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 14:45:56.410 CET [2056] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 14:47:03.274 CET [5716] LOG: checkpoint starting: time 2025-11-17 14:47:09.527 CET [5716] LOG: checkpoint complete: wrote 58 buffers (0.4%); 0 WAL file(s) added, 0 removed, 0 recycled; write=6.115 s, sync=0.092 s, total=6.254 s; sync files=15, longest=0.016 s, average=0.007 s; distance=352 kB, estimate=416 kB; lsn=7/A9C579D8, redo lsn=7/A9C57948 2025-11-17 14:47:13.450 CET [6028] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 14:50:17.082 CET [1656] ERROR: column "none" named in key does not exist at character 169 2025-11-17 14:50:17.082 CET [1656] STATEMENT: CREATE TABLE sonex.app_global_settings ( key character varying(100), value_integer integer, value_bool boolean, value_text character varying(1000), PRIMARY KEY (None) ); ALTER TABLE IF EXISTS sonex.app_global_settings OWNER to postgres; 2025-11-17 14:50:38.884 CET [1656] ERROR: column "none" named in key does not exist at character 178 2025-11-17 14:50:38.884 CET [1656] STATEMENT: CREATE TABLE sonex.app_global_settings ( key character varying(100) NOT NULL, value_integer integer, value_bool boolean, value_text character varying(1000), PRIMARY KEY (None) ); ALTER TABLE IF EXISTS sonex.app_global_settings OWNER to postgres; 2025-11-17 14:51:48.132 CET [1656] ERROR: column "none" named in key does not exist at character 178 2025-11-17 14:51:48.132 CET [1656] STATEMENT: CREATE TABLE sonex.app_global_settings ( key character varying(100) NOT NULL, value_integer integer, value_bool boolean, value_text character varying(1000), PRIMARY KEY (None, key) ); ALTER TABLE IF EXISTS sonex.app_global_settings OWNER to postgres; 2025-11-17 14:52:10.096 CET [444] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-17 14:52:10.096 CET [444] 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-17 14:53:16.870 CET [7112] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 14:57:03.520 CET [5716] LOG: checkpoint starting: time 2025-11-17 14:57:07.230 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.178 s, total=3.710 s; sync files=31, longest=0.011 s, average=0.006 s; distance=172 kB, estimate=392 kB; lsn=7/A9C82AB0, redo lsn=7/A9C82A58 2025-11-17 15:06:36.659 CET [4544] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 15:06:45.391 CET [5816] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 15:09:39.418 CET [3124] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 15:09:39.418 CET [5544] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 15:09:39.419 CET [2772] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 15:10:27.193 CET [2412] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 15:10:27.194 CET [6084] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 15:11:45.427 CET [4872] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 15:11:45.428 CET [4576] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 15:12:03.236 CET [5716] LOG: checkpoint starting: time 2025-11-17 15:12:04.305 CET [5716] LOG: checkpoint complete: wrote 10 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.971 s, sync=0.043 s, total=1.069 s; sync files=7, longest=0.013 s, average=0.007 s; distance=43 kB, estimate=357 kB; lsn=7/A9C8D708, redo lsn=7/A9C8D6B0 2025-11-17 15:26:00.126 CET [4788] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-17 15:26:00.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-17 15:26:11.319 CET [4156] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-17 15:26:11.319 CET [4156] 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-17 15:27:03.313 CET [5716] LOG: checkpoint starting: time 2025-11-17 15:27:04.619 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.066 s, total=1.307 s; sync files=9, longest=0.012 s, average=0.008 s; distance=32 kB, estimate=324 kB; lsn=7/A9C95998, redo lsn=7/A9C95940 2025-11-17 15:29:24.844 CET [2152] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 15:45:31.738 CET [4256] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 15:45:31.739 CET [1804] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 15:47:03.616 CET [5716] LOG: checkpoint starting: time 2025-11-17 15:47:04.139 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.041 s, total=0.524 s; sync files=5, longest=0.016 s, average=0.009 s; distance=16 kB, estimate=293 kB; lsn=7/A9C999E8, redo lsn=7/A9C99990 2025-11-17 15:55:10.924 CET [6044] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 15:55:10.925 CET [5684] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 15:56:07.828 CET [6528] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 15:56:07.829 CET [5204] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 16:01:32.359 CET [6944] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 16:01:32.360 CET [6860] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 16:04:56.622 CET [5620] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 16:04:56.622 CET [7064] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 16:05:55.841 CET [5848] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 16:05:55.841 CET [5612] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 16:22:49.945 CET [6512] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-17 16:22:49.945 CET [6512] 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-17 16:23:23.501 CET [6944] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-17 16:23:23.501 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-17 16:23:23.951 CET [2372] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-17 16:23:23.951 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-17 16:27:03.164 CET [5716] LOG: checkpoint starting: time 2025-11-17 16:27:08.090 CET [5716] LOG: checkpoint complete: wrote 44 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=4.684 s, sync=0.188 s, total=4.926 s; sync files=39, longest=0.009 s, average=0.005 s; distance=191 kB, estimate=283 kB; lsn=7/A9CC9978, redo lsn=7/A9CC9920 2025-11-17 16:31:25.331 CET [6296] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-17 16:31:25.331 CET [6296] 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-17 16:37:03.098 CET [5716] LOG: checkpoint starting: time 2025-11-17 16:37:04.399 CET [5716] LOG: checkpoint complete: wrote 12 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.190 s, sync=0.049 s, total=1.301 s; sync files=10, longest=0.008 s, average=0.005 s; distance=1 kB, estimate=255 kB; lsn=7/A9CC9E38, redo lsn=7/A9CC9DE0 2025-11-17 16:42:03.388 CET [5716] LOG: checkpoint starting: time 2025-11-17 16:42:03.795 CET [5716] LOG: checkpoint complete: wrote 4 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.325 s, sync=0.023 s, total=0.408 s; sync files=4, longest=0.007 s, average=0.006 s; distance=1 kB, estimate=230 kB; lsn=7/A9CCA2D8, redo lsn=7/A9CCA280 2025-11-17 16:43:17.124 CET [5140] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 16:46:57.268 CET [5556] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 16:46:57.269 CET [2804] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 16:52:29.519 CET [444] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 16:53:51.905 CET [3460] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 16:53:51.906 CET [3780] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 16:55:46.914 CET [5564] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 16:55:46.915 CET [4456] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 17:02:57.134 CET [6592] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 17:02:57.134 CET [5176] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 17:08:10.706 CET [3988] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 17:08:10.706 CET [6132] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 17:11:41.275 CET [4332] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 17:11:41.276 CET [2028] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 17:12:43.786 CET [4620] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 17:12:43.787 CET [1088] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 17:17:03.817 CET [5716] LOG: checkpoint starting: time 2025-11-17 17:17:04.785 CET [5716] LOG: checkpoint complete: wrote 9 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.869 s, sync=0.046 s, total=0.969 s; sync files=7, longest=0.009 s, average=0.007 s; distance=32 kB, estimate=210 kB; lsn=7/A9CD26A8, redo lsn=7/A9CD2650 2025-11-17 17:26:11.806 CET [4788] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 17:26:37.607 CET [4156] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 17:55:05.778 CET [3708] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 17:55:05.779 CET [2972] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 17:56:23.975 CET [6860] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 17:56:23.976 CET [2536] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 17:57:03.808 CET [5716] LOG: checkpoint starting: time 2025-11-17 17:57:03.977 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.012 s, total=0.170 s; sync files=2, longest=0.007 s, average=0.006 s; distance=1 kB, estimate=189 kB; lsn=7/A9CD2C08, redo lsn=7/A9CD2BB0 2025-11-17 17:59:36.270 CET [6284] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 17:59:36.271 CET [4688] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 18:02:03.966 CET [5716] LOG: checkpoint starting: time 2025-11-17 18:02:04.140 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.174 s; sync files=2, longest=0.009 s, average=0.008 s; distance=1 kB, estimate=170 kB; lsn=7/A9CD32B8, redo lsn=7/A9CD3260 2025-11-17 18:07:03.145 CET [5716] LOG: checkpoint starting: time 2025-11-17 18:07:03.318 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.173 s; sync files=2, longest=0.009 s, average=0.007 s; distance=2 kB, estimate=153 kB; lsn=7/A9CD3BA8, redo lsn=7/A9CD3B50 2025-11-17 18:08:12.766 CET [5412] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 18:08:12.767 CET [2932] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 18:09:29.273 CET [4524] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 18:09:29.274 CET [7004] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 18:10:50.353 CET [6372] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-17 18:10:50.353 CET [6372] 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-17 18:10:50.480 CET [2504] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-17 18:10:50.480 CET [2504] 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-17 18:12:03.327 CET [5716] LOG: checkpoint starting: time 2025-11-17 18:12:03.495 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.014 s, total=0.169 s; sync files=2, longest=0.008 s, average=0.007 s; distance=4 kB, estimate=138 kB; lsn=7/A9CD4CC0, redo lsn=7/A9CD4C68 2025-11-17 18:12:55.234 CET [6784] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-17 18:12:55.234 CET [6784] 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-17 18:12:55.720 CET [5032] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-17 18:12:55.720 CET [5032] 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-17 18:22:03.497 CET [5716] LOG: checkpoint starting: time 2025-11-17 18:22:03.668 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.172 s; sync files=2, longest=0.009 s, average=0.009 s; distance=5 kB, estimate=125 kB; lsn=7/A9CD60D0, redo lsn=7/A9CD6078 2025-11-17 18:22:40.858 CET [3312] WARNING: PID 4136 is not a PostgreSQL backend process 2025-11-17 18:22:44.736 CET [5852] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-17 18:22:44.736 CET [5852] 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-17 18:22:58.620 CET [5852] ERROR: null value in column "seq" of relation "shipbk_print_jobs" violates not-null constraint 2025-11-17 18:22:58.620 CET [5852] DETAIL: Failing row contains (88439629, 1, null, BK817587560, 0071483527, 71563505, XE0071483527, XE0071483527, DO, SHIP_UNIT, Els van Horssen, Donkerstraat, 6, null, Aalst, 5308KB, NL, Webshop Xenos NL, Schutweg, 8, Waalwijk, 5145 NP, NL, Waiting for registration, {}, 66.000, 68.000, 74.000, 332112.000, 16.000, null, 623615, null, null, [{"Art": "623615", "Qty": 1, "Width": 66, "Height": 68, "Length"..., 630983240, klavertje4@kliksafe.nl, null, 2025-11-17 07:00:00, 2025-11-18 07:00:00, 2025-11-17 14:43:27.190896). 2025-11-17 18:22:58.620 CET [5852] STATEMENT: UPDATE sonex.shipbk_print_jobs SET seq = $1::integer WHERE job_id = 88439629 AND row_nr = 1 AND seq = 1; 2025-11-17 18:23:00.345 CET [6512] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 18:23:33.704 CET [6944] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 18:23:34.173 CET [2372] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 18:24:50.942 CET [5720] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-17 18:24:50.942 CET [5720] 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-17 18:27:03.653 CET [5716] LOG: checkpoint starting: time 2025-11-17 18:27:04.282 CET [5716] LOG: checkpoint complete: wrote 6 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.544 s, sync=0.034 s, total=0.629 s; sync files=7, longest=0.007 s, average=0.005 s; distance=101 kB, estimate=123 kB; lsn=7/A9CEF758, redo lsn=7/A9CEF700 2025-11-17 18:27:12.139 CET [1028] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 18:35:41.297 CET [4456] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-17 18:35:41.297 CET [4456] 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-17 18:37:03.291 CET [5716] LOG: checkpoint starting: time 2025-11-17 18:37:08.146 CET [5716] LOG: checkpoint complete: wrote 44 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=4.711 s, sync=0.092 s, total=4.855 s; sync files=13, longest=0.014 s, average=0.007 s; distance=359 kB, estimate=359 kB; lsn=7/A9D49728, redo lsn=7/A9D496D0 2025-11-17 18:38:18.687 CET [1656] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 18:38:18.796 CET [6296] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 18:42:03.155 CET [5716] LOG: checkpoint starting: time 2025-11-17 18:42:06.442 CET [5716] LOG: checkpoint complete: wrote 30 buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=3.175 s, sync=0.058 s, total=3.288 s; sync files=9, longest=0.011 s, average=0.007 s; distance=158 kB, estimate=339 kB; lsn=7/A9D70FB8, redo lsn=7/A9D70F28 2025-11-17 18:52:03.444 CET [5716] LOG: checkpoint starting: time 2025-11-17 18:52:06.379 CET [5716] LOG: checkpoint complete: wrote 27 buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=2.839 s, sync=0.051 s, total=2.935 s; sync files=8, longest=0.015 s, average=0.007 s; distance=115 kB, estimate=317 kB; lsn=7/A9D8DCA8, redo lsn=7/A9D8DC18 2025-11-17 18:57:03.383 CET [5716] LOG: checkpoint starting: time 2025-11-17 18:57:08.332 CET [5716] LOG: checkpoint complete: wrote 45 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=4.829 s, sync=0.069 s, total=4.949 s; sync files=12, longest=0.011 s, average=0.006 s; distance=253 kB, estimate=310 kB; lsn=7/A9DCD378, redo lsn=7/A9DCD2E8 2025-11-17 19:02:03.336 CET [5716] LOG: checkpoint starting: time 2025-11-17 19:02:08.102 CET [5716] LOG: checkpoint complete: wrote 44 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=4.691 s, sync=0.028 s, total=4.767 s; sync files=6, longest=0.006 s, average=0.005 s; distance=202 kB, estimate=300 kB; lsn=7/A9DFFCD0, redo lsn=7/A9DFFC78 2025-11-17 19:06:00.055 CET [2064] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 19:06:00.055 CET [1988] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 19:07:03.089 CET [5716] LOG: checkpoint starting: time 2025-11-17 19:07:08.258 CET [5716] LOG: checkpoint complete: wrote 47 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=5.027 s, sync=0.089 s, total=5.169 s; sync files=13, longest=0.017 s, average=0.007 s; distance=348 kB, estimate=348 kB; lsn=7/A9E56E80, redo lsn=7/A9E56E28 2025-11-17 19:12:03.246 CET [5716] LOG: checkpoint starting: time 2025-11-17 19:12:09.492 CET [5716] LOG: checkpoint complete: wrote 57 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=6.128 s, sync=0.071 s, total=6.247 s; sync files=14, longest=0.008 s, average=0.006 s; distance=345 kB, estimate=348 kB; lsn=7/A9EAD430, redo lsn=7/A9EAD3D8 2025-11-17 20:01:37.717 CET [4828] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 20:02:03.528 CET [5716] LOG: checkpoint starting: time 2025-11-17 20:02:06.102 CET [5716] LOG: checkpoint complete: wrote 23 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=2.510 s, sync=0.013 s, total=2.575 s; sync files=1, longest=0.013 s, average=0.013 s; distance=21 kB, estimate=315 kB; lsn=7/A9EB29F8, redo lsn=7/A9EB2968 2025-11-17 20:10:44.299 CET [4648] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 20:10:44.300 CET [5476] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 20:11:24.187 CET [5068] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 20:11:45.466 CET [4136] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 20:12:03.092 CET [5716] LOG: checkpoint starting: time 2025-11-17 20:12:03.259 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.012 s, total=0.167 s; sync files=2, longest=0.007 s, average=0.006 s; distance=7 kB, estimate=284 kB; lsn=7/A9EB4728, redo lsn=7/A9EB46D0 2025-11-17 20:13:05.416 CET [6784] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 20:13:06.920 CET [5032] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 20:15:04.585 CET [7148] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 20:15:04.585 CET [6108] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 20:17:03.255 CET [5716] LOG: checkpoint starting: time 2025-11-17 20:17:09.725 CET [5716] LOG: checkpoint complete: wrote 59 buffers (0.4%); 0 WAL file(s) added, 0 removed, 0 recycled; write=6.332 s, sync=0.091 s, total=6.470 s; sync files=17, longest=0.009 s, average=0.006 s; distance=343 kB, estimate=343 kB; lsn=7/A9F0A710, redo lsn=7/A9F0A680 2025-11-17 20:23:38.260 CET [5852] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 21:03:55.679 CET [5488] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-17 21:03:55.679 CET [5488] 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-17 21:03:56.099 CET [2484] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-17 21:03:56.099 CET [2484] 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-17 21:03:58.032 CET [4412] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-17 21:03:58.032 CET [4412] 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-17 21:04:19.775 CET [6376] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-17 21:04:19.775 CET [6376] 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-17 21:04:19.886 CET [6376] ERROR: syntax error at or near "DONE" at character 1 2025-11-17 21:04:19.886 CET [6376] STATEMENT: DONE 2025-11-17 21:07:03.790 CET [5716] LOG: checkpoint starting: time 2025-11-17 21:07:06.703 CET [5716] LOG: checkpoint complete: wrote 27 buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=2.840 s, sync=0.026 s, total=2.914 s; sync files=4, longest=0.014 s, average=0.007 s; distance=32 kB, estimate=312 kB; lsn=7/A9F12AA0, redo lsn=7/A9F12A48 2025-11-17 21:12:03.693 CET [5716] LOG: checkpoint starting: time 2025-11-17 21:12:04.445 CET [5716] LOG: checkpoint complete: wrote 7 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.661 s, sync=0.039 s, total=0.752 s; sync files=6, longest=0.009 s, average=0.007 s; distance=25 kB, estimate=284 kB; lsn=7/A9F19048, redo lsn=7/A9F18FF0 2025-11-17 21:17:03.436 CET [5716] LOG: checkpoint starting: time 2025-11-17 21:17:03.610 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.015 s, total=0.174 s; sync files=2, longest=0.009 s, average=0.008 s; distance=8 kB, estimate=256 kB; lsn=7/A9F1B0A8, redo lsn=7/A9F1B050 2025-11-17 21:52:03.618 CET [5716] LOG: checkpoint starting: time 2025-11-17 21:52:03.786 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.168 s; sync files=2, longest=0.009 s, average=0.007 s; distance=1 kB, estimate=231 kB; lsn=7/A9F1B748, redo lsn=7/A9F1B6F0 2025-11-17 21:57:03.774 CET [5716] LOG: checkpoint starting: time 2025-11-17 21:57:03.944 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.171 s; sync files=2, longest=0.009 s, average=0.007 s; distance=2 kB, estimate=208 kB; lsn=7/A9F1C090, redo lsn=7/A9F1BFE8 2025-11-17 22:07:03.939 CET [5716] LOG: checkpoint starting: time 2025-11-17 22:07:04.102 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.013 s, total=0.164 s; sync files=2, longest=0.007 s, average=0.007 s; distance=2 kB, estimate=187 kB; lsn=7/A9F1CB08, redo lsn=7/A9F1CAB0 2025-11-17 22:12:39.013 CET [2504] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 22:12:39.138 CET [5720] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 22:14:53.079 CET [4456] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 22:44:01.076 CET [6232] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-17 22:44:01.076 CET [6232] 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-17 23:04:29.491 CET [5488] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 23:05:36.711 CET [6376] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 23:05:41.062 CET [2484] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 23:05:41.218 CET [4412] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-17 23:17:03.133 CET [5716] LOG: checkpoint starting: time 2025-11-17 23:17:03.427 CET [5716] LOG: checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.210 s, sync=0.028 s, total=0.295 s; sync files=3, longest=0.012 s, average=0.010 s; distance=12 kB, estimate=170 kB; lsn=7/A9F1FD40, redo lsn=7/A9F1FCE8 2025-11-17 23:21:15.063 CET [6764] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-17 23:21:15.063 CET [6764] 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-17 23:22:03.417 CET [5716] LOG: checkpoint starting: time 2025-11-17 23:22:03.708 CET [5716] LOG: checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.217 s, sync=0.020 s, total=0.292 s; sync files=3, longest=0.009 s, average=0.007 s; distance=12 kB, estimate=154 kB; lsn=7/A9F23110, redo lsn=7/A9F230B8 2025-11-17 23:27:03.704 CET [5716] LOG: checkpoint starting: time 2025-11-17 23:27:03.872 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.169 s; sync files=2, longest=0.009 s, average=0.007 s; distance=3 kB, estimate=139 kB; lsn=7/A9F23F30, redo lsn=7/A9F23ED8