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.

Sign up for GitHub

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

Jump to bottom

Add NO_INDEX_FFS(CONTENTS CONTENTS_PK) hint to reaper queries #5097

Closed
bari12 opened this issue Dec 8, 2021 · 0 comments
Closed

Add NO_INDEX_FFS(CONTENTS CONTENTS_PK) hint to reaper queries #5097

bari12 opened this issue Dec 8, 2021 · 0 comments
Assignees
@rcarpa
Labels
Database enhancement
Milestone
1.27.2

Comments

@bari12
Copy link
Member

bari12 commented Dec 8, 2021

A NO_INDEX_FFS(CONTENTS CONTENTS_PK) hint needs to be added to some reaper queries. Possibly some of the queries need to be transformed to the new sqlalchemy syntax, in order to be able to use prefix_with commands.

rucio/lib/rucio/core/replica.py

Line 1741 in 86b27bc

query = session.query(models.DataIdentifierAssociation.scope, models.DataIdentifierAssociation.name,

@bari12 bari12 closed this as completed in e489d7a Dec 9, 2021
bari12 added a commit that referenced this issue Dec 9, 2021
@bari12
Merge pull request #5100 from rcarpa/patch-5097-reaper_no_index_ffs
c857f58 
Deletion: disable contents_pk index on parent retrieval. Closes #5097
bari12 pushed a commit that referenced this issue Dec 9, 2021
@rcarpa @bari12
Deletion: disable contents_pk index on parent retrieval. Closes #5097
99fcb0d 
Oracle 19c optimiser decides to use the wrong index.
@bari12 bari12 added this to the 1.27.2 milestone Dec 9, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@rcarpa rcarpa

Labels
Database enhancement
Projects
None yet
Milestone
1.27.2
Development

No branches or pull requests
2 participants
@bari12 @rcarpa