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

temporary table attach_dids doesn't tolerate duplicate entries in children #6017

Closed
rcarpa opened this issue Dec 9, 2022 · 0 comments
Closed

temporary table attach_dids doesn't tolerate duplicate entries in children #6017

rcarpa opened this issue Dec 9, 2022 · 0 comments
Assignees
@rcarpa
Labels
Core & Internals
Milestone
1.30.1

Comments

@rcarpa
Copy link
Contributor

rcarpa commented Dec 9, 2022

This seems to be a change in behavioral change from the version without temporary tables:

DatabaseException in rucio.web.rest.flaskapi.v1.dids Attachment POST
Database exception.
Details: (cx_Oracle.IntegrityError) ORA-00001: unique constraint (ATLAS_RUCIO.TEMPORARY_SCOPE_NAME_0_PK) violated
[SQL: INSERT INTO atlas_rucio."TEMPORARY_SCOPE_NAME_0" (scope, name) VALUES (:scope, :name)]
[parameters: [{'scope': 'data22_13p6TeV', 'name': 'data22_13p6TeV.00440497.physics_Main.merge.AOD.f1321_m2153._lb0036._0001.1'}, {'scope': 'data22_13p6TeV', 'name': 'data22_13p6TeV.00440497.physics_Main.merge.AOD.f1321_m2153._lb0056._0001.1'}, {'scope': 'data22_13p6TeV', 'name': 'data22_13p6TeV.00440497.physics_Main.merge.AOD.f1321_m2153._lb0036._0001.1'}]]
@rcarpa rcarpa self-assigned this Dec 9, 2022
@bari12 bari12 closed this as completed in 27dd125 Dec 14, 2022
bari12 added a commit that referenced this issue Dec 14, 2022
@bari12
Merge pull request #6018 from rcarpa/patch-6017-attach_dids_duplicate…
50c31fb 
…_children

Core & Internals: tolerate duplicate entries in attach_dids. Fix #6017
@bari12 bari12 added this to the 1.30.1 milestone Dec 14, 2022
bari12 pushed a commit that referenced this issue Dec 14, 2022
@rcarpa @bari12
Core & Internals: tolerate duplicate entries in attach_dids. Fix #6017
f55c332
ThePhisch pushed a commit to ThePhisch/rucio that referenced this issue Dec 20, 2022
@rcarpa @ThePhisch
Core & Internals: tolerate duplicate entries in attach_dids. Fix ruci…
8231708 
…o#6017
ThePhisch pushed a commit to ThePhisch/rucio that referenced this issue Dec 21, 2022
@rcarpa @ThePhisch
Core & Internals: tolerate duplicate entries in attach_dids. Fix ruci…
062e098 
…o#6017
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@rcarpa rcarpa

Labels
Core & Internals
Projects
None yet
Milestone
1.30.1
Development

No branches or pull requests
2 participants
@bari12 @rcarpa