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

[schittl]

Hallo,

wie bekomme ich es hin, dass der SQL-Adapter (Version 1.6.9) nur diese Werte speichert, sprich eine durchgeführte manuell Wert-Aktualisierung über VIS:

Der DP ist wie folgt eingestellt:

Zusatzinfo:

Versuche mit "nur Änderungen aufzeichnen", brachten keine Verbesserung. Um 4.30 wird alle 2 Tage ein Backup durchgeführt incl. ioBroker-Neustart.

Vielen Dank und vg

Falk

[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.

[schittl]

@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?

[apollon77]

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

[schittl]

Ich habe den Adapter gerade mal neugestartet und es werden ebenfalls Daten geloggt:

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.

[apollon77]

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?

[schittl]

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

[apollon77]

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.

[schittl]

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

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

[apollon77]

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.

[schittl]

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

Danke und vg

Falk

[apollon77]

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

[schittl]

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

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