Re: Vacuum analyze problem

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Vacuum analyze problem
Дата
Msg-id 26147.983500441@sss.pgh.pa.us
обсуждение исходный текст
Ответ на RE: Vacuum analyze problem  (John Hatfield <jhatfield@g-s.com.au>)
Список 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 по дате отправления:

Предыдущее
От: John Hatfield
Дата:
Сообщение: RE: Vacuum analyze problem
Следующее
От: John Hatfield
Дата:
Сообщение: RE: Vacuum analyze problem