Project

General

Profile

Actions

Bug #18814

closed

Error log about duplicates entries when saving node compliance levels

Added by François ARMAND 4 months ago. Updated 4 months ago.

Status:
Released
Priority:
N/A
Category:
Web - Compliance & node report
Target version:
Severity:
User visibility:
Effort required:
Priority:
0

Description

We still have these logs when they are not in english :(

[2021-01-07 00:16:53+0100] 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...
[2021-01-07 00:16:53+0100] ERROR scheduled.job - Error when executing [Store Agent Run Times] scheduler task started at 2021-01-07T00:16:53+01:00, ended at 2021-01-07T00:16:53+01:00. <- 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 ( '1d2dc3f1-fa85-4550-b7dc-504458c3bfd8','2021-01-07 00:01:26+01','aee341b1-97fe-4db0-a48f-4afeef1da629','39c89820-2145-4dcc-bcf9-89d90557f3be',0,4,0,0,0,0,0,4,0,0,0,0,0,0 ) was aborted: ERREUR: la valeur d'une clé dupliquée rompt la contrainte unique « nodecompliancelevels_pkey »
  Detail: La clé « (nodeid, runtimestamp, ruleid, directiveid)=(1d2dc3f1-fa85-4550-b7dc-504458c3bfd8, 2021-01-07 00:01:26+01, aee341b1-97fe-4db0-a48f-4afeef1da629, 39c89820-2145-4dcc-bcf9-89d90557f3be) » existe déjà.  Call getNextException to see other errors in the batch. 
 -> 
[2021-01-07 00:16:58+0100] ERROR report -  SystemError: Error when saving node compliances:; cause was: java.sql.BatchUpdateException: Batch entry 123 insert into nodecompliancelevels (nodeid,runtimestamp,ruleid,directiveid,pending,success...

Related issues

Related to Rudder - Bug #18188: Error log about duplicates entries when saving node compliance levelsReleasedNicolas CHARLESActions
Actions #1

Updated by François ARMAND 4 months ago

  • Related to Bug #18188: Error log about duplicates entries when saving node compliance levels added
Actions #2

Updated by François ARMAND 4 months ago

  • Status changed from New to In progress
Actions #3

Updated by François ARMAND 4 months ago

  • Status changed from In progress to Pending technical review
  • Assignee changed from François ARMAND to Vincent MEMBRÉ
  • Pull Request set to https://github.com/Normation/rudder/pull/3464
Actions #4

Updated by François ARMAND 4 months ago

  • Status changed from Pending technical review to Pending release
Actions #6

Updated by Vincent MEMBRÉ 4 months ago

  • Status changed from Pending release to Released

This bug has been fixed in Rudder 6.1.8 and 6.2.1 which were released today.

Actions

Also available in: Atom PDF