Re: Problem with 2 avcuums in parallel

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Denis Perchine <dyp(at)perchine(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Problem with 2 avcuums in parallel
Date: 2000-11-02 22:42:18
Message-ID: 27223.973204938@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Denis Perchine <dyp(at)perchine(dot)com> writes:
> When I run 2 vacuum's in parallel they hangs. Both.
> I use PostgreSQL from 7.0.x CVS (almost 7.0.3).

Hm. I don't see a hang, but I do see errors like

NOTICE: Deadlock detected -- See the lock(l) manual page for a possible cause.
ERROR: WaitOnLock: error on wakeup - Aborting this transaction

What's curious is that neither 7.0.2 nor current seem to exhibit this
behavior (at least, it's much easier to reproduce in REL7_0_PATCHES than
in 7.0.2 or current). Odd... in theory we shouldn't have introduced any
new bugs in REL7_0_PATCHES that wouldn't also be in current...

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Philip Warner 2000-11-02 22:59:39 Re: Transaction costs?
Previous Message Tom Lane 2000-11-02 22:01:23 Re: relation ### modified while in use