Database Error This Whole Day...

Started by 560cool. December 1st, 2010 11:33 AM
  • 1502 views
  • 25 replies

560cool.

An old timer?

Age 24
Male
Eastern Europe
Seen March 29th, 2021
Posted March 9th, 2021
2,002 posts
13.8 Years
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.
Well, okay. I'm here just to chat with people. Don't really care about signatures and stuff.



Guy

just a guy

Age 31
Male
Florida
Seen March 26th, 2016
Posted January 22nd, 2014
7,127 posts
14.7 Years
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.

Guy

just a guy

Age 31
Male
Florida
Seen March 26th, 2016
Posted January 22nd, 2014
7,127 posts
14.7 Years
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.
Seen January 1st, 2023
Posted April 20th, 2020
4,423 posts
15.4 Years
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

just a guy

Age 31
Male
Florida
Seen March 26th, 2016
Posted January 22nd, 2014
7,127 posts
14.7 Years


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.

560cool.

An old timer?

Age 24
Male
Eastern Europe
Seen March 29th, 2021
Posted March 9th, 2021
2,002 posts
13.8 Years
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.
Well, okay. I'm here just to chat with people. Don't really care about signatures and stuff.



Guy

just a guy

Age 31
Male
Florida
Seen March 26th, 2016
Posted January 22nd, 2014
7,127 posts
14.7 Years
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

Banned

Somewhere in Ilex Forest
Seen April 6th, 2019
Posted March 17th, 2019
7,587 posts
20.7 Years
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

It's Question Time!

Age 30
Female
Florida
Seen March 2nd, 2018
Posted August 26th, 2012
1,746 posts
12.6 Years
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

one more time

Male
A cape
Seen 5 Hours Ago
Posted 7 Hours Ago
16,794 posts
15.2 Years
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.

Staff Anime Villain Collab - Earl de Darkwood - Interstella 5555

Daily | Drabble Dex | A Change of the Season
The Retelling of Pokémon Colosseum
Paired to Sheep :>

Kura

twitter.com/puccarts

Age 33
Female
London, UK (orig. Toronto, Canada)
Seen August 30th, 2021
Posted August 24th, 2021
10,993 posts
18.7 Years
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 @[email protected]


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.
~Yuugiou Fan~
~Kamen Rider Fan~
♡(´・ω・`)LOVE! ☆

Platinum Lucario

The Legendary Master of Light!

Age 30
Male
Warrnambool, Victoria, Australia.
Seen April 2nd, 2023
Posted April 1st, 2021
1,605 posts
15.4 Years
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.
[Platinum Lucario's Signature]
If you need to disable my signature, please give me advice on how to improve the CSS-DIV code. Thank you!
All credits for the avatar since 2008 goes to shorty-antics-27 (fanart account)! Thank you! ^^
Signature Status: Strikes: 1/3 | Infractions: 0/3
It's time to change the future...
to a positive direction!
Let's prevent things from getting bad!

I'm a ROM and ISO Researcher

Current Project: Researching Pokémon Mystery Dungeon Adventure Squad games (WiiWare)

Stellar

Minior used Cosmic Power!

Age 31
Female
outer space.
Seen December 7th, 2022
Posted November 27th, 2022
870 posts
14.1 Years
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

Banned

Female
Cuddling those close to me
Seen March 4th, 2018
Posted March 2nd, 2018
6,459 posts
18.6 Years
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 @[email protected]


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. ;)

Kura

twitter.com/puccarts

Age 33
Female
London, UK (orig. Toronto, Canada)
Seen August 30th, 2021
Posted August 24th, 2021
10,993 posts
18.7 Years
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!
~Yuugiou Fan~
~Kamen Rider Fan~
♡(´・ω・`)LOVE! ☆

Rukario

Banned

Somewhere in Ilex Forest
Seen April 6th, 2019
Posted March 17th, 2019
7,587 posts
20.7 Years
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.

Rukario

Banned

Somewhere in Ilex Forest
Seen April 6th, 2019
Posted March 17th, 2019
7,587 posts
20.7 Years
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

The Legendary Master of Light!

Age 30
Male
Warrnambool, Victoria, Australia.
Seen April 2nd, 2023
Posted April 1st, 2021
1,605 posts
15.4 Years
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
[Platinum Lucario's Signature]
If you need to disable my signature, please give me advice on how to improve the CSS-DIV code. Thank you!
All credits for the avatar since 2008 goes to shorty-antics-27 (fanart account)! Thank you! ^^
Signature Status: Strikes: 1/3 | Infractions: 0/3
It's time to change the future...
to a positive direction!
Let's prevent things from getting bad!

I'm a ROM and ISO Researcher

Current Project: Researching Pokémon Mystery Dungeon Adventure Squad games (WiiWare)