Search Postgresql Archives

Re:

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




>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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux