XF 1.4 Unexpected database error - too many connections

[MarkMark]

What I don't understand is that this is happening when I have either one or no users online (we are a very small board).

Any idea why?

 

[Brogan]

It's a limit imposed by your host so you would need to contact them and ask them to increase the limit.

 

[MarkMark]

It's a limit imposed by your host so you would need to contact them and ask them to increase the limit.

Even if I don't actually have anyone online? Also, if I look at the server error log, there is nothing there?

 

[Brogan]

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.

 

[MarkMark]

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.

 

[MarkMark]

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?

 

[Brogan]

It's an error connecting to the mysql server, so occurs before the XF code runs.

 

[Wesker]

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]

@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).