Hallo,
ich habe hier DbLog, dass nicht so arbeitet wie ich es möchte.
list DbLog
Internals:
COLUMNS field length used for Device: 64, Type: 64, Event: 512, Reading: 64, Value: 128, Unit: 32
CONFIGURATION ./db.conf
DEF ./db.conf .*:(PV_DC|pvIn).*
FD 5
FUUID 6939d7ae-f33f-3e5d-3524-8475f9b5bfd5e436
FVERSION 93_DbLog.pm:v5.11.0-s29401/2024-12-05
MODE asynchronous
MODEL MYSQL
NAME csl_debian_DbLog
NR 2
NTFY_ORDER 50-csl_debian_DbLog
PID 164125
REGEXP .*:(PV_DC|pvIn).*
SBP_PID 164126
SBP_STATE running
STATE connected
TYPE DbLog
UTF8 1
dbconn mysql:database=fhem;host=localhost;port=3306
dbuser fhemuser
eventCount 612
HELPER:
COLSET 1
DEVICECOL 64
EVENTCOL 512
OLDSTATE connected
PACKAGE main
READINGCOL 64
TC current
TH history
TYPECOL 64
UNITCOL 32
VALUECOL 128
VERSION 5.11.0
OLDREADINGS:
READINGS:
2026-03-08 19:19:56 CacheOverflowLastNum 0
2026-03-08 15:14:57 CacheOverflowLastState normal
2026-03-08 19:20:07 CacheUsage 4
2026-03-08 19:19:56 NextSync 2026-03-08 19:20:26 or when CacheUsage 500 is reached
2026-03-08 19:20:07 notify_processing_time 0.0003
2026-03-08 19:19:56 state connected
Attributes:
DbLogType Current/History
asyncMode 1
room LOG
showNotifyTime 1
verbose 2
eine Datenbank:
MariaDB [fhem]> SHOW GRANTS FOR 'fhemuser'@'localhost';
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Grants for fhemuser@localhost |
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------+
| GRANT SELECT, INSERT, UPDATE, INDEX, CREATE VIEW, SHOW VIEW ON *.* TO `fhemuser`@`localhost` IDENTIFIED BY PASSWORD '*0A00846A5F41FFFFE0EAE0BFBF930679977C41F4' |
| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER ON `fhem`.* TO `fhemuser`@`localhost` |
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------+
und ein device:
2026-03-08 19:23:36 I_AC-Power 0.28871
2026-03-08 19:23:36 I_AC_Current 1.38
2026-03-08 19:23:36 I_AC_Energy_WH 1374.734
2026-03-08 19:23:36 I_DC_Power 0.2931
2026-03-08 19:23:36 I_Status On
2026-03-08 19:23:36 I_Temp_SF -2
2026-03-08 19:23:36 I_Temp_Sink 39.06
2026-03-08 19:23:36 M_AC_POWER 0.00
2026-03-08 19:23:36 M_AC_POWER_FeedIn 0
2026-03-08 19:23:36 M_AC_POWER_Purchased 0
2026-03-08 19:23:36 M_Energy_W_SF -3
2026-03-08 19:23:36 M_Exported 186.17
2026-03-08 19:23:36 M_Imported 951.46
2026-03-08 19:23:36 NetzHaus 0.000
2026-03-08 19:23:36 PV_DC 0.000
2026-03-08 19:23:36 pvIn 0.000
2026-03-08 19:23:36 pvOut 0.000
2026-03-08 18:54:24 state opened
der Event Monitor zeigt:
2026-03-08 19:28:21 ModbusAttr SE_10k PV_DC: 0.000
2026-03-08 19:28:21 ModbusAttr SE_10k BatNet: 0.360
2026-03-08 19:28:21 ModbusAttr SE_10k BatExport: 0.000
2026-03-08 19:28:21 ModbusAttr SE_10k BatHaus: 0.360
2026-03-08 19:28:21 ModbusAttr SE_10k PV_Export: 0.000
2026-03-08 19:28:21 ModbusAttr SE_10k PV_Haus: 0.005
2026-03-08 19:28:21 ModbusAttr SE_10k NetzHaus: 0.000
2026-03-08 19:28:21 DbLog csl_debian_DbLog notify_processing_time: 0.0021
2026-03-08 19:28:21 DbLog csl_debian_DbLog notify_processing_time: 0.0003
....
2026-03-08 19:30:34 ModbusAttr SE_10k WR_Effizienz: 0.985
2026-03-08 19:30:34 ModbusAttr SE_10k PV_DC: 0.000
2026-03-08 19:30:34 ModbusAttr SE_10k BatNet: 0.360
.....
2026-03-08 19:31:31 ModbusAttr SE_10k PV_Haus: 0.000
2026-03-08 19:31:31 ModbusAttr SE_10k NetzHaus: 0.000
2026-03-08 19:31:32 DbLog csl_debian_DbLog notify_processing_time: 0.0018
2026-03-08 19:31:32 DbLog csl_debian_DbLog notify_processing_time: 0.0002
entgegen aller Erwartungen
ergibt SELECT TIMESTAMP, DEVICE, READING, VALUE FROM history ORDER BY TIMESTAMP DESC LIMIT 10;
+---------------------+---------------------+------------------+-----------+
| TIMESTAMP | DEVICE | READING | VALUE |
+---------------------+---------------------+------------------+-----------+
| 2026-03-08 18:38:35 | SE_10k | state | CONNECTED |
| 2026-03-08 14:58:00 | SE_10k | vom_Dach | 2.712 |
| 2026-03-08 14:58:00 | YieldDay_M_Imported | state | 951.13 |
| 2026-03-08 14:58:00 | YieldDay_M_Exported | state | 183.90 |
| 2026-03-08 14:58:00 | SE_10k | pvOut | 2.420 |
| 2026-03-08 14:58:00 | SE_10k | etotal | 646.419 |
| 2026-03-08 14:58:00 | SE_10k | dc2ac | 0.000 |
| 2026-03-08 14:58:00 | SE_10k | ac2dc | 0.000 |
| 2026-03-08 14:58:00 | SE_10k | WR_Effizienz | 0.985 |
| 2026-03-08 14:58:00 | SE_10k | PV_Leistung-temp | 5.09 |
+---------------------+---------------------+------------------+-----------+
10 rows in set (0,001 sec)
Wenn man nun den timestamp betrachtet: es sind allesamt Einträge die _vor_ 2026-03-08 19:31:31 entstanden sind.
Diese Einträge kammen ausschließlich mit DbLog DEF ./db.conf .*
Sobald ich einen Filter anlege (s.o.) werden:
1. Einmalig die Filterwerte in DB übertragen
2.danach gar keine events in DB geschrieben.
Weiß jemand einen Rat?
Gruß
Martin
MODE asynchronous
Was meinst du damit?
Das bedeutet, dass DbLog auftretende events im Normalfall nicht sofort in die Datenbank schreibt, sondern diese "sammelt" und dann später wegschreibt. Dadurch werden die Datenbankzugriffe reduziert und die gesamte Performance des Loggings erhöht.
Erkannbar ist das z.B. in den von Dir geposteten readings:
2026-03-08 19:20:07 CacheUsage 4
2026-03-08 19:19:56 NextSync 2026-03-08 19:20:26 or when CacheUsage 500 is reached
Hier siehst Du, dass das nächste Schreiben in die Datenbank nach 30 Sekunden um 19:20:56 erfolgen wird.
Aber ich denke nicht, dass das etwas mit Deinem "Problem" zu tun hat.
Ehrlich gesagt, habe ich Dein Problem gestern beim Lesen schon nicht verstanden und ich verstehe es auch jetzt noch nicht ganz.
Wenn Du mit .* als regexp die gewünschten Werte ins Log bekommst und dann die regex ändert, wonach dann nix mehr gelogged wird, liegt die Vermutung nahe, dass Deine regex nicht wie gewünscht funktioniert.
Dann teste doch einfach mal Alternativen, z.B.:
DEF ./db.conf .*PV_DC.*|.*pvIn.*
Hallo betateilchen,
ja, es liegt nahe, dass regex nicht greift.
Ich habe es so gemeint:
REGEXP .*:(PV_DC|pvIn).* --> alle devices:(in den folgende readings vorkommen) die Werte.
Nach Änderung
Zitat von: betateilchen am 09 März 2026, 14:04:19DEF ./db.conf .*PV_DC.*|.*pvIn.*[/code]
bekomme ich weiter keine Einträge, auch nicht nach:
set csl_debian_DbLog commitCache
der CacheUsage ist danach zwar "0" aber es wird nichts in die DB geschrieben.
Nach
setreading SE_10k PV_DC 9.99
müsste (und wird) ein event erzeugt, das in die Db rein müsste
DbLog vorbose 5 sagt dann:
2026.03.09 14:42:10 4: csl_debian_DbLog - ################################################################
2026.03.09 14:42:10 4: csl_debian_DbLog - ### start of new Logcycle ###
2026.03.09 14:42:10 4: csl_debian_DbLog - ################################################################
2026.03.09 14:42:10 4: csl_debian_DbLog - number of events received: 1 of device: global
2026.03.09 14:42:10 4: csl_debian_DbLog - check Device: global , Event: ATTR csl_debian_DbLog verbose 5
2026.03.09 14:42:10 4: csl_debian_DbLog - ################################################################
2026.03.09 14:42:10 4: csl_debian_DbLog - ### start of new Logcycle ###
2026.03.09 14:42:10 4: csl_debian_DbLog - ################################################################
2026.03.09 14:42:10 4: csl_debian_DbLog - number of events received: 1 of device: csl_debian_DbLog
2026.03.09 14:42:10 4: csl_debian_DbLog - check Device: csl_debian_DbLog , Event: notify_processing_time: 0.0018
2026.03.09 14:42:13 4: csl_debian_DbLog - ################################################################
2026.03.09 14:42:13 4: csl_debian_DbLog - ### start of new Logcycle ###
2026.03.09 14:42:13 4: csl_debian_DbLog - ################################################################
2026.03.09 14:42:13 4: csl_debian_DbLog - number of events received: 30 of device: SE_10k
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: SE_10k , Event: I_AC_Current: 11.38
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: SE_10k , Event: I_AC-Power: 2.6963
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: SE_10k , Event: I_AC_Energy_WH: 1392.633
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: SE_10k , Event: I_DC_Power: 2.7374
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: SE_10k , Event: I_Temp_Sink: 42.47
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: SE_10k , Event: I_Temp_SF: -2
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: SE_10k , Event: I_Status: On
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: SE_10k , Event: BatIN_TOTAL_kWh: 978.10
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: SE_10k , Event: BatOUT_TOTAL_kWh: 923.15
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: SE_10k , Event: Leistungbezug_HM_Meter_kW: 0.00
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: SE_10k , Event: Energiebezug_HM_Meter_kWh: 874.70
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: SE_10k , Event: Leistung_FeedIN_HM_Meter_kW: 0.00
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: SE_10k , Event: Energie_FeedIN_HM_Meter_kWh: 179.90
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: SE_10k , Event: pvIn: 2.660
2026.03.09 14:42:13 5: csl_debian_DbLog - parsed Event: SE_10k , Event: pvIn: 2.660
2026.03.09 14:42:13 4: csl_debian_DbLog - added event - Timestamp: 2026-03-09 14:42:13, Device: SE_10k, Type: MODBUSATTR, Event: pvIn: 2.660, Reading: pvIn, Value: 2.660, Unit:
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: SE_10k , Event: pvOut: 2.460
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: SE_10k , Event: ac2dc: 0.000
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: SE_10k , Event: etotal: 663.345
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: SE_10k , Event: PV_Leistung-temp: 4.99
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: SE_10k , Event: PV_Leistung: 4.99
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: SE_10k , Event: Haus_Last_kW: 0.45
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: SE_10k , Event: vom_Dach: 2.737
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: SE_10k , Event: Hausverbrauch: 0.446
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: SE_10k , Event: WR_Effizienz: 0.985
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: SE_10k , Event: PV_DC: 2.737
2026.03.09 14:42:13 5: csl_debian_DbLog - parsed Event: SE_10k , Event: PV_DC: 2.737
2026.03.09 14:42:13 4: csl_debian_DbLog - added event - Timestamp: 2026-03-09 14:42:13, Device: SE_10k, Type: MODBUSATTR, Event: PV_DC: 2.737, Reading: PV_DC, Value: 2.737, Unit:
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: SE_10k , Event: BatNet: 0.000
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: SE_10k , Event: BatExport: 0.000
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: SE_10k , Event: BatHaus: 0.000
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: SE_10k , Event: PV_Export: 2.250
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: SE_10k , Event: PV_Haus: 0.446
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: SE_10k , Event: NetzHaus: 0.000
2026.03.09 14:42:13 4: csl_debian_DbLog - ################################################################
2026.03.09 14:42:13 4: csl_debian_DbLog - ### start of new Logcycle ###
2026.03.09 14:42:13 4: csl_debian_DbLog - ################################################################
2026.03.09 14:42:13 4: csl_debian_DbLog - number of events received: 1 of device: csl_debian_DbLog
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: csl_debian_DbLog , Event: notify_processing_time: 0.0110
2026.03.09 14:42:13 4: csl_debian_DbLog - ################################################################
2026.03.09 14:42:13 4: csl_debian_DbLog - ### start of new Logcycle ###
2026.03.09 14:42:13 4: csl_debian_DbLog - ################################################################
2026.03.09 14:42:13 4: csl_debian_DbLog - number of events received: 1 of device: YieldDay_M_Exported
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: YieldDay_M_Exported , Event: 196.46
2026.03.09 14:42:13 4: csl_debian_DbLog - ################################################################
2026.03.09 14:42:13 4: csl_debian_DbLog - ### start of new Logcycle ###
2026.03.09 14:42:13 4: csl_debian_DbLog - ################################################################
2026.03.09 14:42:13 4: csl_debian_DbLog - number of events received: 1 of device: csl_debian_DbLog
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: csl_debian_DbLog , Event: notify_processing_time: 0.0016
2026.03.09 14:42:13 4: csl_debian_DbLog - ################################################################
2026.03.09 14:42:13 4: csl_debian_DbLog - ### start of new Logcycle ###
2026.03.09 14:42:13 4: csl_debian_DbLog - ################################################################
2026.03.09 14:42:13 4: csl_debian_DbLog - number of events received: 1 of device: YieldDay_M_Imported
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: YieldDay_M_Imported , Event: 951.88
2026.03.09 14:42:13 4: csl_debian_DbLog - ################################################################
2026.03.09 14:42:13 4: csl_debian_DbLog - ### start of new Logcycle ###
2026.03.09 14:42:13 4: csl_debian_DbLog - ################################################################
2026.03.09 14:42:13 4: csl_debian_DbLog - number of events received: 1 of device: csl_debian_DbLog
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: csl_debian_DbLog , Event: notify_processing_time: 0.0014
2026.03.09 14:42:13 4: csl_debian_DbLog - ################################################################
2026.03.09 14:42:13 4: csl_debian_DbLog - ### start of new Logcycle ###
2026.03.09 14:42:13 4: csl_debian_DbLog - ################################################################
2026.03.09 14:42:13 4: csl_debian_DbLog - number of events received: 21 of device: SE_10k
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: SE_10k , Event: M_AC_POWER: 2.42
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: SE_10k , Event: M_Exported: 196.46
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: SE_10k , Event: M_Imported: 951.88
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: SE_10k , Event: M_Energy_W_SF: -3
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: SE_10k , Event: M_AC_POWER_Purchased: 0
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: SE_10k , Event: M_AC_POWER_FeedIn: 2.42
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: SE_10k , Event: Leistungbezug_HM_Meter_kW: 0.00
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: SE_10k , Event: Energiebezug_HM_Meter_kWh: 874.70
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: SE_10k , Event: Leistung_FeedIN_HM_Meter_kW: 0.00
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: SE_10k , Event: Energie_FeedIN_HM_Meter_kWh: 179.90
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: SE_10k , Event: Haus_Last_kW: 0.28
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: SE_10k , Event: vom_Dach: 2.737
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: SE_10k , Event: Hausverbrauch: 0.276
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: SE_10k , Event: WR_Effizienz: 0.985
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: SE_10k , Event: PV_DC: 2.737
2026.03.09 14:42:13 5: csl_debian_DbLog - parsed Event: SE_10k , Event: PV_DC: 2.737
2026.03.09 14:42:13 4: csl_debian_DbLog - added event - Timestamp: 2026-03-09 14:42:13, Device: SE_10k, Type: MODBUSATTR, Event: PV_DC: 2.737, Reading: PV_DC, Value: 2.737, Unit:
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: SE_10k , Event: BatNet: 0.000
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: SE_10k , Event: BatExport: 0.000
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: SE_10k , Event: BatHaus: 0.000
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: SE_10k , Event: PV_Export: 2.420
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: SE_10k , Event: PV_Haus: 0.276
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: SE_10k , Event: NetzHaus: 0.000
2026.03.09 14:42:13 4: csl_debian_DbLog - ################################################################
2026.03.09 14:42:13 4: csl_debian_DbLog - ### start of new Logcycle ###
2026.03.09 14:42:13 4: csl_debian_DbLog - ################################################################
2026.03.09 14:42:13 4: csl_debian_DbLog - number of events received: 1 of device: csl_debian_DbLog
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: csl_debian_DbLog , Event: notify_processing_time: 0.0064
2026.03.09 14:42:13 4: csl_debian_DbLog - ################################################################
2026.03.09 14:42:13 4: csl_debian_DbLog - ### start of new Logcycle ###
2026.03.09 14:42:13 4: csl_debian_DbLog - ################################################################
2026.03.09 14:42:13 4: csl_debian_DbLog - number of events received: 25 of device: SE_10k
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: SE_10k , Event: B_Average_Temperature: 19.7
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: SE_10k , Event: B_Instantaneous_Power: 0.00
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: SE_10k , Event: B_Available_Energy: 9.53
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: SE_10k , Event: B_State_of_Health: 99.0
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: SE_10k , Event: B_State_of_Energy: 98.9
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: SE_10k , Event: B_Status: TrickleCharge
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: SE_10k , Event: BatIn: 0
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: SE_10k , Event: BatOut: 0
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: SE_10k , Event: B_State_of_Energy_in_kWh: 9.43
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: SE_10k , Event: Leistungbezug_HM_Meter_kW: 0.00
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: SE_10k , Event: Energiebezug_HM_Meter_kWh: 874.70
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: SE_10k , Event: Leistung_FeedIN_HM_Meter_kW: 0.00
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: SE_10k , Event: Energie_FeedIN_HM_Meter_kWh: 179.90
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: SE_10k , Event: dc2ac: 0.000
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: SE_10k , Event: Haus_Last_kW: 0.28
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: SE_10k , Event: vom_Dach: 2.737
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: SE_10k , Event: Hausverbrauch: 0.276
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: SE_10k , Event: WR_Effizienz: 0.985
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: SE_10k , Event: PV_DC: 2.737
2026.03.09 14:42:13 5: csl_debian_DbLog - parsed Event: SE_10k , Event: PV_DC: 2.737
2026.03.09 14:42:13 4: csl_debian_DbLog - added event - Timestamp: 2026-03-09 14:42:13, Device: SE_10k, Type: MODBUSATTR, Event: PV_DC: 2.737, Reading: PV_DC, Value: 2.737, Unit:
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: SE_10k , Event: BatNet: 0.000
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: SE_10k , Event: BatExport: 0.000
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: SE_10k , Event: BatHaus: 0.000
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: SE_10k , Event: PV_Export: 2.420
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: SE_10k , Event: PV_Haus: 0.276
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: SE_10k , Event: NetzHaus: 0.000
2026.03.09 14:42:13 4: csl_debian_DbLog - ################################################################
2026.03.09 14:42:13 4: csl_debian_DbLog - ### start of new Logcycle ###
2026.03.09 14:42:13 4: csl_debian_DbLog - ################################################################
2026.03.09 14:42:13 4: csl_debian_DbLog - number of events received: 1 of device: csl_debian_DbLog
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: csl_debian_DbLog , Event: notify_processing_time: 0.0094
2026.03.09 14:42:13 4: csl_debian_DbLog - ################################################################
2026.03.09 14:42:13 4: csl_debian_DbLog - ### start of new Logcycle ###
2026.03.09 14:42:13 4: csl_debian_DbLog - ################################################################
2026.03.09 14:42:13 4: csl_debian_DbLog - number of events received: 3 of device: NODERED_CSL
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: NODERED_CSL , Event: 1_1_Speicher-Leistung: 0
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: NODERED_CSL , Event: 1_1_time: 2026-03-09T13:42:13.505Z
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: NODERED_CSL , Event: 1_2_inverter: 1
2026.03.09 14:42:13 4: csl_debian_DbLog - ################################################################
2026.03.09 14:42:13 4: csl_debian_DbLog - ### start of new Logcycle ###
2026.03.09 14:42:13 4: csl_debian_DbLog - ################################################################
2026.03.09 14:42:13 4: csl_debian_DbLog - number of events received: 1 of device: csl_debian_DbLog
2026.03.09 14:42:13 4: csl_debian_DbLog - check Device: csl_debian_DbLog , Event: notify_processing_time: 0.0017
2026.03.09 14:42:17 4: csl_debian_DbLog - ################################################################
2026.03.09 14:42:17 4: csl_debian_DbLog - ### start of new Logcycle ###
2026.03.09 14:42:17 4: csl_debian_DbLog - ################################################################
2026.03.09 14:42:17 4: csl_debian_DbLog - number of events received: 15 of device: SE_10k
2026.03.09 14:42:17 4: csl_debian_DbLog - check Device: SE_10k , Event: PV_DC: 9.99
2026.03.09 14:42:17 5: csl_debian_DbLog - parsed Event: SE_10k , Event: PV_DC: 9.99
2026.03.09 14:42:17 4: csl_debian_DbLog - added event - Timestamp: 2026-03-09 14:42:17, Device: SE_10k, Type: MODBUSATTR, Event: PV_DC: 9.99, Reading: PV_DC, Value: 9.99, Unit:
2026.03.09 14:42:17 4: csl_debian_DbLog - check Device: SE_10k , Event: Leistungbezug_HM_Meter_kW: 0.00
2026.03.09 14:42:17 4: csl_debian_DbLog - check Device: SE_10k , Event: Energiebezug_HM_Meter_kWh: 874.70
2026.03.09 14:42:17 4: csl_debian_DbLog - check Device: SE_10k , Event: Leistung_FeedIN_HM_Meter_kW: 0.00
2026.03.09 14:42:17 4: csl_debian_DbLog - check Device: SE_10k , Event: Energie_FeedIN_HM_Meter_kWh: 179.90
2026.03.09 14:42:17 4: csl_debian_DbLog - check Device: SE_10k , Event: Haus_Last_kW: 0.28
2026.03.09 14:42:17 4: csl_debian_DbLog - check Device: SE_10k , Event: vom_Dach: 2.737
2026.03.09 14:42:17 4: csl_debian_DbLog - check Device: SE_10k , Event: Hausverbrauch: 0.276
2026.03.09 14:42:17 4: csl_debian_DbLog - check Device: SE_10k , Event: WR_Effizienz: 0.985
2026.03.09 14:42:17 4: csl_debian_DbLog - check Device: SE_10k , Event: BatNet: 0.000
2026.03.09 14:42:17 4: csl_debian_DbLog - check Device: SE_10k , Event: BatExport: 0.000
2026.03.09 14:42:17 4: csl_debian_DbLog - check Device: SE_10k , Event: BatHaus: 0.000
2026.03.09 14:42:17 4: csl_debian_DbLog - check Device: SE_10k , Event: PV_Export: 2.420
2026.03.09 14:42:17 4: csl_debian_DbLog - check Device: SE_10k , Event: PV_Haus: 0.276
2026.03.09 14:42:17 4: csl_debian_DbLog - check Device: SE_10k , Event: NetzHaus: 0.000
2026.03.09 14:42:17 4: csl_debian_DbLog - ################################################################
2026.03.09 14:42:17 4: csl_debian_DbLog - ### start of new Logcycle ###
2026.03.09 14:42:17 4: csl_debian_DbLog - ################################################################
2026.03.09 14:42:17 4: csl_debian_DbLog - number of events received: 1 of device: csl_debian_DbLog
2026.03.09 14:42:17 4: csl_debian_DbLog - check Device: csl_debian_DbLog , Event: notify_processing_time: 0.0075
2026.03.09 14:42:27 4: csl_debian_DbLog - ################################################################
2026.03.09 14:42:27 4: csl_debian_DbLog - ### start of new Logcycle ###
2026.03.09 14:42:27 4: csl_debian_DbLog - ################################################################
2026.03.09 14:42:27 4: csl_debian_DbLog - number of events received: 18 of device: SolCast_Debian
2026.03.09 14:42:27 4: csl_debian_DbLog - check Device: SolCast_Debian , Event: nextCycletime: 14:43:36
2026.03.09 14:42:27 4: csl_debian_DbLog - check Device: SolCast_Debian , Event: Current_PV: 9990 W
2026.03.09 14:42:27 4: csl_debian_DbLog - check Device: SolCast_Debian , Event: Today_Hour15_PVreal: 2101 Wh
2026.03.09 14:42:27 4: csl_debian_DbLog - check Device: SolCast_Debian , Event: Today_CONdeviation: -22.44 %
2026.03.09 14:42:27 4: csl_debian_DbLog - check Device: SolCast_Debian , Event: Current_GridFeedIn: 2420 W
2026.03.09 14:42:27 4: csl_debian_DbLog - check Device: SolCast_Debian , Event: Current_Consumption: 7570 W
2026.03.09 14:42:27 4: csl_debian_DbLog - check Device: SolCast_Debian , Event: Current_SelfConsumption: 7570 W
2026.03.09 14:42:27 4: csl_debian_DbLog - check Device: SolCast_Debian , Event: Current_SelfConsumptionRate: 76 %
2026.03.09 14:42:27 4: csl_debian_DbLog - check Device: SolCast_Debian , Event: Current_Surplus: 2420 W
2026.03.09 14:42:27 4: csl_debian_DbLog - check Device: SolCast_Debian , Event: NextHours_Sum01_PVforecast: 2517 Wh
2026.03.09 14:42:27 4: csl_debian_DbLog - check Device: SolCast_Debian , Event: NextHours_Sum02_PVforecast: 4091 Wh
2026.03.09 14:42:27 4: csl_debian_DbLog - check Device: SolCast_Debian , Event: NextHours_Sum03_PVforecast: 5042 Wh
2026.03.09 14:42:27 4: csl_debian_DbLog - check Device: SolCast_Debian , Event: NextHours_Sum04_PVforecast: 5314 Wh
2026.03.09 14:42:27 4: csl_debian_DbLog - check Device: SolCast_Debian , Event: RestOfDayPVforecast: 5330 Wh
2026.03.09 14:42:27 4: csl_debian_DbLog - check Device: SolCast_Debian , Event: Today_CONreal: 8220 Wh
2026.03.09 14:42:27 4: csl_debian_DbLog - check Device: SolCast_Debian , Event: Today_PVreal: 16355 Wh
2026.03.09 14:42:27 4: csl_debian_DbLog - check Device: SolCast_Debian , Event: NextHours_Sum04_ConsumptionForecast: 1903 Wh
2026.03.09 14:42:27 4: csl_debian_DbLog - check Device: SolCast_Debian , Event: RestOfDayConsumptionForecast: 6227 Wh
2026.03.09 14:42:27 4: csl_debian_DbLog - ################################################################
2026.03.09 14:42:27 4: csl_debian_DbLog - ### start of new Logcycle ###
2026.03.09 14:42:27 4: csl_debian_DbLog - ################################################################
2026.03.09 14:42:27 4: csl_debian_DbLog - number of events received: 1 of device: csl_debian_DbLog
2026.03.09 14:42:27 4: csl_debian_DbLog - check Device: csl_debian_DbLog , Event: notify_processing_time: 0.0044
2026.03.09 14:42:27 4: csl_debian_DbLog - ################################################################
2026.03.09 14:42:27 4: csl_debian_DbLog - ### New database processing cycle - SBP asynchronous ###
2026.03.09 14:42:27 4: csl_debian_DbLog - ################################################################
2026.03.09 14:42:27 4: csl_debian_DbLog - MemCache contains 5 entries to process
2026.03.09 14:42:27 4: csl_debian_DbLog - DbLogType is: Current/History
2026.03.09 14:42:27 4: csl_debian_DbLog - ################################################################
2026.03.09 14:42:27 4: csl_debian_DbLog - ### start of new Logcycle ###
2026.03.09 14:42:27 4: csl_debian_DbLog - ################################################################
2026.03.09 14:42:27 4: csl_debian_DbLog - number of events received: 1 of device: csl_debian_DbLog
2026.03.09 14:42:27 4: csl_debian_DbLog - check Device: csl_debian_DbLog , Event: CacheOverflowLastNum: 0
2026.03.09 14:42:27 5: csl_debian_DbLog - MemCache contains: 201 -> 2026-03-09 14:42:13|SE_10k|MODBUSATTR|pvIn: 2.660|pvIn|2.660|
2026.03.09 14:42:27 5: csl_debian_DbLog - MemCache contains: 202 -> 2026-03-09 14:42:13|SE_10k|MODBUSATTR|PV_DC: 2.737|PV_DC|2.737|
2026.03.09 14:42:27 5: csl_debian_DbLog - MemCache contains: 203 -> 2026-03-09 14:42:13|SE_10k|MODBUSATTR|PV_DC: 2.737|PV_DC|2.737|
2026.03.09 14:42:27 5: csl_debian_DbLog - MemCache contains: 204 -> 2026-03-09 14:42:13|SE_10k|MODBUSATTR|PV_DC: 2.737|PV_DC|2.737|
2026.03.09 14:42:27 5: csl_debian_DbLog - MemCache contains: 205 -> 2026-03-09 14:42:17|SE_10k|MODBUSATTR|PV_DC: 9.99|PV_DC|9.99|
2026.03.09 14:42:27 4: csl_debian_DbLog - Operation: log_asynch
2026.03.09 14:42:27 5: csl_debian_DbLog - DbLogType: Current/History
2026.03.09 14:42:27 4: csl_debian_DbLog - AutoCommit: ON, Transaction: ON
2026.03.09 14:42:27 4: csl_debian_DbLog - Insert mode: Array
2026.03.09 14:42:27 4: csl_debian_DbLog - Primary Key used in history: DEVICE,READING
2026.03.09 14:42:27 4: csl_debian_DbLog - Primary Key used in current: DEVICE,READING
2026.03.09 14:42:27 5: csl_debian_DbLog - processing 201 -> TS: 2026-03-09 14:42:13, Dev: SE_10k, Type: MODBUSATTR, Event: pvIn: 2.660, Reading: pvIn, Val: 2.660, Unit:
2026.03.09 14:42:27 5: csl_debian_DbLog - processing 202 -> TS: 2026-03-09 14:42:13, Dev: SE_10k, Type: MODBUSATTR, Event: PV_DC: 2.737, Reading: PV_DC, Val: 2.737, Unit:
2026.03.09 14:42:27 5: csl_debian_DbLog - processing 203 -> TS: 2026-03-09 14:42:13, Dev: SE_10k, Type: MODBUSATTR, Event: PV_DC: 2.737, Reading: PV_DC, Val: 2.737, Unit:
2026.03.09 14:42:27 5: csl_debian_DbLog - processing 204 -> TS: 2026-03-09 14:42:13, Dev: SE_10k, Type: MODBUSATTR, Event: PV_DC: 2.737, Reading: PV_DC, Val: 2.737, Unit:
2026.03.09 14:42:27 5: csl_debian_DbLog - processing 205 -> TS: 2026-03-09 14:42:17, Dev: SE_10k, Type: MODBUSATTR, Event: PV_DC: 9.99, Reading: PV_DC, Val: 9.99, Unit:
2026.03.09 14:42:27 4: csl_debian_DbLog - begin Transaction
2026.03.09 14:42:27 4: csl_debian_DbLog - 5 of 5 events inserted into table history using PK on columns DEVICE,READING
2026.03.09 14:42:27 4: csl_debian_DbLog - commit inserted data table >history<
2026.03.09 14:42:27 4: csl_debian_DbLog - begin Transaction
2026.03.09 14:42:27 4: csl_debian_DbLog - 5 of 5 events updated in table current using PK on columns DEVICE,READING
2026.03.09 14:42:27 4: csl_debian_DbLog - commit inserted data table >current<
2026.03.09 14:42:28 4: csl_debian_DbLog - ################################################################
2026.03.09 14:42:28 4: csl_debian_DbLog - ### start of new Logcycle ###
2026.03.09 14:42:28 4: csl_debian_DbLog - ################################################################
2026.03.09 14:42:28 4: csl_debian_DbLog - number of events received: 1 of device: SolCast_Debian
2026.03.09 14:42:28 4: csl_debian_DbLog - check Device: SolCast_Debian , Event: state: updated
2026.03.09 14:42:28 4: csl_debian_DbLog - ################################################################
2026.03.09 14:42:28 4: csl_debian_DbLog - ### start of new Logcycle ###
2026.03.09 14:42:28 4: csl_debian_DbLog - ################################################################
2026.03.09 14:42:28 4: csl_debian_DbLog - number of events received: 1 of device: csl_debian_DbLog
2026.03.09 14:42:28 4: csl_debian_DbLog - check Device: csl_debian_DbLog , Event: notify_processing_time: 0.0019
und in der Db keine Spur vom SE_10k PV_DC 9.99
Etwas ratlos
Martin
Zeig doch mal bitte ein vollständiges list von dem device, das Du gerne loggen möchtest.
Danke für deine Zeit!
list SE_10k:
Internals:
DEF 1 19 192.168.2.40 TCP
DeviceName 192.168.2.40:502
EXPECT idle
FD 16
FUUID 69a041c3-f33f-3e5d-aa24-15098763127d2b28
IODev SE_10k
Interval 19
LASTOPEN 1773034548.98278
MODBUSID 1
MODE master
MODULEVERSION Modbus 5.0.1 - 7.12.2025
NAME SE_10k
NOTIFYDEV global
NR 59
NTFY_ORDER 50-SE_10k
PARTIAL
PROTOCOL TCP
STATE vom Dach:0.583 kW, zum Speicher: 0 kW, ins Netz: 0.320 kW, ins Haus: 0.254 kW, vom Speicher: 0 kW, im Speicher ist noch: 9.43 kWh
TCPConn 1
TYPE ModbusAttr
devioLoglevel 3
devioNoSTATE 1
eventCount 12479
nextOpenDelay 60
DICACHE:
3:
UNPACK
EXPRS:
EXTRAS:
FNAMES:
Helper:
DBLOG:
B_Available_Energy:
csl_debian_DbLog:
TIME 1772993969.49062
VALUE 9.53
B_Average_Temperature:
csl_debian_DbLog:
TIME 1772993969.49062
VALUE 19.3
B_Instantaneous_Power:
csl_debian_DbLog:
TIME 1772993969.49062
VALUE -0.37
B_State_of_Energy:
csl_debian_DbLog:
TIME 1772993969.49062
VALUE 92.6
B_State_of_Energy_in_kWh:
csl_debian_DbLog:
TIME 1772993969.49062
VALUE 8.82
B_State_of_Health:
csl_debian_DbLog:
TIME 1772993969.49062
VALUE 99.0
B_Status:
csl_debian_DbLog:
TIME 1772993969.49062
VALUE Discharge
BatExport:
csl_debian_DbLog:
TIME 1772993969.49062
VALUE 0.010
BatHaus:
csl_debian_DbLog:
TIME 1772993969.49062
VALUE 0.360
BatIN_TOTAL_kWh:
csl_debian_DbLog:
TIME 1772993969.1459
VALUE 971.86
BatIn:
csl_debian_DbLog:
TIME 1772993969.49062
VALUE 0
BatNet:
csl_debian_DbLog:
TIME 1772993969.49062
VALUE 0.370
BatOUT_TOTAL_kWh:
csl_debian_DbLog:
TIME 1772993969.1459
VALUE 917.53
BatOut:
csl_debian_DbLog:
TIME 1772993969.49062
VALUE 0.37
Energie_FeedIN_HM_Meter_kWh:
csl_debian_DbLog:
TIME 1772993969.49062
VALUE 169.70
Energiebezug_HM_Meter_kWh:
csl_debian_DbLog:
TIME 1772993969.49062
VALUE 874.20
Haus_Last_kW:
csl_debian_DbLog:
TIME 1772993969.49062
VALUE 0.29
Hausverbrauch:
csl_debian_DbLog:
TIME 1772993969.49062
VALUE 0.288
I_AC-Power:
csl_debian_DbLog:
TIME 1772993969.1459
VALUE 0.29793
I_AC_Current:
csl_debian_DbLog:
TIME 1772993969.1459
VALUE 1.43
I_AC_Energy_WH:
csl_debian_DbLog:
TIME 1772993969.1459
VALUE 1374.713
I_DC_Power:
csl_debian_DbLog:
TIME 1772993969.1459
VALUE 0.3024
I_Status:
csl_debian_DbLog:
TIME 1772993969.1459
VALUE On
I_Temp_SF:
csl_debian_DbLog:
TIME 1772993969.1459
VALUE -2
I_Temp_Sink:
csl_debian_DbLog:
TIME 1772993969.1459
VALUE 39
Leistung_FeedIN_HM_Meter_kW:
csl_debian_DbLog:
TIME 1772993969.49062
VALUE 0.00
Leistungbezug_HM_Meter_kW:
csl_debian_DbLog:
TIME 1772993969.49062
VALUE 0.00
M_AC_POWER:
csl_debian_DbLog:
TIME 1772993969.36704
VALUE 0.01
M_AC_POWER_FeedIn:
csl_debian_DbLog:
TIME 1772993969.36704
VALUE 0.01
M_AC_POWER_Purchased:
csl_debian_DbLog:
TIME 1772993969.36704
VALUE 0
M_Energy_W_SF:
csl_debian_DbLog:
TIME 1772993969.36704
VALUE -3
M_Exported:
csl_debian_DbLog:
TIME 1772993969.36704
VALUE 186.17
M_Imported:
csl_debian_DbLog:
TIME 1772993969.36704
VALUE 951.46
NetzHaus:
csl_debian_DbLog:
TIME 1772993969.49062
VALUE 0.000
PV_DC:
csl_debian_DbLog:
TIME 1773071775.31023
VALUE 0.583
PV_Export:
csl_debian_DbLog:
TIME 1772993969.49062
VALUE 0.000
PV_Haus:
csl_debian_DbLog:
TIME 1772993969.49062
VALUE 0.004
PV_Leistung:
csl_debian_DbLog:
TIME 1772993969.1459
VALUE 0
PV_Leistung-temp:
csl_debian_DbLog:
TIME 1772993969.1459
VALUE 0.02
WR_Effizienz:
csl_debian_DbLog:
TIME 1772993969.49062
VALUE 0.985
ac2dc:
csl_debian_DbLog:
TIME 1772993969.1459
VALUE 0.000
dc2ac:
csl_debian_DbLog:
TIME 1772993969.49062
VALUE 0.292
etotal:
csl_debian_DbLog:
TIME 1772993969.1459
VALUE 649.864
pvIn:
csl_debian_DbLog:
TIME 1773071775.02316
VALUE 0.485
pvOut:
csl_debian_DbLog:
TIME 1772993969.1459
VALUE 0.000
state:
csl_debian_DbLog:
TIME 1772992464.90796
VALUE CONNECTED
vom_Dach:
csl_debian_DbLog:
TIME 1772993969.49062
VALUE -0.068
OICACHE:
QUEUE:
READ:
BUFFER
READINGS:
2026-03-09 16:56:15 B_Available_Energy 9.53
2026-03-09 16:56:15 B_Average_Temperature 19.2
2026-03-09 16:56:15 B_Instantaneous_Power 0.00
2026-03-09 16:56:15 B_State_of_Energy 98.9
2026-03-09 16:56:15 B_State_of_Energy_in_kWh 9.43
2026-03-09 16:56:15 B_State_of_Health 99.0
2026-03-09 16:56:15 B_Status TrickleCharge
2026-03-09 16:56:15 BatExport 0.000
2026-03-09 16:56:15 BatHaus 0.000
2026-03-09 16:56:15 BatIN_TOTAL_kWh 978.10
2026-03-09 16:56:15 BatIn 0
2026-03-09 16:56:15 BatNet 0.000
2026-03-09 16:56:15 BatOUT_TOTAL_kWh 923.16
2026-03-09 16:56:15 BatOut 0
2026-03-09 16:56:15 Energie_FeedIN_HM_Meter_kWh 182.70
2026-03-09 16:56:15 Energiebezug_HM_Meter_kWh 874.70
2026-03-09 16:56:15 Haus_Last_kW 0.25
2026-03-09 16:56:15 Hausverbrauch 0.254
2026-03-09 16:56:15 I_AC-Power 0.5743
2026-03-09 16:56:15 I_AC_Current 2.53
2026-03-09 16:56:15 I_AC_Energy_WH 1396.35
2026-03-09 16:56:15 I_DC_Power 0.5831
2026-03-09 16:56:15 I_Status On
2026-03-09 16:56:15 I_Temp_SF -2
2026-03-09 16:56:15 I_Temp_Sink 40.56
2026-03-09 16:56:15 Leistung_FeedIN_HM_Meter_kW 0.00
2026-03-09 16:56:15 Leistungbezug_HM_Meter_kW 0.00
2026-03-09 16:56:15 M_AC_POWER 0.32
2026-03-09 16:56:15 M_AC_POWER_FeedIn 0.32
2026-03-09 16:56:15 M_AC_POWER_Purchased 0
2026-03-09 16:56:15 M_Energy_W_SF -3
2026-03-09 16:56:15 M_Exported 199.30
2026-03-09 16:56:15 M_Imported 951.88
2026-03-09 16:56:15 NetzHaus 0.000
2026-03-09 16:56:15 PV_DC 0.583
2026-03-09 16:56:15 PV_Export 0.320
2026-03-09 16:56:15 PV_Haus 0.254
2026-03-09 16:56:15 PV_Leistung 0.90
2026-03-09 16:56:15 PV_Leistung-temp 0.90
2026-03-09 16:56:15 WR_Effizienz 0.985
2026-03-09 16:56:15 ac2dc 0.000
2026-03-09 16:56:15 dc2ac 0.000
2026-03-09 16:56:15 etotal 667.054
2026-03-09 16:56:15 pvIn 0.485
2026-03-09 16:56:15 pvOut 0.350
2026-03-09 06:35:48 state opened
2026-03-09 16:56:15 vom_Dach 0.583
REMEMBER:
lid 1
lname SE_10k
lrecv 1773071775.29285
lsend 1773071775.2368
UPDATECACHE:
h40071:
adr 40071
combine h40071 len 5 I_AC_Current with h40083 len 2 I_AC-Power and h40093 len 3 I_AC_Energy_WH and h40100 len 2 I_DC_Power and h40103 len 1 I_Temp_Sink and h40106 len 1 I_Temp_SF and h40107 len 1 I_Status
len 5
objCombi h40071
reading I_AC_Current
span 37
type h
h40206:
adr 40206
combine h40206 len 5 M_AC_POWER with h40226 len 2 M_Exported and h40234 len 2 M_Imported and h40242 len 1 M_Energy_W_SF
len 5
objCombi h40206
reading M_AC_POWER
span 37
type h
h62828:
adr 62828
combine h62828 len 2 B_Average_Temperature with h62836 len 2 B_Instantaneous_Power and h62848 len 2 B_Available_Energy and h62850 len 2 B_State_of_Health and h62852 len 2 B_State_of_Energy and h62854 len 2 B_Status
len 2
objCombi h62828
reading B_Average_Temperature
span 28
type h
defptr:
SE_10k 1
gotReadings:
B_Available_Energy 9.53
B_Average_Temperature 19.2
B_Instantaneous_Power 0.00
B_State_of_Energy 98.9
B_State_of_Health 99.0
B_Status TrickleCharge
hmccu:
lastRead:
h40071 1773071775.00384
h40083 1773071775.00444
h40093 1773071775.00492
h40100 1773071775.00534
h40103 1773071775.00585
h40106 1773071775.00597
h40107 1773071775.00632
h40206 1773071775.15331
h40226 1773071775.15394
h40234 1773071775.15451
h40242 1773071775.15459
h62828 1773071775.303
h62836 1773071775.30338
h62848 1773071775.30363
h62850 1773071775.30374
h62852 1773071775.30385
h62854 1773071775.30403
Attributes:
dev-h-combine 105
dev-h-defPoll 1
dev-h-defShowGet 1
enableControlSet 1
icon measure_power@green
maxTimeoutsToReconnect 3
obj-h40071-expr ($val[0] * (10 ** $val[4]))
obj-h40071-len 5
obj-h40071-reading I_AC_Current
obj-h40071-unpack s>s>s>s>s>
obj-h40083-expr ($val * (10 ** $val[1]))/1000
obj-h40083-len 2
obj-h40083-reading I_AC-Power
obj-h40083-unpack s>s>
obj-h40093-expr $val * (10 ** $val[1])/1000
obj-h40093-len 3
obj-h40093-reading I_AC_Energy_WH
obj-h40093-unpack l>s>
obj-h40100-expr $val * (10 ** $val[1])/1000
obj-h40100-len 2
obj-h40100-reading I_DC_Power
obj-h40100-unpack s>s>
obj-h40103-expr $val * (10 ** ReadingsNum ($name ,'I_Temp_SF',0))
obj-h40103-len 1
obj-h40103-reading I_Temp_Sink
obj-h40103-unpack s>
obj-h40106-reading I_Temp_SF
obj-h40106-unpack s>
obj-h40107-map 1:Off, 2:Sleeping, 3:Starting, 4:On, 5:Throttled, 6:ShuttingDown, 7:Fault, 8:Maintenance
obj-h40107-reading I_Status
obj-h40206-expr ($val[0] * (10 ** $val[4]))/1000
obj-h40206-format %.2f
obj-h40206-len 5
obj-h40206-reading M_AC_POWER
obj-h40206-unpack s>s>s>s>s>
obj-h40226-expr $val * (10 ** ReadingsNum ($name ,'M_Energy_W_SF',0))/1000
obj-h40226-format %.2f
obj-h40226-len 2
obj-h40226-reading M_Exported
obj-h40226-unpack N
obj-h40234-expr $val * (10 ** ReadingsNum ($name ,'M_Energy_W_SF',0))/1000
obj-h40234-format %.2f
obj-h40234-len 2
obj-h40234-reading M_Imported
obj-h40234-unpack N
obj-h40242-reading M_Energy_W_SF
obj-h40242-unpack s>
obj-h62828-format %.1f
obj-h62828-len 2
obj-h62828-reading B_Average_Temperature
obj-h62828-revRegs 1
obj-h62828-unpack f>
obj-h62836-expr $val / 1000
obj-h62836-format %.2f
obj-h62836-len 2
obj-h62836-reading B_Instantaneous_Power
obj-h62836-revRegs 1
obj-h62836-unpack f>
obj-h62848-expr $val / 1000
obj-h62848-format %.2f
obj-h62848-len 2
obj-h62848-reading B_Available_Energy
obj-h62848-revRegs 1
obj-h62848-unpack f>
obj-h62850-format %.1f
obj-h62850-len 2
obj-h62850-reading B_State_of_Health
obj-h62850-revRegs 1
obj-h62850-unpack f>
obj-h62852-format %.1f
obj-h62852-len 2
obj-h62852-reading B_State_of_Energy
obj-h62852-revRegs 1
obj-h62852-unpack f>
obj-h62854-len 2
obj-h62854-map 0:Off, 1:Standby, 2:Init, 3:Charge, 4:Discharge, 5:Fault, 6:TrickleCharge,7:Idle, 10: PowerSaving
obj-h62854-reading B_Status
room Solar
stateFormat vom Dach:PV_DC kW, zum Speicher: BatIn kW, ins Netz: PV_Export kW, ins Haus: PV_Haus kW, vom Speicher: BatOut kW, im Speicher ist noch: B_State_of_Energy_in_kWh kWh
userReadings BatIn:B_Instantaneous_Power.* {
my $pwr = ReadingsNum ($name, 'B_Instantaneous_Power', 0);
$pwr = $pwr > 0 ? $pwr : 0;
$pwr;
},
BatOut:B_Instantaneous_Power.* {
my $pwr = ReadingsNum ($name, 'B_Instantaneous_Power', 0);
$pwr = $pwr < 0 ? abs $pwr : 0;
$pwr;
},
B_State_of_Energy_in_kWh:B_State_of_Energy.* {
sprintf("%.2f", ReadingsNum ($name,'B_State_of_Energy',0)*(ReadingsNum ($name,'B_Available_Energy',0)/100))
},
BatIN_TOTAL_kWh:I_AC-Power.* {
my $batIN = ReadingsNum ('MD_SolarEdge','storage-7B083F14-lifeTimeEnergyCharged',0)/1000;
my $result =0;
$result= $batIN;
return sprintf("%.2f",$batIN);
},
BatOUT_TOTAL_kWh:I_AC-Power.* {
my $batOUT = ReadingsNum ('MD_SolarEdge','storage-7B083F14-lifeTimeEnergyDischarged',0)/1000;
my $result =0;
$result= $batOUT;
return sprintf("%.2f",$batOUT);
},
M_AC_POWER_Purchased:M_AC_POWER.* {
my $pwr = ReadingsNum ($name, 'M_AC_POWER', 0);
$pwr = $pwr < 0 ? abs $pwr : 0;
return $pwr;
},
M_AC_POWER_FeedIn:M_AC_POWER.* {
my $pwr = ReadingsNum ($name, 'M_AC_POWER', 0);
$pwr = $pwr > 0 ? $pwr : 0;
return $pwr;
},
Leistungbezug_HM_Meter_kW {
my $power = ReadingsNum ('Energiemessung_Smart_Bezug','Leistung_Verbrauch',0)/1000;
my $result = 0;
$result = $power;
return sprintf("%.2f", $result);
},
Energiebezug_HM_Meter_kWh {
my $energie = ReadingsNum ('Energiemessung_Smart_Bezug','IEC_ENERGY_COUNTER',0);
my $result = 0;
$result = $energie;
return sprintf("%.2f", $result);
},
Leistung_FeedIN_HM_Meter_kW {
my $power = ReadingsNum ('Energiemessung_Smart_Einspeisung','Leistung_Einspeisung',0)/1000;
my $result = 0;
$result = $power;
return sprintf("%.2f", $result);
},
Energie_FeedIN_HM_Meter_kWh {
my $energie = ReadingsNum ('Energiemessung_Smart_Einspeisung','IEC_ENERGY_COUNTER',0);
my $result = 0;
$result = $energie;
return sprintf("%.2f", $result);
},
pvIn:I_DC_Power.* {
my $capacity = 10;
my $wr_self = 0.12;
my $dc = ReadingsNum($name,"I_DC_Power",0);
my $house = ReadingsNum($name,"Haus_Last_kW",0);
my $gridin = ReadingsNum($name,"M_AC_POWER_Purchased",0);
my $gridout = ReadingsNum($name,"M_AC_POWER_FeedIn",0);
my $batout = ReadingsNum($name,"BatOut",0);
my $bat_eta = 0.79;
my $bat_ac = $batout * $bat_eta;
my $pv_ac = $house - $gridin + $gridout - $bat_ac;
$pv_ac = 0 if $pv_ac < 0;
$pv_ac -= $wr_self if $pv_ac > $wr_self;
my $pv_dc = $pv_ac / 0.97;
# Clipping
$pv_dc = $capacity if $pv_dc > $capacity;
# Nachtfilter
$pv_dc = 0 if $pv_dc < 0.08;
return sprintf("%.3f",$pv_dc);
},
pvOut:I_DC_Power.* {
my $wr_self = 0.12;
my $pvin = ReadingsNum($name,"pvIn",0);
my $batin = ReadingsNum($name,"BatIn",0);
my $pv_to_ac = $pvin - $batin;
$pv_to_ac = 0 if $pv_to_ac < 0;
my $pv_ac = ($pv_to_ac * 0.97) - $wr_self;
$pv_ac = 0 if $pv_ac < 0;
return sprintf("%.3f",$pv_ac);
},
dc2ac:BatOut.* {
my $batout = ReadingsNum($name,"BatOut",0);
# Wirkungsgradbereich
my $eta = 0.79;
my $ac = $batout * $eta;
$ac = 0 if $ac < 0.05;
return sprintf("%.3f",$ac);
},
ac2dc:I_AC-Power.* {
my $batin = ReadingsNum($name,"BatIn",0);
# Batterie lädt direkt DC von PV
# daher kein AC->DC
return sprintf("%.3f",0);
},
etotal:I_AC_Energy_WH.* {
my $ac_total = ReadingsNum($name,"I_AC_Energy_WH",0);
my $bat_total = ReadingsNum($name,"BatOUT_TOTAL_kWh",0);
my $bat_ac = $bat_total * 0.79;
my $pv_total = $ac_total - $bat_ac;
$pv_total = 0 if $pv_total < 0;
return sprintf("%.3f",$pv_total);
},
PV_Leistung-temp:I_DC_Power.* {
my $i_dc_power = ReadingsNum ($name, 'I_DC_Power', 0);
my $bat_power = ReadingsNum ($name, 'BatIn', 0);
my $bat_out = ReadingsNum ($name, 'BatOut', 0);
my $i_ac_feedin = ReadingsNum ($name, 'M_AC_POWER_FeedIn', 0);
my $pow_faktor = 0.79;
my $result = 0;
$result = $i_dc_power + $bat_power + $i_ac_feedin - ($bat_out * $pow_faktor) ;
if ($result < 0) {
$result = 0;
}
return sprintf("%.2f", $result);
},
PV_Leistung:PV_Leistung-temp.* {
my $pwr = ReadingsNum ($name, 'PV_Leistung-temp', 0);
if (ReadingsVal ('Tag_Nacht', 'state', '0') ne "Tag"){
$pwr = 0;
}
elsif ($pwr < 0.01){
$pwr = 0;
}
return $pwr;
},
Haus_Last_kW:.* {
my $inv_ac = ReadingsNum ($name, 'I_AC-Power', 0);
my $feedin_ac = ReadingsNum ($name,'M_AC_POWER_FeedIn',0);
my $result = 0;
$result = $inv_ac - $feedin_ac;
return sprintf("%.2f", $result);
},
vom_Dach:.* {
my $dc=ReadingsNum("SE_10k","I_DC_Power",0);
my $bin=ReadingsNum("SE_10k","BatIn",0);
my $bout=ReadingsNum("SE_10k","BatOut",0);
sprintf("%.3f",$dc-$bout+$bin)
},
Hausverbrauch:.* {
my $ac=ReadingsNum($name,'I_AC-Power',0);
my $buy=ReadingsNum($name,'M_AC_POWER_Purchased',0);
my $sell=ReadingsNum($name,'M_AC_POWER_FeedIn',0);
sprintf("%.3f",$ac+$buy-$sell)
},
WR_Effizienz:.* {
my $dc=ReadingsNum("SE_10k","I_DC_Power",0);
my $ac=ReadingsNum("SE_10k","I_AC-Power",0);
return 0 if $dc==0;
sprintf("%.3f",$ac/$dc)
},
PV_DC:.* {
my $dc=ReadingsNum($name,'I_DC_Power',0);
my $bin=ReadingsNum($name,'BatIn',0);
my $bout=ReadingsNum($name,'BatOut',0);
my $result = $dc-$bout+$bin;
$result = $result > 0.08 ? $result : 0;
sprintf("%.3f",$result)
},
BatNet:.* {
my $out = ReadingsNum($name,'BatOut',0);
my $in = ReadingsNum($name,'BatIn',0);
my $net = $out - $in;
$net = 0 if $net < 0;
sprintf("%.3f",$net)
},
BatExport:.* {
my $bout=ReadingsNum($name,'BatOut',0);
my $feed=ReadingsNum($name,'M_AC_POWER_FeedIn',0);
my $exp=($bout<$feed)?$bout:$feed;
sprintf("%.3f",$exp)
},
BatHaus:.* {
my $bout=ReadingsNum($name,'BatOut',0);
my $feed=ReadingsNum($name,'M_AC_POWER_FeedIn',0);
my $exp=($bout<$feed)?$bout:$feed;
sprintf("%.3f",$bout-$exp)
},
PV_Export:.* {
my $feed=ReadingsNum($name,'M_AC_POWER_FeedIn',0);
my $bout=ReadingsNum($name,'BatOut',0);
my $exp=($bout<$feed)?$bout:$feed;
sprintf("%.3f",$feed-$exp)
},
PV_Haus:.* {
my $ac=ReadingsNum($name,'I_AC-Power',0);
my $buy=ReadingsNum($name,'M_AC_POWER_Purchased',0);
my $sell=ReadingsNum($name,'M_AC_POWER_FeedIn',0);
my $bout=ReadingsNum($name,'BatOut',0);
my $eta=0.79;
my $haus=$ac+$buy-$sell;
my $batExport = ($bout<$sell)?$bout:$sell;
my $batHaus = ($bout-$batExport)*$eta;
my $pv=$haus-$batHaus-$buy;
$pv=0 if $pv<0;
sprintf("%.3f",$pv)
},
NetzHaus:.* {
my $buy=ReadingsNum($name,'M_AC_POWER_Purchased',0);
sprintf("%.3f",$buy)
}
Ich möchte _nu_ PV_DC und pvIn logen.
Gruß
Martin
Soll DbLog in die Tabelle "current" schreiben?
Bis jetzt hat er immer in "history" geschrieben.
Jetzt sieht es so aus:
MariaDB [fhem]> SELECT TIMESTAMP, DEVICE, READING, VALUE FROM current ORDER BY TIMESTAMP DESC LIMIT 20;
+---------------------+--------------+-----------------------------+-----------+
| TIMESTAMP | DEVICE | READING | VALUE |
+---------------------+--------------+-----------------------------+-----------+
| 2026-03-10 11:26:29 | SE_10k | pvIn | 0.093 |
| 2026-03-10 11:26:29 | SE_10k | BatIn | 0.47 |
| 2026-03-10 11:26:29 | SE_10k | PV_DC | 0.688 |
| 2026-03-10 11:26:29 | SE_10k | BatOut | 0 |
| 2026-03-10 10:53:11 | MD_SolarEdge | BatIn | 0.41 |
| 2026-03-10 10:53:11 | MD_SolarEdge | BatOut | 0 |
| 2026-03-10 09:33:03 | SE_10k | BatNet | 2.630 |
| 2026-03-10 09:33:03 | SE_10k | BatHaus | 2.630 |
| 2026-03-10 09:33:03 | SE_10k | B_Status | Discharge |
| 2026-03-10 09:33:03 | SE_10k | Haus_Last_kW | 4.02 |
| 2026-03-10 09:33:03 | SE_10k | Hausverbrauch | 4.273 |
| 2026-03-10 09:33:03 | SE_10k | BatOUT_TOTAL_kWh | 930.46 |
| 2026-03-10 09:33:03 | SE_10k | B_State_of_Energy | 41.5 |
| 2026-03-10 09:33:03 | SE_10k | B_State_of_Health | 99.0 |
| 2026-03-10 09:33:03 | SE_10k | B_Available_Energy | 9.53 |
| 2026-03-10 09:33:03 | SE_10k | B_Average_Temperature | 17.5 |
| 2026-03-10 09:33:03 | SE_10k | B_Instantaneous_Power | -2.63 |
| 2026-03-10 09:33:03 | SE_10k | B_State_of_Energy_in_kWh | 3.95 |
| 2026-03-10 09:33:03 | SE_10k | Energiebezug_HM_Meter_kWh | 875.10 |
| 2026-03-10 09:33:03 | SE_10k | Energie_FeedIN_HM_Meter_kWh | 182.90 |
+---------------------+--------------+-----------------------------+-----------+
Dass die Werte auch in current geschrieben werden, hast Du in Deinem DbLog-device festgelegt, dort steht "Current/History" als DbLogType. Das ist grundsätzlich ok. In "current" steht immer nur der letzte aufgezeichnete Wert eines readings. Die Werte aus der Tabelle werden verwendet, um bei SVG devices die dropdown-Liste für die reading-Auswahl zu generieren.
Das erklärt aber immer noch nicht, warum Deine regex nicht greift.
Und das list des ModbusAttr hat mir auch keine Idee gegeben.
Vielleicht mal warten, ob der Modulautor sich noch meldet und eine Idee hat.
Offenbar übersehen wir irgendwas ganz profanes.
Ja, es bleibt nur zu hoffen, dass der Modulator hier reinschaut.
Ich habe eine andere fhem-installation, bei der es mit dieser DBLog-DEF sehr gut seit Jahren funktioniert.
Auch regex funktioniert so wie erwartet.
Allerdings wird hier nicht in current-Tabelle geschrieben.
Internals:
COLUMNS field length used for Device: 64, Type: 64, Event: 512, Reading: 64, Value: 128, Unit: 32
CONFIGURATION ./db.conf
DEF ./db.conf .*:(measured-temp|desired-temp|valve_position|humidity|pressure|temperature|Temp|Diesel|batteryLevel|Diff_T1-T2|T1-Vorlauf|T2-Ruecklauf|wetterdaten|regen_counter|power|energy|current|kWh|Leistung|Part_Home|Part_SRV|Part_root|cpu_temp_avg|INFO_history.data_index_length_MB|Spannung|Frequenz|P_AC|Wasserverbrauch|MQTT_Gas|windspeed_SAT_Antenne|Today_PVforecast|Tomorrow_PVforecast|1.svHmIPSunshineCounterToday_14833|Blindleistung_L1|Blindleistung_L2|Blindleistung_L3|I_AC_Energy_WH|Day_Gesamt_vom_Dach|Leistungbilanz_PV_zu_SWDU|status-pv_power).*
FD 5
FUUID 641c5108-f33f-84ec-f14a-2c308b4f98d27913
FVERSION 93_DbLog.pm:v5.11.0-s29401/2024-12-05
MODE asynchronous
MODEL MYSQL
NAME mozart4_DbLog
NR 2
NTFY_ORDER 50-mozart4_DbLog
PID 506
REGEXP .*:(measured-temp|desired-temp|valve_position|humidity|pressure|temperature|Temp|Diesel|batteryLevel|Diff_T1-T2|T1-Vorlauf|T2-Ruecklauf|wetterdaten|regen_counter|power|energy|current|kWh|Leistung|Part_Home|Part_SRV|Part_root|cpu_temp_avg|INFO_history.data_index_length_MB|Spannung|Frequenz|P_AC|Wasserverbrauch|MQTT_Gas|windspeed_SAT_Antenne|Today_PVforecast|Tomorrow_PVforecast|1.svHmIPSunshineCounterToday_14833|Blindleistung_L1|Blindleistung_L2|Blindleistung_L3|I_AC_Energy_WH|Day_Gesamt_vom_Dach|Leistungbilanz_PV_zu_SWDU|status-pv_power).*
SBP_PID 507
SBP_STATE running
STATE connected
TYPE DbLog
UTF8 1
dbconn mysql:database=fhem;host=localhost;port=3306
dbuser fhemuser
eventCount 223417
HELPER:
COLSET 1
DEVICECOL 64
EVENTCOL 512
OLDSTATE connected
PACKAGE main
READINGCOL 64
TC current
TH history
TYPECOL 64
UNITCOL 32
VALUECOL 128
VERSION 5.11.0
OLDREADINGS:
READINGS:
2026-03-10 14:57:11 CacheOverflowLastNum 0
2023-04-20 21:25:35 CacheOverflowLastState normal
2026-03-10 14:57:11 CacheUsage 7
2026-03-10 14:57:11 NextSync 2026-03-10 14:57:41 or when CacheUsage 500 is reached
2026-03-10 14:57:12 notify_processing_time 0.0010
2026-03-10 14:57:11 state connected
Attributes:
DbLogExclude valve_position_STATUS, humidity_STATUS, measured-temp_STATUS, batteryLevel_STATUS, humidity_SAT_Antenne_STATUS, Mein_CUxD_Geraet, Statusanzeige, current_STATUS, current, power_STATUS, energy_OVERFLOW,loadavg, presence, BatteryDummy
DbLogType Current/History
asyncMode 1
excludeDevs HM_Schalt.*,raspi.*,Proplanta*
room LOG
showNotifyTime 1
Gruß
Martin
Die Spur führte über:
Zitat von: betateilchen am 10 März 2026, 12:43:51Dass die Werte auch in current geschrieben werden, hast Du in Deinem DbLog-device festgelegt, dort steht "Current/History" als DbLogType. Das ist grundsätzlich ok.
Bei mir war aber _nur_ current.
Darauf hin habe ich nun das device csl_debian_DbLog und die DB "fhem" gelöscht.
Danach DB und device neu angelegt,
Jetzt ich scheinbar OK.
Eine Frage noch habe ich aber.
kann es sein das ín der Tabelle "history" keinen PK gibt?
Gruß
Martin
[Edit]
ich habe nachträglich:
ALTER TABLE history
ADD PRIMARY KEY (DEVICE, READING, TIMESTAMP);
und nun habe ich PK.
{/Edit)