NEWS

@schneire sagte in Influxdb 2.7. Operator-token gelöscht - restore aus image?:

Ich denke so ist es korrekt oder?

Ja, das passt so und funktioniert bei mir auch. Du könntest noch versuchen, die Leerzeichen in der Query rauszunehmen:

influx query 'from(bucket:"iobroker")|>range(start:-1m)' --raw > test.csv

@ralf-topas
Die anderen Abfragen brachten das Ergebnis:

pi@IOB:/etc/apt/trusted.gpg.d $ ls -la /etc/apt//sources.list.d/ total 24 drwxr-xr-x 2 root root 4096 May 29 21:42 . drwxr-xr-x 9 root root 4096 May 29 21:42 .. -rw-r--r-- 1 root root 53 May 29 21:42 grafana.list -rw-r--r-- 1 root root 56 May 29 21:28 influxdb.list -rw-r--r-- 1 root root 100 May 29 19:02 nodesource.list -rw-r--r-- 1 root root 191 Mar 15 16:00 raspi.list pi@IOB:/etc/apt/trusted.gpg.d $ ls -la /etc/apt/trusted.gpg.d/ total 96 drwxr-xr-x 2 root root 4096 May 29 21:42 . drwxr-xr-x 9 root root 4096 May 29 21:42 .. -rw-r--r-- 1 root root 11861 Jul 30 2023 debian-archive-bookworm-automatic.asc -rw-r--r-- 1 root root 11873 Jul 30 2023 debian-archive-bookworm-security-automatic.asc -rw-r--r-- 1 root root 461 Jul 30 2023 debian-archive-bookworm-stable.asc -rw-r--r-- 1 root root 11861 Jul 30 2023 debian-archive-bullseye-automatic.asc -rw-r--r-- 1 root root 11873 Jul 30 2023 debian-archive-bullseye-security-automatic.asc -rw-r--r-- 1 root root 3403 Jul 30 2023 debian-archive-bullseye-stable.asc -rw-r--r-- 1 root root 11093 Jul 30 2023 debian-archive-buster-automatic.asc -rw-r--r-- 1 root root 11105 Jul 30 2023 debian-archive-buster-security-automatic.asc -rw-r--r-- 1 root root 1704 Jul 30 2023 debian-archive-buster-stable.asc -rw-r--r-- 1 root root 1183 Mar 15 16:00 raspberrypi-archive-stable.gpg

@jojo58 gibt es erst mit influxDB2

@chriswitt
Hi, ich hatte auch nur Posts gesehen, in denen der Button noch vorhanden war. Bei mir dann leider nicht.
Ich mache es folgendermaßen:
(Alles im Teminalprogramm, bei mir auf einem Mac. Ob das die Beste Lösung ist, weiß ich nicht aber es funktioniert bei mir )
Ich erstelle eine .flux-Datei:

from(bucket: "bucket-Name")
|> range(start: -2y)
|> filter(fn: (r) => r["_measurement"] == "Datensatzname")
|> filter(fn: (r) => r["_field"] == "value")

Im Flux kann man den Zeitbereich natürlich auch verändern ...

Dann Query erstellen :
sudo influx query --file Fluxdatei.flux --raw >Datensatz.csv

Ich schiebe die Datei ( die liegt ja bei mir auf dem Linux-Server) zum Mac. Da bearbeite ich die Datei mit
"Easy CSV Editor" ( der funktioniert, kostet glaube ich etwas )

Die geänderte Datei kommt wieder zum Linux-Server, und mit :

sudo influx write -b bucket-Name -f /Dateispeicherort/Datensatz.csv

schreibe ich die Daten wieder in die Datenbank, bei Bedarf in ein anderes Bucket, oder anderes Datenfeld.

Mag etwas umständlich aussehen, funktioniert für mich aber sehr gut.

@meister-mopper
😂 😂 😂
lustig, aber bringt mich nicht so richtig weiter 🙂

Hallo zusammen,

hat keiner eine Idee, wie ich nach dem influxd upgrade die Autorisierung hinbekommen kann, umso die Daten in meinem V2 Bucket integriert zu bekommen?

$ sudo service influxdb stop $ sudo influxd --vault-token '*************' 2024-07-12T10:17:48.285671Z info Welcome to InfluxDB {"log_id": "0qLc1H~G000", "version": "v2.7.6", "commit": "3c58c06206", "build_date": "2024-04-12T21:51:37Z", "log_level": "info"} 2024-07-12T10:17:48.287866Z info Resources opened {"log_id": "0qLc1H~G000", "service": "bolt", "path": "/root/.influxdbv2/influxd.bolt"} 2024-07-12T10:17:48.287956Z info Resources opened {"log_id": "0qLc1H~G000", "service": "sqlite", "path": "/root/.influxdbv2/influxd.sqlite"} 2024-07-12T10:17:48.293238Z info Checking InfluxDB metadata for prior version. {"log_id": "0qLc1H~G000", "bolt_path": "/root/.influxdbv2/influxd.bolt"} 2024-07-12T10:17:48.293435Z info Using data dir {"log_id": "0qLc1H~G000", "service": "storage-engine", "service": "store", "path": "/root/.influxdbv2/engine/data"} 2024-07-12T10:17:48.293498Z info Compaction settings {"log_id": "0qLc1H~G000", "service": "storage-engine", "service": "store", "max_concurrent_compactions": 2, "throughput_bytes_per_second": 50331648, "throughput_bytes_per_second_burst": 50331648} 2024-07-12T10:17:48.293523Z info Open store (start) {"log_id": "0qLc1H~G000", "service": "storage-engine", "service": "store", "op_name": "tsdb_open", "op_event": "start"} 2024-07-12T10:17:48.309555Z info index opened with 8 partitions {"log_id": "0qLc1H~G000", "service": "storage-engine", "index": "tsi"} 2024-07-12T10:17:48.310462Z info loading changes (start) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "start"} 2024-07-12T10:17:48.312341Z info loading changes (end) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "end", "op_elapsed": "1.895ms"} 2024-07-12T10:17:48.314305Z info index opened with 8 partitions {"log_id": "0qLc1H~G000", "service": "storage-engine", "index": "tsi"} 2024-07-12T10:17:48.312238Z info index opened with 8 partitions {"log_id": "0qLc1H~G000", "service": "storage-engine", "index": "tsi"} 2024-07-12T10:17:48.317256Z info Opened file {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "service": "filestore", "path": "/root/.influxdbv2/engine/data/3ac90a92e6f5fd74/autogen/12/000000097-000000002.tsm", "id": 0, "duration": "0.094ms"} 2024-07-12T10:17:48.317374Z info Opened shard {"log_id": "0qLc1H~G000", "service": "storage-engine", "service": "store", "op_name": "tsdb_open", "index_version": "tsi1", "path": "/root/.influxdbv2/engine/data/3ac90a92e6f5fd74/autogen/12", "duration": "22.409ms"} 2024-07-12T10:17:48.317627Z info loading changes (start) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "start"} 2024-07-12T10:17:48.317735Z info loading changes (start) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "start"} 2024-07-12T10:17:48.315290Z info index opened with 8 partitions {"log_id": "0qLc1H~G000", "service": "storage-engine", "index": "tsi"} 2024-07-12T10:17:48.341512Z info loading changes (end) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "end", "op_elapsed": "23.775ms"} 2024-07-12T10:17:48.341787Z info loading changes (end) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "end", "op_elapsed": "24.160ms"} 2024-07-12T10:17:48.341968Z info Opened file {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "service": "filestore", "path": "/root/.influxdbv2/engine/data/3ac90a92e6f5fd74/autogen/14/000000130-000000002.tsm", "id": 0, "duration": "0.111ms"} 2024-07-12T10:17:48.342004Z info Opened file {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "service": "filestore", "path": "/root/.influxdbv2/engine/data/3ac90a92e6f5fd74/autogen/13/000000112-000000002.tsm", "id": 0, "duration": "0.091ms"} 2024-07-12T10:17:48.342038Z info Opened shard {"log_id": "0qLc1H~G000", "service": "storage-engine", "service": "store", "op_name": "tsdb_open", "index_version": "tsi1", "path": "/root/.influxdbv2/engine/data/3ac90a92e6f5fd74/autogen/14", "duration": "46.959ms"} 2024-07-12T10:17:48.342095Z info Opened shard {"log_id": "0qLc1H~G000", "service": "storage-engine", "service": "store", "op_name": "tsdb_open", "index_version": "tsi1", "path": "/root/.influxdbv2/engine/data/3ac90a92e6f5fd74/autogen/13", "duration": "46.515ms"} 2024-07-12T10:17:48.342302Z info loading changes (start) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "start"} 2024-07-12T10:17:48.342332Z info loading changes (end) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "end", "op_elapsed": "0.042ms"} 2024-07-12T10:17:48.342562Z info Opened file {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "service": "filestore", "path": "/root/.influxdbv2/engine/data/3ac90a92e6f5fd74/autogen/10/000000127-000000002.tsm", "id": 0, "duration": "0.106ms"} 2024-07-12T10:17:48.342613Z info Opened shard {"log_id": "0qLc1H~G000", "service": "storage-engine", "service": "store", "op_name": "tsdb_open", "index_version": "tsi1", "path": "/root/.influxdbv2/engine/data/3ac90a92e6f5fd74/autogen/10", "duration": "46.228ms"} 2024-07-12T10:17:48.362077Z info index opened with 8 partitions {"log_id": "0qLc1H~G000", "service": "storage-engine", "index": "tsi"} 2024-07-12T10:17:48.362996Z info index opened with 8 partitions {"log_id": "0qLc1H~G000", "service": "storage-engine", "index": "tsi"} 2024-07-12T10:17:48.364344Z info loading changes (start) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "start"} 2024-07-12T10:17:48.364878Z info loading changes (end) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "end", "op_elapsed": "0.535ms"} 2024-07-12T10:17:48.363221Z info loading changes (start) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "start"} 2024-07-12T10:17:48.365427Z info loading changes (end) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "end", "op_elapsed": "2.212ms"} 2024-07-12T10:17:48.365440Z info Opened file {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "service": "filestore", "path": "/root/.influxdbv2/engine/data/3ac90a92e6f5fd74/autogen/15/000000146-000000002.tsm", "id": 0, "duration": "0.198ms"} 2024-07-12T10:17:48.365978Z info Opened shard {"log_id": "0qLc1H~G000", "service": "storage-engine", "service": "store", "op_name": "tsdb_open", "index_version": "tsi1", "path": "/root/.influxdbv2/engine/data/3ac90a92e6f5fd74/autogen/15", "duration": "23.917ms"} 2024-07-12T10:17:48.370433Z info Opened file {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "service": "filestore", "path": "/root/.influxdbv2/engine/data/3ac90a92e6f5fd74/autogen/16/000000197-000000002.tsm", "id": 0, "duration": "4.819ms"} 2024-07-12T10:17:48.370776Z info Opened shard {"log_id": "0qLc1H~G000", "service": "storage-engine", "service": "store", "op_name": "tsdb_open", "index_version": "tsi1", "path": "/root/.influxdbv2/engine/data/3ac90a92e6f5fd74/autogen/16", "duration": "28.667ms"} 2024-07-12T10:17:48.371681Z info index opened with 8 partitions {"log_id": "0qLc1H~G000", "service": "storage-engine", "index": "tsi"} 2024-07-12T10:17:48.373237Z info loading changes (start) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "start"} 2024-07-12T10:17:48.374412Z info loading changes (end) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "end", "op_elapsed": "1.196ms"} 2024-07-12T10:17:48.376826Z info Opened file {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "service": "filestore", "path": "/root/.influxdbv2/engine/data/3addfb11b06f756e/autogen/97/000000006-000000002.tsm", "id": 0, "duration": "0.423ms"} 2024-07-12T10:17:48.380835Z info Opened shard {"log_id": "0qLc1H~G000", "service": "storage-engine", "service": "store", "op_name": "tsdb_open", "index_version": "tsi1", "path": "/root/.influxdbv2/engine/data/3addfb11b06f756e/autogen/97", "duration": "63.424ms"} 2024-07-12T10:17:48.378033Z info index opened with 8 partitions {"log_id": "0qLc1H~G000", "service": "storage-engine", "index": "tsi"} 2024-07-12T10:17:48.383327Z info loading changes (start) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "start"} 2024-07-12T10:17:48.383413Z info loading changes (end) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "end", "op_elapsed": "0.090ms"} 2024-07-12T10:17:48.383660Z info Opened file {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "service": "filestore", "path": "/root/.influxdbv2/engine/data/3ac90a92e6f5fd74/autogen/17/000000098-000000002.tsm", "id": 0, "duration": "0.101ms"} 2024-07-12T10:17:48.383920Z info Opened shard {"log_id": "0qLc1H~G000", "service": "storage-engine", "service": "store", "op_name": "tsdb_open", "index_version": "tsi1", "path": "/root/.influxdbv2/engine/data/3ac90a92e6f5fd74/autogen/17", "duration": "41.291ms"} 2024-07-12T10:17:48.387021Z info index opened with 8 partitions {"log_id": "0qLc1H~G000", "service": "storage-engine", "index": "tsi"} 2024-07-12T10:17:48.388493Z info loading changes (start) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "start"} 2024-07-12T10:17:48.388671Z info loading changes (end) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "end", "op_elapsed": "0.180ms"} 2024-07-12T10:17:48.389346Z info Opened file {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "service": "filestore", "path": "/root/.influxdbv2/engine/data/3ac90a92e6f5fd74/autogen/19/000000182-000000002.tsm", "id": 0, "duration": "0.404ms"} 2024-07-12T10:17:48.389639Z info Opened shard {"log_id": "0qLc1H~G000", "service": "storage-engine", "service": "store", "op_name": "tsdb_open", "index_version": "tsi1", "path": "/root/.influxdbv2/engine/data/3ac90a92e6f5fd74/autogen/19", "duration": "18.774ms"} 2024-07-12T10:17:48.388588Z info index opened with 8 partitions {"log_id": "0qLc1H~G000", "service": "storage-engine", "index": "tsi"} 2024-07-12T10:17:48.399110Z info index opened with 8 partitions {"log_id": "0qLc1H~G000", "service": "storage-engine", "index": "tsi"} 2024-07-12T10:17:48.409944Z info loading changes (start) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "start"} 2024-07-12T10:17:48.410142Z info loading changes (end) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "end", "op_elapsed": "0.200ms"} 2024-07-12T10:17:48.409940Z info loading changes (start) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "start"} 2024-07-12T10:17:48.410664Z info loading changes (end) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "end", "op_elapsed": "0.731ms"} 2024-07-12T10:17:48.411054Z info Opened file {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "service": "filestore", "path": "/root/.influxdbv2/engine/data/3ac90a92e6f5fd74/autogen/18/000000179-000000002.tsm", "id": 0, "duration": "0.191ms"} 2024-07-12T10:17:48.411273Z info Opened shard {"log_id": "0qLc1H~G000", "service": "storage-engine", "service": "store", "op_name": "tsdb_open", "index_version": "tsi1", "path": "/root/.influxdbv2/engine/data/3ac90a92e6f5fd74/autogen/18", "duration": "43.475ms"} 2024-07-12T10:17:48.410504Z info Opened file {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "service": "filestore", "path": "/root/.influxdbv2/engine/data/3ac90a92e6f5fd74/autogen/20/000000059-000000002.tsm", "id": 0, "duration": "0.102ms"} 2024-07-12T10:17:48.412467Z info Opened shard {"log_id": "0qLc1H~G000", "service": "storage-engine", "service": "store", "op_name": "tsdb_open", "index_version": "tsi1", "path": "/root/.influxdbv2/engine/data/3ac90a92e6f5fd74/autogen/20", "duration": "31.319ms"} 2024-07-12T10:17:48.429299Z info index opened with 8 partitions {"log_id": "0qLc1H~G000", "service": "storage-engine", "index": "tsi"} 2024-07-12T10:17:48.430161Z info loading changes (start) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "start"} 2024-07-12T10:17:48.430245Z info loading changes (end) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "end", "op_elapsed": "0.089ms"} 2024-07-12T10:17:48.430928Z info Opened file {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "service": "filestore", "path": "/root/.influxdbv2/engine/data/3ac90a92e6f5fd74/autogen/21/000000044-000000002.tsm", "id": 0, "duration": "0.157ms"} 2024-07-12T10:17:48.431395Z info Opened shard {"log_id": "0qLc1H~G000", "service": "storage-engine", "service": "store", "op_name": "tsdb_open", "index_version": "tsi1", "path": "/root/.influxdbv2/engine/data/3ac90a92e6f5fd74/autogen/21", "duration": "43.629ms"} 2024-07-12T10:17:48.434024Z info index opened with 8 partitions {"log_id": "0qLc1H~G000", "service": "storage-engine", "index": "tsi"} 2024-07-12T10:17:48.435298Z info loading changes (start) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "start"} 2024-07-12T10:17:48.435364Z info loading changes (end) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "end", "op_elapsed": "0.080ms"} 2024-07-12T10:17:48.435300Z info index opened with 8 partitions {"log_id": "0qLc1H~G000", "service": "storage-engine", "index": "tsi"} 2024-07-12T10:17:48.435670Z info Opened file {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "service": "filestore", "path": "/root/.influxdbv2/engine/data/3ac90a92e6f5fd74/autogen/23/000000036-000000002.tsm", "id": 0, "duration": "0.119ms"} 2024-07-12T10:17:48.435743Z info Opened shard {"log_id": "0qLc1H~G000", "service": "storage-engine", "service": "store", "op_name": "tsdb_open", "index_version": "tsi1", "path": "/root/.influxdbv2/engine/data/3ac90a92e6f5fd74/autogen/23", "duration": "24.371ms"} 2024-07-12T10:17:48.436498Z info loading changes (start) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "start"} 2024-07-12T10:17:48.436585Z info loading changes (end) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "end", "op_elapsed": "0.119ms"} 2024-07-12T10:17:48.436899Z info Opened file {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "service": "filestore", "path": "/root/.influxdbv2/engine/data/3ac90a92e6f5fd74/autogen/22/000000155-000000002.tsm", "id": 0, "duration": "0.169ms"} 2024-07-12T10:17:48.437353Z info Opened shard {"log_id": "0qLc1H~G000", "service": "storage-engine", "service": "store", "op_name": "tsdb_open", "index_version": "tsi1", "path": "/root/.influxdbv2/engine/data/3ac90a92e6f5fd74/autogen/22", "duration": "47.562ms"} 2024-07-12T10:17:48.444100Z info index opened with 8 partitions {"log_id": "0qLc1H~G000", "service": "storage-engine", "index": "tsi"} 2024-07-12T10:17:48.446306Z info index opened with 8 partitions {"log_id": "0qLc1H~G000", "service": "storage-engine", "index": "tsi"} 2024-07-12T10:17:48.451309Z info loading changes (start) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "start"} 2024-07-12T10:17:48.451502Z info loading changes (end) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "end", "op_elapsed": "0.216ms"} 2024-07-12T10:17:48.452047Z info Opened file {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "service": "filestore", "path": "/root/.influxdbv2/engine/data/3ac90a92e6f5fd74/autogen/24/000000036-000000002.tsm", "id": 0, "duration": "0.261ms"} 2024-07-12T10:17:48.452341Z info Opened shard {"log_id": "0qLc1H~G000", "service": "storage-engine", "service": "store", "op_name": "tsdb_open", "index_version": "tsi1", "path": "/root/.influxdbv2/engine/data/3ac90a92e6f5fd74/autogen/24", "duration": "39.771ms"} 2024-07-12T10:17:48.452186Z info loading changes (start) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "start"} 2024-07-12T10:17:48.455847Z info loading changes (end) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "end", "op_elapsed": "3.659ms"} 2024-07-12T10:17:48.456516Z info Opened file {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "service": "filestore", "path": "/root/.influxdbv2/engine/data/3ac90a92e6f5fd74/autogen/25/000000016-000000002.tsm", "id": 0, "duration": "0.115ms"} 2024-07-12T10:17:48.456773Z info Opened shard {"log_id": "0qLc1H~G000", "service": "storage-engine", "service": "store", "op_name": "tsdb_open", "index_version": "tsi1", "path": "/root/.influxdbv2/engine/data/3ac90a92e6f5fd74/autogen/25", "duration": "25.295ms"} 2024-07-12T10:17:48.468771Z info index opened with 8 partitions {"log_id": "0qLc1H~G000", "service": "storage-engine", "index": "tsi"} 2024-07-12T10:17:48.472864Z info loading changes (start) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "start"} 2024-07-12T10:17:48.475133Z info loading changes (end) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "end", "op_elapsed": "2.391ms"} 2024-07-12T10:17:48.475722Z info Opened file {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "service": "filestore", "path": "/root/.influxdbv2/engine/data/3ac90a92e6f5fd74/autogen/26/000000014-000000002.tsm", "id": 0, "duration": "0.229ms"} 2024-07-12T10:17:48.475928Z info Opened shard {"log_id": "0qLc1H~G000", "service": "storage-engine", "service": "store", "op_name": "tsdb_open", "index_version": "tsi1", "path": "/root/.influxdbv2/engine/data/3ac90a92e6f5fd74/autogen/26", "duration": "40.171ms"} 2024-07-12T10:17:48.476071Z info index opened with 8 partitions {"log_id": "0qLc1H~G000", "service": "storage-engine", "index": "tsi"} 2024-07-12T10:17:48.476944Z info loading changes (start) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "start"} 2024-07-12T10:17:48.476967Z info loading changes (end) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "end", "op_elapsed": "0.038ms"} 2024-07-12T10:17:48.473956Z info index opened with 8 partitions {"log_id": "0qLc1H~G000", "service": "storage-engine", "index": "tsi"} 2024-07-12T10:17:48.477207Z info Opened file {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "service": "filestore", "path": "/root/.influxdbv2/engine/data/3ac90a92e6f5fd74/autogen/29/000000025-000000002.tsm", "id": 0, "duration": "0.124ms"} 2024-07-12T10:17:48.477437Z info Opened shard {"log_id": "0qLc1H~G000", "service": "storage-engine", "service": "store", "op_name": "tsdb_open", "index_version": "tsi1", "path": "/root/.influxdbv2/engine/data/3ac90a92e6f5fd74/autogen/29", "duration": "20.610ms"} 2024-07-12T10:17:48.474598Z info index opened with 8 partitions {"log_id": "0qLc1H~G000", "service": "storage-engine", "index": "tsi"} 2024-07-12T10:17:48.480940Z info loading changes (start) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "start"} 2024-07-12T10:17:48.481100Z info loading changes (end) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "end", "op_elapsed": "0.174ms"} 2024-07-12T10:17:48.481786Z info Opened file {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "service": "filestore", "path": "/root/.influxdbv2/engine/data/3ac90a92e6f5fd74/autogen/27/000000010-000000002.tsm", "id": 0, "duration": "0.480ms"} 2024-07-12T10:17:48.482132Z info Opened shard {"log_id": "0qLc1H~G000", "service": "storage-engine", "service": "store", "op_name": "tsdb_open", "index_version": "tsi1", "path": "/root/.influxdbv2/engine/data/3ac90a92e6f5fd74/autogen/27", "duration": "44.704ms"} 2024-07-12T10:17:48.490891Z info loading changes (start) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "start"} 2024-07-12T10:17:48.490987Z info loading changes (end) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "end", "op_elapsed": "0.109ms"} 2024-07-12T10:17:48.491605Z info Opened file {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "service": "filestore", "path": "/root/.influxdbv2/engine/data/3ac90a92e6f5fd74/autogen/28/000000016-000000003.tsm", "id": 0, "duration": "0.428ms"} 2024-07-12T10:17:48.491761Z info Opened shard {"log_id": "0qLc1H~G000", "service": "storage-engine", "service": "store", "op_name": "tsdb_open", "index_version": "tsi1", "path": "/root/.influxdbv2/engine/data/3ac90a92e6f5fd74/autogen/28", "duration": "39.238ms"} 2024-07-12T10:17:48.497866Z info index opened with 8 partitions {"log_id": "0qLc1H~G000", "service": "storage-engine", "index": "tsi"} 2024-07-12T10:17:48.498594Z info index opened with 8 partitions {"log_id": "0qLc1H~G000", "service": "storage-engine", "index": "tsi"} 2024-07-12T10:17:48.501757Z info loading changes (start) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "start"} 2024-07-12T10:17:48.501816Z info loading changes (end) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "end", "op_elapsed": "0.072ms"} 2024-07-12T10:17:48.502125Z info Opened file {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "service": "filestore", "path": "/root/.influxdbv2/engine/data/3ac90a92e6f5fd74/autogen/3/000000096-000000002.tsm", "id": 0, "duration": "0.112ms"} 2024-07-12T10:17:48.502282Z info Opened shard {"log_id": "0qLc1H~G000", "service": "storage-engine", "service": "store", "op_name": "tsdb_open", "index_version": "tsi1", "path": "/root/.influxdbv2/engine/data/3ac90a92e6f5fd74/autogen/3", "duration": "26.327ms"} 2024-07-12T10:17:48.501855Z info loading changes (start) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "start"} 2024-07-12T10:17:48.506900Z info loading changes (end) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "end", "op_elapsed": "5.046ms"} 2024-07-12T10:17:48.507532Z info Opened file {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "service": "filestore", "path": "/root/.influxdbv2/engine/data/3ac90a92e6f5fd74/autogen/30/000000010-000000002.tsm", "id": 0, "duration": "0.255ms"} 2024-07-12T10:17:48.507717Z info Opened shard {"log_id": "0qLc1H~G000", "service": "storage-engine", "service": "store", "op_name": "tsdb_open", "index_version": "tsi1", "path": "/root/.influxdbv2/engine/data/3ac90a92e6f5fd74/autogen/30", "duration": "30.191ms"} 2024-07-12T10:17:48.505738Z info index opened with 8 partitions {"log_id": "0qLc1H~G000", "service": "storage-engine", "index": "tsi"} 2024-07-12T10:17:48.510978Z info loading changes (start) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "start"} 2024-07-12T10:17:48.511100Z info loading changes (end) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "end", "op_elapsed": "0.141ms"} 2024-07-12T10:17:48.511628Z info Opened file {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "service": "filestore", "path": "/root/.influxdbv2/engine/data/3ac90a92e6f5fd74/autogen/31/000000012-000000002.tsm", "id": 0, "duration": "0.186ms"} 2024-07-12T10:17:48.511878Z info Opened shard {"log_id": "0qLc1H~G000", "service": "storage-engine", "service": "store", "op_name": "tsdb_open", "index_version": "tsi1", "path": "/root/.influxdbv2/engine/data/3ac90a92e6f5fd74/autogen/31", "duration": "29.691ms"} 2024-07-12T10:17:48.520644Z info index opened with 8 partitions {"log_id": "0qLc1H~G000", "service": "storage-engine", "index": "tsi"} 2024-07-12T10:17:48.523313Z info index opened with 8 partitions {"log_id": "0qLc1H~G000", "service": "storage-engine", "index": "tsi"} 2024-07-12T10:17:48.546547Z info loading changes (start) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "start"} 2024-07-12T10:17:48.546724Z info loading changes (end) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "end", "op_elapsed": "0.189ms"} 2024-07-12T10:17:48.547433Z info Opened file {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "service": "filestore", "path": "/root/.influxdbv2/engine/data/3ac90a92e6f5fd74/autogen/4/000000090-000000002.tsm", "id": 0, "duration": "0.311ms"} 2024-07-12T10:17:48.547732Z info Opened shard {"log_id": "0qLc1H~G000", "service": "storage-engine", "service": "store", "op_name": "tsdb_open", "index_version": "tsi1", "path": "/root/.influxdbv2/engine/data/3ac90a92e6f5fd74/autogen/4", "duration": "55.922ms"} 2024-07-12T10:17:48.554248Z info loading changes (start) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "start"} 2024-07-12T10:17:48.554430Z info loading changes (end) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "end", "op_elapsed": "0.197ms"} 2024-07-12T10:17:48.555174Z info Opened file {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "service": "filestore", "path": "/root/.influxdbv2/engine/data/3ac90a92e6f5fd74/autogen/5/000000072-000000003.tsm", "id": 0, "duration": "0.295ms"} 2024-07-12T10:17:48.555540Z info Opened shard {"log_id": "0qLc1H~G000", "service": "storage-engine", "service": "store", "op_name": "tsdb_open", "index_version": "tsi1", "path": "/root/.influxdbv2/engine/data/3ac90a92e6f5fd74/autogen/5", "duration": "53.176ms"} 2024-07-12T10:17:48.558458Z info index opened with 8 partitions {"log_id": "0qLc1H~G000", "service": "storage-engine", "index": "tsi"} 2024-07-12T10:17:48.559887Z info loading changes (start) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "start"} 2024-07-12T10:17:48.561318Z info loading changes (end) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "end", "op_elapsed": "1.431ms"} 2024-07-12T10:17:48.564092Z info Opened file {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "service": "filestore", "path": "/root/.influxdbv2/engine/data/3ac90a92e6f5fd74/autogen/7/000000113-000000002.tsm", "id": 0, "duration": "1.413ms"} 2024-07-12T10:17:48.564529Z info Opened shard {"log_id": "0qLc1H~G000", "service": "storage-engine", "service": "store", "op_name": "tsdb_open", "index_version": "tsi1", "path": "/root/.influxdbv2/engine/data/3ac90a92e6f5fd74/autogen/7", "duration": "52.564ms"} 2024-07-12T10:17:48.571832Z info index opened with 8 partitions {"log_id": "0qLc1H~G000", "service": "storage-engine", "index": "tsi"} 2024-07-12T10:17:48.570174Z info index opened with 8 partitions {"log_id": "0qLc1H~G000", "service": "storage-engine", "index": "tsi"} 2024-07-12T10:17:48.572894Z info loading changes (start) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "start"} 2024-07-12T10:17:48.573056Z info loading changes (start) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "start"} 2024-07-12T10:17:48.573074Z info loading changes (end) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "end", "op_elapsed": "0.184ms"} 2024-07-12T10:17:48.576099Z info Opened file {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "service": "filestore", "path": "/root/.influxdbv2/engine/data/3ac90a92e6f5fd74/autogen/9/000000099-000000002.tsm", "id": 0, "duration": "0.095ms"} 2024-07-12T10:17:48.574922Z info index opened with 8 partitions {"log_id": "0qLc1H~G000", "service": "storage-engine", "index": "tsi"} 2024-07-12T10:17:48.575346Z info loading changes (end) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "end", "op_elapsed": "2.289ms"} 2024-07-12T10:17:48.576324Z info Opened shard {"log_id": "0qLc1H~G000", "service": "storage-engine", "service": "store", "op_name": "tsdb_open", "index_version": "tsi1", "path": "/root/.influxdbv2/engine/data/3ac90a92e6f5fd74/autogen/9", "duration": "20.716ms"} 2024-07-12T10:17:48.576367Z info Opened file {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "service": "filestore", "path": "/root/.influxdbv2/engine/data/3ac90a92e6f5fd74/autogen/8/000000051-000000002.tsm", "id": 0, "duration": "0.064ms"} 2024-07-12T10:17:48.577677Z info Opened shard {"log_id": "0qLc1H~G000", "service": "storage-engine", "service": "store", "op_name": "tsdb_open", "index_version": "tsi1", "path": "/root/.influxdbv2/engine/data/3ac90a92e6f5fd74/autogen/8", "duration": "29.897ms"} 2024-07-12T10:17:48.577267Z info loading changes (start) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "start"} 2024-07-12T10:17:48.580239Z info loading changes (end) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "end", "op_elapsed": "2.996ms"} 2024-07-12T10:17:48.581044Z info Opened file {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "service": "filestore", "path": "/root/.influxdbv2/engine/data/3ac90a92e6f5fd74/autogen/6/000000082-000000002.tsm", "id": 0, "duration": "0.186ms"} 2024-07-12T10:17:48.581413Z info Opened shard {"log_id": "0qLc1H~G000", "service": "storage-engine", "service": "store", "op_name": "tsdb_open", "index_version": "tsi1", "path": "/root/.influxdbv2/engine/data/3ac90a92e6f5fd74/autogen/6", "duration": "73.567ms"} 2024-07-12T10:17:48.588129Z info index opened with 8 partitions {"log_id": "0qLc1H~G000", "service": "storage-engine", "index": "tsi"} 2024-07-12T10:17:48.590318Z info loading changes (start) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "start"} 2024-07-12T10:17:48.590679Z info loading changes (end) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "end", "op_elapsed": "0.397ms"} 2024-07-12T10:17:48.591793Z info Opened file {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "service": "filestore", "path": "/root/.influxdbv2/engine/data/3addfb11b06f756e/autogen/106/000000010-000000002.tsm", "id": 0, "duration": "0.569ms"} 2024-07-12T10:17:48.592425Z info Opened shard {"log_id": "0qLc1H~G000", "service": "storage-engine", "service": "store", "op_name": "tsdb_open", "index_version": "tsi1", "path": "/root/.influxdbv2/engine/data/3addfb11b06f756e/autogen/106", "duration": "22.137ms"} 2024-07-12T10:17:48.602743Z info index opened with 8 partitions {"log_id": "0qLc1H~G000", "service": "storage-engine", "index": "tsi"} 2024-07-12T10:17:48.603428Z info loading changes (start) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "start"} 2024-07-12T10:17:48.603487Z info loading changes (end) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "end", "op_elapsed": "0.073ms"} 2024-07-12T10:17:48.604016Z info Opened file {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "service": "filestore", "path": "/root/.influxdbv2/engine/data/3addfb11b06f756e/autogen/124/000000016-000000002.tsm", "id": 0, "duration": "0.377ms"} 2024-07-12T10:17:48.604146Z info Opened shard {"log_id": "0qLc1H~G000", "service": "storage-engine", "service": "store", "op_name": "tsdb_open", "index_version": "tsi1", "path": "/root/.influxdbv2/engine/data/3addfb11b06f756e/autogen/124", "duration": "25.889ms"} 2024-07-12T10:17:48.602775Z info index opened with 8 partitions {"log_id": "0qLc1H~G000", "service": "storage-engine", "index": "tsi"} 2024-07-12T10:17:48.606755Z info loading changes (start) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "start"} 2024-07-12T10:17:48.608019Z info index opened with 8 partitions {"log_id": "0qLc1H~G000", "service": "storage-engine", "index": "tsi"} 2024-07-12T10:17:48.608959Z info loading changes (start) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "start"} 2024-07-12T10:17:48.609040Z info loading changes (end) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "end", "op_elapsed": "0.088ms"} 2024-07-12T10:17:48.609889Z info Opened file {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "service": "filestore", "path": "/root/.influxdbv2/engine/data/3addfb11b06f756e/autogen/133/000000010-000000002.tsm", "id": 0, "duration": "0.432ms"} 2024-07-12T10:17:48.610056Z info Opened shard {"log_id": "0qLc1H~G000", "service": "storage-engine", "service": "store", "op_name": "tsdb_open", "index_version": "tsi1", "path": "/root/.influxdbv2/engine/data/3addfb11b06f756e/autogen/133", "duration": "28.266ms"} 2024-07-12T10:17:48.611366Z info index opened with 8 partitions {"log_id": "0qLc1H~G000", "service": "storage-engine", "index": "tsi"} 2024-07-12T10:17:48.607062Z info loading changes (end) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "end", "op_elapsed": "0.310ms"} 2024-07-12T10:17:48.615140Z info Opened file {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "service": "filestore", "path": "/root/.influxdbv2/engine/data/3addfb11b06f756e/autogen/115/000000008-000000002.tsm", "id": 0, "duration": "0.183ms"} 2024-07-12T10:17:48.615388Z info Opened shard {"log_id": "0qLc1H~G000", "service": "storage-engine", "service": "store", "op_name": "tsdb_open", "index_version": "tsi1", "path": "/root/.influxdbv2/engine/data/3addfb11b06f756e/autogen/115", "duration": "37.953ms"} 2024-07-12T10:17:48.618236Z info loading changes (start) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "start"} 2024-07-12T10:17:48.618386Z info loading changes (end) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "end", "op_elapsed": "0.164ms"} 2024-07-12T10:17:48.618993Z info Opened file {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "service": "filestore", "path": "/root/.influxdbv2/engine/data/3addfb11b06f756e/autogen/142/000000010-000000002.tsm", "id": 0, "duration": "0.264ms"} 2024-07-12T10:17:48.619401Z info Opened shard {"log_id": "0qLc1H~G000", "service": "storage-engine", "service": "store", "op_name": "tsdb_open", "index_version": "tsi1", "path": "/root/.influxdbv2/engine/data/3addfb11b06f756e/autogen/142", "duration": "26.862ms"} 2024-07-12T10:17:48.624959Z info index opened with 8 partitions {"log_id": "0qLc1H~G000", "service": "storage-engine", "index": "tsi"} 2024-07-12T10:17:48.626306Z info loading changes (start) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "start"} 2024-07-12T10:17:48.626386Z info loading changes (end) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "end", "op_elapsed": "0.100ms"} 2024-07-12T10:17:48.627262Z info Opened file {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "service": "filestore", "path": "/root/.influxdbv2/engine/data/3addfb11b06f756e/autogen/151/000000016-000000002.tsm", "id": 0, "duration": "0.390ms"} 2024-07-12T10:17:48.627570Z info Opened shard {"log_id": "0qLc1H~G000", "service": "storage-engine", "service": "store", "op_name": "tsdb_open", "index_version": "tsi1", "path": "/root/.influxdbv2/engine/data/3addfb11b06f756e/autogen/151", "duration": "23.368ms"} 2024-07-12T10:17:48.630912Z info index opened with 8 partitions {"log_id": "0qLc1H~G000", "service": "storage-engine", "index": "tsi"} 2024-07-12T10:17:48.638346Z info loading changes (start) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "start"} 2024-07-12T10:17:48.638486Z info loading changes (end) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "end", "op_elapsed": "0.145ms"} 2024-07-12T10:17:48.638758Z info Opened file {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "service": "filestore", "path": "/root/.influxdbv2/engine/data/3addfb11b06f756e/autogen/160/000000009-000000002.tsm", "id": 0, "duration": "0.100ms"} 2024-07-12T10:17:48.634753Z info index opened with 8 partitions {"log_id": "0qLc1H~G000", "service": "storage-engine", "index": "tsi"} 2024-07-12T10:17:48.638872Z info Opened shard {"log_id": "0qLc1H~G000", "service": "storage-engine", "service": "store", "op_name": "tsdb_open", "index_version": "tsi1", "path": "/root/.influxdbv2/engine/data/3addfb11b06f756e/autogen/160", "duration": "28.774ms"} 2024-07-12T10:17:48.639376Z info loading changes (start) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "start"} 2024-07-12T10:17:48.639441Z info loading changes (end) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "end", "op_elapsed": "0.073ms"} 2024-07-12T10:17:48.639741Z info Opened file {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "service": "filestore", "path": "/root/.influxdbv2/engine/data/3addfb11b06f756e/autogen/169/000000008-000000002.tsm", "id": 0, "duration": "0.152ms"} 2024-07-12T10:17:48.640065Z info Opened shard {"log_id": "0qLc1H~G000", "service": "storage-engine", "service": "store", "op_name": "tsdb_open", "index_version": "tsi1", "path": "/root/.influxdbv2/engine/data/3addfb11b06f756e/autogen/169", "duration": "24.624ms"} 2024-07-12T10:17:48.645873Z info index opened with 8 partitions {"log_id": "0qLc1H~G000", "service": "storage-engine", "index": "tsi"} 2024-07-12T10:17:48.651317Z info loading changes (start) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "start"} 2024-07-12T10:17:48.651666Z info loading changes (end) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "end", "op_elapsed": "0.371ms"} 2024-07-12T10:17:48.652691Z info Opened file {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "service": "filestore", "path": "/root/.influxdbv2/engine/data/3addfb11b06f756e/autogen/178/000000013-000000002.tsm", "id": 0, "duration": "0.430ms"} 2024-07-12T10:17:48.653050Z info Opened shard {"log_id": "0qLc1H~G000", "service": "storage-engine", "service": "store", "op_name": "tsdb_open", "index_version": "tsi1", "path": "/root/.influxdbv2/engine/data/3addfb11b06f756e/autogen/178", "duration": "33.529ms"} 2024-07-12T10:17:48.658099Z info index opened with 8 partitions {"log_id": "0qLc1H~G000", "service": "storage-engine", "index": "tsi"} 2024-07-12T10:17:48.660243Z info loading changes (start) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "start"} 2024-07-12T10:17:48.661269Z info loading changes (end) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "end", "op_elapsed": "1.037ms"} 2024-07-12T10:17:48.660405Z info index opened with 8 partitions {"log_id": "0qLc1H~G000", "service": "storage-engine", "index": "tsi"} 2024-07-12T10:17:48.662464Z info Opened file {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "service": "filestore", "path": "/root/.influxdbv2/engine/data/3addfb11b06f756e/autogen/196/000000008-000000001.tsm", "id": 1, "duration": "0.170ms"} 2024-07-12T10:17:48.662603Z info Opened file {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "service": "filestore", "path": "/root/.influxdbv2/engine/data/3addfb11b06f756e/autogen/196/000000006-000000002.tsm", "id": 0, "duration": "0.212ms"} 2024-07-12T10:17:48.664244Z info index opened with 8 partitions {"log_id": "0qLc1H~G000", "service": "storage-engine", "index": "tsi"} 2024-07-12T10:17:48.664887Z info Opened shard {"log_id": "0qLc1H~G000", "service": "storage-engine", "service": "store", "op_name": "tsdb_open", "index_version": "tsi1", "path": "/root/.influxdbv2/engine/data/3addfb11b06f756e/autogen/196", "duration": "25.946ms"} 2024-07-12T10:17:48.665599Z info loading changes (start) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "start"} 2024-07-12T10:17:48.665676Z info loading changes (end) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "end", "op_elapsed": "0.081ms"} 2024-07-12T10:17:48.668085Z info Opened file {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "service": "filestore", "path": "/root/.influxdbv2/engine/data/3addfb11b06f756e/autogen/187/000000009-000000002.tsm", "id": 0, "duration": "0.251ms"} 2024-07-12T10:17:48.666791Z info loading changes (start) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "start"} 2024-07-12T10:17:48.668798Z info loading changes (end) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "end", "op_elapsed": "2.033ms"} 2024-07-12T10:17:48.668853Z info Opened shard {"log_id": "0qLc1H~G000", "service": "storage-engine", "service": "store", "op_name": "tsdb_open", "index_version": "tsi1", "path": "/root/.influxdbv2/engine/data/3addfb11b06f756e/autogen/187", "duration": "41.187ms"} 2024-07-12T10:17:48.669553Z info Opened file {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "service": "filestore", "path": "/root/.influxdbv2/engine/data/3addfb11b06f756e/autogen/2/000000012-000000002.tsm", "id": 0, "duration": "0.474ms"} 2024-07-12T10:17:48.676042Z info Opened shard {"log_id": "0qLc1H~G000", "service": "storage-engine", "service": "store", "op_name": "tsdb_open", "index_version": "tsi1", "path": "/root/.influxdbv2/engine/data/3addfb11b06f756e/autogen/2", "duration": "35.926ms"} 2024-07-12T10:17:48.673403Z info index opened with 8 partitions {"log_id": "0qLc1H~G000", "service": "storage-engine", "index": "tsi"} 2024-07-12T10:17:48.682257Z info loading changes (start) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "start"} 2024-07-12T10:17:48.682332Z info loading changes (end) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "end", "op_elapsed": "0.087ms"} 2024-07-12T10:17:48.682891Z info Opened file {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "service": "filestore", "path": "/root/.influxdbv2/engine/data/3addfb11b06f756e/autogen/34/000000013-000000002.tsm", "id": 0, "duration": "0.400ms"} 2024-07-12T10:17:48.683132Z info Opened shard {"log_id": "0qLc1H~G000", "service": "storage-engine", "service": "store", "op_name": "tsdb_open", "index_version": "tsi1", "path": "/root/.influxdbv2/engine/data/3addfb11b06f756e/autogen/34", "duration": "27.070ms"} 2024-07-12T10:17:48.691009Z info index opened with 8 partitions {"log_id": "0qLc1H~G000", "service": "storage-engine", "index": "tsi"} 2024-07-12T10:17:48.692159Z info loading changes (start) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "start"} 2024-07-12T10:17:48.692433Z info loading changes (end) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "end", "op_elapsed": "0.286ms"} 2024-07-12T10:17:48.693154Z info Opened file {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "service": "filestore", "path": "/root/.influxdbv2/engine/data/3addfb11b06f756e/autogen/52/000000014-000000002.tsm", "id": 0, "duration": "0.328ms"} 2024-07-12T10:17:48.693344Z info Opened shard {"log_id": "0qLc1H~G000", "service": "storage-engine", "service": "store", "op_name": "tsdb_open", "index_version": "tsi1", "path": "/root/.influxdbv2/engine/data/3addfb11b06f756e/autogen/52", "duration": "19.761ms"} 2024-07-12T10:17:48.694935Z info index opened with 8 partitions {"log_id": "0qLc1H~G000", "service": "storage-engine", "index": "tsi"} 2024-07-12T10:17:48.684278Z info index opened with 8 partitions {"log_id": "0qLc1H~G000", "service": "storage-engine", "index": "tsi"} 2024-07-12T10:17:48.695465Z info loading changes (start) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "start"} 2024-07-12T10:17:48.695882Z info loading changes (end) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "end", "op_elapsed": "0.420ms"} 2024-07-12T10:17:48.696260Z info Opened file {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "service": "filestore", "path": "/root/.influxdbv2/engine/data/3addfb11b06f756e/autogen/61/000000011-000000002.tsm", "id": 0, "duration": "0.154ms"} 2024-07-12T10:17:48.696388Z info Opened shard {"log_id": "0qLc1H~G000", "service": "storage-engine", "service": "store", "op_name": "tsdb_open", "index_version": "tsi1", "path": "/root/.influxdbv2/engine/data/3addfb11b06f756e/autogen/61", "duration": "20.243ms"} 2024-07-12T10:17:48.702388Z info loading changes (start) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "start"} 2024-07-12T10:17:48.703821Z info loading changes (end) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "end", "op_elapsed": "1.440ms"} 2024-07-12T10:17:48.704952Z info Opened file {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "service": "filestore", "path": "/root/.influxdbv2/engine/data/3addfb11b06f756e/autogen/43/000000009-000000002.tsm", "id": 0, "duration": "0.167ms"} 2024-07-12T10:17:48.705361Z info index opened with 8 partitions {"log_id": "0qLc1H~G000", "service": "storage-engine", "index": "tsi"} 2024-07-12T10:17:48.705834Z info Opened shard {"log_id": "0qLc1H~G000", "service": "storage-engine", "service": "store", "op_name": "tsdb_open", "index_version": "tsi1", "path": "/root/.influxdbv2/engine/data/3addfb11b06f756e/autogen/43", "duration": "40.291ms"} 2024-07-12T10:17:48.706356Z info loading changes (start) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "start"} 2024-07-12T10:17:48.706422Z info loading changes (end) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "end", "op_elapsed": "0.068ms"} 2024-07-12T10:17:48.706885Z info Opened file {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "service": "filestore", "path": "/root/.influxdbv2/engine/data/3addfb11b06f756e/autogen/79/000000008-000000002.tsm", "id": 0, "duration": "0.163ms"} 2024-07-12T10:17:48.707704Z info Opened shard {"log_id": "0qLc1H~G000", "service": "storage-engine", "service": "store", "op_name": "tsdb_open", "index_version": "tsi1", "path": "/root/.influxdbv2/engine/data/3addfb11b06f756e/autogen/79", "duration": "14.266ms"} 2024-07-12T10:17:48.720066Z info index opened with 8 partitions {"log_id": "0qLc1H~G000", "service": "storage-engine", "index": "tsi"} 2024-07-12T10:17:48.721181Z info index opened with 8 partitions {"log_id": "0qLc1H~G000", "service": "storage-engine", "index": "tsi"} 2024-07-12T10:17:48.721295Z info loading changes (start) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "start"} 2024-07-12T10:17:48.721514Z info loading changes (end) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "end", "op_elapsed": "0.224ms"} 2024-07-12T10:17:48.721796Z info Opened file {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "service": "filestore", "path": "/root/.influxdbv2/engine/data/3addfb11b06f756e/autogen/70/000000010-000000002.tsm", "id": 0, "duration": "0.112ms"} 2024-07-12T10:17:48.721900Z info Opened shard {"log_id": "0qLc1H~G000", "service": "storage-engine", "service": "store", "op_name": "tsdb_open", "index_version": "tsi1", "path": "/root/.influxdbv2/engine/data/3addfb11b06f756e/autogen/70", "duration": "35.707ms"} 2024-07-12T10:17:48.722042Z info loading changes (start) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "start"} 2024-07-12T10:17:48.722197Z info loading changes (end) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "end", "op_elapsed": "0.161ms"} 2024-07-12T10:17:48.722608Z info Opened file {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "service": "filestore", "path": "/root/.influxdbv2/engine/data/3addfb11b06f756e/autogen/88/000000003-000000002.tsm", "id": 0, "duration": "0.159ms"} 2024-07-12T10:17:48.722830Z info Opened shard {"log_id": "0qLc1H~G000", "service": "storage-engine", "service": "store", "op_name": "tsdb_open", "index_version": "tsi1", "path": "/root/.influxdbv2/engine/data/3addfb11b06f756e/autogen/88", "duration": "26.381ms"} 2024-07-12T10:17:48.725817Z info index opened with 8 partitions {"log_id": "0qLc1H~G000", "service": "storage-engine", "index": "tsi"} 2024-07-12T10:17:48.726682Z info loading changes (start) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "start"} 2024-07-12T10:17:48.726819Z info loading changes (end) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "op_name": "field indices", "op_event": "end", "op_elapsed": "0.139ms"} 2024-07-12T10:17:48.727379Z info Opened file {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "service": "filestore", "path": "/root/.influxdbv2/engine/data/3ac90a92e6f5fd74/autogen/11/000000086-000000002.tsm", "id": 0, "duration": "0.350ms"} 2024-07-12T10:17:48.727556Z info Opened shard {"log_id": "0qLc1H~G000", "service": "storage-engine", "service": "store", "op_name": "tsdb_open", "index_version": "tsi1", "path": "/root/.influxdbv2/engine/data/3ac90a92e6f5fd74/autogen/11", "duration": "21.302ms"} 2024-07-12T10:17:48.728702Z info Open store (end) {"log_id": "0qLc1H~G000", "service": "storage-engine", "service": "store", "op_name": "tsdb_open", "op_event": "end", "op_elapsed": "435.180ms"} 2024-07-12T10:17:48.728795Z info Starting retention policy enforcement service {"log_id": "0qLc1H~G000", "service": "retention", "check_interval": "30m"} 2024-07-12T10:17:48.728905Z info Starting precreation service {"log_id": "0qLc1H~G000", "service": "shard-precreation", "check_interval": "10m", "advance_period": "30m"} 2024-07-12T10:17:48.729889Z info Starting query controller {"log_id": "0qLc1H~G000", "service": "storage-reads", "concurrency_quota": 1024, "initial_memory_bytes_quota_per_query": 9223372036854775807, "memory_bytes_quota_per_query": 9223372036854775807, "max_memory_bytes": 0, "queue_size": 1024} 2024-07-12T10:17:48.732962Z info Configuring InfluxQL statement executor (zeros indicate unlimited). {"log_id": "0qLc1H~G000", "max_select_point": 0, "max_select_series": 0, "max_select_buckets": 0} 2024-07-12T10:17:48.742265Z info Starting {"log_id": "0qLc1H~G000", "service": "telemetry", "interval": "8h"} 2024-07-12T10:17:48.743296Z info Listening {"log_id": "0qLc1H~G000", "service": "tcp-listener", "transport": "http", "addr": ":8086", "port": 8086} 2024-07-12T10:17:49.728157Z info TSM compaction (start) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "tsm1_strategy": "full", "tsm1_optimize": false, "op_name": "tsm1_compact_group", "op_event": "start"} 2024-07-12T10:17:49.728215Z info Beginning compaction {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "tsm1_strategy": "full", "tsm1_optimize": false, "op_name": "tsm1_compact_group", "tsm1_files_n": 2} 2024-07-12T10:17:49.728267Z info Compacting file {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "tsm1_strategy": "full", "tsm1_optimize": false, "op_name": "tsm1_compact_group", "tsm1_index": 0, "tsm1_file": "/root/.influxdbv2/engine/data/3addfb11b06f756e/autogen/196/000000006-000000002.tsm"} 2024-07-12T10:17:49.728308Z info Compacting file {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "tsm1_strategy": "full", "tsm1_optimize": false, "op_name": "tsm1_compact_group", "tsm1_index": 1, "tsm1_file": "/root/.influxdbv2/engine/data/3addfb11b06f756e/autogen/196/000000008-000000001.tsm"} 2024-07-12T10:17:49.909924Z info Compacted file {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "tsm1_strategy": "full", "tsm1_optimize": false, "op_name": "tsm1_compact_group", "tsm1_index": 0, "tsm1_file": "/root/.influxdbv2/engine/data/3addfb11b06f756e/autogen/196/000000008-000000002.tsm.tmp"} 2024-07-12T10:17:49.910048Z info Finished compacting files {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "tsm1_strategy": "full", "tsm1_optimize": false, "op_name": "tsm1_compact_group", "tsm1_files_n": 1} 2024-07-12T10:17:49.910058Z info TSM compaction (end) {"log_id": "0qLc1H~G000", "service": "storage-engine", "engine": "tsm1", "tsm1_strategy": "full", "tsm1_optimize": false, "op_name": "tsm1_compact_group", "op_event": "end", "op_elapsed": "181.918ms"} 2024-07-12T10:17:57.885700Z info Unauthorized {"log_id": "0qLc1H~G000", "error": "authorization not found"} 2024-07-12T10:18:07.889131Z info Unauthorized {"log_id": "0qLc1H~G000", "error": "authorization not found"} ^C2024-07-12T10:18:12.393878Z info Stopping {"log_id": "0qLc1H~G000", "service": "telemetry", "interval": "8h"} 2024-07-12T10:18:12.393964Z info Terminating precreation service {"log_id": "0qLc1H~G000", "service": "shard-precreation"} 2024-07-12T10:18:12.393935Z info Stopping subsystem {"log_id": "0qLc1H~G000", "subsystem": "HTTP server"} 2024-07-12T10:18:12.394095Z info Stopping {"log_id": "0qLc1H~G000", "service": "tcp-listener"} 2024-07-12T10:18:12.394203Z info Stopping subsystem {"log_id": "0qLc1H~G000", "subsystem": "scraper"} 2024-07-12T10:18:12.394556Z info Stopping subsystem {"log_id": "0qLc1H~G000", "subsystem": "task"} 2024-07-12T10:18:12.394777Z info Stopping subsystem {"log_id": "0qLc1H~G000", "subsystem": "query"} 2024-07-12T10:18:12.395955Z info Stopping subsystem {"log_id": "0qLc1H~G000", "subsystem": "replications"} 2024-07-12T10:18:12.395997Z info Stopping subsystem {"log_id": "0qLc1H~G000", "subsystem": "engine"} 2024-07-12T10:18:12.396018Z info Closing retention policy enforcement service {"log_id": "0qLc1H~G000", "service": "retention"} 2024-07-12T10:18:12.400696Z info Stopping subsystem {"log_id": "0qLc1H~G000", "subsystem": "sqlite"} 2024-07-12T10:18:12.400973Z info Stopping subsystem {"log_id": "0qLc1H~G000", "subsystem": "bolt"}

Vielen Dank für eure Unterstützung

@djmarc75 achso 🙂
Bildschirmfoto 2024-07-11 um 08.40.40.png

@thomas-braun sagte in Repo für influxdb-client:

Einmal aus- und wieder einloggen müsste passen

Ja , passt.

@marc-berg

Hab mal alles Mögliche ausgeschalten. Intervall jetzt 30s 🙂

Naja... früher oder später werd ich drüber stolpern.

An alle Adapter Entwickler: so ne Debug Meldung bringt niemandem etwas 😂

@oliverio said in PC stürzt nach Laden hoher Datenmengen ab:

@chriswitt

in javascript einfach in einer variable den timestamp merken, an dem geschrieben wird.
beim nächsten trigger dann prüfen ob letzter timestamp mindestens 30*1000 größer ist.
aber dann sind es in 90 tagen immer noch 15 mio werte.

wenn dir alle 30 sekunden reicht, dann kannst du ja mal probieren, das influx dir das auch alle 30 sekunden aggregiert und nur diese daten liefert. die abfrage ändert die zugrundeliegenden daten nicht, nur die abfrage liefert das.
damit kannst du dann rumspielen ob du evtl noch weiter aggregieren willst.

ich kenne jetzt das skript nicht, aber da müsste doch sicherlich eine influx abfrage drin sein, die du nach den folgenden anweisungen apssassen kannst

https://docs.influxdata.com/influxdb/cloud/query-data/flux/window-aggregate/

versuche soviel funktionalität in die abfrage von influx zu legen, da diese das um einiges effizienter kann, wie du nachher in javascript auswerten kannst.

Ach ich hab halt so gar keine detailllierte Ahnung 😉

Das Skript ist prinzipiell dieses hier :

https://haus-automatisierung.com/software/2023/05/11/influxdb2-pv-dashboard.html

Könnte mir das jemand umbauen auf einen x sek. log ? 😉

Geb auch ein Bier aus 🙂

@balu67

Ich dachte, du wolltest nur bestimmte Daten in der Influx löschen, mit dem command löschst du aber deine ganze influx Installation..

@longbow sagte in Verbindung von influxdb nach Grafana:

also ich hatte mal eine Verbindung von Influxdb nach Grafana, als Version 1 noch möglich war.
Jetzt verbindet sich die beiden ja nur noch, wenn man die Version 2 nimmt

Hast du auch einen kompletten Umzug von v1. X auf v2. X gemacht?

Mit "nur auf neue Version upgraden" ist es nicht getan

Unabhängig davon läuft v1. X nach wie vor, man muss nicht auf v2. X

@lansester sagte in Grünlandtemperatursumme und Flux:

Ist das Javascript, so dass ich es direkt als Skript verwenden kann und muss nur den Datenpunkt meines Außentemp-Sensors angeben?

Nein, das ist kein Javascript, sondern Flux, also die Standard-Abfragesprache der InfluxDB 2.x

Mein Ziel:
Einmal pro Tag ein Skript laufen lassen (Blockly oder Javascript), welches aus den vorhandenen Daten in der InfluxDB (Datenpunkt des Temp-Sensors) die aktuelle Gründlandtemperatur berechnet und in einem Objekt/Datenpunkt ablegt.
Das Objekt würde ich dann wiederum mit loggen und zur Darstellung nutzen.

Genau diesem Umweg benötigst du mit meiner Abfrage eben nicht. Die Abfrage setzt einen Datenpunkt mit Außentemperaturen voraus, der mindestens stündlich in die InfluxDB loggen sollte. Diese Abfrage kannst du 1:1 z.B. in Grafana einfügen (Datenpunkt natürlich anpassen) und bist damit fertig.

255fc85e-f7ad-4326-aa30-258f099f4f7e-grafik.png

@marc-berg
Moin, als kurzer Nachtrag: Jetzt läuft alles wieder ohne Probleme. Herzlichen Dank nochmal.
iobrokerbackup.PNG

@bitwicht
Kann es sein, dass da im Zeitraum evtl. keine Daten vorhanden sind?

@crunchip influx CLI ist natürlich auch drauf sonst würde das backup nicht starten, es bricht ja erst nach einer gewissen Zeit ab.

Der Befehl hätte sonst sofort einen fehler gemacht, bei mir ist das ja fast 10 Minuten gelaufen und beim shard 16 kommt dann der Fehler. (Was auch immer ein shard ist)

sudo influx backup ~ $ influx version Influx CLI dev (git: none) build_date: 2023-04-28T14:24:22Z

Ich glaub ich hab was gefunden, mein Speicher ist wie es aussieht voll 😕

$ df -h Filesystem Size Used Avail Use% Mounted on /dev/root 15G 14G 0 100% / devtmpfs 667M 0 667M 0% /dev tmpfs 925M 0 925M 0% /dev/shm tmpfs 370M 1.1M 369M 1% /run tmpfs 5.0M 4.0K 5.0M 1% /run/lock /dev/mmcblk0p1 255M 31M 225M 13% /boot tmpfs 185M 0 185M 0% /run/user/1000 192.168.1.105:/volume1/Share/rpibackups 2.7T 1.7T 1.1T 62% /home/nfs/mybackup

Wie finde ich denn raus wo das zeug liegt, den Ordner /dev/root gibts nicht, irgendwas hab ich mir da zugemüllt, systemctl sagt auch das influx nichtmehr läuft wegen fehlendem Speicher.

Kann mir jemand sagen wie ich den Orddner finde wo das Zeug drin liegt?

@marc-berg
Hat geklappt mit Kopie von influxd.bolt! Super Danke 🙂

@toki1973 InfluxDB 1.x benötigt keinen Token
https://github.com/simatec/ioBroker.backitup/wiki/ioBroker.backitup-Wiki-Deutsch#influxdb-backup

@marc-berg said in Backup Influxdb 2.6.1 funktioniert nicht:

@christianm

Da ist kein Operator-Token drin. Du hast den originalen also gelöscht (oder den User dazu) und die Anleitung zum Erstellen eines neuen nicht korrekt durchgeführt.

Influxdb und ich werden nicht mehr Freunde,
was hat er denn jetzt schon wieder für Probleme?

dd4837cf-63a4-412f-a723-c0337c45a1cf-grafik.png