 Looks like we're back up now, I was in withdrawal... |
|
|||||||||
  |
 Jan 23 2006, 09:28 PM
Post
#1
|
|
|
Engine and Tools Moderator  Group: Advanced Members Posts: 1,859 Joined: 23-December 03 From: Lebanon TN Member No.: 6  |
(IMG:http://www.frrax.com/rrforum/style_emoticons/default/smile.gif)
Thanks for all your work on getting it back! |
 |
 
|
|
Jan 23 2006, 09:40 PM
Post
#2
|
|
|
CMCer Group: Moderators Posts: 2,932 Joined: 12-February 04 From: the sticks near VIR Member No.: 194 |
Aaaah! That's better! (IMG:http://www.frrax.com/rrforum/style_emoticons/default/thumbup.gif)
|
|
|
|
|
Jan 23 2006, 09:43 PM
Post
#3
|
|
|
Experienced Member Group: Advanced Members Posts: 2,290 Joined: 4-May 04 From: Kenvil, NJ Member No.: 331 |
Same here... it was touch and go for a while but I'm better know.
|
|
|
|
|
Jan 23 2006, 10:06 PM
Post
#4
|
|
|
Chapter 11 Racing Group: Advanced Members Posts: 1,166 Joined: 15-February 04 From: Houston, Republic of Texas Member No.: 207 |
|
|
|
|
|
Jan 23 2006, 10:08 PM
Post
#5
|
|
|
Advanced Member Group: Member Posts: 440 Joined: 23-December 03 From: Nashville, TN Member No.: 1 |
That was quite the outtage (since 5pm-ish yesterday for me). Wonder what happened?
|
|
|
|
|
Jan 23 2006, 10:10 PM
Post
#6
|
|
|
FRRAX Owner/Admin Group: Admin Posts: 15,432 Joined: 13-February 04 From: Ohio Member No.: 196 |
Thanks Guys! Sorry about that.
I sent this reply to a few (who e-mailed me) to explain. QUOTE I'm going to copy and paste this into the next 15 e-mails, so it's not specific to anyone (sorry), but here's the scoop. At about 11:30 am EST on Sunday, we started the upgrade process specified by Invision to move us to the latest software. The upgrade installed and ran the update script (which was supposed to convert the database to the new version) and it trashed the database on the server. Not to worry, we have full backups (multiple in several locations that were pulled right before the upgrade started so nothing was lost), but we have to upload them to the server again and my hosting company has limited the script time to 300 seconds per script (and it takes far longer than 300 seconds to update a 90 meg database), so we've broken it down into sections (93 of them to be exact) and are uploading each of them, one at a time, until done. The issue is, each one takes just about 5 minutes to execute. So, I started on this at 7pm (EST) last night and ran updates/installs until 2 am. The person assisting me (no names, blame me, not him) has been running updates since early this morning and we are up to file 65 out of 93. I hope to have the board back up and on line later this evening. Unfortunately, since the upgrade wouldn't process, we are restoring the board to the "old" version (exactly as it was) until we can work with invision to correct this problem (with the update script). Sorry for the downtime, I was hoping to unveil a new version of the board for everyone today (new as in updated, not really changed), but things don't always work out as planned. Thanks guys, I'm working on it. Kevin / trackbird (your humble admin) Obviously this part is no longer correct. QUOTE we are up to file 65 out of 93. I hope to have the board back up and on line later this evening. Sorry for the down time, sometimes things just don't go as planned. We'll work out the details and hope to get the new version working in the future, but I have no timeline for that upgrade at this time. Thanks and my apologies for the downtime. Kevin |
|
|
|
|
Jan 23 2006, 11:53 PM
Post
#7
|
|
|
Co-Admin and PHP dude. Group: Advanced Members Posts: 31 Joined: 23-December 03 From: Middle Tennessee Member No.: 10 |
I can't let Kevin take all the blame for the down time.
It was me who was attempting to help him with the upgrade, and helping to get it back up when the upgrade failed. I feel personally responsible for the site being down, and would hope that all of you accept my sincerest apologies for the problems. I'm sure we'll try again in the future, but I have a plan to keep us from having to restore the database in 100+ parts (in the end, it was over 100 parts). But I don't know when that will be. Kevin and I will work that out I guess, assuming he still wants my help with it, and with luck we won't have the same problems next time. |
|
|
|
|
Jan 24 2006, 12:25 AM
Post
#8
|
|
|
CMCer Group: Moderators Posts: 2,932 Joined: 12-February 04 From: the sticks near VIR Member No.: 194 |
No problemo! Being an admin is not always a piece of cake! (IMG:http://www.frrax.com/rrforum/style_emoticons/default/wink.gif)
|
|
|
|
|
Jan 24 2006, 01:27 AM
Post
#9
|
|
|
As fast as poor can be Group: Advanced Members Posts: 622 Joined: 25-May 04 From: Buffalo, NY Member No.: 349 |
hehe, you need shell access to run mysql.... You might be able to make your own php.ini file and increase the timeout as well.
|
|
|
|
|
Jan 24 2006, 02:02 AM
Post
#10
|
|
|
Experienced Member Group: Advanced Members Posts: 1,086 Joined: 16-January 04 From: Chandler AZ Member No.: 130 |
QUOTE LWillmann Posted on Jan 23 2006, 17:53 -------------------------------------------------------------------------------- I can't let Kevin take all the blame for the down time. It was me who was attempting to help him with the upgrade, and helping to get it back up when the upgrade failed. I feel personally responsible for the site being down, and would hope that all of you accept my sincerest apologies for the problems. I'm sure we'll try again in the future, but I have a plan to keep us from having to restore the database in 100+ parts (in the end, it was over 100 parts). But I don't know when that will be. Kevin and I will work that out I guess, assuming he still wants my help with it, and with luck we won't have the same problems next time. No worries; glad it's back up - I can't afford to lose the good info and tech support that's available from this board! |
|
|
|
|
Jan 24 2006, 02:09 AM
Post
#11
|
|
|
Nothing says 'I love you.' like a box of Hydroshoks Group: Moderators Posts: 5,284 Joined: 23-December 03 From: Granbury, TX Member No.: 4 |
Don't worry about the down time .... my boss appreciated it. :leaving:
|
|
|
|
|
Jan 24 2006, 02:49 AM
Post
#12
|
|
|
FRRAX Owner/Admin Group: Admin Posts: 15,432 Joined: 13-February 04 From: Ohio Member No.: 196 |
QUOTE (LWillmann @ Jan 23 2006, 18:53) I can't let Kevin take all the blame for the down time. It was me who was attempting to help him with the upgrade, and helping to get it back up when the upgrade failed. I feel personally responsible for the site being down, and would hope that all of you accept my sincerest apologies for the problems. I'm sure we'll try again in the future, but I have a plan to keep us from having to restore the database in 100+ parts (in the end, it was over 100 parts). But I don't know when that will be. Kevin and I will work that out I guess, assuming he still wants my help with it, and with luck we won't have the same problems next time. Thanks Lee, I didn't mind taking the heat (not that there's much heat (IMG:http://www.frrax.com/rrforum/style_emoticons/default/wink.gif) ) on this one. I appreciate all your help and efforts and will gladly accept your assistance (if you're dumb, er, uh...crazy enough to volunteer..... (IMG:http://www.frrax.com/rrforum/style_emoticons/default/rotf.gif) (IMG:http://www.frrax.com/rrforum/style_emoticons/default/rotf.gif) (IMG:http://www.frrax.com/rrforum/style_emoticons/default/rotf.gif) (IMG:http://www.frrax.com/rrforum/style_emoticons/default/rotf.gif) ) with the next attempt. Lee has dedicated/volunteered far more of his personal time to this process than I can count (or I'm trying not to) in an effort to make this an even better (more current?) place. For that I'm greatly indebited to him and his family for allowing me to take up a perfectly good Sunday afternoon and keeping him busy with the board issues. Thanks Lee, I guess the first round is on me (though I may have to buy more than one (IMG:http://www.frrax.com/rrforum/style_emoticons/default/drink.gif) ). (IMG:http://www.frrax.com/rrforum/style_emoticons/default/beerchug.gif) |
|
|
|
|
Jan 24 2006, 03:07 AM
Post
#13
|
|
|
Grumpy Group: Advanced Members Posts: 2,722 Joined: 1-January 04 From: Bakersfield CA Member No.: 81 |
I felt like this (IMG:http://www.frrax.com/rrforum/style_emoticons/default/unsure.gif) for 2 day's, now it this (IMG:http://www.frrax.com/rrforum/style_emoticons/default/biggrin.gif)
I kept checking the site every 20/30 mins to see if was back up (IMG:http://www.frrax.com/rrforum/style_emoticons/default/blink.gif) Thanks guys for your hard work (IMG:http://www.frrax.com/rrforum/style_emoticons/default/beerchug.gif) |
|
|
|
|
Jan 24 2006, 03:26 AM
Post
#14
|
|
|
Co-Admin and PHP dude. Group: Advanced Members Posts: 31 Joined: 23-December 03 From: Middle Tennessee Member No.: 10 |
QUOTE (rushman @ Jan 23 2006, 19:27) hehe, you need shell access to run mysql.... You might be able to make your own php.ini file and increase the timeout as well. Unfortunately, shell access would not have helped us in this case. The problem was in the way we backed up the database. We used "extended" inserts, which combined all 70k+ posts into a single insert statement. That proved to be too much for the server to deal with. So I had to break it up into more managable chunks of 1000 posts each. Next time, I'll leave it with a single insert per record and it should run better. |
|
|
|
|
Jan 24 2006, 03:28 AM
Post
#15
|
|
|
FRRAX Owner/Admin Group: Admin Posts: 15,432 Joined: 13-February 04 From: Ohio Member No.: 196 |
Experience is the best teacher.... We learned a ton this time. Just had to get a good practice run in first..... (IMG:http://www.frrax.com/rrforum/style_emoticons/default/burnout.gif)
|
|
|
|
|
Jan 24 2006, 03:38 AM
Post
#16
|
|
|
North of the border Group: Admin Posts: 2,307 Joined: 4-February 04 From: Montreal, CANADA Member No.: 177 |
(IMG:http://www.frrax.com/rrforum/style_emoticons/default/beerchug.gif)
Kevin, here is the hero of the day Hero -----> , (IMG:http://www.frrax.com/rrforum/style_emoticons/default/rotf.gif) told-you (IMG:http://www.frrax.com/rrforum/style_emoticons/default/rotf.gif) (IMG:http://www.frrax.com/rrforum/style_emoticons/default/nutkick.gif) (IMG:http://www.frrax.com/rrforum/style_emoticons/default/rotf.gif) |
|
|
|
|
Jan 24 2006, 03:40 AM
Post
#17
|
|
|
FRRAX Owner/Admin Group: Admin Posts: 15,432 Joined: 13-February 04 From: Ohio Member No.: 196 |
QUOTE (Eugenio_SS @ Jan 23 2006, 22:38) (IMG:http://www.frrax.com/rrforum/style_emoticons/default/beerchug.gif) Kevin, here is the hero of the day Nah, Lee gets credit for that. He's the brains, I just transfer files. re-reading the post, one can think that I was talking of me, which I wasn't... I was talking of tha good laugh I had when looked @ the file and notice a sql syntax error @ end of file... hence the Hero... , |
|
|
|
|
Jan 24 2006, 03:41 AM
Post
#18
|
|
|
North of the border Group: Admin Posts: 2,307 Joined: 4-February 04 From: Montreal, CANADA Member No.: 177 |
... oh forgot, that was on the 44th beer in the wall. (IMG:http://www.frrax.com/rrforum/style_emoticons/default/rotf.gif)
|
|
|
|
|
Jan 24 2006, 03:45 AM
Post
#19
|
|
|
North of the border Group: Admin Posts: 2,307 Joined: 4-February 04 From: Montreal, CANADA Member No.: 177 |
QUOTE (trackbird @ Jan 23 2006, 22:40) QUOTE (Eugenio_SS @ Jan 23 2006, 22:38) (IMG:http://www.frrax.com/rrforum/style_emoticons/default/beerchug.gif) Kevin, here is the hero of the day Nah, Lee gets credit for that. He's the brains, I just transfer files. even got stuck at transferring, due to our little coma-friend (IMG:http://www.frrax.com/rrforum/style_emoticons/default/nutkick.gif) (IMG:http://www.frrax.com/rrforum/style_emoticons/default/rotf.gif) Thanks Lee for your help. (IMG:http://www.frrax.com/rrforum/style_emoticons/default/beerchug.gif) (IMG:http://www.frrax.com/rrforum/style_emoticons/default/2thumbs.gif) |
|
|
|
|
Jan 24 2006, 01:39 PM
Post
#20
|
|
|
Advanced Member Group: Advanced Members Posts: 854 Joined: 26-December 03 From: NYC, NY Member No.: 50 |
Appreciate both of your guys work! (IMG:http://www.frrax.com/rrforum/style_emoticons/default/beerchug.gif)
|
|
|
|
|
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:
| Lo-Fi Version | Time is now: 19th June 2025 - 03:54 PM |