Posts: 861
Threads: 0
Joined: Oct 2012
Reputation:
8
Explanation into Thursday's outage
09-03-2013, 10:47 PM
If heavy traffic is causing the sessions table to lock up, it's probably a MyISAM table. You could flip that table to the memory engine, would probably alleviate heavy traffic issues.
Sessions tables don't need to be saved to the disk, since sessions data is volatile (non-permanent). I poked around a bit on this particular error.
Posts: 484
Threads: 0
Joined: Sep 2012
Reputation:
3
Explanation into Thursday's outage
09-04-2013, 03:35 PM
Just now: "The maximum server load limit has been reached. Please check back later once the server is less busy."
Posts: 466
Threads: 0
Joined: Mar 2013
Reputation:
9
Explanation into Thursday's outage
09-05-2013, 05:21 PM
Just a minute ago:
MyBB SQL Error
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
2002 - Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
Query:
[READ] Unable to connect to MySQL server
Posts: 826
Threads: 0
Joined: Nov 2011
Reputation:
69
Explanation into Thursday's outage
09-08-2013, 08:07 PM
Just got this error...
MyBB SQL Error
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
126 - Incorrect key file for table './rooshvf_forum/mybb_sessions.MYI'; try to repair it
Query:
Posts: 19,387
Threads: 0
Joined: Aug 2008
Reputation:
414
Explanation into Thursday's outage
09-08-2013, 08:09 PM
Yeah the sessions table crashed.
Within the next two days I'll have another IT guy look at the server.
Posts: 128
Threads: 0
Joined: Feb 2012
Reputation:
6
Explanation into Thursday's outage
09-10-2013, 12:28 PM
I keep getting errors Everytime i click. Lifestyle, everything etc. I refresh and it's ok. Here's one of the errors
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
2013 - Lost connection to MySQL server during query
Query:
SELECT t.*, (t.totalratings/t.numratings) AS averagerating, t.username AS threadusername, u.username FROM mybb_threads t LEFT JOIN mybb_users u ON (u.uid = t.uid) WHERE t.fid='4' AND t.visible='1' ORDER BY t.sticky DESC, t.lastpost desc LIMIT 0, 40
Posts: 750
Threads: 0
Joined: Mar 2012
Reputation:
15
Explanation into Thursday's outage
09-10-2013, 12:29 PM
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:2002 - Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)Query:[READ] Unable to connect to MySQL server
Please contact the MyBB Group for support.
Been happening to me over the past five minutes
Posts: 2,056
Threads: 0
Joined: Feb 2012
Reputation:
114
Explanation into Thursday's outage
09-10-2013, 12:30 PM
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
2002 - Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Query:
[READ] Unable to connect to MySQL server
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
2013 - Lost connection to MySQL server during query
Query:
SELECT p.*, u.username AS userusername FROM mybb_posts p LEFT JOIN mybb_users u ON (p.uid=u.uid) WHERE pid IN (529951,529948,527620,526606,526346,526330,526327,526260,526101,525995,525984,525976,525973,525948,525866,525844,525773,525746,525737,525697,525695,525678,524725,524152,524076) ORDER BY dateline DESC
Posts: 2,467
Threads: 0
Joined: Sep 2012
Reputation:
254
Explanation into Thursday's outage
09-10-2013, 12:34 PM
Tons of errors going on right now.
[size=8pt]"For I reckon that the sufferings of this present time are not worthy to be compared with the glory which shall be revealed in us.”[/size] [size=7pt] - Romans 8:18[/size]
Posts: 183
Threads: 0
Joined: Sep 2011
Reputation:
5
Explanation into Thursday's outage
09-10-2013, 12:47 PM
I've been getting this one frequently over the last few minutes:
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
2002 - Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Query:
[READ] Unable to connect to MySQL server
Posts: 6,446
Threads: 0
Joined: Jun 2013
Reputation:
109
Explanation into Thursday's outage
09-10-2013, 12:57 PM
Ironically while trying to see BoneDaddy's post I got this message:
MyBB SQL Error
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
2006 - MySQL server has gone away
Query:
SELECT u.*, f.* FROM mybb_users u LEFT JOIN mybb_userfields f ON (f.ufid=u.uid) WHERE u.uid='13863' LIMIT 1
Cattle 5000 Rustlings #RustleHouseRecords #5000Posts
Houston (Montrose), Texas
"May get ugly at times. But we get by. Real Niggas never die." - cdr
Follow the Rustler on Twitter | Telegram: CattleRustler
Game is the difference between a broke average looking dude in a 2nd tier city turning bad bitch feminists into maids and fucktoys and a well to do lawyer with 50x the dough taking 3 dates to bang broads in philly.
Posts: 5,942
Threads: 0
Joined: May 2013
Reputation:
35
Explanation into Thursday's outage
09-10-2013, 01:22 PM
Just reading the new threads(so far just everything else and game forums) and get these
everything else
MyBB SQL Error
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
2006 - MySQL server has gone away
Query:
SELECT u.*, f.* FROM mybb_users u LEFT JOIN mybb_userfields f ON (f.ufid=u.uid) WHERE u.uid='13566' LIMIT 1
and this
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
145 - Table './rooshvf_forum/mybb_sessions' is marked as crashed and should be repaired
Query:
DELETE FROM mybb_sessions WHERE uid='13566'
and this was for the game forum
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
2013 - Lost connection to MySQL server during query
Query:
SELECT t.*, (t.totalratings/t.numratings) AS averagerating, t.username AS threadusername, u.username FROM mybb_threads t LEFT JOIN mybb_users u ON (u.uid = t.uid) WHERE t.fid='2' AND t.visible='1' ORDER BY t.sticky DESC, t.lastpost desc LIMIT 0, 40
sometimes just refreshing like you suggested fixes it, sometimes not.
Posts: 826
Threads: 0
Joined: Nov 2011
Reputation:
69
Explanation into Thursday's outage
09-10-2013, 02:03 PM
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
2006 - MySQL server has gone away
Query:
SELECT s.sid, s.ip, s.uid, s.time, s.location, s.location1, u.username, u.invisible, u.usergroup, u.displaygroup FROM mybb_sessions s LEFT JOIN mybb_users u ON (s.uid=u.uid) WHERE s.time>'1378838838' ORDER BY u.username ASC, s.time DESC
Posts: 183
Threads: 0
Joined: Sep 2011
Reputation:
5
Explanation into Thursday's outage
09-10-2013, 02:05 PM
Got the same error again:
yBB has experienced an internal SQL error and cannot continue.
SQL Error:
2002 - Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Query:
[READ] Unable to connect to MySQL server
I should note that I can always recover by refreshing the page.
Posts: 1,232
Threads: 0
Joined: Nov 2012
Explanation into Thursday's outage
09-10-2013, 03:26 PM
i just got a My BB Error message. i switched my browser to Compatibility View, and was able to log on again
Posts: 19,387
Threads: 0
Joined: Aug 2008
Reputation:
414
Explanation into Thursday's outage
09-10-2013, 04:17 PM
New server guy has been working on the server today. Please leave any error messages you get from this point on.
Posts: 6,446
Threads: 0
Joined: Jun 2013
Reputation:
109
Explanation into Thursday's outage
09-11-2013, 01:13 PM
I got this a minute ago.
MyBB SQL Error
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
2002 - Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Query:
[READ] Unable to connect to MySQL serve
Cattle 5000 Rustlings #RustleHouseRecords #5000Posts
Houston (Montrose), Texas
"May get ugly at times. But we get by. Real Niggas never die." - cdr
Follow the Rustler on Twitter | Telegram: CattleRustler
Game is the difference between a broke average looking dude in a 2nd tier city turning bad bitch feminists into maids and fucktoys and a well to do lawyer with 50x the dough taking 3 dates to bang broads in philly.
Posts: 484
Threads: 0
Joined: Sep 2012
Reputation:
3
Explanation into Thursday's outage
09-11-2013, 02:21 PM
Just now:
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
2013 - Lost connection to MySQL server during query
Query:
SELECT t.*, (t.totalratings/t.numratings) AS averagerating, t.username AS threadusername, u.username FROM mybb_threads t LEFT JOIN mybb_users u ON (u.uid = t.uid) WHERE t.fid='4' AND t.visible='1' ORDER BY t.sticky DESC, t.lastpost desc LIMIT 0, 40
Posts: 1,232
Threads: 0
Joined: Nov 2012
Explanation into Thursday's outage
09-11-2013, 03:39 PM
i just got the error,
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
2006 - MySQL server has gone away
Query:
SELECT * FROM mybb_sessions WHERE sid='8a62c34952f4a452994f75a39d941df6' AND ip='130.182.26.199' LIMIT 1
switched on to Compatibility View, smooth as silk now