[gelöst] unerwartete Ergebnisse bei DBrep diffvalue

[Nighthawk]

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

Code Auswählen Erweitern

+---------------------+--------------+------+----------------------------------+-------------------+---------------+------+
| 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:

Code Auswählen Erweitern

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?

[DS_Starter]

Folgendes ist in der Datenbank:

2017-11-30 ...


2017 ??

[Nighthawk]

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:

Code Auswählen Erweitern


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:

Code Auswählen Erweitern

     
.
.
2022-12-05 12:56:24   2022-11-30_23-59-55__Stromzaehler__total_consumption__DIFF__2022-11-30 0.0005

[DS_Starter]

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

[Nighthawk]

Hallo Heiko,

hier ein Log mit Verbose 5 von einem anderen Device, das Problem ist das gleiche:

Code Auswählen Erweitern


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


[DS_Starter]

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 ?

[Nighthawk]

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.

[DS_Starter]

Hmm,

meine ist die 10.1.48-MariaDB-0+deb9u2

Nicht das neuere Versionen das Problem haben ... muss mal googeln

[DS_Starter]

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.

[Nighthawk]

Hallo Heiko,

das sieht gut aus, woran lag es nun?

Code Auswählen Erweitern

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

[DS_Starter]

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

[DS_Starter]

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 ?

[ch.eick]

Moin,
Habt ihr das SQL mal als Statement, dann könnte ich es mir mal anschauen und gegen eine Oracle MySQL testen.

VG Christian

[DS_Starter]

Hi Christian,

Das siehst du weiter oben.
Zuerst werden die Variablen initialisiert:

Code Auswählen Erweitern


2022.12.05 14:56:09 4: DbRep Report - simple do statement: set @V:= 0, @diff:= 0, @diffTotal:= 0, @RB:= 1;


Dann das Statement:

Code Auswählen Erweitern

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.

[ch.eick]

Ja, das verwende ich auch so bei meinen  Abfragen.

[Nighthawk]

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.

[ch.eick]

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.

Code Auswählen Erweitern


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

[DS_Starter]

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

[ch.eick]

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

[Nighthawk]

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

[DS_Starter]

Ist eingecheckt und morgen früh im Update.