Openfire not showing client sessions ver3.7.0

Openfire Openfire Support
1

We restarted our Database server MSSQL 2005 a couple of time over the weekend for a Network Driver update, and have problems reported by openfire xmpp servers.

On the Openfire Server which is Windows 2008R2 STD edition x64 i do a netstat i can see multiple session on the Port, but the Sessions tab under Openfire reports 0 Client Connections.

Error log

Exception in thread “Thread-3” java.lang.NullPointerException

at org.jivesoftware.openfire.pep.IQPEPHandler.stopExecutor(IQPEPHandler.java:251)

at org.jivesoftware.openfire.pep.IQPEPHandler.stop(IQPEPHandler.java:211)

at org.jivesoftware.openfire.XMPPServer.shutdownServer(XMPPServer.java:948)

at org.jivesoftware.openfire.XMPPServer.access$700(XMPPServer.java:146)

at org.jivesoftware.openfire.XMPPServer$ShutdownHookThread.run(XMPPServer.java:898 )

2

Have you cycled Openfire after the database work? Are there any exceptions/stack traces related to the SQL driver on Openfire?

3

I have restart the XMPP Server and Service but has not helped i have a total of 19XMPP servers connecting to the SQL DB, and only 6 Servers are reporting the connection problems. This is the log from 1 Server

at org.eclipse.jetty.server.Dispatcher.include(Dispatcher.java:189)

at com.opensymphony.module.sitemesh.filter.PageFilter.applyDecorator(PageFilter.ja va:156)

at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:59)

at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.ja va:1187)

at org.jivesoftware.util.LocaleFilter.doFilter(LocaleFilter.java:74)

at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.ja va:1187)

at org.jivesoftware.util.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingF ilter.java:50)

at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.ja va:1187)

at org.jivesoftware.admin.PluginFilter.doFilter(PluginFilter.java:78)

at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.ja va:1187)

at org.jivesoftware.admin.AuthCheckFilter.doFilter(AuthCheckFilter.java:164)

at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.ja va:1187)

at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:425)

at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:119)

at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:494)

at org.eclipse.jetty.server.session.SessionHandler.handle(SessionHandler.java:182)

at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:93 3)

at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:362)

at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:867 )

at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117)

at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandler Collection.java:245)

at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.jav a:126)

at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:113)

at org.eclipse.jetty.server.Server.handle(Server.java:334)

at org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:559)

at org.eclipse.jetty.server.HttpConnection$RequestHandler.headerComplete(HttpConne ction.java:992)

at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:541)

at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:203)

at org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:406)

at org.eclipse.jetty.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:4 62)

at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:436)

at java.lang.Thread.run(Unknown Source)

Caused by: org.eclipse.jetty.io.EofException

at org.eclipse.jetty.http.HttpGenerator.flushBuffer(HttpGenerator.java:885)

at org.eclipse.jetty.http.AbstractGenerator.flush(AbstractGenerator.java:421)

at org.eclipse.jetty.server.HttpOutput.flush(HttpOutput.java:78)

at org.eclipse.jetty.server.HttpConnection$Output.flush(HttpConnection.java:1081)

at org.eclipse.jetty.server.HttpWriter.flush(HttpWriter.java:87)

at org.eclipse.jetty.io.UncheckedPrintWriter.flush(UncheckedPrintWriter.java:115)

… 49 more

Caused by: java.io.IOException: An existing connection was forcibly closed by the remote host

at sun.nio.ch.SocketDispatcher.writev0(Native Method)

at sun.nio.ch.SocketDispatcher.writev(Unknown Source)

at sun.nio.ch.IOUtil.write(Unknown Source)

at sun.nio.ch.SocketChannelImpl.write(Unknown Source)

at java.nio.channels.SocketChannel.write(Unknown Source)

at org.eclipse.jetty.io.nio.ChannelEndPoint.flush(ChannelEndPoint.java:237)

at org.eclipse.jetty.io.nio.SelectChannelEndPoint.flush(SelectChannelEndPoint.java :221)

at org.eclipse.jetty.http.HttpGenerator.flushBuffer(HttpGenerator.java:818)

… 54 more