Objects database error: connect ECONNREFUSED 127.0.0.1:9001
-
Dein Hauptproblem ist der total inkonsistente Update-Stand auf der Kiste.
@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 -
Dein Hauptproblem ist der total inkonsistente Update-Stand auf der Kiste.
@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 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"!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 -
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@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 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:~ $Das ist das Ding:
Temp directories causing npm8 problem: 108
Some problems detected, please run iob fixIn dieser Reihenfolge:
iob stop iob fix iob nodejs-update iob stop sudo apt update sudo apt full-upgrade sudo rebootWenn der Server dann wieder läuft schauen wir weiter.
-
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 rebootIch 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 -
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 rebootIch 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 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 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@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.
-
@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 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 =============
@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-if00als COM-Port eintragen.
Fehlen beim sql vielleicht die Credentials?
-
@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-if00als COM-Port eintragen.
Fehlen beim sql vielleicht die Credentials?
@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 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-if00als COM-Port eintragen.
Fehlen beim sql vielleicht die Credentials?
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!
Hey! Du scheinst an dieser Unterhaltung interessiert zu sein, hast aber noch kein Konto.
Hast du es satt, bei jedem Besuch durch die gleichen Beiträge zu scrollen? Wenn du dich für ein Konto anmeldest, kommst du immer genau dorthin zurück, wo du zuvor warst, und kannst dich über neue Antworten benachrichtigen lassen (entweder per E-Mail oder Push-Benachrichtigung). Du kannst auch Lesezeichen speichern und Beiträge positiv bewerten, um anderen Community-Mitgliedern deine Wertschätzung zu zeigen.
Mit deinem Input könnte dieser Beitrag noch besser werden 💗
Registrieren AnmeldenSupport us
605
Online32.8k
Benutzer82.9k
Themen1.3m
Beiträge