In my openfire database, maximum number of sql connection is 25,When I checked packet statics I found that when packet per minute is 1689 and active conversation is :322, total 25 max connection is consumed.
After that when I checked openfire logs, in the admin console of openfire–Info tab ,I got following stuff.
2009.08.19 05:39:24 Unable to get a connection from the database pool (attempt 7 out of 10).
java.sql.SQLException: Couldn’t get connection because we are at maximum connection count (25/25) and there are none available
at org.logicalcobwebs.proxool.Prototyper.quickRefuse(Prototyper.java:309)
at org.logicalcobwebs.proxool.ConnectionPool.getConnection(ConnectionPool.java:152 )
at org.logicalcobwebs.proxool.ProxoolDriver.connect(ProxoolDriver.java:89)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:154)
at org.jivesoftware.database.DefaultConnectionProvider.getConnection(DefaultConnec tionProvider.java:75)
at org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager .java:104)
at org.jivesoftware.openfire.spi.PresenceManagerImpl.userUnavailable(PresenceManag erImpl.java:258)
at org.jivesoftware.openfire.handler.PresenceUpdateHandler.process(PresenceUpdateH andler.java:145)
at org.jivesoftware.openfire.handler.PresenceUpdateHandler.process(PresenceUpdateH andler.java:112)
at org.jivesoftware.openfire.handler.PresenceUpdateHandler.process(PresenceUpdateH andler.java:176)
at org.jivesoftware.openfire.PresenceRouter.handle(PresenceRouter.java:134)
at org.jivesoftware.openfire.PresenceRouter.route(PresenceRouter.java:70)
at org.jivesoftware.openfire.spi.PacketRouterImpl.route(PacketRouterImpl.java:76)
at org.jivesoftware.openfire.SessionManager$ClientSessionListener.onConnectionClos e(SessionManager.java:1133)
at org.jivesoftware.openfire.net.VirtualConnection.notifyCloseListeners(VirtualCon nection.java:203)
at org.jivesoftware.openfire.net.VirtualConnection.close(VirtualConnection.java:17 9)
at org.jivesoftware.openfire.http.HttpSession.close(HttpSession.java:173)
at org.jivesoftware.openfire.http.HttpBindServlet.handleSessionRequest(HttpBindSer vlet.java:246)
at org.jivesoftware.openfire.http.HttpBindServlet.parseDocument(HttpBindServlet.ja va:151)
at org.jivesoftware.openfire.http.HttpBindServlet.doPost(HttpBindServlet.java:120)
So to handle around 5000 active conversation, how much max connection should I use??
Some times I found that while chatting with users, I suddenly get disconnected from openfire server (i.e openfire return stream error.)
Can I know that , is it happening for this connection issue.