Re: server process (PID 1188) exited with exit code -1073741819, 8.2

["JEAN-PIERRE PELLETIER" <pelletier_32(at)sympatico(dot)ca>]

In my real query the ? was used in the where clause,
I moved it to the select while trying to come with a simplified test case.

> From: Dave Cramer <pg(at)fastcrypt(dot)com>
> To: JEAN-PIERRE PELLETIER <pelletier_32(at)sympatico(dot)ca>
> CC: List <pgsql-jdbc(at)postgresql(dot)org>, PostgreSQL-development 
> <pgsql-hackers(at)postgreSQL(dot)org>
> Subject: Re: [JDBC] server process (PID 1188) exited with exit code 
> -1073741819, 8.2 beta1
> Date: Tue, 24 Oct 2006 18:11:18 -0400
>
> This is a server bug, I will post to hackers for you, it has little  to do 
> with JDBC, however the ? can't be a column in a prepared statement
>
> DAVE
> On 24-Oct-06, at 4:45 PM, JEAN-PIERRE PELLETIER wrote:
>
> > Hi,
> >
> > I have a query that throws "org.postgresql.util.PSQLException: An I/ O 
> > error occured while sending to the backend". Here is a simplified  version 
> > of it where I used pg_database, but any table or view do  the same.
> >
> > PreparedStatement pstmt = connection.prepareStatement("select ?  from 
> > (select * from pg_database) t");
> > pstmt.setObject(1, 1);
> > ResultSet rs = pstmt.executeQuery();
> >
> > It restarts PostgreSQL with this in the Log
> > 2006-10-24 15:35:38 LOG:  server process (PID 1188) exited with  exit code 
> > -1073741819
> > 2006-10-24 15:35:38 LOG:  terminating any other active server  processes
> > 2006-10-24 15:35:38 LOG:  all server processes terminated;  reinitializing
> > 2006-10-24 15:35:39 LOG:  database system was interrupted at  2006-10-24 
> > 15:34:54 Eastern Standard Time
> > 2006-10-24 15:35:39 LOG:  Windows fopen("recovery.conf","r")  failed: code 
> > 2, errno 2
> > 2006-10-24 15:35:39 LOG:  Windows fopen("pg_xlog/ 00000001.history","r") 
> > failed: code 2, errno 2
> > 2006-10-24 15:35:39 LOG:  Windows fopen("backup_label","r") failed:  code 
> > 2, errno 2
> > 2006-10-24 15:35:39 LOG:  checkpoint record is at 0/31FDF0A0
> > 2006-10-24 15:35:39 LOG:  redo record is at 0/31FDF0A0; undo record  is at 
> > 0/0; shutdown TRUE
> > 2006-10-24 15:35:39 LOG:  next transaction ID: 0/22535; next OID:  101011
> > 2006-10-24 15:35:39 LOG:  next MultiXactId: 1; next MultiXactOffset: 0
> > 2006-10-24 15:35:39 LOG:  database system was not properly shut  down; 
> > automatic recovery in progress
> > 2006-10-24 15:35:39 LOG:  record with zero length at 0/31FDF0F0
> > 2006-10-24 15:35:39 LOG:  redo is not required
> > 2006-10-24 15:35:40 LOG:  database system is ready
> > 2006-10-24 15:35:40 LOG:  Windows fopen("global/pg_fsm.cache","rb")  
> > failed: code 2, errno 2
> > 2006-10-24 15:35:40 LOG:  transaction ID wrap limit is 2147484172,  
> > limited by database "postgres"
> > 2006-10-24 15:36:40 LOG:  Windows fopen("global/pgstat.stat","rb")  
> > failed: code 2, errno 2
> > 2006-10-24 15:36:40 LOG:  Windows fopen("global/pgstat.stat","rb")  
> > failed: code 2, errno 2
> >
> > I am using PostgreSQL 8.2 beta1 on Windows XP, Service Pack 2
> > Both JDBC3 driver 8.1 build 407 and 8.2 build 503 do the same.
> >
> > Thanks,
> > Jean-Pierre Pelletier
> > e-djuster
> >
> >
> >
> > ---------------------------(end of  broadcast)---------------------------
> > TIP 6: explain analyze is your friend
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>       choose an index scan if your joining column's datatypes do not
>       match