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

ERROR schedule execute_scheduled_processes 40 | (IntegrityError) #54

Closed poudenes closed 2 years ago

poudenes commented 2 years ago

Hi All,

Moved my dB to my NAS. Restored a backup created inside DSMR. All my old information is visible in the UI. But no new information will add in the dB.

I see this error:

2022-06-13 12:08:42,067 ERROR    schedule     execute_scheduled_processes      40 | (IntegrityError) dsmr_consumption.services.run errored: null value in column "delivered_1" of relation "dsmr_consumption_electricityconsumption" violates not-null constraint
DETAIL:  Failing row contains (1102161, 2022-06-13 04:00:00+02, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null).

What can I do?

I followed this how to: https://dsmr-reader.readthedocs.io/en/v5/how-to/database/postgresql-restore-backup.html#importing-a-full-backup

sanderdw commented 2 years ago

That's a specific application error, maybe you can check the issues here: https://github.com/dsmrreader/dsmr-reader/issues/1619