[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:  accepted
 Priority:  Very High   |      Milestone:
Component:  ExoneraTor  |        Version:
 Severity:  Major       |     Resolution:
 Keywords:              |  Actual Points:
Parent ID:              |         Points:
  Sponsor:              |
------------------------+--------------------------

Comment (by starlight):

 a guess is that

 {{{
 AND statusentry.validafter - exitlistentry.scanned <= '1 day'::INTERVAL
 }}}

 is causing the DB engine to perform the subtraction
 for every element in the index/column

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