Modul 93_DbRep - Reporting und Management von Datenbankinhalten (DbLog)

DS_Starter · 13 Dezember 2017, 08:47:46

Hallo Thomas,

hier nochmal die V6.3.2.
Aber du musst eigentlich nur das Attr widgetOverride löschen, Browser refresh und dann geht alles wieder wie gewohnt.

Grüße
Heiko

AndreasR · 13 Dezember 2017, 10:23:56

Hallo Heiko,

denkst du das es möglich ist das ein weiteres Format zu den sqlResultFormat hinzugefügt wird?

Ich verwende aktuell "mline" und lasse mir das SqlResult via Telegramm schicken wenn zu viele Datensätze in der letzten stunde aufgelaufen sind. Leider ist es jedoch so das die Trennzeichen | stören - und Telegramm (oder msg) die einräge zwischen den Trennzeichen verschluckt ..
Daher wäre es großartig wenn ein Format Text, nur mit Zeilenwechseln, zur verfügung stehen würde. Klar das ich das Ergebniss auch selbst durch eine Funktion in der 99_utils parsen könnte - aber eingebaut wäre eleganter

Danke

Andreas

JoeALLb · 13 Dezember 2017, 10:27:34

Hallo Andreas,

Du kannst doch mit Perl in {}
und einer normalen Ersetzungsfunktion ganz einfach die | durch beliebige Zeichen ersetzen und die die Ausgabe somit so zusammenbauen, wie du
sie benötigst. Das geht auch direkt im selben notify|DOIF, je nachdem was du für den Telegramaufruf nutzt....

sG
Joe

DS_Starter · 13 Dezember 2017, 21:59:59

Hi Andreas, hi Joe,

habe die Idee/den Wunsch von Andreas mal aufgenommen und ein Attribut "sqlResultFieldSep" aufgenommen, welches eine Auswahl von möglichen Feldseparatoren "| : /" zur Verfügung stellt. Damit kann man den default "|" bei Kommando sqlCmd abändern.

Bitte pobierts mal aus -> V6.4.1 im ersten Beitrag.

Grüße
Heiko

supergrobi · 14 Dezember 2017, 10:07:47

Zitat von: DS_Starter am 13 Dezember 2017, 08:47:46
Hallo Thomas,

hier nochmal die V6.3.2.
Aber du musst eigentlich nur das Attr widgetOverride löschen, Browser refresh und dann geht alles wieder wie gewohnt.

Grüße
Heiko

Hallo Heiko,

wenn ich in der V6.4.0 als Attribut Timestamp_xxx auswähle, ist das Attributfeld nur noch als DropDown ohne Inhalt auswählbar. Ich kann keinen Wert ala "2017_10_10 00:00:00" eingeben.

ich hab es jetzt mit der 6.3.2 versucht, adviceRemain und adviceDelete funktioniert. Wenn ich jedoch die Zeilen mit delete löschen will, kommt Fehlermeldung: DBD::mysql::st execute failed: called with 2 bind variables when 0 are needed at ./FHEM/93_DbRep.pm line 3954.

FHEM hab ich nach Reload neu gestartet...

lg
Thomas

DS_Starter · 14 Dezember 2017, 10:47:35

Hallo Thomas,

Zitatwenn ich in der V6.4.0 als Attribut Timestamp_xxx auswähle, ist das Attributfeld nur noch als DropDown ohne Inhalt auswählbar. Ich kann keinen Wert ala "2017_10_10 00:00:00" eingeben

Komisch, konnte ich bei mir nicht feststellen. vllt. eine Browsersache wegen javascript.

Wegen dem bind- Fehler .... mach mal bitte ein verbose 4 log , sowie list und stelle es hier rein. Ich habe das schon mal an anderer Stelle gelesen und konnte es bei mir bisher nicht nachvollziehen.

Grüsse
Heiko

supergrobi · 14 Dezember 2017, 11:08:13

ich hoffe ich hab das richtig gemacht...:

Code Auswählen

2017.12.14 11:05:44 4: DbRep DBReporting - -------- New selection --------- 
2017.12.14 11:05:44 4: DbRep DBReporting - Aggregation: no
2017.12.14 11:05:44 4: DbRep DBReporting - Command: delSeqDoublets
2017.12.14 11:05:44 4: DbRep DBReporting - Timestamp begin human readable: 2017-08-01 00:00:00
2017.12.14 11:05:44 4: DbRep DBReporting - Timestamp end human readable: 2017-11-01 00:00:00
2017.12.14 11:05:44 4: DbRep DBReporting -> Start BlockingCall delseqdoubl_DoParse
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-08-01 00:00:00' AND TIMESTAMP < '2017-08-02' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-08-02' AND TIMESTAMP < '2017-08-03' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-08-03' AND TIMESTAMP < '2017-08-04' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-08-04' AND TIMESTAMP < '2017-08-05' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-08-05' AND TIMESTAMP < '2017-08-06' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-08-06' AND TIMESTAMP < '2017-08-07' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-08-07' AND TIMESTAMP < '2017-08-08' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-08-08' AND TIMESTAMP < '2017-08-09' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-08-09' AND TIMESTAMP < '2017-08-10' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-08-10' AND TIMESTAMP < '2017-08-11' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-08-11' AND TIMESTAMP < '2017-08-12' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-08-12' AND TIMESTAMP < '2017-08-13' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-08-13' AND TIMESTAMP < '2017-08-14' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-08-14' AND TIMESTAMP < '2017-08-15' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-08-15' AND TIMESTAMP < '2017-08-16' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-08-16' AND TIMESTAMP < '2017-08-17' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-08-17' AND TIMESTAMP < '2017-08-18' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-08-18' AND TIMESTAMP < '2017-08-19' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-08-19' AND TIMESTAMP < '2017-08-20' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-08-20' AND TIMESTAMP < '2017-08-21' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-08-21' AND TIMESTAMP < '2017-08-22' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-08-22' AND TIMESTAMP < '2017-08-23' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-08-23' AND TIMESTAMP < '2017-08-24' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-08-24' AND TIMESTAMP < '2017-08-25' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-08-25' AND TIMESTAMP < '2017-08-26' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-08-26' AND TIMESTAMP < '2017-08-27' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-08-27' AND TIMESTAMP < '2017-08-28' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-08-28' AND TIMESTAMP < '2017-08-29' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-08-29' AND TIMESTAMP < '2017-08-30' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-08-30' AND TIMESTAMP < '2017-08-31' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-08-31' AND TIMESTAMP < '2017-09-01' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-09-01' AND TIMESTAMP < '2017-09-02' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-09-02' AND TIMESTAMP < '2017-09-03' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-09-03' AND TIMESTAMP < '2017-09-04' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-09-04' AND TIMESTAMP < '2017-09-05' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-09-05' AND TIMESTAMP < '2017-09-06' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-09-06' AND TIMESTAMP < '2017-09-07' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-09-07' AND TIMESTAMP < '2017-09-08' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-09-08' AND TIMESTAMP < '2017-09-09' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-09-09' AND TIMESTAMP < '2017-09-10' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-09-10' AND TIMESTAMP < '2017-09-11' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-09-11' AND TIMESTAMP < '2017-09-12' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-09-12' AND TIMESTAMP < '2017-09-13' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-09-13' AND TIMESTAMP < '2017-09-14' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-09-14' AND TIMESTAMP < '2017-09-15' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-09-15' AND TIMESTAMP < '2017-09-16' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-09-16' AND TIMESTAMP < '2017-09-17' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-09-17' AND TIMESTAMP < '2017-09-18' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-09-18' AND TIMESTAMP < '2017-09-19' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-09-19' AND TIMESTAMP < '2017-09-20' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-09-20' AND TIMESTAMP < '2017-09-21' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-09-21' AND TIMESTAMP < '2017-09-22' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-09-22' AND TIMESTAMP < '2017-09-23' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-09-23' AND TIMESTAMP < '2017-09-24' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-09-24' AND TIMESTAMP < '2017-09-25' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-09-25' AND TIMESTAMP < '2017-09-26' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-09-26' AND TIMESTAMP < '2017-09-27' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-09-27' AND TIMESTAMP < '2017-09-28' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-09-28' AND TIMESTAMP < '2017-09-29' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-09-29' AND TIMESTAMP < '2017-09-30' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-09-30' AND TIMESTAMP < '2017-10-01' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-10-01' AND TIMESTAMP < '2017-10-02' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-10-02' AND TIMESTAMP < '2017-10-03' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-10-03' AND TIMESTAMP < '2017-10-04' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-10-04' AND TIMESTAMP < '2017-10-05' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-10-05' AND TIMESTAMP < '2017-10-06' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-10-06' AND TIMESTAMP < '2017-10-07' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-10-07' AND TIMESTAMP < '2017-10-08' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-10-08' AND TIMESTAMP < '2017-10-09' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-10-09' AND TIMESTAMP < '2017-10-10' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-10-10' AND TIMESTAMP < '2017-10-11' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-10-11' AND TIMESTAMP < '2017-10-12' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-10-12' AND TIMESTAMP < '2017-10-13' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-10-13' AND TIMESTAMP < '2017-10-14' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-10-14' AND TIMESTAMP < '2017-10-15' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-10-15' AND TIMESTAMP < '2017-10-16' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-10-16' AND TIMESTAMP < '2017-10-17' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-10-17' AND TIMESTAMP < '2017-10-18' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-10-18' AND TIMESTAMP < '2017-10-19' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-10-19' AND TIMESTAMP < '2017-10-20' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-10-20' AND TIMESTAMP < '2017-10-21' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-10-21' AND TIMESTAMP < '2017-10-22' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-10-22' AND TIMESTAMP < '2017-10-23' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-10-23' AND TIMESTAMP < '2017-10-24' ;
2017.12.14 11:05:44 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 00:24:18' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 00:39:19' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 00:54:19' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 01:09:29' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 01:24:30' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 01:39:31' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 01:54:32' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 02:09:34' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 02:24:36' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 02:39:38' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 02:54:38' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 03:09:40' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 03:24:42' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 03:39:42' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 03:54:43' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 04:09:44' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 04:24:45' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 04:39:47' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 04:54:47' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 05:09:49' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 05:24:49' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 05:39:50' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 05:54:50' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 06:09:51' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 06:24:51' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 06:39:52' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 06:54:55' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 07:09:56' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 07:24:57' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 07:40:05' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 07:55:07' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 08:10:08' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 08:25:09' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 08:40:10' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 08:55:31' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='1';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 09:10:32' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='1';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 09:29:04' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 09:44:06' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 09:59:08' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 10:14:08' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 10:29:09' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 10:44:09' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 10:59:10' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 11:14:11' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 11:29:11' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 11:44:12' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 11:59:14' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 12:14:14' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 12:29:15' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 12:44:16' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 12:59:16' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 13:14:17' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 13:29:19' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 13:44:21' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 13:59:21' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 14:14:23' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 14:29:28' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 14:44:28' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 14:59:29' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 15:14:31' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 15:29:33' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 15:44:33' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 15:59:35' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 16:14:35' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 16:29:35' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 16:44:35' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 16:59:36' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 17:14:37' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 17:29:38' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 17:44:38' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 17:59:39' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 18:14:39' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 18:29:39' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 18:44:40' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 18:59:41' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 19:14:43' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 19:42:51' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 19:57:51' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 20:12:53' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 20:27:57' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 20:42:59' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 20:57:59' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 21:13:00' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 21:28:01' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 21:43:01' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 21:58:03' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 22:13:05' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 22:28:05' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 22:43:05' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 22:58:05' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 23:13:06' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: delete FROM history where TIMESTAMP = '2017-10-23 23:28:07' AND DEVICE = 'MAX_159796' AND READING = 'onoff' AND VALUE ='0';
2017.12.14 11:05:45 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-10-24' AND TIMESTAMP < '2017-10-25' ;
2017.12.14 11:05:45 2: DbRep DBReporting - DBD::mysql::st execute failed: called with 2 bind variables when 0 are needed at ./FHEM/93_DbRep.pm line 3954.

2017.12.14 11:05:45 4: DbRep DBReporting -> BlockingCall delseqdoubl_DoParse finished
2017.12.14 11:05:45 4: DbRep DBReporting -> Start BlockingCall delseqdoubl_ParseDone
2017.12.14 11:05:45 4: DbRep DBReporting -> BlockingCall delseqdoubl_ParseDone finished
2017.12.14 11:05:56 3: ESPEasy: set ESPEasy_NodeMCU_2 neopixel 85 0 0 0

Edit: Hier noch das Listing...

[code]
Internals:
DATABASE fhem
DEF DbLog
LASTCMD delSeqDoublets delete
NAME DBReporting
NOTIFYDEV global,DBReporting
NR 625
NTFY_ORDER 50-DBReporting
ROLE Client
STATE error
TYPE DbRep
UTF8 0
VERSION 6.3.2
HELPER:
DBLOGDEVICE DbLog
CV:
aggregation day
aggsec 86400
destr 2017-11-01
dsstr 2017-08-01
epoch_seconds_end 1509490800
mestr 11
msstr 08
testr 00:00:00
tsstr 00:00:00
wdadd
yestr 2017
ysstr 2017
Helper:
DBLOG:
2017-10-21_07-23-08__MAX_159796__onoff:
DbLog:
TIME 1513241586.09021
VALUE 0

2017-10-21_07-38-54__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_07-53-56__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_08-08-58__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_08-23-58__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_08-38-07__MAX_159796__onoff:
DbLog:
TIME 1513241586.09021
VALUE 1

2017-10-21_08-53-08__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 1

2017-10-21_09-08-09__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 1

2017-10-21_09-21-19__MAX_159796__onoff:
DbLog:
TIME 1513241586.09021
VALUE 0

2017-10-21_09-36-20__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_09-51-31__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_10-06-32__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_10-21-32__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_10-36-35__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_10-52-20__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_11-51-53__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_12-08-03__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_12-23-04__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_12-38-06__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_12-53-07__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_13-08-08__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_13-23-10__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_13-38-37__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_13-53-37__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_14-22-37__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_14-37-37__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_14-52-56__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_15-07-57__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_15-22-58__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_15-37-58__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_15-52-58__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_16-08-00__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_16-23-01__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_16-38-06__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_16-53-07__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_17-08-09__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_17-23-10__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_17-38-11__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_17-53-17__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_18-08-21__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_18-23-22__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_18-38-43__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_18-53-57__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_19-08-59__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_19-23-59__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_19-39-01__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_19-54-02__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_20-09-03__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_20-24-04__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_20-39-06__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_20-54-06__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_21-09-07__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_21-24-08__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_21-39-08__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_21-54-09__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_22-09-09__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_22-24-10__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_22-39-10__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_22-54-12__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_23-09-14__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_23-24-14__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_23-39-16__MAX_159796__onoff:
DbLog:
TIME 1513241586.09021
VALUE 0

2017-10-21_23-54-17__MAX_159796__onoff:
DbLog:
TIME 1513241586.09021
VALUE 0

2017-10-22_00-09-18__MAX_159796__onoff:
DbLog:
TIME 1513241586.09021
VALUE 0

2017-10-22_00-24-19__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_00-39-29__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_00-54-30__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_01-09-30__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_01-24-32__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_01-39-37__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_01-54-38__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_02-09-40__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_02-24-42__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
&n

DS_Starter · 14 Dezember 2017, 11:23:57

Hast du alles richtig gemacht. Ich kann nur die Ursache des Fehlers nicht erkennen.
Mach nochmal ein list von deinem DBrep device.
und nochmal einen erneuten Lauf, aber mit Endtermin 24.10.

Grüsse
Heiko

supergrobi · 14 Dezember 2017, 11:39:30

hier das neue Log:

Code Auswählen

2017.12.14 11:36:40 4: DbRep DBReporting - -------- New selection --------- 
2017.12.14 11:36:40 4: DbRep DBReporting - Aggregation: no
2017.12.14 11:36:40 4: DbRep DBReporting - Command: delSeqDoublets
2017.12.14 11:36:40 4: DbRep DBReporting - Timestamp begin human readable: 2017-08-01 00:00:00
2017.12.14 11:36:40 4: DbRep DBReporting - Timestamp end human readable: 2017-10-24 00:00:00
2017.12.14 11:36:40 4: DbRep DBReporting -> Start BlockingCall delseqdoubl_DoParse
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-08-01 00:00:00' AND TIMESTAMP < '2017-08-02' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-08-02' AND TIMESTAMP < '2017-08-03' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-08-03' AND TIMESTAMP < '2017-08-04' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-08-04' AND TIMESTAMP < '2017-08-05' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-08-05' AND TIMESTAMP < '2017-08-06' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-08-06' AND TIMESTAMP < '2017-08-07' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-08-07' AND TIMESTAMP < '2017-08-08' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-08-08' AND TIMESTAMP < '2017-08-09' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-08-09' AND TIMESTAMP < '2017-08-10' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-08-10' AND TIMESTAMP < '2017-08-11' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-08-11' AND TIMESTAMP < '2017-08-12' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-08-12' AND TIMESTAMP < '2017-08-13' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-08-13' AND TIMESTAMP < '2017-08-14' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-08-14' AND TIMESTAMP < '2017-08-15' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-08-15' AND TIMESTAMP < '2017-08-16' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-08-16' AND TIMESTAMP < '2017-08-17' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-08-17' AND TIMESTAMP < '2017-08-18' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-08-18' AND TIMESTAMP < '2017-08-19' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-08-19' AND TIMESTAMP < '2017-08-20' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-08-20' AND TIMESTAMP < '2017-08-21' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-08-21' AND TIMESTAMP < '2017-08-22' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-08-22' AND TIMESTAMP < '2017-08-23' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-08-23' AND TIMESTAMP < '2017-08-24' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-08-24' AND TIMESTAMP < '2017-08-25' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-08-25' AND TIMESTAMP < '2017-08-26' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-08-26' AND TIMESTAMP < '2017-08-27' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-08-27' AND TIMESTAMP < '2017-08-28' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-08-28' AND TIMESTAMP < '2017-08-29' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-08-29' AND TIMESTAMP < '2017-08-30' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-08-30' AND TIMESTAMP < '2017-08-31' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-08-31' AND TIMESTAMP < '2017-09-01' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-09-01' AND TIMESTAMP < '2017-09-02' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-09-02' AND TIMESTAMP < '2017-09-03' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-09-03' AND TIMESTAMP < '2017-09-04' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-09-04' AND TIMESTAMP < '2017-09-05' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-09-05' AND TIMESTAMP < '2017-09-06' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-09-06' AND TIMESTAMP < '2017-09-07' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-09-07' AND TIMESTAMP < '2017-09-08' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-09-08' AND TIMESTAMP < '2017-09-09' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-09-09' AND TIMESTAMP < '2017-09-10' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-09-10' AND TIMESTAMP < '2017-09-11' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-09-11' AND TIMESTAMP < '2017-09-12' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-09-12' AND TIMESTAMP < '2017-09-13' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-09-13' AND TIMESTAMP < '2017-09-14' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-09-14' AND TIMESTAMP < '2017-09-15' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-09-15' AND TIMESTAMP < '2017-09-16' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-09-16' AND TIMESTAMP < '2017-09-17' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-09-17' AND TIMESTAMP < '2017-09-18' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-09-18' AND TIMESTAMP < '2017-09-19' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-09-19' AND TIMESTAMP < '2017-09-20' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-09-20' AND TIMESTAMP < '2017-09-21' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-09-21' AND TIMESTAMP < '2017-09-22' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-09-22' AND TIMESTAMP < '2017-09-23' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-09-23' AND TIMESTAMP < '2017-09-24' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-09-24' AND TIMESTAMP < '2017-09-25' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-09-25' AND TIMESTAMP < '2017-09-26' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-09-26' AND TIMESTAMP < '2017-09-27' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-09-27' AND TIMESTAMP < '2017-09-28' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-09-28' AND TIMESTAMP < '2017-09-29' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-09-29' AND TIMESTAMP < '2017-09-30' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-09-30' AND TIMESTAMP < '2017-10-01' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-10-01' AND TIMESTAMP < '2017-10-02' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-10-02' AND TIMESTAMP < '2017-10-03' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-10-03' AND TIMESTAMP < '2017-10-04' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-10-04' AND TIMESTAMP < '2017-10-05' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-10-05' AND TIMESTAMP < '2017-10-06' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-10-06' AND TIMESTAMP < '2017-10-07' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-10-07' AND TIMESTAMP < '2017-10-08' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-10-08' AND TIMESTAMP < '2017-10-09' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-10-09' AND TIMESTAMP < '2017-10-10' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-10-10' AND TIMESTAMP < '2017-10-11' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-10-11' AND TIMESTAMP < '2017-10-12' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-10-12' AND TIMESTAMP < '2017-10-13' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-10-13' AND TIMESTAMP < '2017-10-14' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-10-14' AND TIMESTAMP < '2017-10-15' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-10-15' AND TIMESTAMP < '2017-10-16' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-10-16' AND TIMESTAMP < '2017-10-17' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-10-17' AND TIMESTAMP < '2017-10-18' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-10-18' AND TIMESTAMP < '2017-10-19' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-10-19' AND TIMESTAMP < '2017-10-20' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-10-20' AND TIMESTAMP < '2017-10-21' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-10-21' AND TIMESTAMP < '2017-10-22' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-10-22' AND TIMESTAMP < '2017-10-23' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-10-23' AND TIMESTAMP < '2017-10-24' ;
2017.12.14 11:36:40 4: DbRep DBReporting - SQL execute: SELECT DEVICE,READING,TIMESTAMP,VALUE FROM history where DEVICE = 'MAX_159796' AND READING = 'onoff' AND TIMESTAMP >= '2017-10-24' AND TIMESTAMP < '2017-10-24 00:00:00' ;
2017.12.14 11:36:40 4: DbRep DBReporting -> BlockingCall delseqdoubl_DoParse finished
2017.12.14 11:36:40 4: DbRep DBReporting -> Start BlockingCall delseqdoubl_ParseDone
2017.12.14 11:36:40 4: DbRep DBReporting -> BlockingCall delseqdoubl_ParseDone finished

und das List...

[code]
Internals:
DATABASE fhem
DEF DbLog
LASTCMD delSeqDoublets delete
NAME DBReporting
NOTIFYDEV global,DBReporting
NR 625
NTFY_ORDER 50-DBReporting
ROLE Client
STATE done
TYPE DbRep
UTF8 0
VERSION 6.3.2
HELPER:
DBLOGDEVICE DbLog
CV:
aggregation day
aggsec 86400
destr 2017-10-24
dsstr 2017-08-01
epoch_seconds_end 1508796000
mestr 10
msstr 08
testr 00:00:00
tsstr 00:00:00
wdadd
yestr 2017
ysstr 2017
Helper:
DBLOG:
2017-10-21_07-23-08__MAX_159796__onoff:
DbLog:
TIME 1513247718.29388
VALUE 0

2017-10-21_07-38-54__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_07-53-56__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_08-08-58__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_08-23-58__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_08-38-07__MAX_159796__onoff:
DbLog:
TIME 1513247718.29388
VALUE 1

2017-10-21_08-53-08__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 1

2017-10-21_09-08-09__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 1

2017-10-21_09-21-19__MAX_159796__onoff:
DbLog:
TIME 1513247718.29388
VALUE 0

2017-10-21_09-36-20__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_09-51-31__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_10-06-32__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_10-21-32__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_10-36-35__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_10-52-20__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_11-51-53__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_12-08-03__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_12-23-04__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_12-38-06__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_12-53-07__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_13-08-08__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_13-23-10__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_13-38-37__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_13-53-37__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_14-22-37__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_14-37-37__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_14-52-56__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_15-07-57__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_15-22-58__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_15-37-58__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_15-52-58__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_16-08-00__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_16-23-01__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_16-38-06__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_16-53-07__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_17-08-09__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_17-23-10__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_17-38-11__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_17-53-17__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_18-08-21__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_18-23-22__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_18-38-43__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_18-53-57__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_19-08-59__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_19-23-59__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_19-39-01__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_19-54-02__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_20-09-03__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_20-24-04__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_20-39-06__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_20-54-06__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_21-09-07__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_21-24-08__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_21-39-08__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_21-54-09__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_22-09-09__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_22-24-10__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_22-39-10__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_22-54-12__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_23-09-14__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_23-24-14__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-21_23-39-16__MAX_159796__onoff:
DbLog:
TIME 1513247718.29388
VALUE 0

2017-10-21_23-54-17__MAX_159796__onoff:
DbLog:
TIME 1513247718.29388
VALUE 0

2017-10-22_00-09-18__MAX_159796__onoff:
DbLog:
TIME 1513247718.29388
VALUE 0

2017-10-22_00-24-19__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_00-39-29__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_00-54-30__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_01-09-30__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_01-24-32__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_01-39-37__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_01-54-38__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_02-09-40__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_02-24-42__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_02-39-44__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_02-54-45__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_03-09-46__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_03-24-46__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_03-39-47__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_03-54-49__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_04-10-16__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_04-25-17__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_04-40-18__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_04-55-18__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_05-10-20__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_05-25-21__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_05-40-21__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_05-55-22__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_06-10-24__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_06-25-25__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_06-40-25__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_06-55-26__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_07-10-27__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_07-25-28__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_07-40-29__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_07-55-30__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_08-10-31__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_08-25-33__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_08-40-34__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_08-55-36__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_09-10-37__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_09-25-39__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_09-40-40__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_09-55-41__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_10-10-42__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_10-25-44__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_10-40-44__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_10-55-47__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_11-10-47__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_11-25-50__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_11-40-50__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_11-55-52__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_12-10-54__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_12-18-37__MAX_159796__onoff:
DbLog:
TIME 1513247718.29388
VALUE 1

2017-10-22_12-33-38__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 1

2017-10-22_12-48-40__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 1

2017-10-22_13-03-41__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 1

2017-10-22_13-13-54__MAX_159796__onoff:
DbLog:
TIME 1513247718.29388
VALUE 0

2017-10-22_13-13-56__MAX_159796__onoff:
DbLog:
TIME 1513247718.29388
VALUE 1

2017-10-22_13-28-57__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 1

2017-10-22_13-37-07__MAX_159796__onoff:
DbLog:
TIME 1513247718.29388
VALUE 0

2017-10-22_13-52-09__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_14-07-11__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_14-22-11__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_14-37-12__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_14-52-13__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_15-07-14__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_15-22-15__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_15-37-16__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_15-52-17__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_16-07-18__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_16-22-19__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_16-37-21__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_16-52-22__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_17-07-22__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_17-22-24__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_17-37-25__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_17-52-27__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_18-07-29__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_18-22-29__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_18-37-30__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_18-52-31__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_19-07-33__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_19-22-35__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_19-37-36__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_19-53-40__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_20-08-59__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_20-24-00__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_20-39-00__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_20-54-01__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_21-09-02__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_21-24-02__MAX_159796__onoff:
DbLog:
TIME 1513241832.72518
VALUE 0

2017-10-22_21-39-04__MAX_159796__onoff:

DS_Starter · 14 Dezember 2017, 11:46:33

Hmmm, das list bringt auch keine neuen Erkenntnisse. Aberves wird klar dass das delete funktioniert, nur irgendwann gibt es in dem abzuarbeitenden Datensätzen einen der nicht den Anforderungen entspricht und dann kommt der Fehler.
Du kannst die Läufe mit verschiedenen Zeitabgrenzungen wiederholen.

Aber ich muss am WE schauen ob ich das verbose 4 logging etwas verändern kann um mehr zu sehen.

Grüsse
Heiko

supergrobi · 14 Dezember 2017, 19:43:17

Hallo Heiko,

danke Dir.
Mir ist aufgefallen, dass der Fehler bei kleinen Datenmengen (<62 Zeilen) nicht auftritt. Wobei ich noch nicht genau sagen kann ab welcher Grenze es zu dem Fehler kommt. Bei zu löschenden Zeilen = 62 trat der Fehler auf, die Zeilen wurden jedoch komplett gelöscht. Bei 185 zu löschenden Zeilen trat der Fehler auf, es wurden 92 gelöscht. Nach erneutem Aufruf (gleiche Parameter) wurde der Rest gelöscht (mit Fehlermeldung).
Danach hatte ich einen Monat ausgewählt. Hier war wohl die Zeilenmenge zu groß und FHEM hat sich aufgehängt. Der Perl Task lief mit ~75% CPU Last und FHEM meldete sich nach ca. 3h nicht mehr. Stop/Start FHEM oder Kill half da auch nicht mehr.

lg

Edit: hatte gestern noch etwas rumgespielt. Habe einen Tag aufgerufen bei dem >30000 Lines gelöscht werden sollten. Nach der Analyse mit adviceDelete blieb der fhem/perl Thread bei ~70% CPU Last. FHEM reagierte zwar noch, war aber dadurch halt sehr träge. Erst nach shutdown restart war alles wieder gut... zum löschen bin ich noch nicht gekommen.

DS_Starter · 15 Dezember 2017, 11:45:39

Hallo Thomas, @all,

habe das Problem bzgl. der "delSeqDoublets delete" Funktion gefunden und beseitigen können. Nachdem ich das bei mir nachstellen konnte, hat es sich herauskristallisiert, dass der Fehler nur auftrat nachdem ein tatsächlicher Löschvorgang durchgeführt wurde und danach ein weiterer Select vollzogen wurde (die Anzahl der Datensätze war nebensächlich) -> habe dann den Progammierfehler (Asche auf mein Haupt

) auch gleich gefunden.

Die andere Sache, Thomas, bezüglich:

ZitatNach der Analyse mit adviceDelete blieb der fhem/perl Thread bei ~70% CPU Last. FHEM reagierte zwar noch, war aber dadurch halt sehr träge. Erst nach shutdown restart war alles wieder gut... zum löschen bin ich noch nicht gekommen.

Das hat etwas damit zu tun, dass im Falle sehr großer an den Client zurückgelieferter Datenmengen (anzuzeigende Datensätze), es zu einer Übrlastung der Browsersession kommen kann. Das hat dann die dargestellten negativen Auswirkungen.
In der neuen Version habe ich die Berücksichtigung des Attributes "limit" (default: 1000) mit eingebaut. Bis jetzt war das bei "fetchrows" der Fall, wer das kennt.
Es wirkt sich so aus, dass bei "delSeqDoublets adviceDelete" bzw. "delSeqDoublets adviceRemain" nur die durch "limit" begrenzte Anzahl von Datensätzen zur Anzeige im Browser zurückgeliefert werden. Das bewahrt dann vor Überlastsituationen wenn z.B. 100000 zu löschende Datensätze angezeigt werden sollen.
Durch das Attribut "limit" kann man sich die Menge der anzuzeigenden Datensätze abändern.

Auf die eigentliche Löschfunktion "delSeqDoublets delete" hat diese Einstellung keinen Einfluss.

V6.4.2 im ersten Beitrag, probierts mal bitte aus ...

EDIT: setzt euch das Attribut "event-on-update-reading" generell auf state, damit nicht bei jedem generierten Reading ein Event erzeugt wird.
Grüße
Heiko

supergrobi · 15 Dezember 2017, 12:15:45

perfekt, Danke Dir!

ich probier das nachher mal aus.
hoffentlich krieg ich das hin ohne dem Widget

supergrobi · 15 Dezember 2017, 16:03:37

Vielen Dank!
es läuft.

DS_Starter · 15 Dezember 2017, 16:06:54

ZitatVielen Dank!
es läuft.

sehr schön

Ich mache die Version fertig und checke sie dann ein.
Danke für den Test !

Grüße
Heiko