Navigation

    Logo
    • Register
    • Login
    • Search
    • Recent
    • Tags
    • Unread
    • Categories
    • Unreplied
    • Popular
    • GitHub
    • Docu
    • Hilfe
    1. Home
    2. Deutsch
    3. Error/Bug
    4. Objects database error: connect ECONNREFUSED 127.0.0.1:9001

    NEWS

    • Neuer Blog: Fotos und Eindrücke aus Solingen

    • ioBroker@Smart Living Forum Solingen, 14.06. - Agenda added

    • ioBroker goes Matter ... Matter Adapter in Stable

    Objects database error: connect ECONNREFUSED 127.0.0.1:9001

    This topic has been deleted. Only users with topic management privileges can see it.
    • A
      anno171986 last edited by

      Moin, ich habe seit ein paar tagen das problem, das mein iobroker fast gar nicht mehr läuft, wenn er denn kurz läuft ist er sehr träge.

      Hier die Infos:

      • Adaptername: iobroker Allgemein
      • Link zu Adapterrepository: n/a
      • Adapterversion: n/a
      • js-controller Version: 5.0.19
      • Admin Version: 6.13.16
      • Hardwaresystem: Pi4.
      • Arbeitsspeicher: 8 GB
      • Festplattenart: SSD
      • Betriebssystem: Raspbian GNU/Linux 11 (bullseye)
      • Nodejs-Version: v18.20.2
      • NPM-Version: 10.5.0
      • Installationsart: Skript
      • Image
      • Ort, Name der Imagedatei: Raspberry Pi imager

      iob diag Ausgabe:

      Skript v.2024-04-21
      
      *** BASE SYSTEM ***
         Static hostname: raspberrypi
               Icon name: computer
        Operating System: Raspbian GNU/Linux 11 (bullseye)
                  Kernel: Linux 6.1.21-v8+
            Architecture: arm64
      
      Model           : Raspberry Pi 4 Model B Rev 1.4
      Docker          : false
      Virtualization  : none
      Kernel          : aarch64
      Userland        : 32 bit
      
      Systemuptime and Load:
       18:26:18 up 12:07,  2 users,  load average: 2.22, 2.45, 2.47
      CPU threads: 4
      
      
      *** RASPBERRY THROTTLING ***
      Current issues:
      No throttling issues detected.
      
      Previously detected issues:
      No throttling issues detected.
      
      *** Time and Time Zones ***
                     Local time: Mon 2024-05-06 18:26:18 CEST
                 Universal time: Mon 2024-05-06 16:26:18 UTC
                       RTC time: n/a
                      Time zone: Europe/Berlin (CEST, +0200)
      System clock synchronized: yes
                    NTP service: active
                RTC in local TZ: no
      
      *** Users and Groups ***
      User that called 'iob diag':
      pi
      HOME=/home/pi
      GROUPS=pi adm dialout cdrom sudo audio video plugdev games users input netdev lpadmin nordvpn gpio i2c spi iobroker
      
      User that is running 'js-controller':
      iobroker
      HOME=/home/iobroker
      GROUPS=iobroker tty dialout audio video plugdev bluetooth nordvpn gpio i2c
      
      *** Display-Server-Setup ***
      Display-Server: true
      Desktop:
      Terminal:       tty
      Boot Target:    graphical.target
      
      *** MEMORY ***
                     total        used        free      shared  buff/cache   available
      Mem:            7.8G        1.2G        5.2G        1.0M        1.4G        6.5G
      Swap:           999M          0B        999M
      Total:          8.8G        1.2G        6.2G
      
      Active iob-Instances:   1
      
               7811 M total memory
               1201 M used memory
               1506 M active memory
                873 M inactive memory
               5231 M free memory
                198 M buffer memory
               1179 M swap cache
                999 M total swap
                  0 M used swap
                999 M free swap
      
      *** top - Table Of Processes  ***
      top - 18:26:19 up 12:07,  2 users,  load average: 2.22, 2.45, 2.47
      Tasks: 175 total,   3 running, 163 sleeping,   9 stopped,   0 zombie
      %Cpu(s): 34.3 us, 15.7 sy,  0.0 ni, 50.0 id,  0.0 wa,  0.0 hi,  0.0 si,  0.0 st
      MiB Mem :   7811.3 total,   5232.4 free,   1200.9 used,   1377.9 buff/cache
      MiB Swap:   1000.0 total,   1000.0 free,      0.0 used.   6487.2 avail Mem
      
      *** FAILED SERVICES ***
      
        UNIT                        LOAD   ACTIVE SUB    DESCRIPTION
      * bthelper@hci0.service       loaded failed failed Raspberry Pi bluetooth helper
      * gpio-html-automatik.service loaded failed failed Rolladenautomatik
      
      LOAD   = Reflects whether the unit definition was properly loaded.
      ACTIVE = The high-level unit activation state, i.e. generalization of SUB.
      SUB    = The low-level unit activation state, values depend on unit type.
      2 loaded units listed.
      
      *** FILESYSTEM ***
      Filesystem     Type      Size  Used Avail Use% Mounted on
      /dev/root      ext4      117G   29G   82G  27% /
      devtmpfs       devtmpfs  3.6G     0  3.6G   0% /dev
      tmpfs          tmpfs     3.9G  4.0K  3.9G   1% /dev/shm
      tmpfs          tmpfs     1.6G  1.3M  1.6G   1% /run
      tmpfs          tmpfs     5.0M  4.0K  5.0M   1% /run/lock
      /dev/sda1      vfat      476M   51M  425M  11% /boot
      tmpfs          tmpfs     782M   32K  782M   1% /run/user/1000
      
      Messages concerning ext4 filesystem in dmesg:
      
      Show mounted filesystems:
      TARGET                           SOURCE     FSTYPE     OPTIONS
      /                                /dev/sda2  ext4       rw,noatime
      |-/dev                           devtmpfs   devtmpfs   rw,relatime,size=3735168k,nr_inodes=933792,mode=755
      | |-/dev/shm                     tmpfs      tmpfs      rw,nosuid,nodev
      | |-/dev/pts                     devpts     devpts     rw,nosuid,noexec,relatime,gid=5,mode=620,ptmxmode=000
      | `-/dev/mqueue                  mqueue     mqueue     rw,nosuid,nodev,noexec,relatime
      |-/proc                          proc       proc       rw,relatime
      | `-/proc/sys/fs/binfmt_misc     systemd-1  autofs     rw,relatime,fd=29,pgrp=1,timeout=0,minproto=5,maxproto=5,direct
      |-/sys                           sysfs      sysfs      rw,nosuid,nodev,noexec,relatime
      | |-/sys/kernel/security         securityfs securityfs rw,nosuid,nodev,noexec,relatime
      | |-/sys/fs/cgroup               cgroup2    cgroup2    rw,nosuid,nodev,noexec,relatime,nsdelegate,memory_recursiveprot
      | |-/sys/fs/pstore               pstore     pstore     rw,nosuid,nodev,noexec,relatime
      | |-/sys/fs/bpf                  bpf        bpf        rw,nosuid,nodev,noexec,relatime,mode=700
      | |-/sys/kernel/debug            debugfs    debugfs    rw,nosuid,nodev,noexec,relatime
      | |-/sys/kernel/tracing          tracefs    tracefs    rw,nosuid,nodev,noexec,relatime
      | |-/sys/fs/fuse/connections     fusectl    fusectl    rw,nosuid,nodev,noexec,relatime
      | `-/sys/kernel/config           configfs   configfs   rw,nosuid,nodev,noexec,relatime
      |-/run                           tmpfs      tmpfs      rw,nosuid,nodev,size=1599760k,nr_inodes=819200,mode=755
      | |-/run/lock                    tmpfs      tmpfs      rw,nosuid,nodev,noexec,relatime,size=5120k
      | |-/run/rpc_pipefs              sunrpc     rpc_pipefs rw,relatime
      | `-/run/user/1000               tmpfs      tmpfs      rw,nosuid,nodev,relatime,size=799876k,nr_inodes=199969,mode=700,uid=1000,gid=1000
      |-/home/pi/MyCloudEx2_anno171986 systemd-1  autofs     rw,relatime,fd=46,pgrp=1,timeout=0,minproto=5,maxproto=5,direct
      |-/home/pi/MyCloudEx2_claudia    systemd-1  autofs     rw,relatime,fd=47,pgrp=1,timeout=0,minproto=5,maxproto=5,direct
      `-/boot                          /dev/sda1  vfat       rw,relatime,fmask=0022,dmask=0022,codepage=437,iocharset=ascii,shortname=mixed,errors=remount-ro
      
      Files in neuralgic directories:
      
      /var:
      12G     /var/
      5.7G    /var/log
      3.8G    /var/log/journal/1087cd60d21846fc8a373547c7447138
      3.8G    /var/log/journal
      3.4G    /var/cache/apt
      
      Archived and active journals take up 3.7G in the file system.
      
      /opt/iobroker/backups:
      557M    /opt/iobroker/backups/
      
      /opt/iobroker/iobroker-data:
      1.4G    /opt/iobroker/iobroker-data/
      876M    /opt/iobroker/iobroker-data/files
      463M    /opt/iobroker/iobroker-data/files/vis-2-beta
      428M    /opt/iobroker/iobroker-data/files/vis-2-beta/static
      426M    /opt/iobroker/iobroker-data/files/vis-2-beta/static/js
      
      The five largest files in iobroker-data are:
      277M    /opt/iobroker/iobroker-data/states.jsonl
      35M     /opt/iobroker/iobroker-data/files/devices.admin/static/js/main.24f2bb56.js.map
      33M     /opt/iobroker/iobroker-data/files/iot.admin/static/js/main.1797d034.js.map
      24M     /opt/iobroker/iobroker-data/objects.jsonl
      24M     /opt/iobroker/iobroker-data/files/web.admin/static/js/main.135279a0.js.map
      
      USB-Devices by-id:
      USB-Sticks -  Avoid direct links to /dev/tty* in your adapter setups, please always prefer the links 'by-id':
      
      No Devices found 'by-id'
      
      HINT:
      Your zigbee.0 COM-Port is NOT matching 'by-id'. Please check your setting:
      /dev/ttyACM0
      
      
      
      *** NodeJS-Installation ***
      
      /usr/bin/nodejs         v18.20.2
      /usr/bin/node           v18.20.2
      /usr/bin/npm            10.5.0
      /usr/bin/npx            10.5.0
      /usr/bin/corepack       0.25.2
      
      
      nodejs:
        Installed: 18.20.2-1nodesource1
        Candidate: 18.20.2-1nodesource1
        Version table:
       *** 18.20.2-1nodesource1 1001
              500 https://deb.nodesource.com/node_18.x nodistro/main armhf Packages
              100 /var/lib/dpkg/status
           18.20.1-1nodesource1 1001
              500 https://deb.nodesource.com/node_18.x nodistro/main armhf Packages
           18.20.0-1nodesource1 1001
              500 https://deb.nodesource.com/node_18.x nodistro/main armhf Packages
           18.19.1-1nodesource1 1001
              500 https://deb.nodesource.com/node_18.x nodistro/main armhf Packages
           18.19.0-1nodesource1 1001
              500 https://deb.nodesource.com/node_18.x nodistro/main armhf Packages
           18.18.2-1nodesource1 1001
              500 https://deb.nodesource.com/node_18.x nodistro/main armhf Packages
           18.18.1-1nodesource1 1001
              500 https://deb.nodesource.com/node_18.x nodistro/main armhf Packages
           18.18.0-1nodesource1 1001
              500 https://deb.nodesource.com/node_18.x nodistro/main armhf Packages
           18.17.1-1nodesource1 1001
              500 https://deb.nodesource.com/node_18.x nodistro/main armhf Packages
           18.17.0-1nodesource1 1001
              500 https://deb.nodesource.com/node_18.x nodistro/main armhf Packages
           18.16.1-1nodesource1 1001
              500 https://deb.nodesource.com/node_18.x nodistro/main armhf Packages
           18.16.0-1nodesource1 1001
              500 https://deb.nodesource.com/node_18.x nodistro/main armhf Packages
           18.15.0-1nodesource1 1001
              500 https://deb.nodesource.com/node_18.x nodistro/main armhf Packages
           18.14.2-1nodesource1 1001
              500 https://deb.nodesource.com/node_18.x nodistro/main armhf Packages
           18.14.1-1nodesource1 1001
              500 https://deb.nodesource.com/node_18.x nodistro/main armhf Packages
           18.14.0-1nodesource1 1001
              500 https://deb.nodesource.com/node_18.x nodistro/main armhf Packages
           18.13.0-1nodesource1 1001
              500 https://deb.nodesource.com/node_18.x nodistro/main armhf Packages
           18.12.0-1nodesource1 1001
              500 https://deb.nodesource.com/node_18.x nodistro/main armhf Packages
           18.11.0-1nodesource1 1001
              500 https://deb.nodesource.com/node_18.x nodistro/main armhf Packages
           18.10.0-1nodesource1 1001
              500 https://deb.nodesource.com/node_18.x nodistro/main armhf Packages
           18.9.1-1nodesource1 1001
              500 https://deb.nodesource.com/node_18.x nodistro/main armhf Packages
           18.9.0-1nodesource1 1001
              500 https://deb.nodesource.com/node_18.x nodistro/main armhf Packages
           18.8.0-1nodesource1 1001
              500 https://deb.nodesource.com/node_18.x nodistro/main armhf Packages
           18.7.0-1nodesource1 1001
              500 https://deb.nodesource.com/node_18.x nodistro/main armhf Packages
           18.6.0-1nodesource1 1001
              500 https://deb.nodesource.com/node_18.x nodistro/main armhf Packages
           18.5.0-1nodesource1 1001
              500 https://deb.nodesource.com/node_18.x nodistro/main armhf Packages
           18.4.0-1nodesource1 1001
              500 https://deb.nodesource.com/node_18.x nodistro/main armhf Packages
           18.3.0-1nodesource1 1001
              500 https://deb.nodesource.com/node_18.x nodistro/main armhf Packages
           18.2.0-1nodesource1 1001
              500 https://deb.nodesource.com/node_18.x nodistro/main armhf Packages
           18.1.0-1nodesource1 1001
              500 https://deb.nodesource.com/node_18.x nodistro/main armhf Packages
           18.0.0-1nodesource1 1001
              500 https://deb.nodesource.com/node_18.x nodistro/main armhf Packages
           12.22.12~dfsg-1~deb11u4 500
              500 http://raspbian.raspberrypi.org/raspbian bullseye/main armhf Packages
      
      Temp directories causing npm8 problem: 0
      No problems detected
      
      Errors in npm tree:
      
      *** ioBroker-Installation ***
      
      ioBroker Status
       Objects database error: connect ECONNREFUSED 127.0.0.1:9001
       States database error: connect ECONNREFUSED 127.0.0.1:9000
       States database error: connect ECONNREFUSED 127.0.0.1:9000
       Objects database error: connect ECONNREFUSED 127.0.0.1:9001
       States database error: connect ECONNREFUSED 127.0.0.1:9000
      iobroker is running on this host.
      
      
      Objects type: jsonl
      States  type: jsonl
      
      Core adapters versions
      js-controller:  5.0.19
      admin:          6.13.16
      javascript:     7.8.0
      
      nodejs modules from github:     1
      +-- iobroker.sourceanalytix@0.4.14 (git+ssh://git@github.com/DrozmotiX/ioBroker.sourceanalytix.git#87a9b7837569274a136c4fa03ee6fbfd8a20f183)
      
      Adapter State
        system.adapter.admin.0                  : admin                 : raspberrypi                              -  enabled, port: 8081, bind: 0.0.0.0, run as: admin
        system.adapter.alexa2.0                 : alexa2                : raspberrypi                              -  enabled
        system.adapter.backitup.0               : backitup              : raspberrypi                              -  enabled
        system.adapter.daswetter.0              : daswetter             : raspberrypi                              -  enabled
        system.adapter.device-reminder.0        : device-reminder       : raspberrypi                              -  enabled
        system.adapter.devices.0                : devices               : raspberrypi                              -  enabled
        system.adapter.echarts.0                : echarts               : raspberrypi                              -  enabled
        system.adapter.ems-esp.0                : ems-esp               : raspberrypi                              -  enabled
        system.adapter.flot.0                   : flot                  : raspberrypi                              - disabled
        system.adapter.harmony.0                : harmony               : raspberrypi                              -  enabled
        system.adapter.heatingcontrol.0         : heatingcontrol        : raspberrypi                              -  enabled
        system.adapter.ical.0                   : ical                  : raspberrypi                              -  enabled
        system.adapter.info.0                   : info                  : raspberrypi                              -  enabled
        system.adapter.iot.0                    : iot                   : raspberrypi                              -  enabled
        system.adapter.javascript.0             : javascript            : raspberrypi                              -  enabled
        system.adapter.lgtv.0                   : lgtv                  : raspberrypi                              -  enabled
        system.adapter.lupusec.0                : lupusec               : raspberrypi                              -  enabled
        system.adapter.mihome-vacuum.0          : mihome-vacuum         : raspberrypi                              -  enabled, port: 54321
        system.adapter.mqtt.0                   : mqtt                  : raspberrypi                              -  enabled, port: 1885, bind: 0.0.0.0
        system.adapter.octoprint.0              : octoprint             : raspberrypi                              -  enabled
        system.adapter.pvforecast.0             : pvforecast            : raspberrypi                              -  enabled
        system.adapter.simple-api.0             : simple-api            : raspberrypi                              -  enabled, port: 8087, bind: 192.168.178.12, run as: admin
        system.adapter.sourceanalytix.0         : sourceanalytix        : raspberrypi                              -  enabled
        system.adapter.sql.0                    : sql                   : raspberrypi                              -  enabled, port: 3306
        system.adapter.tankerkoenig.0           : tankerkoenig          : raspberrypi                              -  enabled
        system.adapter.telegram.0               : telegram              : raspberrypi                              -  enabled, port: 8443, bind: 0.0.0.0
        system.adapter.vis-2-beta.0             : vis-2-beta            : raspberrypi                              - disabled
        system.adapter.vis-2-widgets-energy.0   : vis-2-widgets-energy  : raspberrypi                              -  enabled
        system.adapter.vis-2-widgets-gauges.0   : vis-2-widgets-gauges  : raspberrypi                              -  enabled
        system.adapter.vis-2-widgets-material.0 : vis-2-widgets-material: raspberrypi                              -  enabled
        system.adapter.vis-colorpicker.0        : vis-colorpicker       : raspberrypi                              - disabled
        system.adapter.vis-jqui-mfd.0           : vis-jqui-mfd          : raspberrypi                              - disabled
        system.adapter.vis-timeandweather.0     : vis-timeandweather    : raspberrypi                              -  enabled
        system.adapter.vis.0                    : vis                   : raspberrypi                              -  enabled
        system.adapter.web.0                    : web                   : raspberrypi                              -  enabled, port: 8082, bind: 0.0.0.0, run as: admin
        system.adapter.worx.0                   : worx                  : raspberrypi                              - disabled
        system.adapter.yamaha.0                 : yamaha                : raspberrypi                              -  enabled
        system.adapter.zigbee.0                 : zigbee                : raspberrypi                              -  enabled, port: /dev/ttyACM0
      
      + instance is alive
      
      Enabled adapters with bindings
        system.adapter.admin.0                  : admin                 : raspberrypi                              -  enabled, port: 8081, bind: 0.0.0.0, run as: admin
        system.adapter.mihome-vacuum.0          : mihome-vacuum         : raspberrypi                              -  enabled, port: 54321
        system.adapter.mqtt.0                   : mqtt                  : raspberrypi                              -  enabled, port: 1885, bind: 0.0.0.0
        system.adapter.simple-api.0             : simple-api            : raspberrypi                              -  enabled, port: 8087, bind: 192.168.178.12, run as: admin
        system.adapter.sql.0                    : sql                   : raspberrypi                              -  enabled, port: 3306
        system.adapter.telegram.0               : telegram              : raspberrypi                              -  enabled, port: 8443, bind: 0.0.0.0
        system.adapter.web.0                    : web                   : raspberrypi                              -  enabled, port: 8082, bind: 0.0.0.0, run as: admin
        system.adapter.zigbee.0                 : zigbee                : raspberrypi                              -  enabled, port: /dev/ttyACM0
      
      ioBroker-Repositories
      Stable (default): http://download.iobroker.net/sources-dist.json
      Beta (latest) : http://download.iobroker.net/sources-dist-latest.json
      
      Active repo(s): Stable (default)
      
      Installed ioBroker-Instances
       Connection is closed.
      Uncaught Rejection: Error: Objects DB is not allowed to start in the current Multihost environment
          at Redis.<anonymous> (/opt/iobroker/node_modules/@iobroker/db-objects-redis/build/lib/objects/objectsInRedisClient.js:493:23)
          at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
      
      Objects and States
      Please stand by - This may take a while
      Objects:        9815
      States:         1
      
      *** OS-Repositories and Updates ***
      Hit:1 http://archive.raspberrypi.org/debian bullseye InRelease
      Hit:2 http://raspbian.raspberrypi.org/raspbian bullseye InRelease
      Hit:3 https://deb.nodesource.com/node_18.x nodistro InRelease
      Hit:4 https://apt.grafana.com stable InRelease
      Hit:5 https://repo.nordvpn.com/deb/nordvpn/debian stable InRelease
      Reading package lists...
      Pending Updates: 4
      
      *** Listening Ports ***
      Active Internet connections (only servers)
      Proto Recv-Q Send-Q Local Address           Foreign Address         State       User       Inode      PID/Program name
      tcp        0      0 192.168.178.12:3306     0.0.0.0:*               LISTEN      111        16463      693/mariadbd
      tcp        0      0 0.0.0.0:52051           0.0.0.0:*               LISTEN      1000       16047      418/MyMediaForAlexa
      tcp        0      0 0.0.0.0:52050           0.0.0.0:*               LISTEN      1000       16051      418/MyMediaForAlexa
      tcp        0      0 100.120.141.7:49111     0.0.0.0:*               LISTEN      1001       19564      1144/nordfileshared
      tcp        0      0 127.0.0.1:631           0.0.0.0:*               LISTEN      0          879        567/cupsd
      tcp        0      0 0.0.0.0:80              0.0.0.0:*               LISTEN      0          16957      768/python3
      tcp        0      0 0.0.0.0:22              0.0.0.0:*               LISTEN      0          15575      590/sshd: /usr/sbin
      tcp        0      0 127.0.0.1:53            0.0.0.0:*               LISTEN      0          13944      406/connmand
      tcp6       0      0 ::1:631                 :::*                    LISTEN      0          878        567/cupsd
      tcp6       0      0 ::1:53                  :::*                    LISTEN      0          13948      406/connmand
      tcp6       0      0 :::3389                 :::*                    LISTEN      110        14098      648/xrdp
      tcp6       0      0 :::22                   :::*                    LISTEN      0          15577      590/sshd: /usr/sbin
      tcp6       0      0 :::4369                 :::*                    LISTEN      0          673        1/init
      tcp6       0      0 ::1:3350                :::*                    LISTEN      0          15513      584/xrdp-sesman
      udp        0      0 127.0.0.1:53            0.0.0.0:*                           0          13936      406/connmand
      udp        0      0 0.0.0.0:68              0.0.0.0:*                           0          15908      505/dhcpcd
      udp        0      0 0.0.0.0:631             0.0.0.0:*                           0          16396      598/cups-browsed
      udp        0      0 0.0.0.0:58107           0.0.0.0:*                           0          16257      769/nordvpnd
      udp        0      0 0.0.0.0:49954           0.0.0.0:*                           0          18607      -
      udp        0      0 127.0.0.1:45893         0.0.0.0:*                           0          17184      769/nordvpnd
      udp        0      0 0.0.0.0:5353            0.0.0.0:*                           108        13665      403/avahi-daemon: r
      udp        0      0 0.0.0.0:42260           0.0.0.0:*                           0          16255      769/nordvpnd
      udp        0      0 0.0.0.0:38742           0.0.0.0:*                           0          14213      406/connmand
      udp        0      0 127.0.0.1:34900         0.0.0.0:*                           0          17183      769/nordvpnd
      udp        0      0 0.0.0.0:47682           0.0.0.0:*                           0          16256      769/nordvpnd
      udp        0      0 0.0.0.0:60348           0.0.0.0:*                           108        13667      403/avahi-daemon: r
      udp6       0      0 :::45020                :::*                                108        13668      403/avahi-daemon: r
      udp6       0      0 ::1:53                  :::*                                0          13940      406/connmand
      udp6       0      0 :::546                  :::*                                0          16042      505/dhcpcd
      udp6       0      0 :::49954                :::*                                0          18608      -
      udp6       0      0 :::5353                 :::*                                108        13666      403/avahi-daemon: r
      udp6       0      0 :::43390                :::*                                0          16056      769/nordvpnd
      
      *** Log File - Last 25 Lines ***
      
      2024-05-06 18:27:35.680  - info: telegram.0 (28112) Terminated (NO_ERROR): Without reason
      2024-05-06 18:27:36.678  - info: javascript.0 (28040) terminating with timeout
      2024-05-06 18:27:36.684  - info: admin.0 (28001) terminating with timeout
      2024-05-06 18:27:36.687  - info: admin.0 (28001) Terminated (NO_ERROR): Without reason
      2024-05-06 18:27:36.689  - info: javascript.0 (28040) Terminated (NO_ERROR): Without reason
      2024-05-06 18:27:40.162  - error: javascript.0 (28040) Objects database error: connect ECONNREFUSED 127.0.0.1:9001
      2024-05-06 18:27:40.171  - warn: admin.0 (28001) get state error: DB closed
      2024-05-06 18:27:40.171  - warn: javascript.0 (28040) get state error: DB closed
      2024-05-06 18:27:40.171  - warn: admin.0 (28001) get state error: DB closed
      2024-05-06 18:27:40.178  - info: admin.0 (28001) terminating
      2024-05-06 18:27:40.179  - info: admin.0 (28001) terminating
      2024-05-06 18:27:40.191  - error: sql.0 (28075) States database error: connect ECONNREFUSED 127.0.0.1:9000
      2024-05-06 18:27:40.194  - error: sql.0 (28075) Objects database error: connect ECONNREFUSED 127.0.0.1:9001
      2024-05-06 18:27:45.204  - error: sql.0 (28075) Objects database error: connect ECONNREFUSED 127.0.0.1:9001
      2024-05-06 18:27:45.206  - error: sql.0 (28075) States database error: connect ECONNREFUSED 127.0.0.1:9000
      2024-05-06 18:27:46.189  - info: sql.0 (28075) terminating with timeout
      2024-05-06 18:27:46.191  - info: sql.0 (28075) Terminated (NO_ERROR): Without reason
      2024-05-06 18:27:50.216  - error: sql.0 (28075) Objects database error: connect ECONNREFUSED 127.0.0.1:9001
      2024-05-06 18:27:56.833  - info: host.raspberrypi iobroker.js-controller version 5.0.19 js-controller starting
      2024-05-06 18:27:56.843  - info: host.raspberrypi Copyright (c) 2014-2023 bluefox, 2014 hobbyquaker
      2024-05-06 18:27:56.845  - info: host.raspberrypi hostname: raspberrypi, node: v18.20.2
      2024-05-06 18:27:56.846  - info: host.raspberrypi ip addresses: 192.168.178.12 2003:dd:bf3a:b100:7de:bd88:cf59:322e fe80::be23:e850:8020:5a50 100.120.141.7
      2024-05-06 18:27:59.928  - info: host.raspberrypi-Server  Error inMem-objects listening on port 9001: Error: listen EADDRINUSE: address already in use 127.0.0.1:9001
      2024-05-06 18:28:26.875  - error: host.raspberrypi No connection to databases possible, restart
      2024-05-06 18:28:26.884  - info: host.raspberrypi iobroker _restart
      
      
      Thomas Braun 1 Reply Last reply Reply Quote 0
      • Thomas Braun
        Thomas Braun Most Active @anno171986 last edited by Thomas Braun

        @anno171986

        Installier das Betriebssystem neu, diesmal in der 64Bit-Lite-Version. Also 'bookworm' ohne Desktop.

        A 2 Replies Last reply Reply Quote 0
        • A
          anno171986 @Thomas Braun last edited by

          @thomas-braun also komplett die SSD platt machen? Über den Imager? Über den Backitup Adapter danach dann gleich alle Backups einspielen?

          Thomas Braun 1 Reply Last reply Reply Quote 0
          • Thomas Braun
            Thomas Braun Most Active @anno171986 last edited by

            @anno171986

            https://forum.iobroker.net/topic/51869/installation-auf-raspi-einfacher-geht-s-nicht

            Und dann ein Backup wählen, das noch keinen Fehler hat.

            A 1 Reply Last reply Reply Quote 0
            • A
              anno171986 @Thomas Braun last edited by

              @thomas-braun Ich habe BAckups von iobroker, Javascripts, MySQl und Zigbee.

              Gibt es eine empfohlene Reihenfolge?

              Thomas Braun 1 Reply Last reply Reply Quote 0
              • Thomas Braun
                Thomas Braun Most Active @anno171986 last edited by

                @anno171986

                Im iobroker-Backup ist doch soweit alles drin.
                Bei mysql weiß ich es aber nicht genau, hab ich nicht im Einsatz.

                Homoran 1 Reply Last reply Reply Quote 0
                • Homoran
                  Homoran Global Moderator Administrators @Thomas Braun last edited by

                  @thomas-braun sagte in Objects database error: connect ECONNREFUSED 127.0.0.1:9001:

                  Im iobroker-Backup ist doch soweit alles drin.

                  nur Javascript!
                  die anderen beiden müssen extra gesichert und wiederhergestellt werden.

                  @anno171986
                  aber die Reihenfolge kann ich dir bei SQL nicht sagen.

                  A 1 Reply Last reply Reply Quote 0
                  • A
                    anno171986 @Homoran last edited by

                    @homoran Ok, bin dabei und nach und nach scheint alles wieder zu starten. EIne dumme Frage habe ich noch: hätte ich die SQl DB eigenständig backupen müssen?

                    Homoran 1 Reply Last reply Reply Quote 0
                    • Homoran
                      Homoran Global Moderator Administrators @anno171986 last edited by

                      @anno171986 sagte in Objects database error: connect ECONNREFUSED 127.0.0.1:9001:

                      hätte ich die SQl DB eigenständig backupen müssen?

                      über backitup geht das

                      A 1 Reply Last reply Reply Quote 0
                      • A
                        anno171986 @Homoran last edited by

                        @homoran Ich versuche ja das MySQl Backup über den Adapter, das klappt nicht. Jetzt frage ich mich ob denn die DB selbst durch das Backup gesichert wird.

                        Started restore ...
                        [DEBUG] [mysql] - Start mysql Restore ...
                        [DEBUG] [mysql] - sql.0 is stopped
                        [ERROR] [mysql] - ERROR 2002 (HY000): Can't connect to server on '192.168.178.12' (115)
                        
                        [DEBUG] [mysql] - mySql Restore completed successfully
                        [EXIT] mysql restore done
                        [DEBUG] [mysql] - sql.0 started
                        

                        DIe Instanz bleibt gelb

                        Homoran 1 Reply Last reply Reply Quote 0
                        • Homoran
                          Homoran Global Moderator Administrators @anno171986 last edited by

                          @anno171986 sagte in Objects database error: connect ECONNREFUSED 127.0.0.1:9001:

                          Jetzt frage ich mich ob denn die DB selbst durch das Backup gesichert wird.

                          genau die sollte in dem Backup drin sein.

                          Ich nutze SQL nicht

                          1 Reply Last reply Reply Quote 0
                          • A
                            anno171986 @Thomas Braun last edited by

                            @thomas-braun Leider ist nach der Neuinstallation und einspielen des Backups alles viel schlimmer geworden. iobroker läuft jetzt gar nicht mehr.

                            ======== Start marking the full check here =========

                            Skript v.2024-05-22
                            
                            *** BASE SYSTEM ***
                             Static hostname: raspberrypi
                                   Icon name: computer
                            Operating System: Debian GNU/Linux 12 (bookworm)
                                      Kernel: Linux 6.6.28+rpt-rpi-v8
                                Architecture: arm64
                            
                            Model           : Raspberry Pi 4 Model B Rev 1.4
                            Docker          : false
                            Virtualization  : none
                            Kernel          : aarch64
                            Userland        : 64 bit
                            
                            Systemuptime and Load:
                             20:13:46 up 8 days, 7 min,  4 users,  load average: 6.78, 3.30, 3.07
                            CPU threads: 4
                            
                            
                            *** RASPBERRY THROTTLING ***
                            Current issues:
                            No throttling issues detected.
                            
                            Previously detected issues:
                            No throttling issues detected.
                            
                            *** Time and Time Zones ***
                                           Local time: Tue 2024-06-04 20:13:47 CEST
                                       Universal time: Tue 2024-06-04 18:13:47 UTC
                                             RTC time: n/a
                                            Time zone: Europe/Berlin (CEST, +0200)
                            System clock synchronized: yes
                                          NTP service: active
                                      RTC in local TZ: no
                            
                            *** Users and Groups ***
                            User that called 'iob diag':
                            anno171986
                            HOME=/home/anno171986
                            GROUPS=anno171986 adm dialout cdrom sudo audio video plugdev games users input render netdev gpio i2c spi iobroker
                            
                            User that is running 'js-controller':
                            iobroker
                            HOME=/home/iobroker
                            GROUPS=iobroker tty dialout audio video plugdev bluetooth gpio i2c
                            
                            *** Display-Server-Setup ***
                            Display-Server: true
                            Desktop:
                            Terminal:       tty
                            Boot Target:    multi-user.target
                            
                            *** MEMORY ***
                                           total        used        free      shared  buff/cache   available
                            Mem:            8.2G        3.5G        2.4G        1.3M        2.5G        4.7G
                            Swap:           209M          0B        209M
                            Total:          8.4G        3.5G        2.6G
                            
                            Active iob-Instances:   2
                            
                                     7809 M total memory
                                     3346 M used memory
                                     3572 M active memory
                                     1697 M inactive memory
                                     2269 M free memory
                                      159 M buffer memory
                                     2204 M swap cache
                                      199 M total swap
                                        0 M used swap
                                      199 M free swap
                            
                            *** top - Table Of Processes  ***
                            top - 20:13:47 up 8 days, 7 min,  4 users,  load average: 6.78, 3.30, 3.07
                            Tasks: 215 total,   7 running, 208 sleeping,   0 stopped,   0 zombie
                            %Cpu(s): 62.5 us, 37.5 sy,  0.0 ni,  0.0 id,  0.0 wa,  0.0 hi,  0.0 si,  0.0 st
                            MiB Mem :   7809.0 total,   2265.8 free,   3350.6 used,   2363.7 buff/cache
                            MiB Swap:    200.0 total,    200.0 free,      0.0 used.   4458.5 avail Mem
                            
                            *** FAILED SERVICES ***
                            
                              UNIT LOAD ACTIVE SUB DESCRIPTION
                            0 loaded units listed.
                            
                            *** FILESYSTEM ***
                            Filesystem                                  Type      Size  Used Avail Use% Mounted on
                            udev                                        devtmpfs  3.6G     0  3.6G   0% /dev
                            tmpfs                                       tmpfs     781M  1.3M  780M   1% /run
                            /dev/sda2                                   ext4      117G  7.3G  104G   7% /
                            tmpfs                                       tmpfs     3.9G     0  3.9G   0% /dev/shm
                            tmpfs                                       tmpfs     5.0M   16K  5.0M   1% /run/lock
                            /dev/sda1                                   vfat      510M   64M  447M  13% /boot/firmware
                            //192.168.178.11/raspberrypi/ioBrokerBackup cifs      7.3T  1.3T  6.0T  18% /opt/iobroker/backups
                            tmpfs                                       tmpfs     781M     0  781M   0% /run/user/1000
                            
                            Messages concerning ext4 filesystem in dmesg:
                            
                            Show mounted filesystems:
                            TARGET                                                  SOURCE                                      FSTYPE      OPTIONS
                            /                                                       /dev/sda2                                   ext4        rw,noatime
                            |-/sys                                                  sysfs                                       sysfs       rw,nosuid,nodev,noexec,relatime
                            | |-/sys/kernel/security                                securityfs                                  securityfs  rw,nosuid,nodev,noexec,relatime
                            | |-/sys/fs/cgroup                                      cgroup2                                     cgroup2     rw,nosuid,nodev,noexec,relatime,nsdelegate,memory_recursiveprot
                            | |-/sys/fs/pstore                                      pstore                                      pstore      rw,nosuid,nodev,noexec,relatime
                            | |-/sys/fs/bpf                                         bpf                                         bpf         rw,nosuid,nodev,noexec,relatime,mode=700
                            | |-/sys/kernel/debug                                   debugfs                                     debugfs     rw,nosuid,nodev,noexec,relatime
                            | |-/sys/kernel/tracing                                 tracefs                                     tracefs     rw,nosuid,nodev,noexec,relatime
                            | |-/sys/fs/fuse/connections                            fusectl                                     fusectl     rw,nosuid,nodev,noexec,relatime
                            | `-/sys/kernel/config                                  configfs                                    configfs    rw,nosuid,nodev,noexec,relatime
                            |-/proc                                                 proc                                        proc        rw,relatime
                            | `-/proc/sys/fs/binfmt_misc                            systemd-1                                   autofs      rw,relatime,fd=30,pgrp=1,timeout=0,minproto=5,maxproto=5,direct,pipe_ino=2262
                            |   `-/proc/sys/fs/binfmt_misc                          binfmt_misc                                 binfmt_misc rw,nosuid,nodev,noexec,relatime
                            |-/dev                                                  udev                                        devtmpfs    rw,nosuid,relatime,size=3728000k,nr_inodes=932000,mode=755
                            | |-/dev/pts                                            devpts                                      devpts      rw,nosuid,noexec,relatime,gid=5,mode=620,ptmxmode=000
                            | |-/dev/shm                                            tmpfs                                       tmpfs       rw,nosuid,nodev
                            | `-/dev/mqueue                                         mqueue                                      mqueue      rw,nosuid,nodev,noexec,relatime
                            |-/run                                                  tmpfs                                       tmpfs       rw,nosuid,nodev,noexec,relatime,size=799648k,mode=755
                            | |-/run/lock                                           tmpfs                                       tmpfs       rw,nosuid,nodev,noexec,relatime,size=5120k
                            | |-/run/credentials/systemd-sysctl.service             ramfs                                       ramfs       ro,nosuid,nodev,noexec,relatime,mode=700
                            | |-/run/credentials/systemd-sysusers.service           ramfs                                       ramfs       ro,nosuid,nodev,noexec,relatime,mode=700
                            | |-/run/credentials/systemd-tmpfiles-setup-dev.service ramfs                                       ramfs       ro,nosuid,nodev,noexec,relatime,mode=700
                            | |-/run/rpc_pipefs                                     sunrpc                                      rpc_pipefs  rw,relatime
                            | |-/run/credentials/systemd-tmpfiles-setup.service     ramfs                                       ramfs       ro,nosuid,nodev,noexec,relatime,mode=700
                            | `-/run/user/1000                                      tmpfs                                       tmpfs       rw,nosuid,nodev,relatime,size=799644k,nr_inodes=199911,mode=700,uid=1000,gid=1000
                            |-/boot/firmware                                        /dev/sda1                                   vfat        rw,relatime,fmask=0022,dmask=0022,codepage=437,iocharset=ascii,shortname=mixed,errors=remount-ro
                            `-/opt/iobroker/backups                                 //192.168.178.11/raspberrypi/ioBrokerBackup cifs        rw,relatime,vers=3.1.1,cache=strict,username=raspberrypi,uid=1001,noforceuid,gid=1001,noforcegid,addr=192.168.178.11,file_mode=0777,dir_mode=0777,soft,nounix,serverino,mapposix,rsize=4194304,wsize=4194304,bsize=1048576,echo_interval=60,actimeo=1,closetimeo=1
                            
                            Files in neuralgic directories:
                            
                            /var:
                            1.6G    /var/
                            912M    /var/log/journal/9735987036244807bbcd08440a9098fe
                            912M    /var/log/journal
                            912M    /var/log
                            291M    /var/lib
                            
                            Archived and active journals take up 911.5M in the file system.
                            
                            /opt/iobroker/backups:
                            277M    /opt/iobroker/backups/
                            
                            /opt/iobroker/iobroker-data:
                            1.6G    /opt/iobroker/iobroker-data/
                            409M    /opt/iobroker/iobroker-data/files
                            128M    /opt/iobroker/iobroker-data/backup-objects
                            89M     /opt/iobroker/iobroker-data/files/echarts.admin
                            57M     /opt/iobroker/iobroker-data/files/javascript.admin
                            
                            The five largest files in iobroker-data are:
                            994M    /opt/iobroker/iobroker-data/states.jsonl
                            35M     /opt/iobroker/iobroker-data/files/devices.admin/static/js/main.24f2bb56.js.map
                            33M     /opt/iobroker/iobroker-data/files/iot.admin/static/js/main.1797d034.js.map
                            24M     /opt/iobroker/iobroker-data/files/web.admin/static/js/main.135279a0.js.map
                            24M     /opt/iobroker/iobroker-data/files/echarts/static/js/main.2b7495c2.js.map
                            
                            USB-Devices by-id:
                            USB-Sticks -  Avoid direct links to /dev/tty* in your adapter setups, please always prefer the links 'by-id':
                            
                            /dev/serial/by-id/usb-Texas_Instruments_CC2538_USB_CDC-if00
                            
                            HINT:
                            Your zigbee.0 COM-Port is NOT matching 'by-id'. Please check your setting:
                            /dev/ttyACM0
                            
                            
                            
                            *** NodeJS-Installation ***
                            
                            /usr/bin/nodejs         v18.20.3
                            /usr/bin/node           v18.20.3
                            /usr/bin/npm            10.7.0
                            /usr/bin/npx            10.7.0
                            /usr/bin/corepack       0.28.0
                            
                            
                            nodejs:
                              Installed: 18.20.3-1nodesource1
                              Candidate: 18.20.3-1nodesource1
                              Version table:
                             *** 18.20.3-1nodesource1 1001
                                    500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages
                                    100 /var/lib/dpkg/status
                                 18.20.2-1nodesource1 1001
                                    500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages
                                 18.20.1-1nodesource1 1001
                                    500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages
                                 18.20.0-1nodesource1 1001
                                    500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages
                                 18.19.1-1nodesource1 1001
                                    500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages
                                 18.19.0+dfsg-6~deb12u1 500
                                    500 http://deb.debian.org/debian-security bookworm-security/main arm64 Packages
                                 18.19.0-1nodesource1 1001
                                    500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages
                                 18.18.2-1nodesource1 1001
                                    500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages
                                 18.18.1-1nodesource1 1001
                                    500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages
                                 18.18.0-1nodesource1 1001
                                    500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages
                                 18.17.1-1nodesource1 1001
                                    500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages
                                 18.17.0-1nodesource1 1001
                                    500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages
                                 18.16.1-1nodesource1 1001
                                    500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages
                                 18.16.0-1nodesource1 1001
                                    500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages
                                 18.15.0-1nodesource1 1001
                                    500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages
                                 18.14.2-1nodesource1 1001
                                    500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages
                                 18.14.1-1nodesource1 1001
                                    500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages
                                 18.14.0-1nodesource1 1001
                                    500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages
                                 18.13.0+dfsg1-1 500
                                    500 http://deb.debian.org/debian bookworm/main arm64 Packages
                                 18.13.0-1nodesource1 1001
                                    500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages
                                 18.12.0-1nodesource1 1001
                                    500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages
                                 18.11.0-1nodesource1 1001
                                    500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages
                                 18.10.0-1nodesource1 1001
                                    500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages
                                 18.9.1-1nodesource1 1001
                                    500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages
                                 18.9.0-1nodesource1 1001
                                    500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages
                                 18.8.0-1nodesource1 1001
                                    500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages
                                 18.7.0-1nodesource1 1001
                                    500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages
                                 18.6.0-1nodesource1 1001
                                    500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages
                                 18.5.0-1nodesource1 1001
                                    500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages
                                 18.4.0-1nodesource1 1001
                                    500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages
                                 18.3.0-1nodesource1 1001
                                    500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages
                                 18.2.0-1nodesource1 1001
                                    500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages
                                 18.1.0-1nodesource1 1001
                                    500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages
                                 18.0.0-1nodesource1 1001
                                    500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages
                            
                            Temp directories causing npm8 problem: 108
                            Some problems detected, please run iob fix
                            
                            Errors in npm tree:
                            
                            *** ioBroker-Installation ***
                            
                            ioBroker Status
                            iobroker is running on this host.
                            
                            
                            Objects type: jsonl
                            States  type: jsonl
                            
                            Core adapters versions
                            js-controller:  5.0.19
                            admin:          6.13.16
                            javascript:     7.8.0
                            
                            nodejs modules from github:     1
                            +-- iobroker.sourceanalytix@0.4.14 (git+ssh://git@github.com/DrozmotiX/ioBroker.sourceanalytix.git#87a9b7837569274a136c4fa03ee6fbfd8a20f183)
                            
                            Adapter State
                            + system.adapter.admin.0                  : admin                 : raspberrypi                              -  enabled, port: 8081, bind: 0.0.0.0, run as: admin
                              system.adapter.alexa2.0                 : alexa2                : raspberrypi                              -  enabled
                              system.adapter.backitup.0               : backitup              : raspberrypi                              -  enabled
                              system.adapter.daswetter.0              : daswetter             : raspberrypi                              -  enabled
                              system.adapter.device-reminder.0        : device-reminder       : raspberrypi                              -  enabled
                              system.adapter.devices.0                : devices               : raspberrypi                              - disabled
                              system.adapter.echarts.0                : echarts               : raspberrypi                              -  enabled
                              system.adapter.ems-esp.0                : ems-esp               : raspberrypi                              -  enabled
                              system.adapter.flot.0                   : flot                  : raspberrypi                              - disabled
                              system.adapter.harmony.0                : harmony               : raspberrypi                              -  enabled
                              system.adapter.heatingcontrol.0         : heatingcontrol        : raspberrypi                              -  enabled
                              system.adapter.ical.0                   : ical                  : raspberrypi                              -  enabled
                              system.adapter.info.0                   : info                  : raspberrypi                              - disabled
                              system.adapter.iot.0                    : iot                   : raspberrypi                              -  enabled
                              system.adapter.javascript.0             : javascript            : raspberrypi                              -  enabled
                              system.adapter.lgtv.0                   : lgtv                  : raspberrypi                              -  enabled
                              system.adapter.lupusec.0                : lupusec               : raspberrypi                              -  enabled
                              system.adapter.mihome-vacuum.0          : mihome-vacuum         : raspberrypi                              - disabled, port: 54321
                              system.adapter.mqtt.0                   : mqtt                  : raspberrypi                              -  enabled, port: 1885, bind: 0.0.0.0
                              system.adapter.octoprint.0              : octoprint             : raspberrypi                              - disabled
                              system.adapter.pvforecast.0             : pvforecast            : raspberrypi                              - disabled
                              system.adapter.simple-api.0             : simple-api            : raspberrypi                              -  enabled, port: 8087, bind: 192.168.178.12, run as: admin
                              system.adapter.sourceanalytix.0         : sourceanalytix        : raspberrypi                              -  enabled
                              system.adapter.sql.0                    : sql                   : raspberrypi                              - disabled, port: 3306
                              system.adapter.tankerkoenig.0           : tankerkoenig          : raspberrypi                              -  enabled
                              system.adapter.telegram.0               : telegram              : raspberrypi                              -  enabled, port: 8443, bind: 0.0.0.0
                              system.adapter.vis-2-beta.0             : vis-2-beta            : raspberrypi                              - disabled
                              system.adapter.vis-2-widgets-energy.0   : vis-2-widgets-energy  : raspberrypi                              - disabled
                              system.adapter.vis-2-widgets-gauges.0   : vis-2-widgets-gauges  : raspberrypi                              - disabled
                              system.adapter.vis-2-widgets-material.0 : vis-2-widgets-material: raspberrypi                              - disabled
                              system.adapter.vis-colorpicker.0        : vis-colorpicker       : raspberrypi                              - disabled
                              system.adapter.vis-jqui-mfd.0           : vis-jqui-mfd          : raspberrypi                              - disabled
                              system.adapter.vis-timeandweather.0     : vis-timeandweather    : raspberrypi                              - disabled
                              system.adapter.vis.0                    : vis                   : raspberrypi                              - disabled
                              system.adapter.web.0                    : web                   : raspberrypi                              - disabled, port: 8082, bind: 0.0.0.0, run as: admin
                              system.adapter.worx.0                   : worx                  : raspberrypi                              -  enabled
                              system.adapter.yamaha.0                 : yamaha                : raspberrypi                              -  enabled
                              system.adapter.zigbee.0                 : zigbee                : raspberrypi                              -  enabled, port: /dev/ttyACM0
                            
                            + instance is alive
                            
                            Enabled adapters with bindings
                            + system.adapter.admin.0                  : admin                 : raspberrypi                              -  enabled, port: 8081, bind: 0.0.0.0, run as: admin
                              system.adapter.mqtt.0                   : mqtt                  : raspberrypi                              -  enabled, port: 1885, bind: 0.0.0.0
                              system.adapter.simple-api.0             : simple-api            : raspberrypi                              -  enabled, port: 8087, bind: 192.168.178.12, run as: admin
                              system.adapter.telegram.0               : telegram              : raspberrypi                              -  enabled, port: 8443, bind: 0.0.0.0
                              system.adapter.zigbee.0                 : zigbee                : raspberrypi                              -  enabled, port: /dev/ttyACM0
                            
                            ioBroker-Repositories
                            Stable (default): http://download.iobroker.net/sources-dist.json
                            Beta (latest) : http://download.iobroker.net/sources-dist-latest.json
                            
                            Active repo(s): Stable (default)
                            
                            Installed ioBroker-Instances
                            Used repository: Stable (default)
                            Adapter    "admin"        : 6.13.16  , installed 6.13.16
                            Adapter    "alexa2"       : 3.26.5   , installed 3.26.5
                            Adapter    "backitup"     : 2.11.0   , installed 2.11.0
                            Adapter    "daswetter"    : 3.1.13   , installed 3.1.13
                            Adapter    "device-reminder": 3.1.2  , installed 3.1.2
                            Adapter    "devices"      : 1.1.5    , installed 1.1.5
                            Adapter    "echarts"      : 1.7.2    , installed 1.7.2
                            Adapter    "ems-esp"      : 3.5.0    , installed 3.0.3  [Updatable]
                            Adapter    "flot"         : 1.12.0   , installed 1.12.0
                            Adapter    "harmony"      : 1.4.0    , installed 1.4.0
                            Adapter    "heatingcontrol": 2.12.5  , installed 2.12.5
                            Adapter    "ical"         : 1.15.0   , installed 1.14.3 [Updatable]
                            Adapter    "iot"          : 3.2.2    , installed 2.0.11 [Updatable]
                            Adapter    "javascript"   : 8.3.1    , installed 7.8.0  [Updatable]
                            Controller "js-controller": 5.0.19   , installed 5.0.19
                            Adapter    "lgtv"         : 2.2.0    , installed 2.2.0
                            Adapter    "lupusec"      : 1.3.6    , installed 1.3.6
                            Adapter    "mihome-vacuum": 4.2.0    , installed 4.1.1  [Updatable]
                            Adapter    "mqtt"         : 5.2.0    , installed 5.2.0
                            Adapter    "octoprint"    : 5.1.0    , installed 5.1.0
                            Adapter    "pvforecast"   : 2.9.1    , installed 2.9.1
                            Adapter    "simple-api"   : 2.8.0    , installed 2.7.2  [Updatable]
                            Adapter    "socketio"     : 6.7.0    , installed 6.7.0
                            Adapter    "sql"          : 2.2.0    , installed 2.2.0
                            Adapter    "tankerkoenig" : 3.4.0    , installed 3.3.7  [Updatable]
                            Adapter    "telegram"     : 3.3.2    , installed 3.2.1  [Updatable]
                            Adapter    "vis"          : 1.5.4    , installed 1.5.4
                            Adapter    "vis-2-widgets-energy": 0.3.11, installed 0.3.11
                            Adapter    "vis-2-widgets-gauges": 1.0.3, installed 1.0.3
                            Adapter    "vis-2-widgets-material": 1.3.32, installed 1.3.25 [Updatable]
                            Adapter    "vis-colorpicker": 2.0.3  , installed 2.0.3
                            Adapter    "vis-jqui-mfd" : 1.1.1    , installed 1.1.1
                            Adapter    "vis-timeandweather": 1.2.2, installed 1.2.2
                            Adapter    "web"          : 6.2.5    , installed 6.2.5
                            Adapter    "worx"         : 3.0.2    , installed 2.3.4  [Updatable]
                            Adapter    "ws"           : 2.6.1    , installed 2.6.1
                            Adapter    "yamaha"       : 0.5.3    , installed 0.5.3
                            Adapter    "zigbee"       : 1.10.3   , installed 1.10.3
                            
                            Objects and States
                            Please stand by - This may take a while
                            Objects:        9805
                            States:         7152
                            
                            *** OS-Repositories and Updates ***
                            Hit:1 http://deb.debian.org/debian bookworm InRelease
                            Hit:2 http://deb.debian.org/debian-security bookworm-security InRelease
                            Hit:3 http://deb.debian.org/debian bookworm-updates InRelease
                            Hit:4 http://archive.raspberrypi.com/debian bookworm InRelease
                            Hit:5 https://deb.nodesource.com/node_18.x nodistro InRelease
                            Reading package lists...
                            Pending Updates: 4
                            
                            *** Listening Ports ***
                            Active Internet connections (only servers)
                            Proto Recv-Q Send-Q Local Address           Foreign Address         State       User       Inode      PID/Program name
                            tcp        0      0 0.0.0.0:22              0.0.0.0:*               LISTEN      0          1736       729/sshd: /usr/sbin
                            tcp        0      0 127.0.0.1:9001          0.0.0.0:*               LISTEN      1001       6995707    2389797/iobroker.js
                            tcp        0      0 127.0.0.1:9000          0.0.0.0:*               LISTEN      1001       6997486    2389797/iobroker.js
                            tcp        0      0 0.0.0.0:1885            0.0.0.0:*               LISTEN      1001       7005258    2389957/io.mqtt.0
                            tcp        0      0 127.0.0.1:3306          0.0.0.0:*               LISTEN      106        1769       803/mariadbd
                            tcp        0      0 192.168.178.12:8087     0.0.0.0:*               LISTEN      1001       7002408    2391110/io.simple-a
                            tcp6       0      0 :::22                   :::*                    LISTEN      0          1738       729/sshd: /usr/sbin
                            tcp6       0      0 :::61991                :::*                    LISTEN      1001       6998550    2389928/io.harmony.
                            tcp6       0      0 :::8081                 :::*                    LISTEN      1001       6998490    2389840/io.admin.0
                            udp        0      0 0.0.0.0:5353            0.0.0.0:*                           104        1533       554/avahi-daemon: r
                            udp        0      0 0.0.0.0:47870           0.0.0.0:*                           104        1535       554/avahi-daemon: r
                            udp        0      0 0.0.0.0:61991           0.0.0.0:*                           1001       6998551    2389928/io.harmony.
                            udp6       0      0 :::5353                 :::*                                104        1534       554/avahi-daemon: r
                            udp6       0      0 :::52854                :::*                                104        1536       554/avahi-daemon: r
                            udp6       0      0 fe80::378e:5998:7a1:546 :::*                                0          2974       601/NetworkManager
                            
                            *** Log File - Last 25 Lines ***
                            
                            2024-06-04 20:14:46.279  - error: daswetter.0 (2390543) exception in await insertIntoList [Error: Could not check object existence of daswetter.0.NextDaysDetailed.Location_1.Day_2.Hour_4.clouds_value: Cannot check object existence of "daswetter.0.NextDaysDetailed.Location_1.Day_2.Hour_4.clouds_value": Connection is closed.]
                            2024-06-04 20:14:46.282  - error: daswetter.0 (2390543) Cannot check object existence of "daswetter.0.NextDaysDetailed.Location_1.Day_2.Hour_4.snowline_value": Connection is closed.
                            2024-06-04 20:14:46.284  - error: daswetter.0 (2390543) exception in await insertIntoList [Error: Could not check object existence of daswetter.0.NextDaysDetailed.Location_1.Day_2.Hour_4.snowline_value: Cannot check object existence of "daswetter.0.NextDaysDetailed.Location_1.Day_2.Hour_4.snowline_value": Connection is closed.]
                            2024-06-04 20:14:46.291  - error: daswetter.0 (2390543) Cannot check object existence of "daswetter.0.NextDaysDetailed.Location_1.Day_2.Hour_4.windchill_value": Connection is closed.
                            2024-06-04 20:14:46.294  - error: daswetter.0 (2390543) exception in await insertIntoList [Error: Could not check object existence of daswetter.0.NextDaysDetailed.Location_1.Day_2.Hour_4.windchill_value: Cannot check object existence of "daswetter.0.NextDaysDetailed.Location_1.Day_2.Hour_4.windchill_value": Connection is closed.]
                            2024-06-04 20:14:46.558  - error: host.raspberrypi instance system.adapter.daswetter.0 terminated with code 15 (UNKNOWN_ERROR)
                            2024-06-04 20:14:47.983  - info: heatingcontrol.0 (2391035) start statemachine
                            2024-06-04 20:14:50.125  - info: sourceanalytix.0 (2391160) Initialization of mqtt.0.Gaszaehler.main.value successfully
                            2024-06-04 20:14:50.204  - info: sourceanalytix.0 (2391160) Successfully activated SourceAnalytix for 3 of 3 states, will do my Job until you stop me!
                            2024-06-04 20:14:51.759  - info: heatingcontrol.0 (2391035) check all active sensors
                            2024-06-04 20:14:51.915  - info: heatingcontrol.0 (2391035) checking external states
                            2024-06-04 20:14:55.769  - info: tankerkoenig.0 (2391259) Start first request
                            2024-06-04 20:15:07.932  - info: heatingcontrol.0 (2391035) checking external states done
                            2024-06-04 20:15:07.936  - info: heatingcontrol.0 (2391035) calculate current profile point for all rooms
                            2024-06-04 20:15:07.944  - info: heatingcontrol.0 (2391035) start calculate current profile point for profile type 2 (Mo-Fr / Sa - Su)
                            2024-06-04 20:15:08.248  - info: heatingcontrol.0 (2391035) start calculate current profile point for profile type 2 (Mo-Fr / Sa - Su)
                            2024-06-04 20:15:08.545  - info: heatingcontrol.0 (2391035) start calculate current profile point for profile type 2 (Mo-Fr / Sa - Su)
                            2024-06-04 20:15:08.700  - info: heatingcontrol.0 (2391035) start calculate current profile point for profile type 2 (Mo-Fr / Sa - Su)
                            2024-06-04 20:15:08.844  - info: heatingcontrol.0 (2391035) start calculate current profile point for profile type 2 (Mo-Fr / Sa - Su)
                            2024-06-04 20:15:09.027  - info: heatingcontrol.0 (2391035) start calculate current profile point for profile type 2 (Mo-Fr / Sa - Su)
                            2024-06-04 20:15:09.174  - info: heatingcontrol.0 (2391035) start calculate current profile point for profile type 2 (Mo-Fr / Sa - Su)
                            2024-06-04 20:15:09.311  - info: heatingcontrol.0 (2391035) start calculate current profile point for profile type 2 (Mo-Fr / Sa - Su)
                            2024-06-04 20:15:09.800  - info: heatingcontrol.0 (2391035) Wohnzimmer: WZ Thermostatwert eingestellt auf 23.5°C
                            2024-06-04 20:15:10.864  - info: heatingcontrol.0 (2391035) Bad: Bad Thermostatwert eingestellt auf 22°C
                            2024-06-04 20:15:11.480  - info: heatingcontrol.0 (2391035) statemachine started
                            
                            

                            ============ Mark until here for C&P =============

                            Thomas Braun 2 Replies Last reply Reply Quote 0
                            • Thomas Braun
                              Thomas Braun Most Active @anno171986 last edited by Thomas Braun

                              @anno171986 sagte in Objects database error: connect ECONNREFUSED 127.0.0.1:9001:

                              ioBroker Status
                              iobroker is running on this host.

                              Der läuft.
                              Genauso wie ein Display-Server...

                              iob stop
                              sudo reboot
                              
                              A 1 Reply Last reply Reply Quote 0
                              • Thomas Braun
                                Thomas Braun Most Active @anno171986 last edited by

                                @anno171986 sagte in Objects database error: connect ECONNREFUSED 127.0.0.1:9001:

                                Temp directories causing npm8 problem: 108
                                Some problems detected, please run iob fix

                                Das dann auch machen.
                                Und nodejs auf die Empfehlung v20 bringen.

                                iob nodejs-update
                                

                                Die ganzen Adapter auch auf Stand bringen...

                                1 Reply Last reply Reply Quote 0
                                • A
                                  anno171986 @Thomas Braun last edited by

                                  @thomas-braun Ok, jetzt scheint er tatsächlich mal wieder zu laufen, hatte es 2 Wochen nicht mehr probiert weil ich frustriert war. Hauptproblem war der SQL Adapter bzw wohl die Datenbank. Kann man irgendwo im Dateisystem nachgucken ob die Datenbank richtig wiederhergestellt wurde?

                                  Thomas Braun 1 Reply Last reply Reply Quote 0
                                  • Thomas Braun
                                    Thomas Braun Most Active @anno171986 last edited by

                                    @anno171986

                                    Dein Hauptproblem ist der total inkonsistente Update-Stand auf der Kiste.

                                    A 3 Replies Last reply Reply Quote 0
                                    • A
                                      anno171986 @Thomas Braun last edited by

                                      @thomas-braun Ich bin gerade dabei es upzudaten. Als ich es vor 3 Wochen neuaufgesetzt hatte, war alles auf den aktuellen Stand. So war jedenfalls meine Auffassung. Hatte alle Adapter und auch das Betriebsystem geupdated.

                                      cd /opt/iobroker
                                      iobroker backup
                                      iobroker stop
                                      iobroker update | grep Updatable
                                      iobroker upgrade -yes
                                      iobroker fix
                                      iobroker upgrade self
                                      iobroker start
                                      sudo apt update
                                      sudo apt dist-upgrade --fix-missing
                                      sudo reboot now
                                      
                                      1 Reply Last reply Reply Quote 0
                                      • A
                                        anno171986 @Thomas Braun last edited by

                                        @thomas-braun Ich bin gerade dabei es upzudaten. Als ich es vor 3 Wochen neuaufgesetzt hatte, war alles auf den aktuellen Stand. So war jedenfalls meine Auffassung. Hatte alle Adapter und auch das Betriebsystem geupdated.

                                        cd /opt/iobroker
                                        iobroker backup
                                        iobroker stop
                                        iobroker update | grep Updatable
                                        iobroker upgrade -yes
                                        iobroker fix
                                        iobroker upgrade self
                                        iobroker start
                                        sudo apt update
                                        sudo apt dist-upgrade --fix-missing
                                        sudo reboot now
                                        
                                        1 Reply Last reply Reply Quote 0
                                        • A
                                          anno171986 @Thomas Braun last edited by anno171986

                                          @thomas-braun Jetzt kommt der Fehler, der mich letztens auch so geärgert hat:

                                          anno171986@raspberrypi:/opt/iobroker $ iobroker update
                                          No connection to databases possible ...
                                           Unable to enable Expiry Keyspace events from Redis Server: Connection is closed.
                                           Connection is closed.
                                          Uncaught Rejection: Error: States DB is not allowed to start in the current Multihost environment
                                              at Redis.<anonymous> (/opt/iobroker/node_modules/@iobroker/db-states-redis/build/lib/states/statesInRedisClient.js:459:23)
                                              at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
                                          
                                          anno171986@raspberrypi:/opt/iobroker $ iobroker start
                                          anno171986@raspberrypi:/opt/iobroker $ iobroker status
                                          Server Cannot start inMem-states on port 9000: Failed to lock DB file "/opt/iobroker/iobroker-data/states.jsonl"!
                                          
                                          Thomas Braun 1 Reply Last reply Reply Quote 0
                                          • Thomas Braun
                                            Thomas Braun Most Active @anno171986 last edited by

                                            @anno171986

                                            Das ist insofern verwunderlich, weil deine Kiste auf jsonl läuft:

                                            ioBroker Status
                                            iobroker is running on this host.
                                            
                                            
                                            Objects type: jsonl
                                            States  type: jsonl
                                            
                                            A 1 Reply Last reply Reply Quote 0
                                            • First post
                                              Last post

                                            Support us

                                            ioBroker
                                            Community Adapters
                                            Donate

                                            718
                                            Online

                                            31.7k
                                            Users

                                            79.9k
                                            Topics

                                            1.3m
                                            Posts

                                            3
                                            30
                                            1569
                                            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