java.lang.reflect.InvocationTargetException

[Migrated From Jforum.net]

Hi,

I'm working with JForum 2.1.8 and PostgreSQL 7.4 running on SuSE Linux Enterprise Server 9 on a POWER 5+ 64 bits machine.

JForum runs well during several days, but now when I create a new post I recive this message

<!-- BEGIN ERROR STACK TRACE <br /> net.jforum.exceptions.ForumException: java.lang.reflect.InvocationTargetException <br /> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) <br /> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79) <br /> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) <br /> at java.lang.reflect.Method.invoke(Method.java:618) <br /> at net.jforum.Command.process(Command.java:114) <br /> at net.jforum.JForum.processCommand(JForum.java:217) <br /> at net.jforum.JForum.service(JForum.java:200) <br /> at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) <br /> at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:989) <br /> at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:930) <br /> at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:145) <br /> at net.jforum.util.legacy.clickstream.ClickstreamFilter.doFilter(ClickstreamFilter.java:59) <br /> at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:190) <br /> at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:130) <br /> at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:87) <br /> at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:766) <br /> at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:674) <br /> at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:498) <br /> at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:464) <br /> at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:90) <br /> at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:744) <br /> at com.ibm.ws.wswebcontainer.WebContainer.handleRequest(WebContainer.java:1455) <br /> at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:113) <br /> at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:454) <br /> at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:383) <br /> at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:102) <br /> at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165) <br /> at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217) <br /> at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161) <br /> at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:136) <br /> at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:195) <br /> at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:743) <br /> at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:873) <br /> at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1469) <br /> Caused by: java.lang.reflect.InvocationTargetException <br /> ... 34 more <br /> Caused by: net.jforum.exceptions.DatabaseException: java.sql.SQLException: ERROR: duplicate key violates unique constraint "jforum_topics_pkey" <br /> at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1471) <br /> at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1256) <br /> at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:175) <br /> at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:392) <br /> at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:330) <br /> at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:282) <br /> at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105) <br /> at net.jforum.dao.generic.AutoKeys.executeAutoKeysQuery(AutoKeys.java:118) <br /> at net.jforum.dao.generic.AutoKeys.executeAutoKeysQuery(AutoKeys.java:112) <br /> at net.jforum.dao.generic.GenericTopicDAO.addNew(GenericTopicDAO.java:351) <br /> at net.jforum.view.forum.PostAction.insertSave(PostAction.java:1101) <br /> ... 34 more <br /> Caused by: java.sql.SQLException: ERROR: duplicate key violates unique constraint "jforum_topics_pkey" <br /> ... 45 more <br /> <br /> URL is: /jforum/jforum.page?null <br /> END ERROR STACK TRACE-->


Any idea?

Thanks a lot
[originally posted on jforum.net by gardan]

[Migrated From Jforum.net]

Solved,

The problem was that the PostgreSQL database was reset the sequence number files.

Also I changed the JDBC driver to pg74.216.jdbc3.jar.


Regards,
Dani
[originally posted on jforum.net by gardan]