Support Thread - "DatabaseAddOn" Plugin

[fuxl66]

Hi,

Ich habe ein Item in das ich nach jeder Ladesession die geladen kWh schreibe.
Kann ich mit diesem Plugin ebenfalls Verbrauchswerte (Summe von Heute/Tag,Woche,Monat,etc) ermitteln?

Gruß
Markus

Zum oben genannten Case hab ich mir nun ein Zähleritem gebastelt. Damit klappt die Auswertung.


Aber es gibt einen weiteren Case in dem ich den AVG berechnen möchte.
Ich schreibe nach jeder Ladesession die Durschnitts - Kosten / kWh in das item. (ct/kWh)
Siehe Screenshot.

image.png

PowerCarCentAVG:

    Total:
        type: num
        database: 'init'
        database_write_on_shutdown: 'false'
        cache: 'yes'
        visu_acl: rw

    Vormonat1:
        type: num
        cache: 'yes'
        visu_acl: rw
        db_addon_fct: minmax
        db_addon_params_dict: "{'func': 'avg', 'timeframe': 'month', 'start': 2, 'end': 1}"
        db_addon_database_item: 'PowerCarCentAVG.Total'

    Monat1:
        type: num
        cache: 'yes'
        visu_acl: rw
        db_addon_fct: minmax
        db_addon_params_dict: "{'func': 'avg', 'timeframe': 'month', 'start': 1, 'end': 0}"
        db_addon_database_item: 'PowerCarCentAVG.Total'​

Leider bleiben beide Wert auf 0. Monat1 sollte den Durschnittswert für das aktuelle Monats (Feb) ausgeben und Vormonat1 des Vormonats (Jan).
Wo liegt mein Fehler?
image.png


Debug Log hab ich auch schon aktiviert aber keinerlei Eintrag zu finden.

mfg
Markus

[fuxl66]

Hi,

Ich habe ein Item in das ich nach jeder Ladesession die geladen kWh schreibe.
Kann ich mit diesem Plugin ebenfalls Verbrauchswerte (Summe von Heute/Tag,Woche,Monat,etc) ermitteln?

Gruß
Markus

[ooUrmeloo]

Bist Du dir sicher, dass die Probleme mit der DB vom db_addon Plugin kommen.
Ich vermute, dass das Problem bei dir liegt daran, dass 2 Plugins parallel auf die Datenbank zugreifen.
Kannst Du dich vielleicht mal in die Treiber einlesen?

Nein, bin nicht sicher, dass es vom Addon Plugin kommt. Ich habe jetzt auch gelesen, dass sqlite3 ggf. Probleme bei mehreren Usern (d.h. Plugins?) haben kann.
Dann muss ich mich wohl mal einlesen, wie ich einen MySQL Server zum laufen bringe ... damit ich das Mal probieren kann.

[Sisamiwe]

Gibt's bessere Alternativen?

Ich selbst nutze mysql. Dort können mehrere Zugriffe auf die Datenbank besser gehandhabt werden. Dafür ist das Backup etwas aufwendiger
Da ich aber sqlite3 nicht produktiv einsetzte, kann ich das auch nicht extensiv testen. Auf meiner Testinstanz gab es bislang keine Probleme.

Bist Du dir sicher, dass die Probleme mit der DB vom db_addon Plugin kommen.
Ich vermute, dass das Problem bei dir liegt daran, dass 2 Plugins parallel auf die Datenbank zugreifen.
Kannst Du dich vielleicht mal in die Treiber einlesen?

[ooUrmeloo]

Hey,

du nutzt sqlite3 als Datenbank, richtig?

ja ... siehe oben:

driver: sqlite3

Gibt's bessere Alternativen?

[Sisamiwe]

Hat jemand ähnliche Probleme oder eine Idee, was das Problem sein könnte?

Hey,

du nutzt sqlite3 als Datenbank, richtig?

[ooUrmeloo]

Hallo zusammen,
ich habe immer mal wieder - alle paar Monate - das Problem, dass scheinbar meine Database korrupt wird. Das zeigt sich dann in Fehlermeldungen beim database Addon.

2025-10-05 00:00:15 ERROR plugins.db_addon Error 'database disk image is malformed' for query=SELECT time, MIN(val_num) as value FROM log WHERE item_id = 15 AND time BETWEEN 1744305434000 AND 1767222000000 AND val_bool = 1 occurred.
2025-10-05 00:00:15 ERROR plugins.db_addon Error occurred during '_query_log_timestamp' of item=paradigma.Aussentemperatur. Aborting...
2025-10-05 00:01:06 ERROR lib.db Can not execute query: SELECT time, MIN(val_num) as value FROM log WHERE item_id = ? AND time BETWEEN ? AND ? AND val_bool = 1 (args [204, 1750629628920, 1767222000000]): database disk image is malformed

Ich habe bisher auch keine Möglichkeit gefunden, das wieder zu "reparieren", d.h., ich muss dann leider wieder von null anfangen.
Ein database Backup einspielen funktioniert manchmal, aber auch nicht immer.

Verwende folgende config bzw. mache regelmäßig durch einen Neustart ein Backup. Aber irgendwie ist das nicht befriedigend.
Ich speicher die database schon auf einen USB Stick, um die Speicherkarte nicht zu belasten, funktioniert aber offensichtlich auch nicht wirklich.

database:
    plugin_name: database
    driver: sqlite3
    copy_database: true
    copy_database_name: /media/usbstick/smarthomeng_backup.db

    connect:
    -   database:/media/usbstick/smarthomeng.db
    -   check_same_thread:0

db_addon:
    plugin_name: db_addon
    database_plugin_config: database
    startup_run_delay: 120
    use_oldest_entry: true

Hat jemand ähnliche Probleme oder eine Idee, was das Problem sein könnte?

[Cannon]

Das Plugin läuft zwar weiter, aber nach dem keine Verbindung zu DB besteht, berechnet es wahrscheinlich auch nichts.

Prüfst Du das mal?

Ja das ist auch so. Ich meinte nur, dass ich nichts feststellen kann, warum die Verbindung nicht hergestellt wird. Es kommen dann auch weitere Fehler, weil die Verbindung nicht hergestellt wird. Das kommt dann auch mehrmals: "Database reconnect suppressed since last connection is less then 20sec ago".

Wenn aber das ganze im Admin-IF auf DEBUG eingestellt ist, dann kann auch die Verbindung hergestellt werden. Dann läuft alles und auch dann, wenn dann wieder auf INFO umgestellt wird .... bis zum nächsten Neustart.

[Sisamiwe]

Hallo,

auch bei der Logger-Einstellung auf DEBUG kommt es zu einem Fehler:

Das Plugin startet mit run():

2025-04-06 12:50:22 DBGHIGH plugins.db_addon Methode 'run()' aufgerufen
2025-04-06 12:50:22 DEBUG plugins.db_addon Corresponding plugin 'database' with given config name 'database' found.
2025-04-06 12:50:22 DEBUG plugins.db_addon Database is of type 'sqlite' found.
2025-04-06 12:50:22 DEBUG plugins.db_addon Database Plugin available with instance=None and connection=['database:./var/db/smarthomeng.db', 'check_same_thread:0']
2025-04-06 12:50:22 DEBUG plugins.db_addon Initialization of database API successful
2025-04-06 12:50:22 DEBUG plugins.db_addon Connect to database.​

Hier wird die Verbindung hergestellt.

Nach der "Startup-Berechnungspause" beginnt die Berechnung der Items. Dazu wird eine neue Verbindung zur DB hergestellt, und die kommt nicht zu Stande:

2025-04-06 12:55:26 DEBUG plugins.db_addon Connect to database.
2025-04-06 12:55:26 CRITICAL plugins.db_addon Initialization of Database Connection failed: unable to open database file
2025-04-06 12:55:26 DEBUG plugins.db_addon Called with query='SELECT min(time) FROM log WHERE item_id = :item_id;', params={'item_id': None}, cur=None​

Das Plugin läuft zwar weiter, aber nach dem keine Verbindung zu DB besteht, berechnet es wahrscheinlich auch nichts.

Prüfst Du das mal?

[Cannon]

Und vielleicht noch mal als Ergänzung. Noch mal im Admin-Interface alles hin- und hergestellt und es läuft dann auch im DEBUG-Modus wieder.

Wenn ich von DEBUG auf INFO umstelle, während alles funktioniert und den Core nicht neu starte, dann läuft das danach auch weiter. Irgendwie will er die DB-Verbindung nicht herstellen, wenn das LOGLEVEL auf INFO eingestellt ist. Aber auch, wenn es manuell in die logging.yaml eingefügt wird geht es nicht. Nur aus dem Admin-IF. Aber auch im Log sehe ich nichts bedeutendes.

[Cannon]

Du könntest mal testweise den speziell für dieses Plugin definierten Logger aus der logging.yaml zu löschen

Habe ich gemacht. Das Gleiche Problem + nachdem ich es wieder zugefügt habe, bleibt der Fehler bestehen, was aber den Vorteil hat, dass der Debug-Log nun auch existiert.

2025-04-06  12:50:19 DEBUG    plugins.db_addon    Start of db_addon Plugin.
2025-04-06  12:50:19 INFO     plugins.db_addon    All cache_dicts will be initiated.
2025-04-06  12:50:19 DEBUG    plugins.db_addon    Start reading data from '/usr/local/smarthome/var/plugin_data/db_addon/db_addon_data.pkl'
2025-04-06  12:50:19 DEBUG    plugins.db_addon    Successfully read data from /usr/local/smarthome/var/plugin_data/db_addon/db_addon_data.pkl
2025-04-06  12:50:20 DEBUG    plugins.db_addon    parse item: Zentral.Wetter.Wetterstation.Temperatur.Gruenlandtemperatursumme due to 'db_addon_fct'
2025-04-06  12:50:20 DEBUG    plugins.db_addon    Attribut 'database' for item='Zentral.Wetter.Wetterstation.Temperatur.Gruenlandtemperatursumme'  has been found 1 level above item at 'Zentral.Wetter.Wetterstation.Temperatur'.
2025-04-06  12:50:20 DEBUG    plugins.db_addon    database_item=Item: Zentral.Wetter.Wetterstation.Temperatur, db_addon_startup=True, db_addon_ignore_value_list=None, db_addon_ignore_value=None
2025-04-06  12:50:20 DEBUG    plugins.db_addon    Item=Zentral.Wetter.Wetterstation.Temperatur.Gruenlandtemperatursumme added with db_addon_fct=gruenlandtempsumme and database_item=Zentral.Wetter.Wetterstation.Temperatur
2025-04-06  12:50:20 DEBUG    plugins.db_addon    Item 'Zentral.Wetter.Wetterstation.Temperatur.Gruenlandtemperatursumme' added to be run daily.
2025-04-06  12:50:20 DEBUG    plugins.db_addon    Item 'Zentral.Wetter.Wetterstation.Temperatur.Gruenlandtemperatursumme' completely parsed: item_config_data_dict={'db_addon': 'function', 'db_addon_fct': 'gruenlandtempsumme', 'database_item': Item: Zentral.Wetter.Wetterstation.Temperatur, 'query_params': {}, 'suspended': False, 'cat': 'summe', 'sub_cat': None, 'cycle': 'daily', 'on': 'demand', 'startup': True}.
2025-04-06  12:50:20 DEBUG    plugins.db_addon    parse item: Zentral.Wetter.Wetterstation.Temperatur.Waermesumme due to 'db_addon_fct'
2025-04-06  12:50:20 DEBUG    plugins.db_addon    Attribut 'database' for item='Zentral.Wetter.Wetterstation.Temperatur.Waermesumme'  has been found 1 level above item at 'Zentral.Wetter.Wetterstation.Temperatur'.
2025-04-06  12:50:20 DEBUG    plugins.db_addon    database_item=Item: Zentral.Wetter.Wetterstation.Temperatur, db_addon_startup=True, db_addon_ignore_value_list=None, db_addon_ignore_value=None
2025-04-06  12:50:20 DEBUG    plugins.db_addon    Item=Zentral.Wetter.Wetterstation.Temperatur.Waermesumme added with db_addon_fct=waermesumme and database_item=Zentral.Wetter.Wetterstation.Temperatur
2025-04-06  12:50:20 DEBUG    plugins.db_addon    Item 'Zentral.Wetter.Wetterstation.Temperatur.Waermesumme' added to be run daily.
2025-04-06  12:50:20 DEBUG    plugins.db_addon    Item 'Zentral.Wetter.Wetterstation.Temperatur.Waermesumme' completely parsed: item_config_data_dict={'db_addon': 'function', 'db_addon_fct': 'waermesumme', 'database_item': Item: Zentral.Wetter.Wetterstation.Temperatur, 'query_params': {}, 'suspended': False, 'cat': 'summe', 'sub_cat': None, 'cycle': 'daily', 'on': 'demand', 'startup': True}.
2025-04-06  12:50:20 DEBUG    plugins.db_addon    parse item: Zentral.Wetter.Wetterstation.Temperatur.Kaeltesumme due to 'db_addon_fct'
2025-04-06  12:50:20 DEBUG    plugins.db_addon    Attribut 'database' for item='Zentral.Wetter.Wetterstation.Temperatur.Kaeltesumme'  has been found 1 level above item at 'Zentral.Wetter.Wetterstation.Temperatur'.
2025-04-06  12:50:20 DEBUG    plugins.db_addon    database_item=Item: Zentral.Wetter.Wetterstation.Temperatur, db_addon_startup=True, db_addon_ignore_value_list=None, db_addon_ignore_value=None
2025-04-06  12:50:20 DEBUG    plugins.db_addon    Item=Zentral.Wetter.Wetterstation.Temperatur.Kaeltesumme added with db_addon_fct=kaeltesumme and database_item=Zentral.Wetter.Wetterstation.Temperatur
2025-04-06  12:50:20 DEBUG    plugins.db_addon    Item 'Zentral.Wetter.Wetterstation.Temperatur.Kaeltesumme' added to be run daily.
2025-04-06  12:50:20 DEBUG    plugins.db_addon    Item 'Zentral.Wetter.Wetterstation.Temperatur.Kaeltesumme' completely parsed: item_config_data_dict={'db_addon': 'function', 'db_addon_fct': 'kaeltesumme', 'database_item': Item: Zentral.Wetter.Wetterstation.Temperatur, 'query_params': {}, 'suspended': False, 'cat': 'summe', 'sub_cat': None, 'cycle': 'daily', 'on': 'demand', 'startup': True}.
2025-04-06  12:50:20 DEBUG    plugins.db_addon    parse item: Zentral.Wetter.Wetterstation.Temperatur.Wachstumsgradtage due to 'db_addon_fct'
2025-04-06  12:50:20 DEBUG    plugins.db_addon    Attribut 'database' for item='Zentral.Wetter.Wetterstation.Temperatur.Wachstumsgradtage'  has been found 1 level above item at 'Zentral.Wetter.Wetterstation.Temperatur'.
2025-04-06  12:50:20 DEBUG    plugins.db_addon    database_item=Item: Zentral.Wetter.Wetterstation.Temperatur, db_addon_startup=True, db_addon_ignore_value_list=None, db_addon_ignore_value=None
2025-04-06  12:50:20 DEBUG    plugins.db_addon    Item=Zentral.Wetter.Wetterstation.Temperatur.Wachstumsgradtage added with db_addon_fct=wachstumsgradtage and database_item=Zentral.Wetter.Wetterstation.Temperatur
2025-04-06  12:50:20 DEBUG    plugins.db_addon    Item 'Zentral.Wetter.Wetterstation.Temperatur.Wachstumsgradtage' added to be run daily.
2025-04-06  12:50:20 DEBUG    plugins.db_addon    Item 'Zentral.Wetter.Wetterstation.Temperatur.Wachstumsgradtage' completely parsed: item_config_data_dict={'db_addon': 'function', 'db_addon_fct': 'wachstumsgradtage', 'database_item': Item: Zentral.Wetter.Wetterstation.Temperatur, 'query_params': {}, 'suspended': False, 'cat': 'summe', 'sub_cat': None, 'cycle': 'daily', 'on': 'demand', 'startup': True}.
2025-04-06  12:50:21 DEBUG    plugins.db_addon    parse item: Zentral.Wetter.Wetterstation.Regen.gestern due to 'db_addon_fct'
2025-04-06  12:50:21 DEBUG    plugins.db_addon    Attribut 'database' for item='Zentral.Wetter.Wetterstation.Regen.gestern'  has been found 1 level above item at 'Zentral.Wetter.Wetterstation.Regen'.
2025-04-06  12:50:21 DEBUG    plugins.db_addon    database_item=Item: Zentral.Wetter.Wetterstation.Regen, db_addon_startup=None, db_addon_ignore_value_list=None, db_addon_ignore_value=None
2025-04-06  12:50:21 DEBUG    plugins.db_addon    Item=Zentral.Wetter.Wetterstation.Regen.gestern added with db_addon_fct=minmax_heute_minus1_max and database_item=Zentral.Wetter.Wetterstation.Regen
2025-04-06  12:50:21 DEBUG    plugins.db_addon    Item 'Zentral.Wetter.Wetterstation.Regen.gestern' added to be run daily.
2025-04-06  12:50:21 DEBUG    plugins.db_addon    Item 'Zentral.Wetter.Wetterstation.Regen.gestern' completely parsed: item_config_data_dict={'db_addon': 'function', 'db_addon_fct': 'minmax_heute_minus1_max', 'database_item': Item: Zentral.Wetter.Wetterstation.Regen, 'query_params': {'func': 'max', 'timeframe': 'day', 'start': 1, 'end': 1}, 'suspended': False, 'cat': 'wertehistorie', 'sub_cat': 'timeframe', 'cycle': 'daily', 'on': 'demand', 'startup': False}.
2025-04-06  12:50:21 DEBUG    plugins.db_addon    parse item: Zentral.Wetter.pluggit.Temperatur.Gruenlandtemperatursumme due to 'db_addon_fct'
2025-04-06  12:50:21 DEBUG    plugins.db_addon    Attribut 'database' for item='Zentral.Wetter.pluggit.Temperatur.Gruenlandtemperatursumme'  has been found 1 level above item at 'Zentral.Wetter.pluggit.Temperatur'.
2025-04-06  12:50:21 DEBUG    plugins.db_addon    database_item=Item: Zentral.Wetter.pluggit.Temperatur, db_addon_startup=True, db_addon_ignore_value_list=None, db_addon_ignore_value=None
2025-04-06  12:50:21 DEBUG    plugins.db_addon    Item=Zentral.Wetter.pluggit.Temperatur.Gruenlandtemperatursumme added with db_addon_fct=gruenlandtempsumme and database_item=Zentral.Wetter.pluggit.Temperatur
2025-04-06  12:50:21 DEBUG    plugins.db_addon    Item 'Zentral.Wetter.pluggit.Temperatur.Gruenlandtemperatursumme' added to be run daily.
2025-04-06  12:50:21 DEBUG    plugins.db_addon    Item 'Zentral.Wetter.pluggit.Temperatur.Gruenlandtemperatursumme' completely parsed: item_config_data_dict={'db_addon': 'function', 'db_addon_fct': 'gruenlandtempsumme', 'database_item': Item: Zentral.Wetter.pluggit.Temperatur, 'query_params': {}, 'suspended': False, 'cat': 'summe', 'sub_cat': None, 'cycle': 'daily', 'on': 'demand', 'startup': True}.
2025-04-06  12:50:21 DEBUG    plugins.db_addon    parse item: Zentral.Wetter.pluggit.Temperatur.Waermesumme due to 'db_addon_fct'
2025-04-06  12:50:21 DEBUG    plugins.db_addon    Attribut 'database' for item='Zentral.Wetter.pluggit.Temperatur.Waermesumme'  has been found 1 level above item at 'Zentral.Wetter.pluggit.Temperatur'.
2025-04-06  12:50:21 DEBUG    plugins.db_addon    database_item=Item: Zentral.Wetter.pluggit.Temperatur, db_addon_startup=True, db_addon_ignore_value_list=None, db_addon_ignore_value=None
2025-04-06  12:50:21 DEBUG    plugins.db_addon    Item=Zentral.Wetter.pluggit.Temperatur.Waermesumme added with db_addon_fct=waermesumme and database_item=Zentral.Wetter.pluggit.Temperatur
2025-04-06  12:50:21 DEBUG    plugins.db_addon    Item 'Zentral.Wetter.pluggit.Temperatur.Waermesumme' added to be run daily.
2025-04-06  12:50:21 DEBUG    plugins.db_addon    Item 'Zentral.Wetter.pluggit.Temperatur.Waermesumme' completely parsed: item_config_data_dict={'db_addon': 'function', 'db_addon_fct': 'waermesumme', 'database_item': Item: Zentral.Wetter.pluggit.Temperatur, 'query_params': {}, 'suspended': False, 'cat': 'summe', 'sub_cat': None, 'cycle': 'daily', 'on': 'demand', 'startup': True}.
2025-04-06  12:50:21 DEBUG    plugins.db_addon    parse item: Zentral.Wetter.pluggit.Temperatur.Kaeltesumme due to 'db_addon_fct'
2025-04-06  12:50:21 DEBUG    plugins.db_addon    Attribut 'database' for item='Zentral.Wetter.pluggit.Temperatur.Kaeltesumme'  has been found 1 level above item at 'Zentral.Wetter.pluggit.Temperatur'.
2025-04-06  12:50:21 DEBUG    plugins.db_addon    database_item=Item: Zentral.Wetter.pluggit.Temperatur, db_addon_startup=True, db_addon_ignore_value_list=None, db_addon_ignore_value=None
2025-04-06  12:50:21 DEBUG    plugins.db_addon    Item=Zentral.Wetter.pluggit.Temperatur.Kaeltesumme added with db_addon_fct=kaeltesumme and database_item=Zentral.Wetter.pluggit.Temperatur
2025-04-06  12:50:21 DEBUG    plugins.db_addon    Item 'Zentral.Wetter.pluggit.Temperatur.Kaeltesumme' added to be run daily.
2025-04-06  12:50:21 DEBUG    plugins.db_addon    Item 'Zentral.Wetter.pluggit.Temperatur.Kaeltesumme' completely parsed: item_config_data_dict={'db_addon': 'function', 'db_addon_fct': 'kaeltesumme', 'database_item': Item: Zentral.Wetter.pluggit.Temperatur, 'query_params': {}, 'suspended': False, 'cat': 'summe', 'sub_cat': None, 'cycle': 'daily', 'on': 'demand', 'startup': True}.
2025-04-06  12:50:21 DEBUG    plugins.db_addon    parse item: Zentral.Wetter.pluggit.Temperatur.Wachstumsgradtage due to 'db_addon_fct'
2025-04-06  12:50:21 DEBUG    plugins.db_addon    Attribut 'database' for item='Zentral.Wetter.pluggit.Temperatur.Wachstumsgradtage'  has been found 1 level above item at 'Zentral.Wetter.pluggit.Temperatur'.
2025-04-06  12:50:21 DEBUG    plugins.db_addon    database_item=Item: Zentral.Wetter.pluggit.Temperatur, db_addon_startup=True, db_addon_ignore_value_list=None, db_addon_ignore_value=None
2025-04-06  12:50:21 DEBUG    plugins.db_addon    Item=Zentral.Wetter.pluggit.Temperatur.Wachstumsgradtage added with db_addon_fct=wachstumsgradtage and database_item=Zentral.Wetter.pluggit.Temperatur
2025-04-06  12:50:21 DEBUG    plugins.db_addon    Item 'Zentral.Wetter.pluggit.Temperatur.Wachstumsgradtage' added to be run daily.
2025-04-06  12:50:21 DEBUG    plugins.db_addon    Item 'Zentral.Wetter.pluggit.Temperatur.Wachstumsgradtage' completely parsed: item_config_data_dict={'db_addon': 'function', 'db_addon_fct': 'wachstumsgradtage', 'database_item': Item: Zentral.Wetter.pluggit.Temperatur, 'query_params': {}, 'suspended': False, 'cat': 'summe', 'sub_cat': None, 'cycle': 'daily', 'on': 'demand', 'startup': True}.
2025-04-06  12:50:22 DBGHIGH  plugins.db_addon    Methode 'run()' aufgerufen
2025-04-06  12:50:22 DEBUG    plugins.db_addon    Corresponding plugin 'database' with given config name 'database' found.
2025-04-06  12:50:22 DEBUG    plugins.db_addon    Database is of type 'sqlite' found.
2025-04-06  12:50:22 DEBUG    plugins.db_addon    Database Plugin available with instance=None and connection=['database:./var/db/smarthomeng.db', 'check_same_thread:0']
2025-04-06  12:50:22 DEBUG    plugins.db_addon    Initialization of database API successful
2025-04-06  12:50:22 DEBUG    plugins.db_addon    Connect to database.
2025-04-06  12:50:22 DEBUG    plugins.db_addon    scheduler_add: name = plugins.db_addon.cyclic, parameters: prio=3, cron='10 * * * *'
2025-04-06  12:50:22 INFO     plugins.db_addon    Set scheduler for calculating startup-items with delay of 303s to 2025-04-06 12:55:25.651539+02:00.
2025-04-06  12:50:22 DEBUG    plugins.db_addon    scheduler_add: name = plugins.db_addon.startup, parameters: prio=3, next=datetime.datetime(2025, 4, 6, 12, 55, 25, 651539, tzinfo=tzfile('/usr/share/zoneinfo/Europe/Berlin'))
2025-04-06  12:51:04 DEBUG    plugins.db_addon     Updated Item Zentral.Wetter.Wetterstation.Temperatur with value 7.1 will be put to queue in approx. 30s resp. after startup.
2025-04-06  12:51:12 DEBUG    plugins.db_addon     Updated Item Zentral.Wetter.pluggit.Temperatur with value 10.68 will be put to queue in approx. 30s resp. after startup.
2025-04-06  12:51:33 DEBUG    plugins.db_addon     Updated Item Zentral.Wetter.pluggit.Temperatur with value 10.64 will be put to queue in approx. 30s resp. after startup.
2025-04-06  12:52:24 DEBUG    plugins.db_addon     Updated Item Zentral.Wetter.pluggit.Temperatur with value 10.78 will be put to queue in approx. 30s resp. after startup.
2025-04-06  12:53:14 DEBUG    plugins.db_addon     Updated Item Zentral.Wetter.pluggit.Temperatur with value 10.36 will be put to queue in approx. 30s resp. after startup.
2025-04-06  12:54:05 DEBUG    plugins.db_addon     Updated Item Zentral.Wetter.pluggit.Temperatur with value 9.93 will be put to queue in approx. 30s resp. after startup.
2025-04-06  12:54:55 DEBUG    plugins.db_addon     Updated Item Zentral.Wetter.pluggit.Temperatur with value 9.98 will be put to queue in approx. 30s resp. after startup.
2025-04-06  12:55:26 DEBUG    plugins.db_addon    execute_items called with option='startup'
2025-04-06  12:55:26 INFO     plugins.db_addon    8 items will be calculated for option='startup'.
2025-04-06  12:55:26 DEBUG    plugins.db_addon    Items to be calculated: todo_items=[Item: Zentral.Wetter.Wetterstation.Temperatur.Gruenlandtemperatursumme, Item: Zentral.Wetter.Wetterstation.Temperatur.Wachstumsgradtage, Item: Zentral.Wetter.pluggit.Temperatur.Gruenlandtemperatursumme, Item: Zentral.Wetter.pluggit.Temperatur.Wachstumsgradtage, Item: Zentral.Wetter.Wetterstation.Temperatur.Waermesumme, Item: Zentral.Wetter.Wetterstation.Temperatur.Kaeltesumme, Item: Zentral.Wetter.pluggit.Temperatur.Waermesumme, Item: Zentral.Wetter.pluggit.Temperatur.Kaeltesumme]
2025-04-06  12:55:26 DEBUG    plugins.db_addon    scheduler_add: name = plugins.db_addon.onchange_delay, parameters: prio=3, cycle=30
2025-04-06  12:55:26 DEBUG    plugins.db_addon    queue_entry=Item: Zentral.Wetter.Wetterstation.Temperatur.Gruenlandtemperatursumme
2025-04-06  12:55:26 INFO     plugins.db_addon    # 8 item(s) to do. || 'on-demand' item=Zentral.Wetter.Wetterstation.Temperatur.Gruenlandtemperatursumme will be processed.
2025-04-06  12:55:26 DEBUG    plugins.db_addon    Item=Zentral.Wetter.Wetterstation.Temperatur.Gruenlandtemperatursumme with item_config={'db_addon': 'function', 'db_addon_fct': 'gruenlandtempsumme', 'database_item': Item: Zentral.Wetter.Wetterstation.Temperatur, 'query_params': {}, 'suspended': False, 'cat': 'summe', 'sub_cat': None, 'cycle': 'daily', 'on': 'demand', 'startup': True}
2025-04-06  12:55:26 DEBUG    plugins.db_addon    db_addon_fct='gruenlandtempsumme' will _query_item with params={}.
2025-04-06  12:55:26 DEBUG    plugins.db_addon    func='gruenlandtempsumme', database_item=Item: Zentral.Wetter.Wetterstation.Temperatur, year=None, month=None, params={}
2025-04-06  12:55:26 DEBUG    plugins.db_addon    try to get raw data
2025-04-06  12:55:26 DEBUG    plugins.db_addon    called with database_item=Zentral.Wetter.Wetterstation.Temperatur, timeframe='day', start=95, end=0, ignore_value_list=None, data_con_func='first_hour_avg_day'
2025-04-06  12:55:26 DEBUG    plugins.db_addon      called with func='raw', item=Zentral.Wetter.Wetterstation.Temperatur, timeframe='day', start=95, end=0, group='', group2='', ignore_value_list=None, use_oldest_entry=False
2025-04-06  12:55:26 DEBUG    plugins.db_addon    Called with query="SELECT id, name, time, val_str, val_num, val_bool, changed FROM item WHERE name = 'Zentral.Wetter.Wetterstation.Temperatur'", params={}, cur=None
2025-04-06  12:55:26 DEBUG    plugins.db_addon    Connect to database.
2025-04-06  12:55:26 CRITICAL plugins.db_addon    Initialization of Database Connection failed: unable to open database file
2025-04-06  12:55:26 DEBUG    plugins.db_addon    Called with query='SELECT min(time) FROM log WHERE item_id = :item_id;', params={'item_id': None}, cur=None
2025-04-06  12:55:26 WARNING  plugins.db_addon    Database reconnect suppressed since last connection is less then 20sec ago.
2025-04-06  12:55:26 DEBUG    plugins.db_addon    _get_oldest_log for item=Zentral.Wetter.Wetterstation.Temperatur = None
2025-04-06  12:55:26 INFO     plugins.db_addon    no valid data from database query for item=Zentral.Wetter.Wetterstation.Temperatur received during _prepare_value_list. Aborting...
2025-04-06  12:55:26 DEBUG    plugins.db_addon    raw_value_list=None
2025-04-06  12:55:26 DEBUG    plugins.db_addon    result is None for item 'Zentral.Wetter.Wetterstation.Temperatur.Gruenlandtemperatursumme' with 'db_addon_fct='gruenlandtempsumme''
2025-04-06  12:55:26 INFO     plugins.db_addon      Result was None; No item value will be set.
2025-04-06  12:55:26 DEBUG    plugins.db_addon    queue_entry=Item: Zentral.Wetter.Wetterstation.Temperatur.Wachstumsgradtage
2025-04-06  12:55:26 INFO     plugins.db_addon    # 7 item(s) to do. || 'on-demand' item=Zentral.Wetter.Wetterstation.Temperatur.Wachstumsgradtage will be processed.
2025-04-06  12:55:26 DEBUG    plugins.db_addon    Item=Zentral.Wetter.Wetterstation.Temperatur.Wachstumsgradtage with item_config={'db_addon': 'function', 'db_addon_fct': 'wachstumsgradtage', 'database_item': Item: Zentral.Wetter.Wetterstation.Temperatur, 'query_params': {}, 'suspended': False, 'cat': 'summe', 'sub_cat': None, 'cycle': 'daily', 'on': 'demand', 'startup': True}
2025-04-06  12:55:26 DEBUG    plugins.db_addon    db_addon_fct='wachstumsgradtage' will _query_item with params={}.
2025-04-06  12:55:26 DEBUG    plugins.db_addon    func='wachstumsgradtage', database_item=Item: Zentral.Wetter.Wetterstation.Temperatur, year=None, month=None, params={}
2025-04-06  12:55:26 DEBUG    plugins.db_addon    try to get raw data
2025-04-06  12:55:26 DEBUG    plugins.db_addon    called with database_item=Zentral.Wetter.Wetterstation.Temperatur, timeframe='day', start=95, end=0, ignore_value_list=None, data_con_func='minmax_day'
2025-04-06  12:55:26 DEBUG    plugins.db_addon      called with func='raw', item=Zentral.Wetter.Wetterstation.Temperatur, timeframe='day', start=95, end=0, group='', group2='', ignore_value_list=None, use_oldest_entry=False
2025-04-06  12:55:26 DEBUG    plugins.db_addon    Called with query="SELECT id, name, time, val_str, val_num, val_bool, changed FROM item WHERE name = 'Zentral.Wetter.Wetterstation.Temperatur'", params={}, cur=None
2025-04-06  12:55:26 WARNING  plugins.db_addon    Database reconnect suppressed since last connection is less then 20sec ago.
2025-04-06  12:55:26 DEBUG    plugins.db_addon    Called with query='SELECT min(time) FROM log WHERE item_id = :item_id;', params={'item_id': None}, cur=None
2025-04-06  12:55:26 WARNING  plugins.db_addon    Database reconnect suppressed since last connection is less then 20sec ago.
2025-04-06  12:55:26 DEBUG    plugins.db_addon    _get_oldest_log for item=Zentral.Wetter.Wetterstation.Temperatur = None
2025-04-06  12:55:26 INFO     plugins.db_addon    no valid data from database query for item=Zentral.Wetter.Wetterstation.Temperatur received during _prepare_value_list. Aborting...
2025-04-06  12:55:26 DEBUG    plugins.db_addon    raw_value_list=None
2025-04-06  12:55:26 DEBUG    plugins.db_addon    result is None for item 'Zentral.Wetter.Wetterstation.Temperatur.Wachstumsgradtage' with 'db_addon_fct='wachstumsgradtage''
2025-04-06  12:55:26 INFO     plugins.db_addon      Result was None; No item value will be set.
2025-04-06  12:55:26 DEBUG    plugins.db_addon    queue_entry=Item: Zentral.Wetter.pluggit.Temperatur.Gruenlandtemperatursumme
2025-04-06  12:55:26 INFO     plugins.db_addon    # 6 item(s) to do. || 'on-demand' item=Zentral.Wetter.pluggit.Temperatur.Gruenlandtemperatursumme will be processed.
2025-04-06  12:55:26 DEBUG    plugins.db_addon    Item=Zentral.Wetter.pluggit.Temperatur.Gruenlandtemperatursumme with item_config={'db_addon': 'function', 'db_addon_fct': 'gruenlandtempsumme', 'database_item': Item: Zentral.Wetter.pluggit.Temperatur, 'query_params': {}, 'suspended': False, 'cat': 'summe', 'sub_cat': None, 'cycle': 'daily', 'on': 'demand', 'startup': True}
2025-04-06  12:55:26 DEBUG    plugins.db_addon    db_addon_fct='gruenlandtempsumme' will _query_item with params={}.
2025-04-06  12:55:26 DEBUG    plugins.db_addon    func='gruenlandtempsumme', database_item=Item: Zentral.Wetter.pluggit.Temperatur, year=None, month=None, params={}
2025-04-06  12:55:26 DEBUG    plugins.db_addon    try to get raw data
2025-04-06  12:55:26 DEBUG    plugins.db_addon    called with database_item=Zentral.Wetter.pluggit.Temperatur, timeframe='day', start=95, end=0, ignore_value_list=None, data_con_func='first_hour_avg_day'
2025-04-06  12:55:26 DEBUG    plugins.db_addon      called with func='raw', item=Zentral.Wetter.pluggit.Temperatur, timeframe='day', start=95, end=0, group='', group2='', ignore_value_list=None, use_oldest_entry=False
2025-04-06  12:55:26 DEBUG    plugins.db_addon    Called with query="SELECT id, name, time, val_str, val_num, val_bool, changed FROM item WHERE name = 'Zentral.Wetter.pluggit.Temperatur'", params={}, cur=None
2025-04-06  12:55:26 WARNING  plugins.db_addon    Database reconnect suppressed since last connection is less then 20sec ago.
2025-04-06  12:55:26 DEBUG    plugins.db_addon    Called with query='SELECT min(time) FROM log WHERE item_id = :item_id;', params={'item_id': None}, cur=None
2025-04-06  12:55:26 WARNING  plugins.db_addon    Database reconnect suppressed since last connection is less then 20sec ago.
2025-04-06  12:55:26 DEBUG    plugins.db_addon    _get_oldest_log for item=Zentral.Wetter.pluggit.Temperatur = None
2025-04-06  12:55:26 INFO     plugins.db_addon    no valid data from database query for item=Zentral.Wetter.pluggit.Temperatur received during _prepare_value_list. Aborting...
2025-04-06  12:55:26 DEBUG    plugins.db_addon    raw_value_list=None
2025-04-06  12:55:26 DEBUG    plugins.db_addon    result is None for item 'Zentral.Wetter.pluggit.Temperatur.Gruenlandtemperatursumme' with 'db_addon_fct='gruenlandtempsumme''
2025-04-06  12:55:26 INFO     plugins.db_addon      Result was None; No item value will be set.
2025-04-06  12:55:26 DEBUG    plugins.db_addon    queue_entry=Item: Zentral.Wetter.pluggit.Temperatur.Wachstumsgradtage
2025-04-06  12:55:26 INFO     plugins.db_addon    # 5 item(s) to do. || 'on-demand' item=Zentral.Wetter.pluggit.Temperatur.Wachstumsgradtage will be processed.
2025-04-06  12:55:26 DEBUG    plugins.db_addon    Item=Zentral.Wetter.pluggit.Temperatur.Wachstumsgradtage with item_config={'db_addon': 'function', 'db_addon_fct': 'wachstumsgradtage', 'database_item': Item: Zentral.Wetter.pluggit.Temperatur, 'query_params': {}, 'suspended': False, 'cat': 'summe', 'sub_cat': None, 'cycle': 'daily', 'on': 'demand', 'startup': True}
2025-04-06  12:55:26 DEBUG    plugins.db_addon    db_addon_fct='wachstumsgradtage' will _query_item with params={}.
2025-04-06  12:55:26 DEBUG    plugins.db_addon    func='wachstumsgradtage', database_item=Item: Zentral.Wetter.pluggit.Temperatur, year=None, month=None, params={}
2025-04-06  12:55:26 DEBUG    plugins.db_addon    try to get raw data
2025-04-06  12:55:26 DEBUG    plugins.db_addon    called with database_item=Zentral.Wetter.pluggit.Temperatur, timeframe='day', start=95, end=0, ignore_value_list=None, data_con_func='minmax_day'
2025-04-06  12:55:26 DEBUG    plugins.db_addon      called with func='raw', item=Zentral.Wetter.pluggit.Temperatur, timeframe='day', start=95, end=0, group='', group2='', ignore_value_list=None, use_oldest_entry=False
2025-04-06  12:55:26 DEBUG    plugins.db_addon    Called with query="SELECT id, name, time, val_str, val_num, val_bool, changed FROM item WHERE name = 'Zentral.Wetter.pluggit.Temperatur'", params={}, cur=None
2025-04-06  12:55:26 WARNING  plugins.db_addon    Database reconnect suppressed since last connection is less then 20sec ago.
2025-04-06  12:55:26 DEBUG    plugins.db_addon    Called with query='SELECT min(time) FROM log WHERE item_id = :item_id;', params={'item_id': None}, cur=None
2025-04-06  12:55:26 WARNING  plugins.db_addon    Database reconnect suppressed since last connection is less then 20sec ago.
2025-04-06  12:55:26 DEBUG    plugins.db_addon    _get_oldest_log for item=Zentral.Wetter.pluggit.Temperatur = None
2025-04-06  12:55:26 INFO     plugins.db_addon    no valid data from database query for item=Zentral.Wetter.pluggit.Temperatur received during _prepare_value_list. Aborting...
2025-04-06  12:55:26 DEBUG    plugins.db_addon    raw_value_list=None
2025-04-06  12:55:26 DEBUG    plugins.db_addon    result is None for item 'Zentral.Wetter.pluggit.Temperatur.Wachstumsgradtage' with 'db_addon_fct='wachstumsgradtage''
2025-04-06  12:55:26 INFO     plugins.db_addon      Result was None; No item value will be set.
2025-04-06  12:55:26 DEBUG    plugins.db_addon    queue_entry=Item: Zentral.Wetter.Wetterstation.Temperatur.Waermesumme
2025-04-06  12:55:26 INFO     plugins.db_addon    # 4 item(s) to do. || 'on-demand' item=Zentral.Wetter.Wetterstation.Temperatur.Waermesumme will be processed.
2025-04-06  12:55:26 DEBUG    plugins.db_addon    Item=Zentral.Wetter.Wetterstation.Temperatur.Waermesumme with item_config={'db_addon': 'function', 'db_addon_fct': 'waermesumme', 'database_item': Item: Zentral.Wetter.Wetterstation.Temperatur, 'query_params': {}, 'suspended': False, 'cat': 'summe', 'sub_cat': None, 'cycle': 'daily', 'on': 'demand', 'startup': True}
2025-04-06  12:55:26 DEBUG    plugins.db_addon    db_addon_fct='waermesumme' will _query_item with params={}.
2025-04-06  12:55:26 DEBUG    plugins.db_addon    func='waermesumme', database_item=Item: Zentral.Wetter.Wetterstation.Temperatur, year=None, month=None, params={}
2025-04-06  12:55:26 DEBUG    plugins.db_addon    try to get raw data
2025-04-06  12:55:26 DEBUG    plugins.db_addon    called with database_item=Zentral.Wetter.Wetterstation.Temperatur, timeframe='day', start=95, end=0, ignore_value_list=None, data_con_func='first_hour_avg_day'
2025-04-06  12:55:26 DEBUG    plugins.db_addon      called with func='raw', item=Zentral.Wetter.Wetterstation.Temperatur, timeframe='day', start=95, end=0, group='', group2='', ignore_value_list=None, use_oldest_entry=False
2025-04-06  12:55:26 DEBUG    plugins.db_addon    Called with query="SELECT id, name, time, val_str, val_num, val_bool, changed FROM item WHERE name = 'Zentral.Wetter.Wetterstation.Temperatur'", params={}, cur=None
2025-04-06  12:55:26 WARNING  plugins.db_addon    Database reconnect suppressed since last connection is less then 20sec ago.
2025-04-06  12:55:26 DEBUG    plugins.db_addon    Called with query='SELECT min(time) FROM log WHERE item_id = :item_id;', params={'item_id': None}, cur=None
2025-04-06  12:55:26 WARNING  plugins.db_addon    Database reconnect suppressed since last connection is less then 20sec ago.
2025-04-06  12:55:26 DEBUG    plugins.db_addon    _get_oldest_log for item=Zentral.Wetter.Wetterstation.Temperatur = None
2025-04-06  12:55:26 INFO     plugins.db_addon    no valid data from database query for item=Zentral.Wetter.Wetterstation.Temperatur received during _prepare_value_list. Aborting...
2025-04-06  12:55:26 DEBUG    plugins.db_addon    raw_value_list=None
2025-04-06  12:55:26 DEBUG    plugins.db_addon    result is None for item 'Zentral.Wetter.Wetterstation.Temperatur.Waermesumme' with 'db_addon_fct='waermesumme''
2025-04-06  12:55:26 INFO     plugins.db_addon      Result was None; No item value will be set.
2025-04-06  12:55:26 DEBUG    plugins.db_addon    queue_entry=Item: Zentral.Wetter.Wetterstation.Temperatur.Kaeltesumme
2025-04-06  12:55:26 INFO     plugins.db_addon    # 3 item(s) to do. || 'on-demand' item=Zentral.Wetter.Wetterstation.Temperatur.Kaeltesumme will be processed.
2025-04-06  12:55:26 DEBUG    plugins.db_addon    Item=Zentral.Wetter.Wetterstation.Temperatur.Kaeltesumme with item_config={'db_addon': 'function', 'db_addon_fct': 'kaeltesumme', 'database_item': Item: Zentral.Wetter.Wetterstation.Temperatur, 'query_params': {}, 'suspended': False, 'cat': 'summe', 'sub_cat': None, 'cycle': 'daily', 'on': 'demand', 'startup': True}
2025-04-06  12:55:26 DEBUG    plugins.db_addon    db_addon_fct='kaeltesumme' will _query_item with params={}.
2025-04-06  12:55:26 DEBUG    plugins.db_addon    func='kaeltesumme', database_item=Item: Zentral.Wetter.Wetterstation.Temperatur, year=None, month=None, params={}
2025-04-06  12:55:26 DEBUG    plugins.db_addon    try to get raw data
2025-04-06  12:55:26 DEBUG    plugins.db_addon    called with database_item=Zentral.Wetter.Wetterstation.Temperatur, timeframe='day', start=197, end=15, ignore_value_list=None, data_con_func='first_hour_avg_day'
2025-04-06  12:55:26 DEBUG    plugins.db_addon      called with func='raw', item=Zentral.Wetter.Wetterstation.Temperatur, timeframe='day', start=197, end=15, group='', group2='', ignore_value_list=None, use_oldest_entry=False
2025-04-06  12:55:26 DEBUG    plugins.db_addon    Called with query="SELECT id, name, time, val_str, val_num, val_bool, changed FROM item WHERE name = 'Zentral.Wetter.Wetterstation.Temperatur'", params={}, cur=None
2025-04-06  12:55:26 WARNING  plugins.db_addon    Database reconnect suppressed since last connection is less then 20sec ago.
2025-04-06  12:55:26 DEBUG    plugins.db_addon    Called with query='SELECT min(time) FROM log WHERE item_id = :item_id;', params={'item_id': None}, cur=None
2025-04-06  12:55:26 WARNING  plugins.db_addon    Database reconnect suppressed since last connection is less then 20sec ago.
2025-04-06  12:55:26 DEBUG    plugins.db_addon    _get_oldest_log for item=Zentral.Wetter.Wetterstation.Temperatur = None
2025-04-06  12:55:26 INFO     plugins.db_addon    no valid data from database query for item=Zentral.Wetter.Wetterstation.Temperatur received during _prepare_value_list. Aborting...
2025-04-06  12:55:26 DEBUG    plugins.db_addon    raw_value_list=None
2025-04-06  12:55:26 DEBUG    plugins.db_addon    result is None for item 'Zentral.Wetter.Wetterstation.Temperatur.Kaeltesumme' with 'db_addon_fct='kaeltesumme''
2025-04-06  12:55:26 INFO     plugins.db_addon      Result was None; No item value will be set.
2025-04-06  12:55:26 DEBUG    plugins.db_addon    queue_entry=Item: Zentral.Wetter.pluggit.Temperatur.Waermesumme
2025-04-06  12:55:26 INFO     plugins.db_addon    # 2 item(s) to do. || 'on-demand' item=Zentral.Wetter.pluggit.Temperatur.Waermesumme will be processed.
2025-04-06  12:55:26 DEBUG    plugins.db_addon    Item=Zentral.Wetter.pluggit.Temperatur.Waermesumme with item_config={'db_addon': 'function', 'db_addon_fct': 'waermesumme', 'database_item': Item: Zentral.Wetter.pluggit.Temperatur, 'query_params': {}, 'suspended': False, 'cat': 'summe', 'sub_cat': None, 'cycle': 'daily', 'on': 'demand', 'startup': True}
2025-04-06  12:55:26 DEBUG    plugins.db_addon    db_addon_fct='waermesumme' will _query_item with params={}.
2025-04-06  12:55:26 DEBUG    plugins.db_addon    func='waermesumme', database_item=Item: Zentral.Wetter.pluggit.Temperatur, year=None, month=None, params={}
2025-04-06  12:55:26 DEBUG    plugins.db_addon    try to get raw data
2025-04-06  12:55:26 DEBUG    plugins.db_addon    called with database_item=Zentral.Wetter.pluggit.Temperatur, timeframe='day', start=95, end=0, ignore_value_list=None, data_con_func='first_hour_avg_day'
2025-04-06  12:55:26 DEBUG    plugins.db_addon      called with func='raw', item=Zentral.Wetter.pluggit.Temperatur, timeframe='day', start=95, end=0, group='', group2='', ignore_value_list=None, use_oldest_entry=False
2025-04-06  12:55:26 DEBUG    plugins.db_addon    Called with query="SELECT id, name, time, val_str, val_num, val_bool, changed FROM item WHERE name = 'Zentral.Wetter.pluggit.Temperatur'", params={}, cur=None
2025-04-06  12:55:26 WARNING  plugins.db_addon    Database reconnect suppressed since last connection is less then 20sec ago.
2025-04-06  12:55:26 DEBUG    plugins.db_addon    Called with query='SELECT min(time) FROM log WHERE item_id = :item_id;', params={'item_id': None}, cur=None
2025-04-06  12:55:26 WARNING  plugins.db_addon    Database reconnect suppressed since last connection is less then 20sec ago.
2025-04-06  12:55:26 DEBUG    plugins.db_addon    _get_oldest_log for item=Zentral.Wetter.pluggit.Temperatur = None
2025-04-06  12:55:26 INFO     plugins.db_addon    no valid data from database query for item=Zentral.Wetter.pluggit.Temperatur received during _prepare_value_list. Aborting...
2025-04-06  12:55:26 DEBUG    plugins.db_addon    raw_value_list=None
2025-04-06  12:55:26 DEBUG    plugins.db_addon    result is None for item 'Zentral.Wetter.pluggit.Temperatur.Waermesumme' with 'db_addon_fct='waermesumme''
2025-04-06  12:55:26 INFO     plugins.db_addon      Result was None; No item value will be set.
2025-04-06  12:55:26 DEBUG    plugins.db_addon    queue_entry=Item: Zentral.Wetter.pluggit.Temperatur.Kaeltesumme
2025-04-06  12:55:26 INFO     plugins.db_addon    # 1 item(s) to do. || 'on-demand' item=Zentral.Wetter.pluggit.Temperatur.Kaeltesumme will be processed.
2025-04-06  12:55:26 DEBUG    plugins.db_addon    Item=Zentral.Wetter.pluggit.Temperatur.Kaeltesumme with item_config={'db_addon': 'function', 'db_addon_fct': 'kaeltesumme', 'database_item': Item: Zentral.Wetter.pluggit.Temperatur, 'query_params': {}, 'suspended': False, 'cat': 'summe', 'sub_cat': None, 'cycle': 'daily', 'on': 'demand', 'startup': True}
2025-04-06  12:55:26 DEBUG    plugins.db_addon    db_addon_fct='kaeltesumme' will _query_item with params={}.
2025-04-06  12:55:26 DEBUG    plugins.db_addon    func='kaeltesumme', database_item=Item: Zentral.Wetter.pluggit.Temperatur, year=None, month=None, params={}
2025-04-06  12:55:26 DEBUG    plugins.db_addon    try to get raw data
2025-04-06  12:55:26 DEBUG    plugins.db_addon    called with database_item=Zentral.Wetter.pluggit.Temperatur, timeframe='day', start=197, end=15, ignore_value_list=None, data_con_func='first_hour_avg_day'
2025-04-06  12:55:26 DEBUG    plugins.db_addon      called with func='raw', item=Zentral.Wetter.pluggit.Temperatur, timeframe='day', start=197, end=15, group='', group2='', ignore_value_list=None, use_oldest_entry=False
2025-04-06  12:55:26 DEBUG    plugins.db_addon    Called with query="SELECT id, name, time, val_str, val_num, val_bool, changed FROM item WHERE name = 'Zentral.Wetter.pluggit.Temperatur'", params={}, cur=None
2025-04-06  12:55:26 WARNING  plugins.db_addon    Database reconnect suppressed since last connection is less then 20sec ago.
2025-04-06  12:55:26 DEBUG    plugins.db_addon    Called with query='SELECT min(time) FROM log WHERE item_id = :item_id;', params={'item_id': None}, cur=None
2025-04-06  12:55:26 WARNING  plugins.db_addon    Database reconnect suppressed since last connection is less then 20sec ago.
2025-04-06  12:55:26 DEBUG    plugins.db_addon    _get_oldest_log for item=Zentral.Wetter.pluggit.Temperatur = None
2025-04-06  12:55:26 INFO     plugins.db_addon    no valid data from database query for item=Zentral.Wetter.pluggit.Temperatur received during _prepare_value_list. Aborting...
2025-04-06  12:55:26 DEBUG    plugins.db_addon    raw_value_list=None
2025-04-06  12:55:26 DEBUG    plugins.db_addon    result is None for item 'Zentral.Wetter.pluggit.Temperatur.Kaeltesumme' with 'db_addon_fct='kaeltesumme''
2025-04-06  12:55:26 INFO     plugins.db_addon      Result was None; No item value will be set.
2025-04-06  12:55:38 INFO     plugins.db_addon    + Updated item 'Zentral.Wetter.Wetterstation.Temperatur' with value 7.1 is now due to be put to queue for processing. 1 items to do.
2025-04-06  12:55:38 INFO     plugins.db_addon    + Updated item 'Zentral.Wetter.pluggit.Temperatur' with value 9.98 is now due to be put to queue for processing. 2 items to do.
2025-04-06  12:55:38 DEBUG    plugins.db_addon    queue_entry=(Item: Zentral.Wetter.Wetterstation.Temperatur, 7.1)
2025-04-06  12:55:38 INFO     plugins.db_addon    + Updated item 'Zentral.Wetter.pluggit.Temperatur' with value 9.98 is now due to be put to queue for processing. 2 items to do.
2025-04-06  12:55:38 INFO     plugins.db_addon    # 2 item(s) to do. || 'onchange' item=Zentral.Wetter.Wetterstation.Temperatur with value=7.1 will be processed.
2025-04-06  12:55:38 INFO     plugins.db_addon    + Updated item 'Zentral.Wetter.pluggit.Temperatur' with value 9.98 is now due to be put to queue for processing. 3 items to do.
2025-04-06  12:55:38 DEBUG    plugins.db_addon    called with updated_item=Zentral.Wetter.Wetterstation.Temperatur and value=7.1.
2025-04-06  12:55:38 INFO     plugins.db_addon    + Updated item 'Zentral.Wetter.pluggit.Temperatur' with value 9.98 is now due to be put to queue for processing. 4 items to do.
2025-04-06  12:55:38 DEBUG    plugins.db_addon    Following items where identified for update: set().
2025-04-06  12:55:38 INFO     plugins.db_addon    + Updated item 'Zentral.Wetter.pluggit.Temperatur' with value 9.98 is now due to be put to queue for processing. 5 items to do.
2025-04-06  12:55:38 DEBUG    plugins.db_addon    queue_entry=(Item: Zentral.Wetter.pluggit.Temperatur, 10.68)
2025-04-06  12:55:38 INFO     plugins.db_addon    + Updated item 'Zentral.Wetter.pluggit.Temperatur' with value 9.98 is now due to be put to queue for processing. 5 items to do.
2025-04-06  12:55:38 INFO     plugins.db_addon    # 5 item(s) to do. || 'onchange' item=Zentral.Wetter.pluggit.Temperatur with value=10.68 will be processed.
2025-04-06  12:55:38 DEBUG    plugins.db_addon    called with updated_item=Zentral.Wetter.pluggit.Temperatur and value=10.68.
2025-04-06  12:55:38 DEBUG    plugins.db_addon    Following items where identified for update: set().
2025-04-06  12:55:38 DEBUG    plugins.db_addon    queue_entry=(Item: Zentral.Wetter.pluggit.Temperatur, 10.64)
2025-04-06  12:55:38 INFO     plugins.db_addon    # 5 item(s) to do. || 'onchange' item=Zentral.Wetter.pluggit.Temperatur with value=10.64 will be processed.
2025-04-06  12:55:38 DEBUG    plugins.db_addon    called with updated_item=Zentral.Wetter.pluggit.Temperatur and value=10.64.
2025-04-06  12:55:38 DEBUG    plugins.db_addon    Following items where identified for update: set().
2025-04-06  12:55:38 DEBUG    plugins.db_addon    queue_entry=(Item: Zentral.Wetter.pluggit.Temperatur, 10.78)
2025-04-06  12:55:38 INFO     plugins.db_addon    # 4 item(s) to do. || 'onchange' item=Zentral.Wetter.pluggit.Temperatur with value=10.78 will be processed.
2025-04-06  12:55:38 DEBUG    plugins.db_addon    called with updated_item=Zentral.Wetter.pluggit.Temperatur and value=10.78.
2025-04-06  12:55:38 DEBUG    plugins.db_addon    Following items where identified for update: set().
2025-04-06  12:55:38 DEBUG    plugins.db_addon    queue_entry=(Item: Zentral.Wetter.pluggit.Temperatur, 10.36)
2025-04-06  12:55:38 INFO     plugins.db_addon    # 3 item(s) to do. || 'onchange' item=Zentral.Wetter.pluggit.Temperatur with value=10.36 will be processed.
2025-04-06  12:55:38 DEBUG    plugins.db_addon    called with updated_item=Zentral.Wetter.pluggit.Temperatur and value=10.36.
2025-04-06  12:55:38 DEBUG    plugins.db_addon    Following items where identified for update: set().
2025-04-06  12:55:38 DEBUG    plugins.db_addon    queue_entry=(Item: Zentral.Wetter.pluggit.Temperatur, 9.93)
2025-04-06  12:55:38 INFO     plugins.db_addon    # 2 item(s) to do. || 'onchange' item=Zentral.Wetter.pluggit.Temperatur with value=9.93 will be processed.
2025-04-06  12:55:38 DEBUG    plugins.db_addon    called with updated_item=Zentral.Wetter.pluggit.Temperatur and value=9.93.
2025-04-06  12:55:38 DEBUG    plugins.db_addon    Following items where identified for update: set().
2025-04-06  12:55:38 DEBUG    plugins.db_addon    queue_entry=(Item: Zentral.Wetter.pluggit.Temperatur, 9.98)
2025-04-06  12:55:38 INFO     plugins.db_addon    # 1 item(s) to do. || 'onchange' item=Zentral.Wetter.pluggit.Temperatur with value=9.98 will be processed.
2025-04-06  12:55:38 DEBUG    plugins.db_addon    called with updated_item=Zentral.Wetter.pluggit.Temperatur and value=9.98.
2025-04-06  12:55:38 DEBUG    plugins.db_addon    Following items where identified for update: set().
2025-04-06  12:55:46 DEBUG    plugins.db_addon     Updated Item Zentral.Wetter.pluggit.Temperatur with value 9.96 will be put to queue in approx. 30s resp. after startup.
2025-04-06  12:56:05 DEBUG    plugins.db_addon     Updated Item Zentral.Wetter.Wetterstation.Temperatur with value 6.6 will be put to queue in approx. 30s resp. after startup.
2025-04-06  12:56:08 DEBUG    plugins.db_addon    Remaining 2 items in deque are not due, yet.
2025-04-06  12:56:36 DEBUG    plugins.db_addon     Updated Item Zentral.Wetter.pluggit.Temperatur with value 10.04 will be put to queue in approx. 30s resp. after startup.
2025-04-06  12:56:39 INFO     plugins.db_addon    + Updated item 'Zentral.Wetter.pluggit.Temperatur' with value 10.04 is now due to be put to queue for processing. 1 items to do.
2025-04-06  12:56:39 INFO     plugins.db_addon    + Updated item 'Zentral.Wetter.Wetterstation.Temperatur' with value 6.6 is now due to be put to queue for processing. 2 items to do.
2025-04-06  12:56:39 DEBUG    plugins.db_addon    Remaining 1 items in deque are not due, yet.
2025-04-06  12:56:39 DEBUG    plugins.db_addon    queue_entry=(Item: Zentral.Wetter.pluggit.Temperatur, 9.96)
2025-04-06  12:56:39 INFO     plugins.db_addon    # 2 item(s) to do. || 'onchange' item=Zentral.Wetter.pluggit.Temperatur with value=9.96 will be processed.
2025-04-06  12:56:39 DEBUG    plugins.db_addon    called with updated_item=Zentral.Wetter.pluggit.Temperatur and value=9.96.
2025-04-06  12:56:39 DEBUG    plugins.db_addon    Following items where identified for update: set().
2025-04-06  12:56:39 DEBUG    plugins.db_addon    queue_entry=(Item: Zentral.Wetter.Wetterstation.Temperatur, 6.6)
2025-04-06  12:56:39 INFO     plugins.db_addon    # 1 item(s) to do. || 'onchange' item=Zentral.Wetter.Wetterstation.Temperatur with value=6.6 will be processed.
2025-04-06  12:56:39 DEBUG    plugins.db_addon    called with updated_item=Zentral.Wetter.Wetterstation.Temperatur and value=6.6.
2025-04-06  12:56:39 DEBUG    plugins.db_addon    Following items where identified for update: set().
2025-04-06  12:57:09 INFO     plugins.db_addon    + Updated item 'Zentral.Wetter.pluggit.Temperatur' with value 10.04 is now due to be put to queue for processing. 1 items to do.
2025-04-06  12:57:09 DEBUG    plugins.db_addon    queue_entry=(Item: Zentral.Wetter.pluggit.Temperatur, 10.04)
2025-04-06  12:57:09 INFO     plugins.db_addon    # 1 item(s) to do. || 'onchange' item=Zentral.Wetter.pluggit.Temperatur with value=10.04 will be processed.
2025-04-06  12:57:09 DEBUG    plugins.db_addon    called with updated_item=Zentral.Wetter.pluggit.Temperatur and value=10.04.
2025-04-06  12:57:09 DEBUG    plugins.db_addon    Following items where identified for update: set().​

Hilt das irgendwie?

[Sisamiwe]

Ich habe es genau da geändert und dann SmartHomeNG neu gestartet

Die Änderung dort gehen sofort "produktiv".

Du könntest mal testweise den speziell für dieses Plugin definierten Logger aus der logging.yaml zu löschen oder auch mal das Logging auf Default setzen. Dazu den Inhalt von logging.yaml.default in logging.yaml kopieren.

[Cannon]

Hast die mal den LogLevel in der shNG Laufzeit über das AdminIF im Reiter Logging --> Logger Konfiguration verändert?

Ich habe es genau da geändert und dann SmartHomeNG neu gestartet, weil ich nicht sicher war, dass das auch ohne Neustart übernommen wird.

[Sisamiwe]

Standardmäßig ist Level INFO eingestellt. Ich bekomme dann einen Fehler beim Start

Hallo Cannon

ich habe das versucht an 2 Systemen nachzustellen, leider nicht erfolgreich. Auch im Code selbst kann ich keine Stelle finden, die solch ein Verhalten auslöst.
Hast die mal den LogLevel in der shNG Laufzeit über das AdminIF im Reiter Logging --> Logger Konfiguration verändert?

Onkelandy
Hast Du hier noch eine Idee?

[Cannon]

Ich habe das Plugin jetzt eine ganze Weile nicht genutzt, weil ich SmartHomeNG Master nutze und das Plugin nicht so richtig ging und die Developer-Version lief mit dem SmartHomeNG Master 1.10 nicht. Jetzt habe ich auf 1.11 geupdatet und wollte es wieder aktivieren. Allerdings habe ich ein paar Probleme, die irgendwie mit dem Logger zusammenzuhängen scheinen:

Standardmäßig ist Level INFO eingestellt. Ich bekomme dann einen Fehler beim Start

CRITICAL plugins.db_addon    Initialization of Database Connection failed: unable to open database file

Logischerweise wollte ich den Logger dann anschalten, habe also auf DEBUG gestellt. Er macht eine ganze Menge Ausgaben, aber alles funktioniert.

Dann wollte ich das ganze mehrfach nachvollziehen, weil ich mir kaum erklären kann, dass es am Logger liegen kann. Aber auch hier wieder, sobald ich auf INFO umstelle, funktioniert das Plugin nicht.

Aktuell ist wieder auf DEBUG eingestellt (im WebIF steht da 10) es läuft. Aber die ewig langen Logs sind natürlich keine Lösung.