Re: [Firebird-devel] missing pages in rdb$pages?

[John B. <bel...@cs...>]

Hi,

On Saturday, March 30, 2002, at 08:59 AM, John Bellardo wrote:

> [...]
> What is wrong here?  The rdb$pages table seems to indicate there are no 
> pages for the DEPT_BUDGET relation.  But count(*) find 24 rows.  I 
> thought all pages were tracked in rdb$pages?  But rdb$pages clearly 
> doesn't have a root index page for the table, or a pointer page.  What 
> am I missing?  Why is count(*) still working correctly?

I'll help answer my own problem here.  DEPT_BUDGET is a view, so it has 
no pages in the database (no duh!).  I need to look into the problem 
more.

>
> This problem is causing FB2 some grief when it does the count(*) 
> query.  As part of fetching the next record (DPM_next, I believe) 
> get_pointer_page (in DPM) gets called, which in turn calls 
> DPM_scan_pages.  DPM_scan_pages never finds a pointer page for the 
> table because rdb$pages doesn't list one.  This causes the pointer page 
> vector in the relation object to be NULL, which causes get_pointer_page 
> to return NULL and DPM_next to throw the exception BUGCHECK(249) /* msg 
> 249 pointer page vanished from DPM_next */

-John