[Fehler] SQL - Warn und Error Meldungen
-
Ich weiß, das Thema war schon mal; aber eine Lösung hab ich bisher nicht.
Wenn ich iobroker neu starte (aus welchem Grund auch immer), und ich dann in vis flots anklicken
dann funktioniert dies beim 1. x nicht.
Ich mus dann immer vis neu starten und dann werden die flots angezeigt.
Im log folgende Fehler:
Kann man da was machen?
bzw. warum werden die flots nicht beim 1x anklicken korrekt angezeigt.
mfg
dieter
-
Moin,
ich habe mal im Forum nach der Meldung gesucht und bin auch prompt fündig geworden ;)
Schau mal hier ==> https://forum.iobroker.net/viewtopic.php?f=36&t=11301&p=125645#p125645. Evtl. hilft Dir dieser Thread weiter
Gruß,
Eric
-
Hallo Eric,
den Thread kenn ich.
Eine Lösung hab dort nicht gefunden.
mfg
Dieter
-
Hallo Ingo,
mach ich heute abend.
Danke.
mfg
Dieter
-
Habe:
iobroker stop
dann
iobroker start
anbei das debug log:
close details account_circle admin Administrator appsÜbersicht storeAdapter1 subtitlesInstanzen view_listObjekte art_trackAufzählungen view_headlineLog flash_onEreignisse codeSkripte storageHosts build HOST ASUS-BUEROioBroker.admin 3.3.5 refresh pausedelete delete_foreverLog-Größe: 1.14 MB close Zeit Meldung sql.0 2018-04-05 18:16:41.612 debug DELETE FROM ts_number WHERE id=18 AND ts < 1491408960608; sql.0 2018-04-05 18:16:41.609 debug DELETE FROM ts_number WHERE id=17 AND ts < 1491408960582; sql.0 2018-04-05 18:16:41.597 debug INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(18, 1522945000561, 5, 1, 1, 0); sql.0 2018-04-05 18:16:41.582 debug INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(17, 1522945000557, 17.2, 1, 1, 0); sql.0 2018-04-05 18:16:41.566 debug SELECT id, type, name FROM datapoints WHERE name='hm-rpc.0.KEQ1040434.4.SET_TEMPERATURE'; sql.0 2018-04-05 18:16:41.566 debug Type (from Obj) for hm-rpc.0.KEQ1040434.4.SET_TEMPERATURE: 0 sql.0 2018-04-05 18:16:41.566 debug number / 0 / {"def":20,"type":"number","read":true,"write":true,"min":4.5,"max":30.5,"unit":"°C","role":"level.temperature","custom":{"sql.0":{"enabled":true}},"name":"Heizung: Arbeitszimmer.SET_TEMPE sql.0 2018-04-05 18:16:41.566 debug SELECT id, type, name FROM datapoints WHERE name='hm-rpc.0.KEQ1040434.4.ACTUAL_TEMPERATURE'; sql.0 2018-04-05 18:16:41.566 debug Type (from Obj) for hm-rpc.0.KEQ1040434.4.ACTUAL_TEMPERATURE: 0 sql.0 2018-04-05 18:16:41.566 debug number / 0 / {"def":0,"type":"number","read":true,"write":false,"min":-10,"max":56,"unit":"°C","role":"value.temperature","custom":{"sql.0":{"enabled":true}},"name":"Heizung: Arbeitszimmer.ACTUAL_TEMP sql.0 2018-04-05 18:16:41.566 debug Type set in Def for hm-rpc.0.KEQ1040434.4.SET_TEMPERATURE: false sql.0 2018-04-05 18:16:41.566 debug Datatype hm-rpc.0.KEQ1040434.4.SET_TEMPERATURE: Currently: number, StorageType: false sql.0 2018-04-05 18:16:41.566 debug Type set in Def for hm-rpc.0.KEQ1040434.4.ACTUAL_TEMPERATURE: false sql.0 2018-04-05 18:16:41.566 debug Datatype hm-rpc.0.KEQ1040434.4.ACTUAL_TEMPERATURE: Currently: number, StorageType: false sql.0 2018-04-05 18:16:40.561 debug new value received for hm-rpc.0.KEQ1040434.4.SET_TEMPERATURE, new-value=5, ts=1522945000561, relog=false sql.0 2018-04-05 18:16:40.557 debug new value received for hm-rpc.0.KEQ1040434.4.ACTUAL_TEMPERATURE, new-value=17.2, ts=1522945000557, relog=false sql.0 2018-04-05 18:16:28.623 debug sendTo "getHistory" to system.adapter.web.0 from system.adapter.sql.0 sql.0 2018-04-05 18:16:28.623 debug Send: 48 of: 67 in: 27ms sql.0 2018-04-05 18:16:28.598 debug SELECT ts, val FROM ts_number WHERE ts_number.id=55 AND ts_number.ts < 1522944988565 AND ts_number.ts >= 1515172588565 UNION SELECT * from ( SELECT ts, val FROM ts_number WHERE ts_number.id=55 AND t sql.0 2018-04-05 18:16:28.598 debug SELECT ts, val FROM ts_number WHERE ts_number.id=55 AND ts_number.ts < 1522944988565 AND ts_number.ts >= 1515172588565 UNION SELECT * from ( SELECT ts, val FROM ts_number WHERE ts_number.id=55 AND t sql.0 2018-04-05 18:16:28.591 debug SELECT id, type, name FROM datapoints WHERE name='javascript.0.Status.Heizoel.aktuell'; sql.0 2018-04-05 18:16:28.591 debug sendTo "getHistory" to system.adapter.web.0 from system.adapter.sql.0 sql.0 2018-04-05 18:16:28.590 error Please wait till next data record is logged and reload. sql.0 2018-04-05 18:16:28.589 warn For getHistory for id javascript.0.Status.Heizoel.aktuell: Type empty. Need to write data first. Index = undefined sql.0 2018-04-05 18:16:27.056 debug DELETE FROM ts_number WHERE id=28 AND ts < 1491408960036; sql.0 2018-04-05 18:16:27.052 debug DELETE FROM ts_number WHERE id=29 AND ts < 1491408960021; sql.0 2018-04-05 18:16:27.021 debug INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(28, 1522944985990, 15.9, 1, 1, 0); sql.0 2018-04-05 18:16:27.005 debug INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(29, 1522944985991, 5, 1, 1, 0); sql.0 2018-04-05 18:16:27.005 debug SELECT id, type, name FROM datapoints WHERE name='hm-rpc.0.KEQ1040443.4.SET_TEMPERATURE'; sql.0 2018-04-05 18:16:27.005 debug Type (from Obj) for hm-rpc.0.KEQ1040443.4.SET_TEMPERATURE: 0 sql.0 2018-04-05 18:16:27.005 debug number / 0 / {"def":20,"type":"number","read":true,"write":true,"min":4.5,"max":30.5,"unit":"°C","role":"level.temperature","custom":{"sql.0":{"enabled":true}},"name":"Heizung: Schlafzimmer.SET_TEMPER sql.0 2018-04-05 18:16:27.005 debug SELECT id, type, name FROM datapoints WHERE name='hm-rpc.0.KEQ1040443.4.ACTUAL_TEMPERATURE'; sql.0 2018-04-05 18:16:27.005 debug Type (from Obj) for hm-rpc.0.KEQ1040443.4.ACTUAL_TEMPERATURE: 0 sql.0 2018-04-05 18:16:27.005 debug number / 0 / {"def":0,"type":"number","read":true,"write":false,"min":-10,"max":56,"unit":"°C","role":"value.temperature","custom":{"sql.0":{"enabled":true}},"name":"Heizung: Schlafzimmer.ACTUAL_TEMPE sql.0 2018-04-05 18:16:27.005 debug Type set in Def for hm-rpc.0.KEQ1040443.4.SET_TEMPERATURE: false sql.0 2018-04-05 18:16:27.005 debug Datatype hm-rpc.0.KEQ1040443.4.SET_TEMPERATURE: Currently: number, StorageType: false sql.0 2018-04-05 18:16:27.005 debug Type set in Def for hm-rpc.0.KEQ1040443.4.ACTUAL_TEMPERATURE: false sql.0 2018-04-05 18:16:27.005 debug Datatype hm-rpc.0.KEQ1040443.4.ACTUAL_TEMPERATURE: Currently: number, StorageType: false sql.0 2018-04-05 18:16:26.000 debug new value received for hm-rpc.0.KEQ1040443.4.SET_TEMPERATURE, new-value=5, ts=1522944985991, relog=false sql.0 2018-04-05 18:16:25.999 debug new value received for hm-rpc.0.KEQ1040443.4.ACTUAL_TEMPERATURE, new-value=15.9, ts=1522944985990, relog=false sql.0 2018-04-05 18:16:18.764 debug sendTo "getHistory" to system.adapter.web.0 from system.adapter.sql.0 sql.0 2018-04-05 18:16:18.764 debug Send: 139 of: 138 in: 127ms sql.0 2018-04-05 18:16:18.743 debug SELECT ts, val FROM ts_number WHERE ts_number.id=59 AND ts_number.ts < 1522944978489 AND ts_number.ts >= 1522340178489 UNION SELECT * from ( SELECT ts, val FROM ts_number WHERE ts_number.id=59 AND t sql.0 2018-04-05 18:16:18.743 debug sendTo "getHistory" to system.adapter.web.0 from system.adapter.sql.0 sql.0 2018-04-05 18:16:18.743 debug Send: 639 of: 641 in: 107ms sql.0 2018-04-05 18:16:18.649 debug SELECT ts, val FROM ts_number WHERE ts_number.id=50 AND ts_number.ts < 1522944978489 AND ts_number.ts >= 1522340178489 UNION SELECT * from ( SELECT ts, val FROM ts_number WHERE ts_number.id=50 AND t sql.0 2018-04-05 18:16:18.649 debug sendTo "getHistory" to system.adapter.web.0 from system.adapter.sql.0 sql.0 2018-04-05 18:16:18.649 debug Send: 0 of: 1 in: 17ms sql.0 2018-04-05 18:16:18.637 debug SELECT ts, val FROM ts_number WHERE ts_number.id=59 AND ts_number.ts < 1522944978489 AND ts_number.ts >= 1522340178489 UNION SELECT * from ( SELECT ts, val FROM ts_number WHERE ts_number.id=59 AND t sql.0 2018-04-05 18:16:18.634 debug SELECT ts, val FROM ts_number WHERE ts_number.id=50 AND ts_number.ts < 1522944978489 AND ts_number.ts >= 1522340178489 UNION SELECT * from ( SELECT ts, val FROM ts_number WHERE ts_number.id=50 AND t sql.0 2018-04-05 18:16:18.634 debug SELECT ts, val FROM ts_number WHERE ts_number.id=58 AND ts_number.ts < 1522944978489 AND ts_number.ts >= 1522340178489 UNION SELECT * from ( SELECT ts, val FROM ts_number WHERE ts_number.id=58 AND t sql.0 2018-04-05 18:16:18.634 debug SELECT ts, val FROM ts_number WHERE ts_number.id=58 AND ts_number.ts < 1522944978489 AND ts_number.ts >= 1522340178489 UNION SELECT * from ( SELECT ts, val FROM ts_number WHERE ts_number.id=58 AND t sql.0 2018-04-05 18:16:18.629 debug SELECT id, type, name FROM datapoints WHERE name='hm-rega.0.36100'; sql.0 2018-04-05 18:16:18.629 debug sendTo "getHistory" to system.adapter.web.0 from system.adapter.sql.0 sql.0 2018-04-05 18:16:18.629 error Please wait till next data record is logged and reload. sql.0 2018-04-05 18:16:18.629 warn For getHistory for id hm-rega.0.36100: Type empty. Need to write data first. Index = undefined sql.0 2018-04-05 18:16:18.629 debug SELECT id, type, name FROM datapoints WHERE name='hm-rega.0.40977'; sql.0 2018-04-05 18:16:18.629 debug sendTo "getHistory" to system.adapter.web.0 from system.adapter.sql.0 sql.0 2018-04-05 18:16:18.629 error Please wait till next data record is logged and reload. sql.0 2018-04-05 18:16:18.629 warn For getHistory for id hm-rega.0.40977: Type empty. Need to write data first. Index = undefined sql.0 2018-04-05 18:16:18.629 debug SELECT id, type, name FROM datapoints WHERE name='hm-rega.0.33892'; sql.0 2018-04-05 18:16:18.629 debug sendTo "getHistory" to system.adapter.web.0 from system.adapter.sql.0 sql.0 2018-04-05 18:16:18.629 error Please wait till next data record is logged and reload. sql.0 2018-04-05 18:16:18.629 warn For getHistory for id hm-rega.0.33892: Type empty. Need to write data first. Index = undefined sql.0 2018-04-05 18:16:16.031 debug sendTo "getHistory" to system.adapter.web.0 from system.adapter.sql.0 sql.0 2018-04-05 18:16:16.031 debug Send: 559 of: 558 in: 53ms sql.0 2018-04-05 18:16:16.019 debug SELECT ts, val FROM ts_number WHERE ts_number.id=21 AND ts_number.ts < 1522944975831 AND ts_number.ts >= 1522858575831 UNION SELECT * from ( SELECT ts, val FROM ts_number WHERE ts_number.id=21 AND t sql.0 2018-04-05 18:16:16.018 debug sendTo "getHistory" to system.adapter.web.0 from system.adapter.sql.0 sql.0 2018-04-05 18:16:16.018 debug Send: 559 of: 558 in: 39ms sql.0 2018-04-05 18:16:16.004 debug SELECT ts, val FROM ts_number WHERE ts_number.id=19 AND ts_number.ts < 1522944975831 AND ts_number.ts >= 1522858575831 UNION SELECT * from ( SELECT ts, val FROM ts_number WHERE ts_number.id=19 AND t sql.0 2018-04-05 18:16:16.003 debug sendTo "getHistory" to system.adapter.web.0 from system.adapter.sql.0 sql.0 2018-04-05 18:16:16.003 debug Send: 559 of: 558 in: 27ms sql.0 2018-04-05 18:16:15.985 debug SELECT ts, val FROM ts_number WHERE ts_number.id=24 AND ts_number.ts < 1522944975831 AND ts_number.ts >= 1522858575831 UNION SELECT * from ( SELECT ts, val FROM ts_number WHERE ts_number.id=24 AND t sql.0 2018-04-05 18:16:15.984 debug sendTo "getHistory" to system.adapter.web.0 from system.adapter.sql.0 sql.0 2018-04-05 18:16:15.984 debug Send: 559 of: 558 in: 11ms sql.0 2018-04-05 18:16:15.977 debug SELECT ts, val FROM ts_number WHERE ts_number.id=21 AND ts_number.ts < 1522944975831 AND ts_number.ts >= 1522858575831 UNION SELECT * from ( SELECT ts, val FROM ts_number WHERE ts_number.id=21 AND t sql.0 2018-04-05 18:16:15.977 debug SELECT ts, val FROM ts_number WHERE ts_number.id=19 AND ts_number.ts < 1522944975831 AND ts_number.ts >= 1522858575831 UNION SELECT * from ( SELECT ts, val FROM ts_number WHERE ts_number.id=19 AND t sql.0 2018-04-05 18:16:15.977 debug SELECT ts, val FROM ts_number WHERE ts_number.id=24 AND ts_number.ts < 1522944975831 AND ts_number.ts >= 1522858575831 UNION SELECT * from ( SELECT ts, val FROM ts_number WHERE ts_number.id=24 AND t sql.0 2018-04-05 18:16:15.972 debug SELECT ts, val FROM ts_number WHERE ts_number.id=23 AND ts_number.ts < 1522944975831 AND ts_number.ts >= 1522858575831 UNION SELECT * from ( SELECT ts, val FROM ts_number WHERE ts_number.id=23 AND t sql.0 2018-04-05 18:16:15.971 debug SELECT ts, val FROM ts_number WHERE ts_number.id=23 AND ts_number.ts < 1522944975831 AND ts_number.ts >= 1522858575831 UNION SELECT * from ( SELECT ts, val FROM ts_number WHERE ts_number.id=23 AND t sql.0 2018-04-05 18:16:12.731 debug sendTo "getHistory" to system.adapter.web.0 from system.adapter.sql.0 sql.0 2018-04-05 18:16:12.730 debug Send: 547 of: 560 in: 32ms sql.0 2018-04-05 18:16:12.710 debug SELECT ts, val FROM ts_number WHERE ts_number.id=16 AND ts_number.ts < 1522944972568 AND ts_number.ts >= 1522858572568 UNION SELECT * from ( SELECT ts, val FROM ts_number WHERE ts_number.id=16 AND t sql.0 2018-04-05 18:16:12.710 debug sendTo "getHistory" to system.adapter.web.0 from system.adapter.sql.0 sql.0 2018-04-05 18:16:12.709 debug Send: 549 of: 558 in: 12ms sql.0 2018-04-05 18:16:12.697 debug SELECT ts, val FROM ts_number WHERE ts_number.id=16 AND ts_number.ts < 1522944972568 AND ts_number.ts >= 1522858572568 UNION SELECT * from ( SELECT ts, val FROM ts_number WHERE ts_number.id=16 AND t sql.0 2018-04-05 18:16:12.697 debug SELECT ts, val FROM ts_number WHERE ts_number.id=19 AND ts_number.ts < 1522944972568 AND ts_number.ts >= 1522858572568 UNION SELECT * from ( SELECT ts, val FROM ts_number WHERE ts_number.id=19 AND t sql.0 2018-04-05 18:16:12.696 debug SELECT ts, val FROM ts_number WHERE ts_number.id=19 AND ts_number.ts < 1522944972568 AND ts_number.ts >= 1522858572568 UNION SELECT * from ( SELECT ts, val FROM ts_number WHERE ts_number.id=19 AND t sql.0 2018-04-05 18:15:59.922 debug sendTo "getHistory" to system.adapter.web.0 from system.adapter.sql.0 sql.0 2018-04-05 18:15:59.922 debug Send: 289 of: 288 in: 56ms sql.0 2018-04-05 18:15:59.913 debug SELECT ts, val FROM ts_number WHERE ts_number.id=46 AND ts_number.ts < 1522944959790 AND ts_number.ts >= 1522858559790 UNION SELECT * from ( SELECT ts, val FROM ts_number WHERE ts_number.id=46 AND t sql.0 2018-04-05 18:15:59.913 debug sendTo "getHistory" to system.adapter.web.0 from system.adapter.sql.0 sql.0 2018-04-05 18:15:59.913 debug Send: 289 of: 288 in: 46ms sql.0 2018-04-05 18:15:59.891 debug SELECT ts, val FROM ts_number WHERE ts_number.id=47 AND ts_number.ts < 1522944959790 AND ts_number.ts >= 1522858559790 UNION SELECT * from ( SELECT ts, val FROM ts_number WHERE ts_number.id=47 AND t sql.0 2018-04-05 18:15:59.890 debug sendTo "getHistory" to system.adapter.web.0 from system.adapter.sql.0 sql.0 2018-04-05 18:15:59.890 debug Send: 289 of: 288 in: 31ms sql.0 2018-04-05 18:15:59.867 debug SELECT ts, val FROM ts_number WHERE ts_number.id=46 AND ts_number.ts < 1522944959790 AND ts_number.ts >= 1522858559790 UNION SELECT * from ( SELECT ts, val FROM ts_number WHERE ts_number.id=46 AND t sql.0 2018-04-05 18:15:59.867 debug SELECT ts, val FROM ts_number WHERE ts_number.id=47 AND ts_number.ts < 1522944959790 AND ts_number.ts >= 1522858559790 UNION SELECT * from ( SELECT ts, val FROM ts_number WHERE ts_number.id=47 AND t sql.0 2018-04-05 18:15:59.867 debug SELECT ts, val FROM ts_number WHERE ts_number.id=48 AND ts_number.ts < 1522944959790 AND ts_number.ts >= 1522858559790 UNION SELECT * from ( SELECT ts, val FROM ts_number WHERE ts_number.id=48 AND t sql.0 2018-04-05 18:15:59.866 debug SELECT ts, val FROM ts_number WHERE ts_number.id=48 AND ts_number.ts < 1522944959790 AND ts_number.ts >= 1522858559790 UNION SELECT * from ( SELECT ts, val FROM ts_number WHERE ts_number.id=48 AND t sql.0 2018-04-05 18:15:59.855 debug SELECT id, type, name FROM datapoints WHERE name='javascript.0.Status.Photovoltaik.Leistung_aktuell'; sql.0 2018-04-05 18:15:59.855 debug sendTo "getHistory" to system.adapter.web.0 from system.adapter.sql.0 sql.0 2018-04-05 18:15:59.855 error Please wait till next data record is logged and reload. sql.0 2018-04-05 18:15:59.855 warn For getHistory for id javascript.0.Status.Photovoltaik.Leistung_aktuell: Type empty. Need to write data first. Index = undefined sql.0 2018-04-05 18:15:59.855 debug SELECT id, type, name FROM datapoints WHERE name='javascript.0.Status.Photovoltaik.Leistung_Strang2'; sql.0 2018-04-05 18:15:59.855 debug sendTo "getHistory" to system.adapter.web.0 from system.adapter.sql.0 sql.0 2018-04-05 18:15:59.855 error Please wait till next data record is logged and reload. sql.0 2018-04-05 18:15:59.855 warn For getHistory for id javascript.0.Status.Photovoltaik.Leistung_Strang2: Type empty. Need to write data first. Index = undefined sql.0 2018-04-05 18:15:59.855 debug SELECT id, type, name FROM datapoints WHERE name='javascript.0.Status.Photovoltaik.Leistung_Strang1'; sql.0 2018-04-05 18:15:59.855 debug sendTo "getHistory" to system.adapter.web.0 from system.adapter.sql.0 sql.0 2018-04-05 18:15:59.855 error Please wait till next data record is logged and reload. sql.0 2018-04-05 18:15:59.855 warn For getHistory for id javascript.0.Status.Photovoltaik.Leistung_Strang1: Type empty. Need to write data first. Index = undefined sql.0 2018-04-05 18:15:57.527 debug DELETE FROM ts_number WHERE id=1 AND ts < 1491408900521; sql.0 2018-04-05 18:15:57.523 debug DELETE FROM ts_number WHERE id=7 AND ts < 1491408900513; sql.0 2018-04-05 18:15:57.514 debug INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(1, 1522944956476, 44, 1, 1, 0); sql.0 2018-04-05 18:15:57.500 debug INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(7, 1522944956475, 0.26, 1, 1, 0); sql.0 2018-04-05 18:15:57.485 debug SELECT id, type, name FROM datapoints WHERE name='hm-rpc.0.LEQ0534246.2.CURRENT'; sql.0 2018-04-05 18:15:57.485 debug Type (from Obj) for hm-rpc.0.LEQ0534246.2.CURRENT: 0 sql.0 2018-04-05 18:15:57.485 debug number / 0 / {"def":0,"type":"number","read":true,"write":false,"min":0,"max":65535,"unit":"mA","custom":{"sql.0":{"enabled":true}},"name":"Waschmaschine: Leistung.CURRENT"} sql.0 2018-04-05 18:15:57.485 debug Type set in Def for hm-rpc.0.LEQ0534246.2.CURRENT: false sql.0 2018-04-05 18:15:57.485 debug Datatype hm-rpc.0.LEQ0534246.2.CURRENT: Currently: number, StorageType: false sql.0 2018-04-05 18:15:57.485 debug SELECT id, type, name FROM datapoints WHERE name='hm-rpc.0.LEQ0534246.2.POWER'; sql.0 2018-04-05 18:15:57.485 debug Type (from Obj) for hm-rpc.0.LEQ0534246.2.POWER: 0 sql.0 2018-04-05 18:15:57.485 debug number / 0 / {"def":0,"type":"number","read":true,"write":false,"min":0,"max":167772.149902,"unit":"W","custom":{"sql.0":{"enabled":true}},"name":"Waschmaschine: Leistung.POWER"} sql.0 2018-04-05 18:15:57.485 debug Type set in Def for hm-rpc.0.LEQ0534246.2.POWER: false sql.0 2018-04-05 18:15:57.483 debug Datatype hm-rpc.0.LEQ0534246.2.POWER: Currently: number, StorageType: false sql.0 2018-04-05 18:15:56.484 debug new value received for hm-rpc.0.LEQ0534246.2.CURRENT, new-value=44, ts=1522944956476, relog=false sql.0 2018-04-05 18:15:56.483 debug new value received for hm-rpc.0.LEQ0534246.2.POWER, new-value=0.26, ts=1522944956475, relog=false sql.0 2018-04-05 18:15:49.590 debug DELETE FROM ts_number WHERE id=41 AND ts < 1491408900589; sql.0 2018-04-05 18:15:49.557 debug INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(41, 1522944948550, 30, 1, 1, 0); sql.0 2018-04-05 18:15:49.557 debug DELETE FROM ts_number WHERE id=40 AND ts < 1491408900557; sql.0 2018-04-05 18:15:49.557 debug SELECT id, type, name FROM datapoints WHERE name='hm-rpc.0.KEQ0576469.4.SET_TEMPERATURE'; sql.0 2018-04-05 18:15:49.557 debug Type (from Obj) for hm-rpc.0.KEQ0576469.4.SET_TEMPERATURE: 0 sql.0 2018-04-05 18:15:49.557 debug number / 0 / {"def":20,"type":"number","read":true,"write":true,"min":4.5,"max":30.5,"unit":"°C","role":"level.temperature","custom":{"sql.0":{"enabled":true}},"name":"Heizung: Bad_EG.SET_TEMPERATURE" sql.0 2018-04-05 18:15:49.557 debug Type set in Def for hm-rpc.0.KEQ0576469.4.SET_TEMPERATURE: false sql.0 2018-04-05 18:15:49.557 debug Datatype hm-rpc.0.KEQ0576469.4.SET_TEMPERATURE: Currently: number, StorageType: false sql.0 2018-04-05 18:15:49.542 debug INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(40, 1522944948527, 27.6, 1, 1, 0); sql.0 2018-04-05 18:15:49.542 debug SELECT id, type, name FROM datapoints WHERE name='hm-rpc.0.KEQ0576469.4.ACTUAL_TEMPERATURE'; sql.0 2018-04-05 18:15:49.542 debug Type (from Obj) for hm-rpc.0.KEQ0576469.4.ACTUAL_TEMPERATURE: 0 sql.0 2018-04-05 18:15:49.542 debug number / 0 / {"def":0,"type":"number","read":true,"write":false,"min":-10,"max":56,"unit":"°C","role":"value.temperature","custom":{"sql.0":{"enabled":true}},"name":"Heizung: Bad_EG.ACTUAL_TEMPERATURE sql.0 2018-04-05 18:15:49.542 debug Type set in Def for hm-rpc.0.KEQ0576469.4.ACTUAL_TEMPERATURE: false sql.0 2018-04-05 18:15:49.542 debug Datatype hm-rpc.0.KEQ0576469.4.ACTUAL_TEMPERATURE: Currently: number, StorageType: false sql.0 2018-04-05 18:15:48.554 debug new value received for hm-rpc.0.KEQ0576469.4.SET_TEMPERATURE, new-value=30, ts=1522944948550, relog=false sql.0 2018-04-05 18:15:48.526 debug new value received for hm-rpc.0.KEQ0576469.4.ACTUAL_TEMPERATURE, new-value=27.6, ts=1522944948527, relog=false sql.0 2018-04-05 18:15:45.458 debug DELETE FROM ts_number WHERE id=33 AND ts < 1491408900442; sql.0 2018-04-05 18:15:45.458 debug DELETE FROM ts_number WHERE id=32 AND ts < 1491408900427; sql.0 2018-04-05 18:15:45.442 debug INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(33, 1522944944288, 6, 1, 1, 0); sql.0 2018-04-05 18:15:45.308 debug INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(32, 1522944944288, 21.8, 1, 1, 0); sql.0 2018-04-05 18:15:45.308 debug SELECT id, type, name FROM datapoints WHERE name='hm-rpc.0.KEQ0574613.4.SET_TEMPERATURE'; sql.0 2018-04-05 18:15:45.308 debug Type (from Obj) for hm-rpc.0.KEQ0574613.4.SET_TEMPERATURE: 0 sql.0 2018-04-05 18:15:45.308 debug number / 0 / {"def":20,"type":"number","read":true,"write":true,"min":4.5,"max":30.5,"unit":"°C","role":"level.temperature","custom":{"sql.0":{"enabled":true}},"name":"Heizung: Philipp L.SET_TEMPERATU sql.0 2018-04-05 18:15:45.308 debug SELECT id, type, name FROM datapoints WHERE name='hm-rpc.0.KEQ0574613.4.ACTUAL_TEMPERATURE'; sql.0 2018-04-05 18:15:45.308 debug Type (from Obj) for hm-rpc.0.KEQ0574613.4.ACTUAL_TEMPERATURE: 0 sql.0 2018-04-05 18:15:45.308 debug number / 0 / {"def":0,"type":"number","read":true,"write":false,"min":-10,"max":56,"unit":"°C","role":"value.temperature","custom":{"sql.0":{"enabled":true}},"name":"Heizung: Philipp L.ACTUAL_TEMPERAT sql.0 2018-04-05 18:15:45.308 debug Type set in Def for hm-rpc.0.KEQ0574613.4.SET_TEMPERATURE: false sql.0 2018-04-05 18:15:45.308 debug Datatype hm-rpc.0.KEQ0574613.4.SET_TEMPERATURE: Currently: number, StorageType: false sql.0 2018-04-05 18:15:45.308 debug Type set in Def for hm-rpc.0.KEQ0574613.4.ACTUAL_TEMPERATURE: false sql.0 2018-04-05 18:15:45.308 debug Datatype hm-rpc.0.KEQ0574613.4.ACTUAL_TEMPERATURE: Currently: number, StorageType: false sql.0 2018-04-05 18:15:44.287 debug new value received for hm-rpc.0.KEQ0574613.4.SET_TEMPERATURE, new-value=6, ts=1522944944288, relog=false sql.0 2018-04-05 18:15:44.287 debug new value received for hm-rpc.0.KEQ0574613.4.ACTUAL_TEMPERATURE, new-value=21.8, ts=1522944944288, relog=false sql.0 2018-04-05 18:15:43.184 debug DELETE FROM ts_number WHERE id=35 AND ts < 1491408900180; sql.0 2018-04-05 18:15:43.181 debug DELETE FROM ts_number WHERE id=34 AND ts < 1491408900156; sql.0 2018-04-05 18:15:43.156 debug INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(35, 1522944942110, 6, 1, 1, 0); sql.0 2018-04-05 18:15:43.141 debug INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(34, 1522944942110, 19.5, 1, 1, 0); sql.0 2018-04-05 18:15:43.141 debug SELECT id, type, name FROM datapoints WHERE name='hm-rpc.0.KEQ0574642.4.SET_TEMPERATURE'; sql.0 2018-04-05 18:15:43.141 debug Type (from Obj) for hm-rpc.0.KEQ0574642.4.SET_TEMPERATURE: 0 sql.0 2018-04-05 18:15:43.141 debug number / 0 / {"def":20,"type":"number","read":true,"write":true,"min":4.5,"max":30.5,"unit":"°C","role":"level.temperature","custom":{"sql.0":{"enabled":true}},"name":"Heizung: Rebecca L.SET_TEMPERATU sql.0 2018-04-05 18:15:43.141 debug SELECT id, type, name FROM datapoints WHERE name='hm-rpc.0.KEQ0574642.4.ACTUAL_TEMPERATURE'; sql.0 2018-04-05 18:15:43.141 debug Type (from Obj) for hm-rpc.0.KEQ0574642.4.ACTUAL_TEMPERATURE: 0 sql.0 2018-04-05 18:15:43.141 debug number / 0 / {"def":0,"type":"number","read":true,"write":false,"min":-10,"max":56,"unit":"°C","role":"value.temperature","custom":{"sql.0":{"enabled":true}},"name":"Heizung: Rebecca L.ACTUAL_TEMPERAT sql.0 2018-04-05 18:15:43.141 debug Type set in Def for hm-rpc.0.KEQ0574642.4.SET_TEMPERATURE: false sql.0 2018-04-05 18:15:43.141 debug Datatype hm-rpc.0.KEQ0574642.4.SET_TEMPERATURE: Currently: number, StorageType: false sql.0 2018-04-05 18:15:43.141 debug Type set in Def for hm-rpc.0.KEQ0574642.4.ACTUAL_TEMPERATURE: false sql.0 2018-04-05 18:15:43.141 debug Datatype hm-rpc.0.KEQ0574642.4.ACTUAL_TEMPERATURE: Currently: number, StorageType: false sql.0 2018-04-05 18:15:42.125 debug new value received for hm-rpc.0.KEQ0574642.4.SET_TEMPERATURE, new-value=6, ts=1522944942110, relog=false sql.0 2018-04-05 18:15:42.125 debug new value received for hm-rpc.0.KEQ0574642.4.ACTUAL_TEMPERATURE, new-value=19.5, ts=1522944942110, relog=false sql.0 2018-04-05 18:15:40.675 debug DELETE FROM ts_number WHERE id=31 AND ts < 1491408900671; sql.0 2018-04-05 18:15:40.671 debug DELETE FROM ts_number WHERE id=30 AND ts < 1491408900656; sql.0 2018-04-05 18:15:40.658 debug INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(31, 1522944939604, 5, 1, 1, 0); sql.0 2018-04-05 18:15:40.632 debug INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(30, 1522944939604, 14.8, 1, 1, 0); sql.0 2018-04-05 18:15:40.630 debug SELECT id, type, name FROM datapoints WHERE name='hm-rpc.0.KEQ0574459.4.SET_TEMPERATURE'; sql.0 2018-04-05 18:15:40.630 debug Type (from Obj) for hm-rpc.0.KEQ0574459.4.SET_TEMPERATURE: 0 sql.0 2018-04-05 18:15:40.630 debug number / 0 / {"def":20,"type":"number","read":true,"write":true,"min":4.5,"max":30.5,"unit":"°C","role":"level.temperature","custom":{"sql.0":{"enabled":true}},"name":"Heizung: Fitnessraum.SET_TEMPERA sql.0 2018-04-05 18:15:40.630 debug SELECT id, type, name FROM datapoints WHERE name='hm-rpc.0.KEQ0574459.4.ACTUAL_TEMPERATURE'; sql.0 2018-04-05 18:15:40.630 debug Type (from Obj) for hm-rpc.0.KEQ0574459.4.ACTUAL_TEMPERATURE: 0 sql.0 2018-04-05 18:15:40.630 debug number / 0 / {"def":0,"type":"number","read":true,"write":false,"min":-10,"max":56,"unit":"°C","role":"value.temperature","custom":{"sql.0":{"enabled":true}},"name":"Heizung: Fitnessraum.ACTUAL_TEMPER sql.0 2018-04-05 18:15:40.627 debug Type set in Def for hm-rpc.0.KEQ0574459.4.SET_TEMPERATURE: false sql.0 2018-04-05 18:15:40.627 debug Datatype hm-rpc.0.KEQ0574459.4.SET_TEMPERATURE: Currently: number, StorageType: false sql.0 2018-04-05 18:15:40.626 debug Type set in Def for hm-rpc.0.KEQ0574459.4.ACTUAL_TEMPERATURE: false sql.0 2018-04-05 18:15:40.626 debug Datatype hm-rpc.0.KEQ0574459.4.ACTUAL_TEMPERATURE: Currently: number, StorageType: false sql.0 2018-04-05 18:15:39.618 debug new value received for hm-rpc.0.KEQ0574459.4.SET_TEMPERATURE, new-value=5, ts=1522944939604, relog=false sql.0 2018-04-05 18:15:39.618 debug new value received for hm-rpc.0.KEQ0574459.4.ACTUAL_TEMPERATURE, new-value=14.8, ts=1522944939604, relog=false sql.0 2018-04-05 18:15:34.194 debug DELETE FROM ts_number WHERE id=23 AND ts < 1491408900182; sql.0 2018-04-05 18:15:34.189 debug DELETE FROM ts_number WHERE id=19 AND ts < 1491408900167; sql.0 2018-04-05 18:15:34.187 debug DELETE FROM ts_number WHERE id=20 AND ts < 1491408900146; sql.0 2018-04-05 18:15:34.183 debug DELETE FROM ts_number WHERE id=21 AND ts < 1491408900134; sql.0 2018-04-05 18:15:34.175 debug INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(23, 1522944933111, 19, 1, 1, 0); sql.0 2018-04-05 18:15:34.171 debug DELETE FROM ts_bool WHERE id=22 AND ts < 1491408900122; sql.0 2018-04-05 18:15:34.169 debug DELETE FROM ts_number WHERE id=24 AND ts < 1491408900107; sql.0 2018-04-05 18:15:34.156 debug INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(19, 1522944933063, 7.9, 1, 1, 0); sql.0 2018-04-05 18:15:34.136 debug INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(20, 1522944933066, 245, 1, 1, 0); sql.0 2018-04-05 18:15:34.124 debug INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(21, 1522944933065, 5.1, 1, 1, 0); sql.0 2018-04-05 18:15:34.116 debug SELECT id, type, name FROM datapoints WHERE name='hm-rpc.0.LEQ1221393.1.BRIGHTNESS'; sql.0 2018-04-05 18:15:34.116 debug Type (from Obj) for hm-rpc.0.LEQ1221393.1.BRIGHTNESS: 0 sql.0 2018-04-05 18:15:34.116 debug number / 0 / {"def":0,"type":"number","read":true,"write":false,"min":0,"max":255,"role":"value.brightness","custom":{"sql.0":{"enabled":true}},"name":"Kombisensor.BRIGHTNESS"} sql.0 2018-04-05 18:15:34.113 debug Type set in Def for hm-rpc.0.LEQ1221393.1.BRIGHTNESS: false sql.0 2018-04-05 18:15:34.113 debug Datatype hm-rpc.0.LEQ1221393.1.BRIGHTNESS: Currently: number, StorageType: false sql.0 2018-04-05 18:15:34.107 debug INSERT INTO ts_bool (id, ts, val, ack, _from, q) VALUES(22, 1522944933065, 0, 1, 1, 0); sql.0 2018-04-05 18:15:34.089 debug INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(24, 1522944933064, 63, 1, 1, 0); sql.0 2018-04-05 18:15:34.073 debug SELECT id, type, name FROM datapoints WHERE name='hm-rpc.0.LEQ1221393.1.WIND_DIRECTION'; sql.0 2018-04-05 18:15:34.073 debug Type (from Obj) for hm-rpc.0.LEQ1221393.1.WIND_DIRECTION: 0 sql.0 2018-04-05 18:15:34.073 debug number / 0 / {"def":0,"type":"number","read":true,"write":false,"min":0,"max":355,"unit":"degree","custom":{"sql.0":{"enabled":true}},"name":"Kombisensor.WIND_DIRECTION"} sql.0 2018-04-05 18:15:34.073 debug SELECT id, type, name FROM datapoints WHERE name='hm-rpc.0.LEQ1221393.1.WIND_SPEED'; sql.0 2018-04-05 18:15:34.073 debug Type (from Obj) for hm-rpc.0.LEQ1221393.1.WIND_SPEED: 0 sql.0 2018-04-05 18:15:34.073 debug number / 0 / {"def":0,"type":"number","read":true,"write":false,"min":0,"max":1638.299999,"unit":"km/h","custom":{"sql.0":{"enabled":true}},"name":"Kombisensor.WIND_SPEED"} sql.0 2018-04-05 18:15:34.073 debug SELECT id, type, name FROM datapoints WHERE name='hm-rpc.0.LEQ1221393.1.RAINING'; sql.0 2018-04-05 18:15:34.073 debug Type (from Obj) for hm-rpc.0.LEQ1221393.1.RAINING: 2 sql.0 2018-04-05 18:15:34.073 debug boolean / 2 / {"def":false,"type":"boolean","read":true,"write":false,"custom":{"sql.0":{"enabled":true}},"name":"Kombisensor.RAINING"} sql.0 2018-04-05 18:15:34.073 debug SELECT id, type, name FROM datapoints WHERE name='hm-rpc.0.LEQ1221393.1.HUMIDITY'; sql.0 2018-04-05 18:15:34.073 debug Type (from Obj) for hm-rpc.0.LEQ1221393.1.HUMIDITY: 0 sql.0 2018-04-05 18:15:34.073 debug number / 0 / {"def":0,"type":"number","read":true,"write":false,"min":0,"max":99,"unit":"%","role":"value.humidity","custom":{"sql.0":{"enabled":true}},"name":"Kombisensor.HUMIDITY"} sql.0 2018-04-05 18:15:34.073 debug SELECT id, type, name FROM datapoints WHERE name='hm-rpc.0.LEQ1221393.1.TEMPERATURE'; sql.0 2018-04-05 18:15:34.073 debug Type (from Obj) for hm-rpc.0.LEQ1221393.1.TEMPERATURE: 0 sql.0 2018-04-05 18:15:34.073 debug number / 0 / {"def":0,"type":"number","read":true,"write":false,"min":-40,"max":80,"unit":"°C","role":"value.temperature","custom":{"sql.0":{"enabled":true}},"name":"Kombisensor.TEMPERATURE"} sql.0 2018-04-05 18:15:34.073 debug Type set in Def for hm-rpc.0.LEQ1221393.1.WIND_DIRECTION: false sql.0 2018-04-05 18:15:34.073 debug Datatype hm-rpc.0.LEQ1221393.1.WIND_DIRECTION: Currently: number, StorageType: false sql.0 2018-04-05 18:15:34.073 debug Type set in Def for hm-rpc.0.LEQ1221393.1.WIND_SPEED: false sql.0 2018-04-05 18:15:34.073 debug Datatype hm-rpc.0.LEQ1221393.1.WIND_SPEED: Currently: number, StorageType: false sql.0 2018-04-05 18:15:34.073 debug Type set in Def for hm-rpc.0.LEQ1221393.1.RAINING: false sql.0 2018-04-05 18:15:34.073 debug Datatype hm-rpc.0.LEQ1221393.1.RAINING: Currently: boolean, StorageType: false sql.0 2018-04-05 18:15:34.073 debug Type set in Def for hm-rpc.0.LEQ1221393.1.HUMIDITY: false sql.0 2018-04-05 18:15:34.073 debug Datatype hm-rpc.0.LEQ1221393.1.HUMIDITY: Currently: number, StorageType: false sql.0 2018-04-05 18:15:34.073 debug Type set in Def for hm-rpc.0.LEQ1221393.1.TEMPERATURE: false sql.0 2018-04-05 18:15:34.073 debug Datatype hm-rpc.0.LEQ1221393.1.TEMPERATURE: Currently: number, StorageType: false sql.0 2018-04-05 18:15:33.590 debug DELETE FROM ts_number WHERE id=42 AND ts < 1491408900586; sql.0 2018-04-05 18:15:33.587 debug DELETE FROM ts_number WHERE id=43 AND ts < 1491408900568; sql.0 2018-04-05 18:15:33.569 debug INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(42, 1522944932503, 23.7, 1, 1, 0); sql.0 2018-04-05 18:15:33.545 debug INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(43, 1522944932503, 22, 1, 1, 0); sql.0 2018-04-05 18:15:33.538 debug SELECT id, type, name FROM datapoints WHERE name='hm-rpc.0.KEQ0653104.4.SET_TEMPERATURE'; sql.0 2018-04-05 18:15:33.538 debug Type (from Obj) for hm-rpc.0.KEQ0653104.4.SET_TEMPERATURE: 0 sql.0 2018-04-05 18:15:33.538 debug number / 0 / {"def":20,"type":"number","read":true,"write":true,"min":4.5,"max":30.5,"unit":"°C","role":"level.temperature","custom":{"sql.0":{"enabled":true}},"name":"Heizung: Wohnzimmer.SET_TEMPERAT sql.0 2018-04-05 18:15:33.538 debug SELECT id, type, name FROM datapoints WHERE name='hm-rpc.0.KEQ0653104.4.ACTUAL_TEMPERATURE'; sql.0 2018-04-05 18:15:33.538 debug Type (from Obj) for hm-rpc.0.KEQ0653104.4.ACTUAL_TEMPERATURE: 0 sql.0 2018-04-05 18:15:33.538 debug number / 0 / {"def":0,"type":"number","read":true,"write":false,"min":-10,"max":56,"unit":"°C","role":"value.temperature","custom":{"sql.0":{"enabled":true}},"name":"Heizung: Wohnzimmer.ACTUAL_TEMPERA sql.0 2018-04-05 18:15:33.538 debug Type set in Def for hm-rpc.0.KEQ0653104.4.SET_TEMPERATURE: false sql.0 2018-04-05 18:15:33.538 debug Datatype hm-rpc.0.KEQ0653104.4.SET_TEMPERATURE: Currently: number, StorageType: false sql.0 2018-04-05 18:15:33.537 debug Type set in Def for hm-rpc.0.KEQ0653104.4.ACTUAL_TEMPERATURE: false sql.0 2018-04-05 18:15:33.537 debug Datatype hm-rpc.0.KEQ0653104.4.ACTUAL_TEMPERATURE: Currently: number, StorageType: false sql.0 2018-04-05 18:15:33.113 debug new value received for hm-rpc.0.LEQ1221393.1.BRIGHTNESS, new-value=19, ts=1522944933111, relog=false sql.0 2018-04-05 18:15:33.071 debug new value received for hm-rpc.0.LEQ1221393.1.WIND_DIRECTION, new-value=245, ts=1522944933066, relog=false sql.0 2018-04-05 18:15:33.071 debug new value received for hm-rpc.0.LEQ1221393.1.WIND_SPEED, new-value=5.1, ts=1522944933065, relog=false sql.0 2018-04-05 18:15:33.070 debug new value received for hm-rpc.0.LEQ1221393.1.RAINING, new-value=false, ts=1522944933065, relog=false sql.0 2018-04-05 18:15:33.070 debug new value received for hm-rpc.0.LEQ1221393.1.HUMIDITY, new-value=63, ts=1522944933064, relog=false sql.0 2018-04-05 18:15:33.070 debug new value received for hm-rpc.0.LEQ1221393.1.TEMPERATURE, new-value=7.9, ts=1522944933063, relog=false sql.0 2018-04-05 18:15:32.518 debug new value received for hm-rpc.0.KEQ0653104.4.SET_TEMPERATURE, new-value=22, ts=1522944932503, relog=false sql.0 2018-04-05 18:15:32.518 debug new value received for hm-rpc.0.KEQ0653104.4.ACTUAL_TEMPERATURE, new-value=23.7, ts=1522944932503, relog=false sql.0 2018-04-05 18:15:32.019 debug DELETE FROM ts_number WHERE id=37 AND ts < 1491408900017; sql.0 2018-04-05 18:15:32.002 debug INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(37, 1522944930987, 5, 1, 1, 0); sql.0 2018-04-05 18:15:31.994 debug SELECT id, type, name FROM datapoints WHERE name='hm-rpc.0.KEQ1040517.4.SET_TEMPERATURE'; sql.0 2018-04-05 18:15:31.994 debug Type (from Obj) for hm-rpc.0.KEQ1040517.4.SET_TEMPERATURE: 0 sql.0 2018-04-05 18:15:31.994 debug number / 0 / {"def":20,"type":"number","read":true,"write":true,"min":4.5,"max":30.5,"unit":"°C","role":"level.temperature","custom":{"sql.0":{"enabled":true}},"name":"Heizung: Hobbyraum.SET_TEMPERATU sql.0 2018-04-05 18:15:31.994 debug Type set in Def for hm-rpc.0.KEQ1040517.4.SET_TEMPERATURE: false sql.0 2018-04-05 18:15:31.992 debug Datatype hm-rpc.0.KEQ1040517.4.SET_TEMPERATURE: Currently: number, StorageType: false sql.0 2018-04-05 18:15:31.975 debug DELETE FROM ts_number WHERE id=36 AND ts < 1491408900975; sql.0 2018-04-05 18:15:31.960 debug INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(36, 1522944930937, 15.7, 1, 1, 0); sql.0 2018-04-05 18:15:31.960 debug SELECT id, type, name FROM datapoints WHERE name='hm-rpc.0.KEQ1040517.4.ACTUAL_TEMPERATURE'; sql.0 2018-04-05 18:15:31.960 debug Type (from Obj) for hm-rpc.0.KEQ1040517.4.ACTUAL_TEMPERATURE: 0 sql.0 2018-04-05 18:15:31.960 debug number / 0 / {"def":0,"type":"number","read":true,"write":false,"min":-10,"max":56,"unit":"°C","role":"value.temperature","custom":{"sql.0":{"enabled":true}},"name":"Heizung: Hobbyraum.ACTUAL_TEMPERAT sql.0 2018-04-05 18:15:31.960 debug Type set in Def for hm-rpc.0.KEQ1040517.4.ACTUAL_TEMPERATURE: false sql.0 2018-04-05 18:15:31.960 debug Datatype hm-rpc.0.KEQ1040517.4.ACTUAL_TEMPERATURE: Currently: number, StorageType: false sql.0 2018-04-05 18:15:30.990 debug new value received for hm-rpc.0.KEQ1040517.4.SET_TEMPERATURE, new-value=5, ts=1522944930987, relog=false sql.0 2018-04-05 18:15:30.952 debug new value received for hm-rpc.0.KEQ1040517.4.ACTUAL_TEMPERATURE, new-value=15.7, ts=1522944930937, relog=false sql.0 2018-04-05 18:15:22.934 debug DELETE FROM ts_number WHERE id=38 AND ts < 1491408900928; sql.0 2018-04-05 18:15:22.930 debug DELETE FROM ts_number WHERE id=39 AND ts < 1491408900909; sql.0 2018-04-05 18:15:22.913 debug INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(38, 1522944921845, 5, 1, 1, 0); sql.0 2018-04-05 18:15:22.891 debug INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(39, 1522944921845, 15.3, 1, 1, 0); sql.0 2018-04-05 18:15:22.875 debug SELECT id, type, name FROM datapoints WHERE name='hm-rpc.0.LEQ0784844.4.SET_TEMPERATURE'; sql.0 2018-04-05 18:15:22.875 debug Type (from Obj) for hm-rpc.0.LEQ0784844.4.SET_TEMPERATURE: 0 sql.0 2018-04-05 18:15:22.875 debug number / 0 / {"def":20,"type":"number","read":true,"write":true,"min":4.5,"max":30.5,"unit":"°C","role":"level.temperature","custom":{"sql.0":{"enabled":true}},"name":"Heizung: Sauna.SET_TEMPERATURE"} sql.0 2018-04-05 18:15:22.875 debug SELECT id, type, name FROM datapoints WHERE name='hm-rpc.0.LEQ0784844.4.ACTUAL_TEMPERATURE'; sql.0 2018-04-05 18:15:22.875 debug Type (from Obj) for hm-rpc.0.LEQ0784844.4.ACTUAL_TEMPERATURE: 0 sql.0 2018-04-05 18:15:22.875 debug number / 0 / {"def":0,"type":"number","read":true,"write":false,"min":-10,"max":56,"unit":"°C","role":"value.temperature","custom":{"sql.0":{"enabled":true}},"name":"Heizung: Sauna.ACTUAL_TEMPERATURE" sql.0 2018-04-05 18:15:22.875 debug Type set in Def for hm-rpc.0.LEQ0784844.4.SET_TEMPERATURE: false sql.0 2018-04-05 18:15:22.875 debug Datatype hm-rpc.0.LEQ0784844.4.SET_TEMPERATURE: Currently: number, StorageType: false sql.0 2018-04-05 18:15:22.875 debug Type set in Def for hm-rpc.0.LEQ0784844.4.ACTUAL_TEMPERATURE: false sql.0 2018-04-05 18:15:22.875 debug Datatype hm-rpc.0.LEQ0784844.4.ACTUAL_TEMPERATURE: Currently: number, StorageType: false sql.0 2018-04-05 18:15:21.860 debug new value received for hm-rpc.0.LEQ0784844.4.SET_TEMPERATURE, new-value=5, ts=1522944921845, relog=false sql.0 2018-04-05 18:15:21.860 debug new value received for hm-rpc.0.LEQ0784844.4.ACTUAL_TEMPERATURE, new-value=15.3, ts=1522944921845, relog=false sql.0 2018-04-05 18:15:21.419 debug DELETE FROM ts_number WHERE id=2 AND ts < 1491408900415; sql.0 2018-04-05 18:15:21.416 debug DELETE FROM ts_number WHERE id=5 AND ts < 1491408900397; sql.0 2018-04-05 18:15:21.400 debug INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(2, 1522944920343, 0, 1, 1, 0); sql.0 2018-04-05 18:15:21.377 debug INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(5, 1522944920343, 0.02, 1, 1, 0); sql.0 2018-04-05 18:15:21.362 debug SELECT id, type, name FROM datapoints WHERE name='hm-rpc.0.LEQ0471906.2.CURRENT'; sql.0 2018-04-05 18:15:21.362 debug Type (from Obj) for hm-rpc.0.LEQ0471906.2.CURRENT: 0 sql.0 2018-04-05 18:15:21.362 debug number / 0 / {"def":0,"type":"number","read":true,"write":false,"min":0,"max":65535,"unit":"mA","custom":{"sql.0":{"enabled":true}},"name":"Spülmaschine: Leistung.CURRENT"} sql.0 2018-04-05 18:15:21.362 debug SELECT id, type, name FROM datapoints WHERE name='hm-rpc.0.LEQ0471906.2.POWER'; sql.0 2018-04-05 18:15:21.362 debug Type (from Obj) for hm-rpc.0.LEQ0471906.2.POWER: 0 sql.0 2018-04-05 18:15:21.362 debug number / 0 / {"def":0,"type":"number","read":true,"write":false,"min":0,"max":167772.149902,"unit":"W","custom":{"sql.0":{"enabled":true}},"name":"Spülmaschine: Leistung.POWER"} sql.0 2018-04-05 18:15:21.362 debug Type set in Def for hm-rpc.0.LEQ0471906.2.CURRENT: false sql.0 2018-04-05 18:15:21.362 debug Datatype hm-rpc.0.LEQ0471906.2.CURRENT: Currently: number, StorageType: false sql.0 2018-04-05 18:15:21.362 debug Type set in Def for hm-rpc.0.LEQ0471906.2.POWER: false sql.0 2018-04-05 18:15:21.362 debug Datatype hm-rpc.0.LEQ0471906.2.POWER: Currently: number, StorageType: false sql.0 2018-04-05 18:15:20.977 debug DELETE FROM ts_number WHERE id=15 AND ts < 1491408900972; sql.0 2018-04-05 18:15:20.974 debug DELETE FROM ts_number WHERE id=14 AND ts < 1491408900940; sql.0 2018-04-05 18:15:20.955 debug INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(15, 1522944919907, 6, 1, 1, 0); sql.0 2018-04-05 18:15:20.924 debug INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(14, 1522944919907, 20.7, 1, 1, 0); sql.0 2018-04-05 18:15:20.924 debug SELECT id, type, name FROM datapoints WHERE name='hm-rpc.0.LEQ0783942.4.SET_TEMPERATURE'; sql.0 2018-04-05 18:15:20.924 debug Type (from Obj) for hm-rpc.0.LEQ0783942.4.SET_TEMPERATURE: 0 sql.0 2018-04-05 18:15:20.924 debug number / 0 / {"def":20,"type":"number","read":true,"write":true,"min":4.5,"max":30.5,"unit":"°C","role":"level.temperature","custom":{"sql.0":{"enabled":true}},"name":"Heizung: Bad_OG - Handtuch.SET_T sql.0 2018-04-05 18:15:20.924 debug SELECT id, type, name FROM datapoints WHERE name='hm-rpc.0.LEQ0783942.4.ACTUAL_TEMPERATURE'; sql.0 2018-04-05 18:15:20.924 debug Type (from Obj) for hm-rpc.0.LEQ0783942.4.ACTUAL_TEMPERATURE: 0 sql.0 2018-04-05 18:15:20.924 debug number / 0 / {"def":0,"type":"number","read":true,"write":false,"min":-10,"max":56,"unit":"°C","role":"value.temperature","custom":{"sql.0":{"enabled":true}},"name":"Heizung: Bad_OG - Handtuch.ACTUAL_ sql.0 2018-04-05 18:15:20.924 debug Type set in Def for hm-rpc.0.LEQ0783942.4.SET_TEMPERATURE: false sql.0 2018-04-05 18:15:20.924 debug Datatype hm-rpc.0.LEQ0783942.4.SET_TEMPERATURE: Currently: number, StorageType: false sql.0 2018-04-05 18:15:20.924 debug Type set in Def for hm-rpc.0.LEQ0783942.4.ACTUAL_TEMPERATURE: false sql.0 2018-04-05 18:15:20.924 debug Datatype hm-rpc.0.LEQ0783942.4.ACTUAL_TEMPERATURE: Currently: number, StorageType: false sql.0 2018-04-05 18:15:20.357 debug new value received for hm-rpc.0.LEQ0471906.2.CURRENT, new-value=0, ts=1522944920343, relog=false sql.0 2018-04-05 18:15:20.357 debug new value received for hm-rpc.0.LEQ0471906.2.POWER, new-value=0.02, ts=1522944920343, relog=false sql.0 2018-04-05 18:15:19.906 debug new value received for hm-rpc.0.LEQ0783942.4.SET_TEMPERATURE, new-value=6, ts=1522944919907, relog=false sql.0 2018-04-05 18:15:19.906 debug new value received for hm-rpc.0.LEQ0783942.4.ACTUAL_TEMPERATURE, new-value=20.7, ts=1522944919907, relog=false sql.0 2018-04-05 18:15:17.557 debug DELETE FROM ts_number WHERE id=16 AND ts < 1491408900542; sql.0 2018-04-05 18:15:17.526 debug INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(16, 1522944916517, 8.4, 1, 1, 0); sql.0 2018-04-05 18:15:17.526 debug SELECT id, type, name FROM datapoints WHERE name='hm-rpc.0.KEQ0766778.1.TEMPERATURE'; sql.0 2018-04-05 18:15:17.526 debug Type (from Obj) for hm-rpc.0.KEQ0766778.1.TEMPERATURE: 0 sql.0 2018-04-05 18:15:17.526 debug number / 0 / {"def":0,"type":"number","read":true,"write":false,"min":-40,"max":80,"unit":"°C","role":"value.temperature","custom":{"sql.0":{"enabled":true}},"name":"Umwelt: Außensensor.TEMPERATURE"} sql.0 2018-04-05 18:15:17.526 debug Type set in Def for hm-rpc.0.KEQ0766778.1.TEMPERATURE: false sql.0 2018-04-05 18:15:17.526 debug Datatype hm-rpc.0.KEQ0766778.1.TEMPERATURE: Currently: number, StorageType: false sql.0 2018-04-05 18:15:16.518 debug new value received for hm-rpc.0.KEQ0766778.1.TEMPERATURE, new-value=8.4, ts=1522944916517, relog=false sql.0 2018-04-05 18:15:13.833 debug DELETE FROM ts_number WHERE id=26 AND ts < 1491408900829; sql.0 2018-04-05 18:15:13.831 debug DELETE FROM ts_number WHERE id=25 AND ts < 1491408900797; sql.0 2018-04-05 18:15:13.814 debug INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(26, 1522944912771, 6, 1, 1, 0); sql.0 2018-04-05 18:15:13.781 debug INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(25, 1522944912769, 19.8, 1, 1, 0); sql.0 2018-04-05 18:15:13.781 debug SELECT id, type, name FROM datapoints WHERE name='hm-rpc.0.KEQ0724743.4.SET_TEMPERATURE'; sql.0 2018-04-05 18:15:13.781 debug Type (from Obj) for hm-rpc.0.KEQ0724743.4.SET_TEMPERATURE: 0 sql.0 2018-04-05 18:15:13.781 debug number / 0 / {"def":20,"type":"number","read":true,"write":true,"min":4.5,"max":30.5,"unit":"°C","role":"level.temperature","custom":{"sql.0":{"enabled":true}},"name":"Heizung: Bad_OG.SET_TEMPERATURE" sql.0 2018-04-05 18:15:13.781 debug SELECT id, type, name FROM datapoints WHERE name='hm-rpc.0.KEQ0724743.4.ACTUAL_TEMPERATURE'; sql.0 2018-04-05 18:15:13.781 debug Type (from Obj) for hm-rpc.0.KEQ0724743.4.ACTUAL_TEMPERATURE: 0 sql.0 2018-04-05 18:15:13.781 debug number / 0 / {"def":0,"type":"number","read":true,"write":false,"min":-10,"max":56,"unit":"°C","role":"value.temperature","custom":{"sql.0":{"enabled":true}},"name":"Heizung: Bad_OG.ACTUAL_TEMPERATURE sql.0 2018-04-05 18:15:13.781 debug Type set in Def for hm-rpc.0.KEQ0724743.4.SET_TEMPERATURE: false sql.0 2018-04-05 18:15:13.781 debug Datatype hm-rpc.0.KEQ0724743.4.SET_TEMPERATURE: Currently: number, StorageType: false sql.0 2018-04-05 18:15:13.781 debug Type set in Def for hm-rpc.0.KEQ0724743.4.ACTUAL_TEMPERATURE: false sql.0 2018-04-05 18:15:13.781 debug Datatype hm-rpc.0.KEQ0724743.4.ACTUAL_TEMPERATURE: Currently: number, StorageType: false sql.0 2018-04-05 18:15:12.778 debug new value received for hm-rpc.0.KEQ0724743.4.SET_TEMPERATURE, new-value=6, ts=1522944912771, relog=false sql.0 2018-04-05 18:15:12.778 debug new value received for hm-rpc.0.KEQ0724743.4.ACTUAL_TEMPERATURE, new-value=19.8, ts=1522944912769, relog=false sql.0 2018-04-05 18:15:05.742 debug system.adapter.admin.0: logging true sql.0 2018-04-05 18:15:05.254 debug DELETE FROM ts_number WHERE id=44 AND ts < 1491408900238; sql.0 2018-04-05 18:15:05.238 debug INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(44, 1522944904234, 1489.16, 1, 1, 0); sql.0 2018-04-05 18:15:05.238 debug SELECT id, type, name FROM datapoints WHERE name='hm-rpc.0.NEQ0322651.1.LUX'; sql.0 2018-04-05 18:15:05.238 debug Type (from Obj) for hm-rpc.0.NEQ0322651.1.LUX: 0 sql.0 2018-04-05 18:15:05.238 debug number / 0 / {"def":0,"type":"number","read":true,"write":false,"min":0,"max":200000,"unit":"Lux","custom":{"sql.0":{"enabled":true}},"name":"Umwelt: Lichtsensor1.LUX"} sql.0 2018-04-05 18:15:05.238 debug Type set in Def for hm-rpc.0.NEQ0322651.1.LUX: false sql.0 2018-04-05 18:15:05.238 debug Datatype hm-rpc.0.NEQ0322651.1.LUX: Currently: number, StorageType: false sql.0 2018-04-05 18:15:04.234 debug new value received for hm-rpc.0.NEQ0322651.1.LUX, new-value=1489.16, ts=1522944904234, relog=false sql.0 2018-04-05 18:15:02.922 info enabled logging of javascript.0.Status.Wasserzähler.Jahr.Verbrauch_Hochrechnung sql.0 2018-04-05 18:15:02.922 info enabled logging of javascript.0.Status.Wasserzähler.Jahr.Verbrauch_Stand_Jahresanfang sql.0 2018-04-05 18:15:02.922 info enabled logging of javascript.0.Status.Wasserzähler.Aktuell.Verbrauch_in_m3 sql.0 2018-04-05 18:15:02.922 info enabled logging of javascript.0.Status.Wasserzähler.Monat.Verbrauch_in_m3 sql.0 2018-04-05 18:15:02.922 info enabled logging of javascript.0.Status.Wasserzähler.Tag.Verbrauch_in_m3 sql.0 2018-04-05 18:15:02.922 info enabled logging of javascript.0.Status.Wasserzähler.Stunde.Verbrauch_in_m3 sql.0 2018-04-05 18:15:02.922 info enabled logging of mbus.0.BMT-17834338.data.0-0-Current sql.0 2018-04-05 18:15:02.922 info enabled logging of hm-rpc.0.NEQ0322651.1.LUX sql.0 2018-04-05 18:15:02.922 info enabled logging of hm-rpc.0.NEQ0322032.1.LUX sql.0 2018-04-05 18:15:02.922 info enabled logging of hm-rpc.0.LEQ1221393.1.WIND_SPEED sql.0 2018-04-05 18:15:02.921 info enabled logging of hm-rpc.0.LEQ1221393.1.WIND_DIRECTION sql.0 2018-04-05 18:15:02.921 info enabled logging of hm-rpc.0.LEQ1221393.1.TEMPERATURE sql.0 2018-04-05 18:15:02.921 info enabled logging of hm-rpc.0.LEQ1221393.1.RAINING sql.0 2018-04-05 18:15:02.921 info enabled logging of hm-rpc.0.LEQ1221393.1.HUMIDITY sql.0 2018-04-05 18:15:02.921 info enabled logging of hm-rpc.0.LEQ1221393.1.BRIGHTNESS sql.0 2018-04-05 18:15:02.921 info enabled logging of hm-rpc.0.LEQ0784844.4.SET_TEMPERATURE sql.0 2018-04-05 18:15:02.921 info enabled logging of hm-rpc.0.LEQ0784844.4.ACTUAL_TEMPERATURE sql.0 2018-04-05 18:15:02.921 info enabled logging of hm-rpc.0.LEQ0783942.4.SET_TEMPERATURE sql.0 2018-04-05 18:15:02.919 info enabled logging of hm-rpc.0.LEQ0783942.4.ACTUAL_TEMPERATURE sql.0 2018-04-05 18:15:02.919 info enabled logging of hm-rpc.0.LEQ0534246.2.POWER sql.0 2018-04-05 18:15:02.919 info enabled logging of hm-rpc.0.LEQ0534246.2.CURRENT sql.0 2018-04-05 18:15:02.919 info enabled logging of hm-rpc.0.LEQ0471906.2.POWER sql.0 2018-04-05 18:15:02.919 info enabled logging of hm-rpc.0.LEQ0471906.2.CURRENT sql.0 2018-04-05 18:15:02.919 info enabled logging of hm-rpc.0.KEQ1040651.4.SET_TEMPERATURE sql.0 2018-04-05 18:15:02.918 info enabled logging of hm-rpc.0.KEQ1040651.4.ACTUAL_TEMPERATURE sql.0 2018-04-05 18:15:02.918 info enabled logging of hm-rpc.0.KEQ1040517.4.SET_TEMPERATURE sql.0 2018-04-05 18:15:02.918 info enabled logging of hm-rpc.0.KEQ1040517.4.ACTUAL_TEMPERATURE sql.0 2018-04-05 18:15:02.918 info enabled logging of hm-rpc.0.KEQ1040443.4.SET_TEMPERATURE sql.0 2018-04-05 18:15:02.918 info enabled logging of hm-rpc.0.KEQ1040443.4.ACTUAL_TEMPERATURE sql.0 2018-04-05 18:15:02.918 info enabled logging of hm-rpc.0.KEQ1040434.4.SET_TEMPERATURE sql.0 2018-04-05 18:15:02.918 info enabled logging of hm-rpc.0.KEQ1040434.4.ACTUAL_TEMPERATURE sql.0 2018-04-05 18:15:02.918 info enabled logging of hm-rpc.0.KEQ0766778.1.TEMPERATURE sql.0 2018-04-05 18:15:02.918 info enabled logging of hm-rpc.0.KEQ0724743.4.SET_TEMPERATURE sql.0 2018-04-05 18:15:02.918 info enabled logging of hm-rpc.0.KEQ0724743.4.ACTUAL_TEMPERATURE sql.0 2018-04-05 18:15:02.918 info enabled logging of hm-rpc.0.KEQ0653104.4.SET_TEMPERATURE sql.0 2018-04-05 18:15:02.918 info enabled logging of hm-rpc.0.KEQ0653104.4.ACTUAL_TEMPERATURE sql.0 2018-04-05 18:15:02.918 info enabled logging of hm-rpc.0.KEQ0576469.4.SET_TEMPERATURE sql.0 2018-04-05 18:15:02.918 info enabled logging of hm-rpc.0.KEQ0576469.4.ACTUAL_TEMPERATURE sql.0 2018-04-05 18:15:02.918 info enabled logging of hm-rpc.0.KEQ0574642.4.SET_TEMPERATURE sql.0 2018-04-05 18:15:02.918 info enabled logging of hm-rpc.0.KEQ0574642.4.ACTUAL_TEMPERATURE sql.0 2018-04-05 18:15:02.917 info enabled logging of hm-rpc.0.KEQ0574613.4.SET_TEMPERATURE sql.0 2018-04-05 18:15:02.917 info enabled logging of hm-rpc.0.KEQ0574613.4.ACTUAL_TEMPERATURE sql.0 2018-04-05 18:15:02.917 info enabled logging of hm-rpc.0.KEQ0574459.4.SET_TEMPERATURE sql.0 2018-04-05 18:15:02.917 info enabled logging of hm-rpc.0.KEQ0574459.4.ACTUAL_TEMPERATURE sql.0 2018-04-05 18:15:02.917 info enabled logging of hm-rpc.0.BidCoS-RF.50.PRESS_SHORT sql.0 2018-04-05 18:15:02.917 info enabled logging of javascript.0.Status.Stromzähler.Jahr.Produziert_Hochrechnung sql.0 2018-04-05 18:15:02.917 info enabled logging of javascript.0.Status.Stromzähler.Jahr.Eingespeist_Hochrechnung sql.0 2018-04-05 18:15:02.917 info enabled logging of javascript.0.Status.Stromzähler.Jahr.Bezogen_Hochrechnung sql.0 2018-04-05 18:15:02.917 info enabled logging of javascript.0.Status.Stromzähler.Jahr.Produziert_Stand_Jahresanfang sql.0 2018-04-05 18:15:02.917 info enabled logging of javascript.0.Status.Stromzähler.Jahr.Eingespeist_Stand_Jahresanfang sql.0 2018-04-05 18:15:02.917 info enabled logging of javascript.0.Status.Stromzähler.Jahr.Bezogen_Stand_Jahresanfang sql.0 2018-04-05 18:15:02.917 info enabled logging of javascript.0.Status.Stromzähler.Aktuell.Produziert_in_W sql.0 2018-04-05 18:15:02.917 info enabled logging of javascript.0.Status.Stromzähler.Aktuell.Eingespeist_in_W sql.0 2018-04-05 18:15:02.916 info enabled logging of javascript.0.Status.Stromzähler.Aktuell.Bezogen_in_W sql.0 2018-04-05 18:15:02.916 info enabled logging of javascript.0.Status.Stromzähler.Monat.Produziert_in_Wh sql.0 2018-04-05 18:15:02.916 info enabled logging of javascript.0.Status.Stromzähler.Monat.Eingespeist_in_Wh sql.0 2018-04-05 18:15:02.916 info enabled logging of javascript.0.Status.Stromzähler.Monat.Bezogen_in_Wh sql.0 2018-04-05 18:15:02.916 info enabled logging of javascript.0.Status.Stromzähler.Tag.Produziert_in_Wh sql.0 2018-04-05 18:15:02.916 info enabled logging of javascript.0.Status.Stromzähler.Tag.Eingespeist_in_Wh sql.0 2018-04-05 18:15:02.916 info enabled logging of javascript.0.Status.Stromzähler.Tag.Bezogen_in_Wh sql.0 2018-04-05 18:15:02.916 info enabled logging of javascript.0.Status.Stromzähler.Stunde.Produziert_in_Wh sql.0 2018-04-05 18:15:02.916 info enabled logging of javascript.0.Status.Stromzähler.Stunde.Eingespeist_in_Wh sql.0 2018-04-05 18:15:02.916 info enabled logging of javascript.0.Status.Stromzähler.Stunde.Bezogen_in_Wh sql.0 2018-04-05 18:15:02.916 info enabled logging of smartmeter.1.1-0:16_7_0*255.value sql.0 2018-04-05 18:15:02.916 info enabled logging of smartmeter.1.1-0:2_8_0*255.value sql.0 2018-04-05 18:15:02.916 info enabled logging of smartmeter.1.1-0:1_8_0*255.value sql.0 2018-04-05 18:15:02.916 info enabled logging of smartmeter.0.1-0:16_7_0*255.value sql.0 2018-04-05 18:15:02.916 info enabled logging of smartmeter.0.1-0:2_8_0*255.value sql.0 2018-04-05 18:15:02.901 info enabled logging of javascript.0.Automatik.Philipp_Fernseher sql.0 2018-04-05 18:15:02.901 info enabled logging of hm-rega.0.KEQ1090449.0.DUTY_CYCLE sql.0 2018-04-05 18:15:02.901 info enabled logging of hm-rega.0.40977 sql.0 2018-04-05 18:15:02.901 info enabled logging of hm-rega.0.40976 sql.0 2018-04-05 18:15:02.901 info enabled logging of hm-rega.0.40972 sql.0 2018-04-05 18:15:02.901 info enabled logging of hm-rega.0.40970 sql.0 2018-04-05 18:15:02.901 info enabled logging of hm-rega.0.36100 sql.0 2018-04-05 18:15:02.901 info enabled logging of hm-rega.0.33892 sql.0 2018-04-05 18:15:02.901 info enabled logging of hm-rega.0.33645 sql.0 2018-04-05 18:15:02.901 info enabled logging of hm-rega.0.33628 sql.0 2018-04-05 18:15:02.901 info enabled logging of hm-rega.0.33545 sql.0 2018-04-05 18:15:02.901 info enabled logging of javascript.0.Status.Mähroboter.Auftrag2 sql.0 2018-04-05 18:15:02.901 info enabled logging of javascript.0.Status.Mähroboter.Auftrag sql.0 2018-04-05 18:15:02.901 info enabled logging of javascript.0.Status.Mähroboter.Wlan sql.0 2018-04-05 18:15:02.901 info enabled logging of javascript.0.Status.Mähroboter.Battery sql.0 2018-04-05 18:15:02.901 info enabled logging of javascript.0.Status.Mähroboter.Mode sql.0 2018-04-05 18:15:02.901 info enabled logging of javascript.0.Status.Mähroboter.Status sql.0 2018-04-05 18:15:02.901 info enabled logging of javascript.0.Status.Maps.Tasker_LOCSPD2 sql.0 2018-04-05 18:15:02.901 info enabled logging of javascript.0.Status.Maps.Tasker_LOCALT sql.0 2018-04-05 18:15:02.901 info enabled logging of javascript.0.Status.Photovoltaik.Leistung_Strang2 sql.0 2018-04-05 18:15:02.901 info enabled logging of javascript.0.Status.Photovoltaik.Leistung_Strang1 sql.0 2018-04-05 18:15:02.901 info enabled logging of javascript.0.Status.Photovoltaik.Leistung_aktuell sql.0 2018-04-05 18:15:02.901 info enabled logging of javascript.0.Status.Zisterne.aktuell sql.0 2018-04-05 18:15:02.901 info enabled logging of javascript.0.Status.Wassertraenke.aktuell sql.0 2018-04-05 18:15:02.901 info enabled logging of javascript.0.Status.Heizoel.aktuell sql.0 2018-04-05 18:15:02.901 debug SELECT id, name FROM sources; sql.0 2018-04-05 18:15:02.885 debug SELECT id, type, name FROM datapoints; sql.0 2018-04-05 18:15:02.885 info Connected to sqlite sql.0 2018-04-05 18:15:02.885 debug Response: {"errno":1,"code":"SQLITE_ERROR"} sql.0 2018-04-05 18:15:02.885 debug CREATE TABLE ts_bool (id INTEGER, ts INTEGER, val BOOLEAN, ack BOOLEAN, _from INTEGER, q INTEGER, PRIMARY KEY(id, ts)); sql.0 2018-04-05 18:15:02.885 debug Response: {"errno":1,"code":"SQLITE_ERROR"} sql.0 2018-04-05 18:15:02.885 debug CREATE TABLE ts_string (id INTEGER, ts INTEGER, val TEXT, ack BOOLEAN, _from INTEGER, q INTEGER, PRIMARY KEY(id, ts)); sql.0 2018-04-05 18:15:02.885 debug Response: {"errno":1,"code":"SQLITE_ERROR"} sql.0 2018-04-05 18:15:02.885 debug CREATE TABLE ts_number (id INTEGER, ts INTEGER, val REAL, ack BOOLEAN, _from INTEGER, q INTEGER, PRIMARY KEY(id, ts)); sql.0 2018-04-05 18:15:02.885 debug Response: {"errno":1,"code":"SQLITE_ERROR"} sql.0 2018-04-05 18:15:02.885 debug CREATE TABLE datapoints (id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, name TEXT, type INTEGER); sql.0 2018-04-05 18:15:02.885 debug Response: {"errno":1,"code":"SQLITE_ERROR"} sql.0 2018-04-05 18:15:02.869 debug CREATE TABLE sources (id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, name TEXT); sql.0 2018-04-05 18:15:02.869 info starting. Version 1.7.3 in C:/ioBroker/node_modules/iobroker.sql, node: v6.9.0 sql.0 2018-04-05 18:15:02.838 debug statesDB connected sql.0 2018-04-05 18:15:02.823 debug objectDB connectedmfg
-
Habe 1.7.4. installiert.
Danach
iobroker stop
iobroker start
und die flots werden in vis sofort angezeigt.
So ist es super!
Fazit:
Fehler im log sind weg.
Und die Anzeige in vis kommt sofort.
Danke dir.
mfg
Dieter
Hey! Du scheinst an dieser Unterhaltung interessiert zu sein, hast aber noch kein Konto.
Hast du es satt, bei jedem Besuch durch die gleichen Beiträge zu scrollen? Wenn du dich für ein Konto anmeldest, kommst du immer genau dorthin zurück, wo du zuvor warst, und kannst dich über neue Antworten benachrichtigen lassen (entweder per E-Mail oder Push-Benachrichtigung). Du kannst auch Lesezeichen speichern und Beiträge positiv bewerten, um anderen Community-Mitgliedern deine Wertschätzung zu zeigen.
Mit deinem Input könnte dieser Beitrag noch besser werden 💗
Registrieren Anmelden523
Online32.8k
Benutzer82.7k
Themen1.3m
Beiträge