NEWS
Objects database error: connect ECONNREFUSED 127.0.0.1:9001
-
@anno171986 sagte in Objects database error: connect ECONNREFUSED 127.0.0.1:9001:
hätte ich die SQl DB eigenständig backupen müssen?
über backitup geht das
@homoran Ich versuche ja das MySQl Backup über den Adapter, das klappt nicht. Jetzt frage ich mich ob denn die DB selbst durch das Backup gesichert wird.
Started restore ... [DEBUG] [mysql] - Start mysql Restore ... [DEBUG] [mysql] - sql.0 is stopped [ERROR] [mysql] - ERROR 2002 (HY000): Can't connect to server on '192.168.178.12' (115) [DEBUG] [mysql] - mySql Restore completed successfully [EXIT] mysql restore done [DEBUG] [mysql] - sql.0 startedDIe Instanz bleibt gelb
-
@homoran Ich versuche ja das MySQl Backup über den Adapter, das klappt nicht. Jetzt frage ich mich ob denn die DB selbst durch das Backup gesichert wird.
Started restore ... [DEBUG] [mysql] - Start mysql Restore ... [DEBUG] [mysql] - sql.0 is stopped [ERROR] [mysql] - ERROR 2002 (HY000): Can't connect to server on '192.168.178.12' (115) [DEBUG] [mysql] - mySql Restore completed successfully [EXIT] mysql restore done [DEBUG] [mysql] - sql.0 startedDIe Instanz bleibt gelb
@anno171986 sagte in Objects database error: connect ECONNREFUSED 127.0.0.1:9001:
Jetzt frage ich mich ob denn die DB selbst durch das Backup gesichert wird.
genau die sollte in dem Backup drin sein.
Ich nutze SQL nicht
-
Installier das Betriebssystem neu, diesmal in der 64Bit-Lite-Version. Also 'bookworm' ohne Desktop.
@thomas-braun Leider ist nach der Neuinstallation und einspielen des Backups alles viel schlimmer geworden. iobroker läuft jetzt gar nicht mehr.
======== Start marking the full check here =========
Skript v.2024-05-22 *** BASE SYSTEM *** Static hostname: raspberrypi Icon name: computer Operating System: Debian GNU/Linux 12 (bookworm) Kernel: Linux 6.6.28+rpt-rpi-v8 Architecture: arm64 Model : Raspberry Pi 4 Model B Rev 1.4 Docker : false Virtualization : none Kernel : aarch64 Userland : 64 bit Systemuptime and Load: 20:13:46 up 8 days, 7 min, 4 users, load average: 6.78, 3.30, 3.07 CPU threads: 4 *** RASPBERRY THROTTLING *** Current issues: No throttling issues detected. Previously detected issues: No throttling issues detected. *** Time and Time Zones *** Local time: Tue 2024-06-04 20:13:47 CEST Universal time: Tue 2024-06-04 18:13:47 UTC RTC time: n/a Time zone: Europe/Berlin (CEST, +0200) System clock synchronized: yes NTP service: active RTC in local TZ: no *** Users and Groups *** User that called 'iob diag': anno171986 HOME=/home/anno171986 GROUPS=anno171986 adm dialout cdrom sudo audio video plugdev games users input render netdev gpio i2c spi iobroker User that is running 'js-controller': iobroker HOME=/home/iobroker GROUPS=iobroker tty dialout audio video plugdev bluetooth gpio i2c *** Display-Server-Setup *** Display-Server: true Desktop: Terminal: tty Boot Target: multi-user.target *** MEMORY *** total used free shared buff/cache available Mem: 8.2G 3.5G 2.4G 1.3M 2.5G 4.7G Swap: 209M 0B 209M Total: 8.4G 3.5G 2.6G Active iob-Instances: 2 7809 M total memory 3346 M used memory 3572 M active memory 1697 M inactive memory 2269 M free memory 159 M buffer memory 2204 M swap cache 199 M total swap 0 M used swap 199 M free swap *** top - Table Of Processes *** top - 20:13:47 up 8 days, 7 min, 4 users, load average: 6.78, 3.30, 3.07 Tasks: 215 total, 7 running, 208 sleeping, 0 stopped, 0 zombie %Cpu(s): 62.5 us, 37.5 sy, 0.0 ni, 0.0 id, 0.0 wa, 0.0 hi, 0.0 si, 0.0 st MiB Mem : 7809.0 total, 2265.8 free, 3350.6 used, 2363.7 buff/cache MiB Swap: 200.0 total, 200.0 free, 0.0 used. 4458.5 avail Mem *** FAILED SERVICES *** UNIT LOAD ACTIVE SUB DESCRIPTION 0 loaded units listed. *** FILESYSTEM *** Filesystem Type Size Used Avail Use% Mounted on udev devtmpfs 3.6G 0 3.6G 0% /dev tmpfs tmpfs 781M 1.3M 780M 1% /run /dev/sda2 ext4 117G 7.3G 104G 7% / tmpfs tmpfs 3.9G 0 3.9G 0% /dev/shm tmpfs tmpfs 5.0M 16K 5.0M 1% /run/lock /dev/sda1 vfat 510M 64M 447M 13% /boot/firmware //192.168.178.11/raspberrypi/ioBrokerBackup cifs 7.3T 1.3T 6.0T 18% /opt/iobroker/backups tmpfs tmpfs 781M 0 781M 0% /run/user/1000 Messages concerning ext4 filesystem in dmesg: Show mounted filesystems: TARGET SOURCE FSTYPE OPTIONS / /dev/sda2 ext4 rw,noatime |-/sys sysfs sysfs rw,nosuid,nodev,noexec,relatime | |-/sys/kernel/security securityfs securityfs rw,nosuid,nodev,noexec,relatime | |-/sys/fs/cgroup cgroup2 cgroup2 rw,nosuid,nodev,noexec,relatime,nsdelegate,memory_recursiveprot | |-/sys/fs/pstore pstore pstore rw,nosuid,nodev,noexec,relatime | |-/sys/fs/bpf bpf bpf rw,nosuid,nodev,noexec,relatime,mode=700 | |-/sys/kernel/debug debugfs debugfs rw,nosuid,nodev,noexec,relatime | |-/sys/kernel/tracing tracefs tracefs rw,nosuid,nodev,noexec,relatime | |-/sys/fs/fuse/connections fusectl fusectl rw,nosuid,nodev,noexec,relatime | `-/sys/kernel/config configfs configfs rw,nosuid,nodev,noexec,relatime |-/proc proc proc rw,relatime | `-/proc/sys/fs/binfmt_misc systemd-1 autofs rw,relatime,fd=30,pgrp=1,timeout=0,minproto=5,maxproto=5,direct,pipe_ino=2262 | `-/proc/sys/fs/binfmt_misc binfmt_misc binfmt_misc rw,nosuid,nodev,noexec,relatime |-/dev udev devtmpfs rw,nosuid,relatime,size=3728000k,nr_inodes=932000,mode=755 | |-/dev/pts devpts devpts rw,nosuid,noexec,relatime,gid=5,mode=620,ptmxmode=000 | |-/dev/shm tmpfs tmpfs rw,nosuid,nodev | `-/dev/mqueue mqueue mqueue rw,nosuid,nodev,noexec,relatime |-/run tmpfs tmpfs rw,nosuid,nodev,noexec,relatime,size=799648k,mode=755 | |-/run/lock tmpfs tmpfs rw,nosuid,nodev,noexec,relatime,size=5120k | |-/run/credentials/systemd-sysctl.service ramfs ramfs ro,nosuid,nodev,noexec,relatime,mode=700 | |-/run/credentials/systemd-sysusers.service ramfs ramfs ro,nosuid,nodev,noexec,relatime,mode=700 | |-/run/credentials/systemd-tmpfiles-setup-dev.service ramfs ramfs ro,nosuid,nodev,noexec,relatime,mode=700 | |-/run/rpc_pipefs sunrpc rpc_pipefs rw,relatime | |-/run/credentials/systemd-tmpfiles-setup.service ramfs ramfs ro,nosuid,nodev,noexec,relatime,mode=700 | `-/run/user/1000 tmpfs tmpfs rw,nosuid,nodev,relatime,size=799644k,nr_inodes=199911,mode=700,uid=1000,gid=1000 |-/boot/firmware /dev/sda1 vfat rw,relatime,fmask=0022,dmask=0022,codepage=437,iocharset=ascii,shortname=mixed,errors=remount-ro `-/opt/iobroker/backups //192.168.178.11/raspberrypi/ioBrokerBackup cifs rw,relatime,vers=3.1.1,cache=strict,username=raspberrypi,uid=1001,noforceuid,gid=1001,noforcegid,addr=192.168.178.11,file_mode=0777,dir_mode=0777,soft,nounix,serverino,mapposix,rsize=4194304,wsize=4194304,bsize=1048576,echo_interval=60,actimeo=1,closetimeo=1 Files in neuralgic directories: /var: 1.6G /var/ 912M /var/log/journal/9735987036244807bbcd08440a9098fe 912M /var/log/journal 912M /var/log 291M /var/lib Archived and active journals take up 911.5M in the file system. /opt/iobroker/backups: 277M /opt/iobroker/backups/ /opt/iobroker/iobroker-data: 1.6G /opt/iobroker/iobroker-data/ 409M /opt/iobroker/iobroker-data/files 128M /opt/iobroker/iobroker-data/backup-objects 89M /opt/iobroker/iobroker-data/files/echarts.admin 57M /opt/iobroker/iobroker-data/files/javascript.admin The five largest files in iobroker-data are: 994M /opt/iobroker/iobroker-data/states.jsonl 35M /opt/iobroker/iobroker-data/files/devices.admin/static/js/main.24f2bb56.js.map 33M /opt/iobroker/iobroker-data/files/iot.admin/static/js/main.1797d034.js.map 24M /opt/iobroker/iobroker-data/files/web.admin/static/js/main.135279a0.js.map 24M /opt/iobroker/iobroker-data/files/echarts/static/js/main.2b7495c2.js.map USB-Devices by-id: USB-Sticks - Avoid direct links to /dev/tty* in your adapter setups, please always prefer the links 'by-id': /dev/serial/by-id/usb-Texas_Instruments_CC2538_USB_CDC-if00 HINT: Your zigbee.0 COM-Port is NOT matching 'by-id'. Please check your setting: /dev/ttyACM0 *** NodeJS-Installation *** /usr/bin/nodejs v18.20.3 /usr/bin/node v18.20.3 /usr/bin/npm 10.7.0 /usr/bin/npx 10.7.0 /usr/bin/corepack 0.28.0 nodejs: Installed: 18.20.3-1nodesource1 Candidate: 18.20.3-1nodesource1 Version table: *** 18.20.3-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 100 /var/lib/dpkg/status 18.20.2-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.20.1-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.20.0-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.19.1-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.19.0+dfsg-6~deb12u1 500 500 http://deb.debian.org/debian-security bookworm-security/main arm64 Packages 18.19.0-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.18.2-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.18.1-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.18.0-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.17.1-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.17.0-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.16.1-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.16.0-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.15.0-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.14.2-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.14.1-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.14.0-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.13.0+dfsg1-1 500 500 http://deb.debian.org/debian bookworm/main arm64 Packages 18.13.0-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.12.0-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.11.0-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.10.0-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.9.1-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.9.0-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.8.0-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.7.0-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.6.0-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.5.0-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.4.0-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.3.0-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.2.0-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.1.0-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.0.0-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages Temp directories causing npm8 problem: 108 Some problems detected, please run iob fix Errors in npm tree: *** ioBroker-Installation *** ioBroker Status iobroker is running on this host. Objects type: jsonl States type: jsonl Core adapters versions js-controller: 5.0.19 admin: 6.13.16 javascript: 7.8.0 nodejs modules from github: 1 +-- iobroker.sourceanalytix@0.4.14 (git+ssh://git@github.com/DrozmotiX/ioBroker.sourceanalytix.git#87a9b7837569274a136c4fa03ee6fbfd8a20f183) Adapter State + system.adapter.admin.0 : admin : raspberrypi - enabled, port: 8081, bind: 0.0.0.0, run as: admin system.adapter.alexa2.0 : alexa2 : raspberrypi - enabled system.adapter.backitup.0 : backitup : raspberrypi - enabled system.adapter.daswetter.0 : daswetter : raspberrypi - enabled system.adapter.device-reminder.0 : device-reminder : raspberrypi - enabled system.adapter.devices.0 : devices : raspberrypi - disabled system.adapter.echarts.0 : echarts : raspberrypi - enabled system.adapter.ems-esp.0 : ems-esp : raspberrypi - enabled system.adapter.flot.0 : flot : raspberrypi - disabled system.adapter.harmony.0 : harmony : raspberrypi - enabled system.adapter.heatingcontrol.0 : heatingcontrol : raspberrypi - enabled system.adapter.ical.0 : ical : raspberrypi - enabled system.adapter.info.0 : info : raspberrypi - disabled system.adapter.iot.0 : iot : raspberrypi - enabled system.adapter.javascript.0 : javascript : raspberrypi - enabled system.adapter.lgtv.0 : lgtv : raspberrypi - enabled system.adapter.lupusec.0 : lupusec : raspberrypi - enabled system.adapter.mihome-vacuum.0 : mihome-vacuum : raspberrypi - disabled, port: 54321 system.adapter.mqtt.0 : mqtt : raspberrypi - enabled, port: 1885, bind: 0.0.0.0 system.adapter.octoprint.0 : octoprint : raspberrypi - disabled system.adapter.pvforecast.0 : pvforecast : raspberrypi - disabled system.adapter.simple-api.0 : simple-api : raspberrypi - enabled, port: 8087, bind: 192.168.178.12, run as: admin system.adapter.sourceanalytix.0 : sourceanalytix : raspberrypi - enabled system.adapter.sql.0 : sql : raspberrypi - disabled, port: 3306 system.adapter.tankerkoenig.0 : tankerkoenig : raspberrypi - enabled system.adapter.telegram.0 : telegram : raspberrypi - enabled, port: 8443, bind: 0.0.0.0 system.adapter.vis-2-beta.0 : vis-2-beta : raspberrypi - disabled system.adapter.vis-2-widgets-energy.0 : vis-2-widgets-energy : raspberrypi - disabled system.adapter.vis-2-widgets-gauges.0 : vis-2-widgets-gauges : raspberrypi - disabled system.adapter.vis-2-widgets-material.0 : vis-2-widgets-material: raspberrypi - disabled system.adapter.vis-colorpicker.0 : vis-colorpicker : raspberrypi - disabled system.adapter.vis-jqui-mfd.0 : vis-jqui-mfd : raspberrypi - disabled system.adapter.vis-timeandweather.0 : vis-timeandweather : raspberrypi - disabled system.adapter.vis.0 : vis : raspberrypi - disabled system.adapter.web.0 : web : raspberrypi - disabled, port: 8082, bind: 0.0.0.0, run as: admin system.adapter.worx.0 : worx : raspberrypi - enabled system.adapter.yamaha.0 : yamaha : raspberrypi - enabled system.adapter.zigbee.0 : zigbee : raspberrypi - enabled, port: /dev/ttyACM0 + instance is alive Enabled adapters with bindings + system.adapter.admin.0 : admin : raspberrypi - enabled, port: 8081, bind: 0.0.0.0, run as: admin system.adapter.mqtt.0 : mqtt : raspberrypi - enabled, port: 1885, bind: 0.0.0.0 system.adapter.simple-api.0 : simple-api : raspberrypi - enabled, port: 8087, bind: 192.168.178.12, run as: admin system.adapter.telegram.0 : telegram : raspberrypi - enabled, port: 8443, bind: 0.0.0.0 system.adapter.zigbee.0 : zigbee : raspberrypi - enabled, port: /dev/ttyACM0 ioBroker-Repositories Stable (default): http://download.iobroker.net/sources-dist.json Beta (latest) : http://download.iobroker.net/sources-dist-latest.json Active repo(s): Stable (default) Installed ioBroker-Instances Used repository: Stable (default) Adapter "admin" : 6.13.16 , installed 6.13.16 Adapter "alexa2" : 3.26.5 , installed 3.26.5 Adapter "backitup" : 2.11.0 , installed 2.11.0 Adapter "daswetter" : 3.1.13 , installed 3.1.13 Adapter "device-reminder": 3.1.2 , installed 3.1.2 Adapter "devices" : 1.1.5 , installed 1.1.5 Adapter "echarts" : 1.7.2 , installed 1.7.2 Adapter "ems-esp" : 3.5.0 , installed 3.0.3 [Updatable] Adapter "flot" : 1.12.0 , installed 1.12.0 Adapter "harmony" : 1.4.0 , installed 1.4.0 Adapter "heatingcontrol": 2.12.5 , installed 2.12.5 Adapter "ical" : 1.15.0 , installed 1.14.3 [Updatable] Adapter "iot" : 3.2.2 , installed 2.0.11 [Updatable] Adapter "javascript" : 8.3.1 , installed 7.8.0 [Updatable] Controller "js-controller": 5.0.19 , installed 5.0.19 Adapter "lgtv" : 2.2.0 , installed 2.2.0 Adapter "lupusec" : 1.3.6 , installed 1.3.6 Adapter "mihome-vacuum": 4.2.0 , installed 4.1.1 [Updatable] Adapter "mqtt" : 5.2.0 , installed 5.2.0 Adapter "octoprint" : 5.1.0 , installed 5.1.0 Adapter "pvforecast" : 2.9.1 , installed 2.9.1 Adapter "simple-api" : 2.8.0 , installed 2.7.2 [Updatable] Adapter "socketio" : 6.7.0 , installed 6.7.0 Adapter "sql" : 2.2.0 , installed 2.2.0 Adapter "tankerkoenig" : 3.4.0 , installed 3.3.7 [Updatable] Adapter "telegram" : 3.3.2 , installed 3.2.1 [Updatable] Adapter "vis" : 1.5.4 , installed 1.5.4 Adapter "vis-2-widgets-energy": 0.3.11, installed 0.3.11 Adapter "vis-2-widgets-gauges": 1.0.3, installed 1.0.3 Adapter "vis-2-widgets-material": 1.3.32, installed 1.3.25 [Updatable] Adapter "vis-colorpicker": 2.0.3 , installed 2.0.3 Adapter "vis-jqui-mfd" : 1.1.1 , installed 1.1.1 Adapter "vis-timeandweather": 1.2.2, installed 1.2.2 Adapter "web" : 6.2.5 , installed 6.2.5 Adapter "worx" : 3.0.2 , installed 2.3.4 [Updatable] Adapter "ws" : 2.6.1 , installed 2.6.1 Adapter "yamaha" : 0.5.3 , installed 0.5.3 Adapter "zigbee" : 1.10.3 , installed 1.10.3 Objects and States Please stand by - This may take a while Objects: 9805 States: 7152 *** OS-Repositories and Updates *** Hit:1 http://deb.debian.org/debian bookworm InRelease Hit:2 http://deb.debian.org/debian-security bookworm-security InRelease Hit:3 http://deb.debian.org/debian bookworm-updates InRelease Hit:4 http://archive.raspberrypi.com/debian bookworm InRelease Hit:5 https://deb.nodesource.com/node_18.x nodistro InRelease Reading package lists... Pending Updates: 4 *** Listening Ports *** Active Internet connections (only servers) Proto Recv-Q Send-Q Local Address Foreign Address State User Inode PID/Program name tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN 0 1736 729/sshd: /usr/sbin tcp 0 0 127.0.0.1:9001 0.0.0.0:* LISTEN 1001 6995707 2389797/iobroker.js tcp 0 0 127.0.0.1:9000 0.0.0.0:* LISTEN 1001 6997486 2389797/iobroker.js tcp 0 0 0.0.0.0:1885 0.0.0.0:* LISTEN 1001 7005258 2389957/io.mqtt.0 tcp 0 0 127.0.0.1:3306 0.0.0.0:* LISTEN 106 1769 803/mariadbd tcp 0 0 192.168.178.12:8087 0.0.0.0:* LISTEN 1001 7002408 2391110/io.simple-a tcp6 0 0 :::22 :::* LISTEN 0 1738 729/sshd: /usr/sbin tcp6 0 0 :::61991 :::* LISTEN 1001 6998550 2389928/io.harmony. tcp6 0 0 :::8081 :::* LISTEN 1001 6998490 2389840/io.admin.0 udp 0 0 0.0.0.0:5353 0.0.0.0:* 104 1533 554/avahi-daemon: r udp 0 0 0.0.0.0:47870 0.0.0.0:* 104 1535 554/avahi-daemon: r udp 0 0 0.0.0.0:61991 0.0.0.0:* 1001 6998551 2389928/io.harmony. udp6 0 0 :::5353 :::* 104 1534 554/avahi-daemon: r udp6 0 0 :::52854 :::* 104 1536 554/avahi-daemon: r udp6 0 0 fe80::378e:5998:7a1:546 :::* 0 2974 601/NetworkManager *** Log File - Last 25 Lines *** 2024-06-04 20:14:46.279 - error: daswetter.0 (2390543) exception in await insertIntoList [Error: Could not check object existence of daswetter.0.NextDaysDetailed.Location_1.Day_2.Hour_4.clouds_value: Cannot check object existence of "daswetter.0.NextDaysDetailed.Location_1.Day_2.Hour_4.clouds_value": Connection is closed.] 2024-06-04 20:14:46.282 - error: daswetter.0 (2390543) Cannot check object existence of "daswetter.0.NextDaysDetailed.Location_1.Day_2.Hour_4.snowline_value": Connection is closed. 2024-06-04 20:14:46.284 - error: daswetter.0 (2390543) exception in await insertIntoList [Error: Could not check object existence of daswetter.0.NextDaysDetailed.Location_1.Day_2.Hour_4.snowline_value: Cannot check object existence of "daswetter.0.NextDaysDetailed.Location_1.Day_2.Hour_4.snowline_value": Connection is closed.] 2024-06-04 20:14:46.291 - error: daswetter.0 (2390543) Cannot check object existence of "daswetter.0.NextDaysDetailed.Location_1.Day_2.Hour_4.windchill_value": Connection is closed. 2024-06-04 20:14:46.294 - error: daswetter.0 (2390543) exception in await insertIntoList [Error: Could not check object existence of daswetter.0.NextDaysDetailed.Location_1.Day_2.Hour_4.windchill_value: Cannot check object existence of "daswetter.0.NextDaysDetailed.Location_1.Day_2.Hour_4.windchill_value": Connection is closed.] 2024-06-04 20:14:46.558 - error: host.raspberrypi instance system.adapter.daswetter.0 terminated with code 15 (UNKNOWN_ERROR) 2024-06-04 20:14:47.983 - info: heatingcontrol.0 (2391035) start statemachine 2024-06-04 20:14:50.125 - info: sourceanalytix.0 (2391160) Initialization of mqtt.0.Gaszaehler.main.value successfully 2024-06-04 20:14:50.204 - info: sourceanalytix.0 (2391160) Successfully activated SourceAnalytix for 3 of 3 states, will do my Job until you stop me! 2024-06-04 20:14:51.759 - info: heatingcontrol.0 (2391035) check all active sensors 2024-06-04 20:14:51.915 - info: heatingcontrol.0 (2391035) checking external states 2024-06-04 20:14:55.769 - info: tankerkoenig.0 (2391259) Start first request 2024-06-04 20:15:07.932 - info: heatingcontrol.0 (2391035) checking external states done 2024-06-04 20:15:07.936 - info: heatingcontrol.0 (2391035) calculate current profile point for all rooms 2024-06-04 20:15:07.944 - info: heatingcontrol.0 (2391035) start calculate current profile point for profile type 2 (Mo-Fr / Sa - Su) 2024-06-04 20:15:08.248 - info: heatingcontrol.0 (2391035) start calculate current profile point for profile type 2 (Mo-Fr / Sa - Su) 2024-06-04 20:15:08.545 - info: heatingcontrol.0 (2391035) start calculate current profile point for profile type 2 (Mo-Fr / Sa - Su) 2024-06-04 20:15:08.700 - info: heatingcontrol.0 (2391035) start calculate current profile point for profile type 2 (Mo-Fr / Sa - Su) 2024-06-04 20:15:08.844 - info: heatingcontrol.0 (2391035) start calculate current profile point for profile type 2 (Mo-Fr / Sa - Su) 2024-06-04 20:15:09.027 - info: heatingcontrol.0 (2391035) start calculate current profile point for profile type 2 (Mo-Fr / Sa - Su) 2024-06-04 20:15:09.174 - info: heatingcontrol.0 (2391035) start calculate current profile point for profile type 2 (Mo-Fr / Sa - Su) 2024-06-04 20:15:09.311 - info: heatingcontrol.0 (2391035) start calculate current profile point for profile type 2 (Mo-Fr / Sa - Su) 2024-06-04 20:15:09.800 - info: heatingcontrol.0 (2391035) Wohnzimmer: WZ Thermostatwert eingestellt auf 23.5°C 2024-06-04 20:15:10.864 - info: heatingcontrol.0 (2391035) Bad: Bad Thermostatwert eingestellt auf 22°C 2024-06-04 20:15:11.480 - info: heatingcontrol.0 (2391035) statemachine started============ Mark until here for C&P =============
-
@thomas-braun Leider ist nach der Neuinstallation und einspielen des Backups alles viel schlimmer geworden. iobroker läuft jetzt gar nicht mehr.
======== Start marking the full check here =========
Skript v.2024-05-22 *** BASE SYSTEM *** Static hostname: raspberrypi Icon name: computer Operating System: Debian GNU/Linux 12 (bookworm) Kernel: Linux 6.6.28+rpt-rpi-v8 Architecture: arm64 Model : Raspberry Pi 4 Model B Rev 1.4 Docker : false Virtualization : none Kernel : aarch64 Userland : 64 bit Systemuptime and Load: 20:13:46 up 8 days, 7 min, 4 users, load average: 6.78, 3.30, 3.07 CPU threads: 4 *** RASPBERRY THROTTLING *** Current issues: No throttling issues detected. Previously detected issues: No throttling issues detected. *** Time and Time Zones *** Local time: Tue 2024-06-04 20:13:47 CEST Universal time: Tue 2024-06-04 18:13:47 UTC RTC time: n/a Time zone: Europe/Berlin (CEST, +0200) System clock synchronized: yes NTP service: active RTC in local TZ: no *** Users and Groups *** User that called 'iob diag': anno171986 HOME=/home/anno171986 GROUPS=anno171986 adm dialout cdrom sudo audio video plugdev games users input render netdev gpio i2c spi iobroker User that is running 'js-controller': iobroker HOME=/home/iobroker GROUPS=iobroker tty dialout audio video plugdev bluetooth gpio i2c *** Display-Server-Setup *** Display-Server: true Desktop: Terminal: tty Boot Target: multi-user.target *** MEMORY *** total used free shared buff/cache available Mem: 8.2G 3.5G 2.4G 1.3M 2.5G 4.7G Swap: 209M 0B 209M Total: 8.4G 3.5G 2.6G Active iob-Instances: 2 7809 M total memory 3346 M used memory 3572 M active memory 1697 M inactive memory 2269 M free memory 159 M buffer memory 2204 M swap cache 199 M total swap 0 M used swap 199 M free swap *** top - Table Of Processes *** top - 20:13:47 up 8 days, 7 min, 4 users, load average: 6.78, 3.30, 3.07 Tasks: 215 total, 7 running, 208 sleeping, 0 stopped, 0 zombie %Cpu(s): 62.5 us, 37.5 sy, 0.0 ni, 0.0 id, 0.0 wa, 0.0 hi, 0.0 si, 0.0 st MiB Mem : 7809.0 total, 2265.8 free, 3350.6 used, 2363.7 buff/cache MiB Swap: 200.0 total, 200.0 free, 0.0 used. 4458.5 avail Mem *** FAILED SERVICES *** UNIT LOAD ACTIVE SUB DESCRIPTION 0 loaded units listed. *** FILESYSTEM *** Filesystem Type Size Used Avail Use% Mounted on udev devtmpfs 3.6G 0 3.6G 0% /dev tmpfs tmpfs 781M 1.3M 780M 1% /run /dev/sda2 ext4 117G 7.3G 104G 7% / tmpfs tmpfs 3.9G 0 3.9G 0% /dev/shm tmpfs tmpfs 5.0M 16K 5.0M 1% /run/lock /dev/sda1 vfat 510M 64M 447M 13% /boot/firmware //192.168.178.11/raspberrypi/ioBrokerBackup cifs 7.3T 1.3T 6.0T 18% /opt/iobroker/backups tmpfs tmpfs 781M 0 781M 0% /run/user/1000 Messages concerning ext4 filesystem in dmesg: Show mounted filesystems: TARGET SOURCE FSTYPE OPTIONS / /dev/sda2 ext4 rw,noatime |-/sys sysfs sysfs rw,nosuid,nodev,noexec,relatime | |-/sys/kernel/security securityfs securityfs rw,nosuid,nodev,noexec,relatime | |-/sys/fs/cgroup cgroup2 cgroup2 rw,nosuid,nodev,noexec,relatime,nsdelegate,memory_recursiveprot | |-/sys/fs/pstore pstore pstore rw,nosuid,nodev,noexec,relatime | |-/sys/fs/bpf bpf bpf rw,nosuid,nodev,noexec,relatime,mode=700 | |-/sys/kernel/debug debugfs debugfs rw,nosuid,nodev,noexec,relatime | |-/sys/kernel/tracing tracefs tracefs rw,nosuid,nodev,noexec,relatime | |-/sys/fs/fuse/connections fusectl fusectl rw,nosuid,nodev,noexec,relatime | `-/sys/kernel/config configfs configfs rw,nosuid,nodev,noexec,relatime |-/proc proc proc rw,relatime | `-/proc/sys/fs/binfmt_misc systemd-1 autofs rw,relatime,fd=30,pgrp=1,timeout=0,minproto=5,maxproto=5,direct,pipe_ino=2262 | `-/proc/sys/fs/binfmt_misc binfmt_misc binfmt_misc rw,nosuid,nodev,noexec,relatime |-/dev udev devtmpfs rw,nosuid,relatime,size=3728000k,nr_inodes=932000,mode=755 | |-/dev/pts devpts devpts rw,nosuid,noexec,relatime,gid=5,mode=620,ptmxmode=000 | |-/dev/shm tmpfs tmpfs rw,nosuid,nodev | `-/dev/mqueue mqueue mqueue rw,nosuid,nodev,noexec,relatime |-/run tmpfs tmpfs rw,nosuid,nodev,noexec,relatime,size=799648k,mode=755 | |-/run/lock tmpfs tmpfs rw,nosuid,nodev,noexec,relatime,size=5120k | |-/run/credentials/systemd-sysctl.service ramfs ramfs ro,nosuid,nodev,noexec,relatime,mode=700 | |-/run/credentials/systemd-sysusers.service ramfs ramfs ro,nosuid,nodev,noexec,relatime,mode=700 | |-/run/credentials/systemd-tmpfiles-setup-dev.service ramfs ramfs ro,nosuid,nodev,noexec,relatime,mode=700 | |-/run/rpc_pipefs sunrpc rpc_pipefs rw,relatime | |-/run/credentials/systemd-tmpfiles-setup.service ramfs ramfs ro,nosuid,nodev,noexec,relatime,mode=700 | `-/run/user/1000 tmpfs tmpfs rw,nosuid,nodev,relatime,size=799644k,nr_inodes=199911,mode=700,uid=1000,gid=1000 |-/boot/firmware /dev/sda1 vfat rw,relatime,fmask=0022,dmask=0022,codepage=437,iocharset=ascii,shortname=mixed,errors=remount-ro `-/opt/iobroker/backups //192.168.178.11/raspberrypi/ioBrokerBackup cifs rw,relatime,vers=3.1.1,cache=strict,username=raspberrypi,uid=1001,noforceuid,gid=1001,noforcegid,addr=192.168.178.11,file_mode=0777,dir_mode=0777,soft,nounix,serverino,mapposix,rsize=4194304,wsize=4194304,bsize=1048576,echo_interval=60,actimeo=1,closetimeo=1 Files in neuralgic directories: /var: 1.6G /var/ 912M /var/log/journal/9735987036244807bbcd08440a9098fe 912M /var/log/journal 912M /var/log 291M /var/lib Archived and active journals take up 911.5M in the file system. /opt/iobroker/backups: 277M /opt/iobroker/backups/ /opt/iobroker/iobroker-data: 1.6G /opt/iobroker/iobroker-data/ 409M /opt/iobroker/iobroker-data/files 128M /opt/iobroker/iobroker-data/backup-objects 89M /opt/iobroker/iobroker-data/files/echarts.admin 57M /opt/iobroker/iobroker-data/files/javascript.admin The five largest files in iobroker-data are: 994M /opt/iobroker/iobroker-data/states.jsonl 35M /opt/iobroker/iobroker-data/files/devices.admin/static/js/main.24f2bb56.js.map 33M /opt/iobroker/iobroker-data/files/iot.admin/static/js/main.1797d034.js.map 24M /opt/iobroker/iobroker-data/files/web.admin/static/js/main.135279a0.js.map 24M /opt/iobroker/iobroker-data/files/echarts/static/js/main.2b7495c2.js.map USB-Devices by-id: USB-Sticks - Avoid direct links to /dev/tty* in your adapter setups, please always prefer the links 'by-id': /dev/serial/by-id/usb-Texas_Instruments_CC2538_USB_CDC-if00 HINT: Your zigbee.0 COM-Port is NOT matching 'by-id'. Please check your setting: /dev/ttyACM0 *** NodeJS-Installation *** /usr/bin/nodejs v18.20.3 /usr/bin/node v18.20.3 /usr/bin/npm 10.7.0 /usr/bin/npx 10.7.0 /usr/bin/corepack 0.28.0 nodejs: Installed: 18.20.3-1nodesource1 Candidate: 18.20.3-1nodesource1 Version table: *** 18.20.3-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 100 /var/lib/dpkg/status 18.20.2-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.20.1-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.20.0-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.19.1-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.19.0+dfsg-6~deb12u1 500 500 http://deb.debian.org/debian-security bookworm-security/main arm64 Packages 18.19.0-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.18.2-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.18.1-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.18.0-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.17.1-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.17.0-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.16.1-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.16.0-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.15.0-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.14.2-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.14.1-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.14.0-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.13.0+dfsg1-1 500 500 http://deb.debian.org/debian bookworm/main arm64 Packages 18.13.0-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.12.0-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.11.0-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.10.0-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.9.1-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.9.0-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.8.0-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.7.0-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.6.0-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.5.0-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.4.0-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.3.0-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.2.0-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.1.0-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.0.0-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages Temp directories causing npm8 problem: 108 Some problems detected, please run iob fix Errors in npm tree: *** ioBroker-Installation *** ioBroker Status iobroker is running on this host. Objects type: jsonl States type: jsonl Core adapters versions js-controller: 5.0.19 admin: 6.13.16 javascript: 7.8.0 nodejs modules from github: 1 +-- iobroker.sourceanalytix@0.4.14 (git+ssh://git@github.com/DrozmotiX/ioBroker.sourceanalytix.git#87a9b7837569274a136c4fa03ee6fbfd8a20f183) Adapter State + system.adapter.admin.0 : admin : raspberrypi - enabled, port: 8081, bind: 0.0.0.0, run as: admin system.adapter.alexa2.0 : alexa2 : raspberrypi - enabled system.adapter.backitup.0 : backitup : raspberrypi - enabled system.adapter.daswetter.0 : daswetter : raspberrypi - enabled system.adapter.device-reminder.0 : device-reminder : raspberrypi - enabled system.adapter.devices.0 : devices : raspberrypi - disabled system.adapter.echarts.0 : echarts : raspberrypi - enabled system.adapter.ems-esp.0 : ems-esp : raspberrypi - enabled system.adapter.flot.0 : flot : raspberrypi - disabled system.adapter.harmony.0 : harmony : raspberrypi - enabled system.adapter.heatingcontrol.0 : heatingcontrol : raspberrypi - enabled system.adapter.ical.0 : ical : raspberrypi - enabled system.adapter.info.0 : info : raspberrypi - disabled system.adapter.iot.0 : iot : raspberrypi - enabled system.adapter.javascript.0 : javascript : raspberrypi - enabled system.adapter.lgtv.0 : lgtv : raspberrypi - enabled system.adapter.lupusec.0 : lupusec : raspberrypi - enabled system.adapter.mihome-vacuum.0 : mihome-vacuum : raspberrypi - disabled, port: 54321 system.adapter.mqtt.0 : mqtt : raspberrypi - enabled, port: 1885, bind: 0.0.0.0 system.adapter.octoprint.0 : octoprint : raspberrypi - disabled system.adapter.pvforecast.0 : pvforecast : raspberrypi - disabled system.adapter.simple-api.0 : simple-api : raspberrypi - enabled, port: 8087, bind: 192.168.178.12, run as: admin system.adapter.sourceanalytix.0 : sourceanalytix : raspberrypi - enabled system.adapter.sql.0 : sql : raspberrypi - disabled, port: 3306 system.adapter.tankerkoenig.0 : tankerkoenig : raspberrypi - enabled system.adapter.telegram.0 : telegram : raspberrypi - enabled, port: 8443, bind: 0.0.0.0 system.adapter.vis-2-beta.0 : vis-2-beta : raspberrypi - disabled system.adapter.vis-2-widgets-energy.0 : vis-2-widgets-energy : raspberrypi - disabled system.adapter.vis-2-widgets-gauges.0 : vis-2-widgets-gauges : raspberrypi - disabled system.adapter.vis-2-widgets-material.0 : vis-2-widgets-material: raspberrypi - disabled system.adapter.vis-colorpicker.0 : vis-colorpicker : raspberrypi - disabled system.adapter.vis-jqui-mfd.0 : vis-jqui-mfd : raspberrypi - disabled system.adapter.vis-timeandweather.0 : vis-timeandweather : raspberrypi - disabled system.adapter.vis.0 : vis : raspberrypi - disabled system.adapter.web.0 : web : raspberrypi - disabled, port: 8082, bind: 0.0.0.0, run as: admin system.adapter.worx.0 : worx : raspberrypi - enabled system.adapter.yamaha.0 : yamaha : raspberrypi - enabled system.adapter.zigbee.0 : zigbee : raspberrypi - enabled, port: /dev/ttyACM0 + instance is alive Enabled adapters with bindings + system.adapter.admin.0 : admin : raspberrypi - enabled, port: 8081, bind: 0.0.0.0, run as: admin system.adapter.mqtt.0 : mqtt : raspberrypi - enabled, port: 1885, bind: 0.0.0.0 system.adapter.simple-api.0 : simple-api : raspberrypi - enabled, port: 8087, bind: 192.168.178.12, run as: admin system.adapter.telegram.0 : telegram : raspberrypi - enabled, port: 8443, bind: 0.0.0.0 system.adapter.zigbee.0 : zigbee : raspberrypi - enabled, port: /dev/ttyACM0 ioBroker-Repositories Stable (default): http://download.iobroker.net/sources-dist.json Beta (latest) : http://download.iobroker.net/sources-dist-latest.json Active repo(s): Stable (default) Installed ioBroker-Instances Used repository: Stable (default) Adapter "admin" : 6.13.16 , installed 6.13.16 Adapter "alexa2" : 3.26.5 , installed 3.26.5 Adapter "backitup" : 2.11.0 , installed 2.11.0 Adapter "daswetter" : 3.1.13 , installed 3.1.13 Adapter "device-reminder": 3.1.2 , installed 3.1.2 Adapter "devices" : 1.1.5 , installed 1.1.5 Adapter "echarts" : 1.7.2 , installed 1.7.2 Adapter "ems-esp" : 3.5.0 , installed 3.0.3 [Updatable] Adapter "flot" : 1.12.0 , installed 1.12.0 Adapter "harmony" : 1.4.0 , installed 1.4.0 Adapter "heatingcontrol": 2.12.5 , installed 2.12.5 Adapter "ical" : 1.15.0 , installed 1.14.3 [Updatable] Adapter "iot" : 3.2.2 , installed 2.0.11 [Updatable] Adapter "javascript" : 8.3.1 , installed 7.8.0 [Updatable] Controller "js-controller": 5.0.19 , installed 5.0.19 Adapter "lgtv" : 2.2.0 , installed 2.2.0 Adapter "lupusec" : 1.3.6 , installed 1.3.6 Adapter "mihome-vacuum": 4.2.0 , installed 4.1.1 [Updatable] Adapter "mqtt" : 5.2.0 , installed 5.2.0 Adapter "octoprint" : 5.1.0 , installed 5.1.0 Adapter "pvforecast" : 2.9.1 , installed 2.9.1 Adapter "simple-api" : 2.8.0 , installed 2.7.2 [Updatable] Adapter "socketio" : 6.7.0 , installed 6.7.0 Adapter "sql" : 2.2.0 , installed 2.2.0 Adapter "tankerkoenig" : 3.4.0 , installed 3.3.7 [Updatable] Adapter "telegram" : 3.3.2 , installed 3.2.1 [Updatable] Adapter "vis" : 1.5.4 , installed 1.5.4 Adapter "vis-2-widgets-energy": 0.3.11, installed 0.3.11 Adapter "vis-2-widgets-gauges": 1.0.3, installed 1.0.3 Adapter "vis-2-widgets-material": 1.3.32, installed 1.3.25 [Updatable] Adapter "vis-colorpicker": 2.0.3 , installed 2.0.3 Adapter "vis-jqui-mfd" : 1.1.1 , installed 1.1.1 Adapter "vis-timeandweather": 1.2.2, installed 1.2.2 Adapter "web" : 6.2.5 , installed 6.2.5 Adapter "worx" : 3.0.2 , installed 2.3.4 [Updatable] Adapter "ws" : 2.6.1 , installed 2.6.1 Adapter "yamaha" : 0.5.3 , installed 0.5.3 Adapter "zigbee" : 1.10.3 , installed 1.10.3 Objects and States Please stand by - This may take a while Objects: 9805 States: 7152 *** OS-Repositories and Updates *** Hit:1 http://deb.debian.org/debian bookworm InRelease Hit:2 http://deb.debian.org/debian-security bookworm-security InRelease Hit:3 http://deb.debian.org/debian bookworm-updates InRelease Hit:4 http://archive.raspberrypi.com/debian bookworm InRelease Hit:5 https://deb.nodesource.com/node_18.x nodistro InRelease Reading package lists... Pending Updates: 4 *** Listening Ports *** Active Internet connections (only servers) Proto Recv-Q Send-Q Local Address Foreign Address State User Inode PID/Program name tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN 0 1736 729/sshd: /usr/sbin tcp 0 0 127.0.0.1:9001 0.0.0.0:* LISTEN 1001 6995707 2389797/iobroker.js tcp 0 0 127.0.0.1:9000 0.0.0.0:* LISTEN 1001 6997486 2389797/iobroker.js tcp 0 0 0.0.0.0:1885 0.0.0.0:* LISTEN 1001 7005258 2389957/io.mqtt.0 tcp 0 0 127.0.0.1:3306 0.0.0.0:* LISTEN 106 1769 803/mariadbd tcp 0 0 192.168.178.12:8087 0.0.0.0:* LISTEN 1001 7002408 2391110/io.simple-a tcp6 0 0 :::22 :::* LISTEN 0 1738 729/sshd: /usr/sbin tcp6 0 0 :::61991 :::* LISTEN 1001 6998550 2389928/io.harmony. tcp6 0 0 :::8081 :::* LISTEN 1001 6998490 2389840/io.admin.0 udp 0 0 0.0.0.0:5353 0.0.0.0:* 104 1533 554/avahi-daemon: r udp 0 0 0.0.0.0:47870 0.0.0.0:* 104 1535 554/avahi-daemon: r udp 0 0 0.0.0.0:61991 0.0.0.0:* 1001 6998551 2389928/io.harmony. udp6 0 0 :::5353 :::* 104 1534 554/avahi-daemon: r udp6 0 0 :::52854 :::* 104 1536 554/avahi-daemon: r udp6 0 0 fe80::378e:5998:7a1:546 :::* 0 2974 601/NetworkManager *** Log File - Last 25 Lines *** 2024-06-04 20:14:46.279 - error: daswetter.0 (2390543) exception in await insertIntoList [Error: Could not check object existence of daswetter.0.NextDaysDetailed.Location_1.Day_2.Hour_4.clouds_value: Cannot check object existence of "daswetter.0.NextDaysDetailed.Location_1.Day_2.Hour_4.clouds_value": Connection is closed.] 2024-06-04 20:14:46.282 - error: daswetter.0 (2390543) Cannot check object existence of "daswetter.0.NextDaysDetailed.Location_1.Day_2.Hour_4.snowline_value": Connection is closed. 2024-06-04 20:14:46.284 - error: daswetter.0 (2390543) exception in await insertIntoList [Error: Could not check object existence of daswetter.0.NextDaysDetailed.Location_1.Day_2.Hour_4.snowline_value: Cannot check object existence of "daswetter.0.NextDaysDetailed.Location_1.Day_2.Hour_4.snowline_value": Connection is closed.] 2024-06-04 20:14:46.291 - error: daswetter.0 (2390543) Cannot check object existence of "daswetter.0.NextDaysDetailed.Location_1.Day_2.Hour_4.windchill_value": Connection is closed. 2024-06-04 20:14:46.294 - error: daswetter.0 (2390543) exception in await insertIntoList [Error: Could not check object existence of daswetter.0.NextDaysDetailed.Location_1.Day_2.Hour_4.windchill_value: Cannot check object existence of "daswetter.0.NextDaysDetailed.Location_1.Day_2.Hour_4.windchill_value": Connection is closed.] 2024-06-04 20:14:46.558 - error: host.raspberrypi instance system.adapter.daswetter.0 terminated with code 15 (UNKNOWN_ERROR) 2024-06-04 20:14:47.983 - info: heatingcontrol.0 (2391035) start statemachine 2024-06-04 20:14:50.125 - info: sourceanalytix.0 (2391160) Initialization of mqtt.0.Gaszaehler.main.value successfully 2024-06-04 20:14:50.204 - info: sourceanalytix.0 (2391160) Successfully activated SourceAnalytix for 3 of 3 states, will do my Job until you stop me! 2024-06-04 20:14:51.759 - info: heatingcontrol.0 (2391035) check all active sensors 2024-06-04 20:14:51.915 - info: heatingcontrol.0 (2391035) checking external states 2024-06-04 20:14:55.769 - info: tankerkoenig.0 (2391259) Start first request 2024-06-04 20:15:07.932 - info: heatingcontrol.0 (2391035) checking external states done 2024-06-04 20:15:07.936 - info: heatingcontrol.0 (2391035) calculate current profile point for all rooms 2024-06-04 20:15:07.944 - info: heatingcontrol.0 (2391035) start calculate current profile point for profile type 2 (Mo-Fr / Sa - Su) 2024-06-04 20:15:08.248 - info: heatingcontrol.0 (2391035) start calculate current profile point for profile type 2 (Mo-Fr / Sa - Su) 2024-06-04 20:15:08.545 - info: heatingcontrol.0 (2391035) start calculate current profile point for profile type 2 (Mo-Fr / Sa - Su) 2024-06-04 20:15:08.700 - info: heatingcontrol.0 (2391035) start calculate current profile point for profile type 2 (Mo-Fr / Sa - Su) 2024-06-04 20:15:08.844 - info: heatingcontrol.0 (2391035) start calculate current profile point for profile type 2 (Mo-Fr / Sa - Su) 2024-06-04 20:15:09.027 - info: heatingcontrol.0 (2391035) start calculate current profile point for profile type 2 (Mo-Fr / Sa - Su) 2024-06-04 20:15:09.174 - info: heatingcontrol.0 (2391035) start calculate current profile point for profile type 2 (Mo-Fr / Sa - Su) 2024-06-04 20:15:09.311 - info: heatingcontrol.0 (2391035) start calculate current profile point for profile type 2 (Mo-Fr / Sa - Su) 2024-06-04 20:15:09.800 - info: heatingcontrol.0 (2391035) Wohnzimmer: WZ Thermostatwert eingestellt auf 23.5°C 2024-06-04 20:15:10.864 - info: heatingcontrol.0 (2391035) Bad: Bad Thermostatwert eingestellt auf 22°C 2024-06-04 20:15:11.480 - info: heatingcontrol.0 (2391035) statemachine started============ Mark until here for C&P =============
@anno171986 sagte in Objects database error: connect ECONNREFUSED 127.0.0.1:9001:
ioBroker Status
iobroker is running on this host.Der läuft.
Genauso wie ein Display-Server...iob stop sudo reboot -
@thomas-braun Leider ist nach der Neuinstallation und einspielen des Backups alles viel schlimmer geworden. iobroker läuft jetzt gar nicht mehr.
======== Start marking the full check here =========
Skript v.2024-05-22 *** BASE SYSTEM *** Static hostname: raspberrypi Icon name: computer Operating System: Debian GNU/Linux 12 (bookworm) Kernel: Linux 6.6.28+rpt-rpi-v8 Architecture: arm64 Model : Raspberry Pi 4 Model B Rev 1.4 Docker : false Virtualization : none Kernel : aarch64 Userland : 64 bit Systemuptime and Load: 20:13:46 up 8 days, 7 min, 4 users, load average: 6.78, 3.30, 3.07 CPU threads: 4 *** RASPBERRY THROTTLING *** Current issues: No throttling issues detected. Previously detected issues: No throttling issues detected. *** Time and Time Zones *** Local time: Tue 2024-06-04 20:13:47 CEST Universal time: Tue 2024-06-04 18:13:47 UTC RTC time: n/a Time zone: Europe/Berlin (CEST, +0200) System clock synchronized: yes NTP service: active RTC in local TZ: no *** Users and Groups *** User that called 'iob diag': anno171986 HOME=/home/anno171986 GROUPS=anno171986 adm dialout cdrom sudo audio video plugdev games users input render netdev gpio i2c spi iobroker User that is running 'js-controller': iobroker HOME=/home/iobroker GROUPS=iobroker tty dialout audio video plugdev bluetooth gpio i2c *** Display-Server-Setup *** Display-Server: true Desktop: Terminal: tty Boot Target: multi-user.target *** MEMORY *** total used free shared buff/cache available Mem: 8.2G 3.5G 2.4G 1.3M 2.5G 4.7G Swap: 209M 0B 209M Total: 8.4G 3.5G 2.6G Active iob-Instances: 2 7809 M total memory 3346 M used memory 3572 M active memory 1697 M inactive memory 2269 M free memory 159 M buffer memory 2204 M swap cache 199 M total swap 0 M used swap 199 M free swap *** top - Table Of Processes *** top - 20:13:47 up 8 days, 7 min, 4 users, load average: 6.78, 3.30, 3.07 Tasks: 215 total, 7 running, 208 sleeping, 0 stopped, 0 zombie %Cpu(s): 62.5 us, 37.5 sy, 0.0 ni, 0.0 id, 0.0 wa, 0.0 hi, 0.0 si, 0.0 st MiB Mem : 7809.0 total, 2265.8 free, 3350.6 used, 2363.7 buff/cache MiB Swap: 200.0 total, 200.0 free, 0.0 used. 4458.5 avail Mem *** FAILED SERVICES *** UNIT LOAD ACTIVE SUB DESCRIPTION 0 loaded units listed. *** FILESYSTEM *** Filesystem Type Size Used Avail Use% Mounted on udev devtmpfs 3.6G 0 3.6G 0% /dev tmpfs tmpfs 781M 1.3M 780M 1% /run /dev/sda2 ext4 117G 7.3G 104G 7% / tmpfs tmpfs 3.9G 0 3.9G 0% /dev/shm tmpfs tmpfs 5.0M 16K 5.0M 1% /run/lock /dev/sda1 vfat 510M 64M 447M 13% /boot/firmware //192.168.178.11/raspberrypi/ioBrokerBackup cifs 7.3T 1.3T 6.0T 18% /opt/iobroker/backups tmpfs tmpfs 781M 0 781M 0% /run/user/1000 Messages concerning ext4 filesystem in dmesg: Show mounted filesystems: TARGET SOURCE FSTYPE OPTIONS / /dev/sda2 ext4 rw,noatime |-/sys sysfs sysfs rw,nosuid,nodev,noexec,relatime | |-/sys/kernel/security securityfs securityfs rw,nosuid,nodev,noexec,relatime | |-/sys/fs/cgroup cgroup2 cgroup2 rw,nosuid,nodev,noexec,relatime,nsdelegate,memory_recursiveprot | |-/sys/fs/pstore pstore pstore rw,nosuid,nodev,noexec,relatime | |-/sys/fs/bpf bpf bpf rw,nosuid,nodev,noexec,relatime,mode=700 | |-/sys/kernel/debug debugfs debugfs rw,nosuid,nodev,noexec,relatime | |-/sys/kernel/tracing tracefs tracefs rw,nosuid,nodev,noexec,relatime | |-/sys/fs/fuse/connections fusectl fusectl rw,nosuid,nodev,noexec,relatime | `-/sys/kernel/config configfs configfs rw,nosuid,nodev,noexec,relatime |-/proc proc proc rw,relatime | `-/proc/sys/fs/binfmt_misc systemd-1 autofs rw,relatime,fd=30,pgrp=1,timeout=0,minproto=5,maxproto=5,direct,pipe_ino=2262 | `-/proc/sys/fs/binfmt_misc binfmt_misc binfmt_misc rw,nosuid,nodev,noexec,relatime |-/dev udev devtmpfs rw,nosuid,relatime,size=3728000k,nr_inodes=932000,mode=755 | |-/dev/pts devpts devpts rw,nosuid,noexec,relatime,gid=5,mode=620,ptmxmode=000 | |-/dev/shm tmpfs tmpfs rw,nosuid,nodev | `-/dev/mqueue mqueue mqueue rw,nosuid,nodev,noexec,relatime |-/run tmpfs tmpfs rw,nosuid,nodev,noexec,relatime,size=799648k,mode=755 | |-/run/lock tmpfs tmpfs rw,nosuid,nodev,noexec,relatime,size=5120k | |-/run/credentials/systemd-sysctl.service ramfs ramfs ro,nosuid,nodev,noexec,relatime,mode=700 | |-/run/credentials/systemd-sysusers.service ramfs ramfs ro,nosuid,nodev,noexec,relatime,mode=700 | |-/run/credentials/systemd-tmpfiles-setup-dev.service ramfs ramfs ro,nosuid,nodev,noexec,relatime,mode=700 | |-/run/rpc_pipefs sunrpc rpc_pipefs rw,relatime | |-/run/credentials/systemd-tmpfiles-setup.service ramfs ramfs ro,nosuid,nodev,noexec,relatime,mode=700 | `-/run/user/1000 tmpfs tmpfs rw,nosuid,nodev,relatime,size=799644k,nr_inodes=199911,mode=700,uid=1000,gid=1000 |-/boot/firmware /dev/sda1 vfat rw,relatime,fmask=0022,dmask=0022,codepage=437,iocharset=ascii,shortname=mixed,errors=remount-ro `-/opt/iobroker/backups //192.168.178.11/raspberrypi/ioBrokerBackup cifs rw,relatime,vers=3.1.1,cache=strict,username=raspberrypi,uid=1001,noforceuid,gid=1001,noforcegid,addr=192.168.178.11,file_mode=0777,dir_mode=0777,soft,nounix,serverino,mapposix,rsize=4194304,wsize=4194304,bsize=1048576,echo_interval=60,actimeo=1,closetimeo=1 Files in neuralgic directories: /var: 1.6G /var/ 912M /var/log/journal/9735987036244807bbcd08440a9098fe 912M /var/log/journal 912M /var/log 291M /var/lib Archived and active journals take up 911.5M in the file system. /opt/iobroker/backups: 277M /opt/iobroker/backups/ /opt/iobroker/iobroker-data: 1.6G /opt/iobroker/iobroker-data/ 409M /opt/iobroker/iobroker-data/files 128M /opt/iobroker/iobroker-data/backup-objects 89M /opt/iobroker/iobroker-data/files/echarts.admin 57M /opt/iobroker/iobroker-data/files/javascript.admin The five largest files in iobroker-data are: 994M /opt/iobroker/iobroker-data/states.jsonl 35M /opt/iobroker/iobroker-data/files/devices.admin/static/js/main.24f2bb56.js.map 33M /opt/iobroker/iobroker-data/files/iot.admin/static/js/main.1797d034.js.map 24M /opt/iobroker/iobroker-data/files/web.admin/static/js/main.135279a0.js.map 24M /opt/iobroker/iobroker-data/files/echarts/static/js/main.2b7495c2.js.map USB-Devices by-id: USB-Sticks - Avoid direct links to /dev/tty* in your adapter setups, please always prefer the links 'by-id': /dev/serial/by-id/usb-Texas_Instruments_CC2538_USB_CDC-if00 HINT: Your zigbee.0 COM-Port is NOT matching 'by-id'. Please check your setting: /dev/ttyACM0 *** NodeJS-Installation *** /usr/bin/nodejs v18.20.3 /usr/bin/node v18.20.3 /usr/bin/npm 10.7.0 /usr/bin/npx 10.7.0 /usr/bin/corepack 0.28.0 nodejs: Installed: 18.20.3-1nodesource1 Candidate: 18.20.3-1nodesource1 Version table: *** 18.20.3-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 100 /var/lib/dpkg/status 18.20.2-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.20.1-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.20.0-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.19.1-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.19.0+dfsg-6~deb12u1 500 500 http://deb.debian.org/debian-security bookworm-security/main arm64 Packages 18.19.0-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.18.2-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.18.1-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.18.0-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.17.1-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.17.0-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.16.1-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.16.0-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.15.0-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.14.2-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.14.1-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.14.0-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.13.0+dfsg1-1 500 500 http://deb.debian.org/debian bookworm/main arm64 Packages 18.13.0-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.12.0-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.11.0-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.10.0-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.9.1-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.9.0-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.8.0-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.7.0-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.6.0-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.5.0-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.4.0-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.3.0-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.2.0-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.1.0-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages 18.0.0-1nodesource1 1001 500 https://deb.nodesource.com/node_18.x nodistro/main arm64 Packages Temp directories causing npm8 problem: 108 Some problems detected, please run iob fix Errors in npm tree: *** ioBroker-Installation *** ioBroker Status iobroker is running on this host. Objects type: jsonl States type: jsonl Core adapters versions js-controller: 5.0.19 admin: 6.13.16 javascript: 7.8.0 nodejs modules from github: 1 +-- iobroker.sourceanalytix@0.4.14 (git+ssh://git@github.com/DrozmotiX/ioBroker.sourceanalytix.git#87a9b7837569274a136c4fa03ee6fbfd8a20f183) Adapter State + system.adapter.admin.0 : admin : raspberrypi - enabled, port: 8081, bind: 0.0.0.0, run as: admin system.adapter.alexa2.0 : alexa2 : raspberrypi - enabled system.adapter.backitup.0 : backitup : raspberrypi - enabled system.adapter.daswetter.0 : daswetter : raspberrypi - enabled system.adapter.device-reminder.0 : device-reminder : raspberrypi - enabled system.adapter.devices.0 : devices : raspberrypi - disabled system.adapter.echarts.0 : echarts : raspberrypi - enabled system.adapter.ems-esp.0 : ems-esp : raspberrypi - enabled system.adapter.flot.0 : flot : raspberrypi - disabled system.adapter.harmony.0 : harmony : raspberrypi - enabled system.adapter.heatingcontrol.0 : heatingcontrol : raspberrypi - enabled system.adapter.ical.0 : ical : raspberrypi - enabled system.adapter.info.0 : info : raspberrypi - disabled system.adapter.iot.0 : iot : raspberrypi - enabled system.adapter.javascript.0 : javascript : raspberrypi - enabled system.adapter.lgtv.0 : lgtv : raspberrypi - enabled system.adapter.lupusec.0 : lupusec : raspberrypi - enabled system.adapter.mihome-vacuum.0 : mihome-vacuum : raspberrypi - disabled, port: 54321 system.adapter.mqtt.0 : mqtt : raspberrypi - enabled, port: 1885, bind: 0.0.0.0 system.adapter.octoprint.0 : octoprint : raspberrypi - disabled system.adapter.pvforecast.0 : pvforecast : raspberrypi - disabled system.adapter.simple-api.0 : simple-api : raspberrypi - enabled, port: 8087, bind: 192.168.178.12, run as: admin system.adapter.sourceanalytix.0 : sourceanalytix : raspberrypi - enabled system.adapter.sql.0 : sql : raspberrypi - disabled, port: 3306 system.adapter.tankerkoenig.0 : tankerkoenig : raspberrypi - enabled system.adapter.telegram.0 : telegram : raspberrypi - enabled, port: 8443, bind: 0.0.0.0 system.adapter.vis-2-beta.0 : vis-2-beta : raspberrypi - disabled system.adapter.vis-2-widgets-energy.0 : vis-2-widgets-energy : raspberrypi - disabled system.adapter.vis-2-widgets-gauges.0 : vis-2-widgets-gauges : raspberrypi - disabled system.adapter.vis-2-widgets-material.0 : vis-2-widgets-material: raspberrypi - disabled system.adapter.vis-colorpicker.0 : vis-colorpicker : raspberrypi - disabled system.adapter.vis-jqui-mfd.0 : vis-jqui-mfd : raspberrypi - disabled system.adapter.vis-timeandweather.0 : vis-timeandweather : raspberrypi - disabled system.adapter.vis.0 : vis : raspberrypi - disabled system.adapter.web.0 : web : raspberrypi - disabled, port: 8082, bind: 0.0.0.0, run as: admin system.adapter.worx.0 : worx : raspberrypi - enabled system.adapter.yamaha.0 : yamaha : raspberrypi - enabled system.adapter.zigbee.0 : zigbee : raspberrypi - enabled, port: /dev/ttyACM0 + instance is alive Enabled adapters with bindings + system.adapter.admin.0 : admin : raspberrypi - enabled, port: 8081, bind: 0.0.0.0, run as: admin system.adapter.mqtt.0 : mqtt : raspberrypi - enabled, port: 1885, bind: 0.0.0.0 system.adapter.simple-api.0 : simple-api : raspberrypi - enabled, port: 8087, bind: 192.168.178.12, run as: admin system.adapter.telegram.0 : telegram : raspberrypi - enabled, port: 8443, bind: 0.0.0.0 system.adapter.zigbee.0 : zigbee : raspberrypi - enabled, port: /dev/ttyACM0 ioBroker-Repositories Stable (default): http://download.iobroker.net/sources-dist.json Beta (latest) : http://download.iobroker.net/sources-dist-latest.json Active repo(s): Stable (default) Installed ioBroker-Instances Used repository: Stable (default) Adapter "admin" : 6.13.16 , installed 6.13.16 Adapter "alexa2" : 3.26.5 , installed 3.26.5 Adapter "backitup" : 2.11.0 , installed 2.11.0 Adapter "daswetter" : 3.1.13 , installed 3.1.13 Adapter "device-reminder": 3.1.2 , installed 3.1.2 Adapter "devices" : 1.1.5 , installed 1.1.5 Adapter "echarts" : 1.7.2 , installed 1.7.2 Adapter "ems-esp" : 3.5.0 , installed 3.0.3 [Updatable] Adapter "flot" : 1.12.0 , installed 1.12.0 Adapter "harmony" : 1.4.0 , installed 1.4.0 Adapter "heatingcontrol": 2.12.5 , installed 2.12.5 Adapter "ical" : 1.15.0 , installed 1.14.3 [Updatable] Adapter "iot" : 3.2.2 , installed 2.0.11 [Updatable] Adapter "javascript" : 8.3.1 , installed 7.8.0 [Updatable] Controller "js-controller": 5.0.19 , installed 5.0.19 Adapter "lgtv" : 2.2.0 , installed 2.2.0 Adapter "lupusec" : 1.3.6 , installed 1.3.6 Adapter "mihome-vacuum": 4.2.0 , installed 4.1.1 [Updatable] Adapter "mqtt" : 5.2.0 , installed 5.2.0 Adapter "octoprint" : 5.1.0 , installed 5.1.0 Adapter "pvforecast" : 2.9.1 , installed 2.9.1 Adapter "simple-api" : 2.8.0 , installed 2.7.2 [Updatable] Adapter "socketio" : 6.7.0 , installed 6.7.0 Adapter "sql" : 2.2.0 , installed 2.2.0 Adapter "tankerkoenig" : 3.4.0 , installed 3.3.7 [Updatable] Adapter "telegram" : 3.3.2 , installed 3.2.1 [Updatable] Adapter "vis" : 1.5.4 , installed 1.5.4 Adapter "vis-2-widgets-energy": 0.3.11, installed 0.3.11 Adapter "vis-2-widgets-gauges": 1.0.3, installed 1.0.3 Adapter "vis-2-widgets-material": 1.3.32, installed 1.3.25 [Updatable] Adapter "vis-colorpicker": 2.0.3 , installed 2.0.3 Adapter "vis-jqui-mfd" : 1.1.1 , installed 1.1.1 Adapter "vis-timeandweather": 1.2.2, installed 1.2.2 Adapter "web" : 6.2.5 , installed 6.2.5 Adapter "worx" : 3.0.2 , installed 2.3.4 [Updatable] Adapter "ws" : 2.6.1 , installed 2.6.1 Adapter "yamaha" : 0.5.3 , installed 0.5.3 Adapter "zigbee" : 1.10.3 , installed 1.10.3 Objects and States Please stand by - This may take a while Objects: 9805 States: 7152 *** OS-Repositories and Updates *** Hit:1 http://deb.debian.org/debian bookworm InRelease Hit:2 http://deb.debian.org/debian-security bookworm-security InRelease Hit:3 http://deb.debian.org/debian bookworm-updates InRelease Hit:4 http://archive.raspberrypi.com/debian bookworm InRelease Hit:5 https://deb.nodesource.com/node_18.x nodistro InRelease Reading package lists... Pending Updates: 4 *** Listening Ports *** Active Internet connections (only servers) Proto Recv-Q Send-Q Local Address Foreign Address State User Inode PID/Program name tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN 0 1736 729/sshd: /usr/sbin tcp 0 0 127.0.0.1:9001 0.0.0.0:* LISTEN 1001 6995707 2389797/iobroker.js tcp 0 0 127.0.0.1:9000 0.0.0.0:* LISTEN 1001 6997486 2389797/iobroker.js tcp 0 0 0.0.0.0:1885 0.0.0.0:* LISTEN 1001 7005258 2389957/io.mqtt.0 tcp 0 0 127.0.0.1:3306 0.0.0.0:* LISTEN 106 1769 803/mariadbd tcp 0 0 192.168.178.12:8087 0.0.0.0:* LISTEN 1001 7002408 2391110/io.simple-a tcp6 0 0 :::22 :::* LISTEN 0 1738 729/sshd: /usr/sbin tcp6 0 0 :::61991 :::* LISTEN 1001 6998550 2389928/io.harmony. tcp6 0 0 :::8081 :::* LISTEN 1001 6998490 2389840/io.admin.0 udp 0 0 0.0.0.0:5353 0.0.0.0:* 104 1533 554/avahi-daemon: r udp 0 0 0.0.0.0:47870 0.0.0.0:* 104 1535 554/avahi-daemon: r udp 0 0 0.0.0.0:61991 0.0.0.0:* 1001 6998551 2389928/io.harmony. udp6 0 0 :::5353 :::* 104 1534 554/avahi-daemon: r udp6 0 0 :::52854 :::* 104 1536 554/avahi-daemon: r udp6 0 0 fe80::378e:5998:7a1:546 :::* 0 2974 601/NetworkManager *** Log File - Last 25 Lines *** 2024-06-04 20:14:46.279 - error: daswetter.0 (2390543) exception in await insertIntoList [Error: Could not check object existence of daswetter.0.NextDaysDetailed.Location_1.Day_2.Hour_4.clouds_value: Cannot check object existence of "daswetter.0.NextDaysDetailed.Location_1.Day_2.Hour_4.clouds_value": Connection is closed.] 2024-06-04 20:14:46.282 - error: daswetter.0 (2390543) Cannot check object existence of "daswetter.0.NextDaysDetailed.Location_1.Day_2.Hour_4.snowline_value": Connection is closed. 2024-06-04 20:14:46.284 - error: daswetter.0 (2390543) exception in await insertIntoList [Error: Could not check object existence of daswetter.0.NextDaysDetailed.Location_1.Day_2.Hour_4.snowline_value: Cannot check object existence of "daswetter.0.NextDaysDetailed.Location_1.Day_2.Hour_4.snowline_value": Connection is closed.] 2024-06-04 20:14:46.291 - error: daswetter.0 (2390543) Cannot check object existence of "daswetter.0.NextDaysDetailed.Location_1.Day_2.Hour_4.windchill_value": Connection is closed. 2024-06-04 20:14:46.294 - error: daswetter.0 (2390543) exception in await insertIntoList [Error: Could not check object existence of daswetter.0.NextDaysDetailed.Location_1.Day_2.Hour_4.windchill_value: Cannot check object existence of "daswetter.0.NextDaysDetailed.Location_1.Day_2.Hour_4.windchill_value": Connection is closed.] 2024-06-04 20:14:46.558 - error: host.raspberrypi instance system.adapter.daswetter.0 terminated with code 15 (UNKNOWN_ERROR) 2024-06-04 20:14:47.983 - info: heatingcontrol.0 (2391035) start statemachine 2024-06-04 20:14:50.125 - info: sourceanalytix.0 (2391160) Initialization of mqtt.0.Gaszaehler.main.value successfully 2024-06-04 20:14:50.204 - info: sourceanalytix.0 (2391160) Successfully activated SourceAnalytix for 3 of 3 states, will do my Job until you stop me! 2024-06-04 20:14:51.759 - info: heatingcontrol.0 (2391035) check all active sensors 2024-06-04 20:14:51.915 - info: heatingcontrol.0 (2391035) checking external states 2024-06-04 20:14:55.769 - info: tankerkoenig.0 (2391259) Start first request 2024-06-04 20:15:07.932 - info: heatingcontrol.0 (2391035) checking external states done 2024-06-04 20:15:07.936 - info: heatingcontrol.0 (2391035) calculate current profile point for all rooms 2024-06-04 20:15:07.944 - info: heatingcontrol.0 (2391035) start calculate current profile point for profile type 2 (Mo-Fr / Sa - Su) 2024-06-04 20:15:08.248 - info: heatingcontrol.0 (2391035) start calculate current profile point for profile type 2 (Mo-Fr / Sa - Su) 2024-06-04 20:15:08.545 - info: heatingcontrol.0 (2391035) start calculate current profile point for profile type 2 (Mo-Fr / Sa - Su) 2024-06-04 20:15:08.700 - info: heatingcontrol.0 (2391035) start calculate current profile point for profile type 2 (Mo-Fr / Sa - Su) 2024-06-04 20:15:08.844 - info: heatingcontrol.0 (2391035) start calculate current profile point for profile type 2 (Mo-Fr / Sa - Su) 2024-06-04 20:15:09.027 - info: heatingcontrol.0 (2391035) start calculate current profile point for profile type 2 (Mo-Fr / Sa - Su) 2024-06-04 20:15:09.174 - info: heatingcontrol.0 (2391035) start calculate current profile point for profile type 2 (Mo-Fr / Sa - Su) 2024-06-04 20:15:09.311 - info: heatingcontrol.0 (2391035) start calculate current profile point for profile type 2 (Mo-Fr / Sa - Su) 2024-06-04 20:15:09.800 - info: heatingcontrol.0 (2391035) Wohnzimmer: WZ Thermostatwert eingestellt auf 23.5°C 2024-06-04 20:15:10.864 - info: heatingcontrol.0 (2391035) Bad: Bad Thermostatwert eingestellt auf 22°C 2024-06-04 20:15:11.480 - info: heatingcontrol.0 (2391035) statemachine started============ Mark until here for C&P =============
@anno171986 sagte in Objects database error: connect ECONNREFUSED 127.0.0.1:9001:
Temp directories causing npm8 problem: 108
Some problems detected, please run iob fixDas dann auch machen.
Und nodejs auf die Empfehlung v20 bringen.iob nodejs-updateDie ganzen Adapter auch auf Stand bringen...
-
@anno171986 sagte in Objects database error: connect ECONNREFUSED 127.0.0.1:9001:
ioBroker Status
iobroker is running on this host.Der läuft.
Genauso wie ein Display-Server...iob stop sudo reboot@thomas-braun Ok, jetzt scheint er tatsächlich mal wieder zu laufen, hatte es 2 Wochen nicht mehr probiert weil ich frustriert war. Hauptproblem war der SQL Adapter bzw wohl die Datenbank. Kann man irgendwo im Dateisystem nachgucken ob die Datenbank richtig wiederhergestellt wurde?
-
@thomas-braun Ok, jetzt scheint er tatsächlich mal wieder zu laufen, hatte es 2 Wochen nicht mehr probiert weil ich frustriert war. Hauptproblem war der SQL Adapter bzw wohl die Datenbank. Kann man irgendwo im Dateisystem nachgucken ob die Datenbank richtig wiederhergestellt wurde?
Dein Hauptproblem ist der total inkonsistente Update-Stand auf der Kiste.
-
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 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