eRomano Posted December 11, 2006 Share Posted December 11, 2006 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. Quote Link to comment Share on other sites More sharing options...
Estranged Reality Posted December 11, 2006 Share Posted December 11, 2006 Glad it's back up! Quote Link to comment Share on other sites More sharing options...
Montrealer Posted December 11, 2006 Share Posted December 11, 2006 Great to see the beast is alive!! Quote Link to comment Share on other sites More sharing options...
Spoon87 Posted December 11, 2006 Share Posted December 11, 2006 (edited) 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 Quote Link to comment Share on other sites More sharing options...
Estranged Reality Posted December 11, 2006 Share Posted December 11, 2006 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 ERRORmySQL 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,20SQL 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 Quote Link to comment Share on other sites More sharing options...
kevin Posted December 11, 2006 Share Posted December 11, 2006 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 ERRORmySQL 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,20SQL error: Can't create/write to file '/home2/mysqltmp/MYCpHfsA' (Errcode: 13)SQL error code: Date: Monday 11th of December 2006 02:11:57 PMmySQL 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,20SQL error: Can't create/write to file '/home2/mysqltmp/MYm1GMjs' (Errcode: 13)SQL error code: Date: Monday 11th of December 2006 02:13:16 PMYes same thing for me. This reminds me of the debugging assignment I got for engineering Quote Link to comment Share on other sites More sharing options...
Spoon87 Posted December 11, 2006 Share Posted December 11, 2006 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 ERRORmySQL 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,20SQL error: Can't create/write to file '/home2/mysqltmp/MYCpHfsA' (Errcode: 13)SQL error code: Date: Monday 11th of December 2006 02:11:57 PMSame here!"Early days" isn't working either. Quote Link to comment Share on other sites More sharing options...
kevin Posted December 11, 2006 Share Posted December 11, 2006 I dunno the syntax exactly, but it seems it can't write or read temporary files it needs to create. Quote Link to comment Share on other sites More sharing options...
sweetness Posted December 12, 2006 Share Posted December 12, 2006 Its still fucked up for me Quote Link to comment Share on other sites More sharing options...
eRomano Posted December 12, 2006 Author Share Posted December 12, 2006 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=8DON'T DAMN ME:http://www.mygnrforum.com/index.php?showforum=4ANYTHING GOES:http://www.mygnrforum.com/index.php?showforum=26MY WORLD:http://www.mygnrforum.com/index.php?showforum=27Those threads are now accessible. Sorry for the inconvenience. Quote Link to comment Share on other sites More sharing options...
kevin Posted December 12, 2006 Share Posted December 12, 2006 (edited) Eric it did it again at 11:13 pm.. same error as beforeEDITBy it i mean ANYTHING GOES Edited December 12, 2006 by kevin Quote Link to comment Share on other sites More sharing options...
eRomano Posted December 12, 2006 Author Share Posted December 12, 2006 Thank you . This will be solved tomorrow. Quote Link to comment Share on other sites More sharing options...
FunkyMonk Posted December 12, 2006 Share Posted December 12, 2006 (edited) 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 Quote Link to comment Share on other sites More sharing options...
ssiscool Posted December 12, 2006 Share Posted December 12, 2006 good work for fixing it Quote Link to comment Share on other sites More sharing options...
ssiscool Posted December 12, 2006 Share Posted December 12, 2006 just got this in AGmySQL 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,20SQL 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 Quote Link to comment Share on other sites More sharing options...
eRomano Posted December 12, 2006 Author Share Posted December 12, 2006 The ANYTHING GOES Forum is now fixed. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.