Re: Assertion failure in cvs head.

On Thu, 16 Sep 2004, Tom Lane wrote:

> Hmm, how are you issuing these commands exactly (what protocol message
> sequence is being sent?).
>

I've made the test case and the development version of the jar file
available here if you're interested: http://www.ejurka.com/pgsql/jars/tgl/

Here is the relevent section of the log file:

<=BE ReadyForQuery(T)
simple execute,
handler=org(dot)postgresql(dot)jdbc2(dot)AbstractJdbc2Statement$StatementResultHandler(at)133796,
maxRows=0, fetchSize=0, flags=5
FE=> Parse(stmt=null,query="INSERT INTO savepointtable VALUES
($1)",oids={23})
FE=> Bind(stmt=null,portal=null,$1=<1>)
FE=> Describe(portal=null)
FE=> Execute(portal=null,limit=1)
FE=> Sync
<=BE ParseComplete [null]
<=BE BindComplete [null]
<=BE NoData
<=BE CommandStatus(INSERT 66384 1)
<=BE ReadyForQuery(T)
simple execute,
handler=org(dot)postgresql(dot)jdbc2(dot)AbstractJdbc2Statement$StatementResultHandler(at)4741d6,
maxRows=0, fetchSize=0, flags=5
FE=> Parse(stmt=null,query="SAVEPOINT JDBC_SAVEPOINT_0",oids={})
FE=> Bind(stmt=null,portal=null)
FE=> Describe(portal=null)
FE=> Execute(portal=null,limit=1)
FE=> Sync
<=BE ParseComplete [null]
<=BE BindComplete [null]
<=BE NoData
<=BE CommandStatus(SAVEPOINT)
<=BE ReadyForQuery(T)
simple execute,
handler=org(dot)postgresql(dot)jdbc2(dot)AbstractJdbc2Statement$StatementResultHandler(at)337d0f,
maxRows=0, fetchSize=0, flags=5
FE=> Parse(stmt=null,query="INSERT INTO savepointtable VALUES
($1)",oids={23})
FE=> Bind(stmt=null,portal=null,$1=<1>)
FE=> Describe(portal=null)
FE=> Execute(portal=null,limit=1)
FE=> Sync
<=BE ParseComplete [null]
<=BE BindComplete [null]
<=BE NoData
<=BE ErrorMessage(ERROR: duplicate key violates unique constraint
"savepointtable_pkey"
Location: File: nbtinsert.c, Routine: _bt_check_unique, Line: 255
ServerSQLState: 23505)
java.sql.SQLException: ERROR: duplicate key violates unique constraint
"savepointtable_pkey"
Location: File: nbtinsert.c, Routine: _bt_check_unique, Line: 255
ServerSQLState: 23505
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1141)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:944)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:139)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:346)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:294)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:249)
at SavepointTest.addRow(SavepointTest.java:8)
at SavepointTest.main(SavepointTest.java:25)
SQLException: SQLState(23505)
<=BE ReadyForQuery(E)
simple execute,
handler=org(dot)postgresql(dot)jdbc2(dot)AbstractJdbc2Statement$StatementResultHandler(at)1e4cbc4,
maxRows=0, fetchSize=0, flags=23
FE=> Parse(stmt=null,query="ROLLBACK TO SAVEPOINT
JDBC_SAVEPOINT_0",oids={})
FE=> Bind(stmt=null,portal=null)
FE=> Execute(portal=null,limit=1)
FE=> Sync
FE=> Terminate
org.postgresql.util.PSQLException: An I/O error occured while sending to
the backend

Kris Jurka