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
Incorrect result set (missing records) may be returned by the ORDER BY query navigating on an index [CORE5558] #5825
Comments
Modified by: Marcel Portner (mpo)Attachment: sql_desc.jpg [ 13131 ] Attachment: sql_asc.jpg [ 13132 ] |
Commented by: @hvlad Make sure there is no connections to the database |
Commented by: Marcel Portner (mpo) Thanks for this information. |
Modified by: Sean Leyne (seanleyne)status: Open [ 1 ] => Resolved [ 5 ] resolution: Cannot Reproduce [ 5 ] |
Modified by: @pcisarstatus: Resolved [ 5 ] => Closed [ 6 ] |
Commented by: Marcel Portner (mpo) The gfix -v -full give this result: Summary of validation errors
This is in the firebird.log: SOHARDRDUW10 Tue Nov 28 11:34:43 2017 SOHARDRDUW10 Tue Nov 28 11:34:43 2017 SOHARDRDUW10 Tue Nov 28 11:34:44 2017 SOHARDRDUW10 Tue Nov 28 11:34:44 2017 SOHARDRDUW10 Tue Nov 28 11:34:44 2017 SOHARDRDUW10 Tue Nov 28 11:34:44 2017 SOHARDRDUW10 Tue Nov 28 11:34:45 2017 SOHARDRDUW10 Tue Nov 28 11:34:45 2017 SOHARDRDUW10 Tue Nov 28 11:34:45 2017 SOHARDRDUW10 Tue Nov 28 11:34:45 2017 SOHARDRDUW10 Tue Nov 28 11:34:46 2017 SOHARDRDUW10 Tue Nov 28 11:34:46 2017 SOHARDRDUW10 Tue Nov 28 11:34:46 2017 And the gstat -h give this result: Database "C:\dabis800\d800_db\d800.fdb"
I hope this info will help you to find the index problem. |
Commented by: @hvlad You need to rebuild every index with missing entries. |
Modified by: @pavel-zotovstatus: Closed [ 6 ] => Closed [ 6 ] QA Status: No test => Cannot be tested |
Submitted by: Marcel Portner (mpo)
Is duplicated by CORE5672
Attachments:
sql_desc.jpg
sql_asc.jpg
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.
In the firebird.log no error entry is available.
I think the index is in this case corrupt.
Is this problem known?
The text was updated successfully, but these errors were encountered: