Hi,
Sorry for poor English, I am from China.
We use CMwildfire 3.0.1sqlserver
Configuration 3 machine all 4G memory 2CPU
wildfire to Database Connection pool setting: 50
Normally wildfire would keep about 15 connections with database, however when concurrent users surpass 300-500, at some time,the DB connection would hit the maximum 50 immediately, all connections are sleep and wildserver would not respond to any new connection anymore. Database server is OK, the problem is wildfire.
We have chat internal plugins and some content external plugins. content plugin would access database quite frequently.
We have checked all SQLs ,seems no problem.
I am doubting whether there is any bug in wildfire connection pool?
Could anyone help ?
Here is the traceLog:
2006.11.10 14:31:28 org.jivesoftware.wildfire.roster.RosterItemProvider.getItems(RosterItemProvider. java:398)
com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:
- BEGIN NESTED EXCEPTION **
java.net.SocketException
MESSAGE: java.net.ConnectException: Connection refused
STACKTRACE:
java.net.SocketException: java.net.ConnectException: Connection refused
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:156)
at com.mysql.jdbc.MysqlIO.(Roster.java:101)
at org.jivesoftware.wildfire.roster.RosterManager.getRoster(RosterManager.java:94)
at org.jivesoftware.wildfire.handler.PresenceUpdateHandler.broadcastUpdate(Presenc eUpdateHandler.java:291)
at org.jivesoftware.wildfire.handler.PresenceUpdateHandler.process(PresenceUpdateH andler.java:127)
at org.jivesoftware.wildfire.handler.PresenceUpdateHandler.process(PresenceUpdateH andler.java:183)
at org.jivesoftware.wildfire.SessionManager$ClientSessionListener.onConnectionClos e(SessionManager.java:1460)
at org.jivesoftware.wildfire.net.VirtualConnection.notifyCloseListeners(VirtualCon nection.java:147)
at org.jivesoftware.wildfire.net.VirtualConnection.close(VirtualConnection.java:12 1)
at org.jivesoftware.wildfire.handler.IQAuthHandler.login(IQAuthHandler.java:214)
at org.jivesoftware.wildfire.handler.IQAuthHandler.handleIQ(IQAuthHandler.java:155 )
at org.jivesoftware.wildfire.handler.IQHandler.process(IQHandler.java:48)
at org.jivesoftware.wildfire.IQRouter.handle(IQRouter.java:268)
at org.jivesoftware.wildfire.IQRouter.route(IQRouter.java:96)
at org.jivesoftware.wildfire.spi.PacketRouterImpl.route(PacketRouterImpl.java:67)
at org.jivesoftware.wildfire.multiplex.MultiplexerPacketHandler.processIQ(Multiple xerPacketHandler.java:201)
at org.jivesoftware.wildfire.multiplex.MultiplexerPacketHandler.route(MultiplexerP acketHandler.java:174)
at org.jivesoftware.wildfire.net.ConnectionMultiplexerSocketReader$2.run(Connectio nMultiplexerSocketReader.java:149)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
- END NESTED EXCEPTION **