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

unexpected "ERROR: concurrent delete in progress"

From: Jon Nelson <jnelson+pgsql(at)jamponi(dot)net>
To: pgsql-bugs(at)postgresql(dot)org
Subject: unexpected "ERROR: concurrent delete in progress"
Date: 2010-12-07 19:51:07
Message-ID: (view raw or whole thread)
Lists: pgsql-bugs
While tracking down some issues that /might/ be kernel related, I ran
into an error message:

ERROR:  concurrent delete in progress

With this SQL in a file (t.sql):

create temporary table foo as select x as a, ARRAY[x] as b FROM
generate_series(1, 10000000 ) AS x;
create index foo_a_idx on foo (a);
create index foo_b_idx on foo USING GIN (b);

I had issued this bash:

while true; do psql -f t.sql test >> out 2>&1; done

and after a dozen or so iterations I encountered that error message.
Now, it *might* be kernel related, but what else might it be?
I'm on Linux x86_64, using postgresql 8.4.5.



pgsql-bugs by date

Next:From: Tom LaneDate: 2010-12-07 20:19:23
Subject: Re: unexpected "ERROR: concurrent delete in progress"
Previous:From: Kevin GrittnerDate: 2010-12-07 17:48:04
Subject: Re: i need some help on installing all the stuff

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