Project

General

Profile

Actions
Copy link

Bug #14007

closed

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

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

Status:
Released
Priority:
N/A
Assignee:
François ARMAND
Category:
Plugins integration
Target version:
4.3.8
Pull Request:
https://github.com/Normation/rudder/p...
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 open — 2 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 open — 1 closed)

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

Updated by Nicolas CHARLES almost 6 years ago

Actions
Copy link
 #2

Updated by Nicolas CHARLES almost 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
Copy link
 #3

Updated by Nicolas CHARLES almost 6 years ago

  • Status changed from New to In progress
Actions
Copy link
 #4

Updated by Nicolas CHARLES almost 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
Copy link
 #5

Updated by Nicolas CHARLES almost 6 years ago

  • Status changed from Pending technical review to Pending release
Actions
Copy link
 #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
Copy link
 #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
Copy link

Also available in: Atom PDF