gfix & "Index x is corrupt (missing entries) in table ..." all indexes on
large tables
---------------------------------------------------------------------------------------
Key: CORE-3916
URL: http://tracker.firebirdsql.org/browse/CORE-3916
Project: Firebird Core
Issue Type: Bug
Components: GFIX
Affects Versions: 2.5.1
Environment: Win2008 x86, Firebird 2.5.1, 2.5.2 (x86)
Reporter: Viktor Belzetskiy
Attachments: test_corrupt.zip
gfix with the keys "-validate-no_update-full" always gives the error "Index x
is corrupt (missing entries) in table ..." for all table indexes size 2487410
or more pages. Database page size 16K.
To receive this error, you must fill 500 million records.
script:
================================================================
CREATE TABLE REP_ATOM_BRICK_DRUGS_DATA (
PERIOD_ID INTEGER,
BRICK_CODE VARCHAR(5),
DRUGS_ID INTEGER,
IS_DUMP INTEGER,
V DOUBLE PRECISION,
Q DOUBLE PRECISION,
PRT DOUBLE PRECISION
);
CREATE UNIQUE INDEX REP_ATOM_BRICK_DRUGS_DATA_IDX1 ON REP_ATOM_BRICK_DRUGS_DATA
(PERIOD_ID, BRICK_CODE, DRUGS_ID);
CREATE INDEX REP_ATOM_BRICK_DRUGS_DATA_IDX3 ON REP_ATOM_BRICK_DRUGS_DATA
(DRUGS_ID);
================================================================
If necessary, I can send on e-mail archive with empty database and script to
fill it. Archive size 65KB.
--
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
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
