ioBroker.sql icon indicating copy to clipboard operation
ioBroker.sql copied to clipboard

Published 20 hours ago • verified publisher icon ioBroker

Error: connect ETIMEDOUT -> sql.0.info.connection = true ?

Open Scrounger opened this issue 1 year ago • 3 comments

Describe the bug
If the adapter loses the connection to the database, the state sql.0.info.connection is not set to false, and the log shows Error: connect ETIMEDOUT.

To Reproduce
Steps to reproduce the behavior:

  1. Break the connection between sql server and iobroker
  2. Error Error: connect ETIMEDOUT is shown in the log
  3. state sql.0.info.connection is still true
  4. See error

Expected behavior
State sql.0.info.connection should be false, because there is not connection to the sql server. Ok a timeout can happen, but after 5x timeouts in a row, you can expect there is no connection to the server any more

Versions:

  • Adapter version: 2.2.0
  • JS-Controller version: 5.0.19
  • Node version: v18.20.0
  • Operating system: ubuntu

Additional context

Scrounger avatar Jun 15 '24 21:06 Scrounger

Please provide a debug log of such a case if possible

Apollon77 avatar Jun 20 '24 15:06 Apollon77 

2024-06-20 21:02:31.143  - [31merror[39m: sql.0 (3565) Error: connect ETIMEDOUT
2024-06-20 21:02:31.475  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB called for alias.0.Sensoren.Strom.Haus.Autarkie (type: 0, ID: 50) and state: {"val":11,"ack":true,"ts":1718910150478,"q":0,"c":"script.js.alias.Sensoren.Strom.Berechnung","from":"system.adapter.javascript.0","user":"system.user.admin","lc":1718910141474}
2024-06-20 21:02:31.475  - [34mdebug[39m: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Sensoren.Strom.Haus.Autarkie
2024-06-20 21:02:31.475  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB-prepareTaskCheckTypeAndDbId RESULT for alias.0.Sensoren.Strom.Haus.Autarkie (type: 0, ID: 50) and state: {"val":11,"ack":true,"ts":1718910150478,"q":0,"c":"script.js.alias.Sensoren.Strom.Berechnung","from":"system.adapter.javascript.0","user":"system.user.admin","lc":1718910141474}: undefined
2024-06-20 21:02:31.476  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB called for alias.0.Sensoren.Strom.Haus.Leistung_Haus_only (type: 0, ID: 49) and state: {"val":489.64,"ack":true,"ts":1718910150479,"q":0,"c":"script.js.alias.Sensoren.Strom.Berechnung","from":"system.adapter.javascript.0","user":"system.user.admin","lc":1718910150479}
2024-06-20 21:02:31.476  - [34mdebug[39m: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Sensoren.Strom.Haus.Leistung_Haus_only
2024-06-20 21:02:31.476  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB-prepareTaskCheckTypeAndDbId RESULT for alias.0.Sensoren.Strom.Haus.Leistung_Haus_only (type: 0, ID: 49) and state: {"val":489.64,"ack":true,"ts":1718910150479,"q":0,"c":"script.js.alias.Sensoren.Strom.Berechnung","from":"system.adapter.javascript.0","user":"system.user.admin","lc":1718910150479}: undefined
2024-06-20 21:02:31.630  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB called for alias.0.Sensoren.Wetterstation.Aussen.Garten.Temperatur (type: 0, ID: 609) and state: {"val":23.6,"ack":true,"ts":1718910091415,"q":0,"from":"system.adapter.weatherflow_udp.0","user":"system.user.admin","lc":1718910031654}
2024-06-20 21:02:31.630  - [34mdebug[39m: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Sensoren.Wetterstation.Aussen.Garten.Temperatur
2024-06-20 21:02:31.630  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB-prepareTaskCheckTypeAndDbId RESULT for alias.0.Sensoren.Wetterstation.Aussen.Garten.Temperatur (type: 0, ID: 609) and state: {"val":23.6,"ack":true,"ts":1718910091415,"q":0,"from":"system.adapter.weatherflow_udp.0","user":"system.user.admin","lc":1718910031654}: undefined
2024-06-20 21:02:31.631  - [34mdebug[39m: sql.0 (3565) INSERT INTO `iobroker`.ts_number (id, ts, val, ack, _from, q) VALUES (609, 1718910091415, 23.6, 1, 19, 0);
2024-06-20 21:02:31.631  - [34mdebug[39m: sql.0 (3565) Borrow connection from pool: 3 now
2024-06-20 21:02:32.143  - [34mdebug[39m: sql.0 (3565) Return connection to pool: 2 now
2024-06-20 21:02:32.144  - [31merror[39m: sql.0 (3565) Error: connect ETIMEDOUT
2024-06-20 21:02:32.472  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB called for alias.0.Devices.Stromzaehler.Haus.Leistung (type: 0, ID: 31) and state: {"val":658,"ack":true,"ts":1718910151471,"q":0,"from":"system.adapter.mqtt.0","user":"system.user.admin","lc":1718910151471}
2024-06-20 21:02:32.472  - [34mdebug[39m: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Devices.Stromzaehler.Haus.Leistung
2024-06-20 21:02:32.472  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB-prepareTaskCheckTypeAndDbId RESULT for alias.0.Devices.Stromzaehler.Haus.Leistung (type: 0, ID: 31) and state: {"val":658,"ack":true,"ts":1718910151471,"q":0,"from":"system.adapter.mqtt.0","user":"system.user.admin","lc":1718910151471}: undefined
2024-06-20 21:02:32.475  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB called for alias.0.Sensoren.Strom.Haus.Autarkie (type: 0, ID: 50) and state: {"val":12,"ack":true,"ts":1718910151475,"q":0,"c":"script.js.alias.Sensoren.Strom.Berechnung","from":"system.adapter.javascript.0","user":"system.user.admin","lc":1718910151475}
2024-06-20 21:02:32.475  - [34mdebug[39m: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Sensoren.Strom.Haus.Autarkie
2024-06-20 21:02:32.475  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB-prepareTaskCheckTypeAndDbId RESULT for alias.0.Sensoren.Strom.Haus.Autarkie (type: 0, ID: 50) and state: {"val":12,"ack":true,"ts":1718910151475,"q":0,"c":"script.js.alias.Sensoren.Strom.Berechnung","from":"system.adapter.javascript.0","user":"system.user.admin","lc":1718910151475}: undefined
2024-06-20 21:02:32.476  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB called for alias.0.Sensoren.Strom.Haus.Leistung_Haus_only (type: 0, ID: 49) and state: {"val":463.64,"ack":true,"ts":1718910151475,"q":0,"c":"script.js.alias.Sensoren.Strom.Berechnung","from":"system.adapter.javascript.0","user":"system.user.admin","lc":1718910151475}
2024-06-20 21:02:32.476  - [34mdebug[39m: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Sensoren.Strom.Haus.Leistung_Haus_only
2024-06-20 21:02:32.476  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB-prepareTaskCheckTypeAndDbId RESULT for alias.0.Sensoren.Strom.Haus.Leistung_Haus_only (type: 0, ID: 49) and state: {"val":463.64,"ack":true,"ts":1718910151475,"q":0,"c":"script.js.alias.Sensoren.Strom.Berechnung","from":"system.adapter.javascript.0","user":"system.user.admin","lc":1718910151475}: undefined
2024-06-20 21:02:32.631  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB called for alias.0.Sensoren.Wetterstation.Aussen.Garten.Temperatur (type: 0, ID: 609) and state: {"val":23.6,"ack":true,"ts":1718910151626,"q":0,"from":"system.adapter.weatherflow_udp.0","user":"system.user.admin","lc":1718910151626}
2024-06-20 21:02:32.631  - [34mdebug[39m: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Sensoren.Wetterstation.Aussen.Garten.Temperatur
2024-06-20 21:02:32.631  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB-prepareTaskCheckTypeAndDbId RESULT for alias.0.Sensoren.Wetterstation.Aussen.Garten.Temperatur (type: 0, ID: 609) and state: {"val":23.6,"ack":true,"ts":1718910151626,"q":0,"from":"system.adapter.weatherflow_udp.0","user":"system.user.admin","lc":1718910151626}: undefined
2024-06-20 21:02:32.631  - [34mdebug[39m: sql.0 (3565) INSERT INTO `iobroker`.ts_number (id, ts, val, ack, _from, q) VALUES (609, 1718910151626, 23.6, 1, 19, 0);
2024-06-20 21:02:32.631  - [34mdebug[39m: sql.0 (3565) Borrow connection from pool: 3 now
2024-06-20 21:02:32.632  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB called for alias.0.Sensoren.Wetterstation.Aussen.Garten.Helligkeit (type: 0, ID: 610) and state: {"val":1137,"ack":true,"ts":1718910151626,"q":0,"from":"system.adapter.weatherflow_udp.0","user":"system.user.admin","lc":1718910151626}
2024-06-20 21:02:32.632  - [34mdebug[39m: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Sensoren.Wetterstation.Aussen.Garten.Helligkeit
2024-06-20 21:02:32.632  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB-prepareTaskCheckTypeAndDbId RESULT for alias.0.Sensoren.Wetterstation.Aussen.Garten.Helligkeit (type: 0, ID: 610) and state: {"val":1137,"ack":true,"ts":1718910151626,"q":0,"from":"system.adapter.weatherflow_udp.0","user":"system.user.admin","lc":1718910151626}: undefined
2024-06-20 21:02:32.633  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB called for alias.0.Sensoren.Wetterstation.Aussen.Garten.Regenalarm (type: 2, ID: 741) and state: {"val":false,"ack":true,"ts":1718910151630,"q":0,"from":"system.adapter.weatherflow_udp.0","user":"system.user.admin","lc":1718811782305}
2024-06-20 21:02:32.633  - [34mdebug[39m: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Sensoren.Wetterstation.Aussen.Garten.Regenalarm
2024-06-20 21:02:32.633  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB-prepareTaskCheckTypeAndDbId RESULT for alias.0.Sensoren.Wetterstation.Aussen.Garten.Regenalarm (type: 2, ID: 741) and state: {"val":false,"ack":true,"ts":1718910151630,"q":0,"from":"system.adapter.weatherflow_udp.0","user":"system.user.admin","lc":1718811782305}: undefined
2024-06-20 21:02:32.742  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB called for linkeddevices.0.Devices.UG.Technik.Serverschrank.Stromzaehler.Leistung (type: 0, ID: 311) and state: {"val":213,"ack":true,"ts":1718910149453,"q":0,"from":"system.adapter.linkeddevices.0","user":"system.user.admin","lc":1718910144452}
2024-06-20 21:02:32.743  - [34mdebug[39m: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for linkeddevices.0.Devices.UG.Technik.Serverschrank.Stromzaehler.Leistung
2024-06-20 21:02:32.743  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB-prepareTaskCheckTypeAndDbId RESULT for linkeddevices.0.Devices.UG.Technik.Serverschrank.Stromzaehler.Leistung (type: 0, ID: 311) and state: {"val":213,"ack":true,"ts":1718910149453,"q":0,"from":"system.adapter.linkeddevices.0","user":"system.user.admin","lc":1718910144452}: undefined
2024-06-20 21:02:32.743  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB called for linkeddevices.0.Devices.UG.Technik.Serverschrank.Stromzaehler.Leistung (type: 0, ID: 311) and state: {"val":201,"ack":true,"ts":1718910152742,"q":0,"from":"system.adapter.linkeddevices.0","user":"system.user.admin","lc":1718910152742}
2024-06-20 21:02:32.743  - [34mdebug[39m: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for linkeddevices.0.Devices.UG.Technik.Serverschrank.Stromzaehler.Leistung
2024-06-20 21:02:32.743  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB-prepareTaskCheckTypeAndDbId RESULT for linkeddevices.0.Devices.UG.Technik.Serverschrank.Stromzaehler.Leistung (type: 0, ID: 311) and state: {"val":201,"ack":true,"ts":1718910152742,"q":0,"from":"system.adapter.linkeddevices.0","user":"system.user.admin","lc":1718910152742}: undefined
2024-06-20 21:02:32.833  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB called for alias.0.Devices.Heizung.Haus.UG.Heizungsraum.Warmwasser.Temperatur (type: 0, ID: 201) and state: {"val":47.3,"ack":true,"ts":1718910142831,"q":0,"from":"system.adapter.viessmann.0","user":"system.user.admin","lc":1718909862743}
2024-06-20 21:02:32.833  - [34mdebug[39m: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Devices.Heizung.Haus.UG.Heizungsraum.Warmwasser.Temperatur
2024-06-20 21:02:32.833  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB-prepareTaskCheckTypeAndDbId RESULT for alias.0.Devices.Heizung.Haus.UG.Heizungsraum.Warmwasser.Temperatur (type: 0, ID: 201) and state: {"val":47.3,"ack":true,"ts":1718910142831,"q":0,"from":"system.adapter.viessmann.0","user":"system.user.admin","lc":1718909862743}: undefined
2024-06-20 21:02:32.833  - [34mdebug[39m: sql.0 (3565) INSERT INTO `iobroker`.ts_number (id, ts, val, ack, _from, q) VALUES (201, 1718910142831, 47.3, 1, 22, 0);
2024-06-20 21:02:32.833  - [34mdebug[39m: sql.0 (3565) Borrow connection from pool: 4 now
2024-06-20 21:02:32.834  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB called for linkeddevices.0.Devices.UG.Heizungsraum.Heizung.Warmwasser.Temperatur_Verlust (type: 0, ID: 337) and state: {"val":-1.24,"ack":true,"ts":1718910152833,"q":0,"c":"script.js.LinkedDevices.Devices.UG.Heizungsraum.Heizung","from":"system.adapter.javascript.0","user":"system.user.admin","lc":1718910152833}
2024-06-20 21:02:32.834  - [34mdebug[39m: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for linkeddevices.0.Devices.UG.Heizungsraum.Heizung.Warmwasser.Temperatur_Verlust
2024-06-20 21:02:32.834  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB-prepareTaskCheckTypeAndDbId RESULT for linkeddevices.0.Devices.UG.Heizungsraum.Heizung.Warmwasser.Temperatur_Verlust (type: 0, ID: 337) and state: {"val":-1.24,"ack":true,"ts":1718910152833,"q":0,"c":"script.js.LinkedDevices.Devices.UG.Heizungsraum.Heizung","from":"system.adapter.javascript.0","user":"system.user.admin","lc":1718910152833}: undefined
2024-06-20 21:02:33.472  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB called for alias.0.Devices.Stromzaehler.Haus.Leistung (type: 0, ID: 31) and state: {"val":670,"ack":true,"ts":1718910152470,"q":0,"from":"system.adapter.mqtt.0","user":"system.user.admin","lc":1718910152470}
2024-06-20 21:02:33.472  - [34mdebug[39m: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Devices.Stromzaehler.Haus.Leistung
2024-06-20 21:02:33.472  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB-prepareTaskCheckTypeAndDbId RESULT for alias.0.Devices.Stromzaehler.Haus.Leistung (type: 0, ID: 31) and state: {"val":670,"ack":true,"ts":1718910152470,"q":0,"from":"system.adapter.mqtt.0","user":"system.user.admin","lc":1718910152470}: undefined
2024-06-20 21:02:33.475  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB called for alias.0.Sensoren.Strom.Haus.Autarkie (type: 0, ID: 50) and state: {"val":11,"ack":true,"ts":1718910152475,"q":0,"c":"script.js.alias.Sensoren.Strom.Berechnung","from":"system.adapter.javascript.0","user":"system.user.admin","lc":1718910152475}
2024-06-20 21:02:33.475  - [34mdebug[39m: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Sensoren.Strom.Haus.Autarkie
2024-06-20 21:02:33.475  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB-prepareTaskCheckTypeAndDbId RESULT for alias.0.Sensoren.Strom.Haus.Autarkie (type: 0, ID: 50) and state: {"val":11,"ack":true,"ts":1718910152475,"q":0,"c":"script.js.alias.Sensoren.Strom.Berechnung","from":"system.adapter.javascript.0","user":"system.user.admin","lc":1718910152475}: undefined
2024-06-20 21:02:33.483  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB called for alias.0.Sensoren.Strom.Haus.Leistung_Haus_only (type: 0, ID: 49) and state: {"val":475.64,"ack":true,"ts":1718910152477,"q":0,"c":"script.js.alias.Sensoren.Strom.Berechnung","from":"system.adapter.javascript.0","user":"system.user.admin","lc":1718910152477}
2024-06-20 21:02:33.483  - [34mdebug[39m: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Sensoren.Strom.Haus.Leistung_Haus_only
2024-06-20 21:02:33.483  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB-prepareTaskCheckTypeAndDbId RESULT for alias.0.Sensoren.Strom.Haus.Leistung_Haus_only (type: 0, ID: 49) and state: {"val":475.64,"ack":true,"ts":1718910152477,"q":0,"c":"script.js.alias.Sensoren.Strom.Berechnung","from":"system.adapter.javascript.0","user":"system.user.admin","lc":1718910152477}: undefined
2024-06-20 21:02:33.833  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB called for alias.0.Devices.Heizung.Haus.UG.Heizungsraum.Warmwasser.Temperatur (type: 0, ID: 201) and state: {"val":47.2,"ack":true,"ts":1718910152832,"q":0,"from":"system.adapter.viessmann.0","user":"system.user.admin","lc":1718910152832}
2024-06-20 21:02:33.833  - [34mdebug[39m: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Devices.Heizung.Haus.UG.Heizungsraum.Warmwasser.Temperatur
2024-06-20 21:02:33.833  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB-prepareTaskCheckTypeAndDbId RESULT for alias.0.Devices.Heizung.Haus.UG.Heizungsraum.Warmwasser.Temperatur (type: 0, ID: 201) and state: {"val":47.2,"ack":true,"ts":1718910152832,"q":0,"from":"system.adapter.viessmann.0","user":"system.user.admin","lc":1718910152832}: undefined
2024-06-20 21:02:33.833  - [34mdebug[39m: sql.0 (3565) INSERT INTO `iobroker`.ts_number (id, ts, val, ack, _from, q) VALUES (201, 1718910152832, 47.2, 1, 22, 0);
2024-06-20 21:02:33.833  - [34mdebug[39m: sql.0 (3565) Borrow connection from pool: 5 now
2024-06-20 21:02:34.554  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB called for alias.0.Sensoren.Temperatur.Gast.EG.Wohnen.aktuell (type: 0, ID: 604) and state: {"val":24.2,"ack":true,"ts":1718910153553,"q":0,"from":"system.adapter.mqtt.0","user":"system.user.admin","lc":1718910153553}
2024-06-20 21:02:34.554  - [34mdebug[39m: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Sensoren.Temperatur.Gast.EG.Wohnen.aktuell
2024-06-20 21:02:34.554  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB-prepareTaskCheckTypeAndDbId RESULT for alias.0.Sensoren.Temperatur.Gast.EG.Wohnen.aktuell (type: 0, ID: 604) and state: {"val":24.2,"ack":true,"ts":1718910153553,"q":0,"from":"system.adapter.mqtt.0","user":"system.user.admin","lc":1718910153553}: undefined
2024-06-20 21:02:35.477  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB called for alias.0.Devices.Stromzaehler.Haus.Leistung (type: 0, ID: 31) and state: {"val":699,"ack":true,"ts":1718910154475,"q":0,"from":"system.adapter.mqtt.0","user":"system.user.admin","lc":1718910154475}
2024-06-20 21:02:35.477  - [34mdebug[39m: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Devices.Stromzaehler.Haus.Leistung
2024-06-20 21:02:35.477  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB-prepareTaskCheckTypeAndDbId RESULT for alias.0.Devices.Stromzaehler.Haus.Leistung (type: 0, ID: 31) and state: {"val":699,"ack":true,"ts":1718910154475,"q":0,"from":"system.adapter.mqtt.0","user":"system.user.admin","lc":1718910154475}: undefined
2024-06-20 21:02:35.480  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB called for alias.0.Sensoren.Strom.Haus.Leistung_Haus_only (type: 0, ID: 49) and state: {"val":515.64,"ack":true,"ts":1718910154479,"q":0,"c":"script.js.alias.Sensoren.Strom.Berechnung","from":"system.adapter.javascript.0","user":"system.user.admin","lc":1718910154479}
2024-06-20 21:02:35.480  - [34mdebug[39m: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Sensoren.Strom.Haus.Leistung_Haus_only
2024-06-20 21:02:35.480  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB-prepareTaskCheckTypeAndDbId RESULT for alias.0.Sensoren.Strom.Haus.Leistung_Haus_only (type: 0, ID: 49) and state: {"val":515.64,"ack":true,"ts":1718910154479,"q":0,"c":"script.js.alias.Sensoren.Strom.Berechnung","from":"system.adapter.javascript.0","user":"system.user.admin","lc":1718910154479}: undefined
2024-06-20 21:02:35.480  - [34mdebug[39m: sql.0 (3565) INSERT INTO `iobroker`.ts_number (id, ts, val, ack, _from, q) VALUES (49, 1718910131479, 460.64, 1, 3, 0),(49, 1718910132477, 426.64, 1, 3, 0),(49, 1718910137474, 421.64, 1, 3, 0),(49, 1718910139486, 402.64, 1, 3, 0),(49, 1718910141475, 463.64, 1, 3, 0),(49, 1718910146475, 478.64, 1, 3, 0),(49, 1718910147478, 489.64, 1, 3, 0),(49, 1718910150479, 489.64, 1, 3, 0),(49, 1718910151475, 463.64, 1, 3, 0),(49, 1718910152477, 475.64, 1, 3, 0),(49, 1718910154479, 515.64, 1, 3, 0);
2024-06-20 21:02:35.480  - [34mdebug[39m: sql.0 (3565) Borrow connection from pool: 6 now
2024-06-20 21:02:37.160  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB called for linkeddevices.0.Devices.UG.Heizungsraum.Heizstab.Stromzaehler.Leistung (type: 0, ID: 454) and state: {"val":2,"ack":true,"ts":1718910156160,"q":0,"from":"system.adapter.linkeddevices.0","user":"system.user.admin","lc":1718910156160}
2024-06-20 21:02:37.160  - [34mdebug[39m: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for linkeddevices.0.Devices.UG.Heizungsraum.Heizstab.Stromzaehler.Leistung
2024-06-20 21:02:37.160  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB-prepareTaskCheckTypeAndDbId RESULT for linkeddevices.0.Devices.UG.Heizungsraum.Heizstab.Stromzaehler.Leistung (type: 0, ID: 454) and state: {"val":2,"ack":true,"ts":1718910156160,"q":0,"from":"system.adapter.linkeddevices.0","user":"system.user.admin","lc":1718910156160}: undefined
2024-06-20 21:02:37.161  - [34mdebug[39m: sql.0 (3565) INSERT INTO `iobroker`.ts_number (id, ts, val, ack, _from, q) VALUES (454, 1718910156160, 2, 1, 2, 0);
2024-06-20 21:02:37.161  - [34mdebug[39m: sql.0 (3565) Borrow connection from pool: 7 now
2024-06-20 21:02:37.471  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB called for alias.0.Devices.Stromzaehler.Haus.Leistung (type: 0, ID: 31) and state: {"val":680,"ack":true,"ts":1718910156470,"q":0,"from":"system.adapter.mqtt.0","user":"system.user.admin","lc":1718910156470}
2024-06-20 21:02:37.471  - [34mdebug[39m: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Devices.Stromzaehler.Haus.Leistung
2024-06-20 21:02:37.471  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB-prepareTaskCheckTypeAndDbId RESULT for alias.0.Devices.Stromzaehler.Haus.Leistung (type: 0, ID: 31) and state: {"val":680,"ack":true,"ts":1718910156470,"q":0,"from":"system.adapter.mqtt.0","user":"system.user.admin","lc":1718910156470}: undefined
2024-06-20 21:02:37.475  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB called for alias.0.Sensoren.Strom.Haus.Leistung_Haus_only (type: 0, ID: 49) and state: {"val":494.64,"ack":true,"ts":1718910156474,"q":0,"c":"script.js.alias.Sensoren.Strom.Berechnung","from":"system.adapter.javascript.0","user":"system.user.admin","lc":1718910156474}
2024-06-20 21:02:37.475  - [34mdebug[39m: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Sensoren.Strom.Haus.Leistung_Haus_only
2024-06-20 21:02:37.475  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB-prepareTaskCheckTypeAndDbId RESULT for alias.0.Sensoren.Strom.Haus.Leistung_Haus_only (type: 0, ID: 49) and state: {"val":494.64,"ack":true,"ts":1718910156474,"q":0,"c":"script.js.alias.Sensoren.Strom.Berechnung","from":"system.adapter.javascript.0","user":"system.user.admin","lc":1718910156474}: undefined
2024-06-20 21:02:38.471  - [34mdebug[39m: sql.0 (3565) Return connection to pool: 6 now
2024-06-20 21:02:38.472  - [31merror[39m: sql.0 (3565) Error: connect ETIMEDOUT
2024-06-20 21:02:38.474  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB called for alias.0.Sensoren.Strom.Haus.Autarkie (type: 0, ID: 50) and state: {"val":11,"ack":true,"ts":1718910157477,"q":0,"c":"script.js.alias.Sensoren.Strom.Berechnung","from":"system.adapter.javascript.0","user":"system.user.admin","lc":1718910152475}
2024-06-20 21:02:38.474  - [34mdebug[39m: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Sensoren.Strom.Haus.Autarkie
2024-06-20 21:02:38.474  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB-prepareTaskCheckTypeAndDbId RESULT for alias.0.Sensoren.Strom.Haus.Autarkie (type: 0, ID: 50) and state: {"val":11,"ack":true,"ts":1718910157477,"q":0,"c":"script.js.alias.Sensoren.Strom.Berechnung","from":"system.adapter.javascript.0","user":"system.user.admin","lc":1718910152475}: undefined
2024-06-20 21:02:38.475  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB called for alias.0.Sensoren.Strom.Haus.Leistung_Haus_only (type: 0, ID: 49) and state: {"val":478.64,"ack":true,"ts":1718910157478,"q":0,"c":"script.js.alias.Sensoren.Strom.Berechnung","from":"system.adapter.javascript.0","user":"system.user.admin","lc":1718910157478}
2024-06-20 21:02:38.475  - [34mdebug[39m: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Sensoren.Strom.Haus.Leistung_Haus_only
2024-06-20 21:02:38.475  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB-prepareTaskCheckTypeAndDbId RESULT for alias.0.Sensoren.Strom.Haus.Leistung_Haus_only (type: 0, ID: 49) and state: {"val":478.64,"ack":true,"ts":1718910157478,"q":0,"c":"script.js.alias.Sensoren.Strom.Berechnung","from":"system.adapter.javascript.0","user":"system.user.admin","lc":1718910157478}: undefined
2024-06-20 21:02:38.819  - [34mdebug[39m: sql.0 (3565) SELECT
2024-06-20 21:02:38.819  - [34mdebug[39m: sql.0 (3565) Borrow connection from pool: 7 now
2024-06-20 21:02:38.918  - [34mdebug[39m: sql.0 (3565) SELECT
2024-06-20 21:02:38.918  - [34mdebug[39m: sql.0 (3565) Borrow connection from pool: 8 now
2024-06-20 21:02:39.018  - [34mdebug[39m: sql.0 (3565) SELECT
2024-06-20 21:02:39.018  - [34mdebug[39m: sql.0 (3565) Borrow connection from pool: 9 now
2024-06-20 21:02:39.118  - [34mdebug[39m: sql.0 (3565) SELECT
2024-06-20 21:02:39.118  - [34mdebug[39m: sql.0 (3565) Borrow connection from pool: 10 now
2024-06-20 21:02:39.215  - [34mdebug[39m: sql.0 (3565) SELECT
2024-06-20 21:02:39.215  - [34mdebug[39m: sql.0 (3565) Borrow connection from pool: 11 now
2024-06-20 21:02:39.315  - [34mdebug[39m: sql.0 (3565) SELECT
2024-06-20 21:02:39.315  - [34mdebug[39m: sql.0 (3565) Borrow connection from pool: 12 now
2024-06-20 21:02:39.414  - [34mdebug[39m: sql.0 (3565) SELECT
2024-06-20 21:02:39.414  - [34mdebug[39m: sql.0 (3565) Borrow connection from pool: 13 now
2024-06-20 21:02:39.470  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB called for alias.0.Devices.Stromzaehler.Haus.Leistung (type: 0, ID: 31) and state: {"val":657,"ack":true,"ts":1718910158469,"q":0,"from":"system.adapter.mqtt.0","user":"system.user.admin","lc":1718910158469}
2024-06-20 21:02:39.470  - [34mdebug[39m: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Devices.Stromzaehler.Haus.Leistung
2024-06-20 21:02:39.470  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB-prepareTaskCheckTypeAndDbId RESULT for alias.0.Devices.Stromzaehler.Haus.Leistung (type: 0, ID: 31) and state: {"val":657,"ack":true,"ts":1718910158469,"q":0,"from":"system.adapter.mqtt.0","user":"system.user.admin","lc":1718910158469}: undefined
2024-06-20 21:02:39.474  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB called for alias.0.Sensoren.Strom.Haus.Autarkie (type: 0, ID: 50) and state: {"val":12,"ack":true,"ts":1718910158474,"q":0,"c":"script.js.alias.Sensoren.Strom.Berechnung","from":"system.adapter.javascript.0","user":"system.user.admin","lc":1718910158474}
2024-06-20 21:02:39.474  - [34mdebug[39m: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Sensoren.Strom.Haus.Autarkie
2024-06-20 21:02:39.474  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB-prepareTaskCheckTypeAndDbId RESULT for alias.0.Sensoren.Strom.Haus.Autarkie (type: 0, ID: 50) and state: {"val":12,"ack":true,"ts":1718910158474,"q":0,"c":"script.js.alias.Sensoren.Strom.Berechnung","from":"system.adapter.javascript.0","user":"system.user.admin","lc":1718910158474}: undefined
2024-06-20 21:02:39.475  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB called for alias.0.Sensoren.Strom.Haus.Leistung_Haus_only (type: 0, ID: 49) and state: {"val":471.64,"ack":true,"ts":1718910158474,"q":0,"c":"script.js.alias.Sensoren.Strom.Berechnung","from":"system.adapter.javascript.0","user":"system.user.admin","lc":1718910158474}
2024-06-20 21:02:39.475  - [34mdebug[39m: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Sensoren.Strom.Haus.Leistung_Haus_only
2024-06-20 21:02:39.475  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB-prepareTaskCheckTypeAndDbId RESULT for alias.0.Sensoren.Strom.Haus.Leistung_Haus_only (type: 0, ID: 49) and state: {"val":471.64,"ack":true,"ts":1718910158474,"q":0,"c":"script.js.alias.Sensoren.Strom.Berechnung","from":"system.adapter.javascript.0","user":"system.user.admin","lc":1718910158474}: undefined
2024-06-20 21:02:39.515  - [34mdebug[39m: sql.0 (3565) SELECT
2024-06-20 21:02:39.515  - [34mdebug[39m: sql.0 (3565) Borrow connection from pool: 14 now
2024-06-20 21:02:39.612  - [34mdebug[39m: sql.0 (3565) SELECT
2024-06-20 21:02:39.612  - [34mdebug[39m: sql.0 (3565) Borrow connection from pool: 15 now
2024-06-20 21:02:39.711  - [34mdebug[39m: sql.0 (3565) SELECT
2024-06-20 21:02:39.711  - [34mdebug[39m: sql.0 (3565) Borrow connection from pool: 16 now
2024-06-20 21:02:39.811  - [34mdebug[39m: sql.0 (3565) SELECT
2024-06-20 21:02:39.811  - [34mdebug[39m: sql.0 (3565) Borrow connection from pool: 17 now
2024-06-20 21:02:39.912  - [34mdebug[39m: sql.0 (3565) SELECT
2024-06-20 21:02:39.912  - [34mdebug[39m: sql.0 (3565) Borrow connection from pool: 18 now
2024-06-20 21:02:40.008  - [34mdebug[39m: sql.0 (3565) SELECT
2024-06-20 21:02:40.008  - [34mdebug[39m: sql.0 (3565) Borrow connection from pool: 19 now
2024-06-20 21:02:40.108  - [34mdebug[39m: sql.0 (3565) SELECT
2024-06-20 21:02:40.108  - [34mdebug[39m: sql.0 (3565) Borrow connection from pool: 20 now
2024-06-20 21:02:40.208  - [34mdebug[39m: sql.0 (3565) SELECT
2024-06-20 21:02:40.208  - [34mdebug[39m: sql.0 (3565) Borrow connection from pool: 21 now
2024-06-20 21:02:40.309  - [34mdebug[39m: sql.0 (3565) SELECT
2024-06-20 21:02:40.309  - [34mdebug[39m: sql.0 (3565) Borrow connection from pool: 22 now
2024-06-20 21:02:40.404  - [34mdebug[39m: sql.0 (3565) SELECT
2024-06-20 21:02:40.404  - [34mdebug[39m: sql.0 (3565) Borrow connection from pool: 23 now
2024-06-20 21:02:40.471  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB called for alias.0.Devices.Stromzaehler.Haus.Leistung (type: 0, ID: 31) and state: {"val":686,"ack":true,"ts":1718910159470,"q":0,"from":"system.adapter.mqtt.0","user":"system.user.admin","lc":1718910159470}
2024-06-20 21:02:40.471  - [34mdebug[39m: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Devices.Stromzaehler.Haus.Leistung
2024-06-20 21:02:40.471  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB-prepareTaskCheckTypeAndDbId RESULT for alias.0.Devices.Stromzaehler.Haus.Leistung (type: 0, ID: 31) and state: {"val":686,"ack":true,"ts":1718910159470,"q":0,"from":"system.adapter.mqtt.0","user":"system.user.admin","lc":1718910159470}: undefined
2024-06-20 21:02:40.475  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB called for alias.0.Sensoren.Strom.Haus.Autarkie (type: 0, ID: 50) and state: {"val":11,"ack":true,"ts":1718910159474,"q":0,"c":"script.js.alias.Sensoren.Strom.Berechnung","from":"system.adapter.javascript.0","user":"system.user.admin","lc":1718910159474}
2024-06-20 21:02:40.476  - [34mdebug[39m: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Sensoren.Strom.Haus.Autarkie
2024-06-20 21:02:40.476  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB-prepareTaskCheckTypeAndDbId RESULT for alias.0.Sensoren.Strom.Haus.Autarkie (type: 0, ID: 50) and state: {"val":11,"ack":true,"ts":1718910159474,"q":0,"c":"script.js.alias.Sensoren.Strom.Berechnung","from":"system.adapter.javascript.0","user":"system.user.admin","lc":1718910159474}: undefined
2024-06-20 21:02:40.505  - [34mdebug[39m: sql.0 (3565) SELECT
2024-06-20 21:02:40.505  - [34mdebug[39m: sql.0 (3565) Borrow connection from pool: 24 now
2024-06-20 21:02:40.605  - [34mdebug[39m: sql.0 (3565) SELECT
2024-06-20 21:02:40.605  - [34mdebug[39m: sql.0 (3565) Borrow connection from pool: 25 now
2024-06-20 21:02:40.704  - [34mdebug[39m: sql.0 (3565) SELECT
2024-06-20 21:02:40.704  - [34mdebug[39m: sql.0 (3565) Borrow connection from pool: 26 now
2024-06-20 21:02:40.803  - [34mdebug[39m: sql.0 (3565) SELECT
2024-06-20 21:02:40.803  - [34mdebug[39m: sql.0 (3565) Borrow connection from pool: 27 now
2024-06-20 21:02:40.902  - [34mdebug[39m: sql.0 (3565) SELECT
2024-06-20 21:02:40.902  - [34mdebug[39m: sql.0 (3565) Borrow connection from pool: 28 now
2024-06-20 21:02:41.003  - [34mdebug[39m: sql.0 (3565) SELECT
2024-06-20 21:02:41.003  - [34mdebug[39m: sql.0 (3565) Borrow connection from pool: 29 now
2024-06-20 21:02:41.102  - [34mdebug[39m: sql.0 (3565) SELECT
2024-06-20 21:02:41.103  - [34mdebug[39m: sql.0 (3565) Borrow connection from pool: 30 now
2024-06-20 21:02:41.478  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB called for alias.0.Devices.Stromzaehler.Haus.Leistung (type: 0, ID: 31) and state: {"val":681,"ack":true,"ts":1718910160477,"q":0,"from":"system.adapter.mqtt.0","user":"system.user.admin","lc":1718910160477}
2024-06-20 21:02:41.478  - [34mdebug[39m: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Devices.Stromzaehler.Haus.Leistung
2024-06-20 21:02:41.478  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB-prepareTaskCheckTypeAndDbId RESULT for alias.0.Devices.Stromzaehler.Haus.Leistung (type: 0, ID: 31) and state: {"val":681,"ack":true,"ts":1718910160477,"q":0,"from":"system.adapter.mqtt.0","user":"system.user.admin","lc":1718910160477}: undefined
2024-06-20 21:02:41.483  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB called for alias.0.Sensoren.Strom.Haus.Leistung_Haus_only (type: 0, ID: 49) and state: {"val":496.64,"ack":true,"ts":1718910160482,"q":0,"c":"script.js.alias.Sensoren.Strom.Berechnung","from":"system.adapter.javascript.0","user":"system.user.admin","lc":1718910160482}
2024-06-20 21:02:41.484  - [34mdebug[39m: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Sensoren.Strom.Haus.Leistung_Haus_only
2024-06-20 21:02:41.484  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB-prepareTaskCheckTypeAndDbId RESULT for alias.0.Sensoren.Strom.Haus.Leistung_Haus_only (type: 0, ID: 49) and state: {"val":496.64,"ack":true,"ts":1718910160482,"q":0,"c":"script.js.alias.Sensoren.Strom.Berechnung","from":"system.adapter.javascript.0","user":"system.user.admin","lc":1718910160482}: undefined
2024-06-20 21:02:41.632  - [34mdebug[39m: sql.0 (3565) Return connection to pool: 29 now
2024-06-20 21:02:41.632  - [31merror[39m: sql.0 (3565) Error: connect ETIMEDOUT
2024-06-20 21:02:42.170  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB called for linkeddevices.0.Devices.UG.Heizungsraum.Heizstab.Stromzaehler.Leistung (type: 0, ID: 454) and state: {"val":0,"ack":true,"ts":1718910161169,"q":0,"from":"system.adapter.linkeddevices.0","user":"system.user.admin","lc":1718910161169}
2024-06-20 21:02:42.171  - [34mdebug[39m: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for linkeddevices.0.Devices.UG.Heizungsraum.Heizstab.Stromzaehler.Leistung
2024-06-20 21:02:42.171  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB-prepareTaskCheckTypeAndDbId RESULT for linkeddevices.0.Devices.UG.Heizungsraum.Heizstab.Stromzaehler.Leistung (type: 0, ID: 454) and state: {"val":0,"ack":true,"ts":1718910161169,"q":0,"from":"system.adapter.linkeddevices.0","user":"system.user.admin","lc":1718910161169}: undefined
2024-06-20 21:02:42.171  - [34mdebug[39m: sql.0 (3565) INSERT INTO `iobroker`.ts_number (id, ts, val, ack, _from, q) VALUES (454, 1718910161169, 0, 1, 2, 0);
2024-06-20 21:02:42.171  - [34mdebug[39m: sql.0 (3565) Borrow connection from pool: 30 now
2024-06-20 21:02:42.633  - [34mdebug[39m: sql.0 (3565) Return connection to pool: 29 now
2024-06-20 21:02:42.633  - [31merror[39m: sql.0 (3565) Error: connect ETIMEDOUT
2024-06-20 21:02:42.833  - [34mdebug[39m: sql.0 (3565) Return connection to pool: 28 now
2024-06-20 21:02:42.833  - [31merror[39m: sql.0 (3565) Error: connect ETIMEDOUT
2024-06-20 21:02:43.833  - [34mdebug[39m: sql.0 (3565) Return connection to pool: 27 now
2024-06-20 21:02:43.833  - [31merror[39m: sql.0 (3565) Error: connect ETIMEDOUT
2024-06-20 21:02:43.839  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB called for alias.0.Devices.Heizung.Haus.UG.Heizungsraum.Warmwasser.Temperatur (type: 0, ID: 201) and state: {"val":47.3,"ack":true,"ts":1718910162837,"q":0,"from":"system.adapter.viessmann.0","user":"system.user.admin","lc":1718910162837}
2024-06-20 21:02:43.839  - [34mdebug[39m: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Devices.Heizung.Haus.UG.Heizungsraum.Warmwasser.Temperatur
2024-06-20 21:02:43.839  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB-prepareTaskCheckTypeAndDbId RESULT for alias.0.Devices.Heizung.Haus.UG.Heizungsraum.Warmwasser.Temperatur (type: 0, ID: 201) and state: {"val":47.3,"ack":true,"ts":1718910162837,"q":0,"from":"system.adapter.viessmann.0","user":"system.user.admin","lc":1718910162837}: undefined
2024-06-20 21:02:43.839  - [34mdebug[39m: sql.0 (3565) INSERT INTO `iobroker`.ts_number (id, ts, val, ack, _from, q) VALUES (201, 1718910162837, 47.3, 1, 22, 0);
2024-06-20 21:02:43.839  - [34mdebug[39m: sql.0 (3565) Borrow connection from pool: 28 now
2024-06-20 21:02:44.471  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB called for alias.0.Devices.Stromzaehler.Haus.Leistung (type: 0, ID: 31) and state: {"val":683,"ack":true,"ts":1718910163470,"q":0,"from":"system.adapter.mqtt.0","user":"system.user.admin","lc":1718910163470}
2024-06-20 21:02:44.472  - [34mdebug[39m: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Devices.Stromzaehler.Haus.Leistung
2024-06-20 21:02:44.472  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB-prepareTaskCheckTypeAndDbId RESULT for alias.0.Devices.Stromzaehler.Haus.Leistung (type: 0, ID: 31) and state: {"val":683,"ack":true,"ts":1718910163470,"q":0,"from":"system.adapter.mqtt.0","user":"system.user.admin","lc":1718910163470}: undefined
2024-06-20 21:02:45.472  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB called for alias.0.Devices.Stromzaehler.Haus.Leistung (type: 0, ID: 31) and state: {"val":687,"ack":true,"ts":1718910164471,"q":0,"from":"system.adapter.mqtt.0","user":"system.user.admin","lc":1718910164471}
2024-06-20 21:02:45.472  - [34mdebug[39m: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Devices.Stromzaehler.Haus.Leistung
2024-06-20 21:02:45.472  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB-prepareTaskCheckTypeAndDbId RESULT for alias.0.Devices.Stromzaehler.Haus.Leistung (type: 0, ID: 31) and state: {"val":687,"ack":true,"ts":1718910164471,"q":0,"from":"system.adapter.mqtt.0","user":"system.user.admin","lc":1718910164471}: undefined
2024-06-20 21:02:45.479  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB called for alias.0.Sensoren.Strom.Haus.Autarkie (type: 0, ID: 50) and state: {"val":11,"ack":true,"ts":1718910164833,"q":0,"c":"script.js.alias.Sensoren.Strom.Berechnung","from":"system.adapter.javascript.0","user":"system.user.admin","lc":1718910159474}
2024-06-20 21:02:45.479  - [34mdebug[39m: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Sensoren.Strom.Haus.Autarkie
2024-06-20 21:02:45.479  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB-prepareTaskCheckTypeAndDbId RESULT for alias.0.Sensoren.Strom.Haus.Autarkie (type: 0, ID: 50) and state: {"val":11,"ack":true,"ts":1718910164833,"q":0,"c":"script.js.alias.Sensoren.Strom.Berechnung","from":"system.adapter.javascript.0","user":"system.user.admin","lc":1718910159474}: undefined
2024-06-20 21:02:45.480  - [34mdebug[39m: sql.0 (3565) Return connection to pool: 27 now
2024-06-20 21:02:45.480  - [31merror[39m: sql.0 (3565) Error: connect ETIMEDOUT
2024-06-20 21:02:45.480  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB called for alias.0.Sensoren.Strom.Haus.Leistung_Haus_only (type: 0, ID: 49) and state: {"val":503.64,"ack":true,"ts":1718910164834,"q":0,"c":"script.js.alias.Sensoren.Strom.Berechnung","from":"system.adapter.javascript.0","user":"system.user.admin","lc":1718910164834}
2024-06-20 21:02:45.480  - [34mdebug[39m: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Sensoren.Strom.Haus.Leistung_Haus_only
2024-06-20 21:02:45.480  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB-prepareTaskCheckTypeAndDbId RESULT for alias.0.Sensoren.Strom.Haus.Leistung_Haus_only (type: 0, ID: 49) and state: {"val":503.64,"ack":true,"ts":1718910164834,"q":0,"c":"script.js.alias.Sensoren.Strom.Berechnung","from":"system.adapter.javascript.0","user":"system.user.admin","lc":1718910164834}: undefined
2024-06-20 21:02:47.161  - [34mdebug[39m: sql.0 (3565) Return connection to pool: 26 now
2024-06-20 21:02:47.161  - [31merror[39m: sql.0 (3565) Error: connect ETIMEDOUT
2024-06-20 21:02:47.178  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB called for linkeddevices.0.Devices.UG.Heizungsraum.Heizstab.Stromzaehler.Leistung (type: 0, ID: 454) and state: {"val":2,"ack":true,"ts":1718910166177,"q":0,"from":"system.adapter.linkeddevices.0","user":"system.user.admin","lc":1718910166177}
2024-06-20 21:02:47.178  - [34mdebug[39m: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for linkeddevices.0.Devices.UG.Heizungsraum.Heizstab.Stromzaehler.Leistung
2024-06-20 21:02:47.178  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB-prepareTaskCheckTypeAndDbId RESULT for linkeddevices.0.Devices.UG.Heizungsraum.Heizstab.Stromzaehler.Leistung (type: 0, ID: 454) and state: {"val":2,"ack":true,"ts":1718910166177,"q":0,"from":"system.adapter.linkeddevices.0","user":"system.user.admin","lc":1718910166177}: undefined
2024-06-20 21:02:47.178  - [34mdebug[39m: sql.0 (3565) INSERT INTO `iobroker`.ts_number (id, ts, val, ack, _from, q) VALUES (454, 1718910166177, 2, 1, 2, 0);
2024-06-20 21:02:47.178  - [34mdebug[39m: sql.0 (3565) Borrow connection from pool: 27 now
2024-06-20 21:02:47.469  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB called for alias.0.Devices.Stromzaehler.Haus.Leistung (type: 0, ID: 31) and state: {"val":660,"ack":true,"ts":1718910166469,"q":0,"from":"system.adapter.mqtt.0","user":"system.user.admin","lc":1718910166469}
2024-06-20 21:02:47.469  - [34mdebug[39m: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Devices.Stromzaehler.Haus.Leistung
2024-06-20 21:02:47.469  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB-prepareTaskCheckTypeAndDbId RESULT for alias.0.Devices.Stromzaehler.Haus.Leistung (type: 0, ID: 31) and state: {"val":660,"ack":true,"ts":1718910166469,"q":0,"from":"system.adapter.mqtt.0","user":"system.user.admin","lc":1718910166469}: undefined
2024-06-20 21:02:47.473  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB called for alias.0.Sensoren.Strom.Haus.Autarkie (type: 0, ID: 50) and state: {"val":11,"ack":true,"ts":1718910166472,"q":0,"c":"script.js.alias.Sensoren.Strom.Berechnung","from":"system.adapter.javascript.0","user":"system.user.admin","lc":1718910166472}
2024-06-20 21:02:47.473  - [34mdebug[39m: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Sensoren.Strom.Haus.Autarkie
2024-06-20 21:02:47.473  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB-prepareTaskCheckTypeAndDbId RESULT for alias.0.Sensoren.Strom.Haus.Autarkie (type: 0, ID: 50) and state: {"val":11,"ack":true,"ts":1718910166472,"q":0,"c":"script.js.alias.Sensoren.Strom.Berechnung","from":"system.adapter.javascript.0","user":"system.user.admin","lc":1718910166472}: undefined
2024-06-20 21:02:47.473  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB called for alias.0.Sensoren.Strom.Haus.Leistung_Haus_only (type: 0, ID: 49) and state: {"val":474.64,"ack":true,"ts":1718910166473,"q":0,"c":"script.js.alias.Sensoren.Strom.Berechnung","from":"system.adapter.javascript.0","user":"system.user.admin","lc":1718910166473}
2024-06-20 21:02:47.473  - [34mdebug[39m: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Sensoren.Strom.Haus.Leistung_Haus_only
2024-06-20 21:02:47.473  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB-prepareTaskCheckTypeAndDbId RESULT for alias.0.Sensoren.Strom.Haus.Leistung_Haus_only (type: 0, ID: 49) and state: {"val":474.64,"ack":true,"ts":1718910166473,"q":0,"c":"script.js.alias.Sensoren.Strom.Berechnung","from":"system.adapter.javascript.0","user":"system.user.admin","lc":1718910166473}: undefined
2024-06-20 21:02:48.819  - [34mdebug[39m: sql.0 (3565) Return connection to pool: 26 now
2024-06-20 21:02:48.918  - [34mdebug[39m: sql.0 (3565) Return connection to pool: 25 now
2024-06-20 21:02:49.018  - [34mdebug[39m: sql.0 (3565) Return connection to pool: 24 now
2024-06-20 21:02:49.119  - [34mdebug[39m: sql.0 (3565) Return connection to pool: 23 now
2024-06-20 21:02:49.215  - [34mdebug[39m: sql.0 (3565) Return connection to pool: 22 now
2024-06-20 21:02:49.315  - [34mdebug[39m: sql.0 (3565) Return connection to pool: 21 now
2024-06-20 21:02:49.415  - [34mdebug[39m: sql.0 (3565) Return connection to pool: 20 now
2024-06-20 21:02:49.478  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB called for alias.0.Devices.Stromzaehler.Haus.Leistung (type: 0, ID: 31) and state: {"val":662,"ack":true,"ts":1718910168477,"q":0,"from":"system.adapter.mqtt.0","user":"system.user.admin","lc":1718910168477}
2024-06-20 21:02:49.478  - [34mdebug[39m: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Devices.Stromzaehler.Haus.Leistung
2024-06-20 21:02:49.478  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB-prepareTaskCheckTypeAndDbId RESULT for alias.0.Devices.Stromzaehler.Haus.Leistung (type: 0, ID: 31) and state: {"val":662,"ack":true,"ts":1718910168477,"q":0,"from":"system.adapter.mqtt.0","user":"system.user.admin","lc":1718910168477}: undefined
2024-06-20 21:02:49.478  - [34mdebug[39m: sql.0 (3565) INSERT INTO `iobroker`.ts_number (id, ts, val, ack, _from, q) VALUES (31, 1718910151471, 658, 1, 8, 0),(31, 1718910152470, 670, 1, 8, 0),(31, 1718910154475, 699, 1, 8, 0),(31, 1718910156470, 680, 1, 8, 0),(31, 1718910158469, 657, 1, 8, 0),(31, 1718910159470, 686, 1, 8, 0),(31, 1718910160477, 681, 1, 8, 0),(31, 1718910163470, 683, 1, 8, 0),(31, 1718910164471, 687, 1, 8, 0),(31, 1718910166469, 660, 1, 8, 0),(31, 1718910168477, 662, 1, 8, 0);
2024-06-20 21:02:49.478  - [34mdebug[39m: sql.0 (3565) Borrow connection from pool: 21 now
2024-06-20 21:02:49.483  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB called for alias.0.Sensoren.Strom.Haus.Leistung_Haus_only (type: 0, ID: 49) and state: {"val":476.64,"ack":true,"ts":1718910168483,"q":0,"c":"script.js.alias.Sensoren.Strom.Berechnung","from":"system.adapter.javascript.0","user":"system.user.admin","lc":1718910168483}
2024-06-20 21:02:49.484  - [34mdebug[39m: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Sensoren.Strom.Haus.Leistung_Haus_only
2024-06-20 21:02:49.484  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB-prepareTaskCheckTypeAndDbId RESULT for alias.0.Sensoren.Strom.Haus.Leistung_Haus_only (type: 0, ID: 49) and state: {"val":476.64,"ack":true,"ts":1718910168483,"q":0,"c":"script.js.alias.Sensoren.Strom.Berechnung","from":"system.adapter.javascript.0","user":"system.user.admin","lc":1718910168483}: undefined
2024-06-20 21:02:49.515  - [34mdebug[39m: sql.0 (3565) Return connection to pool: 20 now
2024-06-20 21:02:49.612  - [34mdebug[39m: sql.0 (3565) Return connection to pool: 19 now
2024-06-20 21:02:49.711  - [34mdebug[39m: sql.0 (3565) Return connection to pool: 18 now
2024-06-20 21:02:49.811  - [34mdebug[39m: sql.0 (3565) Return connection to pool: 17 now
2024-06-20 21:02:49.912  - [34mdebug[39m: sql.0 (3565) Return connection to pool: 16 now
2024-06-20 21:02:50.008  - [34mdebug[39m: sql.0 (3565) Return connection to pool: 15 now
2024-06-20 21:02:50.109  - [34mdebug[39m: sql.0 (3565) Return connection to pool: 14 now
2024-06-20 21:02:50.209  - [34mdebug[39m: sql.0 (3565) Return connection to pool: 13 now
2024-06-20 21:02:50.309  - [34mdebug[39m: sql.0 (3565) Return connection to pool: 12 now
2024-06-20 21:02:50.405  - [34mdebug[39m: sql.0 (3565) Return connection to pool: 11 now
2024-06-20 21:02:50.505  - [34mdebug[39m: sql.0 (3565) Return connection to pool: 10 now
2024-06-20 21:02:50.605  - [34mdebug[39m: sql.0 (3565) Return connection to pool: 9 now
2024-06-20 21:02:50.705  - [34mdebug[39m: sql.0 (3565) Return connection to pool: 8 now
2024-06-20 21:02:50.803  - [34mdebug[39m: sql.0 (3565) Return connection to pool: 7 now
2024-06-20 21:02:50.903  - [34mdebug[39m: sql.0 (3565) Return connection to pool: 6 now
2024-06-20 21:02:51.003  - [34mdebug[39m: sql.0 (3565) Return connection to pool: 5 now
2024-06-20 21:02:51.103  - [34mdebug[39m: sql.0 (3565) Return connection to pool: 4 now
2024-06-20 21:02:52.172  - [34mdebug[39m: sql.0 (3565) Return connection to pool: 3 now
2024-06-20 21:02:52.172  - [31merror[39m: sql.0 (3565) Error: connect ETIMEDOUT
2024-06-20 21:02:52.471  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB called for alias.0.Devices.Stromzaehler.Haus.Leistung (type: 0, ID: 31) and state: {"val":686,"ack":true,"ts":1718910171470,"q":0,"from":"system.adapter.mqtt.0","user":"system.user.admin","lc":1718910171470}
2024-06-20 21:02:52.471  - [34mdebug[39m: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Devices.Stromzaehler.Haus.Leistung
2024-06-20 21:02:52.471  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB-prepareTaskCheckTypeAndDbId RESULT for alias.0.Devices.Stromzaehler.Haus.Leistung (type: 0, ID: 31) and state: {"val":686,"ack":true,"ts":1718910171470,"q":0,"from":"system.adapter.mqtt.0","user":"system.user.admin","lc":1718910171470}: undefined
2024-06-20 21:02:52.474  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB called for alias.0.Sensoren.Strom.Haus.Leistung_Haus_only (type: 0, ID: 49) and state: {"val":505.64,"ack":true,"ts":1718910171474,"q":0,"c":"script.js.alias.Sensoren.Strom.Berechnung","from":"system.adapter.javascript.0","user":"system.user.admin","lc":1718910171474}
2024-06-20 21:02:52.474  - [34mdebug[39m: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Sensoren.Strom.Haus.Leistung_Haus_only
2024-06-20 21:02:52.474  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB-prepareTaskCheckTypeAndDbId RESULT for alias.0.Sensoren.Strom.Haus.Leistung_Haus_only (type: 0, ID: 49) and state: {"val":505.64,"ack":true,"ts":1718910171474,"q":0,"c":"script.js.alias.Sensoren.Strom.Berechnung","from":"system.adapter.javascript.0","user":"system.user.admin","lc":1718910171474}: undefined
2024-06-20 21:02:53.840  - [34mdebug[39m: sql.0 (3565) Return connection to pool: 2 now
2024-06-20 21:02:53.840  - [31merror[39m: sql.0 (3565) Error: connect ETIMEDOUT
2024-06-20 21:02:54.470  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB called for alias.0.Devices.Stromzaehler.Haus.Leistung (type: 0, ID: 31) and state: {"val":668,"ack":true,"ts":1718910173470,"q":0,"from":"system.adapter.mqtt.0","user":"system.user.admin","lc":1718910173470}
2024-06-20 21:02:54.471  - [34mdebug[39m: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Devices.Stromzaehler.Haus.Leistung
2024-06-20 21:02:54.471  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB-prepareTaskCheckTypeAndDbId RESULT for alias.0.Devices.Stromzaehler.Haus.Leistung (type: 0, ID: 31) and state: {"val":668,"ack":true,"ts":1718910173470,"q":0,"from":"system.adapter.mqtt.0","user":"system.user.admin","lc":1718910173470}: undefined
2024-06-20 21:02:54.644  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB called for mqtt.0.Heizkreisverteiler.UG.Keller.vorlauf (type: 0, ID: 694) and state: {"val":22.8,"ack":true,"ts":1718910169613,"q":0,"from":"system.adapter.mqtt.0","user":"system.user.admin","lc":1718910069612}
2024-06-20 21:02:54.645  - [34mdebug[39m: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for mqtt.0.Heizkreisverteiler.UG.Keller.vorlauf
2024-06-20 21:02:54.645  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB-prepareTaskCheckTypeAndDbId RESULT for mqtt.0.Heizkreisverteiler.UG.Keller.vorlauf (type: 0, ID: 694) and state: {"val":22.8,"ack":true,"ts":1718910169613,"q":0,"from":"system.adapter.mqtt.0","user":"system.user.admin","lc":1718910069612}: undefined
2024-06-20 21:02:55.478  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB called for alias.0.Devices.Stromzaehler.Haus.Leistung (type: 0, ID: 31) and state: {"val":695,"ack":true,"ts":1718910174477,"q":0,"from":"system.adapter.mqtt.0","user":"system.user.admin","lc":1718910174477}
2024-06-20 21:02:55.478  - [34mdebug[39m: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Devices.Stromzaehler.Haus.Leistung
2024-06-20 21:02:55.478  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB-prepareTaskCheckTypeAndDbId RESULT for alias.0.Devices.Stromzaehler.Haus.Leistung (type: 0, ID: 31) and state: {"val":695,"ack":true,"ts":1718910174477,"q":0,"from":"system.adapter.mqtt.0","user":"system.user.admin","lc":1718910174477}: undefined
2024-06-20 21:02:55.645  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB called for mqtt.0.Heizkreisverteiler.UG.Keller.vorlauf (type: 0, ID: 694) and state: {"val":22.9,"ack":true,"ts":1718910174644,"q":0,"from":"system.adapter.mqtt.0","user":"system.user.admin","lc":1718910174644}
2024-06-20 21:02:55.645  - [34mdebug[39m: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for mqtt.0.Heizkreisverteiler.UG.Keller.vorlauf
2024-06-20 21:02:55.645  - [34mdebug[39m: sql.0 (3565) pushValueIntoDB-prepareTaskCheckTypeAndDbId RESULT for mqtt.0.Heizkreisverteiler.UG.Keller.vorlauf (type: 0, ID: 694) and state: {"val":22.9,"ack":true,"ts":1718910174644,"q":0,"from":"system.adapter.mqtt.0","user":"system.user.admin","lc":1718910174644}: undefined
2024-06-20 21:02:57.178  - [34mdebug[39m: sql.0 (3565) Return connection to pool: 1 now
2024-06-20 21:02:57.178  - [31merror[39m: sql.0 (3565) Error: connect ETIMEDOUT

Scrounger avatar Jun 20 '24 19:06 Scrounger

any news?

Scrounger avatar Oct 08 '24 07:10 Scrounger