Project

General

Profile

Bug #14007

indexes on nodecompliancelevels table are not valid and table ArchivedReportsExecution is never used

Added by Nicolas CHARLES 28 days ago. Updated 5 days ago.

Status:
Released
Priority:
N/A
Category:
Plugins integration
Target version:
Severity:
User visibility:
Effort required:
Priority:
0

Description

Indexes on nodecompliancelevels are not valid: we have 3 time the same index

CREATE INDEX nodecompliancelevels_nodeId ON nodecompliancelevels (nodeId);
CREATE INDEX nodecompliancelevels_ruleId ON nodecompliancelevels (nodeId);
CREATE INDEX nodecompliancelevels_directiveId ON nodecompliancelevels (nodeId);


Subtasks

Bug #14017: Apply migration script to remove unecessary indexes during upgradeReleasedBenoît PECCATTE
Bug #14107: Syntax error in migration scriptReleasedFrançois ARMAND

Related issues

Related to Rudder - Architecture #12621: Explore alternative format for compliance tableReleased

Associated revisions

Revision 705d70c6 (diff)
Added by Nicolas CHARLES 27 days ago

Fixes #14007: indexes on nodecompliancelevels table are not valid and table ArchivedReportsExecution is never used

History

#1 Updated by Nicolas CHARLES 28 days ago

#2 Updated by Nicolas CHARLES 27 days ago

  • Subject changed from indexes on nodecompliancelevels table are not valid to indexes on nodecompliancelevels table are not valid and table ArchivedReportsExecution is never used
  • Assignee set to Nicolas CHARLES

#3 Updated by Nicolas CHARLES 27 days ago

  • Status changed from New to In progress

#4 Updated by Nicolas CHARLES 27 days ago

  • Status changed from In progress to Pending technical review
  • Assignee changed from Nicolas CHARLES to François ARMAND
  • Pull Request set to https://github.com/Normation/rudder/pull/2101

#5 Updated by Nicolas CHARLES 27 days ago

  • Status changed from Pending technical review to Pending release

#6 Updated by Vincent MEMBRÉ 5 days ago

  • Status changed from Pending release to Released
This bug has been fixed in Rudder 4.3.8 and 5.0.4 which were released today.
Changelog
Changelog

Also available in: Atom PDF