Objects database error: connect ECONNREFUSED 127.0.0.1:9001

anno171986

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

@anno171986

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

anno171986

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

Thomas Braun

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

anno171986

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

Gibt es eine empfohlene Reihenfolge?

Thomas Braun

@anno171986

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

Homoran

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

anno171986

@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

@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

anno171986

@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

@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

anno171986

@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

@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

Thomas Braun

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

anno171986

@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

@anno171986

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

anno171986

@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

anno171986

@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

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

@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

Community Forum

NEWS

Objects database error: connect ECONNREFUSED 127.0.0.1:9001

Support us

630

32.5k

81.7k

1.3m