search

sanderdw / hassio-addons

DSMR Reader Datalogger and Metabase Home Assistant Add-ons
https://community.home-assistant.io/search?q=%40sanderdw%20%23home-assistant-os
Other
56 stars 14 forks source link

Background processing broken? #37

Closed dennisbrouwer91 closed 2 years ago

dennisbrouwer91 commented 2 years ago

Hi,

After upgrading to the 5.1 version my DSMR Reader instance isn't processing the received data anymore. See screenshot

Schermafbeelding 2022-04-04 om 11 57 48

.

Any known issue?

sanderdw commented 2 years ago

You need to post the log of the addon. Also explain how your setup looks like. The are also other issues like https://community.home-assistant.io/t/dsmr-reader-add-on-for-home-assistant/279087/208?u=sanderdw possible.

dennisbrouwer91 commented 2 years ago

Yes, agreed. I think this part of the log is interesting : 2022-04-04 12:01:53,521 ERROR schedule execute_scheduled_processes 37 | (IntegrityError) dsmr_consumption.services.run errored: null value in column "delivered_1" violates not-null constraint DETAIL: Failing row contains (437786, 2022-04-01 06:58:00+00, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null).

TimeScaleDB Has been rolled back indeed because of it breaking after the upgrade. Setup is pretty simple : Smart meter -> P1 to USB cable directly to my Intel NUC which is running HassIO in Supervised mode. Worked until the upgrade!

sanderdw commented 2 years ago

Maybe have a look here as it's not related to the addon but to the software itself? https://github.com/dsmrreader/dsmr-reader/issues/1288