powered by Jive Software

Java Heap Space Error - User Summary List

Hi all,

i have a issue on my latest Openfire Installation. I have 750,000 Users on my system and i clicked the entry in the dropdown menp “List all” Users. Now every time i open the User Summary i get after 1-2 Minutes the response from the Browser Java Heap Space error.

I have restarted the server but still the same. Openfire still runs.

What can i do to get rid of that failure?

I’m running Ubuntu 12.04.

Java Oracle 64Bit

Log

org.jivesoftware.database.DbConnectionManager - Packet for query is too large (7670028 > 4194304). You can change this value on the server by setting the max_allowed_packet’ variable.

com.mysql.jdbc.PacketTooBigException: Packet for query is too large (7670028 > 4194304). You can change this value on the server by setting the max_allowed_packet’ variable.

I made this changes on the DB.

Browser Output

HTTP ERROR 500

Problem accessing /user-summary.jsp. Reason:

Java heap space

Caused by:

java.lang.OutOfMemoryError: Java heap space at java.util.Arrays.copyOf(Arrays.java:2367) at java.io.CharArrayWriter.write(CharArrayWriter.java:105) at java.io.PrintWriter.write(PrintWriter.java:426) at com.opensymphony.module.sitemesh.filter.RoutablePrintWriter.write(RoutablePrintWriter.java:144) at org.apache.jasper.runtime.JspWriterImpl.flushBuffer(JspWriterImpl.java:118) at org.apache.jasper.runtime.JspWriterImpl.write(JspWriterImpl.java:325) at org.apache.jasper.runtime.JspWriterImpl.write(JspWriterImpl.java:341) at org.jivesoftware.openfire.admin.user_002dsummary_jsp._jspService(user_002dsummary_jsp.java:384) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:547) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1359) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:118) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1330) at org.jivesoftware.util.LocaleFilter.doFilter(LocaleFilter.java:74) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1330) at org.jivesoftware.util.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:50) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1330) at org.jivesoftware.admin.PluginFilter.doFilter(PluginFilter.java:78) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1330) at org.jivesoftware.admin.AuthCheckFilter.doFilter(AuthCheckFilter.java:164) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1330) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:478) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:119) at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:520) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:227) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:941) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:409) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:186) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:875) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117)

Thank you!

Ok i could solve it. I accessed the User Summary Page over a modified Link.

https://domain:9091/user-summary.jsp?start=0&range=1000

Now it works again, but i tried to access the Admin-Page over different Browser and cleaned Cache. Openfire caches the last search query till he can deliever results. Even if you restart him he starts to to query “List all users” again. Looks like a bug.

Thanks

Was it cached in a cookie? Which cache did you clear? I wonder where OF can store the range value if not in a client cookie.

OF-768

Hi,

i used Safari and i made a “reset”. Cookies and Temp files are cleaned too with this option.

I dont want to reproduce that failure again :slight_smile: