Project

General

Custom queries

Profile

Actions

Bug #7316

closed

duplicate key value error on Rudder

Added by Nicolas CHARLES over 9 years ago. Updated over 9 years ago.

Status:
Released
Priority:
N/A
Category:
Web - Config management
Target version:
Severity:
UX impact:
User visibility:
Effort required:
Priority:
Name check:
Fix check:
Regression:

Description

After installing Rudder + enterprise module, the reporting failed, and I got the following error

 ERROR com.normation.rudder.reports.execution.WoReportsExecutionSquerylRepository - Error when trying to update nodes report executions, reason is Batch entry 7 insert into "reportsexecution" ("complete", "date", "insertionid", "nodeconfigid", "nodeid") values ('1','2015-10-27 15:35:21.000000 +00:00:00',629,'-2141039261','root') was aborted.  Call getNextException to see the cause.
java.sql.BatchUpdateException: Batch entry 7 insert into "reportsexecution" ("complete", "date", "insertionid", "nodeconfigid", "nodeid") values ('1','2015-10-27 15:35:21.000000 +00:00:00',629,'-2141039261','root') was aborted.  Call getNextException to see the cause.

on postgres

ERROR:  duplicate key value violates unique constraint "reportsexecution_pkey"STATEMENT:  insert into "reportsexecution" ("complete", "date", "insertionid", "nodeconfigid", "nodeid") values ($1,$2,$3,$4,$5)

happened on 3.1, may happen on every version

#2

Updated by Nicolas CHARLES over 9 years ago

  • Assignee set to François ARMAND
  • Target version changed from 3.1.5 to 2.11.17
#3

Updated by François ARMAND over 9 years ago

  • Status changed from New to In progress
#4

Updated by Nicolas CHARLES over 9 years ago

  • Target version changed from 2.11.17 to 3.0.12
#5

Updated by François ARMAND over 9 years ago

  • Status changed from In progress to Pending technical review
  • Assignee changed from François ARMAND to Nicolas CHARLES
  • Pull Request set to https://github.com/Normation/rudder/pull/936
#6

Updated by François ARMAND over 9 years ago

  • Status changed from Pending technical review to Pending release
  • % Done changed from 0 to 100
#9

Updated by Vincent MEMBRÉ over 9 years ago

  • Status changed from Pending release to Released
Actions

Also available in: Atom PDF