Project

General

Profile

Bug #14007

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

Added by Nicolas CHARLES 11 months ago. Updated 10 months 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 PECCATTEActions
Bug #14107: Syntax error in migration scriptReleasedFrançois ARMANDActions

Related issues

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

Associated revisions

Revision 705d70c6 (diff)
Added by Nicolas CHARLES 11 months ago

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

History

#1

Updated by Nicolas CHARLES 11 months ago

#2

Updated by Nicolas CHARLES 11 months 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 11 months ago

  • Status changed from New to In progress
#4

Updated by Nicolas CHARLES 11 months 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 11 months ago

  • Status changed from Pending technical review to Pending release
#6

Updated by Vincent MEMBRÉ 10 months 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
#7

Updated by Alexis MOUSSET 10 months ago

  • Subject changed from indexes on nodecompliancelevels table are not valid and table ArchivedReportsExecution is never used to Indexes on nodecompliancelevels table are not valid and table ArchivedReportsExecution is never used

Also available in: Atom PDF