From: | Ms swati chande <swativc(at)yahoo(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: |
Date: | 2009-09-24 14:33:11 |
Message-ID: | 910149.507.qm@web112619.mail.gq1.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
>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
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Selena Deckelmann | 2009-09-24 14:37:50 | Re: Looking for way to replicate master db to multiple mobile databases |
Previous Message | Michael Molz | 2009-09-24 14:31:59 | repeatedly process termination in PG 8.2 |