Feature #14706

[Crunch2] Retain record of container retries

Added by Peter Amstutz 14 days ago. Updated 14 days ago.

Status:
New
Priority:
Normal
Assigned To:
-
Category:
-
Target version:
Start date:
Due date:
% Done:

0%

Estimated time:
Story points:
-

Description

The container request record lists the most recent container attempted to fulfill the request. This means when a failed container is retried, previous failed attempts are not visible to the user. This obscures the fact that retries occurred, and sometimes hinders debugging failed containers.

Proposal:

Need a column that has uuids of all containers. Can use array column, eg https://www.postgresql.org/docs/9.6/arrays.html, or JSONB column.

Current data model has "container_uuid" as a singular value. Would be a backwards compatibility problem if that changed to be an array. API should report past attempts in a separate field, like "past_container_uuids".

Unclear if it would be better in the underlying database to have a single array column, or retain container_uuid column and add a past_container_uuids column.

Need to be able to join array column to grant read permission to container records. Section 8.15.5 of postgres docs suggest this is something like:

container.uuid = ANY (container_request.past_container_uuids)

History

#1 Updated by Peter Amstutz 14 days ago

  • Status changed from New to In Progress

#2 Updated by Peter Amstutz 14 days ago

  • Description updated (diff)
  • Status changed from In Progress to New

#3 Updated by Peter Amstutz 14 days ago

  • Tracker changed from Bug to Feature

Also available in: Atom PDF