Subject Re: Memory problem, isc_attach_database failed
Author parviainen.petri
--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@...> wrote:
>
> 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
>
1. yes and we are working on with the copy.
2. checked and tested firebird release 2.0. to 2.1.2
3. WinXP pro and Vista Business
4. Superserver
5. I can register database but when I try connect then I get those errors.
6. No
7. Think about file sizes on firebird. (and we have started with interbase long time ago)