Exception 0xC0000005

From: Ms swati chande <swativc(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Exception 0xC0000005
Date: 2009-09-24 16:22:47
Message-ID: 686483.42571.qm@web112604.mail.gq1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Sorry for resending, it got stalled.
Have subscribed to pgsql-general now.
 
>What query, exactly?  Which PG version is this?
>            regards, tom lane

Its a query involving 15 relations, processing not more than 500 records. The query is written in a .sql file and the file is executed as
 
\i initq.sql
 
Infact, know no .sql file is getting executed. All my .sqls have >=15 records.
 
The error message is:
psql: initq.sql:64: server closed the connection unexpectedly
            This probably means the server terminated abnormally
            before or while processing the request.
psql: initq.sql:64: connection to server was lost
 
and the logfile shows:
 

LOG:  server process (PID 3304) was terminated by exception 0xC0000005
HINT:  See C include file "ntstatus.h" for a description of the hexadecimal value.
LOG:  terminating any other active server processes
LOG:  all server processes terminated; reinitializing
LOG:  database system was interrupted; last known up at 2009-09-24 18:01:00 IST
LOG:  database system was not properly shut down; automatic recovery in progress
LOG:  record with zero length at 0/1A71AE0
LOG:  redo is not required
LOG:  database system is ready to accept connections
LOG:  autovacuum launcher started
 
The execution for this and other queries has been fine so far.
What is exception 0xC0000005?
I am working on Windows XP.
Have built version 8.4.0 from source using Visual Studio 2005.
 
Thanks and Regards
Swati

Responses

Browse pgsql-general by date

  From Date Subject
Next Message mmoncure 2009-09-24 16:28:16 Re: Exception 0xC0000005
Previous Message agostonbejo 2009-09-24 15:35:30 Re: How to have ant's <sql> task insert special chars appropriately?