RRSPORT.CO.UK

    Forum   Gallery   Shop   Sponsors
Home > Site News & Feedback > Rangerovers.net's forum is down
Post Reply  Down to end
Page 1 of 2 12>
 
umbertob



Member Since: 22 Sep 2005
Location: Pasadena, CA
Posts: 944

United States 2006 Range Rover Sport 4.4 V8 HSE Chawton White
Rangerovers.net's forum is down

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?

The error message is the same each time if you try to connect to http://rangerovers.net/forum/index.php (quoting it below in case the site goes back on line):

Quote:
General Error

SQL ERROR [ mysql4 ]

User ranger4_xmb1 already has more than 'max_user_connections' active connections [1203]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.


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. 

Post #171482 Tue Jun 03 2008 9:29pm
View user's profile Send private message View poster's gallery Reply with quote
Martin
Site Administrator & Owner


Member Since: 26 May 2005
Location: Hook Norton
Posts: 3662

United Kingdom 

Hi Umberto,

RRSPORT (and the other sites) are still running phpBB version 2, mainly because I've customised it so much it's not simply a case of upgrading to a new version as they did on Rangerovers.net

Sounds like the added complexity of phpBB might causing an overload of the MySQL server. Not sure why it's related to being overnight, but it might be a backup script of some kind causing the database to fall over. Like this site? Buy some RRSPORT goodies to show your support!

Post #171486 Tue Jun 03 2008 9:49pm
View user's profile Send private message View poster's gallery Send e-mail Reply with quote
Martin
Site Administrator & Owner


Member Since: 26 May 2005
Location: Hook Norton
Posts: 3662

United Kingdom 

Don't forget that members are welcome on here and on fullfatrr.com Very Happy Like this site? Buy some RRSPORT goodies to show your support!

Post #171488 Tue Jun 03 2008 9:50pm
View user's profile Send private message View poster's gallery Send e-mail Reply with quote
Kaine



Member Since: 26 May 2006
Location: Hills of Shropshire
Posts: 8902

United Kingdom 

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

Post #171489 Tue Jun 03 2008 9:53pm
View user's profile Send private message View poster's gallery Reply with quote
umbertob



Member Since: 22 Sep 2005
Location: Pasadena, CA
Posts: 944

United States 2006 Range Rover Sport 4.4 V8 HSE Chawton White

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... Laughing I suddenly have all this free time in my hands, I don't know what to do with myself! 

Post #171490 Tue Jun 03 2008 9:56pm
View user's profile Send private message View poster's gallery Reply with quote
Martin
Site Administrator & Owner


Member Since: 26 May 2005
Location: Hook Norton
Posts: 3662

United Kingdom 

Kaine wrote:
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

How did you sort it Kaine? Like this site? Buy some RRSPORT goodies to show your support!

Post #171491 Tue Jun 03 2008 9:59pm
View user's profile Send private message View poster's gallery Send e-mail Reply with quote
Kaine



Member Since: 26 May 2006
Location: Hills of Shropshire
Posts: 8902

United Kingdom 

just checked my emails with my server host - he had to change the mysql config to 'allow persistant connections'

Post #171492 Tue Jun 03 2008 10:00pm
View user's profile Send private message View poster's gallery Reply with quote
Kaine



Member Since: 26 May 2006
Location: Hills of Shropshire
Posts: 8902

United Kingdom 

Martin - to be honest I dont fully know what Richy did, but I will ask him

Post #171493 Tue Jun 03 2008 10:02pm
View user's profile Send private message View poster's gallery Reply with quote
umbertob



Member Since: 22 Sep 2005
Location: Pasadena, CA
Posts: 944

United States 2006 Range Rover Sport 4.4 V8 HSE Chawton White

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? 

Post #171494 Tue Jun 03 2008 10:17pm
View user's profile Send private message View poster's gallery Reply with quote
Kaine



Member Since: 26 May 2006
Location: Hills of Shropshire
Posts: 8902

United Kingdom 

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

Post #171495 Tue Jun 03 2008 10:19pm
View user's profile Send private message View poster's gallery Reply with quote
shmoogle



Member Since: 07 Sep 2005
Location: ... and for every sprinkle I find, I shall kill you!
Posts: 24350

United Kingdom 

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 Very Happy 

2009 Outstanding Contribution Award - Joint Runner Up
2009 'Tech-Head Of The Year' Award - Runner Up


Like it here? Then Donate to RRSPORT!!

Post #171561 Wed Jun 04 2008 12:25pm
View user's profile Send private message View poster's gallery Reply with quote
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

United Kingdom 

shmoogle wrote:
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 Very Happy


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!

Post #171562 Wed Jun 04 2008 12:28pm
View user's profile Send private message View poster's gallery Reply with quote
shmoogle



Member Since: 07 Sep 2005
Location: ... and for every sprinkle I find, I shall kill you!
Posts: 24350

United Kingdom 

Anything to shut you up Wink 

2009 Outstanding Contribution Award - Joint Runner Up
2009 'Tech-Head Of The Year' Award - Runner Up


Like it here? Then Donate to RRSPORT!!

Post #171564 Wed Jun 04 2008 12:32pm
View user's profile Send private message View poster's gallery Reply with quote
Pelyma



Member Since: 28 Sep 2005
Location: Sussex
Posts: 1497

England 

Thumbs Up Porsche Cayenne S Diesel 66 Plate

Post #171589 Wed Jun 04 2008 2:37pm
View user's profile Send private message View poster's gallery Reply with quote
umbertob



Member Since: 22 Sep 2005
Location: Pasadena, CA
Posts: 944

United States 2006 Range Rover Sport 4.4 V8 HSE Chawton White

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.

Bottom line is, rr.net is still down. Sad I think you are being wise to stick to v.2, Martin... Thank you all for your feedback. 

Post #171593 Wed Jun 04 2008 3:13pm
View user's profile Send private message View poster's gallery Reply with quote
Post Reply  Back to top
Page 1 of 2 12>
All times are GMT

Jump to  
Previous Topic | Next Topic >
Posting Rules
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Site Copyright © 2005-2024 Futuranet Ltd & Martin Lewis
RRSPORT.CO.UK RSS Feed - All Forums

Switch to Mobile site