Project

General

Profile

Actions

Architecture #11925

open

NodeCompliance is not historised when web interface is shut down

Added by Nicolas CHARLES over 6 years ago. Updated 11 days ago.

Status:
New
Priority:
N/A
Category:
Web - Compliance & node report
Target version:
Effort required:
Medium
Name check:
Fix check:
Regression:

Description

If we shut down the web interface, the agents runs are not historized in the NodeCompliance table, and it doesn't catch up when we restart the web interface

The result is that we have gaps in compliance reports

Example, I stopped the web interface from 13:36 to 14:16, and historised compliance is:

rudder=> select nodeid, runtimestamp, endoflife from nodecompliance 
where nodeid != 'root' order by runtimestamp desc;
                nodeid                |      runtimestamp      |         endoflife          
--------------------------------------+------------------------+----------------------------
 db80271f-3b98-4cc6-aaad-9cf29f31fac8 | 2018-01-05 14:20:02+00 | 2018-01-05 14:30:02+00
 db80271f-3b98-4cc6-aaad-9cf29f31fac8 | 2018-01-05 14:16:47+00 | 2018-01-05 14:26:47+00
 db80271f-3b98-4cc6-aaad-9cf29f31fac8 | 2018-01-05 13:36:26+00 | 2018-01-05 13:46:26+00
 db80271f-3b98-4cc6-aaad-9cf29f31fac8 | 2018-01-05 13:35:02+00 | 2018-01-05 13:45:02+00
 db80271f-3b98-4cc6-aaad-9cf29f31fac8 | 2018-01-05 13:31:31+00 | 2018-01-05 13:41:31+00
 db80271f-3b98-4cc6-aaad-9cf29f31fac8 | 2018-01-05 13:30:02+00 | 2018-01-05 13:40:02+00
 db80271f-3b98-4cc6-aaad-9cf29f31fac8 | 2018-01-05 13:26:36+00 | 2018-01-05 13:36:36+00
 db80271f-3b98-4cc6-aaad-9cf29f31fac8 | 2018-01-05 13:25:02+00 | 2018-01-05 13:35:02+00
 db80271f-3b98-4cc6-aaad-9cf29f31fac8 | 2018-01-05 13:21:42+00 | 2018-01-05 13:31:42+00
 db80271f-3b98-4cc6-aaad-9cf29f31fac8 | 2018-01-05 13:20:03+00 | 2018-01-05 13:30:03+00
 db80271f-3b98-4cc6-aaad-9cf29f31fac8 | 2018-01-05 13:18:41+00 | 2018-01-04 15:25:50.942+00

We should be able to have this, as it is stored in table reportsexecution:

 select * from reportsexecution where nodeid <> 'root' order by date desc;
 db80271f-3b98-4cc6-aaad-9cf29f31fac8 | 2018-01-05 14:21:42+00 | t        | 20180105-092705-971adf67 |      148661
 db80271f-3b98-4cc6-aaad-9cf29f31fac8 | 2018-01-05 14:20:02+00 | t        | 20180105-092705-971adf67 |      148616
 db80271f-3b98-4cc6-aaad-9cf29f31fac8 | 2018-01-05 14:16:47+00 | t        | 20180105-092705-971adf67 |      148572
 db80271f-3b98-4cc6-aaad-9cf29f31fac8 | 2018-01-05 14:15:08+00 | t        | 20180105-092705-971adf67 |      148527
 db80271f-3b98-4cc6-aaad-9cf29f31fac8 | 2018-01-05 14:15:02+00 | t        | 20180105-092705-971adf67 |      148483
 db80271f-3b98-4cc6-aaad-9cf29f31fac8 | 2018-01-05 14:11:52+00 | t        | 20180105-092705-971adf67 |      148438
 db80271f-3b98-4cc6-aaad-9cf29f31fac8 | 2018-01-05 14:10:01+00 | t        | 20180105-092705-971adf67 |      148393
 db80271f-3b98-4cc6-aaad-9cf29f31fac8 | 2018-01-05 14:05:57+00 | t        | 20180105-092705-971adf67 |      148390
 db80271f-3b98-4cc6-aaad-9cf29f31fac8 | 2018-01-05 14:05:12+00 | t        | 20180105-092705-971adf67 |      148346
 db80271f-3b98-4cc6-aaad-9cf29f31fac8 | 2018-01-05 14:05:02+00 | t        | 20180105-092705-971adf67 |      148301
 db80271f-3b98-4cc6-aaad-9cf29f31fac8 | 2018-01-05 14:01:02+00 | t        | 20180105-092705-971adf67 |      148298
 db80271f-3b98-4cc6-aaad-9cf29f31fac8 | 2018-01-05 14:00:02+00 | t        | 20180105-092705-971adf67 |      148254
 db80271f-3b98-4cc6-aaad-9cf29f31fac8 | 2018-01-05 13:56:07+00 | t        | 20180105-092705-971adf67 |      148210
 db80271f-3b98-4cc6-aaad-9cf29f31fac8 | 2018-01-05 13:55:02+00 | t        | 20180105-092705-971adf67 |      148165
 db80271f-3b98-4cc6-aaad-9cf29f31fac8 | 2018-01-05 13:52:22+00 | t        | 20180105-092705-971adf67 |      148121
 db80271f-3b98-4cc6-aaad-9cf29f31fac8 | 2018-01-05 13:51:12+00 | t        | 20180105-092705-971adf67 |      148077
 db80271f-3b98-4cc6-aaad-9cf29f31fac8 | 2018-01-05 13:50:02+00 | t        | 20180105-092705-971adf67 |      148032
 db80271f-3b98-4cc6-aaad-9cf29f31fac8 | 2018-01-05 13:46:17+00 | t        | 20180105-092705-971adf67 |      147988
 db80271f-3b98-4cc6-aaad-9cf29f31fac8 | 2018-01-05 13:45:02+00 | t        | 20180105-092705-971adf67 |      147943
 db80271f-3b98-4cc6-aaad-9cf29f31fac8 | 2018-01-05 13:41:21+00 | t        | 20180105-092705-971adf67 |      147899
 db80271f-3b98-4cc6-aaad-9cf29f31fac8 | 2018-01-05 13:40:01+00 | t        | 20180105-092705-971adf67 |      147854
 db80271f-3b98-4cc6-aaad-9cf29f31fac8 | 2018-01-05 13:36:26+00 | t        | 20180105-092705-971adf67 |      147740
 db80271f-3b98-4cc6-aaad-9cf29f31fac8 | 2018-01-05 13:35:02+00 | t        | 20180105-092705-971adf67 |      147624
 db80271f-3b98-4cc6-aaad-9cf29f31fac8 | 2018-01-05 13:31:31+00 | t        | 20180105-092705-971adf67 |      147580
 db80271f-3b98-4cc6-aaad-9cf29f31fac8 | 2018-01-05 13:30:02+00 | t        | 20180105-092705-971adf67 |      147464
 db80271f-3b98-4cc6-aaad-9cf29f31fac8 | 2018-01-05 13:26:36+00 | t        | 20180105-092705-971adf67 |      147420
 db80271f-3b98-4cc6-aaad-9cf29f31fac8 | 2018-01-05 13:25:02+00 | t        | 20180105-092705-971adf67 |      147304
 db80271f-3b98-4cc6-aaad-9cf29f31fac8 | 2018-01-05 13:21:42+00 | t        | 20180105-092705-971adf67 |      147259


Subtasks 1 (1 open0 closed)

Architecture #12144: Extract run analysis function NewActions
Actions #1

Updated by Benoît PECCATTE over 6 years ago

  • Severity set to Minor - inconvenience | misleading | easy workaround
  • User visibility set to Infrequent - complex configurations | third party integrations
  • Effort required set to Medium
  • Priority changed from 0 to 5
Actions #2

Updated by Benoît PECCATTE over 6 years ago

  • Severity changed from Minor - inconvenience | misleading | easy workaround to Major - prevents use of part of Rudder | no simple workaround
  • User visibility changed from Infrequent - complex configurations | third party integrations to Getting started - demo | first install | level 1 Techniques
  • Priority changed from 5 to 53
Actions #3

Updated by Vincent MEMBRÉ about 6 years ago

  • Target version changed from 4.3.0~beta1 to 4.3.0~rc1
Actions #4

Updated by François ARMAND about 6 years ago

  • Target version changed from 4.3.0~rc1 to 4.1.10
  • Priority changed from 53 to 52

Targeting it in 4.1. If it is too big, it will be targeted back in 4.3.

Actions #5

Updated by François ARMAND about 6 years ago

  • Status changed from New to In progress
  • Assignee set to François ARMAND
Actions #6

Updated by Vincent MEMBRÉ about 6 years ago

  • Target version changed from 4.1.10 to 4.1.11
Actions #7

Updated by Vincent MEMBRÉ about 6 years ago

  • Target version changed from 4.1.11 to 4.1.12
  • Priority changed from 52 to 51
Actions #8

Updated by Vincent MEMBRÉ almost 6 years ago

  • Target version changed from 4.1.12 to 4.1.13
  • Priority changed from 51 to 50
Actions #9

Updated by Benoît PECCATTE almost 6 years ago

  • Target version changed from 4.1.13 to 411
Actions #10

Updated by Benoît PECCATTE almost 6 years ago

  • Target version changed from 411 to 4.1.13
Actions #11

Updated by Vincent MEMBRÉ almost 6 years ago

  • Target version changed from 4.1.13 to 4.1.14
  • Priority changed from 50 to 49
Actions #12

Updated by Benoît PECCATTE over 5 years ago

  • Target version changed from 4.1.14 to 4.1.15
  • Priority changed from 49 to 48
Actions #13

Updated by Vincent MEMBRÉ over 5 years ago

  • Target version changed from 4.1.15 to 4.1.16
  • Priority changed from 48 to 46
Actions #14

Updated by Vincent MEMBRÉ over 5 years ago

  • Target version changed from 4.1.16 to 4.1.17
  • Priority changed from 46 to 45
Actions #15

Updated by Vincent MEMBRÉ over 5 years ago

  • Target version changed from 4.1.17 to 4.1.18
  • Priority changed from 45 to 0
Actions #16

Updated by Vincent MEMBRÉ over 5 years ago

  • Target version changed from 4.1.18 to 4.1.19
Actions #17

Updated by Alexis Mousset about 5 years ago

  • Target version changed from 4.1.19 to 4.1.20
Actions #18

Updated by François ARMAND about 5 years ago

  • Target version changed from 4.1.20 to 4.1.21
Actions #19

Updated by Vincent MEMBRÉ about 5 years ago

  • Target version changed from 4.1.21 to 4.1.22
Actions #20

Updated by Vincent MEMBRÉ almost 5 years ago

  • Target version changed from 4.1.22 to 4.1.23
Actions #21

Updated by Vincent MEMBRÉ almost 5 years ago

  • Target version changed from 4.1.23 to 4.1.24
Actions #22

Updated by Vincent MEMBRÉ almost 5 years ago

  • Target version changed from 4.1.24 to 588
Actions #23

Updated by Nicolas CHARLES almost 5 years ago

  • Target version changed from 588 to 5.0.13

targeting to 5.0

Actions #24

Updated by Vincent MEMBRÉ over 4 years ago

  • Target version changed from 5.0.13 to 5.0.14
Actions #25

Updated by Vincent MEMBRÉ over 4 years ago

  • Target version changed from 5.0.14 to 5.0.15
Actions #26

Updated by Vincent MEMBRÉ over 4 years ago

  • Target version changed from 5.0.15 to 5.0.16
Actions #27

Updated by Alexis Mousset about 4 years ago

  • Target version changed from 5.0.16 to 5.0.17
Actions #28

Updated by Vincent MEMBRÉ about 4 years ago

  • Target version changed from 5.0.17 to 5.0.18
Actions #29

Updated by Vincent MEMBRÉ over 3 years ago

  • Target version changed from 5.0.18 to 5.0.19
Actions #30

Updated by Vincent MEMBRÉ over 3 years ago

  • Target version changed from 5.0.19 to 5.0.20
Actions #31

Updated by Vincent MEMBRÉ over 3 years ago

  • Target version changed from 5.0.20 to 797
Actions #32

Updated by Benoît PECCATTE almost 3 years ago

  • Target version changed from 797 to 6.1.14
Actions #33

Updated by Vincent MEMBRÉ almost 3 years ago

  • Target version changed from 6.1.14 to 6.1.15
Actions #34

Updated by Vincent MEMBRÉ almost 3 years ago

  • Target version changed from 6.1.15 to 6.1.16
Actions #35

Updated by Vincent MEMBRÉ over 2 years ago

  • Target version changed from 6.1.16 to 6.1.17
Actions #36

Updated by Vincent MEMBRÉ over 2 years ago

  • Target version changed from 6.1.17 to 6.1.18
Actions #37

Updated by Vincent MEMBRÉ over 2 years ago

  • Target version changed from 6.1.18 to 6.1.19
Actions #38

Updated by Alexis Mousset about 2 years ago

  • Tracker changed from Bug to Architecture
  • Severity deleted (Major - prevents use of part of Rudder | no simple workaround)
  • User visibility deleted (Getting started - demo | first install | level 1 Techniques)
  • Priority deleted (0)
Actions #39

Updated by Vincent MEMBRÉ about 2 years ago

  • Target version changed from 6.1.19 to 6.1.20
Actions #40

Updated by Vincent MEMBRÉ almost 2 years ago

  • Target version changed from 6.1.20 to 6.1.21
Actions #41

Updated by Vincent MEMBRÉ almost 2 years ago

  • Target version changed from 6.1.21 to old 6.1 issues to relocate
Actions #42

Updated by Alexis Mousset about 1 year ago

  • Status changed from In progress to New
Actions #43

Updated by Alexis Mousset about 1 year ago

  • Target version changed from old 6.1 issues to relocate to 8.0.0~alpha1
Actions #44

Updated by Vincent MEMBRÉ 9 months ago

  • Target version changed from 8.0.0~alpha1 to 8.0.0~beta1
Actions #45

Updated by Alexis Mousset 9 months ago

  • Target version changed from 8.0.0~beta1 to 8.1.0~alpha1
Actions #46

Updated by Vincent MEMBRÉ 3 months ago

  • Target version changed from 8.1.0~alpha1 to 8.1.0~beta1
Actions #47

Updated by Vincent MEMBRÉ about 2 months ago

  • Target version changed from 8.1.0~beta1 to 8.1.0~beta2
Actions #48

Updated by Vincent MEMBRÉ about 1 month ago

  • Target version changed from 8.1.0~beta2 to 8.1.0~rc1
Actions #49

Updated by Vincent MEMBRÉ 17 days ago

  • Target version changed from 8.1.0~rc1 to 8.1.0
Actions #50

Updated by Vincent MEMBRÉ 11 days ago

  • Target version changed from 8.1.0 to 8.1.1
Actions

Also available in: Atom PDF