Vacuum Crash

Richard Lynch wrote:

PostgreSQL 6.3.2 said:

NOTICE: BlowawayRelationBuffers(places, 322): block 336 is referenced
(private 0, last 0, global 1)
FATAL 1: VACUUM (vc_rpfheap): BlowawayRelationBuffers returned -2

And now I need to go find the vacuum lock file and blow it away, but I
don't really understand the above message, so wanna ask if I need to worry
about it...

Restart postmaster, remove pg_vlock file and run vacuum again.

Vadim

Using pg_dump with 6.5b1 on solaris sparc, crashes with a core dump.

This means I can't keep backups and I can't upgrade my data model without
being able to export the old data.

If one of the developers wants debug info let me know what you need (e.g.,
what commands to run in gdb--though I'll have to install this or get run
permissions from the sysadmin).

-- Ari Halberstadt mailto:ari@shore.net <http://www.magiccookie.com/&gt;
PGP public key available at <http://www.magiccookie.com/pgpkey.txt&gt;

Beta1 is kind of old. Also, this is clearly a hackers list question. I
recommend you try the most recent snapshot from ftp.postgresql.org.

Using pg_dump with 6.5b1 on solaris sparc, crashes with a core dump.

This means I can't keep backups and I can't upgrade my data model without
being able to export the old data.

If one of the developers wants debug info let me know what you need (e.g.,
what commands to run in gdb--though I'll have to install this or get run
permissions from the sysadmin).

-- Ari Halberstadt mailto:ari@shore.net <http://www.magiccookie.com/&gt;
PGP public key available at <http://www.magiccookie.com/pgpkey.txt&gt;

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026