Navigation

    Logo
    • Register
    • Login
    • Search
    • Recent
    • Tags
    • Unread
    • Categories
    • Unreplied
    • Popular
    • GitHub
    • Docu
    • Hilfe
    1. Home
    2. Deutsch
    3. Error/Bug
    4. Zwei Bugs mit backitup 2.1.0 und 2.0.5

    NEWS

    • ioBroker goes Matter ... Matter Adapter in Stable

    • Monatsrückblick - April 2025

    • Minor js-controller 7.0.7 Update in latest repo

    Zwei Bugs mit backitup 2.1.0 und 2.0.5

    This topic has been deleted. Only users with topic management privileges can see it.
    • Thomas Braun
      Thomas Braun Most Active @Buddinski88 last edited by

      @buddinski88 Rechte passen eigentlich.

      B 1 Reply Last reply Reply Quote 0
      • B
        Buddinski88 @Thomas Braun last edited by

        @thomas-braun, das ist ja schon mal etwas. Dann ist der die Meldung aber umso interessanter 🙂
        Solche Fehler sind mir "besonders lieb"...

        1 Reply Last reply Reply Quote 0
        • wendy2702
          wendy2702 @Buddinski88 last edited by

          @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"!!

          B 1 Reply Last reply Reply Quote 0
          • B
            Buddinski88 @wendy2702 last edited by

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

            wendy2702 1 Reply Last reply Reply Quote 0
            • wendy2702
              wendy2702 @Buddinski88 last edited by

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

              B 1 Reply Last reply Reply Quote 0
              • B
                Buddinski88 @wendy2702 last edited by

                @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 1 Reply Last reply Reply Quote 0
                • simatec
                  simatec Developer Most Active @Buddinski88 last edited by

                  @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

                  B 1 Reply Last reply Reply Quote 0
                  • B
                    Buddinski88 @simatec last edited by

                    @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 1 Reply Last reply Reply Quote 0
                    • simatec
                      simatec Developer Most Active @Buddinski88 last edited by 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.

                      B 1 Reply Last reply Reply Quote 0
                      • B
                        Buddinski88 @simatec last edited by

                        @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 metaxa 2 Replies Last reply Reply Quote 0
                        • wendy2702
                          wendy2702 @Buddinski88 last edited by

                          @buddinski88 nur am Handy gesucht, passt das :

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

                          1 Reply Last reply Reply Quote 0
                          • metaxa
                            metaxa @Buddinski88 last edited by

                            @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 1 Reply Last reply Reply Quote 0
                            • simatec
                              simatec Developer Most Active @metaxa last edited by

                              @metaxa schaue mal bitte in die Doku ...

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

                              metaxa 1 Reply Last reply Reply Quote 1
                              • metaxa
                                metaxa @simatec last edited by 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)
                                1. 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"!!
                                1. BackitUp drüberinstalliert und anschließend den Fixer erfolgreich ausgeführt.
                                2. 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

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

                                2. 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 1 Reply Last reply Reply Quote 0
                                • simatec
                                  simatec Developer Most Active @metaxa last edited by

                                  @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 1 Reply Last reply Reply Quote 1
                                  • metaxa
                                    metaxa @simatec last edited by metaxa

                                    @simatec sagte in Zwei Bugs mit backitup 2.1.0 und 2.0.5:

                                    mal die Einstellungen von deinem NAS

                                    e1e4c5a7-6b29-4933-8d5d-09e5ff622331-grafik.png

                                    (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:
                                    bcd20afc-4ed9-4bb5-8c3d-b906a7640b82-grafik.png

                                    Kann es sein, dass iO den Unterordner SQL nicht anlegen kann?

                                    simatec 1 Reply Last reply Reply Quote 0
                                    • simatec
                                      simatec Developer Most Active @metaxa last edited by

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

                                      metaxa 1 Reply Last reply Reply Quote 0
                                      • metaxa
                                        metaxa @simatec last edited by

                                        @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 M 2 Replies Last reply Reply Quote 0
                                        • simatec
                                          simatec Developer Most Active @metaxa last edited by

                                          @metaxa Gerne ... kein Problem

                                          1 Reply Last reply Reply Quote 1
                                          • M
                                            michael_4358 @metaxa last edited by

                                            @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 1 Reply Last reply Reply Quote 0
                                            • First post
                                              Last post

                                            Support us

                                            ioBroker
                                            Community Adapters
                                            Donate

                                            913
                                            Online

                                            31.6k
                                            Users

                                            79.5k
                                            Topics

                                            1.3m
                                            Posts

                                            6
                                            38
                                            2443
                                            Loading More Posts
                                            • Oldest to Newest
                                            • Newest to Oldest
                                            • Most Votes
                                            Reply
                                            • Reply as topic
                                            Log in to reply
                                            Community
                                            Impressum | Datenschutz-Bestimmungen | Nutzungsbedingungen
                                            The ioBroker Community 2014-2023
                                            logo