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.
    • 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
                                          • A
                                            anno171986 @Thomas Braun last edited by

                                            @thomas-braun Konnte jetzt den Updateprozess starten, aber das gab auch Fehler.

                                            anno171986@raspberrypi:~ $ iobroker stop
                                            anno171986@raspberrypi:~ $ iobroker update | grep Updatable
                                            Adapter    "ems-esp"      : 3.5.0    , installed 3.0.3  [Updatable]
                                            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]
                                            Adapter    "mihome-vacuum": 4.2.0    , installed 4.1.1  [Updatable]
                                            Adapter    "simple-api"   : 2.8.0    , installed 2.7.2  [Updatable]
                                            Adapter    "tankerkoenig" : 3.4.0    , installed 3.3.7  [Updatable]
                                            Adapter    "telegram"     : 3.3.2    , installed 3.2.1  [Updatable]
                                            Adapter    "vis-2-widgets-material": 1.3.32, installed 1.3.25 [Updatable]
                                            Adapter    "worx"         : 3.0.2    , installed 2.3.4  [Updatable]
                                            anno171986@raspberrypi:~ $ iobroker upgrade self
                                            Host    "raspberrypi"    is up to date.
                                            anno171986@raspberrypi:~ $ iobroker upgrade -yes
                                            Update worx from @2.3.4 to @3.0.2
                                            NPM version: 10.7.0
                                            Installing iobroker.worx@3.0.2... (System call)
                                            Try to solve ENOTEMPTY error automatically
                                            Could not handle ENOTEMPTY, because no deletable files were found
                                            npm error code ENOTEMPTY
                                            npm error syscall rename
                                            npm error path /opt/iobroker/node_modules/iobroker.javascript/node_modules/ajv
                                            npm error dest /opt/iobroker/node_modules/iobroker.javascript/node_modules/.ajv-JWAHQ164
                                            npm error errno -39
                                            npm error ENOTEMPTY: directory not empty, rename '/opt/iobroker/node_modules/iobroker.javascript/node_modules/ajv' -> '/opt/iobroker/node_modules/iobroker.javascript/node_modules/.ajv-JWAHQ164'
                                            
                                            npm error A complete log of this run can be found in: /home/iobroker/.npm/_logs/2024-06-04T18_47_41_533Z-debug-0.log
                                            host.raspberrypi Cannot install iobroker.worx@3.0.2: 217
                                            anno171986@raspberrypi:~ $
                                            
                                            Thomas Braun 1 Reply Last reply Reply Quote 0
                                            • First post
                                              Last post

                                            Support us

                                            ioBroker
                                            Community Adapters
                                            Donate

                                            785
                                            Online

                                            31.8k
                                            Users

                                            80.0k
                                            Topics

                                            1.3m
                                            Posts

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