Wenn dies dein erster Besuch hier ist, lies bitte zuerst die Hilfe - Häufig gestellte Fragen durch. Du musst dich vermutlich registrieren, bevor du Beiträge verfassen kannst. Klicke oben auf 'Registrieren', um den Registrierungsprozess zu starten. Du kannst auch jetzt schon Beiträge lesen. Suche dir einfach das Forum aus, das dich am meisten interessiert.
Die Berechnung wird dann immer täglich ausgeführt.
Ich habe am Plugin diverse Dinge geändert / ergänzt / repariert. Du kannst gern mal testen, bevor ich den PR stelle. Siehe hier:
Danke nochmal!
Ich habe das mal bei mir eingesetzt. Funktioniert zumindest bei der initialen Ausführung wunderbar.
Aber ist die Umsetzung jetzt auch "onchange"? (konnte ich noch nicht überprüfen ...). Im WebIF steht da jetzt überall 'täglich'.
Das müsstest Du noch etwas beobachten. Da das Plugin nur auf die Werte der Datenbank zugreift und den Cache des Datenbank-Plugins nicht kennt, kommt es immer zu Verzögerungen in der Auswertung.
Schau mal im Log, ob die Berechnung gar nicht gestartet wird oder das "falsche" Ergebnis errechnet wird.
Das Problem, dass ich für 'minmax_Tag_min' häufiger mal ganztägig den Wert '0' habe, besteht übrigens weiterhin.
Hier aus dem Debug mal ein Beispiel einer Berechnung kurz nach Mitternacht. Der Wert wird dann im Laufe des Tages nicht mehr aktualisiert, d.h., er bleibt immer auf '0'. So habe ich einige Beipiele im log:
Code:
2024-08-04 00:21:28 DEBUG plugins.db_addon Item=temperatur.toilette.min1d with item_config={'db_addon': 'function', 'db_addon_fct': 'minmax_tag_min', 'database_item': Item: EG.Toilette.Heizung.temperatur, 'query_params': {'func': 'min', 'timeframe': 'day', 'start': 0, 'end': 0}, 'suspended': False, 'database_item_path': True, 'cycle': None, 'on': 'change', 'startup': False, 'value': 25.1}
2024-08-04 00:21:28 DEBUG plugins.db_addon 'minmax' Item=EG.Toilette.Heizung.temperatur with func='min' and timeframe='day' detected. Check for update of cache_dicts cache_dict={Item: OG.GaesteAnkl.Heizung.temperatur: {'max': 25.8, 'min': 25.7}, Item: DG.Schlafzimmer.Heizung.temperatur: {'min': 26.8, 'max': 27.0}, Item: EG.Buero.Heizung.temperatur: {'min': 24.9, 'max': 25.0}, Item: DG.Bad.Heizung.temperatur: {'min': 26.8, 'max': 27.0}, Item: paradigma.Aussentemperatur: {'max': 18.1, 'min': 18.1}} and item value.
2024-08-04 00:21:28 DEBUG plugins.db_addon min value for timeframe='day' of item=EG.Toilette.Heizung.temperatur not in cache dict. Query database.
2024-08-04 00:21:28 DEBUG plugins.db_addon called with func='min', item=EG.Toilette.Heizung.temperatur, timeframe='day', start=0, end=0, group='', group2='', ignore_value_list=None, use_oldest_entry=True
2024-08-04 00:21:28 DEBUG plugins.db_addon _get_oldest_log for item=EG.Toilette.Heizung.temperatur = 1713653586849
2024-08-04 00:21:28 DEBUG plugins.db_addon Requested timeframe='day' with start=0 and end=0 resulted in start being timestamp=1722722400000/2024-08-04 00:00:00 and end being timestamp=1722808800000/2024-08-05 00:00:00
2024-08-04 00:21:28 DEBUG plugins.db_addon Called with func='min', item_id=15, ts_start=1722722400000, ts_end=1722808800000, group='', group2='', ignore_value_list=None
2024-08-04 00:21:28 DEBUG plugins.db_addon query='SELECT time, MIN(val_num) as value FROM log WHERE item_id = :item_id AND time BETWEEN :ts_start AND :ts_end AND val_bool = 1', params={'item_id': 15, 'ts_start': 1722722400000, 'ts_end': 1722808800000}
2024-08-04 00:21:28 DEBUG plugins.db_addon Called with query='SELECT time, MIN(val_num) as value FROM log WHERE item_id = :item_id AND time BETWEEN :ts_start AND :ts_end AND val_bool = 1', params={'item_id': 15, 'ts_start': 1722722400000, 'ts_end': 1722808800000}, cur=None
2024-08-04 00:21:28 DEBUG plugins.db_addon Result of query=SELECT time, MIN(val_num) as value FROM log WHERE item_id = 15 AND time BETWEEN 1722722400000 AND 1722808800000 AND val_bool = 1: [(None, None)]
2024-08-04 00:21:28 DEBUG plugins.db_addon result of '_query_log_timestamp' query_result=[(None, None)]
2024-08-04 00:21:28 DEBUG plugins.db_addon value for item=EG.Toilette.Heizung.temperatur with query_params={'func': 'min', 'item_id': 15, 'ts_start': 1722722400000, 'ts_end': 1722808800000, 'group': '', 'group2': '', 'ignore_value_list': None}: []
2024-08-04 00:21:28 INFO plugins.db_addon No values for item=EG.Toilette.Heizung.temperatur in requested timeframe between 1722722400000/2024-08-04 00:00:00 and 1722808800000/2024-08-05 00:00:00 in database found.
2024-08-04 00:21:28 DEBUG plugins.db_addon initial min value for timeframe='day' of item=temperatur.toilette.min1d with will be set to 0
2024-08-04 00:21:28 INFO plugins.db_addon Item value for 'temperatur.toilette.min1d' with func=min will be set to 0
BTW, bei den anderen Berechnungen ('minmax_woche_min, minmax_monat_min, ...) habe ich vereinzelt auch schon beobachtet.
Ein Hinweis: Wenn Du das Log des Plugin auf Debug stellt bekommst Du sehr viele Infomationen darüber, was das Plugin im Hintergrund tut. Da werden auch u.a. auch die Abfragezeiträume ausgegeben. Könntest Du dir das mal anschauen?
ooUrmeloo hatte mir auch schon ein paar Bugs genannt. Daher gibt es in meinem Repo bereits in Update. Könntest Du das auch testen?
Siehe hier
Beste Grüße
Hallo Sisamiwe,
habe die neuese Version genommen und auch auf MySql umgestellt. Alerdings brachte es.
Folgend mal ein Logauszug beim Manuellen Triggern.
2024-08-09 07:52:10 INFO plugins.db_addon Item value for 'EHZ.Strom.verbrauch_tag' will be set to 1080
>> Passt der Wert 2024-08-09 07:53:34 INFO plugins.db_addon Item value for 'EHZ.Strom.verbrauch_tag' with func=None will be set to 7032
>> Wird der Wert dann wieder überschrieben !
Danke für deinen Bemühungen
don Received db_addon cmd='recalc_item' for item_path='EHZ.Strom.verbrauch_tag' via web interface
2024-08-09 07:52:10 INFO plugins.db_addon Recalc of item=EHZ.Strom.verbrauch_tag called via WebIF. Item put to Queue for new calculation.
2024-08-09 07:52:10 DEBUG plugins.db_addon execute_items called with option='item'
2024-08-09 07:52:10 INFO plugins.db_addon 1 items will be calculated for option='item'.
2024-08-09 07:52:10 DEBUG plugins.db_addon Items to be calculated: todo_items=[Item: EHZ.Strom.verbrauch_tag]
2024-08-09 07:52:10 DEBUG plugins.db_addon Result for web interface: True
2024-08-09 07:52:10 DEBUG plugins.db_addon queue_entry=Item: EHZ.Strom.verbrauch_tag
2024-08-09 07:52:10 INFO plugins.db_addon # 1 item(s) to do. || 'on-demand' item=EHZ.Strom.verbrauch_tag will be processed.
2024-08-09 07:52:10 DEBUG plugins.db_addon Item=EHZ.Strom.verbrauch_tag with item_config={'db_addon': 'function', 'db_addon_fct': 'verbrauch_tag', 'database_item': Item: EHZ.Strom, 'query_params': {'timeframe': 'day', 'start': 0, 'end': 0}, 'suspended': False, 'cat': 'verbrauch', 'sub_cat': 'onchange', 'cycle': None, 'on': 'change', 'startup': True, 'value': 7031}
2024-08-09 07:52:10 DEBUG plugins.db_addon db_addon_fct='verbrauch_tag' will _query_item with params={'timeframe': 'day', 'start': 0, 'end': 0, 'database_item': Item: EHZ.Strom}.
2024-08-09 07:52:10 DEBUG plugins.db_addon called with query_params={'timeframe': 'day', 'start': 0, 'end': 0, 'database_item': Item: EHZ.Strom}
2024-08-09 07:52:10 DEBUG plugins.db_addon called with func='last', item=EHZ.Strom, timeframe='day', start=0, end=0, group='', group2='', ignore_value_list=None, use_oldest_entry=False
2024-08-09 07:52:10 DEBUG plugins.db_addon _get_oldest_log for item=EHZ.Strom = 1715205634678
2024-08-09 07:52:10 DEBUG plugins.db_addon Requested timeframe='day' with start=0 and end=0 resulted in start being timestamp=1723154400000/2024-08-09 00:00:00 and end being timestamp=1723240800000/2024-08-10 00:00:00
2024-08-09 07:52:10 DEBUG plugins.db_addon Called with func='last', item_id=13, ts_start=1723154400000, ts_end=1723240800000, group='', group2='', ignore_value_list=None
2024-08-09 07:52:10 DEBUG plugins.db_addon query='SELECT time, val_num as value FROM log WHERE item_id = :item_id AND time BETWEEN :ts_start AND :ts_end ORDER BY time DESC LIMIT 1', params={'item_id': 13, 'ts_start': 1723154400000, 'ts_end': 1723240800000}
2024-08-09 07:52:10 DEBUG plugins.db_addon Called with query='SELECT time, val_num as value FROM log WHERE item_id = :item_id AND time BETWEEN :ts_start AND :ts_end ORDER BY time DESC LIMIT 1', params={'item_id': 13, 'ts_start': 1723154400000, 'ts_end': 1723240800000}, cur=None
2024-08-09 07:52:10 DEBUG plugins.db_addon Result of query=SELECT time, val_num as value FROM log WHERE item_id = 13 AND time BETWEEN 1723154400000 AND 1723240800000 ORDER BY time DESC LIMIT 1: ((1723182682951, 17017680.0),)
2024-08-09 07:52:10 DEBUG plugins.db_addon result of '_query_log_timestamp' query_result=[(1723182682951, 17017680.0)]
2024-08-09 07:52:10 DEBUG plugins.db_addon value for item=EHZ.Strom with query_params={'func': 'last', 'item_id': 13, 'ts_start': 1723154400000, 'ts_end': 1723240800000, 'group': '', 'group2': '', 'ignore_value_list': None}: [[1723182682951, 17017680.0]]
2024-08-09 07:52:10 DEBUG plugins.db_addon value_end=17017680.0
2024-08-09 07:52:10 DEBUG plugins.db_addon called with func='next', item=EHZ.Strom, timeframe='day', start=0, end=0, group='', group2='', ignore_value_list=None, use_oldest_entry=False
2024-08-09 07:52:10 DEBUG plugins.db_addon _get_oldest_log for item=EHZ.Strom = 1715205634678
2024-08-09 07:52:10 DEBUG plugins.db_addon Requested timeframe='day' with start=0 and end=0 resulted in start being timestamp=1723154400000/2024-08-09 00:00:00 and end being timestamp=1723240800000/2024-08-10 00:00:00
2024-08-09 07:52:10 DEBUG plugins.db_addon Called with func='next', item_id=13, ts_start=1723154400000, ts_end=1723240800000, group='', group2='', ignore_value_list=None
2024-08-09 07:52:10 DEBUG plugins.db_addon query='SELECT time, val_num as value FROM log WHERE item_id = :item_id AND time <= :ts_start ORDER BY time DESC LIMIT 1', params={'item_id': 13, 'ts_start': 1723154400000}
2024-08-09 07:52:10 DEBUG plugins.db_addon Called with query='SELECT time, val_num as value FROM log WHERE item_id = :item_id AND time <= :ts_start ORDER BY time DESC LIMIT 1', params={'item_id': 13, 'ts_start': 1723154400000}, cur=None
2024-08-09 07:52:10 DEBUG plugins.db_addon Result of query=SELECT time, val_num as value FROM log WHERE item_id = 13 AND time <= 1723154400000 ORDER BY time DESC LIMIT 1: ((1723154396909, 17016600.0),)
2024-08-09 07:52:10 DEBUG plugins.db_addon result of '_query_log_timestamp' query_result=[(1723154396909, 17016600.0)]
2024-08-09 07:52:10 DEBUG plugins.db_addon value for item=EHZ.Strom with query_params={'func': 'next', 'item_id': 13, 'ts_start': 1723154400000, 'ts_end': 1723240800000, 'group': '', 'group2': '', 'ignore_value_list': None}: [[1723154396909, 17016600.0]]
2024-08-09 07:52:10 DEBUG plugins.db_addon value_start=17016600.0
2024-08-09 07:52:10 DEBUG plugins.db_addon consumption=1080
2024-08-09 07:52:10 DEBUG plugins.db_addon result is 1080 for item 'EHZ.Strom.verbrauch_tag' with 'db_addon_fct='verbrauch_tag'' 2024-08-09 07:52:10 INFO plugins.db_addon Item value for 'EHZ.Strom.verbrauch_tag' will be set to 1080
2024-08-09 07:53:34 INFO plugins.db_addon # 2 item(s) to do. || 'onchange' item=EHZ.Strom with value=17017681 will be processed.
2024-08-09 07:53:34 DEBUG plugins.db_addon called with updated_item=EHZ.Strom and value=17017681.
2024-08-09 07:53:34 DEBUG plugins.db_addon Following items where identified for update: {Item: EHZ.Strom.verbrauch_woche, Item: EHZ.Strom.verbrauch_jahr, Item: EHZ.Strom.verbrauch_tag, Item: EHZ.Strom.verbrauch_monat}.
2024-08-09 07:53:34 DEBUG plugins.db_addon Item=EHZ.Strom.verbrauch_woche with item_config={'db_addon': 'function', 'db_addon_fct': 'verbrauch_woche', 'database_item': Item: EHZ.Strom, 'query_params': {'timeframe': 'week', 'start': 0, 'end': 0}, 'suspended': False, 'cat': 'verbrauch', 'sub_cat': 'onchange', 'cycle': None, 'on': 'change', 'startup': True, 'value': 46456}
2024-08-09 07:53:34 DEBUG plugins.db_addon 'verbrauch' item EHZ.Strom with func=None and value=17017681 detected. Check for update of cache_dicts cache_dict={Item: EHZ.Strom: 16971224, Item: EHZ.UMG604ModBus.PVWirkArbeit: 2451196.5, Item: EHZ.UMG604ModBus.GesWirkArbeit: 1547687.12, Item: waerme.Waerme_dict.energy: 21272} and item value.
2024-08-09 07:53:34 INFO plugins.db_addon Item value for 'EHZ.Strom.verbrauch_woche' with func=None will be set to 46457
2024-08-09 07:53:34 DEBUG plugins.db_addon Item=EHZ.Strom.verbrauch_jahr with item_config={'db_addon': 'function', 'db_addon_fct': 'verbrauch_jahr', 'database_item': Item: EHZ.Strom, 'query_params': {'timeframe': 'year', 'start': 0, 'end': 0}, 'suspended': False, 'cat': 'verbrauch', 'sub_cat': 'onchange', 'cycle': None, 'on': 'change', 'startup': True, 'value': 17017680}
2024-08-09 07:53:34 DEBUG plugins.db_addon 'verbrauch' item EHZ.Strom with func=None and value=17017681 detected. Check for update of cache_dicts cache_dict={Item: EHZ.UMG604ModBus.PVWirkArbeit: 0, Item: EHZ.UMG604ModBus.GesWirkArbeit: 0, Item: EHZ.Strom: 0, Item: waerme.Waerme_dict.energy: 0} and item value.
2024-08-09 07:53:34 INFO plugins.db_addon Item value for 'EHZ.Strom.verbrauch_jahr' with func=None will be set to 17017681
2024-08-09 07:53:34 DEBUG plugins.db_addon Item=EHZ.Strom.verbrauch_tag with item_config={'db_addon': 'function', 'db_addon_fct': 'verbrauch_tag', 'database_item': Item: EHZ.Strom, 'query_params': {'timeframe': 'day', 'start': 0, 'end': 0}, 'suspended': False, 'cat': 'verbrauch', 'sub_cat': 'onchange', 'cycle': None, 'on': 'change', 'startup': True, 'value': 1080}
2024-08-09 07:53:34 DEBUG plugins.db_addon 'verbrauch' item EHZ.Strom with func=None and value=17017681 detected. Check for update of cache_dicts cache_dict={Item: EHZ.Strom: 17010649, Item: EHZ.UMG604ModBus.PVWirkArbeit: 2504582} and item value. 2024-08-09 07:53:34 INFO plugins.db_addon Item value for 'EHZ.Strom.verbrauch_tag' with func=None will be set to 7032
gesamt_verbrauch:
type: num
knx_dpt: 13
visu_acl: rw
database: init
database_maxage: 1000
eval: sh.visu.zaehler.gesamt_bezug()+sh.visu.zaehler.gesamt_eigenverbrauch()
eval_trigger:
- visu.zaehler.gesamt_bezug
- visu.zaehler.gesamt_eigenverbrauch
verbrauch_tag:
name: Verbrauch am heutigen Tag
db_addon_fct: verbrauch_tag
db_addon_startup: yes
type: num
visu_acl: ro
cache: yes
verbrauch_tag_minus1:
name: Verbrauch gestern
db_addon_fct: verbrauch_tag_minus1
db_addon_startup: yes
type: num
visu_acl: ro
cache: yes
In der Plugin Liste steht immer das Plugin als deaktiviert und bei verbunden auf "Nein".
Muss ich an der DB selbst noch was machen? Hat jemand eine Idee, was noch fehlt? Der Arbeitsvorart zählt hoch, aber irgnedwie läuft das nicht weiter...
In der Plugin Liste steht immer das Plugin als deaktiviert und bei verbunden auf "Nein".
Stell bitte mal das Logging für das db_addon auf debug und schau dann mal da rein. Am besten in eine eigene Datei loggen lassen. Das Plugin "erzählt" seht viel.
Dann könntest Du im Log mal schauen, was das Plugin direkt nach dem Start macht. Vielleicht findet es die Datenbank nicht, oder, oder....
Hallo,
ich habe das db_addon am Laufen aber zum Teil bekomme ich komsiche Werte raus. Besonders bei den tagesaktuellen Werte bekomme ich immer wieder falsche Werte. Wenn ich dann auf neuberechnen gehe, dann passen sie meistens wieder.
Was ich auch noch verzweifelt Suche ist, wie man den Loglevel verändert oder auf debug stellt?
Code:
haus_gesamtverbrauch:
type: num
knx_dpt: 13
visu_acl: rw
database: init
database_maxage: 1000
eval: sh.visu.zaehler.haus_tarif_bezug()+sh.visu.zaehler.haus_eigenverbrauch()
eval_trigger:
- visu.zaehler.haus_tarif_bezug
- visu.zaehler.haus_eigenverbrauch
verbrauch_heute:
name: Verbrauch am heutigen Tag
db_addon_fct: verbrauch_tag
db_addon_startup: yes
type: num
visu_acl: ro
cache: yes
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
Code:
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.
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?
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.
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.
Code:
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().
Wir verarbeiten personenbezogene Daten über die Nutzer unserer Website mithilfe von Cookies und anderen Technologien, um unsere Dienste bereitzustellen. Weitere Informationen findest Du in unserer Datenschutzerklärung.
Indem Du unten auf "ICH stimme zu" klickst, stimmst Du unserer Datenschutzerklärung und unseren persönlichen Datenverarbeitungs- und Cookie-Praktiken zu, wie darin beschrieben. Du erkennst außerdem an, dass dieses Forum möglicherweise außerhalb Deines Landes gehostet wird und bist damit einverstanden, dass Deine Daten in dem Land, in dem dieses Forum gehostet wird, gesammelt, gespeichert und verarbeitet werden.
Kommentar