Project

General

Profile

Actions

Bug #18188

closed

Error log about duplicates entries when saving node compliance levels

Added by Nicolas CHARLES about 4 years ago. Updated over 2 years ago.

Status:
Released
Priority:
N/A
Category:
Web - Config management
Target version:
Severity:
Minor - inconvenience | misleading | easy workaround
UX impact:
User visibility:
Effort required:
Priority:
0
Name check:
Reviewed
Fix check:
Checked
Regression:

Description

[2020-09-09 14:14:02+0000] INFO  policy.generation.timing - Policy generation succeeded in:       10 s
[2020-09-09 14:14:02+0000] INFO  policy.generation.manager - Flag file '/opt/rudder/etc/policy-update-running' successfully removed
[2020-09-09 14:14:02+0000] INFO  policy.generation.manager - Flag file '/opt/rudder/etc/trigger-policy-generation' successfully removed
[2020-09-09 14:14:02+0000] INFO  policy.generation.manager - Successful policy update '16' [started 2020-09-09 14:13:51 - ended 2020-09-09 14:14:02]
[2020-09-09 14:14:12+0000] INFO  compliance - [metrics] global compliance (number of components): 12 [p:0 s:1 r:1 e:0 u:0 m:4 nr:4 na:2 rd:0 c:0 ana:0 nc:0 ae:0 bpm:0]
[2020-09-09 14:16:13+0000] ERROR report -  SystemError: Error when saving node compliances:; cause was: java.sql.BatchUpdateException: Batch entry 0 insert into nodecompliancelevels (nodeid,runtimestamp,ruleid,directiveid,pending,success,r...
[2020-09-09 14:16:13+0000] ERROR application - Error when executing [Store Agent Run Times] scheduler task started at 2020-09-09T14:16:13Z, ended at 2020-09-09T14:16:13Z. <- SystemError: Error when saving node compliances:; cause was: java.sql.BatchUpdateException: Batch entry 0 insert into nodecompliancelevels (nodeid,runtimestamp,ruleid,directiveid,pending,success,repaired,error,unexpected,missing,noanswer,notapplicable,reportsdisabled,compliant,auditnotapplicable,noncompliant,auditerror,badpolicymode)
 values ( 'root','2020-09-09 14:05:30+00'::timestamp with time zone,'server-roles','server-roles-directive',0,24,0,0,0,0,0,1,0,0,0,0,0,0 ) was aborted: ERROR: duplicate key value violates unique constraint "nodecompliancelevels_pkey" 
  Detail: Key (nodeid, runtimestamp, ruleid, directiveid)=(root, 2020-09-09 14:05:30+00, server-roles, server-roles-directive) already exists.  Call getNextException to see other errors in the batch. 
 -> 
[2020-09-09 14:16:13+0000] INFO  inventory-processing - Watch new inventory file 'server-root.ocs' with signature available: process.

Related issues 3 (0 open3 closed)

Related to Rudder - Bug #17410: Error log about duplicates entries when saving node compliance levelsReleasedVincent MEMBRÉActions
Related to Rudder - Bug #18814: Error log about duplicates entries when saving node compliance levelsReleasedVincent MEMBRÉActions
Has duplicate Rudder - Bug #10478: Error on inserting into nodecompliance tableResolvedFrançois ARMANDActions
Actions

Also available in: Atom PDF