Re: [Firebird-devel] Small problem with "alter database add difference file"

[Ivan P. <iva...@se...>]

>> Try to specify illegal name
>>
>> ====================
>> alter database add difference file '****';
>>
>> alter database begin backup;
>>
>> Statement failed, SQLCODE = -902
>> [335544344] I/O error during "CreateFile (create)" operation for file
>> "****" [335544733] -Error while trying to create file
>> [14696098] -(Incorrect file name).
>>
>> alter database end backup;
>>
>> Statement failed, SQLCODE = -607
>> [335544351] unsuccessful metadata update
>> [335544382] -Database is not in the physical backup mode
>>
>> alter database drop difference file;
>>
>> Statement failed, SQLCODE = -607
>> [335544351] unsuccessful metadata update
>> [335544832] -Cannot change difference file name while database is in backup
>> mode
>>
>> ====================
>>
>> The engine is a bit confused whether it is in backup mode or not :)
>> The "drop difference file" will succeed only after disconnecting all
>> connections. (tested with FB2.5RC2, Superserver, WinXP)
> 
> Sorry, can't reproduce.
> 
> # ./isql -user sysdba -pas masterke employee
> Database:  employee, User: sysdba
> SQL> alter database add difference file '****';
> SQL> alter database begin backup;
> SQL> alter database end backup;
> SQL> alter database drop difference file;
> SQL>
> 
> No errors at all.

I guess it is because asterisk is legal filename on Linux.
Try to specify e.g. non existent directory. I got the same error with e.g.

  alter database add difference file 'c:\nonexistentdir\a.b';

--------

Here is something similar, connect to db without difference file defined and do:

alter database begin backup;
alter database end backup;
alter database add difference file 'c:\x.x';

Statement failed, SQLCODE = -607
[335544351] unsuccessful metadata update
[335544382] -STORE RDB$FILES failed
[14695426] -message length error (encountered 276, expected 278)