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]),
R3 INTEGER [1:4]
);
ALTER TABLE RVG ADD CONSTRAINT PK_RVG PRIMARY KEY (RYEAR, INS_ID);
Table has 5454042 rows. Error occurs after 2560000 records restored.
To reproduce issue one can download backup from this URL:
http://www.protec.kiev.ua/~artem/db/rvg.7z
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
This SF email is sponsosred by:
Try Windows Azure free for 90 days Click Here
http://p.sf.net/sfu/sfd2d-msazure
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
