Re: ERROR: concurrent insert in progress

[Ganbold <ganbold@xxxxxxxxxxxxx>]

It shows following when I try to reindex:

snort=# reindex index ip_src_idx;
ERROR: concurrent insert in progress

So I think it might be hard disk problem as Tom suggested.
Unfortunately I don't have replacement hard disk now, so I guess
I might change the DB location for a while.

thanks,

Ganbold


Lennin Caro wrote:
> 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@xxxxxxxxxxxxx>/* wrote:
>
>     From: Ganbold <ganbold@xxxxxxxxxxxxx>
>     Subject: [GENERAL] ERROR: concurrent insert in progress
>     To: pgsql-general@xxxxxxxxxxxxxx
>     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
>
>     -- 
>     Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
>     To make changes to your subscription:
>     http://www.postgresql.org/mailpref/pgsql-general