Spark 2.5.8 Sudden Disconnects

Hi all,

We are running Openfile 3.6.4 and Spark 2.5.8…over the last couple of weeks the Spark server drops all the connections to it. You can log back into the app without any issues, but users are starting to complain about it.

I’ve not been able to determine what could be causing this issue:

System specs: Win2k3 w/ sp2, 3GB Ram, plenty of disk space

Has anyone else had this odd random behavior before?

Here is some info from the logs that might help:

2010.08.02 08:56:32 Unable to get a connection from the database pool (attempt 1 out of 10).
java.sql.SQLException: We are already in the process of making 11 connections and the number of simultaneous builds

has been throttled to 10
at org.logicalcobwebs.proxool.Prototyper.checkSimultaneousBuildThrottle(Prototyper .java:260)
at org.logicalcobwebs.proxool.ConnectionPool.getConnection(ConnectionPool.java:164 )
at org.logicalcobwebs.proxool.ProxoolDriver.connect(ProxoolDriver.java:89)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.jivesoftware.database.DefaultConnectionProvider.getConnection(DefaultConnec tionProvider.java:75)
at org.jivesoftware.database.DbConnectionManager.getConnection(DbConnectionManager .java:104)
at org.jivesoftware.openfire.roster.RosterItemProvider.getItems(RosterItemProvider .java:272)
at org.jivesoftware.openfire.roster.Roster.(Roster.java:110)
at org.jivesoftware.openfire.roster.RosterManager.getRoster(RosterManager.java:86)
at org.jivesoftware.openfire.handler.PresenceUpdateHandler.broadcastUpdate(Presenc eUpdateHandler.java:282)
at org.jivesoftware.openfire.handler.PresenceUpdateHandler.process(PresenceUpdateH andler.java:137)
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.sendError(HttpBindServlet.java:1 93)
at org.jivesoftware.openfire.http.HttpBindServlet.handleSessionRequest(HttpBindSer vlet.java:233)
at org.jivesoftware.openfire.http.HttpBindServlet.parseDocument(HttpBindServlet.ja va:151)
at org.jivesoftware.openfire.http.HttpBindServlet.doPost(HttpBindServlet.java:120)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:362)
at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:726)
at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollect ion.java:206)
at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114)
at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
at org.mortbay.jetty.Server.handle(Server.java:324)
at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:505)
at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:843 )
at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:648)
at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:205)
at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:380)
at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:395)
at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:488)
2010.08.02 08:56:42 Packet sent to unreachable address



2010.08.02 08:56:42 Packet sent to unreachable address



2010.08.02 08:56:42 Packet sent to unreachable address



2010.08.02 08:56:42 Packet sent to unreachable address


This is about when the issue happen today.

Hi,

stop Openfire, and set database.defaultProvider.maxConnections to 20 in openfire.xml and start it again.

LG

Hi LG,

Thanks for the response…if I’m reading the config file correctly…I don’t see a field “database.defaultProvider.maxConnections”. I do see “25”…

Hi,

in the xml file it’s indeed - anyhow if there the value 25 is set then I really wonder why you get “We are already in the process of making 11 connections and the number of simultaneous builds has been throttled to 10”. I assume that you did restart Openfire already, so does http://yourserver:9090/server-db.jsp display 10 or 25 for “Maximum Connections”?

LG

Hey,

Yes this system has been rebooted. I’m showing 0 (active), 10 (available), 25 (max) on that page.

Hi Adam,

I did re-read the message “We are already in the process of making 11 connections and the number of simultaneous builds has been throttled to 10” and this seems to be a proxool default (simultaneous-build-throttle). So your database pool did try to create 11 connections within a few seconds. Do you monitor your database server? I guess that it had some performance problems.

LG