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

Alessandro De Noia Alessandro at piemapping.com
Wed May 9 19:18:21 JST 2012


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


More information about the pgpool-general mailing list