Energy Dashboard stopped showing energy sensors

[chomupashchuk]

The problem

After upgrade to 2021.10.x the Energy Dashboard stopped showing energy sensors in dropdown menu. I have few Shelly Plug S, which have energy sensors and additionally custom integration (https://github.com/chomupashchuk/ariston-remotethermo-home-assistant-v2). Shelly Plug S was visible in dropdown and after adding state_class I was able to get Ariston sensors visible in version 2021.9.x. After the upgrade to 2021.10.x I no longer see Shelly (which is an integration in HA) nor sensors from custom component.

Additionally in version 2021.9.x state_class as property did not work, it worked only when it was reported as attribute value, which is strange.

What is version of Home Assistant Core has the issue?

2021.10.1

What was the last working version of Home Assistant Core?

2021.9.1

What type of installation are you running?

Home Assistant Container

Integration causing the issue

No response

Link to integration documentation on our website

No response

Example YAML snippet

No response

Anything in the logs that might be useful for us?

No response

Additional information

No response

[kerbalette]

Same with mine

[licheng5625]

The roit cause might be Recorder cannot query Statistics due to issue with MariaDB #57708

[emontnemery]

@chomupashchuk, @kerbalette Please help by:

1. Check if any issues are reported for the sensors in the statistics dev tool (new feature in 2021.10)
2. Share a screenshot of 1-2 sensors from the state dev tool which you expect to see in the energy dashboard dropdown but are not there

[emontnemery]

@licheng5625 the problem with old versions of database engine will cause statistics for sensors to not be generated, it won't prevent sensors from being possible to select.

[chomupashchuk]

I have nod added sensors to statistics yet, so it is empty with no issues (screenshot). As for sensors I'm including ones, which should be visible in ADD CONSUMPTION option in energy dashboard.

[emontnemery]

@chomupashchuk using your browser's developer tool, please paste the response of WS commands history/list_statistic_ids + history/validate_statistics when you open the statistics dev tool

If you don't see any WS data, try reloading the page after opening the browser development tool

In Chrome, you can right-click on the responses to list_statistics_ids and validate_statistics and choose "copy message" to get the full response

[chomupashchuk]

{"type":"history/list_statistic_ids","id":22}
{"type":"recorder/validate_statistics","id":23}

I have not seen STATISTICS tab before and do not know what kind of data it shows. In my case In Energy in dropdown I had option to select sensors but in the latest version I do not see sensors in dropdown menu. I have not actually added sensors in Energy dashboard, only checked availability option during development of custom integration.

So should STATISTICS show actually added sensors in Energy? I'm asking to avoid confusion.

[emontnemery]

@chomupashchuk please paste the RESPONSE to the WS commands history/list_statistic_ids + history/validate_statistics. In my screenshot it's these:

[chomupashchuk]

{"id": 22, "type": "result", "success": true, "result": []}

{"id": 23, "type": "result", "success": true, "result": {}}

[emontnemery]

Have you manually configured the recorder by any chance? If you have, can you share the recorder configuration?

[chomupashchuk]

Yes, it was configured manually. I have commented out changes temporary and Shelly Plug S appeared as an option in Energy Dashboard. So As i understand in latest version dependency to recorder was added? As same configuration existed in 2021.9.x.

purge_keep_days: 1
#purge_interval: 1
include:
  entities:
#    - sensor.current_weather_temperature
#    - sensor.current_weather_humidity
#    - sensor.current_weather_pressure
    - sensor.living_room_temperature
#    - sensor.living_room_humidity
#    - sensor.living_room_pressure
    - sensor.bedroom_temperature
#    - sensor.bedroom_humidity
#    - sensor.bedroom_pressure
    - sensor.corridor_temperature
#    - sensor.corridor_humidity
#    - sensor.corridor_rssi
    - sensor.kitchen_temperature
#    - sensor.kitchen_humidity
#    - sensor.kitchen_rssi
    - sensor.bathroom_temperature
#    - sensor.bathroom_humidity
#    - sensor.bathroom_rssi
#    - sensor.ac_group_power
#    - sensor.ac_group_apparent_power
#    - sensor.ac_group_reactive_power
#    - sensor.ac_group_factor
#    - sensor.ac_group_current
#    - sensor.ac_group_voltage
#    - sensor.currency_usd
#    - sensor.currency_eur
#    - automation.away
#    - automation.home
#    - sensor.shelly_temperature
#    - sensor.shelly_power
#    - sensor.monobank_eur_ask
#    - sensor.monobank_eur_bid
#    - sensor.monobank_usd_ask
#    - sensor.monobank_usd_bid
#    - sensor.privatbank_eur_ask
#    - sensor.privatbank_eur_bid
#    - sensor.privatbank_usd_ask
#    - sensor.privatbank_usd_bid
#    - binary_sensor.ariston_flame
#    - binary_sensor.ariston_ch_flame
#    - binary_sensor.ariston_dhw_flame
#    - switch.dehumidifier
#    - switch.bathroom_vent
#    - sensor.ariston_ch_set_temperature
    - climate.ariston
    - water_heater.ariston
#    - sensor.currency_eur_beginning
#    - sensor.currency_usd_beginning
#    - sensor.speedtest_download
#    - sensor.speedtest_ping
#    - sensor.speedtest_upload

[emontnemery]

In previous version, a sensor which was excluded from recorder could be picked but it didn't work. In current version, a sensor which is excluded from recorder can't be picked.