Posts: 19,387
Threads: 0
Joined: Aug 2008
Reputation:
414
Explanation into Thursday's outage
08-30-2013, 02:28 AM
There was a planned 15 minute outage to upgrade all the forum software and repair the database. The forum was like a car that hasn't gotten its oil changed in years. I wanted to do a preventive maintenance that would prevent a large downtime.
During the maintenance, a series of problems occurred which broke the site. The server guy I hired spent many hours on the problem and eventually got the site back up. We will monitor the site in the next day to make sure performance is indeed better.
This downtime was most unfortunate.
In the next day, please note down any errors you are getting by taking a screenshoot of the error and noting the URL. You can paste them here.
Posts: 19,387
Threads: 0
Joined: Aug 2008
Reputation:
414
Explanation into Thursday's outage
08-30-2013, 02:30 AM
I'm seeing a couple MYBB SQL Errors.
Posts: 2,223
Threads: 0
Joined: Sep 2011
Reputation:
23
Explanation into Thursday's outage
08-30-2013, 02:33 AM
I got one on the Woman aims to have sex with 100,000 men thread but it was gone when I tried to reproduce.
Posts: 1,729
Threads: 0
Joined: Nov 2012
Reputation:
18
Explanation into Thursday's outage
08-30-2013, 02:35 AM
Are you still going to be bringing back the "Jump to different forum" option at the bottom of the screen and the ability to see the users browsing the thread?
Posts: 2,223
Threads: 0
Joined: Sep 2011
Reputation:
23
Explanation into Thursday's outage
08-30-2013, 02:40 AM
SQL like a pig boy!
MyBB SQL Error
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
2013 - Lost connection to MySQL server during query
Query:
SELECT COUNT(t.tid) AS unread_count FROM mybb_threads t LEFT JOIN mybb_threadsread tr ON (tr.tid=t.tid AND tr.uid='7870') LEFT JOIN mybb_forumsread fr ON (fr.fid=t.fid AND fr.uid='7870') WHERE t.visible=1 AND t.closed NOT LIKE 'moved|%' AND t.fid IN (4) AND t.lastpost > IFNULL(tr.dateline,1377243524) AND t.lastpost > IFNULL(fr.dateline,1377243524) AND t.lastpost>1377243524
Please contact the MyBB Group for support.
Posts: 2,607
Threads: 0
Joined: Apr 2013
Reputation:
130
Explanation into Thursday's outage
08-30-2013, 03:20 AM
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
Quote:Old Chinese Man Wrote:
why you wonder how many man another man bang? why you care who bang who mr high school drama man
Posts: 19,387
Threads: 0
Joined: Aug 2008
Reputation:
414
Explanation into Thursday's outage
08-30-2013, 06:49 AM
The SQL errors seem to have stopped for me. Is it still happening with anyone else?
Posts: 19,387
Threads: 0
Joined: Aug 2008
Reputation:
414
Explanation into Thursday's outage
08-30-2013, 08:45 AM
There has been a reported problem of a registered member disappearing from the database (though his posts are preserved).
If you can no longer log in, email me: roosh at rooshv dot com
Posts: 828
Threads: 0
Joined: Aug 2013
Reputation:
115
Explanation into Thursday's outage
08-30-2013, 09:06 AM
unfortunate timing indeed.
I didn't realize how much I was leaning on this site as a travel resource until last night when I was scrambling to find a PM from a fellow forumer. he kindly detailed all the thursday nightlife spots in a new city.
thanks for getting it back up. I was able to find the PM, and later hook up with a cute blonde as a result.
Posts: 8,017
Threads: 0
Joined: Nov 2010
Explanation into Thursday's outage
08-30-2013, 09:20 AM
Quote: (08-30-2013 08:45 AM)Roosh Wrote:
There has been a reported problem of a registered member disappearing from the database (though his posts are preserved).
If you can no longer log in, email me: roosh at rooshv dot com
Was is Presidentcarter? He is listed now as unregistered.
Posts: 1,985
Threads: 0
Joined: Feb 2011
Reputation:
56
Explanation into Thursday's outage
08-30-2013, 09:21 AM
Just received the following two errors on different pages:
Quote:Quote:
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
2013 - Lost connection to MySQL server during query
Query:
SELECT * FROM mybb_threads WHERE tid='27558'
Quote:Quote:
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
We probably shouldn't be able to see any of the actual database queries used. Makes it much easier for an SQL injection attack.
I can't have sex with your personality, and I can't put my penis in your college degree, and I can't shove my fist in your childhood dreams, so why are you sharing all this information with me?
Posts: 826
Threads: 0
Joined: Nov 2011
Reputation:
69
Explanation into Thursday's outage
08-30-2013, 09:22 AM
This happened around 10:15am
Posts: 2,056
Threads: 0
Joined: Feb 2012
Reputation:
114
Explanation into Thursday's outage
08-30-2013, 09:37 AM
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
145 - Table './rooshvf_forum/mybb_users' is marked as crashed and should be repaired
Query:
SELECT u.*, f.* FROM mybb_users u LEFT JOIN mybb_userfields f ON (f.ufid=u.uid) WHERE u.uid='10286' LIMIT 1
Posts: 19,387
Threads: 0
Joined: Aug 2008
Reputation:
414
Explanation into Thursday's outage
08-30-2013, 11:12 AM
The errors have persisted. I'm aware of them and the IT guy is on it.
Posts: 19,387
Threads: 0
Joined: Aug 2008
Reputation:
414
Explanation into Thursday's outage
08-30-2013, 11:36 AM
Reload the page when you get an error.
I know that this really sucks, and decreases your RVF viewing pleasure, but rest assured that I won't rest until the forum is back to full health. I don't know how long it will take, but it's my top priority right now after banging.
Posts: 5,822
Threads: 0
Joined: Oct 2011
Reputation:
72
Explanation into Thursday's outage
08-30-2013, 12:01 PM
still getting errors but I can refresh the page and get it to come up now.
Why do the heathen rage and the people imagine a vain thing? Psalm 2:1 KJV
Posts: 5,420
Threads: 0
Joined: Sep 2010
Reputation:
102
Explanation into Thursday's outage
08-30-2013, 12:10 PM
why, I was just getting up for my morning coffee hoping to see some bitching about women and the MySQL broke!!
THis was right as it was logging me in as an inveterate abuser.
Then it puked again when I added the screen shot but I didn't catch message.
Posts: 19,387
Threads: 0
Joined: Aug 2008
Reputation:
414
Explanation into Thursday's outage
08-30-2013, 12:10 PM
Can everyone continue to paste the error messages in this thread, so we can troubleshoot the problem.
Posts: 8,017
Threads: 0
Joined: Nov 2010
Explanation into Thursday's outage
08-30-2013, 12:36 PM
I wonder if it is a coincidence that these problems started when Emech started posting on the forum from a MAC.
Posts: 3,448
Threads: 0
Joined: Feb 2013
Reputation:
35
Explanation into Thursday's outage
08-30-2013, 12:37 PM
Same as iknowexactly...I couldn't search anything from 10am until at least noon...probably 1:30
A man is only as faithful as his options-Chris Rock
Posts: 1,723
Threads: 0
Joined: Jul 2010
Explanation into Thursday's outage
08-30-2013, 01:28 PM
Got this a minute ago. Reloaded page and worked normally again.
Wald