Thanks for all your work on getting it back!
Full Version: Looks like we're back up now
Thanks for all your work on getting it back!
Aaaah! That's better! 
Same here... it was touch and go for a while but I'm better know.
That was quite the outtage (since 5pm-ish yesterday for me). Wonder what happened?
Thanks Guys! Sorry about that.
I sent this reply to a few (who e-mailed me) to explain.
Obviously this part is no longer correct.
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
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)
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
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.
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 problemo! Being an admin is not always a piece of cake! 
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.
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.
--------------------------------------------------------------------------------
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!
Don't worry about the down time .... my boss appreciated it. :leaving:
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.
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
) 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.....
) 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
).
I felt like this 
for 2 day's, now it this 
I kept checking the site every 20/30 mins to see if was back up
Thanks guys for your hard work
for 2 day's, now it this I kept checking the site every 20/30 mins to see if was back up
Thanks guys for your hard work
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.
Experience is the best teacher.... We learned a ton this time. Just had to get a good practice run in first..... 
Kevin, here is the hero of the day
Hero -----> ,
told-you 
QUOTE (Eugenio_SS @ Jan 23 2006, 22:38)
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... ,
... oh forgot, that was on the 44th beer in the wall.
QUOTE (trackbird @ Jan 23 2006, 22:40)
QUOTE (Eugenio_SS @ Jan 23 2006, 22:38)
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
Thanks Lee for your help.
Appreciate both of your guys work!
QUOTE (v7guy @ Jan 24 2006, 08:39)
Appreciate both of your guys work!
Lee did most of the work and Kevin learned to transfer files.
I just pin-pointed the where the error was occuring on a specific transfer... trust me, i didn't do anything.
just had a good laugh w/ Kevin.
QUOTE (Eugenio_SS @ Jan 24 2006, 17:40)
QUOTE (v7guy @ Jan 24 2006, 08:39)
Appreciate both of your guys work!
Lee did most of the work and Kevin learned to transfer files.
I just pin-pointed the where the error was occuring on a specific transfer... trust me, i didn't do anything.
just had a good laugh w/ Kevin.
I don't think he meant you......
I'm not even sure he meant me, and I was involved.
I think..... :stupid:
it's so confusing to know who is referring to who...
Glad to see us back up!
I need to work on this whole communication thing 
QUOTE (v7guy @ Jan 25 2006, 02:50)
I need to work on this whole communication thing
what communication thing ? ....
:leaving: see we're not understanding each other.
Good job guys....you managed to schedule this outage so it HAD NO EFFECT on me! 
As I was in Vegas the whole time losing this years race budget! At least I did miss much around here.... :leaving:
As I was in Vegas the whole time losing this years race budget! At least I did miss much around here.... :leaving:
QUOTE (rmackintosh @ Jan 25 2006, 11:49)
Good job guys....you managed to schedule this outage so it HAD NO EFFECT on me! As I was in Vegas the whole time losing this years race budget! At least I did miss much around here.... :leaving:
As I was in Vegas the whole time losing this years race budget! At least I did miss much around here.... :leaving:See, I just didn't want you to fall behind on your reading..... What are friends for?
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.