[Author Prev][Author Next][Thread Prev][Thread Next][Author Index][Thread Index]
Re: [tor-bugs] #3834 [Torflow]: Postgre bandwidth scanner has halted on moria
#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
_______________________________________________
tor-bugs mailing list
tor-bugs@xxxxxxxxxxxxxxxxxxxx
https://lists.torproject.org/cgi-bin/mailman/listinfo/tor-bugs