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