DbLog history - DBD::mysql::st execute failed

borsti67 · 05 Mai 2021, 15:28:58

Hallo,

leider habe ich 2 Dinge recht zeitnah aufeinander gemacht, so dass ich nicht sicher bin welches davon der Auslöser war/ist...

Und zwar habe ich zum einen mittels "update" meine FHEM-Installation auf den neusten Stand gebracht, und mich des weiteren am "Ausdünnen" der doch mittlerweile recht gigantischen MariaDB versucht. Das Update hat keine Fehler gezeigt, aber der "ReduceLogNbl" ist nicht durchgelaufen. Das Problem hier ist, dass offensichtlich da ein temporäres File die Platte füllt. Habe dazu schon Lösungsansätze im Forum gefunden, aber auf der Kiste ist aktuell tatsächlich nicht genug Platz - ich habe mir während des Laufes mit

Code Auswählen

df -h immer mal wieder angeschaut was passiert, und da waren aus den 35% belegt dann 99% geworden.

Also habe ich probiert (wie auch hier empfohlen) erst einmal das das Intervall zu verkleinern, das lief dann auch durch! Nun wollte ich mich langsam an die tatsächlich gewünschten Parameter herantasten, hatte aber noch keinen Erfolg bisher. Aber gut, da werde ich mich am Wochenende noch mal mit befassen (müssen).

Nun ist mir vorhin aber aufgefallen, dass ich seither regelmäßig einen Fehler im Log habe, der zuvor nicht da war (und ich habe seit gestern nicht mehr experimentiert):

Code Auswählen

2021.05.05 14:41:43 2: DbLog myDbLog -> Error table history - DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1 at ./FHEM/93_DbLog.pm line 2641.

Das scheint eine Einfüge-Abfrage zu sein. Zu dieser Zeit sehe ich im Event-Monitor nur folgendes:

Code Auswählen

2021-05-05 14:14:43 RESIDENTS rgr_o durTimerPresence_cr: 5328
2021-05-05 14:14:43 RESIDENTS rgr_o durTimerPresence: 88:47:34
2021-05-05 14:14:43 ROOMMATE rr_O durTimerPresence_cr: 5328
2021-05-05 14:14:43 ROOMMATE rr_O durTimerPresence: 88:47:34
2021-05-05 14:14:43 RESIDENTS rgr_wir durTimerPresence_cr: 12675
2021-05-05 14:14:43 RESIDENTS rgr_wir durTimerPresence: 211:14:31
2021-05-05 14:14:43 ROOMMATE rr_T durTimerAbsence_cr: 348
2021-05-05 14:14:43 ROOMMATE rr_T durTimerAbsence: 05:48:15
2021-05-05 14:14:43 ROOMMATE rr_H durTimerPresence_cr: 4004
2021-05-05 14:14:43 ROOMMATE rr_H durTimerPresence: 66:43:37
2021-05-05 14:14:43 GUEST rg_Gast durTimerAbsence_cr: 1361029
2021-05-05 14:14:43 GUEST rg_Gast durTimerAbsence: 22683:48:41

Demnach müsste einer davon der Auslöser gewesen sein.

Habe ich nun mit dem "Ausdünnungs-Versuch" was zerschossen (wenn ja, wie kann ich es fixen?) oder gibt es ein Problem bei obigen Events?
Weitere Details zu config kann ich gern posten, wenn ich weiß was hierfür relevant sein kann...

DS_Starter · 05 Mai 2021, 18:10:55

Du könntest gleich eine Weiterentwicklung testen die aus einem anderen Grund gemacht wurde, aber trotzdem hilfreich sein könnte.

Zum Download in der FHEMWEB Kommandozeile inklusive der Ausführungszeichen angeben und danach FHEM restarten:

Code Auswählen


"wget -qO ./FHEM/93_DbLog.pm https://svn.fhem.de/fhem/trunk/fhem/contrib/DS_Starter/93_DbLog.pm"

Ansonsten bekommt man mit verbose 4 oder 5 mehr heraus.

borsti67 · 06 Mai 2021, 06:46:22

Danke DS_Starter, mache ich gern.
Was genau wäre zu testen/beobachten? Erwartest Du eine Verbesserung hinsichtlich des "Aufräumens" oder bezüglich obiger Fehlermeldung?
Installiert habe ich die Version jedenfalls schon mal.

Code Auswählen

93_DbLog.pm 23888 2021-03-04 19:58:00Z DS_Starter

DS_Starter · 06 Mai 2021, 09:11:31

Bezüglich der Fehlermeldung. In der neuen Version ist (wegen einer anderen Meldung) das Standardsplitting für die DB Feldaufteilung etwas abgeändert.
Vielleicht trifft es auch in diesem Fall zu. Ohne nähere Prüfung ....

VG

borsti67 · 06 Mai 2021, 09:49:37

ok, der Fehler kommt noch, aber nun in Zeile 2644.

Ich hatte kurz "verbose 4" an, aber dann wird's sehr unübersichtlich im Log.
Werde versuchen das abzupassen, die Einträge scheinen 1x pro Stunde zu kommen - aktiviere den "verbose 4" (oder brauchst Du 5?) über den Zeitraum weg.

DS_Starter · 06 Mai 2021, 11:27:07

Damit das Log in dem Fall nicht zu unübersichtlich wird habe ich das Attr verbose4Devs eingebaut.
Das kannst du benutzen in diesem Fall um nur relevante Deveices zu loggen.

borsti67 · 06 Mai 2021, 12:08:42

ok, das mache ich dann mal.

BTW, aktuell war gerade "weather" der Auslöser, wie es scheint:

Code Auswählen

2021-05-06 11:38:50 FHT az_Heizung actuator: 22%
2021-05-06 11:38:51 DbLog myDbLog CacheOverflowLastNum: 0
2021-05-06 11:38:51 DbLog myDbLog CacheUsage: 501
2021-05-06 11:38:51 DbLog myDbLog CacheUsage: 501
2021-05-06 11:38:51 DbLog myDbLog CacheOverflowLastNum: 1
2021-05-06 11:38:51 DbLog myDbLog CacheOverflowLastState: exceeded
2021-05-06 11:38:51 DbLog myDbLog NextSync: 2021-05-06 11:39:21 or if CacheUsage 500 reached
2021-05-06 11:38:51 DbLog myDbLog connected
2021-05-06 11:38:51 Weather wetter lastError: 
2021-05-06 11:38:51 Weather wetter country: DE
2021-05-06 11:38:51 Weather wetter long: 8.58333
2021-05-06 11:38:51 Weather wetter lat: 53.55000
2021-05-06 11:38:51 Weather wetter apiMaintainer: Marko Oldenburg (<a href=https://forum.fhem.de/index.php?action=profile;u=13684>CoolTux</a>)
2021-05-06 11:38:51 Weather wetter apiVersion: v1.0.2
2021-05-06 11:38:51 Weather wetter city: Bremerhaven
2021-05-06 11:38:51 Weather wetter current_date_time: Do,  6 Mai 2021 11:38
2021-05-06 11:38:51 Weather wetter validity: up-to-date
2021-05-06 11:38:51 Weather wetter status: ok
2021-05-06 11:38:51 Weather wetter visibility: 10000
2021-05-06 11:38:51 Weather wetter wind_direction: 260
2021-05-06 11:38:51 Weather wetter pubDate: Do,  6 Mai 2021 10:35
2021-05-06 11:38:51 Weather wetter humidity: 70
2021-05-06 11:38:51 Weather wetter cloudCover: 40
2021-05-06 11:38:51 Weather wetter tempHigh: 9
2021-05-06 11:38:51 Weather wetter tempLow: 7
2021-05-06 11:38:51 Weather wetter tempFeelsLike_c: 4
2021-05-06 11:38:51 Weather wetter sunriseTime: Do,  6 Mai 2021 05:40
2021-05-06 11:38:51 Weather wetter temp_c: 8
2021-05-06 11:38:51 Weather wetter condition: Mäßig bewölkt
2021-05-06 11:38:51 Weather wetter iconAPI: 03d
2021-05-06 11:38:51 Weather wetter sunsetTime: Do,  6 Mai 2021 21:03
2021-05-06 11:38:51 Weather wetter wind_speed: 28
2021-05-06 11:38:51 Weather wetter pressure: 1004
2021-05-06 11:38:51 Weather wetter low_c: 7
2021-05-06 11:38:51 Weather wetter temperature: 8
2021-05-06 11:38:51 Weather wetter wind: 28
2021-05-06 11:38:51 Weather wetter high_c: 9
2021-05-06 11:38:51 Weather wetter code: 26
2021-05-06 11:38:51 Weather wetter icon: cloudy
2021-05-06 11:38:51 Weather wetter wind_condition: Wind: W 28 km/h
2021-05-06 11:38:51 Weather wetter hfc1_condition: Mäßig bewölkt
2021-05-06 11:38:51 Weather wetter hfc1_iconAPI: 03d
2021-05-06 11:38:51 Weather wetter hfc1_day_of_week: Do, 13:00
2021-05-06 11:38:51 Weather wetter hfc1_wind_speed: 25
2021-05-06 11:38:51 Weather wetter hfc1_low_c: 9
2021-05-06 11:38:51 Weather wetter hfc1_pressure: 1004
2021-05-06 11:38:51 Weather wetter hfc1_temperature: 9
2021-05-06 11:38:51 Weather wetter hfc1_wind: 25
2021-05-06 11:38:51 Weather wetter hfc1_high_c: 10
2021-05-06 11:38:51 Weather wetter hfc1_code: 26
2021-05-06 11:38:51 Weather wetter hfc1_pubDate: Do,  6 Mai 2021 13:00
2021-05-06 11:38:51 Weather wetter hfc1_tempHigh: 10
2021-05-06 11:38:51 Weather wetter hfc1_cloudCover: 41
2021-05-06 11:38:51 Weather wetter hfc1_humidity: 58
2021-05-06 11:38:51 Weather wetter hfc1_tempLow: 9
2021-05-06 11:38:51 Weather wetter hfc1_temp_c: 9
2021-05-06 11:38:51 Weather wetter hfc1_icon: cloudy
2021-05-06 11:38:51 Weather wetter hfc2_high_c: 9
2021-05-06 11:38:51 Weather wetter hfc2_wind: 17
2021-05-06 11:38:51 Weather wetter hfc2_code: 26
2021-05-06 11:38:51 Weather wetter hfc2_temperature: 9
2021-05-06 11:38:51 Weather wetter hfc2_pressure: 1005
2021-05-06 11:38:51 Weather wetter hfc2_low_c: 9
2021-05-06 11:38:51 Weather wetter hfc2_iconAPI: 04d
2021-05-06 11:38:51 Weather wetter hfc2_condition: Überwiegend bewölkt
2021-05-06 11:38:51 Weather wetter hfc2_wind_speed: 17
2021-05-06 11:38:51 Weather wetter hfc2_day_of_week: Do, 16:00
2021-05-06 11:38:51 Weather wetter hfc2_temp_c: 9
2021-05-06 11:38:51 Weather wetter hfc2_tempHigh: 9
2021-05-06 11:38:51 Weather wetter hfc2_cloudCover: 75
2021-05-06 11:38:51 Weather wetter hfc2_humidity: 58
2021-05-06 11:38:51 Weather wetter hfc2_tempLow: 9
2021-05-06 11:38:51 Weather wetter hfc2_pubDate: Do,  6 Mai 2021 16:00
2021-05-06 11:38:51 Weather wetter hfc2_icon: cloudy
2021-05-06 11:38:51 Weather wetter hfc3_code: 28
2021-05-06 11:38:51 Weather wetter hfc3_wind: 11
2021-05-06 11:38:51 Weather wetter hfc3_high_c: 6
2021-05-06 11:38:51 Weather wetter hfc3_day_of_week: Do, 19:00
2021-05-06 11:38:51 Weather wetter hfc3_wind_speed: 11
2021-05-06 11:38:51 Weather wetter hfc3_condition: Bedeckt
2021-05-06 11:38:51 Weather wetter hfc3_iconAPI: 04d
2021-05-06 11:38:51 Weather wetter hfc3_pressure: 1004
2021-05-06 11:38:51 Weather wetter hfc3_low_c: 6
2021-05-06 11:38:51 Weather wetter hfc3_temperature: 6
2021-05-06 11:38:51 Weather wetter hfc3_temp_c: 6
2021-05-06 11:38:51 Weather wetter hfc3_pubDate: Do,  6 Mai 2021 19:00
2021-05-06 11:38:51 Weather wetter hfc3_tempLow: 6
2021-05-06 11:38:51 Weather wetter hfc3_tempHigh: 6
2021-05-06 11:38:51 Weather wetter hfc3_cloudCover: 97
2021-05-06 11:38:51 Weather wetter hfc3_humidity: 69
2021-05-06 11:38:51 Weather wetter hfc3_icon: mostlycloudy
2021-05-06 11:38:51 Weather wetter hfc4_pubDate: Do,  6 Mai 2021 22:00
2021-05-06 11:38:51 Weather wetter hfc4_cloudCover: 100
2021-05-06 11:38:51 Weather wetter hfc4_tempHigh: 5
2021-05-06 11:38:51 Weather wetter hfc4_humidity: 71
2021-05-06 11:38:51 Weather wetter hfc4_tempLow: 5
2021-05-06 11:38:51 Weather wetter hfc4_temp_c: 5
2021-05-06 11:38:51 Weather wetter hfc4_condition: Bedeckt
2021-05-06 11:38:51 Weather wetter hfc4_iconAPI: 04n
2021-05-06 11:38:51 Weather wetter hfc4_day_of_week: Do, 22:00
2021-05-06 11:38:51 Weather wetter hfc4_wind_speed: 9
2021-05-06 11:38:51 Weather wetter hfc4_pressure: 1005
2021-05-06 11:38:51 Weather wetter hfc4_low_c: 5
2021-05-06 11:38:51 Weather wetter hfc4_temperature: 5
2021-05-06 11:38:51 Weather wetter hfc4_wind: 9
2021-05-06 11:38:51 Weather wetter hfc4_high_c: 5
2021-05-06 11:38:51 Weather wetter hfc4_code: 28
2021-05-06 11:38:51 Weather wetter hfc4_icon: mostlycloudy
2021-05-06 11:38:51 Weather wetter hfc5_temperature: 4
2021-05-06 11:38:51 Weather wetter hfc5_pressure: 1005
2021-05-06 11:38:51 Weather wetter hfc5_low_c: 4
2021-05-06 11:38:51 Weather wetter hfc5_iconAPI: 04n
2021-05-06 11:38:51 Weather wetter hfc5_condition: Bedeckt
2021-05-06 11:38:51 Weather wetter hfc5_wind_speed: 6
2021-05-06 11:38:51 Weather wetter hfc5_day_of_week: Fr, 01:00
2021-05-06 11:38:51 Weather wetter hfc5_high_c: 4
2021-05-06 11:38:51 Weather wetter hfc5_wind: 6
2021-05-06 11:38:51 Weather wetter hfc5_code: 28
2021-05-06 11:38:51 Weather wetter hfc5_humidity: 72
2021-05-06 11:38:51 Weather wetter hfc5_cloudCover: 100
2021-05-06 11:38:51 Weather wetter hfc5_tempHigh: 4
2021-05-06 11:38:51 Weather wetter hfc5_tempLow: 4
2021-05-06 11:38:51 Weather wetter hfc5_pubDate: Fr,  7 Mai 2021 01:00
2021-05-06 11:38:51 Weather wetter hfc5_temp_c: 4
2021-05-06 11:38:51 Weather wetter hfc5_icon: mostlycloudy
2021-05-06 11:38:51 Weather wetter hfc6_code: 35
2021-05-06 11:38:51 Weather wetter hfc6_wind: 18
2021-05-06 11:38:51 Weather wetter hfc6_high_c: 4
2021-05-06 11:38:51 Weather wetter hfc6_pressure: 1006
2021-05-06 11:38:51 Weather wetter hfc6_low_c: 4
2021-05-06 11:38:51 Weather wetter hfc6_temperature: 4
2021-05-06 11:38:51 Weather wetter hfc6_day_of_week: Fr, 04:00
2021-05-06 11:38:51 Weather wetter hfc6_wind_speed: 18
2021-05-06 11:38:51 Weather wetter hfc6_condition: Leichter Regen
2021-05-06 11:38:51 Weather wetter hfc6_iconAPI: 10n
2021-05-06 11:38:51 Weather wetter hfc6_rain3h: 1.26
2021-05-06 11:38:51 Weather wetter hfc6_temp_c: 4
2021-05-06 11:38:51 Weather wetter hfc6_tempLow: 4
2021-05-06 11:38:51 Weather wetter hfc6_tempHigh: 4
2021-05-06 11:38:51 Weather wetter hfc6_cloudCover: 100
2021-05-06 11:38:51 Weather wetter hfc6_humidity: 85
2021-05-06 11:38:51 Weather wetter hfc6_pubDate: Fr,  7 Mai 2021 04:00
2021-05-06 11:38:51 Weather wetter hfc6_icon: heavyrain
2021-05-06 11:38:51 Weather wetter hfc7_wind_speed: 19
2021-05-06 11:38:51 Weather wetter hfc7_day_of_week: Fr, 07:00
2021-05-06 11:38:51 Weather wetter hfc7_iconAPI: 10d
2021-05-06 11:38:51 Weather wetter hfc7_condition: Leichter Regen
2021-05-06 11:38:51 Weather wetter hfc7_temperature: 5
2021-05-06 11:38:51 Weather wetter hfc7_pressure: 1008
2021-05-06 11:38:51 Weather wetter hfc7_low_c: 5
2021-05-06 11:38:51 Weather wetter hfc7_code: 35
2021-05-06 11:38:51 Weather wetter hfc7_high_c: 5
2021-05-06 11:38:51 Weather wetter hfc7_wind: 19
2021-05-06 11:38:51 Weather wetter hfc7_pubDate: Fr,  7 Mai 2021 07:00
2021-05-06 11:38:51 Weather wetter hfc7_tempLow: 5
2021-05-06 11:38:51 Weather wetter hfc7_cloudCover: 100
2021-05-06 11:38:51 Weather wetter hfc7_tempHigh: 5
2021-05-06 11:38:51 Weather wetter hfc7_humidity: 89
2021-05-06 11:38:51 Weather wetter hfc7_rain3h: 0.62
2021-05-06 11:38:51 Weather wetter hfc7_temp_c: 5
2021-05-06 11:38:51 Weather wetter hfc7_icon: heavyrain
2021-05-06 11:38:51 Weather wetter hfc8_high_c: 7
2021-05-06 11:38:51 Weather wetter hfc8_wind: 21
2021-05-06 11:38:51 Weather wetter hfc8_code: 35
2021-05-06 11:38:51 Weather wetter hfc8_temperature: 7
2021-05-06 11:38:51 Weather wetter hfc8_pressure: 1010
2021-05-06 11:38:51 Weather wetter hfc8_low_c: 7
2021-05-06 11:38:51 Weather wetter hfc8_iconAPI: 10d
2021-05-06 11:38:51 Weather wetter hfc8_condition: Leichter Regen
2021-05-06 11:38:51 Weather wetter hfc8_wind_speed: 21
2021-05-06 11:38:51 Weather wetter hfc8_day_of_week: Fr, 10:00
2021-05-06 11:38:51 Weather wetter hfc8_temp_c: 7
2021-05-06 11:38:51 Weather wetter hfc8_rain3h: 0.52
2021-05-06 11:38:51 Weather wetter hfc8_tempHigh: 7
2021-05-06 11:38:51 Weather wetter hfc8_cloudCover: 99
2021-05-06 11:38:51 Weather wetter hfc8_humidity: 74
2021-05-06 11:38:51 Weather wetter hfc8_tempLow: 7
2021-05-06 11:38:51 Weather wetter hfc8_pubDate: Fr,  7 Mai 2021 10:00
2021-05-06 11:38:51 Weather wetter hfc8_icon: heavyrain
2021-05-06 11:38:51 Weather wetter hfc9_temp_c: 10
2021-05-06 11:38:51 Weather wetter hfc9_rain3h: 0.33
2021-05-06 11:38:51 Weather wetter hfc9_cloudCover: 76
2021-05-06 11:38:51 Weather wetter hfc9_humidity: 55
2021-05-06 11:38:51 Weather wetter hfc9_tempHigh: 10
2021-05-06 11:38:51 Weather wetter hfc9_tempLow: 10
2021-05-06 11:38:51 Weather wetter hfc9_pubDate: Fr,  7 Mai 2021 13:00
2021-05-06 11:38:51 Weather wetter hfc9_high_c: 10
2021-05-06 11:38:51 Weather wetter hfc9_wind: 25
2021-05-06 11:38:51 Weather wetter hfc9_code: 35
2021-05-06 11:38:51 Weather wetter hfc9_temperature: 10
2021-05-06 11:38:51 Weather wetter hfc9_pressure: 1011
2021-05-06 11:38:51 Weather wetter hfc9_low_c: 10
2021-05-06 11:38:51 Weather wetter hfc9_iconAPI: 10d
2021-05-06 11:38:51 Weather wetter hfc9_condition: Leichter Regen
2021-05-06 11:38:51 Weather wetter hfc9_wind_speed: 25
2021-05-06 11:38:51 Weather wetter hfc9_day_of_week: Fr, 13:00
2021-05-06 11:38:51 Weather wetter hfc9_icon: heavyrain
2021-05-06 11:38:51 Weather wetter hfc10_high_c: 9
2021-05-06 11:38:51 Weather wetter hfc10_wind: 30
2021-05-06 11:38:51 Weather wetter hfc10_code: 26
2021-05-06 11:38:51 Weather wetter hfc10_iconAPI: 04d
2021-05-06 11:38:51 Weather wetter hfc10_condition: Überwiegend bewölkt
2021-05-06 11:38:51 Weather wetter hfc10_wind_speed: 30
2021-05-06 11:38:51 Weather wetter hfc10_day_of_week: Fr, 16:00
2021-05-06 11:38:51 Weather wetter hfc10_temperature: 9
2021-05-06 11:38:51 Weather wetter hfc10_pressure: 1012
2021-05-06 11:38:51 Weather wetter hfc10_low_c: 9
2021-05-06 11:38:51 Weather wetter hfc10_temp_c: 9
2021-05-06 11:38:51 Weather wetter hfc10_pubDate: Fr,  7 Mai 2021 16:00
2021-05-06 11:38:51 Weather wetter hfc10_tempHigh: 9
2021-05-06 11:38:51 Weather wetter hfc10_cloudCover: 58
2021-05-06 11:38:51 Weather wetter hfc10_humidity: 63
2021-05-06 11:38:51 Weather wetter hfc10_tempLow: 9
2021-05-06 11:38:51 Weather wetter hfc10_icon: cloudy
2021-05-06 11:38:51 Weather wetter hfc11_high_c: 7
2021-05-06 11:38:51 Weather wetter hfc11_wind: 27
2021-05-06 11:38:51 Weather wetter hfc11_code: 35
2021-05-06 11:38:51 Weather wetter hfc11_temperature: 7
2021-05-06 11:38:51 Weather wetter hfc11_pressure: 1014
2021-05-06 11:38:51 Weather wetter hfc11_low_c: 7
2021-05-06 11:38:51 Weather wetter hfc11_iconAPI: 10d
2021-05-06 11:38:51 Weather wetter hfc11_condition: Leichter Regen
2021-05-06 11:38:51 Weather wetter hfc11_wind_speed: 27
2021-05-06 11:38:51 Weather wetter hfc11_day_of_week: Fr, 19:00
2021-05-06 11:38:51 Weather wetter hfc11_temp_c: 7
2021-05-06 11:38:51 Weather wetter hfc11_rain3h: 0.31
2021-05-06 11:38:51 Weather wetter hfc11_cloudCover: 45
2021-05-06 11:38:51 Weather wetter hfc11_tempHigh: 7
2021-05-06 11:38:51 Weather wetter hfc11_humidity: 74
2021-05-06 11:38:51 Weather wetter hfc11_tempLow: 7
2021-05-06 11:38:51 Weather wetter hfc11_pubDate: Fr,  7 Mai 2021 19:00
2021-05-06 11:38:51 Weather wetter hfc11_icon: heavyrain
2021-05-06 11:38:51 Weather wetter hfc12_pubDate: Fr,  7 Mai 2021 22:00
2021-05-06 11:38:51 Weather wetter hfc12_tempHigh: 5
2021-05-06 11:38:51 Weather wetter hfc12_cloudCover: 6
2021-05-06 11:38:51 Weather wetter hfc12_humidity: 83
2021-05-06 11:38:51 Weather wetter hfc12_tempLow: 5
2021-05-06 11:38:51 Weather wetter hfc12_temp_c: 5
2021-05-06 11:38:51 Weather wetter hfc12_condition: Klarer Himmel
2021-05-06 11:38:51 Weather wetter hfc12_iconAPI: 01n
2021-05-06 11:38:51 Weather wetter hfc12_day_of_week: Fr, 22:00
2021-05-06 11:38:51 Weather wetter hfc12_wind_speed: 20
2021-05-06 11:38:51 Weather wetter hfc12_pressure: 1015
2021-05-06 11:38:51 Weather wetter hfc12_low_c: 5
2021-05-06 11:38:51 Weather wetter hfc12_temperature: 5
2021-05-06 11:38:51 Weather wetter hfc12_wind: 20
2021-05-06 11:38:51 Weather wetter hfc12_high_c: 5
2021-05-06 11:38:51 Weather wetter hfc12_code: 32
2021-05-06 11:38:51 Weather wetter hfc12_icon: sunny
2021-05-06 11:38:51 Weather wetter hfc13_code: 32
2021-05-06 11:38:51 Weather wetter hfc13_high_c: 3
2021-05-06 11:38:51 Weather wetter hfc13_wind: 17
2021-05-06 11:38:51 Weather wetter hfc13_temperature: 3
2021-05-06 11:38:51 Weather wetter hfc13_low_c: 3
2021-05-06 11:38:51 Weather wetter hfc13_pressure: 1016
2021-05-06 11:38:51 Weather wetter hfc13_wind_speed: 17
2021-05-06 11:38:51 Weather wetter hfc13_day_of_week: Sa, 01:00
2021-05-06 11:38:51 Weather wetter hfc13_iconAPI: 01n
2021-05-06 11:38:51 Weather wetter hfc13_condition: Klarer Himmel
2021-05-06 11:38:51 Weather wetter hfc13_temp_c: 3
2021-05-06 11:38:51 Weather wetter hfc13_tempLow: 3
2021-05-06 11:38:51 Weather wetter hfc13_cloudCover: 7
2021-05-06 11:38:51 Weather wetter hfc13_humidity: 88
2021-05-06 11:38:51 Weather wetter hfc13_tempHigh: 3
2021-05-06 11:38:51 Weather wetter hfc13_pubDate: Sa,  8 Mai 2021 01:00
2021-05-06 11:38:51 Weather wetter hfc13_icon: sunny
2021-05-06 11:38:51 Weather wetter hfc14_high_c: 3
2021-05-06 11:38:51 Weather wetter hfc14_wind: 15
2021-05-06 11:38:51 Weather wetter hfc14_code: 32
2021-05-06 11:38:51 Weather wetter hfc14_iconAPI: 01n
2021-05-06 11:38:51 Weather wetter hfc14_condition: Klarer Himmel
2021-05-06 11:38:51 Weather wetter hfc14_wind_speed: 15
2021-05-06 11:38:51 Weather wetter hfc14_day_of_week: Sa, 04:00
2021-05-06 11:38:51 Weather wetter hfc14_temperature: 3
2021-05-06 11:38:51 Weather wetter hfc14_low_c: 3
2021-05-06 11:38:51 Weather wetter hfc14_pressure: 1017
2021-05-06 11:38:51 Weather wetter hfc14_temp_c: 3
2021-05-06 11:38:51 Weather wetter hfc14_pubDate: Sa,  8 Mai 2021 04:00
2021-05-06 11:38:51 Weather wetter hfc14_cloudCover: 8
2021-05-06 11:38:51 Weather wetter hfc14_humidity: 90
2021-05-06 11:38:51 Weather wetter hfc14_tempHigh: 3
2021-05-06 11:38:51 Weather wetter hfc14_tempLow: 3
2021-05-06 11:38:51 Weather wetter hfc14_icon: sunny
2021-05-06 11:38:51 Weather wetter hfc15_temperature: 5
2021-05-06 11:38:51 Weather wetter hfc15_low_c: 5
2021-05-06 11:38:51 Weather wetter hfc15_pressure: 1017
2021-05-06 11:38:51 Weather wetter hfc15_wind_speed: 14
2021-05-06 11:38:51 Weather wetter hfc15_day_of_week: Sa, 07:00
2021-05-06 11:38:51 Weather wetter hfc15_iconAPI: 02d
2021-05-06 11:38:51 Weather wetter hfc15_condition: Ein paar Wolken
2021-05-06 11:38:51 Weather wetter hfc15_code: 30
2021-05-06 11:38:51 Weather wetter hfc15_high_c: 5
2021-05-06 11:38:51 Weather wetter hfc15_wind: 14
2021-05-06 11:38:51 Weather wetter hfc15_tempLow: 5
2021-05-06 11:38:51 Weather wetter hfc15_tempHigh: 5
2021-05-06 11:38:51 Weather wetter hfc15_cloudCover: 12
2021-05-06 11:38:51 Weather wetter hfc15_humidity: 85
2021-05-06 11:38:51 Weather wetter hfc15_pubDate: Sa,  8 Mai 2021 07:00
2021-05-06 11:38:51 Weather wetter hfc15_temp_c: 5
2021-05-06 11:38:51 Weather wetter hfc15_icon: partly_cloudy
2021-05-06 11:38:51 Weather wetter hfc16_tempLow: 9
2021-05-06 11:38:51 Weather wetter hfc16_humidity: 65
2021-05-06 11:38:51 Weather wetter hfc16_cloudCover: 86
2021-05-06 11:38:51 Weather wetter hfc16_tempHigh: 9
2021-05-06 11:38:51 Weather wetter hfc16_pubDate: Sa,  8 Mai 2021 10:00
2021-05-06 11:38:51 Weather wetter hfc16_temp_c: 9
2021-05-06 11:38:51 Weather wetter hfc16_temperature: 9
2021-05-06 11:38:51 Weather wetter hfc16_pressure: 1017
2021-05-06 11:38:51 Weather wetter hfc16_low_c: 9
2021-05-06 11:38:51 Weather wetter hfc16_wind_speed: 15
2021-05-06 11:38:51 Weather wetter hfc16_day_of_week: Sa, 10:00
2021-05-06 11:38:51 Weather wetter hfc16_iconAPI: 04d
2021-05-06 11:38:51 Weather wetter hfc16_condition: Bedeckt
2021-05-06 11:38:51 Weather wetter hfc16_code: 28
2021-05-06 11:38:51 Weather wetter hfc16_high_c: 9
2021-05-06 11:38:51 Weather wetter hfc16_wind: 15
2021-05-06 11:38:51 Weather wetter hfc16_icon: mostlycloudy
2021-05-06 11:38:51 Weather wetter hfc17_tempLow: 12
2021-05-06 11:38:51 Weather wetter hfc17_tempHigh: 12
2021-05-06 11:38:51 Weather wetter hfc17_cloudCover: 93
2021-05-06 11:38:51 Weather wetter hfc17_humidity: 57
2021-05-06 11:38:51 Weather wetter hfc17_pubDate: Sa,  8 Mai 2021 13:00
2021-05-06 11:38:51 Weather wetter hfc17_temp_c: 12
2021-05-06 11:38:51 Weather wetter hfc17_temperature: 12
2021-05-06 11:38:51 Weather wetter hfc17_pressure: 1015
2021-05-06 11:38:51 Weather wetter hfc17_low_c: 12
2021-05-06 11:38:51 Weather wetter hfc17_wind_speed: 16
2021-05-06 11:38:51 Weather wetter hfc17_day_of_week: Sa, 13:00
2021-05-06 11:38:51 Weather wetter hfc17_iconAPI: 04d
2021-05-06 11:38:51 Weather wetter hfc17_condition: Bedeckt
2021-05-06 11:38:51 Weather wetter hfc17_code: 28
2021-05-06 11:38:51 Weather wetter hfc17_high_c: 12
2021-05-06 11:38:51 Weather wetter hfc17_wind: 16
2021-05-06 11:38:51 Weather wetter hfc17_icon: mostlycloudy
2021-05-06 11:38:51 Weather wetter hfc18_temp_c: 13
2021-05-06 11:38:51 Weather wetter hfc18_pubDate: Sa,  8 Mai 2021 16:00
2021-05-06 11:38:51 Weather wetter hfc18_cloudCover: 100
2021-05-06 11:38:51 Weather wetter hfc18_humidity: 60
2021-05-06 11:38:51 Weather wetter hfc18_tempHigh: 13
2021-05-06 11:38:51 Weather wetter hfc18_tempLow: 13
2021-05-06 11:38:51 Weather wetter hfc18_high_c: 13
2021-05-06 11:38:51 Weather wetter hfc18_wind: 20
2021-05-06 11:38:51 Weather wetter hfc18_code: 28
2021-05-06 11:38:51 Weather wetter hfc18_iconAPI: 04d
2021-05-06 11:38:51 Weather wetter hfc18_condition: Bedeckt
2021-05-06 11:38:51 Weather wetter hfc18_wind_speed: 20
2021-05-06 11:38:51 Weather wetter hfc18_day_of_week: Sa, 16:00
2021-05-06 11:38:51 Weather wetter hfc18_temperature: 13
2021-05-06 11:38:51 Weather wetter hfc18_pressure: 1013
2021-05-06 11:38:51 Weather wetter hfc18_low_c: 13
2021-05-06 11:38:51 Weather wetter hfc18_icon: mostlycloudy
2021-05-06 11:38:51 Weather wetter hfc19_wind: 20
2021-05-06 11:38:51 Weather wetter hfc19_high_c: 11
2021-05-06 11:38:51 Weather wetter hfc19_code: 28
2021-05-06 11:38:51 Weather wetter hfc19_pressure: 1010
2021-05-06 11:38:51 Weather wetter hfc19_low_c: 11
2021-05-06 11:38:51 Weather wetter hfc19_temperature: 11
2021-05-06 11:38:51 Weather wetter hfc19_condition: Bedeckt
2021-05-06 11:38:51 Weather wetter hfc19_iconAPI: 04d
2021-05-06 11:38:51 Weather wetter hfc19_day_of_week: Sa, 19:00
2021-05-06 11:38:51 Weather wetter hfc19_wind_speed: 20
2021-05-06 11:38:51 Weather wetter hfc19_temp_c: 11
2021-05-06 11:38:51 Weather wetter hfc19_cloudCover: 100
2021-05-06 11:38:51 Weather wetter hfc19_humidity: 65
2021-05-06 11:38:51 Weather wetter hfc19_tempHigh: 11
2021-05-06 11:38:51 Weather wetter hfc19_tempLow: 11
2021-05-06 11:38:51 Weather wetter hfc19_pubDate: Sa,  8 Mai 2021 19:00
2021-05-06 11:38:51 Weather wetter hfc19_icon: mostlycloudy
2021-05-06 11:38:51 Weather wetter hfc20_pubDate: Sa,  8 Mai 2021 22:00
2021-05-06 11:38:51 Weather wetter hfc20_tempLow: 9
2021-05-06 11:38:51 Weather wetter hfc20_humidity: 90
2021-05-06 11:38:51 Weather wetter hfc20_cloudCover: 100
2021-05-06 11:38:51 Weather wetter hfc20_tempHigh: 9
2021-05-06 11:38:51 Weather wetter hfc20_rain3h: 1.78
2021-05-06 11:38:51 Weather wetter hfc20_temp_c: 9
2021-05-06 11:38:51 Weather wetter hfc20_day_of_week: Sa, 22:00
2021-05-06 11:38:51 Weather wetter hfc20_wind_speed: 32
2021-05-06 11:38:51 Weather wetter hfc20_condition: Leichter Regen
2021-05-06 11:38:51 Weather wetter hfc20_iconAPI: 10n
2021-05-06 11:38:51 Weather wetter hfc20_pressure: 1007
2021-05-06 11:38:51 Weather wetter hfc20_low_c: 9
2021-05-06 11:38:51 Weather wetter hfc20_temperature: 9
2021-05-06 11:38:51 Weather wetter hfc20_code: 35
2021-05-06 11:38:51 Weather wetter hfc20_wind: 32
2021-05-06 11:38:51 Weather wetter hfc20_high_c: 9
2021-05-06 11:38:51 Weather wetter hfc20_icon: heavyrain
2021-05-06 11:38:51 Weather wetter hfc21_pressure: 1006
2021-05-06 11:38:51 Weather wetter hfc21_low_c: 10
2021-05-06 11:38:51 Weather wetter hfc21_temperature: 10
2021-05-06 11:38:51 Weather wetter hfc21_day_of_week: So, 01:00
2021-05-06 11:38:51 Weather wetter hfc21_wind_speed: 31
2021-05-06 11:38:51 Weather wetter hfc21_condition: Leichter Regen
2021-05-06 11:38:51 Weather wetter hfc21_iconAPI: 10n
2021-05-06 11:38:51 Weather wetter hfc21_code: 35
2021-05-06 11:38:51 Weather wetter hfc21_wind: 31
2021-05-06 11:38:51 Weather wetter hfc21_high_c: 10
2021-05-06 11:38:51 Weather wetter hfc21_tempLow: 10
2021-05-06 11:38:51 Weather wetter hfc21_cloudCover: 100
2021-05-06 11:38:51 Weather wetter hfc21_humidity: 89
2021-05-06 11:38:51 Weather wetter hfc21_tempHigh: 10
2021-05-06 11:38:51 Weather wetter hfc21_pubDate: So,  9 Mai 2021 01:00
2021-05-06 11:38:51 Weather wetter hfc21_rain3h: 2.77
2021-05-06 11:38:51 Weather wetter hfc21_temp_c: 10
2021-05-06 11:38:51 Weather wetter hfc21_icon: heavyrain
2021-05-06 11:38:51 Weather wetter hfc22_high_c: 10
2021-05-06 11:38:51 Weather wetter hfc22_wind: 23
2021-05-06 11:38:51 Weather wetter hfc22_code: 26
2021-05-06 11:38:51 Weather wetter hfc22_iconAPI: 04n
2021-05-06 11:38:51 Weather wetter hfc22_condition: Überwiegend bewölkt
2021-05-06 11:38:51 Weather wetter hfc22_wind_speed: 23
2021-05-06 11:38:51 Weather wetter hfc22_day_of_week: So, 04:00
2021-05-06 11:38:51 Weather wetter hfc22_temperature: 10
2021-05-06 11:38:51 Weather wetter hfc22_pressure: 1005
2021-05-06 11:38:51 Weather wetter hfc22_low_c: 10
2021-05-06 11:38:51 Weather wetter hfc22_temp_c: 10
2021-05-06 11:38:51 Weather wetter hfc22_pubDate: So,  9 Mai 2021 04:00
2021-05-06 11:38:51 Weather wetter hfc22_cloudCover: 60
2021-05-06 11:38:51 Weather wetter hfc22_humidity: 93
2021-05-06 11:38:51 Weather wetter hfc22_tempHigh: 10
2021-05-06 11:38:51 Weather wetter hfc22_tempLow: 10
2021-05-06 11:38:51 Weather wetter hfc22_icon: cloudy
2021-05-06 11:38:51 Weather wetter hfc23_pressure: 1005
2021-05-06 11:38:51 Weather wetter hfc23_low_c: 12
2021-05-06 11:38:51 Weather wetter hfc23_temperature: 12
2021-05-06 11:38:51 Weather wetter hfc23_condition: Überwiegend bewölkt
2021-05-06 11:38:51 Weather wetter hfc23_iconAPI: 04d
2021-05-06 11:38:51 Weather wetter hfc23_day_of_week: So, 07:00
2021-05-06 11:38:51 Weather wetter hfc23_wind_speed: 19
2021-05-06 11:38:51 Weather wetter hfc23_wind: 19
2021-05-06 11:38:51 Weather wetter hfc23_high_c: 12
2021-05-06 11:38:51 Weather wetter hfc23_code: 26
2021-05-06 11:38:51 Weather wetter hfc23_tempHigh: 12
2021-05-06 11:38:51 Weather wetter hfc23_cloudCover: 79
2021-05-06 11:38:51 Weather wetter hfc23_humidity: 91
2021-05-06 11:38:51 Weather wetter hfc23_tempLow: 12
2021-05-06 11:38:51 Weather wetter hfc23_pubDate: So,  9 Mai 2021 07:00
2021-05-06 11:38:51 Weather wetter hfc23_temp_c: 12
2021-05-06 11:38:51 Weather wetter hfc23_icon: cloudy
2021-05-06 11:38:51 Weather wetter hfc24_code: 28
2021-05-06 11:38:51 Weather wetter hfc24_wind: 21
2021-05-06 11:38:51 Weather wetter hfc24_high_c: 17
2021-05-06 11:38:51 Weather wetter hfc24_pressure: 1004
2021-05-06 11:38:51 Weather wetter hfc24_low_c: 17
2021-05-06 11:38:51 Weather wetter hfc24_temperature: 17
2021-05-06 11:38:51 Weather wetter hfc24_day_of_week: So, 10:00
2021-05-06 11:38:51 Weather wetter hfc24_wind_speed: 21
2021-05-06 11:38:51 Weather wetter hfc24_condition: Bedeckt
2021-05-06 11:38:51 Weather wetter hfc24_iconAPI: 04d
2021-05-06 11:38:51 Weather wetter hfc24_temp_c: 17
2021-05-06 11:38:51 Weather wetter hfc24_tempLow: 17
2021-05-06 11:38:51 Weather wetter hfc24_cloudCover: 100
2021-05-06 11:38:51 Weather wetter hfc24_humidity: 73
2021-05-06 11:38:51 Weather wetter hfc24_tempHigh: 17
2021-05-06 11:38:51 Weather wetter hfc24_pubDate: So,  9 Mai 2021 10:00
2021-05-06 11:38:51 Weather wetter hfc24_icon: mostlycloudy
2021-05-06 11:38:51 Weather wetter hfc25_code: 28
2021-05-06 11:38:51 Weather wetter hfc25_high_c: 18
2021-05-06 11:38:51 Weather wetter hfc25_wind: 23
2021-05-06 11:38:51 Weather wetter hfc25_temperature: 18
2021-05-06 11:38:51 Weather wetter hfc25_pressure: 1003
2021-05-06 11:38:51 Weather wetter hfc25_low_c: 18
2021-05-06 11:38:51 Weather wetter hfc25_wind_speed: 23
2021-05-06 11:38:51 Weather wetter hfc25_day_of_week: So, 13:00
2021-05-06 11:38:51 Weather wetter hfc25_iconAPI: 04d
2021-05-06 11:38:51 Weather wetter hfc25_condition: Bedeckt
2021-05-06 11:38:51 Weather wetter hfc25_temp_c: 18
2021-05-06 11:38:51 Weather wetter hfc25_tempLow: 18
2021-05-06 11:38:51 Weather wetter hfc25_cloudCover: 100
2021-05-06 11:38:51 Weather wetter hfc25_tempHigh: 18
2021-05-06 11:38:51 Weather wetter hfc25_humidity: 79
2021-05-06 11:38:51 Weather wetter hfc25_pubDate: So,  9 Mai 2021 13:00
2021-05-06 11:38:51 Weather wetter hfc25_icon: mostlycloudy
2021-05-06 11:38:51 Weather wetter hfc26_temperature: 21
2021-05-06 11:38:51 Weather wetter hfc26_pressure: 1001
2021-05-06 11:38:51 Weather wetter hfc26_low_c: 21
2021-05-06 11:38:51 Weather wetter hfc26_iconAPI: 04d
2021-05-06 11:38:51 Weather wetter hfc26_condition: Bedeckt
2021-05-06 11:38:51 Weather wetter hfc26_wind_speed: 24
2021-05-06 11:38:51 Weather wetter hfc26_day_of_week: So, 16:00
2021-05-06 11:38:51 Weather wetter hfc26_high_c: 21
2021-05-06 11:38:51 Weather wetter hfc26_wind: 24
2021-05-06 11:38:51 Weather wetter hfc26_code: 28
2021-05-06 11:38:51 Weather wetter hfc26_humidity: 72
2021-05-06 11:38:51 Weather wetter hfc26_cloudCover: 100
2021-05-06 11:38:51 Weather wetter hfc26_tempHigh: 21
2021-05-06 11:38:51 Weather wetter hfc26_tempLow: 21
2021-05-06 11:38:51 Weather wetter hfc26_pubDate: So,  9 Mai 2021 16:00
2021-05-06 11:38:51 Weather wetter hfc26_temp_c: 21
2021-05-06 11:38:51 Weather wetter hfc26_icon: mostlycloudy
2021-05-06 11:38:51 Weather wetter hfc27_temp_c: 19
2021-05-06 11:38:51 Weather wetter hfc27_pubDate: So,  9 Mai 2021 19:00
2021-05-06 11:38:51 Weather wetter hfc27_tempLow: 19
2021-05-06 11:38:51 Weather wetter hfc27_cloudCover: 100
2021-05-06 11:38:51 Weather wetter hfc27_tempHigh: 19
2021-05-06 11:38:51 Weather wetter hfc27_humidity: 77
2021-05-06 11:38:51 Weather wetter hfc27_code: 28
2021-05-06 11:38:51 Weather wetter hfc27_high_c: 19
2021-05-06 11:38:51 Weather wetter hfc27_wind: 19
2021-05-06 11:38:51 Weather wetter hfc27_wind_speed: 19
2021-05-06 11:38:51 Weather wetter hfc27_day_of_week: So, 19:00
2021-05-06 11:38:51 Weather wetter hfc27_iconAPI: 04d
2021-05-06 11:38:51 Weather wetter hfc27_condition: Bedeckt
2021-05-06 11:38:51 Weather wetter hfc27_temperature: 19
2021-05-06 11:38:51 Weather wetter hfc27_low_c: 19
2021-05-06 11:38:51 Weather wetter hfc27_pressure: 1001
2021-05-06 11:38:51 Weather wetter hfc27_icon: mostlycloudy
2021-05-06 11:38:51 Weather wetter hfc28_cloudCover: 100
2021-05-06 11:38:51 Weather wetter hfc28_humidity: 85
2021-05-06 11:38:51 Weather wetter hfc28_tempHigh: 16
2021-05-06 11:38:51 Weather wetter hfc28_tempLow: 16
2021-05-06 11:38:51 Weather wetter hfc28_pubDate: So,  9 Mai 2021 22:00
2021-05-06 11:38:51 Weather wetter hfc28_temp_c: 16
2021-05-06 11:38:51 Weather wetter hfc28_rain3h: 0.29
2021-05-06 11:38:51 Weather wetter hfc28_pressure: 1001
2021-05-06 11:38:51 Weather wetter hfc28_low_c: 16
2021-05-06 11:38:51 Weather wetter hfc28_temperature: 16
2021-05-06 11:38:51 Weather wetter hfc28_condition: Leichter Regen
2021-05-06 11:38:51 Weather wetter hfc28_iconAPI: 10n
2021-05-06 11:38:51 Weather wetter hfc28_day_of_week: So, 22:00
2021-05-06 11:38:51 Weather wetter hfc28_wind_speed: 18
2021-05-06 11:38:51 Weather wetter hfc28_wind: 18
2021-05-06 11:38:51 Weather wetter hfc28_high_c: 16
2021-05-06 11:38:51 Weather wetter hfc28_code: 35
2021-05-06 11:38:51 Weather wetter hfc28_icon: heavyrain
2021-05-06 11:38:51 Weather wetter hfc29_high_c: 15
2021-05-06 11:38:51 Weather wetter hfc29_wind: 16
2021-05-06 11:38:51 Weather wetter hfc29_code: 35
2021-05-06 11:38:51 Weather wetter hfc29_temperature: 15
2021-05-06 11:38:51 Weather wetter hfc29_low_c: 15
2021-05-06 11:38:51 Weather wetter hfc29_pressure: 1002
2021-05-06 11:38:51 Weather wetter hfc29_iconAPI: 10n
2021-05-06 11:38:51 Weather wetter hfc29_condition: Leichter Regen
2021-05-06 11:38:51 Weather wetter hfc29_wind_speed: 16
2021-05-06 11:38:51 Weather wetter hfc29_day_of_week: Mo, 01:00
2021-05-06 11:38:51 Weather wetter hfc29_temp_c: 15
2021-05-06 11:38:51 Weather wetter hfc29_rain3h: 0.84
2021-05-06 11:38:51 Weather wetter hfc29_tempHigh: 15
2021-05-06 11:38:51 Weather wetter hfc29_cloudCover: 100
2021-05-06 11:38:51 Weather wetter hfc29_humidity: 95
2021-05-06 11:38:51 Weather wetter hfc29_tempLow: 15
2021-05-06 11:38:51 Weather wetter hfc29_pubDate: Mo, 10 Mai 2021 01:00
2021-05-06 11:38:51 Weather wetter hfc29_icon: heavyrain
2021-05-06 11:38:51 Weather wetter hfc30_wind: 22
2021-05-06 11:38:51 Weather wetter hfc30_high_c: 14
2021-05-06 11:38:51 Weather wetter hfc30_code: 35
2021-05-06 11:38:51 Weather wetter hfc30_condition: Leichter Regen
2021-05-06 11:38:51 Weather wetter hfc30_iconAPI: 10n
2021-05-06 11:38:51 Weather wetter hfc30_day_of_week: Mo, 04:00
2021-05-06 11:38:51 Weather wetter hfc30_wind_speed: 22
2021-05-06 11:38:51 Weather wetter hfc30_pressure: 1002
2021-05-06 11:38:51 Weather wetter hfc30_low_c: 14
2021-05-06 11:38:51 Weather wetter hfc30_temperature: 14
2021-05-06 11:38:51 Weather wetter hfc30_temp_c: 14
2021-05-06 11:38:51 Weather wetter hfc30_rain3h: 0.29
2021-05-06 11:38:51 Weather wetter hfc30_pubDate: Mo, 10 Mai 2021 04:00
2021-05-06 11:38:51 Weather wetter hfc30_cloudCover: 100
2021-05-06 11:38:51 Weather wetter hfc30_humidity: 91
2021-05-06 11:38:51 Weather wetter hfc30_tempHigh: 14
2021-05-06 11:38:51 Weather wetter hfc30_tempLow: 14
2021-05-06 11:38:51 Weather wetter hfc30_icon: heavyrain
2021-05-06 11:38:51 Weather wetter hfc31_temp_c: 15
2021-05-06 11:38:51 Weather wetter hfc31_rain3h: 0.14
2021-05-06 11:38:51 Weather wetter hfc31_pubDate: Mo, 10 Mai 2021 07:00
2021-05-06 11:38:51 Weather wetter hfc31_tempHigh: 15
2021-05-06 11:38:51 Weather wetter hfc31_cloudCover: 100
2021-05-06 11:38:51 Weather wetter hfc31_humidity: 93
2021-05-06 11:38:51 Weather wetter hfc31_tempLow: 15
2021-05-06 11:38:51 Weather wetter hfc31_wind: 22
2021-05-06 11:38:51 Weather wetter hfc31_high_c: 15
2021-05-06 11:38:51 Weather wetter hfc31_code: 35
2021-05-06 11:38:51 Weather wetter hfc31_condition: Leichter Regen
2021-05-06 11:38:51 Weather wetter hfc31_iconAPI: 10d
2021-05-06 11:38:51 Weather wetter hfc31_day_of_week: Mo, 07:00
2021-05-06 11:38:51 Weather wetter hfc31_wind_speed: 22
2021-05-06 11:38:51 Weather wetter hfc31_pressure: 1003
2021-05-06 11:38:51 Weather wetter hfc31_low_c: 15
2021-05-06 11:38:51 Weather wetter hfc31_temperature: 15
2021-05-06 11:38:51 Weather wetter hfc31_icon: heavyrain
2021-05-06 11:38:51 Weather wetter hfc32_wind_speed: 23
2021-05-06 11:38:51 Weather wetter hfc32_day_of_week: Mo, 10:00
2021-05-06 11:38:51 Weather wetter hfc32_iconAPI: 10d
2021-05-06 11:38:51 Weather wetter hfc32_condition: Leichter Regen
2021-05-06 11:38:51 Weather wetter hfc32_temperature: 14
2021-05-06 11:38:51 Weather wetter hfc32_pressure: 1005
2021-05-06 11:38:51 Weather wetter hfc32_low_c: 14
2021-05-06 11:38:51 Weather wetter hfc32_code: 35
2021-05-06 11:38:51 Weather wetter hfc32_high_c: 14
2021-05-06 11:38:51 Weather wetter hfc32_wind: 23
2021-05-06 11:38:51 Weather wetter hfc32_pubDate: Mo, 10 Mai 2021 10:00
2021-05-06 11:38:51 Weather wetter hfc32_tempLow: 14
2021-05-06 11:38:51 Weather wetter hfc32_cloudCover: 97
2021-05-06 11:38:51 Weather wetter hfc32_tempHigh: 14
2021-05-06 11:38:51 Weather wetter hfc32_humidity: 88
2021-05-06 11:38:51 Weather wetter hfc32_rain3h: 0.51
2021-05-06 11:38:51 Weather wetter hfc32_temp_c: 14
2021-05-06 11:38:51 Weather wetter hfc32_icon: heavyrain
2021-05-06 11:38:51 Weather wetter hfc33_day_of_week: Mo, 13:00
2021-05-06 11:38:51 Weather wetter hfc33_wind_speed: 21
2021-05-06 11:38:51 Weather wetter hfc33_condition: Bedeckt
2021-05-06 11:38:51 Weather wetter hfc33_iconAPI: 04d
2021-05-06 11:38:51 Weather wetter hfc33_pressure: 1008
2021-05-06 11:38:51 Weather wetter hfc33_low_c: 17
2021-05-06 11:38:51 Weather wetter hfc33_temperature: 17
2021-05-06 11:38:51 Weather wetter hfc33_code: 28
2021-05-06 11:38:51 Weather wetter hfc33_wind: 21
2021-05-06 11:38:51 Weather wetter hfc33_high_c: 17
2021-05-06 11:38:51 Weather wetter hfc33_pubDate: Mo, 10 Mai 2021 13:00
2021-05-06 11:38:51 Weather wetter hfc33_tempLow: 17
2021-05-06 11:38:51 Weather wetter hfc33_tempHigh: 17
2021-05-06 11:38:51 Weather wetter hfc33_cloudCover: 99
2021-05-06 11:38:51 Weather wetter hfc33_humidity: 68
2021-05-06 11:38:51 Weather wetter hfc33_temp_c: 17
2021-05-06 11:38:51 Weather wetter hfc33_icon: mostlycloudy
2021-05-06 11:38:51 Weather wetter hfc34_pubDate: Mo, 10 Mai 2021 16:00
2021-05-06 11:38:51 Weather wetter hfc34_cloudCover: 100
2021-05-06 11:38:51 Weather wetter hfc34_tempHigh: 17
2021-05-06 11:38:51 Weather wetter hfc34_humidity: 68
2021-05-06 11:38:51 Weather wetter hfc34_tempLow: 17
2021-05-06 11:38:51 Weather wetter hfc34_temp_c: 17
2021-05-06 11:38:51 Weather wetter hfc34_condition: Bedeckt
2021-05-06 11:38:51 Weather wetter hfc34_iconAPI: 04d
2021-05-06 11:38:51 Weather wetter hfc34_day_of_week: Mo, 16:00
2021-05-06 11:38:51 Weather wetter hfc34_wind_speed: 13
2021-05-06 11:38:51 Weather wetter hfc34_low_c: 17
2021-05-06 11:38:51 Weather wetter hfc34_pressure: 1008
2021-05-06 11:38:51 Weather wetter hfc34_temperature: 17
2021-05-06 11:38:51 Weather wetter hfc34_wind: 13
2021-05-06 11:38:51 Weather wetter hfc34_high_c: 17
2021-05-06 11:38:51 Weather wetter hfc34_code: 28
2021-05-06 11:38:51 Weather wetter hfc34_icon: mostlycloudy
2021-05-06 11:38:51 Weather wetter hfc35_temp_c: 13
2021-05-06 11:38:51 Weather wetter hfc35_pubDate: Mo, 10 Mai 2021 19:00
2021-05-06 11:38:51 Weather wetter hfc35_humidity: 86
2021-05-06 11:38:51 Weather wetter hfc35_cloudCover: 100
2021-05-06 11:38:51 Weather wetter hfc35_tempHigh: 13
2021-05-06 11:38:51 Weather wetter hfc35_tempLow: 13
2021-05-06 11:38:51 Weather wetter hfc35_wind: 9
2021-05-06 11:38:51 Weather wetter hfc35_high_c: 13
2021-05-06 11:38:51 Weather wetter hfc35_code: 28
2021-05-06 11:38:51 Weather wetter hfc35_condition: Bedeckt
2021-05-06 11:38:51 Weather wetter hfc35_iconAPI: 04d
2021-05-06 11:38:51 Weather wetter hfc35_day_of_week: Mo, 19:00
2021-05-06 11:38:51 Weather wetter hfc35_wind_speed: 9
2021-05-06 11:38:51 Weather wetter hfc35_pressure: 1008
2021-05-06 11:38:51 Weather wetter hfc35_low_c: 13
2021-05-06 11:38:51 Weather wetter hfc35_temperature: 13
2021-05-06 11:38:51 Weather wetter hfc35_icon: mostlycloudy
2021-05-06 11:38:51 Weather wetter hfc36_temp_c: 12
2021-05-06 11:38:51 Weather wetter hfc36_rain3h: 1.77
2021-05-06 11:38:51 Weather wetter hfc36_pubDate: Mo, 10 Mai 2021 22:00
2021-05-06 11:38:51 Weather wetter hfc36_cloudCover: 100
2021-05-06 11:38:51 Weather wetter hfc36_tempHigh: 12
2021-05-06 11:38:51 Weather wetter hfc36_humidity: 97
2021-05-06 11:38:51 Weather wetter hfc36_tempLow: 12
2021-05-06 11:38:51 Weather wetter hfc36_wind: 15
2021-05-06 11:38:51 Weather wetter hfc36_high_c: 12
2021-05-06 11:38:51 Weather wetter hfc36_code: 35
2021-05-06 11:38:51 Weather wetter hfc36_condition: Leichter Regen
2021-05-06 11:38:51 Weather wetter hfc36_iconAPI: 10n
2021-05-06 11:38:51 Weather wetter hfc36_day_of_week: Mo, 22:00
2021-05-06 11:38:51 Weather wetter hfc36_wind_speed: 15
2021-05-06 11:38:51 Weather wetter hfc36_low_c: 12
2021-05-06 11:38:51 Weather wetter hfc36_pressure: 1007
2021-05-06 11:38:51 Weather wetter hfc36_temperature: 12
2021-05-06 11:38:51 Weather wetter hfc36_icon: heavyrain
2021-05-06 11:38:51 Weather wetter hfc37_code: 35
2021-05-06 11:38:51 Weather wetter hfc37_wind: 9
2021-05-06 11:38:51 Weather wetter hfc37_high_c: 11
2021-05-06 11:38:51 Weather wetter hfc37_pressure: 1008
2021-05-06 11:38:51 Weather wetter hfc37_low_c: 11
2021-05-06 11:38:51 Weather wetter hfc37_temperature: 11
2021-05-06 11:38:51 Weather wetter hfc37_day_of_week: Di, 01:00
2021-05-06 11:38:51 Weather wetter hfc37_wind_speed: 9
2021-05-06 11:38:51 Weather wetter hfc37_condition: Starker Regen
2021-05-06 11:38:51 Weather wetter hfc37_iconAPI: 10n
2021-05-06 11:38:51 Weather wetter hfc37_rain3h: 15.83
2021-05-06 11:38:51 Weather wetter hfc37_temp_c: 11
2021-05-06 11:38:51 Weather wetter hfc37_tempLow: 11
2021-05-06 11:38:51 Weather wetter hfc37_cloudCover: 100
2021-05-06 11:38:51 Weather wetter hfc37_tempHigh: 11
2021-05-06 11:38:51 Weather wetter hfc37_humidity: 97
2021-05-06 11:38:51 Weather wetter hfc37_pubDate: Di, 11 Mai 2021 01:00
2021-05-06 11:38:51 Weather wetter hfc37_icon: heavyrain
2021-05-06 11:38:51 Weather wetter hfc38_wind: 18
2021-05-06 11:38:51 Weather wetter hfc38_high_c: 10
2021-05-06 11:38:51 Weather wetter hfc38_code: 35
2021-05-06 11:38:51 Weather wetter hfc38_condition: Mäßiger Regen
2021-05-06 11:38:51 Weather wetter hfc38_iconAPI: 10n
2021-05-06 11:38:51 Weather wetter hfc38_day_of_week: Di, 04:00
2021-05-06 11:38:51 Weather wetter hfc38_wind_speed: 18
2021-05-06 11:38:51 Weather wetter hfc38_pressure: 1008
2021-05-06 11:38:51 Weather wetter hfc38_low_c: 10
2021-05-06 11:38:51 Weather wetter hfc38_temperature: 10
2021-05-06 11:38:51 Weather wetter hfc38_temp_c: 10
2021-05-06 11:38:51 Weather wetter hfc38_rain3h: 10.45
2021-05-06 11:38:51 Weather wetter hfc38_pubDate: Di, 11 Mai 2021 04:00
2021-05-06 11:38:51 Weather wetter hfc38_cloudCover: 100
2021-05-06 11:38:51 Weather wetter hfc38_tempHigh: 10
2021-05-06 11:38:51 Weather wetter hfc38_humidity: 96
2021-05-06 11:38:51 Weather wetter hfc38_tempLow: 10
2021-05-06 11:38:51 Weather wetter hfc38_icon: heavyrain
2021-05-06 11:38:51 Weather wetter hfc39_high_c: 9
2021-05-06 11:38:51 Weather wetter hfc39_wind: 22
2021-05-06 11:38:51 Weather wetter hfc39_code: 35
2021-05-06 11:38:51 Weather wetter hfc39_iconAPI: 10d
2021-05-06 11:38:51 Weather wetter hfc39_condition: Leichter Regen
2021-05-06 11:38:51 Weather wetter hfc39_wind_speed: 22
2021-05-06 11:38:51 Weather wetter hfc39_day_of_week: Di, 07:00
2021-05-06 11:38:51 Weather wetter hfc39_temperature: 9
2021-05-06 11:38:51 Weather wetter hfc39_pressure: 1009
2021-05-06 11:38:51 Weather wetter hfc39_low_c: 9
2021-05-06 11:38:51 Weather wetter hfc39_temp_c: 9
2021-05-06 11:38:51 Weather wetter hfc39_rain3h: 2.12
2021-05-06 11:38:51 Weather wetter hfc39_pubDate: Di, 11 Mai 2021 07:00
2021-05-06 11:38:51 Weather wetter hfc39_humidity: 95
2021-05-06 11:38:51 Weather wetter hfc39_cloudCover: 100
2021-05-06 11:38:51 Weather wetter hfc39_tempHigh: 9
2021-05-06 11:38:51 Weather wetter hfc39_tempLow: 9
2021-05-06 11:38:51 Weather wetter hfc39_icon: heavyrain
2021-05-06 11:38:51 Weather wetter hfc40_temp_c: 12
2021-05-06 11:38:51 Weather wetter hfc40_tempLow: 12
2021-05-06 11:38:51 Weather wetter hfc40_humidity: 81
2021-05-06 11:38:51 Weather wetter hfc40_cloudCover: 100
2021-05-06 11:38:51 Weather wetter hfc40_tempHigh: 12
2021-05-06 11:38:51 Weather wetter hfc40_pubDate: Di, 11 Mai 2021 10:00
2021-05-06 11:38:51 Weather wetter hfc40_code: 28
2021-05-06 11:38:51 Weather wetter hfc40_wind: 14
2021-05-06 11:38:51 Weather wetter hfc40_high_c: 12
2021-05-06 11:38:51 Weather wetter hfc40_pressure: 1010
2021-05-06 11:38:51 Weather wetter hfc40_low_c: 12
2021-05-06 11:38:51 Weather wetter hfc40_temperature: 12
2021-05-06 11:38:51 Weather wetter hfc40_day_of_week: Di, 10:00
2021-05-06 11:38:51 Weather wetter hfc40_wind_speed: 14
2021-05-06 11:38:51 Weather wetter hfc40_condition: Bedeckt
2021-05-06 11:38:51 Weather wetter hfc40_iconAPI: 04d
2021-05-06 11:38:51 Weather wetter hfc40_icon: mostlycloudy
2021-05-06 11:38:51 Weather wetter T: 8 °C F: 70 % W: 28 km/h P: 1004 hPa
2021-05-06 11:38:51 Weather wetter dewpoint: 2.9
2021-05-06 11:38:51 DbLog myDbLog DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1 at ./FHEM/93_DbLog.pm line 2644. 
2021-05-06 11:38:51 DbLog myDbLog CacheUsage: 244
2021-05-06 11:38:52 DbLog myDbLog connected
2021-05-06 11:38:52 DbLog myDbLog CacheUsage: 245

habe nun auf weather, rr.* und rgr.* eingeschränkt, mal sehen.

Wird die Fehlermeldung eigentlich von perl geworfen? Oder könnte man den SQL-Befehl da irgendwie noch im Klartext rein bekommen?

borsti67 · 06 Mai 2021, 20:23:36

Code Auswählen


2021.05.06 19:39:03 4: DbLog myDbLog -> check Device: wetter , Event: hfc27_low_c: 15
2021.05.06 19:39:03 4: DbLog myDbLog -> added event - Timestamp: 2021-05-06 19:39:02, Device: wetter, Type: WEATHER, Event: hfc27_low_c: 15, Reading: hfc27_low_c, Value: 15, Unit: 
2021.05.06 19:39:03 4: DbLog myDbLog -> check Device: wetter , Event: hfc27_temperature: 15
2021.05.06 19:39:03 4: DbLog myDbLog -> added event - Timestamp: 2021-05-06 19:39:02, Device: wetter, Type: WEATHER, Event: hfc27_temperature: 15, Reading: hfc27_temperature, Value: 15, Unit: 
2021.05.06 19:39:03 4: DbLog myDbLog -> check Device: wetter , Event: hfc27_code: 35
2021.05.06 19:39:03 4: DbLog myDbLog -> added event - Timestamp: 2021-05-06 19:39:02, Device: wetter, Type: WEATHER, Event: hfc27_code: 35, Reading: hfc27_code, Value: 35, Unit: 
2021.05.06 19:39:03 4: DbLog myDbLog -> check Device: wetter , Event: hfc27_wind: 19
2021.05.06 19:39:03 4: DbLog myDbLog -> added event - Timestamp: 2021-05-06 19:39:02, Device: wetter, Type: WEATHER, Event: hfc27_wind: 19, Reading: hfc27_wind, Value: 19, Unit: 
2021.05.06 19:39:03 4: DbLog myDbLog -> check Device: wetter , Event: hfc27_high_c: 15
2021.05.06 19:39:03 4: DbLog myDbLog -> added event - Timestamp: 2021-05-06 19:39:02, Device: wetter, Type: WEATHER, Event: hfc27_high_c: 15, Reading: hfc27_high_c, Value: 15, Unit: 
2021.05.06 19:39:03 4: DbLog myDbLog -> check Device: wetter , Event: hfc27_icon: heavyrain
2021.05.06 19:39:03 4: DbLog myDbLog -> added event - Timestamp: 2021-05-06 19:39:02, Device: wetter, Type: WEATHER, Event: hfc27_icon: heavyrain, Reading: hfc27_icon, Value: heavyrain, Unit: 
2021.05.06 19:39:03 4: DbLog myDbLog -> check Device: wetter , Event: hfc28_pubDate: Mo, 10 Mai 2021 04:00
2021.05.06 19:39:03 4: DbLog myDbLog -> added event - Timestamp: 2021-05-06 19:39:02, Device: wetter, Type: WEATHER, Event: hfc28_pubDate: Mo, 10 Mai 2021 04:00, Reading: hfc28_pubDate, Value: Mo, 10 Mai 2021 04:00, Unit: 
2021.05.06 19:39:03 4: DbLog myDbLog -> check Device: wetter , Event: hfc28_tempLow: 14
2021.05.06 19:39:03 4: DbLog myDbLog -> added event - Timestamp: 2021-05-06 19:39:02, Device: wetter, Type: WEATHER, Event: hfc28_tempLow: 14, Reading: hfc28_tempLow, Value: 14, Unit: 
2021.05.06 19:39:03 4: DbLog myDbLog -> check Device: wetter , Event: hfc28_cloudCover: 100
2021.05.06 19:39:03 4: DbLog myDbLog -> added event - Timestamp: 2021-05-06 19:39:02, Device: wetter, Type: WEATHER, Event: hfc28_cloudCover: 100, Reading: hfc28_cloudCover, Value: 100, Unit: 
2021.05.06 19:39:03 4: DbLog myDbLog -> Number of cache entries reached cachelimit 500 - start database sync.
2021.05.06 19:39:03 4: DbLog myDbLog -> ################################################################
2021.05.06 19:39:03 4: DbLog myDbLog -> ###      New database processing cycle - asynchronous        ###
2021.05.06 19:39:03 4: DbLog myDbLog -> ################################################################
2021.05.06 19:39:03 4: DbLog myDbLog -> MemCache contains 500 entries to process
2021.05.06 19:39:03 4: DbLog myDbLog -> DbLogType is: Current/History
2021.05.06 19:39:03 4: DbLog myDbLog -> Number of cache entries reached cachelimit 500 - start database sync.
2021.05.06 19:39:03 4: DbLog myDbLog -> ################################################################
2021.05.06 19:39:03 4: DbLog myDbLog -> ###      New database processing cycle - asynchronous        ###
2021.05.06 19:39:03 4: DbLog myDbLog -> ################################################################
2021.05.06 19:39:03 4: DbLog myDbLog -> MemCache contains 501 entries to process
2021.05.06 19:39:03 4: DbLog myDbLog -> DbLogType is: Current/History
2021.05.06 19:39:03 4: DbLog myDbLog -> AutoCommit mode: ON, Transaction mode: ON
2021.05.06 19:39:03 4: DbLog myDbLog -> AutoCommit mode: ON, Transaction mode: ON
2021.05.06 19:39:03 4: DbLog myDbLog -> Insert mode: Bulk
2021.05.06 19:39:03 4: DbLog myDbLog -> Insert mode: Bulk
2021.05.06 19:39:03 4: DbLog myDbLog -> Primary Key used in history: none
2021.05.06 19:39:03 4: DbLog myDbLog -> Primary Key used in current: DEVICE,READING
2021.05.06 19:39:03 4: DbLog myDbLog -> Primary Key used in history: none
2021.05.06 19:39:03 4: DbLog myDbLog -> Primary Key used in current: DEVICE,READING
2021.05.06 19:39:03 2: DbLog myDbLog -> Error table history - DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1 at ./FHEM/93_DbLog.pm line 2644.

2021.05.06 19:39:03 4: DbLog myDbLog -> 0 of 0 events updated in table current using PK on columns DEVICE,READING
2021.05.06 19:39:03 4: DbLog myDbLog -> insert / update table current committed by autocommit
2021.05.06 19:39:05 4: DbLog myDbLog -> 501 of 501 events inserted into table history
2021.05.06 19:39:06 4: DbLog myDbLog -> insert table history committed by autocommit
2021.05.06 19:39:07 4: DbLog myDbLog -> 501 of 501 events updated in table current using PK on columns DEVICE,READING
2021.05.06 19:39:07 4: DbLog myDbLog -> insert / update table current committed by autocommit

DS_Starter · 06 Mai 2021, 20:48:03

Da ist nichts abnormales zu sehen, wirst du wohl verbose 5 einschalten müssen.

borsti67 · 09 Mai 2021, 18:50:55

Hm, gerade versucht Logauszüge zu posten, aber scheinbar wird der Beitrag zu lang - in der Vorschau sieht es normal aus, aber nach dem Absenden fehlt die Hälfte.

Macht es Sinn das bei Pastebin oder so einzustellen? Ich sehe da aber leider immer noch nichts nützliches.

borsti67 · 09 Mai 2021, 19:00:03

Einträge sind halt sehr ähnlich für diverse Wetter-Readings...

Code Auswählen

2021.05.09 17:40:54 4: DbLog myDbLog -> ################################################################
2021.05.09 17:40:54 4: DbLog myDbLog -> ###              start of new Logcycle                       ###
2021.05.09 17:40:54 4: DbLog myDbLog -> ################################################################
2021.05.09 17:40:54 4: DbLog myDbLog -> number of events received: 2 of device: rr_T
2021.05.09 17:40:54 4: DbLog myDbLog -> check Device: rr_T , Event: durTimerPresence_cr: 32
2021.05.09 17:40:54 5: DbLog myDbLog -> parsed Event: rr_T , Event: durTimerPresence_cr: 32
2021.05.09 17:40:54 5: DbLog myDbLog -> DbLogExclude of "rr_T": durTimer.*
2021.05.09 17:40:54 4: DbLog myDbLog -> check Device: rr_T , Event: durTimerPresence: 00:32:01
2021.05.09 17:40:54 5: DbLog myDbLog -> parsed Event: rr_T , Event: durTimerPresence: 00:32:01
2021.05.09 17:40:54 5: DbLog myDbLog -> DbLogExclude of "rr_T": durTimer.*
2021.05.09 17:41:02 4: DbLog myDbLog -> ################################################################
2021.05.09 17:41:02 4: DbLog myDbLog -> ###      New database processing cycle - asynchronous        ###
2021.05.09 17:41:02 4: DbLog myDbLog -> ################################################################
2021.05.09 17:41:02 4: DbLog myDbLog -> MemCache contains 250 entries to process
2021.05.09 17:41:02 4: DbLog myDbLog -> DbLogType is: Current/History
2021.05.09 17:41:02 5: DbLog myDbLog -> MemCache contains: 2021-05-09 17:40:31|wetter|WEATHER|hfc27_iconAPI: 04n|hfc27_iconAPI|04n|
2021.05.09 17:41:02 5: DbLog myDbLog -> MemCache contains: 2021-05-09 17:40:31|wetter|WEATHER|hfc27_condition: Bedeckt|hfc27_condition|Bedeckt|
2021.05.09 17:41:02 5: DbLog myDbLog -> MemCache contains: 2021-05-09 

[...]

2021.05.09 17:41:02 5: DbLog myDbLog -> MemCache contains: 2021-05-09 17:40:31|wetter|WEATHER|hfc40_tempHigh: 10|hfc40_tempHigh|10|
2021.05.09 17:41:02 5: DbLog myDbLog -> MemCache contains: 2021-05-09 17:40:31|wetter|WEATHER|hfc40_cloudCover: 100|hfc40_cloudCover|100|
2021.05.09 17:41:02 5: DbLog myDbLog -> MemCache contains: 2021-05-09 17:40:31|wetter|WEATHER|hfc40_humidity: 77|hfc40_humidity|77|
2021.05.09 17:41:02 5: DbLog myDbLog -> MemCache contains: 2021-05-09 17:40:31|wetter|WEATHER|hfc40_pubDate: Fr, 14 Mai 2021 16:00|hfc40_pubDate|Fr, 14 Mai 2021 16:00|
2021.05.09 17:41:02 5: DbLog myDbLog -> MemCache contains: 2021-05-09 17:40:31|wetter|WEATHER|hfc40_icon: mostlycloudy|hfc40_icon|mostlycloudy|
2021.05.09 17:41:02 5: DbLog myDbLog -> MemCache contains: 2021-05-09 17:40:31|wetter|WEATHER|dewpoint: 15.8|dewpoint|15.8|
2021.05.09 17:41:02 5: DbLog myDbLog -> MemCache contains: 2021-05-09 17:40:33|myDbLog|DBLOG|state: DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1 at ./FHEM/93_DbLog.pm line 2644.
|state|DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server ve|
2021.05.09 17:41:02 5: DbLog myDbLog -> MemCache contains: 2021-05-09 17:40:33|myDbLog|DBLOG|state: connected|state|connected|
2021.05.09 17:41:02 5: DbLog myDbLog -> MemCache contains: 2021-05-09 17:40:37|o_SZHeizung|FHT|actuator: 0%|actuator|0|%
2021.05.09 17:41:02 5: DbLog myDbLog -> MemCache contains: 2021-05-09 17:40:40|Heisswasser|FS20|state: off|state|off|
2021.05.09 17:41:02 5: DbLog myDbLog -> MemCache contains: 2021-05-09 17:40:54|di_FHTCheck|DOIF|FHT_az_Heizung: ok|FHT_az_Heizung|ok|
2021.05.09 17:41:02 5: DbLog myDbLog -> MemCache contains: 2021-05-09

im Monitor sah es so aus:

Code Auswählen

2021-05-09 17:40:54 ROOMMATE rr_T durTimerPresence_cr: 32
2021-05-09 17:40:54 ROOMMATE rr_T durTimerPresence: 00:32:01
2021-05-09 17:40:54 DOIF di_FHTCheck FHT_az_Heizung: ok
2021-05-09 17:40:54 DOIF di_FHTCheck cmd_nr: 1
2021-05-09 17:40:54 DOIF di_FHTCheck cmd: 1
2021-05-09 17:40:54 DOIF di_FHTCheck cmd_event: az_Heizung
2021-05-09 17:40:54 DOIF di_FHTCheck cmd_1
2021-05-09 17:40:54 FHT az_Heizung measured-temp: 22.8
2021-05-09 17:40:54 FHT az_Heizung temperature: 22.8
2021-05-09 17:40:55 DOIF di_BatterieCheck alle OK
2021-05-09 17:40:55 FHT az_Heizung battery: ok
2021-05-09 17:40:55 FHT az_Heizung batteryState: ok
2021-05-09 17:40:55 FHT az_Heizung lowtemp: ok
2021-05-09 17:40:55 FHT az_Heizung window: closed
2021-05-09 17:40:55 FHT az_Heizung windowsensor: ok
2021-05-09 17:40:55 FHT az_Heizung warnings: none
2021-05-09 17:41:02 DbLog myDbLog CacheOverflowLastNum: 0
2021-05-09 17:41:02 DbLog myDbLog CacheOverflowLastState: normal
2021-05-09 17:41:02 DbLog myDbLog CacheUsage: 251
2021-05-09 17:41:02 DbLog myDbLog CacheUsage: 252
2021-05-09 17:41:03 FHT bad_Heizung actuator: 0%

Für mich steht da leider auch nicht wirklich was nützliches.

DS_Starter · 15 Mai 2021, 08:49:03

Ich sehe da leider auch nichts.
Tipp: setze dir doch mal das Attr useCharfilter = 1.

VG

borsti67 · 17 Mai 2021, 08:07:15

Danke DS_Starter,
hat leider auch keine Änderung gebracht. Muss ich wohl mit leben...