Bitcoin Forum
December 05, 2016, 08:44:45 PM *
News: Latest stable version of Bitcoin Core: 0.13.1  [Torrent].
 
   Home   Help Search Donate Login Register  
Pages: [1]
  Print  
Author Topic: What happened to bitcointalk.org today? Crashed? Hacked?  (Read 2226 times)
ForceField
aka Vitaliy
Sr. Member
****
Offline Offline

Activity: 388



View Profile
June 28, 2012, 01:58:35 PM
 #1

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"

PC Hardware & Electronics For BTC     Traded w/: Kansattica | jduck1987 | shakaru | newdude | nitetrader | midievil | blo8i | mb300sd | juggalodarkclow | Garr255 | Tril | Ringmasta | SysRun | CrazyBlane | sokay | BCB | str4wm4n | PinkBatman | Bitobsessed | matauc12 | antimattercrusader | BryanK
1480970685
Hero Member
*
Offline Offline

Posts: 1480970685

View Profile Personal Message (Offline)

Ignore
1480970685
Reply with quote  #2

1480970685
Report to moderator
1480970685
Hero Member
*
Offline Offline

Posts: 1480970685

View Profile Personal Message (Offline)

Ignore
1480970685
Reply with quote  #2

1480970685
Report to moderator
1480970685
Hero Member
*
Offline Offline

Posts: 1480970685

View Profile Personal Message (Offline)

Ignore
1480970685
Reply with quote  #2

1480970685
Report to moderator
Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction. Advertise here.
1480970685
Hero Member
*
Offline Offline

Posts: 1480970685

View Profile Personal Message (Offline)

Ignore
1480970685
Reply with quote  #2

1480970685
Report to moderator
1480970685
Hero Member
*
Offline Offline

Posts: 1480970685

View Profile Personal Message (Offline)

Ignore
1480970685
Reply with quote  #2

1480970685
Report to moderator
1480970685
Hero Member
*
Offline Offline

Posts: 1480970685

View Profile Personal Message (Offline)

Ignore
1480970685
Reply with quote  #2

1480970685
Report to moderator
Grouver (BtcBalance)
Hero Member
*****
Offline Offline

Activity: 530



View Profile WWW
June 28, 2012, 02:00:07 PM
 #2

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

davout
Legendary
*
Offline Offline

Activity: 1358


1davout


View Profile WWW
June 28, 2012, 02:09:49 PM
 #3

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

John (John K.)
Global Troll-buster and
Legendary
*
Offline Offline

Activity: 1092


Will read PM's. Have more time lately


View Profile
June 28, 2012, 02:14:48 PM
 #4

Who brought it back online? theymos is off IIRC.

My BTC Tip Jar: 1Pgvfy19uwtYe5o9dg3zZsAjgCPt3XZqz9 , GPG ID: B3AAEEB0 ,OTC ID: johnthedong
Escrow service is available on a case by case basis! (PM Me to verify I'm the escrow!)

Maged
Legendary
*
Offline Offline

Activity: 1260


View Profile
June 28, 2012, 02:55:46 PM
 #5

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.

Stephen Gornick
Legendary
*
Offline Offline

Activity: 1988



View Profile
June 28, 2012, 04:53:16 PM
 #6

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

ForceField
aka Vitaliy
Sr. Member
****
Offline Offline

Activity: 388



View Profile
June 29, 2012, 02:55:53 AM
 #7

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."

PC Hardware & Electronics For BTC     Traded w/: Kansattica | jduck1987 | shakaru | newdude | nitetrader | midievil | blo8i | mb300sd | juggalodarkclow | Garr255 | Tril | Ringmasta | SysRun | CrazyBlane | sokay | BCB | str4wm4n | PinkBatman | Bitobsessed | matauc12 | antimattercrusader | BryanK
John (John K.)
Global Troll-buster and
Legendary
*
Offline Offline

Activity: 1092


Will read PM's. Have more time lately


View Profile
June 29, 2012, 02:57:40 AM
 #8

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

My BTC Tip Jar: 1Pgvfy19uwtYe5o9dg3zZsAjgCPt3XZqz9 , GPG ID: B3AAEEB0 ,OTC ID: johnthedong
Escrow service is available on a case by case basis! (PM Me to verify I'm the escrow!)

pirateat40
Avast Ye!
Sr. Member
****
Offline Offline

Activity: 378


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


View Profile WWW
June 29, 2012, 03:06:17 AM
 #9

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.

 

theymos
Administrator
Legendary
*
Offline Offline

Activity: 2492


View Profile
June 29, 2012, 04:01:13 AM
 #10

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.

1NXYoJ5xU91Jp83XfVMHwwTUyZFK64BoAD
apetersson
Hero Member
*****
Offline Offline

Activity: 666


mycelium.com


View Profile WWW
June 29, 2012, 08:00:18 AM
 #11

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
Pages: [1]
  Print  
 
Jump to:  

Sponsored by , a Bitcoin-accepting VPN.
Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!