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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Michael Charnoky" <noky(at)nextbus(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #3752: query yields "could not find block containing chunk", then server crashes
Date: 2007-11-16 16:00:14
Message-ID: 12942.1195228814@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Michael Charnoky" <noky(at)nextbus(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2007-11-16 19:55:22 Re: B-tree crash recovery error in 8.3 beta 2
Previous Message Lance J. Andersen 2007-11-16 15:46:40 Re: BUG #3751: Conversion error using PreparedStatement.setObject()