At 09:12 PM 4/01/2007, you wrote:

>upgading a database from 1.5.2 on one Linux server to 2.0 on a
>different server fails with errors shown below
>
>The same backup file does restore into a new file under 1.5.2 on the
>original Linux server and into 2.0.0 on a Win XP desktop.
>
>I have also tried taking a backup on the Win 2.0 PC an restoring that
>on the Linux 2.0 server with similar results.
>
>Ths index's that fail are simple, eg
>
>CREATE INDEX MRP_IDX1 ON MRP (STOCK_CODE);
>CREATE INDEX MRP_IDX2 ON MRP (STOCK_CODE, PROGRESS);
>where
> STOCK_CODE VARCHAR(20) CHARACTER SET WIN1252 NOT NULL,
> PROGRESS INTEGER DEFAULT 0 NOT NULL,
>
>All the data appears to have transferred so if pushed I could delete
>the index's, do the backup/restore and then restore the index's,
>
>Any clues appreciated
>
>Dr John
>
>
>
>gbak: activating and creating deferred index MRPSELECT_IDX1
>gbak: activating and creating deferred index MRPSELECT_IDX4
>gbak: activating and creating deferred index MRP_IDX1
>gbak:cannot commit index MRP_IDX1
>gbak: ERROR:I/O error for file ""
>gbak: ERROR: Error while trying to open file
>gbak: ERROR: No such file or directory
>gbak: activating and creating deferred index MRP_IDX2
>gbak:cannot commit index MRP_IDX2
>gbak: ERROR:I/O error for file ""
>gbak: ERROR: Error while trying to open file
>gbak: ERROR: No such file or directory
>gbak: activating and creating deferred index MRP_IDX3
>gbak:cannot commit index MRP_IDX3
>gbak: ERROR:I/O error for file ""
>gbak: ERROR: Error while trying to open file
>gbak: ERROR: No such file or directory
>gbak: activating and creating deferred index PK_MRP
>gbak:cannot commit index PK_MRP
>gbak: ERROR:I/O error for file ""
>gbak: ERROR: Error while trying to open file
>gbak: ERROR: No such file or directory
>gbak: ERROR:action cancelled by trigger (3) to preserve data integrity
>gbak: ERROR: Cannot deactivate index used by a PRIMARY/UNIQUE
>constraint
>gbak:Exiting before completion due to errors

Is the server (user 'firebird') able to find/access the /opt/intl
directory and the file fbintl? It needs to do so in order to read
the collation rules for the character set. Check the permissions.

Did you know that there is a switch ( -i) in gbak to restore without indexes?

./heLen