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

From Craig Ringer
Subject Re: 8.4.4 locked after power failure
Date
Msg-id 4E70036B.70700@ringerc.id.au
Whole thread Raw
In response to Re: 8.4.4 locked after power failure  (Grzegorz Jaśkiewicz <gryzman@gmail.com>)
List pgsql-general
On 09/13/2011 11:04 PM, Grzegorz Jaśkiewicz wrote:
> 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.

Of course it does. How would _you_ go about reproducing it or tracing it
so you could even begin to track it down, though? There just isn't
enough information to work with.

It's like someone contacting you and explaining that they saved a file
containing a huge embedded image from your office suite software, but
when they went to open the file later it crashed the office suite. They
were in a hurry and didn't have the disk space to keep the old one, so
they had to redo the work and save over the file. It's good to get the
report, but ... what do you do about it? They don't have a faulty file,
a reproducible test case, any or any good prospects for working on
creating a test case.

--
Craig Ringer


pgsql-general by date:

Previous
From: Toby Corkindale
Date:
Subject: PostgreSQL benchmarked on XFS vs ZFS vs btrfs vs ext4
Next
From: Craig Ringer
Date:
Subject: Re: Has Pg 9.1.0 been released today?