BZ #128: Running boxinfo.pl opens a connection and it hangs on port 9898

[machack666]

Ramesh 2014-01-31 05:42:30 EST
Hi,

When running the boxinfo.pl in production box with pgpool configured, I noticed
that a connection to port 9898 stays even after the script gets completed.

Here is the list of pid which is stays live holding the port.

-bash-4.1# ps -ef|grep psql
root 1106 1 0 12:45 ? 00:00:00 sh -c psql -X -x -t -h /tmp/ -p
9898 -c "\l+" 2>&1
root 1107 1106 0 12:45 ? 00:00:00 psql -X -x -t -h /tmp/ -p 9898
-c \l+
root 2916 1 0 12:47 ? 00:00:00 sh -c psql -X -x -t -h /tmp/ -p
9898 -c "\l+" 2>&1
root 2917 2916 0 12:47 ? 00:00:00 psql -X -x -t -h /tmp/ -p 9898
-c \l+
root 20912 16390 0 21:08 pts/4 00:00:00 grep psql
root 29850 1 0 12:10 ? 00:00:00 sh -c psql -X -x -t -h /tmp/ -p
9898 -c "\l+" 2>&1
root 29851 29850 0 12:10 ? 00:00:00 psql -X -x -t -h /tmp/ -p 9898
-c \l+
root 32346 1 0 12:44 ? 00:00:00 sh -c psql -X -x -t -h /tmp/ -p
9898 -c "\l+" 2>&1
root 32347 32346 0 12:44 ? 00:00:00 psql -X -x -t -h /tmp/ -p 9898
-c \l+
-bash-4.1#

I tried pass on the parameter to skip the port 9898, looks like it is not
working .

I am not sure whether it is a bug or simply i am missing something. This has
become a critical as few of the scripts which is depended on 9898 is just
hanging over there.

Regards

Ramesh.