Subject Re: [firebird-support] Memory problem, isc_attach_database failed
Author Helen Borrie
At 03:59 PM 18/08/2009, you wrote:
>Hello
>
>RDBMS 2.0 .. to latest.
>We have database which have 8 secondary files.
>First file size is 1,73GB and secondary file sizes are 8KB (all eight secondary files).
>
>Now the situation is that we get following messages: isc_attach_database failed with SQL message 904 (Unsuccesfully execution caused by an unavailable resource.), Engine Code 335544430 (unable to allocate memory from operating system).
>We have tried open database in several computers but no luck.
>
>Is there anything to do or have we lost all data?

It's unlikely you have lost all data, but you are not providing much information.

1. Have you checked to make sure you have all nine files together?

2. "RDBMS 2.0 .. to latest" - what does this mean?

3. What platform (OS and hardware) ?

4. What version and model (Superserver/Classic/Embedded) ?

5. Do you have a backup of this database, that you could restore in a safe place and get information about the header?

6. Do you have any TempDirectories configured in firebird.conf? Do they exist?

7. And, out of curiosity, why do you need 8 secondary files?

./heLen