ERROR: concurrent insert in progress

Поиск
Список
Период
Сортировка
От Ganbold
Тема ERROR: concurrent insert in progress
Дата
Msg-id 486458CD.1050006@micom.mng.net
обсуждение исходный текст
Ответ на Re: ERROR: could not open relation with OID 2836  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: ERROR: concurrent insert in progress  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: ERROR: concurrent insert in progress  (Lennin Caro <lennin.caro@yahoo.com>)
Re: ERROR: concurrent insert in progress  (Lennin Caro <lennin.caro@yahoo.com>)
Список pgsql-general
Hi,

I have problem with my DB:

snort=# vacuum full;
WARNING:  index "ip_src_idx" contains 1921678 row versions, but table
contains 1921693 row versions
HINT:  Rebuild the index with REINDEX.
WARNING:  index "ip_dst_idx" contains 1921668 row versions, but table
contains 1921693 row versions
HINT:  Rebuild the index with REINDEX.
ERROR:  could not read block 988 of relation 1663/16384/16472:
Input/output error
snort=# reindex index ip_src_idx;
ERROR:  concurrent insert in progress


How to solve this problem? Is there any other method fixing the index?

thanks in advance,

Ganbold

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: ERROR: could not open relation with OID 2836
Следующее
От: Tom Lane
Дата:
Сообщение: Re: ERROR: concurrent insert in progress