Forums

mysql max_user_connections

I'm getting the following error, sporadically but more often as of late:

OperationalError: (1226, "User 'rcardenas' has exceeded the 'max_user_connections' resource (current value: 5)")

Not sure why it's happening - perhaps my web2py model is pooling too many connections?

Is it possible to up my max_user_connections by a little, maybe up to 10?

I've done that, temporarily. It will expire at the next deploy though. In the meantime, have a look through your code for any places where you're not releasing connections properly? Every time we've seen this issue, it's been a resource leak due to untidy cleanup...