29 Mar 2012 15:47
[FB-Tracker] Created: (CORE-3802) Firebird 2.5.2 runs out of memory while restoring database backup
Artem Petkevych (JIRA <tracker <at> firebirdsql.org>
2012-03-29 13:47:26 GMT
2012-03-29 13:47:26 GMT
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)
RSS Feed