Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Corrupted database after inserting rows [CORE3841] #4183

Closed
firebird-automations opened this issue May 4, 2012 · 13 comments
Closed

Corrupted database after inserting rows [CORE3841] #4183

firebird-automations opened this issue May 4, 2012 · 13 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: prenosil (prenosil)

Relate to CORE3844
Duplicates CORE3839

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)

Commits: 7b9dd04 2c7bcf9 eda40f7

====== Test Details ======

> Ivan sent me links privately...
No script - no test.

@firebird-automations
Copy link
Collaborator Author

Commented by: Sean Leyne (seanleyne)

Please attach the scripts to this case.

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

assignee: Vlad Khorsun [ hvlad ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @hvlad

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

@firebird-automations
Copy link
Collaborator Author

Commented by: @hvlad

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

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

Version: 2.0.7 [ 10390 ]

Version: 2.1.4 [ 10361 ]

Version: 2.5.0 [ 10221 ]

Version: 2.0.6 [ 10303 ]

Version: 3.0 Initial [ 10301 ]

Version: 2.1.3 [ 10302 ]

Version: 2.1.2 [ 10270 ]

Version: 2.0.5 [ 10222 ]

Version: 2.1.1 [ 10223 ]

Version: 2.1.0 [ 10041 ]

Version: 2.5.2 [ 10450 ] =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 2.5.2 [ 10450 ]

Fix Version: 3.0 Alpha 1 [ 10331 ]

Fix Version: 2.1.6 [ 10460 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

Link: This issue relate to CORE3844 [ CORE3844 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: prenosil (prenosil)

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

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Fix Version: 2.1.5 [ 10420 ]

Fix Version: 2.1.6 [ 10460 ] =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

Link: This issue duplicates CORE3839 [ CORE3839 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

status: Resolved [ 5 ] => Closed [ 6 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

status: Closed [ 6 ] => Closed [ 6 ]

QA Status: No test

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

status: Closed [ 6 ] => Closed [ 6 ]

QA Status: No test => Not enough information

Test Details: > Ivan sent me links privately...
No script - no test.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment