Re: ERROR: concurrent insert in progress

use REINDEX

REINDEX ip_dst_idx

OR

REINDEX table_name

http://www.postgresql.org/docs/8.3/static/sql-reindex.html

tell us the result

thank

--- On Fri, 6/27/08, Ganbold <ganbold(at)micom(dot)mng(dot)net> wrote:
From: Ganbold <ganbold(at)micom(dot)mng(dot)net>
Subject: [GENERAL] ERROR: concurrent insert in progress
To: pgsql-general(at)postgresql(dot)org
Date: Friday, June 27, 2008, 3:04 AM

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