[gelöst] InfluxDB: Blockzeit Verständnisproblem

[Marc Berg]

@iobroker2001

Ich versuche das gerade mal nachzustellen, allerdings funktioniert dies bei mir wie gedacht. Um vielleicht der Ursache etwas näher zu kommen, mach mal bitte folgendes:

• Screenshot der DB Einstellungen der Instanz
• den Screenshot der Historie so groß machen, dass die "from" Spalte mit sichtbar wird
• die Loggingeinstellungen der Instanz auf "debug" stellen
• "erweitertes Logging" im Datenpunkt aktivieren, eigentlich müsste dann sowas in der Art im Log stehen:

value ignored blockTime testDP, value=602, ts=1685820976146, lastState.ts=1685820691064, blockTime=300000

Dann fünf Minuten des Logs exportieren und hier anhängen.

[iobroker2001]

@marc-berg Hallo Marc, danke!

Aber jetzt bin ich verwirrt: Nachdem ich einmal das Debuggen aktiviert hatte, tritt der Fehler anscheinend nicht mehr auf, auch nicht mehr nach dem Abschalten des Debuggens! Ist das möglich?
Wie dem auch so, der Fehler scheint weg zu sein!

Vielen Dank!

Dennoch hier die Daten, falls Dir etwas auffallen sollte:

DB-Einstellungen:

Screenshot Historie NACH dem Debuggen: scheint alles korrekt zu sein diesmal!
Der Influxspaltenname heißt "Schimmelsensor".

Logging:

2023-06-04 10:25:00.325 - info: influxdb.0 (1332) enabled logging of Schimmelsensor, Alias=true
2023-06-04 10:26:52.241 - info: ws.0 (2452) <== Disconnect system.user.admin from ::ffff:192.168.178.58 echarts-show
2023-06-04 10:26:52.259 - info: ws.0 (2452) <== Disconnect system.user.admin from ::ffff:192.168.178.58 echarts-show
2023-06-04 10:26:52.277 - info: ws.0 (2452) <== Disconnect system.user.admin from ::ffff:192.168.178.58 vis.0
2023-06-04 10:26:54.507 - info: ws.0 (2452) ==> Connected system.user.admin from ::ffff:192.168.178.58
2023-06-04 10:26:58.030 - info: ws.0 (2452) ==> Connected system.user.admin from ::ffff:192.168.178.58
2023-06-04 10:26:59.605 - info: ws.0 (2452) ==> Connected system.user.admin from ::ffff:192.168.178.58
2023-06-04 10:27:53.119 - error: javascript.0 (1311) script.js.common.Friedhelm.Rolladen.Schattierung_Flur: Rolladen entschattiert!
2023-06-04 10:28:00.175 - info: host.raspi4 instance system.adapter.mobile-alerts.0 started with pid 27426
2023-06-04 10:28:00.548 - info: host.raspi4 stopInstance system.adapter.influxdb.0 (force=false, process=true)
2023-06-04 10:28:00.798 - info: influxdb.0 (1332) Terminated (ADAPTER_REQUESTED_TERMINATION): Without reason
2023-06-04 10:28:01.456 - info: host.raspi4 instance system.adapter.influxdb.0 terminated for restart.
2023-06-04 10:28:01.458 - info: host.raspi4 Adapter system.adapter.influxdb.0 will be restarted automatically
2023-06-04 10:28:02.532 - info: mobile-alerts.0 (27426) starting. Version 0.5.1 (non-npm: bluerai/ioBroker.mobile-alerts#558b1275accf47ce5f58073481a8af6e57bfa390) in /opt/iobroker/node_modules/iobroker.mobile-alerts, node: v18.16.0, js-controller: 4.0.24
2023-06-04 10:28:13.945 - info: host.raspi4 instance system.adapter.influxdb.0 started with pid 27441
2023-06-04 10:28:15.714 - debug: influxdb.0 (27441) Redis Objects: Use Redis connection: 127.0.0.1:9001
2023-06-04 10:28:15.764 - debug: influxdb.0 (27441) Objects client ready ... initialize now
2023-06-04 10:28:15.767 - debug: influxdb.0 (27441) Objects create System PubSub Client
2023-06-04 10:28:15.768 - debug: influxdb.0 (27441) Objects create User PubSub Client
2023-06-04 10:28:15.830 - debug: influxdb.0 (27441) Objects client initialize lua scripts
2023-06-04 10:28:15.839 - debug: influxdb.0 (27441) Objects connected to redis: 127.0.0.1:9001
2023-06-04 10:28:15.880 - debug: influxdb.0 (27441) Redis States: Use Redis connection: 127.0.0.1:9000
2023-06-04 10:28:15.900 - debug: influxdb.0 (27441) States create System PubSub Client
2023-06-04 10:28:15.902 - debug: influxdb.0 (27441) States create User PubSub Client
2023-06-04 10:28:15.976 - debug: influxdb.0 (27441) States connected to redis: 127.0.0.1:9000
2023-06-04 10:28:16.083 - debug: influxdb.0 (27441) Plugin sentry Initialize Plugin (enabled=true)
2023-06-04 10:28:16.090 - info: influxdb.0 (27441) Plugin sentry Sentry Plugin disabled for this process because sending of statistic data is disabled for the system
2023-06-04 10:28:16.361 - info: influxdb.0 (27441) starting. Version 3.2.0 in /opt/iobroker/node_modules/iobroker.influxdb, node: v18.16.0, js-controller: 4.0.24
2023-06-04 10:28:16.409 - info: influxdb.0 (27441) No stored data from last exit found
2023-06-04 10:28:16.411 - info: influxdb.0 (27441) Connecting http://localhost:8086/ ...
2023-06-04 10:28:16.412 - info: influxdb.0 (27441) Influx DB Version used: 2.x
2023-06-04 10:28:16.413 - debug: influxdb.0 (27441) Connect InfluxDB2: http://localhost:8086/ [iobroker]
2023-06-04 10:28:16.419 - debug: influxdb.0 (27441) Organization being checked: zuhause
2023-06-04 10:28:16.496 - debug: influxdb.0 (27441) Organizations: {"links":{"self":"/api/v2/orgs"},"orgs":[{"links":{"buckets":"/api/v2/buckets?org=zuhause","dashboards":"/api/v2/dashboards?org=zuhause","labels":"/api/v2/orgs/da777db5712d55af/labels","logs":"/api/v2/orgs/da777db5712d55af/logs","members":"/api/v2/orgs/da777db5712d55af/members","owners":"/api/v2/orgs/da777db5712d55af/owners","secrets":"/api/v2/orgs/da777db5712d55af/secrets","self":"/api/v2/orgs/da777db5712d55af","tasks":"/api/v2/tasks?org=zuhause"},"id":"da777db5712d55af","name":"zuhause","description":"","createdAt":"2022-12-24T09:54:58.361597933Z","updatedAt":"2022-12-24T09:54:58.361598193Z"}]}
2023-06-04 10:28:16.548 - debug: influxdb.0 (27441) Buckets: {"links":{"self":"/api/v2/buckets?descending=false&limit=20&offset=0&orgID=da777db5712d55af"},"buckets":[{"id":"6472faa780429f3d","orgID":"da777db5712d55af","type":"system","description":"System bucket for monitoring logs","name":"_monitoring","retentionRules":[{"type":"expire","everySeconds":604800,"shardGroupDurationSeconds":86400}],"createdAt":"2022-12-24T09:54:58.383426557Z","updatedAt":"2022-12-24T09:54:58.383426853Z","links":{"labels":"/api/v2/buckets/6472faa780429f3d/labels","members":"/api/v2/buckets/6472faa780429f3d/members","org":"/api/v2/orgs/da777db5712d55af","owners":"/api/v2/buckets/6472faa780429f3d/owners","self":"/api/v2/buckets/6472faa780429f3d","write":"/api/v2/write?org=da777db5712d55af&bucket=6472faa780429f3d"},"labels":[]},{"id":"313fc80673fc8154","orgID":"da777db5712d55af","type":"system","description":"System bucket for task logs","name":"_tasks","retentionRules":[{"type":"expire","everySeconds":259200,"shardGroupDurationSeconds":86400}],"createdAt":"2022-12-24T09:54:58.366395928Z","updatedAt":"2022-12-24T09:54:58.366396206Z","links":{"labels":"/api/v2/buckets/313fc80673fc8154/labels","members":"/api/v2/buckets/313fc80673fc8154/members","org":"/api/v2/orgs/da777db5712d55af","owners":"/api/v2/buckets/313fc80673fc8154/owners","self":"/api/v2/buckets/313fc80673fc8154","write":"/api/v2/write?org=da777db5712d55af&bucket=313fc80673fc8154"},"labels":[]},{"id":"9b191b71b9474c02","orgID":"da777db5712d55af","type":"user","name":"influx-statistikdaten","retentionRules":[{"type":"expire","everySeconds":604800,"shardGroupDurationSeconds":604800}],"createdAt":"2022-12-24T09:54:58.396852347Z","updatedAt":"2023-04-08T15:23:19.717054585Z","links":{"labels":"/api/v2/buckets/9b191b71b9474c02/labels","members":"/api/v2/buckets/9b191b71b9474c02/members","org":"/api/v2/orgs/da777db5712d55af","owners":"/api/v2/buckets/9b191b71b9474c02/owners","self":"/api/v2/buckets/9b191b71b9474c02","write":"/api/v2/write?org=da777db5712d55af&bucket=9b191b71b9474c02"},"labels":[]},{"id":"df6f2a6384362915","orgID":"da777db5712d55af","type":"user","name":"iobroker","retentionRules":[{"type":"expire","everySeconds":15811200,"shardGroupDurationSeconds":86400}],"createdAt":"2023-04-08T15:24:01.655543293Z","updatedAt":"2023-06-01T15:19:02.750620548Z","links":{"labels":"/api/v2/buckets/df6f2a6384362915/labels","members":"/api/v2/buckets/df6f2a6384362915/members","org":"/api/v2/orgs/da777db5712d55af","owners":"/api/v2/buckets/df6f2a6384362915/owners","self":"/api/v2/buckets/df6f2a6384362915","write":"/api/v2/write?org=da777db5712d55af&bucket=df6f2a6384362915"},"labels":[]},{"id":"ecd164dc8277c2c5","orgID":"da777db5712d55af","type":"user","name":"iobroker-Langzeit","retentionRules":[{"type":"expire","everySeconds":0,"shardGroupDurationSeconds":604800}],"createdAt":"2023-05-16T14:11:20.27097693Z","updatedAt":"2023-06-01T15:19:14.259023022Z","links":{"labels":"/api/v2/buckets/ecd164dc8277c2c5/labels","members":"/api/v2/buckets/ecd164dc8277c2c5/members","org":"/api/v2/orgs/da777db5712d55af","owners":"/api/v2/buckets/ecd164dc8277c2c5/owners","self":"/api/v2/buckets/ecd164dc8277c2c5","write":"/api/v2/write?org=da777db5712d55af&bucket=ecd164dc8277c2c5"},"labels":[]}]}
2023-06-04 10:28:16.551 - info: influxdb.0 (27441) Applying retention policy for iobroker to 15811200 seconds. Shard Group Duration (calculated): 86400 seconds
2023-06-04 10:28:16.555 - debug: influxdb.0 (27441) Query to execute: import "influxdata/influxdb/schema" schema.tagKeys(bucket: "iobroker")
2023-06-04 10:28:16.601 - info: influxdb.0 (27441) enabled logging of hm-rpc.0.KEQ1058846.1.TEMPERATURE, Alias=false, 1 points now activated
2023-06-04 10:28:16.603 - debug: influxdb.0 (27441) Found Alias: hm-rpc.0.LEQ0098583.1.HUMIDITY --> Luftfeuchtigkeit_außen
2023-06-04 10:28:16.604 - info: influxdb.0 (27441) enabled logging of Luftfeuchtigkeit_außen, Alias=true, 2 points now activated
2023-06-04 10:28:16.604 - info: influxdb.0 (27441) enabled logging of hm-rpc.0.LEQ0098583.1.TEMPERATURE, Alias=false, 3 points now activated
2023-06-04 10:28:16.605 - debug: influxdb.0 (27441) Found Alias: hm-rpc.0.OEQ0771493.2.POWER --> Entfeuchtersteckdose
2023-06-04 10:28:16.606 - info: influxdb.0 (27441) enabled logging of Entfeuchtersteckdose, Alias=true, 4 points now activated
2023-06-04 10:28:16.607 - debug: influxdb.0 (27441) Found Alias: hm-rpc.0.UNISENS003.1.AIR_PRESSURE --> Luftdruck
2023-06-04 10:28:16.607 - info: influxdb.0 (27441) enabled logging of Luftdruck, Alias=true, 5 points now activated
2023-06-04 10:28:16.608 - debug: influxdb.0 (27441) Found Alias: jeelink.0.LaCrosse_2.humid --> Schimmelsensor
2023-06-04 10:28:16.609 - info: influxdb.0 (27441) enabled logging of Schimmelsensor, Alias=true, 6 points now activated
2023-06-04 10:28:16.609 - info: influxdb.0 (27441) enabled logging of parser.0.Leistung, Alias=false, 7 points now activated
2023-06-04 10:28:16.610 - info: influxdb.0 (27441) enabled logging of statistics.0.save.sumCount.0_userdata.0.friedhelm.Wetter.Regenmesser.RegenmesserFlanke.hour, Alias=false, 8 points now activated
2023-06-04 10:28:16.611 - info: influxdb.0 (27441) enabled logging of statistics.0.save.sumCount.0_userdata.0.friedhelm.Wetter.Regenmesser.RegenmesserFlanke.day, Alias=false, 9 points now activated
2023-06-04 10:28:16.613 - info: influxdb.0 (27441) enabled logging of statistics.0.temp.sumCount.0_userdata.0.friedhelm.Wetter.Regenmesser.RegenmesserFlanke.hour, Alias=false, 10 points now activated
2023-06-04 10:28:16.614 - info: influxdb.0 (27441) enabled logging of statistics.0.save.minmax.0_userdata.0.friedhelm.Energie.PVA.EnergieTag.dayMax, Alias=false, 11 points now activated
2023-06-04 10:28:16.615 - info: influxdb.0 (27441) enabled logging of statistics.0.save.sumDelta.0_userdata.0.friedhelm.Energie.PVA.EnergieTag.day, Alias=false, 12 points now activated
2023-06-04 10:28:16.616 - info: influxdb.0 (27441) enabled logging of statistics.0.save.sumDelta.0_userdata.0.friedhelm.Energie.PVA.EnergieTag.delta, Alias=false, 13 points now activated
2023-06-04 10:28:16.618 - info: influxdb.0 (27441) enabled logging of alias.0.Wetter.Wind.Böe, Alias=false, 14 points now activated
2023-06-04 10:28:16.619 - info: influxdb.0 (27441) enabled logging of statistics.0.save.minmax.alias.0.Wetter.Wind.Böe.dayMax, Alias=false, 15 points now activated
2023-06-04 10:28:16.621 - debug: influxdb.0 (27441) Found Alias: alias.0.Lichtsensoren.Süd --> LichtsensorSüd
2023-06-04 10:28:16.621 - info: influxdb.0 (27441) enabled logging of LichtsensorSüd, Alias=true, 16 points now activated
2023-06-04 10:28:16.622 - debug: influxdb.0 (27441) Found Alias: statistics.0.save.sumDelta.0_userdata.0.friedhelm.Energie.Gas.Gasuhr.hour --> GasverbrauchStunde
2023-06-04 10:28:16.622 - info: influxdb.0 (27441) enabled logging of GasverbrauchStunde, Alias=true, 17 points now activated
2023-06-04 10:28:16.623 - debug: influxdb.0 (27441) Found Alias: alias.0.Lichtsensoren.West --> LichtsensorWest
2023-06-04 10:28:16.623 - info: influxdb.0 (27441) enabled logging of LichtsensorWest, Alias=true, 18 points now activated
2023-06-04 10:28:16.624 - debug: influxdb.0 (27441) Found Alias: alias.0.Gasuhr.Gasverbrauch4XViertelstunde --> Gasverbrauch4XViertelstunde
2023-06-04 10:28:16.624 - info: influxdb.0 (27441) enabled logging of Gasverbrauch4XViertelstunde, Alias=true, 19 points now activated
2023-06-04 10:28:16.625 - debug: influxdb.0 (27441) Found Alias: worx.0.20183019841200320714.mower.wifiQuality --> WorxWifiQuality
2023-06-04 10:28:16.625 - info: influxdb.0 (27441) enabled logging of WorxWifiQuality, Alias=true, 20 points now activated
2023-06-04 10:28:16.625 - debug: influxdb.0 (27441) Found Alias: worx.0.20183019841200320714.mower.batteryCharging --> WorxWirdGeladen
2023-06-04 10:28:16.626 - info: influxdb.0 (27441) enabled logging of WorxWirdGeladen, Alias=true, 21 points now activated
2023-06-04 10:28:16.627 - debug: influxdb.0 (27441) Found Alias: worx.0.20183019841200320714.mower.batteryState --> Worx_Batteriestand
2023-06-04 10:28:16.627 - info: influxdb.0 (27441) enabled logging of Worx_Batteriestand, Alias=true, 22 points now activated
2023-06-04 10:28:16.629 - debug: influxdb.0 (27441) Found Alias: worx.0.20183019841200320714.mower.batteryTemperature --> WorxTemperatur
2023-06-04 10:28:16.629 - info: influxdb.0 (27441) enabled logging of WorxTemperatur, Alias=true, 23 points now activated
2023-06-04 10:28:16.630 - debug: influxdb.0 (27441) Found Alias: alias.0.Lichtsensoren.Ost --> LichtsensorOst
2023-06-04 10:28:16.630 - info: influxdb.0 (27441) enabled logging of LichtsensorOst, Alias=true, 24 points now activated
2023-06-04 10:28:16.631 - debug: influxdb.0 (27441) Found Alias: alias.0.Wetter.Temperatur_und_Luftfeuchtigkeit.Temperatur_Wintergarten --> Temperatur_Wintergarten
2023-06-04 10:28:16.631 - info: influxdb.0 (27441) enabled logging of Temperatur_Wintergarten, Alias=true, 25 points now activated
2023-06-04 10:28:16.631 - debug: influxdb.0 (27441) Found Alias: alias.0.Wetter.Temperatur_und_Luftfeuchtigkeit.Luftfeuchtigkeit_Wintergarten --> Luftfeuchtigkeit_Wintergarten
2023-06-04 10:28:16.632 - info: influxdb.0 (27441) enabled logging of Luftfeuchtigkeit_Wintergarten, Alias=true, 26 points now activated
2023-06-04 10:28:16.632 - debug: influxdb.0 (27441) Found Alias: alias.0.Wetter.Regen.Regensensor --> Regensensor
2023-06-04 10:28:16.632 - info: influxdb.0 (27441) enabled logging of Regensensor, Alias=true, 27 points now activated
2023-06-04 10:28:16.677 - debug: influxdb.0 (27441) Query to execute: import "influxdata/influxdb/schema" schema.fieldKeys(bucket: "iobroker")
2023-06-04 10:28:16.708 - debug: influxdb.0 (27441) connected set to true
2023-06-04 10:28:16.708 - debug: influxdb.0 (27441) connected set to true
2023-06-04 10:28:16.723 - debug: influxdb.0 (27441) Result of metadata storage type check: [[{"result":"_result","table":0,"_value":"_start"},{"result":"_result","table":0,"_value":"_stop"},{"result":"_result","table":0,"_value":"_field"},{"result":"_result","table":0,"_value":"_measurement"}],[{"result":"_result","table":0,"_value":"ack"},{"result":"_result","table":0,"_value":"from"},{"result":"_result","table":0,"_value":"q"},{"result":"_result","table":0,"_value":"value"}]]
2023-06-04 10:28:16.725 - debug: influxdb.0 (27441) Storage type for metadata found in DB: fields
2023-06-04 10:28:16.726 - info: influxdb.0 (27441) Connected!
2023-06-04 10:28:18.389 - debug: influxdb.0 (27441) new value received for Schimmelsensor (storageType false), new-value=61, ts=1685867298374, relog=false
2023-06-04 10:28:18.390 - debug: influxdb.0 (27441) value ignored blockTime Schimmelsensor, value=61, ts=1685867298374, lastState.ts=1685867226900, blockTime=300000
2023-06-04 10:28:19.173 - info: host.raspi4 instance system.adapter.mobile-alerts.0 terminated with code 0 (NO_ERROR)
2023-06-04 10:28:23.821 - debug: influxdb.0 (27441) Write Point: hm-rpc.0.KEQ1058846.1.TEMPERATURE values:{"value":20,"time":"2023-06-04T08:28:23.812Z","from":"system.adapter.hm-rpc.0","q":0,"ack":true} options: null
2023-06-04 10:28:23.839 - debug: influxdb.0 (27441) Point written to iobroker
2023-06-04 10:28:28.084 - debug: influxdb.0 (27441) Write Point: LichtsensorSüd values:{"value":34.7,"time":"2023-06-04T08:28:28.076Z","from":"system.adapter.hm-rpc.0","q":0,"ack":true} options: null
2023-06-04 10:28:28.101 - debug: influxdb.0 (27441) Point written to iobroker
2023-06-04 10:28:31.732 - debug: influxdb.0 (27441) PING OK
2023-06-04 10:28:36.240 - debug: influxdb.0 (27441) Write Point: Luftdruck values:{"value":1022.9,"time":"2023-06-04T08:28:36.231Z","from":"system.adapter.hm-rpc.0","q":0,"ack":true} options: null
2023-06-04 10:28:36.257 - debug: influxdb.0 (27441) Point written to iobroker
2023-06-04 10:28:36.288 - debug: influxdb.0 (27441) Write Point: LichtsensorOst values:{"value":44.26,"time":"2023-06-04T08:28:36.272Z","from":"system.adapter.hm-rpc.0","q":0,"ack":true} options: null
2023-06-04 10:28:36.312 - debug: influxdb.0 (27441) Point written to iobroker
2023-06-04 10:28:46.736 - debug: influxdb.0 (27441) PING OK
2023-06-04 10:29:01.307 - debug: influxdb.0 (27441) Incoming message getHistory from system.adapter.ws.0
2023-06-04 10:29:01.311 - debug: influxdb.0 (27441) hm-rpc.0.LEQ0098583.1.TEMPERATURE16858673413100.23218176139810565 getHistory message: {"id":"hm-rpc.0.LEQ0098583.1.TEMPERATURE","options":{"start":1685780958116,"end":1685867358116,"aggregate":"minmax","from":false,"ack":false,"q":false,"addID":false,"step":300000,"instance":"system.adapter.influxdb.0","sessionId":3,"user":"system.user.admin"}}
2023-06-04 10:29:01.314 - debug: influxdb.0 (27441) Query to execute:
from(bucket: "iobroker")
|> range(start: 2023-06-03T08:29:18.116Z, stop: 2023-06-04T08:29:18.116Z)
|> filter(fn: (r) => r["_measurement"] == "hm-rpc.0.LEQ0098583.1.TEMPERATURE" and contains(value: r._value, set: [true, false]))
|> pivot(rowKey:["_time"], columnKey: ["_field"], valueColumn: "_value")
|> group()
2023-06-04 10:29:01.326 - debug: influxdb.0 (27441) Write Point: LichtsensorWest values:{"value":5.12,"time":"2023-06-04T08:29:01.310Z","from":"system.adapter.hm-rpc.0","q":0,"ack":true} options: null
2023-06-04 10:29:01.361 - debug: influxdb.0 (27441) Point written to iobroker
2023-06-04 10:29:01.371 - debug: influxdb.0 (27441) Query to execute: from(bucket: "iobroker")
|> range(start: 2022-12-02T08:29:18.116Z, stop: 2023-06-03T08:29:18.115Z)
|> filter(fn: (r) => r["_measurement"] == "hm-rpc.0.LEQ0098583.1.TEMPERATURE")
|> pivot(rowKey:["_time"], columnKey: ["_field"], valueColumn: "_value")
|> group()
|> sort(columns: ["_time"], desc: true)
|> limit(n: 1)
2023-06-04 10:29:01.732 - debug: influxdb.0 (27441) PING OK
2023-06-04 10:29:02.316 - debug: influxdb.0 (27441) Query to execute: from(bucket: "iobroker") |> range(start: 2023-06-03T08:29:18.116Z, stop: 2023-06-04T08:29:18.116Z) |> filter(fn: (r) => r["_measurement"] == "hm-rpc.0.LEQ0098583.1.TEMPERATURE") |> pivot(rowKey:["_time"], columnKey: ["_field"], valueColumn: "_value") |> sort(columns:["_time"], desc: false)
2023-06-04 10:29:02.372 - debug: influxdb.0 (27441) Query to execute: from(bucket: "iobroker")
|> range(start: 2023-06-04T08:29:18.117Z)
|> filter(fn: (r) => r["_measurement"] == "hm-rpc.0.LEQ0098583.1.TEMPERATURE")
|> pivot(rowKey:["_time"], columnKey: ["_field"], valueColumn: "_value")
|> group()
|> sort(columns: ["_time"], desc: false)
|> limit(n: 1)
2023-06-04 10:29:02.413 - debug: influxdb.0 (27441) Send: 421 of: 422 in: 1103ms
2023-06-04 10:29:02.529 - debug: influxdb.0 (27441) Incoming message getHistory from system.adapter.ws.0
2023-06-04 10:29:02.529 - debug: influxdb.0 (27441) hm-rpc.0.KEQ1058846.1.TEMPERATURE16858673425290.0912978969331606 getHistory message: {"id":"hm-rpc.0.KEQ1058846.1.TEMPERATURE","options":{"start":1685780958116,"end":1685867358116,"aggregate":"minmax","from":false,"ack":false,"q":false,"addID":false,"step":300000,"instance":"system.adapter.influxdb.0","sessionId":3,"user":"system.user.admin"}}
2023-06-04 10:29:02.533 - debug: influxdb.0 (27441) Query to execute:
from(bucket: "iobroker")
|> range(start: 2023-06-03T08:29:18.116Z, stop: 2023-06-04T08:29:18.116Z)
|> filter(fn: (r) => r["_measurement"] == "hm-rpc.0.KEQ1058846.1.TEMPERATURE" and contains(value: r._value, set: [true, false]))
|> pivot(rowKey:["_time"], columnKey: ["_field"], valueColumn: "_value")
|> group()
2023-06-04 10:29:02.560 - debug: influxdb.0 (27441) Query to execute: from(bucket: "iobroker")
|> range(start: 2022-12-02T08:29:18.116Z, stop: 2023-06-03T08:29:18.115Z)
|> filter(fn: (r) => r["_measurement"] == "hm-rpc.0.KEQ1058846.1.TEMPERATURE")
|> pivot(rowKey:["_time"], columnKey: ["_field"], valueColumn: "_value")
|> group()
|> sort(columns: ["_time"], desc: true)
|> limit(n: 1)
2023-06-04 10:29:02.939 - debug: influxdb.0 (27441) Query to execute: from(bucket: "iobroker") |> range(start: 2023-06-03T08:29:18.116Z, stop: 2023-06-04T08:29:18.116Z) |> filter(fn: (r) => r["_measurement"] == "hm-rpc.0.KEQ1058846.1.TEMPERATURE") |> pivot(rowKey:["_time"], columnKey: ["_field"], valueColumn: "_value") |> sort(columns:["_time"], desc: false)
2023-06-04 10:29:02.971 - debug: influxdb.0 (27441) Query to execute: from(bucket: "iobroker")
|> range(start: 2023-06-04T08:29:18.117Z)
|> filter(fn: (r) => r["_measurement"] == "hm-rpc.0.KEQ1058846.1.TEMPERATURE")
|> pivot(rowKey:["_time"], columnKey: ["_field"], valueColumn: "_value")
|> group()
|> sort(columns: ["_time"], desc: false)
|> limit(n: 1)
2023-06-04 10:29:02.994 - debug: influxdb.0 (27441) Send: 129 of: 128 in: 465ms
2023-06-04 10:29:03.041 - debug: influxdb.0 (27441) Incoming message getHistory from system.adapter.ws.0
2023-06-04 10:29:03.041 - debug: influxdb.0 (27441) hm-rpc.0.LEQ0098583.1.HUMIDITY16858673430410.00034191283601558986 getHistory message: {"id":"hm-rpc.0.LEQ0098583.1.HUMIDITY","options":{"start":1685780958116,"end":1685867358116,"aggregate":"minmax","from":false,"ack":false,"q":false,"addID":false,"step":300000,"instance":"system.adapter.influxdb.0","sessionId":3,"user":"system.user.admin"}}
2023-06-04 10:29:03.042 - debug: influxdb.0 (27441) Query to execute:
from(bucket: "iobroker")
|> range(start: 2023-06-03T08:29:18.116Z, stop: 2023-06-04T08:29:18.116Z)
|> filter(fn: (r) => r["_measurement"] == "Luftfeuchtigkeit_außen" and contains(value: r._value, set: [true, false]))
|> pivot(rowKey:["_time"], columnKey: ["_field"], valueColumn: "_value")
|> group()
2023-06-04 10:29:03.077 - debug: influxdb.0 (27441) Query to execute: from(bucket: "iobroker")
|> range(start: 2022-12-02T08:29:18.116Z, stop: 2023-06-03T08:29:18.115Z)
|> filter(fn: (r) => r["_measurement"] == "Luftfeuchtigkeit_außen")
|> pivot(rowKey:["_time"], columnKey: ["_field"], valueColumn: "_value")
|> group()
|> sort(columns: ["_time"], desc: true)
|> limit(n: 1)
2023-06-04 10:29:03.280 - debug: influxdb.0 (27441) Query to execute: from(bucket: "iobroker") |> range(start: 2023-06-03T08:29:18.116Z, stop: 2023-06-04T08:29:18.116Z) |> filter(fn: (r) => r["_measurement"] == "Luftfeuchtigkeit_außen") |> pivot(rowKey:["_time"], columnKey: ["_field"], valueColumn: "_value") |> sort(columns:["_time"], desc: false)
2023-06-04 10:29:03.313 - debug: influxdb.0 (27441) Query to execute: from(bucket: "iobroker")
|> range(start: 2023-06-04T08:29:18.117Z)
|> filter(fn: (r) => r["_measurement"] == "Luftfeuchtigkeit_außen")
|> pivot(rowKey:["_time"], columnKey: ["_field"], valueColumn: "_value")
|> group()
|> sort(columns: ["_time"], desc: false)
|> limit(n: 1)
2023-06-04 10:29:03.336 - debug: influxdb.0 (27441) Send: 309 of: 308 in: 295ms
2023-06-04 10:29:16.732 - debug: influxdb.0 (27441) PING OK
2023-06-04 10:29:31.732 - debug: influxdb.0 (27441) PING OK
2023-06-04 10:29:46.732 - debug: influxdb.0 (27441) PING OK
2023-06-04 10:29:55.747 - debug: influxdb.0 (27441) Write Point: Entfeuchtersteckdose values:{"value":0,"time":"2023-06-04T08:29:55.737Z","from":"system.adapter.hm-rpc.0","q":0,"ack":true} options: null
2023-06-04 10:29:55.763 - debug: influxdb.0 (27441) Point written to iobroker
2023-06-04 10:29:59.240 - debug: influxdb.0 (27441) new value received for Schimmelsensor (storageType false), new-value=62, ts=1685867399228, relog=false
2023-06-04 10:29:59.241 - debug: influxdb.0 (27441) value ignored blockTime Schimmelsensor, value=62, ts=1685867399228, lastState.ts=1685867226900, blockTime=300000
2023-06-04 10:30:00.126 - debug: influxdb.0 (27441) Write Point: Gasverbrauch4XViertelstunde values:{"value":0.48,"time":"2023-06-04T08:29:59.000Z","from":"system.adapter.statistics.0","q":0,"ack":true} options: null
2023-06-04 10:30:00.141 - debug: influxdb.0 (27441) Point written to iobroker
2023-06-04 10:30:01.732 - debug: influxdb.0 (27441) PING OK
2023-06-04 10:30:07.644 - debug: influxdb.0 (27441) new value received for Schimmelsensor (storageType false), new-value=62, ts=1685867407631, relog=false
2023-06-04 10:30:07.644 - debug: influxdb.0 (27441) value ignored blockTime Schimmelsensor, value=62, ts=1685867407631, lastState.ts=1685867226900, blockTime=300000
2023-06-04 10:30:11.850 - debug: influxdb.0 (27441) new value received for Schimmelsensor (storageType false), new-value=62, ts=1685867411842, relog=false
2023-06-04 10:30:11.851 - debug: influxdb.0 (27441) value ignored blockTime Schimmelsensor, value=62, ts=1685867411842, lastState.ts=1685867226900, blockTime=300000
2023-06-04 10:30:12.538 - info: admin.0 (1289) ==> Connected system.user.admin from ::ffff:192.168.178.20
2023-06-04 10:30:16.732 - debug: influxdb.0 (27441) PING OK
2023-06-04 10:30:31.734 - debug: influxdb.0 (27441) PING OK
2023-06-04 10:30:46.733 - debug: influxdb.0 (27441) PING OK
2023-06-04 10:30:50.059 - debug: influxdb.0 (27441) Write Point: WorxWirdGeladen values:{"value":false,"time":"2023-06-04T08:30:50.007Z","from":"system.adapter.worx.0","q":0,"ack":true} options: null
2023-06-04 10:30:50.069 - debug: influxdb.0 (27441) Write Point: WorxTemperatur values:{"value":14.3,"time":"2023-06-04T08:30:50.008Z","from":"system.adapter.worx.0","q":0,"ack":true} options: null
2023-06-04 10:30:50.078 - debug: influxdb.0 (27441) Point written to iobroker
2023-06-04 10:30:50.086 - debug: influxdb.0 (27441) Write Point: WorxWifiQuality values:{"value":-50,"time":"2023-06-04T08:30:50.009Z","from":"system.adapter.worx.0","q":0,"ack":true} options: null
2023-06-04 10:30:50.090 - debug: influxdb.0 (27441) Point written to iobroker
2023-06-04 10:30:50.103 - debug: influxdb.0 (27441) Point written to iobroker
2023-06-04 10:30:53.871 - debug: influxdb.0 (27441) new value received for Schimmelsensor (storageType false), new-value=62, ts=1685867453865, relog=false
2023-06-04 10:30:53.872 - debug: influxdb.0 (27441) value ignored blockTime Schimmelsensor, value=62, ts=1685867453865, lastState.ts=1685867226900, blockTime=300000
2023-06-04 10:30:55.075 - debug: influxdb.0 (27441) Write Point: hm-rpc.0.LEQ0098583.1.TEMPERATURE values:{"value":18.8,"time":"2023-06-04T08:30:55.068Z","from":"system.adapter.hm-rpc.0","q":0,"ack":true} options: null
2023-06-04 10:30:55.087 - debug: influxdb.0 (27441) Write Point: Luftfeuchtigkeit_außen values:{"value":59,"time":"2023-06-04T08:30:55.068Z","from":"system.adapter.hm-rpc.0","q":0,"ack":true} options: null
2023-06-04 10:30:55.103 - debug: influxdb.0 (27441) Point written to iobroker
2023-06-04 10:30:55.118 - debug: influxdb.0 (27441) Point written to iobroker
2023-06-04 10:31:01.234 - debug: influxdb.0 (27441) Incoming message getHistory from system.adapter.ws.0
2023-06-04 10:31:01.234 - debug: influxdb.0 (27441) hm-rpc.0.LEQ0098583.1.TEMPERATURE16858674612340.4441766026368563 getHistory message: {"id":"hm-rpc.0.LEQ0098583.1.TEMPERATURE","options":{"start":1685781078113,"end":1685867478113,"aggregate":"minmax","from":false,"ack":false,"q":false,"addID":false,"step":300000,"instance":"system.adapter.influxdb.0","sessionId":4,"user":"system.user.admin"}}
2023-06-04 10:31:01.236 - debug: influxdb.0 (27441) Query to execute:
from(bucket: "iobroker")
|> range(start: 2023-06-03T08:31:18.113Z, stop: 2023-06-04T08:31:18.113Z)
|> filter(fn: (r) => r["_measurement"] == "hm-rpc.0.LEQ0098583.1.TEMPERATURE" and contains(value: r._value, set: [true, false]))
|> pivot(rowKey:["_time"], columnKey: ["_field"], valueColumn: "_value")
|> group()
2023-06-04 10:31:01.299 - debug: influxdb.0 (27441) Query to execute: from(bucket: "iobroker")
|> range(start: 2022-12-02T08:31:18.113Z, stop: 2023-06-03T08:31:18.112Z)
|> filter(fn: (r) => r["_measurement"] == "hm-rpc.0.LEQ0098583.1.TEMPERATURE")
|> pivot(rowKey:["_time"], columnKey: ["_field"], valueColumn: "_value")
|> group()
|> sort(columns: ["_time"], desc: true)
|> limit(n: 1)
2023-06-04 10:31:01.734 - debug: influxdb.0 (27441) PING OK
2023-06-04 10:31:02.202 - debug: influxdb.0 (27441) Query to execute: from(bucket: "iobroker") |> range(start: 2023-06-03T08:31:18.113Z, stop: 2023-06-04T08:31:18.113Z) |> filter(fn: (r) => r["_measurement"] == "hm-rpc.0.LEQ0098583.1.TEMPERATURE") |> pivot(rowKey:["_time"], columnKey: ["_field"], valueColumn: "_value") |> sort(columns:["_time"], desc: false)
2023-06-04 10:31:02.268 - debug: influxdb.0 (27441) Query to execute: from(bucket: "iobroker")
|> range(start: 2023-06-04T08:31:18.114Z)
|> filter(fn: (r) => r["_measurement"] == "hm-rpc.0.LEQ0098583.1.TEMPERATURE")
|> pivot(rowKey:["_time"], columnKey: ["_field"], valueColumn: "_value")
|> group()
|> sort(columns: ["_time"], desc: false)
|> limit(n: 1)
2023-06-04 10:31:02.309 - debug: influxdb.0 (27441) Send: 420 of: 423 in: 1075ms
2023-06-04 10:31:02.451 - debug: influxdb.0 (27441) Incoming message getHistory from system.adapter.ws.0
2023-06-04 10:31:02.452 - debug: influxdb.0 (27441) hm-rpc.0.KEQ1058846.1.TEMPERATURE16858674624520.7897058406560344 getHistory message: {"id":"hm-rpc.0.KEQ1058846.1.TEMPERATURE","options":{"start":1685781078113,"end":1685867478113,"aggregate":"minmax","from":false,"ack":false,"q":false,"addID":false,"step":300000,"instance":"system.adapter.influxdb.0","sessionId":4,"user":"system.user.admin"}}
2023-06-04 10:31:02.456 - debug: influxdb.0 (27441) Query to execute:
from(bucket: "iobroker")
|> range(start: 2023-06-03T08:31:18.113Z, stop: 2023-06-04T08:31:18.113Z)
|> filter(fn: (r) => r["_measurement"] == "hm-rpc.0.KEQ1058846.1.TEMPERATURE" and contains(value: r._value, set: [true, false]))
|> pivot(rowKey:["_time"], columnKey: ["_field"], valueColumn: "_value")
|> group()
2023-06-04 10:31:02.482 - debug: influxdb.0 (27441) Query to execute: from(bucket: "iobroker")
|> range(start: 2022-12-02T08:31:18.113Z, stop: 2023-06-03T08:31:18.112Z)
|> filter(fn: (r) => r["_measurement"] == "hm-rpc.0.KEQ1058846.1.TEMPERATURE")
|> pivot(rowKey:["_time"], columnKey: ["_field"], valueColumn: "_value")
|> group()
|> sort(columns: ["_time"], desc: true)
|> limit(n: 1)
2023-06-04 10:31:02.871 - debug: influxdb.0 (27441) Query to execute: from(bucket: "iobroker") |> range(start: 2023-06-03T08:31:18.113Z, stop: 2023-06-04T08:31:18.113Z) |> filter(fn: (r) => r["_measurement"] == "hm-rpc.0.KEQ1058846.1.TEMPERATURE") |> pivot(rowKey:["_time"], columnKey: ["_field"], valueColumn: "_value") |> sort(columns:["_time"], desc: false)
2023-06-04 10:31:02.899 - debug: influxdb.0 (27441) Query to execute: from(bucket: "iobroker")
|> range(start: 2023-06-04T08:31:18.114Z)
|> filter(fn: (r) => r["_measurement"] == "hm-rpc.0.KEQ1058846.1.TEMPERATURE")
|> pivot(rowKey:["_time"], columnKey: ["_field"], valueColumn: "_value")
|> group()
|> sort(columns: ["_time"], desc: false)
|> limit(n: 1)
2023-06-04 10:31:02.920 - debug: influxdb.0 (27441) Send: 128 of: 127 in: 468ms
2023-06-04 10:31:02.952 - debug: influxdb.0 (27441) Incoming message getHistory from system.adapter.ws.0
2023-06-04 10:31:02.953 - debug: influxdb.0 (27441) hm-rpc.0.LEQ0098583.1.HUMIDITY16858674629520.7158808768072216 getHistory message: {"id":"hm-rpc.0.LEQ0098583.1.HUMIDITY","options":{"start":1685781078113,"end":1685867478113,"aggregate":"minmax","from":false,"ack":false,"q":false,"addID":false,"step":300000,"instance":"system.adapter.influxdb.0","sessionId":4,"user":"system.user.admin"}}
2023-06-04 10:31:02.953 - debug: influxdb.0 (27441) Query to execute:
from(bucket: "iobroker")
|> range(start: 2023-06-03T08:31:18.113Z, stop: 2023-06-04T08:31:18.113Z)
|> filter(fn: (r) => r["_measurement"] == "Luftfeuchtigkeit_außen" and contains(value: r._value, set: [true, false]))
|> pivot(rowKey:["_time"], columnKey: ["_field"], valueColumn: "_value")
|> group()
2023-06-04 10:31:02.989 - debug: influxdb.0 (27441) Query to execute: from(bucket: "iobroker")
|> range(start: 2022-12-02T08:31:18.113Z, stop: 2023-06-03T08:31:18.112Z)
|> filter(fn: (r) => r["_measurement"] == "Luftfeuchtigkeit_außen")
|> pivot(rowKey:["_time"], columnKey: ["_field"], valueColumn: "_value")
|> group()
|> sort(columns: ["_time"], desc: true)
|> limit(n: 1)
2023-06-04 10:31:03.195 - debug: influxdb.0 (27441) Query to execute: from(bucket: "iobroker") |> range(start: 2023-06-03T08:31:18.113Z, stop: 2023-06-04T08:31:18.113Z) |> filter(fn: (r) => r["_measurement"] == "Luftfeuchtigkeit_außen") |> pivot(rowKey:["_time"], columnKey: ["_field"], valueColumn: "_value") |> sort(columns:["_time"], desc: false)
2023-06-04 10:31:03.228 - debug: influxdb.0 (27441) Query to execute: from(bucket: "iobroker")
|> range(start: 2023-06-04T08:31:18.114Z)
|> filter(fn: (r) => r["_measurement"] == "Luftfeuchtigkeit_außen")
|> pivot(rowKey:["_time"], columnKey: ["_field"], valueColumn: "_value")
|> group()
|> sort(columns: ["_time"], desc: false)
|> limit(n: 1)
2023-06-04 10:31:03.254 - debug: influxdb.0 (27441) Send: 308 of: 309 in: 302ms
2023-06-04 10:31:16.733 - debug: influxdb.0 (27441) PING OK
2023-06-04 10:31:19.103 - debug: influxdb.0 (27441) new value received for Schimmelsensor (storageType false), new-value=62, ts=1685867479086, relog=false
2023-06-04 10:31:19.103 - debug: influxdb.0 (27441) value ignored blockTime Schimmelsensor, value=62, ts=1685867479086, lastState.ts=1685867226900, blockTime=300000
2023-06-04 10:31:22.359 - debug: influxdb.0 (27441) Write Point: parser.0.Leistung values:{"value":540,"time":"2023-06-04T08:31:22.353Z","from":"system.adapter.parser.0","q":0,"ack":true} options: null
2023-06-04 10:31:22.370 - debug: influxdb.0 (27441) Point written to iobroker
2023-06-04 10:31:31.733 - debug: influxdb.0 (27441) PING OK
2023-06-04 10:31:37.768 - debug: influxdb.0 (27441) Write Point: LichtsensorSüd values:{"value":34.99,"time":"2023-06-04T08:31:37.732Z","from":"system.adapter.hm-rpc.0","q":0,"ack":true} options: null
2023-06-04 10:31:37.802 - debug: influxdb.0 (27441) Point written to iobroker
2023-06-04 10:31:40.148 - debug: influxdb.0 (27441) new value received for Schimmelsensor (storageType false), new-value=62, ts=1685867500137, relog=false
2023-06-04 10:31:40.149 - debug: influxdb.0 (27441) value ignored blockTime Schimmelsensor, value=62, ts=1685867500137, lastState.ts=1685867226900, blockTime=300000
2023-06-04 10:31:41.231 - debug: influxdb.0 (27441) Write Point: LichtsensorOst values:{"value":43.78,"time":"2023-06-04T08:31:41.195Z","from":"system.adapter.hm-rpc.0","q":0,"ack":true} options: null
2023-06-04 10:31:41.251 - debug: influxdb.0 (27441) Point written to iobroker
2023-06-04 10:31:46.733 - debug: influxdb.0 (27441) PING OK
2023-06-04 10:31:52.736 - debug: influxdb.0 (27441) new value received for Schimmelsensor (storageType false), new-value=62, ts=1685867512721, relog=false
2023-06-04 10:31:52.736 - debug: influxdb.0 (27441) value ignored blockTime Schimmelsensor, value=62, ts=1685867512721, lastState.ts=1685867226900, blockTime=300000
2023-06-04 10:32:01.129 - debug: influxdb.0 (27441) new value received for Schimmelsensor (storageType false), new-value=62, ts=1685867521113, relog=false
2023-06-04 10:32:01.130 - debug: influxdb.0 (27441) value ignored blockTime Schimmelsensor, value=62, ts=1685867521113, lastState.ts=1685867226900, blockTime=300000
2023-06-04 10:32:01.733 - debug: influxdb.0 (27441) PING OK
2023-06-04 10:32:01.962 - debug: influxdb.0 (27441) Incoming message getHistory from system.adapter.ws.0
2023-06-04 10:32:01.963 - debug: influxdb.0 (27441) statistics.0.temp.sumCount.0_userdata.0.friedhelm.Wetter.Regenmesser.RegenmesserFlanke.hour16858675219630.30551674374094917 getHistory message: {"id":"statistics.0.temp.sumCount.0_userdata.0.friedhelm.Wetter.Regenmesser.RegenmesserFlanke.hour","options":{"start":1685781138849,"end":1685867538849,"aggregate":"max","from":false,"ack":false,"q":false,"addID":false,"step":360000,"instance":"system.adapter.influxdb.0","sessionId":3,"user":"system.user.admin"}}
2023-06-04 10:32:01.965 - debug: influxdb.0 (27441) Query to execute:
from(bucket: "iobroker")
|> range(start: 2023-06-03T08:26:18.849Z, stop: 2023-06-04T08:38:18.849Z)
|> filter(fn: (r) => r["_measurement"] == "statistics.0.temp.sumCount.0_userdata.0.friedhelm.Wetter.Regenmesser.RegenmesserFlanke.hour" and contains(value: r._value, set: [true, false]))
|> pivot(rowKey:["_time"], columnKey: ["_field"], valueColumn: "_value")
|> group()
2023-06-04 10:32:01.986 - debug: influxdb.0 (27441) Query to execute: from(bucket: "iobroker")
|> range(start: 2022-12-02T08:26:18.849Z, stop: 2023-06-03T08:26:18.848Z)
|> filter(fn: (r) => r["_measurement"] == "statistics.0.temp.sumCount.0_userdata.0.friedhelm.Wetter.Regenmesser.RegenmesserFlanke.hour")
|> pivot(rowKey:["_time"], columnKey: ["_field"], valueColumn: "_value")
|> group()
|> sort(columns: ["_time"], desc: true)
|> limit(n: 1)
2023-06-04 10:32:02.053 - debug: influxdb.0 (27441) Query to execute: from(bucket: "iobroker") |> range(start: 2023-06-03T08:26:18.849Z, stop: 2023-06-04T08:38:18.849Z) |> filter(fn: (r) => r["_measurement"] == "statistics.0.temp.sumCount.0_userdata.0.friedhelm.Wetter.Regenmesser.RegenmesserFlanke.hour") |> pivot(rowKey:["_time"], columnKey: ["_field"], valueColumn: "_value") |> window(every: 360000ms)|> fill(column: "value", usePrevious: true) |> sort(columns:["_time"], desc: false) |> max(column: "value")
2023-06-04 10:32:02.093 - debug: influxdb.0 (27441) Query to execute: from(bucket: "iobroker")
|> range(start: 2023-06-04T08:38:18.850Z)
|> filter(fn: (r) => r["_measurement"] == "statistics.0.temp.sumCount.0_userdata.0.friedhelm.Wetter.Regenmesser.RegenmesserFlanke.hour")
|> pivot(rowKey:["_time"], columnKey: ["_field"], valueColumn: "_value")
|> group()
|> sort(columns: ["_time"], desc: false)
|> limit(n: 1)
2023-06-04 10:32:02.130 - debug: influxdb.0 (27441) Send: 3 of: 2 in: 166ms
2023-06-04 10:32:02.146 - debug: influxdb.0 (27441) Incoming message getHistory from system.adapter.ws.0
2023-06-04 10:32:02.148 - debug: influxdb.0 (27441) hm-rpc.0.UNISENS003.1.AIR_PRESSURE16858675221470.24691531353172524 getHistory message: {"id":"hm-rpc.0.UNISENS003.1.AIR_PRESSURE","options":{"start":1685781138849,"end":1685867538849,"aggregate":"average","from":false,"ack":false,"q":false,"addID":false,"step":360000,"instance":"system.adapter.influxdb.0","sessionId":3,"user":"system.user.admin"}}
2023-06-04 10:32:02.155 - debug: influxdb.0 (27441) Query to execute:
from(bucket: "iobroker")
|> range(start: 2023-06-03T08:26:18.849Z, stop: 2023-06-04T08:38:18.849Z)
|> filter(fn: (r) => r["_measurement"] == "Luftdruck" and contains(value: r._value, set: [true, false]))
|> pivot(rowKey:["_time"], columnKey: ["_field"], valueColumn: "_value")
|> group()
2023-06-04 10:32:02.188 - debug: influxdb.0 (27441) Query to execute: from(bucket: "iobroker")
|> range(start: 2022-12-02T08:26:18.849Z, stop: 2023-06-03T08:26:18.848Z)
|> filter(fn: (r) => r["_measurement"] == "Luftdruck")
|> pivot(rowKey:["_time"], columnKey: ["_field"], valueColumn: "_value")
|> group()
|> sort(columns: ["_time"], desc: true)
|> limit(n: 1)
2023-06-04 10:32:03.230 - debug: influxdb.0 (27441) Query to execute: from(bucket: "iobroker") |> range(start: 2023-06-03T08:26:18.849Z, stop: 2023-06-04T08:38:18.849Z) |> filter(fn: (r) => r["_measurement"] == "Luftdruck") |> pivot(rowKey:["_time"], columnKey: ["_field"], valueColumn: "_value") |> window(every: 360000ms)|> fill(column: "value", usePrevious: true) |> sort(columns:["_time"], desc: false) |> mean(column: "value")
2023-06-04 10:32:03.300 - debug: influxdb.0 (27441) Query to execute: from(bucket: "iobroker")
|> range(start: 2023-06-04T08:38:18.850Z)
|> filter(fn: (r) => r["_measurement"] == "Luftdruck")
|> pivot(rowKey:["_time"], columnKey: ["_field"], valueColumn: "_value")
|> group()
|> sort(columns: ["_time"], desc: false)
|> limit(n: 1)
2023-06-04 10:32:03.319 - debug: influxdb.0 (27441) Send: 180 of: 179 in: 1172ms
2023-06-04 10:32:03.334 - debug: influxdb.0 (27441) Incoming message getHistory from system.adapter.ws.0
2023-06-04 10:32:03.334 - debug: influxdb.0 (27441) alias.0.Wetter.Regen.Regensensor16858675233340.3555169301118837 getHistory message: {"id":"alias.0.Wetter.Regen.Regensensor","options":{"start":1685781138849,"end":1685867538849,"aggregate":"onchange","from":false,"ack":false,"q":false,"addID":false,"step":360000,"instance":"system.adapter.influxdb.0","sessionId":3,"user":"system.user.admin"}}
2023-06-04 10:32:03.336 - debug: influxdb.0 (27441) Query to execute:
from(bucket: "iobroker")
|> range(start: 2023-06-03T08:32:18.849Z, stop: 2023-06-04T08:32:18.849Z)
|> filter(fn: (r) => r["_measurement"] == "Regensensor" and contains(value: r._value, set: [true, false]))
|> pivot(rowKey:["_time"], columnKey: ["_field"], valueColumn: "_value")
|> group()
2023-06-04 10:32:03.360 - debug: influxdb.0 (27441) Query to execute: from(bucket: "iobroker")
|> range(start: 2022-12-02T08:32:18.849Z, stop: 2023-06-03T08:32:18.848Z)
|> filter(fn: (r) => r["_measurement"] == "Regensensor")
|> pivot(rowKey:["_time"], columnKey: ["_field"], valueColumn: "_value")
|> group()
|> sort(columns: ["_time"], desc: true)
|> limit(n: 1)
2023-06-04 10:32:03.399 - debug: influxdb.0 (27441) Query to execute: from(bucket: "iobroker") |> range(start: 2023-06-03T08:32:18.849Z, stop: 2023-06-04T08:32:18.849Z) |> filter(fn: (r) => r["_measurement"] == "Regensensor") |> pivot(rowKey:["_time"], columnKey: ["_field"], valueColumn: "_value") |> group() |> sort(columns:["_time"], desc: false) |> limit(n: 500)
2023-06-04 10:32:03.422 - debug: influxdb.0 (27441) Query to execute: from(bucket: "iobroker")
|> range(start: 2023-06-04T08:32:18.850Z)
|> filter(fn: (r) => r["_measurement"] == "Regensensor")
|> pivot(rowKey:["_time"], columnKey: ["_field"], valueColumn: "_value")
|> group()
|> sort(columns: ["_time"], desc: false)
|> limit(n: 1)
2023-06-04 10:32:03.442 - debug: influxdb.0 (27441) Send: 27 of: 26 in: 108ms
2023-06-04 10:32:05.332 - debug: influxdb.0 (27441) new value received for Schimmelsensor (storageType false), new-value=62, ts=1685867525325, relog=false
2023-06-04 10:32:05.332 - debug: influxdb.0 (27441) value ignored blockTime Schimmelsensor, value=62, ts=1685867525325, lastState.ts=1685867226900, blockTime=300000

[iobroker2001]

Halt, ich sehe in der InfluxDB aktuell (11:07 Uhr = 09:07Z Uhr) aber folgende Daten:

0 Schimmelsensor value 59 2023-06-04T08:12:24.240Z
0 Schimmelsensor value 60 2023-06-04T08:12:32.632Z
0 Schimmelsensor value 60 2023-06-04T08:20:27.596Z
0 Schimmelsensor value 61 2023-06-04T08:20:44.401Z
0 Schimmelsensor value 62 2023-06-04T08:32:09.525Z
0 Schimmelsensor value 62 2023-06-04T08:39:09.835Z
0 Schimmelsensor value 62 2023-06-04T08:44:33.473Z
0 Schimmelsensor value 62 2023-06-04T08:55:54.391Z
0 Schimmelsensor value 63 2023-06-04T08:56:23.815Z
0 Schimmelsensor value 63 2023-06-04T09:07:27.901Z

Und der Fehler ist auch im Objekt sichtbar:

[Marc Berg]

@iobroker2001 aktiviere mal noch diesen Haken:

Ansonsten wird vor einer Änderung des Wertes nochmals der alte Wert geschrieben, und dann könnte es sein, dass die Blockzeit ignoriert wird.

[iobroker2001]

@marc-berg sagte in InfluxDB: Blockzeit Verständnisproblem:

Blockzeit

Das hat leider keine Wirkung, auch nicht nach Neustart des InfluxDB-Adapters:

[Marc Berg]

@iobroker2001

Nein, die Einträge, die mit "system..." beginnen, wurden noch nicht in die DB geschrieben und warten quasi noch darauf, durch die festgelegten Regeln zu laufen! Also einfach mal noch ein paar Sekunden warten.

[Homoran]

@iobroker2001 die markierten Daten sind Echtzeitdaten, die während das Fenster offen ist, zwar in der Liste erscheinen, aber nicht gespeichert werden!

Bitte Fenster schließen und neu öffnen, dann sollten sie weg sein.

[iobroker2001]

@homoran und @Marc-Berg :

Tschuldigung, das hatte ich noch nicht gewusst!

Ja, das sieht schon anders aus:
Der letzte Wert um 17:17:45 wird tatsächlich beim Verlassen/Neustart des Fensters entfernt.

Den Haken hatte ich gegen 16:50 Uhr gesetzt, und bis jetzt ist kein Wert doppelt geschrieben worden.
Dann werde ich den Haken mal überall da bei den Datenpunkten setzen und als Grundeinstellung in den Adaptereinstellungen.

Falls keine weiteren Fehler auftauchen, sage ich schon einmal vielen Dank!

[Marc Berg]

@iobroker2001 sagte in InfluxDB: Blockzeit Verständnisproblem:

Ja, das sieht schon anders aus:
Der letzte Wert um 17:17:45 wird tatsächlich beim Verlassen/Neustart des Fensters entfernt.

Hmm, wenn ich bei mir das History-Fenster offen lasse, dann erfolgt nach ca. 30 Sekunden ein automatischer Refresh.

Egal. Hauptsache, der Fehler ist weg..

[iobroker2001]

@marc-berg Ja, stimmt, bei mir frischt sich das Fenster auch nach einer Zeit auf.

Jetzt habe ich leider noch eine Frage:
Ich habe ja "Nur Änderungen aufzeichnen" angehakt, aber trotzdem sehe ich noch doppelte Werte, z. B. hier die 70 %:

Kann es sein, dass diese Werte doch geschrieben werden, weil zwischendurch andere Werte durch die Blockzeit weggefallen sind und deshalb nicht mehr sichtbar sind?
Also meine Vermutung im Beispiel: die fetten Werte liegen innerhalb der Blockzeit, werden unterdrückt/nicht sichtbar, und übrig bleiben die beiden nichtfetten 70-%-Werte.

70 69 70 69 70
|------ Blockzeit-------|

[Marc Berg]

@iobroker2001 sagte in [gelöst] InfluxDB: Blockzeit Verständnisproblem:

Also meine Vermutung im Beispiel: die fetten Werte liegen innerhalb der Blockzeit, werden unterdrückt/nicht sichtbar, und übrig bleiben die beiden nichtfetten 70-%-Werte.

Das kann sein, ich kenne die Logik dahinter nicht, kann mir aber vorstellen, dass das alles andere als trivial ist. Vielleicht schlägt ja auch die Einstellung "trotzdem gleiche Werte aufzeichnen" zu.

Ich bin auch kein Fan von dieser Blockierzeit-Einstellung. Stattdessen arbeite ich lieber mit der Einstellung "nur Änderungen aufzeichnen" und drehe den Wert "minimale Differenz" etwas höher (in deinem Beispiel vielleicht auf 2-3%). Dann gehen zwar ein paar Zwischenwerte verloren, aber das liegt wahrscheinlich unterhalb der Messgenauigkeit.
Vorteil ist, dass auch kurzfristige größere Schwankungen aufgezeichnet werden, die sonst durch die Blockierzeit im Nirwana landen würden.

[A Former User]

@iobroker2001 sagte in [gelöst] InfluxDB: Blockzeit Verständnisproblem:

Kann es sein, dass diese Werte doch geschrieben werden, weil zwischendurch andere Werte durch die Blockzeit weggefallen sind und deshalb nicht mehr sichtbar sind?

Moin,

so verstehe ich das jedenfalls, wenn ich mir den Text unterhalb der Einstellung Blockzeit durchlese, damit werden Werte, egal ob niedriger oder höher, in diesem Zeitfenster nicht berücksichtigt, im schlimmsten Fall verfälscht es Deine Auswertung.

Ich aggregiere auf der Anzeigenseite und falls zu viele Daten, dann mache ich auf der influxDB ein Downsampling der Daten, Stichwort Tasks → influxdb V2.x.

VG
Bernd

P.S.: oder halt sowie @Marc-Berg vorgeschlagen hat