unexpected "ERROR: concurrent delete in progress"

Поиск
Список
Период
Сортировка
От Jon Nelson
Тема unexpected "ERROR: concurrent delete in progress"
Дата
Msg-id AANLkTimd_Zx0wbs9KazRbO11jD301=9p=KpUXqij9oGr@mail.gmail.com
обсуждение исходный текст
Ответы Re: unexpected "ERROR: concurrent delete in progress"  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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):

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.


--
Jon

В списке pgsql-bugs по дате отправления:

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: i need some help on installing all the stuff
Следующее
От: Tom Lane
Дата:
Сообщение: Re: unexpected "ERROR: concurrent delete in progress"