Re: BUG #3752: query yields "could not find block containing chunk", then server crashes

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #3752: query yields "could not find block containing chunk", then server crashes
Дата
Msg-id 12942.1195228814@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #3752: query yields "could not find block containing chunk", then server crashes  ("Michael Charnoky" <noky@nextbus.com>)
Список pgsql-bugs
"Michael Charnoky" <noky@nextbus.com> writes:
> 2007-11-15 15:38:03.880 PST: ERROR:  could not find block containing chunk
> 0x902fb98

We can't do much about this without a self-contained test case.

> 2007-11-15 15:38:03.880 PST: STATEMENT:  SELECT path_tag, dayset_tag,
> time2secs(ts_endtime), segtimes
>          FROM pathtimes where rev=(select rev from projects) ORDER BY
> time2secs(ts_endtime);

Is this query using any complex views?  If so, I'd assume the bug is
somehow triggered by that, and try to extract a test case using the
view definition(s).

            regards, tom lane

В списке pgsql-bugs по дате отправления:

Предыдущее
От: "Lance J. Andersen"
Дата:
Сообщение: Re: BUG #3751: Conversion error using PreparedStatement.setObject()
Следующее
От: Tom Lane
Дата:
Сообщение: Re: B-tree crash recovery error in 8.3 beta 2