[Aufruf] Dringender Test sql 1.6.4
-
Hallo,
ein merkwürdiges Problem:
Auswirkungen: Es werden wieder ein paar Null Werte in die Tabelle geschrieben.
Das passiert nur beim Neustart des ioBrokers (Mache ich jede Nacht um 4:00 zur Datensicherung)
Danach ist alles wieder stabil. War vorher nicht so, da hat er wenigstens keine "NULL" Werte geschrieben.
Lösche ich aktuell mit:
DELETE FROM `ts_string` WHERE q = 64;64 steht wohl für vom Adapter geraten …
Kann ich das irgendwie verhindern, das er das macht?
Ich habe das jetzt erstmal über einen Trigger verhindert:
CREATE DEFINER=`root`@`localhost` TRIGGER `DEL_NULL` BEFORE INSERT ON `ts_string` FOR EACH ROW if NEW.val = NULL then set NEW.id = NULL; end if -
Die null Werte sind Absicht. Beim stop der sql Instanz wird ein null als „Ende der datenaufzeichnung“ Markierung geschrieben und beim Start als „Beginn“ Markierung. Unterschied zur 1.6.1 … die null landen jetzt in der richtigen datentabelle.
Die Query Fehler: von wann ist das? Auch vom restart? Hast du ne Idee wie ein leerer wert Zustandekommen kann? Welcher Datenpunkt ist das?
-
Auswirkungen: Es werden wieder ein paar Null Werte in die Tabelle geschrieben.
Das passiert nur beim Neustart des ioBrokers (Mache ich jede Nacht um 4:00 zur Datensicherung)
Danach ist alles wieder stabil. War vorher nicht so, da hat er wenigstens keine "NULL" Werte geschrieben. ` Das ist kein "Problem" sondern das normale Verhalten nach einem Neustart des Adapters.
apollon77 hat das etwas weiter oben beschrieben/erläutert
[EDIT]Wie ich sehe war apollon77 mit seiner Antwort schneller 8-)
-
Ps: könnten die Query Fehler davon kommen das manchmal eine Zahl und manchmal „geschlossen“ da drin steht? Oder wird das in nem String Feld gespeichert?
-
Hallo,
ist ein String-Feld.
Ist halt blöd für die Anzeige in vis, da hier die NULL-Werte angezeigt werden.
-
Kannst du null Werte nicht ignorieren?
Ansonsten ist die Frage (mal wieder) ob man zum Backup wirklich iobroker beenden muss. Ich tue das nicht
-
Ansonsten ist die Frage (mal wieder) ob man zum Backup wirklich iobroker beenden muss. Ich tue das nicht
` Ich auch nicht 8-)Ich lasse Nachts um 04:00h ein Image der SD-Karte auf mein NAS schreiben und im Falle eines Problems habe ich innerhalb von 20 Minuten (so lange dauert es ein 16GB Image auf die SD-Karte zu schreiben) ein funktionierendes Image auf eine SD zurückgespielt. Dafür liegt immer eine Ersatz-SD Karte im Schrank.
-
Man besten vorher iobroker Backup ausführen. Dann hast du beides.
Ich hab ein inkrementelles Backup und rsynce noch das iobroker Verzeichnis auf nen zweiten Rechner.
Am Ende ändert sich nur objects.json und ggf states.json Rest ist recht statisch wenn man nichts ändert.
-
Kannst du null Werte nicht ignorieren?
Ansonsten ist die Frage (mal wieder) ob man zum Backup wirklich iobroker beenden muss. Ich tue das nicht
`Hallo,
wofür sollen die null-Werte gut sein?
Es ist das Standard-Element von VIS, da kann man leider nichts einstellen.
Oder übersehe ich da etwas?
<u>Offtopic:</u>
Das mit den Neustarten muss vlt. nicht mehr sein. Starte aber alles um 4:00 neu.
Aktuell ist das auch gut so, wenn ich sehe wie oft sich irgendein Adapter wegängt
und aufeinmal keine Werte mehr liefert. Habe aktuell z.B. Probleme mit dem REGA-Adapter,
da kommen halt manchmal manche Ereignisse nicht an.
Der andere Adapter läuft aber in der Zeit tadellos (also kein Netzwerk oder ähnliches).
Außerdem halten sich ausfälle so sehr begrenzt, wenn ich mal ein paar Tage weg bin.
-
Auswirkungen: Es werden wieder ein paar Null Werte in die Tabelle geschrieben.
Das passiert nur beim Neustart des ioBrokers (Mache ich jede Nacht um 4:00 zur Datensicherung)
Danach ist alles wieder stabil. War vorher nicht so, da hat er wenigstens keine "NULL" Werte geschrieben. ` Das ist kein "Problem" sondern das normale Verhalten nach einem Neustart des Adapters.
apollon77 hat das etwas weiter oben beschrieben/erläutert
[EDIT]Wie ich sehe war apollon77 mit seiner Antwort schneller 8-) `
Auch das mit der Fehlermeldung?
sql.0 2018-02-04 04:11:32.471 error Cannot insert INSERT INTO `iobroker`.ts_number (id, ts, val, ack, _from, q) VALUES(1550, 1517713892257, , 0, 0, 0);: Error: ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that sql.0 2018-02-04 04:11:32.347 error Cannot insert INSERT INTO `iobroker`.ts_number (id, ts, val, ack, _from, q) VALUES(1549, 1517713892256, , 1, 6, 0);: Error: ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that -
Die Fehlermeldung natürlich nicht. Siehe meine Fragen dazu weiter oben. Irgendwie kommt in einem zahlenfeld ein leerer Wert rein. Wann passiert es? Beim restart bzw indem Fall danach scheinbar. Kannst du es mit einem iobroker stop/Start reproduzieren? Wenn ja bitte mal sql auf Debug stellen und iobroker neu starten. Das log sollte zeigen was genau passiert.
Zu vis history: mach im GitHub mal ein issue auf, vllt kann man eine „ignoriere null“ Einstellung hinzufügen …
-
Also sissiwup,
ich hab auf Github mal eine Kleinigkeit geändert.
Wenn die "eigentlich richtigen typen" denen der ioBroker-Objekte entsprechen (was meistens der Fall sein sollte) dann kann man jetzt in der "datapoints"-tabelle die "type"-SPalte auf NULL setzen und beim nächsten Start bzw beim ersten Loggen von Daten sollte der korrekte Typ aktualisiert werden.
Am besten erstmal mit 1-2 Datenpunkten versuchen bevor du alle Typen killst
Ist das vllt ein "Fix" ?! `
Klappt nicht:
sql.0 2018-02-04 18:03:37.659 error Cannot insert INSERT INTO `iobroker`.undefined (id, ts, val, ack, _from, q) VALUES(1563, 1517763807597, , 1, 6, 0);: Error: ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that sql.0 2018-02-04 18:03:28.966 error Error: ER_NO_SUCH_TABLE: Table 'iobroker.undefined' doesn't exist fritzbox.0 2018-02-04 18:03:27.558 info data from 192.168.1.100: 04.02.18 18:03:27;DISCONNECT;1;0; sql.0 2018-02-04 18:03:23.970 error Cannot insert INSERT INTO `iobroker`.undefined (id, ts, val, ack, _from, q) VALUES(1563, 1517763803920, 057239588336, 1, 6, 0);: Error: ER_NO_SUCH_TABLE: Table 'iobroker.undefined' doesn't exist fritzbox.0 2018-02-04 18:03:23.823 info data from 192.168.1.100: 04.02.18 18:03:23;DISCONNECT;2;0; fritzbox.0 2018-02-04 18:03:23.812 info data from 192.168.1.100: 04.02.18 18:03:23;RING;2;057239588336;9588336;SIP1; fritzbox.0 2018-02-04 18:03:23.351 info data from 192.168.1.100: 04.02.18 18:03:23;CALL;1;12;9588336;9588336;SIP1; sql.0 2018-02-04 18:02:46.360 error Error: ER_NO_SUCH_TABLE: Table 'iobroker.undefined' doesn't exist sql.0 2018-02-04 18:01:50.086 error Cannot delete DELETE FROM `iobroker`.undefined WHERE id=1550 AND ts < 1454691660768;: Error: ER_NO_SUCH_TABLE: Table 'iobroker.undefined' doesn't exist sql.0 2018-02-04 18:01:50.033 error Cannot delete DELETE FROM `iobroker`.undefined WHERE id=1563 AND ts < 1454691660662;: Error: ER_NO_SUCH_TABLE: Table 'iobroker.undefined' doesn't exist sql.0 2018-02-04 18:01:49.767 error Cannot insert INSERT INTO `iobroker`.undefined (id, ts, val, ack, _from, q) VALUES(1550, 1517763694492, NULL, 1, 15, 64);: Error: ER_NO_SUCH_TABLE: Table 'iobroker.undefined' doesn't exist sql.0 2018-02-04 18:01:49.661 error Cannot insert INSERT INTO `iobroker`.undefined (id, ts, val, ack, _from, q) VALUES(1563, 1517763694492, NULL, 1, 15, 64);: Error: ER_NO_SUCH_TABLE: Table 'iobroker.undefined' doesn't exist sql.0 2018-02-04 18:01:47.199 error Cannot delete DELETE FROM `iobroker`.undefined WHERE id=1549 AND ts < 1454691660227;: Error: ER_NO_SUCH_TABLE: Table 'iobroker.undefined' doesn't exist sql.0 2018-02-04 18:01:44.171 error Cannot insert INSERT INTO `iobroker`.undefined (id, ts, val, ack, _from, q) VALUES(1549, 1517763694492, NULL, 1, 15, 64);: Error: ER_NO_SUCH_TABLE: Table 'iobroker.undefined' doesn't exist host.zotac 2018-02-04 18:01:32.233 info instance system.adapter.sql.0 started with pid 26685 host.zotac 2018-02-04 18:01:30.681 info instance system.adapter.sql.0 terminated with code 0 (OK) Caught 2018-02-04 18:01:30.680 error by controller[3]: 2018-02-04 18:01:30.562 - sql.0 Cannot delete DELETE FROM `iobroker`.undefined WHERE id=1549 AND ts < 1454691660553;: Error: ER_NO_SUCH_TABLE: Table 'iobroker.undefined' doesn't e Caught 2018-02-04 18:01:30.680 error by controller[2]: 2018-02-04 18:01:30.550 - sql.0 Cannot insert INSERT INTO `iobroker`.undefined (id, ts, val, ack, _from, q) VALUES(1549, 1517763687678, NULL, 0, 15, 64);: Error: ER_NO_SUCH_TABLE: Caught 2018-02-04 18:01:30.679 error by controller[1]: 2018-02-04 18:01:29.833 - sql.0 Cannot insert INSERT INTO `iobroker`.undefined (id, ts, val, ack, _from, q) VALUES(1550, 1517763687678, NULL, 0, 15, 64);: Error: ER_NO_SUCH_TABLE: sql.0 2018-02-04 18:01:30.562 error Cannot delete DELETE FROM `iobroker`.undefined WHERE id=1549 AND ts < 1454691660553;: Error: ER_NO_SUCH_TABLE: Table 'iobroker.undefined' doesn't exist sql.0 2018-02-04 18:01:30.550 error Cannot insert INSERT INTO `iobroker`.undefined (id, ts, val, ack, _from, q) VALUES(1549, 1517763687678, NULL, 0, 15, 64);: Error: ER_NO_SUCH_TABLE: Table 'iobroker.undefined' doesn't exist sql.0 2018-02-04 18:01:29.821 error Cannot insert INSERT INTO `iobroker`.undefined (id, ts, val, ack, _from, q) VALUES(1550, 1517763687678, NULL, 0, 15, 64);: Error: ER_NO_SUCH_TABLE: Table 'iobroker.undefined' doesn't existSQL fom GITHUB geladen
Datenpunkt 1563 auf NULL geändert.
SQL neu gestartet.
Datenpunkt geändert (steht auf automatisch).
Gleiche für 1550 und 1549
-
Verhindern der NULL-Werte:
CREATE DEFINER=`root`@`localhost` TRIGGER `DEL_NULL` BEFORE INSERT ON `ts_string` FOR EACH ROW if NEW.q = 64 then set NEW.ts = NULL; end ifDas erzeugt zwar im log böse Fehlermeldungen, dafür ist die Historie sauber.
-
Zu vis history: mach im GitHub mal ein issue auf, vllt kann man eine „ignoriere null“ Einstellung hinzufügen … `
=> https://github.com/ioBroker/ioBroker.vis/issues/162
closed vis History #162
-
Zu 1563 und so: Debug log bitte. Sonst rate ich ewig im Code rum und wir machen zig weitere Versuche
-
Zu 1563 und so: Debug log bitte. Sonst rate ich ewig im Code rum und wir machen zig weitere Versuche `
Das ist verdammt viel: Habe es auf 1 Sekunde versucht einzugrenzen:
Date,Facility,Severity,Host,Syslogtag,ProcessID,Messagetype,Message "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","3","iobroker","/usr/local/bin/node:","","1"," error: sql.0 Cannot insert INSERT INTO `iobroker`.undefined (id, ts, val, ack, _from, q) VALUES(1563, 1517765998406, , 1, 6, 0);: Error: ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 1, 6, 0)' at line 1" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 INSERT INTO `iobroker`.ts_string (id, ts, val, ack, _from, q) VALUES(1548, 1517765998413, '', 1, 6, 0);" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Datatype fritzbox.0.callmonitor.all: Currently: string, StorageType: String" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 INSERT INTO `iobroker`.ts_string (id, ts, val, ack, _from, q) VALUES(1545, 1517765998413, '', 1, 6, 0);" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Datatype fritzbox.0.callmonitor.call: Currently: string, StorageType: String" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 INSERT INTO `iobroker`.ts_number (id, ts, val, ack, _from, q) VALUES(1544, 1517765998408, 0, 1, 6, 0);" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Datatype fritzbox.0.calls.counterActualCalls.allActiveCount: Currently: number, StorageType: String" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 INSERT INTO `iobroker`.ts_number (id, ts, val, ack, _from, q) VALUES(1547, 1517765998407, 0, 1, 6, 0);" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Datatype fritzbox.0.calls.counterActualCalls.callCount: Currently: number, StorageType: String" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 INSERT INTO `iobroker`.ts_number (id, ts, val, ack, _from, q) VALUES(1564, 1517765998407, 0, 1, 6, 0);" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Datatype fritzbox.0.calls.counterActualCalls.ringCount: Currently: number, StorageType: String" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 INSERT INTO `iobroker`.ts_string (id, ts, val, ack, _from, q) VALUES(210, 1517765998407, '', 1, 6, 0);" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Datatype fritzbox.0.calls.ringActualNumbers: Currently: string, StorageType: String" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 INSERT INTO `iobroker`.undefined (id, ts, val, ack, _from, q) VALUES(1563, 1517765998406, , 1, 6, 0);" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Datatype fritzbox.0.calls.ringActualNumber: Currently: string, StorageType: String" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 INSERT INTO `iobroker`.ts_bool (id, ts, val, ack, _from, q) VALUES(1562, 1517765998406, false, 1, 6, 0);" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Datatype fritzbox.0.calls.ring: Currently: boolean, StorageType: Boolean" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 INSERT INTO `iobroker`.ts_string (id, ts, val, ack, _from, q) VALUES(1400, 1517765998403, '04.02. 18:39 9588336 X<- 12 9588336 SIP1 -', 1, 6, 0);" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Datatype fritzbox.0.cdr.txt: Currently: string, StorageType: String" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 INSERT INTO `iobroker`.ts_string (id, ts, val, ack, _from, q) VALUES(1557, 1517765998403, '04.02. 18:39 [9588336 ](\"tel:+4957239588336\") **X<- ** 12 9588336 SIP1 -', 1, 6, 0);" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Datatype fritzbox.0.cdr.html: Currently: string, StorageType: String" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 INSERT INTO `iobroker`.ts_string (id, ts, val, ack, _from, q) VALUES(1556, 1517765998401, '{\"date\":\"04.02.18 18:39:58\",\"dateEpoch\":1517765998000,\"dateEpochNow\":1517765998000,\"deltaTime\":0,\"deltaTimeOK\":true,\"type\":\"DISCONNECT\",\"id\":\"1\",\"extensionLine\":\"12\",\"ownNumber\":\"9588336\",\"externalNumber\":\"9588336\",\"lineType\":\"SIP1\",\"durationSecs\":\"0\",\"durationForm\":\" -\",\"durationSecs2\":\"0\",\"durationRingSecs\":\"\",\"connect\":false,\"direction\":\"out\",\"dateStartEpoch\":1517765995000,\"dateConnEpoch\":1517765998000,\"dateEndEpoch\":1517765998000,\"dateStart\":\"04.02.18 18:39:55\",\"dateConn\":\"04.02.18 18:39:58\",\"dateEnd\":\"04.02.18 18:39:58\",\"callSymbol\":\"X<- \",\"callSymbolColor\":\"**X<- **\",\"unknownNumber\":false,\"ownNumberForm\":\"9588336 \",\"externalNumberForm\":\"9588336 \",\"ownNumberE164\":\"+4957239588336\",\"externalE164\":\"+4957239588336\",\"externalTelLink\":\"[9588336 ](\\"tel:+4957239588336\\")\",\"externalTelLinkCenter\":\"[9588336](\\"tel:+4957239588336\\")\"}', 1, 6, 0);" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Datatype fritzbox.0.cdr.json: Currently: string, StorageType: String" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 INSERT INTO `iobroker`.ts_string (id, ts, val, ack, _from, q) VALUES(1554, 1517765998391, '[{\"date\":\"04.02.18 18:39:58\",\"externalNumber\":\"9588336\",\"callSymbolColor\":\"**X<- **\",\"extensionLine\":\"12\",\"ownNumber\":\"9588336\",\"lineType\":\"SIP1\",\"durationForm\":\" -\"},{\"date\":\"04.02.18 18:39:56\",\"externalNumber\":\"057239588336\",\"callSymbolColor\":\"** ->X**\",\"extensionLine\":\"\",\"ownNumber\":\"9588336\",\"lineType\":\"SIP1\",\"durationForm\":\" -\"},{\"date\":\"04.02.18 18:03:27\",\"externalNumber\":\"9588336\",\"callSymbolColor\":\"**X<- **\",\"extensionLine\":\"12\",\"ownNumber\":\"9588336\",\"lineType\":\"SIP1\",\"durationForm\":\" -\"},{\"date\":\"04.02.18 18:03:23\",\"externalNumber\":\"057239588336\",\"callSymbolColor\":\"** ->X**\",\"extensionLine\":\"\",\"ownNumber\":\"9588336\",\"lineType\":\"SIP1\",\"durationForm\":\" -\"},{\"date\":\"04.02.18 17:54:19\",\"externalNumber\":\"9588336\",\"callSymbolColor\":\"**X<- **\",\"extensionLine\":\"12\",\"ownNumber\":\"9588336\",\"lineType\":\"SIP1\",\"durationForm\":\" -\"},{\"date\":\"04.02.18 17:54:14\",\"externalNumber\":\"057239588336\",\"callSymbolColor\":\"** ->X**\",\"extensionLine\":\"\",\"ownNumber\":\"9588336\",\"lineType\":\"SIP1\",\"durationForm\":\" -\"},{\"date\":\"04.02.18 15:27:14\",\"externalNumber\":\"05723915429\",\"callSymbolColor\":\"** ->>**\",\"extensionLine\":\"40\",\"ownNumber\":\"9588336\",\"lineType\":\"SIP1\",\"durationForm\":\" 32\"}]', 1, 6, 0);" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Datatype fritzbox.0.history.allTableJSON: Currently: string, StorageType: String" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 sendTo \"getHistory\" to system.adapter.web.0 from system.adapter.sql.0" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Send: 906 of: 1139 in: 77ms" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 sendTo \"getHistory\" to system.adapter.web.0 from system.adapter.sql.0" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Send: 24 of: 82 in: 49ms" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 SELECT ts, val FROM `iobroker`.ts_number WHERE `iobroker`.ts_number.id=112 AND `iobroker`.ts_number.ts < 1517766020007 AND `iobroker`.ts_number.ts >= 1517593220007 UNION ( SELECT ts, val FROM `iobroker`.ts_number WHERE `iobroker`.ts_number.id=112 AND `iobroker`.ts_number.ts < 1517593220007 ORDER BY `iobroker`.ts_number.ts DESC LIMIT 1) UNION ( SELECT ts, val FROM `iobroker`.ts_number WHERE `iobroker`.ts_number.id=112 AND `iobroker`.ts_number.ts >= 1517766020007 ORDER BY `iobroker`.ts_number.ts ASC LIMIT 1) ORDER BY ts ASC;" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 SELECT ts, val FROM `iobroker`.ts_number WHERE `iobroker`.ts_number.id=112 AND `iobroker`.ts_number.ts < 1517766020007 AND `iobroker`.ts_number.ts >= 1517593220007 UNION ( SELECT ts, val FROM `iobroker`.ts_number WHERE `iobroker`.ts_number.id=112 AND `iobroker`.ts_number.ts < 1517593220007 ORDER BY `iobroker`.ts_number.ts DESC LIMIT 1) UNION ( SELECT ts, val FROM `iobroker`.ts_number WHERE `iobroker`.ts_number.id=112 AND `iobroker`.ts_number.ts >= 1517766020007 ORDER BY `iobroker`.ts_number.ts ASC LIMIT 1) ORDER BY ts ASC;" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 SELECT ts, val FROM `iobroker`.ts_number WHERE `iobroker`.ts_number.id=115 AND `iobroker`.ts_number.ts < 1517766020007 AND `iobroker`.ts_number.ts >= 1517593220007 UNION ( SELECT ts, val FROM `iobroker`.ts_number WHERE `iobroker`.ts_number.id=115 AND `iobroker`.ts_number.ts < 1517593220007 ORDER BY `iobroker`.ts_number.ts DESC LIMIT 1) UNION ( SELECT ts, val FROM `iobroker`.ts_number WHERE `iobroker`.ts_number.id=115 AND `iobroker`.ts_number.ts >= 1517766020007 ORDER BY `iobroker`.ts_number.ts ASC LIMIT 1) ORDER BY ts ASC;" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 SELECT ts, val FROM `iobroker`.ts_number WHERE `iobroker`.ts_number.id=115 AND `iobroker`.ts_number.ts < 1517766020007 AND `iobroker`.ts_number.ts >= 1517593220007 UNION ( SELECT ts, val FROM `iobroker`.ts_number WHERE `iobroker`.ts_number.id=115 AND `iobroker`.ts_number.ts < 1517593220007 ORDER BY `iobroker`.ts_number.ts DESC LIMIT 1) UNION ( SELECT ts, val FROM `iobroker`.ts_number WHERE `iobroker`.ts_number.id=115 AND `iobroker`.ts_number.ts >= 1517766020007 ORDER BY `iobroker`.ts_number.ts ASC LIMIT 1) ORDER BY ts ASC;" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 INSERT INTO `iobroker`.ts_string (id, ts, val, ack, _from, q) VALUES(1553, 1517765998353, '**Tag Zeit ext. Rufnr. g<>k Nbst Eigenes Amt Ltg. Dauer** #01204.02. 18:39 [9588336 ](\"tel:+4957239588336\") **X<- ** 12 9588336 SIP1 - #01204.02. 18:39 [057239588336 ](\"tel:+4957239588336\") ** ->X** 9588336 SIP1 - #01204.02. 18:03 [9588336 ](\"tel:+4957239588336\") **X<- ** 12 9588336 SIP1 - #01204.02. 18:03 [057239588336 ](\"tel:+4957239588336\") ** ->X** 9588336 SIP1 - #01204.02. 17:54 [9588336 ](\"tel:+4957239588336\") **X<- ** 12 9588336 SIP1 - #01204.02. 17:54 [057239588336 ](\"tel:+4957239588336\") ** ->X** 9588336 SIP1 - #01204.02. 15:27 [05723915429 ](\"tel:+495723915429\") ** ->>** 40 9588336 SIP1 32', 1, 6, 0);" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Datatype fritzbox.0.history.allTableHTML: Currently: string, StorageType: String" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:21","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 INSERT INTO `iobroker`.ts_bool (id, ts, val, ack, _from, q) VALUES(775, 1517766020464, true, 1, 1, 0);" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Datatype ping.0.zotac.192_168_1_130: Currently: boolean, StorageType: Boolean" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 INSERT INTO `iobroker`.ts_bool (id, ts, val, ack, _from, q) VALUES(1622, 1517766020448, true, 1, 1, 0);" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Datatype ping.0.zotac.192_168_1_103: Currently: boolean, StorageType: Boolean" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 INSERT INTO `iobroker`.ts_bool (id, ts, val, ack, _from, q) VALUES(785, 1517766020422, true, 1, 1, 0);" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Datatype ping.0.zotac.192_168_1_13: Currently: boolean, StorageType: Boolean" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 INSERT INTO `iobroker`.ts_bool (id, ts, val, ack, _from, q) VALUES(784, 1517766020405, true, 1, 1, 0);" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Datatype ping.0.zotac.192_168_1_12: Currently: boolean, StorageType: Boolean" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 INSERT INTO `iobroker`.ts_bool (id, ts, val, ack, _from, q) VALUES(783, 1517766020388, true, 1, 1, 0);" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Datatype ping.0.zotac.192_168_1_14: Currently: boolean, StorageType: Boolean" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 INSERT INTO `iobroker`.ts_bool (id, ts, val, ack, _from, q) VALUES(1614, 1517766020379, true, 1, 1, 0);" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Datatype ping.0.zotac.192_168_1_10: Currently: boolean, StorageType: Boolean" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 INSERT INTO `iobroker`.ts_bool (id, ts, val, ack, _from, q) VALUES(1621, 1517766020358, true, 1, 1, 0);" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 SELECT id FROM `iobroker`.sources WHERE name='system.adapter.ping.0';" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Datatype ping.0.zotac.192_168_1_102: Currently: boolean, StorageType: Boolean" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 sendTo \"getHistory\" to system.adapter.web.0 from system.adapter.sql.0" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Send: 906 of: 1138 in: 55ms" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 SELECT ts, val FROM `iobroker`.ts_number WHERE `iobroker`.ts_number.id=114 AND `iobroker`.ts_number.ts < 1517766020007 AND `iobroker`.ts_number.ts >= 1517593220007 UNION ( SELECT ts, val FROM `iobroker`.ts_number WHERE `iobroker`.ts_number.id=114 AND `iobroker`.ts_number.ts < 1517593220007 ORDER BY `iobroker`.ts_number.ts DESC LIMIT 1) UNION ( SELECT ts, val FROM `iobroker`.ts_number WHERE `iobroker`.ts_number.id=114 AND `iobroker`.ts_number.ts >= 1517766020007 ORDER BY `iobroker`.ts_number.ts ASC LIMIT 1) ORDER BY ts ASC;" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 SELECT ts, val FROM `iobroker`.ts_number WHERE `iobroker`.ts_number.id=114 AND `iobroker`.ts_number.ts < 1517766020007 AND `iobroker`.ts_number.ts >= 1517593220007 UNION ( SELECT ts, val FROM `iobroker`.ts_number WHERE `iobroker`.ts_number.id=114 AND `iobroker`.ts_number.ts < 1517593220007 ORDER BY `iobroker`.ts_number.ts DESC LIMIT 1) UNION ( SELECT ts, val FROM `iobroker`.ts_number WHERE `iobroker`.ts_number.id=114 AND `iobroker`.ts_number.ts >= 1517766020007 ORDER BY `iobroker`.ts_number.ts ASC LIMIT 1) ORDER BY ts ASC;" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:20","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:19","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:19","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:19","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:19","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:19","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 INSERT INTO `iobroker`.ts_bool (id, ts, val, ack, _from, q) VALUES(1543, 1517765998320, true, 1, 6, 0);" "Today 18:40:19","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Datatype fritzbox.0.system.deltaTimeOK: Currently: boolean, StorageType: Boolean" "Today 18:40:19","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 INSERT INTO `iobroker`.ts_number (id, ts, val, ack, _from, q) VALUES(1546, 1517765998319, 0, 1, 6, 0);" "Today 18:40:19","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Datatype fritzbox.0.system.deltaTime: Currently: number, StorageType: String" "Today 18:40:19","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 INSERT INTO `iobroker`.ts_string (id, ts, val, ack, _from, q) VALUES(1542, 1517765998313, '04.02.18 18:39:58;DISCONNECT;1;0;#015#012', 1, 6, 0);" "Today 18:40:19","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Datatype fritzbox.0.message: Currently: string, StorageType: String" "Today 18:40:19","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 INSERT INTO `iobroker`.ts_string (id, ts, val, ack, _from, q) VALUES(1560, 1517765997640, '', 1, 6, 0);" "Today 18:40:19","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Datatype fritzbox.0.callmonitor.ring: Currently: string, StorageType: String" "Today 18:40:19","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:19","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:19","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:19","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:19","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:19","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:19","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:19","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:19","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:19","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:19","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:19","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:19","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:19","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:19","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:19","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:19","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:19","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:19","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:19","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" "Today 18:40:19","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type set in Def for yr.0.forecast.day0.pressure: undefined" "Today 18:40:19","16","7","iobroker","/usr/local/bin/node:","","1"," debug: sql.0 Type (from Obj) for yr.0.forecast.day0.pressure: undefined" -
Wenn du mir sagst wie ich es Filtern kann, kann ich das gerne machen. Habe einen Logserver, da kann ich alles mögliche einschränken.
-
packe zu allererst bitte den code in "spoiler"
-
Was hat denn Beispielsweise "yr.0.forecast.day0.pressure" für einen typ laut Objekt? (unter Objekte auf das Objekt und rechts das Stiftsymbol. Dort dann "Raw Experten only" und dort in common -> type
Ist das einer der Datenpunkte wo Du es entfernt hast?
-
Was hat denn Beispielsweise "yr.0.forecast.day0.pressure" für einen typ laut Objekt? (unter Objekte auf das Objekt und rechts das Stiftsymbol. Dort dann "Raw Experten only" und dort in common -> type
Ist das einer der Datenpunkte wo Du es entfernt hast? `
Hallo,
{ "from": "system.adapter.admin.0", "ts": 1517660997880, "common": { "name": "Forecast for pressure for today", "type": "boolean", "role": "indicator", "unit": "hPa", "desc": "Forecast for pressure in hPa", "read": true, "write": false, "custom": { "sql.0": { "enabled": true, "changesOnly": false, "debounce": "", "retention": "63072000", "changesRelogInterval": "", "changesMinDelta": 0, "storageType": "" } } }, "native": {}, "acl": { "object": 1636, "owner": "system.user.admin", "ownerGroup": "system.group.administrator", "state": 1636 }, "_id": "yr.0.forecast.day0.pressure", "type": "state" }und der 1563:
{ "_id": "fritzbox.0.calls.ringActualNumber", "type": "state", "common": { "name": "actual last ringing number", "type": "string", "role": "call info", "read": true, "write": false, "desc": "actual last ringing number", "custom": { "sql.0": { "enabled": true, "changesOnly": false, "debounce": "", "retention": "63072000", "changesRelogInterval": "", "changesMinDelta": 0, "storageType": "" } } }, "native": {}, "acl": { "object": 1636, "state": 1636, "owner": "system.user.admin", "ownerGroup": "system.group.administrator" }, "from": "system.adapter.admin.0", "ts": 1517661165185 }
