Artem Petkevych (JIRA | 29 Mar 15:47 2012

[FB-Tracker] Created: (CORE-3802) Firebird 2.5.2 runs out of memory while restoring database backup

Firebird 2.5.2 runs out of memory while restoring database backup
-----------------------------------------------------------------

                 Key: CORE-3802
                 URL: http://tracker.firebirdsql.org/browse/CORE-3802
             Project: Firebird Core
          Issue Type: Bug
          Components: Engine
    Affects Versions: 2.5.2
         Environment: Windows 7 64-bit, RAM 4 gb, Firebird 2.5.2.26449 32-bit
            Reporter: Artem Petkevych

While restoring table with array fields, Firebird consumes all available memory and restore fails with
error "unable to allocate memory from operating system". Same backup can be successfully restored by
Firebird 2.1.4. DDL of the table is:

CREATE TABLE RVG (
    RYEAR   SMALLINT NOT NULL,
    INS_ID  BIGINT NOT NULL,
    S1      DECIMAL(18,2),
    S16     DECIMAL(18,2),
    R1      DECIMAL(18,2) [1:12],
    R4      DECIMAL(18,2) [1:4],
    R5      DECIMAL(18,2) [1:4],
    R6      DECIMAL(18,2) [1:4],
    VK1     COMPUTED BY (R1[1]+R1[2]+R1[3]),
    VK2     COMPUTED BY (R1[4]+R1[5]+R1[6]),
    VK3     COMPUTED BY (R1[7]+R1[8]+R1[9]),
    VK4     COMPUTED BY (R1[10]+R1[11]+R1[12]),
    VG      COMPUTED BY (R1[1]+R1[2]+R1[3]+R1[4]+R1[5]+R1[6]+R1[7]+R1[8]+R1[9]+R1[10]+R1[11]+R1[12]),
(Continue reading)


Gmane