Обсуждение: 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,
Cool. Thanks for your answer.
Best Regards,
Uwe
Cool. Thanks for your answer.
Best Regards,
Uwe
On 25 November 2011 17:43, Tom Lane <tgl@sss.pgh.pa.us> wrote:
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