entities are not being deleted the list still shows them

[comet424]

What version of Spook are you using?

4.0.1

What version of Home Assistant are you using?

2025.9.4

The problem

so i trying to clean up my HA and when i had pfsense it showed up 5 times and each one added _2 _3 _4 _5 on all the entities... now i deleted them all.. as i want jsut 1
and i ran the orphan delete.. i deleted all the stastics.. and when i re added pfsense it adds everything with _5 on the end

i ran the orphan list it shows up 600 orphanes i try to re delete let it sit 10 min and do the list.. and it doesnt delete still over 600

i have the same issue on my main HA i have over 1500 orphans in the list even though i deleted them and of intergrations that been removed... now they dont show up in entites page etc.. but HA still keeping a record, and spook isnt able to remove them

so i cant add pfsense it will add pfsense_5

its doing this on intergrations i removed like unraid etc... so its some how keeping the entities names and not truly deleting them

it used to work in the past but now i noticing it not deleting i just dont remember when sometime last year i know worked

ive tried delete then waited 10-15 min then rebooted home assistant... then did the delete orphanes again let it sit 10 min do a reboot... and when i did the list it didnt delete any.. and when i add pfsense it then does pfsense_5 so its not truly deleting the orphoaned files

what i also noticed is if i do the orphan delete and wait 24 hours..
and i do the list they still there

but when i add a new pfsense instance and call it "router" HA re adds the pfsense as "mikes router" and ist saving all the _4 _5 its not trully erasing the orphanes not truly purging..

is there another option to purge is there a database i can just clean and when you restart HA it re adds all the entites?

i also tried the purge.recorder and entities that still doesnt help the entities stay in the list of orphanes and when i re add a pfsense or unraid it keeps adding _4 _5 and i cant truly purge out any entities really even if they dont show up under entity in the purge entties... they still there in list orphanes...
clearing cache using different browser doesnt help

i did some google searchs and the AI genertrated to say look in the
entity.core.registry file

and the entitys are in there
like

{"aliases":[],"area_id":null,"categories":{},"config_entry_id":null,"config_subentry_id":null,"created_at":"2025-06-04T14:39:09.978054+00:00","device_class":null,"disabled_by":"integration","disabled_by_undefined":false,"entity_id":"sensor.mitch_s_router_memory_buffers_used","hidden_by":null,"hidden_by_undefined":false,"icon":null,"id":"d6100af5e188130b881dff259b6ac7fe","labels":[],"modified_at":"2025-10-01T13:37:30.033044+00:00","name":null,"options":{},"options_undefined":false,"orphaned_timestamp":1759325851.0914936,"platform":"pfsense","unique_id":"71de8ceffae54fefee41_telemetry_mbuf_used"},

there is more then 999
when i search for "mitchs_router"

so i dunno how i can purge or use spook to delete them all not without editing and my other ha has more then 1500
so i not sure how i can get rid of them.
even when like unraid and pfsense intergrations been uninstalled

Anything in the logs? Paste it here!

i also started a topic in Home assistant,  and tried a script that didnt work either..  and now   spook doesnt show orphaned files.. 
 but the core entity registery file still shows 999+ orphaned files,, that it can not be deleted and is messing up creating entities

  [](url)https://community.home-assistant.io/t/how-do-you-purge-entiy-core-registry-file-when-spook-and-purge-dont-work/936419/12

from opening an issue on the core github and home assistant community page.. and getting told its intergration problem.. and not a home assistant issue it seems..

it be nice if Spook can auto delete all the "deleted entities" under core.entities.registry file... since it seems the intergrations use that to append entities names.. so if there is 4 other with the name it just creates a 5th with _5 with the extentsion and database keeps getting bigger like bloated windows... so be nice if spook can when you choose deleted orphaned files it would also wipe out the core.regirstry. entities file ...

maybe change it from a Bug to a Feature Request to be able to purge the core registry file of deleted entities that are orphaned and bugger up re adding devices

[MarcDBehr]

I am seeing a similar thing, Running HA 2025.10.1 I see 187 orphaned entries when I run homeassistant.list_orphaned_database_entities.

Next I run homeassistant.delete_all_orphaned_entities, and when I then run homeassistant.list_orphaned_database_entities 5 minutes later, I still get 187 entities.

Installation method Home Assistant OS
Core 2025.10.1
Supervisor 2025.10.0
Operating System 16.2
Frontend 20251001.0

Spook Version 4.0.1

[heytcass]

Same issue here as well.

[KodinLanewave]

Same issue here - I see in the HA logs that a service restart is attempting to be called as part of this and fails to fully shut down/restart.

Seeing the following in logs when I try to run this - Maybe there's some sort of race condition happening?

2025-10-26 05:23:35.609 WARNING (MainThread) [homeassistant.core] Task <Task pending name='service homeassistant.restart' coro=<_async_admin_handler() running at /usr/src/homeassistant/homeassistant/helpers/service.py:961> wait_for=<Task pending name='admin service homeassistant.restart' coro=<async_setup.<locals>.async_handle_core_service() running at /usr/src/homeassistant/homeassistant/components/homeassistant/__init__.py:238> wait_for=<Future pending cb=[Task.task_wakeup()]> cb=[set.remove(), Task.task_wakeup()]> cb=[set.remove()]> was still running after final writes shutdown stage; Integrations should cancel non-critical tasks when receiving the stop event to prevent delaying shutdown

[KodinLanewave]

Does this help at all? Is this going to get assigned to someone's backlog or otherwise triaged? The only other tool out there that was ever capable of live deletion has been marked as deprecated and therefore isn't easy to install.

[zenguru84]

LE: i think i got it.. the list returns orphan entities from db, but the delete removes the entities from the registry. two different things.

same here. list is working, deleting is not.
i have about 500 orphan entities and hey all have lots of statistics.
it will take me forever to delete it one by one..

[comet424]

the only way i was able to truly get rid of orphan files.. and thats not including the remote homeassistant addon that has been broken for a year

so for the statstics i just do a mass delete for them .. i click the selection mode icon and then check the box select everything with an issue .. then i click deleted the selection button on the right

but so far only way i can do anything.. is i run the spook to delete
then i got into the core registery entities file and delete every entry below "deleted entities" then save and do a reboot i delete stastics again and that seems to solve the issue when i re add devices since it doesnt check the delete enties now.. now spook will detect again off line devices that i jsut re plug in and fixes that issue.. but so far thats the only way i can truly stop this
_2 _3 _4 when its the orginal .. and then sometimes if you go into the entity you can hit the refresh icon and it will rename the entity name with the new upated one... but so far thats what i have done just to get things work

[spanzetta]

same here..
Spook 4.0.1

Installation method Home Assistant OS
Core 2025.12.5
Supervisor 2025.12.3
Operating System 16.3
Frontend 20251203.3

I see this in the log

_Logger: homeassistant.core
Source: core.py:1711
First occurred: 17:29:29 (54 occurrences)
Last logged: 17:29:29

Unable to remove unknown job listener (<Job onetime listen homeassistant_started <function HomeAssistantSpookSensorEntity.async_added_to_hass.._update_state at 0x7f632f9b20> HassJobType.Callback <_OneTimeListener custom_components.spook.ectoplasms.homeassistant.sensor:<function HomeAssistantSpookSensorEntity.async_added_to_hass.._update_state at 0x7f632f9b20>>>, None)
Unable to remove unknown job listener (<Job onetime listen homeassistant_started <function HomeAssistantSpookSensorEntity.async_added_to_hass.._update_state at 0x7f632f9d00> HassJobType.Callback <_OneTimeListener custom_components.spook.ectoplasms.homeassistant.sensor:<function HomeAssistantSpookSensorEntity.async_added_to_hass.._update_state at 0x7f632f9d00>>>, None)
Unable to remove unknown job listener (<Job onetime listen homeassistant_started <function HomeAssistantSpookSensorEntity.async_added_to_hass.._update_state at 0x7f632f9ee0> HassJobType.Callback <_OneTimeListener custom_components.spook.ectoplasms.homeassistant.sensor:<function HomeAssistantSpookSensorEntity.async_added_to_hass.._update_state at 0x7f632f9ee0>>>, None)
Unable to remove unknown job listener (<Job onetime listen homeassistant_start <function _clear_all_entity_ids_cache at 0x7f6815ade0> HassJobType.Callback <_OneTimeListener custom_components.spook.util:<function _clear_all_entity_ids_cache at 0x7f6815ade0>>>, None)
Unable to remove unknown job listener (<Job onetime listen homeassistant_started <function async_setup_entry.._ghost_busters at 0x7f681e00e0> HassJobType.Callback <_OneTimeListener custom_components.spook:<function async_setup_entry.._ghost_busters at 0x7f681e00e0>>>, None)
Traceback (most recent call last):
File "/usr/src/homeassistant/homeassistant/core.py", line 1711, in _async_remove_listener
self.listeners[event_type].remove(filterable_job)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^
ValueError: list.remove(x): x not in list

[andrelung]

Got the same issue. How would I manually delete an orphaned entity?