Azure data explorer integration stops

The problem

Azure Data Explorer integration stops sending data to ADX. After restart the logs says xx number of events dropped

What version of Home Assistant Core has the issue?

2024-06-02

What was the last working version of Home Assistant Core?

No response

What type of installation are you running?

Home Assistant OS

Integration causing the issue

azure data explorer

Link to integration documentation on our website

https://www.home-assistant.io/integrations/azure_data_explorer

Diagnostics information

This seems to happen when a State on the event-bus is not serializable. ex. the HACS integration Affalddk is not serializable, bur this has also been found in other integrations. The solution is to make the ADX integration more robust to filter these malformed data. As a tested workarround, setting up filters on the entities causing the problem will make the ADX integration work again

example of non serializable state:

entity_id='sensor.affalddk_road_number_farligt_affald' state='73' attributes={'date': '2024-08-29', 'date_long': 'Torsdag d. 29-08-2024', 'date_short': 'Tor d. 29/08', 'description': 'Rød boks (1 stk.)', 'duration': 'Om 73 dage', 'entity_picture': 'data:image/svg+xml;base64,PHN2ZyB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciIHdpZHRoPSI2ODAuMzIiIGhlaWdodD0iNjgwLjMyIj48cGF0aCBkPSJNNTEwMi4zNiAwSDB2NTEwMi4zNmg1MTAyLjM2eiIgc3R5bGU9ImZpbGw6I2U5MWQyYztmaWxsLW9wYWNpdHk6MTtmaWxsLXJ1bGU6bm9uemVybztzdHJva2U6bm9uZSIgdHJhbnNmb3JtPSJtYXRyaXgoLjEzMzMzIDAgMCAtLjEzMzMzIDAgNjgwLjMyKSIvPjxwYXRoIGQ9Im0yNjAyLjIzIDIzNDUuMTYtMTAxLjg3LjE0LTUxLjIgODE2LjI0aDIwNC4xem0tNTEuMDItMzA0LjQ0Yy01Ni4zNiAwLTEwMi4wNSA0NS42OS0xMDIuMDUgMTAyLjA1czQ1LjY5IDEwMi4wNSAxMDIuMDUgMTAyLjA1IDEwMi4wNS00NS42OSAxMDIuMDUtMTAyLjA1LTQ1LjY5LTEwMi4wNS0xMDIuMDUtMTAyLjA1bTEyMDAuNjgtMTQ3LjI0LjAxLjAyLTExNDAuNDkgMTg5OC45OWMtMTIuMzEgMjAuMzQtMzQuNjYgMzMuOTMtNjAuMiAzMy45My0yNy4wMyAwLTUwLjQ4LTE1LjIzLTYyLjI0LTM3LjU2TDEzNTAuMjEgMTg5M2wuMDEtLjAxYy03Ljg5LTEyLjQ3LTExLjk2LTI3LjU3LTEwLjU0LTQzLjcgMy4yMy0zNi43NCAzNi4xOC02My44MSA3My4wNy02My44MWgyMjc2LjgzYzM3LjA1IDAgNzAuMTQgMjcuMjggNzMuMTkgNjQuMiAxLjM1IDE2LjItMi44NiAzMS4zNC0xMC44OCA0My44IiBzdHlsZT0iZmlsbDojZmZmO2ZpbGwtb3BhY2l0eToxO2ZpbGwtcnVsZTpub256ZXJvO3N0cm9rZTpub25lIiB0cmFuc2Zvcm09Im1hdHJpeCguMTMzMzMgMCAwIC0uMTMzMzMgMCA2ODAuMzIpIi8+PC9zdmc+', 'last_update': '2024-06-17T08:29:18.328399+02:00', 'name': 'Farligt affald', 'unit_of_measurement': 'dage', 'attribution': 'Data delivered by Danish Municipalities', 'icon': 'mdi:recycle', 'friendly_name': 'Affalddk Road Number Farligt affald'} last_changed=datetime.datetime(2024, 6, 17, 6, 29, 18, 360184, tzinfo=TzInfo(UTC)) last_updated=datetime.datetime(2024, 6, 17, 6, 29, 18, 360184, tzinfo=TzInfo(UTC)) context=Context(id='01J0JE5FWR8DYA0717QTZREFYR')

Example YAML snippet

No response

Anything in the logs that might be useful for us?

Logger: homeassistant.components.azure_data_explorer
Kilde: components/azure_data_explorer/__init__.py:175
integration: Azure Data Explorer (dokumentation, problemer)
Første forekomst: 8.28.21 AM (26 forekomster)
Senest logget: 9.06.46 AM

Dropped 4 old events, consider filtering messages
Dropped 1 old events, consider filtering messages
Dropped 2 old events, consider filtering messages

Additional information

No response

home-assistant / core