[metrics-bugs] #20994 [Metrics/Onionoo]: invalid first_seen timestamp on bridges

[Tor Bug Tracker & Wiki]

#20994: invalid first_seen timestamp on bridges
-----------------------------+------------------------------
 Reporter:  cypherpunks      |          Owner:  metrics-team
     Type:  defect           |         Status:  needs_review
 Priority:  Medium           |      Milestone:
Component:  Metrics/Onionoo  |        Version:
 Severity:  Normal           |     Resolution:
 Keywords:                   |  Actual Points:
Parent ID:                   |         Points:
 Reviewer:                   |        Sponsor:
-----------------------------+------------------------------

Comment (by iwakeh):

 Replying to [comment:10 karsten]:
 > Okay, local tests look good.  I took a backup from the main Onionoo
 instance and imported archived bridge statuses since 2014-12.  I uploaded
 the `status/summary` file from
 [https://people.torproject.org/~karsten/volatile/summary-before.xz before]
 (31M) and [https://people.torproject.org/~karsten/volatile/summary-
 after.xz after] (32M) importing bridge statuses, please take a look if you
 want.  I'll also keep a backup when updating, so that we can roll back the
 day or two after without any issues.  Just in case.  But I think we're
 good here, assuming that the code review does not uncover any major
 issues.

 How did the 37 (mostly 'ki') bridges sneak in?  (grep [-c] "1970-01-01"
 summary-after)
 {{{
 b       ki      03F7D8305D9924E9C26FA29A4DB556AA62605F3E
 10.103.149.101;;        2017-01-23      08:41:04        54588   0
 V2Dir,Valid     -1      ??              -1      null    null    1970-01-01
 00:00:00        null    null    null            null    ::
 b       ki      0B35992DAC9039C0C1B5F3E3277B6D52D0E01D0C
 10.86.91.208;;  2017-01-23      08:41:04        59449   0
 V2Dir,Valid     -1      ??              -1      null    null    1970-01-01
 00:00:00        null    null    null            null    ::
 b       ki      0CE94B36871A2A9311407C477FAC2C5F7F33C473
 10.96.43.158;;  2017-01-23      08:41:04        54636   0
 V2Dir,Valid     -1      ??              -1      null    null    1970-01-01
 00:00:00        null    null    null            null    ::
 b       mullbinde12     0F6EFF59CA04EC8CD2B8ED4920660B624721E24D
 10.3.54.27;;    2017-01-23      08:41:04        52317   0
 Fast,Running,V2Dir,Valid        -1      ??              -1      null
 null    1970-01-01      00:00:00        null    null    null
 null    ::
 ...
 }}}

--
Ticket URL: <https://trac.torproject.org/projects/tor/ticket/20994#comment:12>
Tor Bug Tracker & Wiki <https://trac.torproject.org/>
The Tor Project: anonymity online