[Bug]: localtuya is flooding the DB of events

[m4r1k]

LocalTuya Version

2025.1.1

Home Assistant Version

2025.1.4 Docker

Environment

• Does the device work using the Home Assistant Tuya Cloud component?
• Is this device connected to another local integration, including Home Assistant and any other tools?
• The devices are within the same HA subnet, and they get discovered automatically when I add them

What happened?

Hello there,

I just reported on the HA community how LocalTuya is flooding the DB of events.
https://community.home-assistant.io/t/how-to-keep-your-recorder-database-size-under-control/295795/303?u=m4r1k

42970497|47|localtuya_device_triggered
41694080|45|localtuya_device_dp_triggered
6170957|6|localtuya_states_update

The events are described here: https://github.com/xZetsubou/hass-localtuya/blob/master/documentation/docs/ha_events.md?plain=1

But I think there should be a config on a per-device basis to record all this many events.
Also, I've seen an increase in the number of events from the 2025.1 version.

Steps to reproduce.

unclear

Relevant log output

Diagnostics information.

No response

[xZetsubou]

The is an old issue #372 tho I haven't give it much attention yet so yes I would recommended to exclude it from recorder for now, this could happen if you have a sensors that update every seconds.

[Cook23]

For every new version I make the same modification:

to remove it locally you can comment out a line in localtuya module. from home assistant directory. config/custom_components/localtuya/coordinator.py open the file and search for this line

self._handle_event(self._status, status)

then comment it out or remove you can comment it out by adding "#" at the beginning of the text # self.....

If not "event" and "event_data" table of database grow by several gigabytes every day.

This recording of events by "self._handle_event(self._status, status)" should definitively be an option disabled by default.

[xZetsubou]

this method handle the whole device not only one entity, Now the issue even If I give the user the option to turn it on it's still an issue it's still an issue and If HA doesn't give an option to filter it hard coded, then I'll need to create filter my self it's fine it's not big deal I'll look into it soon.

[Cook23]

Yes but I don't know the reason of these writes in "event" tables of database for every entities. In fact I don't know the use of "event" tables.

For me it's completely useless. The only data I use come from the "state" and "statistics" tables of database. If I truncate these "event" tables nothing change, home assistant still running flawlessly without any difference. I imagine "event" tables have some use but I didn't see it.

It's possible to choose what is recorded in "state" tables from recorder settings but these settings have no effect on event tables.

So I only see "event" tables as a major flaw that cause my home assistant eat my memory and became unfunctionnal in just few weeks.

[xZetsubou]

I made some changes I was hopefully that there was a way to exclude events from HA recorder hard-coded.

TBF, I'm not sure if it will fix this issue totally or not however I still recommend to exclude integration events from recorder in configuration.yml I'll update the events page in docs.

What I'm not sure of does home-assistant record the events that not being listen to? so I there is no listener for any of LT events or wildcard * would HA still even fire an event!?, unfortunately HA discord made dev channel read-only which makes it now hard to find quickly answer for these questions, If home-assistant doesn't filter these by knowing if the event actually listened to or not, then another fix may needed but let's text now how does things go.

note: event: localtuya_device_triggered not longer exists and states_update renamed to status_update

[Cook23]

I made some changes I was hopefully that there was a way to exclude events from HA recorder hard-coded.

TBF, I'm not sure if it will fix this issue totally or not however I still recommend to exclude integration events from recorder in configuration.yml I'll update the events page in docs.

What I'm not sure of does home-assistant record the events that not being listen to? so I there is no listener for any of LT events or wildcard * would HA still even fire an event!?, unfortunately HA discord made dev channel read-only which makes it now hard to find quickly answer for these questions, If home-assistant doesn't filter these by knowing if the event actually listened to or not, then another fix may needed but let's text now how does things go.

note: event: localtuya_device_triggered not longer exists and states_update renamed to status_update

Even if excluded from recorder it's still recorded in "events" databases. According my tests exclude from recorder only act on "states" and "statistics" databases.

All my local tuya measurements variables was excluded (to avoid flooding "states" database) and "events" is still flooded. All measurements data was processed and filtered by node red and only output variable from node red was allowed in recorder. None from local tuya.

[xZetsubou]

According to HA recorder docs it should do that,

I would want to see how much it improved after the changes, if it's still an issue we can look more into it.

[github-actions]

This issue was closed because it was resolved on the release: 2025.3.0