Influxdb restore geht nicht.
-
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.temperatureIn Grafana kann ich auch was auswählen.
Es wird aber nichts angezeigt
Die Datenbank wurde auch verbunden wie es scheint
Kann der Fehler an einem falschen Passwort liegen?
-
@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.
-
@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 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.
-
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] 0Dann 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 -
Die Influx Einstellungen im Backitup Adapter sehen so aus.
Alte Datenbank löschen wurde ausgewählt
-
@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.
-
@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.
-
Siehe ein Post vorher.
Der Haken wurde gesetzt -
Datenbank hier gelöscht. Error erscheint trotzdem im Restore.
Wie lösche ich die Datenbank manuel und der shell?
-
@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>' -
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 > -
@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.
-
@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!
Es kann manchmal so einfach sein!
Vielen Dank!!!
-
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 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!
