6 Replies Latest reply on Jan 23, 2017 11:44 AM by Guus der Kinderen

    MySQL connection pool problems in 4.1.1

    Jindrich Sarson

      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