Re: Vacuum analyze problem - Mailing list pgsql-admin

From Tom Lane
Subject Re: Vacuum analyze problem
Date
Msg-id 26147.983500441@sss.pgh.pa.us
Whole thread Raw
In response to RE: Vacuum analyze problem  (John Hatfield <jhatfield@g-s.com.au>)
List pgsql-admin
John Hatfield <jhatfield@g-s.com.au> writes:
> The last bit of vacuum verbose analyse
> NOTICE:  --Relation pg_rewrite--
> pqReadData() -- backend closed the channel unexpectedly.

OK, so pg_rewrite seems to be broken.  Not good...

> This GDB was configured as "i386-redhat-linux"..."/var/lib/pgsql/data/base/gsmai
> n_test/core": not in executable format: File format not recognized

You need to do "gdb /path/to/postgres/executable core".

Or try it like this instead:

    * fire up psql in one window
    * determine PID of backend connected to psql
    * attach to live backend process with gdb:
        gdb /path/to/postgres/executable
        attach PID
        cont
    * issue vacuum command to psql

gdb should catch the crash and then you can issue "bt".

            regards, tom lane

pgsql-admin by date:

Previous
From: John Hatfield
Date:
Subject: RE: Vacuum analyze problem
Next
From: John Hatfield
Date:
Subject: RE: Vacuum analyze problem