Bug #14392
closed
If a rule targets too many groups, policy generation fails
Added by Nicolas CHARLES almost 6 years ago.
Updated over 5 years ago.
Category:
Performance and scalability
Severity:
Major - prevents use of part of Rudder | no simple workaround
User visibility:
Infrequent - complex configurations | third party integrations
Effort required:
Very Small
Description
With a very very large list of groups in a rules, the historization (part of policy generation) fails because we have a pkey constraint on table rulesgroupjoin (rules id + serialization of groups of rules)
However, this pk creates a btree, that cannot index long text - error is
ERROR: index row size 3528 exceeds maximum 2712 for index "rulesgroupjoin_pkey"
ASTUCE : Values larger than 1/3 of a buffer page cannot be indexed.
Consider a function index of an MD5 hash of the value, or use full text indexing.
dropping the pkey solves the issue
alter table rulesgroupjoin drop constraint rulesgroupjoin_pkey;
recreating an index is still necessary for correct perf of historization though:
CREATE INDEX rule_id_group on rulesgroupjoin (rulePkeyId);
- Subject changed from if rules uses too numerous, policy generation fails because historisation fails to If rules uses too numerous, policy generation fails because historisation fails
- Description updated (diff)
- Subject changed from If rules uses too numerous, policy generation fails because historisation fails to If rules uses too much groups, policy generation fails because historisation fails
- Target version changed from 4.1.20 to 4.1.21
- Assignee set to Nicolas CHARLES
- Status changed from New to In progress
- 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/2150
- Subject changed from If rules uses too much groups, policy generation fails because historisation fails to If rules uses too many groups, policy generation fails
- Description updated (diff)
- Status changed from Pending technical review to Pending release
- Subject changed from If rules uses too many groups, policy generation fails to If a rule uses too many groups, policy generation fails
- Subject changed from If a rule uses too many groups, policy generation fails to If a rule targets too many groups, policy generation fails
- Priority changed from 70 to 69
- Status changed from Pending release to Released
This bug has been fixed in Rudder 4.1.21, 4.3.11 and 5.0.9 which were released today.
Also available in: Atom
PDF