Objects database error: connect ECONNREFUSED 127.0.0.1:9001

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

anno171986

@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

@anno171986

Das ist das Ding:

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

In dieser Reihenfolge:

iob stop 
iob fix
iob nodejs-update
iob stop
sudo apt update
sudo apt full-upgrade
sudo reboot

Wenn der Server dann wieder läuft schauen wir weiter.

anno171986

@thomas-braun

Nothing to do - Your installation is using the correct paths.

You are running nodejs v20.14.0. Do you want to install recommended version 18.20.3?

Press <y> to continue or any other key to quit
We are not fixing your installation. Exiting.
anno171986@raspberrypi:~ $ iob stop
anno171986@raspberrypi:~ $ sudo apt update
Hit:1 http://deb.debian.org/debian bookworm InRelease
Hit:2 http://deb.debian.org/debian-security bookworm-security InRelease
Hit:3 http://archive.raspberrypi.com/debian bookworm InRelease
Hit:4 http://deb.debian.org/debian bookworm-updates InRelease
Hit:5 https://deb.nodesource.com/node_20.x nodistro InRelease
Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
All packages are up to date.
anno171986@raspberrypi:~ $ sudo apt full-upgrade
Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
Calculating upgrade... Done
The following packages were automatically installed and are no longer required:
  linux-headers-6.6.20+rpt-common-rpi linux-kbuild-6.6.20+rpt
Use 'sudo apt autoremove' to remove them.
The following packages will be REMOVED:
  linux-headers-6.6.20+rpt-rpi-2712 linux-headers-6.6.20+rpt-rpi-v8 linux-image-6.6.20+rpt-rpi-2712 linux-image-6.6.20+rpt-rpi-v8
0 upgraded, 0 newly installed, 4 to remove and 0 not upgraded.
After this operation, 70.9 MB disk space will be freed.
Do you want to continue? [Y/n] y
(Reading database ... 111073 files and directories currently installed.)
Removing linux-headers-6.6.20+rpt-rpi-2712 (1:6.6.20-1+rpt1) ...
Removing linux-headers-6.6.20+rpt-rpi-v8 (1:6.6.20-1+rpt1) ...
Removing linux-image-6.6.20+rpt-rpi-2712 (1:6.6.20-1+rpt1) ...
/etc/kernel/postrm.d/initramfs-tools:
update-initramfs: Deleting /boot/initrd.img-6.6.20+rpt-rpi-2712
Removing linux-image-6.6.20+rpt-rpi-v8 (1:6.6.20-1+rpt1) ...
/etc/kernel/postrm.d/initramfs-tools:
update-initramfs: Deleting /boot/initrd.img-6.6.20+rpt-rpi-v8
anno171986@raspberrypi:~ $ sudo reboot

Ich bin mal bei Version 20 geblieben

Nach dem Neustart konnte ich das update starten

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 -yes

Thomas Braun

@anno171986

Und ein erneutes

iob diag

spuckt nun was aus?

anno171986

@thomas-braun Habe ich gerade gestartet, poste ich gleich.

Was im iob Protokoll steht z.b. das Problem mit SQL

sql.0
	2024-06-04 21:21:37.894	error	Error: connect ECONNREFUSED 192.168.178.12:3306

Thomas Braun

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

Der lässt dich nicht ran. Warum auch immer. Von msql hab ich aber keine Ahnung. Muss dir wwer anders weiterhelfen.

Community Forum

NEWS

Objects database error: connect ECONNREFUSED 127.0.0.1:9001

Support us

349

32.5k

81.7k

1.3m