Navigation

    Logo
    • Register
    • Login
    • Search
    • Recent
    • Tags
    • Unread
    • Categories
    • Unreplied
    • Popular
    • GitHub
    • Docu
    • Hilfe
    1. Home
    2. Deutsch
    3. Error/Bug
    4. Influx arbeitet nicht mehr stabil

    NEWS

    • Neuer Blog: Fotos und Eindrücke aus Solingen

    • ioBroker@Smart Living Forum Solingen, 14.06. - Agenda added

    • ioBroker goes Matter ... Matter Adapter in Stable

    Influx arbeitet nicht mehr stabil

    This topic has been deleted. Only users with topic management privileges can see it.
    • crunchip
      crunchip Forum Testing Most Active @Altersrentner last edited by

      @altersrentner keine Ahnung, das ist eigentlich das, was man bei der Installation als erstes einrichtet

      A 1 Reply Last reply Reply Quote 0
      • A
        Altersrentner @crunchip last edited by

        @crunchip
        So ist es gewesen
        Aber influx lauft immer noch nicht stabil
        Instanzen
        verbunden mit Host rot
        Lebenszeichen rot
        Verbunden mit gerät grün
        Vorher war es genau umgekehrt

        crunchip 1 Reply Last reply Reply Quote 0
        • crunchip
          crunchip Forum Testing Most Active @Altersrentner last edited by crunchip

          @altersrentner
          hast du den service neu gestartet?
          ruf nochmal den status ab, ob der auch sicher läuft
          zeige mal die Einstellungen der Instanz von Influx

          A 1 Reply Last reply Reply Quote 0
          • A
            Altersrentner @crunchip last edited by Altersrentner

            @crunchip sagte in Influx arbeitet nicht mehr stabil:

            @altersrentner
            hast du den service neu gestartet?
            ruf nochmal den status ab, ob der auch sicher läuft
            zeige mal die Einstellungen der Instanz von Influx

            pi@raspberrypi:~ $ systemctl status influxdb
● influxdb.service - InfluxDB is an open-source, distributed, time series database
   Loaded: loaded (/lib/systemd/system/influxdb.service; enabled; vendor preset: enabled)
   Active: active (running) since Mon 2021-12-27 19:50:12 CET; 1min 12s ago
     Docs: man:influxd(1)
 Main PID: 8691 (influxd)
    Tasks: 15 (limit: 4915)
   CGroup: /system.slice/influxdb.service
           └─8691 /usr/bin/influxd -config /etc/influxdb/influxdb.conf

Dec 27 19:51:23 raspberrypi influxd[8691]: [httpd] 192.168.178.41 - admin [27/Dec/2021:19:51:23 +0100] "POST /write?database=
Dec 27 19:51:23 raspberrypi influxd[8691]: [httpd] 192.168.178.41 - admin [27/Dec/2021:19:51:23 +0100] "POST /write?database=
Dec 27 19:51:23 raspberrypi influxd[8691]: [httpd] 192.168.178.41 - admin [27/Dec/2021:19:51:23 +0100] "POST /write?database=
Dec 27 19:51:23 raspberrypi influxd[8691]: [httpd] 192.168.178.41 - admin [27/Dec/2021:19:51:23 +0100] "POST /write?database=
Dec 27 19:51:23 raspberrypi influxd[8691]: [httpd] 192.168.178.41 - admin [27/Dec/2021:19:51:23 +0100] "POST /write?database=
Dec 27 19:51:24 raspberrypi influxd[8691]: [httpd] 192.168.178.41 - admin [27/Dec/2021:19:51:23 +0100] "POST /write?database=
Dec 27 19:51:24 raspberrypi influxd[8691]: [httpd] 192.168.178.41 - admin [27/Dec/2021:19:51:24 +0100] "POST /write?database=
Dec 27 19:51:24 raspberrypi influxd[8691]: [httpd] 192.168.178.41 - admin [27/Dec/2021:19:51:24 +0100] "POST /write?database=
Dec 27 19:51:24 raspberrypi influxd[8691]: [httpd] 192.168.178.41 - admin [27/Dec/2021:19:51:24 +0100] "POST /write?database=
Dec 27 19:51:24 raspberrypi influxd[8691]: [httpd] 192.168.178.41 - admin [27/Dec/2021:19:51:24 +0100] "POST /write?database=
lines 1-19/19 (END)

            Service wurde vorher gestartet
            Muss jetzt erst mal weg.
            Meine Chefin hat ein Problem.
            Danke, Melde mich wieder
            Mit freundlichen Grüßen
            Michael

            crunchip 1 Reply Last reply Reply Quote 0
            • crunchip
              crunchip Forum Testing Most Active @Altersrentner last edited by

              @altersrentner sagte in Influx arbeitet nicht mehr stabil:

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

              der Klassiker😁

              1 Reply Last reply Reply Quote 0
              • OliverIO
                OliverIO @Altersrentner last edited by 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.

                A 1 Reply Last reply Reply Quote 0
                • A
                  Altersrentner @OliverIO last edited by

                  @oliverio Hallo,

                  1. 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.
                  2. 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 1 Reply Last reply Reply Quote 0
                  • crunchip
                    crunchip Forum Testing Most Active @Altersrentner last edited by

                    @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

                    A 2 Replies Last reply Reply Quote 0
                    • A
                      Altersrentner @crunchip last edited by

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

                      Mit freundlichen Grüßen
                      Michael

                      crunchip 1 Reply Last reply Reply Quote 0
                      • A
                        Altersrentner @crunchip last edited by

                        @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

                        1 Reply Last reply Reply Quote 0
                        • crunchip
                          crunchip Forum Testing Most Active @Altersrentner last edited by 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

                          A 2 Replies Last reply Reply Quote 0
                          • A
                            Altersrentner @crunchip last edited by

                            @crunchip
                            Influx läuft auf dem ioBroker Pi

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

                            Deshalb händisch😠 😧

                            crunchip 1 Reply Last reply Reply Quote 0
                            • A
                              Altersrentner @crunchip last edited by

                              @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() - 5m

                              Löschen kann ich den Punkt auch nicht😧
                              MfG Michael

                              crunchip 1 Reply Last reply Reply Quote 0
                              • crunchip
                                crunchip Forum Testing Most Active @Altersrentner last edited by

                                @altersrentner seltsam
                                dann installier mal den client noch nach

                                sudo apt install influxdb-client

                                danach sollte es gehen

                                1 Reply Last reply Reply Quote 0
                                • crunchip
                                  crunchip Forum Testing Most Active @Altersrentner last edited by 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
                                  53db0450-0a2c-4618-a6bd-2b1cdbb169f1-grafik.png

                                  und wie gesagt, musst du für diese Datenpunkte das loggen in iobroker erst deativieren, sonst kommen die ja wieder

                                  A 1 Reply Last reply Reply Quote 0
                                  • A
                                    Altersrentner @crunchip last edited by

                                    @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
                                    53db0450-0a2c-4618-a6bd-2b1cdbb169f1-grafik.png

                                    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 1 Reply Last reply Reply Quote 0
                                    • OliverIO
                                      OliverIO @Altersrentner last edited by

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

                                      A 1 Reply Last reply Reply Quote 0
                                      • A
                                        Altersrentner @OliverIO last edited by

                                        @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 crunchip 2 Replies Last reply Reply Quote 0
                                        • OliverIO
                                          OliverIO @Altersrentner last edited by

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

                                          A 1 Reply Last reply Reply Quote 0
                                          • crunchip
                                            crunchip Forum Testing Most Active @Altersrentner last edited by

                                            @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

                                            A 1 Reply Last reply Reply Quote 0
                                            • First post
                                              Last post

                                            Support us

                                            ioBroker
                                            Community Adapters
                                            Donate

                                            678
                                            Online

                                            31.9k
                                            Users

                                            80.1k
                                            Topics

                                            1.3m
                                            Posts

                                            influx grafana vis
                                            9
                                            214
                                            15299
                                            Loading More Posts
                                            • Oldest to Newest
                                            • Newest to Oldest
                                            • Most Votes
                                            Reply
                                            • Reply as topic
                                            Log in to reply
                                            Community
                                            Impressum | Datenschutz-Bestimmungen | Nutzungsbedingungen
                                            The ioBroker Community 2014-2023
                                            logo