View Full Version : Database Errors


mgentz
April 11th, 2014, 05:29 AM
Alex I keep getting database errors when searching through the forums. Is it me or is something up?

agentbad
April 11th, 2014, 05:52 AM
Yeah I'm getting the same thing.

subxero
April 11th, 2014, 06:02 AM
sorry I couldn't resist :p

Alex
April 11th, 2014, 08:02 AM
Consider yourself lucky, most people couldn't even get to the forum! :)

All is fixed now; a server reboot at my ISP seems to have corrupted a table. It's not supposed to happen that way, but sometimes, well, it does.

Let me know if you see anything weird going forward...

/moved to forum info

Alex
April 11th, 2014, 10:48 AM
OK - all tables have been rebuilt & optimized, all should be working about as quickly as it can work on this hardware at this point. I was thinking that SSL would slow down page views a bit, but it hasn't moved the needle more than a few percent in terms of server load. :thumbup:

mgentz
April 11th, 2014, 05:03 PM
Cool. Thanks!!

rasta
April 12th, 2014, 10:41 AM
:runaway2:

^ Me when I couldn't get on ninjette earlier

Alex
April 12th, 2014, 11:25 AM
Have been tweaking all morning. Full file system check, repair/optimize all db tables (yet again), and a couple other tweaks to the setup. Each table now loads in auto-recover mode, so if it has crashed for whatever reason, it will try and repair it on its own instead of waiting for me to get off my lazy butt and fix it. I also disabled some performance improving flags, that may have made it more likely to cause corruption on unexpected reboots. I don't expect the change to be noticeable in terms of system speed, but should make it more reliable.

akima
April 12th, 2014, 12:48 PM
Our benevolent overlord has been working tirelessly to maintain the ninjette cult community infrastructure https://fc06.deviantart.net/fs48/f/2009/168/0/1/_worships__by_Synfull.gif

Alex
April 12th, 2014, 12:52 PM
https://bvlsingler.files.wordpress.com/2013/11/charles-barsotti-we-re-a-pack-not-a-cult-new-yorker-cartoon.jpg

akima
April 12th, 2014, 01:00 PM
one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us, one of us

NevadaWolf
April 13th, 2014, 07:54 AM
Shush you silly squirrel, I like the idea of being a pack! :D