Influxdb restore geht nicht.
-
@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!
