Re: [GENERAL] ERROR: concurrent insert in progress

[Ganbold]

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 /<[EMAIL PROTECTED]>/* wrote:

    From: Ganbold <[EMAIL PROTECTED]>
    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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general