> --- In firebird-support@yahoogroups.com, Thomas Steinmaurer <ts@...> wrote:
>>
>>> --- In firebird-support@yahoogroups.com, Thomas Steinmaurer <ts@> wrote:
>>>>
>>>>> I am migrating FB 1.5 databases on a Linux box to FB 2.5 on a Windows server. All proceeded according to plan. However, I have one database that is complaining. I backed it up from the command prompt. I use IBExpert as my front end on the Windows machine, and use it to restore my databases.
>>>>>
>>>>> The sick database seems to function correctly, but will not restore from a backup. I can provide a log of the restore if someone would like to look at it.
>>>>
>>>> Any error message upon restore?
>>>>
>>>>
>>>> --
>>>> With regards,
>>>> Thomas Steinmaurer
>>>> http://www.upscene.com/
>>>>
>>> Plenty. I have the log
>>
>> Is it too long for posting it here?
>>
>> Usually the last part of the restore log including the error message
>> should be sufficient.
>>
>> --
>> With regards,
>> Thomas Steinmaurer
>> http://www.upscene.com/
>>
>
> Here is a chunk that has the errors in it
>
> gbak: restoring column UNITS_PK
> gbak: restoring column MULTIPLIER
> gbak: restoring column PIECES
> gbak: restoring column SUPPLIER_ORDER_NO
> gbak:committing metadata for table ORDERS
> gbak:error committing metadata for table ORDERS
> gbak: ERROR:unsuccessful metadata update
> gbak: ERROR: ORDERS
> gbak: ERROR: Implementation of text subtype 65280 not located.

This seems to be an inconsistency in Firebird 1.5 system tables, which
strikes back when restoring under Firebird 2.

Can you please run the following SQL on the 1.5 database?

select
rdb$collation_id
, count(*)
from
rdb$relation_fields
group by
rdb$collation_id



--
With regards,
Thomas Steinmaurer
http://www.upscene.com/