Server Problems Resolved

   / Server Problems Resolved #1  

Muhammad

Administrator
Moderator
Joined
Mar 21, 1998
Messages
20,646
Location
San Diego, CA
Tractor
None currently
What Happened?

On Tuesday evening, our server's hard drive began to fail, which led to the corruption of our database. Unaware at the time that the hard drive was failing, we did an initial fix on Tuesday night, but errors and other problems persisted on Wednesday and into Thursday morning.

After discovering the need to replace the hard drive on Thursday morning, we closed the forums down and began the process of replacing the drive today around 5:00PM EST.

Since then we have been working non-stop to setup, configure, and restore the site and move all data to the new hard drive.

Why Did This Happen?

We don't have a rock solid explanation at this time as to why the hard drive would fail---It was about 5 months old. We consider it a freak incident.

Was Any Data Lost?

Unfortunately, approximately 200-250 active user accounts were corrupted and removed in our database rebuild. All posts by those users will no longer be associated with the poster names, but the actual content of the messages will still be available through searching and in threads.

Additionally, all posts from July 2nd-July 3rd were lost. We estimate this at approximately 600-800 messages.

On the plus side, we have verified that all current posts and users are clean and free of corruption.

How Will I be Affected?

Threads and messages posted by affected users will appear as unregistered posts with the username 'Poster' ... this was the best fix we could come up with, to get the posts back into the database and free of corruption.

It seems that users who have registered in the past 5 months are most likely to be affected.

<font color="brown">If you are getting a 'Username Does Not Exist' error</font> when trying to login, then you are probably among the 200-250 affected posters. Many of you already re-registered on July 2nd-3rd, but unfortunately you will have to re-register once more.

Click here for instructions if your account has been lost.

The Future

It has always been our goal to provide an extremely reliable service to our users, and this outage is certainly uncharacteristic of TractorByNet.com. We do what we can to prevent downtime, but sometimes it just isn't in our hands.

Again, thank you for your patience and understanding. We're ready to get back to talking about tractors now! /forums/images/graemlins/smirk.gif

If you get any errors, please report them in this thread.
 
   / Server Problems Resolved #2  
Glad that you got it worked out with minimal damage. We are not used to TBN having major problems.
Withdrawal can be bad. /forums/images/graemlins/smile.gif /forums/images/graemlins/smile.gif /forums/images/graemlins/smile.gif /forums/images/graemlins/smile.gif
 
   / Server Problems Resolved #3  
<font color="blue"> After discovering the need to replace the hard drive on Thursday morning,</font>
Were the drives either RAID 1 or RAID 5?
 
   / Server Problems Resolved #4  
</font><font color="blue" class="small">( Withdrawal can be bad. )</font>
Tell me about it!! I didn't know what to do with myself last night...... /forums/images/graemlins/confused.gif
Mark
 
   / Server Problems Resolved #5  
Muhammad. First I would like to say thanks for all the work you have put into this site to make it the best on the web.

Next, I noticed the same error wornings on CountryBy net today, that TractorBynet had yesterday. That one run on the same server? Still problems with CBN?

Once agen, thanks for all the hard work! /forums/images/graemlins/cool.gif /forums/images/graemlins/smile.gif I would hate to lose the site now, after FINLY getting my tractor, after almost 3 years of being here /forums/images/graemlins/smile.gif
 
   / Server Problems Resolved #6  
Hey - I just went over to CBN and kept going! /forums/images/graemlins/grin.gif /forums/images/graemlins/grin.gif
 
   / Server Problems Resolved #7  
Everything is certainly working well and fast this morning and looks good. I do get a weird heading on the main index page on CBN, but I've forgotten how to copy it. Are you getting something like that?
 
   / Server Problems Resolved #8  
TBN Staff,

Sounds like you had a long day and we appreciate all of the efforts to get things up and running. Given all of the traffic here it is amazing there are not more problems. Well done.

MarkV
 
   / Server Problems Resolved #9  
<font color="blue">but I've forgotten how to copy it</font>

Warning: mysql_query(): Unable to save result set in /home/country/htdocs/forums/mysql.inc.php on line 71
SQL ERROR: Unable to do_query: SELECT COUNT(*) FROM w3t_Users WHERE U_Approved='yes'
Got error 127 from table handler
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/country/htdocs/forums/mysql.inc.php on line 83
 
   / Server Problems Resolved #10  
Thanks, Mike, that's the one. That lets me know it isn't just my computer. /forums/images/graemlins/laugh.gif
 

Tractor & Equipment Auctions

2- 30 X 42 TRIANGLE PIPE RACK (A52472)
2- 30 X 42...
2018 Ford F-150 4x4 Ext. Cab Pickup Truck (A50323)
2018 Ford F-150...
40FT Shipping Container (Modified for Parts Storage) (A51573)
40FT Shipping...
1999 KENWORTH W900 TANDEM AXLE SLEEPER (A52576)
1999 KENWORTH W900...
2008 Ford F-250 4x4 Knapheide Service Truck with Liftgate (A51692)
2008 Ford F-250...
2011 FREIGHTLINER CORNADO (INOPERABLE) (A52472)
2011 FREIGHTLINER...
 
Top