Navigation

    Logo
    • Register
    • Login
    • Search
    • Recent
    • Tags
    • Unread
    • Categories
    • Unreplied
    • Popular
    • GitHub
    • Docu
    • Hilfe
    1. Home
    2. Deutsch
    3. Tester
    4. [Aufruf] Dringender Test sql 1.6.4

    NEWS

    • ioBroker 10-Jahres Community Treffen - ein kleiner ReCap

    • Tester für Responsive Initiative gesucht

    • 50€: Mach mit bei einer Smarthome Studie mit ioBroker!

    [Aufruf] Dringender Test sql 1.6.4

    This topic has been deleted. Only users with topic management privileges can see it.
    • sissiwup
      sissiwup last edited by

      Hallo,

      ist ein String-Feld.

      Ist halt blöd für die Anzeige in vis, da hier die NULL-Werte angezeigt werden.

      1 Reply Last reply Reply Quote 0
      • apollon77
        apollon77 last edited by

        Kannst du null Werte nicht ignorieren?

        Ansonsten ist die Frage (mal wieder) ob man zum Backup wirklich iobroker beenden muss. Ich tue das nicht 😉

        1 Reply Last reply Reply Quote 0
        • BBTown
          BBTown last edited by

          @apollon77:

          Ansonsten ist die Frage (mal wieder) ob man zum Backup wirklich iobroker beenden muss. Ich tue das nicht 😉 ` Ich auch nicht 8-)

          Ich lasse Nachts um 04:00h ein Image der SD-Karte auf mein NAS schreiben und im Falle eines Problems habe ich innerhalb von 20 Minuten (so lange dauert es ein 16GB Image auf die SD-Karte zu schreiben) ein funktionierendes Image auf eine SD zurückgespielt. Dafür liegt immer eine Ersatz-SD Karte im Schrank.

          1 Reply Last reply Reply Quote 0
          • apollon77
            apollon77 last edited by

            Man besten vorher iobroker Backup ausführen. Dann hast du beides.

            Ich hab ein inkrementelles Backup und rsynce noch das iobroker Verzeichnis auf nen zweiten Rechner.

            Am Ende ändert sich nur objects.json und ggf states.json Rest ist recht statisch wenn man nichts ändert.

            1 Reply Last reply Reply Quote 0
            • sissiwup
              sissiwup last edited by

              @apollon77:

              Kannst du null Werte nicht ignorieren?

              Ansonsten ist die Frage (mal wieder) ob man zum Backup wirklich iobroker beenden muss. Ich tue das nicht 😉 `

              Hallo,

              wofür sollen die null-Werte gut sein?

              Es ist das Standard-Element von VIS, da kann man leider nichts einstellen.

              Oder übersehe ich da etwas?

              <u>Offtopic:</u>

              Das mit den Neustarten muss vlt. nicht mehr sein. Starte aber alles um 4:00 neu.

              Aktuell ist das auch gut so, wenn ich sehe wie oft sich irgendein Adapter wegängt

              und aufeinmal keine Werte mehr liefert. Habe aktuell z.B. Probleme mit dem REGA-Adapter,

              da kommen halt manchmal manche Ereignisse nicht an.

              Der andere Adapter läuft aber in der Zeit tadellos (also kein Netzwerk oder ähnliches).

              Außerdem halten sich ausfälle so sehr begrenzt, wenn ich mal ein paar Tage weg bin.

              1 Reply Last reply Reply Quote 0
              • sissiwup
                sissiwup last edited by

                @BBTown:

                @sissiwup:

                Auswirkungen: Es werden wieder ein paar Null Werte in die Tabelle geschrieben.

                Das passiert nur beim Neustart des ioBrokers (Mache ich jede Nacht um 4:00 zur Datensicherung)

                Danach ist alles wieder stabil. War vorher nicht so, da hat er wenigstens keine "NULL" Werte geschrieben. ` Das ist kein "Problem" sondern das normale Verhalten nach einem Neustart des Adapters.

                apollon77 hat das etwas weiter oben beschrieben/erläutert

                [EDIT]Wie ich sehe war apollon77 mit seiner Antwort schneller 8-) `

                Auch das mit der Fehlermeldung?

                sql.0	2018-02-04 04:11:32.471	error	Cannot insert INSERT INTO `iobroker`.ts_number (id, ts, val, ack, _from, q) VALUES(1550, 1517713892257, , 0, 0, 0);: Error: ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that
sql.0	2018-02-04 04:11:32.347	error	Cannot insert INSERT INTO `iobroker`.ts_number (id, ts, val, ack, _from, q) VALUES(1549, 1517713892256, , 1, 6, 0);: Error: ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that
                1 Reply Last reply Reply Quote 0
                • apollon77
                  apollon77 last edited by

                  Die Fehlermeldung natürlich nicht. Siehe meine Fragen dazu weiter oben. Irgendwie kommt in einem zahlenfeld ein leerer Wert rein. Wann passiert es? Beim restart bzw indem Fall danach scheinbar. Kannst du es mit einem iobroker stop/Start reproduzieren? Wenn ja bitte mal sql auf Debug stellen und iobroker neu starten. Das log sollte zeigen was genau passiert.

                  Zu vis history: mach im GitHub mal ein issue auf, vllt kann man eine „ignoriere null“ Einstellung hinzufügen …

                  1 Reply Last reply Reply Quote 0
                  • sissiwup
                    sissiwup last edited by

                    @apollon77:

                    Also sissiwup,

                    ich hab auf Github mal eine Kleinigkeit geändert.

                    Wenn die "eigentlich richtigen typen" denen der ioBroker-Objekte entsprechen (was meistens der Fall sein sollte) dann kann man jetzt in der "datapoints"-tabelle die "type"-SPalte auf NULL setzen und beim nächsten Start bzw beim ersten Loggen von Daten sollte der korrekte Typ aktualisiert werden.

                    Am besten erstmal mit 1-2 Datenpunkten versuchen bevor du alle Typen killst 🙂

                    Ist das vllt ein "Fix" ?! `

                    Klappt nicht:

                    sql.0	2018-02-04 18:03:37.659	error	Cannot insert INSERT INTO `iobroker`.undefined (id, ts, val, ack, _from, q) VALUES(1563, 1517763807597, , 1, 6, 0);: Error: ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that
sql.0	2018-02-04 18:03:28.966	error	Error: ER_NO_SUCH_TABLE: Table 'iobroker.undefined' doesn't exist
fritzbox.0	2018-02-04 18:03:27.558	info	data from 192.168.1.100: 04.02.18 18:03:27;DISCONNECT;1;0;
sql.0	2018-02-04 18:03:23.970	error	Cannot insert INSERT INTO `iobroker`.undefined (id, ts, val, ack, _from, q) VALUES(1563, 1517763803920, 057239588336, 1, 6, 0);: Error: ER_NO_SUCH_TABLE: Table 'iobroker.undefined' doesn't exist
fritzbox.0	2018-02-04 18:03:23.823	info	data from 192.168.1.100: 04.02.18 18:03:23;DISCONNECT;2;0;
fritzbox.0	2018-02-04 18:03:23.812	info	data from 192.168.1.100: 04.02.18 18:03:23;RING;2;057239588336;9588336;SIP1;
fritzbox.0	2018-02-04 18:03:23.351	info	data from 192.168.1.100: 04.02.18 18:03:23;CALL;1;12;9588336;9588336;SIP1;
sql.0	2018-02-04 18:02:46.360	error	Error: ER_NO_SUCH_TABLE: Table 'iobroker.undefined' doesn't exist
sql.0	2018-02-04 18:01:50.086	error	Cannot delete DELETE FROM `iobroker`.undefined WHERE id=1550 AND ts < 1454691660768;: Error: ER_NO_SUCH_TABLE: Table 'iobroker.undefined' doesn't exist
sql.0	2018-02-04 18:01:50.033	error	Cannot delete DELETE FROM `iobroker`.undefined WHERE id=1563 AND ts < 1454691660662;: Error: ER_NO_SUCH_TABLE: Table 'iobroker.undefined' doesn't exist
sql.0	2018-02-04 18:01:49.767	error	Cannot insert INSERT INTO `iobroker`.undefined (id, ts, val, ack, _from, q) VALUES(1550, 1517763694492, NULL, 1, 15, 64);: Error: ER_NO_SUCH_TABLE: Table 'iobroker.undefined' doesn't exist
sql.0	2018-02-04 18:01:49.661	error	Cannot insert INSERT INTO `iobroker`.undefined (id, ts, val, ack, _from, q) VALUES(1563, 1517763694492, NULL, 1, 15, 64);: Error: ER_NO_SUCH_TABLE: Table 'iobroker.undefined' doesn't exist
sql.0	2018-02-04 18:01:47.199	error	Cannot delete DELETE FROM `iobroker`.undefined WHERE id=1549 AND ts < 1454691660227;: Error: ER_NO_SUCH_TABLE: Table 'iobroker.undefined' doesn't exist
sql.0	2018-02-04 18:01:44.171	error	Cannot insert INSERT INTO `iobroker`.undefined (id, ts, val, ack, _from, q) VALUES(1549, 1517763694492, NULL, 1, 15, 64);: Error: ER_NO_SUCH_TABLE: Table 'iobroker.undefined' doesn't exist
host.zotac	2018-02-04 18:01:32.233	info	instance system.adapter.sql.0 started with pid 26685
host.zotac	2018-02-04 18:01:30.681	info	instance system.adapter.sql.0 terminated with code 0 (OK)
Caught	2018-02-04 18:01:30.680	error	by controller[3]: 2018-02-04 18:01:30.562 - sql.0 Cannot delete DELETE FROM `iobroker`.undefined WHERE id=1549 AND ts < 1454691660553;: Error: ER_NO_SUCH_TABLE: Table 'iobroker.undefined' doesn't e
Caught	2018-02-04 18:01:30.680	error	by controller[2]: 2018-02-04 18:01:30.550 - sql.0 Cannot insert INSERT INTO `iobroker`.undefined (id, ts, val, ack, _from, q) VALUES(1549, 1517763687678, NULL, 0, 15, 64);: Error: ER_NO_SUCH_TABLE:
Caught	2018-02-04 18:01:30.679	error	by controller[1]: 2018-02-04 18:01:29.833 - sql.0 Cannot insert INSERT INTO `iobroker`.undefined (id, ts, val, ack, _from, q) VALUES(1550, 1517763687678, NULL, 0, 15, 64);: Error: ER_NO_SUCH_TABLE:
sql.0	2018-02-04 18:01:30.562	error	Cannot delete DELETE FROM `iobroker`.undefined WHERE id=1549 AND ts < 1454691660553;: Error: ER_NO_SUCH_TABLE: Table 'iobroker.undefined' doesn't exist
sql.0	2018-02-04 18:01:30.550	error	Cannot insert INSERT INTO `iobroker`.undefined (id, ts, val, ack, _from, q) VALUES(1549, 1517763687678, NULL, 0, 15, 64);: Error: ER_NO_SUCH_TABLE: Table 'iobroker.undefined' doesn't exist
sql.0	2018-02-04 18:01:29.821	error	Cannot insert INSERT INTO `iobroker`.undefined (id, ts, val, ack, _from, q) VALUES(1550, 1517763687678, NULL, 0, 15, 64);: Error: ER_NO_SUCH_TABLE: Table 'iobroker.undefined' doesn't exist

                    SQL fom GITHUB geladen

                    Datenpunkt 1563 auf NULL geändert.

                    SQL neu gestartet.

                    Datenpunkt geändert (steht auf automatisch).

                    Gleiche für 1550 und 1549

                    1 Reply Last reply Reply Quote 0
                    • sissiwup
                      sissiwup last edited by

                      Verhindern der NULL-Werte:

                      CREATE DEFINER=`root`@`localhost` 
TRIGGER `DEL_NULL` 
BEFORE INSERT ON `ts_string` 
FOR EACH ROW 
   if NEW.q = 64 then 
      set NEW.ts = NULL; 
   end if

                      Das erzeugt zwar im log böse Fehlermeldungen, dafür ist die Historie sauber.

                      1 Reply Last reply Reply Quote 0
                      • sissiwup
                        sissiwup last edited by

                        @apollon77:

                        Zu vis history: mach im GitHub mal ein issue auf, vllt kann man eine „ignoriere null“ Einstellung hinzufügen … `

                        => https://github.com/ioBroker/ioBroker.vis/issues/162

                        sissiwup created this issue in ioBroker/ioBroker.vis

                        closed vis History #162

                        1 Reply Last reply Reply Quote 0
                        • apollon77
                          apollon77 last edited by

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

                          1 Reply Last reply Reply Quote 0
                          • sissiwup
                            sissiwup last edited by

                            @apollon77:

                            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"
                            1 Reply Last reply Reply Quote 0
                            • sissiwup
                              sissiwup last edited by

                              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.

                              1 Reply Last reply Reply Quote 0
                              • BBTown
                                BBTown last edited by

                                packe zu allererst bitte den code in "spoiler"

                                1 Reply Last reply Reply Quote 0
                                • apollon77
                                  apollon77 last edited by

                                  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?

                                  1 Reply Last reply Reply Quote 0
                                  • sissiwup
                                    sissiwup last edited by

                                    @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
}
                                    1 Reply Last reply Reply Quote 0
                                    • apollon77
                                      apollon77 last edited by

                                      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.

                                      1 Reply Last reply Reply Quote 0
                                      • ruhr70
                                        ruhr70 last edited by

                                        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.

                                        1 Reply Last reply Reply Quote 0
                                        • apollon77
                                          apollon77 last edited by

                                          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 🙂

                                          1 Reply Last reply Reply Quote 0
                                          • sissiwup
                                            sissiwup last edited by

                                            @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).

                                            1 Reply Last reply Reply Quote 0
                                            • First post
                                              Last post

                                            Support us

                                            ioBroker
                                            Community Adapters
                                            Donate

                                            869
                                            Online

                                            30.4k
                                            Users

                                            76.8k
                                            Topics

                                            1.2m
                                            Posts

                                            15
                                            203
                                            16011
                                            Loading More Posts
                                            • Oldest to Newest
                                            • Newest to Oldest
                                            • Most Votes
                                            Reply
                                            • Reply as topic
                                            Log in to reply
                                            Community
                                            Impressum | Datenschutz-Bestimmungen | Nutzungsbedingungen
                                            The ioBroker Community 2014-2023
                                            logo