Skip site navigation (1) Skip section navigation (2)

Re: Assertion failure in cvs head.

From: Kris Jurka <books(at)ejurka(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Assertion failure in cvs head.
Date: 2004-09-16 16:03:29
Message-ID: Pine.BSO.4.56.0409161059440.28479@leary.csoft.net (view raw or flat)
Thread:
Lists: pgsql-bugs

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

In response to

pgsql-bugs by date

Next:From: Bruno Wolff IIIDate: 2004-09-16 17:36:14
Subject: Re: BUG #1252: Optimization of SELECT for NOT NULL case
Previous:From: Tom LaneDate: 2004-09-16 14:55:19
Subject: Re: Assertion failure in cvs head.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group