[RSSAC Caucus] Some very different early results looking at publication latency

Sept. 5, 2019

      Hi there. If you read my last message, you saw some data at the bottom. It turns out the data was all wrong. Duane caught the fact that some of it was clearly wrong, and after a bunch of futzing with my report program, I saw the error (hint: time gaps are hard). The new data is below.
...
From the output, you can see that it is not always the same RSO that is lagging. None of the SOA transitions of the four so far took place in a single five-minute window.
Looking at the individual measurements, some collectors see different SOAs from the same RSO in the same collection period between v4 and v6; this could be routing differences, Some collectors see different SOAS from the same RSO in the same collection period between TCP and UDP; this is possibly due to load balancers and some of the systems behind them not being updated at the same time.

I hope this helps.

--Paul Hoffman

There are 213354 result records in the database
Out of 4638 five-minute gaps, 12 have more than one SOA

==========

20190902:221500 (1567487700):
  a    2019090201: 30    2019090300: 02
  b    2019090201: 32    2019090300: 00
  c    2019090201: 32    2019090300: 00
  d    2019090201: 32    2019090300: 00
  e    2019090201: 32    2019090300: 00
  f    2019090201: 32    2019090300: 00
  g    2019090201: 32    2019090300: 00
  h    2019090201: 28    2019090300: 04
  i    2019090201: 32    2019090300: 00
  j    2019090201: 28    2019090300: 04
  k    2019090201: 30    2019090300: 02
  l    2019090201: 32    2019090300: 00
  m    2019090201: 30    2019090300: 02

20190902:222000 (1567488000):
  a    2019090201: 00    2019090300: 32
  b    2019090201: 00    2019090300: 32
  c    2019090201: 00    2019090300: 32
  d    2019090201: 00    2019090300: 32
  e    2019090201: 00    2019090300: 32
  f    2019090201: 04    2019090300: 28
  g    2019090201: 00    2019090300: 30
  h    2019090201: 00    2019090300: 32
  i    2019090201: 00    2019090300: 32
  j    2019090201: 00    2019090300: 32
  k    2019090201: 01    2019090300: 31
  l    2019090201: 25    2019090300: 07
  m    2019090201: 00    2019090300: 32

==========

20190903:101500 (1567530900):
  a    2019090300: 00    2019090301: 32
  b    2019090300: 00    2019090301: 32
  c    2019090300: 00    2019090301: 30
  d    2019090300: 04    2019090301: 28
  e    2019090300: 00    2019090301: 32
  f    2019090300: 04    2019090301: 28
  g    2019090300: 00    2019090301: 31
  h    2019090300: 00    2019090301: 32
  i    2019090300: 03    2019090301: 28
  j    2019090300: 00    2019090301: 31
  k    2019090300: 01    2019090301: 30
  l    2019090300: 13    2019090301: 19
  m    2019090300: 00    2019090301: 32

20190903:102000 (1567531200):
  a    2019090300: 00    2019090301: 32
  b    2019090300: 00    2019090301: 32
  c    2019090300: 00    2019090301: 32
  d    2019090300: 00    2019090301: 32
  e    2019090300: 00    2019090301: 32
  f    2019090300: 04    2019090301: 28
  g    2019090300: 00    2019090301: 32
  h    2019090300: 00    2019090301: 32
  i    2019090300: 00    2019090301: 32
  j    2019090300: 00    2019090301: 32
  k    2019090300: 00    2019090301: 32
  l    2019090300: 00    2019090301: 32
  m    2019090300: 00    2019090301: 32

==========

20190903:222000 (1567574400):
  a    2019090301: 00    2019090400: 32
  b    2019090301: 10    2019090400: 22
  c    2019090301: 25    2019090400: 06
  d    2019090301: 04    2019090400: 28
  e    2019090301: 01    2019090400: 31
  f    2019090301: 32    2019090400: 00
  g    2019090301: 01    2019090400: 29
  h    2019090301: 12    2019090400: 20
  i    2019090301: 28    2019090400: 02
  j    2019090301: 00    2019090400: 32
  k    2019090301: 30    2019090400: 02
  l    2019090301: 29    2019090400: 02
  m    2019090301: 00    2019090400: 32

20190903:222500 (1567574700):
  a    2019090301: 00    2019090400: 32
  b    2019090301: 00    2019090400: 32
  c    2019090301: 00    2019090400: 32
  d    2019090301: 00    2019090400: 32
  e    2019090301: 00    2019090400: 32
  f    2019090301: 04    2019090400: 28
  g    2019090301: 00    2019090400: 31
  h    2019090301: 00    2019090400: 32
  i    2019090301: 00    2019090400: 32
  j    2019090301: 00    2019090400: 32
  k    2019090301: 01    2019090400: 31
  l    2019090301: 01    2019090400: 31
  m    2019090301: 00    2019090400: 32

20190903:223000 (1567575000):
  a    2019090301: 00    2019090400: 32
  b    2019090301: 00    2019090400: 32
  c    2019090301: 00    2019090400: 32
  d    2019090301: 00    2019090400: 32
  e    2019090301: 00    2019090400: 32
  f    2019090301: 04    2019090400: 28
  g    2019090301: 00    2019090400: 31
  h    2019090301: 00    2019090400: 32
  i    2019090301: 00    2019090400: 32
  j    2019090301: 00    2019090400: 32
  k    2019090301: 00    2019090400: 32
  l    2019090301: 00    2019090400: 32
  m    2019090301: 00    2019090400: 32

20190903:223500 (1567575300):
  a    2019090301: 00    2019090400: 32
  b    2019090301: 00    2019090400: 32
  c    2019090301: 00    2019090400: 32
  d    2019090301: 00    2019090400: 32
  e    2019090301: 00    2019090400: 32
  f    2019090301: 04    2019090400: 28
  g    2019090301: 00    2019090400: 29
  h    2019090301: 00    2019090400: 32
  i    2019090301: 00    2019090400: 32
  j    2019090301: 00    2019090400: 31
  k    2019090301: 00    2019090400: 32
  l    2019090301: 00    2019090400: 32
  m    2019090301: 00    2019090400: 32

20190903:224000 (1567575600):
  a    2019090301: 00    2019090400: 32
  b    2019090301: 00    2019090400: 32
  c    2019090301: 00    2019090400: 32
  d    2019090301: 00    2019090400: 32
  e    2019090301: 00    2019090400: 32
  f    2019090301: 04    2019090400: 28
  g    2019090301: 00    2019090400: 30
  h    2019090301: 00    2019090400: 32
  i    2019090301: 00    2019090400: 31
  j    2019090301: 00    2019090400: 32
  k    2019090301: 00    2019090400: 32
  l    2019090301: 00    2019090400: 32
  m    2019090301: 00    2019090400: 32

==========

20190904:081500 (1567610100):
  a    2019090400: 00    2019090401: 32
  b    2019090400: 00    2019090401: 32
  c    2019090400: 00    2019090401: 32
  d    2019090400: 00    2019090401: 32
  e    2019090400: 00    2019090401: 32
  f    2019090400: 04    2019090401: 28
  g    2019090400: 00    2019090401: 30
  h    2019090400: 00    2019090401: 32
  i    2019090400: 01    2019090401: 27
  j    2019090400: 00    2019090401: 32
  k    2019090400: 00    2019090401: 31
  l    2019090400: 18    2019090401: 14
  m    2019090400: 00    2019090401: 32

20190904:082000 (1567610400):
  a    2019090400: 00    2019090401: 32
  b    2019090400: 00    2019090401: 32
  c    2019090400: 00    2019090401: 32
  d    2019090400: 00    2019090401: 32
  e    2019090400: 00    2019090401: 32
  f    2019090400: 04    2019090401: 28
  g    2019090400: 00    2019090401: 31
  h    2019090400: 00    2019090401: 32
  i    2019090400: 01    2019090401: 28
  j    2019090400: 00    2019090401: 32
  k    2019090400: 00    2019090401: 31
  l    2019090400: 00    2019090401: 32
  m    2019090400: 00    2019090401: 32

20190904:082500 (1567610700):
  a    2019090400: 00    2019090401: 32
  b    2019090400: 00    2019090401: 32
  c    2019090400: 00    2019090401: 32
  d    2019090400: 00    2019090401: 32
  e    2019090400: 00    2019090401: 32
  f    2019090400: 00    2019090401: 32
  g    2019090400: 00    2019090401: 29
  h    2019090400: 00    2019090401: 32
  i    2019090400: 02    2019090401: 27
  j    2019090400: 00    2019090401: 32
  k    2019090400: 00    2019090401: 32
  l    2019090400: 00    2019090401: 31
  m    2019090400: 00    2019090401: 32