: [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 19
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
use REINDEX
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
Ganbold <[EMAIL PROTECTED]> writes:
> I have problem with my DB:
> ERROR: could not read block 988 of relation 1663/16384/16472:
> Input/output error
> How to solve this problem?
First, replace your failed disk; then get out your backups and restore
your system ...
reg
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
H
