Subject | RE: [firebird-support] info |
---|---|
Author | Paul Beach |
Post date | 2017-12-22T12:15:36Z |
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
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