Subject Re: [firebird-support] Corrupted indexes still corrupt after restore
Author Helen Borrie
At 04:04 PM 17/07/2005 +0200, you wrote:
>Hi,
>
>this is an issue from a german newsgroup:
>during an update, someone received the following error when updating
>a table:
>
>internal gds software consistency check (partner index description not found
>(175))
>
>As this is an error that was often discussed before, I told the poster
>to recreate all indexes and foreign key indexes related to the
>table in question. This fixed the problem.
>
>It was quite interesting for me that the poster mentioned that a
>backup and restore did not fix the problem. AFAIU gbak pumps the data
>from the backup file into a new file and then creates the indexes.
>As the indexes were renewed during the restore, why did the original
>poster still receive the "partner index description not found" error?

Probably the restore would not have worked and the rebuilding of the
indexes was done on the original database (or a copy of it).

./hb