[tor-bugs] #3834 [Torflow]: Postgre bandwidth scanner has halted on moria

[Tor Bug Tracker & Wiki]

#3834: Postgre bandwidth scanner has halted on moria
-----------------------+----------------------------------------------------
 Reporter:  mikeperry  |          Owner:  aagbsn
     Type:  defect     |         Status:  new   
 Priority:  major      |      Milestone:        
Component:  Torflow    |        Version:        
 Keywords:             |         Parent:        
   Points:             |   Actualpoints:        
-----------------------+----------------------------------------------------

Comment(by aagbsn):

 adding from email:

 % ps -w -u postgres u
 USER       PID %CPU %MEM    VSZ   RSS TTY      STAT START   TIME COMMAND
 postgres  2353  0.0  0.0 101012  4400 ?        S    Jun21  14:30
 /usr/lib/postgr
 esql/8.3/bin/postgres -D /var/lib/postgresql/8.3/mai
 postgres  2358  0.0  0.4 101144 26656 ?        Ss   Jun21  11:19 postgres:
 write
 r process
 postgres  2359  0.0  0.0 101012  1068 ?        Ss   Jun21   6:53 postgres:
 wal writer process
 postgres  2360  0.0  0.0 101564  1488 ?        Ss   Jun21  11:44 postgres:
 autovacuum launcher process
 postgres  2361  0.0  0.0  71752  1192 ?        Ss   Jun21  18:33 postgres:
 stats collector process
 postgres  3642  0.2  0.2 103936 16688 ?        Ss   00:43   0:40 postgres:
 bwscanner bwscan1 127.0.0.1(58025) idle in transaction
 postgres  3667  0.2  0.2 103888 17280 ?        Ss   00:43   0:38 postgres:
 bwscanner bwscan2 127.0.0.1(58054) idle
 postgres  3679  0.0  0.2 103900 14248 ?        Ss   00:43   0:08 postgres:
 bwscanner bwscan3 127.0.0.1(58056) UPDATE waiting
 postgres  4023  0.1  0.2 103388 13832 ?        Ss   00:46   0:21 postgres:
 bwscanner bwscan1 127.0.0.1(43811) idle
 postgres  4027  0.1  0.2 103328 14720 ?        Ss   00:46   0:26 postgres:
 bwscanner bwscan2 127.0.0.1(43817) idle
 postgres  4031  0.0  0.1 103356  8408 ?        Ss   00:46   0:00 postgres:
 bwscanner bwscan3 127.0.0.1(43858) idle in transaction
 postgres 30756  0.8  0.2 103308 13736 ?        Ss   04:59   0:12 postgres:
 bwscanner bwscan4 127.0.0.1(45962) idle
 postgres 31138  0.3  0.1 103368  9808 ?        Ss   05:02   0:03 postgres:
 bwscanner bwscan4 127.0.0.1(46645) idle in transaction

 searching around for postgres "UPDATE WAITING" gives a few interesting
 results:
 http://archives.postgresql.org/pgsql-general/2002-08/msg01119.php
 http://archives.postgresql.org/pgsql-sql/1999-05/msg00065.php

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