Project

General

Profile

Actions
Copy link

Bug #14007

closed

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

Bug #14007: Indexes on nodecompliancelevels table are not valid and table ArchivedReportsExecution is never used

Added by Nicolas CHARLES about 7 years ago. Updated almost 7 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

Updated by Nicolas CHARLES about 7 years ago Actions
Copy link
 #1

Updated by Nicolas CHARLES about 7 years ago Actions
Copy link
 #2

  • 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

Updated by Nicolas CHARLES about 7 years ago Actions
Copy link
 #3

  • Status changed from New to In progress

Updated by Nicolas CHARLES about 7 years ago Actions
Copy link
 #4

  • 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

Updated by Nicolas CHARLES about 7 years ago Actions
Copy link
 #5

  • Status changed from Pending technical review to Pending release

Updated by Vincent MEMBRÉ about 7 years ago Actions
Copy link
 #6

  • 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

Updated by Alexis Mousset almost 7 years ago Actions
Copy link
 #7

  • 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: PDF Atom