Explanation into Thursday's outage

Explanation into Thursday's outage - Printable Version

+- Roosh V Forum (https://rooshvforum.network)
+-- Forum: Main (https://rooshvforum.network/forum-1.html)
+--- Forum: Everything Else (https://rooshvforum.network/forum-7.html)
+--- Thread: Explanation into Thursday's outage (/thread-27558.html)

Pages: 1 2 3 4 5 6

Explanation into Thursday's outage - Roosh - 09-03-2013

Quote: (09-03-2013 07:18 PM)aphelion Wrote:

Exact repro steps for the crash error:

From browsing the Everything Else forum
http://www.rooshvforum.network/forum-4.html

clicking on the Main tab results in a MyBB error.
http://www.rooshvforum.network/forum-1.html

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1194 - Table 'mybb_sessions' is marked as crashed and should be repaired
Query:
SELECT s.ip, s.uid, u.username, s.time, u.invisible, u.usergroup, u.usergroup, u.displaygroup FROM mybb_sessions s LEFT JOIN mybb_users u ON (s.uid=u.uid) WHERE s.time > '1378252864' AND location1='1' AND nopermission != 1 ORDER BY u.username ASC, s.time DESC

However, navigating to the Main Forum by simply going to http://www.rooshvforum.network works as expected.

Try now.

Quote: (09-03-2013 07:23 PM)TheSlayer Wrote:

The forum is still very slow for me and I am also getting crash errors. Also had a couple of 500 Internal Server errors or whatever those are called.

Can you paste the crash errors so I can troubleshoot.

Explanation into Thursday's outage - ryanf - 09-03-2013

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.

Explanation into Thursday's outage - Roosh - 09-04-2013

Quote: (09-03-2013 10:47 PM)ryanf Wrote:

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.

Excellent I'll keep that in mind. It was the first time it ever happened.

Explanation into Thursday's outage - Kickb - 09-04-2013

Is anyone having trouble uploading avatars?

I have a good one but when I try to upload, a message pops up telling me the file is invalid. Please upload a valid file.

I just got a new phone, but it uses the same OS as my old galaxy. I save the files as jpegs. Maybe it is my phone?

[Image: gary-sm.jpg]

Explanation into Thursday's outage - Roosh - 09-04-2013

Quote: (09-04-2013 09:13 AM)kickboxer Wrote:

Is anyone having trouble uploading avatars?

I have a good one but when I try to upload, a message pops up telling me the file is invalid. Please upload a valid file.

I just got a new phone, but it uses the same OS as my old galaxy. I save the files as jpegs. Maybe it is my phone?

Try to duplicate the program using a normal browser.

Explanation into Thursday's outage - Kickb - 09-04-2013

It worked. Thanks.

Explanation into Thursday's outage - Acute Angle - 09-04-2013

Just now: "The maximum server load limit has been reached. Please check back later once the server is less busy."

Explanation into Thursday's outage - placer - 09-05-2013

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

Explanation into Thursday's outage - DirectDanger - 09-08-2013

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:

Explanation into Thursday's outage - Roosh - 09-08-2013

Yeah the sessions table crashed.

Within the next two days I'll have another IT guy look at the server.

Explanation into Thursday's outage - Zeus - 09-10-2013

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

Explanation into Thursday's outage - Pacesetter20 - 09-10-2013

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

Explanation into Thursday's outage - Thomas the Rhymer - 09-10-2013

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

Explanation into Thursday's outage - scorpion - 09-10-2013

Tons of errors going on right now.

Explanation into Thursday's outage - BoneDaddy - 09-10-2013

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

Explanation into Thursday's outage - Cattle Rustler - 09-10-2013

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

Explanation into Thursday's outage - eradicator - 09-10-2013

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.

Explanation into Thursday's outage - DirectDanger - 09-10-2013

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

Explanation into Thursday's outage - BoneDaddy - 09-10-2013

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.

Explanation into Thursday's outage - GameTheory - 09-10-2013

i just got a My BB Error message. i switched my browser to Compatibility View, and was able to log on again

Explanation into Thursday's outage - Roosh - 09-10-2013

New server guy has been working on the server today. Please leave any error messages you get from this point on.

Explanation into Thursday's outage - Cattle Rustler - 09-11-2013

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

Explanation into Thursday's outage - Acute Angle - 09-11-2013

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

Explanation into Thursday's outage - placer - 09-11-2013

At the bottom of a page I was reading:

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
2013 - Lost connection to MySQL server during query
Query:
UPDATE mybb_users SET lastactive='1378927526', timeonline=timeonline+86 WHERE uid='13137'

Explanation into Thursday's outage - GameTheory - 09-11-2013

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