Problem vergessen. Mein Fehler. Wo keine Events, da kein log
Hallo Zusammen,
Ich nutze MariaDB auf einem seperaten Pi um die Logflut auszulagern. bis Mitte Februar hat's scheinbar hingehauen. Jetzt ist mir aufgefallen, dass fast keine Logs mehr geschrieben werden.
Daraufhin habe ich die Tabellen geleert. Vielleicht waren mehrere zehntausend Einträge schuld. Aber leider lags nicht daran.
Was ist anders? Eigentlich nichts. Ich glaube zu den Zeitpunkt ein fhem Update gemacht zu haben, bin mir aber nicht sicher.
define logdb DbLog ./db.conf .*:.*
attr logdb DbLogSelectionMode Include
attr logdb DbLogType History
attr logdb room 97_Gateways
attr logdb verbose 1
# COLUMNS field length used for Device: 64, Type: 64, Event: 512, Reading: 64, Value: 128, Unit: 32
# CONFIGURATION ./db.conf
# DEF ./db.conf .*:.*
# FD 6
# FUUID 632cbed5-f33f-194a-74a4-cb8827d9df895c03
# FVERSION 93_DbLog.pm:v5.8.4-s27271/2023-02-25
# MODE synchronous
# MODEL MYSQL
# NAME logdb
# NR 2
# NTFY_ORDER 50-logdb
# PID 898
# REGEXP .*:.*
# SBP_PID 985
# SBP_STATE running
# STATE connected
# TYPE DbLog
# UTF8 0
# dbconn mysql:database=fhem;host=192.168.188.98;port=3306
# dbuser fhemuser
# eventCount 2
# 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.8.4
# OLDREADINGS:
# READINGS:
# 2023-03-01 09:13:08 CacheOverflowLastNum 0
# 2022-09-22 22:00:21 CacheOverflowLastState normal
# 2023-03-10 07:03:24 CacheUsage 0
# 2023-03-10 07:03:24 state connected
#
setstate logdb connected
setstate logdb 2023-03-01 09:13:08 CacheOverflowLastNum 0
setstate logdb 2022-09-22 22:00:21 CacheOverflowLastState normal
setstate logdb 2023-03-10 07:03:24 CacheUsage 0
setstate logdb 2023-03-10 07:03:24 state connected
define 45_Thermostat_Tuer HMCCUCHN 00345F29B53C1E:1
attr 45_Thermostat_Tuer DbLogInclude measured-temp
attr 45_Thermostat_Tuer cmdIcon auto:sani_heating_automatic manu:sani_heating_manual boost:sani_heating_boost on:general_an off:general_aus
attr 45_Thermostat_Tuer event-min-interval .*:900
attr 45_Thermostat_Tuer room 40_OG_Wohnräume->45_Schlafzimmer
attr 45_Thermostat_Tuer substexcl desired-temp
attr 45_Thermostat_Tuer verbose 5
attr 45_Thermostat_Tuer webCmd desired-temp:auto:manu:boost:on:off
attr 45_Thermostat_Tuer widgetOverride desired-temp:slider,4.5,0.5,30.5,1
# DEF 00345F29B53C1E:1
# FUUID 640a506e-f33f-194a-1137-6dc12e762cae40c0
# IODev d_ccu
# NAME 45_Thermostat_Tuer
# NR 457
# STATE 21.1
# TYPE HMCCUCHN
# ccuaddr 00345F29B53C1E:1
# ccudevstate active
# ccuif HmIP-RF
# ccuname HmIP-WTH-B-2 00345F29B53C1E:1
# ccurolectrl HEATING_CLIMATECONTROL_TRANSCEIVER
# ccurolestate HEATING_CLIMATECONTROL_TRANSCEIVER
# ccusubtype WTH-B
# ccutype HmIP-WTH-B-2
# eventCount 12
# firmware 1.2.16
# readonly no
# Helper:
# DBLOG:
# measured-temp:
# logdb:
# TIME 1678427596.0279
# VALUE 21.1
# READINGS:
# 2023-03-10 06:53:15 ACTIVE_PROFILE 1
# 2023-03-10 06:53:15 ACTUAL_TEMPERATURE 21.1
# 2023-03-10 06:53:15 ACTUAL_TEMPERATURE_STATUS NORMAL
# 2023-03-10 06:53:15 BOOST_MODE false
# 2023-03-10 06:53:15 BOOST_TIME 0
# 2023-03-10 06:53:15 FROST_PROTECTION false
# 2023-03-10 06:53:15 HEATING_COOLING HEATING
# 2023-03-10 06:53:15 HUMIDITY 50
# 2023-03-10 06:53:15 HUMIDITY_STATUS NORMAL
# 2023-03-10 00:12:10 IODev d_ccu
# 2023-03-10 06:53:15 PARTY_MODE false
# 2023-03-10 00:12:58 PARTY_SET_POINT_TEMPERATURE 0.0
# 2023-03-10 00:12:58 PARTY_TIME_END
# 2023-03-10 00:12:58 PARTY_TIME_START
# 2023-03-10 06:53:15 QUICK_VETO_TIME 0
# 2023-03-10 06:53:15 SET_POINT_MODE manual
# 2023-03-10 06:53:15 SET_POINT_TEMPERATURE 20.0
# 2023-03-10 06:53:15 SWITCH_POINT_OCCURED false
# 2023-03-10 06:53:15 WINDOW_STATE closed
# 2023-03-10 06:53:15 activity alive
# 2023-03-10 06:53:15 battery ok
# 2023-03-10 06:53:15 control 20.0
# 2023-03-10 06:53:15 desired-temp 20.0
# 2023-03-10 06:53:15 devstate ok
# 2023-03-10 06:53:15 hmstate 21.1
# 2023-03-10 06:53:15 humidity 50
# 2023-03-10 06:53:15 measured-temp 21.1
# 2023-03-10 06:53:15 rssidevice -78
# 2023-03-10 00:12:58 rssipeer -75
# 2023-03-10 06:53:15 state 21.1
# 2023-03-10 06:53:15 voltage 3.1
# hmccu:
# channels 1
# detect 1
# devspec 00345F29B53C1E:1
# nodefaults 1
# role 1:HEATING_CLIMATECONTROL_TRANSCEIVER
# setDefaults 0
# cmdlist:
# get
# set manu:noArg boost:noArg auto:noArg holiday:noArg on:noArg desired-temp off:noArg toggle:noArg
# control:
# chn 1
# dpt SET_POINT_TEMPERATURE
# dp:
# 0.CONFIG_PENDING:
# VALUES:
# NVAL 0
# ONVAL 0
# OSVAL false
# OVAL 0
# SVAL false
# VAL 0
# 0.DUTY_CYCLE:
# VALUES:
# NVAL 0
# ONVAL 0
# OSVAL false
# OVAL 0
# SVAL false
# VAL 0
# 0.INSTALL_TEST:
# VALUES:
# NVAL true
# ONVAL true
# OSVAL true
# OVAL true
# SVAL true
# VAL true
# 0.LOW_BAT:
# VALUES:
# NVAL 0
# ONVAL 0
# OSVAL ok
# OVAL 0
# SVAL ok
# VAL 0
# 0.OPERATING_VOLTAGE:
# VALUES:
# NVAL 3.1
# ONVAL 3.1
# OSVAL 3.1
# OVAL 3.1
# SVAL 3.1
# VAL 3.1
# 0.OPERATING_VOLTAGE_STATUS:
# VALUES:
# NVAL 0
# ONVAL 0
# OSVAL NORMAL
# OVAL 0
# SVAL NORMAL
# VAL 0
# 0.RSSI_DEVICE:
# VALUES:
# NVAL -78
# ONVAL -78
# OSVAL -78
# OVAL -78
# SVAL -78
# VAL -78
# 0.RSSI_PEER:
# VALUES:
# NVAL -75
# ONVAL -75
# OSVAL -75
# OVAL 181
# SVAL -75
# VAL 181
# 0.UNREACH:
# VALUES:
# NVAL 0
# ONVAL 0
# OSVAL alive
# OVAL 0
# SVAL alive
# VAL 0
# 0.UPDATE_PENDING:
# VALUES:
# NVAL false
# ONVAL false
# OSVAL false
# OVAL false
# SVAL false
# VAL false
# 1.ACTIVE_PROFILE:
# VALUES:
# NVAL 1
# ONVAL 1
# OSVAL 1
# OVAL 1
# SVAL 1
# VAL 1
# 1.ACTUAL_TEMPERATURE:
# VALUES:
# NVAL 21.1
# ONVAL 21.1
# OSVAL 21.1
# OVAL 21.1
# SVAL 21.1
# VAL 21.1
# 1.ACTUAL_TEMPERATURE_STATUS:
# VALUES:
# NVAL 0
# ONVAL 0
# OSVAL NORMAL
# OVAL 0
# SVAL NORMAL
# VAL 0
# 1.BOOST_MODE:
# VALUES:
# NVAL 0
# ONVAL 0
# OSVAL false
# OVAL 0
# SVAL false
# VAL 0
# 1.BOOST_TIME:
# VALUES:
# NVAL 0
# ONVAL 0
# OSVAL 0
# OVAL 0
# SVAL 0
# VAL 0
# 1.FROST_PROTECTION:
# VALUES:
# NVAL 0
# ONVAL 0
# OSVAL false
# OVAL 0
# SVAL false
# VAL 0
# 1.HEATING_COOLING:
# VALUES:
# NVAL 0
# ONVAL 0
# OSVAL HEATING
# OVAL 0
# SVAL HEATING
# VAL 0
# 1.HUMIDITY:
# VALUES:
# NVAL 50
# ONVAL 51
# OSVAL 51
# OVAL 51
# SVAL 50
# VAL 50
# 1.HUMIDITY_STATUS:
# VALUES:
# NVAL 0
# ONVAL 0
# OSVAL NORMAL
# OVAL 0
# SVAL NORMAL
# VAL 0
# 1.PARTY_MODE:
# VALUES:
# NVAL 0
# ONVAL 0
# OSVAL false
# OVAL 0
# SVAL false
# VAL 0
# 1.PARTY_SET_POINT_TEMPERATURE:
# VALUES:
# NVAL 0.000000
# ONVAL 0.000000
# OSVAL 0.0
# OVAL 0.000000
# SVAL 0.0
# VAL 0.000000
# 1.PARTY_TIME_END:
# VALUES:
# NVAL
# ONVAL
# OSVAL
# OVAL
# SVAL
# VAL
# 1.PARTY_TIME_START:
# VALUES:
# NVAL
# ONVAL
# OSVAL
# OVAL
# SVAL
# VAL
# 1.QUICK_VETO_TIME:
# VALUES:
# NVAL 0
# ONVAL 0
# OSVAL 0
# OVAL 0
# SVAL 0
# VAL 0
# 1.SET_POINT_MODE:
# VALUES:
# NVAL 1
# ONVAL 1
# OSVAL manual
# OVAL 1
# SVAL manual
# VAL 1
# 1.SET_POINT_TEMPERATURE:
# VALUES:
# NVAL 20.0
# ONVAL 20.0
# OSVAL 20.0
# OVAL 20.0
# SVAL 20.0
# VAL 20.0
# 1.SWITCH_POINT_OCCURED:
# VALUES:
# NVAL 0
# ONVAL 0
# OSVAL false
# OVAL 0
# SVAL false
# VAL 0
# 1.WINDOW_STATE:
# VALUES:
# NVAL 0
# ONVAL 0
# OSVAL closed
# OVAL 0
# SVAL closed
# VAL 0
# roleCmds:
# get:
# set:
# auto:
# channel 1
# role HEATING_CLIMATECONTROL_TRANSCEIVER
# subcount 1
# syntax V:CONTROL_MODE:0
# usage auto
# subcmd:
# 000:
# args 0
# dpt CONTROL_MODE
# fnc
# max 3
# min 0
# parname CONTROL_MODE
# partype 3
# ps VALUES
# scn 000
# unit
# boost:
# channel 1
# role HEATING_CLIMATECONTROL_TRANSCEIVER
# subcount 1
# syntax V:BOOST_MODE:1
# usage boost
# subcmd:
# 000:
# args 1
# dpt BOOST_MODE
# fnc
# max 1
# min 0
# parname BOOST_MODE
# partype 3
# ps VALUES
# scn 000
# unit
# desired-temp:
# channel 1
# role HEATING_CLIMATECONTROL_TRANSCEIVER
# subcount 1
# syntax V:SET_POINT_TEMPERATURE:?temperature
# usage desired-temp temperature
# subcmd:
# 000:
# args
# dpt SET_POINT_TEMPERATURE
# fnc
# max 30.5
# min 4.5
# parname temperature
# partype 2
# ps VALUES
# scn 000
# unit �C
# holiday:
# channel 1
# role HEATING_CLIMATECONTROL_TRANSCEIVER
# subcount 1
# syntax V:CONTROL_MODE:2
# usage holiday
# subcmd:
# 000:
# args 2
# dpt CONTROL_MODE
# fnc
# max 3
# min 0
# parname CONTROL_MODE
# partype 3
# ps VALUES
# scn 000
# unit
# manu:
# channel 1
# role HEATING_CLIMATECONTROL_TRANSCEIVER
# subcount 1
# syntax V:CONTROL_MODE:1
# usage manu
# subcmd:
# 000:
# args 1
# dpt CONTROL_MODE
# fnc
# max 3
# min 0
# parname CONTROL_MODE
# partype 3
# ps VALUES
# scn 000
# unit
# off:
# channel 1
# role HEATING_CLIMATECONTROL_TRANSCEIVER
# subcount 2
# syntax V:CONTROL_MODE:1 V:SET_POINT_TEMPERATURE:4.5
# usage off
# subcmd:
# 000:
# args 1
# dpt CONTROL_MODE
# fnc
# max 3
# min 0
# parname CONTROL_MODE
# partype 3
# ps VALUES
# scn 000
# unit
# 001:
# args 4.5
# dpt SET_POINT_TEMPERATURE
# fnc
# max 30.5
# min 4.5
# parname SET_POINT_TEMPERATURE
# partype 3
# ps VALUES
# scn 001
# unit �C
# on:
# channel 1
# role HEATING_CLIMATECONTROL_TRANSCEIVER
# subcount 2
# syntax V:CONTROL_MODE:1 V:SET_POINT_TEMPERATURE:30.5
# usage on
# subcmd:
# 000:
# args 1
# dpt CONTROL_MODE
# fnc
# max 3
# min 0
# parname CONTROL_MODE
# partype 3
# ps VALUES
# scn 000
# unit
# 001:
# args 30.5
# dpt SET_POINT_TEMPERATURE
# fnc
# max 30.5
# min 4.5
# parname SET_POINT_TEMPERATURE
# partype 3
# ps VALUES
# scn 001
# unit �C
# state:
# chn 1
# dpt ACTUAL_TEMPERATURE
#
setstate 45_Thermostat_Tuer 21.1
setstate 45_Thermostat_Tuer 2023-03-10 06:53:15 ACTIVE_PROFILE 1
setstate 45_Thermostat_Tuer 2023-03-10 06:53:15 ACTUAL_TEMPERATURE 21.1
setstate 45_Thermostat_Tuer 2023-03-10 06:53:15 ACTUAL_TEMPERATURE_STATUS NORMAL
setstate 45_Thermostat_Tuer 2023-03-10 06:53:15 BOOST_MODE false
setstate 45_Thermostat_Tuer 2023-03-10 06:53:15 BOOST_TIME 0
setstate 45_Thermostat_Tuer 2023-03-10 06:53:15 FROST_PROTECTION false
setstate 45_Thermostat_Tuer 2023-03-10 06:53:15 HEATING_COOLING HEATING
setstate 45_Thermostat_Tuer 2023-03-10 06:53:15 HUMIDITY 50
setstate 45_Thermostat_Tuer 2023-03-10 06:53:15 HUMIDITY_STATUS NORMAL
setstate 45_Thermostat_Tuer 2023-03-10 00:12:10 IODev d_ccu
setstate 45_Thermostat_Tuer 2023-03-10 06:53:15 PARTY_MODE false
setstate 45_Thermostat_Tuer 2023-03-10 00:12:58 PARTY_SET_POINT_TEMPERATURE 0.0
setstate 45_Thermostat_Tuer 2023-03-10 00:12:58 PARTY_TIME_END
setstate 45_Thermostat_Tuer 2023-03-10 00:12:58 PARTY_TIME_START
setstate 45_Thermostat_Tuer 2023-03-10 06:53:15 QUICK_VETO_TIME 0
setstate 45_Thermostat_Tuer 2023-03-10 06:53:15 SET_POINT_MODE manual
setstate 45_Thermostat_Tuer 2023-03-10 06:53:15 SET_POINT_TEMPERATURE 20.0
setstate 45_Thermostat_Tuer 2023-03-10 06:53:15 SWITCH_POINT_OCCURED false
setstate 45_Thermostat_Tuer 2023-03-10 06:53:15 WINDOW_STATE closed
setstate 45_Thermostat_Tuer 2023-03-10 06:53:15 activity alive
setstate 45_Thermostat_Tuer 2023-03-10 06:53:15 battery ok
setstate 45_Thermostat_Tuer 2023-03-10 06:53:15 control 20.0
setstate 45_Thermostat_Tuer 2023-03-10 06:53:15 desired-temp 20.0
setstate 45_Thermostat_Tuer 2023-03-10 06:53:15 devstate ok
setstate 45_Thermostat_Tuer 2023-03-10 06:53:15 hmstate 21.1
setstate 45_Thermostat_Tuer 2023-03-10 06:53:15 humidity 50
setstate 45_Thermostat_Tuer 2023-03-10 06:53:15 measured-temp 21.1
setstate 45_Thermostat_Tuer 2023-03-10 06:53:15 rssidevice -78
setstate 45_Thermostat_Tuer 2023-03-10 00:12:58 rssipeer -75
setstate 45_Thermostat_Tuer 2023-03-10 06:53:15 state 21.1
setstate 45_Thermostat_Tuer 2023-03-10 06:53:15 voltage 3.1
Woran könnte es liegen? Eigentlich sollten ja alle 15 Minuten ein Wert kommen.
Grüße [/s]