2025-11-27 05:01:32.421 CET [2356] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-27 05:01:32.422 CET [7156] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-27 05:12:20.162 CET [7108] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-27 05:12:20.162 CET [7108] 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-27 05:12:20.379 CET [5800] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-27 05:12:20.379 CET [5800] 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-27 05:12:22.598 CET [6736] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-27 05:12:22.598 CET [6736] 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-27 05:12:39.879 CET [5632] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-27 05:12:39.879 CET [5632] 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-27 05:20:31.416 CET [7120] LOG: checkpoint starting: time 2025-11-27 05:20:31.816 CET [7120] LOG: checkpoint complete: wrote 4 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.322 s, sync=0.025 s, total=0.400 s; sync files=2, longest=0.014 s, average=0.013 s; distance=21 kB, estimate=147 kB; lsn=7/AA5AFEA0, redo lsn=7/AA5AFE48 2025-11-27 05:25:31.806 CET [7120] LOG: checkpoint starting: time 2025-11-27 05:25:32.662 CET [7120] LOG: checkpoint complete: wrote 8 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.774 s, sync=0.035 s, total=0.857 s; sync files=6, longest=0.010 s, average=0.006 s; distance=38 kB, estimate=136 kB; lsn=7/AA5B9828, redo lsn=7/AA5B97D0 2025-11-27 05:30:31.659 CET [7120] LOG: checkpoint starting: time 2025-11-27 05:30:32.293 CET [7120] LOG: checkpoint complete: wrote 6 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.543 s, sync=0.044 s, total=0.635 s; sync files=5, longest=0.014 s, average=0.009 s; distance=19 kB, estimate=124 kB; lsn=7/AA5BE480, redo lsn=7/AA5BE428 2025-11-27 05:35:31.288 CET [7120] LOG: checkpoint starting: time 2025-11-27 05:35:32.033 CET [7120] LOG: checkpoint complete: wrote 7 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.662 s, sync=0.036 s, total=0.746 s; sync files=4, longest=0.016 s, average=0.009 s; distance=25 kB, estimate=114 kB; lsn=7/AA5C4C00, redo lsn=7/AA5C4BA8 2025-11-27 07:08:32.576 CET [5116] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-27 07:08:32.576 CET [5116] 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-27 07:08:32.942 CET [4084] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-27 07:08:32.942 CET [4084] 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-27 07:10:31.142 CET [7120] LOG: checkpoint starting: time 2025-11-27 07:10:31.787 CET [7120] LOG: checkpoint complete: wrote 6 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.541 s, sync=0.056 s, total=0.645 s; sync files=6, longest=0.013 s, average=0.010 s; distance=17 kB, estimate=105 kB; lsn=7/AA5C9058, redo lsn=7/AA5C9000 2025-11-27 07:12:32.273 CET [5800] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-27 07:12:50.050 CET [6736] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-27 07:18:22.386 CET [5632] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-27 07:58:00.518 CET [5116] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-27 07:58:00.521 CET [4084] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-27 08:15:31.840 CET [7120] LOG: checkpoint starting: time 2025-11-27 08:15:32.129 CET [7120] LOG: checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.212 s, sync=0.027 s, total=0.290 s; sync files=3, longest=0.015 s, average=0.009 s; distance=14 kB, estimate=96 kB; lsn=7/AA5CCA20, redo lsn=7/AA5CC9C8 2025-11-27 08:25:31.126 CET [7120] LOG: checkpoint starting: time 2025-11-27 08:25:31.416 CET [7120] LOG: checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.215 s, sync=0.022 s, total=0.291 s; sync files=3, longest=0.011 s, average=0.008 s; distance=13 kB, estimate=87 kB; lsn=7/AA5CFE78, redo lsn=7/AA5CFE20 2025-11-27 08:30:31.408 CET [7120] LOG: checkpoint starting: time 2025-11-27 08:30:32.035 CET [7120] LOG: checkpoint complete: wrote 6 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.546 s, sync=0.037 s, total=0.628 s; sync files=4, longest=0.015 s, average=0.010 s; distance=21 kB, estimate=81 kB; lsn=7/AA5D5288, redo lsn=7/AA5D5230 2025-11-27 08:35:31.031 CET [7120] LOG: checkpoint starting: time 2025-11-27 08:35:34.869 CET [7120] LOG: checkpoint complete: wrote 35 buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=3.722 s, sync=0.071 s, total=3.839 s; sync files=10, longest=0.013 s, average=0.008 s; distance=195 kB, estimate=195 kB; lsn=7/AA606120, redo lsn=7/AA6060C8 2025-11-27 09:51:11.571 CET [5336] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-27 09:51:11.571 CET [5336] 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-27 09:51:11.938 CET [6184] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-27 09:51:11.938 CET [6184] 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-27 09:53:24.475 CET [6184] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-27 09:53:24.476 CET [5336] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-27 12:50:32.090 CET [7120] LOG: checkpoint starting: time 2025-11-27 12:50:32.385 CET [7120] LOG: checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.214 s, sync=0.031 s, total=0.296 s; sync files=3, longest=0.013 s, average=0.011 s; distance=16 kB, estimate=177 kB; lsn=7/AA60A190, redo lsn=7/AA60A138 2025-11-27 13:45:32.421 CET [7120] LOG: checkpoint starting: time 2025-11-27 13:45:33.379 CET [7120] LOG: checkpoint complete: wrote 9 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.873 s, sync=0.034 s, total=0.958 s; sync files=4, longest=0.012 s, average=0.009 s; distance=54 kB, estimate=165 kB; lsn=7/AA617BE8, redo lsn=7/AA617B90 2025-11-27 14:25:32.404 CET [7120] LOG: checkpoint starting: time 2025-11-27 14:25:32.912 CET [7120] LOG: checkpoint complete: wrote 5 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.431 s, sync=0.028 s, total=0.509 s; sync files=4, longest=0.008 s, average=0.007 s; distance=19 kB, estimate=150 kB; lsn=7/AA61C818, redo lsn=7/AA61C7C0 2025-11-27 14:30:32.912 CET [7120] LOG: checkpoint starting: time 2025-11-27 14:30:33.209 CET [7120] LOG: checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.228 s, sync=0.020 s, total=0.297 s; sync files=3, longest=0.013 s, average=0.007 s; distance=15 kB, estimate=137 kB; lsn=7/AA6204D8, redo lsn=7/AA620480 2025-11-27 14:55:32.236 CET [7120] LOG: checkpoint starting: time 2025-11-27 14:55:35.969 CET [7120] LOG: checkpoint complete: wrote 34 buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=3.607 s, sync=0.076 s, total=3.734 s; sync files=10, longest=0.016 s, average=0.008 s; distance=207 kB, estimate=207 kB; lsn=7/AA6544A0, redo lsn=7/AA654448 2025-11-27 17:06:30.212 CET [5268] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-27 17:06:30.212 CET [5268] 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-27 17:06:41.109 CET [5268] ERROR: relation "picklocdvw" does not exist at character 39 2025-11-27 17:06:41.109 CET [5268] STATEMENT: SELECT PL.*, NULL ConfigProblems FROM PickLocDVW PL WHERE PickLocState = A AND 1 = 1 ORDER BY ArtNr, LocName, PickId 2025-11-27 17:06:56.583 CET [5268] ERROR: column "a" does not exist at character 79 2025-11-27 17:06:56.583 CET [5268] STATEMENT: SELECT PL.*, NULL ConfigProblems FROM wms.PickLocDVW PL WHERE PickLocState = A AND 1 = 1 ORDER BY ArtNr, LocName, PickId 2025-11-27 17:19:18.223 CET [5268] ERROR: syntax error at or near "artnr" at character 98 2025-11-27 17:19:18.223 CET [5268] STATEMENT: SELECT LocName, artnr, quantity FROM wms.PickLocDVW WHERE PickLocState = 'A' AND zone ='XWEB' artnr = '547444' 2025-11-27 17:43:47.294 CET [5268] ERROR: syntax error at or near "STRING_AGG" at character 95 2025-11-27 17:43:47.294 CET [5268] STATEMENT: SELECT artnr, STRING_AGG(CASE WHEN zone <> 'XWEB' THEN LocName END, ', ') AS dc_loc STRING_AGG(CASE WHEN zone = 'XWEB' THEN LocName END, ', ') AS vir_loc FROM wms.PickLocDVW WHERE PickLocState = 'A' GROUP BY artnr; 2025-11-27 17:54:09.580 CET [4872] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-27 17:54:09.580 CET [704] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-27 17:54:09.581 CET [6944] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-27 17:54:09.582 CET [5160] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-27 17:55:33.070 CET [7120] LOG: checkpoint starting: time 2025-11-27 17:55:33.932 CET [7120] LOG: checkpoint complete: wrote 8 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.756 s, sync=0.051 s, total=0.863 s; sync files=5, longest=0.018 s, average=0.011 s; distance=40 kB, estimate=191 kB; lsn=7/AA65E508, redo lsn=7/AA65E4B0 2025-11-27 18:29:38.703 CET [2232] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-27 18:29:38.704 CET [4572] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-27 18:32:46.800 CET [5712] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-27 18:32:46.800 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-27 18:32:46.917 CET [2684] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-27 18:32:46.917 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-27 18:32:47.307 CET [2460] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-27 18:32:47.307 CET [2460] 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-27 18:35:33.961 CET [7120] LOG: checkpoint starting: time 2025-11-27 18:35:34.715 CET [7120] LOG: checkpoint complete: wrote 7 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.650 s, sync=0.035 s, total=0.755 s; sync files=4, longest=0.014 s, average=0.009 s; distance=40 kB, estimate=176 kB; lsn=7/AA668660, redo lsn=7/AA668608 2025-11-27 18:40:33.703 CET [7120] LOG: checkpoint starting: time 2025-11-27 18:40:34.154 CET [7120] LOG: checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.316 s, sync=0.007 s, total=0.451 s; sync files=1, longest=0.007 s, average=0.007 s; distance=15 kB, estimate=160 kB; lsn=7/AA66C498, redo lsn=7/AA66C440 2025-11-27 18:45:33.151 CET [7120] LOG: checkpoint starting: time 2025-11-27 18:45:33.331 CET [7120] LOG: checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.112 s, sync=0.014 s, total=0.180 s; sync files=2, longest=0.008 s, average=0.007 s; distance=6 kB, estimate=144 kB; lsn=7/AA66DE70, redo lsn=7/AA66DE18 2025-11-27 19:45:48.951 CET [5268] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-27 20:32:57.052 CET [2684] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-27 20:35:38.004 CET [2460] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-27 21:00:33.437 CET [7120] LOG: checkpoint starting: time 2025-11-27 21:00:34.072 CET [7120] LOG: checkpoint complete: wrote 6 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.545 s, sync=0.040 s, total=0.635 s; sync files=4, longest=0.012 s, average=0.010 s; distance=23 kB, estimate=132 kB; lsn=7/AA673D30, redo lsn=7/AA673CD8 2025-11-27 21:05:33.074 CET [7120] LOG: checkpoint starting: time 2025-11-27 21:05:33.465 CET [7120] LOG: checkpoint complete: wrote 4 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.326 s, sync=0.019 s, total=0.392 s; sync files=3, longest=0.008 s, average=0.007 s; distance=16 kB, estimate=120 kB; lsn=7/AA677F50, redo lsn=7/AA677EF8 2025-11-27 21:30:33.478 CET [7120] LOG: checkpoint starting: time 2025-11-27 21:30:33.992 CET [7120] LOG: checkpoint complete: wrote 5 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.433 s, sync=0.033 s, total=0.515 s; sync files=4, longest=0.010 s, average=0.009 s; distance=17 kB, estimate=110 kB; lsn=7/AA67C708, redo lsn=7/AA67C6B0 2025-11-27 21:35:33.981 CET [7120] LOG: checkpoint starting: time 2025-11-27 21:35:34.593 CET [7120] LOG: checkpoint complete: wrote 6 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.539 s, sync=0.018 s, total=0.612 s; sync files=4, longest=0.006 s, average=0.005 s; distance=20 kB, estimate=101 kB; lsn=7/AA6817C8, redo lsn=7/AA681770 2025-11-27 21:40:33.594 CET [7120] LOG: checkpoint starting: time 2025-11-27 21:40:39.250 CET [7120] LOG: checkpoint complete: wrote 52 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=5.567 s, sync=0.044 s, total=5.657 s; sync files=6, longest=0.015 s, average=0.008 s; distance=201 kB, estimate=201 kB; lsn=7/AA6B3F88, redo lsn=7/AA6B3F30 2025-11-27 21:45:33.246 CET [7120] LOG: checkpoint starting: time 2025-11-27 21:45:33.979 CET [7120] LOG: checkpoint complete: wrote 7 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.650 s, sync=0.029 s, total=0.734 s; sync files=5, longest=0.010 s, average=0.006 s; distance=26 kB, estimate=184 kB; lsn=7/AA6BA9D8, redo lsn=7/AA6BA980 2025-11-27 22:00:33.972 CET [7120] LOG: checkpoint starting: time 2025-11-27 22:00:38.890 CET [7120] LOG: checkpoint complete: wrote 45 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=4.801 s, sync=0.067 s, total=4.919 s; sync files=13, longest=0.009 s, average=0.006 s; distance=244 kB, estimate=244 kB; lsn=7/AA6F7C78, redo lsn=7/AA6F7C20 2025-11-27 22:05:33.884 CET [7120] LOG: checkpoint starting: time 2025-11-27 22:05:34.074 CET [7120] LOG: checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.112 s, sync=0.021 s, total=0.191 s; sync files=2, longest=0.012 s, average=0.011 s; distance=1 kB, estimate=220 kB; lsn=7/AA6F8280, redo lsn=7/AA6F8228 2025-11-27 23:20:33.099 CET [7120] LOG: checkpoint starting: time 2025-11-27 23:20:33.274 CET [7120] LOG: checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.106 s, sync=0.019 s, total=0.175 s; sync files=2, longest=0.011 s, average=0.010 s; distance=1 kB, estimate=198 kB; lsn=7/AA6F8A10, redo lsn=7/AA6F89B8 2025-11-27 23:25:33.263 CET [7120] LOG: checkpoint starting: time 2025-11-27 23:25:33.542 CET [7120] LOG: checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.211 s, sync=0.021 s, total=0.279 s; sync files=3, longest=0.008 s, average=0.007 s; distance=5 kB, estimate=179 kB; lsn=7/AA6F9E58, redo lsn=7/AA6F9E00