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

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

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: server process (PID 1188) exited with exit code -1073741819, 8.2 beta1
Date: 2006-10-24 22:11:18
Message-ID: 1B8AB823-5FD8-4225-8B3C-CE1A72223C23@fastcrypt.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-jdbc
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
>


In response to

Responses

pgsql-hackers by date

Next:From: Joshua D. DrakeDate: 2006-10-24 22:13:34
Subject: Re: [HACKERS] Replication documentation addition
Previous:From: Simon RiggsDate: 2006-10-24 22:05:37
Subject: Re: [HACKERS] Replication documentation addition

pgsql-jdbc by date

Next:From: JEAN-PIERRE PELLETIERDate: 2006-10-24 22:34:37
Subject: Re: server process (PID 1188) exited with exit code -1073741819, 8.2
Previous:From: JEAN-PIERRE PELLETIERDate: 2006-10-24 20:45:08
Subject: server process (PID 1188) exited with exit code -1073741819, 8.2 beta1

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