PDA

View Full Version : Database Error This Whole Day...


560cool.
December 1st, 2010, 11:33 AM
So, today, it was a free day (1st December ~ Romania's National Day) that I wanted to spend on PC.

Thing is, I kept getting database errors from, like, 9 AM till 7 PM. It's UTC +2 here, if anyone's wondering. :/

I was just curious why PC has been down this whole day.

Guy
December 1st, 2010, 11:38 AM
It wasn't just PC apparently. All vB run forums were down as well.

This may be because vBulletin was working on their own issues at the time, I couldn't say exactly, but it wasn't just PC that was down for so long.

Gun Gear Alpha
December 1st, 2010, 11:40 AM
Not All, Bleach exile froums were running fine.
Might have been a sever problem.

countryemo
December 1st, 2010, 11:42 AM
I noticed this too, it kinda sucked. but no not all. PHO was still up.
i wonder what happend, i thought pc just died

Guy
December 1st, 2010, 11:48 AM
Heh, if it was the server, then that was a pretty long time. When I got on this morning, a majority of the latest posts were roughly from 2:30 this morning (EST. Time) and I got on about after 9 AM.

I know Serebii's site was down as well, but I couldn't say for how long or if it was for the same reason. It may very well have been a server issue then.

Avey
December 1st, 2010, 11:59 AM
Heh, if it was the server, then that was a pretty long time. When I got on this morning, a majority of the latest posts were roughly from 2:30 this morning (EST. Time) and I got on about after 9 AM.

I know Serebii's site was down as well, but I couldn't say for how long or if it was for the same reason. It may very well have been a server issue then.

Serebii's server being down at the same time as PC's really isn't anything to go deducing something from.

Guy
December 1st, 2010, 12:07 PM
Serebii's server being down at the same time as PC's really isn't anything to go deducing something from.
Just using it as a reference, but that's true enough. I do know it wasn't just PC that was down during the time though or so I was told by another on MSN.

Going by everything that was said, my guess is PC probably just died from the server becoming too busy to handle the amount of activity that was going on at the time. ):

Unless, Rukario can enlighten us further and I'm missing something.

Massacre.
December 1st, 2010, 12:12 PM
Not all vBulletin boards, PHO and my own forum was running fine. But yeah, that was an unusually long downtime :(

560cool.
December 1st, 2010, 12:18 PM
Wow, all vB boards ? Dx

I don't really go on other forums, so I didn't quite notice.
And no, for me, PC was down for almost a full 12 hours. I suppose you guys were sleeping, but this was my free day...

I'm not whining or anything. (: Just that it was weird, since we usually get announced by Rukario whenever the forum dies... from an update or something.

Guy
December 1st, 2010, 12:23 PM
Wow, all vB boards ? Dx

I'm not whining or anything. (: Just that it was weird, since we usually get announced by Rukario whenever the forum dies... from an update or something.
Nope, apparently it wasn't all vB boards.

I believe the downtime wasn't really expected to occur, so no warning was put up for the long period of time.

Rukario
December 1st, 2010, 01:44 PM
apparently one of the db tables (users) crashed some time after the backup that runs bi-weekly.. of course this is while I'm sleeping and didn't see it until I logged on this morning.

It was easy to fix, but I had to be here to fix it.

AshPikastar
December 1st, 2010, 02:07 PM
I was wondering why PC was down all morning. It started working around 12pm for me. I thought it was just me but my friend was having the same problem too but PC isn't the only site that was down huh?

bobandbill
December 1st, 2010, 05:46 PM
I know Serebii's site was down as well, but I couldn't say for how long or if it was for the same reason. It may very well have been a server issue then. Actually for me sppf was up most of the time during PC's database failings - it only had lag problems for a short bit rather than a complete collapse. Forum problems between here and there were definitely separate.

Kura
December 1st, 2010, 07:25 PM
apparently one of the db tables (users) crashed some time after the backup that runs bi-weekly.. of course this is while I'm sleeping and didn't see it until I logged on this morning.

It was easy to fix, but I had to be here to fix it.

It'd be much less stressful on you and the rest of the members if there was more than one person fixing the things that always seem to glitch up @_@


Also I suggest a DB error thread be sticked. Too many threads have been made lately. Just accept it's a major problem and sticky it.

~RNC~
December 1st, 2010, 07:26 PM
Goodness, I am soo glad that I had issues to try and fix of my own, I hate it when I come here and PC is down and more angrier as the longer it is down!!

Platinum Lucario
December 1st, 2010, 10:34 PM
I wouldn't be surprised that... yet another vBulletin Database Error occured. When I posted my thread on it... it was mainly because it was happening too often for me, which I do assume it's happening alot more than when I first joined PC.

I was kinda wondering if PC ever had alot of Database Errors before I joined PC? Even though I was not online at the time the latest forum crash occured, but I just wonder to myself... how come haven't I seen a single Database Error occur on the Serebii forums? :\

That still makes me wonder... all I've encountered on that forum is basically lagging, no Database Errors/Crashes whatsoever.

So it makes me think... will PC ever get a better dedicated server? And I wonder what type of server Serebii forums runs on? Because I think there might be a difference... either that... or something might have been done to prevent it.

Inkpuddle
December 2nd, 2010, 01:37 AM
I was kinda wondering if PC ever had alot of Database Errors before I joined PC? Even though I was not online at the time the latest forum crash occured, but I just wonder to myself... how come haven't I seen a single Database Error occur on the Serebii forums? :\

That still makes me wonder... all I've encountered on that forum is basically lagging, no Database Errors/Crashes whatsoever.

So it makes me think... will PC ever get a better dedicated server? And I wonder what type of server Serebii forums runs on? Because I think there might be a difference... either that... or something might have been done to prevent it.
Serebii also has little more than half the members that PC has, fewer features (as far as I know), and it looks a lot less graphic-heavy on first impression. I can't say how exactly that affects server strain, but I would imagine it doesn't lighten the load at all. You can't really compare forums like that without taking the content into account. :/

Anyway, I agree with Kura. I think a sticky would save time as well as keep people more informed. And thanks for taking care of the issue Rukario, I have no idea what you just said but all I know is that PC is up and running again. xD

Melody
December 2nd, 2010, 01:45 AM
It'd be much less stressful on you and the rest of the members if there was more than one person fixing the things that always seem to glitch up @_@


Also I suggest a DB error thread be sticked. Too many threads have been made lately. Just accept it's a major problem and sticky it.

...I definitely agree with Kura here. A sticky for DBE related queries might cut the clutter of those threads whenever DBEs DO strike.

It also couldn't be extremely harmful to choose the most trustworthy administrator on here and give them limited access to the required tools to fix a DBE, if this can indeed be easily done without giving away the keys to the kingdom.. (Perhaps a login to the server itself with a little bash script they can call that gives options to 'fix the DB' with?) I dunno what the server runs particularly, other than it's a linux variant or something similar, but I don't think it would be too difficult to put together something that can invoke the proper tools with the proper permissions. ;)

Team Fail
December 2nd, 2010, 07:23 AM
Also I suggest a DB error thread be sticked. Too many threads have been made lately. Just accept it's a major problem and sticky it.
Agreed. DB Errors have become popular as of late, so someone should create a thread highlighting recent DB Errors, so millions of threads aren't made on them. X/

I wanted to go on yesterday (somehow, our IP hasn't changed outinternet to the new house yet...) but I couldn't. Now, I have to use school computers until I get my computer back on.

The 100 Mega Shock
December 2nd, 2010, 12:25 PM
Well you could just not make these threads - either way there's nothing to be gained for anyone except the same repeated discussions and half-baked solutions.

Kura
December 2nd, 2010, 01:47 PM
Thing is.. people don't realize that maybe their solution hasn't been mentioned. :/ No one here really knows or understands the problem unless they've read through pages of an older thread. That's why they make new threads. It's a very valid problem and they're just trying to address it to the staff. No harm!

AshPikastar
December 10th, 2010, 09:58 AM
Was PC down for any of you guys today? It's been down almost all day for me. It got back up on 12:53Pm in my time.

Rukario
December 10th, 2010, 10:05 AM
most of these 'errors' are not so much error, but TOO MANY CONNECTIONS at once.. it happens time to time and is a, IMO, design flaw in the software we use. There isn't much we can do about it unless we basically double our current servers and throw a ton of CPU / RAM at it.. which we can't as its WAY too expensive (low $1000's range)

So for now, you'll all need to just deal with it and be patient while we recover the server.

Gumball Watterson
December 10th, 2010, 10:55 AM
Steve, I swear to goodness, the server was going down while only 64 users were connected today.

Rukario
December 10th, 2010, 12:14 PM
its the auths.. session hashes, whatever you want to call it.. it locks up the database (and apache after a while) since it locks the tables, and each new query has to wait.. and wait.. and wait.. and wait.. and wait.. and wait..

..

..

..

..

..

..

..

..

..

and wait..

..

..

..

..

..

..

..

..

..

..

and wait...

you get the idea.

Platinum Lucario
December 11th, 2010, 03:34 AM
Hm... now I understand why the server pretty much crashes more than what we thought it would. Yeah, too many connections going at once, I get the idea. It's not just the users that are registered that cause the problem... look how many guests that are not registered come on PC every single day. there's about hundreads of them. So just look at how many guests are online as well, not just the registered users of the forum.

But yeah, every supporter is sure to try and help Steve as much as they can. The supporters donate out of their kindness to help Steve with the dedicated server costs. The answer to getting double of the dedicated servers... lies behind how many supporters can donate to PC. If the number of supporters double out of donating alot of money to keep PC running, then PC will improve and more RAM and CPU will be used, we've just gotta keep helping Steve by donating, trust me... it's the only way to granting PC more dedicated servers. ('-'d)

However... the future is always a mystery. We'll all appriciate the present, of what happens... now! And life is full of many wonderful things! ;D