[Aufruf] Dringender Test sql 1.6.4

apollon77

Zu 1563 und so: Debug log bitte. Sonst rate ich ewig im Code rum und wir machen zig weitere Versuche

sissiwup

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"

sissiwup

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.

BBTown

packe zu allererst bitte den code in "spoiler"

apollon77

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?

sissiwup

~~@apollon77:~~

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
}

apollon77

kapiere ich nicht

Habe nochmal auf Github logging erweitert. Also wenns geht bitte nochmal typ auf null setzen bei ausgewählten Datenpunkten und Debug Log schicken vom Start, Der Ausschnitt wie weiter oben war sinnvoll.

ruhr70

geht zwar nicht um den sql 1.6.4

der sql 1.6.7 sorgt bei mir mal immer wieder für volle Systemlast.

Alle Prozesse laufen bei ca. 0,3 - 1,0% Last. Der SQL schießt irgendwann auf ca. 90% hoch und zieht dann den js-controller mit.

apollon77

Wir sind hier im Thread quasibei 1.6.4+

Wie oft denn? Welche Features nutzt du? Nimmst Du das automatische Loggen auch ohne Änderung? Welche Zeiträume? Passt das grob? Wie viele Datenpunkte?

Eine vermutung ist, das du viele Werte regelmässig ohne Wertänderungen hast und loggst.Ich versuche das zwar zu verteilen kann aber sein das das kaputt gegangen ist als die "Null"-Schreiben Nummer reingekommen ist. Da könnte ich checken wenn Du die Annahme bestätigst … sonst muss ich schauen

sissiwup

~~@ruhr70:~~

geht zwar nicht um den sql 1.6.4

der sql 1.6.7 sorgt bei mir mal immer wieder für volle Systemlast.

Alle Prozesse laufen bei ca. 0,3 - 1,0% Last. Der SQL schießt irgendwann auf ca. 90% hoch und zieht dann den js-controller mit. `

Kann ich bestätigen. Da werden unheimlich viele Aktionen gemacht. Habe ich durchs loggen gesehen.

Mußte es auf 1 Sekunde einschränken um überhaupt eine Chance zu haben. Waren trotzdem mehr als 100000 Zeichen in der kurzen Zeit.

(was er macht, sieht man oben im log bei meinem Post).

apollon77

In deinem log sieht man nur leider auch nicht die "Auslöser" Steht das viel "relog" im Log?

apollon77

ALso nehmen wir mal an es liegt an relogging was durch das initiale "null-Werte schreiben" von der Zufallsverteilung alle wieder gleichgezogen werden.

Könnte jetzt wieder tun. Please Test Github

apollon77

@sissiwup: zu dem "typ reset auf null"-Thema: Habe nochmal auf Github logging erweitert. Also wenns geht bitte nochmal typ auf null setzen bei ausgewählten Datenpunkten und Debug Log schicken vom Start, Der Ausschnitt wie weiter oben war sinnvoll.

ruhr70

~~@apollon77:~~

Wie oft denn? Welche Features nutzt du? Nimmst Du das automatische Loggen auch ohne Änderung? Welche Zeiträume? Passt das grob? Wie viele Datenpunkte?

Eine vermutung ist, das du viele Werte regelmässig ohne Wertänderungen hast und loggst.Ich versuche das zwar zu verteilen kann aber sein das das kaputt gegangen ist als die "Null"-Schreiben Nummer reingekommen ist. Da könnte ich checken wenn Du die Annahme bestätigst … sonst muss ich schauen `

Ich weiß, dass man mit meiner Aussage recht wenig anfangen kann.

Wenn ich es greifen könnte hätte ich mehr geschrieben. War erst einmal eine Wasserstandsmeldung

Ich probiere gerade einiges an der ioBroker Installation, da das latest Repro nicht lädt.

Irgendwann bei den diversen Schritten (Admin Updates, Repro aus Datei einlesen, Slave Update, …) usw. ging die sql Last extrem hoch. Wann genau kann ich leider nicht greifen.

Die Version vom SQL lief davor ohne Probleme. Auf einmal habe ich immer wieder die Situation, dass der SQL Adapter extrem viel CPU Last zieht.

Ein Start und Stop des Adapters bringt nichts. Beim letzten mal war es nach ein Reboot des Linux Host (kein Raspi, sondern eine VM auf einem NUC mit Power) wieder OK. Jetzt habe ich gerade den Zustand, dass sich die CPU Last nicht mehr beruhigt. Auch nach Reboot nicht.

Bei den meisten Datenpunkten habe ich den Haken "bei Änderung" gesetzt.

Da genau diese Konstellation der Adapter auch mit normaler Last lief glaube ich nciht, dass es an der Anzahl der Datenpunkte liegt.

Nur beim Rebbot kommt die Meldung "too many Connections".

Es werden 139 Datenpunkte geloggt.

Einige Datenpunkte sind dabei, bei denen sich der Wert sehr selten ändert.

Dort ist in der Regel der Haken "Änderungen aufzeichnen" gesetzt.

Was mich irritiert. Dann sollten doch nur Änderungen geloggt werden?

Bei einer Stichprobe eines Datenpunkts mit dem Haken finde ich unter Einstellungen/Tabelle alle 5 Sekunden den gleichen Wert. :?

[EDIT]

habe ich den Parameter

"Nach Intervall aufzeichnen(s)

(0 = Deaktivieren)"

ggf. falsch verstanden, bzw. ignoriert? Dort stand bei den kontrollierten Datenpunkt eine 4 drin.

Wird dann nach jedem 4. gleichem Wert der identische Wert geschrieben?

apollon77

"Nur Änderungen" sollte nicht zu "alle 5 sekunden" führen.

Es gibt aber eine zweite EInstellung "Log unchanged values any(s)" bzw auf Deutsch "Gleiche Werte aufzeichnen(s)". Das meinte ich. Was steht denn da drin? Wenn da immer 0 steht dann kann das damit nichts zu tun haben.

Wenn es das nicht ist dann weiss ich es nicht. Der Adapter loggt an sich nur etwas wenn:

er startet - überall "null"s
er beendet wird - überall "null"s
wenn Daten reinkommen bzw. States sich ändern

Also ein kurzer Lastpeak beim start (weil ja alle "Null" geschrieben werden) ist zu erwarten.

Ansonsten Auf Debug stellen und auch wenns viel ist laufen lassen bis das Problem existiert. Dann Log schicken und alle Infos zu zeitpunkten oder so helfen dann.

ruhr70

~~@apollon77:~~

"Nur Änderungen" sollte nicht zu "alle 5 sekunden" führen.

Es gibt aber eine zweite EInstellung "Log unchanged values any(s)" bzw auf Deutsch "Gleiche Werte aufzeichnen(s)". Das meinte ich. Was steht denn da drin? Wenn da immer 0 steht dann kann das damit nichts zu tun haben. `

Siehe oben…

Hatte wohl gerade editiert, als Du Deine Antwort geschrieben hattest. Zu mindestens bei einem DP stand dort eine 4.

Ich kontrolliere dann mal alle DPs.

Kann aber sagen, dass es mit den vorhanden Einstellungen in den letzten Wochen ruhig (keine Last) war.

Habe auch gerade 1.6.8 installiert. Die Last ist immer noch hoch, aber so um die 30% niedriger als vorher.

apollon77

~~@ruhr70:~~

habe ich den Parameter

"Nach Intervall aufzeichnen(s)

(0 = Deaktivieren)"

ggf. falsch verstanden, bzw. ignoriert? Dort stand bei den kontrollierten Datenpunkt eine 4 drin.

Wird dann nach jedem 4. gleichem Wert der identische Wert geschrieben? `

"Nach Interval aufzeichnen" sagt mir nichts … Heisst das echt so???

Ansinsten kann ich aus dem englischen nur erraten das es genau um

Gleiche Werte aufzeichnen(s)

geht und eine 4 dort heisst: alle 4 SEKUNDEN wird der Wert geloggt auch wenn er sich nicht geändert hat

apollon77

~~@ruhr70:~~

Hatte wohl gerade editiert, als Du Deine Antwort geschrieben hattest. Zu mindestens bei einem DP stand dort eine 4.

Ich kontrolliere dann mal alle DPs.

Kann aber sagen, dass es mit den vorhanden Einstellungen in den letzten Wochen ruhig (keine Last) war.

Habe auch gerade 1.6.8 installiert. Die Last ist immer noch hoch, aber so um die 30% niedriger als vorher. `

Dann mach mal die 4s raus bei allen und checke wie es dann ist

Wenn noch zu hoch: Debug log

ruhr70

~~@apollon77:~~

"Nach Interval aufzeichnen" sagt mir nichts … Heisst das echt so???

Ansinsten kann ich aus dem englischen nur erraten das es genau um

Gleiche Werte aufzeichnen(s)

geht und eine 4 dort heisst: alle 4 SEKUNDEN wird der Wert geloggt auch wenn er sich nicht geändert hat `

ja, heißt so (war copy & paste).

Danke für die Erklärung. Hätte ich vorher mal nachsehen sollen :roll:

Nach dem Adapterupdate auf 1.6.8:

apollon77

Interessant mit der Bezeichnung. Steht’s im nicht in den Textfiles drin … häää ... checke ich morgen

Hatte nur das Update auf 1.6.8 den Effekt oder auch das du die 4 aus dem Feld entfernt hast?! Ersteres wäre falsch.

NEWS

[Aufruf] Dringender Test sql 1.6.4

Support us

495

32.4k

81.4k

1.3m