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

Reaper 2.0 traceback #2970

Closed
cserf opened this issue Oct 10, 2019 · 0 comments · Fixed by #2974
Closed

Reaper 2.0 traceback #2970

cserf opened this issue Oct 10, 2019 · 0 comments · Fixed by #2974
Assignees
Milestone

Comments

@cserf
Copy link
Contributor

cserf commented Oct 10, 2019

Motivation

2019-10-10 09:55:25,486 28542   CRITICAL        Thread [38/50] :  Traceback (most recent call last):
  File "/usr/lib/python2.7/site-packages/rucio/daemons/reaper/reaper2.py", line 425, in reaper
    delete_replicas(rse_id=rse_id, files=deleted_files)
  File "/usr/lib/python2.7/site-packages/rucio/db/sqla/session.py", line 365, in new_funct
    raise DatabaseException(str(error))
DatabaseException: Database exception.
Details: (cx_Oracle.IntegrityError) ORA-02292: integrity constraint (ATLAS_RUCIO.SOURCES_REPLICAS_FK) violated - child record found
[SQL: DELETE /*+ INDEX(REPLICAS REPLICAS_PK) */ FROM atlas_rucio.replicas WHERE atlas_rucio.replicas.rse_id = :rse_id_1 AND (atlas_rucio.replicas.scope = :scope_1 AND atlas_rucio.replicas.name = :name_1 OR atlas_rucio.replicas.scope = :scope_2 AND atlas_rucio.replicas.na
me = :name_2 OR atlas_rucio.replicas.scope = :scope_3 AND atlas_rucio.replicas.name = :name_3 OR atlas_rucio.replicas.scope = :scope_4 AND atlas_rucio.replicas.name = :name_4 OR atlas_rucio.replicas.scope = :scope_5 AND atlas_rucio.replicas.name = :name_5 OR atlas_rucio.
replicas.scope = :scope_6 AND atlas_rucio.replicas.name = :name_6 OR atlas_rucio.replicas.scope = :scope_7 AND atlas_rucio.replicas.name = :name_7 OR atlas_rucio.replicas.scope = :scope_8 AND atlas_rucio.replicas.name = :name_8 OR atlas_rucio.replicas.scope = :scope_9 AN
D atlas_rucio.replicas.name = :name_9 OR atlas_rucio.replicas.scope = :scope_10 AND atlas_rucio.replicas.name = :name_10)]
[parameters: {u'name_2': 'DAOD_STDM2.18683656._000507.pool.root.1', u'name_3': 'DAOD_EXOT8.18715924._000001.pool.root.1', u'name_1': 'DAOD_STDM2.18685082._000356.pool.root.1', u'name_6': 'DAOD_EXOT8.18716233._000001.pool.root.1', u'name_7': 'DAOD_EXOT8.18716233._000003.p
ool.root.1', u'name_4': 'DAOD_EXOT8.18715924._000002.pool.root.1', u'name_5': 'DAOD_EXOT8.18715924._000003.pool.root.1', u'scope_10': 'mc16_13TeV', u'name_8': 'DAOD_EXOT8.18715667._000005.pool.root.1', u'name_9': 'DAOD_EXOT8.18716233._000002.pool.root.1', u'scope_6': 'mc
16_13TeV', u'scope_7': 'mc16_13TeV', u'scope_4': 'mc16_13TeV', u'scope_5': 'mc16_13TeV', u'scope_2': 'data16_13TeV', u'scope_3': 'mc16_13TeV', u'scope_1': 'data17_13TeV', u'name_10': 'DAOD_EXOT8.18715667._000012.pool.root.1', u'rse_id_1': <read-only buffer for 0x7fbe1d1d
f618, size -1, offset 0 at 0x7fbe2c4c5570>, u'scope_8': 'mc16_13TeV', u'scope_9': 'mc16_13TeV'}]
(Background on this error at: http://sqlalche.me/e/gkpj)

The problem is due to the relaxed constraint to keep files that are being transfered

@cserf cserf self-assigned this Oct 10, 2019
cserf added a commit to cserf/rucio that referenced this issue Oct 11, 2019
bari12 added a commit that referenced this issue Oct 14, 2019
bari12 added a commit that referenced this issue Oct 14, 2019
@bari12 bari12 added this to the 1.20.7 milestone Oct 14, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants