Jump to content

Forum Problems (April 10, 2009) ... This SUCKS!

TGO David

By TGO David
in Feedback and Support

Recommended Posts

  • Administrator
TGO David Postus Maximus

TGO David

Posted
  • Administrator
Posted

We had a problem with our database that was at the very least contributing heavily to the server performance issues we have had all day. Because of this, we were forced to roll back to a backup made last night.

I've managed to strip out all of the offending code and get us back to where we should be... but we have essentially lost one day's worth of posts and new member registrations.

To say that I'm unhappy about this would be an understatement.

  • Replies 20
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Guest Mugster

Guest Mugster

Posted
Posted

Whew, I thought I had a stroke there for like a few seconds.

set autocommit=on; FTW!

jughead Established Contributor

jughead

Posted
Posted

anyone that can make this stuff work has my undying support. keep up the good work. i can tolerate a glitch once in a while without blood pressure getting out of hand.

Farman Established Contributor

Farman

Posted
Posted
anyone that can make this stuff work has my undying support. keep up the good work. i can tolerate a glitch once in a while without blood pressure getting out of hand.

+10

Fallguy Postus Maximus

Fallguy

Posted
Posted
anyone that can make this stuff work has my undying support. keep up the good work. i can tolerate a glitch once in a while without blood pressure getting out of hand.

Yep!!

One good thing....it may have killed a few threads that were dying a slow agonizing death....lol

Guest mustangdave

Guest mustangdave

Posted
Posted

That explains a missing post I made...thx dave

mcurrier Prolific Contributor

mcurrier

Posted
Posted

Not being critical, just asking, but didn't this just happen a few days ago or in the past week or two as well? where we had to roll back to a previous backup and lost a bunch of new posts?

Perhaps we could have the backup done 4 times per day instead of just one? (just guessing here). I don't know how much the backup slows down the forum while it is in progress.

  • Administrator
TGO David Postus Maximus

TGO David

Posted
  • Author
  • Administrator
Posted

I think the last time it happened was a few months back. Possibly before we even had to move to the new server.

Backups aren't time consuming but they do require that the forum is shut down while they occur and they do eat up some space on our server until I offload them. If I were to do it more than once a day, I'm afraid people might complain about the downtime.

I'm looking into some other options right now as well. One of our members suggested hosting with Amazon's Elastic Computing 2 (EC2) service and I've got to do some investigating there. It would mean an almost infinite jump in available storage capacity and bandwidth, but there are other concerns that I need to become comfortable with before making any moves.

Right now we have what the highest tier of virtual server hosting with our current provider. I'm not entirely convinced that we are exceeding the limits of that system, but there is clearly a problem that I've not been able to pinpoint the cause of.

Still working on it!

Fallguy Postus Maximus

Fallguy

Posted
Posted

To be honest the inner workings of the board are over my head. But when I was looking for imaging software to make backups of my hard drive, I found some that if the operating system is still running (which it is of course) it somehow makes a quick image then backs that up...or something like that. Now of course any changes you make from that time forward won't be included in the backup.

Is there anything like that that could be used on the board? You know...take a quick image that wouldn't require it being shut down to back up?

Like I said...this is a little beyond me so if this is silly or impossiable...just look over me...lol

Guest db99wj

Guest db99wj

Posted
Posted

Well crap. I go outside all day, come back and see all these posts gone, man some of my best material was used yesterday. I mean, really, some of the funniest stuff you have ever read in your life was on here, that I put up Friday morning, I kid you not, I mean, it had me rolling in the floor, and since that was the case, it would have really had Caynracer Rolling On The Floor Laughing His A$$ Off!!!

O well, what can you do.

Dave, it happens, it sucks, and we know you are doing everything you can to try to make sure it doesn't happen. You are running a great site, it's growing and reaching a lot of people. Besides, it all the providers fault! Crazy add ons.

  • Administrator
TGO David Postus Maximus

TGO David

Posted
  • Author
  • Administrator
Posted

Update...

I've thrown the gauntlet down with our web hosting provider. If they can't get the server fixed, we're moving elsewhere. More on this as events warrant but I've had enough of this as I'm sure you all have as well.

strickj Postus Maximus

strickj

Posted
Posted (edited)
Well crap. I go outside all day, come back and see all these posts gone, man some of my best material was used yesterday. I mean, really, some of the funniest stuff you have ever read in your life was on here, that I put up Friday morning, I kid you not, I mean, it had me rolling in the floor, and since that was the case, it would have really had Caynracer Rolling On The Floor Laughing His A$$ Off!!!

O well, what can you do.

You with funny material! :screwy:

Naa....I'll believe it when I see it :)

Edited by strickj
strickj Postus Maximus

strickj

Posted
Posted (edited)

Nope,must've just been you TDR :screwy:

On a side note,is one of the features you removed include the list of currently active users on the bottom of pages?

Edited by strickj

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Go to topic listing

TGO HELPFUL LINKS

Outside of TGO...

TRADING POST NOTICE

Before engaging in any transaction of goods or services on TGO, all parties involved must know and follow the local, state and Federal laws regarding those transactions.

TGO makes no claims, guarantees or assurances regarding any such transactions.

THE FINE PRINT

Tennessee Gun Owners (TNGunOwners.com) is the premier Community and Discussion Forum for gun owners, firearm enthusiasts, sportsmen and Second Amendment proponents in the state of Tennessee and surrounding region.

TNGunOwners.com (TGO) is a presentation of Enthusiast Productions. The TGO state flag logo and the TGO tri-hole "icon" logo are trademarks of Tennessee Gun Owners. The TGO logos and all content presented on this site may not be reproduced in any form without express written permission. The opinions expressed on TGO are those of their authors and do not necessarily reflect those of the site's owners or staff.

TNGunOwners.com (TGO) is not a lobbying organization and has no affiliation with any lobbying organizations.  Beware of scammers using the Tennessee Gun Owners name, purporting to be Pro-2A lobbying organizations!

×
×
  • Create New...

Important Information

By using this site, you agree to the following.
Terms of Use | Privacy Policy | Guidelines
 
We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.