DB corruption

regi

Stilling ploughing my way through it fixing stuff as I see it. I still think there might be one or two things I still need to optimise. If you get any SQL errors from the site, please post them below. Thanks

aidan_walsh

Provided we can get back in to post them

FranknFurter

JUST got this at 3:26am



There seems to have been a slight problem with the boards.ie/vbulletin database.
Please try again by pressing the [url="javascript:window.location=window.location;"]refresh[/url] button in your browser.

An E-Mail has been dispatched to our [email="jerry@boards.ie,regi@boards.ie"]Technical Staff[/email], who you can also contact if the problem persists.

We apologise for any inconvenience.

kinkstr

I got the same error as frank at 3.29

Lump

kinkstr wrote:

I got the same error as frank at 3.29

I imagine it hleps if you post the url of the page that provides the error

John

Cloud

Just to fill you in the current status at boards.ie: sometime on Monday we started having problems with our vBulletin database (currently over 2 GB in size) where the server process kept dying. After a few attempts to restart this, ecksor ran a repair and managed to get things running on Monday night. This was okay until Tuesday afternoon when the database returned to its bad behaviour. Again, regi tried a database repair, which didn't solve the problem. He then started an advanced database repair which took ages (due to the huge size of the database). regi and ecksor identified a potential SQL problem with a vBulletin modification we installed for RSS feeds.

This has been a bad week for boards.ie; it was just at the end of last week that we had to replace our web server hardware after it "fell over". However, if this article from Slashdot is to believed (Monday, January 24th to be Worst Day of the Year), then things were meant to go wrong on Monday!

WizZard

Well good luck with all of it. Much appreciated!

seamus

Sterling work lads. Kudos.

Any plans to migrate the DB to another server, or is it nothing to do with MySQL at all?

steveland?

azezil

Subbed list not working, IE6 sp2
Every other drop down menu works

WizZard

azezil wrote:

Subbed list not working, IE6 sp2
Every other drop down menu works

Check out Clouds thread.

Goodshape

Cloud wrote:

Regi and ecksor identified a potential SQL problem with a vBulletin modification we installed for RSS feeds.

Oops :rolleyes:

Good work all the same... Hope things get better.

azezil

WizZard wrote:

Check out Clouds thread.

lol i'm blind, carry on

Does this explain why we've no stars?

seamus

Papa Smut wrote:

Does this explain why we've no stars?

I see loads of stars.

Dump your cache, and you should have them back.

Lump

Ah, where is clouds thread? I can't see it. Also, how the fúck do you get in to the moderators board! I can't find it since my subbed list disappeared!


John

WizZard

Clouds thread is just about one or two below this one at the mo'

<edit>Titled: Combat Manoeuvres</edit>

Lump

Ahhhhhh


John

LegacyUser

Regi needs to change his sig .. I don't think it makes sense anymore
"The slack admin" NOT.

Fair play lads .. been a tough week .. when MySql plays up it can be an absolute b*t*h to find out the real cause of the problem. Heres hoping {bubby crosses fingers}

otron

Cloud wrote:

He then started an advanced database repair which took ages (due to the huge size of the database).

<NERD>
Go on tellus - how big is the DB?
</NERD>

WizZard

2GB I think, from another thread.

seamus

otron wrote:

<NERD>
Go on tellus - how big is the DB?
</NERD>

Yeah, 2GB.

The repair took around 7 hours, not including the amount of troubleshooting, tweaking and hacking they had to do.

Zombienosh

well done to the guys!
if this was a pub i'd buy ya all a bloody pint!

cheers :cool:

LegacyUser

seamus wrote:

Yeah, 2GB.

The repair took around 7 hours, not including the amount of troubleshooting, tweaking and hacking they had to do.

Do they have any idea longterm why it keeps corrupting?? Is the database mirrored or stripped? If so, might want to look into that.

seamus

bubby wrote:

Do they have any idea longterm why it keeps corrupting?? Is the database mirrored or stripped? If so, might want to look into that.

From what I gather it was the mysqld process that kept crashing, causing the DB to become corrupt. At the moment, we're running on a "Vanilla" install of VBulletin, becuase they're trying to track down the cause of the process crashes.
It would seem that the corruption is a software issue, not a hardware one.

Villain

It seems that the server is able for the lunch rush, anyway of restricting the load, if that is the problem?

mewso

On page: http://www.boards.ie/vbulletin/showthread.php?p=2312854#post2312854

Error on page:

Warning: Unexpected character in input: ' in /usr/local/www/www.boards.ie/vbulletin/includes/functions_showthread.php(640) : eval()'d code on line 145

Warning: Unexpected character in input: ' in /usr/local/www/www.boards.ie/vbulletin/includes/functions_showthread.php(640) : eval()'d code on line 145

Warning: Unexpected character in input: ' in /usr/local/www/www.boards.ie/vbulletin/includes/functions_showthread.php(640) : eval()'d code on line 145

Vb Bulletin Message:

Unable to add cookies, header already sent.
File: /usr/local/www/www.boards.ie/vbulletin/includes/functions_showthread.php(640) : eval()'d code
Line: 145

Link worked second time I tried it.

Gordon

Just delete all of Bubba's posts, that'll fair optimize the db.

Hobbes

your not running MySQL on windows are you? There is a new worm about. Mentioned on /. just now.

regi

No, we don't run mysql on windows. The mysql machine isn't even directly connected to the internet.