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.