We’ve also occasionally had the same problem since upgrading to Zammad 6.4.
I can’t see any problems in the logs either, except that nginx logs a timeout from the zammad upstream.
If I can help you find a solution, please let me know (how i can help).
We recently ran into the same thing. Our “quite” time is around 3:00 am US Central. Cron job at that time that automatically reboots Zammad everyday has been added to prevent the mid-day meltdowns. For about a week it has been holding its grounds.
We just upgraded to 6.4 last night. I’ve had to restart the Zammad service 4 or 5 times today. It just did it again and I went digging but can’t figure it out.
That’s because the quotes are messed up. zammad run rails r "p Sessions.list.uniq.count"
Code blocks avoid that usually.
I checked, and we only have 2 active sessions when it occurred.
Just to keep you updated on this matter,
we still have that problem but the amount of needed restarts went down from several times a day to like two times within the the last two weeks. Last time it happened there were 12 sessions.
I am not sure if that relies to having less system load because of holidays or changes in version.
Last time it happened on january 2nd and I updated to the latest version then.
Since the problem continues to occur intermittently, I’ve set up a cron job and a bash script that checks the website’s status every 2 minutes. If it detects that the website is down, it will execute the Zammad restart command.
I hope this helps anyone who is waiting for the core team to resolve the issue.