Project

General

Profile

Bug #17778

table nodes contains on entry per node per generation, which is too much

Added by Nicolas CHARLES 3 months ago. Updated 2 months ago.

Status:
Released
Priority:
N/A
Category:
Performance and scalability
Target version:
Severity:
User visibility:
Effort required:
Priority:
0

Description

table nodes should historize nodes info, and it check changes at each policy generation
but it should not create a new entry for each node at each policy generation, as seem to indicate https://issues.rudder.io/issues/17772 , but rather create an entry when there's a change

On load test system, I have 74 971 809 entries in nodes, for 4500 fairly static nodes


Related issues

Related to Rudder - Question #17772: "nodes" table is very bigNewActions
Related to Rudder - Question #15436: How to clean the tables 'nodes' and 'nodes_info' of seemingly out of date informations ?NewActions
Related to Rudder - Bug #14770: Invalid comparision of String and Option[String] in HistorizationService ReleasedNicolas CHARLESActions
#1

Updated by Nicolas CHARLES 3 months ago

#2

Updated by Nicolas CHARLES 3 months ago

  • Related to Question #15436: How to clean the tables 'nodes' and 'nodes_info' of seemingly out of date informations ? added
#3

Updated by Nicolas CHARLES 3 months ago

this is most likely because we compare the description of the node from the DB (which is empty), with Some(description), which is some("")

#4

Updated by Nicolas CHARLES 3 months ago

  • Status changed from New to In progress
  • Assignee set to Nicolas CHARLES
#5

Updated by Nicolas CHARLES 3 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/3086
#6

Updated by Nicolas CHARLES 3 months ago

  • Target version changed from 6.0.7 to 5.0.18

exists in 5.0, retargeting

#7

Updated by Nicolas CHARLES 3 months ago

  • Pull Request changed from https://github.com/Normation/rudder/pull/3086 to https://github.com/Normation/rudder/pull/3088
#8

Updated by Nicolas CHARLES 3 months ago

  • Related to Bug #14770: Invalid comparision of String and Option[String] in HistorizationService added
#9

Updated by Nicolas CHARLES 3 months ago

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

Updated by Vincent MEMBRÉ 2 months ago

  • Status changed from Pending release to Released

This bug has been fixed in Rudder 5.0.18 and 6.1.2 which were released today.

Also available in: Atom PDF