Migration is ready, this is how it looks like.
This is my main, using homeassistant_v2
This is test server 2 using MARIADB from scratch, and no migration
this is from my new migration, migrated from the first screenshot
you can see the migrated one is correct, no issue with the migration at all…
So we can exclude the problem comes from the migration.
i did not start home assistant test server 3 yet, but as you can see some time has passed so it will add new data, and thats where it goes wrong, it will reset to 0, thats what happened last time
@vingerha let me know if u need something else before i start up my third test server. so we can see whats going to happen
// wait i noticed something, see screenshot 1
the entry at 11:15:00 is this = 1.291619999999892(state) 1176.3091600000134(sum)
the migrated one
the entry at 11:15:00 is this = 1.13905(state) 1176.16(sum)
//UPDATE2
i did start up my third system with the new migrated DB
getting this message now, running 2022.12 beta
lets wait till an update has happened, the costs look fine.