[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):
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
_______________________________________________
tor-bugs mailing list
tor-bugs@xxxxxxxxxxxxxxxxxxxx
https://lists.torproject.org/cgi-bin/mailman/listinfo/tor-bugs