Neuer Blogbeitrag: Monatsrückblick - Dezember 2025 🎄

[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

[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:~ $