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. <[email protected]>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 <[email protected] > > <mailto:[email protected]>> 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 > > <[email protected] <mailto:[email protected]>> 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!!! > > >> > > > >> > > > >> > > > ======================================================================================= > > >> > [r...@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 > > [email protected] > > 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 > [email protected] > http://pgfoundry.org/mailman/listinfo/pgpool-general >
_______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
