Hi, I was working on my patch when I noticed that pcp_proc_info doesn't work anymore on HEAD. I mean on a vanilla HEAD (ie, without any patchs, clear as it could come from CVS).
See this example: guilla...@laptop:/opt/pgpool-head$ ps -ef | grep pgpool 1000 11350 13641 0 17:25 pts/1 00:00:00 bin/pgpool -f etc/pgpool.conf -n 1000 11351 11350 0 17:25 pts/1 00:00:00 pgpool: wait for connection request 1000 11352 11350 0 17:25 pts/1 00:00:00 pgpool: wait for connection request 1000 11353 11350 0 17:25 pts/1 00:00:00 pgpool: wait for connection request 1000 11354 11350 0 17:25 pts/1 00:00:00 pgpool: wait for connection request 1000 11355 11350 0 17:25 pts/1 00:00:00 pgpool: wait for connection request 1000 11356 11350 0 17:25 pts/1 00:00:00 pgpool: wait for connection request 1000 11357 11350 0 17:25 pts/1 00:00:00 pgpool: wait for connection request 1000 11358 11350 0 17:25 pts/1 00:00:00 pgpool: wait for connection request 1000 11359 11350 0 17:25 pts/1 00:00:00 pgpool: wait for connection request 1000 11360 11350 0 17:25 pts/1 00:00:00 pgpool: wait for connection request 1000 11361 11350 0 17:25 pts/1 00:00:00 pgpool: wait for connection request 1000 11362 11350 0 17:25 pts/1 00:00:00 pgpool: wait for connection request 1000 11363 11350 0 17:25 pts/1 00:00:00 pgpool: wait for connection request 1000 11364 11350 0 17:25 pts/1 00:00:00 pgpool: wait for connection request 1000 11365 11350 0 17:25 pts/1 00:00:00 pgpool: wait for connection request 1000 11366 11350 0 17:25 pts/1 00:00:00 pgpool: wait for connection request 1000 11367 11350 0 17:25 pts/1 00:00:00 pgpool: wait for connection request 1000 11368 11350 0 17:25 pts/1 00:00:00 pgpool: wait for connection request 1000 11369 11350 0 17:25 pts/1 00:00:00 pgpool: wait for connection request 1000 11370 11350 0 17:25 pts/1 00:00:00 pgpool: wait for connection request 1000 11371 11350 0 17:25 pts/1 00:00:00 pgpool: wait for connection request 1000 11372 11350 0 17:25 pts/1 00:00:00 pgpool: wait for connection request 1000 11373 11350 0 17:25 pts/1 00:00:00 pgpool: wait for connection request 1000 11374 11350 0 17:25 pts/1 00:00:00 pgpool: wait for connection request 1000 11375 11350 0 17:25 pts/1 00:00:00 pgpool: wait for connection request 1000 11376 11350 0 17:25 pts/1 00:00:00 pgpool: wait for connection request 1000 11377 11350 0 17:25 pts/1 00:00:00 pgpool: wait for connection request 1000 11378 11350 0 17:25 pts/1 00:00:00 pgpool: wait for connection request 1000 11379 11350 0 17:25 pts/1 00:00:00 pgpool: wait for connection request 1000 11380 11350 0 17:25 pts/1 00:00:00 pgpool: wait for connection request 1000 11381 11350 0 17:25 pts/1 00:00:00 pgpool: guillaume postgres [local] idle 1000 11382 11350 0 17:25 pts/1 00:00:00 pgpool: guillaume b1 127.0.0.1(37793) idle 1000 11383 11350 0 17:25 pts/1 00:00:00 pgpool: PCP: wait for connection request 1000 11384 11350 0 17:25 pts/1 00:00:00 pgpool: worker process 1000 11728 14734 0 17:41 pts/2 00:00:00 grep --color=auto pgpool So, I have two psql connected to PostgreSQL via pgpool. Let's try to get info from pid 11381 and 11382: guilla...@laptop:/opt/pgpool-head$ bin/pcp_proc_info 10 localhost 9898 postgres toto 11382 guilla...@laptop:/opt/pgpool-head$ bin/pcp_proc_info 10 localhost 9898 postgres toto 11381 Nothing at all. That's already weird. If I look at all processes, I finally found the pid: guilla...@laptop:/opt/pgpool-head$ bin/pcp_proc_info 10 localhost 9898 postgres toto 11351 b1 guillaume 1279985121 1279985142 3 0 1 But if I look at my ps output, 11351 is waiting for a connection. I tried to figure what was going one, but failed. If anyone has any ideas, I'm open to hear them :) PS: tried on V2_3_STABLE, works great. -- Guillaume http://www.postgresql.fr http://dalibo.com _______________________________________________ Pgpool-hackers mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-hackers
