[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):

 Replying to [comment:15 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
 >
 >
 Also found this piece of info:

 http://grokbase.com/t/postgresql.org/pgsql-general/2011/06/postgres-8-3-10
 -alter-table-waiting-issue/16hv6ndfcuqzm2ncyf2w6dr77p6e

 Maybe an exception is preventing the transaction from completing? Every
 freeze Roger has seen has been preceded by a Socks5Erorr...

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