Objects database error: connect ECONNREFUSED 127.0.0.1:9001
-
@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.
-
@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 -
@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 -
@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 -
@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 -
-
@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 =============
-
@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
-
ENDLICH!
Es lag an den Credentials und an den Rechten für den User (Remote-Zugriff).
Jetzt, wo der SQl Adapter wieder grün wurde konnte ich auch das SQL Backup einspielen und die DB ist nun auch wieder da.
Vielen DAnk für deine Hilfe!
