Hallo,
ich versuch gerade eine Übersicht über die Monats und Jahresverbräuche aufzubauen.
Dazu wollte ich mir die Monats, bzw. Jahresverbräuche mit DBrep berechnen lassen, leider bekomme ich dabei aber nicht das Ergebnis was ich erwarte.
Hier ein Beispiel:
Folgendes ist in der Datenbank:s
+---------------------+--------------+------+----------------------------------+-------------------+---------------+------+
| TIMESTAMP | DEVICE | TYPE | EVENT | READING | VALUE | UNIT |
+---------------------+--------------+------+----------------------------------+-------------------+---------------+------+
| 2017-11-30 00:00:12 | Stromzaehler | OBIS | total_consumption: 22047.5792124 | total_consumption | 22047.5792124 | |
.
.
.
.
| 2017-11-30 23:59:59 | Stromzaehler | OBIS | total_consumption: 22059.6079391 | total_consumption | 22059.6079391 | |
Hier noch das DBrep Device:
Internals:
DATABASE fhem_long
DEF logdb_long
FUUID 5cb5702d-f33f-357a-dac7-0da64b8c7661b076
FVERSION 93_DbRep.pm:v8.50.4-s26650/2022-11-04
LASTCMD diffValue display
MODEL Client
NAME Dbrep_long
NOTIFYDEV global,Dbrep_long
NR 195
NTFY_ORDER 50-Dbrep_long
ROLE Client
STATE done
TYPE DbRep
UTF8 1
eventCount 8
HELPER:
DBLOGDEVICE logdb_long
GRANTS USAGE,INSERT,UPDATE,DELETE,SELECT
IDRETRIES 2
MINTS 2016-12-26 23:33:00
PACKAGE main
VERSION 8.50.4
CV:
aggregation day
aggsec 86400
destr 2022-11-30
dsstr 2022-11-01
epoch_seconds_end 1669849199
mestr 11
msstr 11
testr 23:59:59
tsstr 00:00:00
wdadd
yestr 2022
ysstr 2022
DBREPCOL:
COLSET 1
DEVICE 64
EVENT 512
READING 64
TYPE 64
UNIT 32
VALUE 128
OLDREADINGS:
READINGS:
2022-12-01 12:17:33 2022-11-01_23-59-58__Stromzaehler__total_consumption__DIFF__2022-11-01 0.0000
2022-12-01 12:17:33 2022-11-02_23-59-59__Stromzaehler__total_consumption__DIFF__2022-11-02 0.0007
2022-12-01 12:17:33 2022-11-03_23-59-56__Stromzaehler__total_consumption__DIFF__2022-11-03 0.0006
2022-12-01 12:17:33 2022-11-04_23-59-59__Stromzaehler__total_consumption__DIFF__2022-11-04 0.0006
2022-12-01 12:17:33 2022-11-05_23-59-58__Stromzaehler__total_consumption__DIFF__2022-11-05 0.0007
2022-12-01 12:17:33 2022-11-06_23-59-59__Stromzaehler__total_consumption__DIFF__2022-11-06 0.0008
2022-12-01 12:17:33 2022-11-07_23-59-56__Stromzaehler__total_consumption__DIFF__2022-11-07 0.0006
2022-12-01 12:17:33 2022-11-08_23-59-59__Stromzaehler__total_consumption__DIFF__2022-11-08 0.0005
2022-12-01 12:17:33 2022-11-09_23-59-56__Stromzaehler__total_consumption__DIFF__2022-11-09 0.0007
2022-12-01 12:17:33 2022-11-10_23-59-58__Stromzaehler__total_consumption__DIFF__2022-11-10 0.0005
2022-12-01 12:17:33 2022-11-11_23-59-56__Stromzaehler__total_consumption__DIFF__2022-11-11 0.0005
2022-12-01 12:17:33 2022-11-12_23-59-55__Stromzaehler__total_consumption__DIFF__2022-11-12 0.0004
2022-12-01 12:17:33 2022-11-13_23-59-58__Stromzaehler__total_consumption__DIFF__2022-11-13 0.0007
2022-12-01 12:17:33 2022-11-14_23-59-40__Stromzaehler__total_consumption__DIFF__2022-11-14 0.0006
2022-12-01 12:17:33 2022-11-15_23-59-59__Stromzaehler__total_consumption__DIFF__2022-11-15 0.0014
2022-12-01 12:17:33 2022-11-16_23-59-57__Stromzaehler__total_consumption__DIFF__2022-11-16 0.0005
2022-12-01 12:17:33 2022-11-17_23-59-56__Stromzaehler__total_consumption__DIFF__2022-11-17 0.0007
2022-12-01 12:17:33 2022-11-18_23-59-59__Stromzaehler__total_consumption__DIFF__2022-11-18 0.0006
2022-12-01 12:17:33 2022-11-19_23-59-56__Stromzaehler__total_consumption__DIFF__2022-11-19 0.0005
2022-12-01 12:17:33 2022-11-20_23-59-59__Stromzaehler__total_consumption__DIFF__2022-11-20 0.0006
2022-12-01 12:17:33 2022-11-21_23-59-59__Stromzaehler__total_consumption__DIFF__2022-11-21 0.0007
2022-12-01 12:17:33 2022-11-22_23-59-59__Stromzaehler__total_consumption__DIFF__2022-11-22 0.0006
2022-12-01 12:17:33 2022-11-23_23-59-59__Stromzaehler__total_consumption__DIFF__2022-11-23 0.0007
2022-12-01 12:17:33 2022-11-24_23-59-56__Stromzaehler__total_consumption__DIFF__2022-11-24 0.0006
2022-12-01 12:17:33 2022-11-25_23-59-59__Stromzaehler__total_consumption__DIFF__2022-11-25 0.0006
2022-12-01 12:17:33 2022-11-26_23-59-55__Stromzaehler__total_consumption__DIFF__2022-11-26 0.0005
2022-12-01 12:17:33 2022-11-27_23-59-56__Stromzaehler__total_consumption__DIFF__2022-11-27 0.0006
2022-12-01 12:17:33 2022-11-28_23-59-57__Stromzaehler__total_consumption__DIFF__2022-11-28 0.0007
2022-12-01 12:17:33 2022-11-29_23-59-58__Stromzaehler__total_consumption__DIFF__2022-11-29 0.0005
2022-12-01 12:17:33 2022-11-30_23-59-55__Stromzaehler__total_consumption__DIFF__2022-11-30 0.0005
2022-12-01 12:17:33 background_processing_time 11.7581
2022-12-01 12:17:33 sql_processing_time 6.7730
2022-12-01 12:17:33 state done
hmccu:
Attributes:
DbLogExclude .*
aggregation day
allowDeletion 1
devStateIcon connected:10px-kreis-gelb .*disconnect:10px-kreis-rot .*done:10px-kreis-gruen
device Stromzaehler
group Datenbank
reading total_consumption
room 90_Datenbank
showproctime 1
sortby 27
timestamp_begin previous_month_begin
timestamp_end previous_month_end
Wie man hier erkennt, bekomme ich bei Diffvalue als Ergebnis für den 30.11.22 den Wert 0.0005, erwartet hätte ich den Wert 12,0287267.
Was mache ich falsch, oder verstehe ich die Funktion von Diffvalue falsch?
ZitatFolgendes ist in der Datenbank:
2017-11-30 ...
2017 ??
Hallo Heiko,
ja, meine DB ist mittlerweile recht groß :-)
Das Datum spielt bei dem Problem aber keine Rolle, das Ergeblis ist immer unerklärlich.
hier noch ein Beispiel:
select value from history where device = "Stromzaehler" and reading = "total_consumption" and timestamp like "2022-11-30%" ORDER BY timestamp DESC Limit 1;
+----------------+
| value |
+----------------+
| 12612.88269031 |
+----------------+
select value from history where device = "Stromzaehler" and reading = "total_consumption" and timestamp like "2022-11-30%" ORDER BY timestamp ASC Limit 1;
+----------------+
| value |
+----------------+
| 12597.68599355 |
+----------------+
select (select value from history where device = "Stromzaehler" and reading = "total_consumption" and timestamp like "2022-11-30%" ORDER BY timestamp DESC Limit 1) - (select value from history where device = "Stromzaehler" and reading = "total_consumption" and timestamp like "2022-11-30%" ORDER BY timestamp ASC Limit 1) AS Differenz;
+--------------------+
| Differenz |
+--------------------+
| 15.196696760000123 |
+--------------------+
Und so sieht das diffvalue Ergebnis aus:
.
.
2022-12-05 12:56:24 2022-11-30_23-59-55__Stromzaehler__total_consumption__DIFF__2022-11-30 0.0005
Kann ich so bei mir nicht nachvollziehen.
Ich habe viele Diff's laufen und die passen.
Da hilft vermutlich nur wenn du mal verbose 4 oder 5 im Device anschaltest und wir die Statements und deren Ergebnisse anschauen.
Meine DB ist auch schon mit Energiedaten seit 2014 gefüllt und 6GB groß.
Hallo Heiko,
hier ein Log mit Verbose 5 von einem anderen Device, das Problem ist das gleiche:
2022.12.05 14:56:07 4: DbRep Report - -------- New selection ---------
2022.12.05 14:56:07 4: DbRep Report - Command: diffValue display
2022.12.05 14:56:07 4: DbRep Report - FullDay option: 0
2022.12.05 14:56:07 5: DbRep Report - Timestamp begin epocheseconds: 1667257200
2022.12.05 14:56:07 4: DbRep Report - Timestamp begin human readable: 2022-11-01 00:00:00
2022.12.05 14:56:07 5: DbRep Report - Timestamp end epocheseconds: 1669849199
2022.12.05 14:56:07 4: DbRep Report - Timestamp end human readable: 2022-11-30 23:59:59
2022.12.05 14:56:07 5: DbRep Report - Daylight savings changed: 0 (from "Wed Nov 30 00:00:00 2022" to "Thu Dec 1 00:00:00 2022")
2022.12.05 14:56:07 5: DbRep Report - runtime_string: 2022-11-30, runtime_string_first: 2022-11-30, runtime_string_next: 2022-11-30 23:59:59
2022.12.05 14:56:07 4: DbRep Report - Aggregation: day
2022.12.05 14:56:07 5: DbRep Report - BlockingCall with PID "102511" started
2022.12.05 14:56:07 4: DbRep Report - Database connect - user: fhemDB, UTF-8 option set: yes
2022.12.05 14:56:07 5: DbRep Report - IsTimeSet: 1, IsAggrSet: 1
2022.12.05 14:56:07 5: DbRep Report - Timestamp-Array:
2022-11-01#2022-11-01 00:00:00#2022-11-02 2022-11-02#2022-11-02#2022-11-03 2022-11-03#2022-11-03#2022-11-04 2022-11-04#2022-11-04#2022-11-05 2022-11-05#2022-11-05#2022-11-06 2022-11-06#2022-11-06#2022-11-07 2022-11-07#2022-11-07#2022-11-08 2022-11-08#2022-11-08#2022-11-09 2022-11-09#2022-11-09#2022-11-10 2022-11-10#2022-11-10#2022-11-11 2022-11-11#2022-11-11#2022-11-12 2022-11-12#2022-11-12#2022-11-13 2022-11-13#2022-11-13#2022-11-14 2022-11-14#2022-11-14#2022-11-15 2022-11-15#2022-11-15#2022-11-16 2022-11-16#2022-11-16#2022-11-17 2022-11-17#2022-11-17#2022-11-18 2022-11-18#2022-11-18#2022-11-19 2022-11-19#2022-11-19#2022-11-20 2022-11-20#2022-11-20#2022-11-21 2022-11-21#2022-11-21#2022-11-22 2022-11-22#2022-11-22#2022-11-23 2022-11-23#2022-11-23#2022-11-24 2022-11-24#2022-11-24#2022-11-25 2022-11-25#2022-11-25#2022-11-26 2022-11-26#2022-11-26#2022-11-27 2022-11-27#2022-11-27#2022-11-28 2022-11-28#2022-11-28#2022-11-29 2022-11-29#2022-11-29#2022-11-30 2022-11-30#2022-11-30#2022-11-30 23:59:59
2022.12.05 14:56:07 4: DbRep Report - simple do statement: set @V:= 0, @diff:= 0, @diffTotal:= 0, @RB:= 1;
2022.12.05 14:56:07 5: DbRep Report - Devices for operation -
included (1): Gasverbrauch
included with wildcard:
excluded (0):
excluded with wildcard:
2022.12.05 14:56:09 5: DbRep Report - Readings for operation -
included (1): countsOverall
included with wildcard:
excluded (0):
excluded with wildcard:
2022.12.05 14:56:09 4: DbRep Report - SQL execute: SELECT TIMESTAMP,VALUE, if(VALUE-@V < 0 OR @RB = 1 , @diff:= 0, @diff:= VALUE-@V ) as DIFF, @V:= VALUE as VALUEBEFORE, @RB:= '0' as RBIT FROM history where ( DEVICE = 'Gasverbrauch' ) AND ( READING = 'countsOverall' ) AND TIMESTAMP >= '2022-11-29' AND TIMESTAMP < '2022-11-30' ORDER BY TIMESTAMP;
2022.12.05 14:56:09 4: DbRep Report - simple do statement: set @V:= 0, @diff:= 0, @diffTotal:= 0, @RB:= 1;
2022.12.05 14:56:09 5: DbRep Report - Devices for operation -
included (1): Gasverbrauch
included with wildcard:
excluded (0):
excluded with wildcard:
2022.12.05 14:56:09 5: DbRep Report - Readings for operation -
included (1): countsOverall
included with wildcard:
excluded (0):
excluded with wildcard:
2022.12.05 14:56:09 4: DbRep Report - SQL execute: SELECT TIMESTAMP,VALUE, if(VALUE-@V < 0 OR @RB = 1 , @diff:= 0, @diff:= VALUE-@V ) as DIFF, @V:= VALUE as VALUEBEFORE, @RB:= '0' as RBIT FROM history where ( DEVICE = 'Gasverbrauch' ) AND ( READING = 'countsOverall' ) AND TIMESTAMP >= '2022-11-30' AND TIMESTAMP <= '2022-11-30 23:59:59' ORDER BY TIMESTAMP;
2022.12.05 14:56:09 5: DbRep Report - data of row_array result assigned to fields:
2022.12.05 14:56:10 4: DbRep Report - balance difference of 0 between 2022-11-30 and 2022-11-30
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_00:17:32, VALUE: 151332, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_00:21:31, VALUE: 151333, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_00:45:30, VALUE: 151333, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_00:49:30, VALUE: 151334, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_00:55:29, VALUE: 151334, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_01:01:29, VALUE: 151334, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_01:13:28, VALUE: 151334, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_01:17:28, VALUE: 151335, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_01:41:27, VALUE: 151335, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_01:45:26, VALUE: 151336, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_01:57:26, VALUE: 151336, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_02:03:25, VALUE: 151336, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_02:09:25, VALUE: 151336, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_02:13:25, VALUE: 151337, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_02:37:23, VALUE: 151337, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_02:41:23, VALUE: 151338, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_02:59:22, VALUE: 151338, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_03:05:22, VALUE: 151338, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_03:08:22, VALUE: 151339, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_03:32:20, VALUE: 151339, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_03:36:20, VALUE: 151340, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_03:59:55, VALUE: 151340, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_04:04:18, VALUE: 151341, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_04:28:17, VALUE: 151341, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_04:32:17, VALUE: 151342, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_04:56:15, VALUE: 151342, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_05:00:15, VALUE: 151343, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_05:06:15, VALUE: 151343, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_05:08:15, VALUE: 151344, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_05:20:14, VALUE: 151344, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_05:23:14, VALUE: 151345, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_05:47:12, VALUE: 151345, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_05:50:12, VALUE: 151346, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_05:56:12, VALUE: 151346, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_06:02:11, VALUE: 151346, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_06:14:11, VALUE: 151346, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_06:18:11, VALUE: 151347, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_06:42:09, VALUE: 151347, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_06:46:09, VALUE: 151348, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_06:58:08, VALUE: 151348, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_07:04:08, VALUE: 151348, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_07:10:08, VALUE: 151348, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_07:13:07, VALUE: 151349, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_07:37:06, VALUE: 151349, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_07:41:06, VALUE: 151350, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_07:59:05, VALUE: 151350, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_08:05:04, VALUE: 151350, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_08:09:04, VALUE: 151351, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_08:33:03, VALUE: 151351, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_08:37:03, VALUE: 151352, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_08:55:01, VALUE: 151352, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_09:01:01, VALUE: 151352, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_09:05:01, VALUE: 151353, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_09:11:01, VALUE: 151354, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_09:15:00, VALUE: 151355, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_09:38:59, VALUE: 151355, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_09:41:59, VALUE: 151356, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_09:59:55, VALUE: 151356, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_10:05:57, VALUE: 151356, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_10:09:57, VALUE: 151357, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_10:33:56, VALUE: 151357, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_10:36:55, VALUE: 151358, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_10:59:55, VALUE: 151358, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_11:04:54, VALUE: 151359, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_11:28:52, VALUE: 151359, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_11:32:52, VALUE: 151360, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_11:56:51, VALUE: 151360, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_11:59:51, VALUE: 151361, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_12:05:50, VALUE: 151361, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_12:23:49, VALUE: 151361, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_12:27:49, VALUE: 151362, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_12:51:48, VALUE: 151362, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_12:55:47, VALUE: 151363, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_13:00:47, VALUE: 151364, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_13:24:46, VALUE: 151364, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_13:26:46, VALUE: 151365, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_13:50:44, VALUE: 151365, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_13:54:44, VALUE: 151366, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_13:59:55, VALUE: 151366, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_14:06:43, VALUE: 151366, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_14:18:43, VALUE: 151366, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_14:21:42, VALUE: 151367, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_14:45:41, VALUE: 151367, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_14:49:41, VALUE: 151368, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_14:55:40, VALUE: 151368, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_15:01:40, VALUE: 151368, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_15:13:39, VALUE: 151368, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_15:17:39, VALUE: 151369, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_15:41:38, VALUE: 151369, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_15:45:38, VALUE: 151370, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_15:57:37, VALUE: 151370, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_16:03:36, VALUE: 151370, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_16:21:35, VALUE: 151370, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_16:27:35, VALUE: 151371, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_16:51:34, VALUE: 151371, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_16:55:33, VALUE: 151372, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_17:01:33, VALUE: 151372, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_17:19:32, VALUE: 151372, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_17:23:32, VALUE: 151373, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_17:47:30, VALUE: 151373, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_17:50:30, VALUE: 151374, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_17:56:30, VALUE: 151374, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_18:02:30, VALUE: 151374, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_18:14:29, VALUE: 151374, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_18:18:29, VALUE: 151375, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_18:42:27, VALUE: 151375, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_18:45:27, VALUE: 151376, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_18:57:26, VALUE: 151376, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_19:03:26, VALUE: 151376, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_19:09:26, VALUE: 151376, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_19:13:26, VALUE: 151377, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_19:37:24, VALUE: 151377, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_19:40:24, VALUE: 151378, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_19:58:23, VALUE: 151378, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_20:04:22, VALUE: 151378, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_20:08:22, VALUE: 151379, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_20:13:22, VALUE: 151380, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_20:18:22, VALUE: 151381, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_20:22:21, VALUE: 151382, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_20:28:21, VALUE: 151382, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_20:30:21, VALUE: 151383, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_20:54:20, VALUE: 151383, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_20:58:19, VALUE: 151384, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_21:04:19, VALUE: 151384, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_21:22:18, VALUE: 151384, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_21:25:18, VALUE: 151385, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_21:49:16, VALUE: 151385, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_21:53:16, VALUE: 151386, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_21:59:16, VALUE: 151386, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_22:05:15, VALUE: 151386, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_22:17:15, VALUE: 151386, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_22:20:15, VALUE: 151387, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_22:43:13, VALUE: 151387, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_22:48:13, VALUE: 151388, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_22:59:55, VALUE: 151388, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_23:06:12, VALUE: 151388, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_23:12:12, VALUE: 151388, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_23:15:11, VALUE: 151389, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_23:39:10, VALUE: 151389, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_23:43:10, VALUE: 151390, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_23:55:09, VALUE: 151390, DIFF: 0.0000
2022.12.05 14:56:10 4: DbRep Report - print result of diffValue calculation before encoding ...
2022.12.05 14:56:10 4: runtimestring Key: 2022-11-30, value: 2022-11-30|0|2022-11-30_23:55:09
2022.12.05 14:56:10 4: DbRep Report - count of values used for calc:
2022.12.05 14:56:10 4: 2022-11-30 => 142
2022.12.05 14:56:10 5: DbRep Report - BlockingCall PID "102511" finished
2022.12.05 14:56:10 4: DbRep Report - print result of diffValue calculation after decoding ...
2022.12.05 14:56:10 4: DbRep Report - runtimestring Key: 2022-11-30, value: 2022-11-30|0|2022-11-30_23:55:09
Ich erkenne das Problem, sehe aber momentan keine Lösung.
Auch wenn es unwahrscheinlich scheint ... vllt. kann deine MySQL Version nicht mit dem Statement (das Variablensetting) umgehen.
Was ist deine DB-Version ?
Hallo Heiko,
die Version war bis eben
mysqld Ver 10.6.7-MariaDB-2ubuntu1.1 for debian-linux-gnu on x86_64 (Ubuntu 22.04)
jetzt nach dem Update ist es
mysqld Ver 10.6.11-MariaDB-0ubuntu0.22.04.1 for debian-linux-gnu on x86_64 (Ubuntu 22.04)
das Problem bleibt leider.
Hmm,
meine ist die 10.1.48-MariaDB-0+deb9u2
Nicht das neuere Versionen das Problem haben ... muss mal googeln
Ich habe dir eine Testversion in mein contrib geladen (siehe Fußtext).
Kannst du die mal bei dir probieren ?
Nach dem Download reload bzw. restart nicht vergessen.
Hallo Heiko,
das sieht gut aus, woran lag es nun?
.
.
2022-12-05 17:26:04 2022-11-29_23-59-33__Gasverbrauch__countsOverall__DIFF__2022-11-29 61.0000
2022-12-05 17:26:04 2022-11-30_23-55-09__Gasverbrauch__countsOverall__DIFF__2022-11-30 58.0000
Danke und Gruß
Alex
Wie ich vermutete.
Offensichtlich kann die MySQL Version nicht mit der Syntax umgehen.
Ich habe einfach die Routine, die ich z.B. für SQLite verwende, auch für MariaDb/MySQL aktiviert.
Weiß nur noch nicht wie ich jetzt damit umgehe ...
Ich habe die Änderung mit meiner MariaDB getestet und mich entschieden diese Änderung ins Repo zu übernehmen.
Scheint zu passen.
Habe das Modul nochmal bisschen angepasst.
Kannst du bitte nochmal aus dem contrib laden und bei dir testen ?
Moin,
Habt ihr das SQL mal als Statement, dann könnte ich es mir mal anschauen und gegen eine Oracle MySQL testen.
VG Christian
Hi Christian,
Das siehst du weiter oben.
Zuerst werden die Variablen initialisiert:
2022.12.05 14:56:09 4: DbRep Report - simple do statement: set @V:= 0, @diff:= 0, @diffTotal:= 0, @RB:= 1;
Dann das Statement:
2022.12.05 14:56:09 4: DbRep Report - SQL execute: SELECT TIMESTAMP,VALUE, if(VALUE-@V < 0 OR @RB = 1 , @diff:= 0, @diff:= VALUE-@V ) as DIFF, @V:= VALUE as VALUEBEFORE, @RB:= '0' as RBIT FROM history where ( DEVICE = 'Gasverbrauch' ) AND ( READING = 'countsOverall' ) AND TIMESTAMP >= '2022-11-29' AND TIMESTAMP < '2022-11-30' ORDER BY TIMESTAMP;
Das Konstrukt kennst du ja.
Ja, das verwende ich auch so bei meinen Abfragen.
Hallo Heiko,
danke dafür, hab ich eingespielt und die ersten Tests gemacht, soweit sieht es ganz gut aus. Morgen werde ich noch etwas intensiver testen, bei dem Stromzählerwerten (OBIS) hatte ich seltsame Ergebnisse gehabt, das muss ich mir nochmal genauer anschauen.
Hallo Heiko,
sorry, dass es etwas gedauert hat.
Ich habe es dann jetzt mal im original Oracle MySQL Docker Container getestet und der Syntax funktioniert einwandfrei.
mysql> select version();
+-----------+
| version() |
+-----------+
| 8.0.28 |
+-----------+
mysql> set @V:= 0, @diff:= 0, @diffTotal:= 0, @RB:= 1;
Query OK, 0 rows affected (0.00 sec)
mysql> select @V, @diff, @diffTotal, @RB;
+------+-------+------------+------+
| @V | @diff | @diffTotal | @RB |
+------+-------+------------+------+
| 0 | 0 | 0 | 1 |
+------+-------+------------+------+
mysql>
SELECT TIMESTAMP,
VALUE,
if(VALUE-@V < 0 OR @RB = 1 , @diff:= 0, @diff:= VALUE-@V ) as DIFF,
@V:= VALUE as VALUEBEFORE,
@RB:= '0' as RBIT
FROM history
WHERE ( DEVICE = 'WR_0_KSEM' )
AND ( READING = 'Active_energy+' )
AND TIMESTAMP >= '2022-11-29'
AND TIMESTAMP < '2022-11-30'
ORDER BY TIMESTAMP;
+---------------------+-------+------+-------------+------+
| TIMESTAMP | VALUE | DIFF | VALUEBEFORE | RBIT |
+---------------------+-------+------+-------------+------+
| 2022-11-29 00:29:54 | 7770 | 0 | 7770 | 0 |
| 2022-11-29 04:35:55 | 7771 | 1 | 7771 | 0 |
| 2022-11-29 08:27:56 | 7772 | 1 | 7772 | 0 |
<snip>
| 2022-11-29 19:26:11 | 7786 | 1 | 7786 | 0 |
| 2022-11-29 22:50:11 | 7787 | 1 | 7787 | 0 |
+---------------------+-------+------+-------------+------+
mysql>
SELECT sum(DIFF)
FROM (
SELECT TIMESTAMP,
VALUE,
if(VALUE-@V < 0 OR @RB = 1 , @diff:= 0, @diff:= VALUE-@V ) as DIFF,
@V:= VALUE as VALUEBEFORE,
@RB:= '0' as RBIT
FROM history
WHERE ( DEVICE = 'WR_0_KSEM' )
AND ( READING = 'Active_energy+' )
AND TIMESTAMP >= '2022-11-29'
AND TIMESTAMP < '2022-11-30'
ORDER BY TIMESTAMP
) SUM ;
+-----------+
| sum(DIFF) |
+-----------+
| 17 |
+-----------+
Falls Du noch weitere Tests haben möchtest, dann melde Dich einfach.
VG Christian
Danke Christian,
das bestätigt eigentlich meine weiter oben geäußerte Vermutung.
Die Syntax läuft ja schon jahrelang einwandfrei, wird aber wohl bei den neueren MariaDB Releases nicht mehr so unterstützt wie
es scheint.
Wie dem auch sein, ich habe jetzt den Standardcode für diffValue auch für MariaDB drin und das passt auch.
Aber interessant ist es trotzdem ...
LG,
Heiko
Zitat von: DS_Starter am 07 Dezember 2022, 09:48:41
Die Syntax läuft ja schon jahrelang einwandfrei, wird aber wohl bei den neueren MariaDB Releases nicht mehr so unterstützt wie
es scheint.
Wie dem auch sein, ich habe jetzt den Standardcode für diffValue auch für MariaDB drin und das passt auch.
Aber interessant ist es trotzdem ...
Hallo Heiko,
ich mag es ja, wenn man das Original direkt verwenden kann :-)
Im Oracle MySQL sind berits diverse weitere Konfigurationen im laufe der Jahre geändert worden, die die Sicherheit erhöhen sollen.
So gehen die Versionen dann immer weiter auseinander und es gibt natürlich auch zeitliche Verzögerungen, bis das alles nachgezogen
worden ist.
Da der Container jedoch nur für 64 Bit bereitgestellt wird ist es natürlich eine grundlegende Entscheidung, wenn man es auf einem RPI
oder ähnichem System laufen lassen möchte. Bei mir läuft es nun seit ca. 2 Jahren stabil auf einem RPI 4 mit 64 Bit OS unter Docker. Das
hat mir bereits sehr viel Zeit gespart und ich kann es nur empfehlen.
VG Christian
Hallo Heiko,
auch von meiner Seite die positive Rückmeldung, läuft soweit ohne Probleme.
Die von mir angesprochenen Auffälligkeiten liegen an dem DB Inhalt, irgendwie sind in der DB "Wackelige" Daten enthalten, da muss ich wohl mal aufräumen..
Danke nochmal und Gruß
Alex
Ist eingecheckt und morgen früh im Update.