NEWS
Zwei Bugs mit backitup 2.1.0 und 2.0.5
-
Systemdata Bitte Ausfüllen Hardwaresystem: NUC Arbeitsspeicher: 16GB Festplattenart: SSD Betriebssystem: Ubuntu 20.04.1 Node-Version: 12.20.0 Nodejs-Version: 12.20.0 NPM-Version: 6.14.8 Installationsart: Skript Image genutzt: Nein Guten Morgen zusammen,
ich bekomme seit ein paar Tagen Fehler beim Erstellen meines MySQL Backups via backitup 2.1.0 (habe ich heute früh testweise von 2.0.5 aktualisiert).
[ERROR] [mysql] - [IGNORED] Error: Command failed: mysqldump -u iobrokerAdmin -p**** iobroker -h mysql -P 3306 --quick > /opt/iobroker/backups/mysql_2021_04_02-08_59_13_backupiobroker.sql mysqldump: [Warning] Using a password on the command line interface can be insecure. mysqldump: Couldn't execute 'SELECT COLUMN_NAME, JSON_EXTRACT(HISTOGRAM, '$."number-of-buckets-specified"') FROM information_schema.COLUMN_STATISTICS WHERE SCHEMA_NAME = 'iobroker' AND TABLE_NAME = 'datapoints';': Unknown table 'COLUMN_STATISTICS' in information_schema (1109)
Außerdem wird im Log noch folgender Fehler gemeldet:
backitup.0 2021-04-02 08:49:59.659 error (3289408) [iobroker] Backup folder not created: Error: EPERM: operation not permitted, chmod '/opt/iobroker/backups'Please reinstall backitup and run "iobroker fix"!!
iobroker fix habe ich ausgeführt, aber die Meldung erscheint trotzdem.
So wie ich das verstehe sollte der Fehler geprüft und nicht ignoriert werden.Kann mir jemand bei der Analyse/Behebung der Fehler helfen?
Viele Grüße,
Bastian -
@buddinski88
Wie sehen denn die Rechte an dem Verzeichnis jetzt aus?getfacl /opt/iobroker/backups
-
@thomas-braun, danke für deine Frage. Die Rechte sind wie folgt.
buddy@iobroker-prod:~$ getfacl /opt/iobroker/backups getfacl: Removing leading '/' from absolute path names # file: opt/iobroker/backups # owner: iobroker # group: iobroker user::rwx group::r-x group:iobroker:rwx mask::rwx other::r-x default:user::rwx default:group::r-x default:group:iobroker:rwx default:mask::rwx default:other::r-x
-
@buddinski88 Rechte passen eigentlich.
-
@thomas-braun, das ist ja schon mal etwas. Dann ist der die Meldung aber umso interessanter
Solche Fehler sind mir "besonders lieb"... -
@buddinski88 sagte in Zwei Bugs mit backitup 2.1.0 und 2.0.5:
Couldn't execute 'SELECT COLUMN_NAME
mySQL Fehler, hat erstmal nichts mit ioBroker zu tun.
Mal beides ausgeführt was im Log steht:
@buddinski88 sagte in Zwei Bugs mit backitup 2.1.0 und 2.0.5:
'Please reinstall backitup and run "iobroker fix"!!
-
@wendy2702 das habe ich beides schon gemacht. Hatte heute morgen 2.0.5 am laufen und hab dieses deinstalliert. Anschließend 2.1.0 installiert und iobroker fix ausgeführt.
Ergebnis ist das im ersten Beitrag beschriebene -
@buddinski88 kannst du mal das komplette Log vom Backupitup adapter im Debug mode posten.
-
@wendy2702, klar gerne. Hab eben den Debugmodus aktiviert und anbei das Log.
backitup.0 2021-04-02 14:21:33.253 debug (283789) [iobroker] exec: done backitup.0 2021-04-02 14:21:33.101 debug (283789) [iobroker/umount] done backitup.0 2021-04-02 14:21:33.100 debug (283789) [iobroker/umount] umount successfully completed backitup.0 2021-04-02 14:21:28.069 debug (283789) [iobroker/umount] mount activ, umount is started ... backitup.0 2021-04-02 14:21:27.906 debug (283789) [iobroker/historyJSON] done backitup.0 2021-04-02 14:21:27.905 debug (283789) [iobroker/historyJSON] new history json values created backitup.0 2021-04-02 14:21:27.747 debug (283789) [iobroker/historyHTML] done backitup.0 2021-04-02 14:21:27.746 debug (283789) [iobroker/historyHTML] new history html values created backitup.0 2021-04-02 14:21:27.290 debug (283789) [iobroker/pushover] done backitup.0 2021-04-02 14:21:27.289 debug (283789) sendTo "send" to system.adapter.pushover.1 from system.adapter.backitup.0 backitup.0 2021-04-02 14:21:26.977 debug (283789) [iobroker/clean] done backitup.0 2021-04-02 14:21:26.977 debug (283789) [iobroker/clean] Backup files not deleted from /opt/iobroker/backups because some errors. backitup.0 2021-04-02 14:21:26.374 debug (283789) [iobroker/cifs] done backitup.0 2021-04-02 14:21:25.619 debug (283789) [iobroker/grafana] done backitup.0 2021-04-02 14:21:25.619 debug (283789) [iobroker/grafana] Grafana tmp directory "/opt/iobroker/backups/grafana_tmp" successfully deleted backitup.0 2021-04-02 14:21:24.845 debug (283789) [iobroker/grafana] Try deleting the Grafana tmp directory: "/opt/iobroker/backups/grafana_tmp" backitup.0 2021-04-02 14:21:24.844 debug (283789) [iobroker/grafana] Backup created: /opt/iobroker/backups/grafana_2021_04_02-14_21_19_backupiobroker.tar.gz backitup.0 2021-04-02 14:21:19.580 debug (283789) [iobroker/grafana] start Grafana backup compress ... backitup.0 2021-04-02 14:21:19.579 debug (283789) [iobroker/grafana] found Dashboard: system backitup.0 2021-04-02 14:21:19.576 debug (283789) [iobroker/grafana] found Dashboard: fritz-box-router-status backitup.0 2021-04-02 14:21:19.565 debug (283789) [iobroker/grafana] found Dashboard: heizung backitup.0 2021-04-02 14:21:19.556 debug (283789) [iobroker/grafana] found Dashboard: octoprint backitup.0 2021-04-02 14:21:19.520 debug (283789) [iobroker/grafana] found Dashboard: proxmox backitup.0 2021-04-02 14:21:19.492 debug (283789) [iobroker/grafana] found Dashboard: homematic backitup.0 2021-04-02 14:21:19.251 debug (283789) [iobroker/grafana] Grafana is available ... Status: 200 backitup.0 2021-04-02 14:21:19.218 debug (283789) [iobroker/grafana] start Grafana request ... backitup.0 2021-04-02 14:21:19.217 debug (283789) [iobroker/grafana] Created datasource directory backitup.0 2021-04-02 14:21:19.214 debug (283789) [iobroker/grafana] Created dashboards_manually_restore directory backitup.0 2021-04-02 14:21:19.210 debug (283789) [iobroker/grafana] Created dashboard directory backitup.0 2021-04-02 14:21:19.205 debug (283789) [iobroker/grafana] Created grafana_tmp directory: "/opt/iobroker/backups/grafana_tmp" backitup.0 2021-04-02 14:21:19.199 debug (283789) [iobroker/grafana] Start Grafana Backup ... backitup.0 2021-04-02 14:21:19.047 debug (283789) [iobroker/zigbee] done backitup.0 2021-04-02 14:21:19.046 debug (283789) [iobroker/zigbee] found zigbee database: zigbee.0 backitup.0 2021-04-02 14:21:18.441 debug (283789) [iobroker/mysql] mysqldump: Couldn't execute 'SELECT COLUMN_NAME, JSON_EXTRACT(HISTOGRAM, '$."number-of-buckets-specified"') FROM information_schema.COLU backitup.0 2021-04-02 14:21:18.441 debug (283789) [iobroker/mysql] mysqldump: [Warning] Using a password on the command line interface can be insecure. backitup.0 2021-04-02 14:21:18.440 debug (283789) [iobroker/mysql] [IGNORED] Error: Command failed: mysqldump -u iobrokerAdmin -p**** iobroker -h mysql -P 3306 --quick > /opt/iobroker/backups/mysql_2021_04_02-14_21_18_backupiobroker.sql backitup.0 2021-04-02 14:21:18.065 debug (283789) [iobroker/iobroker] done backitup.0 2021-04-02 14:21:17.031 debug (283789) [iobroker/iobroker] Backup created: /opt/iobroker/backups/iobroker_2021_04_02-14_21_04_backupiobroker.tar.gz backitup.0 2021-04-02 14:21:07.438 debug (283789) [iobroker/iobroker] host.iobroker-prod 19358 objects saved backitup.0 2021-04-02 14:21:07.379 debug (283789) [iobroker/iobroker] host.iobroker-prod 18329 states saved backitup.0 2021-04-02 14:21:04.275 debug (283789) [iobroker/mount] done backitup.0 2021-04-02 14:21:04.273 debug (283789) [iobroker/mount] mount successfully completed backitup.0 2021-04-02 14:20:54.695 debug (283789) detect last backup file: iobroker_2021_04_02-08_58_59_backupiobroker.tar.gz backitup.0 2021-04-02 14:20:54.694 debug (283789) detect backup file 19 from cifs: iobroker_2021_04_02-08_58_59_backupiobroker.tar.gz backitup.0 2021-04-02 14:20:54.694 debug (283789) detect backup file 18 from cifs: iobroker_2021_04_02-08_50_10_backupiobroker.tar.gz backitup.0 2021-04-02 14:20:54.694 debug (283789) detect backup file 17 from cifs: iobroker_2021_04_02-08_44_33_backupiobroker.tar.gz backitup.0 2021-04-02 14:20:54.694 debug (283789) detect backup file 16 from cifs: iobroker_2021_04_02-07_28_43_backupiobroker.tar.gz backitup.0 2021-04-02 14:20:54.693 debug (283789) detect backup file 15 from cifs: iobroker_2021_04_02-07_24_05_backupiobroker.tar.gz backitup.0 2021-04-02 14:20:54.693 debug (283789) detect backup file 14 from cifs: iobroker_2021_04_02-07_04_48_backupiobroker.tar.gz backitup.0 2021-04-02 14:20:54.693 debug (283789) detect backup file 13 from cifs: iobroker_2021_04_02-00_00_21_backupiobroker.tar.gz backitup.0 2021-04-02 14:20:54.693 debug (283789) detect backup file 12 from cifs: iobroker_2021_04_01-00_00_21_backupiobroker.tar.gz backitup.0 2021-04-02 14:20:54.692 debug (283789) detect backup file 11 from cifs: iobroker_2021_03_31-00_00_21_backupiobroker.tar.gz backitup.0 2021-04-02 14:20:54.692 debug (283789) detect backup file 10 from cifs: iobroker_2021_03_30-00_00_21_backupiobroker.tar.gz backitup.0 2021-04-02 14:20:54.692 debug (283789) detect backup file 9 from cifs: iobroker_2021_03_29-00_00_21_backupiobroker.tar.gz backitup.0 2021-04-02 14:20:54.692 debug (283789) detect backup file 8 from cifs: iobroker_2021_03_28-00_00_21_backupiobroker.tar.gz backitup.0 2021-04-02 14:20:54.691 debug (283789) detect backup file 7 from cifs: iobroker_2021_03_27-00_00_21_backupiobroker.tar.gz backitup.0 2021-04-02 14:20:54.691 debug (283789) detect backup file 6 from cifs: iobroker_2021_03_26-00_00_21_backupiobroker.tar.gz backitup.0 2021-04-02 14:20:54.691 debug (283789) detect backup file 5 from cifs: iobroker_2021_03_25-00_00_21_backupiobroker.tar.gz backitup.0 2021-04-02 14:20:54.691 debug (283789) detect backup file 4 from cifs: iobroker_2021_03_24-00_00_22_backupiobroker.tar.gz backitup.0 2021-04-02 14:20:54.691 debug (283789) detect backup file 3 from cifs: iobroker_2021_03_23-00_00_21_backupiobroker.tar.gz backitup.0 2021-04-02 14:20:54.690 debug (283789) detect backup file 2 from cifs: iobroker_2021_03_22-00_00_21_backupiobroker.tar.gz backitup.0 2021-04-02 14:20:54.690 debug (283789) detect backup file 1 from cifs: iobroker_2021_03_21-00_00_21_backupiobroker.tar.gz backitup.0 2021-04-02 14:20:54.092 debug (283789) [iobroker/mount] umount successfully completed backitup.0 2021-04-02 14:20:54.049 debug (283789) [iobroker/mount] mount activ... umount is started before mount!! backitup.0 2021-04-02 14:20:54.040 debug (283789) Backup has started ... backitup.0 2021-04-02 14:20:54.029 error (283789) [iobroker] Backup folder not created: Error: EPERM: operation not permitted, chmod '/opt/iobroker/backups'Please reinstall backitup and run "iobroker fix"!! backitup.0 2021-04-02 14:20:51.862 debug (283789) mount successfully completed backitup.0 2021-04-02 14:20:51.392 debug (283789) telegram-instance: backitup.0 2021-04-02 14:20:50.206 info (283789) [ccu] backup was activated at 01:30 every 3 day(s) backitup.0 2021-04-02 14:20:50.184 info (283789) [iobroker] backup was activated at 02:40 every 1 day(s) backitup.0 2021-04-02 14:20:50.117 info (283789) starting. Version 2.1.0 in /opt/iobroker/node_modules/iobroker.backitup, node: v12.20.0, js-controller: 3.2.16 backitup.0 2021-04-02 14:20:50.107 info (283789) Plugin sentry Sentry Plugin disabled for this process because sending of statistic data is disabled for the system backitup.0 2021-04-02 14:20:50.104 debug (283789) Plugin sentry Initialize Plugin (enabled=true) backitup.0 2021-04-02 14:20:49.215 debug (283789) statesDB connected backitup.0 2021-04-02 14:20:49.215 debug (283789) States connected to redis: 127.0.0.1:9000 backitup.0 2021-04-02 14:20:49.199 debug (283789) States create User PubSub Client backitup.0 2021-04-02 14:20:49.198 debug (283789) States create System PubSub Client backitup.0 2021-04-02 14:20:49.162 debug (283789) Redis States: Use Redis connection: 127.0.0.1:9000 backitup.0 2021-04-02 14:20:49.160 debug (283789) objectDB connected backitup.0 2021-04-02 14:20:49.154 debug (283789) Objects connected to redis: 127.0.0.1:9001 backitup.0 2021-04-02 14:20:49.138 debug (283789) Objects client initialize lua scripts backitup.0 2021-04-02 14:20:49.138 debug (283789) Objects create User PubSub Client backitup.0 2021-04-02 14:20:49.137 debug (283789) Objects create System PubSub Client backitup.0 2021-04-02 14:20:49.136 debug (283789) Objects client ready ... initialize now backitup.0 2021-04-02 14:20:49.114 debug (283789) Redis Objects: Use Redis connection: 127.0.0.1:9001 backitup.0 2021-04-02 14:20:44.432 info (3546) Terminated (ADAPTER_REQUESTED_TERMINATION): Without reason backitup.0 2021-04-02 14:20:44.431 info (3546) terminating backitup.0 2021-04-02 14:20:44.430 info (3546) cleaned everything up... backitup.0 2021-04-02 14:20:44.429 info (3546) Got terminate signal TERMINATE_YOURSELF
-
@buddinski88
Stelle mal zum testen den mount aus und erstelle das Backup mal lokal.
So wie ich das sehe, passt irgendwas mit deinen Rechten auf dem NAS nicht
Das würde auch erklären, warum Backitup auf dem NAS die alten Files nicht löschen kann -
@simatec danke das du auch mit auf die Fehler schaust.
Ich habe gerade einen Test gemacht (NAS) ist deaktiviert und Debug des Adapters an.
Leider kommen beide Fehlermeldungen immer noch:backitup.0 2021-04-02 19:35:43.969 debug (701811) [iobroker] exec: done backitup.0 2021-04-02 19:35:43.663 debug (701811) [iobroker/historyJSON] done backitup.0 2021-04-02 19:35:43.663 debug (701811) [iobroker/historyJSON] new history json values created backitup.0 2021-04-02 19:35:43.508 debug (701811) [iobroker/historyHTML] done backitup.0 2021-04-02 19:35:43.507 debug (701811) [iobroker/historyHTML] new history html values created backitup.0 2021-04-02 19:35:43.052 debug (701811) [iobroker/pushover] done backitup.0 2021-04-02 19:35:43.051 debug (701811) sendTo "send" to system.adapter.pushover.1 from system.adapter.backitup.0 backitup.0 2021-04-02 19:35:42.743 debug (701811) [iobroker/clean] done backitup.0 2021-04-02 19:35:42.742 debug (701811) [iobroker/clean] Backup files not deleted from /opt/iobroker/backups because some errors. backitup.0 2021-04-02 19:35:41.382 debug (701811) [iobroker/grafana] done backitup.0 2021-04-02 19:35:41.381 debug (701811) [iobroker/grafana] Grafana tmp directory "/opt/iobroker/backups/grafana_tmp" successfully deleted backitup.0 2021-04-02 19:35:41.369 debug (701811) [iobroker/grafana] Try deleting the Grafana tmp directory: "/opt/iobroker/backups/grafana_tmp" backitup.0 2021-04-02 19:35:41.368 debug (701811) [iobroker/grafana] Backup created: /opt/iobroker/backups/grafana_2021_04_02-19_35_36_backupiobroker.tar.gz backitup.0 2021-04-02 19:35:36.218 debug (701811) [iobroker/grafana] start Grafana backup compress ... backitup.0 2021-04-02 19:35:36.217 debug (701811) [iobroker/grafana] found Dashboard: system backitup.0 2021-04-02 19:35:36.193 debug (701811) [iobroker/grafana] found Dashboard: proxmox backitup.0 2021-04-02 19:35:36.189 debug (701811) [iobroker/grafana] found Dashboard: fritz-box-router-status backitup.0 2021-04-02 19:35:36.184 debug (701811) [iobroker/grafana] found Dashboard: octoprint backitup.0 2021-04-02 19:35:36.122 debug (701811) [iobroker/grafana] found Dashboard: heizung backitup.0 2021-04-02 19:35:36.070 debug (701811) [iobroker/grafana] found Dashboard: homematic backitup.0 2021-04-02 19:35:35.832 debug (701811) [iobroker/grafana] Grafana is available ... Status: 200 backitup.0 2021-04-02 19:35:35.786 debug (701811) [iobroker/grafana] start Grafana request ... backitup.0 2021-04-02 19:35:35.785 debug (701811) [iobroker/grafana] Created datasource directory backitup.0 2021-04-02 19:35:35.785 debug (701811) [iobroker/grafana] Created dashboards_manually_restore directory backitup.0 2021-04-02 19:35:35.784 debug (701811) [iobroker/grafana] Created dashboard directory backitup.0 2021-04-02 19:35:35.784 debug (701811) [iobroker/grafana] Created grafana_tmp directory backitup.0 2021-04-02 19:35:35.783 debug (701811) [iobroker/grafana] old grafana_tmp directory "/opt/iobroker/backups/grafana_tmp" successfully deleted backitup.0 2021-04-02 19:35:35.777 debug (701811) [iobroker/grafana] Try deleting the old grafana_tmp directory: "/opt/iobroker/backups/grafana_tmp" backitup.0 2021-04-02 19:35:35.777 debug (701811) [iobroker/grafana] Start Grafana Backup ... backitup.0 2021-04-02 19:35:35.625 debug (701811) [iobroker/zigbee] done backitup.0 2021-04-02 19:35:35.624 debug (701811) [iobroker/zigbee] found zigbee database: zigbee.0 backitup.0 2021-04-02 19:35:35.019 debug (701811) [iobroker/mysql] mysqldump: Couldn't execute 'SELECT COLUMN_NAME, JSON_EXTRACT(HISTOGRAM, '$."number-of-buckets-specified"') FROM information_schema.COLU backitup.0 2021-04-02 19:35:35.019 debug (701811) [iobroker/mysql] mysqldump: [Warning] Using a password on the command line interface can be insecure. backitup.0 2021-04-02 19:35:35.018 debug (701811) [iobroker/mysql] [IGNORED] Error: Command failed: mysqldump -u iobrokerAdmin -p**** iobroker -h mysql -P 3306 --quick > /opt/iobroker/backups/mysql_2021_04_02-19_35_34_backupiobroker.sql backitup.0 2021-04-02 19:35:34.672 debug (701811) [iobroker/iobroker] done backitup.0 2021-04-02 19:35:33.643 debug (701811) [iobroker/iobroker] Backup created: /opt/iobroker/backups/iobroker_2021_04_02-19_35_19_backupiobroker.tar.gz backitup.0 2021-04-02 19:35:23.246 debug (701811) [iobroker/iobroker] host.iobroker-prod 19372 objects saved backitup.0 2021-04-02 19:35:23.185 debug (701811) [iobroker/iobroker] host.iobroker-prod 18340 states saved backitup.0 2021-04-02 19:35:19.564 debug (701811) Backup has started ... backitup.0 2021-04-02 19:35:04.889 debug (701811) telegram-instance: backitup.0 2021-04-02 19:35:03.836 debug (701811) No backup file was found backitup.0 2021-04-02 19:35:03.828 info (701811) [ccu] backup was activated at 01:30 every 3 day(s) backitup.0 2021-04-02 19:35:03.799 info (701811) [iobroker] backup was activated at 02:40 every 1 day(s) backitup.0 2021-04-02 19:35:03.732 info (701811) starting. Version 2.1.0 in /opt/iobroker/node_modules/iobroker.backitup, node: v12.20.0, js-controller: 3.2.16 backitup.0 2021-04-02 19:35:03.723 info (701811) Plugin sentry Sentry Plugin disabled for this process because sending of statistic data is disabled for the system backitup.0 2021-04-02 19:35:03.719 debug (701811) Plugin sentry Initialize Plugin (enabled=true) backitup.0 2021-04-02 19:35:03.178 debug (701811) statesDB connected backitup.0 2021-04-02 19:35:03.177 debug (701811) States connected to redis: 127.0.0.1:9000 backitup.0 2021-04-02 19:35:03.164 debug (701811) States create User PubSub Client backitup.0 2021-04-02 19:35:03.163 debug (701811) States create System PubSub Client backitup.0 2021-04-02 19:35:03.147 debug (701811) Redis States: Use Redis connection: 127.0.0.1:9000 backitup.0 2021-04-02 19:35:03.145 debug (701811) objectDB connected backitup.0 2021-04-02 19:35:03.136 debug (701811) Objects connected to redis: 127.0.0.1:9001 backitup.0 2021-04-02 19:35:03.112 debug (701811) Objects client initialize lua scripts backitup.0 2021-04-02 19:35:03.111 debug (701811) Objects create User PubSub Client backitup.0 2021-04-02 19:35:03.110 debug (701811) Objects create System PubSub Client backitup.0 2021-04-02 19:35:03.084 debug (701811) Objects client ready ... initialize now backitup.0 2021-04-02 19:35:02.953 debug (701811) Redis Objects: Use Redis connection: 127.0.0.1:9001
-
@buddinski88
Das liegt aber nicht an Backitup.
Backitup verwendet die mysqldump und den originalen Backup Prozess von mysql.
Deine Datenbank hat ein Problem.backitup.0 2021-04-02 19:35:35.019 debug (701811) [iobroker/mysql] mysqldump: Couldn't execute 'SELECT COLUMN_NAME, JSON_EXTRACT(HISTOGRAM, '$."number-of-buckets-specified"') FROM information_schema.COLU
Schaue dir mal deine Datenbank genauer an.
Die zweite Meldung im clean ist die Konsequenz daraus.
Es werden keine Backups gelöscht, da die neuen Backups fehlerhaft sind. -
@simatec, guten morgen. Ich habe mir die Datenbank mal angeschaut.
Das Statement wird entweder im Log abgeschnitten oder ist falsch, denn die Tabelle COLU gibt es nicht, sondern nur COLUMNS.
Daraus ergibt sich dann folgendes Statement:SELECT COLUMN_NAME, JSON_EXTRACT(HISTOGRAM, '$."number-of-buckets-specified"') FROM information_schema.COLUMNS
Dann kommt aber schon die nächste Meldung, wenn ich das in PhpMyAdmin ausführe:
#1054 - Unbekanntes Tabellenfeld 'HISTOGRAM' in field list
Kennst du eine Möglichkeit die Datenbank zu reparieren?
-
@buddinski88 nur am Handy gesucht, passt das :
-
@buddinski88 sagte in Zwei Bugs mit backitup 2.1.0 und 2.0.5:
Kennst du eine Möglichkeit die Datenbank zu reparieren?
Servus, hast du eine machbare Reparaturmöglichkeit gefunden? Den Link von @wendy2702 habe ich mir angesehen, scheitere an meinen rudimentären mySQL sowie Englischkenntnissen. Das Tool "MySqlRepairToolbox" habe ich mir runtergeladen, kann dort aber nicht meine MariaDB 5 auf der Syno auswählen.
Oder hat irgend ein anderer WIssender die Zeit und Muße mir zu helfen?
Meine Fehlermeldung im Backitup Adapter:
BackItUp: Your backup was not completely created. Please check the errors!! mysql: Error: Command failed: mysqldump -u andreas -p**** ioBroker -h 192.168.0.98 -P 3306 --quick --single-transaction > /opt/iobroker/backups/mysql_2021_04_13-02_15_50_backupiobroker.sql /bin/sh: 1: mysqldump: not found
-
@metaxa schaue mal bitte in die Doku ...
https://github.com/simatec/ioBroker.backitup/blob/master/docs/de/backitup.md#mysql-backup
-
@simatec sagte in Zwei Bugs mit backitup 2.1.0 und 2.0.5:
schaue mal bitte in die Doku ...
Danke dir, hätte ich selbst drauf kommen können !
Nur jetzt bin ich irgendwie tiefer reingerutscht.
- "sudo apt-get install mysql-client" fehlerfrei durchgeführt
- neue Fehlermeldung:
mount: Error: Command failed: sudo mount -t cifs -o username=Andreas,password=****,rw,file_mode=0777,dir_mode=0777 //192.168.0.98/backups/io_096_vm /opt/iobroker/backups mount error(16): Device or resource busy Refer to the mount.cifs(8) manual page (e.g. man mount.cifs)
- Nachgelesen in der Doku und im Log:
(2451) [iobroker] Backup folder not created: Error: EPERM: operation not permitted, chmod '/opt/iobroker/backups'Please reinstall backitup and run "iobroker fix"!!
- BackitUp drüberinstalliert und anschließend den Fixer erfolgreich ausgeführt.
- Neue Fehlermeldung:
mysql: Error: Command failed: mysqldump -u andreas -p**** ioBroker -h 192.168.0.98 -P 3306 --quick --single-transaction > /opt/iobroker/backups/mysql_2021_04_13-13_43_34_backupiobroker.sql /bin/sh: 1: cannot create /opt/iobroker/backups/mysql_2021_04_13-13_43_34_backupiobroker.sql: Permission denied
-
Jetzt habe ich mittels WinSCP den backup Ordner angesehen und festgestellt, da sind ein Haufen backups drinnen (SQL Backups alle mit 0KB) Ich habe jetzt einmal alle Dateien gelöscht.
-
Ich komme einfach nicht weiter, hier das Log. Irgendwas darf iO irgendwo nicht
Started iobroker ... [DEBUG] [mount] - Wake on LAN wait 10 Seconds for NAS! [DEBUG] [mount] - Wake on LAN MAC-Address: 20:DE:20:DE:20:DE [DEBUG] [mount] - mount activ... umount is started before mount!! [DEBUG] [mount] - umount successfully completed [DEBUG] [mount] start with {"mountType":"NFS","type":"storage","source":"cifs","mount":"192.168.0.98","debugging":true,"fileDir":"/opt/iobroker/node_modules/iobroker.backitup","wakeOnLAN":true,"macAd":"20:DE:20:DE:20:DE","wolTime":"10","smb":"vers=1.0","sudo":true,"cifsDomain":"","deleteOldBackup":true,"ownDir":true,"bkpType":"Minimal","dir":"/volume1/backups/io_096_vm","dirMinimal":"/volume1/backups/io_096_vm","user":"Andreas","pass":"****"} [DEBUG] [mount] - mount successfully completed [DEBUG] [mount] - done [DEBUG] [iobroker] start with {"type":"creator","time":"02:15","debugging":true,"everyXDays":"2","nameSuffix":"096_VM100","deleteBackupAfter":0,"cifs":{"enabled":true,"mountType":"NFS","type":"storage","source":"cifs","mount":"192.168.0.98","debugging":true,"fileDir":"/opt/iobroker/node_modules/iobroker.backitup","wakeOnLAN":true,"macAd":"20:DE:20:DE:20:DE","wolTime":"10","smb":"vers=1.0","sudo":true,"cifsDomain":"","deleteOldBackup":true,"ownDir":true,"bkpType":"Minimal","dir":"/volume1/backups/io_096_vm","dirMinimal":"/volume1/backups/io_096_vm","user":"Andreas","pass":"****","context":{"fileNames":[],"errors":{},"done":["umount","mount"],"types":[]},"adapter":null},"dir":"/opt/iobroker","zigbee":{"enabled":true,"type":"creator","ftp":{"enabled":false,"type":"storage","source":"cifs","host":"","debugging":true,"deleteOldBackup":false,"ownDir":false,"bkpType":"Minimal","dir":"/backupDir","dirMinimal":"/backupDir/minimal","user":"","pass":"****","port":"21"},"cifs":{"enabled":true,"mountType":"NFS","type":"storage","source":"cifs","mount":"192.168.0.98","debugging":true,"fileDir":"/opt/iobroker/node_modules/iobroker.backitup","wakeOnLAN":true,"macAd":"20:DE:20:DE:20:DE","wolTime":"10","smb":"vers=1.0","sudo":true,"cifsDomain":"","deleteOldBackup":true,"ownDir":true,"bkpType":"Minimal","dir":"/volume1/backups/io_096_vm","dirMinimal":"/volume1/backups/io_096_vm","user":"Andreas","pass":"****"},"dropbox":{"enabled":false,"type":"storage","source":"cifs","debugging":true,"deleteOldBackup":false,"accessToken":"****","ownDir":false,"bkpType":"Minimal","dir":"/backupDir","dirMinimal":"/backupDir/minimal"},"webdav":{"enabled":false,"type":"storage","source":"cifs","debugging":true,"deleteOldBackup":false,"username":"username","pass":"****","url":"https://example.com/remote.php/dav/files/username/","ownDir":false,"bkpType":"Minimal","dir":"/backupDir","dirMinimal":"/backupDir/iobroker"},"googledrive":{"enabled":false,"type":"storage","source":"cifs","debugging":true,"deleteOldBackup":false,"accessJson":"****","ownDir":false,"bkpType":"Minimal","dir":"/backupDir","dirMinimal":"/backupDir/minimal"},"path":"/opt/iobroker/iobroker-data"},"historyHTML":{"enabled":true,"type":"message","entriesNumber":"25","systemLang":"de"},"historyJSON":{"enabled":true,"type":"message","entriesNumber":"25","systemLang":"de"},"telegram":{"enabled":true,"notificationsType":"E-Mail","type":"message","instance":"","SilentNotice":false,"NoticeType":"longTelegramNotice","User":"none","onlyError":false,"telegramWaiting":0,"systemLang":"de"},"email":{"enabled":true,"notificationsType":"E-Mail","type":"message","instance":"email.0","NoticeType":"longEmailNotice","emailReceiver":"cech.andreas@chello.at","emailSender":"smart-kb@inode.at","onlyError":false,"emailWaiting":60000,"systemLang":"de"},"pushover":{"enabled":true,"notificationsType":"E-Mail","type":"message","instance":"","SilentNotice":false,"NoticeType":"longPushoverNotice","deviceID":"","onlyError":false,"pushoverWaiting":0,"systemLang":"de"},"whatsapp":{"enabled":true,"notificationsType":"E-Mail","type":"message","instance":"","NoticeType":"longWhatsappNotice","onlyError":false,"whatsappWaiting":0,"systemLang":"de"},"backupDir":"/opt/iobroker/backups"} [DEBUG] [iobroker] - host.ioBroker-Prod 23419 states saved [DEBUG] [iobroker] - host.ioBroker-Prod 25891 objects saved [ERROR] [iobroker] - host.ioBroker-Prod Cannot pack directory /opt/iobroker/node_modules/iobroker.js-controller/tmp/backup: Error: EACCES: permission denied, open '/opt/iobroker/backups/iobroker_2021_04_13-14_26_33_096_VM100_backupiobroker.tar.gz' [ERROR] [iobroker] - host.ioBroker-Prod Cannot pack directory /opt/iobroker/node_modules/iobroker.js-controller/tmp/backup: Error [ERR_STREAM_DESTROYED]: Cannot call write after a stream was destroyed [DEBUG] [iobroker] - done [DEBUG] [zigbee] - found zigbee database: zigbee.0 [DEBUG] [zigbee] - done [ERROR] [zigbee] - [IGNORED] Error: EACCES: permission denied, open '/opt/iobroker/backups/zigbee.0_2021_04_13-14_26_49_backupiobroker.tar.gz' [DEBUG] [cifs] - done [DEBUG] [cifs] start with {"mountType":"NFS","type":"storage","source":"cifs","mount":"192.168.0.98","debugging":true,"fileDir":"/opt/iobroker/node_modules/iobroker.backitup","wakeOnLAN":true,"macAd":"20:DE:20:DE:20:DE","wolTime":"10","smb":"vers=1.0","sudo":true,"cifsDomain":"","deleteOldBackup":true,"ownDir":true,"bkpType":"Minimal","dir":"/volume1/backups/io_096_vm","dirMinimal":"/volume1/backups/io_096_vm","user":"Andreas","pass":"****","backupDir":"/opt/iobroker/backups","deleteBackupAfter":0} [ERROR] [clean] - Backup files not deleted from /opt/iobroker/backups because some errors. [DEBUG] [clean] - done [DEBUG] [email] start with {"type":"creator","time":"02:15","debugging":true,"everyXDays":"2","nameSuffix":"096_VM100","deleteBackupAfter":0,"cifs":{"enabled":true,"mountType":"NFS","type":"storage","source":"cifs","mount":"192.168.0.98","debugging":true,"fileDir":"/opt/iobroker/node_modules/iobroker.backitup","wakeOnLAN":true,"macAd":"20:DE:20:DE:20:DE","wolTime":"10","smb":"vers=1.0","sudo":true,"cifsDomain":"","deleteOldBackup":true,"ownDir":true,"bkpType":"Minimal","dir":"/volume1/backups/io_096_vm","dirMinimal":"/volume1/backups/io_096_vm","user":"Andreas","pass":"****","context":{"fileNames":["/opt/iobroker/backups/iobroker_2021_04_13-14_26_33_096_VM100_backupiobroker.tar.gz","/opt/iobroker/backups/zigbee.0_2021_04_13-14_26_49_backupiobroker.tar.gz"],"errors":{"zigbee":"Error: EACCES: permission denied, open '/opt/iobroker/backups/zigbee.0_2021_04_13-14_26_49_backupiobroker.tar.gz'"},"done":["umount","mount","iobroker"],"types":["iobroker"]},"adapter":null},"dir":"/opt/iobroker","zigbee":{"enabled":true,"type":"creator","ftp":{"enabled":false,"type":"storage","source":"cifs","host":"","debugging":true,"deleteOldBackup":false,"ownDir":false,"bkpType":"Minimal","dir":"/backupDir","dirMinimal":"/backupDir/minimal","user":"","pass":"****","port":"21"},"cifs":{"enabled":true,"mountType":"NFS","type":"storage","source":"cifs","mount":"192.168.0.98","debugging":true,"fileDir":"/opt/iobroker/node_modules/iobroker.backitup","wakeOnLAN":true,"macAd":"20:DE:20:DE:20:DE","wolTime":"10","smb":"vers=1.0","sudo":true,"cifsDomain":"","deleteOldBackup":true,"ownDir":true,"bkpType":"Minimal","dir":"/volume1/backups/io_096_vm","dirMinimal":"/volume1/backups/io_096_vm","user":"Andreas","pass":"****"},"dropbox":{"enabled":false,"type":"storage","source":"cifs","debugging":true,"deleteOldBackup":false,"accessToken":"****","ownDir":false,"bkpType":"Minimal","dir":"/backupDir","dirMinimal":"/backupDir/minimal"},"webdav":{"enabled":false,"type":"storage","source":"cifs","debugging":true,"deleteOldBackup":false,"username":"username","pass":"****","url":"https://example.com/remote.php/dav/files/username/","ownDir":false,"bkpType":"Minimal","dir":"/backupDir","dirMinimal":"/backupDir/iobroker"},"googledrive":{"enabled":false,"type":"storage","source":"cifs","debugging":true,"deleteOldBackup":false,"accessJson":"****","ownDir":false,"bkpType":"Minimal","dir":"/backupDir","dirMinimal":"/backupDir/minimal"},"path":"/opt/iobroker/iobroker-data"},"historyHTML":{"enabled":true,"type":"message","entriesNumber":"25","systemLang":"de"},"historyJSON":{"enabled":true,"type":"message","entriesNumber":"25","systemLang":"de"},"telegram":{"enabled":true,"notificationsType":"E-Mail","type":"message","instance":"","SilentNotice":false,"NoticeType":"longTelegramNotice","User":"none","onlyError":false,"telegramWaiting":0,"systemLang":"de"},"email":{"enabled":true,"notificationsType":"E-Mail","type":"message","instance":"email.0","NoticeType":"longEmailNotice","emailReceiver":"cech.andreas@chello.at","emailSender":"smart-kb@inode.at","onlyError":false,"emailWaiting":60000,"systemLang":"de","time":"13. April 2021 um 14:26 Uhr"},"pushover":{"enabled":true,"notificationsType":"E-Mail","type":"message","instance":"","SilentNotice":false,"NoticeType":"longPushoverNotice","deviceID":"","onlyError":false,"pushoverWaiting":0,"systemLang":"de"},"whatsapp":{"enabled":true,"notificationsType":"E-Mail","type":"message","instance":"","NoticeType":"longWhatsappNotice","onlyError":false,"whatsappWaiting":0,"systemLang":"de"},"backupDir":"/opt/iobroker/backups"} [DEBUG] [historyHTML] - new history html values created [DEBUG] [historyHTML] - done [DEBUG] [historyJSON] - new history json values created [DEBUG] [historyJSON] - done [DEBUG] [historyHTML] start with {"type":"creator","time":"02:15","debugging":true,"everyXDays":"2","nameSuffix":"096_VM100","deleteBackupAfter":0,"cifs":{"enabled":true,"mountType":"NFS","type":"storage","source":"cifs","mount":"192.168.0.98","debugging":true,"fileDir":"/opt/iobroker/node_modules/iobroker.backitup","wakeOnLAN":true,"macAd":"20:DE:20:DE:20:DE","wolTime":"10","smb":"vers=1.0","sudo":true,"cifsDomain":"","deleteOldBackup":true,"ownDir":true,"bkpType":"Minimal","dir":"/volume1/backups/io_096_vm","dirMinimal":"/volume1/backups/io_096_vm","user":"Andreas","pass":"****","context":{"fileNames":["/opt/iobroker/backups/iobroker_2021_04_13-14_26_33_096_VM100_backupiobroker.tar.gz","/opt/iobroker/backups/zigbee.0_2021_04_13-14_26_49_backupiobroker.tar.gz"],"errors":{"zigbee":"Error: EACCES: permission denied, open '/opt/iobroker/backups/zigbee.0_2021_04_13-14_26_49_backupiobroker.tar.gz'"},"done":["umount","mount","iobroker"],"types":["iobroker"]},"adapter":null},"dir":"/opt/iobroker","zigbee":{"enabled":true,"type":"creator","ftp":{"enabled":false,"type":"storage","source":"cifs","host":"","debugging":true,"deleteOldBackup":false,"ownDir":false,"bkpType":"Minimal","dir":"/backupDir","dirMinimal":"/backupDir/minimal","user":"","pass":"****","port":"21"},"cifs":{"enabled":true,"mountType":"NFS","type":"storage","source":"cifs","mount":"192.168.0.98","debugging":true,"fileDir":"/opt/iobroker/node_modules/iobroker.backitup","wakeOnLAN":true,"macAd":"20:DE:20:DE:20:DE","wolTime":"10","smb":"vers=1.0","sudo":true,"cifsDomain":"","deleteOldBackup":true,"ownDir":true,"bkpType":"Minimal","dir":"/volume1/backups/io_096_vm","dirMinimal":"/volume1/backups/io_096_vm","user":"Andreas","pass":"****"},"dropbox":{"enabled":false,"type":"storage","source":"cifs","debugging":true,"deleteOldBackup":false,"accessToken":"****","ownDir":false,"bkpType":"Minimal","dir":"/backupDir","dirMinimal":"/backupDir/minimal"},"webdav":{"enabled":false,"type":"storage","source":"cifs","debugging":true,"deleteOldBackup":false,"username":"username","pass":"****","url":"https://example.com/remote.php/dav/files/username/","ownDir":false,"bkpType":"Minimal","dir":"/backupDir","dirMinimal":"/backupDir/iobroker"},"googledrive":{"enabled":false,"type":"storage","source":"cifs","debugging":true,"deleteOldBackup":false,"accessJson":"****","ownDir":false,"bkpType":"Minimal","dir":"/backupDir","dirMinimal":"/backupDir/minimal"},"path":"/opt/iobroker/iobroker-data"},"historyHTML":{"enabled":true,"type":"message","entriesNumber":"25","systemLang":"de","time":"13. April 2021 um 14:26 Uhr"},"historyJSON":{"enabled":true,"type":"message","entriesNumber":"25","systemLang":"de"},"telegram":{"enabled":true,"notificationsType":"E-Mail","type":"message","instance":"","SilentNotice":false,"NoticeType":"longTelegramNotice","User":"none","onlyError":false,"telegramWaiting":0,"systemLang":"de"},"email":{"enabled":true,"notificationsType":"E-Mail","type":"message","instance":"email.0","NoticeType":"longEmailNotice","emailReceiver":"cech.andreas@chello.at","emailSender":"smart-kb@inode.at","onlyError":false,"emailWaiting":60000,"systemLang":"de"},"pushover":{"enabled":true,"notificationsType":"E-Mail","type":"message","instance":"","SilentNotice":false,"NoticeType":"longPushoverNotice","deviceID":"","onlyError":false,"pushoverWaiting":0,"systemLang":"de"},"whatsapp":{"enabled":true,"notificationsType":"E-Mail","type":"message","instance":"","NoticeType":"longWhatsappNotice","onlyError":false,"whatsappWaiting":0,"systemLang":"de"},"backupDir":"/opt/iobroker/backups"} [DEBUG] [umount] - mount activ, umount is started ... [DEBUG] [historyJSON] start with {"type":"creator","time":"02:15","debugging":true,"everyXDays":"2","nameSuffix":"096_VM100","deleteBackupAfter":0,"cifs":{"enabled":true,"mountType":"NFS","type":"storage","source":"cifs","mount":"192.168.0.98","debugging":true,"fileDir":"/opt/iobroker/node_modules/iobroker.backitup","wakeOnLAN":true,"macAd":"20:DE:20:DE:20:DE","wolTime":"10","smb":"vers=1.0","sudo":true,"cifsDomain":"","deleteOldBackup":true,"ownDir":true,"bkpType":"Minimal","dir":"/volume1/backups/io_096_vm","dirMinimal":"/volume1/backups/io_096_vm","user":"Andreas","pass":"****","context":{"fileNames":["/opt/iobroker/backups/iobroker_2021_04_13-14_26_33_096_VM100_backupiobroker.tar.gz","/opt/iobroker/backups/zigbee.0_2021_04_13-14_26_49_backupiobroker.tar.gz"],"errors":{"zigbee":"Error: EACCES: permission denied, open '/opt/iobroker/backups/zigbee.0_2021_04_13-14_26_49_backupiobroker.tar.gz'"},"done":["umount","mount","iobroker"],"types":["iobroker"]},"adapter":null},"dir":"/opt/iobroker","zigbee":{"enabled":true,"type":"creator","ftp":{"enabled":false,"type":"storage","source":"cifs","host":"","debugging":true,"deleteOldBackup":false,"ownDir":false,"bkpType":"Minimal","dir":"/backupDir","dirMinimal":"/backupDir/minimal","user":"","pass":"****","port":"21"},"cifs":{"enabled":true,"mountType":"NFS","type":"storage","source":"cifs","mount":"192.168.0.98","debugging":true,"fileDir":"/opt/iobroker/node_modules/iobroker.backitup","wakeOnLAN":true,"macAd":"20:DE:20:DE:20:DE","wolTime":"10","smb":"vers=1.0","sudo":true,"cifsDomain":"","deleteOldBackup":true,"ownDir":true,"bkpType":"Minimal","dir":"/volume1/backups/io_096_vm","dirMinimal":"/volume1/backups/io_096_vm","user":"Andreas","pass":"****"},"dropbox":{"enabled":false,"type":"storage","source":"cifs","debugging":true,"deleteOldBackup":false,"accessToken":"****","ownDir":false,"bkpType":"Minimal","dir":"/backupDir","dirMinimal":"/backupDir/minimal"},"webdav":{"enabled":false,"type":"storage","source":"cifs","debugging":true,"deleteOldBackup":false,"username":"username","pass":"****","url":"https://example.com/remote.php/dav/files/username/","ownDir":false,"bkpType":"Minimal","dir":"/backupDir","dirMinimal":"/backupDir/iobroker"},"googledrive":{"enabled":false,"type":"storage","source":"cifs","debugging":true,"deleteOldBackup":false,"accessJson":"****","ownDir":false,"bkpType":"Minimal","dir":"/backupDir","dirMinimal":"/backupDir/minimal"},"path":"/opt/iobroker/iobroker-data"},"historyHTML":{"enabled":true,"type":"message","entriesNumber":"25","systemLang":"de"},"historyJSON":{"enabled":true,"type":"message","entriesNumber":"25","systemLang":"de","time":"13. April 2021 um 14:26 Uhr"},"telegram":{"enabled":true,"notificationsType":"E-Mail","type":"message","instance":"","SilentNotice":false,"NoticeType":"longTelegramNotice","User":"none","onlyError":false,"telegramWaiting":0,"systemLang":"de"},"email":{"enabled":true,"notificationsType":"E-Mail","type":"message","instance":"email.0","NoticeType":"longEmailNotice","emailReceiver":"cech.andreas@chello.at","emailSender":"smart-kb@inode.at","onlyError":false,"emailWaiting":60000,"systemLang":"de"},"pushover":{"enabled":true,"notificationsType":"E-Mail","type":"message","instance":"","SilentNotice":false,"NoticeType":"longPushoverNotice","deviceID":"","onlyError":false,"pushoverWaiting":0,"systemLang":"de"},"whatsapp":{"enabled":true,"notificationsType":"E-Mail","type":"message","instance":"","NoticeType":"longWhatsappNotice","onlyError":false,"whatsappWaiting":0,"systemLang":"de"},"backupDir":"/opt/iobroker/backups"} [DEBUG] [umount] start with {"mountType":"NFS","type":"storage","source":"cifs","mount":"192.168.0.98","debugging":true,"fileDir":"/opt/iobroker/node_modules/iobroker.backitup","wakeOnLAN":true,"macAd":"20:DE:20:DE:20:DE","wolTime":"10","smb":"vers=1.0","sudo":true,"cifsDomain":"","deleteOldBackup":true,"ownDir":true,"bkpType":"Minimal","dir":"/volume1/backups/io_096_vm","dirMinimal":"/volume1/backups/io_096_vm","user":"Andreas","pass":"****","backupDir":"/opt/iobroker/backups"} [DEBUG] [umount] - umount successfully completed [DEBUG] [umount] - done [EXIT] 9 [DEBUG] [email] - [iobroker] used E-Mail-Instance: email.0 [DEBUG] [email] - done [EXIT] 9
Es ist aber sicher kein Bug im Adapter, soll ich mit meiner gesamten Anfrage ins Hauptforum übersiedeln?
LG -
@metaxa sagte in Zwei Bugs mit backitup 2.1.0 und 2.0.5:
Permission denied
Du hast keine Rechte auf deinem NAS, um Dateien zu schreiben.
Was hast du für ein NAS? Zeige mal die Einstellungen von deinem NAS -
@simatec sagte in Zwei Bugs mit backitup 2.1.0 und 2.0.5:
mal die Einstellungen von deinem NAS
(Muss mir mal gleich selbst auf die Schulter klopfen, ich habe alle meine Backups die im iobroker/backups gemounted waren durch meine Löschorgie auf dem NAS gelöscht :-))
Aktuell sind aber wieder neue Backups im Ordner:
Kann es sein, dass iO den Unterordner SQL nicht anlegen kann?
-
@metaxa SQL hat keinen Unterordner ...
Welche Version von Backitup nutzt du denn?