Re: 8.4.4 locked after power failure - Mailing list pgsql-general

From Grzegorz Jaśkiewicz
Subject Re: 8.4.4 locked after power failure
Date
Msg-id CAJY59_hW9XgEnbVBDPgZVpSscpV_0ru9xD8MnYxWzZfJRJCv8Q@mail.gmail.com
Whole thread Raw
In response to Re: 8.4.4 locked after power failure  (Merlin Moncure <mmoncure@gmail.com>)
Responses Re: 8.4.4 locked after power failure
Re: 8.4.4 locked after power failure
List pgsql-general
2011/9/13 Merlin Moncure <mmoncure@gmail.com>:
> 2011/9/13 Grzegorz Jaśkiewicz <gryzman@gmail.com>:
>> I'm guessing I won't get much more from devs , without providing more
>> info here which unfortunately has been lost.
>
> yup -- you destroyed all the evidence.  if it happens again, try
> posting some more info, particularly what's going on with locks,
> pg_stat_activity, maybe an strace of any stuck processes, etc.  also
> irc can be a good place to get some quick help if its time sensitive.

See, I was hoping that just the fact that it occurred might trigger
some suspicions on the -devel side of things. I know it would in my
product.



--
GJ

pgsql-general by date:

Previous
From: Hannes Erven
Date:
Subject: Re: Re: Need help with what I think is likely a simple query - for each distinct val, return only one record with the most recent date.
Next
From: Merlin Moncure
Date:
Subject: Re: 8.4.4 locked after power failure