What happened to bitcointalk.org today? Crashed? Hacked?

apetersson

hero member

Activity: 668

Merit: 501

Quote from: irc

[01:27]   yellowhat   theymos: are you sure its not a self-dos due to new addons (maybe badly written) addons?
[01:29]   yellowhat   is the source available? I could review the sql maybe
[01:30]   yellowhat   maybe its doing something dumb as querying without index or anything

/pats myself on back for remote debugging ninja-senses Grin

theymos

administrator

Activity: 5222

Merit: 13032

I have a guess about what caused all of the problems today. While writing watchlist.php today, I ran an SQL query that seemed to really confuse MySQL. It was something like this:

Code:

select t.ID_TOPIC as ID_TOPIC, t.ID_BOARD as ID_BOARD, 
t.ID_LAST_MSG, m.subject AS subject from smf_watchlist w LEFT JOIN
smf_topics t ON (t.ID_TOPIC = t.ID_TOPIC) LEFT JOIN smf_messages m ON
(m.ID_MSG = t.ID_FIRST_MSG) where w.ID_MEMBER = 35;

I believe it was the ON (t.ID_TOPIC = t.ID_TOPIC) part that caused problems. (This isn't actually what I wanted to do -- I meant to compare ID_TOPIC in two different tables.) I think this query caused the database to lock up completely and refuse all connections, even after I stopped loading the page which ran this query. Maybe it also created huge temporary files which caused the other problems -- I didn't notice.

pirateat40

sr. member

Activity: 378

Merit: 250

"Yes I am a pirate, 200 years too late."

From what I've gathered, Maged slipped on a stale hot pocket (pepperoni) and spilled his Malava Novocaine drink all over the back of the server. It just needed to dry out a bit before the system came back up.

Warning! Smoke signals are often mistranslated.

John (John K.)

legendary

Activity: 1288

Merit: 1227

Away on an extended break

I got another one:

Quote

Database Error: Query execution was interrupted
File: /var/www/bitcoin/smf/Sources/BoardIndex.php
Line: 84Database Error: MySQL server has gone away
File: /var/www/bitcoin/smf/Sources/Load.php
Line: 2040

ForceField

sr. member

Activity: 386

Merit: 250

Site was down again at 10:54PM EST. New error message:

"Connection Problems
Sorry, SMF was unable to connect to the database. This may be caused by the server being busy. Please try again later."

Stephen Gornick

legendary

Activity: 2506

Merit: 1010

With current traffic exceeding two million page views per week, this forum is getting quite a workout!

Maged

legendary

Activity: 1204

Merit: 1015

Quote from: John (John K.) on June 28, 2012, 09:14:48 AM

Who brought it back online? theymos is off IIRC.

Most likely it was Mark (MagicalTux).

Also, based on when the posts stopped, we either reverted to a DB backup, or this was the result of the backup. I don't have a tracker watching when the forum is down (since I can't do anything anyway), so I don't know which it was.

John (John K.)

legendary

Activity: 1288

Merit: 1227

Away on an extended break

Who brought it back online? theymos is off IIRC.

davout

legendary

Activity: 1372

Merit: 1008

1davout

Usually happens to MySQL when the partition it sits on is full.

Grouver (BtcBalance)

hero member

Activity: 530

Merit: 500

Got an "Got error 134 from storage engine" message.
So I assume the database crashed or was full?

ForceField

sr. member

Activity: 386

Merit: 250

When trying to access bitcointalk.org today, the following error message was displayed on a blank white page:

"Table './bitcoin/smf_sessions' is marked as crashed and should be repaired"

Topic: What happened to bitcointalk.org today? Crashed? Hacked? (Read 2457 times)