Re: New kind of crash? - Mailing list pgsql-bugs

From Alvaro Herrera
Subject Re: New kind of crash?
Date
Msg-id 20130311012240.GA9412@alvh.no-ip.org
Whole thread Raw
In response to Re: New kind of crash?  (Josh Berkus <josh@agliodbs.com>)
Responses Re: New kind of crash?
List pgsql-bugs
Josh Berkus wrote:
> On 03/08/2013 07:27 PM, Alvaro Herrera wrote:
> > Josh Berkus wrote:
> >> Folks,
> >>
> >> This is one I've never seen before:
> >>
> >> =3D> select generate_master_tables();
> >> WARNING:  AbortTransaction while in COMMIT state
> >> PANIC:  cannot abort transaction 9387287, it was already committed
> >=20
> > Anything that causes an ERROR in the final stages of a transaction
> > commit will look like this.  Maybe, for example, something tried to
> > acquire more shared memory for something (serializable xact?) but tha=
t
> > was already full because of lock objects.
>=20
> Well, is it worth trying to reproduce and diagnose?

IMO it's worth adding enough protections that in these situations you
get regular ERRORs rather than PANICs, assuming the scenario is not too
contrived and the required patches are not too complex.

--=20
=C1lvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

pgsql-bugs by date:

Previous
From: Josh Berkus
Date:
Subject: Re: New kind of crash?
Next
From: Rushabh Lathia
Date:
Subject: ERROR: invalid input syntax for type timestamp with time zone