2025-11-11 06:07:43.270 CET [6484] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 06:07:43.270 CET [6484] 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-11 06:07:43.631 CET [5784] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 06:07:43.631 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';
2025-11-11 06:07:43.692 CET [5784] ERROR:  syntax error at or near "FROM" at character 1
2025-11-11 06:07:43.692 CET [5784] STATEMENT:  FROM wms.StockRegularDVW  
	WHERE  pickzone = 'XWEBPICK'
	AND usage = 'PCK'
	AND blocked = 'N'
	AND blockedout = 'N'
	GROUP BY artnr;
2025-11-11 06:08:25.192 CET [5784] ERROR:  unterminated quoted identifier at or near """ at character 182
2025-11-11 06:08:25.192 CET [5784] STATEMENT:  SELECT artnr as ArticleId, SUM(quantity) as Quantity
	FROM wms.StockRegularDVW  
	WHERE  pickzone = 'XWEBPICK'
	AND usage = 'PCK'
	AND blocked = 'N'
	AND blockedout = 'N'
	GROUP BY artnr;"
2025-11-11 06:08:30.520 CET [5784] ERROR:  unterminated quoted identifier at or near """ at character 181
2025-11-11 06:08:30.520 CET [5784] STATEMENT:  SELECT artnr as ArticleId, SUM(quantity) as Quantity
	FROM wms.StockRegularDVW  
	WHERE  pickzone = 'XWEBPICK'
	AND usage = 'PCK'
	AND blocked = 'N'
	AND blockedout = 'N'
	GROUP BY artnr"
2025-11-11 06:09:16.856 CET [6468] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 06:09:16.856 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-11 06:09:17.007 CET [2680] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 06:09:17.007 CET [2680] 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-11 06:10:23.270 CET [5784] ERROR:  column "stockregulardvw.locname" must appear in the GROUP BY clause or be used in an aggregate function at character 8
2025-11-11 06:10:23.270 CET [5784] STATEMENT:  SELECT locname, artnr as ArticleId, SUM(quantity) as Quantity
	FROM wms.StockRegularDVW  
	WHERE  pickzone = 'XWEBPICK'
	AND usage = 'PCK'
	AND blocked = 'N'
	AND blockedout = 'N'
	GROUP BY artnr
2025-11-11 06:10:46.007 CET [5784] ERROR:  column "stockregulardvw.locname" must appear in the GROUP BY clause or be used in an aggregate function at character 8
2025-11-11 06:10:46.007 CET [5784] STATEMENT:  SELECT locname, artnr as ArticleId, SUM(quantity) as Quantity
	FROM wms.StockRegularDVW  
	WHERE  pickzone = 'XWEBPICK'
	AND usage = 'PCK'
	AND blocked = 'N'
	AND blockedout = 'N'
	ORDER BY locname
	--GROUP BY artnr
2025-11-11 06:11:07.426 CET [5784] ERROR:  syntax error at or near "GROUP" at character 193
2025-11-11 06:11:07.426 CET [5784] STATEMENT:  SELECT locname, artnr as ArticleId, SUM(quantity) as Quantity
	FROM wms.StockRegularDVW  
	WHERE  pickzone = 'XWEBPICK'
	AND usage = 'PCK'
	AND blocked = 'N'
	AND blockedout = 'N'
	ORDER BY locname
	GROUP BY artnr, locname
2025-11-11 06:14:28.154 CET [5784] ERROR:  syntax error at or near "AND" at character 183
2025-11-11 06:14:28.154 CET [5784] STATEMENT:  SELECT pickzone, usage, locname, artnr as ArticleId --, SUM(quantity) as Quantity
	FROM wms.StockRegularDVW  
	WHERE  pickzone = 'XWEBPICK'
	--AND usage = 'PCK'
	AND locname LIKE 'XW%';
	AND blocked = 'N'
	AND blockedout = 'N'
	ORDER BY locname
	--GROUP BY artnr, locname
2025-11-11 06:51:54.481 CET [5716] LOG:  checkpoint starting: time
2025-11-11 06:51:55.609 CET [5716] LOG:  checkpoint complete: wrote 10 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.973 s, sync=0.102 s, total=1.129 s; sync files=9, longest=0.015 s, average=0.012 s; distance=4 kB, estimate=49 kB; lsn=7/A42B7BF8, redo lsn=7/A42B4230
2025-11-11 07:41:31.549 CET [3392] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 07:41:31.551 CET [5696] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 07:41:31.552 CET [4740] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 07:41:31.554 CET [7052] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 07:41:31.565 CET [2836] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 07:41:31.571 CET [3224] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 07:41:31.572 CET [6224] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 07:41:31.573 CET [6652] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 07:41:31.574 CET [1140] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 07:41:31.577 CET [5336] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 07:41:31.578 CET [2792] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 07:41:31.580 CET [3128] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 07:41:31.586 CET [4864] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 07:41:31.591 CET [2320] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 07:41:31.592 CET [3288] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 07:41:31.592 CET [7088] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 07:41:31.599 CET [4520] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 07:41:31.604 CET [444] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 08:07:53.383 CET [6484] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 08:10:06.781 CET [2680] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 08:14:44.066 CET [5784] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 08:17:31.204 CET [1964] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 08:17:38.407 CET [2372] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 08:17:38.547 CET [1620] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 08:17:39.194 CET [4612] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 08:17:43.280 CET [7084] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 08:19:25.979 CET [6500] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 08:19:27.026 CET [2788] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 08:19:27.885 CET [5020] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 08:19:41.322 CET [4844] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 08:19:42.317 CET [424] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 08:19:42.879 CET [5368] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 08:19:50.494 CET [4228] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 08:19:51.494 CET [6252] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 08:19:52.040 CET [4200] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 08:22:57.697 CET [6856] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 08:22:57.697 CET [6856] 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-11 08:22:57.805 CET [1972] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 08:22:57.805 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-11 08:22:57.861 CET [2300] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 08:22:57.861 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-11 08:22:57.942 CET [3312] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 08:22:57.942 CET [3312] 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-11 08:22:57.969 CET [4236] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 08:22:57.969 CET [4236] 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-11 08:22:58.025 CET [2112] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 08:22:58.025 CET [2112] 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-11 08:22:58.068 CET [924] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 08:22:58.068 CET [924] 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-11 08:22:58.111 CET [5276] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 08:22:58.111 CET [5276] 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-11 08:22:58.150 CET [4916] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 08:22:58.150 CET [4916] 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-11 08:23:02.846 CET [5684] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 08:23:02.846 CET [5684] 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-11 08:23:03.445 CET [5832] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 08:23:03.445 CET [5832] 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-11 08:23:03.449 CET [5712] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 08:23:03.449 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-11 08:25:29.638 CET [3040] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 08:25:29.638 CET [3040] 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-11 08:26:35.762 CET [196] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 08:26:36.691 CET [4416] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 08:26:37.483 CET [5164] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 08:27:46.656 CET [5112] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 08:27:47.562 CET [6528] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 08:27:48.240 CET [4560] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 08:29:50.924 CET [5712] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 08:29:50.924 CET [3040] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 08:29:50.924 CET [5684] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 08:30:42.624 CET [1408] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 08:30:43.588 CET [6596] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 08:30:44.509 CET [3280] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 08:30:58.975 CET [4572] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 08:30:59.538 CET [2068] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 08:31:07.098 CET [3660] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 08:31:07.973 CET [6752] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 08:31:08.858 CET [4348] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 08:34:04.035 CET [1112] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 08:34:04.865 CET [2368] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 08:34:05.585 CET [5924] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 08:34:51.402 CET [3428] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 08:34:52.340 CET [1724] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 08:34:53.147 CET [6496] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 08:35:02.240 CET [6736] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 08:35:03.162 CET [1652] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 08:35:03.953 CET [3000] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 08:41:08.617 CET [5836] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 08:41:14.603 CET [2356] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 08:41:14.696 CET [2864] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 08:41:15.103 CET [2696] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 08:41:15.196 CET [5692] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 08:41:15.775 CET [4248] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 13:07:54.804 CET [5752] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 13:07:54.804 CET [5752] 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-11 13:07:55.172 CET [5992] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 13:07:55.172 CET [5992] 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-11 13:07:55.185 CET [3668] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 13:07:55.185 CET [3668] 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-11 13:07:55.457 CET [400] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 13:07:55.457 CET [400] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2025-11-11 13:07:55.609 CET [4348] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 13:07:55.609 CET [4348] 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-11 13:07:55.761 CET [6648] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 13:07:55.761 CET [6648] 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-11 13:07:56.006 CET [6904] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 13:07:56.006 CET [6904] 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-11 13:07:56.260 CET [6200] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 13:07:56.260 CET [6200] 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-11 13:09:16.433 CET [5752] ERROR:  column roa.art does not exist at character 252
2025-11-11 13:09:16.433 CET [5752] STATEMENT:  SELECT
	    ROA.conumber AS orders,
	    ROA.artnr,
	    MAX(ROA.packlistdescr) AS description,
	    MAX(ROA.classification) AS classification,
	    SUM(ROA.qordered) AS ordered
	FROM wms.RcpOrd RO
	JOIN wms.RcpOrdArt ROA ON RO.Conumber = ROA.Conumber
	WHERE ROA.art = '556191'
	GROUP BY ROA.artnr
	ORDER BY ROA.artnr DESC
2025-11-11 13:09:28.976 CET [5752] ERROR:  syntax error at or near "GROUP" at character 1
2025-11-11 13:09:28.976 CET [5752] STATEMENT:  GROUP BY ROA.artnr
	
2025-11-11 13:09:52.293 CET [5752] ERROR:  column roa.art does not exist at character 251
2025-11-11 13:09:52.293 CET [5752] STATEMENT:  SELECT
	    ROA.conumber AS order,
	    ROA.artnr,
	    MAX(ROA.packlistdescr) AS description,
	    MAX(ROA.classification) AS classification,
	    SUM(ROA.qordered) AS ordered
	FROM wms.RcpOrd RO
	JOIN wms.RcpOrdArt ROA ON RO.Conumber = ROA.Conumber
	WHERE ROA.art = "556191"
	GROUP BY ROA.artnr
	ORDER BY ROA.artnr DESC
2025-11-11 13:10:00.376 CET [5752] ERROR:  column roa.art does not exist at character 251
2025-11-11 13:10:00.376 CET [5752] STATEMENT:  SELECT
	    ROA.conumber AS order,
	    ROA.artnr,
	    MAX(ROA.packlistdescr) AS description,
	    MAX(ROA.classification) AS classification,
	    SUM(ROA.qordered) AS ordered
	FROM wms.RcpOrd RO
	JOIN wms.RcpOrdArt ROA ON RO.Conumber = ROA.Conumber
	WHERE ROA.art = 556191
	GROUP BY ROA.artnr
	ORDER BY ROA.artnr DESC
2025-11-11 13:10:12.042 CET [5752] ERROR:  syntax error at or near "556191" at character 1
2025-11-11 13:10:12.042 CET [5752] STATEMENT:  556191
2025-11-11 13:10:19.506 CET [5752] ERROR:  syntax error at or near "556191" at character 1
2025-11-11 13:10:19.506 CET [5752] STATEMENT:  556191
2025-11-11 13:10:30.654 CET [5752] ERROR:  operator does not exist: character varying = integer at character 261
2025-11-11 13:10:30.654 CET [5752] HINT:  No operator matches the given name and argument types. You might need to add explicit type casts.
2025-11-11 13:10:30.654 CET [5752] STATEMENT:  SELECT
	    ROA.conumber AS order,
	    ROA.artnr,
	    MAX(ROA.packlistdescr) AS description,
	    MAX(ROA.classification) AS classification,
	    SUM(ROA.qordered) AS ordered
	FROM wms.RcpOrd RO
	JOIN wms.RcpOrdArt ROA ON RO.Conumber = ROA.Conumber
	WHERE ROA.artnr = 556191
	GROUP BY ROA.artnr
	ORDER BY ROA.artnr DESC
2025-11-11 13:11:02.506 CET [5752] ERROR:  column "artnr" does not exist at character 32
2025-11-11 13:11:02.506 CET [5752] STATEMENT:  SELECT
	*
	FROM wms.RcpOrd
	WHERE artnr = 556191
	ORDER BY ROA.artnr DESC
2025-11-11 13:11:08.797 CET [5752] ERROR:  syntax error at or near "556191" at character 1
2025-11-11 13:11:08.797 CET [5752] STATEMENT:  556191
2025-11-11 13:11:18.204 CET [5752] ERROR:  column "artnr" does not exist at character 32
2025-11-11 13:11:18.204 CET [5752] STATEMENT:  SELECT
	*
	FROM wms.RcpOrd
	WHERE artnr = "556191"
	ORDER BY ROA.artnr DESC
2025-11-11 13:11:28.386 CET [4144] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 13:11:28.386 CET [4144] 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-11 13:11:29.219 CET [6748] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 13:11:29.219 CET [6748] 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-11 13:11:29.221 CET [4644] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 13:11:29.221 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-11 13:12:21.573 CET [4112] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 13:12:21.573 CET [4112] 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-11 13:13:30.168 CET [4112] ERROR:  syntax error at or near "LIMIT" at character 36
2025-11-11 13:13:30.168 CET [4112] STATEMENT:  SELECT * FROM wms.rcpordart
	WHERE 
	LIMIT 100
	
2025-11-11 13:13:49.980 CET [4112] ERROR:  syntax error at or near "LIMIT" at character 36
2025-11-11 13:13:49.980 CET [4112] STATEMENT:  SELECT * FROM wms.RcpOrdArt
	WHERE 
	LIMIT 100
	
2025-11-11 13:14:20.985 CET [4112] ERROR:  syntax error at or near "=" at character 36
2025-11-11 13:14:20.985 CET [4112] STATEMENT:  SELECT * FROM wms.RcpOrdArt
	 artnr = 556191
	LIMIT 100
	
2025-11-11 13:14:24.412 CET [4112] ERROR:  syntax error at or near "556191" at character 1
2025-11-11 13:14:24.412 CET [4112] STATEMENT:  556191
2025-11-11 13:14:32.603 CET [4112] ERROR:  syntax error at or near "556191" at character 1
2025-11-11 13:14:32.603 CET [4112] STATEMENT:  556191
2025-11-11 13:14:58.967 CET [4112] ERROR:  syntax error at or near "LIKE" at character 36
2025-11-11 13:14:58.967 CET [4112] STATEMENT:  SELECT * FROM wms.RcpOrdArt
	 artnr LIKE '556191'
	LIMIT 100
	
2025-11-11 13:16:54.932 CET [5716] LOG:  checkpoint starting: time
2025-11-11 13:17:06.945 CET [5716] LOG:  checkpoint complete: wrote 110 buffers (0.7%); 0 WAL file(s) added, 0 removed, 0 recycled; write=11.878 s, sync=0.085 s, total=12.013 s; sync files=12, longest=0.012 s, average=0.008 s; distance=367 kB, estimate=367 kB; lsn=7/A43101B0, redo lsn=7/A4310120
2025-11-11 14:44:45.808 CET [5316] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 14:44:45.808 CET [5316] 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-11 14:44:46.160 CET [3508] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 14:44:46.160 CET [3508] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2025-11-11 14:44:46.222 CET [3508] ERROR:  permission denied for foreign-data wrapper oracle_fdw
2025-11-11 14:44:46.222 CET [3508] STATEMENT:  -- =====================================================
	--  FDW CONFIGURATION – locuswmst (read-only access for user "sonex")
	-- =====================================================
	
	CREATE EXTENSION IF NOT EXISTS oracle_fdw;
	
	-- 1) Foreign server
	DROP SERVER IF EXISTS locuswmst CASCADE;
	
	CREATE SERVER locuswmst
	  FOREIGN DATA WRAPPER oracle_fdw
	  OPTIONS (
	    dbserver '(DESCRIPTION=
	                (ADDRESS_LIST=
	                  (ADDRESS=(PROTOCOL=TCP)(HOST=10.53.2.31)(PORT=1521))
	                )
	                (CONNECT_DATA=(SID=wmst))
	              )'
	  );
	
	-- 2) User mapping (sonex -> Oracle user sje/same10)
	CREATE USER MAPPING FOR sonex
	  SERVER locuswmst
	  OPTIONS (
	    user 'sje',
	    password 'SJE'
	  );
	
	-- 3) Uprawnienia do serwera
	GRANT USAGE ON FOREIGN SERVER locuswmst TO sonex;
	
	-- 4) Lokalne schema
	CREATE SCHEMA IF NOT EXISTS wmst;
	
	-- 5) Import tabel z Oracle schema LOCUS do schema wmst
	IMPORT FOREIGN SCHEMA "LOCUS"
	  FROM SERVER locuswmst
	  INTO wmst;
	
	-- 6) Tylko SELECT
	REVOKE ALL PRIVILEGES ON SCHEMA wmst FROM PUBLIC;
	REVOKE ALL PRIVILEGES ON ALL TABLES IN SCHEMA wmst FROM PUBLIC;
	REVOKE ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA wmst FROM PUBLIC;
	REVOKE ALL PRIVILEGES ON ALL FUNCTIONS IN SCHEMA wmst FROM PUBLIC;
	
	GRANT USAGE ON SCHEMA wmst TO sonex;
	GRANT SELECT ON ALL TABLES IN SCHEMA wmst TO sonex;
	
	-- 7) Domyślne przywileje (nowe tabele)
	ALTER DEFAULT PRIVILEGES FOR ROLE postgres IN SCHEMA wmst
	  GRANT SELECT ON TABLES TO sonex;
	
2025-11-11 14:45:28.180 CET [6820] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 14:45:28.180 CET [6820] 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-11 14:45:55.925 CET [6076] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 14:45:56.597 CET [3308] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 14:46:14.457 CET [3836] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 14:46:14.566 CET [5220] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 14:46:15.171 CET [4396] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 14:46:20.787 CET [1484] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 14:46:38.803 CET [1544] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 14:46:41.459 CET [2980] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 14:46:42.334 CET [5344] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 14:47:10.170 CET [1704] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 14:47:10.170 CET [1704] 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-11 14:47:10.634 CET [1996] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 14:47:10.634 CET [1996] 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-11 14:47:10.649 CET [5640] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 14:47:10.649 CET [5640] 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-11 14:47:23.949 CET [5040] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 14:47:23.949 CET [5040] 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-11 14:47:27.571 CET [5040] ERROR:  user mapping not found for user "postgres", server "locuswmst"
2025-11-11 14:47:27.571 CET [5040] STATEMENT:  -- =====================================================
	--  FDW CONFIGURATION – locuswmst (read-only access for user "sonex")
	-- =====================================================
	
	CREATE EXTENSION IF NOT EXISTS oracle_fdw;
	
	-- 1) Foreign server
	DROP SERVER IF EXISTS locuswmst CASCADE;
	
	CREATE SERVER locuswmst
	  FOREIGN DATA WRAPPER oracle_fdw
	  OPTIONS (
	    dbserver '(DESCRIPTION=
	                (ADDRESS_LIST=
	                  (ADDRESS=(PROTOCOL=TCP)(HOST=10.53.2.31)(PORT=1521))
	                )
	                (CONNECT_DATA=(SID=wmst))
	              )'
	  );
	
	-- 2) User mapping (sonex -> Oracle user sje/same10)
	CREATE USER MAPPING FOR sonex
	  SERVER locuswmst
	  OPTIONS (
	    user 'sje',
	    password 'SJE'
	  );
	
	-- 3) Uprawnienia do serwera
	GRANT USAGE ON FOREIGN SERVER locuswmst TO sonex;
	
	-- 4) Lokalne schema
	CREATE SCHEMA IF NOT EXISTS wmst;
	
	-- 5) Import tabel z Oracle schema LOCUS do schema wmst
	IMPORT FOREIGN SCHEMA "LOCUS"
	  FROM SERVER locuswmst
	  INTO wmst;
	
	-- 6) Tylko SELECT
	REVOKE ALL PRIVILEGES ON SCHEMA wmst FROM PUBLIC;
	REVOKE ALL PRIVILEGES ON ALL TABLES IN SCHEMA wmst FROM PUBLIC;
	REVOKE ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA wmst FROM PUBLIC;
	REVOKE ALL PRIVILEGES ON ALL FUNCTIONS IN SCHEMA wmst FROM PUBLIC;
	
	GRANT USAGE ON SCHEMA wmst TO sonex;
	GRANT SELECT ON ALL TABLES IN SCHEMA wmst TO sonex;
	
	-- 7) Domyślne przywileje (nowe tabele)
	ALTER DEFAULT PRIVILEGES FOR ROLE postgres IN SCHEMA wmst
	  GRANT SELECT ON TABLES TO sonex;
	
2025-11-11 14:49:36.514 CET [5040] ERROR:  user mapping not found for user "postgres", server "locuswmst"
2025-11-11 14:49:36.514 CET [5040] STATEMENT:  -- =====================================================
	--  FDW CONFIGURATION – locuswmst (read-only access for user "sonex")
	-- =====================================================
	
	CREATE EXTENSION IF NOT EXISTS oracle_fdw;
	
	-- 1) Foreign server
	DROP SERVER IF EXISTS locuswmst CASCADE;
	
	CREATE SERVER locuswmst
	  FOREIGN DATA WRAPPER oracle_fdw
	  OPTIONS (
	    dbserver '(DESCRIPTION=
	                (ADDRESS_LIST=
	                  (ADDRESS=(PROTOCOL=TCP)(HOST=10.53.2.31)(PORT=1521))
	                )
	                (CONNECT_DATA=(SID=wmst))
	              )'
	  );
	
	-- 2) User mapping (sonex -> Oracle user sje/same10)
	CREATE USER MAPPING FOR sonex
	  SERVER locuswmst
	  OPTIONS (
	    user 'SJE',
	    password 'SJE'
	  );
	
	-- 3) Uprawnienia do serwera
	GRANT USAGE ON FOREIGN SERVER locuswmst TO sonex;
	
	-- 4) Lokalne schema
	CREATE SCHEMA IF NOT EXISTS wmst;
	
	-- 5) Import tabel z Oracle schema LOCUS do schema wmst
	IMPORT FOREIGN SCHEMA "LOCUS"
	  FROM SERVER locuswmst
	  INTO wmst;
	
	-- 6) Tylko SELECT
	REVOKE ALL PRIVILEGES ON SCHEMA wmst FROM PUBLIC;
	REVOKE ALL PRIVILEGES ON ALL TABLES IN SCHEMA wmst FROM PUBLIC;
	REVOKE ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA wmst FROM PUBLIC;
	REVOKE ALL PRIVILEGES ON ALL FUNCTIONS IN SCHEMA wmst FROM PUBLIC;
	
	GRANT USAGE ON SCHEMA wmst TO sonex;
	GRANT SELECT ON ALL TABLES IN SCHEMA wmst TO sonex;
	
	-- 7) Domyślne przywileje (nowe tabele)
	ALTER DEFAULT PRIVILEGES FOR ROLE postgres IN SCHEMA wmst
	  GRANT SELECT ON TABLES TO sonex;
	
2025-11-11 14:51:06.577 CET [5040] ERROR:  cannot authenticate connection to foreign Oracle server
2025-11-11 14:51:06.577 CET [5040] DETAIL:  ORA-01017: invalid username/password; logon denied
	Help: https://docs.oracle.com/error-help/db/ora-01017/
2025-11-11 14:51:06.577 CET [5040] STATEMENT:  -- =====================================================
	--  FDW CONFIGURATION – locuswmst (read-only access for users "postgres" and "sonex")
	-- =====================================================
	
	CREATE EXTENSION IF NOT EXISTS oracle_fdw;
	
	-- 1) Foreign server
	DROP SERVER IF EXISTS locuswmst CASCADE;
	
	CREATE SERVER locuswmst
	  FOREIGN DATA WRAPPER oracle_fdw
	  OPTIONS (
	    dbserver '(DESCRIPTION=
	                (ADDRESS_LIST=
	                  (ADDRESS=(PROTOCOL=TCP)(HOST=10.53.2.31)(PORT=1521))
	                )
	                (CONNECT_DATA=(SID=wmst))
	              )'
	  );
	
	-- 2) User mappings (dla postgres i sonex)
	CREATE USER MAPPING IF NOT EXISTS FOR postgres
	  SERVER locuswmst
	  OPTIONS (user 'sje', password 'same10');
	
	CREATE USER MAPPING IF NOT EXISTS FOR sonex
	  SERVER locuswmst
	  OPTIONS (user 'sje', password 'same10');
	
	-- 3) Uprawnienia do serwera
	GRANT USAGE ON FOREIGN SERVER locuswmst TO postgres, sonex;
	
	-- 4) Lokalne schema
	CREATE SCHEMA IF NOT EXISTS wmst;
	
	-- 5) Import tabel z Oracle schema LOCUS do schema wmst
	IMPORT FOREIGN SCHEMA "LOCUS"
	  FROM SERVER locuswmst
	  INTO wmst;
	
	-- 6) Ograniczenie przywilejów – tylko SELECT
	REVOKE ALL PRIVILEGES ON SCHEMA wmst FROM PUBLIC;
	REVOKE ALL PRIVILEGES ON ALL TABLES IN SCHEMA wmst FROM PUBLIC;
	REVOKE ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA wmst FROM PUBLIC;
	REVOKE ALL PRIVILEGES ON ALL FUNCTIONS IN SCHEMA wmst FROM PUBLIC;
	
	GRANT USAGE ON SCHEMA wmst TO postgres, sonex;
	GRANT SELECT ON ALL TABLES IN SCHEMA wmst TO postgres, sonex;
	
	-- 7) Domyślne przywileje (dla nowych tabel)
	ALTER DEFAULT PRIVILEGES FOR ROLE postgres IN SCHEMA wmst
	  GRANT SELECT ON TABLES TO postgres, sonex;
	
2025-11-11 14:51:55.022 CET [5716] LOG:  checkpoint starting: time
2025-11-11 14:52:49.691 CET [3580] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 14:52:49.691 CET [3580] 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-11 14:52:50.143 CET [4372] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 14:52:50.143 CET [4372] 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-11 14:52:50.143 CET [3112] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 14:52:50.143 CET [3112] 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-11 14:53:10.758 CET [2684] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 14:53:10.758 CET [2684] 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-11 14:53:11.218 CET [6436] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 14:53:11.218 CET [6436] 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-11 14:53:11.218 CET [6676] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 14:53:11.218 CET [6676] 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-11 14:53:55.691 CET [4396] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 14:53:55.691 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-11 14:53:56.135 CET [5872] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 14:53:56.135 CET [5872] 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-11 14:53:56.208 CET [6208] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 14:53:56.208 CET [6208] 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-11 14:54:45.620 CET [2488] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 14:54:46.617 CET [3856] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 14:54:47.211 CET [5540] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 14:54:49.457 CET [6612] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 14:54:49.457 CET [6612] 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-11 14:55:14.879 CET [6612] ERROR:  syntax error at or near "\" at character 1
2025-11-11 14:55:14.879 CET [6612] STATEMENT:  \de+ locuswmst
	
2025-11-11 14:55:32.251 CET [6612] ERROR:  server "locuswmst" does not exist
2025-11-11 14:55:32.251 CET [6612] STATEMENT:  IMPORT FOREIGN SCHEMA "LOCUS" FROM SERVER locuswmst INTO wmst;
	
2025-11-11 14:56:25.431 CET [5716] LOG:  checkpoint complete: wrote 2542 buffers (15.5%); 0 WAL file(s) added, 2 removed, 0 recycled; write=270.015 s, sync=0.302 s, total=270.409 s; sync files=62, longest=0.011 s, average=0.005 s; distance=31542 kB, estimate=31542 kB; lsn=7/A6702B88, redo lsn=7/A61DDB50
2025-11-11 14:57:54.554 CET [6600] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 14:57:55.436 CET [4488] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 14:57:56.186 CET [4204] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 14:58:25.458 CET [4032] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 14:58:25.458 CET [4032] 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-11 14:58:25.880 CET [5888] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 14:58:25.880 CET [5888] 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-11 14:58:25.895 CET [7140] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 14:58:25.895 CET [7140] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2025-11-11 14:58:51.065 CET [6484] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 14:58:51.065 CET [6484] 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-11 14:58:54.246 CET [2244] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 14:58:54.246 CET [2244] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2025-11-11 14:58:54.262 CET [6904] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 14:58:54.262 CET [6904] 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-11 15:04:45.666 CET [5552] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 15:04:46.542 CET [6052] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 15:04:47.256 CET [6536] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 15:05:54.087 CET [1724] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 15:05:55.009 CET [3040] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 15:05:55.738 CET [6624] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 15:06:27.272 CET [3224] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 15:06:27.272 CET [3224] 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-11 15:06:27.363 CET [3224] ERROR:  user mapping not found for user "postgres", server "locuswmst"
2025-11-11 15:06:27.363 CET [3224] STATEMENT:  -- =====================================================
	--  LocusWMS
	-- =====================================================
	DROP SERVER IF EXISTS locuswmst CASCADE;
	CREATE SERVER locuswmst
	  FOREIGN DATA WRAPPER oracle_fdw
	  OPTIONS (
	    dbserver '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.53.2.31)(PORT=1521))(CONNECT_DATA=(SID=wmspt)))'
	  );
	
	-- 2) Create user mapping for sonex -> Oracle user (sje/same10)
	CREATE USER MAPPING FOR sonex
	  SERVER locuswmst
	  OPTIONS (user 'SJE', password 'SJE');
	
	-- 3) Allow user sonex to use this foreign server
	GRANT USAGE ON FOREIGN SERVER locuswmst TO sonex;
	
	-- 4) Local schema for Oracle tables
	CREATE SCHEMA IF NOT EXISTS wmst;
	
	-- 5) Import all tables from Oracle schema LOCUS into local schema wms
	IMPORT FOREIGN SCHEMA "LOCUS"
	  FROM SERVER locuswmst
	  INTO wmst;
	
	-- 6) Restrict all privileges and allow only SELECT for user sonex
	REVOKE ALL PRIVILEGES ON SCHEMA wmst FROM PUBLIC;
	REVOKE ALL PRIVILEGES ON ALL TABLES IN SCHEMA wmst FROM PUBLIC;
	REVOKE ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA wmst FROM PUBLIC;
	REVOKE ALL PRIVILEGES ON ALL FUNCTIONS IN SCHEMA wmst FROM PUBLIC;
	
	GRANT USAGE ON SCHEMA wmst TO sonex;
	GRANT SELECT ON ALL TABLES IN SCHEMA wmst TO sonex;
	
	-- 7) Default privileges: automatically grant SELECT on new tables to sonex
	ALTER DEFAULT PRIVILEGES FOR ROLE postgres IN SCHEMA wmst GRANT SELECT ON TABLES TO sonex;
	
	
2025-11-11 15:06:48.552 CET [3224] ERROR:  user mapping not found for user "postgres", server "locuswmst"
2025-11-11 15:06:48.552 CET [3224] STATEMENT:  -- =====================================================
	--  LocusWMS
	-- =====================================================
	DROP SERVER IF EXISTS locuswmst CASCADE;
	CREATE SERVER locuswmst
	  FOREIGN DATA WRAPPER oracle_fdw
	  OPTIONS (
	    dbserver '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.53.2.31)(PORT=1521))(CONNECT_DATA=(SID=wmspt)))'
	  );
	
	-- 2) Create user mapping for sonex -> Oracle user (sje/same10)
	CREATE USER MAPPING FOR sonex
	  SERVER locuswmst
	  OPTIONS (user 'SJE', password 'SJE');
	
	-- 3) Allow user sonex to use this foreign server
	GRANT USAGE ON FOREIGN SERVER locuswmst TO sonex;
	
	-- 4) Local schema for Oracle tables
	CREATE SCHEMA IF NOT EXISTS wmst;
	
	-- 5) Import all tables from Oracle schema LOCUS into local schema wms
	IMPORT FOREIGN SCHEMA "LOCUS"
	  FROM SERVER locuswmst
	  INTO wmst;
	
	-- 6) Restrict all privileges and allow only SELECT for user sonex
	REVOKE ALL PRIVILEGES ON SCHEMA wmst FROM PUBLIC;
	REVOKE ALL PRIVILEGES ON ALL TABLES IN SCHEMA wmst FROM PUBLIC;
	REVOKE ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA wmst FROM PUBLIC;
	REVOKE ALL PRIVILEGES ON ALL FUNCTIONS IN SCHEMA wmst FROM PUBLIC;
	
	GRANT USAGE ON SCHEMA wmst TO sonex;
	GRANT SELECT ON ALL TABLES IN SCHEMA wmst TO sonex;
	
	-- 7) Default privileges: automatically grant SELECT on new tables to sonex
	--ALTER DEFAULT PRIVILEGES FOR ROLE postgres IN SCHEMA wmst GRANT SELECT ON TABLES TO sonex;
	
	
2025-11-11 15:06:55.447 CET [5716] LOG:  checkpoint starting: time
2025-11-11 15:07:18.660 CET [1992] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 15:07:19.598 CET [5432] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 15:07:20.342 CET [6900] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 15:07:43.080 CET [5716] LOG:  checkpoint complete: wrote 435 buffers (2.7%); 0 WAL file(s) added, 0 removed, 0 recycled; write=47.380 s, sync=0.193 s, total=47.633 s; sync files=37, longest=0.012 s, average=0.006 s; distance=5309 kB, estimate=28919 kB; lsn=7/A67122C8, redo lsn=7/A670CF58
2025-11-11 15:08:32.022 CET [3224] ERROR:  user mapping not found for user "postgres", server "locuswmst"
2025-11-11 15:08:32.022 CET [3224] STATEMENT:  -- =====================================================
	--  LocusWMS
	-- =====================================================
	--DROP SERVER IF EXISTS locuswmst CASCADE;
	--CREATE SERVER locuswmst
	--  FOREIGN DATA WRAPPER oracle_fdw
	--  OPTIONS (
	--    dbserver '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.53.2.31)(PORT=1521))(CONNECT_DATA=(SID=wmspt)))'
	--  );
	
	-- 2) Create user mapping for sonex -> Oracle user (sje/same10)
	--CREATE USER MAPPING FOR sonex
	--  SERVER locuswmst
	--  OPTIONS (user 'SJE', password 'SJE');
	
	-- 3) Allow user sonex to use this foreign server
	--GRANT USAGE ON FOREIGN SERVER locuswmst TO sonex;
	
	-- 4) Local schema for Oracle tables
	--CREATE SCHEMA IF NOT EXISTS wmst;
	
	-- 5) Import all tables from Oracle schema LOCUS into local schema wms
	IMPORT FOREIGN SCHEMA "LOCUS"
	  FROM SERVER locuswmst
	  INTO wmst;
	
	-- 6) Restrict all privileges and allow only SELECT for user sonex
	--REVOKE ALL PRIVILEGES ON SCHEMA wmst FROM PUBLIC;
	--REVOKE ALL PRIVILEGES ON ALL TABLES IN SCHEMA wmst FROM PUBLIC;
	--REVOKE ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA wmst FROM PUBLIC;
	--REVOKE ALL PRIVILEGES ON ALL FUNCTIONS IN SCHEMA wmst FROM PUBLIC;
	
	--GRANT USAGE ON SCHEMA wmst TO sonex;
	--GRANT SELECT ON ALL TABLES IN SCHEMA wmst TO sonex;
	
	-- 7) Default privileges: automatically grant SELECT on new tables to sonex
	--ALTER DEFAULT PRIVILEGES FOR ROLE postgres IN SCHEMA wmst GRANT SELECT ON TABLES TO sonex;
	
	
2025-11-11 15:11:38.960 CET [4144] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 15:11:55.100 CET [5716] LOG:  checkpoint starting: time
2025-11-11 15:11:56.871 CET [5716] LOG:  checkpoint complete: wrote 16 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.633 s, sync=0.086 s, total=1.771 s; sync files=16, longest=0.010 s, average=0.006 s; distance=55 kB, estimate=26032 kB; lsn=7/A671AF98, redo lsn=7/A671AF40
2025-11-11 15:12:31.679 CET [4644] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 15:15:23.601 CET [4112] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 15:17:08.291 CET [6836] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 15:17:09.213 CET [4932] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 15:17:09.927 CET [2996] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 15:28:53.389 CET [3224] ERROR:  user mapping not found for user "postgres", server "locuswmst"
2025-11-11 15:28:53.389 CET [3224] STATEMENT:  -- =====================================================
	--  LocusWMS
	-- =====================================================
	--DROP SERVER IF EXISTS locuswmst CASCADE;
	--CREATE SERVER locuswmst
	--  FOREIGN DATA WRAPPER oracle_fdw
	--  OPTIONS (
	--    dbserver '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.53.2.31)(PORT=1521))(CONNECT_DATA=(SID=wmspt)))'
	--  );
	
	-- 2) Create user mapping for sonex -> Oracle user (sje/same10)
	--CREATE USER MAPPING FOR sonex
	--  SERVER locuswmst
	--  OPTIONS (user 'SJE', password 'SJE');
	
	-- 3) Allow user sonex to use this foreign server
	--GRANT USAGE ON FOREIGN SERVER locuswmst TO sonex;
	
	-- 4) Local schema for Oracle tables
	--CREATE SCHEMA IF NOT EXISTS wmst;
	
	-- 5) Import all tables from Oracle schema LOCUS into local schema wms
	IMPORT FOREIGN SCHEMA "LOCUS"
	  FROM SERVER locuswmst
	  INTO wmst;
	
	-- 6) Restrict all privileges and allow only SELECT for user sonex
	--REVOKE ALL PRIVILEGES ON SCHEMA wmst FROM PUBLIC;
	--REVOKE ALL PRIVILEGES ON ALL TABLES IN SCHEMA wmst FROM PUBLIC;
	--REVOKE ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA wmst FROM PUBLIC;
	--REVOKE ALL PRIVILEGES ON ALL FUNCTIONS IN SCHEMA wmst FROM PUBLIC;
	
	--GRANT USAGE ON SCHEMA wmst TO sonex;
	--GRANT SELECT ON ALL TABLES IN SCHEMA wmst TO sonex;
	
	-- 7) Default privileges: automatically grant SELECT on new tables to sonex
	--ALTER DEFAULT PRIVILEGES FOR ROLE postgres IN SCHEMA wmst GRANT SELECT ON TABLES TO sonex;
	
	
2025-11-11 15:30:37.613 CET [3224] ERROR:  cannot connect to foreign Oracle server
2025-11-11 15:30:37.613 CET [3224] DETAIL:  ORA-12505: Cannot connect to database. SID wmspt is not registered with the listener at host 10.53.2.31 port 1521. (CONNECTION_ID=2dRcHKFyRsa4TrmBisva/A==)
	Help: https://docs.oracle.com/error-help/db/ora-12505/
2025-11-11 15:30:37.613 CET [3224] STATEMENT:  -- =====================================================
	--  LocusWMS
	-- =====================================================
	--DROP SERVER IF EXISTS locuswmst CASCADE;
	--CREATE SERVER locuswmst
	--  FOREIGN DATA WRAPPER oracle_fdw
	--  OPTIONS (
	--    dbserver '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.53.2.31)(PORT=1521))(CONNECT_DATA=(SID=wmspt)))'
	--  );
	
	--2) Create user mapping for sonex -> Oracle user (sje/same10)
	--CREATE USER MAPPING FOR postgres
	--  SERVER locuswmst
	--  OPTIONS (user 'SJE', password 'SJE');
	
	-- 3) Allow user sonex to use this foreign server
	--GRANT USAGE ON FOREIGN SERVER locuswmst TO postgres;
	
	-- 4) Local schema for Oracle tables
	--CREATE SCHEMA IF NOT EXISTS wmst;
	
	-- 5) Import all tables from Oracle schema LOCUS into local schema wms
	IMPORT FOREIGN SCHEMA "LOCUS"
	  FROM SERVER locuswmst
	  INTO wmst;
	
	-- 6) Restrict all privileges and allow only SELECT for user sonex
	--REVOKE ALL PRIVILEGES ON SCHEMA wmst FROM PUBLIC;
	--REVOKE ALL PRIVILEGES ON ALL TABLES IN SCHEMA wmst FROM PUBLIC;
	--REVOKE ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA wmst FROM PUBLIC;
	--REVOKE ALL PRIVILEGES ON ALL FUNCTIONS IN SCHEMA wmst FROM PUBLIC;
	
	--GRANT USAGE ON SCHEMA wmst TO sonex;
	--GRANT SELECT ON ALL TABLES IN SCHEMA wmst TO sonex;
	
	-- 7) Default privileges: automatically grant SELECT on new tables to sonex
	--ALTER DEFAULT PRIVILEGES FOR ROLE postgres IN SCHEMA wmst GRANT SELECT ON TABLES TO sonex;
	
	
2025-11-11 15:31:55.886 CET [5716] LOG:  checkpoint starting: time
2025-11-11 15:31:56.739 CET [5716] LOG:  checkpoint complete: wrote 8 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.760 s, sync=0.044 s, total=0.854 s; sync files=8, longest=0.012 s, average=0.006 s; distance=28 kB, estimate=23432 kB; lsn=7/A6722060, redo lsn=7/A6721FF0
2025-11-11 15:33:43.527 CET [3224] ERROR:  server "locuswmst" already exists
2025-11-11 15:33:43.527 CET [3224] STATEMENT:  -- =====================================================
	--  LocusWMS
	-- =====================================================
	--DROP SERVER IF EXISTS locuswmst CASCADE;
	CREATE SERVER locuswmst
	  FOREIGN DATA WRAPPER oracle_fdw
	  OPTIONS (
	    dbserver '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.53.2.31)(PORT=1521))(CONNECT_DATA=(SID=wmst)))'
	  );
	
	--2) Create user mapping for sonex -> Oracle user (sje/same10)
	--CREATE USER MAPPING FOR postgres
	--  SERVER locuswmst
	--  OPTIONS (user 'SJE', password 'SJE');
	
	-- 3) Allow user sonex to use this foreign server
	--GRANT USAGE ON FOREIGN SERVER locuswmst TO postgres;
	
	-- 4) Local schema for Oracle tables
	--CREATE SCHEMA IF NOT EXISTS wmst;
	
	-- 5) Import all tables from Oracle schema LOCUS into local schema wms
	--IMPORT FOREIGN SCHEMA "LOCUS"
	--  FROM SERVER locuswmst
	--  INTO wmst;
	
	-- 6) Restrict all privileges and allow only SELECT for user sonex
	--REVOKE ALL PRIVILEGES ON SCHEMA wmst FROM PUBLIC;
	--REVOKE ALL PRIVILEGES ON ALL TABLES IN SCHEMA wmst FROM PUBLIC;
	--REVOKE ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA wmst FROM PUBLIC;
	--REVOKE ALL PRIVILEGES ON ALL FUNCTIONS IN SCHEMA wmst FROM PUBLIC;
	
	--GRANT USAGE ON SCHEMA wmst TO sonex;
	--GRANT SELECT ON ALL TABLES IN SCHEMA wmst TO sonex;
	
	-- 7) Default privileges: automatically grant SELECT on new tables to sonex
	--ALTER DEFAULT PRIVILEGES FOR ROLE postgres IN SCHEMA wmst GRANT SELECT ON TABLES TO sonex;
	
	
2025-11-11 15:36:20.622 CET [5580] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 15:36:20.622 CET [5580] 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-11 15:36:21.071 CET [6892] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 15:36:21.071 CET [6892] 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-11 15:36:21.087 CET [2836] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 15:36:21.087 CET [2836] 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-11 15:36:46.597 CET [4124] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 15:36:46.597 CET [4124] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2025-11-11 15:36:46.939 CET [5180] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 15:36:46.939 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-11 15:36:55.406 CET [5592] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 15:36:55.406 CET [5592] 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-11 15:36:55.420 CET [5140] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 15:36:55.420 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-11 15:36:55.731 CET [5716] LOG:  checkpoint starting: time
2025-11-11 15:41:25.367 CET [5716] LOG:  checkpoint complete: wrote 2969 buffers (18.1%); 0 WAL file(s) added, 2 removed, 0 recycled; write=269.239 s, sync=0.314 s, total=269.637 s; sync files=57, longest=0.018 s, average=0.006 s; distance=34303 kB, estimate=34303 kB; lsn=7/A88AB2A8, redo lsn=7/A88A1D88
2025-11-11 15:41:34.540 CET [6252] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 15:41:34.541 CET [4620] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 15:41:34.543 CET [696] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 15:41:34.544 CET [6432] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 15:41:34.546 CET [7076] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 15:41:34.547 CET [4932] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 15:41:34.549 CET [6512] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 15:43:16.690 CET [1992] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 15:43:16.690 CET [1992] 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-11 15:46:55.380 CET [5716] LOG:  checkpoint starting: time
2025-11-11 15:46:57.006 CET [5716] LOG:  checkpoint complete: wrote 15 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.518 s, sync=0.062 s, total=1.626 s; sync files=8, longest=0.014 s, average=0.008 s; distance=51 kB, estimate=30878 kB; lsn=7/A88AEBF0, redo lsn=7/A88AEB98
2025-11-11 15:50:25.232 CET [6100] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 15:50:25.232 CET [6948] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 15:50:25.233 CET [4256] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 15:50:25.235 CET [6088] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 15:50:25.241 CET [2612] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 15:50:25.245 CET [4884] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 15:50:25.253 CET [5984] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 15:51:55.004 CET [5716] LOG:  checkpoint starting: time
2025-11-11 15:51:55.744 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.038 s, total=0.741 s; sync files=4, longest=0.014 s, average=0.010 s; distance=34 kB, estimate=27793 kB; lsn=7/A88B7640, redo lsn=7/A88B75E8
2025-11-11 16:06:55.732 CET [5716] LOG:  checkpoint starting: time
2025-11-11 16:06:56.124 CET [5716] LOG:  checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.326 s, sync=0.013 s, total=0.392 s; sync files=2, longest=0.008 s, average=0.007 s; distance=7 kB, estimate=25015 kB; lsn=7/A88B9508, redo lsn=7/A88B94B0
2025-11-11 16:12:07.319 CET [1992] ERROR:  column "gtcode" does not exist at character 1281
2025-11-11 16:12:07.319 CET [1992] STATEMENT:  SELECT SUBSTR(A1,1,1) COLLOOUTPUT, SUBSTR(A2,1,9) COLLOID, N1 ROWNR, SUBSTR(A3,1,40) PAYMENTTERMREADABLECODE, SUBSTR(A4,1,60) STOCKOWNNAME, SUBSTR(A5,1,4000) STOCKOWNSTREET, SUBSTR(A6,1,4000) STOCKOWNHOUSENR, SUBSTR(A7,1,9) STOCKOWNCOUNTRY, SUBSTR(A8,1,60) STOCKOWNZIPCODE, SUBSTR(A9,1,60) STOCKOWNTOWN, SUBSTR(A10,1,10) STOCKOWNDPDDEPOT, SUBSTR(A11,1,60) RECIPNAME, SUBSTR(A12,1,4000) RECIPSTREET, SUBSTR(A13,1,4000) RECIPHOUSENR, SUBSTR(A14,1,9) RECIPCOUNTRY, SUBSTR(A15,1,60) RECIPZIPCODE, SUBSTR(A16,1,60) RECIPTOWN, SUBSTR(A17,1,60) RECIPATT, SUBSTR(A18,1,30) RECIPTELNR, SUBSTR(A19,1,100) RECIPEMAIL, SUBSTR(A20,1,60) INVOICENAME, SUBSTR(A21,1,4000) INVOICESTREET, SUBSTR(A22,1,4000) INVOICEHOUSENR, SUBSTR(A23,1,9) INVOICECOUNTRY, SUBSTR(A24,1,60) INVOICEZIPCODE, SUBSTR(A25,1,60) INVOICETOWN, SUBSTR(A26,1,60) INVOICEATT, SUBSTR(A27,1,18) CONUMBER, SUBSTR(A28,1,18) PALNUMBER, SUBSTR(A29,1,14) BKPALNUMBER, SUBSTR(A30,1,4000) EXPDAYDOCK, SUBSTR(A31,1,20) SHIPMENT, SUBSTR(A32,1,9) PALID, SUBSTR(A33,1,20) GTCODE, N2
	WEIGHT, SUBSTR(A34,1,40) ORDERDESCR, SUBSTR(A35,1,86) CONTENTDESCR, SUBSTR(A36,1,9) ROACLASSIFICATION, SUBSTR(A37,1,3) PRINTERTYPE, SUBSTR(A38,1,6) REPORTNAME, N3 SEQ, SUBSTR(A39,1,20) COLLOBARCODE, SUBSTR(A40,1,20) PAGEBREAK FROM wmst.PQueueSQLData WHERE GTCODE = 'BKNL' ORDER BY JobId, Line
2025-11-11 16:14:01.168 CET [1992] ERROR:  user mapping not found for user "sonex", server "locuswmst"
2025-11-11 16:14:01.168 CET [1992] STATEMENT:  SELECT SUBSTR(A1,1,1) COLLOOUTPUT, SUBSTR(A2,1,9) COLLOID, N1 ROWNR, SUBSTR(A3,1,40) PAYMENTTERMREADABLECODE, SUBSTR(A4,1,60) STOCKOWNNAME, SUBSTR(A5,1,4000) STOCKOWNSTREET, SUBSTR(A6,1,4000) STOCKOWNHOUSENR, SUBSTR(A7,1,9) STOCKOWNCOUNTRY, SUBSTR(A8,1,60) STOCKOWNZIPCODE, SUBSTR(A9,1,60) STOCKOWNTOWN, SUBSTR(A10,1,10) STOCKOWNDPDDEPOT, SUBSTR(A11,1,60) RECIPNAME, SUBSTR(A12,1,4000) RECIPSTREET, SUBSTR(A13,1,4000) RECIPHOUSENR, SUBSTR(A14,1,9) RECIPCOUNTRY, SUBSTR(A15,1,60) RECIPZIPCODE, SUBSTR(A16,1,60) RECIPTOWN, SUBSTR(A17,1,60) RECIPATT, SUBSTR(A18,1,30) RECIPTELNR, SUBSTR(A19,1,100) RECIPEMAIL, SUBSTR(A20,1,60) INVOICENAME, SUBSTR(A21,1,4000) INVOICESTREET, SUBSTR(A22,1,4000) INVOICEHOUSENR, SUBSTR(A23,1,9) INVOICECOUNTRY, SUBSTR(A24,1,60) INVOICEZIPCODE, SUBSTR(A25,1,60) INVOICETOWN, SUBSTR(A26,1,60) INVOICEATT, SUBSTR(A27,1,18) CONUMBER, SUBSTR(A28,1,18) PALNUMBER, SUBSTR(A29,1,14) BKPALNUMBER, SUBSTR(A30,1,4000) EXPDAYDOCK, SUBSTR(A31,1,20) SHIPMENT, SUBSTR(A32,1,9) PALID, SUBSTR(A33,1,20) GTCODE, N2
	WEIGHT, SUBSTR(A34,1,40) ORDERDESCR, SUBSTR(A35,1,86) CONTENTDESCR, SUBSTR(A36,1,9) ROACLASSIFICATION, SUBSTR(A37,1,3) PRINTERTYPE, SUBSTR(A38,1,6) REPORTNAME, N3 SEQ, SUBSTR(A39,1,20) COLLOBARCODE, SUBSTR(A40,1,20) PAGEBREAK FROM wmst.PQueueSQLData WHERE A33 = 'BKNL' ORDER BY JobId, Line
2025-11-11 16:14:52.279 CET [4436] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 16:14:52.279 CET [4436] 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-11 16:15:02.461 CET [4436] ERROR:  permission denied for foreign server locuswmst
2025-11-11 16:15:02.461 CET [4436] STATEMENT:  CREATE USER MAPPING IF NOT EXISTS FOR sonex
	  SERVER locuswmst
	  OPTIONS (user 'SJE', password 'SJE');
2025-11-11 16:15:15.444 CET [7148] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 16:15:15.444 CET [7148] 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-11 16:15:15.856 CET [6432] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 16:15:15.856 CET [6432] 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-11 16:15:15.857 CET [5588] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 16:15:15.857 CET [5588] 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-11 16:15:49.907 CET [3268] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 16:15:49.907 CET [3268] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2025-11-11 16:15:49.967 CET [3268] ERROR:  permission denied for foreign server locuswmst
2025-11-11 16:15:49.967 CET [3268] STATEMENT:  CREATE USER MAPPING IF NOT EXISTS FOR sonex
	  SERVER locuswmst
	  OPTIONS (user 'SJE', password 'SJE');
2025-11-11 16:16:13.209 CET [3268] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 16:16:13.209 CET [6432] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 16:16:13.209 CET [7148] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 17:05:01.557 CET [560] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 17:05:01.557 CET [560] 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-11 17:05:02.047 CET [4196] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 17:05:02.047 CET [4196] 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-11 17:07:57.270 CET [5500] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 17:07:57.270 CET [5500] 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-11 17:08:18.456 CET [5828] ERROR:  permission denied to cancel query
2025-11-11 17:08:18.456 CET [5828] DETAIL:  Only roles with the SUPERUSER attribute may cancel queries of roles with the SUPERUSER attribute.
2025-11-11 17:08:18.456 CET [5828] STATEMENT:  SELECT pg_cancel_backend(5500);
2025-11-11 17:09:10.383 CET [2472] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 17:09:10.383 CET [2472] 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-11 17:09:11.004 CET [5824] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 17:09:11.004 CET [5824] 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-11 17:09:11.008 CET [6008] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 17:09:11.008 CET [6008] 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-11 17:09:33.470 CET [4604] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 17:09:33.470 CET [4604] 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-11 17:09:33.803 CET [4604] ERROR:  connection for foreign table "pqueuesqldata" cannot be authenticated
2025-11-11 17:09:33.803 CET [4604] DETAIL:  ORA-01017: invalid username/password; logon denied
	Help: https://docs.oracle.com/error-help/db/ora-01017/
2025-11-11 17:09:33.803 CET [4604] STATEMENT:  SELECT SUBSTR(A1,1,1) COLLOOUTPUT, SUBSTR(A2,1,9) COLLOID, N1 ROWNR, SUBSTR(A3,1,40) PAYMENTTERMREADABLECODE, SUBSTR(A4,1,60) STOCKOWNNAME, SUBSTR(A5,1,4000) STOCKOWNSTREET, SUBSTR(A6,1,4000) STOCKOWNHOUSENR, SUBSTR(A7,1,9) STOCKOWNCOUNTRY, SUBSTR(A8,1,60) STOCKOWNZIPCODE, SUBSTR(A9,1,60) STOCKOWNTOWN, SUBSTR(A10,1,10) STOCKOWNDPDDEPOT, SUBSTR(A11,1,60) RECIPNAME, SUBSTR(A12,1,4000) RECIPSTREET, SUBSTR(A13,1,4000) RECIPHOUSENR, SUBSTR(A14,1,9) RECIPCOUNTRY, SUBSTR(A15,1,60) RECIPZIPCODE, SUBSTR(A16,1,60) RECIPTOWN, SUBSTR(A17,1,60) RECIPATT, SUBSTR(A18,1,30) RECIPTELNR, SUBSTR(A19,1,100) RECIPEMAIL, SUBSTR(A20,1,60) INVOICENAME, SUBSTR(A21,1,4000) INVOICESTREET, SUBSTR(A22,1,4000) INVOICEHOUSENR, SUBSTR(A23,1,9) INVOICECOUNTRY, SUBSTR(A24,1,60) INVOICEZIPCODE, SUBSTR(A25,1,60) INVOICETOWN, SUBSTR(A26,1,60) INVOICEATT, SUBSTR(A27,1,18) CONUMBER, SUBSTR(A28,1,18) PALNUMBER, SUBSTR(A29,1,14) BKPALNUMBER, SUBSTR(A30,1,4000) EXPDAYDOCK, SUBSTR(A31,1,20) SHIPMENT, SUBSTR(A32,1,9) PALID, SUBSTR(A33,1,20) GTCODE, N2
	WEIGHT, SUBSTR(A34,1,40) ORDERDESCR, SUBSTR(A35,1,86) CONTENTDESCR, SUBSTR(A36,1,9) ROACLASSIFICATION, SUBSTR(A37,1,3) PRINTERTYPE, SUBSTR(A38,1,6) REPORTNAME, N3 SEQ, SUBSTR(A39,1,20) COLLOBARCODE, SUBSTR(A40,1,20) PAGEBREAK FROM wmst.PQueueSQLData WHERE A33 = 'BKNL' ORDER BY JobId, Line
2025-11-11 17:11:04.782 CET [7084] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 17:11:04.782 CET [7084] 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-11 17:11:55.187 CET [5716] LOG:  checkpoint starting: time
2025-11-11 17:11:56.623 CET [5716] LOG:  checkpoint complete: wrote 13 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.304 s, sync=0.080 s, total=1.437 s; sync files=13, longest=0.015 s, average=0.007 s; distance=40 kB, estimate=22517 kB; lsn=7/A88C3538, redo lsn=7/A88C34E0
2025-11-11 17:13:13.085 CET [6776] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 17:13:13.085 CET [6776] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2025-11-11 17:16:55.618 CET [5716] LOG:  checkpoint starting: time
2025-11-11 17:16:55.909 CET [5716] LOG:  checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.215 s, sync=0.024 s, total=0.292 s; sync files=3, longest=0.014 s, average=0.008 s; distance=3 kB, estimate=20266 kB; lsn=7/A88C4408, redo lsn=7/A88C43B0
2025-11-11 17:19:46.603 CET [6776] ERROR:  syntax error at or near "sonex" at character 1
2025-11-11 17:19:46.603 CET [6776] STATEMENT:  sonex
2025-11-11 17:21:55.902 CET [5716] LOG:  checkpoint starting: time
2025-11-11 17:21:56.525 CET [5716] LOG:  checkpoint complete: wrote 6 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.540 s, sync=0.031 s, total=0.624 s; sync files=6, longest=0.007 s, average=0.006 s; distance=2 kB, estimate=18239 kB; lsn=7/A88C4F48, redo lsn=7/A88C4EF0
2025-11-11 17:23:29.834 CET [3368] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 17:23:29.834 CET [3368] 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-11 17:26:23.651 CET [2360] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 17:26:23.651 CET [2360] 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-11 17:26:55.512 CET [5716] LOG:  checkpoint starting: time
2025-11-11 17:26:56.023 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.035 s, total=0.512 s; sync files=5, longest=0.011 s, average=0.007 s; distance=3 kB, estimate=16416 kB; lsn=7/A88C5BF0, redo lsn=7/A88C5B98
2025-11-11 17:36:45.537 CET [2932] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 17:36:45.537 CET [2932] 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-11 17:45:15.351 CET [2932] ERROR:  relation "pqueue" does not exist at character 15
2025-11-11 17:45:15.351 CET [2932] STATEMENT:  select * from PQueue
2025-11-11 18:45:56.135 CET [4604] ERROR:  syntax error at or near "FROM" at character 158
2025-11-11 18:45:56.135 CET [4604] STATEMENT:  SELECT jobid, line, n1,n2,n3,a1,a2,a3,a4,a5,a6,a7,a8,a9,a10,a11,a12,a13,a14,a15,a16,a20,a23,a24,a25,a26,a27,a28,a29,a30,a31,a32,a33,a34,a35,a36,a37,a38,a39 *FROM wmst.PQueueSQLData WHERE A33 = 'BKNL' ORDER BY a27, Line
2025-11-11 18:55:04.099 CET [6172] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 18:55:04.099 CET [6172] 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-11 18:55:23.740 CET [5388] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 18:55:23.740 CET [5388] 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-11 18:55:23.938 CET [1080] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 18:55:23.938 CET [1080] 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-11 19:26:33.735 CET [6008] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 19:26:44.851 CET [2472] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 19:41:39.213 CET [4604] ERROR:  syntax error at or near "FROM" at character 161
2025-11-11 19:41:39.213 CET [4604] STATEMENT:  SELECT jobid, line, n1,n2,n3,a1,a2,a3,a4,a5,a6,a7,a8,a9,a10,a11,a12,a13,a14,a15,a16,a20,a23,a24,a25,a26,a27,a28,a29,a30,a31,a32,a33,a34,a35,a36,a37,a38,a39,a4 *FROM wmst.PQueueSQLData WHERE A38 = 'SHIPBK' ORDER BY a27, Line
2025-11-11 19:42:41.444 CET [4604] ERROR:  syntax error at or near "FROM" at character 1270
2025-11-11 19:42:41.444 CET [4604] STATEMENT:  SELECT SUBSTR(A1,1,1) COLLOOUTPUT, SUBSTR(A2,1,9) COLLOID, N1 ROWNR, SUBSTR(A3,1,40) PAYMENTTERMREADABLECODE, SUBSTR(A4,1,60) STOCKOWNNAME, SUBSTR(A5,1,4000) STOCKOWNSTREET, SUBSTR(A6,1,4000) STOCKOWNHOUSENR, SUBSTR(A7,1,9) STOCKOWNCOUNTRY, SUBSTR(A8,1,60) STOCKOWNZIPCODE, SUBSTR(A9,1,60) STOCKOWNTOWN, SUBSTR(A10,1,10) STOCKOWNDPDDEPOT, SUBSTR(A11,1,60) RECIPNAME, SUBSTR(A12,1,4000) RECIPSTREET, SUBSTR(A13,1,4000) RECIPHOUSENR, SUBSTR(A14,1,9) RECIPCOUNTRY, SUBSTR(A15,1,60) RECIPZIPCODE, SUBSTR(A16,1,60) RECIPTOWN, SUBSTR(A17,1,60) RECIPATT, SUBSTR(A18,1,30) RECIPTELNR, SUBSTR(A19,1,100) RECIPEMAIL, SUBSTR(A20,1,60) INVOICENAME, SUBSTR(A21,1,4000) INVOICESTREET, SUBSTR(A22,1,4000) INVOICEHOUSENR, SUBSTR(A23,1,9) INVOICECOUNTRY, SUBSTR(A24,1,60) INVOICEZIPCODE, SUBSTR(A25,1,60) INVOICETOWN, SUBSTR(A26,1,60) INVOICEATT, SUBSTR(A27,1,18) CONUMBER, SUBSTR(A28,1,18) PALNUMBER, SUBSTR(A29,1,20) BKPALNUMBER, SUBSTR(A30,1,4000) EXPDAYDOCK, SUBSTR(A31,1,20) SHIPMENT, SUBSTR(A32,1,9) PALID, SUBSTR(A33,1,20) GTCODE, N2
	WEIGHT, SUBSTR(A34,1,40) ORDERDESCR, SUBSTR(A35,1,86) CONTENTDESCR, SUBSTR(A36,1,9) ROACLASSIFICATION, SUBSTR(A37,1,3) PRINTERTYPE, SUBSTR(A38,1,6) REPORTNAME, N3 SEQ, SUBSTR(A39,1,20) COLLOBARCODE, SUBSTR(A40,1,20) PAGEBREAK FROM PQueueSQLData FROM wmst.PQueueSQLData WHERE A38 = 'SHIPBK' ORDER BY a27, Line
2025-11-11 19:45:37.564 CET [2932] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 19:55:50.251 CET [6436] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 19:55:50.251 CET [6436] 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-11 19:56:09.307 CET [6244] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 19:56:09.307 CET [6244] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2025-11-11 19:56:18.848 CET [4536] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 19:56:18.848 CET [4536] 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-11 19:57:20.188 CET [6436] ERROR:  column "raportname" does not exist at character 33
2025-11-11 19:57:20.188 CET [6436] HINT:  Perhaps you meant to reference the column "pqueue.reportname".
2025-11-11 19:57:20.188 CET [6436] STATEMENT:  SELECT * FROM wmst.pqueue WHERE raportname = 'SHIPDPD'
	
2025-11-11 20:24:36.916 CET [5276] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 20:24:36.916 CET [5276] 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-11 20:24:37.057 CET [6544] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 20:24:37.057 CET [6544] 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-11 20:24:41.827 CET [4216] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 20:24:41.827 CET [4216] 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-11 20:25:57.038 CET [6436] ERROR:  syntax error at or near "AND" at character 31
2025-11-11 20:25:57.038 CET [6436] STATEMENT:  SELECT p.* FROM wmst.pqueue p AND wmst.pqueuesqldata d WHERE p.jobid = d.jobid AND reportname = 'SHIPBK'
	
2025-11-11 20:26:11.203 CET [6436] ERROR:  syntax error at or near "AND" at character 36
2025-11-11 20:26:11.203 CET [6436] STATEMENT:  SELECT p.*, d.* FROM wmst.pqueue p AND wmst.pqueuesqldata d WHERE p.jobid = d.jobid AND reportname = 'SHIPBK'
	
2025-11-11 20:29:56.830 CET [940] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 20:29:56.830 CET [940] 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-11 20:31:23.946 CET [400] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 20:31:23.946 CET [400] STATEMENT:  SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8';
2025-11-11 20:31:55.129 CET [5716] LOG:  checkpoint starting: time
2025-11-11 20:31:55.411 CET [5716] LOG:  checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.216 s, sync=0.016 s, total=0.282 s; sync files=2, longest=0.009 s, average=0.008 s; distance=8 kB, estimate=14775 kB; lsn=7/A88C7C40, redo lsn=7/A88C7BE8
2025-11-11 20:55:14.250 CET [6172] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 20:57:52.098 CET [5612] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 20:57:52.098 CET [5612] 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-11 21:46:22.483 CET [4604] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 21:56:31.701 CET [4536] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 22:24:47.186 CET [6544] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 22:25:05.176 CET [4216] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 22:26:28.855 CET [6436] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 22:31:34.577 CET [400] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 22:40:31.871 CET [2964] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 22:40:31.871 CET [2964] 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-11 22:40:51.502 CET [2976] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 22:40:51.502 CET [2976] 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-11 22:40:51.683 CET [2112] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 22:40:51.683 CET [2112] 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-11 22:41:29.730 CET [2964] ERROR:  syntax error at or near "number" at character 33
2025-11-11 22:41:29.730 CET [2964] STATEMENT:  SELECT * FROM wmst.pal
	WHERE pa;number = '0068076119'
	LIMIT 100
	
2025-11-11 22:45:05.428 CET [940] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 22:58:02.273 CET [1080] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 22:58:37.938 CET [5612] LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

	
2025-11-11 23:01:25.853 CET [6152] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 23:01:25.853 CET [6152] 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-11 23:01:48.081 CET [2992] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 23:01:48.081 CET [2992] 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-11 23:02:16.684 CET [5516] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 23:02:16.684 CET [5516] 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-11 23:03:34.523 CET [2092] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 23:03:34.523 CET [2092] 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-11 23:04:15.758 CET [5048] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 23:04:15.758 CET [5048] 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-11 23:05:14.289 CET [5492] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 23:05:14.289 CET [5492] 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-11 23:05:40.836 CET [6068] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 23:05:40.836 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-11 23:05:53.506 CET [4656] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 23:05:53.506 CET [4656] 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-11 23:06:14.593 CET [6168] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 23:06:14.593 CET [6168] 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-11 23:13:52.430 CET [4296] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 23:13:52.430 CET [4296] 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-11 23:13:52.440 CET [6504] LOG:  getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately.

	
2025-11-11 23:13:52.440 CET [6504] 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-11 23:15:54.707 CET [2488] WARNING:  PID 4216 is not a PostgreSQL backend process