From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Jon Nelson <jnelson+pgsql(at)jamponi(dot)net> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: unexpected "ERROR: concurrent delete in progress" |
Date: | 2010-12-07 20:19:23 |
Message-ID: | 27631.1291753163@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Jon Nelson <jnelson+pgsql(at)jamponi(dot)net> writes:
> 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):
> begin;
> 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);
> rollback;
> 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.
FWIW, I can't replicate that using either HEAD or current 8.4.x,
on Fedora 13 x86_64. It's quite unobvious though how kernel
or hardware flakiness might lead to that message. *Maybe* you
could get it from a dropped hint-bit or some such, but I don't
see a clear explanation.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | DavidW | 2010-12-08 06:03:10 | Cannot not create python language |
Previous Message | Jon Nelson | 2010-12-07 19:51:07 | unexpected "ERROR: concurrent delete in progress" |