Bug #23837: Enforce change request and workflow table schema - Rudder - Issue Tracker

Actions

Copy link

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 about 1 year ago. Updated about 1 year ago.

Status:

Released

Priority:

N/A

Assignee:

François ARMAND

Category:

Web - Maintenance

Target version:

7.3.10

Pull Request:

https://github.com/Normation/rudder/p...

Severity:

UX impact:

User visibility:

Effort required:

Small

Priority:

Name check:

To do

Fix check:

Error - Fixed

Regression:

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