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@yahoo.com)


--- Michael Simms <grim@argh.demon.co.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