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

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@fastcrypt.com>
>To: JEAN-PIERRE PELLETIER <pelletier_32@sympatico.ca>
>CC: List <pgsql-jdbc@postgresql.org>, PostgreSQL-development
><pgsql-hackers@postgreSQL.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