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

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

<snip>

Mike Mascari (mascarim@yahoo.com)

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

Michael