XF 2.2 504 Gateway Time-out on Forum Nodes

[Shane Greer]

Hi folks

Looking for some help.

My forum nodes when clicked on give me a 504 time out but when I enter via last ppost, new posts etc it works fine... any ideas what the problem could be

Thanks

Shane

 

[Paul B]

No problems here.

I just clicked on various nodes, threads, etc. and they all loaded fairly quickly.

 

[Shane Greer]

No problems here.

I just clicked on various nodes, threads, etc. and they all loaded fairly quickly.

Yeah its this site here...

Oops! We ran into some problems.

They work fine if not logged in... but as soon as you log in they throw up 504's.

Hmmmm.

 

[Paul B]

Most likely an add-on or other customisation involved which is available to logged in members only.

 

[Shane Greer]

Ok I tried to disable a couple of plug ins and now Im getting this.

An unexpected database error occurred. Please try again later.

Page source shows

<!-- User already has more than 'max_user_connections' active connections -->

 

[Paul B]

That's a server limitation.

Your host will need to increase the value.

 

[Shane Greer]

Rectified itself but still having a 504 when clicking on the main nodes... have turned all the addons off... wasnt that many and it made no difference. Might try it on a default theme to see if thats the issue.

 

[Shane Greer]

Oh me... contacted my hosts about the max user connections who state...

Thank you for your response.

In regards to a solution, sadly we cannot look in to this for you as this is down to the behaviour and functions of the script which is beyond support.
In basic terms, every amendment to the database requires a connection to be made. These connections should be opened, amendment made and then closed. Even if a user is using the forum, the site should be coded as to not be leaving a connection open. It indicates to me that the forum is not killing the open connections in a timely manner, which is resulting in the multiple connections stacking up and resulting in new connections not being made.

In this instance, you would need to approach the forum supplier in regards to what can be done in closing the connections in a timely manner.

Thanks again for contacting us.

-------------------------------------------

My xenforo forum doesnt even have that many folk using it.

Where do I go from here... anyone have a good suggestion for new hosts?

Thanks

Shane

 

[Ozzy47]

Definitely get a new host.

 

[Old Nick]

Where do I go from here... anyone have a good suggestion for new hosts?

It depends on your budget but you can think of XF Cloud for example.

 

[Shane Greer]

I have had the same hosts sine 2010 and yeah have had a few hiccups along the way - thing is my forum isnt very big. All my other sites are working (powered by wordpress) its just Im getting a max user error on the 504 for my xenforo home nodes. If I log out I can whizz around like nobodies business no errors. All my members are getting the same error when logged in. It only started happening this morning.

 

[TPerry]

I have had the same hosts sine 2010 and yeah have had a few hiccups along the way - thing is my forum isnt very big. All my other sites are working (powered by wordpress) its just Im getting a max user error on the 504 for my xenforo home nodes. If I log out I can whizz around like nobodies business no errors. All my members are getting the same error when logged in. It only started happening this morning.

Errr... if you have several sites on one hosting (shared) and they have a cap on the number of mySQL connections.. that limit normally applies for ALL sites... not each specific site. So you may want to check into that.