search

ioBroker / ioBroker.sql

Store history data in SQL Database: MySQL, PostgreSQL or SQLite
MIT License
45 stars 25 forks source link

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

Open Scrounger opened 3 months ago

Scrounger commented 3 months ago

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:

Additional context

Apollon77 commented 3 months ago

Please provide a debug log of such a case if possible

Scrounger commented 3 months ago 
2024-06-20 21:02:31.143  - error: sql.0 (3565) Error: connect ETIMEDOUT
2024-06-20 21:02:31.475  - debug: 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  - debug: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Sensoren.Strom.Haus.Autarkie
2024-06-20 21:02:31.475  - debug: 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  - debug: 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  - debug: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Sensoren.Strom.Haus.Leistung_Haus_only
2024-06-20 21:02:31.476  - debug: 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  - debug: 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  - debug: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Sensoren.Wetterstation.Aussen.Garten.Temperatur
2024-06-20 21:02:31.630  - debug: 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  - debug: 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  - debug: sql.0 (3565) Borrow connection from pool: 3 now
2024-06-20 21:02:32.143  - debug: sql.0 (3565) Return connection to pool: 2 now
2024-06-20 21:02:32.144  - error: sql.0 (3565) Error: connect ETIMEDOUT
2024-06-20 21:02:32.472  - debug: 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  - debug: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Devices.Stromzaehler.Haus.Leistung
2024-06-20 21:02:32.472  - debug: 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  - debug: 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  - debug: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Sensoren.Strom.Haus.Autarkie
2024-06-20 21:02:32.475  - debug: 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  - debug: 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  - debug: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Sensoren.Strom.Haus.Leistung_Haus_only
2024-06-20 21:02:32.476  - debug: 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  - debug: 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  - debug: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Sensoren.Wetterstation.Aussen.Garten.Temperatur
2024-06-20 21:02:32.631  - debug: 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  - debug: 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  - debug: sql.0 (3565) Borrow connection from pool: 3 now
2024-06-20 21:02:32.632  - debug: 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  - debug: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Sensoren.Wetterstation.Aussen.Garten.Helligkeit
2024-06-20 21:02:32.632  - debug: 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  - debug: 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  - debug: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Sensoren.Wetterstation.Aussen.Garten.Regenalarm
2024-06-20 21:02:32.633  - debug: 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  - debug: 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  - debug: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for linkeddevices.0.Devices.UG.Technik.Serverschrank.Stromzaehler.Leistung
2024-06-20 21:02:32.743  - debug: 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  - debug: 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  - debug: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for linkeddevices.0.Devices.UG.Technik.Serverschrank.Stromzaehler.Leistung
2024-06-20 21:02:32.743  - debug: 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  - debug: 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  - debug: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Devices.Heizung.Haus.UG.Heizungsraum.Warmwasser.Temperatur
2024-06-20 21:02:32.833  - debug: 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  - debug: 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  - debug: sql.0 (3565) Borrow connection from pool: 4 now
2024-06-20 21:02:32.834  - debug: 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  - debug: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for linkeddevices.0.Devices.UG.Heizungsraum.Heizung.Warmwasser.Temperatur_Verlust
2024-06-20 21:02:32.834  - debug: 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  - debug: 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  - debug: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Devices.Stromzaehler.Haus.Leistung
2024-06-20 21:02:33.472  - debug: 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  - debug: 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  - debug: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Sensoren.Strom.Haus.Autarkie
2024-06-20 21:02:33.475  - debug: 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  - debug: 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  - debug: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Sensoren.Strom.Haus.Leistung_Haus_only
2024-06-20 21:02:33.483  - debug: 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  - debug: 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  - debug: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Devices.Heizung.Haus.UG.Heizungsraum.Warmwasser.Temperatur
2024-06-20 21:02:33.833  - debug: 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  - debug: 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  - debug: sql.0 (3565) Borrow connection from pool: 5 now
2024-06-20 21:02:34.554  - debug: 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  - debug: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Sensoren.Temperatur.Gast.EG.Wohnen.aktuell
2024-06-20 21:02:34.554  - debug: 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  - debug: 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  - debug: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Devices.Stromzaehler.Haus.Leistung
2024-06-20 21:02:35.477  - debug: 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  - debug: 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  - debug: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Sensoren.Strom.Haus.Leistung_Haus_only
2024-06-20 21:02:35.480  - debug: 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  - debug: 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  - debug: sql.0 (3565) Borrow connection from pool: 6 now
2024-06-20 21:02:37.160  - debug: 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  - debug: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for linkeddevices.0.Devices.UG.Heizungsraum.Heizstab.Stromzaehler.Leistung
2024-06-20 21:02:37.160  - debug: 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  - debug: 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  - debug: sql.0 (3565) Borrow connection from pool: 7 now
2024-06-20 21:02:37.471  - debug: 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  - debug: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Devices.Stromzaehler.Haus.Leistung
2024-06-20 21:02:37.471  - debug: 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  - debug: 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  - debug: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Sensoren.Strom.Haus.Leistung_Haus_only
2024-06-20 21:02:37.475  - debug: 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  - debug: sql.0 (3565) Return connection to pool: 6 now
2024-06-20 21:02:38.472  - error: sql.0 (3565) Error: connect ETIMEDOUT
2024-06-20 21:02:38.474  - debug: 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  - debug: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Sensoren.Strom.Haus.Autarkie
2024-06-20 21:02:38.474  - debug: 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  - debug: 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  - debug: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Sensoren.Strom.Haus.Leistung_Haus_only
2024-06-20 21:02:38.475  - debug: 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  - debug: sql.0 (3565) SELECT
2024-06-20 21:02:38.819  - debug: sql.0 (3565) Borrow connection from pool: 7 now
2024-06-20 21:02:38.918  - debug: sql.0 (3565) SELECT
2024-06-20 21:02:38.918  - debug: sql.0 (3565) Borrow connection from pool: 8 now
2024-06-20 21:02:39.018  - debug: sql.0 (3565) SELECT
2024-06-20 21:02:39.018  - debug: sql.0 (3565) Borrow connection from pool: 9 now
2024-06-20 21:02:39.118  - debug: sql.0 (3565) SELECT
2024-06-20 21:02:39.118  - debug: sql.0 (3565) Borrow connection from pool: 10 now
2024-06-20 21:02:39.215  - debug: sql.0 (3565) SELECT
2024-06-20 21:02:39.215  - debug: sql.0 (3565) Borrow connection from pool: 11 now
2024-06-20 21:02:39.315  - debug: sql.0 (3565) SELECT
2024-06-20 21:02:39.315  - debug: sql.0 (3565) Borrow connection from pool: 12 now
2024-06-20 21:02:39.414  - debug: sql.0 (3565) SELECT
2024-06-20 21:02:39.414  - debug: sql.0 (3565) Borrow connection from pool: 13 now
2024-06-20 21:02:39.470  - debug: 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  - debug: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Devices.Stromzaehler.Haus.Leistung
2024-06-20 21:02:39.470  - debug: 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  - debug: 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  - debug: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Sensoren.Strom.Haus.Autarkie
2024-06-20 21:02:39.474  - debug: 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  - debug: 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  - debug: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Sensoren.Strom.Haus.Leistung_Haus_only
2024-06-20 21:02:39.475  - debug: 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  - debug: sql.0 (3565) SELECT
2024-06-20 21:02:39.515  - debug: sql.0 (3565) Borrow connection from pool: 14 now
2024-06-20 21:02:39.612  - debug: sql.0 (3565) SELECT
2024-06-20 21:02:39.612  - debug: sql.0 (3565) Borrow connection from pool: 15 now
2024-06-20 21:02:39.711  - debug: sql.0 (3565) SELECT
2024-06-20 21:02:39.711  - debug: sql.0 (3565) Borrow connection from pool: 16 now
2024-06-20 21:02:39.811  - debug: sql.0 (3565) SELECT
2024-06-20 21:02:39.811  - debug: sql.0 (3565) Borrow connection from pool: 17 now
2024-06-20 21:02:39.912  - debug: sql.0 (3565) SELECT
2024-06-20 21:02:39.912  - debug: sql.0 (3565) Borrow connection from pool: 18 now
2024-06-20 21:02:40.008  - debug: sql.0 (3565) SELECT
2024-06-20 21:02:40.008  - debug: sql.0 (3565) Borrow connection from pool: 19 now
2024-06-20 21:02:40.108  - debug: sql.0 (3565) SELECT
2024-06-20 21:02:40.108  - debug: sql.0 (3565) Borrow connection from pool: 20 now
2024-06-20 21:02:40.208  - debug: sql.0 (3565) SELECT
2024-06-20 21:02:40.208  - debug: sql.0 (3565) Borrow connection from pool: 21 now
2024-06-20 21:02:40.309  - debug: sql.0 (3565) SELECT
2024-06-20 21:02:40.309  - debug: sql.0 (3565) Borrow connection from pool: 22 now
2024-06-20 21:02:40.404  - debug: sql.0 (3565) SELECT
2024-06-20 21:02:40.404  - debug: sql.0 (3565) Borrow connection from pool: 23 now
2024-06-20 21:02:40.471  - debug: 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  - debug: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Devices.Stromzaehler.Haus.Leistung
2024-06-20 21:02:40.471  - debug: 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  - debug: 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  - debug: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Sensoren.Strom.Haus.Autarkie
2024-06-20 21:02:40.476  - debug: 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  - debug: sql.0 (3565) SELECT
2024-06-20 21:02:40.505  - debug: sql.0 (3565) Borrow connection from pool: 24 now
2024-06-20 21:02:40.605  - debug: sql.0 (3565) SELECT
2024-06-20 21:02:40.605  - debug: sql.0 (3565) Borrow connection from pool: 25 now
2024-06-20 21:02:40.704  - debug: sql.0 (3565) SELECT
2024-06-20 21:02:40.704  - debug: sql.0 (3565) Borrow connection from pool: 26 now
2024-06-20 21:02:40.803  - debug: sql.0 (3565) SELECT
2024-06-20 21:02:40.803  - debug: sql.0 (3565) Borrow connection from pool: 27 now
2024-06-20 21:02:40.902  - debug: sql.0 (3565) SELECT
2024-06-20 21:02:40.902  - debug: sql.0 (3565) Borrow connection from pool: 28 now
2024-06-20 21:02:41.003  - debug: sql.0 (3565) SELECT
2024-06-20 21:02:41.003  - debug: sql.0 (3565) Borrow connection from pool: 29 now
2024-06-20 21:02:41.102  - debug: sql.0 (3565) SELECT
2024-06-20 21:02:41.103  - debug: sql.0 (3565) Borrow connection from pool: 30 now
2024-06-20 21:02:41.478  - debug: 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  - debug: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Devices.Stromzaehler.Haus.Leistung
2024-06-20 21:02:41.478  - debug: 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  - debug: 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  - debug: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Sensoren.Strom.Haus.Leistung_Haus_only
2024-06-20 21:02:41.484  - debug: 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  - debug: sql.0 (3565) Return connection to pool: 29 now
2024-06-20 21:02:41.632  - error: sql.0 (3565) Error: connect ETIMEDOUT
2024-06-20 21:02:42.170  - debug: 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  - debug: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for linkeddevices.0.Devices.UG.Heizungsraum.Heizstab.Stromzaehler.Leistung
2024-06-20 21:02:42.171  - debug: 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  - debug: 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  - debug: sql.0 (3565) Borrow connection from pool: 30 now
2024-06-20 21:02:42.633  - debug: sql.0 (3565) Return connection to pool: 29 now
2024-06-20 21:02:42.633  - error: sql.0 (3565) Error: connect ETIMEDOUT
2024-06-20 21:02:42.833  - debug: sql.0 (3565) Return connection to pool: 28 now
2024-06-20 21:02:42.833  - error: sql.0 (3565) Error: connect ETIMEDOUT
2024-06-20 21:02:43.833  - debug: sql.0 (3565) Return connection to pool: 27 now
2024-06-20 21:02:43.833  - error: sql.0 (3565) Error: connect ETIMEDOUT
2024-06-20 21:02:43.839  - debug: 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  - debug: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Devices.Heizung.Haus.UG.Heizungsraum.Warmwasser.Temperatur
2024-06-20 21:02:43.839  - debug: 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  - debug: 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  - debug: sql.0 (3565) Borrow connection from pool: 28 now
2024-06-20 21:02:44.471  - debug: 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  - debug: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Devices.Stromzaehler.Haus.Leistung
2024-06-20 21:02:44.472  - debug: 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  - debug: 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  - debug: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Devices.Stromzaehler.Haus.Leistung
2024-06-20 21:02:45.472  - debug: 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  - debug: 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  - debug: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Sensoren.Strom.Haus.Autarkie
2024-06-20 21:02:45.479  - debug: 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  - debug: sql.0 (3565) Return connection to pool: 27 now
2024-06-20 21:02:45.480  - error: sql.0 (3565) Error: connect ETIMEDOUT
2024-06-20 21:02:45.480  - debug: 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  - debug: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Sensoren.Strom.Haus.Leistung_Haus_only
2024-06-20 21:02:45.480  - debug: 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  - debug: sql.0 (3565) Return connection to pool: 26 now
2024-06-20 21:02:47.161  - error: sql.0 (3565) Error: connect ETIMEDOUT
2024-06-20 21:02:47.178  - debug: 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  - debug: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for linkeddevices.0.Devices.UG.Heizungsraum.Heizstab.Stromzaehler.Leistung
2024-06-20 21:02:47.178  - debug: 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  - debug: 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  - debug: sql.0 (3565) Borrow connection from pool: 27 now
2024-06-20 21:02:47.469  - debug: 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  - debug: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Devices.Stromzaehler.Haus.Leistung
2024-06-20 21:02:47.469  - debug: 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  - debug: 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  - debug: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Sensoren.Strom.Haus.Autarkie
2024-06-20 21:02:47.473  - debug: 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  - debug: 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  - debug: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Sensoren.Strom.Haus.Leistung_Haus_only
2024-06-20 21:02:47.473  - debug: 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  - debug: sql.0 (3565) Return connection to pool: 26 now
2024-06-20 21:02:48.918  - debug: sql.0 (3565) Return connection to pool: 25 now
2024-06-20 21:02:49.018  - debug: sql.0 (3565) Return connection to pool: 24 now
2024-06-20 21:02:49.119  - debug: sql.0 (3565) Return connection to pool: 23 now
2024-06-20 21:02:49.215  - debug: sql.0 (3565) Return connection to pool: 22 now
2024-06-20 21:02:49.315  - debug: sql.0 (3565) Return connection to pool: 21 now
2024-06-20 21:02:49.415  - debug: sql.0 (3565) Return connection to pool: 20 now
2024-06-20 21:02:49.478  - debug: 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  - debug: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Devices.Stromzaehler.Haus.Leistung
2024-06-20 21:02:49.478  - debug: 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  - debug: 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  - debug: sql.0 (3565) Borrow connection from pool: 21 now
2024-06-20 21:02:49.483  - debug: 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  - debug: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Sensoren.Strom.Haus.Leistung_Haus_only
2024-06-20 21:02:49.484  - debug: 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  - debug: sql.0 (3565) Return connection to pool: 20 now
2024-06-20 21:02:49.612  - debug: sql.0 (3565) Return connection to pool: 19 now
2024-06-20 21:02:49.711  - debug: sql.0 (3565) Return connection to pool: 18 now
2024-06-20 21:02:49.811  - debug: sql.0 (3565) Return connection to pool: 17 now
2024-06-20 21:02:49.912  - debug: sql.0 (3565) Return connection to pool: 16 now
2024-06-20 21:02:50.008  - debug: sql.0 (3565) Return connection to pool: 15 now
2024-06-20 21:02:50.109  - debug: sql.0 (3565) Return connection to pool: 14 now
2024-06-20 21:02:50.209  - debug: sql.0 (3565) Return connection to pool: 13 now
2024-06-20 21:02:50.309  - debug: sql.0 (3565) Return connection to pool: 12 now
2024-06-20 21:02:50.405  - debug: sql.0 (3565) Return connection to pool: 11 now
2024-06-20 21:02:50.505  - debug: sql.0 (3565) Return connection to pool: 10 now
2024-06-20 21:02:50.605  - debug: sql.0 (3565) Return connection to pool: 9 now
2024-06-20 21:02:50.705  - debug: sql.0 (3565) Return connection to pool: 8 now
2024-06-20 21:02:50.803  - debug: sql.0 (3565) Return connection to pool: 7 now
2024-06-20 21:02:50.903  - debug: sql.0 (3565) Return connection to pool: 6 now
2024-06-20 21:02:51.003  - debug: sql.0 (3565) Return connection to pool: 5 now
2024-06-20 21:02:51.103  - debug: sql.0 (3565) Return connection to pool: 4 now
2024-06-20 21:02:52.172  - debug: sql.0 (3565) Return connection to pool: 3 now
2024-06-20 21:02:52.172  - error: sql.0 (3565) Error: connect ETIMEDOUT
2024-06-20 21:02:52.471  - debug: 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  - debug: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Devices.Stromzaehler.Haus.Leistung
2024-06-20 21:02:52.471  - debug: 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  - debug: 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  - debug: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Sensoren.Strom.Haus.Leistung_Haus_only
2024-06-20 21:02:52.474  - debug: 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  - debug: sql.0 (3565) Return connection to pool: 2 now
2024-06-20 21:02:53.840  - error: sql.0 (3565) Error: connect ETIMEDOUT
2024-06-20 21:02:54.470  - debug: 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  - debug: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Devices.Stromzaehler.Haus.Leistung
2024-06-20 21:02:54.471  - debug: 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  - debug: 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  - debug: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for mqtt.0.Heizkreisverteiler.UG.Keller.vorlauf
2024-06-20 21:02:54.645  - debug: 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  - debug: 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  - debug: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for alias.0.Devices.Stromzaehler.Haus.Leistung
2024-06-20 21:02:55.478  - debug: 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  - debug: 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  - debug: sql.0 (3565) prepareTaskCheckTypeAndDbId CALLED for mqtt.0.Heizkreisverteiler.UG.Keller.vorlauf
2024-06-20 21:02:55.645  - debug: 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  - debug: sql.0 (3565) Return connection to pool: 1 now
2024-06-20 21:02:57.178  - error: sql.0 (3565) Error: connect ETIMEDOUT