2025-11-26 04:53:14.165 CET [5096] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-26 04:53:14.165 CET [5096] 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-26 04:53:14.600 CET [3900] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-26 04:53:14.600 CET [3900] 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-26 05:00:29.911 CET [3900] ERROR: syntax error at end of input at character 2164 2025-11-26 05:00:29.911 CET [3900] STATEMENT: Select stockeventid, userexec, newdt, lgstkproc, mainprocess, restypeexec, handlingtype, oldlocation, newlocation, newartnr, newqty, resourceexec, collobarcode, picklistid, conr, contid From ltt.StockEvents WHERE --oldlocation <> newlocation newdaydt = DATE '2025-11-24' AND userexec = 'JENDRYKES' -- Web picking -- AND restypeexec = 'HAND' AND mainprocess = 'ORDPICK' AND lgstkproc = 'ORDPICK' AND handlingtype = 'OP2' AND oldlocation is null -- Rivers pikowanie -- AND restypeexec = 'HAND' AND mainprocess = 'NAVUL' AND lgstkproc = 'REVPCK' AND handlingtype = 'TS2' AND newlocation <> oldlocation --newlocation LIKE 'R%' -- Rivers odkładanie -- AND restypeexec = 'HAND' AND mainprocess = 'NAVUL' AND lgstkproc = 'REVPCK' AND handlingtype = 'TU4' AND newlocation LIKE 'X%' AND newlocation NOT LIKE 'XWE%' -- Packing -- AND handlingtype = 'XP3' AND oldlocation ='TAFEL008' AND oldlocation<>newlocation -- Werk AND restypeexec = 'HAND' AND --mainprocess = 'ALGEMEEN'-- AND lgstkproc = 'STOCKCHG' -- AND newlocation <> oldlocation AND oldlocation LIKE 'R%' --AND handlingtype IN ('TU4', 'TU5', 'XP3') --AND mainprocess = 'ALGEMEEN' --AND restypeexec = 'HAND' --AND oldlocation <> newlocation --AND handlingtype = 'TU4' --AND oldlocation LIKE 'R%' --AND newlocation LIKE 'X%' --ORDER BY userexec ASC, newdt asc --LIMIT 1000 718450732 ----- lgstkproc ----- -- DESPATCH -- INVENT -- NAVUL -- ONTVANG -- ORDPICK -- REALLOC -- REVPCK -- STOCKCHG - WERK ------------------------- ---- mainprocess ----- -- ALGEMEEN - WERK -- DESPATCH -- INRUIM -- INVENT -- NAVUL -- ORDPICK -- REALLOC -------------------------- ---- handlingtype ----- -- DL1 -- DV1 -- FPE -- LC1 -- LP1 -- MS1 -- MV1 -- OP1 -- OP2 -- OP5 -- RC0 -- RC1 -- RS1 -- SNP -- SQL -- TI1 -- TO5 -- TS2 -- TU2 -- TU4 - WERK TO PICK LOC -- TU5 - WERK TO STOCK LOC -- WV1 -- XC1 -- XC2 -- XC4 -- XC5 -- XL2 -- XL4 -- XL6 -- XP2 -- XP3 - WERK TO STOCK LOC -- XP4 -- XP5 ----------------------- ---- WERK ---- -- AND lgstkproc = 'STOCKCHG' -- AND mainprocess = 'ALGEMEEN' -- AND handlingtype = 'TU4' -- AND restypeexec = 'HAND' -- AND oldlocation LIKE 'R%' -- AND newlocation LIKE 'X%' 2025-11-26 05:00:30.577 CET [7120] LOG: checkpoint starting: time 2025-11-26 05:00:30.875 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.035 s, total=0.299 s; sync files=3, longest=0.016 s, average=0.012 s; distance=8 kB, estimate=105 kB; lsn=7/AA4BFD48, redo lsn=7/AA4BFCF0 2025-11-26 05:03:34.775 CET [3900] ERROR: syntax error at or near "NOT" at character 1099 2025-11-26 05:03:34.775 CET [3900] STATEMENT: Select stockeventid, userexec, newdt, lgstkproc, mainprocess, restypeexec, handlingtype, oldlocation, newlocation, newartnr, newqty, resourceexec, collobarcode, picklistid, conr, contid From ltt.StockEvents WHERE --oldlocation <> newlocation newdaydt = DATE '2025-11-24' AND userexec = 'JENDRYKES' -- Web picking -- AND restypeexec = 'HAND' AND mainprocess = 'ORDPICK' AND lgstkproc = 'ORDPICK' AND handlingtype = 'OP2' AND oldlocation is null -- Rivers pikowanie -- AND restypeexec = 'HAND' AND mainprocess = 'NAVUL' AND lgstkproc = 'REVPCK' AND handlingtype = 'TS2' AND newlocation <> oldlocation --newlocation LIKE 'R%' -- Rivers odkładanie -- AND restypeexec = 'HAND' AND mainprocess = 'NAVUL' AND lgstkproc = 'REVPCK' AND handlingtype = 'TU4' AND newlocation LIKE 'X%' AND newlocation NOT LIKE 'XWE%' -- Packing -- AND handlingtype = 'XP3' AND oldlocation ='TAFEL008' AND oldlocation<>newlocation -- Werk AND restypeexec = 'HAND' AND mainprocess = 'ALGEMEEN' AND lgstkproc = 'STOCKCHG' AND (oldlocation LIKE 'R%' OR oldlocation is null) AND newlocation NOT LIKE 'XWE%' AND newlocation NOT 'X%' AND handlingtype IN ('TU4', 'TU5', 'XP3') --AND mainprocess = 'ALGEMEEN' --AND restypeexec = 'HAND' --AND oldlocation <> newlocation --AND handlingtype = 'TU4' --AND oldlocation LIKE 'R%' --AND newlocation LIKE 'X%' --ORDER BY userexec ASC, newdt asc --LIMIT 1000 718450732 ----- lgstkproc ----- -- DESPATCH -- INVENT -- NAVUL -- ONTVANG -- ORDPICK -- REALLOC -- REVPCK -- STOCKCHG - WERK ------------------------- ---- mainprocess ----- -- ALGEMEEN - WERK -- DESPATCH -- INRUIM -- INVENT -- NAVUL -- ORDPICK -- REALLOC -------------------------- ---- handlingtype ----- -- DL1 -- DV1 -- FPE -- LC1 -- LP1 -- MS1 -- MV1 -- OP1 -- OP2 -- OP5 -- RC0 -- RC1 -- RS1 -- SNP -- SQL -- TI1 -- TO5 -- TS2 -- TU2 -- TU4 - WERK TO PICK LOC -- TU5 - WERK TO STOCK LOC -- WV1 -- XC1 -- XC2 -- XC4 -- XC5 -- XL2 -- XL4 -- XL6 -- XP2 -- XP3 - WERK TO STOCK LOC -- XP4 -- XP5 ----------------------- ---- WERK ---- -- AND lgstkproc = 'STOCKCHG' -- AND mainprocess = 'ALGEMEEN' -- AND handlingtype = 'TU4' -- AND restypeexec = 'HAND' -- AND oldlocation LIKE 'R%' -- AND newlocation LIKE 'X%' 2025-11-26 05:05:30.862 CET [7120] LOG: checkpoint starting: time 2025-11-26 05:05:31.145 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.021 s, total=0.284 s; sync files=3, longest=0.009 s, average=0.007 s; distance=10 kB, estimate=95 kB; lsn=7/AA4C28E8, redo lsn=7/AA4C2890 2025-11-26 06:15:30.197 CET [7120] LOG: checkpoint starting: time 2025-11-26 06:15:34.486 CET [7120] LOG: checkpoint complete: wrote 39 buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=4.153 s, sync=0.092 s, total=4.289 s; sync files=12, longest=0.017 s, average=0.008 s; distance=208 kB, estimate=208 kB; lsn=7/AA5014C8, redo lsn=7/AA4F6908 2025-11-26 06:20:30.482 CET [7120] LOG: checkpoint starting: time 2025-11-26 06:20:30.991 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.023 s, total=0.509 s; sync files=4, longest=0.009 s, average=0.006 s; distance=50 kB, estimate=192 kB; lsn=7/AA503398, redo lsn=7/AA503340 2025-11-26 06:25:30.983 CET [7120] LOG: checkpoint starting: time 2025-11-26 06:25:31.813 CET [7120] LOG: checkpoint complete: wrote 8 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.764 s, sync=0.021 s, total=0.830 s; sync files=4, longest=0.008 s, average=0.006 s; distance=25 kB, estimate=175 kB; lsn=7/AA509930, redo lsn=7/AA5098D8 2025-11-26 06:30:30.817 CET [7120] LOG: checkpoint starting: time 2025-11-26 06:30:31.218 CET [7120] LOG: checkpoint complete: wrote 4 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.328 s, sync=0.024 s, total=0.401 s; sync files=3, longest=0.011 s, average=0.008 s; distance=9 kB, estimate=159 kB; lsn=7/AA50C118, redo lsn=7/AA50C0C0 2025-11-26 06:35:30.217 CET [7120] LOG: checkpoint starting: time 2025-11-26 06:35:30.607 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.391 s; sync files=3, longest=0.011 s, average=0.007 s; distance=16 kB, estimate=144 kB; lsn=7/AA510190, redo lsn=7/AA510138 2025-11-26 06:40:30.618 CET [7120] LOG: checkpoint starting: time 2025-11-26 06:40:30.904 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.020 s, total=0.286 s; sync files=3, longest=0.009 s, average=0.007 s; distance=13 kB, estimate=131 kB; lsn=7/AA5135B8, redo lsn=7/AA513560 2025-11-26 06:53:24.335 CET [5096] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-26 07:05:17.471 CET [3900] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-26 08:05:30.941 CET [7120] LOG: checkpoint starting: time 2025-11-26 08:05:31.228 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.024 s, total=0.287 s; sync files=3, longest=0.009 s, average=0.008 s; distance=11 kB, estimate=119 kB; lsn=7/AA5164C0, redo lsn=7/AA516468 2025-11-26 12:45:30.535 CET [7120] LOG: checkpoint starting: time 2025-11-26 12:45:31.048 CET [7120] LOG: checkpoint complete: wrote 5 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.436 s, sync=0.031 s, total=0.514 s; sync files=4, longest=0.013 s, average=0.008 s; distance=15 kB, estimate=109 kB; lsn=7/AA51A168, redo lsn=7/AA51A110 2025-11-26 13:25:30.072 CET [7120] LOG: checkpoint starting: time 2025-11-26 13:25:30.358 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.020 s, total=0.287 s; sync files=3, longest=0.009 s, average=0.007 s; distance=6 kB, estimate=98 kB; lsn=7/AA51BCE0, redo lsn=7/AA51BC88 2025-11-26 13:30:30.363 CET [7120] LOG: checkpoint starting: time 2025-11-26 13:30:34.731 CET [7120] LOG: checkpoint complete: wrote 40 buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=4.234 s, sync=0.089 s, total=4.369 s; sync files=10, longest=0.021 s, average=0.009 s; distance=254 kB, estimate=254 kB; lsn=7/AA55B5F8, redo lsn=7/AA55B5A0 2025-11-26 13:35:30.729 CET [7120] LOG: checkpoint starting: time 2025-11-26 13:35:31.324 CET [7120] LOG: checkpoint complete: wrote 6 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.534 s, sync=0.013 s, total=0.595 s; sync files=2, longest=0.009 s, average=0.007 s; distance=33 kB, estimate=232 kB; lsn=7/AA563D98, redo lsn=7/AA563D40 2025-11-26 13:40:30.321 CET [7120] LOG: checkpoint starting: time 2025-11-26 13:40:30.606 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.022 s, total=0.285 s; sync files=3, longest=0.009 s, average=0.008 s; distance=10 kB, estimate=210 kB; lsn=7/AA566950, redo lsn=7/AA5668F8 2025-11-26 13:55:56.540 CET [940] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-26 13:55:56.540 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-26 13:55:56.967 CET [6680] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-26 13:55:56.967 CET [6680] 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-26 13:57:58.066 CET [6680] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-26 13:57:58.069 CET [940] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-26 15:15:30.676 CET [7120] LOG: checkpoint starting: time 2025-11-26 15:15:30.852 CET [7120] LOG: checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.105 s, sync=0.022 s, total=0.177 s; sync files=2, longest=0.015 s, average=0.011 s; distance=3 kB, estimate=189 kB; lsn=7/AA567660, redo lsn=7/AA567608 2025-11-26 15:55:30.900 CET [7120] LOG: checkpoint starting: time 2025-11-26 15:55:31.194 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.029 s, total=0.295 s; sync files=3, longest=0.012 s, average=0.010 s; distance=12 kB, estimate=171 kB; lsn=7/AA56A6B0, redo lsn=7/AA56A658 2025-11-26 16:00:30.193 CET [7120] LOG: checkpoint starting: time 2025-11-26 16:00:30.501 CET [7120] LOG: checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.225 s, sync=0.023 s, total=0.309 s; sync files=3, longest=0.012 s, average=0.008 s; distance=12 kB, estimate=155 kB; lsn=7/AA56D980, redo lsn=7/AA56D928 2025-11-26 16:30:30.513 CET [7120] LOG: checkpoint starting: time 2025-11-26 16:30:31.241 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.028 s, total=0.728 s; sync files=4, longest=0.008 s, average=0.007 s; distance=17 kB, estimate=141 kB; lsn=7/AA571D90, redo lsn=7/AA571D38 2025-11-26 16:35:30.241 CET [7120] LOG: checkpoint starting: time 2025-11-26 16:35:33.966 CET [7120] LOG: checkpoint complete: wrote 34 buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=3.602 s, sync=0.079 s, total=3.725 s; sync files=10, longest=0.013 s, average=0.008 s; distance=195 kB, estimate=195 kB; lsn=7/AA5A2B20, redo lsn=7/AA5A2AC8 2025-11-26 16:40:30.954 CET [7120] LOG: checkpoint starting: time 2025-11-26 16:40:31.118 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.015 s, total=0.165 s; sync files=2, longest=0.009 s, average=0.008 s; distance=4 kB, estimate=176 kB; lsn=7/AA5A3B80, redo lsn=7/AA5A3B28 2025-11-26 19:30:30.253 CET [7120] LOG: checkpoint starting: time 2025-11-26 19:30:30.986 CET [7120] LOG: checkpoint complete: wrote 7 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.645 s, sync=0.036 s, total=0.733 s; sync files=4, longest=0.013 s, average=0.009 s; distance=27 kB, estimate=161 kB; lsn=7/AA5AA840, redo lsn=7/AA5AA7E8