Project

General

Profile

Actions
Copy link

Architecture #11925

open

NodeCompliance is not historised when web interface is shut down

Added by Nicolas CHARLES almost 7 years ago. Updated 20 days ago.

Status:
New
Priority:
N/A
Assignee:
François ARMAND
Category:
Web - Compliance & node report
Target version:
8.1.11
Pull Request:
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 open — 0 closed)

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

Updated by Benoît PECCATTE almost 7 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
Copy link
 #2

Updated by Benoît PECCATTE almost 7 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
Copy link
 #3

Updated by Vincent MEMBRÉ almost 7 years ago

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

Updated by François ARMAND almost 7 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
Copy link
 #5

Updated by François ARMAND almost 7 years ago

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

Updated by Vincent MEMBRÉ almost 7 years ago

  • Target version changed from 4.1.10 to 4.1.11
Actions
Copy link
 #7

Updated by Vincent MEMBRÉ over 6 years ago

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

Updated by Vincent MEMBRÉ over 6 years ago

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

Updated by Benoît PECCATTE over 6 years ago

  • Target version changed from 4.1.13 to 411
Actions
Copy link
 #10

Updated by Benoît PECCATTE over 6 years ago

  • Target version changed from 411 to 4.1.13
Actions
Copy link
 #11

Updated by Vincent MEMBRÉ over 6 years ago

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

Updated by Benoît PECCATTE over 6 years ago

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

Updated by Vincent MEMBRÉ about 6 years ago

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

Updated by Vincent MEMBRÉ about 6 years ago

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

Updated by Vincent MEMBRÉ about 6 years ago

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

Updated by Vincent MEMBRÉ almost 6 years ago

  • Target version changed from 4.1.18 to 4.1.19
Actions
Copy link
 #17

Updated by Alexis Mousset almost 6 years ago

  • Target version changed from 4.1.19 to 4.1.20
Actions
Copy link
 #18

Updated by François ARMAND almost 6 years ago

  • Target version changed from 4.1.20 to 4.1.21
Actions
Copy link
 #19

Updated by Vincent MEMBRÉ over 5 years ago

  • Target version changed from 4.1.21 to 4.1.22
Actions
Copy link
 #20

Updated by Vincent MEMBRÉ over 5 years ago

  • Target version changed from 4.1.22 to 4.1.23
Actions
Copy link
 #21

Updated by Vincent MEMBRÉ over 5 years ago

  • Target version changed from 4.1.23 to 4.1.24
Actions
Copy link
 #22

Updated by Vincent MEMBRÉ over 5 years ago

  • Target version changed from 4.1.24 to 588
Actions
Copy link
 #23

Updated by Nicolas CHARLES over 5 years ago

  • Target version changed from 588 to 5.0.13

targeting to 5.0

Actions
Copy link
 #24

Updated by Vincent MEMBRÉ over 5 years ago

  • Target version changed from 5.0.13 to 5.0.14
Actions
Copy link
 #25

Updated by Vincent MEMBRÉ about 5 years ago

  • Target version changed from 5.0.14 to 5.0.15
Actions
Copy link
 #26

Updated by Vincent MEMBRÉ about 5 years ago

  • Target version changed from 5.0.15 to 5.0.16
Actions
Copy link
 #27

Updated by Alexis Mousset almost 5 years ago

  • Target version changed from 5.0.16 to 5.0.17
Actions
Copy link
 #28

Updated by Vincent MEMBRÉ over 4 years ago

  • Target version changed from 5.0.17 to 5.0.18
Actions
Copy link
 #29

Updated by Vincent MEMBRÉ over 4 years ago

  • Target version changed from 5.0.18 to 5.0.19
Actions
Copy link
 #30

Updated by Vincent MEMBRÉ over 4 years ago

  • Target version changed from 5.0.19 to 5.0.20
Actions
Copy link
 #31

Updated by Vincent MEMBRÉ about 4 years ago

  • Target version changed from 5.0.20 to 797
Actions
Copy link
 #32

Updated by Benoît PECCATTE over 3 years ago

  • Target version changed from 797 to 6.1.14
Actions
Copy link
 #33

Updated by Vincent MEMBRÉ over 3 years ago

  • Target version changed from 6.1.14 to 6.1.15
Actions
Copy link
 #34

Updated by Vincent MEMBRÉ over 3 years ago

  • Target version changed from 6.1.15 to 6.1.16
Actions
Copy link
 #35

Updated by Vincent MEMBRÉ over 3 years ago

  • Target version changed from 6.1.16 to 6.1.17
Actions
Copy link
 #36

Updated by Vincent MEMBRÉ about 3 years ago

  • Target version changed from 6.1.17 to 6.1.18
Actions
Copy link
 #37

Updated by Vincent MEMBRÉ about 3 years ago

  • Target version changed from 6.1.18 to 6.1.19
Actions
Copy link
 #38

Updated by Alexis Mousset almost 3 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
Copy link
 #39

Updated by Vincent MEMBRÉ over 2 years ago

  • Target version changed from 6.1.19 to 6.1.20
Actions
Copy link
 #40

Updated by Vincent MEMBRÉ over 2 years ago

  • Target version changed from 6.1.20 to 6.1.21
Actions
Copy link
 #41

Updated by Vincent MEMBRÉ over 2 years ago

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

Updated by Alexis Mousset almost 2 years ago

  • Status changed from In progress to New
Actions
Copy link
 #43

Updated by Alexis Mousset almost 2 years ago

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

Updated by Vincent MEMBRÉ over 1 year ago

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

Updated by Alexis Mousset over 1 year ago

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

Updated by Vincent MEMBRÉ 11 months ago

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

Updated by Vincent MEMBRÉ 10 months ago

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

Updated by Vincent MEMBRÉ 9 months ago

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

Updated by Vincent MEMBRÉ 9 months ago

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

Updated by Vincent MEMBRÉ 9 months ago

  • Target version changed from 8.1.0 to 8.1.1
Actions
Copy link
 #51

Updated by Vincent MEMBRÉ 8 months ago

  • Target version changed from 8.1.1 to 8.1.2
Actions
Copy link
 #52

Updated by Vincent MEMBRÉ 8 months ago

  • Target version changed from 8.1.2 to 8.1.3
Actions
Copy link
 #53

Updated by Vincent MEMBRÉ 7 months ago

  • Target version changed from 8.1.3 to 8.1.4
Actions
Copy link
 #54

Updated by Vincent MEMBRÉ 6 months ago

  • Target version changed from 8.1.4 to 8.1.5
Actions
Copy link
 #55

Updated by Vincent MEMBRÉ 6 months ago

  • Target version changed from 8.1.5 to 8.1.6
Actions
Copy link
 #56

Updated by Vincent MEMBRÉ 5 months ago

  • Target version changed from 8.1.6 to 8.1.7
Actions
Copy link
 #57

Updated by Vincent MEMBRÉ 3 months ago

  • Target version changed from 8.1.7 to 8.1.8
Actions
Copy link
 #58

Updated by Vincent MEMBRÉ about 1 month ago

  • Target version changed from 8.1.8 to 8.1.9
Actions
Copy link
 #59

Updated by Vincent MEMBRÉ 25 days ago

  • Target version changed from 8.1.9 to 8.1.10
Actions
Copy link
 #60

Updated by Vincent MEMBRÉ 20 days ago

  • Target version changed from 8.1.10 to 8.1.11
Actions
Copy link

Also available in: Atom PDF