Search Postgresql Archives

ERROR: concurrent insert in progress

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux