Thread: strange error message

Hi,<br /><br />I've got a strange error message in our java application.<br />the only reference to this message i find
in<font><font size="2"><a
href="https://webmaileu.harman.com/owa/redir.aspx?C=834176e3ff1b4f1eae758f541e93549f&URL=http%3a%2f%2fmingo.info-science.uiowa.edu%2feichmann%2fcourses%2fdatabase%2fPostgres%2fprogrammer.pdf"
target="_blank">http://mingo.info-science.uiowa.edu/eichmann/courses/database/Postgres/programmer.pdf</a>.but I still
don'tknow how to solve this or even what the source od this error is.<br /> currently I don't have the executed sql
yet.I'm trying to get this.<br />Any Idea what that could be?<br /></font></font><br />ERROR JDBCTransaction:124 - JDBC
commitfailed<br /><b>org.postgresql.util.PSQLException: ERROR: bogus varno: 65001</b><br /> at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)<br/> at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)<br/> at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)<br/> at
org.postgresql.jdbc2.AbstractJdbc2Connection.executeTransactionCommand(AbstractJdbc2Connection.java:671)<br/> at
org.postgresql.jdbc2.AbstractJdbc2Connection.commit(AbstractJdbc2Connection.java:691)<br/> at
sun.reflect.GeneratedMethodAccessor49.invoke(UnknownSource)<br /> at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<br/> at
java.lang.reflect.Method.invoke(Method.java:597)<br/> at
org.postgresql.ds.jdbc23.AbstractJdbc23PooledConnection$ConnectionHandler.invoke(AbstractJdbc23PooledConnection.java:352)<br
/>at $Proxy24.commit(Unknown Source)<br /> at
org.hibernate.transaction.JDBCTransaction.commitAndResetAutoCommit(JDBCTransaction.java:139)<br/> at
org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:115)<br/>...<br /><br />Thanks,<br />Uwe<br /><br
/>

Uwe Bartels <uwe.bartels@gmail.com> writes:
> I've got a strange error message in our java application.

> ERROR JDBCTransaction:124 - JDBC commit failed
> *org.postgresql.util.PSQLException: ERROR: bogus varno: 65001*

This is a symptom of some kind of planner error.  If you are not
running the latest minor release of your Postgres branch, update
and see if it goes away.  If not, please file a bug report with
sufficient information to reproduce the problem by hand (ie, the
problem query plus schema+data sufficient to run it against).
        regards, tom lane

Hi Tom,<br /><br />Cool. Thanks for your answer.<br /><br />Best Regards,<br />Uwe<br /><br /><div
class="gmail_quote">On25 November 2011 17:43, Tom Lane <span dir="ltr"><<a
href="mailto:tgl@sss.pgh.pa.us">tgl@sss.pgh.pa.us</a>></span>wrote:<br /><blockquote class="gmail_quote"
style="margin:0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"><div class="im">Uwe
Bartels<<a href="mailto:uwe.bartels@gmail.com">uwe.bartels@gmail.com</a>> writes:<br /> > I've got a strange
errormessage in our java application.<br /><br /></div><div class="im">> ERROR JDBCTransaction:124 - JDBC commit
failed<br/></div>> *org.postgresql.util.PSQLException: ERROR: bogus varno: 65001*<br /><br /> This is a symptom of
somekind of planner error.  If you are not<br /> running the latest minor release of your Postgres branch, update<br />
andsee if it goes away.  If not, please file a bug report with<br /> sufficient information to reproduce the problem by
hand(ie, the<br /> problem query plus schema+data sufficient to run it against).<br /><br />                      
 regards,tom lane<br /></blockquote></div><br />