Re: panic on 7.3 - Mailing list pgsql-hackers

From Tom Lane
Subject Re: panic on 7.3
Date
Msg-id 13463.1137821774@sss.pgh.pa.us
Whole thread Raw
In response to Re: panic on 7.3  (Rick Gigger <rick@alpinenetworking.com>)
Responses Re: panic on 7.3
List pgsql-hackers
Rick Gigger <rick@alpinenetworking.com> writes:
> I don't know if 2K could have passed since the last checkpoint.
> ...
> now that I think about it I was getting about 400 pages requests /  
> minute and each of those would have have been doing at least 2  
> transactions so yes, I guess that is very likely.

Good, 'cause if you didn't have a couple thousand transactions between
checkpoints then we need another theory ;-)

>> You realize of course that that's pretty old ...

> Yes.  I will be upgrading immediately.

You'll want to include this patch:
http://archives.postgresql.org/pgsql-committers/2006-01/msg00289.php
(or see adjacent messages if you plan to move to something newer than
7.3.*).  We probably will not put out another set of releases until
next month, unless something really big comes along.  This one doesn't
qualify as really big IMHO, because it's not a PANIC-grade failure in
the later branches.  But having been burnt once, I'm sure you'll want
a patched copy ...
        regards, tom lane


pgsql-hackers by date:

Previous
From: Rick Gigger
Date:
Subject: Re: panic on 7.3
Next
From: Tom Lane
Date:
Subject: Re: could not access status of transaction 0