Skip to content

chore(autopilot): make auction post-processing db operations atomic #3437

Description

@mrnaveira

Background

Currently, the post_processing function on the autopilot performs multiple database saving operations in parallel. While this is good for performance, it opens the door for database inconsistencies in case the autopilot restarts between database operations.

Ideally we would like all the database operations (specially storing the winners and reference scores) to be done atomically.

Details

More in detail, the database operations are in the post_processing function:

save_auction
save_solutions // affects the proposed_solutions table
save_competition // affects the settlement_scores
save_surplus_capturing_jit_order_owner
store_fee_policies

Acceptance criteria

All previously indicated database operations are done atomically. Ideally with minimal performance impact.

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions