Project

General

Profile

Actions

Bug #10478

closed

Error on inserting into nodecompliance table

Added by Nicolas CHARLES about 7 years ago. Updated over 3 years ago.

Status:
Resolved
Priority:
N/A
Category:
Web - Compliance & node report
Target version:
Severity:
Minor - inconvenience | misleading | easy workaround
UX impact:
User visibility:
Operational - other Techniques | Rudder settings | Plugins
Effort required:
Priority:
29
Name check:
Fix check:
Checked
Regression:

Description

In my postgresql logs, I get sometimes errors like

ERROR:  duplicate key value violates unique constraint "nodecompliance_pkey" 
DETAIL:  Key (nodeid, runtimestamp)=(747ebdce-2769-4d04-a7ae-0ff6ace8086a, 2017-03-21 00:27:19+00) already exists.
STATEMENT:  insert into nodecompliance (nodeid, runtimestamp, endoflife, runanalysis, summary, details)
                               values ($1, $2, $3, $4, $5, $6)

ERROR:  duplicate key value violates unique constraint "nodecompliance_pkey" 
DETAIL:  Key (nodeid, runtimestamp)=(root, 2017-03-21 15:30:53+00) already exists.
STATEMENT:  insert into nodecompliance (nodeid, runtimestamp, endoflife, runanalysis, summary, details)
                               values ($1, $2, $3, $4, $5, $6)

There is 0 logs in the webapp about that


Related issues 3 (0 open3 closed)

Related to Rudder - Bug #13427: On error on nodecompliance SQL, logs are hugeReleasedFrançois ARMANDActions
Related to Rudder - Bug #15021: When receiving lots of reports, while load is high, an error occurs on node compliance historisation RejectedActions
Is duplicate of Rudder - Bug #18188: Error log about duplicates entries when saving node compliance levelsReleasedNicolas CHARLESActions
Actions #1

Updated by François ARMAND about 7 years ago

  • Tracker changed from Bug to Architecture
Actions #2

Updated by François ARMAND about 7 years ago

We are switching that ticket to architecture because this is not a feature for now, so an user should not even know about that.

Actions #3

Updated by Vincent MEMBRÉ about 7 years ago

  • Target version changed from 4.1.0 to 4.1.1
Actions #4

Updated by Vincent MEMBRÉ almost 7 years ago

  • Target version changed from 4.1.1 to 4.1.2
Actions #5

Updated by Vincent MEMBRÉ almost 7 years ago

  • Target version changed from 4.1.2 to 4.1.3
Actions #6

Updated by Vincent MEMBRÉ almost 7 years ago

  • Target version changed from 4.1.3 to 4.1.4
Actions #7

Updated by Vincent MEMBRÉ almost 7 years ago

  • Target version changed from 4.1.4 to 4.1.5
Actions #8

Updated by Alexis Mousset almost 7 years ago

  • Target version changed from 4.1.5 to 4.1.6
Actions #9

Updated by Vincent MEMBRÉ over 6 years ago

  • Target version changed from 4.1.6 to 4.1.7
Actions #10

Updated by Vincent MEMBRÉ over 6 years ago

  • Target version changed from 4.1.7 to 4.1.8
Actions #11

Updated by Vincent MEMBRÉ over 6 years ago

  • Target version changed from 4.1.8 to 4.1.9
Actions #12

Updated by Vincent MEMBRÉ over 6 years ago

  • Target version changed from 4.1.9 to 4.1.10
Actions #13

Updated by Vincent MEMBRÉ about 6 years ago

  • Target version changed from 4.1.10 to 4.1.11
Actions #14

Updated by Vincent MEMBRÉ almost 6 years ago

  • Target version changed from 4.1.11 to 4.1.12
Actions #15

Updated by Vincent MEMBRÉ almost 6 years ago

  • Target version changed from 4.1.12 to 4.1.13
Actions #16

Updated by Nicolas CHARLES over 5 years ago

If all reports are duplicated (even end run), we get an error

[2018-07-10 12:50:32] ERROR report - Error when saving node compliances: Batch entry 0 insert into nodecompliance (nodeid, runtimestamp, endoflife, runanalysis, summary, details)
 values ('817e987d-db8a-4368-8dc4-6bf061775f96', '2018-07-10 12:50:19+00'::timestamp with time zone, '2018-07-10 13:00:19+00'::timestamp with time zone, '{
  "run":{
    "type":"ComputeCompliance",
    "expectedConfigId":"20180710-124310-f0870b1e",
    "runConfigId":"20180710-124310-f0870b1e" 
  },
  "status":{
    "status":"success" 

 was aborted: ERROR: duplicate key value violates unique constraint "nodecompliance_pkey" 
  Detail: Key (nodeid, runtimestamp)=(817e987d-db8a-4368-8dc4-6bf061775f96, 2018-07-10 12:50:19+00) already exists.  Call getNextException to see other errors in the batch.

entries are correctly unique in reportsexecution

Actions #17

Updated by Vincent MEMBRÉ over 5 years ago

  • Target version changed from 4.1.13 to 4.1.14
Actions #18

Updated by Benoît PECCATTE over 5 years ago

  • Target version changed from 4.1.14 to 4.1.15
Actions #19

Updated by Vincent MEMBRÉ over 5 years ago

  • Target version changed from 4.1.15 to 4.1.16
Actions #20

Updated by Vincent MEMBRÉ over 5 years ago

  • Target version changed from 4.1.16 to 4.1.17
Actions #21

Updated by Vincent MEMBRÉ over 5 years ago

  • Target version changed from 4.1.17 to 4.1.18
Actions #22

Updated by Vincent MEMBRÉ about 5 years ago

  • Target version changed from 4.1.18 to 4.1.19
Actions #23

Updated by Alexis Mousset about 5 years ago

  • Target version changed from 4.1.19 to 4.1.20
Actions #24

Updated by François ARMAND about 5 years ago

  • Target version changed from 4.1.20 to 4.1.21
Actions #25

Updated by Vincent MEMBRÉ almost 5 years ago

  • Target version changed from 4.1.21 to 4.1.22
Actions #26

Updated by Benoît PECCATTE almost 5 years ago

  • Target version changed from 4.1.22 to 5.0.10
Actions #27

Updated by Vincent MEMBRÉ almost 5 years ago

  • Target version changed from 5.0.10 to 5.0.11
Actions #28

Updated by Vincent MEMBRÉ almost 5 years ago

  • Target version changed from 5.0.11 to 5.0.12
Actions #29

Updated by Vincent MEMBRÉ over 4 years ago

  • Target version changed from 5.0.12 to 5.0.13
Actions #30

Updated by Vincent MEMBRÉ over 4 years ago

  • Target version changed from 5.0.13 to 5.0.14
Actions #31

Updated by Vincent MEMBRÉ over 4 years ago

  • Target version changed from 5.0.14 to 5.0.15
Actions #32

Updated by Vincent MEMBRÉ over 4 years ago

  • Target version changed from 5.0.15 to 5.0.16
Actions #33

Updated by Alexis Mousset about 4 years ago

  • Target version changed from 5.0.16 to 5.0.17
Actions #34

Updated by François ARMAND almost 4 years ago

  • Related to Bug #13427: On error on nodecompliance SQL, logs are huge added
Actions #35

Updated by François ARMAND almost 4 years ago

  • Related to Bug #15021: When receiving lots of reports, while load is high, an error occurs on node compliance historisation added
Actions #36

Updated by Vincent MEMBRÉ almost 4 years ago

  • Target version changed from 5.0.17 to 5.0.18
Actions #37

Updated by Benoît PECCATTE almost 4 years ago

  • Target version changed from 5.0.18 to 6.2.0~beta1
Actions #38

Updated by Vincent MEMBRÉ over 3 years ago

  • Target version changed from 6.2.0~beta1 to 6.2.0~rc1
Actions #39

Updated by François ARMAND over 3 years ago

  • Tracker changed from Architecture to Bug
  • Severity set to Minor - inconvenience | misleading | easy workaround
  • User visibility set to Operational - other Techniques | Rudder settings | Plugins
  • Priority set to 29

This still happens and cause unending problems with users understanding.

Actions #40

Updated by François ARMAND over 3 years ago

  • Status changed from New to Resolved

Duplicate of #18188

Actions #41

Updated by François ARMAND over 3 years ago

  • Is duplicate of Bug #18188: Error log about duplicates entries when saving node compliance levels added
Actions #42

Updated by François ARMAND over 3 years ago

  • Fix check set to Checked
Actions

Also available in: Atom PDF