[tor-bugs] #17488 [ExoneraTor]: ExoneraTor hangs forever on old known-positive test

[Tor Bug Tracker & Wiki]

#17488: ExoneraTor hangs forever on old known-positive test
------------------------+------------------------------
 Reporter:  starlight   |          Owner:  karsten
     Type:  defect      |         Status:  needs_review
 Priority:  Very High   |      Milestone:
Component:  ExoneraTor  |        Version:
 Severity:  Major       |     Resolution:
 Keywords:              |  Actual Points:
Parent ID:              |         Points:
  Sponsor:              |
------------------------+------------------------------
Changes (by karsten):

 * status:  accepted => needs_review


Comment:

 Thanks for digging that out, but we're using PostgreSQL, not MySQL.
 However, I'm also actually curious about making this change to always
 search for all hits in the same /24 or /48, because I'd like to avoid
 making more than one database query per request.  But that's another
 ticket, we should first get this one fixed.

 I just pushed
 [https://gitweb.torproject.org/user/karsten/exonerator.git/log/?h=task-17488
 branch-17488 to my public repository] and deployed that branch on
 https://exonerator.torproject.org/.  Want to give it a try and see if
 there are still performance problems with any query you come up with?

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