Interesting problems and interesting solutions.
The live reply feature means that your browser always has an open connection to the server hanging around. This connection is new since the live reply feature is new - it used to be that loading a page was one and done. Now, these new persistent...
I shut down the server briefly about 40 minutes ago to increase the disk size, so that may explain the outage, but not the logged out issue. Can you try logging in on a different browser or in private browsing mode to see if it is an issue with your cookies and cache?
So the suspicion at this point ( @The Dark Wizard had the idea ) is that the HTTPS certificate automatically renewed itself, and this confused the Cloudflare communication process running on the server. I'm not sure why it was causing only intermittent issues, but all I have done is restart the...
This doesn't surprise me. We've having some serious issues with the server right now and I suspect that alerts might be part of the problem. I'll post an update when I have more information.
How long does it go on when you notice this start to happen? Do you know if anyone else has the same problem when you do?
Can you let me know the time of day when it happens again?
Thanks for the update on this. We still have extremely large threads, but we don't seem to have the heavy queries that were causing these lockups before.
There's nothing you can do on the client side. This is entirely a server issue.
And I found a more direct cause. The query above references one thread in particular. It's working with the posts that are contained in a single thread. The problem is that the one thread has over 20,000 posts. There...