[#CORE-3841] Corrupted database after inserting rows

Firebird Core

Corrupted database after inserting rows

Created: 04/May/12 04:01 PM Updated: 23/Apr/13 01:51 PM

Component/s:

Engine

Affects Version/s:

2.1.0, 2.1.1, 2.0.5, 2.1.2, 2.1.3, 3.0 Initial, 2.0.6, 2.5.0, 2.1.4, 2.5.1, 2.0.7

Fix Version/s:

2.1.5, 2.5.2, 3.0 Alpha 1

Time Tracking:

Not Specified

Environment:

Windows

Issue Links:

Duplicate

This issue duplicates:

~~CORE-3839~~ Values disappearing from index

Relate

This issue relate to:

~~CORE-3844~~ Validation not detects one specific case of index corruption

Planning Status:

Unspecified

Description

« Hide

I have sql script that can reproducibly corrupt the database just by inserting some rows,
validation then shows errors like this:

PRENOSIL (Server) Fri May 04 19:21:52 2012
Database: C:\TEMP\TEST.FDB
Index 3 is corrupt on page 14769 level 0. File: ..\..\..\src\jrd\validation.cpp, line: 1542
in table PRIJEMKAH (220)

(I will send the link to download test case by request)

All

Comments

Work Log

Change History

Version Control

Subversion Commits

Sort Order:

[ Permalink | « Hide ]

Sean Leyne added a comment - 04/May/12 05:04 PM

Please attach the scripts to this case.

[ Permalink | « Hide ]

Vlad Khorsun added a comment - 04/May/12 06:24 PM

Ivan sent me links privately and i reproduced and confirmed the bug.
I think it is the same bug as in ~~CORE-3839~~ and it is again about descending index.

[ Permalink | « Hide ]

Vlad Khorsun added a comment - 11/May/12 07:49 PM

The bug was introduced in v2.0.0 with ODS11 and new index structure

[ Permalink | « Hide ]

prenosil added a comment - 18/May/12 10:02 AM

Tested on full version of script (which generated much more errors than the sample script I sent), and everything is o.k. now. Thanks.