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

Error during hash index scans can cause postgres halt!

From: "ykhuang" <hyk(at)ruc(dot)edu(dot)cn>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Error during hash index scans can cause postgres halt!
Date: 2008-03-07 03:27:35
Message-ID: fqqco2$3mn$1@news.hub.org (view raw or flat)
Thread:
Lists: pgsql-bugs
recurred through deadlock.

client1:
 create table test(a int);
 create index id on test using hash(a);
 insert into test values(1);
 insert into test values(2);
 set enable_seqscan=off;
 begin;
 update test set a=a+1 where a=1;

client2:
 set enable_seqscan=off;
 begin;
 update test set a=a+1 where a=2;

client1:
  update test set a=a+1 where a=2;

client2:
 update test set a=a+1 where a=1;



Responses

pgsql-bugs by date

Next:From: Euler Taveira de OliveiraDate: 2008-03-07 06:14:09
Subject: Re: [BUGS] BUG #3975: tsearch2 index should not bomb out of 1Mb limit
Previous:From: Shana8426Date: 2008-03-07 02:45:44
Subject: BUG #4018: Installation failure

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