Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group