Incorrect result set (missing records) may be returned by the ORDER BY query
navigating on an index
---------------------------------------------------------------------------------------------------
Key: CORE-5672
URL: http://tracker.firebirdsql.org/browse/CORE-5672
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 2.5.6
Reporter: Marcel Portner
(CORE-5558)
I had a database where the result set are incorrect, when the query use an
ORDER BY ASC. On this TITITELTHEMA field it has an ascending index.
After a backup/restore everything worked again correctly.
The gfix -v -full give this result:
Summary of validation errors
Number of record level errors : 30
Number of index page errors : 12
This is in the firebird.log:
SOHARDRDUW10 Tue Nov 28 11:34:43 2017
Database: C:\DABIS800\D800_DB\D800.FDB
Index 1 is corrupt (record 18701286 have missing entries) in table TITEL (132)
SOHARDRDUW10 Tue Nov 28 11:34:43 2017
Database: C:\DABIS800\D800_DB\D800.FDB
Index 2 is corrupt (record 18701286 have missing entries) in table TITEL (132)
SOHARDRDUW10 Tue Nov 28 11:34:44 2017
Database: C:\DABIS800\D800_DB\D800.FDB
Index 3 is corrupt on page 93838 level 0 at offset 40. File:
..\..\..\src\jrd\validation.cpp, line: 2181
in table TITEL (132)
SOHARDRDUW10 Tue Nov 28 11:34:44 2017
Database: C:\DABIS800\D800_DB\D800.FDB
Index 3 is corrupt (record 2899481 have missing entries) in table TITEL (132)
SOHARDRDUW10 Tue Nov 28 11:34:44 2017
Database: C:\DABIS800\D800_DB\D800.FDB
Index 5 is corrupt (record 18701286 have missing entries) in table TITEL (132)
SOHARDRDUW10 Tue Nov 28 11:34:44 2017
Database: C:\DABIS800\D800_DB\D800.FDB
Index 7 is corrupt (record 18701286 have missing entries) in table TITEL (132)
SOHARDRDUW10 Tue Nov 28 11:34:45 2017
Database: C:\DABIS800\D800_DB\D800.FDB
Index 8 is corrupt (record 18701286 have missing entries) in table TITEL (132)
SOHARDRDUW10 Tue Nov 28 11:34:45 2017
Database: C:\DABIS800\D800_DB\D800.FDB
Index 12 is corrupt (record 18701286 have missing entries) in table TITEL (132)
SOHARDRDUW10 Tue Nov 28 11:34:45 2017
Database: C:\DABIS800\D800_DB\D800.FDB
Index 15 is corrupt (record 18701286 have missing entries) in table TITEL (132)
SOHARDRDUW10 Tue Nov 28 11:34:45 2017
Database: C:\DABIS800\D800_DB\D800.FDB
Index 16 is corrupt (record 18701286 have missing entries) in table TITEL (132)
SOHARDRDUW10 Tue Nov 28 11:34:46 2017
Database: C:\DABIS800\D800_DB\D800.FDB
Index 18 is corrupt (record 18701286 have missing entries) in table TITEL (132)
SOHARDRDUW10 Tue Nov 28 11:34:46 2017
Database: C:\DABIS800\D800_DB\D800.FDB
Index 22 is corrupt (record 18701286 have missing entries) in table TITEL (132)
SOHARDRDUW10 Tue Nov 28 11:34:46 2017
Database: C:\DABIS800\D800_DB\D800.FDB
Relation has 41 orphan backversions (257 in use) in table TITEL (132)
And the gstat -h give this result:
Database "C:\dabis800\d800_db\d800.fdb"
Database header page information:
Flags 0
Checksum 12345
Generation 98357682
Page size 16384
ODS version 11.2
Oldest transaction 97774510
Oldest active 97900104
Oldest snapshot 97900104
Next transaction 97900104
Bumped transaction 1
Sequence number 0
Next attachment ID 443186
Implementation ID 26
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 1
Creation date Nov 17, 2017 21:00:48
Attributes force write, multi-user maintenance
Variable header data:
Sweep interval: 20000
*END*
I hope this info will help you to find the index problem.
--
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
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
