Happy Saint Patrick's Day! My presumption stands that the major partying associated with the occasion was last night, but I'm sure there are some that will be going at it tonight, and probably a surprising number who started last night and are still going. Hope you had a fine old time, and everyone stays safe.

Redmask wrote on Mar 17, 2013, 17:01:I didn't know what this site was running, after doing some research into Chatbear it looks pretty ancient. A proper fix will take longer, as a workaround you could just make a cron job to use apachectl to restart Apache gracefully every X hours, that way someone doesn't have to be around.

That's a good idea: Restart every 24 hours at say, 3AM Eastern Time. Better it be down 5m daily in the middle of the night than randomly for hours at a time.

"The worst of it all is i used to ENJOY getting excited for big titles like this, but these publishers just keep ruining my love for this wonderful hobby with their endless fuckery." - Sempai

I didn't know what this site was running, after doing some research into Chatbear it looks pretty ancient. A proper fix will take longer, as a workaround you could just make a cron job to use apachectl to restart Apache gracefully every X hours, that way someone doesn't have to be around.

Redmask wrote on Mar 17, 2013, 16:22:Any word on why the site has been experiencing large amounts of downtime?

From yesterday's Out of the Blue:

Frans wrote on Mar 17, 2013, 14:45:We know the site hiccups are caused by MySQL locking up, which in turn causes all Apache processes to eventually get tied up, waiting for queries to complete, and making the site unresponsive.

I've spent many an hour trying to figure out why MySQL locks up, obviously without success, so in recent months Blue and I simply resorted to restarting Apache & MySQL. Because we aren't always around, some outages last up to several hours. Sorry about that.

I suspect the problem is in the forums code, as that's the only code that has actual LOCK statements (when storing a new post and updating thread counters), but I don't have enough real MySQL wizardry under my belt to understand why this can run flawlessly for days or even several weeks, and then cause multiple lockups on some days again, like this weekend.

That bus driver is fucking awesome. He's deliberately rear ending cars that cut him off and stop short hoping to score an insurance settlement (apparently thinking that the person that hits you from behind is always at fault). He records it all on a dashcam and posts it to YouTube and apparently has never lost a single case in court so far.