[Aufruf] Dringender Test sql 1.6.4

[frankjoke]

Na da hat sich ja einiges bewegt inzwischen!

Ich habe den Sinn der Null-Werte nicht verstanden, die sollten nie notwendig und sein!

Eine Integration der Daten im Nachhinein (notwendig um z.B die Leistung zu berechnnen) wird dadurch unnötig kompliziert.

Null-Werte sollten aufgezeichnet werden wenn KEINE Daten kommen.

Eine STrategie welche ich verwenden musste um einer Industrielle Anwendung Daten aufzuzeichnen war folgende:

Es gibt zwei timeouts:

t1 = die maximale Zeit zwischen gleichen Datenpunkten (kann/soll verwendet werden um Datenpunkte aufzuzeichnen auch wenn die Daten gleich bleiben damit z.B. jede STunde oder jeden Tag zumindest ein Datenpunkt aufgezeichnet wird.

t2 = maximale Dauer zwischen zwei Datenpunkten, wenn länger wird null als Unterbrechung aufgezeichnet (aber nur 1x!)

Die Datenpunkte wurden (mit den Zeitstempeln) folgendermaßen mit der Strategie 'nbur bei Änderung' gespeichert:

• Letzter Datenpunkt wird als alter gespeichert

• neuer als neuer

• t2 wird neu getriggert

wenn alt==neu

• • t1 wird beim ersten mal getriggert
• • wenn t1 ausläuft wird neu geschrieben und t1 wieder getriggert.

sonst (wenn alt != neu)

• • alt wird gespeichert (hat noch den timestamp des letzten alten Wertes)
• • neu wird gespeichert
• • t1 und t2 werden gecancelt

wenn t2 ausläuft (dann ist der letzte Datenpunkt noch der neue vom letzten mal und der alte der alte davor)

• • neu wird geschrieben
• • null wird geschrieben

Diese Methode zeichnet genau auf wie lange gleiche Daten gelesen wurden und wann Änderungen oder keine Daten vorkanem.

Die Daten sind dann leicht integrierbar und fehlende Daten werden auch gekennzeichnet.

Die 'Entprellung' fehlt hier zwar, kann aber auch eingebunden werden, sie ist aber bei Aufzeichnung von Änderungen meist nicht notwendig.

[frankjoke]

Ich vergaß:

Wer auch immer Flot betreut, Bitte ein Update damit die Null-Werte keine alter anzeigen! Ansonsten kann man sie nie verwenden!

Ich hatte seit gestern in 25 verschiedenen Datenreihen 45 Nullen, wobei ich mir nicht vorstellen kann warum die auftauchen da die Daten immer geliefert wurden (mit Ausnahme des Regens…).

Alle Nullen sind aus der Datenbank entfernt und (uns SQL angewiesen diese NICHT zu speichern, Flot liefert noch immer alerts, jetzt bei ALLEN Abfragen, auch bei jenen welche gestern noch gingen da sie keine Nullen enthielten :((((!

Suche dauert an

[apollon77]

Null Werte sollten kein alert zeigen. Wir genau lautet das alert? Wenn es das von oben im Thread ist (log Data First und so) dann liegt es nicht an null werten sondern daran das die datenabfrage nicht geklappt hat weil sql Adapter den typ nicht kannte und daher nicht wusste in welcher Tabelle er suchen musste.

[frankjoke]

Hallo Ingo:

Die Meldung ist:

Please wait till next data record is logged and reload.

Ich hatte NICHTS an den Daten geändert und habe auch in die Datenbank geschaut ob irgendwelche Typen oder ID's nicht vorhanden sind, aber nein alles OK.

Nun gestern ging alles wieder nachdem ich die Nullen aus den 'ts_number' gelöscht habe. heute hab ich neues SQL 1.7 installiert und Aufzeichnung von Nullen ausgeschaltet, alle Nullen seit gestern gelöscht aber trotzdem (auch nach re-boot) kommt jetzt bei jeder Flot-Abfrage (have ca 12 davon verteilt auf jede der Vis-Seiten) der Alert., auch ohne Nullen!

Das Einzige was ich geändert habe war SQL auf 1.7 von Git! Die Daten in der Datenbank schauen OK aus und für Alle Daten liegen 20-200 Werte vom letzten Tag vor (Ausser dem Regen).

Bin schon etwas verzeifelt, wenn Flot wenigstens melden würde welche Daten da nicht passen…

Versuche es im chrome zu debuggen, bin aber nocht nicht soweit um sagen zu können wo es auftritt.

[frankjoke]

Ok, hab mir Flot 1.7.5 mal angeschaut.

Im data.js gibt's zwei Punkte wo das alrert erzeugt wird (Bitte rausnehemen):

Bei Zeile 400:

 socket.emit('getHistory', config.ticks, option, function (err, res, stepIgnore, _sessionId) {
                if (err) window.alert(err);

und bei Zeile 583

           socket.emit('getHistory', config.ticks, option, function (err, res, stepIgnore, _sessionId) {
                if (err) window.alert(err);

In beiden Fällen werden Daten von SQL (oder dem akuten history-provider) abgefragt.

Ich habe dann eine alte Flot-Version (1.6.2) auf einer Virtuellen Machine geladen und gesehen dass diese Abfragen da schon drinnen waren.

Also ist die Änderung durch den SQL-Adapter entstanden, er liefert jetzt Fehler und hat vorher keinen Fehler geliefert!

Wenn das so ist wie du beschrieben hast ist die Fehlerbeschreibung und der Fehler nicht richtig da definitiv richtige Daten vorhanden sind - und waren!

mit altem SQL 1.6.1 tritt der Fehler auch nicht auf.

[apollon77]

Ok damn bitte ein Debug log vom Start des sql Adapters bis zum dann abfragen eines Solchen flot Grafik wo das Problem auftritt schicken. Muss ich reinschauen.

Hab dir doch gesagt das es nicht an den Mülls liegt

Und nochmal gefragt ( hatte ich Eiter oben schon). Hast du mal bei so einem Datenpunkt in der sql konfig des Datenpunkte einen „speichern als“ korrekt gesetzt?

[frankjoke]

Ok,

hab 1.6.1 wieder runter und dann 1.6.9 installiert. Dort kommt Fehler nicht.

Aber bei 1.7.0 kommt er wieder.

Log:

! 2018-02-11 19:34:58.504 - [31merror[39m: host.cslstretch instance system.adapter.sql.0 terminated with code 0 (OK) 2018-02-11 19:34:58.504 - [32minfo[39m: host.cslstretch Restart adapter system.adapter.sql.0 because enabled 2018-02-11 19:35:01.689 - [32minfo[39m: host.cslstretch instance system.adapter.sql.0 started with pid 10869 2018-02-11 19:35:03.414 - [34mdebug[39m: sql.0 objectDB connected 2018-02-11 19:35:03.468 - [34mdebug[39m: sql.0 statesDB connected 2018-02-11 19:35:03.537 - [32minfo[39m: sql.0 starting. Version 1.7.0 in /opt/iobroker/node_modules/iobroker.sql, node: v6.12.3 2018-02-11 19:35:03.603 - [32minfo[39m: sql.0 enabled logging of hm-rpc.0.NEQ0532409.1.TEMPERATURE 2018-02-11 19:35:03.603 - [32minfo[39m: sql.0 enabled logging of hm-rpc.0.NEQ0532409.2.TEMPERATURE 2018-02-11 19:35:03.604 - [32minfo[39m: sql.0 enabled logging of hm-rpc.0.NEQ0532409.3.TEMPERATURE 2018-02-11 19:35:03.604 - [32minfo[39m: sql.0 enabled logging of xs1.0.Sensors.Pool 2018-02-11 19:35:03.604 - [32minfo[39m: sql.0 enabled logging of xs1.0.Sensors.TempTER 2018-02-11 19:35:03.605 - [32minfo[39m: sql.0 enabled logging of xs1.0.Sensors.TempSTR 2018-02-11 19:35:03.605 - [32minfo[39m: sql.0 enabled logging of xs1.0.Sensors.TempWZ 2018-02-11 19:35:03.605 - [32minfo[39m: sql.0 enabled logging of xs1.0.Sensors.TempSZ 2018-02-11 19:35:03.606 - [32minfo[39m: sql.0 enabled logging of xs1.0.Sensors.TempAZS 2018-02-11 19:35:03.606 - [32minfo[39m: sql.0 enabled logging of xs1.0.Sensors.HeissWasser 2018-02-11 19:35:03.607 - [32minfo[39m: sql.0 enabled logging of xs1.0.Sensors.LuftfeuchteWZ 2018-02-11 19:35:03.608 - [32minfo[39m: sql.0 enabled logging of xs1.0.Sensors.LuftfeuchteSZ 2018-02-11 19:35:03.609 - [32minfo[39m: sql.0 enabled logging of xs1.0.Sensors.LuftfeuchteAZS 2018-02-11 19:35:03.609 - [32minfo[39m: sql.0 enabled logging of xs1.0.Sensors.LuftfeuchteTER 2018-02-11 19:35:03.609 - [32minfo[39m: sql.0 enabled logging of xs1.0.Sensors.LuftfeuchteSTR 2018-02-11 19:35:03.610 - [32minfo[39m: sql.0 enabled logging of km200.0.heatingCircuits.hc1.roomtemperature 2018-02-11 19:35:03.611 - [32minfo[39m: sql.0 enabled logging of km200.0.heatingCircuits.hc2.actualSupplyTemperature 2018-02-11 19:35:03.611 - [32minfo[39m: sql.0 enabled logging of km200.0.heatingCircuits.hc2.pumpModulation 2018-02-11 19:35:03.611 - [32minfo[39m: sql.0 enabled logging of km200.0.heatingCircuits.hc2.roomtemperature 2018-02-11 19:35:03.612 - [32minfo[39m: sql.0 enabled logging of km200.0.system.heatSources.hs1.actualModulation 2018-02-11 19:35:03.612 - [32minfo[39m: sql.0 enabled logging of km200.0.system.heatSources.hs1.actualPower 2018-02-11 19:35:03.613 - [32minfo[39m: sql.0 enabled logging of km200.0.system.sensors.temperatures.hotWater_t2 2018-02-11 19:35:03.613 - [32minfo[39m: sql.0 enabled logging of km200.0.system.sensors.temperatures.outdoor_t1 2018-02-11 19:35:03.613 - [32minfo[39m: sql.0 enabled logging of km200.0.system.sensors.temperatures.supply_t1 2018-02-11 19:35:03.613 - [32minfo[39m: sql.0 enabled logging of radar.0.ECB-Kurse.USD 2018-02-11 19:35:03.614 - [32minfo[39m: sql.0 enabled logging of radar.0.ECB-Kurse.GBP 2018-02-11 19:35:03.614 - [32minfo[39m: sql.0 enabled logging of javascript.0.StateMachine.sunpos 2018-02-11 19:35:03.614 - [32minfo[39m: sql.0 enabled logging of javascript.0.StateMachine.helligkeit 2018-02-11 19:35:03.614 - [32minfo[39m: sql.0 enabled logging of javascript.0.StateMachine.Astro 2018-02-11 19:35:03.614 - [32minfo[39m: sql.0 enabled logging of hm-rpc.0.NEQ1100493.1.HUMIDITY 2018-02-11 19:35:03.615 - [32minfo[39m: sql.0 enabled logging of hm-rpc.0.NEQ1100493.1.RAINING 2018-02-11 19:35:03.615 - [32minfo[39m: sql.0 enabled logging of hm-rpc.0.NEQ1100493.1.RAIN_COUNTER 2018-02-11 19:35:03.615 - [32minfo[39m: sql.0 enabled logging of hm-rpc.0.NEQ1100493.1.SUNSHINEDURATION 2018-02-11 19:35:03.615 - [32minfo[39m: sql.0 enabled logging of hm-rpc.0.NEQ1100493.1.TEMPERATURE 2018-02-11 19:35:03.615 - [32minfo[39m: sql.0 enabled logging of hm-rpc.0.NEQ1100493.1.WIND_DIRECTION 2018-02-11 19:35:03.616 - [32minfo[39m: sql.0 enabled logging of hm-rpc.0.NEQ1100493.1.WIND_DIRECTION_RANGE 2018-02-11 19:35:03.616 - [32minfo[39m: sql.0 enabled logging of hm-rpc.0.NEQ1100493.1.WIND_SPEED 2018-02-11 19:35:03.616 - [32minfo[39m: sql.0 enabled logging of hm-rega.0.5321 2018-02-11 19:35:03.616 - [32minfo[39m: sql.0 enabled logging of km200.0.heatSources.hs1.actualPower 2018-02-11 19:35:03.616 - [32minfo[39m: sql.0 enabled logging of systeminfo.0.System.Mem_free 2018-02-11 19:35:03.616 - [32minfo[39m: sql.0 enabled logging of systeminfo.0.System.Load.Load 2018-02-11 19:35:03.617 - [32minfo[39m: sql.0 enabled logging of systeminfo.0.Currency.BTC-EUR 2018-02-11 19:35:03.617 - [32minfo[39m: sql.0 enabled logging of systeminfo.0.Currency.USD 2018-02-11 19:35:03.617 - [32minfo[39m: sql.0 enabled logging of systeminfo.0.Currency.GBP 2018-02-11 19:35:03.617 - [32minfo[39m: sql.0 enabled logging of systeminfo.0.System.CPU_Temperatur 2018-02-11 19:35:03.769 - [34mdebug[39m: sql.0 CREATE TABLE sources (id SERIAL NOT NULL PRIMARY KEY, name TEXT); 2018-02-11 19:35:03.776 - [34mdebug[39m: sql.0 Response: {"name":"error","length":101,"severity":"ERROR","code":"42P07","file":"heap.c","line":"1067","routine":"heap_create_with_catalog"} 2018-02-11 19:35:03.777 - [34mdebug[39m: sql.0 OK. Table "sources" yet exists 2018-02-11 19:35:03.789 - [34mdebug[39m: sql.0 CREATE TABLE datapoints (id SERIAL NOT NULL PRIMARY KEY, name TEXT, type INTEGER); 2018-02-11 19:35:03.794 - [34mdebug[39m: sql.0 Response: {"name":"error","length":104,"severity":"ERROR","code":"42P07","file":"heap.c","line":"1067","routine":"heap_create_with_catalog"} 2018-02-11 19:35:03.794 - [34mdebug[39m: sql.0 OK. Table "datapoints" yet exists 2018-02-11 19:35:03.806 - [34mdebug[39m: sql.0 CREATE TABLE ts_number (id INTEGER NOT NULL, ts BIGINT, val REAL, ack BOOLEAN, _from INTEGER, q INTEGER, PRIMARY KEY(id, ts)); 2018-02-11 19:35:03.809 - [34mdebug[39m: sql.0 Response: {"name":"error","length":103,"severity":"ERROR","code":"42P07","file":"heap.c","line":"1067","routine":"heap_create_with_catalog"} 2018-02-11 19:35:03.809 - [34mdebug[39m: sql.0 OK. Table "ts_number" yet exists 2018-02-11 19:35:03.824 - [34mdebug[39m: sql.0 CREATE TABLE ts_string (id INTEGER NOT NULL, ts BIGINT, val TEXT, ack BOOLEAN, _from INTEGER, q INTEGER, PRIMARY KEY(id, ts)); 2018-02-11 19:35:03.827 - [34mdebug[39m: sql.0 Response: {"name":"error","length":103,"severity":"ERROR","code":"42P07","file":"heap.c","line":"1067","routine":"heap_create_with_catalog"} 2018-02-11 19:35:03.827 - [34mdebug[39m: sql.0 OK. Table "ts_string" yet exists 2018-02-11 19:35:03.839 - [34mdebug[39m: sql.0 CREATE TABLE ts_bool (id INTEGER NOT NULL, ts BIGINT, val BOOLEAN, ack BOOLEAN, _from INTEGER, q INTEGER, PRIMARY KEY(id, ts)); 2018-02-11 19:35:03.843 - [34mdebug[39m: sql.0 Response: {"name":"error","length":101,"severity":"ERROR","code":"42P07","file":"heap.c","line":"1067","routine":"heap_create_with_catalog"} 2018-02-11 19:35:03.844 - [34mdebug[39m: sql.0 OK. Table "ts_bool" yet exists 2018-02-11 19:35:03.845 - [32minfo[39m: sql.0 Connected to postgresql 2018-02-11 19:35:03.847 - [34mdebug[39m: sql.0 SELECT id, type, name FROM datapoints; 2018-02-11 19:35:06.187 - [34mdebug[39m: sql.0 new value received for km200.0.heatingCircuits.hc2.actualSupplyTemperature, new-value=27, ts=1518374106182, relog=false 2018-02-11 19:35:12.958 - [34mdebug[39m: sql.0 new value received for km200.0.system.heatSources.hs1.actualModulation, new-value=25, ts=1518374112952, relog=false 2018-02-11 19:35:13.122 - [34mdebug[39m: sql.0 new value received for km200.0.system.heatSources.hs1.actualPower, new-value=5, ts=1518374113101, relog=false 2018-02-11 19:35:13.963 - [34mdebug[39m: sql.0 Datatype km200.0.system.heatSources.hs1.actualModulation: Currently: number, StorageType: false 2018-02-11 19:35:13.970 - [34mdebug[39m: sql.0 Type set in Def for km200.0.system.heatSources.hs1.actualModulation: false 2018-02-11 19:35:13.971 - [34mdebug[39m: sql.0 Type (from DB-Type) for km200.0.system.heatSources.hs1.actualModulation: 0 2018-02-11 19:35:13.972 - [34mdebug[39m: sql.0 SELECT id FROM sources WHERE name='system.adapter.km200.0'; 2018-02-11 19:35:13.994 - [34mdebug[39m: sql.0 INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(57, 1518374112952, 25, true, 8, 0); 2018-02-11 19:35:23.123 - [34mdebug[39m: sql.0 Datatype km200.0.system.heatSources.hs1.actualPower: Currently: number, StorageType: false 2018-02-11 19:35:23.125 - [34mdebug[39m: sql.0 Type set in Def for km200.0.system.heatSources.hs1.actualPower: false 2018-02-11 19:35:23.125 - [34mdebug[39m: sql.0 Type (from DB-Type) for km200.0.system.heatSources.hs1.actualPower: 0 2018-02-11 19:35:23.128 - [34mdebug[39m: sql.0 INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(69, 1518374113101, 5, true, 8, 0); 2018-02-11 19:35:27.541 - [34mdebug[39m: sql.0 new value received for xs1.0.Sensors.TempSTR, new-value=2.1, ts=1518374127000, relog=false 2018-02-11 19:35:27.552 - [34mdebug[39m: sql.0 new value received for xs1.0.Sensors.LuftfeuchteSTR, new-value=57, ts=1518374127000, relog=false 2018-02-11 19:35:28.281 - [34mdebug[39m: sql.0 new value received for km200.0.system.sensors.temperatures.hotWater_t2, new-value=50.6, ts=1518374128277, relog=false 2018-02-11 19:35:28.431 - [34mdebug[39m: sql.0 new value received for km200.0.system.sensors.temperatures.outdoor_t1, new-value=1.9, ts=1518374128422, relog=false 2018-02-11 19:35:28.577 - [34mdebug[39m: sql.0 new value received for km200.0.system.sensors.temperatures.supply_t1, new-value=37.4, ts=1518374128571, relog=false 2018-02-11 19:35:29.197 - [34mdebug[39m: sql.0 new value received for xs1.0.Sensors.TempAZS, new-value=21.6, ts=1518374128000, relog=false 2018-02-11 19:35:29.204 - [34mdebug[39m: sql.0 new value received for xs1.0.Sensors.LuftfeuchteAZS, new-value=32, ts=1518374128000, relog=false 2018-02-11 19:35:33.407 - [34mdebug[39m: sql.0 new value received for xs1.0.Sensors.TempWZ, new-value=23.4, ts=1518374132000, relog=false 2018-02-11 19:35:33.410 - [34mdebug[39m: sql.0 new value received for xs1.0.Sensors.LuftfeuchteWZ, new-value=25, ts=1518374132000, relog=false 2018-02-11 19:35:34.447 - [34mdebug[39m: sql.0 new value received for xs1.0.Sensors.TempTER, new-value=2.2, ts=1518374133000, relog=false 2018-02-11 19:35:34.448 - [34mdebug[39m: sql.0 new value received for xs1.0.Sensors.LuftfeuchteTER, new-value=54, ts=1518374133000, relog=false 2018-02-11 19:35:39.483 - [34mdebug[39m: sql.0 new value received for xs1.0.Sensors.TempSZ, new-value=21.4, ts=1518374138000, relog=false 2018-02-11 19:35:39.488 - [34mdebug[39m: sql.0 new value received for xs1.0.Sensors.LuftfeuchteSZ, new-value=30, ts=1518374138000, relog=false 2018-02-11 19:35:58.291 - [33mwarn[39m: sql.0 For getHistory for id systeminfo.0.System.Load.Load: Type empty. Need to write data first. Index = 82 2018-02-11 19:35:58.293 - [31merror[39m: sql.0 Please wait till next data record is logged and reload. 2018-02-11 19:35:58.296 - [34mdebug[39m: sql.0 sendTo "getHistory" to system.adapter.web.0 from system.adapter.sql.0 2018-02-11 19:35:58.299 - [34mdebug[39m: sql.0 SELECT ts, val FROM undefined WHERE undefined.id=82 AND undefined.ts < 1518374156832 AND undefined.ts >= 1518287756832 UNION ( SELECT ts, val FROM undefined WHERE undefined.id=82 AND undefined.ts < 1518287756832 ORDER BY undefined.ts DESC LIMIT 1) UNION ( SELECT ts, val FROM undefined WHERE undefined.id=82 AND undefined.ts >= 1518374156832 ORDER BY undefined.ts ASC LIMIT 1) ORDER BY ts ASC; 2018-02-11 19:35:58.300 - [34mdebug[39m: sql.0 SELECT ts, val FROM undefined WHERE undefined.id=82 AND undefined.ts < 1518374156832 AND undefined.ts >= 1518287756832 UNION ( SELECT ts, val FROM undefined WHERE undefined.id=82 AND undefined.ts < 1518287756832 ORDER BY undefined.ts DESC LIMIT 1) UNION ( SELECT ts, val FROM undefined WHERE undefined.id=82 AND undefined.ts >= 1518374156832 ORDER BY undefined.ts ASC LIMIT 1) ORDER BY ts ASC; 2018-02-11 19:35:58.304 - [33mwarn[39m: sql.0 For getHistory for id systeminfo.0.System.Mem_free: Type empty. Need to write data first. Index = 88 2018-02-11 19:35:58.304 - [31merror[39m: sql.0 Please wait till next data record is logged and reload. 2018-02-11 19:35:58.305 - [34mdebug[39m: sql.0 sendTo "getHistory" to system.adapter.web.0 from system.adapter.sql.0 2018-02-11 19:35:58.306 - [34mdebug[39m: sql.0 SELECT ts, val FROM undefined WHERE undefined.id=88 AND undefined.ts < 1518374156832 AND undefined.ts >= 1518287756832 UNION ( SELECT ts, val FROM undefined WHERE undefined.id=88 AND undefined.ts < 1518287756832 ORDER BY undefined.ts DESC LIMIT 1) UNION ( SELECT ts, val FROM undefined WHERE undefined.id=88 AND undefined.ts >= 1518374156832 ORDER BY undefined.ts ASC LIMIT 1) ORDER BY ts ASC; 2018-02-11 19:35:58.307 - [34mdebug[39m: sql.0 SELECT ts, val FROM undefined WHERE undefined.id=88 AND undefined.ts < 1518374156832 AND undefined.ts >= 1518287756832 UNION ( SELECT ts, val FROM undefined WHERE undefined.id=88 AND undefined.ts < 1518287756832 ORDER BY undefined.ts DESC LIMIT 1) UNION ( SELECT ts, val FROM undefined WHERE undefined.id=88 AND undefined.ts >= 1518374156832 ORDER BY undefined.ts ASC LIMIT 1) ORDER BY ts ASC; 2018-02-11 19:35:58.308 - [33mwarn[39m: sql.0 For getHistory for id systeminfo.0.System.CPU_Temperatur: Type empty. Need to write data first. Index = 84 2018-02-11 19:35:58.308 - [31merror[39m: sql.0 Please wait till next data record is logged and reload. 2018-02-11 19:35:58.309 - [34mdebug[39m: sql.0 sendTo "getHistory" to system.adapter.web.0 from system.adapter.sql.0 2018-02-11 19:35:58.309 - [34mdebug[39m: sql.0 SELECT ts, val FROM undefined WHERE undefined.id=84 AND undefined.ts < 1518374156832 AND undefined.ts >= 1518287756832 UNION ( SELECT ts, val FROM undefined WHERE undefined.id=84 AND undefined.ts < 1518287756832 ORDER BY undefined.ts DESC LIMIT 1) UNION ( SELECT ts, val FROM undefined WHERE undefined.id=84 AND undefined.ts >= 1518374156832 ORDER BY undefined.ts ASC LIMIT 1) ORDER BY ts ASC; 2018-02-11 19:35:58.309 - [34mdebug[39m: sql.0 SELECT ts, val FROM undefined WHERE undefined.id=84 AND undefined.ts < 1518374156832 AND undefined.ts >= 1518287756832 UNION ( SELECT ts, val FROM undefined WHERE undefined.id=84 AND undefined.ts < 1518287756832 ORDER BY undefined.ts DESC LIMIT 1) UNION ( SELECT ts, val FROM undefined WHERE undefined.id=84 AND undefined.ts >= 1518374156832 ORDER BY undefined.ts ASC LIMIT 1) ORDER BY ts ASC; 2018-02-11 19:35:58.311 - [33mwarn[39m: sql.0 For getHistory for id javascript.0.StateMachine.Astro: Type empty. Need to write data first. Index = 68 2018-02-11 19:35:58.311 - [31merror[39m: sql.0 Please wait till next data record is logged and reload. 2018-02-11 19:35:58.311 - [34mdebug[39m: sql.0 sendTo "getHistory" to system.adapter.web.0 from system.adapter.sql.0 2018-02-11 19:35:58.311 - [34mdebug[39m: sql.0 SELECT ts, val FROM undefined WHERE undefined.id=68 AND undefined.ts < 1518374156832 AND undefined.ts >= 1518287756832 UNION ( SELECT ts, val FROM undefined WHERE undefined.id=68 AND undefined.ts < 1518287756832 ORDER BY undefined.ts DESC LIMIT 1) UNION ( SELECT ts, val FROM undefined WHERE undefined.id=68 AND undefined.ts >= 1518374156832 ORDER BY undefined.ts ASC LIMIT 1) ORDER BY ts ASC; 2018-02-11 19:35:58.311 - [34mdebug[39m: sql.0 SELECT ts, val FROM undefined WHERE undefined.id=68 AND undefined.ts < 1518374156832 AND undefined.ts >= 1518287756832 UNION ( SELECT ts, val FROM undefined WHERE undefined.id=68 AND undefined.ts < 1518287756832 ORDER BY undefined.ts DESC LIMIT 1) UNION ( SELECT ts, val FROM undefined WHERE undefined.id=68 AND undefined.ts >= 1518374156832 ORDER BY undefined.ts ASC LIMIT 1) ORDER BY ts ASC; 2018-02-11 19:35:58.330 - [31merror[39m: sql.0 error: relation "undefined" does not exist 2018-02-11 19:35:58.331 - [34mdebug[39m: sql.0 sendTo "getHistory" to system.adapter.web.0 from system.adapter.sql.0 2018-02-11 19:35:58.336 - [31merror[39m: sql.0 error: relation "undefined" does not exist 2018-02-11 19:35:58.336 - [34mdebug[39m: sql.0 sendTo "getHistory" to system.adapter.web.0 from system.adapter.sql.0 2018-02-11 19:35:58.341 - [31merror[39m: sql.0 error: relation "undefined" does not exist 2018-02-11 19:35:58.342 - [34mdebug[39m: sql.0 sendTo "getHistory" to system.adapter.web.0 from system.adapter.sql.0 2018-02-11 19:35:58.343 - [31merror[39m: sql.0 error: relation "undefined" does not exist 2018-02-11 19:35:58.343 - [34mdebug[39m: sql.0 sendTo "getHistory" to system.adapter.web.0 from system.adapter.sql.0 2018-02-11 19:36:00.031 - [34mdebug[39m: sql.0 new value received for systeminfo.0.System.CPU_Temperatur, new-value=54, ts=1518374160028, relog=false 2018-02-11 19:36:01.661 - [34mdebug[39m: sql.0 new value received for xs1.0.Sensors.Pool, new-value=3.5, ts=1518374161000, relog=false 2018-02-11 19:36:09.744 - [34mdebug[39m: sql.0 For getHistory for id hm-rpc.0.NEQ1100493.1.RAINING: Type empty, use dbtype 2 2018-02-11 19:36:09.745 - [34mdebug[39m: sql.0 SELECT ts, val FROM ts_bool WHERE ts_bool.id=71 AND ts_bool.ts < 1518374156832 AND ts_bool.ts >= 1518287756832 UNION ( SELECT ts, val FROM ts_bool WHERE ts_bool.id=71 AND ts_bool.ts < 1518287756832 ORDER BY ts_bool.ts DESC LIMIT 1) UNION ( SELECT ts, val FROM ts_bool WHERE ts_bool.id=71 AND ts_bool.ts >= 1518374156832 ORDER BY ts_bool.ts ASC LIMIT 1) ORDER BY ts ASC; 2018-02-11 19:36:09.751 - [34mdebug[39m: sql.0 SELECT ts, val FROM ts_bool WHERE ts_bool.id=71 AND ts_bool.ts < 1518374156832 AND ts_bool.ts >= 1518287756832 UNION ( SELECT ts, val FROM ts_bool WHERE ts_bool.id=71 AND ts_bool.ts < 1518287756832 ORDER BY ts_bool.ts DESC LIMIT 1) UNION ( SELECT ts, val FROM ts_bool WHERE ts_bool.id=71 AND ts_bool.ts >= 1518374156832 ORDER BY ts_bool.ts ASC LIMIT 1) ORDER BY ts ASC; 2018-02-11 19:36:09.789 - [34mdebug[39m: sql.0 Send: 36 of: 35 in: 46ms 2018-02-11 19:36:09.789 - [34mdebug[39m: sql.0 sendTo "getHistory" to system.adapter.web.0 from system.adapter.sql.0 2018-02-11 19:36:32.405 - [34mdebug[39m: sql.0 new value received for xs1.0.Sensors.TempWZ, new-value=23.4, ts=1518374191000, relog=false 2018-02-11 19:36:32.407 - [34mdebug[39m: sql.0 value not changed xs1.0.Sensors.TempWZ, last-value=23.4, new-value=23.4, ts=1518374191000 2018-02-11 19:36:32.411 - [34mdebug[39m: sql.0 new value received for xs1.0.Sensors.LuftfeuchteWZ, new-value=25, ts=1518374191000, relog=false 2018-02-11 19:36:32.413 - [34mdebug[39m: sql.0 value not changed xs1.0.Sensors.LuftfeuchteWZ, last-value=25, new-value=25, ts=1518374191000 2018-02-11 19:36:40.193 - [34mdebug[39m: sql.0 new value received for xs1.0.Sensors.TempAZS, new-value=21.6, ts=1518374199000, relog=false 2018-02-11 19:36:40.195 - [34mdebug[39m: sql.0 value not changed xs1.0.Sensors.TempAZS, last-value=21.6, new-value=21.6, ts=1518374199000 2018-02-11 19:36:40.202 - [34mdebug[39m: sql.0 new value received for xs1.0.Sensors.LuftfeuchteAZS, new-value=32, ts=1518374199000, relog=false 2018-02-11 19:36:40.206 - [34mdebug[39m: sql.0 value not changed xs1.0.Sensors.LuftfeuchteAZS, last-value=32, new-value=32, ts=1518374199000 2018-02-11 19:36:46.191 - [34mdebug[39m: sql.0 Datatype km200.0.heatingCircuits.hc2.actualSupplyTemperature: Currently: number, StorageType: false 2018-02-11 19:36:46.192 - [34mdebug[39m: sql.0 Type set in Def for km200.0.heatingCircuits.hc2.actualSupplyTemperature: false 2018-02-11 19:36:46.192 - [34mdebug[39m: sql.0 Type (from DB-Type) for km200.0.heatingCircuits.hc2.actualSupplyTemperature: 0 2018-02-11 19:36:46.192 - [34mdebug[39m: sql.0 INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(55, 1518374106182, 27, true, 8, 0); 2018-02-11 19:36:46.480 - [34mdebug[39m: sql.0 new value received for xs1.0.Sensors.TempSZ, new-value=21.4, ts=1518374205000, relog=false 2018-02-11 19:36:46.480 - [34mdebug[39m: sql.0 value not changed xs1.0.Sensors.TempSZ, last-value=21.4, new-value=21.4, ts=1518374205000 2018-02-11 19:36:46.485 - [34mdebug[39m: sql.0 new value received for xs1.0.Sensors.LuftfeuchteSZ, new-value=30, ts=1518374205000, relog=false 2018-02-11 19:36:46.486 - [34mdebug[39m: sql.0 value not changed xs1.0.Sensors.LuftfeuchteSZ, last-value=30, new-value=30, ts=1518374205000 2018-02-11 19:36:57.419 - [34mdebug[39m: sql.0 new value received for xs1.0.Sensors.TempTER, new-value=2.2, ts=1518374216000, relog=false 2018-02-11 19:36:57.420 - [34mdebug[39m: sql.0 value not changed xs1.0.Sensors.TempTER, last-value=2.2, new-value=2.2, ts=1518374216000 2018-02-11 19:36:57.441 - [34mdebug[39m: sql.0 new value received for xs1.0.Sensors.LuftfeuchteTER, new-value=54, ts=1518374216000, relog=false 2018-02-11 19:36:57.441 - [34mdebug[39m: sql.0 value not changed xs1.0.Sensors.LuftfeuchteTER, last-value=54, new-value=54, ts=1518374216000 2018-02-11 19:37:02.667 - [34mdebug[39m: sql.0 new value received for xs1.0.Sensors.Pool, new-value=3.4, ts=1518374222000, relog=false 2018-02-11 19:37:02.669 - [34mdebug[39m: sql.0 Min-Delta reached xs1.0.Sensors.Pool, last-value=3.5, new-value=3.4, ts=1518374222000 2018-02-11 19:37:08.283 - [34mdebug[39m: sql.0 Datatype km200.0.system.sensors.temperatures.hotWater_t2: Currently: number, StorageType: false 2018-02-11 19:37:08.284 - [34mdebug[39m: sql.0 Type set in Def for km200.0.system.sensors.temperatures.hotWater_t2: false 2018-02-11 19:37:08.285 - [34mdebug[39m: sql.0 Type (from DB-Type) for km200.0.system.sensors.temperatures.hotWater_t2: 0 2018-02-11 19:37:08.286 - [34mdebug[39m: sql.0 INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(47, 1518374128277, 50.6, true, 8, 0); 2018-02-11 19:37:08.433 - [34mdebug[39m: sql.0 Datatype km200.0.system.sensors.temperatures.outdoor_t1: Currently: number, StorageType: false 2018-02-11 19:37:08.434 - [34mdebug[39m: sql.0 Type set in Def for km200.0.system.sensors.temperatures.outdoor_t1: false 2018-02-11 19:37:08.435 - [34mdebug[39m: sql.0 Type (from DB-Type) for km200.0.system.sensors.temperatures.outdoor_t1: 0 2018-02-11 19:37:08.436 - [34mdebug[39m: sql.0 INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(48, 1518374128422, 1.9, true, 8, 0); 2018-02-11 19:37:08.580 - [34mdebug[39m: sql.0 Datatype km200.0.system.sensors.temperatures.supply_t1: Currently: number, StorageType: false 2018-02-11 19:37:08.581 - [34mdebug[39m: sql.0 Type set in Def for km200.0.system.sensors.temperatures.supply_t1: false 2018-02-11 19:37:08.582 - [34mdebug[39m: sql.0 Type (from DB-Type) for km200.0.system.sensors.temperatures.supply_t1: 0 2018-02-11 19:37:08.583 - [34mdebug[39m: sql.0 INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(51, 1518374128571, 37.4, true, 8, 0); 2018-02-11 19:37:19.953 - [34mdebug[39m: sql.0 new value received for hm-rpc.0.NEQ1100493.1.TEMPERATURE, new-value=1.6, ts=1518374239950, relog=false 2018-02-11 19:37:19.956 - [34mdebug[39m: sql.0 new value received for hm-rpc.0.NEQ1100493.1.HUMIDITY, new-value=75, ts=1518374239951, relog=false 2018-02-11 19:37:19.960 - [34mdebug[39m: sql.0 new value received for hm-rpc.0.NEQ1100493.1.RAINING, new-value=false, ts=1518374239954, relog=false 2018-02-11 19:37:19.962 - [34mdebug[39m: sql.0 new value received for hm-rpc.0.NEQ1100493.1.RAIN_COUNTER, new-value=111.215, ts=1518374239955, relog=false 2018-02-11 19:37:19.962 - [34mdebug[39m: sql.0 new value received for hm-rpc.0.NEQ1100493.1.WIND_SPEED, new-value=0, ts=1518374239956, relog=false 2018-02-11 19:37:19.964 - [34mdebug[39m: sql.0 new value received for hm-rpc.0.NEQ1100493.1.WIND_DIRECTION, new-value=175, ts=1518374239958, relog=false 2018-02-11 19:37:19.965 - [34mdebug[39m: sql.0 new value received for hm-rpc.0.NEQ1100493.1.WIND_DIRECTION_RANGE, new-value=67, ts=1518374239959, relog=false 2018-02-11 19:37:19.969 - [34mdebug[39m: sql.0 new value received for hm-rpc.0.NEQ1100493.1.SUNSHINEDURATION, new-value=141, ts=1518374239963, relog=false 2018-02-11 19:37:20.963 - [34mdebug[39m: sql.0 Datatype hm-rpc.0.NEQ1100493.1.RAINING: Currently: boolean, StorageType: Boolean 2018-02-11 19:37:20.964 - [34mdebug[39m: sql.0 SELECT id FROM sources WHERE name='system.adapter.hm-rpc.0'; 2018-02-11 19:37:20.990 - [34mdebug[39m: sql.0 INSERT INTO ts_bool (id, ts, val, ack, _from, q) VALUES(71, 1518374239954, false, true, 3, 0); 2018-02-11 19:37:31.400 - [34mdebug[39m: sql.0 new value received for xs1.0.Sensors.TempWZ, new-value=23.4, ts=1518374250000, relog=false 2018-02-11 19:37:31.401 - [34mdebug[39m: sql.0 value not changed xs1.0.Sensors.TempWZ, last-value=23.4, new-value=23.4, ts=1518374250000 2018-02-11 19:37:31.405 - [34mdebug[39m: sql.0 new value received for xs1.0.Sensors.LuftfeuchteWZ, new-value=25, ts=1518374250000, relog=false 2018-02-11 19:37:31.405 - [34mdebug[39m: sql.0 value not changed xs1.0.Sensors.LuftfeuchteWZ, last-value=25, new-value=25, ts=1518374250000 2018-02-11 19:37:40.033 - [34mdebug[39m: sql.0 Datatype systeminfo.0.System.CPU_Temperatur: Currently: number, StorageType: false 2018-02-11 19:37:40.034 - [34mdebug[39m: sql.0 Type set in Def for systeminfo.0.System.CPU_Temperatur: false 2018-02-11 19:37:40.034 - [34mdebug[39m: sql.0 Type (from DB-Type) for systeminfo.0.System.CPU_Temperatur: 0 2018-02-11 19:37:40.035 - [34mdebug[39m: sql.0 SELECT id FROM sources WHERE name='system.adapter.systeminfo.0'; 2018-02-11 19:37:40.060 - [34mdebug[39m: sql.0 INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(84, 1518374160028, 54, true, 14, 0); 2018-02-11 19:37:40.110 - [34mdebug[39m: sql.0 DELETE FROM ts_number WHERE id=84 AND ts < 1517164620108; 2018-02-11 19:37:51.194 - [34mdebug[39m: sql.0 new value received for xs1.0.Sensors.TempAZS, new-value=21.6, ts=1518374270000, relog=false 2018-02-11 19:37:51.194 - [34mdebug[39m: sql.0 value not changed xs1.0.Sensors.TempAZS, last-value=21.6, new-value=21.6, ts=1518374270000 2018-02-11 19:37:51.203 - [34mdebug[39m: sql.0 new value received for xs1.0.Sensors.LuftfeuchteAZS, new-value=32, ts=1518374270000, relog=false 2018-02-11 19:37:51.203 - [34mdebug[39m: sql.0 value not changed xs1.0.Sensors.LuftfeuchteAZS, last-value=32, new-value=32, ts=1518374270000 2018-02-11 19:37:53.476 - [34mdebug[39m: sql.0 new value received for xs1.0.Sensors.TempSZ, new-value=21.4, ts=1518374272000, relog=false 2018-02-11 19:37:53.476 - [34mdebug[39m: sql.0 value not changed xs1.0.Sensors.TempSZ, last-value=21.4, new-value=21.4, ts=1518374272000 2018-02-11 19:37:53.485 - [34mdebug[39m: sql.0 new value received for xs1.0.Sensors.LuftfeuchteSZ, new-value=30, ts=1518374272000, relog=false 2018-02-11 19:37:53.486 - [34mdebug[39m: sql.0 value not changed xs1.0.Sensors.LuftfeuchteSZ, last-value=30, new-value=30, ts=1518374272000 2018-02-11 19:38:03.665 - [34mdebug[39m: sql.0 new value received for xs1.0.Sensors.Pool, new-value=3.4, ts=1518374283000, relog=false 2018-02-11 19:38:03.665 - [34mdebug[39m: sql.0 value not changed xs1.0.Sensors.Pool, last-value=3.4, new-value=3.4, ts=1518374283000 2018-02-11 19:38:05.582 - [34mdebug[39m: sql.0 new value received for xs1.0.Sensors.TempSTR, new-value=2, ts=1518374285000, relog=false 2018-02-11 19:38:05.583 - [34mdebug[39m: sql.0 Min-Delta reached xs1.0.Sensors.TempSTR, last-value=2.1, new-value=2, ts=1518374285000 2018-02-11 19:38:05.599 - [34mdebug[39m: sql.0 new value received for xs1.0.Sensors.LuftfeuchteSTR, new-value=57, ts=1518374285000, relog=false 2018-02-11 19:38:05.600 - [34mdebug[39m: sql.0 value not changed xs1.0.Sensors.LuftfeuchteSTR, last-value=57, new-value=57, ts=1518374285000 2018-02-11 19:38:20.433 - [34mdebug[39m: sql.0 new value received for xs1.0.Sensors.TempTER, new-value=2.2, ts=1518374299000, relog=false 2018-02-11 19:38:20.433 - [34mdebug[39m: sql.0 value not changed xs1.0.Sensors.TempTER, last-value=2.2, new-value=2.2, ts=1518374299000 2018-02-11 19:38:20.434 - [34mdebug[39m: sql.0 new value received for xs1.0.Sensors.LuftfeuchteTER, new-value=55, ts=1518374299000, relog=false 2018-02-11 19:38:20.434 - [34mdebug[39m: sql.0 Min-Delta reached xs1.0.Sensors.LuftfeuchteTER, last-value=54, new-value=55, ts=1518374299000 2018-02-11 19:38:20.435 - [34mdebug[39m: sql.0 Datatype xs1.0.Sensors.LuftfeuchteTER: Currently: number, StorageType: false 2018-02-11 19:38:20.435 - [34mdebug[39m: sql.0 Type set in Def for xs1.0.Sensors.LuftfeuchteTER: false 2018-02-11 19:38:20.435 - [34mdebug[39m: sql.0 Type (from DB-Type) for xs1.0.Sensors.LuftfeuchteTER: 0 2018-02-11 19:38:20.435 - [34mdebug[39m: sql.0 SELECT id FROM sources WHERE name='system.adapter.xs1.0'; 2018-02-11 19:38:20.455 - [34mdebug[39m: sql.0 INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(36, 1518374216000, 54, true, 6, 0); 2018-02-11 19:38:30.397 - [34mdebug[39m: sql.0 new value received for xs1.0.Sensors.TempWZ, new-value=23.4, ts=1518374309000, relog=false 2018-02-11 19:38:30.397 - [34mdebug[39m: sql.0 value not changed xs1.0.Sensors.TempWZ, last-value=23.4, new-value=23.4, ts=1518374309000 2018-02-11 19:38:30.406 - [34mdebug[39m: sql.0 new value received for xs1.0.Sensors.LuftfeuchteWZ, new-value=25, ts=1518374309000, relog=false 2018-02-11 19:38:30.407 - [34mdebug[39m: sql.0 value not changed xs1.0.Sensors.LuftfeuchteWZ, last-value=25, new-value=25, ts=1518374309000 2018-02-11 19:38:54.449 - [34mdebug[39m: sql.0 Datatype xs1.0.Sensors.TempTER: Currently: number, StorageType: false 2018-02-11 19:38:54.450 - [34mdebug[39m: sql.0 Type set in Def for xs1.0.Sensors.TempTER: false 2018-02-11 19:38:54.451 - [34mdebug[39m: sql.0 Type (from DB-Type) for xs1.0.Sensors.TempTER: 0 2018-02-11 19:38:54.454 - [34mdebug[39m: sql.0 INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(42, 1518374133000, 2.2, true, 6, 0); 2018-02-11 19:38:59.151 - [34mdebug[39m: sql.0 new value received for javascript.0.StateMachine.sunpos, new-value=-25.5, ts=1518374339146, relog=false 2018-02-11 19:38:59.963 - [34mdebug[39m: sql.0 Datatype hm-rpc.0.NEQ1100493.1.RAIN_COUNTER: Currently: number, StorageType: false 2018-02-11 19:38:59.964 - [34mdebug[39m: sql.0 Type set in Def for hm-rpc.0.NEQ1100493.1.RAIN_COUNTER: false 2018-02-11 19:38:59.964 - [34mdebug[39m: sql.0 Type (from DB-Type) for hm-rpc.0.NEQ1100493.1.RAIN_COUNTER: 0 2018-02-11 19:38:59.965 - [34mdebug[39m: sql.0 INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(76, 1518374239955, 111.215, true, 3, 0); 2018-02-11 19:38:59.968 - [34mdebug[39m: sql.0 Datatype hm-rpc.0.NEQ1100493.1.WIND_SPEED: Currently: number, StorageType: false 2018-02-11 19:38:59.969 - [34mdebug[39m: sql.0 Type set in Def for hm-rpc.0.NEQ1100493.1.WIND_SPEED: false 2018-02-11 19:38:59.969 - [34mdebug[39m: sql.0 Type (from DB-Type) for hm-rpc.0.NEQ1100493.1.WIND_SPEED: 0 2018-02-11 19:38:59.970 - [34mdebug[39m: sql.0 INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(74, 1518374239956, 0, true, 3, 0); 2018-02-11 19:38:59.975 - [34mdebug[39m: sql.0 Datatype hm-rpc.0.NEQ1100493.1.WIND_DIRECTION: Currently: number, StorageType: false 2018-02-11 19:38:59.976 - [34mdebug[39m: sql.0 Type set in Def for hm-rpc.0.NEQ1100493.1.WIND_DIRECTION: false 2018-02-11 19:38:59.976 - [34mdebug[39m: sql.0 Type (from DB-Type) for hm-rpc.0.NEQ1100493.1.WIND_DIRECTION: 0 2018-02-11 19:38:59.976 - [34mdebug[39m: sql.0 INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(77, 1518374239958, 175, true, 3, 0); 2018-02-11 19:38:59.977 - [34mdebug[39m: sql.0 Datatype hm-rpc.0.NEQ1100493.1.WIND_DIRECTION_RANGE: Currently: number, StorageType: false 2018-02-11 19:38:59.978 - [34mdebug[39m: sql.0 Type set in Def for hm-rpc.0.NEQ1100493.1.WIND_DIRECTION_RANGE: false 2018-02-11 19:38:59.978 - [34mdebug[39m: sql.0 Type (from DB-Type) for hm-rpc.0.NEQ1100493.1.WIND_DIRECTION_RANGE: 0 2018-02-11 19:38:59.978 - [34mdebug[39m: sql.0 INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(75, 1518374239959, 67, true, 3, 0); 2018-02-11 19:38:59.979 - [34mdebug[39m: sql.0 Datatype hm-rpc.0.NEQ1100493.1.SUNSHINEDURATION: Currently: number, StorageType: false 2018-02-11 19:38:59.979 - [34mdebug[39m: sql.0 Type set in Def for hm-rpc.0.NEQ1100493.1.SUNSHINEDURATION: false 2018-02-11 19:38:59.979 - [34mdebug[39m: sql.0 Type (from DB-Type) for hm-rpc.0.NEQ1100493.1.SUNSHINEDURATION: 0 2018-02-11 19:38:59.980 - [34mdebug[39m: sql.0 INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(78, 1518374239963, 141, true, 3, 0); 2018-02-11 19:39:02.195 - [34mdebug[39m: sql.0 new value received for xs1.0.Sensors.TempAZS, new-value=21.6, ts=1518374341000, relog=false 2018-02-11 19:39:02.195 - [34mdebug[39m: sql.0 value not changed xs1.0.Sensors.TempAZS, last-value=21.6, new-value=21.6, ts=1518374341000 2018-02-11 19:39:02.201 - [34mdebug[39m: sql.0 new value received for xs1.0.Sensors.LuftfeuchteAZS, new-value=32, ts=1518374341000, relog=false 2018-02-11 19:39:02.202 - [34mdebug[39m: sql.0 value not changed xs1.0.Sensors.LuftfeuchteAZS, last-value=32, new-value=32, ts=1518374341000 2018-02-11 19:39:04.667 - [34mdebug[39m: sql.0 new value received for xs1.0.Sensors.Pool, new-value=3.4, ts=1518374344000, relog=false 2018-02-11 19:39:04.668 - [34mdebug[39m: sql.0 value not changed xs1.0.Sensors.Pool, last-value=3.4, new-value=3.4, ts=1518374344000 2018-02-11 19:39:09.154 - [34mdebug[39m: sql.0 Datatype javascript.0.StateMachine.sunpos: Currently: number, StorageType: Number 2018-02-11 19:39:09.155 - [34mdebug[39m: sql.0 Type set in Def for javascript.0.StateMachine.sunpos: Number 2018-02-11 19:39:09.156 - [34mdebug[39m: sql.0 Type (from Def) for javascript.0.StateMachine.sunpos: 0 2018-02-11 19:39:09.157 - [34mdebug[39m: sql.0 SELECT id FROM sources WHERE name='system.adapter.javascript.0'; 2018-02-11 19:39:09.182 - [34mdebug[39m: sql.0 INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(67, 1518374339146, -25.5, false, 1, 0); 2018-02-11 19:39:09.226 - [34mdebug[39m: sql.0 DELETE FROM ts_number WHERE id=67 AND ts < 1515695940226; 2018-02-11 19:39:24.615 - [34mdebug[39m: sql.0 new value received for xs1.0.Sensors.TempSTR, new-value=2, ts=1518374364000, relog=false 2018-02-11 19:39:24.616 - [34mdebug[39m: sql.0 value not changed xs1.0.Sensors.TempSTR, last-value=2, new-value=2, ts=1518374364000 2018-02-11 19:39:24.624 - [34mdebug[39m: sql.0 new value received for xs1.0.Sensors.LuftfeuchteSTR, new-value=57, ts=1518374364000, relog=false 2018-02-11 19:39:24.625 - [34mdebug[39m: sql.0 value not changed xs1.0.Sensors.LuftfeuchteSTR, last-value=57, new-value=57, ts=1518374364000 2018-02-11 19:39:29.395 - [34mdebug[39m: sql.0 new value received for xs1.0.Sensors.TempWZ, new-value=23.4, ts=1518374368000, relog=false 2018-02-11 19:39:29.396 - [34mdebug[39m: sql.0 value not changed xs1.0.Sensors.TempWZ, last-value=23.4, new-value=23.4, ts=1518374368000 2018-02-11 19:39:29.406 - [34mdebug[39m: sql.0 new value received for xs1.0.Sensors.LuftfeuchteWZ, new-value=25, ts=1518374368000, relog=false 2018-02-11 19:39:29.406 - [34mdebug[39m: sql.0 value not changed xs1.0.Sensors.LuftfeuchteWZ, last-value=25, new-value=25, ts=1518374368000 2018-02-11 19:39:43.422 - [34mdebug[39m: sql.0 new value received for xs1.0.Sensors.TempTER, new-value=2.2, ts=1518374382000, relog=false 2018-02-11 19:39:43.423 - [34mdebug[39m: sql.0 value not changed xs1.0.Sensors.TempTER, last-value=2.2, new-value=2.2, ts=1518374382000 2018-02-11 19:39:43.434 - [34mdebug[39m: sql.0 new value received for xs1.0.Sensors.LuftfeuchteTER, new-value=54, ts=1518374382000, relog=false 2018-02-11 19:39:43.434 - [34mdebug[39m: sql.0 Min-Delta reached xs1.0.Sensors.LuftfeuchteTER, last-value=55, new-value=54, ts=1518374382000 2018-02-11 19:39:57.633 - [34mdebug[39m: sql.0 new value received for km200.0.heatSources.hs1.actualPower, new-value=0, ts=1518374397627, relog=false 2018-02-11 19:40:00.024 - [34mdebug[39m: sql.0 new value received for systeminfo.0.System.CPU_Temperatur, new-value=55, ts=1518374400021, relog=false 2018-02-11 19:40:00.025 - [34mdebug[39m: sql.0 Min-Delta reached systeminfo.0.System.CPU_Temperatur, last-value=54, new-value=55, ts=1518374400021 2018-02-11 19:40:05.667 - [34mdebug[39m: sql.0 new value received for xs1.0.Sensors.Pool, new-value=3.4, ts=1518374405000, relog=false 2018-02-11 19:40:05.668 - [34mdebug[39m: sql.0 value not changed xs1.0.Sensors.Pool, last-value=3.4, new-value=3.4, ts=1518374405000 2018-02-11 19:40:06.162 - [34mdebug[39m: sql.0 new value received for km200.0.heatingCircuits.hc2.actualSupplyTemperature, new-value=26, ts=1518374406156, relog=false 2018-02-11 19:40:06.163 - [34mdebug[39m: sql.0 Min-Delta reached km200.0.heatingCircuits.hc2.actualSupplyTemperature, last-value=27, new-value=26, ts=1518374406156 2018-02-11 19:40:07.479 - [34mdebug[39m: sql.0 new value received for xs1.0.Sensors.TempSZ, new-value=21.4, ts=1518374406000, relog=false 2018-02-11 19:40:07.482 - [34mdebug[39m: sql.0 value not changed xs1.0.Sensors.TempSZ, last-value=21.4, new-value=21.4, ts=1518374406000 2018-02-11 19:40:07.484 - [34mdebug[39m: sql.0 new value received for xs1.0.Sensors.LuftfeuchteSZ, new-value=30, ts=1518374406000, relog=false 2018-02-11 19:40:07.484 - [34mdebug[39m: sql.0 value not changed xs1.0.Sensors.LuftfeuchteSZ, last-value=30, new-value=30, ts=1518374406000 2018-02-11 19:40:08.205 - [34mdebug[39m: sql.0 new value received for hm-rpc.0.NEQ1100493.1.TEMPERATURE, new-value=1.5, ts=1518374408199, relog=false 2018-02-11 19:40:08.206 - [34mdebug[39m: sql.0 Min-Delta reached hm-rpc.0.NEQ1100493.1.TEMPERATURE, last-value=1.6, new-value=1.5, ts=1518374408199 2018-02-11 19:40:08.210 - [34mdebug[39m: sql.0 new value received for hm-rpc.0.NEQ1100493.1.HUMIDITY, new-value=75, ts=1518374408205, relog=false 2018-02-11 19:40:08.211 - [34mdebug[39m: sql.0 value not changed hm-rpc.0.NEQ1100493.1.HUMIDITY, last-value=75, new-value=75, ts=1518374408205 2018-02-11 19:40:08.216 - [34mdebug[39m: sql.0 new value received for hm-rpc.0.NEQ1100493.1.RAINING, new-value=false, ts=1518374408208, relog=false 2018-02-11 19:40:08.217 - [34mdebug[39m: sql.0 value not changed hm-rpc.0.NEQ1100493.1.RAINING, last-value=false, new-value=false, ts=1518374408208 2018-02-11 19:40:08.217 - [34mdebug[39m: sql.0 new value received for hm-rpc.0.NEQ1100493.1.RAIN_COUNTER, new-value=111.215, ts=1518374408210, relog=false 2018-02-11 19:40:08.217 - [34mdebug[39m: sql.0 value not changed hm-rpc.0.NEQ1100493.1.RAIN_COUNTER, last-value=111.215, new-value=111.215, ts=1518374408210 2018-02-11 19:40:08.218 - [34mdebug[39m: sql.0 new value received for hm-rpc.0.NEQ1100493.1.WIND_SPEED, new-value=0, ts=1518374408212, relog=false 2018-02-11 19:40:08.218 - [34mdebug[39m: sql.0 value not changed hm-rpc.0.NEQ1100493.1.WIND_SPEED, last-value=0, new-value=0, ts=1518374408212 2018-02-11 19:40:08.269 - [34mdebug[39m: sql.0 new value received for hm-rpc.0.NEQ1100493.1.WIND_DIRECTION, new-value=120, ts=1518374408264, relog=false 2018-02-11 19:40:08.272 - [34mdebug[39m: sql.0 Min-Delta reached hm-rpc.0.NEQ1100493.1.WIND_DIRECTION, last-value=175, new-value=120, ts=1518374408264 2018-02-11 19:40:08.275 - [34mdebug[39m: sql.0 new value received for hm-rpc.0.NEQ1100493.1.WIND_DIRECTION_RANGE, new-value=67, ts=1518374408269, relog=false 2018-02-11 19:40:08.275 - [34mdebug[39m: sql.0 value not changed hm-rpc.0.NEQ1100493.1.WIND_DIRECTION_RANGE, last-value=67, new-value=67, ts=1518374408269 2018-02-11 19:40:08.278 - [34mdebug[39m: sql.0 new value received for hm-rpc.0.NEQ1100493.1.SUNSHINEDURATION, new-value=141, ts=1518374408271, relog=false 2018-02-11 19:40:08.280 - [34mdebug[39m: sql.0 value not changed hm-rpc.0.NEQ1100493.1.SUNSHINEDURATION, last-value=141, new-value=141, ts=1518374408271 2018-02-11 19:40:12.590 - [34mdebug[39m: sql.0 new value received for km200.0.system.heatSources.hs1.actualModulation, new-value=0, ts=1518374412586, relog=false 2018-02-11 19:40:12.591 - [34mdebug[39m: sql.0 Min-Delta reached km200.0.system.heatSources.hs1.actualModulation, last-value=25, new-value=0, ts=1518374412586 2018-02-11 19:40:12.741 - [34mdebug[39m: sql.0 new value received for km200.0.system.heatSources.hs1.actualPower, new-value=0, ts=1518374412736, relog=false 2018-02-11 19:40:12.741 - [34mdebug[39m: sql.0 Min-Delta reached km200.0.system.heatSources.hs1.actualPower, last-value=5, new-value=0, ts=1518374412736 2018-02-11 19:40:13.195 - [34mdebug[39m: sql.0 new value received for xs1.0.Sensors.TempAZS, new-value=21.6, ts=1518374412000, relog=false 2018-02-11 19:40:13.196 - [34mdebug[39m: sql.0 value not changed xs1.0.Sensors.TempAZS, last-value=21.6, new-value=21.6, ts=1518374412000 2018-02-11 19:40:13.202 - [34mdebug[39m: sql.0 new value received for xs1.0.Sensors.LuftfeuchteAZS, new-value=32, ts=1518374412000, relog=false 2018-02-11 19:40:13.202 - [34mdebug[39m: sql.0 value not changed xs1.0.Sensors.LuftfeuchteAZS, last-value=32, new-value=32, ts=1518374412000 2018-02-11 19:40:13.592 - [34mdebug[39m: sql.0 Datatype km200.0.system.heatSources.hs1.actualModulation: Currently: number, StorageType: Number 2018-02-11 19:40:13.595 - [34mdebug[39m: sql.0 INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(57, 1518374412586, 0, true, 8, 0); 2018-02-11 19:40:22.743 - [34mdebug[39m: sql.0 new value received for hm-rpc.0.NEQ0532409.1.TEMPERATURE, new-value=25.4, ts=1518374422737, relog=false 2018-02-11 19:40:22.744 - [34mdebug[39m: sql.0 Datatype km200.0.system.heatSources.hs1.actualPower: Currently: number, StorageType: Number 2018-02-11 19:40:22.745 - [34mdebug[39m: sql.0 INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(69, 1518374412736, 0, true, 8, 0); 2018-02-11 19:40:22.825 - [34mdebug[39m: sql.0 new value received for hm-rpc.0.NEQ0532409.2.TEMPERATURE, new-value=24.9, ts=1518374422820, relog=false 2018-02-11 19:40:22.833 - [34mdebug[39m: sql.0 new value received for hm-rpc.0.NEQ0532409.3.TEMPERATURE, new-value=0.5, ts=1518374422828, relog=false 2018-02-11 19:40:28.395 - [34mdebug[39m: sql.0 new value received for xs1.0.Sensors.TempWZ, new-value=23.4, ts=1518374427000, relog=false 2018-02-11 19:40:28.395 - [34mdebug[39m: sql.0 value not changed xs1.0.Sensors.TempWZ, last-value=23.4, new-value=23.4, ts=1518374427000 2018-02-11 19:40:28.404 - [34mdebug[39m: sql.0 new value received for xs1.0.Sensors.LuftfeuchteWZ, new-value=25, ts=1518374427000, relog=false 2018-02-11 19:40:28.405 - [34mdebug[39m: sql.0 value not changed xs1.0.Sensors.LuftfeuchteWZ, last-value=25, new-value=25, ts=1518374427000 2018-02-11 19:40:32.746 - [34mdebug[39m: sql.0 Datatype hm-rpc.0.NEQ0532409.1.TEMPERATURE: Currently: number, StorageType: false 2018-02-11 19:40:32.747 - [34mdebug[39m: sql.0 Type set in Def for hm-rpc.0.NEQ0532409.1.TEMPERATURE: false 2018-02-11 19:40:32.747 - [34mdebug[39m: sql.0 Type (from DB-Type) for hm-rpc.0.NEQ0532409.1.TEMPERATURE: 0 2018-02-11 19:40:32.748 - [34mdebug[39m: sql.0 INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(19, 1518374422737, 25.4, true, 3, 0); 2018-02-11 19:40:32.825 - [34mdebug[39m: sql.0 Datatype hm-rpc.0.NEQ0532409.2.TEMPERATURE: Currently: number, StorageType: false 2018-02-11 19:40:32.826 - [34mdebug[39m: sql.0 Type set in Def for hm-rpc.0.NEQ0532409.2.TEMPERATURE: false 2018-02-11 19:40:32.827 - [34mdebug[39m: sql.0 Type (from DB-Type) for hm-rpc.0.NEQ0532409.2.TEMPERATURE: 0 2018-02-11 19:40:32.827 - [34mdebug[39m: sql.0 INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(20, 1518374422820, 24.9, true, 3, 0); 2018-02-11 19:40:33.474 - [34mdebug[39m: sql.0 new value received for km200.0.system.sensors.temperatures.hotWater_t2, new-value=50.1, ts=1518374433467, relog=false 2018-02-11 19:40:33.474 - [34mdebug[39m: sql.0 Min-Delta reached km200.0.system.sensors.temperatures.hotWater_t2, last-value=50.6, new-value=50.1, ts=1518374433467 2018-02-11 19:40:33.763 - [34mdebug[39m: sql.0 new value received for km200.0.system.sensors.temperatures.supply_t1, new-value=30, ts=1518374433757, relog=false 2018-02-11 19:40:33.764 - [34mdebug[39m: sql.0 Min-Delta reached km200.0.system.sensors.temperatures.supply_t1, last-value=37.4, new-value=30, ts=1518374433757 2018-02-11 19:40:43.640 - [34mdebug[39m: sql.0 new value received for xs1.0.Sensors.TempSTR, new-value=2, ts=1518374443000, relog=false 2018-02-11 19:40:43.640 - [34mdebug[39m: sql.0 value not changed xs1.0.Sensors.TempSTR, last-value=2, new-value=2, ts=1518374443000 2018-02-11 19:40:43.651 - [34mdebug[39m: sql.0 new value received for xs1.0.Sensors.LuftfeuchteSTR, new-value=57, ts=1518374443000, relog=false 2018-02-11 19:40:43.651 - [34mdebug[39m: sql.0 value not changed xs1.0.Sensors.LuftfeuchteSTR, last-value=57, new-value=57, ts=1518374443000 2018-02-11 19:41:06.429 - [34mdebug[39m: sql.0 new value received for xs1.0.Sensors.TempTER, new-value=2.2, ts=1518374465000, relog=false 2018-02-11 19:41:06.430 - [34mdebug[39m: sql.0 value not changed xs1.0.Sensors.TempTER, last-value=2.2, new-value=2.2, ts=1518374465000 2018-02-11 19:41:06.438 - [34mdebug[39m: sql.0 new value received for xs1.0.Sensors.LuftfeuchteTER, new-value=54, ts=1518374465000, relog=false 2018-02-11 19:41:06.439 - [34mdebug[39m: sql.0 value not changed xs1.0.Sensors.LuftfeuchteTER, last-value=54, new-value=54, ts=1518374465000 2018-02-11 19:41:06.664 - [34mdebug[39m: sql.0 new value received for xs1.0.Sensors.Pool, new-value=3.4, ts=1518374466000, relog=false 2018-02-11 19:41:06.664 - [34mdebug[39m: sql.0 value not changed xs1.0.Sensors.Pool, last-value=3.4, new-value=3.4, ts=1518374466000 2018-02-11 19:41:14.471 - [34mdebug[39m: sql.0 new value received for xs1.0.Sensors.TempSZ, new-value=21.4, ts=1518374473000, relog=false 2018-02-11 19:41:14.472 - [34mdebug[39m: sql.0 value not changed xs1.0.Sensors.TempSZ, last-value=21.4, new-value=21.4, ts=1518374473000 2018-02-11 19:41:14.484 - [34mdebug[39m: sql.0 new value received for xs1.0.Sensors.LuftfeuchteSZ, new-value=30, ts=1518374473000, relog=false 2018-02-11 19:41:14.485 - [34mdebug[39m: sql.0 value not changed xs1.0.Sensors.LuftfeuchteSZ, last-value=30, new-value=30, ts=1518374473000 2018-02-11 19:41:24.194 - [34mdebug[39m: sql.0 new value received for xs1.0.Sensors.TempAZS, new-value=21.6, ts=1518374483000, relog=false 2018-02-11 19:41:24.195 - [34mdebug[39m: sql.0 value not changed xs1.0.Sensors.TempAZS, last-value=21.6, new-value=21.6, ts=1518374483000 2018-02-11 19:41:24.202 - [34mdebug[39m: sql.0 new value received for xs1.0.Sensors.LuftfeuchteAZS, new-value=32, ts=1518374483000, relog=false 2018-02-11 19:41:24.203 - [34mdebug[39m: sql.0 value not changed xs1.0.Sensors.LuftfeuchteAZS, last-value=32, new-value=32, ts=1518374483000 2018-02-11 19:41:27.399 - [34mdebug[39m: sql.0 new value received for xs1.0.Sensors.TempWZ, new-value=23.4, ts=1518374486000, relog=false 2018-02-11 19:41:27.400 - [34mdebug[39m: sql.0 value not changed xs1.0.Sensors.TempWZ, last-value=23.4, new-value=23.4, ts=1518374486000 2018-02-11 19:41:27.406 - [34mdebug[39m: sql.0 new value received for xs1.0.Sensors.LuftfeuchteWZ, new-value=25, ts=1518374486000, relog=false 2018-02-11 19:41:27.407 - [34mdebug[39m: sql.0 value not changed xs1.0.Sensors.LuftfeuchteWZ, last-value=25, new-value=25, ts=1518374486000 2018-02-11 19:41:37.637 - [34mdebug[39m: sql.0 Datatype km200.0.heatSources.hs1.actualPower: Currently: number, StorageType: Number 2018-02-11 19:41:37.638 - [34mdebug[39m: sql.0 Type set in Def for km200.0.heatSources.hs1.actualPower: Number 2018-02-11 19:41:37.639 - [34mdebug[39m: sql.0 Type (from Def) for km200.0.heatSources.hs1.actualPower: 0 2018-02-11 19:41:37.639 - [34mdebug[39m: sql.0 INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(89, 1518374397627, 0, true, 8, 0); 2018-02-11 19:41:40.026 - [34mdebug[39m: sql.0 Datatype systeminfo.0.System.CPU_Temperatur: Currently: number, StorageType: Number 2018-02-11 19:41:40.027 - [34mdebug[39m: sql.0 INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(84, 1518374400021, 55, true, 14, 0); 2018-02-11 19:41:46.166 - [34mdebug[39m: sql.0 Datatype km200.0.heatingCircuits.hc2.actualSupplyTemperature: Currently: number, StorageType: Number 2018-02-11 19:41:46.167 - [34mdebug[39m: sql.0 INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(55, 1518374406156, 26, true, 8, 0); 2018-02-11 19:41:48.272 - [34mdebug[39m: sql.0 Datatype hm-rpc.0.NEQ1100493.1.WIND_DIRECTION: Currently: number, StorageType: Number 2018-02-11 19:41:48.273 - [34mdebug[39m: sql.0 INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(77, 1518374408264, 120, true, 3, 0); 2018-02-11 19:42:00.033 - [34mdebug[39m: sql.0 new value received for systeminfo.0.System.CPU_Temperatur, new-value=59, ts=1518374520029, relog=false 2018-02-11 19:42:00.033 - [34mdebug[39m: sql.0 Min-Delta reached systeminfo.0.System.CPU_Temperatur, last-value=55, new-value=59, ts=1518374520029 2018-02-11 19:42:07.554 - [34mdebug[39m: sql.0 Datatype xs1.0.Sensors.LuftfeuchteSTR: Currently: number, StorageType: false 2018-02-11 19:42:07.555 - [34mdebug[39m: sql.0 Type set in Def for xs1.0.Sensors.LuftfeuchteSTR: false 2018-02-11 19:42:07.556 - [34mdebug[39m: sql.0 Type (from DB-Type) for xs1.0.Sensors.LuftfeuchteSTR: 0 2018-02-11 19:42:07.557 - [34mdebug[39m: sql.0 INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(44, 1518374127000, 57, true, 6, 0); 2018-02-11 19:42:07.674 - [34mdebug[39m: sql.0 new value received for xs1.0.Sensors.Pool, new-value=3.4, ts=1518374527000, relog=false 2018-02-11 19:42:07.675 - [34mdebug[39m: sql.0 value not changed xs1.0.Sensors.Pool, last-value=3.4, new-value=3.4, ts=1518374527000 2018-02-11 19:42:09.200 - [34mdebug[39m: sql.0 Datatype xs1.0.Sensors.TempAZS: Currently: number, StorageType: false 2018-02-11 19:42:09.201 - [34mdebug[39m: sql.0 Type set in Def for xs1.0.Sensors.TempAZS: false 2018-02-11 19:42:09.202 - [34mdebug[39m: sql.0 Type (from DB-Type) for xs1.0.Sensors.TempAZS: 0 2018-02-11 19:42:09.202 - [34mdebug[39m: sql.0 INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(38, 1518374128000, 21.6, true, 6, 0); 2018-02-11 19:42:09.207 - [34mdebug[39m: sql.0 Datatype xs1.0.Sensors.LuftfeuchteAZS: Currently: number, StorageType: false 2018-02-11 19:42:09.208 - [34mdebug[39m: sql.0 Type set in Def for xs1.0.Sensors.LuftfeuchteAZS: false 2018-02-11 19:42:09.209 - [34mdebug[39m: sql.0 Type (from DB-Type) for xs1.0.Sensors.LuftfeuchteAZS: 0 2018-02-11 19:42:09.209 - [34mdebug[39m: sql.0 INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(39, 1518374128000, 32, true, 6, 0); 2018-02-11 19:42:13.409 - [34mdebug[39m: sql.0 Datatype xs1.0.Sensors.TempWZ: Currently: number, StorageType: false 2018-02-11 19:42:13.410 - [34mdebug[39m: sql.0 Type set in Def for xs1.0.Sensors.TempWZ: false 2018-02-11 19:42:13.411 - [34mdebug[39m: sql.0 Type (from DB-Type) for xs1.0.Sensors.TempWZ: 0 2018-02-11 19:42:13.412 - [34mdebug[39m: sql.0 INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(41, 1518374132000, 23.4, true, 6, 0); 2018-02-11 19:42:13.415 - [34mdebug[39m: sql.0 Datatype xs1.0.Sensors.LuftfeuchteWZ: Currently: number, StorageType: false 2018-02-11 19:42:13.416 - [34mdebug[39m: sql.0 Type set in Def for xs1.0.Sensors.LuftfeuchteWZ: false 2018-02-11 19:42:13.416 - [34mdebug[39m: sql.0 Type (from DB-Type) for xs1.0.Sensors.LuftfeuchteWZ: 0 2018-02-11 19:42:13.417 - [34mdebug[39m: sql.0 INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(35, 1518374132000, 25, true, 6, 0); 2018-02-11 19:42:13.475 - [34mdebug[39m: sql.0 Datatype km200.0.system.sensors.temperatures.hotWater_t2: Currently: number, StorageType: Number 2018-02-11 19:42:13.476 - [34mdebug[39m: sql.0 INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(47, 1518374433467, 50.1, true, 8, 0); 2018-02-11 19:42:13.765 - [34mdebug[39m: sql.0 Datatype km200.0.system.sensors.temperatures.supply_t1: Currently: number, StorageType: Number 2018-02-11 19:42:13.766 - [34mdebug[39m: sql.0 INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(51, 1518374433757, 30, true, 8, 0); 2018-02-11 19:42:14.449 - [34mdebug[39m: sql.0 Datatype xs1.0.Sensors.LuftfeuchteTER: Currently: number, StorageType: Number 2018-02-11 19:42:14.450 - [34mdebug[39m: sql.0 INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(36, 1518374382000, 54, true, 6, 0); 2018-02-11 19:42:19.484 - [34mdebug[39m: sql.0 Datatype xs1.0.Sensors.TempSZ: Currently: number, StorageType: false 2018-02-11 19:42:19.485 - [34mdebug[39m: sql.0 Type set in Def for xs1.0.Sensors.TempSZ: false 2018-02-11 19:42:19.486 - [34mdebug[39m: sql.0 Type (from DB-Type) for xs1.0.Sensors.TempSZ: 0 2018-02-11 19:42:19.486 - [34mdebug[39m: sql.0 INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(40, 1518374138000, 21.4, true, 6, 0); 2018-02-11 19:42:19.490 - [34mdebug[39m: sql.0 Datatype xs1.0.Sensors.LuftfeuchteSZ: Currently: number, StorageType: false 2018-02-11 19:42:19.491 - [34mdebug[39m: sql.0 Type set in Def for xs1.0.Sensors.LuftfeuchteSZ: false 2018-02-11 19:42:19.492 - [34mdebug[39m: sql.0 Type (from DB-Type) for xs1.0.Sensors.LuftfeuchteSZ: 0 2018-02-11 19:42:19.492 - [34mdebug[39m: sql.0 INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(34, 1518374138000, 30, true, 6, 0); 2018-02-11 19:42:19.958 - [34mdebug[39m: sql.0 Datatype hm-rpc.0.NEQ1100493.1.HUMIDITY: Currently: number, StorageType: false 2018-02-11 19:42:19.959 - [34mdebug[39m: sql.0 Type set in Def for hm-rpc.0.NEQ1100493.1.HUMIDITY: false 2018-02-11 19:42:19.960 - [34mdebug[39m: sql.0 Type (from DB-Type) for hm-rpc.0.NEQ1100493.1.HUMIDITY: 0 2018-02-11 19:42:19.960 - [34mdebug[39m: sql.0 INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(72, 1518374239951, 75, true, 3, 0); 2018-02-11 19:42:21.476 - [34mdebug[39m: sql.0 new value received for xs1.0.Sensors.TempSZ, new-value=21.4, ts=1518374540000, relog=false 2018-02-11 19:42:21.477 - [34mdebug[39m: sql.0 value not changed xs1.0.Sensors.TempSZ, last-value=21.4, new-value=21.4, ts=1518374540000 2018-02-11 19:42:21.485 - [34mdebug[39m: sql.0 new value received for xs1.0.Sensors.LuftfeuchteSZ, new-value=30, ts=1518374540000, relog=false 2018-02-11 19:42:21.486 - [34mdebug[39m: sql.0 value not changed xs1.0.Sensors.LuftfeuchteSZ, last-value=30, new-value=30, ts=1518374540000 2018-02-11 19:42:26.403 - [34mdebug[39m: sql.0 new value received for xs1.0.Sensors.TempWZ, new-value=23.4, ts=1518374545000, relog=false 2018-02-11 19:42:26.415 - [34mdebug[39m: sql.0 value not changed xs1.0.Sensors.TempWZ, last-value=23.4, new-value=23.4, ts=1518374545000 2018-02-11 19:42:26.422 - [34mdebug[39m: sql.0 new value received for xs1.0.Sensors.LuftfeuchteWZ, new-value=25, ts=1518374545000, relog=false 2018-02-11 19:42:26.422 - [34mdebug[39m: sql.0 value not changed xs1.0.Sensors.LuftfeuchteWZ, last-value=25, new-value=25, ts=1518374545000 2018-02-11 19:42:29.426 - [34mdebug[39m: sql.0 new value received for xs1.0.Sensors.TempTER, new-value=2.2, ts=1518374548000, relog=false 2018-02-11 19:42:29.427 - [34mdebug[39m: sql.0 value not changed xs1.0.Sensors.TempTER, last-value=2.2, new-value=2.2, ts=1518374548000 2018-02-11 19:42:29.439 - [34mdebug[39m: sql.0 new value received for xs1.0.Sensors.LuftfeuchteTER, new-value=54, ts=1518374548000, relog=false 2018-02-11 19:42:29.440 - [34mdebug[39m: sql.0 value not changed xs1.0.Sensors.LuftfeuchteTER, last-value=54, new-value=54, ts=1518374548000 2018-02-11 19:42:35.196 - [34mdebug[39m: sql.0 new value received for xs1.0.Sensors.TempAZS, new-value=21.6, ts=1518374554000, relog=false 2018-02-11 19:42:35.196 - [34mdebug[39m: sql.0 value not changed xs1.0.Sensors.TempAZS, last-value=21.6, new-value=21.6, ts=1518374554000 2018-02-11 19:42:35.203 - [34mdebug[39m: sql.0 new value received for xs1.0.Sensors.LuftfeuchteAZS, new-value=32, ts=1518374554000, relog=false 2018-02-11 19:42:35.204 - [34mdebug[39m: sql.0 value not changed xs1.0.Sensors.LuftfeuchteAZS, last-value=32, new-value=32, ts=1518374554000 2018-02-11 19:42:41.929 - [34mdebug[39m: sql.0 new value received for hm-rpc.0.NEQ1100493.1.TEMPERATURE, new-value=1.5, ts=1518374561926, relog=false 2018-02-11 19:42:41.929 - [34mdebug[39m: sql.0 value not changed hm-rpc.0.NEQ1100493.1.TEMPERATURE, last-value=1.5, new-value=1.5, ts=1518374561926 2018-02-11 19:42:41.951 - [34mdebug[39m: sql.0 new value received for hm-rpc.0.NEQ1100493.1.HUMIDITY, new-value=76, ts=1518374561947, relog=false 2018-02-11 19:42:41.952 - [34mdebug[39m: sql.0 Min-Delta reached hm-rpc.0.NEQ1100493.1.HUMIDITY, last-value=75, new-value=76, ts=1518374561947 2018-02-11 19:42:41.952 - [34mdebug[39m: sql.0 Datatype hm-rpc.0.NEQ1100493.1.HUMIDITY: Currently: number, StorageType: Number 2018-02-11 19:42:41.952 - [34mdebug[39m: sql.0 INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(72, 1518374408205, 75, true, 3, 0); 2018-02-11 19:42:41.977 - [34mdebug[39m: sql.0 new value received for hm-rpc.0.NEQ1100493.1.RAINING, new-value=false, ts=1518374561974, relog=false 2018-02-11 19:42:41.977 - [34mdebug[39m: sql.0 value not changed hm-rpc.0.NEQ1100493.1.RAINING, last-value=false, new-value=false, ts=1518374561974 2018-02-11 19:42:41.980 - [34mdebug[39m: sql.0 new value received for hm-rpc.0.NEQ1100493.1.RAIN_COUNTER, new-value=111.215, ts=1518374561976, relog=false 2018-02-11 19:42:41.981 - [34mdebug[39m: sql.0 value not changed hm-rpc.0.NEQ1100493.1.RAIN_COUNTER, last-value=111.215, new-value=111.215, ts=1518374561976 2018-02-11 19:42:41.986 - [34mdebug[39m: sql.0 new value received for hm-rpc.0.NEQ1100493.1.WIND_SPEED, new-value=0, ts=1518374561978, relog=false 2018-02-11 19:42:41.986 - [34mdebug[39m: sql.0 value not changed hm-rpc.0.NEQ1100493.1.WIND_SPEED, last-value=0, new-value=0, ts=1518374561978 2018-02-11 19:42:41.987 - [34mdebug[39m: sql.0 new value received for hm-rpc.0.NEQ1100493.1.WIND_DIRECTION, new-value=80, ts=1518374561978, relog=false 2018-02-11 19:42:41.987 - [34mdebug[39m: sql.0 Min-Delta reached hm-rpc.0.NEQ1100493.1.WIND_DIRECTION, last-value=120, new-value=80, ts=1518374561978 2018-02-11 19:42:41.990 - [34mdebug[39m: sql.0 new value received for hm-rpc.0.NEQ1100493.1.WIND_DIRECTION_RANGE, new-value=67, ts=1518374561980, relog=false 2018-02-11 19:42:41.993 - [34mdebug[39m: sql.0 value not changed hm-rpc.0.NEQ1100493.1.WIND_DIRECTION_RANGE, last-value=67, new-value=67, ts=1518374561980 2018-02-11 19:42:41.993 - [34mdebug[39m: sql.0 new value received for hm-rpc.0.NEQ1100493.1.SUNSHINEDURATION, new-value=141, ts=1518374561983, relog=false 2018-02-11 19:42:41.994 - [34mdebug[39m: sql.0 value not changed hm-rpc.0.NEQ1100493.1.SUNSHINEDURATION, last-value=141, new-value=141, ts=1518374561983 !

Der Fehler passiert hach getHistory wo

SELECT ts, val FROM undefined WHERE  undefined.id=88 AND undefined.ts < 1518374156832 AND undefined.ts >= 1518287756832 UNION ( SELECT ts, val FROM undefined WHERE  undefined.id=88 AND undefined.ts < 1518287756832 ORDER BY undefined.ts DESC LIMIT 1) UNION ( SELECT ts, val FROM undefined WHERE  undefined.id=88 AND undefined.ts >= 1518374156832 ORDER BY undefined.ts ASC LIMIT 1) ORDER BY ts ASC

als SQL generiert wird!

Da der content von getHistory gleich ist wie vorher ist da etwas bei der SQL-Erzeugung faul da es undefined anstatt ts_number liefert.

[sissiwup]

Hallo,

ich hab noch ein neues Problem festgestellt:

Ich habe ein neues Heizkörperthermostat.

Ich logge da Ventil, Aktuelle Temperatur und Soll(set)-Temperatur.

Ventil, Aktuelle Temperatur laufen. Soll Temperatur (wird natürlich seltener geändert)

wird nicht mehr geloggt. Dieser Datenpunkt steht auf "Änderungen". Alle anderen sind

ohne "Änderungen".

Kann das noch wer feststellen?

[sissiwup]

Noch eine weitere Unschönheit:

Ändere ich auch nur irgendetwas an einen Datenpunkt, wird dieser bis er einen Wert loggt

nicht mehr abfragbar. Warum wird hier nicht der Wert aus der Datenbank genommen?

Es hilft auch nichts den Datenpunkt von Automatisch auf den korrekten Wert zu stellen.

Ich habe durchaus Datenpunkte, die nur einmal pro Woche Aktiv werden, oder seltener (z.B. ausgelöster Alarm).

Die kann ich dann erst wieder anzeigen, wenn ich einmal Alarm ausgelöst habe. :?:

[Kueppert]

Hi Sissi,

ich hatte Probleme mit den Adapter, allerdings wurde immer geloggt. Ich nutze auch die Option, nur Änderungen zu speichern. Mach Mal einen Screen von deinen SQL Einstellungen für das Objekt.

Dass die Werte in Objekt unter Tabelle nicht angezeigt werden hatte ich auch. Die Werte sind allerdings noch alle da. Das Phänomen hatte ich aber nur, wenn ich den Adapter neu gestartet habe oder den Datentyp von automatisch auf was aber geändert habe…

VG Thorsten

Gesendet von meinem HUAWEI RIO-L01 mit Tapatalk

[sissiwup]

Hallo,

anbei eine weitere Merkwürdigkeit:

kommt mit Fehler:

sql.0	2018-02-16 09:11:37.702	error	Please wait till next data record is logged and reload.
sql.0	2018-02-16 09:11:37.701	warn	For getHistory for id hm-rpc.0.LEQ1023360.1.LEVEL: Type empty. Need to write data first. Index = undefined

in der DB ist aber:

sauber hinterlegt.

Kann es sein das er type = 0 als nicht vorhanden erkennt?

[sissiwup]

@Kueppert:

Hi Sissi,

ich hatte Probleme mit den Adapter, allerdings wurde immer geloggt. Ich nutze auch die Option, nur Änderungen zu speichern. Mach Mal einen Screen von deinen SQL Einstellungen für das Objekt.

Dass die Werte in Objekt unter Tabelle nicht angezeigt werden hatte ich auch. Die Werte sind allerdings noch alle da. Das Phänomen hatte ich aber nur, wenn ich den Adapter neu gestartet habe oder den Datentyp von automatisch auf was aber geändert habe…

VG Thorsten

Gesendet von meinem HUAWEI RIO-L01 mit Tapatalk `

Hallo,

habe das "Änderung" rausgenommen. Jetzt geht er wieder.

[sissiwup]

Habe das Parallel-Schreiben rausgenommen, da 1500 Connections nicht ausgereicht haben:

sql.0	2018-02-16 20:23:18.586	error	Cannot queue new requests, because more than 100
sql.0	2018-02-16 20:23:18.573	error	Cannot queue new requests, because more than 100
sql.0	2018-02-16 20:23:16.117	error	Cannot queue new requests, because more than 100
sql.0	2018-02-16 20:23:16.083	error	Cannot queue new requests, because more than 100
sql.0	2018-02-16 20:23:16.061	error	Cannot queue new requests, because more than 100

was kann man da machen?

[Kueppert]

Wohin speicherst du deine Daten? Auf eine Synology? Da kannst du via phpmyadmin dem User unbegrenzt Verbindungen einräumen. Evtl hilft das…

Gesendet von meinem HUAWEI RIO-L01 mit Tapatalk

[sissiwup]

@Kueppert:

Wohin speicherst du deine Daten? Auf eine Synology? Da kannst du via phpmyadmin dem Bedburger unbegrenzt Verbindungen einräumen. Evtl hilft das…

Gesendet von meinem HUAWEI RIO-L01 mit Tapatalk `

Ne, ist ein Server. Der kann 1500 Verbindungen….

[apollon77]

@fsjoke:

Ok, hab mir Flot 1.7.5 mal angeschaut.

… `

flot 1.7.6 hat das ersetzt durch console.error.

@sissiwup:

Ändere ich auch nur irgendetwas an einen Datenpunkt, wird dieser bis er einen Wert loggt

nicht mehr abfragbar. Warum wird hier nicht der Wert aus der Datenbank genommen?

Es hilft auch nichts den Datenpunkt von Automatisch auf den korrekten Wert zu stellen. `

Bitte 1.7.1 von sql ansehen. Ich habe bei History mal eingebaut das der DBtyp (falls vorhanden) genutzt wird. Die Logik war vorher "zu vorsichtig"

[apollon77]

@sissiwup:

Habe das Parallel-Schreiben rausgenommen, da 1500 Connections nicht ausgereicht haben:

sql.0	2018-02-16 20:23:18.586	error	Cannot queue new requests, because more than 100
sql.0	2018-02-16 20:23:18.573	error	Cannot queue new requests, because more than 100
sql.0	2018-02-16 20:23:16.117	error	Cannot queue new requests, because more than 100
sql.0	2018-02-16 20:23:16.083	error	Cannot queue new requests, because more than 100
sql.0	2018-02-16 20:23:16.061	error	Cannot queue new requests, because more than 100

was kann man da machen? `

Was genau meinst Du?

Parallele Requests = Eingeschaltet sollte diese Fehlermeldung niemals generieren!

Wie kommst Du darauf das 1500 Requests nicht ausgereicht haben? Gab es Connection Fehler?

[sissiwup]

@apollon77:

@sissiwup:

Habe das Parallel-Schreiben rausgenommen, da 1500 Connections nicht ausgereicht haben:

sql.0	2018-02-16 20:23:18.586	error	Cannot queue new requests, because more than 100
sql.0	2018-02-16 20:23:18.573	error	Cannot queue new requests, because more than 100
sql.0	2018-02-16 20:23:16.117	error	Cannot queue new requests, because more than 100
sql.0	2018-02-16 20:23:16.083	error	Cannot queue new requests, because more than 100
sql.0	2018-02-16 20:23:16.061	error	Cannot queue new requests, because more than 100

was kann man da machen? `

Was genau meinst Du?

Parallele Requests = Eingeschaltet sollte diese Fehlermeldung niemals generieren!

Wie kommst Du darauf das 1500 Requests nicht ausgereicht haben? Gab es Connection Fehler? `

Hallo,

ja, die DB hat einen Fehler zuviele Connections angezeigt. Und da sind 1500 angelegt.

[sissiwup]

Hallo,

seit 1.7.0 gibt es wieder vermehrt duplicate Keys:

host.zotac	2018-02-17 08:06:09.026	info	instance system.adapter.yr.0 terminated with code 0 (OK)
sql.0	2018-02-17 08:06:05.171	error	Cannot insert INSERT INTO `iobroker`.ts_number (id, ts, val, ack, _from, q) VALUES(236, 1518851163950, 1024, 1, 4, 0);: Error: ER_DUP_ENTRY: Duplicate entry '236-1518851163950' for key 'PRIMARY'
sql.0	2018-02-17 08:06:05.144	error	Cannot insert INSERT INTO `iobroker`.ts_number (id, ts, val, ack, _from, q) VALUES(236, 1518851163949, 1024, 1, 4, 0);: Error: ER_DUP_ENTRY: Duplicate entry '236-1518851163949' for key 'PRIMARY'
sql.0	2018-02-17 08:06:05.142	error	Cannot insert INSERT INTO `iobroker`.ts_number (id, ts, val, ack, _from, q) VALUES(236, 1518851163950, 1024, 1, 4, 0);: Error: ER_DUP_ENTRY: Duplicate entry '236-1518851163950' for key 'PRIMARY'
sql.0	2018-02-17 08:06:05.139	error	Cannot insert INSERT INTO `iobroker`.ts_number (id, ts, val, ack, _from, q) VALUES(236, 1518851163949, 1024, 1, 4, 0);: Error: ER_DUP_ENTRY: Duplicate entry '236-1518851163949' for key 'PRIMARY'
sql.0	2018-02-17 08:06:05.136	error	Cannot insert INSERT INTO `iobroker`.ts_number (id, ts, val, ack, _from, q) VALUES(236, 1518851163950, 1024, 1, 4, 0);: Error: ER_DUP_ENTRY: Duplicate entry '236-1518851163950' for key 'PRIMARY'
sql.0	2018-02-17 08:06:05.120	error	Cannot insert INSERT INTO `iobroker`.ts_number (id, ts, val, ack, _from, q) VALUES(236, 1518851163949, 1024, 1, 4, 0);: Error: ER_DUP_ENTRY: Duplicate entry '236-1518851163949' for key 'PRIMARY'
yr.0	2018-02-17 08:06:03.918	info	got weather data from yr.no

host.zotac	2018-02-17 07:30:00.065	info	instance system.adapter.tankerkoenig.0 started with pid 11094
sql.0	2018-02-17 07:29:26.746	error	Cannot insert INSERT INTO `iobroker`.ts_string (id, ts, val, ack, _from, q) VALUES(1617, 1518848965643, 'VS-16 EG Trepphaus AUF', 0, 13, 0);: Error: ER_DUP_ENTRY: Duplicate entry '1617-1518848965643'
sql.0	2018-02-17 07:29:26.727	error	Cannot insert INSERT INTO `iobroker`.ts_string (id, ts, val, ack, _from, q) VALUES(1617, 1518848965643, 'VS-16 EG Trepphaus AUF', 0, 13, 0);: Error: ER_DUP_ENTRY: Duplicate entry '1617-1518848965643'
sql.0	2018-02-17 07:29:26.724	error	Cannot insert INSERT INTO `iobroker`.ts_string (id, ts, val, ack, _from, q) VALUES(1617, 1518848965642, 'VS-16 EG Trepphaus AUF', 0, 13, 0);: Error: ER_DUP_ENTRY: Duplicate entry '1617-1518848965642'
sql.0	2018-02-17 07:29:26.715	error	Cannot insert INSERT INTO `iobroker`.ts_string (id, ts, val, ack, _from, q) VALUES(1617, 1518848965642, 'VS-16 EG Trepphaus AUF', 0, 13, 0);: Error: ER_DUP_ENTRY: Duplicate entry '1617-1518848965642'
sql.0	2018-02-17 07:29:26.704	error	Cannot insert INSERT INTO `iobroker`.ts_string (id, ts, val, ack, _from, q) VALUES(1617, 1518848965642, 'VS-16 EG Trepphaus AUF', 0, 13, 0);: Error: ER_DUP_ENTRY: Duplicate entry '1617-1518848965642'
sql.0	2018-02-17 07:29:26.701	error	Cannot insert INSERT INTO `iobroker`.ts_string (id, ts, val, ack, _from, q) VALUES(1617, 1518848965643, 'VS-16 EG Trepphaus AUF', 0, 13, 0);: Error: ER_DUP_ENTRY: Duplicate entry '1617-1518848965643'
javascript.0	2018-02-17 07:20:00.852	info	script.js.servicemeldungen: Text Homematic-Servicemeldungen: keine Servicemeldungen

Der erste Punkt wird vom Wetter-Adaper yr gesetzt und ist der Druck.

Der zweite Punkt wird vom Skript-Adapter geschrieben. Allerdings nur einmal, da die Loggausgaben vom Skript auch nur einmal kommen.

Wie entstehen die doppelten Werte?

In der Datenbank kommen im zweiten Fall auch 2 Einträge an.

Was mich wundert ist, da der Entprelltimer auf 1000ms steht.

[sissiwup]

Noch eine kleine Unschönheit:

Wenn man für mehre Werte die Vorgaben ändern möchte:

Dann geht das für Änderungen Aufzeichnen nicht, wenn es unterschiedliche Werte gibt.

Für alle anderen kann man es für mehrere Datenpunkte gleichzeitig anpassen.