The Viper Files uses JavaScript to enhance essential functionality, we recommend browsing with JavaScript enabled.

 Donate to The Viper Files and receive access to premium accounts such as Uploaded, RapidGator, FileFactory, Netload, TurboBit, and MegaShares! 

Welcome Guest ( Log In | Register )

Important Announcement: Please consider donating to TVF! In return, you'll receive a Uploaded.net/.to , RapidGator.com , FileFactory.com , Netload.in , MegaShares.com , and Turbobit.net Premium Account. cool.gif
Many Premium Accounts for the price of one. Plus, access to our private RapidLeech along with everyone's respect and many other bonus features. 2thumbsup.gif

2 Pages V   1 2 >  
Reply to this topicStart new topic
> Downtime Info
Viper3773
post May 27 2011, 03:16 AM
Post #1


Administrator // Founder
Group Icon

Group: Root Admin
Posts: 42,460
Joined: 5-February 07
From: The Viper Files Index
Skin: TVF Reloaded
Member No.: 1



Hey guys. As I am typing this it is 5 AM my time.. (I hate being up at 5am tongue.gif) 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 wink.gif


Hope this helps everyones understanding! smile.gif


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! smile.gif


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!


--------------------
Go to the top of the page
 
+Quote Post
Dementzia
post May 27 2011, 03:55 AM
Post #2


Beginner
Group Icon

Group: Members
Posts: 9
Joined: 9-November 10
Skin: TVF 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. smart.gif
Stay safe and have a great weekend!

PS donating a month in lieu of a gift. whistle.gif
Go to the top of the page
 
+Quote Post
hex
post May 27 2011, 06:45 AM
Post #3


Special little helper
Group Icon

Group: Moderators
Posts: 7,649
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. thumbsup.gif
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. tongue.gif biggrin.gif
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). biggrin.gif


--------------------
Go to the top of the page
 
+Quote Post
chuchay
post May 27 2011, 07:22 AM
Post #4


Teacher
Group Icon

Group: Members
Posts: 112
Joined: 22-March 08
Skin: TVF Reloaded
Member No.: 29,078



Congrats viper for the graduation and for this community smile.gif
You are graduating from high school or college?


--------------------
Go to the top of the page
 
+Quote Post
hex
post May 27 2011, 07:40 AM
Post #5


Special little helper
Group Icon

Group: Moderators
Posts: 7,649
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



--------------------
Go to the top of the page
 
+Quote Post
Kurruppt
post May 27 2011, 07:52 AM
Post #6


Teh Addict
Group Icon

Group: Moderators
Posts: 818
Joined: 6-October 10
From: Colorado
Skin: TVF Retro
Member No.: 83,642





--------------------

Members--> <--Members
Go to the top of the page
 
+Quote Post
Lord Hellfire
post May 27 2011, 08:45 AM
Post #7


Executioner
Group Icon

Group: Members
Posts: 3,957
Joined: 7-January 10
Skin: TVF Reloaded
Member No.: 68,972



great job viper getting the site back working ... cheers.gif

Congratulations on graduating ..enjoy ur weekend viper
Go to the top of the page
 
+Quote Post
the undertaker
post May 27 2011, 09:01 AM
Post #8


Teh Addict
Group Icon

Group: Members
Posts: 872
Joined: 18-June 08
Skin: TVF 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
Go to the top of the page
 
+Quote Post
Ali3n
post May 27 2011, 09:29 AM
Post #9


Former Moderator
Group Icon

Group: Members
Posts: 452
Joined: 28-June 09
From: Errrm Im Here
Skin: TVF Reloaded
Member No.: 55,217



welcome back TVF......Congrats on graduation m8 smile.gif


--------------------
Go to the top of the page
 
+Quote Post
Psychoca
post May 27 2011, 11:23 AM
Post #10


Moderator
Group Icon

Group: Moderators
Posts: 793
Joined: 28-August 08
From: Longship nearby...
Skin: TVF Reloaded
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...



--------------------
Go to the top of the page
 
+Quote Post
Viper3773
post May 27 2011, 03:20 PM
Post #11


Administrator // Founder
Group Icon

Group: Root Admin
Posts: 42,460
Joined: 5-February 07
From: The Viper Files Index
Skin: TVF 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 smile.gif

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. smart.gif
Stay safe and have a great weekend!

PS donating a month in lieu of a gift. whistle.gif


Thank you for donating, it is much appreciated smile.gif
QUOTE (chuchay @ May 27 2011, 09:22 AM) *
Congrats viper for the graduation and for this community smile.gif
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 tongue.gif

QUOTE (Kurruppt @ May 27 2011, 09:52 AM) *


biggrin.gif

QUOTE (Lord Hellfire @ May 27 2011, 10:45 AM) *
great job viper getting the site back working ... cheers.gif

Congratulations on graduating ..enjoy ur weekend viper


Thank you smile.gif

QUOTE (the undertaker @ May 27 2011, 11:01 AM) *
good job viper and congrads on graduating


Thanks smile.gif

QUOTE (Ali3n @ May 27 2011, 11:29 AM) *
welcome back TVF......Congrats on graduation m8 smile.gif


Ty smile.gif

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 smile.gif


--------------------
Go to the top of the page
 
+Quote Post
letswrok
post May 27 2011, 09:02 PM
Post #12


Beginner
Group Icon

Group: Members
Posts: 1
Joined: 26-June 08
Skin: TVF 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
Go to the top of the page
 
+Quote Post
Pic
post May 28 2011, 04:14 AM
Post #13


Philosopher
Group Icon

Group: Members
Posts: 287
Joined: 5-February 11
From: planet_42o
Skin: TVF 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 .


--------------------




Go to the top of the page
 
+Quote Post
Viper3773
post May 28 2011, 10:31 AM
Post #14


Administrator // Founder
Group Icon

Group: Root Admin
Posts: 42,460
Joined: 5-February 07
From: The Viper Files Index
Skin: TVF 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 tongue.gif

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 smile.gif


--------------------
Go to the top of the page
 
+Quote Post
hunter4
post May 28 2011, 12:42 PM
Post #15


Teacher
Group Icon

Group: Members
Posts: 144
Joined: 2-May 10
From: N. CA - way North
Skin: TVF Reloaded
Member No.: 75,716



CONGRATULATIONS on all things ... you're a great human being, I really admire your tenacity.
@hunter4

Go to the top of the page
 
+Quote Post

2 Pages V   1 2 >
Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests)
0 Members:

 

-

> Similar Topics

    Topic Title Replies Topic Starter Views Last Action
No new   30 Viper3773 34,440 18th September 2011 - 08:00 PM
Last post by: Viper3773



Free Full Premium Downloads RapidShare Hotfile Free Downloads Full Version Download Full RAR Downloads The Mass Auto DDL Submitter MassDDL.com

RSS Lo-Fi Version Time is now: 1st October 2014 - 08:15 AM
DMCA Policy