Project

General

Profile

Actions

Bug #23837

closed

Architecture #23677: Migrate to zio-json

Architecture #23706: Migrate public plugins to zio

Rudder plugins - Architecture #23831: Migrate change request API in change-validation to zio-json

Enforce change request and workflow table schema

Added by Clark ANDRIANASOLO 12 months ago. Updated 12 months ago.

Status:
Released
Priority:
N/A
Category:
Web - Maintenance
Target version:
Severity:
UX impact:
User visibility:
Effort required:
Small
Priority:
0
Name check:
To do
Fix check:
Error - Fixed
Regression:
No

Description

It turns out the columns constraints and the value we expect from SQL queries do not match : sometimes we expect non-nullable values but we could get null from the column in the database table.
We should have never inserted/updated null value so we could migrate the columns to add the non-nullability constraint by :
  • doing it without preventing the start of Rudder (it should be run asynchronously) and with a user-friendly error message
  • not doing the migration when it has already been done
Actions

Also available in: Atom PDF