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

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 (view raw or flat)
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: bla.tar.gz
Description: application/x-gzip (6.1 KB)

In response to

Responses

pgsql-bugs by date

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

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