Downtime and Database Issues

**Greg** · Feb 19, 2006, 9:07 AM

Just installed a more current version of the image resize mod.

ctenidae · Feb 19, 2006, 1:37 PM

Greg.
Rocks.

That is all.

**Greg** · Feb 20, 2006, 1:24 PM

Still having some major stability issues. The database seemed to crash a few times already today. I think I may have it narrowed down to the script that pulls the post data from the forum and displays the recent discussion on the rest of the site. This same script also powers the News portal and trip report portals, as well as many of the RSS feeds. I've removed use of this script from every page I could. This hopefully will reduce the load on the database server. I am in touch with the script's author to rewrite it to make it more efficient. I guess, in a sense this is a good thing in that the site has become busy enough that it's maxing out the efficiency of some of the scripts and quite possibly phpBB. I think it may be time to pursue more stable forum software, i.e. vBulletin. A conversion would be a huge undertaking though so hopefully we can limp through the rest of the ski season and maybe convert over the slower summer months.

**Greg** · Feb 21, 2006, 2:34 PM

Still problems. I've disabled the News portal temporarily to pin down whether the scripting there is indeed causing the problems. Sorry for the inconvenience...

ctenidae · Feb 21, 2006, 4:26 PM

No worries, Greg.
You might want to try crossconnecting the proton accelerator with the flux capacitor, and shunt the excess wattage through the dihydrogenmonoxide acidase inhibitor. If you can get it ramped up to one point twenty-one gigawatts, well, there's just no telling what you can do.

As you might have noticed, my programming skillz are pretty much limited to ctrl-alt-dlt

andyzee · Feb 21, 2006, 4:34 PM

Now I can see why your ranked as "AlpineZone Authority"

Quote:

Originally Posted by ctenidae

No worries, Greg.
You might want to try crossconnecting the proton accelerator with the flux capacitor, and shunt the excess wattage through the dihydrogenmonoxide acidase inhibitor. If you can get it ramped up to one point twenty-one gigawatts, well, there's just no telling what you can do.

As you might have noticed, my programming skillz are pretty much limited to ctrl-alt-dlt

**Greg** · Feb 21, 2006, 6:01 PM

There is a good chance that I am going to attempt a vBulletin conversion in the next few days. This will likely result in several hours of down time. I'll post an announcement if I decide to proceed here.

Catul · Feb 22, 2006, 8:28 AM

Greg, sounds like you have a major undertaking on your hands over the next couple of days - good luck!

Hope it all works out, I need my daily (or more) AlpineZone fix!

EDIT: the forum is really flying this morning, looks like disabling the News script might have done the trick? Let's hope it lasts ...

**Greg** · Feb 22, 2006, 9:02 AM

Working on importing to a test board now. Things are going VERY smoothly. I may upgrade the actual forum as soon as this morning. If the forums go down, you'll know what I'm doing...

Catul · Feb 22, 2006, 9:05 AM

Hope you got a good backup - don't lose all the stuff here!

Feb 19, 2006, 9:07 AM	#11 (permalink)
Greg Mad River Glen - 2/8/08 Join Date: Jul 2001 Location: Thomaston, CT Posts: 18,916	Just installed a more current version of the image resize mod. __________________ Greg 2007-08, 2006-07, 2005-06, 2004-05 Life's too short for warm up runs.

Feb 19, 2006, 1:37 PM	#12 (permalink)
ctenidae Join Date: Nov 2004 Location: Boston Posts: 4,540	Greg. Rocks. That is all. __________________ "Man is an imperfect animal and never quite trustworthy in the dark."- HG Wells

Feb 20, 2006, 1:24 PM	#13 (permalink)
Greg Mad River Glen - 2/8/08 Join Date: Jul 2001 Location: Thomaston, CT Posts: 18,916	Still having some major stability issues. The database seemed to crash a few times already today. I think I may have it narrowed down to the script that pulls the post data from the forum and displays the recent discussion on the rest of the site. This same script also powers the News portal and trip report portals, as well as many of the RSS feeds. I've removed use of this script from every page I could. This hopefully will reduce the load on the database server. I am in touch with the script's author to rewrite it to make it more efficient. I guess, in a sense this is a good thing in that the site has become busy enough that it's maxing out the efficiency of some of the scripts and quite possibly phpBB. I think it may be time to pursue more stable forum software, i.e. vBulletin. A conversion would be a huge undertaking though so hopefully we can limp through the rest of the ski season and maybe convert over the slower summer months. __________________ Greg 2007-08, 2006-07, 2005-06, 2004-05 Life's too short for warm up runs.

Feb 21, 2006, 2:34 PM	#14 (permalink)
Greg Mad River Glen - 2/8/08 Join Date: Jul 2001 Location: Thomaston, CT Posts: 18,916	Still problems. I've disabled the News portal temporarily to pin down whether the scripting there is indeed causing the problems. Sorry for the inconvenience... __________________ Greg 2007-08, 2006-07, 2005-06, 2004-05 Life's too short for warm up runs.

Feb 21, 2006, 4:26 PM	#15 (permalink)
ctenidae Join Date: Nov 2004 Location: Boston Posts: 4,540	No worries, Greg. You might want to try crossconnecting the proton accelerator with the flux capacitor, and shunt the excess wattage through the dihydrogenmonoxide acidase inhibitor. If you can get it ramped up to one point twenty-one gigawatts, well, there's just no telling what you can do. As you might have noticed, my programming skillz are pretty much limited to ctrl-alt-dlt __________________ "Man is an imperfect animal and never quite trustworthy in the dark."- HG Wells

Feb 21, 2006, 6:01 PM	#17 (permalink)
Greg Mad River Glen - 2/8/08 Join Date: Jul 2001 Location: Thomaston, CT Posts: 18,916	There is a good chance that I am going to attempt a vBulletin conversion in the next few days. This will likely result in several hours of down time. I'll post an announcement if I decide to proceed here. __________________ Greg 2007-08, 2006-07, 2005-06, 2004-05 Life's too short for warm up runs.

Feb 22, 2006, 8:28 AM	#18 (permalink)
Catul Join Date: Dec 2005 Location: Avon, CT Posts: 157	Greg, sounds like you have a major undertaking on your hands over the next couple of days - good luck! Hope it all works out, I need my daily (or more) AlpineZone fix! EDIT: the forum is really flying this morning, looks like disabling the News script might have done the trick? Let's hope it lasts ...

Feb 22, 2006, 9:02 AM	#19 (permalink)
Greg Mad River Glen - 2/8/08 Join Date: Jul 2001 Location: Thomaston, CT Posts: 18,916	Working on importing to a test board now. Things are going VERY smoothly. I may upgrade the actual forum as soon as this morning. If the forums go down, you'll know what I'm doing... __________________ Greg 2007-08, 2006-07, 2005-06, 2004-05 Life's too short for warm up runs.

Feb 22, 2006, 9:05 AM	#20 (permalink)
Catul Join Date: Dec 2005 Location: Avon, CT Posts: 157	Hope you got a good backup - don't lose all the stuff here!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode