Issue Details (XML | Word | Printable)

Key: CORE-4845
Type: Bug Bug
Status: Open Open
Priority: Major Major
Assignee: Unassigned
Reporter: Alex Gilev
Votes: 0
Watchers: 1

If you were logged in you would be able to see more operations.
Firebird Core

GBAK fails for big tables with BLOBs

Created: 23/Jun/15 02:40 PM   Updated: 24/Jun/15 07:31 AM
Component/s: GBAK
Affects Version/s: 2.5.2
Fix Version/s: None

Environment: Windows 2003/7/etc, 32bit

QA Status: No test

 Description  « Hide
While performing backup for big database (about 90 Ggb) GBAK fails with error:
gbak:error accessing BLOB column EXT_INFO -- continuing
gbak: ERROR:unable to allocate memory from operating system

It stops working after writing about 10 millions records, Firebird "eat" at this moment about 2Ggb memory. Tested with Firebird 64 at another PC and it perfomed backup well.

We have about 20 PCs with such databases and Windows 32bit (so Firebird 32 bit too) and it's not very easy to migrate all this PCs to Win64. Maybe it's possible to make some fix in Firebird to "eat" less memory while perform such backups?

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Dmitry Yemanov added a comment - 23/Jun/15 03:07 PM
Looks very similar to CORE-3802. Do you use official v2.5.2 build 26539 or some snapshot build?

Alex Gilev added a comment - 24/Jun/15 07:31 AM
Yes, we use official I saw CORE-3802, but there is problem with restore and computed fields, we have not computed fields. I can try to upgrade to 2.5.4, maybe our problem fixed there?