From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | felix(at)crowfix(dot)com |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: 7.3.2 closing connections, sometimes |
Date: | 2005-07-06 21:44:44 |
Message-ID: | 200507062144.j66LiiR28675@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
felix(at)crowfix(dot)com wrote:
> > Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> > > This message is from the backend exiting abruptly. Is isn't an "ERROR"
> > > as we define it for logging purposes. That's why there is nothing in
> > > the logs.
> >
> > Nonetheless I'd expect there to be at least a postmaster complaint about
> > a crashed backend --- assuming that that's what's going on. Do the
> > other active connections get forcibly closed when this happens?
>
> Haven't had any others open, it's a dev system. But I'll try leaving
> a psql session open. Right now it's gotten itself into the mood of
> always working, so it might have to wait a while.
>
> Could a corrupt db cause these mood swings? And if so, would that
> persist even across dropdb / creatdb?
Yes, that is possible, but usually it would fail consistently. Have you
run memtest and disk diagnostics?
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
From | Date | Subject | |
---|---|---|---|
Next Message | Otto Blomqvist | 2005-07-06 21:51:53 | Adding miscadmin.h generates errors ? |
Previous Message | Dawid Kuroczko | 2005-07-06 21:30:52 | Re: About unsigned smallint? |