Weird issue with energy cost after change DB to MariaDB

Configuration
1

Hello

I’ve a very strange issue with my installation. Late July I switched to MariaDB and migrate all tables from SQLite to MariaDB without issue, and every thing is working right except the calculated cost of energy in energy page.

The price is obtained from ESIOS REE Integration that gives a price for every hour of the day.

The calculation was working fine while using SQLite, but after moving to MariaDB it began to give very weird costs calculations, like (for example yesterday 1261,80€ for 15 kWh, other days the calculation may be higher).

The price from integration is right, as I’m watching it in home page.

I’ve removed and created again in energy panel, and wait the month change to see if it has something related but no.

I really don’t understand the influence of the DB and (think) everything was migrated without problem.

Do anyone knows how to solve this / guide me where to search?

Thanks!

2

I migrated to mariadb last Friday and just noticed the energy calculations since are completely nuts. More than a factor 1000 wrong some days. I have no idea so far what’s causing it, did you find something?

3

Hello, are there any updates or could you resolve your Problems?
I recently moved to maradb which worked well, but since then, Energy costs a weird. One day its 20 Cents/kWh, the other day its Cents/kWh and i dont know why.