Re: [GENERAL] Bug Report

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

>
> Who knows why this occurred, but to be able to
> vacuum again:

<snip>

> Mike Mascari (mascarim(at)yahoo(dot)com)

Thanks for the help, it is all happily working now.

Michael