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

Re: ERROR: concurrent insert in progress

From: Ganbold <ganbold(at)micom(dot)mng(dot)net>
To: lennin(dot)caro(at)yahoo(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: ERROR: concurrent insert in progress
Date: 2008-06-28 07:10:45
Message-ID: 4865E3F5.4080000@micom.mng.net (view raw or flat)
Thread:
Lists: pgsql-general
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(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
>
>     -- 
>     Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
>     To make changes to your subscription:
>     http://www.postgresql.org/mailpref/pgsql-general
>
>


In response to

pgsql-general by date

Next:From: Bob DuffeyDate: 2008-06-28 07:53:04
Subject: Re: query planner weirdness?
Previous:From: Steve AtkinsDate: 2008-06-28 05:50:39
Subject: Re: query planner weirdness?

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