Subject RE: [firebird-support] info
Author Paul Beach
Try the following...

Partner index description not found (175))

internal gds software consistency check (partner index description not found.
Missing index for a primary or a foreign key. The problem may be caused by
physical database corruption or by a bug.

Recovery process:

To find the missing index, use following SELECT statement:

select R.RDB$CONSTRAINT_NAME, R.RDB$INDEX_NAME as REFINDEXNAME,
I.RDB$INDEX_NAME as REALINDEX, I.RDB$RELATION_NAME, I.RDB$INDEX_INACTIVE
from RDB$INDICES I RIGHT
JOIN RDB$RELATION_CONSTRAINTS R on I.RDB$INDEX_NAME = R.RDB$INDEX_NAME
where R.RDB$CONSTRAINT_TYPE = 'FOREIGN KEY'
or R.RDB$CONSTRAINT_TYPE = 'PRIMARY KEY'
order by R.RDB$CONSTRAINT_NAME

The contraint that is missing an index (where column REALINDEX is empty) will be
corrupted. Try and recreate this constraint.

Paul