Re: total db lockup

actually, I'm using postgresql 7.3.2. I noticed there were some hash index fixes in 7.4, so that might be it. Would there be any other reason for this deadlock? This database has been in production for almost 2 years and this is the first time we've seen the problem.

thanks,

Eugene

>
> From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
> Date: 2005/08/19 Fri AM 11:22:04 EST
> To: Eugene <eugene1(at)sympatico(dot)ca>
> CC: pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] total db lockup
>
> On Fri, Aug 19, 2005 at 10:54:35AM -0400, Eugene wrote:
> > Thanks Alvaro.
> >
> > Here it is again:
> >
> > problem description: http://rafb.net/paste/results/bLAtIk26.html
> > db state before first restart: http://rafb.net/paste/results/D1Bqe125.html
> > db state before second restart: http://rafb.net/paste/results/D1Bqe125.html
> > table definition: http://rafb.net/paste/results/W35ccD49.html
>
> Ok, so it seems the lockup occured only with the hash indexes? Then it
> means we still have bugs in the locking code for those. It doesn't
> surprise me. There's a reason they are not recommended, you know?
>
> Let us know if you find the problem showing up again with btree indexes.
> The hash indexes bugs should be fixed, but they are not high priority ...
>
> --
> Alvaro Herrera (<alvherre[a]alvh.no-ip.org>)
> "If it wasn't for my companion, I believe I'd be having
> the time of my life" (John Dunbar)
>