You're only a Guest! Register today!
You're only a Guest! Register today!
Important Announcement: Please consider donating to TVF! In return, you'll receive a RapidShare.com, MegaShares.com, Uploaded.net/.to, TurboBit.net, FileFactory.com, DepositFiles.com, ExtaBit.com, & Netload.in Premium Account.  EIGHT Accounts (and counting, we are constantly adding more accounts) for the price of one. Plus, access to our private RapidLeech along with everyone's respect and many other bonus features. |
  |
| Downtime Info |
 May 27 2011, 03:16 AM
Post
#1
|
|
 Administrator // Founder  Group: Root Admin Posts: 41,980 Joined: 5-February 07 From: The Viper Files Index Skin: TVF 2011 Reloaded Member No.: 1  |
Hey guys. As I am typing this it is 5 AM my time.. (I hate being up at 5am
 ) I've been setting my alarm in intervals of 3 hours for the past couple of nights to ensure that the shell command that I ran was working. I will do my best to explain things.We were down for a whole day (~12 hours) before I realized something was actually really wrong. I thought perhaps a reboot would suffice, but it didn't. My data center was helping as well, and they were telling me the database was corrupt which was causing apache to work extremely hard and bog down the CPU. They recommended a restore from a backup as they thought data would be lost. I did have a backup from six days prior to this situation started, but I figured that by the time I got it uploaded, working, etc. that the "current" database would be better if we could use. A couple of days ago during the wee hours of the morning, the CPU spiked high and caused a glitch in the database. I found that the "posts" table was "in use" which doesn't exactly mean corrupt, but the number of data that it reports is different than what it actually has. This is what you see sometimes when you see a "IPS Driver Error" because I have to do this same thing with a different table. The difference is, the posts table is 4GB, which the other one is like 19KB. So instead of producing a IPS Driver Error, the errored posts table just bogged down the server. The shell command that I had to run repairs and forces the repair in safemode. This command ran for over 24 hours, so I had to make sure I kept my computer on + connected to the network + no sleep, etc for it. The command had to process 876,000 lines of SQL. I miss calculated on night 1, the process went from 60% to 20% overnight because I didn't see that it was in the hundred thousands, thought it was just 87,600. But It finally completed and it ACTUALLY worked  Hope this helps everyones understanding!  Thank you to the people who donated while being down. If you are a current VIP, I'll have your PP email address on record so I can correctly allocate your time. If you're not, I'll be emailing you, but please feel free shoot me a PM anyways with the transaction details! VIPs who were set to expire will receive a couple extra days to make up for this too, btw. Thank you for reading my novella, I'm just glad to see the site back up. Have a good weekend everyone! It'll be a busy one for me, I graduate this weekend! -------------------- |
 |
 
|
|
May 27 2011, 03:55 AM
Post
#2
|
|
|
Beginner  Group: Members Posts: 9 Joined: 9-November 10 Skin: TVF 2011 Reloaded Member No.: 85,036 |
QUOTE (Viper3773 @ May 27 2011, 03:16 AM)  Thank you for reading my novella, I'm just glad to see the site back up. Have a good weekend everyone! It'll be a busy one for me, I graduate this weekend! Glad to see the site back up...well done and welcome back. Congratulations on graduation.  Stay safe and have a great weekend! PS donating a month in lieu of a gift.  |
|
|
|
|
May 27 2011, 06:45 AM
Post
#3
|
|
 Special little helper  Group: Moderators Posts: 6,641 Joined: 20-October 07 From: a galaxy far, far away. Skin: TVF 2010 Member No.: 15,110 |
Nice job,Viper! I had complete faith in you,good thing you had a backup just in case.
 Congratulations on graduating and try not to bore the crowd during your valedictorian speech about how you were able to run a warez forum,maintain a 4.0 and sleep with all the girls in your 2011 class.  I only wish I was as mature and intelligent as you are when I was your age (during the Cenozoic era). You will go far in this world (providing the religious freaks and Mayans are not correct). --------------------  |
|
|
|
|
May 27 2011, 07:22 AM
Post
#4
|
|
 Teacher Group: Members Posts: 112 Joined: 22-March 08 Skin: TVF 2011 Reloaded Member No.: 29,078 |
Congrats viper for the graduation and for this community
You are graduating from high school or college? --------------------   |
|
|
|
|
May 27 2011, 07:40 AM
Post
#5
|
|
|
Special little helper Group: Moderators Posts: 6,641 Joined: 20-October 07 From: a galaxy far, far away. Skin: TVF 2010 Member No.: 15,110 |
QUOTE (chuchay @ May 27 2011, 06:22 AM) You are graduating from high school or college? "Massage Therapy Trade School for Nerds" Here you go,Viper,very informative. CODE http://www.funnyordie.com/videos/12c3211713/college-is-a-scam -------------------- |
|
|
|
|
May 27 2011, 07:52 AM
Post
#6
|
|
 Teh Addict Group: Moderators Posts: 774 Joined: 6-October 10 From: Colorado Skin: TVF Retro Member No.: 83,642 |
--------------------  Members-->  <--Members |
|
|
|
|
May 27 2011, 08:45 AM
Post
#7
|
|
|
Executioner Group: Moderators Posts: 3,957 Joined: 7-January 10 Skin: TVF 2011 Reloaded Member No.: 68,972 |
great job viper getting the site back working ...
 Congratulations on graduating ..enjoy ur weekend viper |
|
|
|
|
May 27 2011, 09:01 AM
Post
#8
|
|
 Teh Addict Group: Members Posts: 860 Joined: 18-June 08 Skin: TVF 2011 Reloaded Member No.: 36,567 |
good job viper and congrads on graduating
This post has been edited by the undertaker: May 27 2011, 09:51 AM |
|
|
|
|
May 27 2011, 09:29 AM
Post
#9
|
|
 Moderator Group: Moderators Posts: 452 Joined: 28-June 09 From: Errrm Im Here Skin: TVF 2011 Reloaded Member No.: 55,217 |
welcome back TVF......Congrats on graduation m8
--------------------  |
|
|
|
|
May 27 2011, 11:23 AM
Post
#10
|
|
 Moderator Group: Moderators Posts: 783 Joined: 28-August 08 From: Longship nearby... Skin: TVF 2010 Member No.: 43,646 |
Well done of your graduation...
As ever, you never cease to amaze me in the speed you recover the site when it does go down... --------------------  |
|
|
|
|
May 27 2011, 03:20 PM
Post
#11
|
|
|
Administrator // Founder Group: Root Admin Posts: 41,980 Joined: 5-February 07 From: The Viper Files Index Skin: TVF 2011 Reloaded Member No.: 1 |
QUOTE (whaty0uwant @ May 27 2011, 05:32 AM) Congrats on graduation Viper, and thanks for the hard work, no sleep and no fun getting this back up and running, hope everyone appreciate what all goes into this on your side of things, not as easy as a lot of people probably think... Thanks! Thank you whatyouwant QUOTE (Dementzia @ May 27 2011, 05:55 AM) QUOTE (Viper3773 @ May 27 2011, 03:16 AM) Thank you for reading my novella, I'm just glad to see the site back up. Have a good weekend everyone! It'll be a busy one for me, I graduate this weekend! Glad to see the site back up...well done and welcome back. Congratulations on graduation. Stay safe and have a great weekend! PS donating a month in lieu of a gift. Thank you for donating, it is much appreciated QUOTE (chuchay @ May 27 2011, 09:22 AM) Congrats viper for the graduation and for this community You are graduating from high school or college? High school! QUOTE (hex @ May 27 2011, 09:40 AM) QUOTE (chuchay @ May 27 2011, 06:22 AM) You are graduating from high school or college? "Massage Therapy Trade School for Nerds" Here you go,Viper,very informative. CODE http://www.funnyordie.com/videos/12c3211713/college-is-a-scam nice QUOTE (Kurruppt @ May 27 2011, 09:52 AM) QUOTE (Lord Hellfire @ May 27 2011, 10:45 AM) great job viper getting the site back working ... Congratulations on graduating ..enjoy ur weekend viper Thank you QUOTE (the undertaker @ May 27 2011, 11:01 AM) good job viper and congrads on graduating Thanks QUOTE (Ali3n @ May 27 2011, 11:29 AM) welcome back TVF......Congrats on graduation m8 Ty QUOTE (Psychoca @ May 27 2011, 01:23 PM) Well done of your graduation... As ever, you never cease to amaze me in the speed you recover the site when it does go down... Thanks for the positive support
-------------------- |
|
|
|
|
May 27 2011, 09:02 PM
Post
#12
|
|
 Beginner Group: Members Posts: 1 Joined: 26-June 08 Skin: TVF 2011 Reloaded Member No.: 37,341 |
grats on ur graduation
the downtime freaked me out good to see it back edit i juz realized this is my first post since joining... This post has been edited by letswrok: May 27 2011, 09:03 PM |
|
|
|
|
May 28 2011, 04:14 AM
Post
#13
|
|
 Philosopher  Group: VIP Donator Posts: 287 Joined: 5-February 11 From: planet_42o Skin: TVF 2011 Reloaded Member No.: 89,647 |
QUOTE (Viper3773 @ May 27 2011, 04:16 AM) If you are a current VIP, I'll have your PP email address on record so I can correctly allocate your time. no worries here about a lil down time . YOUR hard work is well , well , appreciated here !! THANK YOU AGAIN ! Pic . --------------------      |
|
|
|
|
May 28 2011, 10:31 AM
Post
#14
|
|
|
Administrator // Founder Group: Root Admin Posts: 41,980 Joined: 5-February 07 From: The Viper Files Index Skin: TVF 2011 Reloaded Member No.: 1 |
QUOTE (letswrok @ May 27 2011, 11:02 PM) grats on ur graduation the downtime freaked me out good to see it back edit i juz realized this is my first post since joining... Me too, and awesome and welcome to posting QUOTE (Pic @ May 28 2011, 06:14 AM) QUOTE (Viper3773 @ May 27 2011, 04:16 AM) If you are a current VIP, I'll have your PP email address on record so I can correctly allocate your time. no worries here about a lil down time . YOUR hard work is well , well , appreciated here !! THANK YOU AGAIN ! Pic . You are def welcome
-------------------- |
|
|
|
|
May 28 2011, 12:42 PM
Post
#15
|
|
 Teacher Group: Members Posts: 144 Joined: 2-May 10 From: N. CA - way North Skin: TVF 2011 Reloaded Member No.: 75,716 |
CONGRATULATIONS on all things ... you're a great human being, I really admire your tenacity.
@hunter4 
|
|
|
|
|
1 User(s) are reading this topic (1 Guests)
0 Members:
Similar Topics
| Topic Title | Replies | Topic Starter | Views | Last Action | |||
|---|---|---|---|---|---|---|---|
 |
30 | Viper3773 | 32,916 | 18th September 2011 - 08:00 PM Last post by: Viper3773 |
|||
|
Lo-Fi Version | Time is now: 18th May 2013 - 07:16 PM |