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
Assignee:
Category:
Web - Compliance & node report
Target version:
Pull Request:
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
Updated by François ARMAND about 7 years ago
- Tracker changed from Bug to Architecture
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.
Updated by Vincent MEMBRÉ about 7 years ago
- Target version changed from 4.1.0 to 4.1.1
Updated by Vincent MEMBRÉ about 7 years ago
- Target version changed from 4.1.1 to 4.1.2
Updated by Vincent MEMBRÉ almost 7 years ago
- Target version changed from 4.1.2 to 4.1.3
Updated by Vincent MEMBRÉ almost 7 years ago
- Target version changed from 4.1.3 to 4.1.4
Updated by Vincent MEMBRÉ almost 7 years ago
- Target version changed from 4.1.4 to 4.1.5
Updated by Alexis Mousset almost 7 years ago
- Target version changed from 4.1.5 to 4.1.6
Updated by Vincent MEMBRÉ over 6 years ago
- Target version changed from 4.1.6 to 4.1.7
Updated by Vincent MEMBRÉ over 6 years ago
- Target version changed from 4.1.7 to 4.1.8
Updated by Vincent MEMBRÉ over 6 years ago
- Target version changed from 4.1.8 to 4.1.9
Updated by Vincent MEMBRÉ over 6 years ago
- Target version changed from 4.1.9 to 4.1.10
Updated by Vincent MEMBRÉ about 6 years ago
- Target version changed from 4.1.10 to 4.1.11
Updated by Vincent MEMBRÉ about 6 years ago
- Target version changed from 4.1.11 to 4.1.12
Updated by Vincent MEMBRÉ almost 6 years ago
- Target version changed from 4.1.12 to 4.1.13
Updated by Nicolas CHARLES almost 6 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
Updated by Vincent MEMBRÉ almost 6 years ago
- Target version changed from 4.1.13 to 4.1.14
Updated by Benoît PECCATTE almost 6 years ago
- Target version changed from 4.1.14 to 4.1.15
Updated by Vincent MEMBRÉ over 5 years ago
- Target version changed from 4.1.15 to 4.1.16
Updated by Vincent MEMBRÉ over 5 years ago
- Target version changed from 4.1.16 to 4.1.17
Updated by Vincent MEMBRÉ over 5 years ago
- Target version changed from 4.1.17 to 4.1.18
Updated by Vincent MEMBRÉ over 5 years ago
- Target version changed from 4.1.18 to 4.1.19
Updated by Alexis Mousset over 5 years ago
- Target version changed from 4.1.19 to 4.1.20
Updated by François ARMAND about 5 years ago
- Target version changed from 4.1.20 to 4.1.21
Updated by Vincent MEMBRÉ about 5 years ago
- Target version changed from 4.1.21 to 4.1.22
Updated by Benoît PECCATTE about 5 years ago
- Target version changed from 4.1.22 to 5.0.10
Updated by Vincent MEMBRÉ almost 5 years ago
- Target version changed from 5.0.10 to 5.0.11
Updated by Vincent MEMBRÉ almost 5 years ago
- Target version changed from 5.0.11 to 5.0.12
Updated by Vincent MEMBRÉ almost 5 years ago
- Target version changed from 5.0.12 to 5.0.13
Updated by Vincent MEMBRÉ over 4 years ago
- Target version changed from 5.0.13 to 5.0.14
Updated by Vincent MEMBRÉ over 4 years ago
- Target version changed from 5.0.14 to 5.0.15
Updated by Vincent MEMBRÉ over 4 years ago
- Target version changed from 5.0.15 to 5.0.16
Updated by Alexis Mousset about 4 years ago
- Target version changed from 5.0.16 to 5.0.17
Updated by François ARMAND about 4 years ago
- Related to Bug #13427: On error on nodecompliance SQL, logs are huge added
Updated by François ARMAND about 4 years ago
- Related to Bug #15021: When receiving lots of reports, while load is high, an error occurs on node compliance historisation added
Updated by Vincent MEMBRÉ about 4 years ago
- Target version changed from 5.0.17 to 5.0.18
Updated by Benoît PECCATTE about 4 years ago
- Target version changed from 5.0.18 to 6.2.0~beta1
Updated by Vincent MEMBRÉ over 3 years ago
- Target version changed from 6.2.0~beta1 to 6.2.0~rc1
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.
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