Project

General

Profile

Actions

Bug #14007

closed

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

Added by Nicolas CHARLES about 6 years ago. Updated almost 6 years ago.

Status:
Released
Priority:
N/A
Category:
Plugins integration
Target version:
Severity:
UX impact:
User visibility:
Effort required:
Priority:
0
Name check:
Fix check:
Regression:

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 2 (0 open2 closed)

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

Related issues 1 (0 open1 closed)

Related to Rudder - Architecture #12621: Explore alternative format for compliance tableReleasedFrançois ARMANDActions
Actions #1

Updated by Nicolas CHARLES about 6 years ago

Actions #2

Updated by Nicolas CHARLES about 6 years 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
Actions #3

Updated by Nicolas CHARLES about 6 years ago

  • Status changed from New to In progress
Actions #4

Updated by Nicolas CHARLES about 6 years 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
Actions #5

Updated by Nicolas CHARLES about 6 years ago

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

Updated by Vincent MEMBRÉ almost 6 years 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
Actions #7

Updated by Alexis Mousset almost 6 years 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
Actions

Also available in: Atom PDF