Обсуждение: strange error message

Поиск
Список
Период
Сортировка

strange error message

От
Uwe Bartels
Дата:
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
/>

Re: strange error message

От
Tom Lane
Дата:
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


Re: strange error message

От
Uwe Bartels
Дата:
Hi Tom,

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