Influx arbeitet nicht mehr stabil

crunchip

@altersrentner sagte in Influx arbeitet nicht mehr stabil:

Muss jetzt erst mal weg.
Meine Chefin hat ein Problem.

der Klassiker:grin:

OliverIO

@altersrentner sagte in Influx arbeitet nicht mehr stabil:

Dec 22 07:34:34 raspberrypi influxd[31563]: ts=2021-12-22T06:34:34.960740Z lvl=info msg="Compacting file" log_id=0Y_Cnnp0000 engine=tsm1 tsm1_level=2 tsm1_strategy=level trace_id=0Y_DQdK0000 op_name=tsm1_compact_group tsm1_index=3 tsm1_file=/var/lib/influxdb/data/iobroker/global/294/000000078-000000002.tsm
Dec 22 07:34:34 raspberrypi influxd[31563]: ts=2021-12-22T06:34:34.960850Z lvl=info msg="Aborted compaction" log_id=0Y_Cnnp0000 engine=tsm1 tsm1_level=2 tsm1_strategy=level trace_id=0Y_DQdK0000 op_name=tsm1_compact_group error="compaction in progress: open /var/lib/influxdb/data/iobroker/global/294/000000078-000000003.tsm.tmp: file exists"

Ich beziehe mich mal auf die beiden Zeile oben aus dem syslog.
Das scheint hier das eigentliche Problem zu sein.

influxdb arbeitet ja primär im RAM und schreibt nur etwas zeitverzögert die Daten erst auf die Platte/SD/SSD.

Dabei scheint es ein Problem zu geben. Da der Fehler gestaffelt auftritt und weil da schon etwas existiert abgebrochen wird, scheint es sich hier ein OOM-loop (Out Of Memory) zu handeln.

dh. die Datenbank im Speicher läuft voll, möchte die Daten zusammenfassen und auf die Platte schreiben (compacting).
Da das zu lange dauert (SD-Karte?) oder der block ist zu groß (shard)

https://community.influxdata.com/t/aborted-compaction/12144/8

Erklärung und link zur dokumentation ist in diesem Beitrag
https://community.influxdata.com/t/aborted-compaction/12144/10

Evtl reicht auch einfach das RAM des Raspis nicht aus.
Zur Analyse ist ersteinmal nur syslog dein Freund.
In das log von iobroker musst du erstmal nicht schauen, da dort nur die symptome angezeigt werden, die das nicht funktionierende influx erzeugt.
Evtl solltest du mal alles auf dem Rechner beenden und dann nur influxdb starten, so das er seine Aufräumarbeiten (compacting) mal zu Ende bekommt.
Wenn das dann auch nicht funktioniert, dann ist wirklich das RAM am Ende.

Altersrentner

@oliverio Hallo,

Ich hatte noch gestern Abend so wie in Deinem Beitrag beschrieben,
alle Instanzen ausgeschaltet und nur Influx.0 auf grün belassen.
Nach einiger Zeit wurden dann alle Instanzen zugeschaltet.
Danach lief Influx.
Nach einiger Zeit habe ich über die Konsole
iob stop und iob start gemacht.

Bin mir aber nicht sicher ob die Reihenfolge 1/2 so OK war.

Auf alle Fälle habe ich viel zu viele geloggte Datenpunkte,
die ich jetzt händisch von influx befreie.
Mal sehen wie lange es jetzt gut geht.
Mit freundlichen Grüßen
Michael

crunchip

@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

Altersrentner

@crunchip
Ich bin immer noch händisch dabei:anguished:
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_c

Mit freundlichen Grüßen
Michael

Altersrentner

@crunchip

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

crunchip

@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/495963

du gehst mit putty auf deinen Rechner wo Influxdb läuft

dann startest du die CLI mit

influx

danach deine Datenbank auswählen, wenn diese iobroker heisst, ansonsten kannst du dir mit show databases alle datenbanken anzeigen lassen

use iobroker

danach lässt du dir alle Serien anzeigen

show series

diejenigen, 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

Altersrentner

@crunchip
Influx läuft auf dem ioBroker Pi

pi@raspberrypi:~ $ influx
-bash: influx: command not found
pi@raspberrypi:~ $

Deshalb händisch:angry: :anguished:

Altersrentner

@crunchip :blush: :blush: :blush: :+1:
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() - 5m

Löschen kann ich den Punkt auch nicht:anguished:
MfG Michael

crunchip

@altersrentner seltsam
dann installier mal den client noch nach

sudo apt install influxdb-client

danach sollte es gehen

crunchip

@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

Altersrentner

@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

OliverIO

@altersrentner
Ja, sonst würde er das nächste mal in der Datenbank neu angelegt werden.

Altersrentner

@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?

OliverIO

@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.

crunchip

@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

Altersrentner

@oliverio
geht das nicht auch über Remotedesktop?
Mit dem Fhem PI komme ich da rauf.
Aber mit ioBroker PI nicht,
Kann man den aktivieren?

Thomas Braun

@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.

Altersrentner

@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

crunchip

@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 Befehl

Influx
DROP DATABASE iobroker

Community Forum

NEWS

Influx arbeitet nicht mehr stabil

Support us

531

32.7k

82.5k

1.3m