Postmortem May 19th Database Issue

  • 🐕 I am attempting to get the site runnning as fast as possible. If you are experiencing slow page load times, please report it.
Status
Not open for further replies.

Null

Ooperator
kiwifarms.net
Joined
Nov 14, 2012
A recent environmental change has resulted in unpredictable loss of connection. That's basically it. The error I'm seeing is "No route to host", which is very hard to find related documentation on. In short, for whatever reason, one or both of the servers have suddenly decided to stop recognizing their name. I suppose that's my fault for relying on hostnames to begin with.

I've made a change just now. If you still experience issues let me know.
 
@Null, Can you post the farms "emergency contacts" again? I know you posted it before, and I thought I saved them, but apparently I'm an idiot.

There was a list of the discord, back up links, etc...
 
livefootageofnull.png


Seriously though, computers can be fucking assholes sometimes. Hopefully you can sort it out soon. At least when it has been acting up, it's only been a couple minutes at the most. At least from what I've noticed anyway.
 
For me the host error only happened for a few minutes yesterday and today
 
  • Agree
Reactions: A Hot Potato
I just had an issue momentarily.

I took a snapshot of what I got, if that helps.
Screenshot_20180519-151020.png
 
  • Agree
Reactions: Army Burger
New I just had an issue momentarily.
I've taken another stab at fixing the problem.

I reviewed the database error logs and it said that the session table was crashing. Sessions are what represent a single user's activity on the site.

Some time ago, I changed sessions off of memory caching on the webserver for caching on the database to try and manage memory better. Now, the table responsible for session caching is crashing and it reboots by wiping the session table clean. I've moved it back to the webserver to see if that helps.
 
Status
Not open for further replies.
Back