Re: [HACKERS] Index corruption

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';
}