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 7 months ago. Updated 6 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 #1

Updated by Clark ANDRIANASOLO 7 months ago

  • Tracker changed from Architecture to Bug
  • Priority set to 0
Actions #2

Updated by Clark ANDRIANASOLO 7 months ago

  • Status changed from New to In progress
Actions #3

Updated by Clark ANDRIANASOLO 7 months ago

  • Status changed from In progress to Pending technical review
  • Assignee changed from Clark ANDRIANASOLO to François ARMAND
  • Pull Request set to https://github.com/Normation/rudder/pull/5233
Actions #4

Updated by Clark ANDRIANASOLO 6 months ago

  • Status changed from Pending technical review to Pending release
Actions #5

Updated by Vincent MEMBRÉ 6 months ago

  • Fix check changed from To do to Error - Fixed
Actions #6

Updated by Vincent MEMBRÉ 6 months ago

  • Status changed from Pending release to Released

This bug has been fixed in Rudder 7.3.10 and 8.0.4 which were released today.

Actions

Also available in: Atom PDF