2025-12-15 07:01:02.037 CET [7120] LOG: checkpoint starting: time 2025-12-15 07:01:02.334 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.031 s, total=0.297 s; sync files=3, longest=0.014 s, average=0.011 s; distance=16 kB, estimate=220 kB; lsn=7/AAE036C0, redo lsn=7/AAE03668 2025-12-15 07:06:02.340 CET [7120] LOG: checkpoint starting: time 2025-12-15 07:06:02.848 CET [7120] LOG: checkpoint complete: wrote 5 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.432 s, sync=0.023 s, total=0.508 s; sync files=4, longest=0.008 s, average=0.006 s; distance=24 kB, estimate=200 kB; lsn=7/AAE09740, redo lsn=7/AAE096E8 2025-12-15 07:11:02.843 CET [7120] LOG: checkpoint starting: time 2025-12-15 07:11:03.126 CET [7120] LOG: checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.213 s, sync=0.018 s, total=0.283 s; sync files=3, longest=0.007 s, average=0.006 s; distance=14 kB, estimate=182 kB; lsn=7/AAE0D070, redo lsn=7/AAE0D018 2025-12-15 07:16:02.126 CET [7120] LOG: checkpoint starting: time 2025-12-15 07:16:02.409 CET [7120] LOG: checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.216 s, sync=0.019 s, total=0.284 s; sync files=3, longest=0.007 s, average=0.006 s; distance=15 kB, estimate=165 kB; lsn=7/AAE10E28, redo lsn=7/AAE10DD0 2025-12-15 07:41:02.430 CET [7120] LOG: checkpoint starting: time 2025-12-15 07:41:02.721 CET [7120] LOG: checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.218 s, sync=0.025 s, total=0.292 s; sync files=3, longest=0.009 s, average=0.009 s; distance=15 kB, estimate=150 kB; lsn=7/AAE14BB0, redo lsn=7/AAE14B58 2025-12-15 08:07:43.128 CET [2504] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-12-15 08:07:43.128 CET [2504] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2025-12-15 08:07:43.307 CET [5540] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-12-15 08:07:43.307 CET [5540] 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-12-15 08:07:43.396 CET [4784] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-12-15 08:07:43.396 CET [4784] 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-12-15 08:07:43.594 CET [2772] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-12-15 08:07:43.594 CET [2772] 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-12-15 08:07:43.635 CET [4456] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-12-15 08:07:43.635 CET [4456] STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice; SELECT set_config('bytea_output','hex',false) FROM pg_show_all_settings() WHERE name = 'bytea_output'; SET client_encoding='utf-8'; 2025-12-15 08:07:43.720 CET [3772] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-12-15 08:07:43.720 CET [3772] 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-12-15 08:08:53.291 CET [4784] ERROR: syntax error at or near "=" at character 36 2025-12-15 08:08:53.291 CET [4784] STATEMENT: SELECT * FROM wms.PickLocDVW artnr = '052116'; 2025-12-15 08:11:02.767 CET [7120] LOG: checkpoint starting: time 2025-12-15 08:11:03.279 CET [7120] LOG: checkpoint complete: wrote 5 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.441 s, sync=0.022 s, total=0.513 s; sync files=4, longest=0.008 s, average=0.006 s; distance=21 kB, estimate=137 kB; lsn=7/AAE1A368, redo lsn=7/AAE1A310 2025-12-15 08:16:02.285 CET [7120] LOG: checkpoint starting: time 2025-12-15 08:16:02.787 CET [7120] LOG: checkpoint complete: wrote 5 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.437 s, sync=0.021 s, total=0.503 s; sync files=3, longest=0.009 s, average=0.007 s; distance=32 kB, estimate=127 kB; lsn=7/AAE226D0, redo lsn=7/AAE22678 2025-12-15 08:19:33.291 CET [4456] ERROR: unterminated quoted identifier at or near """ at character 400 2025-12-15 08:19:33.291 CET [4456] STATEMENT: SELECT artnr AS ArticleId, descr AS name, STRING_AGG(CASE WHEN zone <> 'XWEB' THEN LocName END, ', ') AS DcLoc, STRING_AGG(CASE WHEN zone = 'XWEB' THEN LocName END, ', ') AS VirLoc, SUM(CASE WHEN zone = 'XWEB' THEN quantity ELSE 0 END) AS VirQty, SUM(CASE WHEN zone <> 'XWEB' THEN quantity ELSE 0 END) AS DcQty FROM wms.PickLocDVW WHERE LocState = 'A' GROUP BY artnr, descr;" 2025-12-15 08:21:02.797 CET [7120] LOG: checkpoint starting: time 2025-12-15 08:21:03.087 CET [7120] LOG: checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.217 s, sync=0.024 s, total=0.291 s; sync files=3, longest=0.010 s, average=0.008 s; distance=15 kB, estimate=116 kB; lsn=7/AAE26590, redo lsn=7/AAE26538 2025-12-15 08:23:29.284 CET [5232] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-12-15 08:26:02.088 CET [7120] LOG: checkpoint starting: time 2025-12-15 08:26:03.260 CET [7120] LOG: checkpoint complete: wrote 11 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.085 s, sync=0.035 s, total=1.173 s; sync files=5, longest=0.011 s, average=0.007 s; distance=71 kB, estimate=111 kB; lsn=7/AAE38318, redo lsn=7/AAE382C0 2025-12-15 08:34:06.666 CET [560] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-12-15 08:34:06.667 CET [6976] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-12-15 08:43:32.989 CET [1140] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-12-15 08:45:49.604 CET [1280] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-12-15 08:50:58.610 CET [4052] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-12-15 08:50:58.611 CET [7096] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-12-15 08:53:14.806 CET [2948] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-12-15 09:06:02.284 CET [7120] LOG: checkpoint starting: time 2025-12-15 09:06:02.456 CET [7120] LOG: checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.108 s, sync=0.012 s, total=0.172 s; sync files=2, longest=0.007 s, average=0.006 s; distance=6 kB, estimate=101 kB; lsn=7/AAE39E90, redo lsn=7/AAE39E38 2025-12-15 09:16:02.452 CET [7120] LOG: checkpoint starting: time 2025-12-15 09:16:02.623 CET [7120] LOG: checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.103 s, sync=0.016 s, total=0.172 s; sync files=2, longest=0.011 s, average=0.008 s; distance=7 kB, estimate=91 kB; lsn=7/AAE3BD38, redo lsn=7/AAE3BCE0 2025-12-15 09:26:02.619 CET [7120] LOG: checkpoint starting: time 2025-12-15 09:26:02.788 CET [7120] LOG: checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.102 s, sync=0.013 s, total=0.170 s; sync files=2, longest=0.008 s, average=0.007 s; distance=1 kB, estimate=82 kB; lsn=7/AAE3C398, redo lsn=7/AAE3C340 2025-12-15 10:07:53.302 CET [2504] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-12-15 10:07:53.458 CET [5540] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-12-15 10:07:53.755 CET [2772] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-12-15 10:07:54.099 CET [3772] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-12-15 10:16:31.416 CET [4784] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-12-15 10:19:48.243 CET [4456] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host.