NAML error on login and no updates

[Gale (Audacity Team)]

Hi I get the below error when I log in, view http://audacity.238276.n2.nabble.com/audacity-devel-f238278.html then click a link to read a topic.

Logged in or not, http://audacity.238276.n2.nabble.com/audacity-devel-f238278.html is not updating for recent posts that have been accepted by the associated mailing list ( [e-mail] ).


Thanks


Gale


Error 500
NAML exception in customized site: select * from node where cookie=?
        in do_login(nabble:login.naml:5) - <n.do_login> - public void nabble.view.web.template.ServletNamespace.do_login(nabble.naml.compiler.IPrintWriter,nabble.naml.compiler.Interpreter) throws java.io.IOException,javax.servlet.ServletException
        in if(nabble:login.naml:3) - <n.if.is_submitted_form> - public static void nabble.naml.namespaces.BasicNamespace._if(nabble.naml.compiler.IPrintWriter,nabble.naml.compiler.Interpreter)
        in current_permission_version(nabble:permissions.naml:6) - <n.current_permission_version/>
        in (nabble:login.naml:1) - <macro name="login_page" requires="servlet">
Message: NAML exception in customized site: select * from node where cookie=?
RequestURI: /template/NamlServlet.jtp
Server: n2.nabble.com
Caused by:
fschmidt.util.servlet.JtpContextServlet$JtpServletException: url=http://audacity.238276.n2.nabble.com/template/NamlServlet.jtp?nextUrl=http://audacity.238276.n2.nabble.com/Nyquist-Generate-Prompt-td7558169.html¯o=login_page&login_page=&email=[e-mail]&password=nuts  user-agent=Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.31 (KHTML, like Gecko) Chrome/26.0.1410.64 Safari/537.31 method=POST referer=http://audacity.238276.n2.nabble.com/template/NamlServlet.jtp?macro=login_page&nextUrl=http%3A%2F%2Faudacity.238276.n2.nabble.com%2FNyquist-Generate-Prompt-td7558169.html
        at fschmidt.util.servlet.JtpContextServlet.handleException(JtpContextServlet.java:571)
        at fschmidt.util.servlet.JtpContextServlet.service2(JtpContextServlet.java:465)
        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:126)
        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.content(AbstractHttpConnection.java:925)
        at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:857)
        at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:235)
        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: javax.servlet.ServletException: NAML exception in customized site: select * from node where cookie=?
        in do_login(nabble:login.naml:5) - <n.do_login> - public void nabble.view.web.template.ServletNamespace.do_login(nabble.naml.compiler.IPrintWriter,nabble.naml.compiler.Interpreter) throws java.io.IOException,javax.servlet.ServletException
        in if(nabble:login.naml:3) - <n.if.is_submitted_form> - public static void nabble.naml.namespaces.BasicNamespace._if(nabble.naml.compiler.IPrintWriter,nabble.naml.compiler.Interpreter)
        in current_permission_version(nabble:permissions.naml:6) - <n.current_permission_version/>
        in (nabble:login.naml:1) - <macro name="login_page" requires="servlet">
        at nabble.view.web.template.NamlServlet.checkTweaked(NamlServlet.java:185)
        at nabble.view.web.template.NamlServlet.service(NamlServlet.java:144)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
        at fschmidt.util.servlet.JtpContextServlet.service2(JtpContextServlet.java:461)
        ... 38 more
Caused by: nabble.naml.compiler.TemplateRuntimeException: select * from node where cookie=?
        in do_login(nabble:login.naml:5) - <n.do_login> - public void nabble.view.web.template.ServletNamespace.do_login(nabble.naml.compiler.IPrintWriter,nabble.naml.compiler.Interpreter) throws java.io.IOException,javax.servlet.ServletException
        in if(nabble:login.naml:3) - <n.if.is_submitted_form> - public static void nabble.naml.namespaces.BasicNamespace._if(nabble.naml.compiler.IPrintWriter,nabble.naml.compiler.Interpreter)
        in current_permission_version(nabble:permissions.naml:6) - <n.current_permission_version/>
        in (nabble:login.naml:1) - <macro name="login_page" requires="servlet">
        at nabble.naml.compiler.Compiler.interpFix(Compiler.java:2007)
        at nabble.naml.compiler.Compiler$Block.run(Compiler.java:1636)
        at nabble.naml.compiler.Compiler$Chunks.run(Compiler.java:1121)
        at nabble.naml.compiler.BlockWrapper.printTo(BlockWrapper.java:68)
        at nabble.naml.compiler.TemplatePrintWriter.print(TemplatePrintWriter.java:22)
        at nabble.naml.namespaces.BasicNamespace._if(BasicNamespace.java:140)
        at sun.reflect.GeneratedMethodAccessor7.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:601)
        at nabble.naml.compiler.JavaCall.invoke(JavaCall.java:26)
        at nabble.naml.compiler.Compiler$Block.invoke(Compiler.java:1557)
        at nabble.naml.compiler.Compiler$Block.run(Compiler.java:1631)
        at nabble.naml.compiler.Compiler$Chunks.run(Compiler.java:1121)
        at nabble.naml.compiler.Compiler$VarScope.run(Compiler.java:1259)
        at nabble.naml.compiler.Template.run(Template.java:61)
        at nabble.naml.compiler.Template.run(Template.java:33)
        at nabble.modules.ModuleManager.run(ModuleManager.java:270)
        at nabble.view.web.template.NamlServlet.service(NamlServlet.java:165)
        at nabble.view.web.template.NamlServlet.service(NamlServlet.java:134)
        ... 40 more
Caused by: java.lang.RuntimeException: select * from node where cookie=?
        at nabble.model.CursorNodeIterator.<init>(CursorNodeIterator.java:53)
        at nabble.model.UserImpl.moveToRegisteredAccount(UserImpl.java:965)
        at nabble.view.lib.Jtp.doLogin(Jtp.java:126)
        at nabble.view.web.template.ServletNamespace.do_login(ServletNamespace.java:244)
        at sun.reflect.GeneratedMethodAccessor419.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:601)
        at nabble.naml.compiler.JavaCall.invoke(JavaCall.java:26)
        at nabble.naml.compiler.Compiler$Block.invoke(Compiler.java:1557)
        at nabble.naml.compiler.Compiler$Block.run(Compiler.java:1631)
        ... 57 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.<init>(AbstractJdbc2Connection.java:125)
        at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
        at org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:22)
        at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:32)
        at org.postgresql.jdbc4.Jdbc4Connection.<init>(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.<init>(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 nabble.model.CursorNodeIterator.<init>(CursorNodeIterator.java:37)
        ... 66 more

[Pedro]

We had a glitch on our server. Please, let me know if it happens again.