Error 500 after changing application

[mywaytoo]

http://welwynhatfield.983918.n3.nabble.com/Business-f2216886.html
http://welwynhatfield.983918.n3.nabble.com/Celebrations-and-Thank-yous-f2595030.html

I was trying to add a comment, but nothing was happening, so I pressed Post Message a second time... and this 500 error occurred...

BUT I think that the reason it was taking so long to post a comment, or NOT post a comment, might have something to do with the fact that I changed application from Board Topics Main View back to Forum. I did this deliberately because I felt happier adding things to the forum application.

Well I had added a new forum correctly, but COULDN'T move it upwards, as a pinned forum... I wanted them in alphabetical order... so I left it there and then this is where I tried to add the topic...

Hope this is helpful...


Error 500
select event,last_modified from http_cache where event in ('2:2595030','1:2595030')
RequestURI=/Celebrations-and-Thank-yous-f2595030.html

Caused by:
java.lang.RuntimeException: select event,last_modified from http_cache where event in ('2:2595030','1:2595030')
        at fschmidt.util.servlet.DbCache.lastModifieds(DbCache.java:131)
        at fschmidt.util.servlet.MemCache.lastModifieds(MemCache.java:56)
        at fschmidt.util.servlet.JtpContextServlet.getLastModified(JtpContextServlet.java:528)
        at fschmidt.util.servlet.JtpContextServlet.service2(JtpContextServlet.java:422)
        at fschmidt.util.servlet.JtpContextServlet.service(JtpContextServlet.java:325)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
        at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511)
        at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1166)
        at org.mortbay.servlet.UserAgentFilter.doFilter(UserAgentFilter.java:81)
        at fschmidt.util.servlet.GzipFilter.doFilter(GzipFilter.java:137)
        at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
        at cachingfilter.CachingFilter.doFilter(CachingFilter.java:156)
        at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
        at fschmidt.util.servlet.BadBotFilter.doFilter(BadBotFilter.java:74)
        at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1157)
        at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:388)
        at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182)
        at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)
        at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:230)
        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:326)
        at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542)
        at org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:923)
        at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:547)
        at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:212)
        at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
        at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:409)
        at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582)
Caused by: org.postgresql.util.PSQLException: FATAL: sorry, too many clients already
        at org.postgresql.core.v3.ConnectionFactoryImpl.readStartupMessages(ConnectionFactoryImpl.java:444)
        at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:99)
        at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)
        at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:124)
        at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
        at org.postgresql.jdbc3.Jdbc3Connection.<init>(Jdbc3Connection.java:24)
        at org.postgresql.Driver.makeConnection(Driver.java:386)
        at org.postgresql.Driver.connect(Driver.java:260)
        at java.sql.DriverManager.getConnection(DriverManager.java:582)
        at java.sql.DriverManager.getConnection(DriverManager.java:154)
        at fschmidt.db.base.DbDatabaseImpl.getConnection(DbDatabaseImpl.java:67)
        at fschmidt.db.pool.DbDatabaseImpl$Con.<init>(DbDatabaseImpl.java:237)
        at fschmidt.db.pool.DbDatabaseImpl$Con.<init>(DbDatabaseImpl.java:222)
        at fschmidt.db.pool.DbDatabaseImpl.getConnection2(DbDatabaseImpl.java:216)
        at fschmidt.db.pool.DbDatabaseImpl.getConnection(DbDatabaseImpl.java:180)
        at fschmidt.db.extend.FilterDatabase.getConnection(FilterDatabase.java:67)
        at fschmidt.util.servlet.DbCache.lastModifieds(DbCache.java:113)
        ... 28 more

[Zandranna]

Ditto for me too on both my forums

[mywaytoo]

Now I can access the gallery, newspaper and blog... but not the forum applications... NOR the outermost / top level...

Edit... I retried... 'Loading...' message appeared, and disappeared leaving a totally blank screen... BUT I left it... AND it loaded OK...

Latest info... after closing and re-entering the website... Same problem with having to wait for loading...
BUT the forum has moved upwards as I tried to do earlier.
AND the topic I entered is there... twice... BUT no post appears at this stage.
Select the topic and the post is there...

I shall leave it like this for you to look at if you want... just let me know when I can try again... Thank you.