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.
- The end goal is to rename
uuid_convert_string_to_uuid
intouuid
- To do that, we need to drop the
uuid
column. - This, in turn, will drop indexes present on the
uuid
column - 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:
- Create necessary indexes on
uuid_convert_string_to_uuid
asynchronously (this MR) - Create necessary indexes on
uuid_convert_string_to_uuid
synchronously (subsequent MR) - 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.
-
I have evaluated the MR acceptance checklist for this MR.
Edited by Michał Zając