Forum

This content is now out of date.

Visit Our Community

max_user_connections

Hi,

There is an error we very frequently get for exceeding the max connection.

Connection Failed Connection Failed
Error Message: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: User 'jp_yf_admin' has exceeded the 'max_user_connections' resource (current value: 30)

We have set Max user connection limit as 30 at data source level.

When we checked at the back end all connections are not open or active.Most of the connections are in sleep mode. I assume the application should automatically close those connection if they are in sleep.This is what is leading to exceed the user connection limit.

Even if we increase the limit of user connection the problem would surely persist.

Is there is any way we can avoid or close those connection which are not in use or in sleep mode?

Thanks,
Mala
Hello Mala,

Thank you for posting your question / issue on the forum.

This is an interesting one for sure. I've included the links
to two forum posts that are probably worth looking over.

DB Connections

Determining Closed Connections


Please let us know if any of this information proves helpful to
your present situation.

If not, we will continue to look into this for you.

Thank you,

Kyle

Thanks for trying Yellowfin

Please complete the form below to request your copy of Yellowfin today.