RRSPORT.CO.UK |
||
Forum Gallery Shop Sponsors |
Home · FAQ · New Posts · My Posts · PMs · Search · Members · Members Map · Calendar · Profile · Donate · Register · Log In |
Home > Site News & Feedback > Rangerovers.net's forum is down |
|
|
umbertob Member Since: 22 Sep 2005 Location: Pasadena, CA Posts: 944 |
Again. Ever since the upgrade from version 2.x.x to version 3 of the phpBB software (I believe those are the version numbers, not 100% sure as I was not involved in the upgrade, I am just a mod there...) we have had a couple of fairly long service disruptions, last week we were down for about 3 days and it has now been several hours of blackout again today. Martin, since you are obviously knowledgeable about this BB software although yours looks far more "customized" than the one in use at rr.net, do you think these outages are coincidental - server related perhaps - or due to possible bugs in the new software?
These outages seem to "start" overnight here in the US - surely when the number of hits is very low - so I don't think the real cause for these crashes would be too many visitors as the message above appears to imply, but I am far from being an expert. Just trying to help out the owner of rr.net in avoiding these outages in the future. Is rrsport.co.uk - as well as its "sister" web sites - running on the new forum software platform? Did you experience similar issues after upgrading? Any ideas or feedback would be appreciated, thanks a lot. |
||
Tue Jun 03 2008 9:29pm |
|
Martin Site Administrator & Owner Member Since: 26 May 2005 Location: Hook Norton Posts: 3662 |
Hi Umberto,
|
||
Tue Jun 03 2008 9:49pm |
|
Martin Site Administrator & Owner Member Since: 26 May 2005 Location: Hook Norton Posts: 3662 |
Don't forget that members are welcome on here and on fullfatrr.com Like this site? Buy some RRSPORT goodies to show your support! |
||
Tue Jun 03 2008 9:50pm |
|
Kaine Member Since: 26 May 2006 Location: Hills of Shropshire Posts: 8902 |
Martin is spot on - its an sql problem - I had the same issue with mytreg.com and mytiguan.com when I upgraded to phpbb 3.0 |
||
Tue Jun 03 2008 9:53pm |
|
umbertob Member Since: 22 Sep 2005 Location: Pasadena, CA Posts: 944 |
Thanks Martin, I'll pass this along to John. I'll hang out with you guys until they figure it out, hope you don't mind... I suddenly have all this free time in my hands, I don't know what to do with myself! |
||
Tue Jun 03 2008 9:56pm |
|
Martin Site Administrator & Owner Member Since: 26 May 2005 Location: Hook Norton Posts: 3662 |
How did you sort it Kaine? Like this site? Buy some RRSPORT goodies to show your support! |
||
Tue Jun 03 2008 9:59pm |
|
Kaine Member Since: 26 May 2006 Location: Hills of Shropshire Posts: 8902 |
just checked my emails with my server host - he had to change the mysql config to 'allow persistant connections' |
||
Tue Jun 03 2008 10:00pm |
|
Kaine Member Since: 26 May 2006 Location: Hills of Shropshire Posts: 8902 |
Martin - to be honest I dont fully know what Richy did, but I will ask him |
||
Tue Jun 03 2008 10:02pm |
|
umbertob Member Since: 22 Sep 2005 Location: Pasadena, CA Posts: 944 |
Thanks Kaine, I'll be watching this thread in case you get any more info from your tech guy. So, the settings were changed from "Disallow" to "Allow" persistent connections? |
||
Tue Jun 03 2008 10:17pm |
|
Kaine Member Since: 26 May 2006 Location: Hills of Shropshire Posts: 8902 |
yep - it seems some hosts default their settings to disallow persistant connections for security and bandwidth issues. I believe its a one line item in server mysql config files, but I'm not 100% sure |
||
Tue Jun 03 2008 10:19pm |
|
shmoogle Member Since: 07 Sep 2005 Location: ... and for every sprinkle I find, I shall kill you! Posts: 24350 |
It could be this isn't actually an issue in MySQL, but more an issue in the PHP database connection logic. Theory says create a connection to the db, operate across it, close it and thus release resources back to the pool. If the PHP MySQL libraries or the code in phpBB that calls them isn't managing the connections properly, the database resources simply get chewed up and never released. I'm not a MySQL expert but in application development generally, persistent connections are normally set for performance reasons (i.e. to increase performance of apps that have high, constant database use where the creation of connections has an impact on response) but this brings with it it's own set of caveats... so only allow them if you're aware of the consequences
|
||
Wed Jun 04 2008 12:25pm |
|
Very Annoyed Site Moderator Member Since: 23 Aug 2005 Location: bat-wielding monkey-spanking tough-love zero-tolerance Euro-sceptic moderator - So just watch it! Posts: 19459 |
You took the words out of my mouth! 2005 Zambezi TDV6 - Gone but not forgotten 2009 Alaska TDV8 - Gone and much missed. WINNER - 2009 �Idler Of The Year� Award Runner Up - 2009 �Just Doing What It�s Designed To Do� Award DO NOT CLICK HERE! |
||
Wed Jun 04 2008 12:28pm |
|
shmoogle Member Since: 07 Sep 2005 Location: ... and for every sprinkle I find, I shall kill you! Posts: 24350 |
Anything to shut you up
|
||
Wed Jun 04 2008 12:32pm |
|
Pelyma Member Since: 28 Sep 2005 Location: Sussex Posts: 1497 |
Porsche Cayenne S Diesel 66 Plate |
||
Wed Jun 04 2008 2:37pm |
|
umbertob Member Since: 22 Sep 2005 Location: Pasadena, CA Posts: 944 |
I was browsing the phpbb 3.0 support forum last night. There are tons of similar instances reported, apparently the server host does indeed need to get involved and make changes into its settings to "play nice" with the new bb version. Basically, phpbb2 uses one connection, over and over again. phpbb3 makes a connection, and when the pages finish loading (sent to browser of user) it closes the connection. That's where the problem starts.
|
||
Wed Jun 04 2008 3:13pm |
|
|
All times are GMT |
< Previous Topic | Next Topic > |
Posting Rules
|
Site Copyright © 2005-2024 Futuranet Ltd & Martin Lewis