[pgpool-general: 435] Re: Load balacing isn't working (skipping slot because backend_status = 1)

[Tatsuo Ishii]

It seems you are running pgpool-II in raw mode. Can you show me pgpool.conf?
Also please let me know what version of pgpoolII you are running.
(pgpool --version)
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> Hi,
> firstly thanks for the amazing software.
> 
> I've configured a 4 servers balancing system and I'm going to test the 
> balancing but it's not working because the queries are executed only on 
> the first server.
> This is the log:
> 
> 2012-05-09 12:07:52 DEBUG: pid 16216: new_connection: connecting 0 backend
> 2012-05-09 12:07:52 DEBUG: pid 16216: new_connection: skipping slot 0 
> because backend_status = 3
> 2012-05-09 12:07:52 DEBUG: pid 16216: new_connection: connecting 1 backend
> 2012-05-09 12:07:52 DEBUG: pid 16216: new_connection: connecting 2 backend
> 2012-05-09 12:07:52 DEBUG: pid 16216: new_connection: skipping slot 2 
> because backend_status = 1
> 2012-05-09 12:07:52 DEBUG: pid 16216: new_connection: connecting 3 backend
> 2012-05-09 12:07:52 DEBUG: pid 16216: new_connection: skipping slot 3 
> because backend_status = 1
> 
> Somebody can offer an advice?
> 
> Thanks,
> 
> Alex
> 
> 
> 
> 
> 
> -- 
> Alessandro De Noia
> GIS Developer
> 
> e: alessandro at piemapping.com | w: www.piemapping.com
> Caledonia House, 223 - 231 Pentonville Road, London, N1 9NG
> 
> Please don't print this e-mail unless you really need to
> 
> PIE trading name of MPIE Limited, is a company registered in England and Wales with company number 6991293. Vat number: 983340996
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general