QUERY: falscher zusätzlicher Datenpunkt in der Zukunft

[BernhardLinz]

Es gibt dazu bereits einen Issue beim ioBroker.echarts Adapter: https://github.com/ioBroker/ioBroker.echarts/issues/87 Ich denke das Problem kommt aber aus dem iobroker.influxdb Adapter heraus (oder aus InfluxDB selbst).

Beschreibung: Folgendes Skript, welches ich aus der Anleitung zum Adapter entnommen habe, fragt die Datensätze zu einem Datenpunkt ab. Als Zeitraum wird 30 Minuten in die Vergangenheit und 2h in die Zukunft angegeben:

var end = Date.now();
sendTo('influxdb.0', 'getHistory', {
    id: 'tuya.0.01507801e868e7553d50.3',
    options: {
        start:      end - 1800000,
        end:        end + 7200000,
        aggregate: 'onchange',
        addId: true
    }
}, function (result) {
    for (var i = 0; i < result.result.length; i++) {
        console.log(result.result[i].id + ' ' + result.result[i].val + " " + new Date(result.result[i].ts).toISOString());
    }
});

Die Ausgabe ist zum Beispiel wie folgt (Startzeit sieht man ja an den Loggingeinträgen):

2023-02-01 19:22:39.411  - info: javascript.1 (237231) Start javascript script.js.Tests.influxdb_test1
2023-02-01 19:22:39.431  - info: javascript.1 (237231) script.js.Tests.influxdb_test1: registered 0 subscriptions, 0 schedules, 0 messages, 0 logs and 0 file subscriptions
2023-02-01 19:22:42.930  - info: javascript.1 (237231) script.js.Tests.influxdb_test1: tuya.0.01507801e868e7553d50.3 59 2023-02-01T17:52:39.431Z
2023-02-01 19:22:42.931  - info: javascript.1 (237231) script.js.Tests.influxdb_test1: tuya.0.01507801e868e7553d50.3 59 2023-02-01T17:55:43.486Z
2023-02-01 19:22:42.931  - info: javascript.1 (237231) script.js.Tests.influxdb_test1: tuya.0.01507801e868e7553d50.3 58 2023-02-01T17:56:14.485Z
2023-02-01 19:22:42.932  - info: javascript.1 (237231) script.js.Tests.influxdb_test1: tuya.0.01507801e868e7553d50.3 57 2023-02-01T17:57:26.374Z
2023-02-01 19:22:42.932  - info: javascript.1 (237231) script.js.Tests.influxdb_test1: tuya.0.01507801e868e7553d50.3 58 2023-02-01T17:59:30.475Z
2023-02-01 19:22:42.933  - info: javascript.1 (237231) script.js.Tests.influxdb_test1: tuya.0.01507801e868e7553d50.3 57 2023-02-01T17:59:54.184Z
2023-02-01 19:22:42.933  - info: javascript.1 (237231) script.js.Tests.influxdb_test1: tuya.0.01507801e868e7553d50.3 58 2023-02-01T18:00:30.186Z
2023-02-01 19:22:42.933  - info: javascript.1 (237231) script.js.Tests.influxdb_test1: tuya.0.01507801e868e7553d50.3 56 2023-02-01T18:01:30.006Z
2023-02-01 19:22:42.933  - info: javascript.1 (237231) script.js.Tests.influxdb_test1: tuya.0.01507801e868e7553d50.3 56 2023-02-01T18:02:11.978Z
2023-02-01 19:22:42.934  - info: javascript.1 (237231) script.js.Tests.influxdb_test1: tuya.0.01507801e868e7553d50.3 57 2023-02-01T18:02:43.916Z
2023-02-01 19:22:42.934  - info: javascript.1 (237231) script.js.Tests.influxdb_test1: tuya.0.01507801e868e7553d50.3 57 2023-02-01T18:03:49.968Z
2023-02-01 19:22:42.934  - info: javascript.1 (237231) script.js.Tests.influxdb_test1: tuya.0.01507801e868e7553d50.3 56 2023-02-01T18:03:57.785Z
2023-02-01 19:22:42.934  - info: javascript.1 (237231) script.js.Tests.influxdb_test1: tuya.0.01507801e868e7553d50.3 57 2023-02-01T18:04:59.798Z
2023-02-01 19:22:42.934  - info: javascript.1 (237231) script.js.Tests.influxdb_test1: tuya.0.01507801e868e7553d50.3 57 2023-02-01T18:05:41.657Z
2023-02-01 19:22:42.934  - info: javascript.1 (237231) script.js.Tests.influxdb_test1: tuya.0.01507801e868e7553d50.3 56 2023-02-01T18:06:45.696Z
2023-02-01 19:22:42.934  - info: javascript.1 (237231) script.js.Tests.influxdb_test1: tuya.0.01507801e868e7553d50.3 55 2023-02-01T18:06:55.609Z
2023-02-01 19:22:42.934  - info: javascript.1 (237231) script.js.Tests.influxdb_test1: tuya.0.01507801e868e7553d50.3 55 2023-02-01T18:07:31.487Z
2023-02-01 19:22:42.934  - info: javascript.1 (237231) script.js.Tests.influxdb_test1: tuya.0.01507801e868e7553d50.3 55 2023-02-01T18:08:03.438Z
2023-02-01 19:22:42.935  - info: javascript.1 (237231) script.js.Tests.influxdb_test1: tuya.0.01507801e868e7553d50.3 55 2023-02-01T18:08:37.415Z
2023-02-01 19:22:42.935  - info: javascript.1 (237231) script.js.Tests.influxdb_test1: tuya.0.01507801e868e7553d50.3 55 2023-02-01T18:09:17.370Z
2023-02-01 19:22:42.935  - info: javascript.1 (237231) script.js.Tests.influxdb_test1: tuya.0.01507801e868e7553d50.3 55 2023-02-01T18:09:49.319Z
2023-02-01 19:22:42.935  - info: javascript.1 (237231) script.js.Tests.influxdb_test1: tuya.0.01507801e868e7553d50.3 55 2023-02-01T18:11:03.325Z
2023-02-01 19:22:42.935  - info: javascript.1 (237231) script.js.Tests.influxdb_test1: tuya.0.01507801e868e7553d50.3 54 2023-02-01T18:11:27.167Z
2023-02-01 19:22:42.935  - info: javascript.1 (237231) script.js.Tests.influxdb_test1: tuya.0.01507801e868e7553d50.3 54 2023-02-01T18:12:03.131Z
2023-02-01 19:22:42.935  - info: javascript.1 (237231) script.js.Tests.influxdb_test1: tuya.0.01507801e868e7553d50.3 55 2023-02-01T18:12:43.039Z
2023-02-01 19:22:42.935  - info: javascript.1 (237231) script.js.Tests.influxdb_test1: tuya.0.01507801e868e7553d50.3 54 2023-02-01T18:13:22.994Z
2023-02-01 19:22:42.935  - info: javascript.1 (237231) script.js.Tests.influxdb_test1: tuya.0.01507801e868e7553d50.3 54 2023-02-01T18:14:35.131Z
2023-02-01 19:22:42.936  - info: javascript.1 (237231) script.js.Tests.influxdb_test1: tuya.0.01507801e868e7553d50.3 55 2023-02-01T18:14:46.959Z
2023-02-01 19:22:42.936  - info: javascript.1 (237231) script.js.Tests.influxdb_test1: tuya.0.01507801e868e7553d50.3 53 2023-02-01T18:15:34.822Z
2023-02-01 19:22:42.936  - info: javascript.1 (237231) script.js.Tests.influxdb_test1: tuya.0.01507801e868e7553d50.3 53 2023-02-01T18:16:08.785Z
2023-02-01 19:22:42.936  - info: javascript.1 (237231) script.js.Tests.influxdb_test1: tuya.0.01507801e868e7553d50.3 53 2023-02-01T18:18:09.041Z
2023-02-01 19:22:42.936  - info: javascript.1 (237231) script.js.Tests.influxdb_test1: tuya.0.01507801e868e7553d50.3 52 2023-02-01T18:18:24.545Z
2023-02-01 19:22:42.936  - info: javascript.1 (237231) script.js.Tests.influxdb_test1: tuya.0.01507801e868e7553d50.3 52 2023-02-01T18:21:24.840Z
2023-02-01 19:22:42.936  - info: javascript.1 (237231) script.js.Tests.influxdb_test1: tuya.0.01507801e868e7553d50.3 53 2023-02-01T18:22:22.202Z
2023-02-01 19:22:42.936  - info: javascript.1 (237231) script.js.Tests.influxdb_test1: tuya.0.01507801e868e7553d50.3 53 2023-02-01T20:22:39.431Z

Die Zeitstempel am Ende sind Zulu-Zeit, deshalb um 1h verschoben. 2023-02-01T18:22:22.202Z ist der Zeitstempel des vorletzten und letzten echten Wertes. Trotzdem folgt noch ein Wert für 2023-02-01T20:22:39.431Z den es aber ja eigentlich gar nicht gibt. Und der immer den selben Wert enthält wie der letzte Echte.

Ich habe mich - mit meinen bescheidenen Datenbankkenntnissen - direkt an Abfragen der InfluxDB versucht. Dabei konnte ich das Verhalten nicht feststellen - was aber nichts heißt, eventuell war mein Statement anders oder InfluxDB filtert das. In Grafana ist das Phänomen ebenfalls nicht zu beobachten, auch da kann ich mir ja die Werte im Explorer als Tabelle anzeigen lassen. Dort sind dann alle Zeitpunkte in der Zukunft leer

[Apollon77]

Da ist bisher absicht für eine "bessere" grafische Darstellung weil sonst das chart mittendrin aufhört was wieder andere User verwirrt hat. :-)

[Apollon77]

Was ist denn das "Problem" damit ausser das ein Wert fortgeführt wird aktuell? Man kann vllt irgendwas einbauen solche Interpolierten Zusatzwerte wegzulassen ...

[BernhardLinz]

Das Problem ist das der SQL-Adapter sich hier anders verhält. Da gibt es diesen letzten, "interpolierten", Wert nicht Bei der Nutzung z.B. eCharts und der Darstellung von festen Zeiträumen tanzen dann die Linien. Ich habe z.B. ein Chart mit dem aktuellen Stromverbrauch, zusätzlich L1 bis L3 + die Solarproduktion. Als Zeitraum 0:00 bis 24:00. Da tanzen dann den ganzen Tag 4 gerade Linien herum.

Ok, Einzelschicksal - doch die Frage wie man die Linie am Ende wegbekommt hatten wir ein paar mal im Forum. Beim SQL-Adapter als Quelle bekommt man das durch Einstellungen hin, beim InfluxDB nicht

Vorschlag wäre es Global in den Adaptereinstellungen konfigurierbar zu machen, gerne per Default eingeschaltet damit sich das gewohnte Verhalten nicht ändert.

[Apollon77]

Bitte für einen Datenpunkt Das erweitere Logging aktivieren, Loglevel des Adapters auf Debug stellen, dann so eine "getHistory" Abfrage machen und log Posten, Danke

[BernhardLinz]

iobroker@iobroker:~$ tail -n 50000 -F /opt/iobroker/log/iobroker.current.log | grep influx
2023-02-07 12:24:21.008  - info: influxdb.0 (1701864) enabled logging of 0_userdata.0.Solaranlage.Total.Energy-Power, Alias=false
2023-02-07 12:25:26.784  - info: influxdb.0 (1701864) Loglevel changed from "info" to "debug"
2023-02-07 12:25:27.813  - debug: influxdb.0 (1701864) PING OK
2023-02-07 12:25:32.306  - debug: influxdb.0 (1701864) new value received for 0_userdata.0.Solaranlage.Total.Energy-Power (storageType Number), new-value=5866, ts=1675769132291, relog=false
2023-02-07 12:25:32.306  - debug: influxdb.0 (1701864) Value logged 0_userdata.0.Solaranlage.Total.Energy-Power, value=5866, ts=1675769132291
2023-02-07 12:25:32.306  - debug: influxdb.0 (1701864) Datatype 0_userdata.0.Solaranlage.Total.Energy-Power: Currently: number, StorageType: Number
2023-02-07 12:25:32.306  - debug: influxdb.0 (1701864) Write Point: 0_userdata.0.Solaranlage.Total.Energy-Power values:{"value":5866,"time":"2023-02-07T11:25:32.291Z","from":"system.adapter.javascript.0","q":0,"ack":false} options: null
2023-02-07 12:25:32.323  - debug: influxdb.0 (1701864) Point written to Bucket_iobroker
2023-02-07 12:25:42.812  - debug: influxdb.0 (1701864) PING OK
2023-02-07 12:25:45.509  - debug: influxdb.0 (1701864) new value received for 0_userdata.0.Solaranlage.Total.Energy-Power (storageType Number), new-value=5865, ts=1675769145496, relog=false
2023-02-07 12:25:45.509  - debug: influxdb.0 (1701864) Value logged 0_userdata.0.Solaranlage.Total.Energy-Power, value=5865, ts=1675769145496
2023-02-07 12:25:45.510  - debug: influxdb.0 (1701864) Datatype 0_userdata.0.Solaranlage.Total.Energy-Power: Currently: number, StorageType: Number
2023-02-07 12:25:45.510  - debug: influxdb.0 (1701864) Write Point: 0_userdata.0.Solaranlage.Total.Energy-Power values:{"value":5865,"time":"2023-02-07T11:25:45.496Z","from":"system.adapter.javascript.0","q":0,"ack":false} options: null
2023-02-07 12:25:45.524  - debug: influxdb.0 (1701864) Point written to Bucket_iobroker
2023-02-07 12:25:47.348  - debug: influxdb.0 (1701864) new value received for 0_userdata.0.Solaranlage.Total.Energy-Power (storageType Number), new-value=5858, ts=1675769147321, relog=false
2023-02-07 12:25:47.349  - debug: influxdb.0 (1701864) Value logged 0_userdata.0.Solaranlage.Total.Energy-Power, value=5858, ts=1675769147321
2023-02-07 12:25:47.349  - debug: influxdb.0 (1701864) Datatype 0_userdata.0.Solaranlage.Total.Energy-Power: Currently: number, StorageType: Number
2023-02-07 12:25:47.349  - debug: influxdb.0 (1701864) Write Point: 0_userdata.0.Solaranlage.Total.Energy-Power values:{"value":5858,"time":"2023-02-07T11:25:47.321Z","from":"system.adapter.javascript.0","q":0,"ack":false} options: null
2023-02-07 12:25:47.358  - debug: influxdb.0 (1701864) Point written to Bucket_iobroker
2023-02-07 12:25:49.033  - debug: influxdb.0 (1701864) new value received for 0_userdata.0.Solaranlage.Total.Energy-Power (storageType Number), new-value=5851, ts=1675769149018, relog=false
2023-02-07 12:25:49.034  - debug: influxdb.0 (1701864) Value logged 0_userdata.0.Solaranlage.Total.Energy-Power, value=5851, ts=1675769149018
2023-02-07 12:25:49.034  - debug: influxdb.0 (1701864) Datatype 0_userdata.0.Solaranlage.Total.Energy-Power: Currently: number, StorageType: Number
2023-02-07 12:25:49.034  - debug: influxdb.0 (1701864) Write Point: 0_userdata.0.Solaranlage.Total.Energy-Power values:{"value":5851,"time":"2023-02-07T11:25:49.018Z","from":"system.adapter.javascript.0","q":0,"ack":false} options: null
2023-02-07 12:25:49.048  - debug: influxdb.0 (1701864) Point written to Bucket_iobroker
2023-02-07 12:25:57.811  - debug: influxdb.0 (1701864) PING OK
2023-02-07 12:26:02.548  - debug: influxdb.0 (1701864) new value received for 0_userdata.0.Solaranlage.Total.Energy-Power (storageType Number), new-value=5846, ts=1675769162436, relog=false
2023-02-07 12:26:02.552  - debug: influxdb.0 (1701864) Value logged 0_userdata.0.Solaranlage.Total.Energy-Power, value=5846, ts=1675769162436
2023-02-07 12:26:02.553  - debug: influxdb.0 (1701864) Datatype 0_userdata.0.Solaranlage.Total.Energy-Power: Currently: number, StorageType: Number
2023-02-07 12:26:02.553  - debug: influxdb.0 (1701864) Write Point: 0_userdata.0.Solaranlage.Total.Energy-Power values:{"value":5846,"time":"2023-02-07T11:26:02.436Z","from":"system.adapter.javascript.0","q":0,"ack":false} options: null
2023-02-07 12:26:02.578  - debug: influxdb.0 (1701864) Point written to Bucket_iobroker
2023-02-07 12:26:04.085  - debug: influxdb.0 (1701864) new value received for 0_userdata.0.Solaranlage.Total.Energy-Power (storageType Number), new-value=5840, ts=1675769164068, relog=false
2023-02-07 12:26:04.086  - debug: influxdb.0 (1701864) Value logged 0_userdata.0.Solaranlage.Total.Energy-Power, value=5840, ts=1675769164068
2023-02-07 12:26:04.086  - debug: influxdb.0 (1701864) Datatype 0_userdata.0.Solaranlage.Total.Energy-Power: Currently: number, StorageType: Number
2023-02-07 12:26:04.087  - debug: influxdb.0 (1701864) Write Point: 0_userdata.0.Solaranlage.Total.Energy-Power values:{"value":5840,"time":"2023-02-07T11:26:04.068Z","from":"system.adapter.javascript.0","q":0,"ack":false} options: null
2023-02-07 12:26:04.106  - debug: influxdb.0 (1701864) Point written to Bucket_iobroker
2023-02-07 12:26:12.814  - debug: influxdb.0 (1701864) PING OK
2023-02-07 12:26:14.184  - debug: influxdb.0 (1701864) new value received for 0_userdata.0.Solaranlage.Total.Energy-Power (storageType Number), new-value=5838, ts=1675769174179, relog=false
2023-02-07 12:26:14.184  - debug: influxdb.0 (1701864) Value logged 0_userdata.0.Solaranlage.Total.Energy-Power, value=5838, ts=1675769174179
2023-02-07 12:26:14.185  - debug: influxdb.0 (1701864) Datatype 0_userdata.0.Solaranlage.Total.Energy-Power: Currently: number, StorageType: Number
2023-02-07 12:26:14.185  - debug: influxdb.0 (1701864) Write Point: 0_userdata.0.Solaranlage.Total.Energy-Power values:{"value":5838,"time":"2023-02-07T11:26:14.179Z","from":"system.adapter.javascript.0","q":0,"ack":false} options: null
2023-02-07 12:26:14.204  - debug: influxdb.0 (1701864) Point written to Bucket_iobroker
2023-02-07 12:26:15.755  - debug: influxdb.0 (1701864) new value received for 0_userdata.0.Solaranlage.Total.Energy-Power (storageType Number), new-value=5837, ts=1675769175738, relog=false
2023-02-07 12:26:15.756  - debug: influxdb.0 (1701864) Value logged 0_userdata.0.Solaranlage.Total.Energy-Power, value=5837, ts=1675769175738
2023-02-07 12:26:15.756  - debug: influxdb.0 (1701864) Datatype 0_userdata.0.Solaranlage.Total.Energy-Power: Currently: number, StorageType: Number
2023-02-07 12:26:15.756  - debug: influxdb.0 (1701864) Write Point: 0_userdata.0.Solaranlage.Total.Energy-Power values:{"value":5837,"time":"2023-02-07T11:26:15.738Z","from":"system.adapter.javascript.0","q":0,"ack":false} options: null
2023-02-07 12:26:15.766  - debug: influxdb.0 (1701864) Point written to Bucket_iobroker
2023-02-07 12:26:17.359  - debug: influxdb.0 (1701864) new value received for 0_userdata.0.Solaranlage.Total.Energy-Power (storageType Number), new-value=5838, ts=1675769177309, relog=false
2023-02-07 12:26:17.360  - debug: influxdb.0 (1701864) Value logged 0_userdata.0.Solaranlage.Total.Energy-Power, value=5838, ts=1675769177309
2023-02-07 12:26:17.360  - debug: influxdb.0 (1701864) Datatype 0_userdata.0.Solaranlage.Total.Energy-Power: Currently: number, StorageType: Number
2023-02-07 12:26:17.360  - debug: influxdb.0 (1701864) Write Point: 0_userdata.0.Solaranlage.Total.Energy-Power values:{"value":5838,"time":"2023-02-07T11:26:17.309Z","from":"system.adapter.javascript.0","q":0,"ack":false} options: null
2023-02-07 12:26:17.369  - debug: influxdb.0 (1701864) Point written to Bucket_iobroker
2023-02-07 12:26:19.065  - debug: influxdb.0 (1701864) new value received for 0_userdata.0.Solaranlage.Total.Energy-Power (storageType Number), new-value=5837, ts=1675769179047, relog=false
2023-02-07 12:26:19.070  - debug: influxdb.0 (1701864) Value logged 0_userdata.0.Solaranlage.Total.Energy-Power, value=5837, ts=1675769179047
2023-02-07 12:26:19.070  - debug: influxdb.0 (1701864) Datatype 0_userdata.0.Solaranlage.Total.Energy-Power: Currently: number, StorageType: Number
2023-02-07 12:26:19.071  - debug: influxdb.0 (1701864) Write Point: 0_userdata.0.Solaranlage.Total.Energy-Power values:{"value":5837,"time":"2023-02-07T11:26:19.047Z","from":"system.adapter.javascript.0","q":0,"ack":false} options: null
2023-02-07 12:26:19.089  - debug: influxdb.0 (1701864) Point written to Bucket_iobroker
2023-02-07 12:26:27.816  - debug: influxdb.0 (1701864) PING OK
2023-02-07 12:26:30.293  - info: javascript.1 (1701654) Stop script script.js.Tests.influxdb_test1
2023-02-07 12:26:30.297  - info: javascript.0 (1701474) Stop script script.js.Tests.influxdb_test1
2023-02-07 12:26:30.527  - debug: influxdb.0 (1701864) new value received for 0_userdata.0.Solaranlage.Total.Energy-Power (storageType Number), new-value=5838, ts=1675769190501, relog=false
2023-02-07 12:26:30.527  - debug: influxdb.0 (1701864) Value logged 0_userdata.0.Solaranlage.Total.Energy-Power, value=5838, ts=1675769190501
2023-02-07 12:26:30.528  - debug: influxdb.0 (1701864) Datatype 0_userdata.0.Solaranlage.Total.Energy-Power: Currently: number, StorageType: Number
2023-02-07 12:26:30.528  - debug: influxdb.0 (1701864) Write Point: 0_userdata.0.Solaranlage.Total.Energy-Power values:{"value":5838,"time":"2023-02-07T11:26:30.501Z","from":"system.adapter.javascript.0","q":0,"ack":false} options: null
2023-02-07 12:26:30.547  - debug: influxdb.0 (1701864) Point written to Bucket_iobroker
2023-02-07 12:26:32.290  - debug: influxdb.0 (1701864) new value received for 0_userdata.0.Solaranlage.Total.Energy-Power (storageType Number), new-value=5843, ts=1675769192274, relog=false
2023-02-07 12:26:32.291  - debug: influxdb.0 (1701864) Value logged 0_userdata.0.Solaranlage.Total.Energy-Power, value=5843, ts=1675769192274
2023-02-07 12:26:32.291  - debug: influxdb.0 (1701864) Datatype 0_userdata.0.Solaranlage.Total.Energy-Power: Currently: number, StorageType: Number
2023-02-07 12:26:32.292  - debug: influxdb.0 (1701864) Write Point: 0_userdata.0.Solaranlage.Total.Energy-Power values:{"value":5843,"time":"2023-02-07T11:26:32.274Z","from":"system.adapter.javascript.0","q":0,"ack":false} options: null
2023-02-07 12:26:32.312  - debug: influxdb.0 (1701864) Point written to Bucket_iobroker
2023-02-07 12:26:34.101  - debug: influxdb.0 (1701864) new value received for 0_userdata.0.Solaranlage.Total.Energy-Power (storageType Number), new-value=5850, ts=1675769194085, relog=false
2023-02-07 12:26:34.101  - debug: influxdb.0 (1701864) Value logged 0_userdata.0.Solaranlage.Total.Energy-Power, value=5850, ts=1675769194085
2023-02-07 12:26:34.101  - debug: influxdb.0 (1701864) Datatype 0_userdata.0.Solaranlage.Total.Energy-Power: Currently: number, StorageType: Number
2023-02-07 12:26:34.102  - debug: influxdb.0 (1701864) Write Point: 0_userdata.0.Solaranlage.Total.Energy-Power values:{"value":5850,"time":"2023-02-07T11:26:34.085Z","from":"system.adapter.javascript.0","q":0,"ack":false} options: null
2023-02-07 12:26:34.115  - debug: influxdb.0 (1701864) Point written to Bucket_iobroker
2023-02-07 12:26:41.700  - info: javascript.1 (1701654) Start javascript script.js.Tests.influxdb_test1
2023-02-07 12:26:41.714  - info: javascript.1 (1701654) script.js.Tests.influxdb_test1: registered 0 subscriptions, 0 schedules, 0 messages, 0 logs and 0 file subscriptions
2023-02-07 12:26:41.715  - debug: influxdb.0 (1701864) Incoming message getHistory from system.adapter.javascript.1
2023-02-07 12:26:41.720  - debug: influxdb.0 (1701864) 0_userdata.0.Solaranlage.Total.Energy-Power16757692017200.15063751974973827 getHistory message: {"id":"0_userdata.0.Solaranlage.Total.Energy-Power","options":{"start":1675767401713,"end":1675776401713,"aggregate":"onchange","addId":true}}
2023-02-07 12:26:41.720  - debug: influxdb.0 (1701864) 0_userdata.0.Solaranlage.Total.Energy-Power16757692017200.15063751974973827 getHistory (InfluxDB2) options final: {"id":"0_userdata.0.Solaranlage.Total.Energy-Power","start":1675767401713,"end":1675776401713,"step":null,"count":500,"aggregate":"onchange","limit":2000,"addId":true,"ignoreNull":true,"returnNewestEntries":false,"percentile":null,"quantile":null,"integralUnit":null,"integralInterpolation":null,"removeBorderValues":false,"logId":"0_userdata.0.Solaranlage.Total.Energy-Power16757692017200.15063751974973827","round":10000,"debugLog":true}
2023-02-07 12:26:41.723  - debug: influxdb.0 (1701864) Query to execute:
2023-02-07 12:26:41.920  - debug: influxdb.0 (1701864) 0_userdata.0.Solaranlage.Total.Energy-Power16757692017200.15063751974973827 Bool check error: runtime error @4:12-4:147: filter: type conflict: bool != string
2023-02-07 12:26:41.920  - debug: influxdb.0 (1701864) 0_userdata.0.Solaranlage.Total.Energy-Power16757692017200.15063751974973827 History-queries to execute: from(bucket: "Bucket_iobroker")
2023-02-07 12:26:41.921  - debug: influxdb.0 (1701864) Query to execute: from(bucket: "Bucket_iobroker")
2023-02-07 12:26:42.050  - debug: influxdb.0 (1701864) Query to execute: from(bucket: "Bucket_iobroker")  |> range(start: 2023-02-07T10:56:41.713Z, stop: 2023-02-07T13:26:41.713Z) |> filter(fn: (r) => r["_measurement"] == "0_userdata.0.Solaranlage.Total.Energy-Power") |> pivot(rowKey:["_time"], columnKey: ["_field"], valueColumn: "_value") |> group() |> sort(columns:["_time"], desc: false) |> limit(n: 500)
2023-02-07 12:26:42.098  - debug: influxdb.0 (1701864) Query to execute: from(bucket: "Bucket_iobroker")
2023-02-07 12:26:42.121  - debug: influxdb.0 (1701864) 0_userdata.0.Solaranlage.Total.Energy-Power16757692017200.15063751974973827 Parsing retrieved rows:[[],[{"result":"_result","table":0,"_start":"2023-02-07T10:56:41.713Z","_stop":"2023-02-07T13:26:41.713Z","_time":"2023-02-07T11:24:21.048Z","_measurement":"0_userdata.0.Solaranlage.Total.Energy-Power","ack":false,"from":"system.adapter.influxdb.0","q":0,"value":5852,"time":"2023-02-07T11:24:21.048Z"},{"result":"_result","table":0,"_start":"2023-02-07T10:56:41.713Z","_stop":"2023-02-07T13:26:41.713Z","_time":"2023-02-07T11:24:32.243Z","_measurement":"0_userdata.0.Solaranlage.Total.Energy-Power","ack":false,"from":"system.adapter.javascript.0","q":0,"value":5859,"time":"2023-02-07T11:24:32.243Z"},{"result":"_result","table":0,"_start":"2023-02-07T10:56:41.713Z","_stop":"2023-02-07T13:26:41.713Z","_time":"2023-02-07T11:24:34.099Z","_measurement":"0_userdata.0.Solaranlage.Total.Energy-Power","ack":false,"from":"system.adapter.javascript.0","q":0,"value":5862,"time":"2023-02-07T11:24:34.099Z"},{"result":"_result","table":0,"_start":"2023-02-07T10:56:41.713Z","_stop":"2023-02-07T13:26:41.713Z","_time":"2023-02-07T11:25:00.529Z","_measurement":"0_userdata.0.Solaranlage.Total.Energy-Power","ack":false,"from":"system.adapter.javascript.0","q":0,"value":5863,"time":"2023-02-07T11:25:00.529Z"},{"result":"_result","table":0,"_start":"2023-02-07T10:56:41.713Z","_stop":"2023-02-07T13:26:41.713Z","_time":"2023-02-07T11:25:02.642Z","_measurement":"0_userdata.0.Solaranlage.Total.Energy-Power","ack":false,"from":"system.adapter.javascript.0","q":0,"value":5870,"time":"2023-02-07T11:25:02.642Z"},{"result":"_result","table":0,"_start":"2023-02-07T10:56:41.713Z","_stop":"2023-02-07T13:26:41.713Z","_time":"2023-02-07T11:25:04.261Z","_measurement":"0_userdata.0.Solaranlage.Total.Energy-Power","ack":false,"from":"system.adapter.javascript.0","q":0,"value":5874,"time":"2023-02-07T11:25:04.261Z"},{"result":"_result","table":0,"_start":"2023-02-07T10:56:41.713Z","_stop":"2023-02-07T13:26:41.713Z","_time":"2023-02-07T11:25:14.136Z","_measurement":"0_userdata.0.Solaranlage.Total.Energy-Power","ack":false,"from":"system.adapter.javascript.0","q":0,"value":5875,"time":"2023-02-07T11:25:14.136Z"},{"result":"_result","table":0,"_start":"2023-02-07T10:56:41.713Z","_stop":"2023-02-07T13:26:41.713Z","_time":"2023-02-07T11:25:17.31Z","_measurement":"0_userdata.0.Solaranlage.Total.Energy-Power","ack":false,"from":"system.adapter.javascript.0","q":0,"value":5873,"time":"2023-02-07T11:25:17.31Z"},{"result":"_result","table":0,"_start":"2023-02-07T10:56:41.713Z","_stop":"2023-02-07T13:26:41.713Z","_time":"2023-02-07T11:25:19.069Z","_measurement":"0_userdata.0.Solaranlage.Total.Energy-Power","ack":false,"from":"system.adapter.javascript.0","q":0,"value":5871,"time":"2023-02-07T11:25:19.069Z"},{"result":"_result","table":0,"_start":"2023-02-07T10:56:41.713Z","_stop":"2023-02-07T13:26:41.713Z","_time":"2023-02-07T11:25:32.291Z","_measurement":"0_userdata.0.Solaranlage.Total.Energy-Power","ack":false,"from":"system.adapter.javascript.0","q":0,"value":5866,"time":"2023-02-07T11:25:32.291Z"},{"result":"_result","table":0,"_start":"2023-02-07T10:56:41.713Z","_stop":"2023-02-07T13:26:41.713Z","_time":"2023-02-07T11:25:45.496Z","_measurement":"0_userdata.0.Solaranlage.Total.Energy-Power","ack":false,"from":"system.adapter.javascript.0","q":0,"value":5865,"time":"2023-02-07T11:25:45.496Z"},{"result":"_result","table":0,"_start":"2023-02-07T10:56:41.713Z","_stop":"2023-02-07T13:26:41.713Z","_time":"2023-02-07T11:25:47.321Z","_measurement":"0_userdata.0.Solaranlage.Total.Energy-Power","ack":false,"from":"system.adapter.javascript.0","q":0,"value":5858,"time":"2023-02-07T11:25:47.321Z"},{"result":"_result","table":0,"_start":"2023-02-07T10:56:41.713Z","_stop":"2023-02-07T13:26:41.713Z","_time":"2023-02-07T11:25:49.018Z","_measurement":"0_userdata.0.Solaranlage.Total.Energy-Power","ack":false,"from":"system.adapter.javascript.0","q":0,"value":5851,"time":"2023-02-07T11:25:49.018Z"},{"result":"_result","table":0,"_start":"2023-02-07T10:56:41.713Z","_stop":"2023-02-07T13:26:41.713Z","_time":"2023-02-07T11:26:02.436Z","_measurement":"0_userdata.0.Solaranlage.Total.Energy-Power","ack":false,"from":"system.adapter.javascript.0","q":0,"value":5846,"time":"2023-02-07T11:26:02.436Z"},{"result":"_result","table":0,"_start":"2023-02-07T10:56:41.713Z","_stop":"2023-02-07T13:26:41.713Z","_time":"2023-02-07T11:26:04.068Z","_measurement":"0_userdata.0.Solaranlage.Total.Energy-Power","ack":false,"from":"system.adapter.javascript.0","q":0,"value":5840,"time":"2023-02-07T11:26:04.068Z"},{"result":"_result","table":0,"_start":"2023-02-07T10:56:41.713Z","_stop":"2023-02-07T13:26:41.713Z","_time":"2023-02-07T11:26:14.179Z","_measurement":"0_userdata.0.Solaranlage.Total.Energy-Power","ack":false,"from":"system.adapter.javascript.0","q":0,"value":5838,"time":"2023-02-07T11:26:14.179Z"},{"result":"_result","table":0,"_start":"2023-02-07T10:56:41.713Z","_stop":"2023-02-07T13:26:41.713Z","_time":"2023-02-07T11:26:15.738Z","_measurement":"0_userdata.0.Solaranlage.Total.Energy-Power","ack":false,"from":"system.adapter.javascript.0","q":0,"value":5837,"time":"2023-02-07T11:26:15.738Z"},{"result":"_result","table":0,"_start":"2023-02-07T10:56:41.713Z","_stop":"2023-02-07T13:26:41.713Z","_time":"2023-02-07T11:26:17.309Z","_measurement":"0_userdata.0.Solaranlage.Total.Energy-Power","ack":false,"from":"system.adapter.javascript.0","q":0,"value":5838,"time":"2023-02-07T11:26:17.309Z"},{"result":"_result","table":0,"_start":"2023-02-07T10:56:41.713Z","_stop":"2023-02-07T13:26:41.713Z","_time":"2023-02-07T11:26:19.047Z","_measurement":"0_userdata.0.Solaranlage.Total.Energy-Power","ack":false,"from":"system.adapter.javascript.0","q":0,"value":5837,"time":"2023-02-07T11:26:19.047Z"},{"result":"_result","table":0,"_start":"2023-02-07T10:56:41.713Z","_stop":"2023-02-07T13:26:41.713Z","_time":"2023-02-07T11:26:30.501Z","_measurement":"0_userdata.0.Solaranlage.Total.Energy-Power","ack":false,"from":"system.adapter.javascript.0","q":0,"value":5838,"time":"2023-02-07T11:26:30.501Z"},{"result":"_result","table":0,"_start":"2023-02-07T10:56:41.713Z","_stop":"2023-02-07T13:26:41.713Z","_time":"2023-02-07T11:26:32.274Z","_measurement":"0_userdata.0.Solaranlage.Total.Energy-Power","ack":false,"from":"system.adapter.javascript.0","q":0,"value":5843,"time":"2023-02-07T11:26:32.274Z"},{"result":"_result","table":0,"_start":"2023-02-07T10:56:41.713Z","_stop":"2023-02-07T13:26:41.713Z","_time":"2023-02-07T11:26:34.085Z","_measurement":"0_userdata.0.Solaranlage.Total.Energy-Power","ack":false,"from":"system.adapter.javascript.0","q":0,"value":5850,"time":"2023-02-07T11:26:34.085Z"}],[]]
2023-02-07 12:26:42.127  - debug: influxdb.0 (1701864) 0_userdata.0.Solaranlage.Total.Energy-Power16757692017200.15063751974973827 Beautify: 22 results
2023-02-07 12:26:42.127  - debug: influxdb.0 (1701864) Send: 24 of: 22 in: 408ms
2023-02-07 12:26:42.134  - info: javascript.1 (1701654) script.js.Tests.influxdb_test1: 0_userdata.0.Solaranlage.Total.Energy-Power 5852 2023-02-07T10:56:41.713Z
2023-02-07 12:26:42.135  - info: javascript.1 (1701654) script.js.Tests.influxdb_test1: 0_userdata.0.Solaranlage.Total.Energy-Power 5852 2023-02-07T11:24:21.048Z
2023-02-07 12:26:42.135  - info: javascript.1 (1701654) script.js.Tests.influxdb_test1: 0_userdata.0.Solaranlage.Total.Energy-Power 5859 2023-02-07T11:24:32.243Z
2023-02-07 12:26:42.135  - info: javascript.1 (1701654) script.js.Tests.influxdb_test1: 0_userdata.0.Solaranlage.Total.Energy-Power 5862 2023-02-07T11:24:34.099Z
2023-02-07 12:26:42.136  - info: javascript.1 (1701654) script.js.Tests.influxdb_test1: 0_userdata.0.Solaranlage.Total.Energy-Power 5863 2023-02-07T11:25:00.529Z
2023-02-07 12:26:42.136  - info: javascript.1 (1701654) script.js.Tests.influxdb_test1: 0_userdata.0.Solaranlage.Total.Energy-Power 5870 2023-02-07T11:25:02.642Z
2023-02-07 12:26:42.136  - info: javascript.1 (1701654) script.js.Tests.influxdb_test1: 0_userdata.0.Solaranlage.Total.Energy-Power 5874 2023-02-07T11:25:04.261Z
2023-02-07 12:26:42.136  - info: javascript.1 (1701654) script.js.Tests.influxdb_test1: 0_userdata.0.Solaranlage.Total.Energy-Power 5875 2023-02-07T11:25:14.136Z
2023-02-07 12:26:42.136  - info: javascript.1 (1701654) script.js.Tests.influxdb_test1: 0_userdata.0.Solaranlage.Total.Energy-Power 5873 2023-02-07T11:25:17.310Z
2023-02-07 12:26:42.136  - info: javascript.1 (1701654) script.js.Tests.influxdb_test1: 0_userdata.0.Solaranlage.Total.Energy-Power 5871 2023-02-07T11:25:19.069Z
2023-02-07 12:26:42.136  - info: javascript.1 (1701654) script.js.Tests.influxdb_test1: 0_userdata.0.Solaranlage.Total.Energy-Power 5866 2023-02-07T11:25:32.291Z
2023-02-07 12:26:42.136  - info: javascript.1 (1701654) script.js.Tests.influxdb_test1: 0_userdata.0.Solaranlage.Total.Energy-Power 5865 2023-02-07T11:25:45.496Z
2023-02-07 12:26:42.136  - info: javascript.1 (1701654) script.js.Tests.influxdb_test1: 0_userdata.0.Solaranlage.Total.Energy-Power 5858 2023-02-07T11:25:47.321Z
2023-02-07 12:26:42.136  - info: javascript.1 (1701654) script.js.Tests.influxdb_test1: 0_userdata.0.Solaranlage.Total.Energy-Power 5851 2023-02-07T11:25:49.018Z
2023-02-07 12:26:42.136  - info: javascript.1 (1701654) script.js.Tests.influxdb_test1: 0_userdata.0.Solaranlage.Total.Energy-Power 5846 2023-02-07T11:26:02.436Z
2023-02-07 12:26:42.136  - info: javascript.1 (1701654) script.js.Tests.influxdb_test1: 0_userdata.0.Solaranlage.Total.Energy-Power 5840 2023-02-07T11:26:04.068Z
2023-02-07 12:26:42.136  - info: javascript.1 (1701654) script.js.Tests.influxdb_test1: 0_userdata.0.Solaranlage.Total.Energy-Power 5838 2023-02-07T11:26:14.179Z
2023-02-07 12:26:42.136  - info: javascript.1 (1701654) script.js.Tests.influxdb_test1: 0_userdata.0.Solaranlage.Total.Energy-Power 5837 2023-02-07T11:26:15.738Z
2023-02-07 12:26:42.136  - info: javascript.1 (1701654) script.js.Tests.influxdb_test1: 0_userdata.0.Solaranlage.Total.Energy-Power 5838 2023-02-07T11:26:17.309Z
2023-02-07 12:26:42.137  - info: javascript.1 (1701654) script.js.Tests.influxdb_test1: 0_userdata.0.Solaranlage.Total.Energy-Power 5837 2023-02-07T11:26:19.047Z
2023-02-07 12:26:42.137  - info: javascript.1 (1701654) script.js.Tests.influxdb_test1: 0_userdata.0.Solaranlage.Total.Energy-Power 5838 2023-02-07T11:26:30.501Z
2023-02-07 12:26:42.137  - info: javascript.1 (1701654) script.js.Tests.influxdb_test1: 0_userdata.0.Solaranlage.Total.Energy-Power 5843 2023-02-07T11:26:32.274Z
2023-02-07 12:26:42.137  - info: javascript.1 (1701654) script.js.Tests.influxdb_test1: 0_userdata.0.Solaranlage.Total.Energy-Power 5850 2023-02-07T11:26:34.085Z
2023-02-07 12:26:42.137  - info: javascript.1 (1701654) script.js.Tests.influxdb_test1: 0_userdata.0.Solaranlage.Total.Energy-Power 5850 2023-02-07T13:26:41.713Z
2023-02-07 12:26:42.811  - debug: influxdb.0 (1701864) PING OK
2023-02-07 12:26:45.515  - debug: influxdb.0 (1701864) new value received for 0_userdata.0.Solaranlage.Total.Energy-Power (storageType Number), new-value=5851, ts=1675769205497, relog=false
2023-02-07 12:26:45.517  - debug: influxdb.0 (1701864) Value logged 0_userdata.0.Solaranlage.Total.Energy-Power, value=5851, ts=1675769205497
2023-02-07 12:26:45.517  - debug: influxdb.0 (1701864) Datatype 0_userdata.0.Solaranlage.Total.Energy-Power: Currently: number, StorageType: Number
2023-02-07 12:26:45.517  - debug: influxdb.0 (1701864) Write Point: 0_userdata.0.Solaranlage.Total.Energy-Power values:{"value":5851,"time":"2023-02-07T11:26:45.497Z","from":"system.adapter.javascript.0","q":0,"ack":false} options: null
2023-02-07 12:26:45.527  - debug: influxdb.0 (1701864) Point written to Bucket_iobroker
2023-02-07 12:26:47.320  - debug: influxdb.0 (1701864) new value received for 0_userdata.0.Solaranlage.Total.Energy-Power (storageType Number), new-value=5855, ts=1675769207303, relog=false
2023-02-07 12:26:47.321  - debug: influxdb.0 (1701864) Value logged 0_userdata.0.Solaranlage.Total.Energy-Power, value=5855, ts=1675769207303
2023-02-07 12:26:47.321  - debug: influxdb.0 (1701864) Datatype 0_userdata.0.Solaranlage.Total.Energy-Power: Currently: number, StorageType: Number
2023-02-07 12:26:47.321  - debug: influxdb.0 (1701864) Write Point: 0_userdata.0.Solaranlage.Total.Energy-Power values:{"value":5855,"time":"2023-02-07T11:26:47.303Z","from":"system.adapter.javascript.0","q":0,"ack":false} options: null
2023-02-07 12:26:47.332  - debug: influxdb.0 (1701864) Point written to Bucket_iobroker
2023-02-07 12:26:49.069  - debug: influxdb.0 (1701864) new value received for 0_userdata.0.Solaranlage.Total.Energy-Power (storageType Number), new-value=5859, ts=1675769209060, relog=false
2023-02-07 12:26:49.069  - debug: influxdb.0 (1701864) Value logged 0_userdata.0.Solaranlage.Total.Energy-Power, value=5859, ts=1675769209060
2023-02-07 12:26:49.070  - debug: influxdb.0 (1701864) Datatype 0_userdata.0.Solaranlage.Total.Energy-Power: Currently: number, StorageType: Number
2023-02-07 12:26:49.070  - debug: influxdb.0 (1701864) Write Point: 0_userdata.0.Solaranlage.Total.Energy-Power values:{"value":5859,"time":"2023-02-07T11:26:49.060Z","from":"system.adapter.javascript.0","q":0,"ack":false} options: null
2023-02-07 12:26:49.085  - debug: influxdb.0 (1701864) Point written to Bucket_iobroker
2023-02-07 12:26:57.811  - debug: influxdb.0 (1701864) PING OK
2023-02-07 12:27:00.532  - debug: influxdb.0 (1701864) new value received for 0_userdata.0.Solaranlage.Total.Energy-Power (storageType Number), new-value=5860, ts=1675769220518, relog=false
2023-02-07 12:27:00.532  - debug: influxdb.0 (1701864) Value logged 0_userdata.0.Solaranlage.Total.Energy-Power, value=5860, ts=1675769220518
2023-02-07 12:27:00.532  - debug: influxdb.0 (1701864) Datatype 0_userdata.0.Solaranlage.Total.Energy-Power: Currently: number, StorageType: Number
2023-02-07 12:27:00.533  - debug: influxdb.0 (1701864) Write Point: 0_userdata.0.Solaranlage.Total.Energy-Power values:{"value":5860,"time":"2023-02-07T11:27:00.518Z","from":"system.adapter.javascript.0","q":0,"ack":false} options: null
2023-02-07 12:27:00.545  - debug: influxdb.0 (1701864) Point written to Bucket_iobroker
2023-02-07 12:27:04.120  - debug: influxdb.0 (1701864) new value received for 0_userdata.0.Solaranlage.Total.Energy-Power (storageType Number), new-value=5861, ts=1675769224069, relog=false
2023-02-07 12:27:04.121  - debug: influxdb.0 (1701864) Value logged 0_userdata.0.Solaranlage.Total.Energy-Power, value=5861, ts=1675769224069
2023-02-07 12:27:04.121  - debug: influxdb.0 (1701864) Datatype 0_userdata.0.Solaranlage.Total.Energy-Power: Currently: number, StorageType: Number
2023-02-07 12:27:04.121  - debug: influxdb.0 (1701864) Write Point: 0_userdata.0.Solaranlage.Total.Energy-Power values:{"value":5861,"time":"2023-02-07T11:27:04.069Z","from":"system.adapter.javascript.0","q":0,"ack":false} options: null
2023-02-07 12:27:04.130  - debug: influxdb.0 (1701864) Point written to Bucket_iobroker

[0xdefec71f]

Gibt es hier neue Erkenntnisse? Es ist schon sehr ärgerlich, weil bei mir sind so ziemlich alle Grafiken unbrauchbar durch diesen bug. Es sind auch nicht alle Datenpunkte betroffen, so wie hier die blaue und magentafarbenen Linien. Ich habe bereits ein downgrade auf Version 3.1.3 durchgeführt, jedoch ohne Verbesserung. Weiter zurück geht leider nicht.

[Apollon77]

Hm ... Hören die Daten dort jeweils auf wo es gerade wird? oder was ist das? Dann ist das ggf noch was anderes ...

[0xdefec71f]

Nein, eben nicht. es sind durchgehend Daten vorhanden, wie bei der gelben Linie. Wenn ich in den hinteren Bereich hinein zoome, werden auch alle Daten angezeigt, manchmal aber auch wieder nur der hintere Bereich nicht. Es ist augenscheinlich willkürlich welche Datenpunkte oder Zeiten es betrifft. Es ist jedoch immer der rechte/jüngste Bereich. Der Entwickler von Echarts weist das Problem von sich, siehe link von oben. Ich gebe gern noch weitere Informationen wenn ich kann. Aber vielleicht ist es zielführend wenn man das mit @GermanBluefox zusammen angeht. Das Problem besteht jedenfalls nicht, wenn man mit grafana direkt eine query an die DB schickt.

[0xdefec71f]

Ich habe mir mal eben den Flot Adapter installiert und dort den identischen Datenpunkt gezeichnet. Mit Flot tritt es nicht auf!

Rechts außen sieht man, dass die Daten nur in Echarts nicht richtig dargestellt werden. Die Verlaufsdaten unter Objekte sehen unauffällig aus.

Es scheint wirklich ein Echarts Problem zu sein.

[BernhardLinz]

Es scheint wirklich ein Echarts Problem zu sein.

Naja, wie man in meinem ersten Beitrag hier sehen kann kommt der zusätzliche Wert auch bei einer Abfrage per sendTo. Also eher nicht ein Problem des eChart-Adapters.

Flot geht da vielleicht anders mit um oder dieser fällt durch eine andere Verarbeitung weg. Der SQL-Adapter zeigt dieses Verhalten jedenfalls nicht (in Zusammenarbeit mit MySQL/MariaDB)

[sweinreuter]

+1

Ich habe das gleiche Problem nach Umstellung von History auf InfluxDB. Recht unschön anzuschauen.

Dass 'getHistory' "erfundene" Werte in der Zukunft liefert ist schon sehr eigenartig. Andere Chart-Tools ignorieren das vmtl. dadurch, dass sie selbst alles was neuer ist als "jetzt" weglassen. Wäre natürlich auch eine Lösung in eCharts, aber ein Fix an der Quelle der Daten wäre schon am besten...