Re: postgres server crashes unexpectedly - Mailing list pgsql-sql

From Chadwick Horn
Subject Re: postgres server crashes unexpectedly
Date
Msg-id 8ECADC453D394D089097C660876A9BA7@ToshibaLaptop
Whole thread Raw
In response to Re: postgres server crashes unexpectedly  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: postgres server crashes unexpectedly
List pgsql-sql
> "Chadwick Horn" <chadhorn@gmail.com> writes:
>> I keep getting this error:
>
>> Attempting reset: WARNING: terminating connection because of crash of 
>> another server process
>
> It looks to me like psql is managing to start a new connection before
> the postmaster notices the crash of the prior backend and tells
> everybody to get out of town.  Which is odd, but maybe not too
> implausible if your kernel is set up to favor interactive processes over
> background --- it'd likely think psql is interactive and the postmaster
> isn't.

Is there a way to disable this or to make both interactive and/or 
background?

>
>> What could be doing this? It just started out of the blue... I reindexed 
>> the
>> index it mentioned and it seems to error out more...
>
> If you reindexed only the last-mentioned index, then you reindexed the
> wrong thing; it presumably died on the next index of story_member.
> I'd reindex the whole table rather than guess which that is.
>
> You should also consider the not-zero probability that you have more
> than one corrupted index.  Keep reindexing tables until you can get
> through a database-wide VACUUM.

I have VACUUM'd it until it's fibers are coming out. It seems to crash at 
various places (which, most likely, would be resolved if question #1 above 
is possible) and holds no consistancy. The error logs provide even fewer 
clues than the verbose output.


-chadwick



pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: postgres server crashes unexpectedly
Next
From: "Campbell, Lance"
Date:
Subject: Create on insert a unique random number