2026-01-28 06:31:23.343 CET [4568] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2026-01-28 06:31:23.343 CET [4568] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2026-01-28 06:31:23.725 CET [1928] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2026-01-28 06:31:23.725 CET [1928] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2026-01-28 06:53:13.215 CET [7128] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2026-01-28 06:53:13.215 CET [7128] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2026-01-28 06:56:59.409 CET [7120] LOG:  checkpoint starting: time
2026-01-28 06:57:05.407 CET [7120] LOG:  checkpoint complete: wrote 54 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=5.776 s, sync=0.170 s, total=5.999 s; sync files=27, longest=0.020 s, average=0.007 s; distance=290 kB, estimate=290 kB; lsn=7/AB90B548, redo lsn=7/AB90B4B8
2026-01-28 07:06:03.984 CET [2944] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2026-01-28 07:06:03.984 CET [2944] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2026-01-28 07:21:59.437 CET [7120] LOG:  checkpoint starting: time
2026-01-28 07:22:01.757 CET [7120] LOG:  checkpoint complete: wrote 21 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=2.178 s, sync=0.093 s, total=2.320 s; sync files=13, longest=0.012 s, average=0.008 s; distance=73 kB, estimate=268 kB; lsn=7/AB91DB70, redo lsn=7/AB91DB18
2026-01-28 07:36:06.078 CET [1972] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2026-01-28 07:36:06.078 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';
2026-01-28 07:36:33.495 CET [4880] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2026-01-28 07:36:33.495 CET [4880] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2026-01-28 07:36:54.028 CET [220] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2026-01-28 07:36:54.028 CET [220] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2026-01-28 07:36:59.782 CET [7120] LOG:  checkpoint starting: time
2026-01-28 07:37:00.054 CET [7120] LOG:  checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.215 s, sync=0.009 s, total=0.273 s; sync files=1, longest=0.009 s, average=0.009 s; distance=14 kB, estimate=243 kB; lsn=7/AB921468, redo lsn=7/AB921410
2026-01-28 07:37:27.233 CET [6700] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2026-01-28 07:37:27.233 CET [6700] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2026-01-28 07:41:59.049 CET [7120] LOG:  checkpoint starting: time
2026-01-28 07:41:59.429 CET [7120] LOG:  checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.327 s, sync=0.008 s, total=0.381 s; sync files=1, longest=0.008 s, average=0.008 s; distance=7 kB, estimate=219 kB; lsn=7/AB9232D8, redo lsn=7/AB923280
2026-01-28 07:46:59.428 CET [7120] LOG:  checkpoint starting: time
2026-01-28 07:46:59.822 CET [7120] LOG:  checkpoint complete: wrote 4 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.323 s, sync=0.024 s, total=0.395 s; sync files=4, longest=0.012 s, average=0.006 s; distance=20 kB, estimate=199 kB; lsn=7/AB9286A0, redo lsn=7/AB928648
2026-01-28 07:51:59.827 CET [7120] LOG:  checkpoint starting: time
2026-01-28 07:52:00.233 CET [7120] LOG:  checkpoint complete: wrote 4 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.325 s, sync=0.031 s, total=0.406 s; sync files=4, longest=0.011 s, average=0.008 s; distance=18 kB, estimate=181 kB; lsn=7/AB92D068, redo lsn=7/AB92D010
2026-01-28 07:56:59.231 CET [7120] LOG:  checkpoint starting: time
2026-01-28 07:56:59.633 CET [7120] LOG:  checkpoint complete: wrote 4 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.326 s, sync=0.030 s, total=0.402 s; sync files=4, longest=0.012 s, average=0.008 s; distance=19 kB, estimate=165 kB; lsn=7/AB931D50, redo lsn=7/AB931CF8
2026-01-28 07:58:17.222 CET [4880] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2026-01-28 07:58:17.222 CET [4880] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2026-01-28 08:06:59.630 CET [7120] LOG:  checkpoint starting: time
2026-01-28 08:07:00.025 CET [7120] LOG:  checkpoint complete: wrote 4 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.322 s, sync=0.023 s, total=0.396 s; sync files=4, longest=0.007 s, average=0.006 s; distance=23 kB, estimate=151 kB; lsn=7/AB937CB8, redo lsn=7/AB937C60
2026-01-28 08:14:56.916 CET [4880] ERROR:  syntax error at or near "newclassification" at character 1
2026-01-28 08:14:56.916 CET [4880] STATEMENT:  newclassification
2026-01-28 08:37:52.183 CET [4880] ERROR:  canceling statement due to user request
2026-01-28 08:37:52.183 CET [4880] STATEMENT:  WITH coids AS (
	  SELECT coid
	  FROM ltt.cohist
	  WHERE dtcreate >= date '2026-01-27'
	    AND dtcreate <  date '2026-01-28'
	    AND ordertype = 'WEB'
	)
	SELECT c.*, l.*
	FROM coids x
	JOIN ltt.cohist     c ON c.coid = x.coid
	JOIN ltt.colinehist l ON l.coid = x.coid;
2026-01-28 08:39:52.398 CET [4880] ERROR:  syntax error at or near "8" at character 1
2026-01-28 08:39:52.398 CET [4880] STATEMENT:  8
2026-01-28 08:44:26.360 CET [4880] ERROR:  syntax error at or near "JOIN" at character 195
2026-01-28 08:44:26.360 CET [4880] STATEMENT:  SELECT c.*, l.*
	FROM (
	  SELECT *
	  FROM ltt.cohist
	  WHERE dtcreate >= date '2026-01-26'
	    AND dtcreate <  date '2026-01-27'
	    AND ordertype = 'WEB'
	) c
	WHERE newclassification is not null
	JOIN ltt.colinehist l ON l.coid = c.coid;
2026-01-28 08:44:38.064 CET [4880] ERROR:  syntax error at or near "JOIN" at character 197
2026-01-28 08:44:38.064 CET [4880] STATEMENT:  SELECT c.*, l.*
	FROM (
	  SELECT *
	  FROM ltt.cohist
	  WHERE dtcreate >= date '2026-01-26'
	    AND dtcreate <  date '2026-01-27'
	    AND ordertype = 'WEB'
	) c
	WHERE l.newclassification is not null
	JOIN ltt.colinehist l ON l.coid = c.coid;
2026-01-28 08:45:51.581 CET [4880] ERROR:  syntax error at or near "AND" at character 1
2026-01-28 08:45:51.581 CET [4880] STATEMENT:  AND
2026-01-28 08:47:54.838 CET [4880] ERROR:  missing FROM-clause entry for table "l" at character 12
2026-01-28 08:47:54.838 CET [4880] STATEMENT:  SELECT
	    l.conumber,
	    l.coline,
	    COUNT(*) AS cnt
	FROM (
	    SELECT c.*, l.*
	    FROM ltt.cohist c
	    JOIN ltt.colinehist l
	      ON l.coid = c.coid
	     AND l.newclassification IS NOT NULL
	    WHERE c.dtcreate >= DATE '2026-01-26'
	      AND c.dtcreate <  DATE '2026-01-27'
	      AND c.ordertype = 'WEB'
	) q
	GROUP BY l.conumber, l.coline
	HAVING COUNT(*) > 1;
2026-01-28 08:47:57.406 CET [4880] ERROR:  missing FROM-clause entry for table "l" at character 12
2026-01-28 08:47:57.406 CET [4880] STATEMENT:  SELECT
	    l.conumber,
	    l.coline,
	    COUNT(*) AS cnt
	FROM (
	    SELECT c.*, l.*
	    FROM ltt.cohist c
	    JOIN ltt.colinehist l
	      ON l.coid = c.coid
	     AND l.newclassification IS NOT NULL
	    WHERE c.dtcreate >= DATE '2026-01-26'
	      AND c.dtcreate <  DATE '2026-01-27'
	      AND c.ordertype = 'WEB'
	) q
	GROUP BY l.conumber, l.coline
	HAVING COUNT(*) > 1;
2026-01-28 08:52:34.303 CET [4880] ERROR:  syntax error at or near "AND" at character 201
2026-01-28 08:52:34.303 CET [4880] STATEMENT:  SELECT c.*, l.*
	FROM (
	  SELECT *
	  FROM ltt.cohist
	  WHERE dtcreate >= date '2026-01-27'
	    AND dtcreate <  date '2026-01-28'
	    AND ordertype = 'WEB'
	) c
	JOIN ltt.colinehist l ON l.coid = c.coid;
	AND l.newclassification IS NOT NULL;
	
2026-01-28 08:53:25.320 CET [7128] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2026-01-28 09:31:59.104 CET [7120] LOG:  checkpoint starting: time
2026-01-28 09:31:59.399 CET [7120] LOG:  checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.215 s, sync=0.032 s, total=0.296 s; sync files=3, longest=0.016 s, average=0.011 s; distance=12 kB, estimate=137 kB; lsn=7/AB93AF20, redo lsn=7/AB93AEC8
2026-01-28 09:36:59.391 CET [7120] LOG:  checkpoint starting: time
2026-01-28 09:37:03.879 CET [7120] LOG:  checkpoint complete: wrote 41 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=4.364 s, sync=0.079 s, total=4.489 s; sync files=12, longest=0.015 s, average=0.007 s; distance=176 kB, estimate=176 kB; lsn=7/AB967170, redo lsn=7/AB9670E0
2026-01-28 09:37:04.393 CET [220] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2026-01-28 09:37:27.836 CET [4568] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2026-01-28 10:01:57.142 CET [4880] ERROR:  relation "rcp.rcpordgvw" does not exist at character 30
2026-01-28 10:01:57.142 CET [4880] STATEMENT:  SELECT
	    o.*,
	    a.*
	FROM rcp.rcpordgvw o
	JOIN rcp.rcpordartgvw a
	    ON a.conumber = o.conumber
	WHERE o.ordtype = 'WEB'
2026-01-28 10:12:23.138 CET [4880] ERROR:  column o.datecreatedt does not exist at character 148
2026-01-28 10:12:23.138 CET [4880] HINT:  Perhaps you meant to reference the column "o.datecreated".
2026-01-28 10:12:23.138 CET [4880] STATEMENT:  SELECT
	    o.conumber, o.recipient, o.recipname, o.descr, o.ordtype, o.despatchdate, o.packinglist, o.despatchlabel, o.subrcpnr, o.dspwaveid, 
	    o.datecreatedt, o.datemodified, o.deliverydate, a.coline, a.artnr, a.qordered, a.classification, a.state
	FROM wms.rcpordgvw o
	JOIN wms.rcpordartgvw a
	    ON a.conumber = o.conumber
	WHERE o.ordtype = 'WEB'
2026-01-28 10:23:53.783 CET [4880] ERROR:  relation "wms.rcpord_snapshot" does not exist
2026-01-28 10:23:53.783 CET [4880] STATEMENT:  -- numer zamówienia
	CREATE INDEX ix_rcpord_snapshot_conumber
	    ON wms.rcpord_snapshot (conumber);
	
	-- artykuł
	CREATE INDEX ix_rcpord_snapshot_artnr
	    ON wms.rcpord_snapshot (artnr);
	
	-- klasyfikacja
	CREATE INDEX ix_rcpord_snapshot_classification
	    ON wms.rcpord_snapshot (classification);
	
	-- daty (najczęstsze filtrowanie / zakresy)
	CREATE INDEX ix_rcpord_snapshot_datecreated
	    ON wms.rcpord_snapshot (datecreated);
	
	CREATE INDEX ix_rcpord_snapshot_despatchdate
	    ON wms.rcpord_snapshot (despatchdate);
	
	CREATE INDEX ix_rcpord_snapshot_deliverydate
	    ON wms.rcpord_snapshot (deliverydate);
	
2026-01-28 10:23:57.434 CET [4880] ERROR:  relation "wms.rcpord_snapshot" does not exist
2026-01-28 10:23:57.434 CET [4880] STATEMENT:  -- numer zamówienia
	CREATE INDEX ix_rcpord_snapshot_conumber
	    ON wms.rcpord_snapshot (conumber);
	
	-- artykuł
	CREATE INDEX ix_rcpord_snapshot_artnr
	    ON wms.rcpord_snapshot (artnr);
	
	-- klasyfikacja
	CREATE INDEX ix_rcpord_snapshot_classification
	    ON wms.rcpord_snapshot (classification);
	
	-- daty (najczęstsze filtrowanie / zakresy)
	CREATE INDEX ix_rcpord_snapshot_datecreated
	    ON wms.rcpord_snapshot (datecreated);
	
	CREATE INDEX ix_rcpord_snapshot_despatchdate
	    ON wms.rcpord_snapshot (despatchdate);
	
	CREATE INDEX ix_rcpord_snapshot_deliverydate
	    ON wms.rcpord_snapshot (deliverydate);
	
2026-01-28 10:25:22.477 CET [5784] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2026-01-28 10:25:22.477 CET [5784] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2026-01-28 10:25:28.758 CET [2372] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2026-01-28 10:25:28.758 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';
2026-01-28 10:25:28.801 CET [3712] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2026-01-28 10:25:28.801 CET [3712] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2026-01-28 10:25:31.986 CET [5480] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2026-01-28 10:26:59.922 CET [7120] LOG:  checkpoint starting: time
2026-01-28 10:27:04.340 CET [7120] LOG:  checkpoint complete: wrote 39 buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=4.157 s, sync=0.213 s, total=4.419 s; sync files=40, longest=0.018 s, average=0.006 s; distance=197 kB, estimate=197 kB; lsn=7/AB998788, redo lsn=7/AB9986F8
2026-01-28 10:29:02.969 CET [6700] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2026-01-28 10:38:02.230 CET [1928] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2026-01-28 10:55:01.266 CET [6280] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2026-01-28 10:55:01.266 CET [6280] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2026-01-28 10:55:01.594 CET [6520] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2026-01-28 10:55:01.594 CET [6520] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2026-01-28 10:55:01.657 CET [6520] ERROR:  relation "sonex.rcpord_snapshot_hist" does not exist
2026-01-28 10:55:01.657 CET [6520] STATEMENT:  CREATE INDEX IF NOT EXISTS ix_rcpord_snapshot_hist_key
	    ON sonex.rcpord_snapshot_hist (conumber, coline, archived_at DESC);
2026-01-28 10:58:45.628 CET [7112] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2026-01-28 10:58:45.628 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';
2026-01-28 11:02:12.180 CET [3660] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2026-01-28 11:02:12.180 CET [3660] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2026-01-28 11:06:59.375 CET [7120] LOG:  checkpoint starting: time
2026-01-28 11:08:58.782 CET [7120] LOG:  checkpoint complete: wrote 1093 buffers (6.7%); 0 WAL file(s) added, 2 removed, 0 recycled; write=119.190 s, sync=0.130 s, total=119.408 s; sync files=24, longest=0.022 s, average=0.006 s; distance=36731 kB, estimate=36731 kB; lsn=7/ADE84F28, redo lsn=7/ADD77408
2026-01-28 11:11:59.773 CET [7120] LOG:  checkpoint starting: time
2026-01-28 11:12:17.041 CET [7120] LOG:  checkpoint complete: wrote 158 buffers (1.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=17.132 s, sync=0.089 s, total=17.268 s; sync files=15, longest=0.016 s, average=0.006 s; distance=1093 kB, estimate=33167 kB; lsn=7/ADE88BB8, redo lsn=7/ADE88B28
2026-01-28 11:16:32.257 CET [6520] ERROR:  syntax error at or near "coline" at character 1
2026-01-28 11:16:32.257 CET [6520] STATEMENT:  coline
2026-01-28 11:16:59.038 CET [7120] LOG:  checkpoint starting: time
2026-01-28 11:17:10.971 CET [1128] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2026-01-28 11:17:10.971 CET [1128] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2026-01-28 11:17:38.266 CET [1128] ERROR:  column "ordertype" does not exist at character 36
2026-01-28 11:17:38.266 CET [1128] STATEMENT:  SELECT * FROM ltt.colinehist
	WHERE ordertype = 'WEB' 
	AND dtcreate >= date '2026-01-27'
	AND dtcreate <  date '2026-01-28'
	
2026-01-28 11:18:45.793 CET [7120] LOG:  checkpoint complete: wrote 978 buffers (6.0%); 0 WAL file(s) added, 2 removed, 0 recycled; write=106.585 s, sync=0.097 s, total=106.755 s; sync files=18, longest=0.011 s, average=0.006 s; distance=28454 kB, estimate=32696 kB; lsn=7/AFB92590, redo lsn=7/AFA525A0
2026-01-28 13:10:40.348 CET [3712] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2026-01-28 13:13:54.767 CET [3660] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2026-01-28 13:16:47.175 CET [6520] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2026-01-28 13:17:20.721 CET [6280] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2026-01-28 13:17:48.277 CET [1128] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.