Delete all orphaned entities not working

frenck / spook

A scary 👻 powerful toolbox 🧰 for Home Assistant 🏡

https://spook.boo

MIT License

514 stars 40 forks source link

Delete all orphaned entities not working #827

Open Jezza34000 opened 1 month ago

Jezza34000 commented 1 month ago

What version of Spook are you using?

v3.1.0

What version of Home Assistant are you using?

2024.8.3

The problem

Hi, Action > "Home Assistant Core Integration: List all orphaned database entities 👻" Give me 185 entites :

` count: 185 entities:

button.withee_reinitialiser_le_filtre
sensor.withee_surface_du_nettoyage_courant
sensor.tasmota_last_restart_time
time.withee_fin_npd
switch.withee_child_lock
sensor.omg_esp32_ble_sys_ip
sensor.withee_temps_de_sechage_de_la_serpilliere_restant
cover.esprts_test_cover
binary_sensor.withee_penurie_d_eau
switch.withee_ne_pas_deranger

`

When i use : "Home Assistant Core Integration: Delete all orphaned entities 👻" action is OK I restart many time, but entities are still here

Anything in the logs? Paste it here!

No response

joshrp5 commented 1 month ago

I am experiencing the same thing. I just installed spooky for the first time for this reason specifically. Sad to see it isn't working.

travisp commented 1 month ago

Agreed, it has no effect here.

freakyjoe8 commented 2 weeks ago

yes, same for me. Trying to delete 770 orphaned entities but nothing happens.

CaptInsano commented 2 weeks ago

I came here with the same issue: The action homeassistant.delete_all_orphaned_entities does not delete the entities listed from action homeassistant.list_orphaned_database_entities.

However the script example here: https://spook.boo/entities (find it under: "Script to remove entities from database") works perfectly for me.

travisp commented 1 week ago

I came here with the same issue:

The action homeassistant.delete_all_orphaned_entities does not delete the entities listed from action homeassistant.list_orphaned_database_entities.

However the script example here: https://spook.boo/entities (find it under: "Script to remove entities from database") works perfectly for me.

I tried the script. I first had to reduce the number of entities it was trying to use because the template size was too large. At 1000 entities at a time I received no error but nothing happened. At 100 entities it worked... until I'd gone through about 700 entities and then it too stopped working.

That makes me think that whatever is making it fail silently (maybe a problem removing a particular entity) is also causing the delete orphaned entities action to fail silently.

Edit: I take that back as I was eventually able to remove all the orphaned entities. But it took many multiple passes over the same entities.