Skip to content

Create indexes necessary for uuid column type change asynchronously

What does this MR do and why?

Create indexes necessary for uuid column type change asynchronously.

  1. The end goal is to rename uuid_convert_string_to_uuid into uuid
  2. To do that, we need to drop the uuid column.
  3. This, in turn, will drop indexes present on the uuid column
  4. If there's no unique index present on the uuid column our ingestion pipeline will break because it depends on an unique index - spec failure

To mitigate this we will:

  1. Create necessary indexes on uuid_convert_string_to_uuid asynchronously (this MR)
  2. Create necessary indexes on uuid_convert_string_to_uuid synchronously (subsequent MR)
  3. Perform cleanup - Cleanup after vulnerability_occurrences.uuid ty... (!127754 - merged)

Related to #425028 (closed)

MR acceptance checklist

This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.

Edited by Michał Zając

Merge request reports