[Pgpool-general] Why pgpool II always refuses connections?
Zhidong She
zhidong.she at gmail.com
Wed Dec 22 01:57:25 UTC 2010
Hi, thanks for you reply.
How to view the SCO and MAXUP value in my host? and how to change it?
On Tue, Dec 21, 2010 at 10:27 PM, Edmundo Robles L.
<erobles at sensacd.com.mx>wrote:
> 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.
> _______________________________________________
> Pgpool-general mailing list
> Pgpool-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgpool-general
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20101222/e602bfa1/attachment-0001.html>
More information about the Pgpool-general
mailing list