Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group