Issue Details (XML | Word | Printable)

Key: CORE-3841
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Vlad Khorsun
Reporter: prenosil
Votes: 0
Watchers: 3
Operations

If you were logged in you would be able to see more operations.
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
 
Relate
 

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: Ascending order - Click to sort in descending order
Sean Leyne added a comment - 04/May/12 05:04 PM
Please attach the scripts to this case.

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.

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

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.