• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

XF 1.4 Unexpected database error - too many connections

Brogan

XenForo moderator
Staff member
#2
It's a limit imposed by your host so you would need to contact them and ask them to increase the limit.
 

Brogan

XenForo moderator
Staff member
#4
Guests and bots will also count.

If you are seeing that with no registered members online, the limit must be very low.

Only your host can resolve it.
 
#5
Guests and bots will also count.

If you are seeing that with no registered members online, the limit must be very low.

Only your host can resolve it.
Ok, thanks. Haven't had any issues until today, and have had lots online at the same time before. Will speak to host.
 
#6
Guests and bots will also count.

If you are seeing that with no registered members online, the limit must be very low.

Only your host can resolve it.
Sorry to be a pain but just a quick question.

My host is looking into the problem, but what confuses me is that, despite the errors, nothing shows up in my error log in the admin area - shouldn't there be some detail in here?
 

Wesker

Well-known member
#8
We also had this issue frequently on our old server. We had to restart mySQL through SSH but it's never recommended to restart mySQL unless you have no choice as it can cause a table to be corrupt upon mySQL restarting.
 

Jeremy P

Well-known member
#9
@Wesker, this is controlled by the MySQL 'max_connections' setting. If you are running your own server, you can raise this value if the current value is troublesome. However, OP is using a shared/managed host, so that isn't relevant.

Additionally, it is possible to shutdown/restart MySQL gracefully. I've only ever seen corruption from killing it unexpectedly (ie via killall or OOM).