Обсуждение: PANIC: XX000: right sibling is not next child in "pg_depend_reference_index"

Поиск
Список
Период
Сортировка

PANIC: XX000: right sibling is not next child in "pg_depend_reference_index"

От
Ryan Gran
Дата:
DEBUG:  00000: StartTransactionCommand
LOCATION:  start_xact_command, postgres.c:1981
DEBUG:  00000: ProcessQuery
LOCATION:  ProcessQuery, pquery.c:128
STATEMENT:  INSERT INTO links VALUES ($1, $2, $3)
PANIC:  XX000: right sibling is not next child in
"pg_depend_reference_index"
LOCATION:  _bt_pagedel, nbtpage.c:983
DEBUG:  00000: reaping dead processes
LOCATION:  reaper, postmaster.c:2027
LOG:  00000: autovacuum process (PID 5338) was terminated by signal 6
LOCATION:  LogChildExit, postmaster.c:2431
LOG:  00000: terminating any other active server processes

This error is occurring about once a day.  I believe it the result of a
less-then-graceful shutdown.  Using 8.1.0 under OS/X.  Have tried
vacuuming and reindexing to no avail

Re: PANIC: XX000: right sibling is not next child in "pg_depend_reference_index"

От
Tom Lane
Дата:
Ryan Gran <ryan@cnvi.com> writes:
> PANIC:  XX000: right sibling is not next child in
> "pg_depend_reference_index"

Perhaps this is explained here?
http://archives.postgresql.org/pgsql-general/2006-04/msg00848.php

> Using 8.1.0 under OS/X.

You are of course aware that we are up to 8.1.4, and there were pretty
dang compelling reasons for each one of those four update releases.
http://developer.postgresql.org/docs/postgres/release.html

            regards, tom lane