Problem with Forum - 500 Error

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Problem with Forum - 500 Error

Coleen_Astalos
There appears to be a problem with my forum (forum.sudsol.org).
I've not made any changes to my forum and I'm getting this error:  
Error 500

couldn't update db for: s1100894

Message: ERROR: insert or update on table "file_node" violates foreign key constraint "file_node_node_id_fkey"
Detail: Key (node_id)=(30483) is not present in table "node".

RequestURI: /

Server: n7.nabble.com
Caused by:

java.lang.RuntimeException: couldn't update db for: s1100894
	at nabble.model.Db.getDb(Db.java:117)
	at nabble.model.Db.access$100(Db.java:26)
	at nabble.model.Db$1.get(Db.java:128)
	at nabble.model.Db$1.get(Db.java:126)
	at fschmidt.util.java.SimpleCache.get(SimpleCache.java:19)
	at nabble.model.Db.db(Db.java:137)
	at nabble.model.SiteKey.getDb(SiteKey.java:60)
	at nabble.model.SiteImpl$1.get(SiteImpl.java:278)
	at nabble.model.SiteImpl$1.get(SiteImpl.java:276)
	at fschmidt.util.java.SimpleCache.get(SimpleCache.java:19)
	at nabble.model.SiteImpl.table(SiteImpl.java:299)
	at nabble.model.SiteImpl.getSite(SiteImpl.java:303)
	at nabble.model.SiteKey.site(SiteKey.java:40)
	at nabble.model.SiteGlobal.site(SiteGlobal.java:86)
	at nabble.model.ModelHome.getSite(ModelHome.java:77)
	at nabble.view.lib.Jtp.getSite(Jtp.java:867)
	at nabble.view.lib.UrlMapperImpl.getUrlMapping(UrlMapperImpl.java:48)
	at fschmidt.util.servlet.JtpContextServlet.service2(JtpContextServlet.java:357)
	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:135)
	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:748)
Caused by: org.postgresql.util.PSQLException: ERROR: insert or update on table "file_node" violates foreign key constraint "file_node_node_id_fkey"
  Detail: Key (node_id)=(30483) is not present in table "node".
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
	at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)
	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:302)
	at nabble.model.DbUpdater.exec(DbUpdater.java:87)
	at nabble.model.DbSiteUpdater.execCatching(DbSiteUpdater.java:167)
	at nabble.model.DbSiteUpdater.update(DbSiteUpdater.java:804)
	at nabble.model.DbSiteUpdater.go(DbSiteUpdater.java:152)
	at nabble.model.DbSiteUpdater$1.run(DbSiteUpdater.java:135)
	... 4 more


Help, I need to get my site back up ASAP.
Thanks,
Coleen
Reply | Threaded
Open this post in threaded view
|

Re: Problem with Forum - 500 Error

fffilimnov
Administrator
Hello.

Fixed.
Reply | Threaded
Open this post in threaded view
|

Re: Problem with Forum - 500 Error

Coleen_Astalos
Thank you.