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

Also available in: Atom PDF