Re: [Firebird-test] Database that will not restore using Firebird 2.0 Alpha

[Pavel C. <pc...@ib...>]

Steve Landrum wrote:
> Hi all.
> 
> Thank you all for an execelent job done on Firebird 2.0.  I have been 
> testing the program with several databases and so far have only found 1 
> issue with 1 database.
> 
> Operating System WinXP SP2
> Firebird Superserver
> Local restore using gbak did not try with the services api.
> 30 Gig free on the drive.
> Athalon64 3400 processor.
> 
> Found a database I can't restore.  This database does restore properly 
> using 1.5.2 It looks like the restore fails when trying to add a role to 
> the database. The error message varies depending the switches used so 
> there may be more than one issue here.
> 
> When restoring regularly with just the -c switch the error message is.
> 
> D:\>"c:\program files\firebird\firebird_2_0\bin\gbak" -c -user sysdba 
> -password
> masterkey d:\db\master.gbk d:\db\master.fdb
> 
> gbak: ERROR:attempted update of read-only column
> gbak:Exiting before completion due to errors
> 
> Using switch -c -i the message is
> 
> D:\>"c:\program files\firebird\firebird_2_0\bin\gbak" -c -v -i -user sysdba
> -password masterkey d:\db\master.fbk d:\db\master.fdb
> 
> gbak:    restoring privilege for user SYSDBA
> gbak:    restoring privilege for user SYSDBA
> gbak:restoring SQL role: TREADWARE
> gbak:creating indexes
> gbak:    committing metadata
> gbak: ERROR:attempted update of read-only column
> gbak:Exiting before completion due to errors

I can confirm that this issue exists, as I've got another such report.

> I have the metadata backup that will reproduce this if needed.

Yes, that would be most helpful. Could you create a bug tracker entry 
for it in Field-test tracker? You can attach the backup to it.

Best regards
Pavel Cisar