Zwei Bugs mit backitup 2.1.0 und 2.0.5

[wendy2702]

@buddinski88 kannst du mal das komplette Log vom Backupitup adapter im Debug mode posten.

[Buddinski88]

@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

[simatec]

@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

[Buddinski88]

@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

[simatec]

@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.

[Buddinski88]

@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?

[wendy2702]

@buddinski88 nur am Handy gesucht, passt das :

https://serverfault.com/questions/912162/mysqldump-throws-unknown-table-column-statistics-in-information-schema-1109

[metaxa]

@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

[simatec]

@metaxa schaue mal bitte in die Doku ...

https://github.com/simatec/ioBroker.backitup/blob/master/docs/de/backitup.md#mysql-backup

[metaxa]

@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.

1. "sudo apt-get install mysql-client" fehlerfrei durchgeführt
2. 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)

3. 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"!!

4. BackitUp drüberinstalliert und anschließend den Fixer erfolgreich ausgeführt.
5. 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

6. 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.

7. 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

[simatec]

@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

[metaxa]

@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?

[simatec]

@metaxa SQL hat keinen Unterordner ...
Welche Version von Backitup nutzt du denn?

[metaxa]

@simatec Sorry, für die späte Rückmeldung. Ich versuchte den Fehler einzugrenzen.

BackitUp: 2.1.0 (heute morgen upgedated) 1x Host, 1x Slave
Node JS: 12.19.0
NPM: 6.14.8
JS-Controller: 3.2.16

Es läuft jetzt alles!
Was mußte ich machen. Nach jeder Änderung in der Adapteroberfläche ging danach nichts mehr, endete immer in dieser Art Fehlermeldungen:

BackItUp:
Your backup was not completely created. Please check the errors!!

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)

Nach einem Neustart der vollständigen VM ging es dann immer auf Anhieb. Ich habe das Gefühl, dass der Unmountbefehl immer wieder hängen blieb.
NFS habe ich wieder rausgenommen, auch die Freigabe auf dem NAS (Screen weiter oben) und bin wieder retour auf CIFS. Paar Steps mit Zwischenkontrollen und Neustarts brachten das Ergebnis. Scheinbar ist das ändern der Cronjobs nund speichern der Config kein Problem.

Für Zigbee, SQL, usw. werden keine Unterverzeichnisse angeboten, auch keine eigenen Cronjobs. Die werden offensichtlich mit dem ioBroker Backup paralell angestossen.
Gibt es dafür einen bestimmten Grund?

Danke jedenfalls für den tollen Adapter und deine Muße mir heute unter "Bugs" dennoch zuhelfen.
LG, mxa

[simatec]

@metaxa Gerne ... kein Problem

[michael_4358]

@metaxa

habe auf meinem pi das gleiche problem...
kann aber deine fehler behebung nicht ganz nach vollziehen

hast du einfach die alten backups gelöscht und alles neugestartet??

[metaxa]

@michael_4358 was willst du alles backupen, welche adapter?

[michael_4358]

@metaxa ioBroker;zigbee;jarvis

und wenn ich die history mit einbinde stürtzt das adapter ab

[simatec]

@michael_4358
Ohne Debug Log wird es schwierig dir zu helfen

[michael_4358]

@simatec