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

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

From: "JEAN-PIERRE PELLETIER" <pelletier_32(at)sympatico(dot)ca>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: server process (PID 1188) exited with exit code -1073741819, 8.2 beta1
Date: 2006-10-24 20:45:08
Message-ID: BAY118-F910FFA84302F2F0EA339D95010@phx.gbl (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-jdbc
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



Responses

pgsql-hackers by date

Next:From: Magnus HaganderDate: 2006-10-24 20:59:41
Subject: Re: Release stamping (Was: [CORE] Schedule for release?)
Previous:From: Martijn van OosterhoutDate: 2006-10-24 20:23:07
Subject: Re: [SPAM?] Re: Asynchronous I/O Support

pgsql-jdbc by date

Next:From: Dave CramerDate: 2006-10-24 22:11:18
Subject: Re: server process (PID 1188) exited with exit code -1073741819, 8.2 beta1
Previous:From: Adriaan JoubertDate: 2006-10-24 16:20:04
Subject: Re: [JDBC] currval() race condition on se?==?iso-8859-1?Q?rver?

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