[Author Prev][Author Next][Thread Prev][Thread Next][Author Index][Thread Index]

Re: [tor-bugs] #3265 [Tor Relay]: Relays publish on average more than 1 descriptor per hour

#3265: Relays publish on average more than 1 descriptor per hour
-----------------------+----------------------------------------------------
 Reporter:  karsten    |          Owner:                     
     Type:  defect     |         Status:  needs_information  
 Priority:  normal     |      Milestone:                     
Component:  Tor Relay  |        Version:  Tor: 0.2.2.22-alpha
 Keywords:             |         Parent:                     
   Points:             |   Actualpoints:                     
-----------------------+----------------------------------------------------
Changes (by karsten):

  * status:  new => needs_information


Comment:

 Here's a quick SQL statement to see if this problem still exists.  It
 does.  There are some relays publishing 200 descriptors or more per day:

 {{{
 tordir=> SELECT date, numdescs, COUNT(*) FROM
   (SELECT DATE(published), COUNT(*) AS numdescs
   FROM descriptor WHERE published > '2011-07-22'
   GROUP BY fingerprint, DATE(published)) a
   GROUP BY 1, 2 HAVING numdescs >= 50 ORDER BY 1, 2;

     date    | numdescs | count
 ------------+----------+-------
  2011-07-22 |       84 |     1
  2011-07-22 |      209 |     1
  2011-07-23 |       51 |     1
  2011-07-23 |       55 |     1
  2011-07-23 |       58 |     1
  2011-07-23 |      107 |     1
  2011-07-23 |      202 |     1
  2011-07-24 |       59 |     2
  2011-07-24 |       83 |     1
  2011-07-24 |      197 |     1
  2011-07-25 |       60 |     1
  2011-07-25 |       78 |     1
  2011-07-25 |      182 |     1
  2011-07-26 |      157 |     1
 (14 rows)
 }}}

-- 
Ticket URL: <https://trac.torproject.org/projects/tor/ticket/3265#comment:1>
Tor Bug Tracker & Wiki <https://trac.torproject.org/>
The Tor Project: anonymity online
_______________________________________________
tor-bugs mailing list
tor-bugs@xxxxxxxxxxxxxxxxxxxx
https://lists.torproject.org/cgi-bin/mailman/listinfo/tor-bugs