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