Bitcoin Forum
November 23, 2017, 01:34:15 PM *
News: Latest stable version of Bitcoin Core: 0.15.1  [Torrent].
 
   Home   Help Search Donate Login Register  
Pages: [1]
  Print  
Author Topic: What happened to bitcointalk.org today? Crashed? Hacked?  (Read 2341 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
1511444055
Hero Member
*
Offline Offline

Posts: 1511444055

View Profile Personal Message (Offline)

Ignore
1511444055
Reply with quote  #2

1511444055
Report to moderator
Join ICO Now Coinlancer is Disrupting the Freelance marketplace!
Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction. Advertise here.
1511444055
Hero Member
*
Offline Offline

Posts: 1511444055

View Profile Personal Message (Offline)

Ignore
1511444055
Reply with quote  #2

1511444055
Report to moderator
1511444055
Hero Member
*
Offline Offline

Posts: 1511444055

View Profile Personal Message (Offline)

Ignore
1511444055
Reply with quote  #2

1511444055
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: 1372


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: 1190


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: 2324



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: 1190


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: 2856


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



View Profile
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!