From: | Mike Mascari <mascarim(at)yahoo(dot)com> |
---|---|
To: | Michael Simms <grim(at)argh(dot)demon(dot)co(dot)uk> |
Cc: | pgsql-general(at)postgreSQL(dot)org |
Subject: | Re: [GENERAL] Bug Report |
Date: | 1999-08-07 19:50:05 |
Message-ID: | 19990807195005.5998.rocketmail@web128.yahoomail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Who knows why this occurred, but to be able to
vacuum again:
1. Stop and restart the postmaster - this will
eliminate the CreatePortal() problem.
2. Ensure there isn't a pg_vlock file in the
$PGDATA/base/<dbname> directory.
3. Drop and recreate the index search_url_refnum_key
4. Vacuum away...
Hope that helps,
Mike Mascari (mascarim(at)yahoo(dot)com)
--- Michael Simms <grim(at)argh(dot)demon(dot)co(dot)uk> wrote:
> I have just found a bug in 6.5.1
>
> >vacuum;
> NOTICE: BlowawayRelationBuffers(search_url, 5):
> block 106 is referenced (private 0, last 0, global
> 1)
> pqReadData() -- backend closed the channel
> unexpectedly.
> This probably means the backend terminated
> abnormally
> before or while processing the request.
> We have lost the connection to the backend, so
> further processing is impossible. Terminating.
>
> >vacuum;
> NOTICE: Index search_url_refnum_key: NUMBER OF
> INDEX' TUPLES (96) IS NOT THE SAME AS HEAP' (192)
> ERROR: Cannot insert a duplicate key into a unique
> index
>
> >vacuum
> NOTICE: CreatePortal: portal <vacuum> already
> exists
>
> NOTICE: Index search_url_refnum_key: NUMBER OF
> INDEX' TUPLES (96) IS NOT THE SAME AS HEAP' (192)
> ERROR: Cannot insert a duplicate key into a unique
> index
>
>
> Looks like I cant vacuum my database any more.
>
> M Simms
_____________________________________________________________
Do You Yahoo!?
Bid and sell for free at http://auctions.yahoo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Simms | 1999-08-07 20:01:03 | Re: [GENERAL] Bug Report |
Previous Message | Hub.Org News Admin | 1999-08-07 19:47:55 |