0.111.2 breaks history graphs.

[tomlut]

Checklist

• I have updated to the latest available Home Assistant version.
• I have cleared the cache of my browser.
• I have tried a different browser to see if it is related to my browser.

The problem

Since updating to v0.111.2 (from 0.110.7) all history graphs, including the core Lovelace card and more info pop-ups show only the current value.

My database is fine and custom-mini-graph cards display entity history correctly.

Expected behavior

History graph card to show a history of entities.

Steps to reproduce

Click on any entity that has history data and a unit.

Environment

• Home Assistant release with the issue:
  Home Assistant NUC image 0.111.2
• Last working Home Assistant release (if known):
  0.110.7
• Browser and browser version:
  Fails on the latest Firefox, Chrome, and the iOS app.
• Operating system:
  Windows 10, iOS13.5.1

State of relevant entities

N/A

Problem-relevant configuration

N/A

Javascript errors shown in your browser console/inspector

Additional information

[bramkragten]

What database do you use?

[bramkragten]

CC @bdraco

[thecode]

I have the same issue, I'm using the MariaDB as an addon, manually downgraded HA to 0.111.1 and got all the sensors data back.

[tomlut]

MariaDB addon.

[bdraco]

Setting up a mariadb server now for testing

[thecode]

can it be related to this home-assistant/core#36746?
My system is using Asia/Jerusalem timezone (GMT+3)

[bdraco]

can it be related to this home-assistant/core#36746?
My system is using Asia/Jerusalem timezone (GMT+3)

definitely the cause of the regression

[thecode]

@tomlut you can manually downgrade to 0.111.1 by using:
ha core update --version=0.111.1
From the SSH / Web Terminal

[bdraco]

Please try this patch

bdraco/home-assistant@8bcbfdc

[thecode]

Please try this patch

bdraco/home-assistant@8bcbfdc

Is there an easy way to apply it on hassio installation?
I have a dev system with the code but I don't have the DB there.

[bdraco]

There is a bit of setup to get inside the hassio docker container:

https://developers.home-assistant.io/docs/operating-system/debugging/#home-assistant-operating-system

https://developers.home-assistant.io/docs/operating-system/debugging/#accessing-the-container-bash

[tomlut]

@tomlut you can manually downgrade to 0.111.1 by using:
ha core update --version=0.111.1
From the SSH / Web Terminal

Thanks, but I'm already back on 0.110.7

Didn't realise 0.111.1 would work. Also have other issues with custom cards on 0.111 so am waiting for them to be fixed.

[bdraco]

I did replicate the issue and verified the patch fixes it. It would be good to get a second verification.