<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
<!DOCTYPE bugzilla SYSTEM "https://jogamp.org/bugzilla/page.cgi?id=bugzilla.dtd">

<bugzilla version="5.2"
          urlbase="https://jogamp.org/bugzilla/"
          
          maintainer="sgothel@jausoft.com"
>

    <bug>
          <bug_id>762</bug_id>
          
          <creation_ts>2013-06-23 11:41:39 +0200</creation_ts>
          <short_desc>Too many users on the JogAmp Nabble forum; forum needs replacement</short_desc>
          <delta_ts>2019-03-29 17:54:46 +0100</delta_ts>
          <reporter_accessible>1</reporter_accessible>
          <cclist_accessible>1</cclist_accessible>
          <classification_id>1</classification_id>
          <classification>General</classification>
          <product>Default</product>
          <component>default</component>
          <version>2.3.0</version>
          <rep_platform>All</rep_platform>
          <op_sys>all</op_sys>
          <bug_status>RESOLVED</bug_status>
          <resolution>DUPLICATE</resolution>
          <dup_id>1095</dup_id>
          
          <bug_file_loc></bug_file_loc>
          <status_whiteboard></status_whiteboard>
          <keywords></keywords>
          <priority>---</priority>
          <bug_severity>enhancement</bug_severity>
          <target_milestone>---</target_milestone>
          
          
          <everconfirmed>0</everconfirmed>
          <reporter name="Xerxes Rånby">xerxes</reporter>
          <assigned_to name="Sven Gothel">sgothel</assigned_to>
          
          
          <cf_type>---</cf_type>
          <cf_scm_refs></cf_scm_refs>
          <cf_workaround>---</cf_workaround>

      

      

      

          <comment_sort_order>oldest_to_newest</comment_sort_order>  
          <long_desc isprivate="0" >
    <commentid>2708</commentid>
    <comment_count>0</comment_count>
    <who name="Xerxes Rånby">xerxes</who>
    <bug_when>2013-06-23 11:41:39 +0200</bug_when>
    <thetext>The Nabble forum server are frequently overloaded:
Error 500&apos; are now common: Oops... An error has occurred
Caused by: org.postgresql.util.PSQLException: FATAL: sorry, too many clients already
Test URL:
http://forum.jogamp.org/Java3D-crash-intel-4000-tp4029426.html

Output:
Error 500

url=http://forum.jogamp.org/Java3D-crash-intel-4000-tp4029426.html  method=GET user-agent=Mozilla/5.0 (X11; Ubuntu; Linux i686; rv:21.0) Gecko/20100101 Firefox/21.0 referer=http://t.co/3YA6cHZKj4 remote=37.197.24.45

Message: key = 66646

RequestURI: /Java3D-crash-intel-4000-tp4029426.html

Server: n3.nabble.com
Caused by:

fschmidt.util.servlet.JtpContextServlet$JtpRuntimeException: url=http://forum.jogamp.org/Java3D-crash-intel-4000-tp4029426.html  method=GET user-agent=Mozilla/5.0 (X11; Ubuntu; Linux i686; rv:21.0) Gecko/20100101 Firefox/21.0 referer=http://t.co/3YA6cHZKj4 remote=37.197.24.45
	at fschmidt.util.servlet.JtpContextServlet.handleException(JtpContextServlet.java:559)
	at fschmidt.util.servlet.JtpContextServlet.service2(JtpContextServlet.java:463)
	at fschmidt.util.servlet.JtpContextServlet.service(JtpContextServlet.java:332)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
	at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:565)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1360)
	at org.eclipse.jetty.servlets.UserAgentFilter.doFilter(UserAgentFilter.java:77)
	at org.eclipse.jetty.servlets.GzipFilter.doFilter(GzipFilter.java:144)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1331)
	at cachingfilter.CachingFilter.doFilter(CachingFilter.java:133)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1331)
	at fschmidt.util.servlet.BadBotFilter.doFilter(BadBotFilter.java:74)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1331)
	at fschmidt.util.servlet.ConnectionLimitFilter.doFilter(ConnectionLimitFilter.java:94)
	at nabble.view.lib.NabbleConnectionLimitFilter.doFilter(NabbleConnectionLimitFilter.java:26)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1331)
	at nabble.view.lib.NabbleErrorFilter.doFilter(NabbleErrorFilter.java:21)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1331)
	at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:477)
	at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:225)
	at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1031)
	at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:406)
	at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:186)
	at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:965)
	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117)
	at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:250)
	at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:149)
	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:111)
	at org.eclipse.jetty.server.Server.handle(Server.java:349)
	at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:449)
	at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.headerComplete(AbstractHttpConnection.java:910)
	at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:634)
	at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:230)
	at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:76)
	at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:609)
	at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:45)
	at nabble.model.Executors$1$1.run(Executors.java:27)
	at fschmidt.util.executor.ThreadTimer$1.run(ThreadTimer.java:18)
	at fschmidt.util.executor.AbstractThreadPool$1.run(AbstractThreadPool.java:29)
	at java.lang.Thread.run(Thread.java:722)
Caused by: fschmidt.db.SQLRuntimeException: key = 66646
	at fschmidt.db.base.DbTableImpl.findByPrimaryKey(DbTableImpl.java:80)
	at fschmidt.db.cache.DbTableImpl.findByPrimaryKey(DbTableImpl.java:135)
	at nabble.model.UserImpl.getUser(UserImpl.java:402)
	at nabble.model.NodeImpl.getOwnerImpl(NodeImpl.java:1009)
	at nabble.model.NodeImpl.getOwner(NodeImpl.java:1015)
	at nabble.view.lib.NabbleErrorHandler.writeMyErrorPage(NabbleErrorHandler.java:78)
	at nabble.view.lib.NabbleErrorHandler.writeErrorPage(NabbleErrorHandler.java:51)
	at org.eclipse.jetty.server.handler.ErrorHandler.handleErrorPage(ErrorHandler.java:68)
	at org.eclipse.jetty.server.handler.ErrorHandler.handle(ErrorHandler.java:57)
	at nabble.view.lib.NabbleErrorHandler.handle(NabbleErrorHandler.java:31)
	at org.eclipse.jetty.server.Response.sendError(Response.java:331)
	at org.eclipse.jetty.server.Response.sendError(Response.java:399)
	at javax.servlet.http.HttpServletResponseWrapper.sendError(HttpServletResponseWrapper.java:128)
	at cachingfilter.CachingResponseWrapper.sendError(CachingResponseWrapper.java:322)
	at javax.servlet.http.HttpServletResponseWrapper.sendError(HttpServletResponseWrapper.java:128)
	at org.eclipse.jetty.http.gzip.GzipResponseWrapper.sendError(GzipResponseWrapper.java:296)
	at javax.servlet.http.HttpServletResponseWrapper.sendError(HttpServletResponseWrapper.java:128)
	at fschmidt.util.servlet.JtpContextServlet$5.sendError(JtpContextServlet.java:311)
	at javax.servlet.http.HttpServletResponseWrapper.sendError(HttpServletResponseWrapper.java:128)
	at nabble.view.web.forum.Permalink.sendToTopicPage(Permalink.java:111)
	at nabble.view.web.forum.Permalink.service(Permalink.java:102)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
	at fschmidt.util.servlet.JtpContextServlet.service2(JtpContextServlet.java:461)
	... 38 more
Caused by: org.postgresql.util.PSQLException: FATAL: sorry, too many clients already
	at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:293)
	at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:108)
	at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)
	at org.postgresql.jdbc2.AbstractJdbc2Connection.&lt;init&gt;(AbstractJdbc2Connection.java:125)
	at org.postgresql.jdbc3.AbstractJdbc3Connection.&lt;init&gt;(AbstractJdbc3Connection.java:30)
	at org.postgresql.jdbc3g.AbstractJdbc3gConnection.&lt;init&gt;(AbstractJdbc3gConnection.java:22)
	at org.postgresql.jdbc4.AbstractJdbc4Connection.&lt;init&gt;(AbstractJdbc4Connection.java:32)
	at org.postgresql.jdbc4.Jdbc4Connection.&lt;init&gt;(Jdbc4Connection.java:24)
	at org.postgresql.Driver.makeConnection(Driver.java:393)
	at org.postgresql.Driver.connect(Driver.java:267)
	at java.sql.DriverManager.getConnection(DriverManager.java:579)
	at java.sql.DriverManager.getConnection(DriverManager.java:190)
	at fschmidt.db.base.DbDatabaseImpl.getConnection(DbDatabaseImpl.java:67)
	at fschmidt.db.pool.PooledConnection.&lt;init&gt;(PooledConnection.java:68)
	at fschmidt.db.pool.Pool.getConnection2(Pool.java:149)
	at fschmidt.db.pool.Pool.getConnection(Pool.java:118)
	at fschmidt.db.pool.DbDatabaseImpl.getConnection(DbDatabaseImpl.java:132)
	at fschmidt.db.extend.FilterDatabase.getConnection(FilterDatabase.java:67)
	at fschmidt.db.base.DbTableImpl.findByPrimaryKey(DbTableImpl.java:65)
	... 60 more</thetext>
  </long_desc><long_desc isprivate="0" >
    <commentid>4634</commentid>
    <comment_count>1</comment_count>
    <who name="Sven Gothel">sgothel</who>
    <bug_when>2015-03-10 10:28:41 +0100</bug_when>
    <thetext>Discussion continues on Bug 1095 ..

*** This bug has been marked as a duplicate of bug 1095 ***</thetext>
  </long_desc>
      
      

    </bug>

</bugzilla>