2025-11-20 04:55:24.169 CET [7120] LOG: checkpoint starting: time 2025-11-20 04:55:24.346 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.018 s, total=0.177 s; sync files=2, longest=0.011 s, average=0.009 s; distance=4 kB, estimate=30 kB; lsn=7/AA228B38, redo lsn=7/AA228AE0 2025-11-20 05:09:57.550 CET [1532] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-20 05:09:57.551 CET [6964] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-20 05:23:03.840 CET [4200] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-20 05:23:03.840 CET [4200] 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-20 05:23:04.028 CET [4000] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-20 05:23:04.028 CET [4000] 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-20 05:23:04.138 CET [1028] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-20 05:23:04.138 CET [1028] 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-20 05:23:04.164 CET [7088] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-20 05:23:04.164 CET [7088] 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-20 05:23:04.213 CET [6528] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-20 05:23:04.213 CET [6528] 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-20 05:23:04.287 CET [3368] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-20 05:23:04.287 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-20 05:23:11.671 CET [4324] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-20 05:23:11.671 CET [4324] 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-20 05:23:12.272 CET [5020] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-20 05:23:12.272 CET [5020] 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-20 05:23:12.272 CET [212] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-20 05:23:12.272 CET [212] 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-20 05:23:22.827 CET [656] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-20 05:23:22.827 CET [656] 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-20 05:25:24.349 CET [7120] LOG: checkpoint starting: time 2025-11-20 05:25:25.090 CET [7120] LOG: checkpoint complete: wrote 7 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.657 s, sync=0.041 s, total=0.741 s; sync files=6, longest=0.012 s, average=0.007 s; distance=25 kB, estimate=29 kB; lsn=7/AA22F258, redo lsn=7/AA22F200 2025-11-20 05:30:24.084 CET [7120] LOG: checkpoint starting: time 2025-11-20 05:30:24.475 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.018 s, total=0.391 s; sync files=3, longest=0.007 s, average=0.006 s; distance=12 kB, estimate=28 kB; lsn=7/AA2325D0, redo lsn=7/AA232578 2025-11-20 05:40:24.487 CET [7120] LOG: checkpoint starting: time 2025-11-20 05:40:24.654 CET [7120] LOG: checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.104 s, sync=0.014 s, total=0.168 s; sync files=2, longest=0.009 s, average=0.007 s; distance=0 kB, estimate=25 kB; lsn=7/AA2327A0, redo lsn=7/AA232748 2025-11-20 05:45:24.649 CET [7120] LOG: checkpoint starting: time 2025-11-20 05:45:25.061 CET [7120] LOG: checkpoint complete: wrote 4 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.331 s, sync=0.025 s, total=0.412 s; sync files=3, longest=0.010 s, average=0.009 s; distance=13 kB, estimate=24 kB; lsn=7/AA235EC0, redo lsn=7/AA235E68 2025-11-20 05:47:47.500 CET [392] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-20 05:49:16.170 CET [656] ERROR: argument of WHERE must be type boolean, not type text at character 44 2025-11-20 05:49:16.170 CET [656] STATEMENT: SELECT * FROM sonex.app_translations WHERE pl ORDER BY id ASC 2025-11-20 05:49:19.890 CET [656] ERROR: syntax error at or near "ORDER" at character 45 2025-11-20 05:49:19.890 CET [656] STATEMENT: SELECT * FROM sonex.app_translations WHERE ORDER BY id ASC 2025-11-20 05:50:24.056 CET [7120] LOG: checkpoint starting: time 2025-11-20 05:50:24.562 CET [7120] LOG: checkpoint complete: wrote 5 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.420 s, sync=0.029 s, total=0.507 s; sync files=5, longest=0.007 s, average=0.006 s; distance=20 kB, estimate=23 kB; lsn=7/AA23B158, redo lsn=7/AA23B100 2025-11-20 06:29:30.765 CET [656] ERROR: syntax error at or near "ORDER" at character 38 2025-11-20 06:29:30.765 CET [656] STATEMENT: SELECT * FROM wms.PickDate LIMIT 100 ORDER BY id ASC 2025-11-20 06:29:49.820 CET [656] ERROR: syntax error at or near "ORDER" at character 38 2025-11-20 06:29:49.820 CET [656] STATEMENT: SELECT * FROM wms.PickDate LIMIT 100 ORDER BY UsrName ASC 2025-11-20 06:29:56.453 CET [656] ERROR: syntax error at or near "ORDER" at character 38 2025-11-20 06:29:56.453 CET [656] STATEMENT: SELECT * FROM wms.PickDate LIMIT 100 ORDER BY UsrName ASC 2025-11-20 06:30:04.330 CET [656] ERROR: relation "wms.pickdate" does not exist at character 15 2025-11-20 06:30:04.330 CET [656] STATEMENT: SELECT * FROM wms.PickDate ORDER BY UsrName ASC LIMIT 100 2025-11-20 06:30:42.976 CET [656] ERROR: relation "wms.datedone" does not exist at character 15 2025-11-20 06:30:42.976 CET [656] STATEMENT: SELECT * FROM wms.DateDone ORDER BY UsrName ASC LIMIT 100 2025-11-20 06:41:19.572 CET [656] ERROR: column "username" does not exist at character 8 2025-11-20 06:41:19.572 CET [656] HINT: Perhaps you meant to reference the column "pickstat.usrname". 2025-11-20 06:41:19.572 CET [656] STATEMENT: SELECT username, nrpicks FROM wms.PickStat WHERE pickzone = 'XWEBPICK' ORDER BY UsrName ASC LIMIT 100 2025-11-20 06:41:43.256 CET [656] ERROR: syntax error at or near "ORDER" at character 63 2025-11-20 06:41:43.256 CET [656] STATEMENT: SELECT username, nrpicks FROM wms.PickStat WHERE pickzone = ORDER BY UsrName ASC LIMIT 100 2025-11-20 06:55:18.187 CET [656] ERROR: column "pqueue.reportname" must appear in the GROUP BY clause or be used in an aggregate function at character 189 2025-11-20 06:55:18.187 CET [656] STATEMENT: SELECT usrname AS LocusName, COUNT(jobid) FROM wms.PQueue WHERE reportname = 'LEVBON2X' --AND pickdate >= '2020-11-09'::date --AND pickdate <= '2020-11-09'::date GROUP BY usrname ORDER BY reportname ASC LIMIT 100 2025-11-20 07:23:22.000 CET [4324] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-20 07:53:47.353 CET [656] ERROR: relation "stockevents" does not exist at character 349 2025-11-20 07:53:47.353 CET [656] STATEMENT: SELECT UserExec, COUNT(HandlingId) HandlingId, SUM(AantalArt) AantalArt, SUM(AantalPU) AantalPU, SUM(TotaalAantal) TotaalAantal, dt FROM ( SELECT UserExec, HandlingId, COUNT(DISTINCT OldArtnr) AantalArt, SUM(NewQty / OldSuPerPu) AantalPU, SUM(NewQty) TotaalAantal, NewDayDt Dt FROM StockEvents SE WHERE LgstkProc = 'REVPCK' AND HandlingType = 'XP3' AND OldLocation = 'XWEB-PND' AND NewLocation != 'XWEB-PND' GROUP BY UserExec, HandlingId, NewDayDt) UH WHERE dt >= '19-22-2025'::date AND dt <= '19-22-1900'::date GROUP BY UserExec,Dt ORDER BY dt desc 2025-11-20 07:53:59.438 CET [656] ERROR: date/time field value out of range: "19-22-2025" at character 551 2025-11-20 07:53:59.438 CET [656] HINT: Perhaps you need a different "datestyle" setting. 2025-11-20 07:53:59.438 CET [656] STATEMENT: SELECT UserExec, COUNT(HandlingId) HandlingId, SUM(AantalArt) AantalArt, SUM(AantalPU) AantalPU, SUM(TotaalAantal) TotaalAantal, dt FROM ( SELECT UserExec, HandlingId, COUNT(DISTINCT OldArtnr) AantalArt, SUM(NewQty / OldSuPerPu) AantalPU, SUM(NewQty) TotaalAantal, NewDayDt Dt FROM ltt.StockEvents SE WHERE LgstkProc = 'REVPCK' AND HandlingType = 'XP3' AND OldLocation = 'XWEB-PND' AND NewLocation != 'XWEB-PND' GROUP BY UserExec, HandlingId, NewDayDt) UH WHERE dt >= '19-22-2025'::date AND dt <= '19-22-1900'::date GROUP BY UserExec,Dt ORDER BY dt desc 2025-11-20 07:56:04.624 CET [656] ERROR: syntax error at or near "FROM" at character 63 2025-11-20 07:56:04.624 CET [656] STATEMENT: SELECT UserExec AS LocusName, SUM(AantalArt) AantalArt, FROM ( SELECT UserExec, HandlingId, COUNT(DISTINCT OldArtnr) AantalArt, SUM(NewQty / OldSuPerPu) AantalPU, SUM(NewQty) TotaalAantal, NewDayDt Dt FROM ltt.StockEvents SE WHERE LgstkProc = 'REVPCK' AND HandlingType = 'XP3' AND OldLocation = 'XWEB-PND' AND NewLocation != 'XWEB-PND' GROUP BY UserExec, HandlingId, NewDayDt) UH WHERE dt >= '19-11-2025'::date AND dt <= '20-11-2025'::date GROUP BY UserExec,Dt ORDER BY dt desc 2025-11-20 07:56:10.222 CET [656] ERROR: syntax error at or near "dt" at character 65 2025-11-20 07:56:10.222 CET [656] STATEMENT: SELECT UserExec AS LocusName, SUM(AantalArt) AantalArt dt FROM ( SELECT UserExec, HandlingId, COUNT(DISTINCT OldArtnr) AantalArt, SUM(NewQty / OldSuPerPu) AantalPU, SUM(NewQty) TotaalAantal, NewDayDt Dt FROM ltt.StockEvents SE WHERE LgstkProc = 'REVPCK' AND HandlingType = 'XP3' AND OldLocation = 'XWEB-PND' AND NewLocation != 'XWEB-PND' GROUP BY UserExec, HandlingId, NewDayDt) UH WHERE dt >= '19-11-2025'::date AND dt <= '20-11-2025'::date GROUP BY UserExec,Dt ORDER BY dt desc 2025-11-20 07:56:49.976 CET [656] ERROR: syntax error at or near "FROM" at character 98 2025-11-20 07:56:49.976 CET [656] STATEMENT: SELECT UserExec AS LocusName, SUM(AantalArt) AantalArt, SUM(TotaalAantal) TotaalAantal, FROM ( SELECT UserExec, HandlingId, COUNT(DISTINCT OldArtnr) AantalArt, SUM(NewQty / OldSuPerPu) AantalPU, SUM(NewQty) TotaalAantal, NewDayDt Dt FROM ltt.StockEvents SE WHERE LgstkProc = 'REVPCK' AND HandlingType = 'XP3' AND OldLocation = 'XWEB-PND' AND NewLocation != 'XWEB-PND' GROUP BY UserExec, HandlingId, NewDayDt) UH WHERE dt >= '19-11-2025'::date AND dt <= '20-11-2025'::date GROUP BY UserExec ORDER BY UserExec desc 2025-11-20 07:59:18.052 CET [1804] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-20 07:59:18.052 CET [1804] 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-20 07:59:28.549 CET [4088] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-20 07:59:28.549 CET [4088] 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-20 07:59:48.731 CET [2860] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-20 07:59:48.731 CET [2860] 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-20 08:00:24.665 CET [7120] LOG: checkpoint starting: time 2025-11-20 08:00:24.973 CET [7120] LOG: checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.221 s, sync=0.022 s, total=0.308 s; sync files=2, longest=0.012 s, average=0.011 s; distance=8 kB, estimate=22 kB; lsn=7/AA23D230, redo lsn=7/AA23D1D8 2025-11-20 08:08:32.515 CET [5556] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-20 08:08:32.516 CET [2932] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-20 08:09:34.002 CET [6060] ERROR: invalid input syntax for type timestamp: "@From::date" at character 191 2025-11-20 08:09:34.002 CET [6060] STATEMENT: SELECT usrname AS locusname, SUM(nrpicks) as picking FROM wms.PickStat WHERE pickzone = 'XWEBPICK' AND pickdate >= '@From::date' AND pickdate <= '@To::date' GROUP BY usrname ORDER BY UsrName ASC 2025-11-20 08:09:49.992 CET [4644] ERROR: invalid input syntax for type timestamp: "@From::date" at character 191 2025-11-20 08:09:49.992 CET [4644] STATEMENT: SELECT usrname AS locusname, SUM(nrpicks) as picking FROM wms.PickStat WHERE pickzone = 'XWEBPICK' AND pickdate >= '@From::date' AND pickdate <= '@To::date' GROUP BY usrname ORDER BY UsrName ASC 2025-11-20 08:10:24.964 CET [7120] LOG: checkpoint starting: time 2025-11-20 08:10:25.601 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.046 s, total=0.637 s; sync files=6, longest=0.010 s, average=0.008 s; distance=20 kB, estimate=22 kB; lsn=7/AA242530, redo lsn=7/AA2424D8 2025-11-20 08:11:21.503 CET [6060] ERROR: invalid input syntax for type timestamp: "@From::date" at character 191 2025-11-20 08:11:21.503 CET [6060] STATEMENT: SELECT usrname AS locusname, SUM(nrpicks) as picking FROM wms.PickStat WHERE pickzone = 'XWEBPICK' AND pickdate >= '@From::date' AND pickdate <= '@To::date' GROUP BY usrname ORDER BY UsrName ASC 2025-11-20 08:13:39.256 CET [4644] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-20 08:13:39.257 CET [6060] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-20 08:15:04.337 CET [1152] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-20 08:15:04.338 CET [3884] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-20 08:29:25.917 CET [212] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-20 08:40:02.680 CET [3696] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-20 08:40:02.681 CET [5592] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-20 08:45:02.031 CET [5716] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-20 08:45:02.032 CET [3856] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-20 08:45:02.033 CET [3024] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-20 08:45:02.034 CET [6048] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-20 08:45:02.035 CET [1220] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-20 08:45:24.616 CET [7120] LOG: checkpoint starting: time 2025-11-20 08:45:25.465 CET [7120] LOG: checkpoint complete: wrote 8 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.758 s, sync=0.044 s, total=0.850 s; sync files=5, longest=0.016 s, average=0.009 s; distance=39 kB, estimate=39 kB; lsn=7/AA24C3B8, redo lsn=7/AA24C328 2025-11-20 08:58:51.415 CET [4548] ERROR: canceling statement due to user request 2025-11-20 08:58:51.415 CET [4548] STATEMENT: SELECT UserExec AS LocusName, SUM(AantalArt) AS Rivers FROM ( SELECT UserExec, HandlingId, COUNT(DISTINCT OldArtnr) AantalArt, SUM(NewQty / OldSuPerPu) AantalPU, SUM(NewQty) TotaalAantal, NewDayDt Dt FROM ltt.StockEvents SE WHERE LgstkProc = 'REVPCK' AND HandlingType = 'XP3' AND OldLocation = 'XWEB-PND' AND NewLocation != 'XWEB-PND' GROUP BY UserExec, HandlingId, NewDayDt ) UH WHERE Dt >= $1 AND Dt <= $2 GROUP BY UserExec ORDER BY UserExec DESC 2025-11-20 09:40:24.497 CET [7120] LOG: checkpoint starting: time 2025-11-20 09:40:25.227 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.030 s, total=0.731 s; sync files=4, longest=0.010 s, average=0.008 s; distance=11 kB, estimate=36 kB; lsn=7/AA24F0D8, redo lsn=7/AA24F080 2025-11-20 09:57:11.282 CET [656] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-20 09:59:28.161 CET [1804] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-20 10:00:35.815 CET [4088] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-20 10:14:12.355 CET [2772] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-20 10:14:12.356 CET [1080] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-20 10:15:57.605 CET [7056] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-20 10:15:57.606 CET [3464] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-20 10:17:05.070 CET [6064] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-20 10:17:05.070 CET [6064] 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-20 10:17:05.405 CET [5000] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-20 10:17:05.405 CET [5000] 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-20 10:23:49.026 CET [424] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-20 10:23:49.026 CET [424] 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-20 10:37:20.438 CET [2128] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-20 10:37:20.438 CET [2128] 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-20 10:37:20.485 CET [424] ERROR: canceling statement due to user request 2025-11-20 10:37:20.485 CET [424] STATEMENT: SELECT DISTINCT lgstkproc FROM ltt.StockEvents ORDER BY lgstkproc; 2025-11-20 10:37:20.596 CET [6820] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-20 10:37:20.596 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-20 10:42:25.691 CET [2860] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-20 11:38:35.272 CET [6864] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-20 11:38:35.272 CET [6864] 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-20 11:38:35.695 CET [448] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-20 11:38:35.695 CET [448] 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-20 12:18:50.327 CET [5000] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-20 12:23:58.747 CET [6064] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-20 12:37:30.658 CET [6820] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-20 13:34:32.220 CET [424] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-20 13:38:45.413 CET [6864] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-20 13:38:47.987 CET [448] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-20 13:55:24.410 CET [7120] LOG: checkpoint starting: time 2025-11-20 13:55:24.699 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.025 s, total=0.289 s; sync files=3, longest=0.009 s, average=0.009 s; distance=8 kB, estimate=33 kB; lsn=7/AA2513C8, redo lsn=7/AA251370 2025-11-20 14:00:24.704 CET [7120] LOG: checkpoint starting: time 2025-11-20 14:00:25.097 CET [7120] LOG: checkpoint complete: wrote 4 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.327 s, sync=0.022 s, total=0.394 s; sync files=3, longest=0.011 s, average=0.008 s; distance=15 kB, estimate=32 kB; lsn=7/AA2550F0, redo lsn=7/AA255098 2025-11-20 14:20:03.637 CET [352] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-20 14:20:03.637 CET [352] 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-20 14:20:03.968 CET [1060] LOG: getsockopt(TCP_KEEPCNT) failed: A non-blocking socket operation could not be completed immediately. 2025-11-20 14:20:03.968 CET [1060] 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-20 14:30:08.198 CET [2024] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-20 14:30:24.135 CET [7120] LOG: checkpoint starting: time 2025-11-20 14:30:24.310 CET [7120] LOG: checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.107 s, sync=0.021 s, total=0.176 s; sync files=2, longest=0.013 s, average=0.011 s; distance=2 kB, estimate=29 kB; lsn=7/AA255B10, redo lsn=7/AA255AB8 2025-11-20 14:45:24.303 CET [7120] LOG: checkpoint starting: time 2025-11-20 14:45:24.496 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.017 s, total=0.194 s; sync files=2, longest=0.009 s, average=0.009 s; distance=3 kB, estimate=26 kB; lsn=7/AA2567A0, redo lsn=7/AA256748 2025-11-20 14:50:24.493 CET [7120] LOG: checkpoint starting: time 2025-11-20 14:50:24.667 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.018 s, total=0.175 s; sync files=2, longest=0.011 s, average=0.009 s; distance=3 kB, estimate=24 kB; lsn=7/AA257670, redo lsn=7/AA257618 2025-11-20 14:55:24.675 CET [7120] LOG: checkpoint starting: time 2025-11-20 14:55:24.850 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.019 s, total=0.176 s; sync files=2, longest=0.014 s, average=0.010 s; distance=4 kB, estimate=22 kB; lsn=7/AA2587B0, redo lsn=7/AA258758 2025-11-20 15:10:24.856 CET [7120] LOG: checkpoint starting: time 2025-11-20 15:10:25.022 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.012 s, total=0.166 s; sync files=2, longest=0.007 s, average=0.006 s; distance=4 kB, estimate=20 kB; lsn=7/AA259B30, redo lsn=7/AA259AD8 2025-11-20 15:11:58.715 CET [2920] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-20 15:20:24.030 CET [7120] LOG: checkpoint starting: time 2025-11-20 15:20:24.196 CET [7120] LOG: checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.107 s, sync=0.012 s, total=0.166 s; sync files=2, longest=0.007 s, average=0.006 s; distance=5 kB, estimate=19 kB; lsn=7/AA25B120, redo lsn=7/AA25B0C8 2025-11-20 15:21:24.864 CET [1060] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host. 2025-11-20 15:25:24.198 CET [7120] LOG: checkpoint starting: time 2025-11-20 15:25:24.701 CET [7120] LOG: checkpoint complete: wrote 5 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.435 s, sync=0.022 s, total=0.504 s; sync files=3, longest=0.014 s, average=0.008 s; distance=20 kB, estimate=20 kB; lsn=7/AA2601C0, redo lsn=7/AA260168 2025-11-20 15:30:24.705 CET [7120] LOG: checkpoint starting: time 2025-11-20 15:30:24.881 CET [7120] LOG: checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.109 s, sync=0.023 s, total=0.176 s; sync files=2, longest=0.016 s, average=0.012 s; distance=5 kB, estimate=18 kB; lsn=7/AA261650, redo lsn=7/AA2615F8 2025-11-20 16:20:13.758 CET [352] LOG: could not receive data from client: An existing connection was forcibly closed by the remote host.