Monatsrückblick Januar/Februar 2026 ist online!

[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 :point_up: !

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 :persevere:

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

[wendy2702]

@michael_4358 kannst du das logfile bitte als Text in Code Tags </> posten!

[simatec]

@michael_4358
Bitte die Instanz auf debug stellen, damit man hier einfach mehr sieht

[michael_4358]

@wendy2702 wo kann ich den adapter umschalten?

[metaxa]

@michael_4358

[michael_4358]

@metaxa ```

2021-04-19 11:34:32.024 - info: host.raspberrypi instance system.adapter.backitup.0 terminated with code 11 (ADAPTER_REQUESTED_TERMINATION)
2021-04-19 11:34:34.446 - info: host.raspberrypi instance system.adapter.backitup.0 started with pid 4271
2021-04-19 11:34:37.605 - debug: backitup.0 (4271) Redis Objects: Use Redis connection: 127.0.0.1:9001
2021-04-19 11:34:37.668 - debug: backitup.0 (4271) Objects client ready ... initialize now
2021-04-19 11:34:37.670 - debug: backitup.0 (4271) Objects create System PubSub Client
2021-04-19 11:34:37.672 - debug: backitup.0 (4271) Objects create User PubSub Client
2021-04-19 11:34:37.673 - debug: backitup.0 (4271) Objects client initialize lua scripts
2021-04-19 11:34:37.688 - debug: backitup.0 (4271) Objects connected to redis: 127.0.0.1:9001
2021-04-19 11:34:37.698 - debug: backitup.0 (4271) objectDB connected
2021-04-19 11:34:37.700 - debug: backitup.0 (4271) Redis States: Use Redis connection: 127.0.0.1:9000
2021-04-19 11:34:37.724 - debug: backitup.0 (4271) States create System PubSub Client
2021-04-19 11:34:37.726 - debug: backitup.0 (4271) States create User PubSub Client
2021-04-19 11:34:37.736 - debug: backitup.0 (4271) States connected to redis: 127.0.0.1:9000
2021-04-19 11:34:37.737 - debug: backitup.0 (4271) statesDB connected
2021-04-19 11:34:38.148 - debug: backitup.0 (4271) Plugin sentry Initialize Plugin (enabled=true)
2021-04-19 11:34:38.378 - info: backitup.0 (4271) starting. Version 2.1.0 in /opt/iobroker/node_modules/iobroker.backitup, node: v12.21.0, js-controller: 3.2.16
2021-04-19 11:34:38.468 - info: backitup.0 (4271) [iobroker] backup was activated at 12:00 every 5 day(s)
2021-04-19 11:34:38.504 - debug: backitup.0 (4271) [iobroker] 10 00 12 */5 * *
2021-04-19 11:34:38.653 - debug: backitup.0 (4271) first mount attempt with smb option failed. try next mount attempt without smb option ...
2021-04-19 11:34:38.803 - debug: backitup.0 (4271) mount successfully completed
2021-04-19 11:34:40.869 - debug: backitup.0 (4271) detect backup file 1 from cifs: iobroker_2021_04_14-21_47_13_Pi4-1_backupiobroker.tar.gz
2021-04-19 11:34:40.869 - debug: backitup.0 (4271) detect backup file 2 from cifs: iobroker_2021_04_14-21_48_53_Pi4-1_backupiobroker.tar.gz
2021-04-19 11:34:40.870 - debug: backitup.0 (4271) detect backup file 3 from cifs: iobroker_2021_04_16-12_00_36_Pi4-1_backupiobroker.tar.gz
2021-04-19 11:34:40.870 - debug: backitup.0 (4271) detect backup file 4 from cifs: iobroker_2021_04_17-14_10_04_Pi4-1_backupiobroker.tar.gz
2021-04-19 11:34:40.871 - debug: backitup.0 (4271) detect backup file 5 from cifs: iobroker_2021_04_17-14_12_03_Pi4-1_backupiobroker.tar.gz
2021-04-19 11:34:40.872 - debug: backitup.0 (4271) detect last backup file: iobroker_2021_04_17-14_12_03_Pi4-1_backupiobroker.tar.gz
2021-04-19 11:34:48.477 - debug: backitup.0 (4271) mount activ... umount in 2 Seconds!!
2021-04-19 11:34:50.549 - debug: backitup.0 (4271) umount successfully completed
2021-04-19 11:34:51.476 - debug: backitup.0 (4271) telegram-instance: telegram.0
2021-04-19 11:34:51.479 - debug: backitup.0 (4271) sendTo "getTelegramUser" to system.adapter.admin.0 from system.adapter.backitup.0: {"1440354501":{"firstName":"Anja"},"1455495559":{"firstName":"Michael","userName":"michael4358"}}
2021-04-19 11:34:54.699 - info: host.raspberrypi stopInstance system.adapter.backitup.0 (force=false, process=true)
2021-04-19 11:34:54.716 - info: backitup.0 (4271) Got terminate signal TERMINATE_YOURSELF
2021-04-19 11:34:54.717 - info: backitup.0 (4271) cleaned everything up...
2021-04-19 11:34:54.718 - info: backitup.0 (4271) terminating
2021-04-19 11:34:54.720 - debug: backitup.0 (4271) Plugin sentry destroyed
2021-04-19 11:34:54.721 - info: backitup.0 (4271) Terminated (ADAPTER_REQUESTED_TERMINATION): Without reason
2021-04-19 11:34:54.717 - info: host.raspberrypi stopInstance system.adapter.backitup.0 send kill signal
2021-04-19 11:34:55.382 - info: host.raspberrypi instance system.adapter.backitup.0 terminated with code 11 (ADAPTER_REQUESTED_TERMINATION)
2021-04-19 11:34:57.759 - info: host.raspberrypi instance system.adapter.backitup.0 started with pid 4543
2021-04-19 11:35:00.906 - debug: backitup.0 (4543) Redis Objects: Use Redis connection: 127.0.0.1:9001
2021-04-19 11:35:00.944 - debug: backitup.0 (4543) Objects client ready ... initialize now
2021-04-19 11:35:00.967 - debug: backitup.0 (4543) Objects create System PubSub Client
2021-04-19 11:35:00.968 - debug: backitup.0 (4543) Objects create User PubSub Client
2021-04-19 11:35:00.969 - debug: backitup.0 (4543) Objects client initialize lua scripts
2021-04-19 11:35:00.984 - debug: backitup.0 (4543) Objects connected to redis: 127.0.0.1:9001
2021-04-19 11:35:00.994 - debug: backitup.0 (4543) objectDB connected
2021-04-19 11:35:00.996 - debug: backitup.0 (4543) Redis States: Use Redis connection: 127.0.0.1:9000
2021-04-19 11:35:01.005 - debug: backitup.0 (4543) States create System PubSub Client
2021-04-19 11:35:01.006 - debug: backitup.0 (4543) States create User PubSub Client
2021-04-19 11:35:01.015 - debug: backitup.0 (4543) States connected to redis: 127.0.0.1:9000
2021-04-19 11:35:01.016 - debug: backitup.0 (4543) statesDB connected
2021-04-19 11:35:01.412 - debug: backitup.0 (4543) Plugin sentry Initialize Plugin (enabled=true)
2021-04-19 11:35:01.645 - info: backitup.0 (4543) starting. Version 2.1.0 in /opt/iobroker/node_modules/iobroker.backitup, node: v12.21.0, js-controller: 3.2.16
2021-04-19 11:35:01.738 - info: backitup.0 (4543) [iobroker] backup was activated at 12:00 every 5 day(s)
2021-04-19 11:35:01.768 - debug: backitup.0 (4543) [iobroker] 10 00 12 */5 * *
2021-04-19 11:35:01.891 - debug: backitup.0 (4543) first mount attempt with smb option failed. try next mount attempt without smb option ...
2021-04-19 11:35:02.043 - debug: backitup.0 (4543) mount successfully completed
2021-04-19 11:35:02.619 - error: backitup.0 (4543) [iobroker] Backup folder not created: Error: EPERM: operation not permitted, chmod '/opt/iobroker/backups'Please reinstall backitup and run "iobroker fix"!!
2021-04-19 11:35:02.640 - debug: backitup.0 (4543) Backup has started ...
2021-04-19 11:35:02.655 - debug: backitup.0 (4543) [iobroker/mount] mount activ... umount is started before mount!!
2021-04-19 11:35:02.716 - debug: backitup.0 (4543) [iobroker/mount] umount successfully completed
2021-04-19 11:35:04.110 - debug: backitup.0 (4543) detect backup file 1 from cifs: iobroker_2021_04_14-21_47_13_Pi4-1_backupiobroker.tar.gz
2021-04-19 11:35:04.110 - debug: backitup.0 (4543) detect backup file 2 from cifs: iobroker_2021_04_14-21_48_53_Pi4-1_backupiobroker.tar.gz
2021-04-19 11:35:04.111 - debug: backitup.0 (4543) detect backup file 3 from cifs: iobroker_2021_04_16-12_00_36_Pi4-1_backupiobroker.tar.gz
2021-04-19 11:35:04.111 - debug: backitup.0 (4543) detect backup file 4 from cifs: iobroker_2021_04_17-14_10_04_Pi4-1_backupiobroker.tar.gz
2021-04-19 11:35:04.112 - debug: backitup.0 (4543) detect backup file 5 from cifs: iobroker_2021_04_17-14_12_03_Pi4-1_backupiobroker.tar.gz
2021-04-19 11:35:04.113 - debug: backitup.0 (4543) detect last backup file: iobroker_2021_04_17-14_12_03_Pi4-1_backupiobroker.tar.gz
2021-04-19 11:35:12.710 - debug: backitup.0 (4543) [iobroker/mount] first mount attempt with smb option failed. try next mount attempt without smb option ...
2021-04-19 11:35:12.873 - debug: backitup.0 (4543) [iobroker/mount] mount successfully completed
2021-04-19 11:35:12.874 - debug: backitup.0 (4543) [iobroker/mount] done
2021-04-19 11:35:16.110 - debug: backitup.0 (4543) [iobroker/iobroker] host.raspberrypi 3777 states saved
2021-04-19 11:35:16.202 - debug: backitup.0 (4543) [iobroker/iobroker] host.raspberrypi 6872 objects saved
2021-04-19 11:35:19.933 - debug: backitup.0 (4543) [iobroker/iobroker] Backup created: /opt/iobroker/backups/iobroker_2021_04_19-11_35_13_Pi4-1_backupiobroker.tar.gz
2021-04-19 11:35:20.984 - debug: backitup.0 (4543) [iobroker/iobroker] done
2021-04-19 11:35:21.739 - debug: backitup.0 (4543) [iobroker/historyDB] compress from historyDB started ...
2021-04-19 11:35:21.740 - debug: backitup.0 (4543) [iobroker/historyDB] [IGNORED] Backitup cannot found source "undefined" for compress!
2021-04-19 11:35:21.892 - debug: backitup.0 (4543) [iobroker/zigbee] found zigbee database: zigbee.0,zigbee.1
2021-04-19 11:35:21.893 - debug: backitup.0 (4543) [iobroker/zigbee] done
2021-04-19 11:35:22.197 - debug: backitup.0 (4543) [iobroker/jarvis] Jarvis Backup cannot created. Please install a Jarvis version >= 2.2.0
2021-04-19 11:35:22.200 - debug: backitup.0 (4543) [iobroker/jarvis] done
2021-04-19 11:35:22.802 - debug: backitup.0 (4543) [iobroker/cifs] done
2021-04-19 11:35:23.405 - debug: backitup.0 (4543) [iobroker/clean] Backup files not deleted from /opt/iobroker/backups because some errors.
2021-04-19 11:35:23.406 - debug: backitup.0 (4543) [iobroker/clean] done
2021-04-19 11:35:23.864 - debug: backitup.0 (4543) [iobroker/telegram] [iobroker] used Telegram-Instance: telegram.0
2021-04-19 11:35:23.872 - debug: backitup.0 (4543) sendTo "send" to system.adapter.telegram.0 from system.adapter.backitup.0
2021-04-19 11:35:23.873 - debug: backitup.0 (4543) [iobroker/telegram] done
2021-04-19 11:35:24.178 - debug: backitup.0 (4543) [iobroker/historyHTML] new history html values created
2021-04-19 11:35:24.179 - debug: backitup.0 (4543) [iobroker/historyHTML] done
2021-04-19 11:35:24.369 - debug: backitup.0 (4543) [iobroker/historyJSON] new history json values created
2021-04-19 11:35:24.371 - debug: backitup.0 (4543) [iobroker/historyJSON] done
2021-04-19 11:35:24.581 - debug: backitup.0 (4543) [iobroker/umount] mount activ, umount is started ...
2021-04-19 11:35:29.652 - debug: backitup.0 (4543) [iobroker/umount] umount successfully completed
2021-04-19 11:35:29.654 - debug: backitup.0 (4543) [iobroker/umount] done
2021-04-19 11:35:29.805 - debug: backitup.0 (4543) [iobroker] exec: done
```