Hi,
I just upgraded to 4.1.1 and immediately after startup the problems with MySQL connection pool begins. All 50 connections in pool are used according to Connection pool info in few seconds and 0 available connections became permanent. This results into unavailability to connect by any user.
When downgrade to 4.0.4, everything works fine.
Tried with both Java 7 and Java 8.
Logs:
2017.01.03 16:39:06 org.jivesoftware.openfire.auth.DefaultAuthProvider - User SQL failure:
java.sql.SQLException: ConnectionManager.getConnection() failed to obtain a connection after 11 retries. The exception from the last attempt is as follows: java.sql.SQLException: Couldn’t get connection because we are at maximum connection count (50/50) and there are none available
at org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager .java:156)
at org.jivesoftware.openfire.auth.DefaultAuthProvider.getUserInfo(DefaultAuthProvi der.java:89)
at org.jivesoftware.openfire.auth.DefaultAuthProvider.getUserInfo(DefaultAuthProvi der.java:119)
at org.jivesoftware.openfire.auth.DefaultAuthProvider.getUserInfo(DefaultAuthProvi der.java:119)
at org.jivesoftware.openfire.auth.DefaultAuthProvider.getUserInfo(DefaultAuthProvi der.java:119)
at org.jivesoftware.openfire.auth.DefaultAuthProvider.getUserInfo(DefaultAuthProvi der.java:119)
at org.jivesoftware.openfire.auth.DefaultAuthProvider.getUserInfo(DefaultAuthProvi der.java:119)
at org.jivesoftware.openfire.auth.DefaultAuthProvider.getUserInfo(DefaultAuthProvi der.java:119)
at org.jivesoftware.openfire.auth.DefaultAuthProvider.getUserInfo(DefaultAuthProvi der.java:119)
at org.jivesoftware.openfire.auth.DefaultAuthProvider.getUserInfo(DefaultAuthProvi der.java:119)
at org.jivesoftware.openfire.auth.DefaultAuthProvider.getUserInfo(DefaultAuthProvi der.java:119)
at org.jivesoftware.openfire.auth.DefaultAuthProvider.getUserInfo(DefaultAuthProvi der.java:119)
at org.jivesoftware.openfire.auth.DefaultAuthProvider.getUserInfo(DefaultAuthProvi der.java:119)
at org.jivesoftware.openfire.auth.DefaultAuthProvider.getUserInfo(DefaultAuthProvi der.java:119)
at org.jivesoftware.openfire.auth.DefaultAuthProvider.getUserInfo(DefaultAuthProvi der.java:119)
at org.jivesoftware.openfire.auth.DefaultAuthProvider.getUserInfo(DefaultAuthProvi der.java:119)
Any idea how to fix this?
Thanks,
Jindrich