ERROR: concurrent insert in progress

From: Ganbold <ganbold(at)micom(dot)mng(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: ERROR: concurrent insert in progress
Date: 2008-06-27 03:04:45
Message-ID: 486458CD.1050006@micom.mng.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2008-06-27 04:06:32 Re: ERROR: concurrent insert in progress
Previous Message Tom Lane 2008-06-27 02:23:07 Re: ERROR: could not open relation with OID 2836