Monday night database problem (threads problem)

[eRomano]

There was a problem with the database arround 1:30AM on monday Dec 11th.

A combination of small problems led to a table in the Forum being locked (ie the most important table in the database).

This problem, and a few other ones have been fully fixed. In addition, the configuration file for the server was also edited to prevent things like this from occurring again.

The Forum was back up and running normally at 1:30PM on Dec 11th.

Downtime was exactly 12 hours. Sorry for the inconvenience.

[Estranged Reality]

Glad it's back up!

[Montrealer]

Great to see the beast is alive!!

[Spoon87]

The down time pissed me off, since I am ill at home right now, and without the forum I didn't have anything to do while lying in bed,coughing my lungs out.

Anyway, good that it's back up, thanks Eric.

*edit*

It still isn't fixed completely, the "early days" section still isn't available for example!

Edited December 11, 2006 by Spoon87

[Estranged Reality]

I hate to be the bearer of bad news, but I receive the following when trying to access Anything Goes and My World:

IPS DRIVER ERROR

mySQL query error: SELECT * FROM ibf_topics t WHERE t.forum_id=27 AND t.pinned IN (0,1) and t.approved=1 ORDER BY t.pinned DESC, t.last_post DESC LIMIT 0,20

SQL error: Can't create/write to file '/home2/mysqltmp/MYCpHfsA' (Errcode: 13)

SQL error code:

Date: Monday 11th of December 2006 02:11:57 PM

[kevin]

I hate to be the bearer of bad news, but I receive the following when trying to access Anything Goes and My World:

IPS DRIVER ERROR

mySQL query error: SELECT * FROM ibf_topics t WHERE t.forum_id=27 AND t.pinned IN (0,1) and t.approved=1 ORDER BY t.pinned DESC, t.last_post DESC LIMIT 0,20

SQL error: Can't create/write to file '/home2/mysqltmp/MYCpHfsA' (Errcode: 13)

SQL error code:

Date: Monday 11th of December 2006 02:11:57 PM

mySQL query error: SELECT * FROM ibf_topics t WHERE t.forum_id=26 AND t.pinned IN (0,1) and t.approved=1 ORDER BY t.pinned DESC,  t.last_post DESC LIMIT 0,20

SQL error: Can't create/write to file '/home2/mysqltmp/MYm1GMjs' (Errcode: 13)
SQL error code: 
Date: Monday 11th of December 2006 02:13:16 PM

Yes same thing for me. This reminds me of the debugging assignment I got for engineering

[Spoon87]

I hate to be the bearer of bad news, but I receive the following when trying to access Anything Goes and My World:

IPS DRIVER ERROR

mySQL query error: SELECT * FROM ibf_topics t WHERE t.forum_id=27 AND t.pinned IN (0,1) and t.approved=1 ORDER BY t.pinned DESC, t.last_post DESC LIMIT 0,20

SQL error: Can't create/write to file '/home2/mysqltmp/MYCpHfsA' (Errcode: 13)

SQL error code:

Date: Monday 11th of December 2006 02:11:57 PM

Same here!

"Early days" isn't working either.

[kevin]

I dunno the syntax exactly, but it seems it can't write or read temporary files it needs to create.

[sweetness]

Its still fucked up for me

[eRomano]

Turns out that there are a few Forums for wich there is a similar error after the table repair and configuration fix:

YESTERDAYS - ORIGINAL GNR - THE EARLY DAYS:

http://www.mygnrforum.com/index.php?showforum=8

DON'T DAMN ME:

http://www.mygnrforum.com/index.php?showforum=4

ANYTHING GOES:

http://www.mygnrforum.com/index.php?showforum=26

MY WORLD:

http://www.mygnrforum.com/index.php?showforum=27

Those threads are now accessible. Sorry for the inconvenience.

[kevin]

Eric it did it again at 11:13 pm.. same error as before

EDIT

By it i mean ANYTHING GOES

Edited December 12, 2006 by kevin

[eRomano]

Thank you . This will be solved tomorrow.

[FunkyMonk]

I'm still getting the same problem here, only for Anything Goes and the like.

Edit: Woops. Guess i posted too late, thanks eric

Edited December 12, 2006 by FunkyMonk

[ssiscool]

good work for fixing it

[ssiscool]

just got this in AG

mySQL query error: SELECT * FROM ibf_topics t WHERE t.forum_id=26 AND t.pinned IN (0,1) and t.approved=1 ORDER BY t.pinned DESC,  t.last_post DESC LIMIT 0,20

SQL error: Can't create/write to file '/home2/mysqltmp/MYUMuxXG' (Errcode: 13)
SQL error code: 
Date: Tuesday 12th of December 2006 05:44:27 AM

[eRomano]

The ANYTHING GOES Forum is now fixed.