Re: DB terminating

From: Scott Felt <scott(dot)felt(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: DB terminating
Date: 2009-12-03 18:11:26
Message-ID: 26630488.post@talk.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Thanks. I altered the log log_statements and added the PID to the
log_line_prefix. I have uploaded the log. Forgive me if I'm missing
something obvious here, but I do not see that PID referenced elsewhere. Is
there a a "crash report" somewhere or is that just these logs?

Thank you.
Scott

Tom Lane-2 wrote:
>
> Scott Felt <scott(dot)felt(at)gmail(dot)com> writes:
>> Hello. I have been having an issue with a database. The logs
>> consistently
>> show this:
>
>> 2009-11-17 16:03:55 ESTLOG: 00000: server process (PID 9644) exited with
>> exit code 128
>
> This looks like a fairly garden-variety backend crash, but with only
> this much information there's no way to identify the cause. You might
> try setting log_statements = all and see if there's any consistency in
> what the process was doing just before it crashed. (You'd need to add
> PID to log_line_prefix so you could associate the log entries with the
> crash report.)
>
> regards, tom lane
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
>

--
View this message in context: http://old.nabble.com/DB-terminating-tp26412532p26630488.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Felt 2009-12-03 18:12:46 Re: DB terminating
Previous Message Bret 2009-12-03 17:57:54 Re: code example for PQgetCopyData