Influx arbeitet nicht mehr stabil
-
@altersrentner sagte in Influx arbeitet nicht mehr stabil:
Auf alle Fälle habe ich viel zu viele geloggte Datenpunkte,
die ich jetzt händisch von influx befreie.dachte das hast du bereits
https://forum.iobroker.net/post/725155 -
@crunchip
Ich bin immer noch händisch dabei
sieht es jetzt schon besser aus?code_text/lib/influxdb/data/iobroker/global/334/000000126-000000002.tsm Dec 28 15:52:27 raspberrypi influxd[8371]: ts=2021-12-28T14:52:27.935591Z lvl=info msg="Aborted compaction" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOIZcl000 op_name=tsm1_compact_group error="compaction in progress: open /var/lib/influxdb/data/iobroker/global/334/000000126-000000003.tsm.tmp: file exists" Dec 28 15:52:27 raspberrypi influxd[8371]: ts=2021-12-28T14:52:27.937801Z lvl=info msg="TSM compaction (end)" log_id=0YgR3JW0000 engine=tsm1 tsm1_level=2 tsm1_strategy=level trace_id=0YhOIVjG000 op_name=tsm1_compact_group op_event=end op_elapsed=1000.493ms Dec 28 15:52:27 raspberrypi influxd[8371]: ts=2021-12-28T14:52:27.938212Z lvl=info msg="TSM compaction (start)" log_id=0YgR3JW0000 engine=tsm1 tsm1_level=2 tsm1_strategy=level trace_id=0YhOIZdW000 op_name=tsm1_compact_group op_event=start Dec 28 15:52:27 raspberrypi influxd[8371]: ts=2021-12-28T14:52:27.938274Z lvl=info msg="Beginning compaction" log_id=0YgR3JW0000 engine=tsm1 tsm1_level=2 tsm1_strategy=level trace_id=0YhOIZdW000 op_name=tsm1_compact_group tsm1_files_n=4 Dec 28 15:52:27 raspberrypi influxd[8371]: ts=2021-12-28T14:52:27.938317Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_level=2 tsm1_strategy=level trace_id=0YhOIZdW000 op_name=tsm1_compact_group tsm1_index=0 tsm1_file=/var/lib/influxdb/data/iobroker/global/278/000000027-000000002.tsm Dec 28 15:52:27 raspberrypi influxd[8371]: ts=2021-12-28T14:52:27.938363Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_level=2 tsm1_strategy=level trace_id=0YhOIZdW000 op_name=tsm1_compact_group tsm1_index=1 tsm1_file=/var/lib/influxdb/data/iobroker/global/278/000000040-000000002.tsm Dec 28 15:52:27 raspberrypi influxd[8371]: ts=2021-12-28T14:52:27.938406Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_level=2 tsm1_strategy=level trace_id=0YhOIZdW000 op_name=tsm1_compact_group tsm1_index=2 tsm1_file=/var/lib/influxdb/data/iobroker/global/278/000000052-000000002.tsm Dec 28 15:52:27 raspberrypi influxd[8371]: ts=2021-12-28T14:52:27.938450Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_level=2 tsm1_strategy=level trace_id=0YhOIZdW000 op_name=tsm1_compact_group tsm1_index=3 tsm1_file=/var/lib/influxdb/data/iobroker/global/278/000000068-000000002.tsm Dec 28 15:52:27 raspberrypi influxd[8371]: ts=2021-12-28T14:52:27.938620Z lvl=info msg="Aborted compaction" log_id=0YgR3JW0000 engine=tsm1 tsm1_level=2 tsm1_strategy=level trace_id=0YhOIZdW000 op_name=tsm1_compact_group error="compaction in progress: open /var/lib/influxdb/data/iobroker/global/278/000000068-000000003.tsm.tmp: file exists" Dec 28 15:52:28 raspberrypi influxd[8371]: ts=2021-12-28T14:52:28.935777Z lvl=info msg="TSM compaction (end)" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOIZcl000 op_name=tsm1_compact_group op_event=end op_elapsed=1000.715ms Dec 28 15:52:28 raspberrypi influxd[8371]: ts=2021-12-28T14:52:28.937328Z lvl=info msg="TSM compaction (start)" log_id=0YgR3JW0000 engine=tsm1 tsm1_level=2 tsm1_strategy=level trace_id=0YhOIcYG000 op_name=tsm1_compact_group op_event=start Dec 28 15:52:28 raspberrypi influxd[8371]: ts=2021-12-28T14:52:28.937376Z lvl=info msg="Beginning compaction" log_id=0YgR3JW0000 engine=tsm1 tsm1_level=2 tsm1_strategy=level trace_id=0YhOIcYG000 op_name=tsm1_compact_group tsm1_files_n=4 Dec 28 15:52:28 raspberrypi influxd[8371]: ts=2021-12-28T14:52:28.937397Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_level=2 tsm1_strategy=level trace_id=0YhOIcYG000 op_name=tsm1_compact_group tsm1_index=0 tsm1_file=/var/lib/influxdb/data/iobroker/global/294/000000036-000000002.tsm Dec 28 15:52:28 raspberrypi influxd[8371]: ts=2021-12-28T14:52:28.937420Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_level=2 tsm1_strategy=level trace_id=0YhOIcYG000 op_name=tsm1_compact_group tsm1_index=1 tsm1_file=/var/lib/influxdb/data/iobroker/global/294/000000046-000000002.tsm Dec 28 15:52:28 raspberrypi influxd[8371]: ts=2021-12-28T14:52:28.937440Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_level=2 tsm1_strategy=level trace_id=0YhOIcYG000 op_name=tsm1_compact_group tsm1_index=2 tsm1_file=/var/lib/influxdb/data/iobroker/global/294/000000062-000000002.tsm Dec 28 15:52:28 raspberrypi influxd[8371]: ts=2021-12-28T14:52:28.937461Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_level=2 tsm1_strategy=level trace_id=0YhOIcYG000 op_name=tsm1_compact_group tsm1_index=3 tsm1_file=/var/lib/influxdb/data/iobroker/global/294/000000078-000000002.tsm Dec 28 15:52:28 raspberrypi influxd[8371]: ts=2021-12-28T14:52:28.937569Z lvl=info msg="Aborted compaction" log_id=0YgR3JW0000 engine=tsm1 tsm1_level=2 tsm1_strategy=level trace_id=0YhOIcYG000 op_name=tsm1_compact_group error="compaction in progress: open /var/lib/influxdb/data/iobroker/global/294/000000078-000000003.tsm.tmp: file exists" Dec 28 15:52:28 raspberrypi influxd[8371]: ts=2021-12-28T14:52:28.938823Z lvl=info msg="TSM compaction (end)" log_id=0YgR3JW0000 engine=tsm1 tsm1_level=2 tsm1_strategy=level trace_id=0YhOIZdW000 op_name=tsm1_compact_group op_event=end op_elapsed=1000.622ms Dec 28 15:52:29 raspberrypi influxd[8371]: ts=2021-12-28T14:52:29.134435Z lvl=info msg="Executing query" log_id=0YgR3JW0000 service=query query="SELECT max(value) FROM iobroker.global.\"mihome.0.devices.weather_v1_158d00023213f6.temperature\" WHERE time >= now() - 1d AND time <= now() GROUP BY time(2m) fill(previous)" Dec 28 15:52:29 raspberrypi influxd[8371]: ts=2021-12-28T14:52:29.145194Z lvl=info msg="Executing query" log_id=0YgR3JW0000 service=query query="SELECT max(value) FROM iobroker.global.\"fhem.0.Temp_Heizkessel.temperature\" WHERE time >= now() - 1d AND time <= now() GROUP BY time(2m) fill(previous)" Dec 28 15:52:29 raspberrypi influxd[8371]: ts=2021-12-28T14:52:29.151816Z lvl=info msg="Executing query" log_id=0YgR3JW0000 service=query query="SELECT max(value) FROM iobroker.global.\"hm-rpc.0.OEQ0673599.2.TEMPERATURE\" WHERE time >= now() - 1d AND time <= now() GROUP BY time(2m) fill(previous)" Dec 28 15:52:29 raspberrypi influxd[8371]: ts=2021-12-28T14:52:29.168429Z lvl=info msg="Executing query" log_id=0YgR3JW0000 service=query query="SELECT max(value) FROM iobroker.global.\"shelly.0.SHSW-PM#8CAAB542C16C#1.Relay0.Power\" WHERE time >= now() - 1d AND time <= now() GROUP BY time(2m) fill(previous)" Dec 28 15:52:29 raspberrypi influxd[8371]: [httpd] 192.168.178.94, 192.168.178.94,192.168.178.41 - admin [28/Dec/2021:15:52:29 +0100] "GET /query?db=iobroker&epoch=ms&q=SELECT+max%28%22value%22%29+FROM+%22mihome.0.devices.weather_v1_158d00023213f6.temperature%22+WHERE+time+%3E%3D+now%28%29+-+24h+and+time+%3C%3D+now%28%29+GROUP+BY+time%282m%29+fill%28previous%29%3BSELECT+max%28%22value%22%29+FROM+%22fhem.0.Temp_Heizkessel.temperature%22+WHERE+time+%3E%3D+now%28%29+-+24h+and+time+%3C%3D+now%28%29+GROUP+BY+time%282m%29+fill%28previous%29%3BSELECT+max%28%22value%22%29+FROM+%22hm-rpc.0.OEQ0673599.2.TEMPERATURE%22+WHERE+time+%3E%3D+now%28%29+-+24h+and+time+%3C%3D+now%28%29+GROUP+BY+time%282m%29+fill%28previous%29%3BSELECT+max%28%22value%22%29+FROM+%22shelly.0.SHSW-PM%238CAAB542C16C%231.Relay0.Power%22+WHERE+time+%3E%3D+now%28%29+-+24h+and+time+%3C%3D+now%28%29+GROUP+BY+time%282m%29+fill%28previous%29 HTTP/1.1" 200 8091 "-" "Grafana/8.0.6" c75d0607-67ed-11ec-873a-000000000000 83420 Dec 28 15:52:29 raspberrypi influxd[8371]: ts=2021-12-28T14:52:29.934778Z lvl=info msg="TSM compaction (start)" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOIgRW000 op_name=tsm1_compact_group op_event=start Dec 28 15:52:29 raspberrypi influxd[8371]: ts=2021-12-28T14:52:29.934837Z lvl=info msg="Beginning compaction" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOIgRW000 op_name=tsm1_compact_group tsm1_files_n=5 Dec 28 15:52:29 raspberrypi influxd[8371]: ts=2021-12-28T14:52:29.934860Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOIgRW000 op_name=tsm1_compact_group tsm1_index=0 tsm1_file=/var/lib/influxdb/data/iobroker/global/334/000000041-000000003.tsm Dec 28 15:52:29 raspberrypi influxd[8371]: ts=2021-12-28T14:52:29.934883Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOIgRW000 op_name=tsm1_compact_group tsm1_index=1 tsm1_file=/var/lib/influxdb/data/iobroker/global/334/000000074-000000003.tsm Dec 28 15:52:29 raspberrypi influxd[8371]: ts=2021-12-28T14:52:29.934904Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOIgRW000 op_name=tsm1_compact_group tsm1_index=2 tsm1_file=/var/lib/influxdb/data/iobroker/global/334/000000107-000000003.tsm Dec 28 15:52:29 raspberrypi influxd[8371]: ts=2021-12-28T14:52:29.934926Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOIgRW000 op_name=tsm1_compact_group tsm1_index=3 tsm1_file=/var/lib/influxdb/data/iobroker/global/334/000000115-000000002.tsm Dec 28 15:52:29 raspberrypi influxd[8371]: ts=2021-12-28T14:52:29.934946Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOIgRW000 op_name=tsm1_compact_group tsm1_index=4 tsm1_file=/var/lib/influxdb/data/iobroker/global/334/000000126-000000002.tsm Dec 28 15:52:29 raspberrypi influxd[8371]: ts=2021-12-28T14:52:29.935062Z lvl=info msg="Aborted compaction" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOIgRW000 op_name=tsm1_compact_group error="compaction in progress: open /var/lib/influxdb/data/iobroker/global/334/000000126-000000003.tsm.tmp: file exists" Dec 28 15:52:29 raspberrypi influxd[8371]: ts=2021-12-28T14:52:29.937721Z lvl=info msg="TSM compaction (end)" log_id=0YgR3JW0000 engine=tsm1 tsm1_level=2 tsm1_strategy=level trace_id=0YhOIcYG000 op_name=tsm1_compact_group op_event=end op_elapsed=1000.398ms Dec 28 15:52:30 raspberrypi influxd[8371]: ts=2021-12-28T14:52:30.084112Z lvl=info msg="Executing query" log_id=0YgR3JW0000 service=query query="SELECT max(value) FROM iobroker.global.\"mihome.0.devices.weather_v1_158d00023213f6.temperature\" WHERE time >= now() - 1d AND time <= now() GROUP BY time(2m) fill(previous)" Dec 28 15:52:30 raspberrypi influxd[8371]: ts=2021-12-28T14:52:30.092122Z lvl=info msg="Executing query" log_id=0YgR3JW0000 service=query query="SELECT max(value) FROM iobroker.global.\"hm-rpc.0.20200127_4.1.TEMPERATURE\" WHERE time >= now() - 1d AND time <= now() GROUP BY time(2m) fill(previous)" Dec 28 15:52:30 raspberrypi influxd[8371]: [httpd] 192.168.178.92, 192.168.178.92,192.168.178.41 - admin [28/Dec/2021:15:52:30 +0100] "GET /query?db=iobroker&epoch=ms&q=SELECT+max%28%22value%22%29+FROM+%22mihome.0.devices.weather_v1_158d00023213f6.temperature%22+WHERE+time+%3E%3D+now%28%29+-+24h+and+time+%3C%3D+now%28%29+GROUP+BY+time%282m%29+fill%28previous%29%3BSELECT+max%28%22value%22%29+FROM+%22hm-rpc.0.20200127_4.1.TEMPERATURE%22+WHERE+time+%3E%3D+now%28%29+-+24h+and+time+%3C%3D+now%28%29+GROUP+BY+time%282m%29+fill%28previous%29 HTTP/1.1" 200 4368 "-" "Grafana/8.0.6" c7ee0e2d-67ed-11ec-873b-000000000000 45765 Dec 28 15:52:30 raspberrypi influxd[8371]: ts=2021-12-28T14:52:30.935206Z lvl=info msg="TSM compaction (start)" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOIkLl000 op_name=tsm1_compact_group op_event=start Dec 28 15:52:30 raspberrypi influxd[8371]: ts=2021-12-28T14:52:30.935301Z lvl=info msg="Beginning compaction" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOIkLl000 op_name=tsm1_compact_group tsm1_files_n=5 Dec 28 15:52:30 raspberrypi influxd[8371]: ts=2021-12-28T14:52:30.935213Z lvl=info msg="TSM compaction (end)" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOIgRW000 op_name=tsm1_compact_group op_event=end op_elapsed=1000.440ms Dec 28 15:52:30 raspberrypi influxd[8371]: ts=2021-12-28T14:52:30.935348Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOIkLl000 op_name=tsm1_compact_group tsm1_index=0 tsm1_file=/var/lib/influxdb/data/iobroker/global/270/000000030-000000002.tsm Dec 28 15:52:30 raspberrypi influxd[8371]: ts=2021-12-28T14:52:30.935469Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOIkLl000 op_name=tsm1_compact_group tsm1_index=1 tsm1_file=/var/lib/influxdb/data/iobroker/global/270/000000042-000000002.tsm Dec 28 15:52:30 raspberrypi influxd[8371]: ts=2021-12-28T14:52:30.935527Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOIkLl000 op_name=tsm1_compact_group tsm1_index=2 tsm1_file=/var/lib/influxdb/data/iobroker/global/270/000000044-000000001.tsm Dec 28 15:52:30 raspberrypi influxd[8371]: ts=2021-12-28T14:52:30.935577Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOIkLl000 op_name=tsm1_compact_group tsm1_index=3 tsm1_file=/var/lib/influxdb/data/iobroker/global/270/000000046-000000001.tsm Dec 28 15:52:30 raspberrypi influxd[8371]: ts=2021-12-28T14:52:30.935622Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOIkLl000 op_name=tsm1_compact_group tsm1_index=4 tsm1_file=/var/lib/influxdb/data/iobroker/global/270/000000048-000000001.tsm Dec 28 15:52:30 raspberrypi influxd[8371]: ts=2021-12-28T14:52:30.935662Z lvl=info msg="TSM compaction (start)" log_id=0YgR3JW0000 engine=tsm1 tsm1_level=2 tsm1_strategy=level trace_id=0YhOIkLl001 op_name=tsm1_compact_group op_event=start Dec 28 15:52:30 raspberrypi influxd[8371]: ts=2021-12-28T14:52:30.935733Z lvl=info msg="Beginning compaction" log_id=0YgR3JW0000 engine=tsm1 tsm1_level=2 tsm1_strategy=level trace_id=0YhOIkLl001 op_name=tsm1_compact_group tsm1_files_n=4 Dec 28 15:52:30 raspberrypi influxd[8371]: ts=2021-12-28T14:52:30.935789Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_level=2 tsm1_strategy=level trace_id=0YhOIkLl001 op_name=tsm1_compact_group tsm1_index=0 tsm1_file=/var/lib/influxdb/data/iobroker/global/318/000000043-000000002.tsm Dec 28 15:52:30 raspberrypi influxd[8371]: ts=2021-12-28T14:52:30.935839Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_level=2 tsm1_strategy=level trace_id=0YhOIkLl001 op_name=tsm1_compact_group tsm1_index=1 tsm1_file=/var/lib/influxdb/data/iobroker/global/318/000000058-000000002.tsm Dec 28 15:52:30 raspberrypi influxd[8371]: ts=2021-12-28T14:52:30.935884Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_level=2 tsm1_strategy=level trace_id=0YhOIkLl001 op_name=tsm1_compact_group tsm1_index=2 tsm1_file=/var/lib/influxdb/data/iobroker/global/318/000000074-000000002.tsm Dec 28 15:52:30 raspberrypi influxd[8371]: ts=2021-12-28T14:52:30.935856Z lvl=info msg="Aborted compaction" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOIkLl000 op_name=tsm1_compact_group error="compaction in progress: open /var/lib/influxdb/data/iobroker/global/270/000000048-000000002.tsm.tmp: file exists" Dec 28 15:52:30 raspberrypi influxd[8371]: ts=2021-12-28T14:52:30.935929Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_level=2 tsm1_strategy=level trace_id=0YhOIkLl001 op_name=tsm1_compact_group tsm1_index=3 tsm1_file=/var/lib/influxdb/data/iobroker/global/318/000000090-000000002.tsm Dec 28 15:52:30 raspberrypi influxd[8371]: ts=2021-12-28T14:52:30.936137Z lvl=info msg="Aborted compaction" log_id=0YgR3JW0000 engine=tsm1 tsm1_level=2 tsm1_strategy=level trace_id=0YhOIkLl001 op_name=tsm1_compact_group error="compaction in progress: open /var/lib/influxdb/data/iobroker/global/318/000000090-000000003.tsm.tmp: file exists" Dec 28 15:52:31 raspberrypi influxd[8371]: ts=2021-12-28T14:52:31.936156Z lvl=info msg="TSM compaction (end)" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOIkLl000 op_name=tsm1_compact_group op_event=end op_elapsed=1000.959ms Dec 28 15:52:31 raspberrypi influxd[8371]: ts=2021-12-28T14:52:31.936434Z lvl=info msg="TSM compaction (end)" log_id=0YgR3JW0000 engine=tsm1 tsm1_level=2 tsm1_strategy=level trace_id=0YhOIkLl001 op_name=tsm1_compact_group op_event=end op_elapsed=1000.831ms Dec 28 15:52:31 raspberrypi influxd[8371]: ts=2021-12-28T14:52:31.937832Z lvl=info msg="TSM compaction (start)" log_id=0YgR3JW0000 engine=tsm1 tsm1_level=2 tsm1_strategy=level trace_id=0YhOIoGG000 op_name=tsm1_compact_group op_event=start Dec 28 15:52:31 raspberrypi influxd[8371]: ts=2021-12-28T14:52:31.937960Z lvl=info msg="Beginning compaction" log_id=0YgR3JW0000 engine=tsm1 tsm1_level=2 tsm1_strategy=level trace_id=0YhOIoGG000 op_name=tsm1_compact_group tsm1_files_n=4 Dec 28 15:52:31 raspberrypi influxd[8371]: ts=2021-12-28T14:52:31.938039Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_level=2 tsm1_strategy=level trace_id=0YhOIoGG000 op_name=tsm1_compact_group tsm1_index=0 tsm1_file=/var/lib/influxdb/data/iobroker/global/294/000000036-000000002.tsm Dec 28 15:52:31 raspberrypi influxd[8371]: ts=2021-12-28T14:52:31.937833Z lvl=info msg="TSM compaction (start)" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOIoGG001 op_name=tsm1_compact_group op_event=start Dec 28 15:52:31 raspberrypi influxd[8371]: ts=2021-12-28T14:52:31.938096Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_level=2 tsm1_strategy=level trace_id=0YhOIoGG000 op_name=tsm1_compact_group tsm1_index=1 tsm1_file=/var/lib/influxdb/data/iobroker/global/294/000000046-000000002.tsm Dec 28 15:52:31 raspberrypi influxd[8371]: ts=2021-12-28T14:52:31.938154Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_level=2 tsm1_strategy=level trace_id=0YhOIoGG000 op_name=tsm1_compact_group tsm1_index=2 tsm1_file=/var/lib/influxdb/data/iobroker/global/294/000000062-000000002.tsm Dec 28 15:52:31 raspberrypi influxd[8371]: ts=2021-12-28T14:52:31.938140Z lvl=info msg="Beginning compaction" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOIoGG001 op_name=tsm1_compact_group tsm1_files_n=8 Dec 28 15:52:31 raspberrypi influxd[8371]: ts=2021-12-28T14:52:31.938210Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_level=2 tsm1_strategy=level trace_id=0YhOIoGG000 op_name=tsm1_compact_group tsm1_index=3 tsm1_file=/var/lib/influxdb/data/iobroker/global/294/000000078-000000002.tsm Dec 28 15:52:31 raspberrypi influxd[8371]: ts=2021-12-28T14:52:31.938236Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOIoGG001 op_name=tsm1_compact_group tsm1_index=0 tsm1_file=/var/lib/influxdb/data/iobroker/global/286/000000032-000000002.tsm Dec 28 15:52:31 raspberrypi influxd[8371]: ts=2021-12-28T14:52:31.938294Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOIoGG001 op_name=tsm1_compact_group tsm1_index=1 tsm1_file=/var/lib/influxdb/data/iobroker/global/286/000000046-000000002.tsm Dec 28 15:52:31 raspberrypi influxd[8371]: ts=2021-12-28T14:52:31.938346Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOIoGG001 op_name=tsm1_compact_group tsm1_index=2 tsm1_file=/var/lib/influxdb/data/iobroker/global/286/000000047-000000001.tsm Dec 28 15:52:31 raspberrypi influxd[8371]: ts=2021-12-28T14:52:31.938398Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOIoGG001 op_name=tsm1_compact_group tsm1_index=3 tsm1_file=/var/lib/influxdb/data/iobroker/global/286/000000049-000000001.tsm Dec 28 15:52:31 raspberrypi influxd[8371]: ts=2021-12-28T14:52:31.938415Z lvl=info msg="Aborted compaction" log_id=0YgR3JW0000 engine=tsm1 tsm1_level=2 tsm1_strategy=level trace_id=0YhOIoGG000 op_name=tsm1_compact_group error="compaction in progress: open /var/lib/influxdb/data/iobroker/global/294/000000078-000000003.tsm.tmp: file exists" Dec 28 15:52:31 raspberrypi influxd[8371]: ts=2021-12-28T14:52:31.938449Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOIoGG001 op_name=tsm1_compact_group tsm1_index=4 tsm1_file=/var/lib/influxdb/data/iobroker/global/286/000000051-000000001.tsm Dec 28 15:52:31 raspberrypi influxd[8371]: ts=2021-12-28T14:52:31.938559Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOIoGG001 op_name=tsm1_compact_group tsm1_index=5 tsm1_file=/var/lib/influxdb/data/iobroker/global/286/000000053-000000001.tsm Dec 28 15:52:31 raspberrypi influxd[8371]: ts=2021-12-28T14:52:31.940529Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOIoGG001 op_name=tsm1_compact_group tsm1_index=6 tsm1_file=/var/lib/influxdb/data/iobroker/global/286/000000055-000000001.tsm Dec 28 15:52:31 raspberrypi influxd[8371]: ts=2021-12-28T14:52:31.940632Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOIoGG001 op_name=tsm1_compact_group tsm1_index=7 tsm1_file=/var/lib/influxdb/data/iobroker/global/286/000000056-000000001.tsm Dec 28 15:52:31 raspberrypi influxd[8371]: ts=2021-12-28T14:52:31.940914Z lvl=info msg="Aborted compaction" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOIoGG001 op_name=tsm1_compact_group error="compaction in progress: open /var/lib/influxdb/data/iobroker/global/286/000000056-000000002.tsm.tmp: file exists" Dec 28 15:52:32 raspberrypi influxd[8371]: ts=2021-12-28T14:52:32.938749Z lvl=info msg="TSM compaction (end)" log_id=0YgR3JW0000 engine=tsm1 tsm1_level=2 tsm1_strategy=level trace_id=0YhOIoGG000 op_name=tsm1_compact_group op_event=end op_elapsed=1000.929ms Dec 28 15:52:32 raspberrypi influxd[8371]: ts=2021-12-28T14:52:32.941693Z lvl=info msg="TSM compaction (end)" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOIoGG001 op_name=tsm1_compact_group op_event=end op_elapsed=1003.870ms Dec 28 15:52:33 raspberrypi influxd[8371]: ts=2021-12-28T14:52:33.935345Z lvl=info msg="TSM compaction (start)" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOIw3l001 op_name=tsm1_compact_group op_event=start Dec 28 15:52:33 raspberrypi influxd[8371]: ts=2021-12-28T14:52:33.936096Z lvl=info msg="Beginning compaction" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOIw3l001 op_name=tsm1_compact_group tsm1_files_n=5 Dec 28 15:52:33 raspberrypi influxd[8371]: ts=2021-12-28T14:52:33.936260Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOIw3l001 op_name=tsm1_compact_group tsm1_index=0 tsm1_file=/var/lib/influxdb/data/iobroker/global/270/000000030-000000002.tsm Dec 28 15:52:33 raspberrypi influxd[8371]: ts=2021-12-28T14:52:33.936318Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOIw3l001 op_name=tsm1_compact_group tsm1_index=1 tsm1_file=/var/lib/influxdb/data/iobroker/global/270/000000042-000000002.tsm Dec 28 15:52:33 raspberrypi influxd[8371]: ts=2021-12-28T14:52:33.936360Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOIw3l001 op_name=tsm1_compact_group tsm1_index=2 tsm1_file=/var/lib/influxdb/data/iobroker/global/270/000000044-000000001.tsm Dec 28 15:52:33 raspberrypi influxd[8371]: ts=2021-12-28T14:52:33.936400Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOIw3l001 op_name=tsm1_compact_group tsm1_index=3 tsm1_file=/var/lib/influxdb/data/iobroker/global/270/000000046-000000001.tsm Dec 28 15:52:33 raspberrypi influxd[8371]: ts=2021-12-28T14:52:33.936440Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOIw3l001 op_name=tsm1_compact_group tsm1_index=4 tsm1_file=/var/lib/influxdb/data/iobroker/global/270/000000048-000000001.tsm Dec 28 15:52:33 raspberrypi influxd[8371]: ts=2021-12-28T14:52:33.936646Z lvl=info msg="Aborted compaction" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOIw3l001 op_name=tsm1_compact_group error="compaction in progress: open /var/lib/influxdb/data/iobroker/global/270/000000048-000000002.tsm.tmp: file exists" Dec 28 15:52:33 raspberrypi influxd[8371]: ts=2021-12-28T14:52:33.935337Z lvl=info msg="TSM compaction (start)" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOIw3l000 op_name=tsm1_compact_group op_event=start Dec 28 15:52:33 raspberrypi influxd[8371]: ts=2021-12-28T14:52:33.936787Z lvl=info msg="Beginning compaction" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOIw3l000 op_name=tsm1_compact_group tsm1_files_n=5 Dec 28 15:52:33 raspberrypi influxd[8371]: ts=2021-12-28T14:52:33.936832Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOIw3l000 op_name=tsm1_compact_group tsm1_index=0 tsm1_file=/var/lib/influxdb/data/iobroker/global/334/000000041-000000003.tsm Dec 28 15:52:33 raspberrypi influxd[8371]: ts=2021-12-28T14:52:33.936874Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOIw3l000 op_name=tsm1_compact_group tsm1_index=1 tsm1_file=/var/lib/influxdb/data/iobroker/global/334/000000074-000000003.tsm Dec 28 15:52:33 raspberrypi influxd[8371]: ts=2021-12-28T14:52:33.936914Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOIw3l000 op_name=tsm1_compact_group tsm1_index=2 tsm1_file=/var/lib/influxdb/data/iobroker/global/334/000000107-000000003.tsm Dec 28 15:52:33 raspberrypi influxd[8371]: ts=2021-12-28T14:52:33.936954Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOIw3l000 op_name=tsm1_compact_group tsm1_index=3 tsm1_file=/var/lib/influxdb/data/iobroker/global/334/000000115-000000002.tsm Dec 28 15:52:33 raspberrypi influxd[8371]: ts=2021-12-28T14:52:33.936994Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOIw3l000 op_name=tsm1_compact_group tsm1_index=4 tsm1_file=/var/lib/influxdb/data/iobroker/global/334/000000126-000000002.tsm Dec 28 15:52:33 raspberrypi influxd[8371]: ts=2021-12-28T14:52:33.937178Z lvl=info msg="Aborted compaction" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOIw3l000 op_name=tsm1_compact_group error="compaction in progress: open /var/lib/influxdb/data/iobroker/global/334/000000126-000000003.tsm.tmp: file exists" Dec 28 15:52:34 raspberrypi grafana-server[512]: t=2021-12-28T15:52:34+0100 lvl=warn msg="Request Origin is not authorized" logger=live origin=http://192.168.178.41:3000 appUrl=http://localhost:3000/ allowedOrigins= Dec 28 15:52:34 raspberrypi grafana-server[512]: t=2021-12-28T15:52:34+0100 lvl=info msg="Request Completed" logger=context userId=0 orgId=1 uname= method=GET path=/api/live/ws status=403 remote_addr=192.168.178.92 time_ms=0 size=10 referer= Dec 28 15:52:34 raspberrypi influxd[8371]: ts=2021-12-28T14:52:34.936945Z lvl=info msg="TSM compaction (end)" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOIw3l001 op_name=tsm1_compact_group op_event=end op_elapsed=1001.606ms Dec 28 15:52:34 raspberrypi influxd[8371]: ts=2021-12-28T14:52:34.937343Z lvl=info msg="TSM compaction (start)" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOIzzG000 op_name=tsm1_compact_group op_event=start Dec 28 15:52:34 raspberrypi influxd[8371]: ts=2021-12-28T14:52:34.937410Z lvl=info msg="Beginning compaction" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOIzzG000 op_name=tsm1_compact_group tsm1_files_n=8 Dec 28 15:52:34 raspberrypi influxd[8371]: ts=2021-12-28T14:52:34.937454Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOIzzG000 op_name=tsm1_compact_group tsm1_index=0 tsm1_file=/var/lib/influxdb/data/iobroker/global/286/000000032-000000002.tsm Dec 28 15:52:34 raspberrypi influxd[8371]: ts=2021-12-28T14:52:34.937502Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOIzzG000 op_name=tsm1_compact_group tsm1_index=1 tsm1_file=/var/lib/influxdb/data/iobroker/global/286/000000046-000000002.tsm Dec 28 15:52:34 raspberrypi influxd[8371]: ts=2021-12-28T14:52:34.937547Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOIzzG000 op_name=tsm1_compact_group tsm1_index=2 tsm1_file=/var/lib/influxdb/data/iobroker/global/286/000000047-000000001.tsm Dec 28 15:52:34 raspberrypi influxd[8371]: ts=2021-12-28T14:52:34.937592Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOIzzG000 op_name=tsm1_compact_group tsm1_index=3 tsm1_file=/var/lib/influxdb/data/iobroker/global/286/000000049-000000001.tsm Dec 28 15:52:34 raspberrypi influxd[8371]: ts=2021-12-28T14:52:34.937637Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOIzzG000 op_name=tsm1_compact_group tsm1_index=4 tsm1_file=/var/lib/influxdb/data/iobroker/global/286/000000051-000000001.tsm Dec 28 15:52:34 raspberrypi influxd[8371]: ts=2021-12-28T14:52:34.937681Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOIzzG000 op_name=tsm1_compact_group tsm1_index=5 tsm1_file=/var/lib/influxdb/data/iobroker/global/286/000000053-000000001.tsm Dec 28 15:52:34 raspberrypi influxd[8371]: ts=2021-12-28T14:52:34.937728Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOIzzG000 op_name=tsm1_compact_group tsm1_index=6 tsm1_file=/var/lib/influxdb/data/iobroker/global/286/000000055-000000001.tsm Dec 28 15:52:34 raspberrypi influxd[8371]: ts=2021-12-28T14:52:34.937597Z lvl=info msg="TSM compaction (end)" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOIw3l000 op_name=tsm1_compact_group op_event=end op_elapsed=1002.293ms Dec 28 15:52:34 raspberrypi influxd[8371]: ts=2021-12-28T14:52:34.937771Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOIzzG000 op_name=tsm1_compact_group tsm1_index=7 tsm1_file=/var/lib/influxdb/data/iobroker/global/286/000000056-000000001.tsm Dec 28 15:52:34 raspberrypi influxd[8371]: ts=2021-12-28T14:52:34.938043Z lvl=info msg="Aborted compaction" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOIzzG000 op_name=tsm1_compact_group error="compaction in progress: open /var/lib/influxdb/data/iobroker/global/286/000000056-000000002.tsm.tmp: file exists" Dec 28 15:52:34 raspberrypi influxd[8371]: ts=2021-12-28T14:52:34.938318Z lvl=info msg="TSM compaction (start)" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOIzzW000 op_name=tsm1_compact_group op_event=start Dec 28 15:52:34 raspberrypi influxd[8371]: ts=2021-12-28T14:52:34.938384Z lvl=info msg="Beginning compaction" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOIzzW000 op_name=tsm1_compact_group tsm1_files_n=4 Dec 28 15:52:34 raspberrypi influxd[8371]: ts=2021-12-28T14:52:34.938429Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOIzzW000 op_name=tsm1_compact_group tsm1_index=0 tsm1_file=/var/lib/influxdb/data/iobroker/global/326/000000038-000000002.tsm Dec 28 15:52:34 raspberrypi influxd[8371]: ts=2021-12-28T14:52:34.938474Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOIzzW000 op_name=tsm1_compact_group tsm1_index=1 tsm1_file=/var/lib/influxdb/data/iobroker/global/326/000000054-000000002.tsm Dec 28 15:52:34 raspberrypi influxd[8371]: ts=2021-12-28T14:52:34.938518Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOIzzW000 op_name=tsm1_compact_group tsm1_index=2 tsm1_file=/var/lib/influxdb/data/iobroker/global/326/000000056-000000001.tsm Dec 28 15:52:34 raspberrypi influxd[8371]: ts=2021-12-28T14:52:34.938562Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOIzzW000 op_name=tsm1_compact_group tsm1_index=3 tsm1_file=/var/lib/influxdb/data/iobroker/global/326/000000058-000000001.tsm Dec 28 15:52:34 raspberrypi influxd[8371]: ts=2021-12-28T14:52:34.938731Z lvl=info msg="Aborted compaction" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOIzzW000 op_name=tsm1_compact_group error="compaction in progress: open /var/lib/influxdb/data/iobroker/global/326/000000058-000000002.tsm.tmp: file exists" Dec 28 15:52:35 raspberrypi influxd[8371]: ts=2021-12-28T14:52:35.938248Z lvl=info msg="TSM compaction (end)" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOIzzG000 op_name=tsm1_compact_group op_event=end op_elapsed=1000.918ms Dec 28 15:52:35 raspberrypi influxd[8371]: ts=2021-12-28T14:52:35.938966Z lvl=info msg="TSM compaction (end)" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOIzzW000 op_name=tsm1_compact_group op_event=end op_elapsed=1000.673ms Dec 28 15:52:36 raspberrypi influxd[8371]: ts=2021-12-28T14:52:36.935305Z lvl=info msg="TSM compaction (start)" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOJ6ml001 op_name=tsm1_compact_group op_event=start Dec 28 15:52:36 raspberrypi influxd[8371]: ts=2021-12-28T14:52:36.935457Z lvl=info msg="Beginning compaction" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOJ6ml001 op_name=tsm1_compact_group tsm1_files_n=5 Dec 28 15:52:36 raspberrypi influxd[8371]: ts=2021-12-28T14:52:36.935515Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOJ6ml001 op_name=tsm1_compact_group tsm1_index=0 tsm1_file=/var/lib/influxdb/data/iobroker/global/334/000000041-000000003.tsm Dec 28 15:52:36 raspberrypi influxd[8371]: ts=2021-12-28T14:52:36.935605Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOJ6ml001 op_name=tsm1_compact_group tsm1_index=1 tsm1_file=/var/lib/influxdb/data/iobroker/global/334/000000074-000000003.tsm Dec 28 15:52:36 raspberrypi influxd[8371]: ts=2021-12-28T14:52:36.935662Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOJ6ml001 op_name=tsm1_compact_group tsm1_index=2 tsm1_file=/var/lib/influxdb/data/iobroker/global/334/000000107-000000003.tsm Dec 28 15:52:36 raspberrypi influxd[8371]: ts=2021-12-28T14:52:36.935293Z lvl=info msg="TSM compaction (start)" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOJ6ml000 op_name=tsm1_compact_group op_event=start Dec 28 15:52:36 raspberrypi influxd[8371]: ts=2021-12-28T14:52:36.935713Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOJ6ml001 op_name=tsm1_compact_group tsm1_index=3 tsm1_file=/var/lib/influxdb/data/iobroker/global/334/000000115-000000002.tsm Dec 28 15:52:36 raspberrypi influxd[8371]: ts=2021-12-28T14:52:36.935768Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOJ6ml001 op_name=tsm1_compact_group tsm1_index=4 tsm1_file=/var/lib/influxdb/data/iobroker/global/334/000000126-000000002.tsm Dec 28 15:52:36 raspberrypi influxd[8371]: ts=2021-12-28T14:52:36.935755Z lvl=info msg="Beginning compaction" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOJ6ml000 op_name=tsm1_compact_group tsm1_files_n=5 Dec 28 15:52:36 raspberrypi influxd[8371]: ts=2021-12-28T14:52:36.935844Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOJ6ml000 op_name=tsm1_compact_group tsm1_index=0 tsm1_file=/var/lib/influxdb/data/iobroker/global/270/000000030-000000002.tsm Dec 28 15:52:36 raspberrypi influxd[8371]: ts=2021-12-28T14:52:36.935902Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOJ6ml000 op_name=tsm1_compact_group tsm1_index=1 tsm1_file=/var/lib/influxdb/data/iobroker/global/270/000000042-000000002.tsm Dec 28 15:52:36 raspberrypi influxd[8371]: ts=2021-12-28T14:52:36.935958Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOJ6ml000 op_name=tsm1_compact_group tsm1_index=2 tsm1_file=/var/lib/influxdb/data/iobroker/global/270/000000044-000000001.tsm Dec 28 15:52:36 raspberrypi influxd[8371]: ts=2021-12-28T14:52:36.936011Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOJ6ml000 op_name=tsm1_compact_group tsm1_index=3 tsm1_file=/var/lib/influxdb/data/iobroker/global/270/000000046-000000001.tsm Dec 28 15:52:36 raspberrypi influxd[8371]: ts=2021-12-28T14:52:36.936103Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOJ6ml000 op_name=tsm1_compact_group tsm1_index=4 tsm1_file=/var/lib/influxdb/data/iobroker/global/270/000000048-000000001.tsm Dec 28 15:52:36 raspberrypi influxd[8371]: ts=2021-12-28T14:52:36.935985Z lvl=info msg="Aborted compaction" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOJ6ml001 op_name=tsm1_compact_group error="compaction in progress: open /var/lib/influxdb/data/iobroker/global/334/000000126-000000003.tsm.tmp: file exists" Dec 28 15:52:36 raspberrypi influxd[8371]: ts=2021-12-28T14:52:36.936326Z lvl=info msg="Aborted compaction" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOJ6ml000 op_name=tsm1_compact_group error="compaction in progress: open /var/lib/influxdb/data/iobroker/global/270/000000048-000000002.tsm.tmp: file exists" Dec 28 15:52:37 raspberrypi influxd[8371]: ts=2021-12-28T14:52:37.936313Z lvl=info msg="TSM compaction (end)" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOJ6ml001 op_name=tsm1_compact_group op_event=end op_elapsed=1001.024ms Dec 28 15:52:37 raspberrypi influxd[8371]: ts=2021-12-28T14:52:37.936494Z lvl=info msg="TSM compaction (end)" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOJ6ml000 op_name=tsm1_compact_group op_event=end op_elapsed=1001.220ms Dec 28 15:52:37 raspberrypi influxd[8371]: ts=2021-12-28T14:52:37.937180Z lvl=info msg="TSM compaction (start)" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOJAhG000 op_name=tsm1_compact_group op_event=start Dec 28 15:52:37 raspberrypi influxd[8371]: ts=2021-12-28T14:52:37.937218Z lvl=info msg="Beginning compaction" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOJAhG000 op_name=tsm1_compact_group tsm1_files_n=8 Dec 28 15:52:37 raspberrypi influxd[8371]: ts=2021-12-28T14:52:37.937240Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOJAhG000 op_name=tsm1_compact_group tsm1_index=0 tsm1_file=/var/lib/influxdb/data/iobroker/global/286/000000032-000000002.tsm Dec 28 15:52:37 raspberrypi influxd[8371]: ts=2021-12-28T14:52:37.937262Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOJAhG000 op_name=tsm1_compact_group tsm1_index=1 tsm1_file=/var/lib/influxdb/data/iobroker/global/286/000000046-000000002.tsm Dec 28 15:52:37 raspberrypi influxd[8371]: ts=2021-12-28T14:52:37.937283Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOJAhG000 op_name=tsm1_compact_group tsm1_index=2 tsm1_file=/var/lib/influxdb/data/iobroker/global/286/000000047-000000001.tsm Dec 28 15:52:37 raspberrypi influxd[8371]: ts=2021-12-28T14:52:37.937304Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOJAhG000 op_name=tsm1_compact_group tsm1_index=3 tsm1_file=/var/lib/influxdb/data/iobroker/global/286/000000049-000000001.tsm Dec 28 15:52:37 raspberrypi influxd[8371]: ts=2021-12-28T14:52:37.937381Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOJAhG000 op_name=tsm1_compact_group tsm1_index=4 tsm1_file=/var/lib/influxdb/data/iobroker/global/286/000000051-000000001.tsm Dec 28 15:52:37 raspberrypi influxd[8371]: ts=2021-12-28T14:52:37.937406Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOJAhG000 op_name=tsm1_compact_group tsm1_index=5 tsm1_file=/var/lib/influxdb/data/iobroker/global/286/000000053-000000001.tsm Dec 28 15:52:37 raspberrypi influxd[8371]: ts=2021-12-28T14:52:37.937428Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOJAhG000 op_name=tsm1_compact_group tsm1_index=6 tsm1_file=/var/lib/influxdb/data/iobroker/global/286/000000055-000000001.tsm Dec 28 15:52:37 raspberrypi influxd[8371]: ts=2021-12-28T14:52:37.937448Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOJAhG000 op_name=tsm1_compact_group tsm1_index=7 tsm1_file=/var/lib/influxdb/data/iobroker/global/286/000000056-000000001.tsm Dec 28 15:52:37 raspberrypi influxd[8371]: ts=2021-12-28T14:52:37.937581Z lvl=info msg="Aborted compaction" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOJAhG000 op_name=tsm1_compact_group error="compaction in progress: open /var/lib/influxdb/data/iobroker/global/286/000000056-000000002.tsm.tmp: file exists" Dec 28 15:52:37 raspberrypi influxd[8371]: ts=2021-12-28T14:52:37.937297Z lvl=info msg="TSM compaction (start)" log_id=0YgR3JW0000 engine=tsm1 tsm1_level=2 tsm1_strategy=level trace_id=0YhOJAhG001 op_name=tsm1_compact_group op_event=start Dec 28 15:52:37 raspberrypi influxd[8371]: ts=2021-12-28T14:52:37.937642Z lvl=info msg="Beginning compaction" log_id=0YgR3JW0000 engine=tsm1 tsm1_level=2 tsm1_strategy=level trace_id=0YhOJAhG001 op_name=tsm1_compact_group tsm1_files_n=4 Dec 28 15:52:37 raspberrypi influxd[8371]: ts=2021-12-28T14:52:37.937662Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_level=2 tsm1_strategy=level trace_id=0YhOJAhG001 op_name=tsm1_compact_group tsm1_index=0 tsm1_file=/var/lib/influxdb/data/iobroker/global/278/000000027-000000002.tsm Dec 28 15:52:37 raspberrypi influxd[8371]: ts=2021-12-28T14:52:37.937683Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_level=2 tsm1_strategy=level trace_id=0YhOJAhG001 op_name=tsm1_compact_group tsm1_index=1 tsm1_file=/var/lib/influxdb/data/iobroker/global/278/000000040-000000002.tsm Dec 28 15:52:37 raspberrypi influxd[8371]: ts=2021-12-28T14:52:37.937705Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_level=2 tsm1_strategy=level trace_id=0YhOJAhG001 op_name=tsm1_compact_group tsm1_index=2 tsm1_file=/var/lib/influxdb/data/iobroker/global/278/000000052-000000002.tsm Dec 28 15:52:37 raspberrypi influxd[8371]: ts=2021-12-28T14:52:37.937725Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_level=2 tsm1_strategy=level trace_id=0YhOJAhG001 op_name=tsm1_compact_group tsm1_index=3 tsm1_file=/var/lib/influxdb/data/iobroker/global/278/000000068-000000002.tsm Dec 28 15:52:37 raspberrypi influxd[8371]: ts=2021-12-28T14:52:37.937804Z lvl=info msg="Aborted compaction" log_id=0YgR3JW0000 engine=tsm1 tsm1_level=2 tsm1_strategy=level trace_id=0YhOJAhG001 op_name=tsm1_compact_group error="compaction in progress: open /var/lib/influxdb/data/iobroker/global/278/000000068-000000003.tsm.tmp: file exists" Dec 28 15:52:38 raspberrypi influxd[8371]: ts=2021-12-28T14:52:38.937726Z lvl=info msg="TSM compaction (end)" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOJAhG000 op_name=tsm1_compact_group op_event=end op_elapsed=1000.548ms Dec 28 15:52:38 raspberrypi influxd[8371]: ts=2021-12-28T14:52:38.937946Z lvl=info msg="TSM compaction (end)" log_id=0YgR3JW0000 engine=tsm1 tsm1_level=2 tsm1_strategy=level trace_id=0YhOJAhG001 op_name=tsm1_compact_group op_event=end op_elapsed=1000.654ms Dec 28 15:52:39 raspberrypi influxd[8371]: ts=2021-12-28T14:52:39.137048Z lvl=info msg="Executing query" log_id=0YgR3JW0000 service=query query="SELECT max(value) FROM iobroker.global.\"mihome.0.devices.weather_v1_158d00023213f6.temperature\" WHERE time >= now() - 1d AND time <= now() GROUP BY time(2m) fill(previous)" Dec 28 15:52:39 raspberrypi influxd[8371]: ts=2021-12-28T14:52:39.144395Z lvl=info msg="Executing query" log_id=0YgR3JW0000 service=query query="SELECT max(value) FROM iobroker.global.\"fhem.0.Temp_Heizkessel.temperature\" WHERE time >= now() - 1d AND time <= now() GROUP BY time(2m) fill(previous)" Dec 28 15:52:39 raspberrypi influxd[8371]: ts=2021-12-28T14:52:39.149831Z lvl=info msg="Executing query" log_id=0YgR3JW0000 service=query query="SELECT max(value) FROM iobroker.global.\"hm-rpc.0.OEQ0673599.2.TEMPERATURE\" WHERE time >= now() - 1d AND time <= now() GROUP BY time(2m) fill(previous)" Dec 28 15:52:39 raspberrypi influxd[8371]: ts=2021-12-28T14:52:39.165812Z lvl=info msg="Executing query" log_id=0YgR3JW0000 service=query query="SELECT max(value) FROM iobroker.global.\"shelly.0.SHSW-PM#8CAAB542C16C#1.Relay0.Power\" WHERE time >= now() - 1d AND time <= now() GROUP BY time(2m) fill(previous)" Dec 28 15:52:39 raspberrypi influxd[8371]: [httpd] 192.168.178.94, 192.168.178.94,192.168.178.41 - admin [28/Dec/2021:15:52:39 +0100] "GET /query?db=iobroker&epoch=ms&q=SELECT+max%28%22value%22%29+FROM+%22mihome.0.devices.weather_v1_158d00023213f6.temperature%22+WHERE+time+%3E%3D+now%28%29+-+24h+and+time+%3C%3D+now%28%29+GROUP+BY+time%282m%29+fill%28previous%29%3BSELECT+max%28%22value%22%29+FROM+%22fhem.0.Temp_Heizkessel.temperature%22+WHERE+time+%3E%3D+now%28%29+-+24h+and+time+%3C%3D+now%28%29+GROUP+BY+time%282m%29+fill%28previous%29%3BSELECT+max%28%22value%22%29+FROM+%22hm-rpc.0.OEQ0673599.2.TEMPERATURE%22+WHERE+time+%3E%3D+now%28%29+-+24h+and+time+%3C%3D+now%28%29+GROUP+BY+time%282m%29+fill%28previous%29%3BSELECT+max%28%22value%22%29+FROM+%22shelly.0.SHSW-PM%238CAAB542C16C%231.Relay0.Power%22+WHERE+time+%3E%3D+now%28%29+-+24h+and+time+%3C%3D+now%28%29+GROUP+BY+time%282m%29+fill%28previous%29 HTTP/1.1" 200 8091 "-" "Grafana/8.0.6" cd53818a-67ed-11ec-873c-000000000000 75451 Dec 28 15:52:39 raspberrypi influxd[8371]: ts=2021-12-28T14:52:39.934793Z lvl=info msg="TSM compaction (start)" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOJIVW000 op_name=tsm1_compact_group op_event=start Dec 28 15:52:39 raspberrypi influxd[8371]: ts=2021-12-28T14:52:39.934844Z lvl=info msg="Beginning compaction" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOJIVW000 op_name=tsm1_compact_group tsm1_files_n=5 Dec 28 15:52:39 raspberrypi influxd[8371]: ts=2021-12-28T14:52:39.934867Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOJIVW000 op_name=tsm1_compact_group tsm1_index=0 tsm1_file=/var/lib/influxdb/data/iobroker/global/334/000000041-000000003.tsm Dec 28 15:52:39 raspberrypi influxd[8371]: ts=2021-12-28T14:52:39.934890Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOJIVW000 op_name=tsm1_compact_group tsm1_index=1 tsm1_file=/var/lib/influxdb/data/iobroker/global/334/000000074-000000003.tsm Dec 28 15:52:39 raspberrypi influxd[8371]: ts=2021-12-28T14:52:39.934912Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOJIVW000 op_name=tsm1_compact_group tsm1_index=2 tsm1_file=/var/lib/influxdb/data/iobroker/global/334/000000107-000000003.tsm Dec 28 15:52:39 raspberrypi influxd[8371]: ts=2021-12-28T14:52:39.934933Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOJIVW000 op_name=tsm1_compact_group tsm1_index=3 tsm1_file=/var/lib/influxdb/data/iobroker/global/334/000000115-000000002.tsm Dec 28 15:52:39 raspberrypi influxd[8371]: ts=2021-12-28T14:52:39.934953Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOJIVW000 op_name=tsm1_compact_group tsm1_index=4 tsm1_file=/var/lib/influxdb/data/iobroker/global/334/000000126-000000002.tsm Dec 28 15:52:39 raspberrypi influxd[8371]: ts=2021-12-28T14:52:39.935059Z lvl=info msg="Aborted compaction" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOJIVW000 op_name=tsm1_compact_group error="compaction in progress: open /var/lib/influxdb/data/iobroker/global/334/000000126-000000003.tsm.tmp: file exists" Dec 28 15:52:39 raspberrypi influxd[8371]: ts=2021-12-28T14:52:39.935132Z lvl=info msg="TSM compaction (start)" log_id=0YgR3JW0000 engine=tsm1 tsm1_level=2 tsm1_strategy=level trace_id=0YhOJIVl000 op_name=tsm1_compact_group op_event=start Dec 28 15:52:39 raspberrypi influxd[8371]: ts=2021-12-28T14:52:39.935176Z lvl=info msg="Beginning compaction" log_id=0YgR3JW0000 engine=tsm1 tsm1_level=2 tsm1_strategy=level trace_id=0YhOJIVl000 op_name=tsm1_compact_group tsm1_files_n=4 Dec 28 15:52:39 raspberrypi influxd[8371]: ts=2021-12-28T14:52:39.935197Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_level=2 tsm1_strategy=level trace_id=0YhOJIVl000 op_name=tsm1_compact_group tsm1_index=0 tsm1_file=/var/lib/influxdb/data/iobroker/global/318/000000043-000000002.tsm Dec 28 15:52:39 raspberrypi influxd[8371]: ts=2021-12-28T14:52:39.935219Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_level=2 tsm1_strategy=level trace_id=0YhOJIVl000 op_name=tsm1_compact_group tsm1_index=1 tsm1_file=/var/lib/influxdb/data/iobroker/global/318/000000058-000000002.tsm Dec 28 15:52:39 raspberrypi influxd[8371]: ts=2021-12-28T14:52:39.935240Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_level=2 tsm1_strategy=level trace_id=0YhOJIVl000 op_name=tsm1_compact_group tsm1_index=2 tsm1_file=/var/lib/influxdb/data/iobroker/global/318/000000074-000000002.tsm Dec 28 15:52:39 raspberrypi influxd[8371]: ts=2021-12-28T14:52:39.935261Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_level=2 tsm1_strategy=level trace_id=0YhOJIVl000 op_name=tsm1_compact_group tsm1_index=3 tsm1_file=/var/lib/influxdb/data/iobroker/global/318/000000090-000000002.tsm Dec 28 15:52:39 raspberrypi influxd[8371]: ts=2021-12-28T14:52:39.935355Z lvl=info msg="Aborted compaction" log_id=0YgR3JW0000 engine=tsm1 tsm1_level=2 tsm1_strategy=level trace_id=0YhOJIVl000 op_name=tsm1_compact_group error="compaction in progress: open /var/lib/influxdb/data/iobroker/global/318/000000090-000000003.tsm.tmp: file exists" Dec 28 15:52:40 raspberrypi influxd[8371]: ts=2021-12-28T14:52:40.086418Z lvl=info msg="Executing query" log_id=0YgR3JW0000 service=query query="SELECT max(value) FROM iobroker.global.\"mihome.0.devices.weather_v1_158d00023213f6.temperature\" WHERE time >= now() - 1d AND time <= now() GROUP BY time(2m) fill(previous)" Dec 28 15:52:40 raspberrypi influxd[8371]: ts=2021-12-28T14:52:40.090873Z lvl=info msg="Executing query" log_id=0YgR3JW0000 service=query query="SELECT max(value) FROM iobroker.global.\"hm-rpc.0.20200127_4.1.TEMPERATURE\" WHERE time >= now() - 1d AND time <= now() GROUP BY time(2m) fill(previous)" Dec 28 15:52:40 raspberrypi influxd[8371]: [httpd] 192.168.178.92, 192.168.178.92,192.168.178.41 - admin [28/Dec/2021:15:52:40 +0100] "GET /query?db=iobroker&epoch=ms&q=SELECT+max%28%22value%22%29+FROM+%22mihome.0.devices.weather_v1_158d00023213f6.temperature%22+WHERE+time+%3E%3D+now%28%29+-+24h+and+time+%3C%3D+now%28%29+GROUP+BY+time%282m%29+fill%28previous%29%3BSELECT+max%28%22value%22%29+FROM+%22hm-rpc.0.20200127_4.1.TEMPERATURE%22+WHERE+time+%3E%3D+now%28%29+-+24h+and+time+%3C%3D+now%28%29+GROUP+BY+time%282m%29+fill%28previous%29 HTTP/1.1" 200 4368 "-" "Grafana/8.0.6" cde48010-67ed-11ec-873d-000000000000 24218 Dec 28 15:52:40 raspberrypi influxd[8371]: ts=2021-12-28T14:52:40.935281Z lvl=info msg="TSM compaction (end)" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOJIVW000 op_name=tsm1_compact_group op_event=end op_elapsed=1000.490ms Dec 28 15:52:40 raspberrypi influxd[8371]: ts=2021-12-28T14:52:40.935555Z lvl=info msg="TSM compaction (end)" log_id=0YgR3JW0000 engine=tsm1 tsm1_level=2 tsm1_strategy=level trace_id=0YhOJIVl000 op_name=tsm1_compact_group op_event=end op_elapsed=1000.427ms Dec 28 15:52:40 raspberrypi influxd[8371]: ts=2021-12-28T14:52:40.937443Z lvl=info msg="TSM compaction (start)" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOJMQG000 op_name=tsm1_compact_group op_event=start Dec 28 15:52:40 raspberrypi influxd[8371]: ts=2021-12-28T14:52:40.937541Z lvl=info msg="Beginning compaction" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOJMQG000 op_name=tsm1_compact_group tsm1_files_n=8 Dec 28 15:52:40 raspberrypi influxd[8371]: ts=2021-12-28T14:52:40.937595Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOJMQG000 op_name=tsm1_compact_group tsm1_index=0 tsm1_file=/var/lib/influxdb/data/iobroker/global/286/000000032-000000002.tsm Dec 28 15:52:40 raspberrypi influxd[8371]: ts=2021-12-28T14:52:40.937650Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOJMQG000 op_name=tsm1_compact_group tsm1_index=1 tsm1_file=/var/lib/influxdb/data/iobroker/global/286/000000046-000000002.tsm Dec 28 15:52:40 raspberrypi influxd[8371]: ts=2021-12-28T14:52:40.937701Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOJMQG000 op_name=tsm1_compact_group tsm1_index=2 tsm1_file=/var/lib/influxdb/data/iobroker/global/286/000000047-000000001.tsm Dec 28 15:52:40 raspberrypi influxd[8371]: ts=2021-12-28T14:52:40.937753Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOJMQG000 op_name=tsm1_compact_group tsm1_index=3 tsm1_file=/var/lib/influxdb/data/iobroker/global/286/000000049-000000001.tsm Dec 28 15:52:40 raspberrypi influxd[8371]: ts=2021-12-28T14:52:40.937824Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOJMQG000 op_name=tsm1_compact_group tsm1_index=4 tsm1_file=/var/lib/influxdb/data/iobroker/global/286/000000051-000000001.tsm Dec 28 15:52:40 raspberrypi influxd[8371]: ts=2021-12-28T14:52:40.937828Z lvl=info msg="TSM compaction (start)" log_id=0YgR3JW0000 engine=tsm1 tsm1_level=2 tsm1_strategy=level trace_id=0YhOJMQG001 op_name=tsm1_compact_group op_event=start Dec 28 15:52:40 raspberrypi influxd[8371]: ts=2021-12-28T14:52:40.937878Z lvl=info msg="Compacting file" log_id=0YgR3JW0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0YhOJMQG000 op_name=tsm1_cMit freundlichen Grüßen
Michael -
influx use "Datenbank" show series Drop SERIES FROM "dein Datenpunkt"Was muss ich in der Konsole eingeben?
DB Name laut influx.0 =iobroker
Danke
MfG Michael -
@altersrentner sagte in Influx arbeitet nicht mehr stabil:
Ich bin immer noch händisch dabei
was machst du da?
@altersrentner sagte in Influx arbeitet nicht mehr stabil:
Was muss ich in der Konsole eingeben
hab ich dir doch als Beispiel oben gezeigt
https://forum.iobroker.net/post/495963du gehst mit putty auf deinen Rechner wo Influxdb läuft
dann startest du die CLI mit
influxdanach deine Datenbank auswählen, wenn diese
iobrokerheisst, ansonsten kannst du dir mitshow databasesalle datenbanken anzeigen lassenuse iobrokerdanach lässt du dir alle Serien anzeigen
show seriesdiejenigen, welche du löschen möchtest, musst do nun jeweils einzeln mittels DROP Befehl löschen, hier als Beispiel
Drop SERIES FROM "0.userdata.0.Eigen_Datenpunkte.Batterie.Status.BatterieBüro"anderfalls denke ich, geht es schneller, wie auch schon oben erwähnt, mit InfluxdbStudio für Windows
-
@crunchip
Influx läuft auf dem ioBroker Pipi@raspberrypi:~ $ influx -bash: influx: command not found pi@raspberrypi:~ $Deshalb händisch
-
@crunchip
Habe influxdbStudio für Win installiert.
Links im Baum ist die DB iobroker zu sehen und darunter Datenpunkte
Diese lassen sich aber nicht öffnen.
nur z.B.SELECT * FROM "0_userdata.0.XiaomiSensorStatus.XiaomiTemperaturStatus.BadezimmerTemp_Telegram_Sensorstatus" WHERE time > now() - 5mLöschen kann ich den Punkt auch nicht
MfG Michael -
@altersrentner seltsam
dann installier mal den client noch nachsudo apt install influxdb-clientdanach sollte es gehen
-
@altersrentner sagte in Influx arbeitet nicht mehr stabil:
Löschen kann ich den Punkt auch nicht
hab influxstudio gerade selbst schnell mal geladen, sollte eigentlich so gehen
Serie links anklicken und dann auf drop serie, siehe Pfeil
und wie gesagt, musst du für diese Datenpunkte das loggen in iobroker erst deativieren, sonst kommen die ja wieder
-
@crunchip sagte in Influx arbeitet nicht mehr stabil:
@altersrentner sagte in Influx arbeitet nicht mehr stabil:
Löschen kann ich den Punkt auch nicht
hab influxstudio gerade selbst schnell mal geladen, sollte eigentlich so gehen
Serie links anklicken und dann auf drop serie, siehe Pfeil
und wie gesagt, musst du für diese Datenpunkte das loggen in iobroker erst deativieren, sonst kommen die ja wieder
Verstehe ich das richtig,
wenn ich in der Datenbank unter Studio einen Punkt lösche,
muß dieser auch noch unter Objekte deaktiviert werden.
MfG Michael -
@altersrentner
Ja, sonst würde er das nächste mal in der Datenbank neu angelegt werden. -
@oliverio Da werde ich aber verrückt,
Die Studio ist so was von langsam, das geht überhaupt nicht.
Gibt es nicht eine schnellere Lösung? -
@altersrentner
Du könntest ein löschscript für influx in einem editor vorbereiten und dann in einem Rutsch ausführen lassen.Oder du könntest dir das Studio
Auf einem anderen schnelleren Rechner unter linux installieren und dich dann Remote mit der Datenbank verbinden.Das deaktivieren aller datenpunkte in Iobroker weiß ich nicht wie man das beschleunigen könnte.
Es kommt auch darauf an wieviele du hast und wieviele du davon aktiviert haben möchtest. -
@altersrentner sagte in Influx arbeitet nicht mehr stabil:
Gibt es nicht eine schnellere Lösung?
hatte ich dir ja schon genannt, da du unendlich viele Datenpunkte in die Influx schreibst, wäre es abzuwägen, die paar Daten die du eigentlich möchtest, zu verwerfen und von vorne zu starten,
heisst,
die Influx Instanz zu löschen, somit sind alle weg und du legst die Instanz neu an und aktivierst die Daten die du haben möchtest.
Desweiteren, wenn du alles sauber haben möchtest, löscht du ebenfalls die Datenbank selbst und lässt sie automatisch wieder anlegen, das erfolgt dann allerdings, bevor du eine neue Influxinstanz startest -
@oliverio
geht das nicht auch über Remotedesktop?
Mit dem Fhem PI komme ich da rauf.
Aber mit ioBroker PI nicht,
Kann man den aktivieren? -
@altersrentner sagte in Influx arbeitet nicht mehr stabil:
geht das nicht auch über Remotedesktop?
Der noch mehr Ressourcen braucht? Davon ab agiert man grundsätzlich nicht mit einem Desktop auf einem Server. Nicht lokal, nicht remote.
-
@crunchip
für mich zum Verständnis,- influc.0 löschen
- Datenbank löschen, wie DB löschen
- wieder neu anlegen, wie muss ich das machen
- influc.0 neu installieren
ist die Reihenfolge so OK
-
@altersrentner sagte in Influx arbeitet nicht mehr stabil:
zum Verständnis,
ich möchte dich zu nichts überreden, wie gesagt, es kommt darauf an, wie wichtig dir deinen bisherigen gesammelten Daten sind.
Wenn du sagst, ok, ich starte bei Null,
dann löscht du die Influx Instanz.Anschliessend löscht du die Datenbank in der Influx CLI.
Danach fügst du wieder eine InfluxDB Instanz hinzu, trägst deine Daten wieder ein und eine Neue Datenbank wird automatisch angelegt.
Danach kannst du dir deine Datenpunkte aussuchen und das loggen aktivieren.
Somit ersparst du dir das Stundenlange geklicke und gelösche.Das löschen der Datenbank, vorrausgesetzt du hast das erwähnte Paket (sudo apt install influxdb-client) nachinstalliert, damit du Influx aufrufen kannst
sofern deine Datenbank iobroker heisst, lautet der BefehlInflux DROP DATABASE iobroker -
@crunchip
ich habe momentan 15900 Punkte.
Wenn ich mich richtig erinnere brauche ich
die geloggten Daten nur für die Graphen -
@altersrentner sagte in Influx arbeitet nicht mehr stabil:
die geloggten Daten nur für die Graphen
die würden dann ebenfalls von neu beginnen
-
@crunchip
das wäre kein Problem.
Ich mache jetzt Schluss.
Melde mich morgen wieder.
Gute Nacht
Michael
