Menu
▾
▴
[netdisco-cvs] [ netdisco-Bugs-2892746 ] Postgres processes stuck in IDLE or "IDLE IN TRANSACTION"
|
From: SourceForge.net <no...@so...> - 2009-11-05 18:36:05
|
Bugs item #2892746, was opened at 2009-11-05 09:39 Message generated for change (Comment added) made by booloo You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=558508&aid=2892746&group_id=80033 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Back-End Group: 1.0 Status: Open Resolution: None Priority: 8 Private: No Submitted By: Max Baker (maxbaker) Assigned to: Nobody/Anonymous (nobody) Summary: Postgres processes stuck in IDLE or "IDLE IN TRANSACTION" Initial Comment: Seen on a 1.0 production box at UCSC, there are postgres processes that are stuck in IDLE or IDLE in transaction states. Once there are enough of these, there are no more available connections to the database and Netdisco borks. Probable root cause is : 1. Netdisco starts a transaction 2. The user or application aborts in the middle 3. Netdisco or the Database back-end does not abort that transaction 4. The database waits forever for the transaction to finish Ideas on how to track this down or fix this are most welcome. ---------------------------------------------------------------------- Comment By: Mark Boolootian (booloo) Date: 2009-11-05 10:36 Message: Here's a snapshot of what the system typically looks like when the problem manifests: $ ps auxwww USER PID %CPU %MEM VSZ RSS TT STAT STARTED TIME COMMAND pgsql 10610 16.1 3.4 43364 34824 ?? Rs 8:01AM 9:35.40 postgres: netdisco netdisco [local] (postgres) pgsql 10607 10.5 3.5 43364 34936 ?? Rs 8:01AM 10:01.02 postgres: netdisco netdisco [local] (postgres) pgsql 10609 10.4 3.5 43364 34916 ?? Ss 8:01AM 9:27.31 postgres: netdisco netdisco [local] (postgres) pgsql 10606 9.9 3.4 43364 34848 ?? Rs 8:01AM 9:23.36 postgres: netdisco netdisco [local] (postgres) pgsql 4165 7.8 3.4 43364 34868 ?? Rs 9:00PM 79:26.43 postgres: netdisco netdisco [local] (postgres) pgsql 4169 7.8 3.5 43364 34964 ?? Rs 9:00PM 76:49.41 postgres: netdisco netdisco [local] (postgres) pgsql 4166 7.7 3.5 43364 34972 ?? Ss 9:00PM 79:44.18 postgres: netdisco netdisco [local] (postgres) pgsql 10608 6.4 3.4 43364 34876 ?? Rs 8:01AM 9:45.30 postgres: netdisco netdisco [local] (postgres) pgsql 4168 5.2 3.4 43364 34880 ?? Rs 9:00PM 78:25.05 postgres: netdisco netdisco [local] (postgres) pgsql 4167 3.4 3.5 43364 35004 ?? Ss 9:00PM 77:38.79 postgres: netdisco netdisco [local] (postgres) pgsql 10890 3.0 3.5 43364 35016 ?? Rs 9:00AM 6:12.08 postgres: netdisco netdisco [local] (postgres) root 0 0.0 0.0 0 0 ?? DLs 10:49AM 0:00.27 [swapper] root 1 0.0 0.0 1888 312 ?? ILs 10:49AM 0:00.04 /sbin/init -- root 2 0.0 0.0 0 8 ?? DL 10:49AM 0:05.32 [g_event] root 3 0.0 0.0 0 8 ?? DL 10:49AM 0:33.80 [g_up] root 4 0.0 0.0 0 8 ?? DL 10:49AM 1:01.60 [g_down] root 5 0.0 0.0 0 8 ?? DL 10:49AM 0:00.00 [kqueue taskq] root 6 0.0 0.0 0 8 ?? DL 10:49AM 0:00.00 [xpt_thrd] root 7 0.0 0.0 0 8 ?? DL 10:49AM 0:00.00 [acpi_task_0] root 8 0.0 0.0 0 8 ?? DL 10:49AM 0:00.00 [acpi_task_1] root 9 0.0 0.0 0 8 ?? DL 10:49AM 0:00.00 [acpi_task_2] root 10 0.0 0.0 0 8 ?? DL 10:49AM 0:00.00 [audit] root 11 0.0 0.0 0 8 ?? RL 10:49AM 275:32.69 [idle: cpu0] root 12 0.0 0.0 0 8 ?? WL 10:49AM 0:16.24 [swi1: net] root 13 0.0 0.0 0 8 ?? LL 10:49AM 2:48.01 [swi4: clock sio] root 14 0.0 0.0 0 8 ?? WL 10:49AM 0:00.00 [swi3: vm] root 15 0.0 0.0 0 8 ?? DL 10:49AM 0:08.62 [yarrow] root 16 0.0 0.0 0 8 ?? WL 10:49AM 0:44.12 [swi2: cambio] root 17 0.0 0.0 0 8 ?? WL 10:49AM 0:00.00 [swi5: +] root 18 0.0 0.0 0 8 ?? DL 10:49AM 0:00.00 [thread taskq] root 19 0.0 0.0 0 8 ?? WL 10:49AM 0:00.00 [swi6: Giant taskq] root 20 0.0 0.0 0 8 ?? WL 10:49AM 0:00.00 [swi6: task queue] root 21 0.0 0.0 0 8 ?? WL 10:49AM 0:00.00 [irq9: acpi0] root 22 0.0 0.0 0 8 ?? WL 10:49AM 0:00.00 [irq14: ata0] root 23 0.0 0.0 0 8 ?? WL 10:49AM 0:00.00 [irq15: ata1] root 24 0.0 0.0 0 8 ?? WL 10:49AM 0:13.16 [irq17: mpt0] root 25 0.0 0.0 0 8 ?? DL 10:49AM 0:00.00 [mpt_recovery0] root 26 0.0 0.0 0 8 ?? WL 10:49AM 1:07.02 [irq18: le0] root 27 0.0 0.0 0 8 ?? WL 10:49AM 0:00.00 [irq1: atkbd0] root 28 0.0 0.0 0 8 ?? WL 10:49AM 0:00.00 [irq12: psm0] root 29 0.0 0.0 0 8 ?? WL 10:49AM 0:00.00 [swi0: sio] root 30 0.0 0.0 0 8 ?? DL 10:49AM 0:00.48 [fdc0] root 31 0.0 0.0 0 8 ?? WL 10:49AM 0:00.00 [irq7: ppbus0 ppc0] root 32 0.0 0.0 0 16 ?? DL 10:49AM 0:00.00 [sctp_iterator] root 33 0.0 0.0 0 8 ?? DL 10:49AM 0:00.37 [pagedaemon] root 34 0.0 0.0 0 8 ?? DL 10:49AM 0:00.00 [vmdaemon] root 35 0.0 0.0 0 8 ?? DL 10:49AM 0:00.01 [pagezero] root 36 0.0 0.0 0 8 ?? DL 10:49AM 0:02.22 [bufdaemon] root 37 0.0 0.0 0 8 ?? DL 10:49AM 0:00.67 [vnlru] root 38 0.0 0.0 0 8 ?? DL 10:49AM 0:31.20 [syncer] root 39 0.0 0.0 0 8 ?? DL 10:49AM 0:10.63 [softdepflush] root 129 0.0 0.1 1380 696 ?? Is 10:49AM 0:00.00 adjkerntz -i root 465 0.0 0.0 1888 412 ?? Is 10:49AM 0:00.00 /sbin/devd root 522 0.0 0.1 3184 960 ?? Ss 10:49AM 0:00.52 /usr/sbin/syslogd -ss root 619 0.0 0.2 4672 1788 ?? Ss 10:49AM 0:04.71 /usr/sbin/ntpd -g -c /etc/ntp.conf -p /var/run/ntpd.pid -f /var/db/ntpd.drift root 660 0.0 0.4 7908 3972 ?? Ss 10:49AM 0:59.68 /usr/local/sbin/bacula-fd -u root -g wheel -v -c /usr/local/etc/bacula-fd.conf root 669 0.0 2.0 24084 20084 ?? Ss 10:49AM 0:04.15 /usr/local/sbin/httpd root 682 0.0 0.3 5752 2684 ?? Is 10:49AM 0:00.02 /usr/sbin/sshd -4 root 688 0.0 0.3 5876 2728 ?? Ss 10:49AM 0:01.90 sendmail: accepting connections (sendmail) www 691 0.0 2.6 33972 26504 ?? I 10:49AM 0:00.93 /usr/local/sbin/httpd www 692 0.0 2.6 33708 26252 ?? I 10:49AM 0:00.99 /usr/local/sbin/httpd www 693 0.0 2.6 33756 26236 ?? I 10:49AM 0:00.73 /usr/local/sbin/httpd www 695 0.0 2.5 28524 24808 ?? I 10:49AM 0:00.67 /usr/local/sbin/httpd smmsp 697 0.0 0.3 5876 2552 ?? Is 10:49AM 0:00.05 sendmail: Queue runner@00:30:00 for /var/spool/clientmqueue (sendmail) root 703 0.0 0.1 3212 1104 ?? Is 10:49AM 0:00.46 /usr/sbin/cron -s www 813 0.0 2.6 34028 26552 ?? I 10:51AM 0:01.60 /usr/local/sbin/httpd www 894 0.0 2.6 34160 26532 ?? I 11:03AM 0:00.70 /usr/local/sbin/httpd www 895 0.0 2.6 34084 26596 ?? I 11:03AM 0:01.06 /usr/local/sbin/httpd www 896 0.0 2.7 34140 26856 ?? I 11:03AM 0:00.82 /usr/local/sbin/httpd www 1060 0.0 2.5 33216 25712 ?? I 11:38AM 0:00.52 /usr/local/sbin/httpd www 1061 0.0 2.6 34076 26532 ?? I 11:38AM 0:00.79 /usr/local/sbin/httpd pgsql 2161 0.0 0.5 42332 4660 ?? Ss 2:54PM 0:02.91 /usr/local/bin/postgres -D /usr/local/pgsql/data pgsql 2167 0.0 3.4 42332 34192 ?? Ss 2:54PM 0:56.88 postgres: writer process (postgres) pgsql 2168 0.0 0.5 42332 4764 ?? Ss 2:54PM 0:14.51 postgres: wal writer process (postgres) pgsql 2169 0.0 0.5 42332 4848 ?? Ss 2:54PM 0:03.36 postgres: autovacuum launcher process (postgres) pgsql 2170 0.0 0.5 10412 4568 ?? Ss 2:54PM 0:40.50 postgres: stats collector process (postgres) pgsql 2221 0.0 0.8 42332 7940 ?? Is 2:59PM 0:00.04 postgres: netdisco netdisco [local] (postgres) pgsql 2223 0.0 1.9 43356 18784 ?? Is 2:59PM 0:00.23 postgres: netdisco netdisco [local] (postgres) pgsql 2244 0.0 0.8 42332 7644 ?? Is 3:00PM 0:00.03 postgres: netdisco netdisco [local] (postgres) pgsql 2245 0.0 1.7 43356 17072 ?? Is 3:00PM 0:00.38 postgres: netdisco netdisco [local] (postgres) pgsql 2247 0.0 0.8 42332 7724 ?? Is 3:00PM 0:00.03 postgres: netdisco netdisco [local] (postgres) pgsql 2248 0.0 2.1 43356 20952 ?? Is 3:00PM 0:00.27 postgres: netdisco netdisco [local] (postgres) pgsql 2250 0.0 0.7 42332 7324 ?? Is 3:01PM 0:00.02 postgres: netdisco netdisco [local] (postgres) pgsql 2251 0.0 1.5 43356 15552 ?? Is 3:01PM 0:00.09 postgres: netdisco netdisco [local] (postgres) pgsql 2253 0.0 0.7 42332 7424 ?? Is 3:01PM 0:00.03 postgres: netdisco netdisco [local] (postgres) pgsql 2254 0.0 2.2 43356 22624 ?? Is 3:01PM 0:00.24 postgres: netdisco netdisco [local] (postgres) pgsql 2256 0.0 0.7 42332 7560 ?? Is 3:02PM 0:00.02 postgres: netdisco netdisco [local] (postgres) pgsql 2257 0.0 1.2 43356 12388 ?? Is 3:02PM 0:00.05 postgres: netdisco netdisco [local] (postgres) pgsql 2381 0.0 0.7 42332 7552 ?? Is 3:20PM 0:00.02 postgres: netdisco netdisco [local] (postgres) pgsql 2382 0.0 1.3 43356 12748 ?? Is 3:20PM 0:00.31 postgres: netdisco netdisco [local] (postgres) pgsql 2650 0.0 0.8 42332 7932 ?? Is 4:01PM 0:00.03 postgres: netdisco netdisco [local] (postgres) pgsql 2652 0.0 1.3 43356 12872 ?? Is 4:02PM 0:00.10 postgres: netdisco netdisco [local] (postgres) pgsql 2653 0.0 0.7 42332 7236 ?? Is 4:02PM 0:00.02 postgres: netdisco netdisco [local] (postgres) pgsql 2677 0.0 0.7 42332 6716 ?? Is 4:10PM 0:00.02 postgres: netdisco netdisco [local] (postgres) pgsql 2678 0.0 2.7 43356 26960 ?? Is 4:10PM 0:00.36 postgres: netdisco netdisco [local] (postgres) pgsql 2795 0.0 1.4 43356 13960 ?? Is 4:30PM 0:00.20 postgres: netdisco netdisco [local] (postgres) root 2830 0.0 0.3 8428 3104 ?? Is 4:34PM 0:00.04 sshd: booloo [priv] (sshd) booloo 2832 0.0 0.3 8428 3104 ?? I 4:34PM 0:00.06 sshd: booloo@ttyp1 (sshd) root 4137 0.0 0.1 3212 1152 ?? I 9:00PM 0:00.00 cron: running job (cron) netdisco 4141 0.0 0.1 3464 1212 ?? Is 9:00PM 0:00.00 /bin/sh -c /usr/local/netdisco/netdisco -b -w netdisco 4146 0.0 1.9 23208 19288 ?? I 9:00PM 0:06.17 netdisco: parent waiting for children to exit (perl5.8.9) netdisco 4160 0.0 1.9 23208 19296 ?? S 9:00PM 0:08.32 netdisco: nbtstat 128.114.168.80 (perl5.8.9) netdisco 4161 0.0 1.9 23208 19292 ?? S 9:00PM 0:08.36 netdisco: worker 2 looking for nbtstat job (perl5.8.9) netdisco 4162 0.0 1.9 23208 19292 ?? S 9:00PM 0:08.27 netdisco: worker 3 looking for nbtstat job (perl5.8.9) netdisco 4163 0.0 1.9 23208 19296 ?? S 9:00PM 0:08.07 netdisco: worker 4 looking for nbtstat job (perl5.8.9) netdisco 4164 0.0 1.9 23208 19296 ?? S 9:00PM 0:07.96 netdisco: nbtstat 128.114.69.157 (perl5.8.9) root 5804 0.0 0.1 3212 1148 ?? I 2:00AM 0:00.00 cron: running job (cron) netdisco 5809 0.0 0.0 0 0 ?? Z 2:00AM 0:00.33 <defunct> netdisco 5827 0.0 1.3 17896 12800 ?? S 2:00AM 0:08.34 netdisco: admin daemon (perl5.8.9) pgsql 5828 0.0 3.4 42340 34588 ?? Ss 2:00AM 0:11.87 postgres: netdisco netdisco [local] (postgres) root 10572 0.0 0.1 3212 1148 ?? I 8:00AM 0:00.00 cron: running job (cron) netdisco 10577 0.0 0.1 3464 1160 ?? Is 8:00AM 0:00.00 /bin/sh -c /usr/local/netdisco/netdisco -b -w netdisco 10580 0.0 1.9 23136 19276 ?? I 8:00AM 0:05.72 netdisco: parent waiting for children to exit (perl5.8.9) netdisco 10601 0.0 1.9 23136 19284 ?? S 8:01AM 0:01.06 netdisco: nbtstat 128.114.2.81 (perl5.8.9) netdisco 10602 0.0 1.9 23136 19284 ?? S 8:01AM 0:01.08 netdisco: nbtstat 128.114.188.92 (perl5.8.9) netdisco 10603 0.0 1.9 23136 19284 ?? S 8:01AM 0:01.09 netdisco: nbtstat 128.114.151.106 (perl5.8.9) netdisco 10604 0.0 1.9 23136 19284 ?? S 8:01AM 0:01.12 netdisco: worker 4 looking for nbtstat job (perl5.8.9) netdisco 10605 0.0 1.9 23136 19284 ?? S 8:01AM 0:01.08 netdisco: nbtstat 169.233.6.104 (perl5.8.9) root 10859 0.0 0.1 3212 1148 ?? I 9:00AM 0:00.00 cron: running job (cron) netdisco 10863 0.0 0.1 3464 1160 ?? Is 9:00AM 0:00.00 /bin/sh -c /usr/local/netdisco/netdisco -b -R netdisco 10868 0.0 1.4 18316 14456 ?? I 9:00AM 0:00.67 netdisco: parent waiting for children to exit (perl5.8.9) netdisco 10884 0.0 2.0 24464 20396 ?? S 9:00AM 0:43.58 netdisco: rediscover 128.114.27.91 (perl5.8.9) root 11250 0.0 0.3 8428 3132 ?? Is 10:29AM 0:00.04 sshd: booloo [priv] (sshd) booloo 11252 0.0 0.3 8428 3124 ?? S 10:29AM 0:00.02 sshd: booloo@ttyp0 (sshd) root 761 0.0 0.1 3184 900 v0 Is+ 10:49AM 0:00.00 /usr/libexec/getty Pc ttyv0 root 762 0.0 0.1 3184 900 v1 Is+ 10:49AM 0:00.00 /usr/libexec/getty Pc ttyv1 root 763 0.0 0.1 3184 900 v2 Is+ 10:49AM 0:00.00 /usr/libexec/getty Pc ttyv2 root 764 0.0 0.1 3184 900 v3 Is+ 10:49AM 0:00.00 /usr/libexec/getty Pc ttyv3 root 765 0.0 0.1 3184 900 v4 Is+ 10:49AM 0:00.00 /usr/libexec/getty Pc ttyv4 root 766 0.0 0.1 3184 900 v5 Is+ 10:49AM 0:00.00 /usr/libexec/getty Pc ttyv5 root 767 0.0 0.1 3184 900 v6 Is+ 10:49AM 0:00.00 /usr/libexec/getty Pc ttyv6 root 768 0.0 0.1 3184 900 v7 Is+ 10:49AM 0:00.00 /usr/libexec/getty Pc ttyv7 booloo 11254 0.0 0.2 4400 1940 p0 Is 10:29AM 0:00.03 -bash (bash) root 11258 0.0 0.1 3620 1324 p0 I 10:29AM 0:00.01 su - root 11259 0.0 0.2 4464 2104 p0 I 10:29AM 0:00.02 -su (csh) root 11263 0.0 0.1 3620 1304 p0 I 10:29AM 0:00.01 su - netdisco netdisco 11264 0.0 0.1 3464 1304 p0 S 10:29AM 0:00.01 -su (sh) netdisco 11266 0.0 0.1 3244 976 p0 R+ 10:29AM 0:00.00 ps auxwww booloo 2834 0.0 0.2 4400 1920 p1 Is+ 4:34PM 0:00.04 -bash (bash) $ /usr/local/netdisco/sql/pg -b /usr/local/netdisco/sql/pg_procs.sql /usr/local/netdisco/sql/pg - Netdisco Postgres Wrapper. Loading /usr/local/netdisco/sql/pg_procs.sql into psql select datname, datid, procpid, usesysid, query_start, waiting, current_query from pg_stat_activity order by procpid; datname | datid | procpid | usesysid | query_start | waiting | current_query ----------+-------+---------+----------+-------------------------------+---------+------------------------------------------------------------------------------------------------------------------------------------------------------- netdisco | 16385 | 2221 | 16384 | 2009-11-05 10:08:13.079641-08 | f | <IDLE> netdisco | 16385 | 2223 | 16384 | 2009-11-05 10:08:13.076505-08 | f | <IDLE> netdisco | 16385 | 2244 | 16384 | 2009-11-05 09:46:49.696344-08 | f | <IDLE> netdisco | 16385 | 2245 | 16384 | 2009-11-04 17:11:00.900333-08 | f | <IDLE> netdisco | 16385 | 2247 | 16384 | 2009-11-05 10:08:17.645875-08 | f | <IDLE> netdisco | 16385 | 2248 | 16384 | 2009-11-05 10:08:17.634511-08 | f | <IDLE> netdisco | 16385 | 2250 | 16384 | 2009-11-05 07:02:42.437776-08 | f | <IDLE> netdisco | 16385 | 2251 | 16384 | 2009-11-04 17:17:45.565971-08 | f | <IDLE> netdisco | 16385 | 2253 | 16384 | 2009-11-04 17:24:15.098992-08 | f | <IDLE> netdisco | 16385 | 2254 | 16384 | 2009-11-04 17:24:15.095214-08 | f | <IDLE> netdisco | 16385 | 2256 | 16384 | 2009-11-05 09:40:41.031347-08 | f | <IDLE> netdisco | 16385 | 2257 | 16384 | 2009-11-04 17:17:57.133511-08 | f | <IDLE> netdisco | 16385 | 2381 | 16384 | 2009-11-05 10:08:06.852568-08 | f | <IDLE> netdisco | 16385 | 2382 | 16384 | 2009-11-05 10:08:06.849928-08 | f | <IDLE> netdisco | 16385 | 2650 | 16384 | 2009-11-05 09:41:14.945045-08 | f | <IDLE> netdisco | 16385 | 2652 | 16384 | 2009-11-05 09:41:14.509713-08 | f | <IDLE> netdisco | 16385 | 2653 | 16384 | 2009-11-05 09:40:57.833446-08 | f | <IDLE> netdisco | 16385 | 2677 | 16384 | 2009-11-04 16:35:13.183755-08 | f | <IDLE> netdisco | 16385 | 2678 | 16384 | 2009-11-04 16:35:13.165859-08 | f | <IDLE> netdisco | 16385 | 2795 | 16384 | 2009-11-05 09:40:57.830067-08 | f | <IDLE> netdisco | 16385 | 4165 | 16384 | 2009-11-05 10:29:58.351124-08 | f | SELECT * FROM process WHERE controller = '4146' AND action = 'nbtstat' AND device = '169.233.31.119' FOR UPDATE netdisco | 16385 | 4166 | 16384 | 2009-11-05 10:29:58.45745-08 | f | SELECT * FROM process WHERE controller = '4146' AND action = 'nbtstat' AND device = '128.114.113.107' FOR UPDATE netdisco | 16385 | 4167 | 16384 | 2009-11-05 10:30:06.521762-08 | t | SELECT controller,action,device FROM process WHERE (controller = '4146') AND (status = 'queued') AND (action = 'nbtstat') LIMIT 1 OFFSET 3 FOR UPDATE netdisco | 16385 | 4168 | 16384 | 2009-11-05 10:29:59.651495-08 | f | UPDATE process SET count='0',status='done' WHERE controller = '4146' AND action = 'nbtstat' AND device = '128.114.162.241' netdisco | 16385 | 4169 | 16384 | 2009-11-05 10:30:03.673767-08 | f | SELECT * FROM process WHERE controller = '4146' AND action = 'nbtstat' AND device = '128.114.44.243' FOR UPDATE netdisco | 16385 | 5828 | 16384 | 2009-11-05 10:30:09.189695-08 | f | <IDLE> netdisco | 16385 | 10606 | 16384 | 2009-11-05 10:30:07.307818-08 | f | SELECT * FROM process WHERE controller = '10580' AND action = 'nbtstat' AND device = '128.114.204.54' FOR UPDATE netdisco | 16385 | 10607 | 16384 | 2009-11-05 10:30:03.193168-08 | f | UPDATE process SET count='0',status='done' WHERE controller = '10580' AND action = 'nbtstat' AND device = '128.114.199.195' netdisco | 16385 | 10608 | 16384 | 2009-11-05 10:30:09.087472-08 | f | SELECT * FROM process WHERE controller = '10580' AND action = 'nbtstat' AND device = '169.233.7.101' FOR UPDATE netdisco | 16385 | 10609 | 16384 | 2009-11-05 10:30:08.622443-08 | f | UPDATE process SET status='running' WHERE controller = '10580' AND action = 'nbtstat' AND device = '169.233.41.67' netdisco | 16385 | 10610 | 16384 | 2009-11-05 10:30:07.557831-08 | f | SELECT * FROM process WHERE controller = '10580' AND action = 'nbtstat' AND device = '128.114.252.24' FOR UPDATE netdisco | 16385 | 10890 | 16384 | 2009-11-05 10:30:02.446825-08 | f | UPDATE process SET status='running' WHERE controller = '10868' AND action = 'rediscover' AND device = '169.233.35.228' netdisco | 16385 | 11273 | 16384 | 2009-11-05 10:30:08.993754-08 | f | <IDLE> netdisco | 16385 | 11279 | 16384 | 2009-11-05 10:30:09.256541-08 | f | select datname, datid, procpid, usesysid, query_start, waiting, current_query from pg_stat_activity order by procpid; (34 rows) ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=558508&aid=2892746&group_id=80033 |