2024-07-22 13:06:49.093 CEST [649] LOG: checkpoint starting: time 2024-07-22 13:07:21.883 CEST [649] LOG: checkpoint complete: wrote 274 buffers (1.7%); 0 WAL file(s) added, 0 removed, 3 recycled; write=32.767 s, sync=0.012 s, total=32.791 s; sync files=45, longest=0.004 s, average=0.001 s; distance=43796 kB, estimate=57580 kB 2024-07-22 13:11:49.908 CEST [649] LOG: checkpoint starting: time 2024-07-22 13:15:13.787 CEST [649] LOG: checkpoint complete: wrote 159 buffers (1.0%); 0 WAL file(s) added, 0 removed, 2 recycled; write=203.858 s, sync=0.007 s, total=203.879 s; sync files=39, longest=0.003 s, average=0.001 s; distance=38078 kB, estimate=55630 kB 2024-07-22 13:16:49.212 CEST [649] LOG: checkpoint starting: time 2024-07-22 13:19:49.628 CEST [649] LOG: checkpoint complete: wrote 147 buffers (0.9%); 0 WAL file(s) added, 0 removed, 3 recycled; write=180.392 s, sync=0.012 s, total=180.417 s; sync files=37, longest=0.003 s, average=0.001 s; distance=37789 kB, estimate=53846 kB 2024-07-22 13:21:49.492 CEST [649] LOG: checkpoint starting: time 2024-07-22 13:24:54.406 CEST [649] LOG: checkpoint complete: wrote 130 buffers (0.8%); 0 WAL file(s) added, 0 removed, 2 recycled; write=184.891 s, sync=0.012 s, total=184.914 s; sync files=50, longest=0.004 s, average=0.001 s; distance=37880 kB, estimate=52249 kB 2024-07-22 13:26:49.284 CEST [649] LOG: checkpoint starting: time 2024-07-22 13:28:40.493 CEST [649] LOG: checkpoint complete: wrote 149 buffers (0.9%); 0 WAL file(s) added, 0 removed, 2 recycled; write=111.185 s, sync=0.014 s, total=111.210 s; sync files=42, longest=0.005 s, average=0.001 s; distance=38112 kB, estimate=50836 kB 2024-07-22 13:31:49.900 CEST [649] LOG: checkpoint starting: time 2024-07-22 13:35:10.812 CEST [649] LOG: checkpoint complete: wrote 218 buffers (1.3%); 0 WAL file(s) added, 0 removed, 3 recycled; write=200.868 s, sync=0.013 s, total=200.913 s; sync files=69, longest=0.004 s, average=0.001 s; distance=42289 kB, estimate=49981 kB 2024-07-22 13:36:49.893 CEST [649] LOG: checkpoint starting: time 2024-07-22 13:40:27.764 CEST [649] LOG: checkpoint complete: wrote 246 buffers (1.5%); 0 WAL file(s) added, 0 removed, 2 recycled; write=217.850 s, sync=0.011 s, total=217.872 s; sync files=61, longest=0.003 s, average=0.001 s; distance=39795 kB, estimate=48962 kB 2024-07-22 13:41:49.846 CEST [649] LOG: checkpoint starting: time 2024-07-22 13:44:41.667 CEST [649] LOG: checkpoint complete: wrote 212 buffers (1.3%); 0 WAL file(s) added, 0 removed, 3 recycled; write=171.794 s, sync=0.013 s, total=171.822 s; sync files=62, longest=0.004 s, average=0.001 s; distance=38052 kB, estimate=47871 kB 2024-07-22 13:46:49.937 CEST [649] LOG: checkpoint starting: time 2024-07-22 13:47:50.090 CEST [649] LOG: checkpoint complete: wrote 148 buffers (0.9%); 0 WAL file(s) added, 0 removed, 2 recycled; write=60.128 s, sync=0.013 s, total=60.153 s; sync files=39, longest=0.003 s, average=0.001 s; distance=35942 kB, estimate=46678 kB 2024-07-22 13:51:49.872 CEST [649] LOG: checkpoint starting: time 2024-07-22 13:53:36.367 CEST [649] LOG: checkpoint complete: wrote 135 buffers (0.8%); 0 WAL file(s) added, 0 removed, 2 recycled; write=106.473 s, sync=0.013 s, total=106.496 s; sync files=42, longest=0.004 s, average=0.001 s; distance=36053 kB, estimate=45616 kB 2024-07-22 13:56:49.312 CEST [649] LOG: checkpoint starting: time 2024-07-22 13:59:31.507 CEST [649] LOG: checkpoint complete: wrote 152 buffers (0.9%); 0 WAL file(s) added, 0 removed, 2 recycled; write=162.173 s, sync=0.012 s, total=162.196 s; sync files=37, longest=0.003 s, average=0.001 s; distance=37360 kB, estimate=44790 kB 2024-07-22 14:01:49.305 CEST [649] LOG: checkpoint starting: time 2024-07-22 14:05:05.356 CEST [649] LOG: checkpoint complete: wrote 302 buffers (1.8%); 0 WAL file(s) added, 0 removed, 4 recycled; write=196.027 s, sync=0.012 s, total=196.052 s; sync files=51, longest=0.003 s, average=0.001 s; distance=58025 kB, estimate=58025 kB 2024-07-22 14:06:49.800 CEST [649] LOG: checkpoint starting: time 2024-07-22 14:07:32.409 CEST [649] LOG: checkpoint complete: wrote 258 buffers (1.6%); 0 WAL file(s) added, 0 removed, 3 recycled; write=42.584 s, sync=0.013 s, total=42.610 s; sync files=43, longest=0.003 s, average=0.001 s; distance=45067 kB, estimate=56729 kB 2024-07-22 14:09:30.385 CEST [38093] zabbix@zabbix LOG: could not receive data from client: Connection reset by peer 2024-07-22 14:09:30.387 CEST [12286] zabbix@zabbix LOG: could not receive data from client: Connection reset by peer 2024-07-22 14:09:30.388 CEST [673] zabbix@zabbix LOG: could not receive data from client: Connection reset by peer 2024-07-22 14:09:30.393 CEST [683] zabbix@zabbix LOG: could not receive data from client: Connection reset by peer 2024-07-22 14:09:30.395 CEST [692] zabbix@zabbix LOG: could not receive data from client: Connection reset by peer 2024-07-22 14:09:30.398 CEST [684] zabbix@zabbix LOG: could not receive data from client: Connection reset by peer 2024-07-22 14:09:30.398 CEST [689] zabbix@zabbix LOG: could not receive data from client: Connection reset by peer 2024-07-22 14:09:30.399 CEST [678] zabbix@zabbix LOG: could not receive data from client: Connection reset by peer 2024-07-22 14:09:30.400 CEST [677] zabbix@zabbix LOG: could not receive data from client: Connection reset by peer 2024-07-22 14:09:30.401 CEST [676] zabbix@zabbix LOG: could not receive data from client: Connection reset by peer 2024-07-22 14:09:30.406 CEST [681] zabbix@zabbix LOG: could not receive data from client: Connection reset by peer 2024-07-22 14:09:30.420 CEST [680] zabbix@zabbix LOG: could not receive data from client: Connection reset by peer 2024-07-22 14:09:30.421 CEST [700] zabbix@zabbix LOG: could not receive data from client: Connection reset by peer 2024-07-22 14:09:30.423 CEST [687] zabbix@zabbix LOG: could not receive data from client: Connection reset by peer 2024-07-22 14:09:30.425 CEST [675] zabbix@zabbix LOG: could not receive data from client: Connection reset by peer 2024-07-22 14:09:30.426 CEST [674] zabbix@zabbix LOG: could not receive data from client: Connection reset by peer 2024-07-22 14:09:30.433 CEST [688] zabbix@zabbix LOG: could not receive data from client: Connection reset by peer 2024-07-22 14:09:30.437 CEST [685] zabbix@zabbix LOG: could not receive data from client: Connection reset by peer 2024-07-22 14:11:49.679 CEST [649] LOG: checkpoint starting: time 2024-07-22 14:12:05.336 CEST [649] LOG: checkpoint complete: wrote 160 buffers (1.0%); 0 WAL file(s) added, 0 removed, 2 recycled; write=15.641 s, sync=0.006 s, total=15.658 s; sync files=161, longest=0.003 s, average=0.001 s; distance=35358 kB, estimate=54592 kB 2024-07-22 14:16:49.425 CEST [649] LOG: checkpoint starting: time 2024-07-22 14:16:50.943 CEST [649] LOG: checkpoint complete: wrote 16 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.507 s, sync=0.003 s, total=1.519 s; sync files=8, longest=0.002 s, average=0.001 s; distance=112 kB, estimate=49144 kB 2024-07-22 14:21:50.024 CEST [649] LOG: checkpoint starting: time 2024-07-22 14:21:54.150 CEST [649] LOG: checkpoint complete: wrote 42 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=4.114 s, sync=0.003 s, total=4.126 s; sync files=17, longest=0.003 s, average=0.001 s; distance=276 kB, estimate=44257 kB 2024-07-22 14:24:00.536 CEST [157106] zabbix@zabbix LOG: could not receive data from client: No route to host 2024-07-22 14:24:00.536 CEST [157106] zabbix@zabbix LOG: unexpected EOF on client connection with an open transaction 2024-07-22 14:26:50.222 CEST [649] LOG: checkpoint starting: time 2024-07-22 14:26:53.344 CEST [649] LOG: checkpoint complete: wrote 32 buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=3.111 s, sync=0.003 s, total=3.123 s; sync files=15, longest=0.002 s, average=0.001 s; distance=36 kB, estimate=39835 kB 2024-07-22 14:31:50.389 CEST [649] LOG: checkpoint starting: time 2024-07-22 14:31:51.505 CEST [649] LOG: checkpoint complete: wrote 12 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.104 s, sync=0.004 s, total=1.117 s; sync files=9, longest=0.003 s, average=0.001 s; distance=48 kB, estimate=35857 kB 2024-07-22 14:36:08.960 CEST [157913] postgres@zabbix ERROR: relation "audit" does not exist at character 22 2024-07-22 14:36:08.960 CEST [157913] postgres@zabbix STATEMENT: SELECT count(*) FROM audit; 2024-07-22 14:36:50.584 CEST [649] LOG: checkpoint starting: time 2024-07-22 14:36:55.010 CEST [649] LOG: checkpoint complete: wrote 46 buffers (0.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=4.416 s, sync=0.003 s, total=4.427 s; sync files=17, longest=0.002 s, average=0.001 s; distance=526 kB, estimate=32323 kB 2024-07-22 14:39:38.520 CEST [157801] zabbix@zabbix LOG: could not receive data from client: No route to host 2024-07-22 14:39:38.520 CEST [157801] zabbix@zabbix LOG: unexpected EOF on client connection with an open transaction 2024-07-22 14:39:38.526 CEST [666] zabbix@zabbix LOG: could not receive data from client: No route to host 2024-07-22 14:39:38.526 CEST [666] zabbix@zabbix LOG: unexpected EOF on client connection with an open transaction 2024-07-22 14:41:50.104 CEST [649] LOG: checkpoint starting: time 2024-07-22 14:41:52.223 CEST [649] LOG: checkpoint complete: wrote 22 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=2.108 s, sync=0.003 s, total=2.120 s; sync files=11, longest=0.002 s, average=0.001 s; distance=128 kB, estimate=29104 kB 2024-07-22 14:46:50.317 CEST [649] LOG: checkpoint starting: time 2024-07-22 14:46:51.635 CEST [649] LOG: checkpoint complete: wrote 14 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.306 s, sync=0.004 s, total=1.319 s; sync files=10, longest=0.003 s, average=0.001 s; distance=97 kB, estimate=26203 kB 2024-07-22 14:51:50.736 CEST [649] LOG: checkpoint starting: time 2024-07-22 14:51:51.954 CEST [649] LOG: checkpoint complete: wrote 13 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.205 s, sync=0.003 s, total=1.219 s; sync files=9, longest=0.003 s, average=0.001 s; distance=96 kB, estimate=23593 kB 2024-07-22 14:56:51.054 CEST [649] LOG: checkpoint starting: time 2024-07-22 14:56:52.269 CEST [649] LOG: checkpoint complete: wrote 13 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.206 s, sync=0.003 s, total=1.216 s; sync files=9, longest=0.002 s, average=0.001 s; distance=97 kB, estimate=21243 kB 2024-07-22 15:01:51.296 CEST [649] LOG: checkpoint starting: time 2024-07-22 15:02:07.944 CEST [649] LOG: checkpoint complete: wrote 168 buffers (1.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=16.639 s, sync=0.003 s, total=16.649 s; sync files=80, longest=0.003 s, average=0.001 s; distance=992 kB, estimate=19218 kB 2024-07-22 15:06:51.992 CEST [649] LOG: checkpoint starting: time 2024-07-22 15:06:53.208 CEST [649] LOG: checkpoint complete: wrote 13 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.206 s, sync=0.003 s, total=1.217 s; sync files=9, longest=0.002 s, average=0.001 s; distance=97 kB, estimate=17306 kB 2024-07-22 15:11:51.277 CEST [649] LOG: checkpoint starting: time 2024-07-22 15:11:52.426 CEST [649] LOG: checkpoint complete: wrote 13 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.113 s, sync=0.004 s, total=1.149 s; sync files=8, longest=0.003 s, average=0.001 s; distance=92 kB, estimate=15584 kB 2024-07-22 15:16:51.488 CEST [649] LOG: checkpoint starting: time 2024-07-22 15:18:18.464 CEST [649] LOG: checkpoint complete: wrote 871 buffers (5.3%); 0 WAL file(s) added, 0 removed, 0 recycled; write=86.965 s, sync=0.003 s, total=86.977 s; sync files=61, longest=0.002 s, average=0.001 s; distance=7205 kB, estimate=14746 kB 2024-07-22 15:21:51.548 CEST [649] LOG: checkpoint starting: time 2024-07-22 15:22:19.330 CEST [649] LOG: checkpoint complete: wrote 278 buffers (1.7%); 0 WAL file(s) added, 0 removed, 0 recycled; write=27.770 s, sync=0.004 s, total=27.782 s; sync files=23, longest=0.003 s, average=0.001 s; distance=247 kB, estimate=13296 kB 2024-07-22 15:26:51.428 CEST [649] LOG: checkpoint starting: time 2024-07-22 15:26:53.445 CEST [649] LOG: checkpoint complete: wrote 21 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=2.008 s, sync=0.003 s, total=2.017 s; sync files=10, longest=0.002 s, average=0.001 s; distance=170 kB, estimate=11984 kB 2024-07-22 15:30:28.398 CEST [158133] LOG: job 1007 threw an error 2024-07-22 15:30:28.407 CEST [158133] ERROR: case not found 2024-07-22 15:30:28.407 CEST [158133] HINT: CASE statement is missing ELSE part. 2024-07-22 15:30:28.407 CEST [158133] CONTEXT: PL/pgSQL function _timescaledb_functions.policy_compression(integer,jsonb) line 58 at CASE 2024-07-22 15:30:28.414 CEST [626] LOG: background worker "Compression Policy [1007]" (PID 158133) exited with exit code 1 2024-07-22 15:31:51.480 CEST [649] LOG: checkpoint starting: time 2024-07-22 15:31:52.798 CEST [649] LOG: checkpoint complete: wrote 14 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.307 s, sync=0.003 s, total=1.318 s; sync files=10, longest=0.002 s, average=0.001 s; distance=106 kB, estimate=10796 kB 2024-07-22 15:36:51.884 CEST [649] LOG: checkpoint starting: time 2024-07-22 15:36:52.902 CEST [649] LOG: checkpoint complete: wrote 11 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.006 s, sync=0.003 s, total=1.018 s; sync files=7, longest=0.002 s, average=0.001 s; distance=96 kB, estimate=9726 kB 2024-07-22 15:41:51.972 CEST [649] LOG: checkpoint starting: time 2024-07-22 15:41:53.089 CEST [649] LOG: checkpoint complete: wrote 13 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.106 s, sync=0.004 s, total=1.118 s; sync files=8, longest=0.003 s, average=0.001 s; distance=99 kB, estimate=8763 kB 2024-07-22 15:46:51.176 CEST [649] LOG: checkpoint starting: time 2024-07-22 15:46:52.298 CEST [649] LOG: checkpoint complete: wrote 12 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.106 s, sync=0.005 s, total=1.122 s; sync files=8, longest=0.004 s, average=0.001 s; distance=99 kB, estimate=7897 kB 2024-07-22 15:51:51.352 CEST [649] LOG: checkpoint starting: time 2024-07-22 15:51:52.468 CEST [649] LOG: checkpoint complete: wrote 12 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.105 s, sync=0.004 s, total=1.117 s; sync files=8, longest=0.003 s, average=0.001 s; distance=108 kB, estimate=7118 kB 2024-07-22 15:56:51.555 CEST [649] LOG: checkpoint starting: time 2024-07-22 15:56:52.673 CEST [649] LOG: checkpoint complete: wrote 12 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.106 s, sync=0.003 s, total=1.119 s; sync files=8, longest=0.002 s, average=0.001 s; distance=97 kB, estimate=6416 kB 2024-07-22 16:01:51.773 CEST [649] LOG: checkpoint starting: time 2024-07-22 16:01:52.890 CEST [649] LOG: checkpoint complete: wrote 12 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.105 s, sync=0.004 s, total=1.117 s; sync files=8, longest=0.003 s, average=0.001 s; distance=105 kB, estimate=5785 kB 2024-07-22 16:06:51.984 CEST [649] LOG: checkpoint starting: time 2024-07-22 16:06:53.102 CEST [649] LOG: checkpoint complete: wrote 12 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.106 s, sync=0.003 s, total=1.119 s; sync files=8, longest=0.002 s, average=0.001 s; distance=95 kB, estimate=5216 kB 2024-07-22 16:11:51.152 CEST [649] LOG: checkpoint starting: time 2024-07-22 16:11:52.170 CEST [649] LOG: checkpoint complete: wrote 12 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0 recycled; write=1.006 s, sync=0.004 s, total=1.018 s; sync files=7, longest=0.003 s, average=0.001 s; distance=100 kB, estimate=4704 kB 2024-07-22 16:16:51.948 CEST [649] LOG: checkpoint starting: time 2024-07-22 16:17:59.507 CEST [649] LOG: checkpoint complete: wrote 678 buffers (4.1%); 0 WAL file(s) added, 0 removed, 3 recycled; write=67.544 s, sync=0.003 s, total=67.560 s; sync files=68, longest=0.003 s, average=0.001 s; distance=40907 kB, estimate=40907 kB 2024-07-22 16:20:25.100 CEST [158318] zabbix@zabbix WARNING: there is no transaction in progress 2024-07-22 16:20:35.105 CEST [158318] zabbix@zabbix LOG: could not receive data from client: Connection reset by peer 2024-07-22 16:21:51.336 CEST [649] LOG: checkpoint starting: time 2024-07-22 16:26:21.066 CEST [649] LOG: checkpoint complete: wrote 587 buffers (3.6%); 0 WAL file(s) added, 0 removed, 13 recycled; write=269.691 s, sync=0.014 s, total=269.730 s; sync files=192, longest=0.003 s, average=0.001 s; distance=207363 kB, estimate=207363 kB 2024-07-22 16:26:51.097 CEST [649] LOG: checkpoint starting: time 2024-07-22 16:29:28.109 CEST [649] LOG: checkpoint complete: wrote 330 buffers (2.0%); 0 WAL file(s) added, 0 removed, 4 recycled; write=156.977 s, sync=0.020 s, total=157.013 s; sync files=41, longest=0.007 s, average=0.001 s; distance=66973 kB, estimate=193324 kB 2024-07-22 16:31:51.884 CEST [649] LOG: checkpoint starting: time 2024-07-22 16:33:06.038 CEST [158399] zabbix@zabbix WARNING: there is no transaction in progress 2024-07-22 16:33:16.044 CEST [158399] zabbix@zabbix LOG: could not receive data from client: Connection reset by peer 2024-07-22 16:33:51.234 CEST [649] LOG: checkpoint complete: wrote 247 buffers (1.5%); 0 WAL file(s) added, 0 removed, 2 recycled; write=119.325 s, sync=0.013 s, total=119.350 s; sync files=74, longest=0.003 s, average=0.001 s; distance=35624 kB, estimate=177554 kB 2024-07-22 16:36:51.836 CEST [649] LOG: checkpoint starting: time 2024-07-22 16:41:02.704 CEST [649] LOG: checkpoint complete: wrote 192 buffers (1.2%); 0 WAL file(s) added, 0 removed, 2 recycled; write=250.822 s, sync=0.034 s, total=250.868 s; sync files=77, longest=0.022 s, average=0.001 s; distance=37641 kB, estimate=163562 kB 2024-07-22 16:41:51.753 CEST [649] LOG: checkpoint starting: time 2024-07-22 16:44:45.692 CEST [649] LOG: checkpoint complete: wrote 322 buffers (2.0%); 0 WAL file(s) added, 0 removed, 2 recycled; write=173.907 s, sync=0.022 s, total=173.939 s; sync files=40, longest=0.010 s, average=0.001 s; distance=36342 kB, estimate=150840 kB