Hi,
I've dug around a bit more and things seem to be going wrong in
access/nbtree/nbtsearch.c. I've printed out everything that seemed even remotely
relevant and I'm hoping that somebody can tell me what is going on here. Is this
just a corruption of the index? I know dropping and re-creating a system index
is not allowed, but is there some way that I could disable that check and
recreate the index?
Regards,
Adriaan
in _bt_step at line 1131
(ladebug) p *opaque
struct BTPageOpaqueData { btpo_prev = 1949202277; btpo_next = 745239393; btpo_parent = 779576686; btpo_flags = 25705;
}
(ladebug) p page
0x1400fac70="\024"
(ladebug) p *rel
struct RelationData { rd_fd = 14; rd_nblocks = 0; rd_refcnt = 1; rd_myxactonly = '\000'; rd_isnailed = '\000';
rd_isnoname= '\000'; rd_nonameunlinked = '\000'; rd_am = 0x14024a000; rd_rel = 0x1402486d0; rd_id = 17030; lockInfo =
0x14024e430="\206B";rd_att = 0x1401d3df0; rd_rules = 0x0; rd_istrat = 0x14024a410; rd_support = 0x140249fe0; trigdesc =
0x0;
}
(ladebug) p *(rel->rd_am)
struct FormData_pg_am { amname = union nameData { data = "btree"; alignmentDummy = 1701999714; }; amowner = 2001;
amkind= 'o'; amstrategies = 5; amsupport = 1; amgettuple = 330; aminsert = 331; amdelete = 332; amgetattr = 0;
amsetlock= 0; amsettid = 0; amfreetuple = 0; ambeginscan = 333; amrescan = 334; amendscan = 335; ammarkpos = 336;
amrestrpos= 337; amopen = 0; amclose = 0; ambuild = 338; amcreate = 0; amdestroy = 0;
}
(ladebug) p *(rel->rd_rel)
struct FormData_pg_class { relname = union nameData { data = "pg_proc_prosrc_index"; alignmentDummy = 1885300592;
};reltype = 0; relowner = 2001; relam = 403; relpages = 22; reltuples = 1073; relhasindex = '\000'; relisshared =
'\000';relkind = 'i'; relnatts = 1; relchecks = 0; reltriggers = 0; relukeys = 0; relfkeys = 0; relrefs = 0; relhaspkey
='\000'; relhasrules = '\000'; relacl = [0] = 0;
}
(ladebug) p *(rel->rd_att->attrs[0]) [ Only one attribute ]
struct FormData_pg_attribute { attrelid = 17030; attname = union nameData { data = "prosrc"; alignmentDummy =
1936683632;}; atttypid = 25; attdisbursion = 0; attlen = -1; attnum = 1; attnelems = 0; attcacheoff = -1; atttypmod =
-1;attbyval = '\000'; attisset = '\000'; attalign = 'i'; attnotnull = '\000'; atthasdef = '\000';
}