[Pgpool-general] Why pgpool II always refuses connections?
Edmundo Robles L.
erobles at sensacd.com.mx
Tue Dec 21 14:27:39 UTC 2010
how many process by user are setting in your system???
maybe this could help you, before i have a limit of 100 process on SCO,
because the MAXUP variable have that value. So i can have near of 90
connection trough pgpool.
On 12/21/2010 03:53 AM, Zhidong She wrote:
> pgpool can accept new connection from psql, and can finish pgbench
> test without "-C" option.
> I also can run "-C" again without restart pgpool, but it always
> refused new connection after 28232 tries.
>
> Just now I setup a new pgpool platform in our lab, we got same failure
> with pgbench -C.
> Thanks very much for your care.
>
> On Tue, Dec 21, 2010 at 5:35 PM, Tatsuo Ishii <ishii at sraoss.co.jp
> <mailto:ishii at sraoss.co.jp>> wrote:
>
> 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 <mailto: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)
> >>
>
>
>
> _______________________________________________
> Pgpool-general mailing list
> Pgpool-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgpool-general
El contenido de este correo electrónico y sus archivos adjuntos son privados y confidenciales y va dirigido exclusivamente a su destinatario. No se autoriza la utilización, retransmisión, diseminación, o cualquier otro uso de esta información por un receptor o entidades distintas al destinatario. Si recibe este correo sin ser el destinatario se le solicita eliminarlo y hacerlo del conocimiento del emisor. La empresa no se hace responsable de transmisiones o comunicaciones no autorizadas o emitidas por personas ajenas a sus colaboradores utilizando éste medio electrónico.
The content of this email and its attached files are private and confidential and intended exclusively for the use of the individual or entity to which they are addressed. The retransmission, dissemination, or any other use of this information other than by the intended recipient is prohibited. If you have received this email in error please delete it and notify the sender. The company cannot be held liable for unauthorized electronic transmissions or communications, nor for those emitted by non-company individuals and entities.
More information about the Pgpool-general
mailing list