Navigation

    Logo
    • Register
    • Login
    • Search
    • Recent
    • Tags
    • Unread
    • Categories
    • Unreplied
    • Popular
    • GitHub
    • Docu
    • Hilfe
    1. Home
    2. Deutsch
    3. ioBroker Allgemein
    4. [gelöst] SQL History - Nur manuelle Aktualisierung protokollieren

    NEWS

    • Neues Video "KI im Smart Home" - ioBroker plus n8n

    • Neues Video über Aliase, virtuelle Geräte und Kategorien

    • Wir empfehlen: Node.js 22.x

    [gelöst] SQL History - Nur manuelle Aktualisierung protokollieren

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

      @apollon77:

      Was sind denn das für Werte die da geschrieben werden ? Die sql Instanz sollte maximal Werte speichern wenn sie sich nicht geändert haben. Bitte mal aktuellste 1.8.0 vom github versuchen ob es da gefixt ist.

      Wenn nicht dann bitte logging auf Debug setzen und log senden. `
      Es sind Logicals. Habe die Instanz aktualisiert und werde morgen wieder berichten. Sind die Einstellungen erstmal korrekt?

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

        Mit den Einstellungen sollten ausschließlich die Werte geloggt werden die sich tatsächlich gesetzt werden.

        1 Reply Last reply Reply Quote 0
        • S
          schittl last edited by

          Ich habe den Adapter gerade mal neugestartet und es werden ebenfalls Daten geloggt: 3116_sql2.jpg

          Den Adapter habe ich auf debug gestellt und hier ein Auszug aus dem Log:

          ! ````
          sql.0 2018-05-03 09:17:48.785 debug INSERT INTO ioBroker.ts_number (id, ts, val, ack, _from, q) VALUES(95, 1525331867751, 18.49, 1, 15, 0);
          sql.0 2018-05-03 09:17:48.784 debug Datatype system.adapter.hm-rpc.1.memHeapUsed: Currently: number, StorageType: Number
          sql.0 2018-05-03 09:17:48.564 debug INSERT INTO ioBroker.ts_number (id, ts, val, ack, _from, q) VALUES(90, 1525331867542, 22.94, 1, 8, 0);
          sql.0 2018-05-03 09:17:48.562 debug Datatype system.adapter.rpi2.0.memHeapUsed: Currently: number, StorageType: Number
          sql.0 2018-05-03 09:17:48.408 debug Min-Delta reached system.adapter.hm-rega.0.memHeapUsed, last-value=18.11, new-value=18.15, ts=1525331868383
          sql.0 2018-05-03 09:17:48.407 debug new value received for system.adapter.hm-rega.0.memHeapUsed, new-value=18.15, ts=1525331868383, relog=false
          sql.0 2018-05-03 09:17:48.278 debug Min-Delta reached system.adapter.yahka.0.memHeapUsed, last-value=15.39, new-value=15.55, ts=1525331868260
          sql.0 2018-05-03 09:17:48.277 debug new value received for system.adapter.yahka.0.memHeapUsed, new-value=15.55, ts=1525331868260, relog=false
          sql.0 2018-05-03 09:17:47.773 debug Min-Delta reached system.adapter.hm-rpc.1.memHeapUsed, last-value=18.46, new-value=18.49, ts=1525331867751
          sql.0 2018-05-03 09:17:47.772 debug new value received for system.adapter.hm-rpc.1.memHeapUsed, new-value=18.49, ts=1525331867751, relog=false
          sql.0 2018-05-03 09:17:47.561 debug Min-Delta reached system.adapter.rpi2.0.memHeapUsed, last-value=22.88, new-value=22.94, ts=1525331867542
          sql.0 2018-05-03 09:17:47.560 debug new value received for system.adapter.rpi2.0.memHeapUsed, new-value=22.94, ts=1525331867542, relog=false
          sql.0 2018-05-03 09:17:44.806 debug INSERT INTO ioBroker.ts_number (id, ts, val, ack, _from, q) VALUES(47, 1525331863796, 20.63, 0, 5, 0);
          sql.0 2018-05-03 09:17:44.805 debug Datatype javascript.0.AquaGuard.Vorratstank.19.ACTUAL_TEMPERTURE: Currently: number, StorageType: Number
          sql.0 2018-05-03 09:17:44.800 debug INSERT INTO ioBroker.ts_number (id, ts, val, ack, _from, q) VALUES(97, 1525331863779, 10.65, 1, 3, 0);
          sql.0 2018-05-03 09:17:44.799 debug Datatype system.adapter.hm-rpc.0.memHeapUsed: Currently: number, StorageType: Number
          sql.0 2018-05-03 09:17:44.773 debug INSERT INTO ioBroker.ts_number (id, ts, val, ack, _from, q) VALUES(84, 1525331863753, 27.15, 1, 10, 0);
          sql.0 2018-05-03 09:17:44.771 debug Datatype system.adapter.telegram.0.memHeapUsed: Currently: number, StorageType: Number
          sql.0 2018-05-03 09:17:44.748 debug INSERT INTO ioBroker.ts_number (id, ts, val, ack, _from, q) VALUES(93, 1525331863729, 12.73, 1, 14, 0);
          sql.0 2018-05-03 09:17:44.747 debug Datatype system.adapter.g-homa.0.memHeapUsed: Currently: number, StorageType: Number
          sql.0 2018-05-03 09:17:44.015 debug value not changed hm-rpc.0.NEQ1515796.4.SET_TEMPERATURE, last-value=17, new-value=17, ts=1525331863972
          sql.0 2018-05-03 09:17:44.013 debug new value received for hm-rpc.0.NEQ1515796.4.SET_TEMPERATURE, new-value=17, ts=1525331863972, relog=false
          sql.0 2018-05-03 09:17:44.012 debug value not changed hm-rpc.0.NEQ1515796.4.ACTUAL_TEMPERATURE, last-value=23.4, new-value=23.4, ts=1525331863969
          sql.0 2018-05-03 09:17:44.011 debug new value received for hm-rpc.0.NEQ1515796.4.ACTUAL_TEMPERATURE, new-value=23.4, ts=1525331863969, relog=false
          sql.0 2018-05-03 09:17:43.970 debug value not changed hm-rpc.0.NEQ1515796.4.VALVE_STATE, last-value=0, new-value=0, ts=1525331863964
          sql.0 2018-05-03 09:17:43.970 debug new value received for hm-rpc.0.NEQ1515796.4.VALVE_STATE, new-value=0, ts=1525331863964, relog=false
          sql.0 2018-05-03 09:17:43.803 debug Min-Delta reached javascript.0.AquaGuard.Vorratstank.19.ACTUAL_TEMPERTURE, last-value=20.56, new-value=20.63, ts=1525331863796
          sql.0 2018-05-03 09:17:43.803 debug new value received for javascript.0.AquaGuard.Vorratstank.19.ACTUAL_TEMPERTURE, new-value=20.63, ts=1525331863796, relog=false
          sql.0 2018-05-03 09:17:43.797 debug Min-Delta reached system.adapter.hm-rpc.0.memHeapUsed, last-value=11.05, new-value=10.65, ts=1525331863779
          sql.0 2018-05-03 09:17:43.796 debug new value received for system.adapter.hm-rpc.0.memHeapUsed, new-value=10.65, ts=1525331863779, relog=false
          sql.0 2018-05-03 09:17:43.770 debug Min-Delta reached system.adapter.telegram.0.memHeapUsed, last-value=27.01, new-value=27.15, ts=1525331863753
          sql.0 2018-05-03 09:17:43.769 debug new value received for system.adapter.telegram.0.memHeapUsed, new-value=27.15, ts=1525331863753, relog=false
          sql.0 2018-05-03 09:17:43.744 debug Min-Delta reached system.adapter.g-homa.0.memHeapUsed, last-value=12.69, new-value=12.73, ts=1525331863729
          sql.0 2018-05-03 09:17:43.743 debug new value received for system.adapter.g-homa.0.memHeapUsed, new-value=12.73, ts=1525331863729, relog=false
          sql.0 2018-05-03 09:17:41.077 debug value not changed javascript.0.AquaGuard.Aqua.15.ACTUAL_TEMPERTURE, last-value=24.81, new-value=24.81, ts=1525331861070
          sql.0 2018-05-03 09:17:41.076 debug new value received for javascript.0.AquaGuard.Aqua.15.ACTUAL_TEMPERTURE, new-value=24.81, ts=1525331861070, relog=false
          sql.0 2018-05-03 09:17:40.312 debug INSERT INTO ioBroker.ts_number (id, ts, val, ack, _from, q) VALUES(86, 1525331859286, 35.87, 1, 6, 0);
          sql.0 2018-05-03 09:17:40.310 debug Datatype system.adapter.admin.0.memHeapUsed: Currently: number, StorageType: Number
          sql.0 2018-05-03 09:17:39.994 debug INSERT INTO ioBroker.ts_number (id, ts, val, ack, _from, q) VALUES(89, 1525331858973, 105.47, 1, 13, 0);
          sql.0 2018-05-03 09:17:39.993 debug Datatype system.adapter.cloud.0.memHeapUsed: Currently: number, StorageType: Number
          sql.0 2018-05-03 09:17:39.972 debug INSERT INTO ioBroker.ts_number (id, ts, val, ack, _from, q) VALUES(91, 1525331858947, 19.66, 1, 5, 0);
          sql.0 2018-05-03 09:17:39.971 debug Datatype system.adapter.web.0.memHeapUsed: Currently: number, StorageType: Number
          sql.0 2018-05-03 09:17:39.920 debug INSERT INTO ioBroker.ts_number (id, ts, val, ack, _from, q) VALUES(96, 1525331858882, 29, 1, 16, 0);
          sql.0 2018-05-03 09:17:39.918 debug Datatype system.adapter.sql.0.memHeapUsed: Currently: number, StorageType: Number
          sql.0 2018-05-03 09:17:39.765 debug INSERT INTO ioBroker.ts_number (id, ts, val, ack, _from, q) VALUES(101, 1525331858734, 87, 1, 17, 0);
          sql.0 2018-05-03 09:17:39.764 debug Datatype system.host.rock64.freemem: Currently: number, StorageType: Number
          sql.0 2018-05-03 09:17:39.759 debug INSERT INTO ioBroker.ts_number (id, ts, val, ack, _from, q) VALUES(98, 1525331858732, 89.29, 1, 17, 0);
          sql.0 2018-05-03 09:17:39.758 debug Datatype system.host.rock64.memHeapUsed: Currently: number, StorageType: Number
          sql.0 2018-05-03 09:17:39.751 debug INSERT INTO ioBroker.ts_number (id, ts, val, ack, _from, q) VALUES(102, 1525331858727, 0.13, 1, 17, 0);
          sql.0 2018-05-03 09:17:39.750 debug Datatype system.host.rock64.load: Currently: number, StorageType: Number
          sql.0 2018-05-03 09:17:39.309 debug Min-Delta reached system.adapter.admin.0.memHeapUsed, last-value=35.99, new-value=35.87, ts=1525331859286
          sql.0 2018-05-03 09:17:39.309 debug new value received for system.adapter.admin.0.memHeapUsed, new-value=35.87, ts=1525331859286, relog=false
          sql.0 2018-05-03 09:17:39.210 debug INSERT INTO ioBroker.ts_number (id, ts, val, ack, _from, q) VALUES(88, 1525331858181, 12.67, 1, 12, 0);
          sql.0 2018-05-03 09:17:39.209 debug Datatype system.adapter.hue.0.memHeapUsed: Currently: number, StorageType: Number
          sql.0 2018-05-03 09:17:39.194 debug value not changed javascript.0.AquaGuard.Aqua.14.ACTUAL_TEMPERTURE, last-value=22.88, new-value=22.88, ts=1525331859182
          sql.0 2018-05-03 09:17:39.193 debug new value received for javascript.0.AquaGuard.Aqua.14.ACTUAL_TEMPERTURE, new-value=22.88, ts=1525331859182, relog=false
          sql.0 2018-05-03 09:17:38.992 debug Min-Delta reached system.adapter.cloud.0.memHeapUsed, last-value=105.41, new-value=105.47, ts=1525331858973
          sql.0 2018-05-03 09:17:38.991 debug new value received for system.adapter.cloud.0.memHeapUsed, new-value=105.47, ts=1525331858973, relog=false
          sql.0 2018-05-03 09:17:38.970 debug Min-Delta reached system.adapter.web.0.memHeapUsed, last-value=19.47, new-value=19.66, ts=1525331858947
          sql.0 2018-05-03 09:17:38.970 debug new value received for system.adapter.web.0.memHeapUsed, new-value=19.66, ts=1525331858947, relog=false
          sql.0 2018-05-03 09:17:38.917 debug Min-Delta reached system.adapter.sql.0.memHeapUsed, last-value=28.82, new-value=29, ts=1525331858882
          sql.0 2018-05-03 09:17:38.915 debug new value received for system.adapter.sql.0.memHeapUsed, new-value=29, ts=1525331858882, relog=false
          sql.0 2018-05-03 09:17:38.761 debug Min-Delta reached system.host.rock64.freemem, last-value=92, new-value=87, ts=1525331858734
          sql.0 2018-05-03 09:17:38.758 debug new value received for system.host.rock64.freemem, new-value=87, ts=1525331858734, relog=false
          sql.0 2018-05-03 09:17:38.757 debug Min-Delta reached system.host.rock64.memHeapUsed, last-value=81.82, new-value=89.29, ts=1525331858732
          sql.0 2018-05-03 09:17:38.757 debug new value received for system.host.rock64.memHeapUsed, new-value=89.29, ts=1525331858732, relog=false
          sql.0 2018-05-03 09:17:38.749 debug Min-Delta reached system.host.rock64.load, last-value=0.17, new-value=0.13, ts=1525331858727
          sql.0 2018-05-03 09:17:38.748 debug new value received for system.host.rock64.load, new-value=0.13, ts=1525331858727, relog=false
          sql.0 2018-05-03 09:17:38.208 debug Min-Delta reached system.adapter.hue.0.memHeapUsed, last-value=12.75, new-value=12.67, ts=1525331858181
          sql.0 2018-05-03 09:17:38.207 debug new value received for system.adapter.hue.0.memHeapUsed, new-value=12.67, ts=1525331858181, relog=false
          sql.0 2018-05-03 09:17:38.099 debug INSERT INTO ioBroker.ts_number (id, ts, val, ack, _from, q) VALUES(87, 1525331857077, 68.36, 1, 1, 0);
          sql.0 2018-05-03 09:17:38.098 debug Datatype system.adapter.javascript.0.memHeapUsed: Currently: number, StorageType: Number
          sql.0 2018-05-03 09:17:37.264 debug value not changed javascript.0.AquaGuard.Aqua.13.ACTUAL_TEMPERTURE, last-value=23.06, new-value=23.06, ts=1525331857251
          sql.0 2018-05-03 09:17:37.263 debug new value received for javascript.0.AquaGuard.Aqua.13.ACTUAL_TEMPERTURE, new-value=23.06, ts=1525331857251, relog=false
          sql.0 2018-05-03 09:17:37.096 debug Min-Delta reached system.adapter.javascript.0.memHeapUsed, last-value=67.8, new-value=68.36, ts=1525331857077
          sql.0 2018-05-03 09:17:37.095 debug new value received for system.adapter.javascript.0.memHeapUsed, new-value=68.36, ts=1525331857077, relog=false
          sql.0 2018-05-03 09:17:36.727 debug INSERT INTO ioBroker.ts_number (id, ts, val, ack, _from, q) VALUES(85, 1525331855703, 22.33, 1, 11, 0);
          sql.0 2018-05-03 09:17:36.724 debug Datatype system.adapter.broadlink2.0.memHeapUsed: Currently: number, StorageType: Number
          sql.0 2018-05-03 09:17:35.722 debug Min-Delta reached system.adapter.broadlink2.0.memHeapUsed, last-value=22.27, new-value=22.33, ts=1525331855703
          sql.0 2018-05-03 09:17:35.721 debug new value received for system.adapter.broadlink2.0.memHeapUsed, new-value=22.33, ts=1525331855703, relog=false
          sql.0 2018-05-03 09:17:34.388 debug INSERT INTO ioBroker.ts_number (id, ts, val, ack, _from, q) VALUES(94, 1525331853366, 18.11, 1, 4, 0);
          sql.0 2018-05-03 09:17:34.386 debug Datatype system.adapter.hm-rega.0.memHeapUsed: Currently: number, StorageType: Number
          sql.0 2018-05-03 09:17:34.211 debug INSERT INTO ioBroker.ts_number (id, ts, val, ack, _from, q) VALUES(92, 1525331853194, 15.39, 1, 7, 0);
          sql.0 2018-05-03 09:17:34.210 debug Datatype system.adapter.yahka.0.memHeapUsed: Currently: number, StorageType: Number
          sql.0 2018-05-03 09:17:33.773 debug INSERT INTO ioBroker.ts_number (id, ts, val, ack, _from, q) VALUES(95, 1525331852733, 18.46, 1, 15, 0);
          sql.0 2018-05-03 09:17:33.772 debug Datatype system.adapter.hm-rpc.1.memHeapUsed: Currently: number, StorageType: Number
          sql.0 2018-05-03 09:17:33.559 debug INSERT INTO ioBroker.ts_number (id, ts, val, ack, _from, q) VALUES(90, 1525331852536, 22.88, 1, 8, 0);
          sql.0 2018-05-03 09:17:33.556 debug Datatype system.adapter.rpi2.0.memHeapUsed: Currently: number, StorageType: Number
          sql.0 2018-05-03 09:17:33.383 debug Min-Delta reached system.adapter.hm-rega.0.memHeapUsed, last-value=17.83, new-value=18.11, ts=1525331853366
          sql.0 2018-05-03 09:17:33.382 debug new value received for system.adapter.hm-rega.0.memHeapUsed, new-value=18.11, ts=1525331853366, relog=false
          sql.0 2018-05-03 09:17:33.208 debug Min-Delta reached system.adapter.yahka.0.memHeapUsed, last-value=15.12, new-value=15.39, ts=1525331853194
          sql.0 2018-05-03 09:17:33.207 debug new value received for system.adapter.yahka.0.memHeapUsed, new-value=15.39, ts=1525331853194, relog=false
          sql.0 2018-05-03 09:17:32.750 debug Min-Delta reached system.adapter.hm-rpc.1.memHeapUsed, last-value=18.18, new-value=18.46, ts=1525331852733
          sql.0 2018-05-03 09:17:32.750 debug new value received for system.adapter.hm-rpc.1.memHeapUsed, new-value=18.46, ts=1525331852733, relog=false
          sql.0 2018-05-03 09:17:32.555 debug Min-Delta reached system.adapter.rpi2.0.memHeapUsed, last-value=22.83, new-value=22.88, ts=1525331852536
          sql.0 2018-05-03 09:17:32.554 debug new value received for system.adapter.rpi2.0.memHeapUsed, new-value=22.88, ts=1525331852536, relog=false
          sql.0 2018-05-03 09:17:29.723 debug INSERT INTO ioBroker.ts_number (id, ts, val, ack, _from, q) VALUES(97, 1525331848716, 11.05, 1, 3, 0);
          sql.0 2018-05-03 09:17:29.722 debug Datatype system.adapter.hm-rpc.0.memHeapUsed: Currently: number, StorageType: Number
          sql.0 2018-05-03 09:17:29.711 debug INSERT INTO ioBroker.ts_number (id, ts, val, ack, _from, q) VALUES(84, 1525331848673, 27.01, 1, 10, 0);
          sql.0 2018-05-03 09:17:29.710 debug Datatype system.adapter.telegram.0.memHeapUsed: Currently: number, StorageType: Number
          sql.0 2018-05-03 09:17:29.705 debug INSERT INTO ioBroker.ts_number (id, ts, val, ack, _from, q) VALUES(93, 1525331848644, 12.69, 1, 14, 0);
          sql.0 2018-05-03 09:17:29.704 debug Datatype system.adapter.g-homa.0.memHeapUsed: Currently: number, StorageType: Number
          sql.0 2018-05-03 09:17:28.722 debug Min-Delta reached system.adapter.hm-rpc.0.memHeapUsed, last-value=11.76, new-value=11.05, ts=1525331848716
          sql.0 2018-05-03 09:17:28.721 debug new value received for system.adapter.hm-rpc.0.memHeapUsed, new-value=11.05, ts=1525331848716, relog=false
          sql.0 2018-05-03 09:17:28.705 debug Min-Delta reached system.adapter.telegram.0.memHeapUsed, last-value=27.2, new-value=27.01, ts=1525331848673
          sql.0 2018-05-03 09:17:28.704 debug new value received for system.adapter.telegram.0.memHeapUsed, new-value=27.01, ts=1525331848673, relog=false
          sql.0 2018-05-03 09:17:28.703 debug Min-Delta reached system.adapter.g-homa.0.memHeapUsed, last-value=12.63, new-value=12.69, ts=1525331848644
          sql.0 2018-05-03 09:17:28.702 debug new value received for system.adapter.g-homa.0.memHeapUsed, new-value=12.69, ts=1525331848644, relog=false
          sql.0 2018-05-03 09:17:28.684 debug INSERT INTO ioBroker.ts_number (id, ts, val, ack, _from, q) VALUES(49, 1525331847665, 17, 1, 4, 0);
          sql.0 2018-05-03 09:17:28.683 debug Datatype hm-rega.0.OEQ0605968.0.DUTY_CYCLE: Currently: number, StorageType: Number
          sql.0 2018-05-03 09:17:27.676 debug Min-Delta reached hm-rega.0.OEQ0605968.0.DUTY_CYCLE, last-value=16, new-value=17, ts=1525331847665
          sql.0 2018-05-03 09:17:27.675 debug new value received for hm-rega.0.OEQ0605968.0.DUTY_CYCLE, new-value=17, ts=1525331847665, relog=false
          sql.0 2018-05-03 09:17:25.304 debug INSERT INTO ioBroker.ts_number (id, ts, val, ack, _from, q) VALUES(86, 1525331844285, 35.99, 1, 6, 0);
          sql.0 2018-05-03 09:17:25.303 debug Datatype system.adapter.admin.0.memHeapUsed: Currently: number, StorageType: Number
          sql.0 2018-05-03 09:17:24.999 debug INSERT INTO ioBroker.ts_number (id, ts, val, ack, _from, q) VALUES(89, 1525331843969, 105.41, 1, 13, 0);
          sql.0 2018-05-03 09:17:24.998 debug Datatype system.adapter.cloud.0.memHeapUsed: Currently: number, StorageType: Number
          sql.0 2018-05-03 09:17:24.983 debug INSERT INTO ioBroker.ts_number (id, ts, val, ack, _from, q) VALUES(91, 1525331843944, 19.47, 1, 5, 0);
          sql.0 2018-05-03 09:17:24.981 debug Datatype system.adapter.web.0.memHeapUsed: Currently: number, StorageType: Number
          sql.0 2018-05-03 09:17:24.880 debug INSERT INTO ioBroker.ts_number (id, ts, val, ack, _from, q) VALUES(96, 1525331843873, 28.82, 1, 16, 0);
          sql.0 2018-05-03 09:17:24.879 debug Datatype system.adapter.sql.0.memHeapUsed: Currently: number, StorageType: Number
          sql.0 2018-05-03 09:17:24.669 debug INSERT INTO ioBroker.ts_number (id, ts, val, ack, _from, q) VALUES(101, 1525331843632, 92, 1, 17, 0);
          sql.0 2018-05-03 09:17:24.667 debug Datatype system.host.rock64.freemem: Currently: number, StorageType: Number
          sql.0 2018-05-03 09:17:24.663 debug INSERT INTO ioBroker.ts_number (id, ts, val, ack, _from, q) VALUES(98, 1525331843627, 81.82, 1, 17, 0);
          sql.0 2018-05-03 09:17:24.661 debug Datatype system.host.rock64.memHeapUsed: Currently: number, StorageType: Number
          sql.0 2018-05-03 09:17:24.653 debug INSERT INTO ioBroker.ts_number (id, ts, val, ack, _from, q) VALUES(102, 1525331843617, 0.17, 1, 17, 0);
          sql.0 2018-05-03 09:17:24.651 debug Datatype system.host.rock64.load: Currently: number, StorageType: Number
          sql.0 2018-05-03 09:17:24.302 debug Min-Delta reached system.adapter.admin.0.memHeapUsed, last-value=35.6, new-value=35.99, ts=1525331844285
          sql.0 2018-05-03 09:17:24.301 debug new value received for system.adapter.admin.0.memHeapUsed, new-value=35.99, ts=1525331844285, relog=false
          sql.0 2018-05-03 09:17:24.193 debug INSERT INTO ioBroker.ts_number (id, ts, val, ack, _from, q) VALUES(88, 1525331843162, 12.75, 1, 12, 0);
          sql.0 2018-05-03 09:17:24.192 debug Datatype system.adapter.hue.0.memHeapUsed: Currently: number, StorageType: Number
          sql.0 2018-05-03 09:17:23.997 debug Min-Delta reached system.adapter.cloud.0.memHeapUsed, last-value=105.14, new-value=105.41, ts=1525331843969
          sql.0 2018-05-03 09:17:23.997 debug new value received for system.adapter.cloud.0.memHeapUsed, new-value=105.41, ts=1525331843969, relog=false
          sql.0 2018-05-03 09:17:23.980 debug Min-Delta reached system.adapter.web.0.memHeapUsed, last-value=20.21, new-value=19.47, ts=1525331843944
          sql.0 2018-05-03 09:17:23.979 debug new value received for system.adapter.web.0.memHeapUsed, new-value=19.47, ts=1525331843944, relog=false
          sql.0 2018-05-03 09:17:23.878 debug Min-Delta reached system.adapter.sql.0.memHeapUsed, last-value=28.9, new-value=28.82, ts=1525331843873
          sql.0 2018-05-03 09:17:23.877 debug new value received for system.adapter.sql.0.memHeapUsed, new-value=28.82, ts=1525331843873, relog=false
          sql.0 2018-05-03 09:17:23.661 debug Min-Delta reached system.host.rock64.freemem, last-value=83, new-value=92, ts=1525331843632
          sql.0 2018-05-03 09:17:23.660 debug new value received for system.host.rock64.freemem, new-value=92, ts=1525331843632, relog=false
          sql.0 2018-05-03 09:17:23.660 debug Min-Delta reached system.host.rock64.memHeapUsed, last-value=76.89, new-value=81.82, ts=1525331843627
          sql.0 2018-05-03 09:17:23.659 debug new value received for system.host.rock64.memHeapUsed, new-value=81.82, ts=1525331843627, relog=false
          sql.0 2018-05-03 09:17:23.649 debug Min-Delta reached system.host.rock64.load, last-value=0.22, new-value=0.17, ts=1525331843617
          sql.0 2018-05-03 09:17:23.648 debug new value received for system.host.rock64.load, new-value=0.17, ts=1525331843617, relog=false
          sql.0 2018-05-03 09:17:23.174 debug Min-Delta reached system.adapter.hue.0.memHeapUsed, last-value=12.51, new-value=12.75, ts=1525331843162
          sql.0 2018-05-03 09:17:23.173 debug new value received for system.adapter.hue.0.memHeapUsed, new-value=12.75, ts=1525331843162, relog=false
          sql.0 2018-05-03 09:17:23.038 debug INSERT INTO ioBroker.ts_number (id, ts, val, ack, _from, q) VALUES(87, 1525331842014, 67.8, 1, 1, 0);
          sql.0 2018-05-03 09:17:23.037 debug Datatype system.adapter.javascript.0.memHeapUsed: Currently: number, StorageType: Number
          sql.0 2018-05-03 09:17:22.030 debug Min-Delta reached system.adapter.javascript.0.memHeapUsed, last-value=67.46, new-value=67.8, ts=1525331842014
          sql.0 2018-05-03 09:17:22.028 debug new value received for system.adapter.javascript.0.memHeapUsed, new-value=67.8, ts=1525331842014, relog=false
          sql.0 2018-05-03 09:17:21.703 debug INSERT INTO ioBroker.ts_number (id, ts, val, ack, _from, q) VALUES(85, 1525331840684, 22.27, 1, 11, 0);
          sql.0 2018-05-03 09:17:21.702 debug Datatype system.adapter.broadlink2.0.memHeapUsed: Currently: number, StorageType: Number
          sql.0 2018-05-03 09:17:20.700 debug Min-Delta reached system.adapter.broadlink2.0.memHeapUsed, last-value=22.19, new-value=22.27, ts=1525331840684
          sql.0 2018-05-03 09:17:20.700 debug new value received for system.adapter.broadlink2.0.memHeapUsed, new-value=22.27, ts=1525331840684, relog=false
          sql.0 2018-05-03 09:17:19.380 debug INSERT INTO ioBroker.ts_number (id, ts, val, ack, _from, q) VALUES(94, 1525331838362, 17.83, 1, 4, 0);
          sql.0 2018-05-03 09:17:19.379 debug Datatype system.adapter.hm-rega.0.memHeapUsed: Currently: number, StorageType: Number
          sql.0 2018-05-03 09:17:19.192 debug INSERT INTO ioBroker.ts_number (id, ts, val, ack, _from, q) VALUES(92, 1525331838172, 15.12, 1, 7, 0);
          sql.0 2018-05-03 09:17:19.191 debug Datatype system.adapter.yahka.0.memHeapUsed: Currently: number, StorageType: Number
          sql.0 2018-05-03 09:17:18.733 debug INSERT INTO ioBroker.ts_number (id, ts, val, ack, _from, q) VALUES(95, 1525331837713, 18.18, 1, 15, 0);
          sql.0 2018-05-03 09:17:18.732 debug Datatype system.adapter.hm-rpc.1.memHeapUsed: Currently: number, StorageType: Number
          sql.0 2018-05-03 09:17:18.553 debug INSERT INTO ioBroker.ts_number (id, ts, val, ack, _from, q) VALUES(90, 1525331837531, 22.83, 1, 8, 0);
          sql.0 2018-05-03 09:17:18.552 debug Datatype system.adapter.rpi2.0.memHeapUsed: Currently: number, StorageType: Number
          sql.0 2018-05-03 09:17:18.378 debug Min-Delta reached system.adapter.hm-rega.0.memHeapUsed, last-value=17.75, new-value=17.83, ts=1525331838362
          sql.0 2018-05-03 09:17:18.377 debug new value received for system.adapter.hm-rega.0.memHeapUsed, new-value=17.83, ts=1525331838362, relog=false
          sql.0 2018-05-03 09:17:18.190 debug Min-Delta reached system.adapter.yahka.0.memHeapUsed, last-value=14.97, new-value=15.12, ts=1525331838172
          sql.0 2018-05-03 09:17:18.189 debug new value received for system.adapter.yahka.0.memHeapUsed, new-value=15.12, ts=1525331838172, relog=false
          sql.0 2018-05-03 09:17:17.731 debug Min-Delta reached system.adapter.hm-rpc.1.memHeapUsed, last-value=17.93, new-value=18.18, ts=1525331837713
          sql.0 2018-05-03 09:17:17.730 debug new value received for system.adapter.hm-rpc.1.memHeapUsed, new-value=18.18, ts=1525331837713, relog=false
          sql.0 2018-05-03 09:17:17.551 debug Min-Delta reached system.adapter.rpi2.0.memHeapUsed, last-value=22.57, new-value=22.83, ts=1525331837531
          sql.0 2018-05-03 09:17:17.550 debug new value received for system.adapter.rpi2.0.memHeapUsed, new-value=22.83, ts=1525331837531, relog=false
          sql.0 2018-05-03 09:17:15.937 debug sendTo "getHistory" to system.adapter.cloud.0 from system.adapter.sql.0
          sql.0 2018-05-03 09:17:15.934 debug Send: 50 of: 50 in: 55ms
          sql.0 2018-05-03 09:17:15.885 debug SELECT ts, val, ack, ioBroker.sources.name as 'from', q FROM ioBroker.ts_bool INNER JOIN ioBroker.sources ON ioBroker.sources.id=ioBroker.ts_bool._from WHERE ioBroker.ts_bool.id=50 AND sql.0 2018-05-03 09:17:15.884 debug SELECT ts, val, ack,ioBroker.sources.name as 'from', q FROM ioBroker.ts_bool INNER JOIN ioBroker.sources ON ioBroker.sources.id=ioBroker.ts_bool._from WHERE ioBroker.ts_bool.id=50 AND
          sql.0 2018-05-03 09:17:14.713 debug INSERT INTO ioBroker.ts_number (id, ts, val, ack, _from, q) VALUES(97, 1525331833702, 11.76, 1, 3, 0);
          sql.0 2018-05-03 09:17:14.712 debug Datatype system.adapter.hm-rpc.0.memHeapUsed: Currently: number, StorageType: Number
          sql.0 2018-05-03 09:17:14.687 debug INSERT INTO ioBroker.ts_number (id, ts, val, ack, _from, q) VALUES(84, 1525331833669, 27.2, 1, 10, 0);
          sql.0 2018-05-03 09:17:14.686 debug Datatype system.adapter.telegram.0.memHeapUsed: Currently: number, StorageType: Number
          sql.0 2018-05-03 09:17:14.662 debug INSERT INTO ioBroker.ts_number (id, ts, val, ack, _from, q) VALUES(93, 1525331833641, 12.63, 1, 14, 0);
          sql.0 2018-05-03 09:17:14.661 debug Datatype system.adapter.g-homa.0.memHeapUsed: Currently: number, StorageType: Number
          sql.0 2018-05-03 09:17:13.711 debug Min-Delta reached system.adapter.hm-rpc.0.memHeapUsed, last-value=11.32, new-value=11.76, ts=1525331833702
          sql.0 2018-05-03 09:17:13.710 debug new value received for system.adapter.hm-rpc.0.memHeapUsed, new-value=11.76, ts=1525331833702, relog=false
          sql.0 2018-05-03 09:17:13.685 debug Min-Delta reached system.adapter.telegram.0.memHeapUsed, last-value=27.06, new-value=27.2, ts=1525331833669
          sql.0 2018-05-03 09:17:13.684 debug new value received for system.adapter.telegram.0.memHeapUsed, new-value=27.2, ts=1525331833669, relog=false
          sql.0 2018-05-03 09:17:13.660 debug Min-Delta reached system.adapter.g-homa.0.memHeapUsed, last-value=12.56, new-value=12.63, ts=1525331833641
          sql.0 2018-05-03 09:17:13.659 debug new value received for system.adapter.g-homa.0.memHeapUsed, new-value=12.63, ts=1525331833641, relog=false
          sql.0 2018-05-03 09:17:10.301 debug INSERT INTO ioBroker.ts_number (id, ts, val, ack, _from, q) VALUES(86, 1525331829282, 35.6, 1, 6, 0);
          sql.0 2018-05-03 09:17:10.300 debug Datatype system.adapter.admin.0.memHeapUsed: Currently: number, StorageType: Number
          sql.0 2018-05-03 09:17:09.985 debug INSERT INTO ioBroker.ts_number (id, ts, val, ack, _from, q) VALUES(89, 1525331828964, 105.14, 1, 13, 0);
          sql.0 2018-05-03 09:17:09.984 debug Datatype system.adapter.cloud.0.memHeapUsed: Currently: number, StorageType: Number
          sql.0 2018-05-03 09:17:09.959 debug INSERT INTO ioBroker.ts_number (id, ts, val, ack, _from, q) VALUES(91, 1525331828940, 20.21, 1, 5, 0);
          sql.0 2018-05-03 09:17:09.957 debug Datatype system.adapter.web.0.memHeapUsed: Currently: number, StorageType: Number
          sql.0 2018-05-03 09:17:09.883 debug INSERT INTO ioBroker.ts_number (id, ts, val, ack, _from, q) VALUES(96, 1525331828871, 28.9, 1, 16, 0);
          sql.0 2018-05-03 09:17:09.882 debug Datatype system.adapter.sql.0.memHeapUsed: Currently: number, StorageType: Number
          sql.0 2018-05-03 09:17:09.639 debug INSERT INTO ioBroker.ts_number (id, ts, val, ack, _from, q) VALUES(101, 1525331828608, 83, 1, 17, 0);
          sql.0 2018-05-03 09:17:09.638 debug Datatype system.host.rock64.freemem: Currently: number, StorageType: Number
          sql.0 2018-05-03 09:17:09.633 debug INSERT INTO ioBroker.ts_number (id, ts, val, ack, _from, q) VALUES(98, 1525331828606, 76.89, 1, 17, 0);
          sql.0 2018-05-03 09:17:09.632 debug Datatype system.host.rock64.memHeapUsed: Currently: number, StorageType: Number
          sql.0 2018-05-03 09:17:09.625 debug INSERT INTO ioBroker.ts_number (id, ts, val, ack, _from, q) VALUES(102, 1525331828602, 0.22, 1, 17, 0);

          
          Ich hoffe es ist das richtige Log? Ich komme gerade leider nur über pro auf meinem Admin, daher ist das Log nicht vollständig.
          1 Reply Last reply Reply Quote 0
          • apollon77
            apollon77 last edited by

            Log ist das richtige. Es wäre aber super eins zu haben wo auch der relevante Datenpunkt mit auftaucht 🙂

            Kann es sein das die anderen zeitpunkte wo es diese true/false Logs gabe auch von SQL-Instanz restarts kommen?

            1 Reply Last reply Reply Quote 0
            • S
              schittl last edited by

              Ja zu 99% sind das reine Restarts des Adapters… Anscheinend wird beim Stoppen und beim Starten jeweils der Datenpunkt historisiert...

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

                Ja, an sich werden da "NULL"-Werte reingeschrieben. sollten also eigentlich keine true/false kommen. komisch. Du kannst das schreiben der NULL Werte in den aktuellen Versionen in den Adaptereinstellungen ausschalten.

                1 Reply Last reply Reply Quote 0
                • S
                  schittl last edited by

                  Ich habe die Option mal deaktiviert. Mal schauen ob es sich bessert:

                  3116_sqladapter.jpg

                  Was bedeutet eigentlich an "Start- / Stop-Grenzen"? Neustart? Für was ist die Option gut?

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

                    Die Idee ist das man genau sieht wann es Daten gibt und wann nicht. Viele Graphentools (auch flot) verbinden einfach alle Datenpunkte. Wenn also der Adapter aus ist für Zeit X und danach wieder angeht dann gab es irgendwann den letzten Wert und dann den nächsten Wert als es wieder an ging. die werden verbunden und man "denkt" das sich die Werte so verhalten haben - stimmt aber nicht.

                    Man sieht also das Loch in den Daten nicht.

                    Mit dem Loggen von "NULL" geht der Graph an sich auf NULL/0 und dann von NULL/0 wieder auf den nächsten Wert. Man sieht das also.

                    1 Reply Last reply Reply Quote 0
                    • S
                      schittl last edited by

                      Ich habe inzwischen mehrmals den Adapter neu gestartet und es werden mit deaktivierter Option auch keine Werte mehr historisiert: 3116_sql3.jpg
                      Ich prüfe mal weiter aber ansonsten scheint die Option die Ursache zu sein.

                      Danke und vg

                      Falk

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

                        Hier hilft debug log um genau zu sehen was "Im Adapter" so passiert"

                        1 Reply Last reply Reply Quote 0
                        • S
                          schittl last edited by

                          Es sind bis dato nach deaktivierter Option keine zusätzlichen Werte entstanden 😄

                          Danke <emoji seq="1f64f-1f3fb">🙏🏻</emoji>

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

                          Support us

                          ioBroker
                          Community Adapters
                          Donate
                          FAQ Cloud / IOT
                          HowTo: Node.js-Update
                          HowTo: Backup/Restore
                          Downloads
                          BLOG

                          844
                          Online

                          32.1k
                          Users

                          80.7k
                          Topics

                          1.3m
                          Posts

                          2
                          13
                          1111
                          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