Page MenuHomePhabricator

`UNIQUE constraint failed: blob.name` during manifest upload to Reggie
Closed, ResolvedPublic

Description

Upload of an image manifest to Reggie failed today with a unique constraint violation. At the time there were two manifest uploads to the same repo:

2024-06-06 22:36:07,387 put_manifest(repos/releng/scap/cache/verify-deps-bookworm, master-I218be862c39080e9a8711211dee2786e32b2fae2)
2024-06-06 22:36:07,391 put_manifest(repos/releng/scap/cache/verify-deps-bookworm, master-I68c5d877d833894f7111b82af7a10e8a95a92aee)

The relevant part of the stack trace:

Traceback (most recent call last):
...
  File "/srv/app/app.py", line 529, in put_manifest
    manifest_blob = REPOBLOBS.put(repo, request.data)
  File "/srv/app/reggie/repo.py", line 44, in put
    return self.finish_upload(repo, uuid, offset)
  File "/srv/app/reggie/repo.py", line 24, in finish_upload
    lock_database_exclusive(self.db_session)
  File "/srv/app/reggie/database.py", line 27, in lock_database_exclusive
    db_session.flush()
...

Details

TitleReferenceAuthorSource BranchDest Branch
helm Chart: Bump appVersion to v1.12.0repos/releng/reggie!87dancymain-I96fdafc821fa7656ff14efb76bec711f67c8d54dmain
Fix bug with concurrent upload of manifestsrepos/releng/reggie!84dancymain-Ie3cfec8f9bc0b74400f5c58530aaebc161cf1acbmain
Customize query in GitLab

Event Timeline

dancy triaged this task as Medium priority.Thu, Jun 6, 10:54 PM
dancy updated the task description. (Show Details)
dancy claimed this task.

Fixed in Reggie v1.12.0.