2025-11-15 01:29:47.520 CET [4476] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-15 01:51:05.765 CET [5128] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-15 01:51:22.963 CET [404] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-15 10:20:16.011 CET [4960] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-15 10:20:16.011 CET [4960] 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-15 10:20:16.020 CET [2732] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-15 10:20:16.020 CET [2732] 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-15 10:21:01.586 CET [3872] WARNING: PID 5128 is not a PostgreSQL backend process 2025-11-15 10:21:01.934 CET [4140] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-15 10:21:01.934 CET [4140] 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-15 10:21:01.987 CET [2300] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-15 10:21:01.987 CET [2300] 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-15 10:26:59.581 CET [5716] LOG: checkpoint starting: time 2025-11-15 10:27:01.477 CET [5716] LOG: checkpoint complete: wrote 17 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.747 s, sync=0.095 s, total=1.896 s; sync files=12, longest=0.018 s, average=0.008 s; distance=33 kB, estimate=1099 kB; lsn=7/A92C36F8, redo lsn=7/A92C3668 2025-11-15 11:15:12.505 CET [2792] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-15 11:15:12.505 CET [2792] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2025-11-15 11:16:59.527 CET [5716] LOG: checkpoint starting: time 2025-11-15 11:17:10.131 CET [5716] LOG: checkpoint complete: wrote 96 buffers (0.6%); 0 WAL file(s) added, 0 removed, 0 recycled; write=10.357 s, sync=0.184 s, total=10.605 s; sync files=32, longest=0.016 s, average=0.006 s; distance=714 kB, estimate=1060 kB; lsn=7/A9376228, redo lsn=7/A93761D0 2025-11-15 11:21:59.135 CET [5716] LOG: checkpoint starting: time 2025-11-15 11:21:59.405 CET [5716] LOG: checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.219 s, sync=0.006 s, total=0.271 s; sync files=1, longest=0.006 s, average=0.006 s; distance=7 kB, estimate=955 kB; lsn=7/A9378068, redo lsn=7/A9377FF8 2025-11-15 11:26:59.413 CET [5716] LOG: checkpoint starting: time 2025-11-15 11:26:59.925 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.031 s, total=0.513 s; sync files=4, longest=0.012 s, average=0.008 s; distance=11 kB, estimate=861 kB; lsn=7/A937ADB8, redo lsn=7/A937AD60 2025-11-15 11:37:49.510 CET [6100] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-15 11:37:49.510 CET [6100] 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-15 11:41:59.919 CET [5716] LOG: checkpoint starting: time 2025-11-15 11:42:00.542 CET [5716] LOG: checkpoint complete: wrote 5 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.542 s, sync=0.026 s, total=0.624 s; sync files=4, longest=0.008 s, average=0.007 s; distance=15 kB, estimate=776 kB; lsn=7/A937ED48, redo lsn=7/A937ECF0 2025-11-15 12:21:22.777 CET [2300] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-15 12:21:59.561 CET [5716] LOG: checkpoint starting: time 2025-11-15 12:21:59.949 CET [5716] LOG: checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.320 s, sync=0.017 s, total=0.389 s; sync files=2, longest=0.010 s, average=0.009 s; distance=8 kB, estimate=699 kB; lsn=7/A9380E18, redo lsn=7/A9380DC0 2025-11-15 12:25:11.470 CET [2744] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-15 12:25:11.470 CET [2744] 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-15 12:25:12.032 CET [6020] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-15 12:25:12.032 CET [6020] 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-15 12:25:12.138 CET [6020] ERROR: syntax error at or near "SENDERCOUNTRY" at character 1 2025-11-15 12:25:12.138 CET [6020] STATEMENT: SENDERCOUNTRY 2025-11-15 13:15:22.631 CET [2792] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-15 13:24:46.120 CET [2732] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-15 13:26:59.953 CET [5716] LOG: checkpoint starting: time 2025-11-15 13:27:00.348 CET [5716] LOG: checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.328 s, sync=0.023 s, total=0.396 s; sync files=2, longest=0.013 s, average=0.012 s; distance=16 kB, estimate=631 kB; lsn=7/A9384E88, redo lsn=7/A9384E30 2025-11-15 13:28:26.474 CET [6068] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-15 13:28:26.474 CET [6068] 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-15 13:28:26.949 CET [4396] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-15 13:28:26.949 CET [4396] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2025-11-15 13:31:14.436 CET [5920] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-15 13:31:14.437 CET [3804] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-15 13:38:03.035 CET [6100] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-15 13:49:47.214 CET [1616] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-15 13:49:47.214 CET [1616] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2025-11-15 13:50:13.466 CET [2512] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-15 13:50:13.466 CET [2512] 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-15 13:52:42.954 CET [2512] ERROR: column "qwstimate" does not exist at character 22 2025-11-15 13:52:42.954 CET [2512] HINT: Perhaps you meant to reference the column "retourline.qestimate". 2025-11-15 13:52:42.954 CET [2512] STATEMENT: SELECT artnr as art, qwstimate as qy FROM wms.retourline WHERE referencenr = 'XE0071493716' LIMIT 100 2025-11-15 13:52:47.083 CET [2512] ERROR: syntax error at or near "qexpected" at character 1 2025-11-15 13:52:47.083 CET [2512] STATEMENT: qexpected 2025-11-15 13:52:52.762 CET [2512] ERROR: column "qwstimate" does not exist at character 22 2025-11-15 13:52:52.762 CET [2512] HINT: Perhaps you meant to reference the column "retourline.qestimate". 2025-11-15 13:52:52.762 CET [2512] STATEMENT: SELECT artnr as art, qwstimate as qy FROM wms.retourline WHERE referencenr = 'XE0071493716' LIMIT 100 2025-11-15 14:22:37.551 CET [2512] ERROR: column "retourline.retournr" must appear in the GROUP BY clause or be used in an aggregate function at character 8 2025-11-15 14:22:37.551 CET [2512] STATEMENT: SELECT * FROM wms.retourline WHERE referencenr = 'XE0071493716' GROUP BY artnr 2025-11-15 14:22:43.240 CET [2512] ERROR: column "retourline.retournr" must appear in the GROUP BY clause or be used in an aggregate function at character 8 2025-11-15 14:22:43.240 CET [2512] STATEMENT: SELECT * FROM wms.retourline WHERE referencenr = 'XE0071493716' GROUP BY artnr 2025-11-15 14:25:21.604 CET [2744] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-15 14:25:41.518 CET [6020] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-15 14:27:16.987 CET [1892] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-15 14:27:16.987 CET [1892] 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-15 14:27:16.996 CET [6596] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-15 14:27:16.996 CET [6596] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2025-11-15 14:30:50.803 CET [2512] ERROR: aggregate function calls cannot be nested at character 739 2025-11-15 14:30:50.803 CET [2512] 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, p.A20 AS RECIPIENTNAME, p.A21 AS RECIPIENTSTREET, p.A22 AS RECIPIENTHOUSENR, p.A26 AS RECIPIENTATT, p.A25 AS RECIPIENTTOWN, p.A24 AS RECIPIENTZIPCODE, p.A23 AS RECIPIENTCOUNTRY, p.A11 AS SENDERNAME, p.A12 AS SENDERSTREET, p.A13 AS SENDERHOUSENR, p.A16 AS SENDEROWN, p.A15 AS SENDERZIPCODE, p.A14 AS SENDERCOUNTRY, r.items AS retour_items FROM wms.PQueueSQLData p LEFT JOIN ( SELECT referencenr, jsonb_agg(jsonb_build_object('art', artnr, 'qty', SUM(qexpected))) AS items FROM wms.retourline GROUP BY referencenr ) r ON r.referencenr = p.A39 WHERE p.A38 = 'SHIPBK' LIMIT 1; 2025-11-15 14:30:54.912 CET [2512] ERROR: aggregate function calls cannot be nested at character 739 2025-11-15 14:30:54.912 CET [2512] 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, p.A20 AS RECIPIENTNAME, p.A21 AS RECIPIENTSTREET, p.A22 AS RECIPIENTHOUSENR, p.A26 AS RECIPIENTATT, p.A25 AS RECIPIENTTOWN, p.A24 AS RECIPIENTZIPCODE, p.A23 AS RECIPIENTCOUNTRY, p.A11 AS SENDERNAME, p.A12 AS SENDERSTREET, p.A13 AS SENDERHOUSENR, p.A16 AS SENDEROWN, p.A15 AS SENDERZIPCODE, p.A14 AS SENDERCOUNTRY, r.items AS retour_items FROM wms.PQueueSQLData p LEFT JOIN ( SELECT referencenr, jsonb_agg(jsonb_build_object('art', artnr, 'qty', SUM(qexpected))) AS items FROM wms.retourline GROUP BY referencenr ) r ON r.referencenr = p.A39 WHERE p.A38 = 'SHIPBK' LIMIT 1; 2025-11-15 14:31:59.440 CET [5716] LOG: checkpoint starting: time 2025-11-15 14:32:00.202 CET [5716] LOG: checkpoint complete: wrote 7 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.651 s, sync=0.053 s, total=0.762 s; sync files=7, longest=0.012 s, average=0.008 s; distance=29 kB, estimate=571 kB; lsn=7/A938C558, redo lsn=7/A938C500 2025-11-15 14:47:35.488 CET [5156] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-15 14:47:35.488 CET [5156] 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-15 15:06:59.247 CET [5716] LOG: checkpoint starting: time 2025-11-15 15:06:59.406 CET [5716] LOG: checkpoint complete: wrote 1 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.103 s, sync=0.010 s, total=0.160 s; sync files=1, longest=0.010 s, average=0.010 s; distance=8 kB, estimate=514 kB; lsn=7/A938E5A8, redo lsn=7/A938E550 2025-11-15 15:11:06.273 CET [3548] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-15 15:11:06.273 CET [3548] 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-15 15:11:32.391 CET [3548] ERROR: relation "artpackgvw" does not exist at character 15 2025-11-15 15:11:32.391 CET [3548] STATEMENT: SELECT * FROM ArtPackGVW LIMIT 100 2025-11-15 15:15:17.605 CET [3548] ERROR: column "iunutyqyf" does not exist at character 57 2025-11-15 15:15:17.605 CET [3548] HINT: Perhaps you meant to reference the column "artpackgvw.iunitqyf". 2025-11-15 15:15:17.605 CET [3548] STATEMENT: SELECT * FROM wms.ArtPackGVW WHERE artnr = '830441' and iunutyqyf = 'SU' 2025-11-15 15:53:20.533 CET [4980] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-15 15:53:20.533 CET [4980] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2025-11-15 15:56:59.451 CET [5716] LOG: checkpoint starting: time 2025-11-15 15:57:04.701 CET [5716] LOG: checkpoint complete: wrote 47 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=5.054 s, sync=0.143 s, total=5.250 s; sync files=27, longest=0.011 s, average=0.006 s; distance=247 kB, estimate=488 kB; lsn=7/A93CC348, redo lsn=7/A93CC2B8 2025-11-15 16:07:57.367 CET [6436] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-15 16:14:33.143 CET [1020] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-15 16:18:26.066 CET [5756] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-15 16:18:26.067 CET [6412] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-15 16:21:59.738 CET [5716] LOG: checkpoint starting: time 2025-11-15 16:22:03.238 CET [5716] LOG: checkpoint complete: wrote 32 buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=3.381 s, sync=0.070 s, total=3.500 s; sync files=12, longest=0.010 s, average=0.006 s; distance=109 kB, estimate=450 kB; lsn=7/A93E7758, redo lsn=7/A93E76C8 2025-11-15 16:28:11.020 CET [6596] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-15 16:28:35.049 CET [4396] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-15 16:40:07.782 CET [2512] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-15 16:45:43.300 CET [1616] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-15 16:47:45.176 CET [6068] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-15 17:18:34.150 CET [3548] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-15 17:44:13.026 CET [1448] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-15 17:44:13.026 CET [1448] 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-15 17:44:21.379 CET [6380] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-15 17:44:21.379 CET [6380] 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-15 17:44:29.644 CET [5780] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-15 17:44:29.644 CET [5780] 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-15 17:44:32.044 CET [5924] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-15 17:44:32.044 CET [5924] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2025-11-15 17:44:32.197 CET [5180] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-15 17:44:32.197 CET [5180] 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-15 17:44:41.696 CET [5812] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-15 17:44:41.696 CET [5812] 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-15 17:49:22.675 CET [4776] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-15 17:49:22.675 CET [4776] 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-15 17:50:56.070 CET [3008] LOG: could not send data to client: An existing connection was forcibly closed by the remote host. 2025-11-15 17:50:56.070 CET [3008] STATEMENT: SELECT * FROM sonex.v_shipbk_source 2025-11-15 17:50:56.070 CET [3008] FATAL: connection to client lost 2025-11-15 17:50:56.070 CET [3008] STATEMENT: SELECT * FROM sonex.v_shipbk_source 2025-11-15 17:51:52.572 CET [6752] ERROR: column "items" of relation "shipbk_print_jobs" does not exist at character 364 2025-11-15 17:51:52.572 CET [6752] STATEMENT: INSERT INTO sonex.shipbk_print_jobs (job_id,row_nr,seq,co_number,pal_number,pal_id,bk_pal_number,collo_barcode,exp_day_dock,roa_classification, recipient_name,recipient_street,recipient_house_nr,recipient_att,recipient_town,recipient_zip_code, recipient_country,sender_name,sender_street,sender_house_nr,sender_own,sender_zip_code,sender_country, items,status,created_at,imported_at,updated_at) VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10, $11,$12,$13,$14,$15,$16, $17,$18,$19,$20,$21,$22,$23, $24,'NEW',now(),now(),now()) 2025-11-15 17:51:59.325 CET [5716] LOG: checkpoint starting: time 2025-11-15 17:51:59.708 CET [5716] LOG: checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.324 s, sync=0.011 s, total=0.384 s; sync files=1, longest=0.011 s, average=0.011 s; distance=8 kB, estimate=406 kB; lsn=7/A93E9770, redo lsn=7/A93E9718 2025-11-15 17:52:22.260 CET [6752] ERROR: column "items" of relation "shipbk_print_jobs" does not exist at character 364 2025-11-15 17:52:22.260 CET [6752] STATEMENT: INSERT INTO sonex.shipbk_print_jobs (job_id,row_nr,seq,co_number,pal_number,pal_id,bk_pal_number,collo_barcode,exp_day_dock,roa_classification, recipient_name,recipient_street,recipient_house_nr,recipient_att,recipient_town,recipient_zip_code, recipient_country,sender_name,sender_street,sender_house_nr,sender_own,sender_zip_code,sender_country, items,status,created_at,imported_at,updated_at) VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10, $11,$12,$13,$14,$15,$16, $17,$18,$19,$20,$21,$22,$23, $24,'NEW',now(),now(),now()) 2025-11-15 17:52:52.282 CET [6752] ERROR: column "items" is of type jsonb but expression is of type text at character 523 2025-11-15 17:52:52.282 CET [6752] HINT: You will need to rewrite or cast the expression. 2025-11-15 17:52:52.282 CET [6752] STATEMENT: INSERT INTO sonex.shipbk_print_jobs (job_id,row_nr,seq,co_number,pal_number,pal_id,bk_pal_number,collo_barcode,exp_day_dock,roa_classification, recipient_name,recipient_street,recipient_house_nr,recipient_att,recipient_town,recipient_zip_code, recipient_country,sender_name,sender_street,sender_house_nr,sender_own,sender_zip_code,sender_country, items,status,created_at,imported_at,updated_at) VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10, $11,$12,$13,$14,$15,$16, $17,$18,$19,$20,$21,$22,$23, $24,'NEW',now(),now(),now()) 2025-11-15 17:53:07.674 CET [5156] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-15 17:53:22.233 CET [6752] ERROR: column "items" is of type jsonb but expression is of type text at character 523 2025-11-15 17:53:22.233 CET [6752] HINT: You will need to rewrite or cast the expression. 2025-11-15 17:53:22.233 CET [6752] STATEMENT: INSERT INTO sonex.shipbk_print_jobs (job_id,row_nr,seq,co_number,pal_number,pal_id,bk_pal_number,collo_barcode,exp_day_dock,roa_classification, recipient_name,recipient_street,recipient_house_nr,recipient_att,recipient_town,recipient_zip_code, recipient_country,sender_name,sender_street,sender_house_nr,sender_own,sender_zip_code,sender_country, items,status,created_at,imported_at,updated_at) VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10, $11,$12,$13,$14,$15,$16, $17,$18,$19,$20,$21,$22,$23, $24,'NEW',now(),now(),now()) 2025-11-15 17:53:39.298 CET [6752] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-15 17:56:59.697 CET [5716] LOG: checkpoint starting: time 2025-11-15 17:57:00.998 CET [5716] LOG: checkpoint complete: wrote 12 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.196 s, sync=0.055 s, total=1.301 s; sync files=9, longest=0.011 s, average=0.007 s; distance=50 kB, estimate=370 kB; lsn=7/A93F6268, redo lsn=7/A93F6210 2025-11-15 18:17:14.587 CET [4980] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-15 18:17:59.923 CET [584] ERROR: column "status" does not exist at character 538 2025-11-15 18:17:59.923 CET [584] DETAIL: There is a column named "status" in table "shipbk_print_jobs", but it cannot be referenced from this part of the query. 2025-11-15 18:17:59.923 CET [584] STATEMENT: INSERT INTO sonex.shipbk_print_jobs (job_id,row_nr,seq,co_number,pal_number,pal_id,bk_pal_number,collo_barcode,exp_day_dock,roa_classification, recipient_name,recipient_street,recipient_house_nr,recipient_att,recipient_town,recipient_zip_code, recipient_country,sender_name,sender_street,sender_house_nr,sender_own,sender_zip_code,sender_country, items,status, errors, created_at,imported_at,updated_at) VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10, $11,$12,$13,$14,$15,$16, $17,$18,$19,$20,$21,$22,$23, $24, @Status, @Errors, now(),now(),now()) 2025-11-15 18:18:29.426 CET [584] ERROR: column "status" does not exist at character 538 2025-11-15 18:18:29.426 CET [584] DETAIL: There is a column named "status" in table "shipbk_print_jobs", but it cannot be referenced from this part of the query. 2025-11-15 18:18:29.426 CET [584] STATEMENT: INSERT INTO sonex.shipbk_print_jobs (job_id,row_nr,seq,co_number,pal_number,pal_id,bk_pal_number,collo_barcode,exp_day_dock,roa_classification, recipient_name,recipient_street,recipient_house_nr,recipient_att,recipient_town,recipient_zip_code, recipient_country,sender_name,sender_street,sender_house_nr,sender_own,sender_zip_code,sender_country, items,status, errors, created_at,imported_at,updated_at) VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10, $11,$12,$13,$14,$15,$16, $17,$18,$19,$20,$21,$22,$23, $24, @Status, @Errors, now(),now(),now()) 2025-11-15 18:18:59.404 CET [584] ERROR: column "status" does not exist at character 538 2025-11-15 18:18:59.404 CET [584] DETAIL: There is a column named "status" in table "shipbk_print_jobs", but it cannot be referenced from this part of the query. 2025-11-15 18:18:59.404 CET [584] STATEMENT: INSERT INTO sonex.shipbk_print_jobs (job_id,row_nr,seq,co_number,pal_number,pal_id,bk_pal_number,collo_barcode,exp_day_dock,roa_classification, recipient_name,recipient_street,recipient_house_nr,recipient_att,recipient_town,recipient_zip_code, recipient_country,sender_name,sender_street,sender_house_nr,sender_own,sender_zip_code,sender_country, items,status, errors, created_at,imported_at,updated_at) VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10, $11,$12,$13,$14,$15,$16, $17,$18,$19,$20,$21,$22,$23, $24, @Status, @Errors, now(),now(),now()) 2025-11-15 18:19:29.367 CET [584] ERROR: column "status" does not exist at character 538 2025-11-15 18:19:29.367 CET [584] DETAIL: There is a column named "status" in table "shipbk_print_jobs", but it cannot be referenced from this part of the query. 2025-11-15 18:19:29.367 CET [584] STATEMENT: INSERT INTO sonex.shipbk_print_jobs (job_id,row_nr,seq,co_number,pal_number,pal_id,bk_pal_number,collo_barcode,exp_day_dock,roa_classification, recipient_name,recipient_street,recipient_house_nr,recipient_att,recipient_town,recipient_zip_code, recipient_country,sender_name,sender_street,sender_house_nr,sender_own,sender_zip_code,sender_country, items,status, errors, created_at,imported_at,updated_at) VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10, $11,$12,$13,$14,$15,$16, $17,$18,$19,$20,$21,$22,$23, $24, @Status, @Errors, now(),now(),now()) 2025-11-15 18:19:59.407 CET [584] ERROR: column "status" does not exist at character 538 2025-11-15 18:19:59.407 CET [584] DETAIL: There is a column named "status" in table "shipbk_print_jobs", but it cannot be referenced from this part of the query. 2025-11-15 18:19:59.407 CET [584] STATEMENT: INSERT INTO sonex.shipbk_print_jobs (job_id,row_nr,seq,co_number,pal_number,pal_id,bk_pal_number,collo_barcode,exp_day_dock,roa_classification, recipient_name,recipient_street,recipient_house_nr,recipient_att,recipient_town,recipient_zip_code, recipient_country,sender_name,sender_street,sender_house_nr,sender_own,sender_zip_code,sender_country, items,status, errors, created_at,imported_at,updated_at) VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10, $11,$12,$13,$14,$15,$16, $17,$18,$19,$20,$21,$22,$23, $24, @Status, @Errors, now(),now(),now()) 2025-11-15 18:20:29.940 CET [5432] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-15 18:20:29.940 CET [5432] 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-15 18:22:00.029 CET [5716] LOG: checkpoint starting: time 2025-11-15 18:22:00.310 CET [5716] LOG: checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.219 s, sync=0.019 s, total=0.282 s; sync files=3, longest=0.009 s, average=0.007 s; distance=9 kB, estimate=334 kB; lsn=7/A93F8750, redo lsn=7/A93F86F8 2025-11-15 18:27:00.323 CET [5716] LOG: checkpoint starting: time 2025-11-15 18:27:00.720 CET [5716] LOG: checkpoint complete: wrote 4 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.324 s, sync=0.024 s, total=0.398 s; sync files=4, longest=0.009 s, average=0.006 s; distance=30 kB, estimate=304 kB; lsn=7/A94002E8, redo lsn=7/A9400290 2025-11-15 18:56:12.048 CET [3956] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-15 18:56:12.048 CET [3956] 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-15 18:56:39.744 CET [6720] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-15 18:56:39.744 CET [6720] 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-15 18:57:00.743 CET [5716] LOG: checkpoint starting: time 2025-11-15 18:57:00.918 CET [5716] LOG: checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.101 s, sync=0.021 s, total=0.176 s; sync files=2, longest=0.011 s, average=0.011 s; distance=9 kB, estimate=274 kB; lsn=7/A9402728, redo lsn=7/A94026D0 2025-11-15 18:58:30.571 CET [4372] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-15 19:02:00.925 CET [5716] LOG: checkpoint starting: time 2025-11-15 19:02:02.901 CET [5716] LOG: checkpoint complete: wrote 18 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.856 s, sync=0.072 s, total=1.976 s; sync files=10, longest=0.013 s, average=0.008 s; distance=94 kB, estimate=256 kB; lsn=7/A9419F70, redo lsn=7/A9419F18 2025-11-15 20:22:56.005 CET [5712] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-15 20:22:56.005 CET [5712] 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-15 20:22:56.014 CET [7136] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-15 20:22:56.014 CET [7136] 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-15 20:27:00.972 CET [5716] LOG: checkpoint starting: time 2025-11-15 20:27:01.818 CET [5716] LOG: checkpoint complete: wrote 8 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.749 s, sync=0.039 s, total=0.847 s; sync files=7, longest=0.009 s, average=0.006 s; distance=46 kB, estimate=235 kB; lsn=7/A9425998, redo lsn=7/A9425940 2025-11-15 20:27:18.632 CET [7136] ERROR: COALESCE could not convert type json to jsonb at character 709 2025-11-15 20:27:18.632 CET [7136] 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, p.a20 AS recipientname, p.a21 AS recipientstreet, p.a22 AS recipienthousenr, p.a26 AS recipientatt, p.a25 AS recipienttown, p.a24 AS recipientzipcode, p.a23 AS recipientcountry, 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(r.items, '[]'::json) || COALESCE(c.items, '[]'::json) AS items FROM wms.pqueuesqldata p LEFT JOIN LATERAL ( SELECT jsonb_agg(jsonb_build_object('art', x.artnr, 'qty', x.qy, 'width', x.width, 'height', x.height, 'length', x.length, 'volume', x.volume, 'gweight', x.gweight)) AS items FROM ( SELECT rl.artnr, sum(rl.qexpected) AS qy, max(ap.width) AS width, max(ap.height) AS height, max(ap.length) AS length, max(ap.volume) AS volume, max(ap.gweight) AS gweight FROM wms.retourline rl LEFT JOIN wms.artpackgvw ap ON ap.artnr::text = rl.artnr::text AND ap.iunitqyf::text = 'SU'::text AND ap.quantity = 1 WHERE rl.referencenr::text = p.a39::text GROUP BY rl.artnr) x) r ON true LEFT JOIN LATERAL ( SELECT jsonb_agg(jsonb_build_object('art', x.artnr, 'qty', x.qy, 'width', x.width, 'height', x.height, 'length', x.length, 'volume', x.volume, 'gweight', x.gweight)) AS items FROM ( SELECT ct.artnr, sum(ct.quantity) AS qy, max(ap.width) AS width, max(ap.height) AS height, max(ap.length) AS length, max(ap.volume) AS volume, max(ap.gweight) AS gweight FROM wms.cont ct LEFT JOIN wms.artpackgvw ap ON ap.artnr::text = ct.artnr::text AND ap.iunitqyf::text = 'SU'::text AND ap.quantity = 1 WHERE ct.collobarcode::text = p.a39::text GROUP BY ct.artnr) x) c ON true WHERE p.a38::text = 'SHIPBK'::text AND p.jobid > (( SELECT COALESCE(max(shipbk_print_jobs.job_id), 0) AS "coalesce" FROM sonex.shipbk_print_jobs)); 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-15 20:28:13.384 CET [7136] ERROR: operator does not exist: json || json at character 721 2025-11-15 20:28:13.384 CET [7136] HINT: No operator matches the given name and argument types. You might need to add explicit type casts. 2025-11-15 20:28:13.384 CET [7136] 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, p.a20 AS recipientname, p.a21 AS recipientstreet, p.a22 AS recipienthousenr, p.a26 AS recipientatt, p.a25 AS recipienttown, p.a24 AS recipientzipcode, p.a23 AS recipientcountry, 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(r.items, '[]'::json) || COALESCE(c.items, '[]'::json) AS items FROM wms.pqueuesqldata p LEFT JOIN LATERAL ( SELECT json_agg(json_build_object('art', x.artnr, 'qty', x.qy, 'width', x.width, 'height', x.height, 'length', x.length, 'volume', x.volume, 'gweight', x.gweight)) AS items FROM ( SELECT rl.artnr, sum(rl.qexpected) AS qy, max(ap.width) AS width, max(ap.height) AS height, max(ap.length) AS length, max(ap.volume) AS volume, max(ap.gweight) AS gweight FROM wms.retourline rl LEFT JOIN wms.artpackgvw ap ON ap.artnr::text = rl.artnr::text AND ap.iunitqyf::text = 'SU'::text AND ap.quantity = 1 WHERE rl.referencenr::text = p.a39::text GROUP BY rl.artnr) x) r ON true LEFT JOIN LATERAL ( SELECT json_agg(json_build_object('art', x.artnr, 'qty', x.qy, 'width', x.width, 'height', x.height, 'length', x.length, 'volume', x.volume, 'gweight', x.gweight)) AS items FROM ( SELECT ct.artnr, sum(ct.quantity) AS qy, max(ap.width) AS width, max(ap.height) AS height, max(ap.length) AS length, max(ap.volume) AS volume, max(ap.gweight) AS gweight FROM wms.cont ct LEFT JOIN wms.artpackgvw ap ON ap.artnr::text = ct.artnr::text AND ap.iunitqyf::text = 'SU'::text AND ap.quantity = 1 WHERE ct.collobarcode::text = p.a39::text GROUP BY ct.artnr) x) c ON true WHERE p.a38::text = 'SHIPBK'::text AND p.jobid > (( SELECT COALESCE(max(shipbk_print_jobs.job_id), 0) AS "coalesce" FROM sonex.shipbk_print_jobs)); 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-15 20:29:12.531 CET [7136] ERROR: operator does not exist: json || json at character 790 2025-11-15 20:29:12.531 CET [7136] HINT: No operator matches the given name and argument types. You might need to add explicit type casts. 2025-11-15 20:29:12.531 CET [7136] 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, p.a20 AS recipientname, p.a21 AS recipientstreet, p.a22 AS recipienthousenr, p.a26 AS recipientatt, p.a25 AS recipienttown, p.a24 AS recipientzipcode, p.a23 AS recipientcountry, 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(r.items, '[]'::json) || COALESCE(c.items, '[]'::json))::json AS items FROM wms.pqueuesqldata p LEFT JOIN LATERAL ( SELECT json_agg(json_build_object( 'art', x.artnr, 'qty', x.qy, 'width', x.width, 'height', x.height, 'length', x.length, 'volume', x.volume, 'gweight', x.gweight )) AS items FROM ( SELECT rl.artnr, sum(rl.qexpected) AS qy, max(ap.width) AS width, max(ap.height) AS height, max(ap.length) AS length, max(ap.volume) AS volume, max(ap.gweight) AS gweight FROM wms.retourline rl LEFT JOIN wms.artpackgvw ap ON ap.artnr::text = rl.artnr::text AND ap.iunitqyf::text = 'SU' AND ap.quantity = 1 WHERE rl.referencenr::text = p.a39::text GROUP BY rl.artnr ) x ) r ON true LEFT JOIN LATERAL ( SELECT json_agg(json_build_object( 'art', x.artnr, 'qty', x.qy, 'width', x.width, 'height', x.height, 'length', x.length, 'volume', x.volume, 'gweight', x.gweight )) AS items FROM ( SELECT ct.artnr, sum(ct.quantity) AS qy, max(ap.width) AS width, max(ap.height) AS height, max(ap.length) AS length, max(ap.volume) AS volume, max(ap.gweight) AS gweight FROM wms.cont ct LEFT JOIN wms.artpackgvw ap ON ap.artnr::text = ct.artnr::text AND ap.iunitqyf::text = 'SU' AND ap.quantity = 1 WHERE ct.collobarcode::text = p.a39::text GROUP BY ct.artnr ) x ) c ON true WHERE p.a38::text = 'SHIPBK' AND p.jobid > ( SELECT COALESCE(MAX(shipbk_print_jobs.job_id), 0) FROM sonex.shipbk_print_jobs ); 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-15 20:32:00.806 CET [5716] LOG: checkpoint starting: time 2025-11-15 20:32:08.854 CET [5716] LOG: checkpoint complete: wrote 73 buffers (0.4%); 0 WAL file(s) added, 0 removed, 0 recycled; write=7.845 s, sync=0.152 s, total=8.048 s; sync files=28, longest=0.010 s, average=0.006 s; distance=479 kB, estimate=479 kB; lsn=7/A94A7808, redo lsn=7/A949D838 2025-11-15 20:35:16.921 CET [3416] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-15 20:35:16.922 CET [6132] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-15 20:35:16.923 CET [6196] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-15 20:35:16.924 CET [5492] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-15 20:35:16.926 CET [2948] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-15 20:35:16.930 CET [5720] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-15 20:35:16.932 CET [4348] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-15 20:35:16.933 CET [584] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-15 20:35:16.934 CET [5752] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-15 20:35:16.943 CET [4204] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-15 20:35:16.946 CET [5192] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-15 20:35:16.949 CET [3644] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-15 20:35:16.954 CET [7060] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-15 20:35:16.955 CET [6396] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-15 20:44:38.517 CET [6468] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-15 20:44:38.517 CET [6468] 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-15 20:44:45.464 CET [6512] WARNING: PID 3548 is not a PostgreSQL backend process 2025-11-15 20:44:45.817 CET [1884] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-15 20:44:45.817 CET [1884] 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-15 20:44:45.917 CET [6652] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-15 20:44:45.917 CET [6652] 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-15 20:44:51.488 CET [5552] WARNING: PID 5156 is not a PostgreSQL backend process 2025-11-15 20:45:02.852 CET [6776] WARNING: PID 1616 is not a PostgreSQL backend process 2025-11-15 20:45:15.281 CET [1976] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-15 20:45:15.281 CET [1976] 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-15 20:56:21.714 CET [6380] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-15 20:56:23.615 CET [3956] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-15 20:57:20.842 CET [6720] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-15 21:00:03.996 CET [5180] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-15 21:00:04.097 CET [4776] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-15 21:08:23.127 CET [2356] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-15 21:14:59.708 CET [4960] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-15 21:17:50.953 CET [6752] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-15 21:19:34.399 CET [6948] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-15 21:22:00.903 CET [5716] LOG: checkpoint starting: time 2025-11-15 21:22:02.658 CET [5716] LOG: checkpoint complete: wrote 16 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.653 s, sync=0.056 s, total=1.756 s; sync files=10, longest=0.012 s, average=0.006 s; distance=49 kB, estimate=436 kB; lsn=7/A94A9F38, redo lsn=7/A94A9EE0 2025-11-15 21:25:30.545 CET [1704] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-15 21:25:30.545 CET [3288] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-15 21:27:00.659 CET [5716] LOG: checkpoint starting: time 2025-11-15 21:27:02.830 CET [5716] LOG: checkpoint complete: wrote 20 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=2.069 s, sync=0.055 s, total=2.171 s; sync files=9, longest=0.010 s, average=0.007 s; distance=107 kB, estimate=403 kB; lsn=7/A94C4E88, redo lsn=7/A94C4E30 2025-11-15 21:37:00.831 CET [5716] LOG: checkpoint starting: time 2025-11-15 21:37:02.664 CET [5716] LOG: checkpoint complete: wrote 17 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.749 s, sync=0.039 s, total=1.834 s; sync files=6, longest=0.012 s, average=0.007 s; distance=62 kB, estimate=369 kB; lsn=7/A94D4A20, redo lsn=7/A94D49C8 2025-11-15 21:59:17.868 CET [3776] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-15 22:17:00.693 CET [5716] LOG: checkpoint starting: time 2025-11-15 22:17:01.540 CET [5716] LOG: checkpoint complete: wrote 8 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.763 s, sync=0.034 s, total=0.848 s; sync files=6, longest=0.007 s, average=0.006 s; distance=42 kB, estimate=337 kB; lsn=7/A94DF4E0, redo lsn=7/A94DF488 2025-11-15 22:23:05.598 CET [6960] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-15 22:23:05.598 CET [6960] 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-15 22:23:26.639 CET [5340] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-15 22:23:26.639 CET [5340] 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-15 22:27:00.549 CET [5716] LOG: checkpoint starting: time 2025-11-15 22:27:05.528 CET [5716] LOG: checkpoint complete: wrote 45 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=4.755 s, sync=0.179 s, total=4.980 s; sync files=33, longest=0.014 s, average=0.006 s; distance=256 kB, estimate=328 kB; lsn=7/A951F6A0, redo lsn=7/A951F610 2025-11-15 22:30:06.386 CET [2732] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-15 22:30:06.386 CET [2732] 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-15 22:37:00.535 CET [5716] LOG: checkpoint starting: time 2025-11-15 22:37:03.549 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.127 s, total=3.015 s; sync files=15, longest=0.017 s, average=0.009 s; distance=116 kB, estimate=307 kB; lsn=7/A953C678, redo lsn=7/A953C620 2025-11-15 22:42:00.545 CET [5716] LOG: checkpoint starting: time 2025-11-15 22:42:04.606 CET [5716] LOG: checkpoint complete: wrote 37 buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=3.942 s, sync=0.074 s, total=4.062 s; sync files=9, longest=0.019 s, average=0.009 s; distance=207 kB, estimate=297 kB; lsn=7/A95705D8, redo lsn=7/A9570548 2025-11-15 22:45:12.929 CET [6652] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-15 22:45:26.817 CET [1976] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-15 22:52:02.440 CET [5196] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-15 22:57:00.622 CET [5716] LOG: checkpoint starting: time 2025-11-15 22:57:01.446 CET [5716] LOG: checkpoint complete: wrote 8 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.759 s, sync=0.020 s, total=0.825 s; sync files=4, longest=0.008 s, average=0.005 s; distance=31 kB, estimate=271 kB; lsn=7/A9578440, redo lsn=7/A95783B0 2025-11-15 23:07:00.455 CET [5716] LOG: checkpoint starting: time 2025-11-15 23:07:03.603 CET [5716] LOG: checkpoint complete: wrote 29 buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=3.037 s, sync=0.066 s, total=3.149 s; sync files=10, longest=0.015 s, average=0.007 s; distance=130 kB, estimate=257 kB; lsn=7/A9598DC8, redo lsn=7/A9598D70 2025-11-15 23:11:25.521 CET [5416] ERROR: syntax error at or near "$27" at character 931 2025-11-15 23:11:25.521 CET [5416] STATEMENT: INSERT INTO sonex.shipbk_print_jobs (job_id,row_nr,seq,co_number,pal_number,pal_id,bk_pal_number,collo_barcode,exp_day_dock,roa_classification, recipient_name,recipient_street,recipient_house_nr,recipient_att,recipient_town,recipient_zip_code, recipient_country,sender_name,sender_street,sender_house_nr,sender_own,sender_zip_code,sender_country, items, status, errors, created_at,imported_at,updated_at, width, height, length, gweight, volume) VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10, $11,$12,$13,$14,$15,$16, $17,$18,$19,$20,$21,$22,$23, $24, $25, $26, now(),now(),now()),$27,$28,$29,$30,$31 2025-11-15 23:11:55.172 CET [5416] ERROR: syntax error at or near "$27" at character 931 2025-11-15 23:11:55.172 CET [5416] STATEMENT: INSERT INTO sonex.shipbk_print_jobs (job_id,row_nr,seq,co_number,pal_number,pal_id,bk_pal_number,collo_barcode,exp_day_dock,roa_classification, recipient_name,recipient_street,recipient_house_nr,recipient_att,recipient_town,recipient_zip_code, recipient_country,sender_name,sender_street,sender_house_nr,sender_own,sender_zip_code,sender_country, items, status, errors, created_at,imported_at,updated_at, width, height, length, gweight, volume) VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10, $11,$12,$13,$14,$15,$16, $17,$18,$19,$20,$21,$22,$23, $24, $25, $26, now(),now(),now()),$27,$28,$29,$30,$31 2025-11-15 23:12:00.615 CET [5716] LOG: checkpoint starting: time 2025-11-15 23:12:02.440 CET [5716] LOG: checkpoint complete: wrote 17 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.739 s, sync=0.034 s, total=1.826 s; sync files=5, longest=0.013 s, average=0.007 s; distance=46 kB, estimate=235 kB; lsn=7/A95A4880, redo lsn=7/A95A47F0 2025-11-15 23:12:25.177 CET [5416] ERROR: syntax error at or near "$27" at character 931 2025-11-15 23:12:25.177 CET [5416] STATEMENT: INSERT INTO sonex.shipbk_print_jobs (job_id,row_nr,seq,co_number,pal_number,pal_id,bk_pal_number,collo_barcode,exp_day_dock,roa_classification, recipient_name,recipient_street,recipient_house_nr,recipient_att,recipient_town,recipient_zip_code, recipient_country,sender_name,sender_street,sender_house_nr,sender_own,sender_zip_code,sender_country, items, status, errors, created_at,imported_at,updated_at, width, height, length, gweight, volume) VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10, $11,$12,$13,$14,$15,$16, $17,$18,$19,$20,$21,$22,$23, $24, $25, $26, now(),now(),now()),$27,$28,$29,$30,$31 2025-11-15 23:12:55.294 CET [5416] ERROR: syntax error at or near "$27" at character 931 2025-11-15 23:12:55.294 CET [5416] STATEMENT: INSERT INTO sonex.shipbk_print_jobs (job_id,row_nr,seq,co_number,pal_number,pal_id,bk_pal_number,collo_barcode,exp_day_dock,roa_classification, recipient_name,recipient_street,recipient_house_nr,recipient_att,recipient_town,recipient_zip_code, recipient_country,sender_name,sender_street,sender_house_nr,sender_own,sender_zip_code,sender_country, items, status, errors, created_at,imported_at,updated_at, width, height, length, gweight, volume) VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10, $11,$12,$13,$14,$15,$16, $17,$18,$19,$20,$21,$22,$23, $24, $25, $26, now(),now(),now()),$27,$28,$29,$30,$31 2025-11-15 23:13:25.185 CET [5416] ERROR: syntax error at or near "$27" at character 931 2025-11-15 23:13:25.185 CET [5416] STATEMENT: INSERT INTO sonex.shipbk_print_jobs (job_id,row_nr,seq,co_number,pal_number,pal_id,bk_pal_number,collo_barcode,exp_day_dock,roa_classification, recipient_name,recipient_street,recipient_house_nr,recipient_att,recipient_town,recipient_zip_code, recipient_country,sender_name,sender_street,sender_house_nr,sender_own,sender_zip_code,sender_country, items, status, errors, created_at,imported_at,updated_at, width, height, length, gweight, volume) VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10, $11,$12,$13,$14,$15,$16, $17,$18,$19,$20,$21,$22,$23, $24, $25, $26, now(),now(),now()),$27,$28,$29,$30,$31 2025-11-15 23:13:55.190 CET [5416] ERROR: syntax error at or near "$27" at character 931 2025-11-15 23:13:55.190 CET [5416] STATEMENT: INSERT INTO sonex.shipbk_print_jobs (job_id,row_nr,seq,co_number,pal_number,pal_id,bk_pal_number,collo_barcode,exp_day_dock,roa_classification, recipient_name,recipient_street,recipient_house_nr,recipient_att,recipient_town,recipient_zip_code, recipient_country,sender_name,sender_street,sender_house_nr,sender_own,sender_zip_code,sender_country, items, status, errors, created_at,imported_at,updated_at, width, height, length, gweight, volume) VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10, $11,$12,$13,$14,$15,$16, $17,$18,$19,$20,$21,$22,$23, $24, $25, $26, now(),now(),now()),$27,$28,$29,$30,$31 2025-11-15 23:14:25.220 CET [5416] ERROR: syntax error at or near "$27" at character 931 2025-11-15 23:14:25.220 CET [5416] STATEMENT: INSERT INTO sonex.shipbk_print_jobs (job_id,row_nr,seq,co_number,pal_number,pal_id,bk_pal_number,collo_barcode,exp_day_dock,roa_classification, recipient_name,recipient_street,recipient_house_nr,recipient_att,recipient_town,recipient_zip_code, recipient_country,sender_name,sender_street,sender_house_nr,sender_own,sender_zip_code,sender_country, items, status, errors, created_at,imported_at,updated_at, width, height, length, gweight, volume) VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10, $11,$12,$13,$14,$15,$16, $17,$18,$19,$20,$21,$22,$23, $24, $25, $26, now(),now(),now()),$27,$28,$29,$30,$31 2025-11-15 23:14:30.851 CET [5416] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-15 23:15:08.806 CET [6328] ERROR: column "gweight" of relation "shipbk_print_jobs" does not exist at character 589 2025-11-15 23:15:08.806 CET [6328] STATEMENT: INSERT INTO sonex.shipbk_print_jobs (job_id,row_nr,seq,co_number,pal_number,pal_id,bk_pal_number,collo_barcode,exp_day_dock,roa_classification, recipient_name,recipient_street,recipient_house_nr,recipient_att,recipient_town,recipient_zip_code, recipient_country,sender_name,sender_street,sender_house_nr,sender_own,sender_zip_code,sender_country, items, status, errors, created_at,imported_at,updated_at, width, height, length, gweight, volume) VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10, $11,$12,$13,$14,$15,$16, $17,$18,$19,$20,$21,$22,$23, $24, $25, $26, now(),now(),now(),$27,$28,$29,$30,$31) 2025-11-15 23:15:38.438 CET [6328] ERROR: column "gweight" of relation "shipbk_print_jobs" does not exist at character 589 2025-11-15 23:15:38.438 CET [6328] STATEMENT: INSERT INTO sonex.shipbk_print_jobs (job_id,row_nr,seq,co_number,pal_number,pal_id,bk_pal_number,collo_barcode,exp_day_dock,roa_classification, recipient_name,recipient_street,recipient_house_nr,recipient_att,recipient_town,recipient_zip_code, recipient_country,sender_name,sender_street,sender_house_nr,sender_own,sender_zip_code,sender_country, items, status, errors, created_at,imported_at,updated_at, width, height, length, gweight, volume) VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10, $11,$12,$13,$14,$15,$16, $17,$18,$19,$20,$21,$22,$23, $24, $25, $26, now(),now(),now(),$27,$28,$29,$30,$31) 2025-11-15 23:16:08.443 CET [6328] ERROR: column "gweight" of relation "shipbk_print_jobs" does not exist at character 589 2025-11-15 23:16:08.443 CET [6328] STATEMENT: INSERT INTO sonex.shipbk_print_jobs (job_id,row_nr,seq,co_number,pal_number,pal_id,bk_pal_number,collo_barcode,exp_day_dock,roa_classification, recipient_name,recipient_street,recipient_house_nr,recipient_att,recipient_town,recipient_zip_code, recipient_country,sender_name,sender_street,sender_house_nr,sender_own,sender_zip_code,sender_country, items, status, errors, created_at,imported_at,updated_at, width, height, length, gweight, volume) VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10, $11,$12,$13,$14,$15,$16, $17,$18,$19,$20,$21,$22,$23, $24, $25, $26, now(),now(),now(),$27,$28,$29,$30,$31) 2025-11-15 23:16:13.829 CET [6328] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-15 23:17:00.428 CET [5716] LOG: checkpoint starting: time 2025-11-15 23:17:01.054 CET [5716] LOG: checkpoint complete: wrote 6 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.549 s, sync=0.030 s, total=0.626 s; sync files=5, longest=0.007 s, average=0.006 s; distance=18 kB, estimate=214 kB; lsn=7/A95A9170, redo lsn=7/A95A9118 2025-11-15 23:22:00.055 CET [5716] LOG: checkpoint starting: time 2025-11-15 23:22:01.981 CET [5716] LOG: checkpoint complete: wrote 18 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.844 s, sync=0.038 s, total=1.926 s; sync files=6, longest=0.012 s, average=0.007 s; distance=95 kB, estimate=202 kB; lsn=7/A95C10C0, redo lsn=7/A95C1068