#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2014
    Posts
    4
    Rep Power
    0

    Unable to allocate memory from OS


    Hi,

    I am currently using FB 2.1 (32bit) on Windows 7 64bit. When I tried to connect to a database file (size 11 GB) using IBOConsole or IBExpert, I got an error message saying "unable to allocate memory from operating system". In fact, i have free memory of 13GB and free HDD space of about 1 TB.

    Anyone has any idea what is going on?

    Thanks in advance.

    Comments on this post

    • mariuz agrees
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2010
    Posts
    43
    Rep Power
    4
    What exact 2.1 version are you using? Your problem might be related to:

    http://tracker.firebirdsql.org/browse/CORE-3791

    More in-depth information on that problem is available here:
    http://dyemanov.blogspot.co.at/2012/...m-caching.html
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2014
    Posts
    4
    Rep Power
    0
    Thanks for your reply! Appreciate it!

    I m using FB v2.1.5.18496

    Will check out the link. Thanks!
  6. #4
  7. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2010
    Posts
    43
    Rep Power
    4
    As 2.1.5 has this fixed, it isn't the cause then. Are you using SuperServer or Classic? If SuperServer, then with 32-bit you probably simply hit the 32-bit limit from a memory POV?

    Comments on this post

    • mariuz agrees
  8. #5
  9. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2014
    Posts
    4
    Rep Power
    0
    Sorry, I have been away last few weeks and not able to reply.

    I managed to fix the problem. What I did:

    1. Uninstall 32 bit FB.
    2. Install 64 bit FB.
    3. Try connect to database.
    4. This time different message popped up: Implementation limit exceeded. Transaction count exceeded. Perform backup and restore to make database operable again."
    4. Google for solution.
    5. Set database to read-only using gfix.
    6. Then backup.
    7. Then restore.
    8. Try connect again, and it works!

    Hope above information helps.

IMN logo majestic logo threadwatch logo seochat tools logo