Influxdb restore geht nicht.

Thomas Braun

@bill-s-preston sagte in Influxdb restore geht nicht.:

Wie bekomme ich auf das neue System ebenfalls 6.6.1 ?

Mit deinem Paketmanager? Wie immer unter Linux/Debian. Man installiert i.d.R. nicht irgendwas von irgendwoher, wenn man das auch aus seinen Repos ziehen kann. Was meinst denn du, warum du die beiden Quellen gerade ziehen solltest?

sudo apt install grafana=6.6.1

Auch wenn ich vermute, das es nicht an der Version hängt, sondern an dem noch nicht richtig eingespielten Backup der Datenquelle.

Bill S. Preston

@thomas-braun

Es scheint so als ob die daten alle da sind

herke@raspberrypi:~ $ influx
Connected to http://localhost:8086 version 1.8.10
InfluxDB shell version: 1.8.10
> show databases
name: databases
name
----
_internal
iobroker
> list all databases
ERR: error parsing query: found list, expected SELECT, DELETE, SHOW, CREATE, DROP, EXPLAIN, GRANT, REVOKE, ALTER, SET, KILL at line 1, char 1
Warning: It is possible this error is due to not setting a database.
Please set a database with the command "use <database>".
> show databases
name: databases
name
----
_internal
iobroker
> show measurements
ERR: database name required
Warning: It is possible this error is due to not setting a database.
Please set a database with the command "use <database>".
> use iobroker
Using database iobroker
> show measurements
name: measurements
name
----
0_userdata.0.Gasverbrauch.Gaskosten.Gaskosten_Jahr
0_userdata.0.Gasverbrauch.Gaskosten.Gaskosten_Monat
0_userdata.0.Gasverbrauch.Gaskosten.Gaskosten_Tag
0_userdata.0.Gasverbrauch.Gaskosten.Gaskosten_Woche
0_userdata.0.Gasverbrauch.Gasverbrauch_Jahr
0_userdata.0.Gasverbrauch.Gasverbrauch_Jahr_in_kwh
0_userdata.0.Gasverbrauch.Gasverbrauch_Monat
0_userdata.0.Gasverbrauch.Gasverbrauch_Monat_in_kwh
0_userdata.0.Gasverbrauch.Gasverbrauch_Stündlich
0_userdata.0.Gasverbrauch.Gasverbrauch_Tag
0_userdata.0.Gasverbrauch.Gasverbrauch_Tag_in_kwh
0_userdata.0.Gasverbrauch.Gasverbrauch_Woche
0_userdata.0.Gasverbrauch.Gasverbrauch_Woche_in_kwh
0_userdata.0.Stromvebrauch.Geschirrspüler.Geschirrspüler_Kosten_Tag
0_userdata.0.Stromvebrauch.Geschirrspüler.Geschirrspüler_Verbrauch_Jahr
0_userdata.0.Stromvebrauch.Geschirrspüler.Geschirrspüler_Verbrauch_Monat
0_userdata.0.Stromvebrauch.Geschirrspüler.Geschirrspüler_Verbrauch_Woche
0_userdata.0.Stromvebrauch.Geschirrspüler.Geschirspüler_Verbrauch
0_userdata.0.Stromvebrauch.Stromkosten.Stromkosten_Jahr
0_userdata.0.Stromvebrauch.Stromkosten.Stromkosten_Monat
0_userdata.0.Stromvebrauch.Stromkosten.Stromkosten_Tag
0_userdata.0.Stromvebrauch.Stromkosten.Stromkosten_Woche
0_userdata.0.Stromvebrauch.Stromverbrauch_Jahr
0_userdata.0.Stromvebrauch.Stromverbrauch_Monat
0_userdata.0.Stromvebrauch.Stromverbrauch_Tag
0_userdata.0.Stromvebrauch.Stromverbrauch_Woche
0_userdata.0.Wasserverbrauch.Wasserverbrauch_Jahr
0_userdata.0.Wasserverbrauch.Wasserverbrauch_Monat
0_userdata.0.Wasserverbrauch.Wasserverbrauch_Tag
0_userdata.0.Wasserverbrauch.Wasserverbrauch_Woche
fullybrowser.0.192_168_178_46.Info.batteryLevel
hm-rpc.1.0001DA49A3412A.6.CURRENT
hm-rpc.1.0001DA49A3412A.6.ENERGY_COUNTER
hm-rpc.1.0001DA49A3412A.6.POWER
hm-rpc.1.000A18A9A302A1.1.LEVEL
hm-rpc.1.000A18A9A302A1.1.SET_POINT_TEMPERATURE
hm-rpc.1.000A18A9A8058A.1.LEVEL
hm-rpc.1.000A1BE9A2971B.1.ACTUAL_TEMPERATURE
hm-rpc.1.000A1BE9A2971B.1.LEVEL
hm-rpc.1.000A9A49969BB9.1.ACTUAL_TEMPERATURE
hm-rpc.1.000A9A49969BB9.1.HUMIDITY
hm-rpc.1.000A9A49969BC0.1.ACTUAL_TEMPERATURE
hm-rpc.1.000A9A49969BC0.1.HUMIDITY
hm-rpc.1.000A9A49995473.1.ACTUAL_TEMPERATURE
hm-rpc.1.000A9A49995473.1.HUMIDITY
hm-rpc.1.002A1BE9A78ADE.0.OPERATING_VOLTAGE
hm-rpc.1.0031DD89994601.1.CURRENT_ILLUMINATION
hm-rpc.1.0031DD89994601.1.ILLUMINATION
hm-rpc.3.MEQ0546462.4.ACTUAL_TEMPERATURE
hm-rpc.3.MEQ0546462.4.SET_TEMPERATURE
hm-rpc.3.MEQ0546462.4.VALVE_STATE
hm-rpc.3.SEQ1374828.1.IEC_ENERGY_COUNTER
hm-rpc.3.SEQ1374828.1.IEC_POWER
javascript.0.Außenthermometer.Außentemperatur
javascript.0.Außenthermometer.Luftfeuchtigkeit_Außen
javascript.0.Entfeuchter_Tagesverbrauch
javascript.0.Entfeuchter_Zähler_an/aus
javascript.0.Gas.BrennerAktiv
javascript.0.Gas.Brennerlaufzeit
javascript.0.Gas.Brennerstarts
javascript.0.Gas.Leistung
javascript.0.Gas.Verbrauch_Energie
javascript.0.Gas.Verbrauch_Volumen
javascript.0.Gasverbrauch.Gas_Jährlich
javascript.0.Gasverbrauch.Gas_Monatlich
javascript.0.Gasverbrauch.Gas_Stündlich_Zähler
javascript.0.Gasverbrauch.Gas_Woche
javascript.0.Gasverbrauch.Gas_heute
javascript.0.Gasverbrauch.Gasverbrauch_täglich_NEU
javascript.0.Luftentfeuchter_Verbrauch_Täglich
javascript.0.Nacht_für_Grafana
javascript.0.Neue_Aufzeichnung_für_Helligkeit.Current_Illumination
javascript.0.Neue_Aufzeichnung_für_Helligkeit.Illumintion
javascript.0.Regenmenge.Regenmenge_Jahr
javascript.0.Regenmenge.Regenmenge_Monat
javascript.0.Regenmenge.Regenmenge_Stunde
javascript.0.Regenmenge.Regenmenge_Tag
javascript.0.Regenmenge.Regenmenge_Woche
javascript.0.Stromverbrauch.Jahr.Verbrauch_Jahr_Neu
javascript.0.Stromverbrauch.Monat.Kosten_Monat
javascript.0.Stromverbrauch.Monat.Verbrauch_Monat
javascript.0.Stromverbrauch.Preis_kW/h
javascript.0.Stromverbrauch.Tag.Kosten_Tag
javascript.0.Stromverbrauch.Tag.Verbrauch_Tag
javascript.0.Stromverbrauch.Trockner.Trockner_Jahr_2021
javascript.0.Stromverbrauch.Trockner.Trockner_Jahr_2022
javascript.0.Stromverbrauch.Trockner.Trockner_Kosten_Tag
javascript.0.Stromverbrauch.Zwischenstecker.Kosten_Tag
javascript.0.Stromverbrauch.Zwischenstecker.Verbrauch_Tag
javascript.0.Stromverbrauch.Zählerstand_per_Script
javascript.0.Wasserzähler.Gestern
javascript.0.Wasserzähler.Heute
javascript.0.Wasserzähler.Jährlich
javascript.0.Wasserzähler.Letztes_Jahr
javascript.0.Wasserzähler.Monatlich
javascript.0.Wasserzähler.Wöchentlich
javascript.0.Wasserzähler.Wöchentlich2
javascript.0.Xiomi_Thermometer_Dachboden.Luftfeuchtigkeit
javascript.0.Xiomi_Thermometer_Dachboden.Temperatur
openweathermap.0.forecast.current.humidity
openweathermap.0.forecast.current.temperature
shelly.0.SHWT-1#AC5BEF#1.rssi
shelly.0.SHWT-1#AC5BEF#1.sensor.battery
shelly.0.SHWT-1#C8AA8B#1.rssi
shelly.0.SHWT-1#C8AA8B#1.sensor.battery
sonoff.0.Gosund1.ENERGY_Power
sonoff.0.Gosund1.ENERGY_Today
sonoff.0.Gosund1.ENERGY_Total
sonoff.0.Gosund3.ENERGY_ApparentPower
sonoff.0.Gosund3.ENERGY_Current
sonoff.0.Gosund3.ENERGY_Factor
sonoff.0.Gosund3.ENERGY_Power
sonoff.0.Gosund3.ENERGY_ReactivePower
sonoff.0.Gosund4.ENERGY_Power
sonoff.0.Gosund4.ENERGY_Today
sonoff.0.Gosund4.ENERGY_Yesterday
worx.0.2022302672080000094F.mower.batteryChargeCycle
worx.0.2022302672080000094F.mower.batteryState
worx.0.2022302672080000094F.mower.batteryTemperature
worx.0.2022302672080000094F.mower.batteryVoltage
worx.0.2022302672080000094F.mower.totalBladeTime
worx.0.2022302672080000094F.mower.totalDistance
worx.0.2022302672080000094F.rawMqtt.battery_charge_cycles
worx.0.2022302672080000094F.rawMqtt.blade_work_time
zigbee.1.00158d00058a6353.humidity
zigbee.1.00158d00058a6353.temperature
zigbee.1.00158d00058ca467.humidity
zigbee.1.00158d00058ca467.temperature

In Grafana kann ich auch was auswählen.
Es wird aber nichts angezeigt

Die Datenbank wurde auch verbunden wie es scheint

.mölkm.jpg

Kann der Fehler an einem falschen Passwort liegen?

Thomas Braun

@bill-s-preston sagte in Influxdb restore geht nicht.:

Kann der Fehler an einem falschen Passwort liegen?

Influxdb operiert soweit ich das weiß mit Tokens. Kann dir aber @Marc-Berg vielleicht besser was zu sagen, ich verwende kein influxdb.

Marc Berg

@bill-s-preston sagte in Influxdb restore geht nicht.:

Kann der Fehler an einem falschen Passwort liegen?

Nein. Wenn der Test grün ist, passt das.

Kann es sein, dass nach deinem Restore (eines älteren Backups) in den letzten 6 Stunden keine Daten stecken?

Bill S. Preston

@marc-berg

Backup wurde gestern abend erstellt.

Marc Berg

@bill-s-preston sagte in Influxdb restore geht nicht.:

Backup wurde gestern abend erstellt.

Hast du ein Log vom erfolgreich durchgeführten Restore? Die Daten, die zu sehen sind, scheinen ja nur die neu hinzugekommenen zu sein.

Bill S. Preston

@marc-berg

Hier der Log vom erstellten Backup

Started iobroker ...
[DEBUG] [iobroker] - host.iobroker 10121 states saved

[DEBUG] [iobroker] - host.iobroker 11718 objects saved

[DEBUG] [iobroker] - Backup created: /opt/iobroker/backups/iobroker_2024_05_05-10_46_32_backupiobroker.tar.gz

[DEBUG] [iobroker] - done
[DEBUG] [influxDB] - InfluxDB-Backup started ...
[DEBUG] [influxDB] - Start InfluxDB Backup ...
[DEBUG] [influxDB] - InfluxDB Backup tmp directory created 
[DEBUG] [influxDB] - Packed 51MB so far...
[DEBUG] [influxDB] - Packed 103MB so far...
[DEBUG] [influxDB] - Packed 110MB so far...
[DEBUG] [influxDB] - Packed 157MB so far...
[DEBUG] [influxDB] - Packed 204MB so far...
[DEBUG] [influxDB] - Packed 205MB so far...
[DEBUG] [influxDB] - Packed 243MB so far...
[DEBUG] [influxDB] - Packed 290MB so far...
[DEBUG] [influxDB] - Packed 320MB so far...
[DEBUG] [influxDB] - Packed 339MB so far...
[DEBUG] [influxDB] - Packed 373MB so far...
[DEBUG] [influxDB] - Packed 396MB so far...
[DEBUG] [influxDB] - Packed 397MB so far...
[DEBUG] [influxDB] - Packed 443MB so far...
[DEBUG] [influxDB] - Packed 485MB so far...
[DEBUG] [influxDB] - Backup created: /opt/iobroker/backups/influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [influxDB] - Try deleting the InfluxDB tmp directory: "/opt/iobroker/backups/influxDB_2024_05_05-10_46_48_backupiobroker"
[DEBUG] [influxDB] - InfluxDB tmp directory "/opt/iobroker/backups/influxDB_2024_05_05-10_46_48_backupiobroker" successfully deleted
[DEBUG] [influxDB] - InfluxDB-Backup for is finish
[DEBUG] [influxDB] - done
[DEBUG] [zigbee] - found zigbee database: zigbee.0,zigbee.1
[DEBUG] [zigbee] - done
[DEBUG] [grafana] - Start Grafana Backup ...
[DEBUG] [grafana] - Created grafana_tmp directory: "/opt/iobroker/backups/grafana_tmp"
[DEBUG] [grafana] - Created dashboard directory
[DEBUG] [grafana] - Created dashboards_manually_restore directory
[DEBUG] [grafana] - Created datasource directory
[DEBUG] [grafana] - start Grafana request ...
[DEBUG] [grafana] - Grafana is available ... Status: 200
[DEBUG] [grafana] - found Dashboard: hausubersicht
[DEBUG] [grafana] - start Grafana backup compress ...
[DEBUG] [grafana] - Backup created: /opt/iobroker/backups/grafana_2024_05_05-10_52_18_backupiobroker.tar.gz
[DEBUG] [grafana] - Try deleting the Grafana tmp directory: "/opt/iobroker/backups/grafana_tmp"
[DEBUG] [grafana] - Grafana tmp directory "/opt/iobroker/backups/grafana_tmp" successfully deleted
[DEBUG] [grafana] - done
[DEBUG] [onedrive] - Onedrive: Copy iobroker_2024_05_05-10_46_32_backupiobroker.tar.gz...
[DEBUG] [onedrive] - 8% uploaded from iobroker_2024_05_05-10_46_32_backupiobroker.tar.gz
[DEBUG] [onedrive] - 17% uploaded from iobroker_2024_05_05-10_46_32_backupiobroker.tar.gz
[DEBUG] [onedrive] - 25% uploaded from iobroker_2024_05_05-10_46_32_backupiobroker.tar.gz
[DEBUG] [onedrive] - 33% uploaded from iobroker_2024_05_05-10_46_32_backupiobroker.tar.gz
[DEBUG] [onedrive] - 41% uploaded from iobroker_2024_05_05-10_46_32_backupiobroker.tar.gz
[DEBUG] [onedrive] - 50% uploaded from iobroker_2024_05_05-10_46_32_backupiobroker.tar.gz
[DEBUG] [onedrive] - 58% uploaded from iobroker_2024_05_05-10_46_32_backupiobroker.tar.gz
[DEBUG] [onedrive] - 66% uploaded from iobroker_2024_05_05-10_46_32_backupiobroker.tar.gz
[DEBUG] [onedrive] - 75% uploaded from iobroker_2024_05_05-10_46_32_backupiobroker.tar.gz
[DEBUG] [onedrive] - 83% uploaded from iobroker_2024_05_05-10_46_32_backupiobroker.tar.gz
[DEBUG] [onedrive] - 91% uploaded from iobroker_2024_05_05-10_46_32_backupiobroker.tar.gz
[DEBUG] [onedrive] - 99% uploaded from iobroker_2024_05_05-10_46_32_backupiobroker.tar.gz
[DEBUG] [onedrive] - 100% uploaded from iobroker_2024_05_05-10_46_32_backupiobroker.tar.gz
[DEBUG] [onedrive] - iobroker_2024_05_05-10_46_32_backupiobroker.tar.gz with Id: 88074934BF049F84!156199 saved on Onedrive
[DEBUG] [onedrive] - Onedrive: Copy influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz...
[DEBUG] [onedrive] - 0% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 1% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 2% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 3% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 4% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 5% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 6% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 7% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 8% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 9% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 10% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 11% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 12% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 13% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 14% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 15% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 16% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 17% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 18% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 19% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 20% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 21% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 22% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 23% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 24% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 25% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 26% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 27% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 28% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 29% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 30% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 31% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 32% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 33% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 34% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 35% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 36% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 37% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 38% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 39% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 40% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 41% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 42% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 43% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 44% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 45% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 46% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 47% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 48% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 49% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 50% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 51% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 52% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 53% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 54% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 55% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 56% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 57% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 58% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 59% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 60% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 61% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 62% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 63% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 64% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 65% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 66% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 67% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 68% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 69% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 70% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 71% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 72% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 73% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 74% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 75% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 76% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 77% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 78% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 79% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 80% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 81% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 82% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 83% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 84% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 85% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 86% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 87% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 88% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 89% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 90% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 91% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 92% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 93% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 94% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 95% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 96% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 97% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 98% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 99% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - 100% uploaded from influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz
[DEBUG] [onedrive] - influxDB_2024_05_05-10_46_48_backupiobroker.tar.gz with Id: 88074934BF049F84!156200 saved on Onedrive
[DEBUG] [onedrive] - Onedrive: Copy zigbee.0_2024_05_05-10_52_15_backupiobroker.tar.gz...
[DEBUG] [onedrive] - 100% uploaded from zigbee.0_2024_05_05-10_52_15_backupiobroker.tar.gz
[DEBUG] [onedrive] - zigbee.0_2024_05_05-10_52_15_backupiobroker.tar.gz with Id: 88074934BF049F84!156201 saved on Onedrive
[DEBUG] [onedrive] - Onedrive: Copy zigbee.1_2024_05_05-10_52_15_backupiobroker.tar.gz...
[DEBUG] [onedrive] - 100% uploaded from zigbee.1_2024_05_05-10_52_15_backupiobroker.tar.gz
[DEBUG] [onedrive] - zigbee.1_2024_05_05-10_52_15_backupiobroker.tar.gz with Id: 88074934BF049F84!156202 saved on Onedrive
[DEBUG] [onedrive] - Onedrive: Copy grafana_2024_05_05-10_52_18_backupiobroker.tar.gz...
[DEBUG] [onedrive] - 100% uploaded from grafana_2024_05_05-10_52_18_backupiobroker.tar.gz
[DEBUG] [onedrive] - grafana_2024_05_05-10_52_18_backupiobroker.tar.gz with Id: 88074934BF049F84!156203 saved on Onedrive
[DEBUG] [onedrive] - done
[DEBUG] [clean] - No older backup files are deleted, because this backup was started manually
[DEBUG] [clean] - done
[DEBUG] [historyHTML] - new history html values created
[DEBUG] [historyHTML] - done
[DEBUG] [historyJSON] - new history json values created
[DEBUG] [historyJSON] - done
[EXIT] 0

Dann das erstellte Backup via FileZilla in den Iobroker Backupordner gepackt

Dann im neuen System das Restore durchgeführt

Und hier der Log vom Restore

Started restore ...
[DEBUG] [influxDB] - Created tmp directory
[DEBUG] [influxDB] - Start infuxDB Restore ...
[DEBUG] [influxDB] - influxdb.0 is stopped
[ERROR] [influxDB] - 2024/05/05 10:07:50 error updating meta: DB metadata not changed. database may already exist
restore: DB metadata not changed. database may already exist

[DEBUG] [influxDB] - Try deleting the InfluxDB tmp directory
[DEBUG] [influxDB] - InfluxDB tmp directory was successfully deleted
[DEBUG] [influxDB] - infuxDB Restore completed successfully
[EXIT] influxDB restore done
[DEBUG] [influxDB] - influxdb.0 started

Bill S. Preston

Die Influx Einstellungen im Backitup Adapter sehen so aus.
Alte Datenbank löschen wurde ausgewählt

Marc Berg

@bill-s-preston sagte in Influxdb restore geht nicht.:

[ERROR] [influxDB] - 2024/05/05 10:07:50 error updating meta: DB metadata not changed. database may already exist

Computer sagt "Error".

Ein Restore funktioniert nur, wenn vorher die Datenbank leer war. Die Datenbank also vorher löschen und verhindern, dass sofort wieder Daten über den Adapter reinfliegen.

In den Backitup Einstellungen gibt es einen Punkt "DB vor dem Restore löschen" oder so. Der funktioniert unter InfluxDB 2.x nicht, aber unter 1.x sollte es laufen.

Marc Berg

@bill-s-preston sagte in Influxdb restore geht nicht.:

Alte Datenbank löschen wurde ausgewählt

Dann geht es wohl unter 1.x auch nicht. Dann musst du die DB manuell z.B. in den Instanzeinstellungen löschen.

Bill S. Preston

@marc-berg

Siehe ein Post vorher.
Der Haken wurde gesetzt

Bill S. Preston

@marc-berg

Datenbank hier gelöscht. Error erscheint trotzdem im Restore.

Wie lösche ich die Datenbank manuel und der shell?

Marc Berg

@bill-s-preston sagte in Influxdb restore geht nicht.:

Wie lösche ich die Datenbank manuel und der shell?

Mein Google sagt:

influx -execute 'DROP DATABASE <database_name>'

Bill S. Preston

Wenn ich direkt nach dem Löschen der Datenbank mittels Backitupadapter die Datenbank lösche in Influx nach Datenbanken suche, wird "iobroker" nicht mehr angezeigt.

herke@raspberrypi:~ $ influx
Connected to http://localhost:8086 version 1.8.10
InfluxDB shell version: 1.8.10
> show databases
name: databases
name
----
_internal
>

Wenn ich mich mit Putty neu im System anmelde, dann ist sie wieder da.


herke@raspberrypi:~ $ influx
Connected to http://localhost:8086 version 1.8.10
InfluxDB shell version: 1.8.10
> show databases
name: databases
name
----
_internal
iobroker
>

Marc Berg

@bill-s-preston sagte in Influxdb restore geht nicht.:

Wenn ich mich mit Putty neu im System anmelde, dann ist sie wieder da.

Ich gehe davon aus, dass du den/die InfluxDB-Instanz(en)nicht gestoppt hast? Dann fliegen natürlich sofort wieder Daten rein und die DB wird automatisch angelegt.

Bill S. Preston

@marc-berg said in Influxdb restore geht nicht.:

@bill-s-preston sagte in Influxdb restore geht nicht.:

Wenn ich mich mit Putty neu im System anmelde, dann ist sie wieder da.

Ich gehe davon aus, dass du den/die InfluxDB-Instanz(en)nicht gestoppt hast? Dann fliegen natürlich sofort wieder Daten rein und die DB wird automatisch angelegt.

Das war es! :+1:

Es kann manchmal so einfach sein!

Vielen Dank!!!

Bill S. Preston

Ein Problem jagt das Nächste!

Ich habe gestern ein Raspberrymatic Update durchgeführt und nun habe ich in meinen Verbräuchen einen utopisch hohen Wert drin.
Kann man einzelne aus influx löschen?

Bill S. Preston

@bill-s-preston said in Influxdb restore geht nicht.:

Ein Problem jagt das Nächste!

Ich habe gestern ein Raspberrymatic Update durchgeführt und nun habe ich in meinen Verbräuchen einen utopisch hohen Wert drin.
Kann man einzelne aus influx löschen?

Liegt wohl an einer neu gestartetet Variablen in einem Script nach dem Restore.
Meine Vebrauchsscripte scheinen nicht sicher vor "Einwirkungen von Außen" zu sein.

Backup und Restore funktioniert auf jeden Fall.
Vielen Dank nochmal!

Community Forum

NEWS

Influxdb restore geht nicht.

Support us

871

32.6k

82.2k

1.3m