search

FirebirdSQL / firebird

Firebird server, client and tools
https://www.firebirdsql.org/
1.24k stars 214 forks source link

GBAK fails for big tables with BLOBs [CORE4845] #5141

Open firebird-automations opened 9 years ago

firebird-automations commented 9 years ago

Submitted by: Alex Gilev (xstarter)

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?

firebird-automations commented 9 years ago

Commented by: @dyemanov

Looks very similar to CORE3802. Do you use official v2.5.2 build 26539 or some snapshot build?

firebird-automations commented 9 years ago

Commented by: Alex Gilev (xstarter)

Yes, we use official 2.5.2.26539. I saw CORE3802, 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?