# Livechat hanging in list of incomming chats - room not found - not deletable

**URL:** <https://forums.rocket.chat/t/livechat-hanging-in-list-of-incomming-chats-room-not-found-not-deletable/3950>\
**Category:** Community Support\
**Created:** [June 12, 2019, 7:08am UTC](https://forums.rocket.chat/t/livechat-hanging-in-list-of-incomming-chats-room-not-found-not-deletable/3950 "2019-06-12T07:08:57Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![pbel](https://avatars.discourse-cdn.com/v4/letter/p/f08c70/32.png) [@pbel](https://forums.rocket.chat/u/pbel)\
**Post date:** [June 12, 2019, 7:08am UTC](https://forums.rocket.chat/t/livechat-hanging-in-list-of-incomming-chats-room-not-found-not-deletable/3950/1 "2019-06-12T07:08:57Z")

</div>

Hi. We have one very old support chat hanging: in the desktop client it appears in “incomming chats”. When clicking on it it says “room not found”. Also in Livechat admin / Current chats it is not in the list

=\> how can I delete this weird hanging thing? Is this something I need to delete in MongoDB directly? how would I do that?

Thanks for any advise  
Regards  
Petr

---

<div class="post-metadata">

**Author:** ![son4everbiz](https://avatars.discourse-cdn.com/v4/letter/s/4491bb/32.png) [@son4everbiz](https://forums.rocket.chat/u/son4everbiz)\
**Post date:** [March 17, 2020, 3:53am UTC](https://forums.rocket.chat/t/livechat-hanging-in-list-of-incomming-chats-room-not-found-not-deletable/3950/2 "2020-03-17T03:53:07Z")

</div>

I have this same problem. Did you ever find a resolution?

---

<div class="post-metadata">

**Author:** ![son4everbiz](https://avatars.discourse-cdn.com/v4/letter/s/4491bb/32.png) [@son4everbiz](https://forums.rocket.chat/u/son4everbiz)\
**Post date:** [March 17, 2020, 4:56am UTC](https://forums.rocket.chat/t/livechat-hanging-in-list-of-incomming-chats-room-not-found-not-deletable/3950/3 "2020-03-17T04:56:09Z")

</div>

I was able to find the solution on github in the issues list here: [https://github.com/RocketChat/Rocket.Chat/issues/15748](https://github.com/RocketChat/Rocket.Chat/issues/15748). You will need to run a query on the rocketchat database.

Run the mongodb shell. If you are using docker, follow these steps, otherwise skip to the next section:

- Locate your rocket chat mongodb container id by executing: `docker ps | grep mongo`
- Execute the following using your container ID in place of `[container_id]`: `docker exec -it [container_id] /bin/bash`
- You should now be at a prompt inside your docker container.

Run the mongodb shell:  
`mongo`

Switch to the rocketchat database:  
`use rocketchat`

Execute the following query:  
`db.rocketchat_livechat_inquiry.update({status: 'queued',closedBy: {$exists: 1}},{$set: {status: 'closed'}},{multi: true})`

You should see a result with some number of matched and modified records.