UPDATE 31.10.: Amazon Alexa - ioBroker Skill läuft aus ?

[Tottbeck]

@apollon77 sagte in Mini-HowTo: Cannot find view "system" for search "host":

Das wäre duerch ein "iob upload admin" gefixt gewesen

OK, danke. Habe ich gemacht (auf dem Master) und konnte dann ein BackItUp Instanz anlegen (auf dem Slave wo sie vorher auch war).
Dann kann ich das lokale Backup auswählen, aber das Einspielen klappt nicht.

Die Meldung ist zwar etwas widerspüchlich, es geht aber etwas zu schnell und wurde wohl abgebrochen.
Wenn ich auf dem Master das BackItUp auswähle, (da findet er auch die auf dem Slave-Backup-Folder, dann kommt in dem Restore Fenster nur eine Fehlermeldung "192.168.xxx.yyy hat die Verbindung abgelehnt."

Dann habe ich BackItUp auf der Raspi3 (Master) verschoben, das Backup in den lokale Ordner kopiert und restored.
Das geht zwar aber dann habe ich wieder keine Instanzen.

[wendy2702]

@tottbeck das dauert.

Hast du mal parallel ins iobroker log geschaut bzw. Wie lange hast du gewartet?

[apollon77]

@tottbeck dann am Besten mal im
Backitup thread melden?

[Tottbeck]

@wendy2702
Ich habe nicht auf den log geschaut, aber mindesten 30 Minuten gewartet.
Mit dem alten Backup hatte ich schon nach kurzer Zeit wieder die ersten Instanzen up.

Ich habe iwie keine Möglichkeit gefunden das Backup vernünftig einzuspielen.
Ist es nicht zulässig ein BackitUp-Restore vom Slave zu machen? (Hatte ich mal gemacht meine ich bin aber nicht sicher)

@apollon77
Ja macht wohl mehr Sinn bzgl BackitUp, ich hänge das mal an meinen alten Thread zum Multihost
https://forum.iobroker.net/topic/43295/slave-adapter-fehlen-beim-multihost-system-aufsetzen/11

Danke Euch

[Anzic]

@apollon77 This situation happens to me every time when the container is reloaded. I'm already tired of restoring from a backup file. For me the procedure looks like this:
reloading the container, I get:
Cannot read system.config: null (OK when migrating or restoring)
npm i iobroker.js-controller@4.0.23 --production
iob stop
iob restore iobroker_2022_05_05-02_00_10_backupiobroker.tar.gz
and the agonizing wait until everything is removed and re-installed. Is there a way to fix it faster? I tried the fix, it doesn't help.
also found that when this happens the iobroker.json file resets the objects setting to "file" even though I'm using JSONL. I thought it would be better when I switched to it, but it only got worse. Please help, I'm really tired of restoring the entire system every time.

[apollon77]

@anzic What exactly do you mean with "when container is reloaded"?

Additionally: what does "iob status" give you ? Which DB type do you use? It should also not really happen with JSONL (which is starndard in 4.0.x contoller) and should also not happen again with js-controller 4 File DB usage.

So please provide logs from iobroker from such a "reload" last mins before and some mins after start". I hope that "reload" do not mean "immediate kill of anything and no proper shutdown"

[Anzic]

@apollon77
i mean that when i restart container with iobroker (buanet/iobroker:v6.1.0). The iobroker.json file is reset to the default one, which states that the "file" object base is used instead of "jsonl". At this point, the controller tries to connect to the objects.json file which is generated automatically, which is 23 KB in size. And if I try to set up iobroker with iobroker setup custom specifying the correct "jsonl" as objects db (even if I put the previously saved objects.jsonl file in a folder), it overwrites it using the objects.json.migrated source file and the system doesn't start. So far I have found such a solution for recovery :
stop iobroker - iob stop
then I execute pgrep -f '^io.' | xargs kill -9 because not all processes are stopped, and if I don't do this and try to put the correct iobroker.json and objects.jsonl, the system will still overwrite them from the "wrong" objects.json.migrated. Therefore pgrep -f '^io.' | xargs kill -9
after that I replace the iobroker.json file and objects.jsonl that I saved on the working system.
and run iob start
in this order the system starts up. Unfortunately, I have to go to the slave later, and run iob setup custom , i.e. for some reason, he also loses contact with the master.

root@iobroker:/opt/iobroker# iob isrun
 Cannot read system.config: null (OK when migrating or restoring)
iobroker is running on this host.


Objects type: file
States  type: redis

Reboot occurs by restarting the container, not power loss.
"Last entries" before rebooting do not give anything, there are standard logs that are not related to stopping the controller in any way.
But the first start can be interesting, apparently, the controller cannot find the objects.json file (although why is it looking for it if it should use objects.jsonl). This is probably due to the fact that after a reboot, an entry appears in the iobroker.json file that it is working with the "file", so it tries to "find" it.

2022-05-11 22:48:04.387  - info: host.iobroker iobroker.js-controller version 4.0.23 js-controller starting
2022-05-11 22:48:04.391  - info: host.iobroker Copyright (c) 2014-2022 bluefox, 2014 hobbyquaker
2022-05-11 22:48:04.391  - info: host.iobroker hostname: iobroker, node: v14.19.2
2022-05-11 22:48:04.391  - info: host.iobroker ip addresses: 192.168.1.100 172.23.0.100
2022-05-11 22:48:04.402  - warn: host.iobroker-Server Configured backup period 120 is larger than the supported maximum of 35791 minutes. Defaulting to 120 minutes.
2022-05-11 22:48:04.406  - error: host.iobroker-Server Cannot load /opt/iobroker/iobroker-data/objects.json: Database file /opt/iobroker/iobroker-data/objects.json does not exists.. We try last Backup!
2022-05-11 22:48:04.410  - error: host.iobroker-Server Cannot load /opt/iobroker/iobroker-data/objects.json.bak: Database file /opt/iobroker/iobroker-data/objects.json.bak does not exists.. Continue with empty dataset!
2022-05-11 22:48:04.410  - error: host.iobroker-Server If this is no Migration or initial start please restore the last backup from /opt/iobroker/iobroker-data/backup-objects
2022-05-11 22:48:04.500  - error: host.iobroker Cannot read system.config: null (OK when migrating or restoring)
2022-05-11 22:48:04.548  - error: host.iobroker Cannot find view "system" for search "host"
2022-05-11 22:48:04.589  - info: host.iobroker connected to Objects and States
2022-05-11 22:48:04.618  - info: host.iobroker added notifications configuration of host
2022-05-11 22:48:04.621  - warn: host.iobroker logger system.adapter.admin.0.logging was deleted
2022-05-11 22:48:04.622  - warn: host.iobroker logger system.adapter.javascript.2.logging was deleted
2022-05-11 22:48:04.623  - warn: host.iobroker logger system.adapter.javascript.0.logging was deleted
2022-05-11 22:48:04.623  - warn: host.iobroker logger system.adapter.iot.0.logging was deleted
2022-05-11 22:48:04.664  - error: host.iobroker Cannot find view "system" for search "instance"
2022-05-11 22:48:04.664  - error: host.iobroker Could not add notifications config of this host: Could not get notifications setup from instances: Cannot find view "system"
2022-05-11 22:48:04.677  - info: host.iobroker Plugin sentry Sentry Plugin disabled for this process because sending of statistic data is disabled for the system
2022-05-11 22:48:04.682  - error: host.iobroker Cannot find view "system" for search "host"
2022-05-11 22:48:04.689  - error: host.iobroker Cannot find view "system" for search "state"
2022-05-11 22:48:04.689  - error: host.iobroker Cannot find view "system" for search "instance"
2022-05-11 22:48:04.690  - error: host.iobroker Could not collect system.host.iobroker states to check for obsolete states: Error: Cannot find view "system"
2022-05-11 22:48:04.690  - error: host.iobroker  _design/system missing - call node iobroker.js setup
2022-05-11 22:48:04.691  - info: host.iobroker  no instances found
2022-05-11 22:48:04.691  - info: host.iobroker no instances found

Perhaps in my case, it will be correct to make a "reverse" migration to "file" and then back to jsonl. Then the "correct" iobroker.json file will be created and at the next reboot, it will simply start using it, which of course is also not entirely true, but at least it will not "break" the whole system, I hope.

[apollon77]

@anzic the main question is why the objects.json is not existing. It is not broken. It is not existing. So why???

Please show the content of /opt/iobroker/iobroker-data while running and ideally directly on such a restart.

Please also show „iob status“ from a running system

[apollon77]

PS: What the variables are set in your container? e.g. IOB_STATESDB_TYPE .. if this is set to "file" then the DB will be reset on any start ... you then needs to adjust that to jsonl

[Anzic]

Пользователь @apollon77 написал в Mini-HowTo: Cannot find view "system" for search "host":

IOB_STATESDB_TYPE

How did I miss this?? Indeed, "file" was written in docker-compose.yml. I'll change it to jsonl and check again. Thanks for the hint.

[Anzic]

@apollon77 from nas:

Anzor@NAS:/volume2/doker_mapping/iobroker/iobroker-data$ ls -la
total 26416
drwxrwxr-x 1 Anzor users      626 May 12 09:36 .
drwxrwxr-x 1 Anzor users      764 May 11 22:47 ..
drwxr-xr-x 1 Anzor users       64 Apr 15 01:12 backitup
drwxrwxr-x 1 Anzor users     1840 May 12 11:03 backup-objects
drwxr-xr-x 1 Anzor users      660 Feb 27 21:41 esphome.0
drwxrwxr-x 1 Anzor users     4128 May 11 02:07 files
drwxrwxrwx 1 Anzor users       58 Mar 27 13:15 ham_0
drwxr-xr-x 1 Anzor users        0 Oct 31  2021 homekit-controller.0
-rw-rwxr-- 1 Anzor users     3593 May 11 23:18 iobroker.json
drwxr-xr-x 1 Anzor users        0 Jun 30  2020 letsencrypt
drwxrwxrwx 1 Anzor users       22 Jun 30  2020 lgtv_0
drwxr-xr-x 1 Anzor users       22 Jul 10  2020 lgtv_1
drwxrwxrwx 1 Anzor users       24 Jun 30  2020 mercury_0
drwxrwxrwx 1 Anzor users      200 May 10 23:08 my-backup
drwxr-xr-x 1 Anzor users      714 May  8 11:35 node-red
-rw-rw-rw- 1 Anzor users        3 May 11 02:09 notifications.json
-rw-r--r-- 1 Anzor  1000    23624 May 11 22:48 objects.json.bak.migrated
-rw-rw-rw- 1 Anzor  1000 26957147 May 12 11:40 objects.jsonl
-rw-rw-rw- 1 Anzor users    12762 May 11 01:57 objects.jsonl.444
-rw-rw-rw- 1 Anzor users    12762 May 11 02:01 objects.jsonl.gj
drwxrwxrwx 1 Anzor  1000        0 May 12 11:40 objects.jsonl.lock
-rw-r--r-- 1 Anzor  1000    23624 May 11 22:58 objects.json.migrated
drwxr-xr-x 1 Anzor users       60 Aug  6  2020 sayit
drwxrwxrwx 1 Anzor users        0 Apr 24 02:01 telegram_0
drwxrwxrwx 1 Anzor users       32 Sep 11  2021 tmp
drwxr-xr-x 1 Anzor users       18 Sep 14  2020 tuya_0
drwxrwxrwx 1 Anzor users      640 May  7 00:19 yahka.0.hapdata
drwxr-xr-x 1 Anzor users      128 May  2  2021 yahka.1.hapdata
drwxr-xr-x 1 Anzor users       22 Jun 30  2020 zigbee_0
Anzor@NAS:/volume2/doker_mapping/iobroker/iobroker-data$

from inside of container:

root@iobroker:/opt/iobroker/iobroker-data# ls -la
total 26448
drwxrwxr-x 1 iobroker users         626 May 12 09:36 .
drwxrwxr-x 1 iobroker users         764 May 11 22:47 ..
drwxr-xr-x 1 iobroker users          64 Apr 15 01:12 backitup
drwxrwxr-x 1 iobroker users        1840 May 12 11:03 backup-objects
drwxr-xr-x 1 iobroker users         660 Feb 27 21:41 esphome.0
drwxrwxr-x 1 iobroker users        4128 May 11 02:07 files
drwxrwxrwx 1 iobroker users          58 Mar 27 13:15 ham_0
drwxr-xr-x 1 iobroker users           0 Oct 31  2021 homekit-controller.0
-rw-rwxr-- 1 iobroker users        3593 May 11 23:18 iobroker.json
drwxr-xr-x 1 iobroker users           0 Jun 30  2020 letsencrypt
drwxrwxrwx 1 iobroker users          22 Jun 30  2020 lgtv_0
drwxr-xr-x 1 iobroker users          22 Jul 10  2020 lgtv_1
drwxrwxrwx 1 iobroker users          24 Jun 30  2020 mercury_0
drwxrwxrwx 1 iobroker users         200 May 10 23:08 my-backup
drwxr-xr-x 1 iobroker users         714 May  8 11:35 node-red
-rw-rw-rw- 1 iobroker users           3 May 11 02:09 notifications.json
-rw-r--r-- 1 iobroker iobroker    23624 May 11 22:48 objects.json.bak.migrated
-rw-rw-rw- 1 iobroker iobroker 26992013 May 12 11:41 objects.jsonl
-rw-rw-rw- 1 iobroker users       12762 May 11 01:57 objects.jsonl.444
-rw-rw-rw- 1 iobroker users       12762 May 11 02:01 objects.jsonl.gj
drwxrwxrwx 1 iobroker iobroker        0 May 12 11:42 objects.jsonl.lock
-rw-r--r-- 1 iobroker iobroker    23624 May 11 22:58 objects.json.migrated
drwxr-xr-x 1 iobroker users          60 Aug  6  2020 sayit
drwxrwxrwx 1 iobroker users           0 Apr 24 02:01 telegram_0
drwxrwxrwx 1 iobroker users          32 Sep 11  2021 tmp
drwxr-xr-x 1 iobroker users          18 Sep 14  2020 tuya_0
drwxrwxrwx 1 iobroker users         640 May  7 00:19 yahka.0.hapdata
drwxr-xr-x 1 iobroker users         128 May  2  2021 yahka.1.hapdata
drwxr-xr-x 1 iobroker users          22 Jun 30  2020 zigbee_0
root@iobroker:/opt/iobroker/iobroker-data#

root@iobroker:/opt/iobroker/iobroker-data# iob status
iobroker is running on this host.


Objects type: jsonl
States  type: redis
root@iobroker:/opt/iobroker/iobroker-data#

[Anzic]

@apollon77 weird but changing IOB_STATESDB_TYPE to jsonl didn't help (. The situation is the same as before. What can I do to catch the error?

[Anzic]

Пользователь @apollon77 написал в Mini-HowTo: Cannot find view "system" for search "host":

show the content of /opt/iobroker/iobroker-data while running and ideally directly on such a restart.

first load after stopping the container:
from host:

Anzor@NAS:/volume2/doker_mapping/iobroker/iobroker-data$ ls -la
total 32108
drwxrwxr-x 1 Anzor users      646 May 12 12:15 .
drwxrwxr-x 1 Anzor users      764 May 12 12:14 ..
drwxr-xr-x 1 Anzor users       64 Apr 15 01:12 backitup
drwxrwxr-x 1 Anzor users     1904 May 12 12:15 backup-objects
drwxr-xr-x 1 Anzor users      660 Feb 27 21:41 esphome.0
drwxrwxr-x 1 Anzor users     4128 May 11 02:07 files
drwxrwxrwx 1 Anzor users       58 Mar 27 13:15 ham_0
drwxr-xr-x 1 Anzor users        0 Oct 31  2021 homekit-controller.0
-rw-rwxr-- 1 Anzor users     3593 May 12 12:15 iobroker.json
drwxr-xr-x 1 Anzor users        0 Jun 30  2020 letsencrypt
drwxrwxrwx 1 Anzor users       22 Jun 30  2020 lgtv_0
drwxr-xr-x 1 Anzor users       22 Jul 10  2020 lgtv_1
drwxrwxrwx 1 Anzor users       24 Jun 30  2020 mercury_0
drwxrwxrwx 1 Anzor users      200 May 10 23:08 my-backup
drwxr-xr-x 1 Anzor users      714 May  8 11:35 node-red
-rw-rw-rw- 1 Anzor users        3 May 12 11:51 notifications.json
-rw-r--r-- 1 Anzor  1000    23624 May 12 12:15 objects.json
-rw-r--r-- 1 Anzor  1000    23624 May 12 12:15 objects.json.bak
-rw-r--r-- 1 Anzor users    23624 May 11 22:48 objects.json.bak.migrated
-rw-rw-rw- 1 Anzor users 32737610 May 12 12:15 objects.jsonl
-rw-rw-rw- 1 Anzor users    12762 May 11 01:57 objects.jsonl.444
-rw-rw-rw- 1 Anzor users    12762 May 11 02:01 objects.jsonl.gj
-rw-r--r-- 1 Anzor users    23624 May 11 22:58 objects.json.migrated
drwxr-xr-x 1 Anzor users       60 Aug  6  2020 sayit
drwxrwxrwx 1 Anzor users        0 Apr 24 02:01 telegram_0
drwxrwxrwx 1 Anzor users       32 Sep 11  2021 tmp
drwxr-xr-x 1 Anzor users       18 Sep 14  2020 tuya_0
drwxrwxrwx 1 Anzor users      640 May  7 00:19 yahka.0.hapdata
drwxr-xr-x 1 Anzor users      128 May  2  2021 yahka.1.hapdata
drwxr-xr-x 1 Anzor users       22 Jun 30  2020 zigbee_0
Anzor@NAS:/volume2/doker_mapping/iobroker/iobroker-data$

from container:

root@iobroker:/opt/iobroker/iobroker-data# ls -la
total 32108
drwxrwxr-x 1 iobroker users         646 May 12 12:15 .
drwxrwxr-x 1 iobroker users         764 May 12 12:14 ..
drwxr-xr-x 1 iobroker users          64 Apr 15 01:12 backitup
drwxrwxr-x 1 iobroker users        1904 May 12 12:15 backup-objects
drwxr-xr-x 1 iobroker users         660 Feb 27 21:41 esphome.0
drwxrwxr-x 1 iobroker users        4128 May 11 02:07 files
drwxrwxrwx 1 iobroker users          58 Mar 27 13:15 ham_0
drwxr-xr-x 1 iobroker users           0 Oct 31  2021 homekit-controller.0
-rw-rwxr-- 1 iobroker users        3593 May 12 12:15 iobroker.json
drwxr-xr-x 1 iobroker users           0 Jun 30  2020 letsencrypt
drwxrwxrwx 1 iobroker users          22 Jun 30  2020 lgtv_0
drwxr-xr-x 1 iobroker users          22 Jul 10  2020 lgtv_1
drwxrwxrwx 1 iobroker users          24 Jun 30  2020 mercury_0
drwxrwxrwx 1 iobroker users         200 May 10 23:08 my-backup
drwxr-xr-x 1 iobroker users         714 May  8 11:35 node-red
-rw-rw-rw- 1 iobroker users           3 May 12 11:51 notifications.json
-rw-r--r-- 1 iobroker iobroker    23624 May 12 12:15 objects.json
-rw-r--r-- 1 iobroker iobroker    23624 May 12 12:15 objects.json.bak
-rw-r--r-- 1 iobroker users       23624 May 11 22:48 objects.json.bak.migrated
-rw-rw-rw- 1 iobroker users    32737610 May 12 12:15 objects.jsonl
-rw-rw-rw- 1 iobroker users       12762 May 11 01:57 objects.jsonl.444
-rw-rw-rw- 1 iobroker users       12762 May 11 02:01 objects.jsonl.gj
-rw-r--r-- 1 iobroker users       23624 May 11 22:58 objects.json.migrated
drwxr-xr-x 1 iobroker users          60 Aug  6  2020 sayit
drwxrwxrwx 1 iobroker users           0 Apr 24 02:01 telegram_0
drwxrwxrwx 1 iobroker users          32 Sep 11  2021 tmp
drwxr-xr-x 1 iobroker users          18 Sep 14  2020 tuya_0
drwxrwxrwx 1 iobroker users         640 May  7 00:19 yahka.0.hapdata
drwxr-xr-x 1 iobroker users         128 May  2  2021 yahka.1.hapdata
drwxr-xr-x 1 iobroker users          22 Jun 30  2020 zigbee_0
root@iobroker:/opt/iobroker/iobroker-data#

iobroker.json - iobroker.json

I think I know the answer. I changed the docker compose, but the container remained with the old settings, so everything breaks. Now I will recreate the container and check.

[Anzic]

@apollon77 no luck. after recreating the container, the objects.jsonl file is still overwritten

immediately after creating the container:

root@iobroker:/opt/iobroker/iobroker-data# ls -la
total 112
drwxrwxr-x 1 iobroker users      590 May 12 12:46 .
drwxrwxr-x 1 iobroker users      764 May 12 12:38 ..
drwxr-xr-x 1 iobroker users       64 Apr 15 01:12 backitup
drwxrwxr-x 1 iobroker users     1968 May 12 12:38 backup-objects
drwxr-xr-x 1 iobroker users      660 Feb 27 21:41 esphome.0
drwxrwxr-x 1 iobroker users     4128 May 11 02:07 files
drwxrwxrwx 1 iobroker users       58 Mar 27 13:15 ham_0
drwxr-xr-x 1 iobroker users        0 Oct 31  2021 homekit-controller.0
-rw-rwxr-- 1 iobroker users     3601 May 12 12:43 iobroker.json
drwxr-xr-x 1 iobroker users        0 Jun 30  2020 letsencrypt
drwxrwxrwx 1 iobroker users       22 Jun 30  2020 lgtv_0
drwxr-xr-x 1 iobroker users       22 Jul 10  2020 lgtv_1
drwxrwxrwx 1 iobroker users       24 Jun 30  2020 mercury_0
drwxrwxrwx 1 iobroker users      200 May 10 23:08 my-backup
drwxr-xr-x 1 iobroker users      714 May  8 11:35 node-red
-rw-rw-rw- 1 iobroker users        3 May 12 11:51 notifications.json
-rw-r--r-- 1 iobroker iobroker 23624 May 12 12:38 objects.json.bak.migrated
-rw-r--r-- 1 iobroker iobroker 24253 May 12 12:43 objects.jsonl
-rw-rw-rw- 1 iobroker users    12762 May 11 01:57 objects.jsonl.444
-rw-rw-rw- 1 iobroker users    12762 May 11 02:01 objects.jsonl.gj
-rw-r--r-- 1 iobroker iobroker 23624 May 12 12:38 objects.json.migrated
drwxr-xr-x 1 iobroker users       60 Aug  6  2020 sayit
drwxrwxrwx 1 iobroker users        0 Apr 24 02:01 telegram_0
drwxrwxrwx 1 iobroker users       32 Sep 11  2021 tmp
drwxr-xr-x 1 iobroker users       18 Sep 14  2020 tuya_0
drwxrwxrwx 1 iobroker users      640 May  7 00:19 yahka.0.hapdata
drwxr-xr-x 1 iobroker users      128 May  2  2021 yahka.1.hapdata
drwxr-xr-x 1 iobroker users       22 Jun 30  2020 zigbee_0
root@iobroker:/opt/iobroker/iobroker-data#

[Fix_Flix]

meine Backups sind leider zu alt sprich die Datein sind zu alt und alle kaputt ich habe aber noch hilft das?

LG Felix

[Thomas Braun]

@fix_flix

Bilder von Konsolentext kann man nicht lesen oder gar daraus was kopieren.
Stell TEXT auch als TEXT (in CodeTags eingebettet) hier rein.

[rieders]

Hallo
In meinem Verzeichnis vom IOBroker fehlt die objects.jsonl Datei.

Unter iobrker staus bekomme ich diese Meldung.
Objects type: jsonl
States type: jsonl

Wie kann ich die jsonl Datei wieder herstellen?

André

[Thomas Braun]

@rieders sagte in Mini-HowTo: Cannot find view "system" for search "host":

In meinem Verzeichnis vom IOBroker

In welchem? Die Verzeichnisse haben sich nicht geändert, lediglich die Datei-Endung.

[apollon77]

@rieders Welche Files haste denn? und was ist so in backup-objects verzeichnis?

[rieders]

Die Datei hat sich wieder angelegt!!!!
Ich habe aber noch probleme das sich Objekte von Fhem nicht importieren lassen.
Die laufen über MQTT.
Unter Iobroker erhalte ich diese Meldung
fhem.0.Wasserzaehler_garten.: Error: The id "fhem.0.Wasserzaehler_garten." is invalid. Ids are not allowed to end in "." [main] [eventFHEM] [processEvent] [parseEvent] [eventOK] [setState] [processSetState] [setStateDoWrite]

Vielen Dank für die schnellen Antworten
André