Objects database error: connect ECONNREFUSED 127.0.0.1:9001

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.

anno171986

@thomas-braun Hier der iob diag Auszug, auch dort steht was zu SQL

======== 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.31+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:
 21:23:04 up 4 min,  2 users,  load average: 2.57, 2.25, 1.04
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 21:23:04 CEST
           Universal time: Tue 2024-06-04 19:23:04 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: false
Desktop:
Terminal:       tty
Boot Target:    multi-user.target

*** MEMORY ***
               total        used        free      shared  buff/cache   available
Mem:            8.2G        3.8G        3.7G        1.3M        835M        4.4G
Swap:           209M          0B        209M
Total:          8.4G        3.8G        3.9G

Active iob-Instances:   22

         7809 M total memory
         3601 M used memory
         3561 M active memory
          570 M inactive memory
         3533 M free memory
           59 M buffer memory
          736 M swap cache
          199 M total swap
            0 M used swap
          199 M free swap

*** top - Table Of Processes  ***
top - 21:23:04 up 4 min,  2 users,  load average: 2.57, 2.25, 1.04
Tasks: 206 total,   1 running, 205 sleeping,   0 stopped,   0 zombie
%Cpu(s): 12.5 us, 25.0 sy,  0.0 ni, 50.0 id, 12.5 wa,  0.0 hi,  0.0 si,  0.0 st
MiB Mem :   7809.0 total,   3532.5 free,   3602.2 used,    796.8 buff/cache
MiB Swap:    200.0 total,    200.0 free,      0.0 used.   4206.9 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.1G  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
tmpfs          tmpfs     781M     0  781M   0% /run/user/1000

Messages concerning ext4 filesystem in dmesg:
[Tue Jun  4 21:18:30 2024] Kernel command line: coherent_pool=1M 8250.nr_uarts=0 snd_bcm2835.enable_headphones=0 snd_bcm2835.enable_headphones=1 snd_bcm2835.enable_hdmi=1 snd_bcm2835.enable_hdmi=0  smsc95xx.macaddr=E4:5F:01:47:26:6F vc_mem.mem_base=0x3eb00000 vc_mem.mem_size=0x3ff00000  console=ttyS0,115200 console=tty1 root=PARTUUID=a36b2e0a-02 rootfstype=ext4 fsck.repair=yes rootwait cfg80211.ieee80211_regdom=GE
[Tue Jun  4 21:18:36 2024] EXT4-fs (sda2): mounted filesystem 93c89e92-8f2e-4522-ad32-68faed883d2f ro with ordered data mode. Quota mode: none.
[Tue Jun  4 21:18:38 2024] EXT4-fs (sda2): re-mounted 93c89e92-8f2e-4522-ad32-68faed883d2f r/w. Quota mode: none.

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=2361
|   `-/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

Files in neuralgic directories:

/var:
1.7G    /var/
936M    /var/log/journal/9735987036244807bbcd08440a9098fe
936M    /var/log/journal
936M    /var/log
292M    /var/lib

Archived and active journals take up 935.5M in the file system.

/opt/iobroker/backups:
37M     /opt/iobroker/backups/

/opt/iobroker/iobroker-data:
859M    /opt/iobroker/iobroker-data/
525M    /opt/iobroker/iobroker-data/files
138M    /opt/iobroker/iobroker-data/files/javascript.admin
128M    /opt/iobroker/iobroker-data/backup-objects
118M    /opt/iobroker/iobroker-data/files/javascript.admin/static

The five largest files in iobroker-data are:
186M    /opt/iobroker/iobroker-data/states.jsonl
38M     /opt/iobroker/iobroker-data/files/iot.admin/static/js/main.3d563dc9.js.map
35M     /opt/iobroker/iobroker-data/files/devices.admin/static/js/main.24f2bb56.js.map
27M     /opt/iobroker/iobroker-data/files/tankerkoenig.admin/build/index.js.map
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':

/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         v20.14.0
/usr/bin/node           v20.14.0
/usr/bin/npm            10.7.0
/usr/bin/npx            10.7.0
/usr/bin/corepack       0.28.1


nodejs:
  Installed: 20.14.0-1nodesource1
  Candidate: 20.14.0-1nodesource1
  Version table:
 *** 20.14.0-1nodesource1 1001
        500 https://deb.nodesource.com/node_20.x nodistro/main arm64 Packages
        100 /var/lib/dpkg/status
     20.13.1-1nodesource1 1001
        500 https://deb.nodesource.com/node_20.x nodistro/main arm64 Packages
     20.13.0-1nodesource1 1001
        500 https://deb.nodesource.com/node_20.x nodistro/main arm64 Packages
     20.12.2-1nodesource1 1001
        500 https://deb.nodesource.com/node_20.x nodistro/main arm64 Packages
     20.12.1-1nodesource1 1001
        500 https://deb.nodesource.com/node_20.x nodistro/main arm64 Packages
     20.12.0-1nodesource1 1001
        500 https://deb.nodesource.com/node_20.x nodistro/main arm64 Packages
     20.11.1-1nodesource1 1001
        500 https://deb.nodesource.com/node_20.x nodistro/main arm64 Packages
     20.11.0-1nodesource1 1001
        500 https://deb.nodesource.com/node_20.x nodistro/main arm64 Packages
     20.10.0-1nodesource1 1001
        500 https://deb.nodesource.com/node_20.x nodistro/main arm64 Packages
     20.9.0-1nodesource1 1001
        500 https://deb.nodesource.com/node_20.x nodistro/main arm64 Packages
     20.8.1-1nodesource1 1001
        500 https://deb.nodesource.com/node_20.x nodistro/main arm64 Packages
     20.8.0-1nodesource1 1001
        500 https://deb.nodesource.com/node_20.x nodistro/main arm64 Packages
     20.7.0-1nodesource1 1001
        500 https://deb.nodesource.com/node_20.x nodistro/main arm64 Packages
     20.6.1-1nodesource1 1001
        500 https://deb.nodesource.com/node_20.x nodistro/main arm64 Packages
     20.6.0-1nodesource1 1001
        500 https://deb.nodesource.com/node_20.x nodistro/main arm64 Packages
     20.5.1-1nodesource1 1001
        500 https://deb.nodesource.com/node_20.x nodistro/main arm64 Packages
     20.5.0-1nodesource1 1001
        500 https://deb.nodesource.com/node_20.x nodistro/main arm64 Packages
     20.4.0-1nodesource1 1001
        500 https://deb.nodesource.com/node_20.x nodistro/main arm64 Packages
     20.3.1-1nodesource1 1001
        500 https://deb.nodesource.com/node_20.x nodistro/main arm64 Packages
     20.3.0-1nodesource1 1001
        500 https://deb.nodesource.com/node_20.x nodistro/main arm64 Packages
     20.2.0-1nodesource1 1001
        500 https://deb.nodesource.com/node_20.x nodistro/main arm64 Packages
     20.1.0-1nodesource1 1001
        500 https://deb.nodesource.com/node_20.x nodistro/main arm64 Packages
     20.0.0-1nodesource1 1001
        500 https://deb.nodesource.com/node_20.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.13.0+dfsg1-1 500
        500 http://deb.debian.org/debian bookworm/main arm64 Packages

Temp directories causing npm8 problem: 0
No problems detected

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:     8.3.1

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                              -  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                              - 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                              -  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                              - 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.sql.0                    : sql                   : raspberrypi                              -  enabled, port: 3306
+ 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.5.0
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.15.0
Adapter    "iot"          : 3.2.2    , installed 3.2.2
Adapter    "javascript"   : 8.3.1    , installed 8.3.1
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    "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.8.0
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.4.0
Adapter    "telegram"     : 3.3.2    , installed 3.3.2
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.32
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 3.0.2
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:        9822
States:         7204

*** OS-Repositories and Updates ***
Hit:1 http://archive.raspberrypi.com/debian bookworm InRelease
Hit:2 http://deb.debian.org/debian bookworm InRelease
Hit:3 http://deb.debian.org/debian-security bookworm-security 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...
Pending Updates: 0

*** 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 127.0.0.1:3306          0.0.0.0:*               LISTEN      106        4056       780/mariadbd
tcp        0      0 192.168.178.12:8087     0.0.0.0:*               LISTEN      1001       6933       1491/io.simple-api.
tcp        0      0 0.0.0.0:22              0.0.0.0:*               LISTEN      0          4008       703/sshd: /usr/sbin
tcp        0      0 127.0.0.1:9000          0.0.0.0:*               LISTEN      1001       4084       673/iobroker.js-con
tcp        0      0 127.0.0.1:9001          0.0.0.0:*               LISTEN      1001       7184       673/iobroker.js-con
tcp        0      0 0.0.0.0:1885            0.0.0.0:*               LISTEN      1001       7709       1237/io.mqtt.0
tcp6       0      0 :::8081                 :::*                    LISTEN      1001       7256       902/io.admin.0
tcp6       0      0 :::22                   :::*                    LISTEN      0          4010       703/sshd: /usr/sbin
tcp6       0      0 :::61991                :::*                    LISTEN      1001       9485       1163/io.harmony.0
udp        0      0 0.0.0.0:61991           0.0.0.0:*                           1001       9486       1163/io.harmony.0
udp        0      0 0.0.0.0:5353            0.0.0.0:*                           104        960        550/avahi-daemon: r
udp        0      0 0.0.0.0:52195           0.0.0.0:*                           104        962        550/avahi-daemon: r
udp6       0      0 fe80::b1a2:bab:8ce2:546 :::*                                0          7363       592/NetworkManager
udp6       0      0 fe80::378e:5998:7a1:546 :::*                                0          6419       592/NetworkManager
udp6       0      0 :::5353                 :::*                                104        961        550/avahi-daemon: r
udp6       0      0 :::34631                :::*                                104        963        550/avahi-daemon: r

*** Log File - Last 25 Lines ***

2024-06-04 21:22:01.836  - warn: sql.0 (964) No Connection to database
2024-06-04 21:22:01.838  - warn: sql.0 (964) No Connection to database
2024-06-04 21:22:01.846  - warn: sql.0 (964) storeState executed with 40 errors: Error writing state for 0_userdata.0.daswetter.futureHumidity: undefined, Data: {"ts":1717459200000,"val":97,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureHumidity: undefined, Data: {"ts":1717470000000,"val":98,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureHumidity: undefined, Data: {"ts":1717480800000,"val":89,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureHumidity: undefined, Data: {"ts":1717491600000,"val":77,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureHumidity: undefined, Data: {"ts":1717502400000,"val":66,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureHumidity: undefined, Data: {"ts":1717513200000,"val":79,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureHumidity: undefined, Data: {"ts":1717524000000,"val":85,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureHumidity: undefined, Data: {"ts":1717534800000,"val":90,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureHumidity: undefined, Data: {"ts":1717545600000,"val":81,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureHumidity: undefined, Data: {"ts":1717556400000,"val":92,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureHumidity: undefined, Data: {"ts":1717567200000,"val":85,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureHumidity: undefined, Data: {"ts":1717578000000,"val":57,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureHumidity: undefined, Data: {"ts":1717588800000,"val":50,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureHumidity: undefined, Data: {"ts":1717599600000,"val":51,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureHumidity: undefined, Data: {"ts":1717610400000,"val":62,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureHumidity: undefined, Data: {"ts":1717621200000,"val":78,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureHumidity: undefined, Data: {"ts":1717632000000,"val":82,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureHumidity: undefined, Data: {"ts":1717642800000,"val":81,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureHumidity: undefined, Data: {"ts":1717653600000,"val":77,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureHumidity: undefined, Data: {"ts":1717664400000,"val":61,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureHumidity: undefined, Data: {"ts":1717675200000,"val":59,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureHumidity: undefined, Data: {"ts":1717686000000,"val":72,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureHumidity: undefined, Data: {"ts":1717696800000,"val":75,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureHumidity: undefined, Data: {"ts":1717707600000,"val":87,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureHumidity: undefined, Data: {"ts":1717718400000,"val":90,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureHumidity: undefined, Data: {"ts":1717729200000,"val":92,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureHumidity: undefined, Data: {"ts":1717740000000,"val":83,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureHumidity: undefined, Data: {"ts":1717750800000,"val":59,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureHumidity: undefined, Data: {"ts":1717761600000,"val":55,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureHumidity: undefined, Data: {"ts":1717772400000,"val":66,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureHumidity: undefined, Data: {"ts":1717783200000,"val":65,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureHumidity: undefined, Data: {"ts":1717794000000,"val":82,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureHumidity: undefined, Data: {"ts":1717804800000,"val":91,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureHumidity: undefined, Data: {"ts":1717815600000,"val":93,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureHumidity: undefined, Data: {"ts":1717826400000,"val":76,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureHumidity: undefined, Data: {"ts":1717837200000,"val":73,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureHumidity: undefined, Data: {"ts":1717848000000,"val":77,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureHumidity: undefined, Data: {"ts":1717858800000,"val":66,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureHumidity: undefined, Data: {"ts":1717869600000,"val":69,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureHumidity: undefined, Data: {"ts":1717880400000,"val":75,"ack":false,"from":"mcuScript"}
2024-06-04 21:22:01.852  - warn: sql.0 (964) storeState executed with 40 errors: Error writing state for 0_userdata.0.daswetter.futurePressure: undefined, Data: {"ts":1717459200000,"val":1016,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futurePressure: undefined, Data: {"ts":1717470000000,"val":1015,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futurePressure: undefined, Data: {"ts":1717480800000,"val":1014,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futurePressure: undefined, Data: {"ts":1717491600000,"val":1013,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futurePressure: undefined, Data: {"ts":1717502400000,"val":1011,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futurePressure: undefined, Data: {"ts":1717513200000,"val":1010,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futurePressure: undefined, Data: {"ts":1717524000000,"val":1008,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futurePressure: undefined, Data: {"ts":1717534800000,"val":1007,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futurePressure: undefined, Data: {"ts":1717545600000,"val":1005,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futurePressure: undefined, Data: {"ts":1717556400000,"val":1004,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futurePressure: undefined, Data: {"ts":1717567200000,"val":1007,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futurePressure: undefined, Data: {"ts":1717578000000,"val":1009,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futurePressure: undefined, Data: {"ts":1717588800000,"val":1010,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futurePressure: undefined, Data: {"ts":1717599600000,"val":1012,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futurePressure: undefined, Data: {"ts":1717610400000,"val":1012,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futurePressure: undefined, Data: {"ts":1717621200000,"val":1013,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futurePressure: undefined, Data: {"ts":1717632000000,"val":1014,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futurePressure: undefined, Data: {"ts":1717642800000,"val":1014,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futurePressure: undefined, Data: {"ts":1717653600000,"val":1015,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futurePressure: undefined, Data: {"ts":1717664400000,"val":1016,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futurePressure: undefined, Data: {"ts":1717675200000,"val":1016,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futurePressure: undefined, Data: {"ts":1717686000000,"val":1016,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futurePressure: undefined, Data: {"ts":1717696800000,"val":1016,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futurePressure: undefined, Data: {"ts":1717707600000,"val":1017,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futurePressure: undefined, Data: {"ts":1717718400000,"val":1017,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futurePressure: undefined, Data: {"ts":1717729200000,"val":1017,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futurePressure: undefined, Data: {"ts":1717740000000,"val":1017,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futurePressure: undefined, Data: {"ts":1717750800000,"val":1017,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futurePressure: undefined, Data: {"ts":1717761600000,"val":1016,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futurePressure: undefined, Data: {"ts":1717772400000,"val":1016,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futurePressure: undefined, Data: {"ts":1717783200000,"val":1015,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futurePressure: undefined, Data: {"ts":1717794000000,"val":1015,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futurePressure: undefined, Data: {"ts":1717804800000,"val":1014,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futurePressure: undefined, Data: {"ts":1717815600000,"val":1012,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futurePressure: undefined, Data: {"ts":1717826400000,"val":1011,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futurePressure: undefined, Data: {"ts":1717837200000,"val":1010,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futurePressure: undefined, Data: {"ts":1717848000000,"val":1010,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futurePressure: undefined, Data: {"ts":1717858800000,"val":1009,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futurePressure: undefined, Data: {"ts":1717869600000,"val":1009,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futurePressure: undefined, Data: {"ts":1717880400000,"val":1009,"ack":false,"from":"mcuScript"}
2024-06-04 21:22:01.854  - warn: sql.0 (964) storeState executed with 40 errors: Error writing state for 0_userdata.0.daswetter.futureRain: undefined, Data: {"ts":1717459200000,"val":0,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureRain: undefined, Data: {"ts":1717470000000,"val":0,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureRain: undefined, Data: {"ts":1717480800000,"val":0.3,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureRain: undefined, Data: {"ts":1717491600000,"val":0.7,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureRain: undefined, Data: {"ts":1717502400000,"val":0.5,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureRain: undefined, Data: {"ts":1717513200000,"val":0.1,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureRain: undefined, Data: {"ts":1717524000000,"val":0.3,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureRain: undefined, Data: {"ts":1717534800000,"val":0,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureRain: undefined, Data: {"ts":1717545600000,"val":0.9,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureRain: undefined, Data: {"ts":1717556400000,"val":3.2,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureRain: undefined, Data: {"ts":1717567200000,"val":1.3,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureRain: undefined, Data: {"ts":1717578000000,"val":0,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureRain: undefined, Data: {"ts":1717588800000,"val":0,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureRain: undefined, Data: {"ts":1717599600000,"val":0,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureRain: undefined, Data: {"ts":1717610400000,"val":0,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureRain: undefined, Data: {"ts":1717621200000,"val":0,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureRain: undefined, Data: {"ts":1717632000000,"val":0,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureRain: undefined, Data: {"ts":1717642800000,"val":0,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureRain: undefined, Data: {"ts":1717653600000,"val":0,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureRain: undefined, Data: {"ts":1717664400000,"val":0,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureRain: undefined, Data: {"ts":1717675200000,"val":0.2,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureRain: undefined, Data: {"ts":1717686000000,"val":0.2,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureRain: undefined, Data: {"ts":1717696800000,"val":0.1,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureRain: undefined, Data: {"ts":1717707600000,"val":0,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureRain: undefined, Data: {"ts":1717718400000,"val":0,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureRain: undefined, Data: {"ts":1717729200000,"val":0,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureRain: undefined, Data: {"ts":1717740000000,"val":0,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureRain: undefined, Data: {"ts":1717750800000,"val":0,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureRain: undefined, Data: {"ts":1717761600000,"val":0,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureRain: undefined, Data: {"ts":1717772400000,"val":0.3,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureRain: undefined, Data: {"ts":1717783200000,"val":0,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureRain: undefined, Data: {"ts":1717794000000,"val":0,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureRain: undefined, Data: {"ts":1717804800000,"val":0,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureRain: undefined, Data: {"ts":1717815600000,"val":0,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureRain: undefined, Data: {"ts":1717826400000,"val":0,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureRain: undefined, Data: {"ts":1717837200000,"val":0,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureRain: undefined, Data: {"ts":1717848000000,"val":0.8,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureRain: undefined, Data: {"ts":1717858800000,"val":1,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureRain: undefined, Data: {"ts":1717869600000,"val":0,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureRain: undefined, Data: {"ts":1717880400000,"val":0,"ack":false,"from":"mcuScript"}
2024-06-04 21:22:01.873  - warn: sql.0 (964) storeState executed with 40 errors: Error writing state for 0_userdata.0.daswetter.futureUV_Index: undefined, Data: {"ts":1717459200000,"val":0,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureUV_Index: undefined, Data: {"ts":1717470000000,"val":0,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureUV_Index: undefined, Data: {"ts":1717480800000,"val":0,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureUV_Index: undefined, Data: {"ts":1717491600000,"val":3,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureUV_Index: undefined, Data: {"ts":1717502400000,"val":3,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureUV_Index: undefined, Data: {"ts":1717513200000,"val":1,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureUV_Index: undefined, Data: {"ts":1717524000000,"val":0,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureUV_Index: undefined, Data: {"ts":1717534800000,"val":0,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureUV_Index: undefined, Data: {"ts":1717545600000,"val":0,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureUV_Index: undefined, Data: {"ts":1717556400000,"val":0,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureUV_Index: undefined, Data: {"ts":1717567200000,"val":1,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureUV_Index: undefined, Data: {"ts":1717578000000,"val":4,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureUV_Index: undefined, Data: {"ts":1717588800000,"val":5,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureUV_Index: undefined, Data: {"ts":1717599600000,"val":2,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureUV_Index: undefined, Data: {"ts":1717610400000,"val":0,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureUV_Index: undefined, Data: {"ts":1717621200000,"val":0,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureUV_Index: undefined, Data: {"ts":1717632000000,"val":0,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureUV_Index: undefined, Data: {"ts":1717642800000,"val":0,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureUV_Index: undefined, Data: {"ts":1717653600000,"val":1,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureUV_Index: undefined, Data: {"ts":1717664400000,"val":2,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureUV_Index: undefined, Data: {"ts":1717675200000,"val":3,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureUV_Index: undefined, Data: {"ts":1717686000000,"val":1,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureUV_Index: undefined, Data: {"ts":1717696800000,"val":0,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureUV_Index: undefined, Data: {"ts":1717707600000,"val":0,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureUV_Index: undefined, Data: {"ts":1717718400000,"val":0,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureUV_Index: undefined, Data: {"ts":1717729200000,"val":0,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureUV_Index: undefined, Data: {"ts":1717740000000,"val":1,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureUV_Index: undefined, Data: {"ts":1717750800000,"val":3,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureUV_Index: undefined, Data: {"ts":1717761600000,"val":4,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureUV_Index: undefined, Data: {"ts":1717772400000,"val":1,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureUV_Index: undefined, Data: {"ts":1717783200000,"val":0,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureUV_Index: undefined, Data: {"ts":1717794000000,"val":0,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureUV_Index: undefined, Data: {"ts":1717804800000,"val":0,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureUV_Index: undefined, Data: {"ts":1717815600000,"val":0,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureUV_Index: undefined, Data: {"ts":1717826400000,"val":1,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureUV_Index: undefined, Data: {"ts":1717837200000,"val":3,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureUV_Index: undefined, Data: {"ts":1717848000000,"val":4,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureUV_Index: undefined, Data: {"ts":1717858800000,"val":1,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureUV_Index: undefined, Data: {"ts":1717869600000,"val":0,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureUV_Index: undefined, Data: {"ts":1717880400000,"val":0,"ack":false,"from":"mcuScript"}
2024-06-04 21:22:01.875  - warn: sql.0 (964) storeState executed with 40 errors: Error writing state for 0_userdata.0.daswetter.futureWind: undefined, Data: {"ts":1717459200000,"val":6,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureWind: undefined, Data: {"ts":1717470000000,"val":3,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureWind: undefined, Data: {"ts":1717480800000,"val":8,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureWind: undefined, Data: {"ts":1717491600000,"val":16,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureWind: undefined, Data: {"ts":1717502400000,"val":16,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureWind: undefined, Data: {"ts":1717513200000,"val":13,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureWind: undefined, Data: {"ts":1717524000000,"val":12,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureWind: undefined, Data: {"ts":1717534800000,"val":12,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureWind: undefined, Data: {"ts":1717545600000,"val":18,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureWind: undefined, Data: {"ts":1717556400000,"val":19,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureWind: undefined, Data: {"ts":1717567200000,"val":14,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureWind: undefined, Data: {"ts":1717578000000,"val":19,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureWind: undefined, Data: {"ts":1717588800000,"val":20,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureWind: undefined, Data: {"ts":1717599600000,"val":20,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureWind: undefined, Data: {"ts":1717610400000,"val":13,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureWind: undefined, Data: {"ts":1717621200000,"val":9,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureWind: undefined, Data: {"ts":1717632000000,"val":7,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureWind: undefined, Data: {"ts":1717642800000,"val":10,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureWind: undefined, Data: {"ts":1717653600000,"val":11,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureWind: undefined, Data: {"ts":1717664400000,"val":19,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureWind: undefined, Data: {"ts":1717675200000,"val":19,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureWind: undefined, Data: {"ts":1717686000000,"val":16,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureWind: undefined, Data: {"ts":1717696800000,"val":11,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureWind: undefined, Data: {"ts":1717707600000,"val":7,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureWind: undefined, Data: {"ts":1717718400000,"val":8,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureWind: undefined, Data: {"ts":1717729200000,"val":7,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureWind: undefined, Data: {"ts":1717740000000,"val":9,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureWind: undefined, Data: {"ts":1717750800000,"val":14,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureWind: undefined, Data: {"ts":1717761600000,"val":17,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureWind: undefined, Data: {"ts":1717772400000,"val":15,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureWind: undefined, Data: {"ts":1717783200000,"val":11,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureWind: undefined, Data: {"ts":1717794000000,"val":9,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureWind: undefined, Data: {"ts":1717804800000,"val":11,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureWind: undefined, Data: {"ts":1717815600000,"val":14,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureWind: undefined, Data: {"ts":1717826400000,"val":17,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureWind: undefined, Data: {"ts":1717837200000,"val":21,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureWind: undefined, Data: {"ts":1717848000000,"val":20,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureWind: undefined, Data: {"ts":1717858800000,"val":17,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureWind: undefined, Data: {"ts":1717869600000,"val":12,"ack":false,"from":"mcuScript"}, Error writing state for 0_userdata.0.daswetter.futureWind: undefined, Data: {"ts":1717880400000,"val":11,"ack":false,"from":"mcuScript"}
2024-06-04 21:22:07.901  - error: sql.0 (964) Error: connect ECONNREFUSED 192.168.178.12:3306
2024-06-04 21:22:18.022  - error: telegram.0 (995) Failed sending [chatId - 1211163069]: Error: ETELEGRAM: 400 Bad Request: text is too long
2024-06-04 21:22:37.906  - error: sql.0 (964) Error: connect ECONNREFUSED 192.168.178.12:3306
2024-06-04 21:22:48.068  - info: zigbee.0 (1309) Send command to 0x0c4314fffe56b4df failed with: Code 9999 (No response)
2024-06-04 21:22:48.339  - warn: zigbee.0 (1309) DeviceAvailability:Failed to ping 0xa4c138add3c0a8a7 TS011F
2024-06-04 21:22:48.850  - warn: zigbee.0 (1309) DeviceAvailability:Failed to ping 0x588e81fffee0ccc6 TS0502A
2024-06-04 21:23:07.911  - error: sql.0 (964) Error: connect ECONNREFUSED 192.168.178.12:3306
2024-06-04 21:23:10.230  - warn: zigbee.0 (1309) DeviceAvailability:Failed to ping 0xf0d1b80000196d05 Gardenpole RGBW Z3
2024-06-04 21:23:10.847  - warn: zigbee.0 (1309) DeviceAvailability:Failed to ping 0x5c0272fffe802c81 TRADFRI control outlet
2024-06-04 21:23:10.976  - warn: zigbee.0 (1309) DeviceAvailability:Failed to ping 0x7cb03eaa0a00b70b CLA60 TW OSRAM
2024-06-04 21:23:11.498  - warn: zigbee.0 (1309) DeviceAvailability:Failed to ping 0x680ae2fffe3a4858 ZG9101SAC-HP
2024-06-04 21:23:11.758  - warn: zigbee.0 (1309) DeviceAvailability:Failed to ping 0xa4c13801297e5e2b TS0001
2024-06-04 21:23:11.773  - warn: zigbee.0 (1309) DeviceAvailability:Failed to ping 0xa4c138b3d7c14b87 TS011F
2024-06-04 21:23:11.799  - warn: zigbee.0 (1309) DeviceAvailability:Failed to ping 0xa4c138bc4d1cdc90 TS011F
2024-06-04 21:23:12.178  - warn: zigbee.0 (1309) DeviceAvailability:Failed to ping 0x680ae2fffe3a482b ZG9101SAC-HP
2024-06-04 21:23:12.474  - warn: zigbee.0 (1309) DeviceAvailability:Failed to ping 0xa4c138f12aac2718 TS011F
2024-06-04 21:23:12.673  - warn: zigbee.0 (1309) DeviceAvailability:Failed to ping 0xa4c13883d0135f67 TS011F
2024-06-04 21:23:37.922  - error: sql.0 (964) Error: connect ECONNREFUSED 192.168.178.12:3306

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

Thomas Braun

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

/dev/serial/by-id/usb-Texas_Instruments_CC2538_USB_CDC-if00

Im Zigbee-Adapter statt /dev/ttyACM0 besser

/dev/serial/by-id/usb-Texas_Instruments_CC2538_USB_CDC-if00

als COM-Port eintragen.

Fehlen beim sql vielleicht die Credentials?

anno171986

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

/dev/serial/by-id/usb-Texas_Instruments_CC2538_USB_CDC-if00

Ich bin gerade am Testen mit SQL

anno171986

@thomas-braun

ENDLICH!

Es lag an den Credentials und an den Rechten für den User (Remote-Zugriff).

Jetzt, wo der SQl Adapter wieder grün wurde konnte ich auch das SQL Backup einspielen und die DB ist nun auch wieder da.

Vielen DAnk für deine Hilfe!

Community Forum

NEWS

Objects database error: connect ECONNREFUSED 127.0.0.1:9001

Support us

395

32.6k

81.9k

1.3m