Too many unprocessed readings & Day statistics are lagging behind

[TimvdEijnden]

I got these notifications:

And the numbers keep increasing.

I'm running https://github.com/xirixiz/dsmr-reader-docker with postgres:12

What I've tried:

• Removing /etc/localtime:/etc/localtime:ro
• Upgrading from 4.14.0 to 4.15.1

I did this just 20 minutes ago, does it need more time to solve this or can I manually fix this?

Here is the debug info dump:

DSMR-READER
    App / Python / Database                                                     v4.15.1 / v3.9.3 / postgresql
    BE sleep / DL sleep / Retention / Override                                     1.0s / 5.0s / 672h / False
    Latest telegram version read / Parser settings                                                 "42" / "4"

DATA
    Telegrams total (est.)                                                                              55348
    Consumption records electricity / gas (est.)                                                  18985 / 464

UNRESOLVED ISSUES
    Too many unprocessed readings: 20397                                                   1 week, 4 days ago
    Day statistics are lagging behind                                                      1 week, 4 days ago

[TimvdEijnden]

I just noticed that the date of the dsmr_reader container was
Thu Apr 8 08:01:55 UTC 2021

And postgres:
Thu 08 Apr 2021 10:02:37 AM CEST

I just added TZ=Europe/Amsterdam to the dsmr_reader environment variables and recreated the container and checked again.

Now the dates are in sync.

$ docker exec -it dsmr_reader bash -c date
Thu Apr  8 10:07:41 CEST 2021
$ docker exec -it postgres bash -c date
Thu 08 Apr 2021 10:07:42 AM CEST

Numbers are still increasing

[TimvdEijnden]

Just fixed it by changing postgres image from postgres:12 to postgres:12.4-alpine, numbers are going down now 🎉