Gallery Suddenly stops responding

[Arun_Sunkari1]

Hi All,

Gallery suddenly stops responding and users are not able to load the collection or anything on UI.
If we restart the  Alteryx services, then it getting back to normal, it is happening in every 2 or 3 days

I have checked the gallery, service logs and event logs also but didn't find any.

All the Alteryx services are working fine in the backend, but i m unable to find any error.
please help me out.

 CPU and memory utilization is also not high

Server version 2022.1

  

[Arun_Sunkari1 · Accepted solution]

According to the recommendation from the Vendor, the server had a large number of active sessions on MongoDB. they have suggested to clear the session on Mongo DB by executing the below query.

"db.sessions.remove({UpdateDate:{$lt: new Date(ISODate().getTime() - 1000 * 86400 * 30)}})"

[Mohan9]

Hi Arun,
db.sessions.remove({UpdateDate:{$lt: new Date(ISODate().getTime() - 1000 * 86400 * 30)}})
Have you run this command & Is it worked for you to clear last 30 days sessions,
Can you please let me know, we are planning to will implement in our environment and test it.

Thank you