Re: BUG #4945: Parallel update(s) gone wild

From: "Dan Boeriu" <dan(dot)boeriu(at)roost(dot)com>
To: "Robert Haas" <robertmhaas(at)gmail(dot)com>
Cc: "Craig Ringer" <craig(at)postnewspapers(dot)com(dot)au>, "PostgreSQL bugs" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #4945: Parallel update(s) gone wild
Date: 2009-07-29 05:05:52
Message-ID: EF2E22898E35844BA4479BBF97078AC1FD0ABA@be10.exg4.exghost.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


Attached is the reproducible test case - I was able to reproduce the problem on 32 and 64 bit 8.3.6 and 8.4.0 RedHat 5.3 kernel 2.6.18-128.1.16.el5 #1 SMP

JUST IN CASE - if the second update ever finishes just do a couple of times:

INSERT INTO xxx SELECT * FROM xxx;

That should do it.

Please let me know if you were able to reproduce the problem.

Dan Boeriu
Senior Architect - Roost.com
P: (415) 742 8056
Roost.com - 2008 Inman Award Winner for Most Innovative New Technology

Attachment Content-Type Size
bla.tar.gz application/x-gzip 6.1 KB

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Craig Ringer 2009-07-29 07:36:11 Re: BUG #4951: installation dir wrong for libpq compilation
Previous Message Jeff Janes 2009-07-29 03:23:23 BUG #4952: commit_delay ignored because CountActiveBackends always returns zero