[Pgpool-general] Why pgpool II always refuses connections?

Tue Dec 21 09:35:37 UTC 2010

After failure of pgbench -C, does pgpool still accept connections from psql?
Or does it become unusable until restarting?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> No any error on message or pgpool log.
> Our platform is centos5.8
> Kernel is: 2.6.18-164.el5 #1 SMP Thu Sep 3 03:28:30 EDT 2009 x86_64 x86_64
> x86_64 GNU/Linux
> 
> On Tue, Dec 21, 2010 at 5:27 PM, Tatsuo Ishii <ishii at sraoss.co.jp> wrote:
> 
>> Is there any error message in pgpool log or /var/log/messages?
>> What is the platform are you running on?
>> --
>> Tatsuo Ishii
>> SRA OSS, Inc. Japan
>> English: http://www.sraoss.co.jp/index_en.php
>> Japanese: http://www.sraoss.co.jp
>>
>> > Hi all,
>> >
>> > We are testing pgpool II by pgbench, when we use below command to do the
>> > test, the pgpool runs ok.
>> > /opt/PostgreSQL/8.4/bin/pgbench -t 2000 -c 20 -h 172.17.3.10 -p 9999 -U
>> > postgres pgbench
>> >
>> > But if we add "-C" option, which means to establish new connection for
>> every
>> > transaction, the pgpool II will always refuse the connections after about
>> > 28230 successful connection.
>> > /opt/PostgreSQL/8.4/bin/pgbench -t 2000 -C -c 20 -h 172.17.3.10 -p 9999
>> -U
>> > postgres pgbench
>> >
>> > I tried many times, and the number of transactions actually processed is
>> > always at 28232 or so.
>> >
>> > Please see below the detail infomation, any pgpool arguments need to be
>> > adjusted to avoid this issue?
>> >
>> > Thanks very much for your help!!!
>> >
>> >
>> =======================================================================================
>> > [root at ucs09 shell]# /opt/PostgreSQL/8.4/bin/pgbench -C -t 2000 -c 20 -h
>> > 172.17.3.10 -p 9999 -U postgres pgbench
>> > starting vacuum...end.
>> > Connection to database "pgbench" failed:
>> > could not connect to server: Cannot assign requested address
>> >         Is the server running on host "172.17.3.10" and accepting
>> >         TCP/IP connections on port 9999?
>> > Client 12 aborted in establishing connection.
>> > Connection to database "pgbench" failed:
>> > could not connect to server: Cannot assign requested address
>> >         Is the server running on host "172.17.3.10" and accepting
>> >         TCP/IP connections on port 9999?
>> > Client 13 aborted in establishing connection.
>> > Connection to database "pgbench" failed:
>> > could not connect to server: Cannot assign requested address
>> >         Is the server running on host "172.17.3.10" and accepting
>> >         TCP/IP connections on port 9999?
>> > Client 3 aborted in establishing connection.
>> > Connection to database "pgbench" failed:
>> > could not connect to server: Cannot assign requested address
>> >         Is the server running on host "172.17.3.10" and accepting
>> >         TCP/IP connections on port 9999?
>> > Client 0 aborted in establishing connection.
>> > Connection to database "pgbench" failed:
>> > could not connect to server: Cannot assign requested address
>> >         Is the server running on host "172.17.3.10" and accepting
>> >         TCP/IP connections on port 9999?
>> > Client 16 aborted in establishing connection.
>> > Connection to database "pgbench" failed:
>> > could not connect to server: Cannot assign requested address
>> >         Is the server running on host "172.17.3.10" and accepting
>> >         TCP/IP connections on port 9999?
>> > Client 8 aborted in establishing connection.
>> > Connection to database "pgbench" failed:
>> > could not connect to server: Cannot assign requested address
>> >         Is the server running on host "172.17.3.10" and accepting
>> >         TCP/IP connections on port 9999?
>> > Client 4 aborted in establishing connection.
>> > Connection to database "pgbench" failed:
>> > could not connect to server: Cannot assign requested address
>> >         Is the server running on host "172.17.3.10" and accepting
>> >         TCP/IP connections on port 9999?
>> > Client 5 aborted in establishing connection.
>> > Connection to database "pgbench" failed:
>> > could not connect to server: Cannot assign requested address
>> >         Is the server running on host "172.17.3.10" and accepting
>> >         TCP/IP connections on port 9999?
>> > Client 1 aborted in establishing connection.
>> > Connection to database "pgbench" failed:
>> > could not connect to server: Cannot assign requested address
>> >         Is the server running on host "172.17.3.10" and accepting
>> >         TCP/IP connections on port 9999?
>> > Client 9 aborted in establishing connection.
>> > Connection to database "pgbench" failed:
>> > could not connect to server: Cannot assign requested address
>> >         Is the server running on host "172.17.3.10" and accepting
>> >         TCP/IP connections on port 9999?
>> > Client 10 aborted in establishing connection.
>> > Connection to database "pgbench" failed:
>> > could not connect to server: Cannot assign requested address
>> >         Is the server running on host "172.17.3.10" and accepting
>> >         TCP/IP connections on port 9999?
>> > Client 2 aborted in establishing connection.
>> > Connection to database "pgbench" failed:
>> > could not connect to server: Cannot assign requested address
>> >         Is the server running on host "172.17.3.10" and accepting
>> >         TCP/IP connections on port 9999?
>> > Client 6 aborted in establishing connection.
>> > Connection to database "pgbench" failed:
>> > could not connect to server: Cannot assign requested address
>> >         Is the server running on host "172.17.3.10" and accepting
>> >         TCP/IP connections on port 9999?
>> > Client 11 aborted in establishing connection.
>> > Connection to database "pgbench" failed:
>> > could not connect to server: Cannot assign requested address
>> >         Is the server running on host "172.17.3.10" and accepting
>> >         TCP/IP connections on port 9999?
>> > Client 15 aborted in establishing connection.
>> > Connection to database "pgbench" failed:
>> > could not connect to server: Cannot assign requested address
>> >         Is the server running on host "172.17.3.10" and accepting
>> >         TCP/IP connections on port 9999?
>> > Client 14 aborted in establishing connection.
>> > Connection to database "pgbench" failed:
>> > could not connect to server: Cannot assign requested address
>> >         Is the server running on host "172.17.3.10" and accepting
>> >         TCP/IP connections on port 9999?
>> > Client 7 aborted in establishing connection.
>> > Connection to database "pgbench" failed:
>> > could not connect to server: Cannot assign requested address
>> >         Is the server running on host "172.17.3.10" and accepting
>> >         TCP/IP connections on port 9999?
>> > Client 17 aborted in establishing connection.
>> > Connection to database "pgbench" failed:
>> > could not connect to server: Cannot assign requested address
>> >         Is the server running on host "172.17.3.10" and accepting
>> >         TCP/IP connections on port 9999?
>> > Client 18 aborted in establishing connection.
>> > Connection to database "pgbench" failed:
>> > could not connect to server: Cannot assign requested address
>> >         Is the server running on host "172.17.3.10" and accepting
>> >         TCP/IP connections on port 9999?
>> > Client 19 aborted in establishing connection.
>> > transaction type: TPC-B (sort of)
>> > scaling factor: 20
>> > query mode: simple
>> > number of clients: 20
>> > number of transactions per client: 2000
>> > number of transactions actually processed: 28232/40000
>> > tps = 841.807364 (including connections establishing)
>> > tps = 2069.595197 (excluding connections establishing)
>>