[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