[pgpool-general: 5106] Re: About SELECT load balancing in master/slave mode

[David Sisk -X (dsisk - TEKSYSTEMS INC at Cisco)]

Interesting…I got the “kind mismatch” errors with load balancing turned ON, and they disappeared when it was turned OFF…so the opposite.

Developers, should we expect that any of these bugs around load balancing are fixed in the upcoming 3.6.0 release?

[banner2]



David Sisk
Engineer - Software
dsisk at cisco.com<mailto:dsisk at cisco.com>
Tel:

Cisco Systems, Inc.
7025-6 Kit Creek Road PO Box 14987
RESEARCH TRIANGLE PARK
27709-4987
United States
cisco.com


[http://www.cisco.com/assets/swa/img/thinkbeforeyouprint.gif]Think before you print.

This email may contain confidential and privileged material for the sole use of the intended recipient. Any review, use, distribution or disclosure by others is strictly prohibited. If you are not the intended recipient (or authorized to receive for the recipient), please contact the sender by reply email and delete all copies of this message.
Please click here<http://www.cisco.com/web/about/doing_business/legal/cri/index.html> for Company Registration Information.


From: pgpool-general-bounces at pgpool.net [mailto:pgpool-general-bounces at pgpool.net] On Behalf Of erdenebat at skysys.mn
Sent: Sunday, November 6, 2016 7:13 AM
To: pgpool-general at pgpool.net
Subject: [pgpool-general: 5103] Re: About SELECT load balancing in master/slave mode

I'm testing pgpool-II 3.5.4. While load balancing is turned off, pgpool-II gives a following error:

LOG: pool_read_kind: error message from 1 th kind backend:database "mydb" does not exist
ERROR: unable to read message kind
DETAIL: kind does not match between master(53) slot[1] (45)

backend1 is standby server. I don't understand why pgpool-II tries to read from standby while load balancing is off.

Regards,
Erdenebat


06.11.2016, 19:31, "erdenebat at skysys.mn<mailto:erdenebat at skysys.mn>" <erdenebat at skysys.mn<mailto:erdenebat at skysys.mn>>:
I turned off load balancing. But it seems that load balancing is still working.
On the standby, it gives an error 'database does not exist'.
I understand that pgpool-II does not access standby while load balancing is off.


02.11.2016, 17:57, "erdenebat at skysys.mn<mailto:erdenebat at skysys.mn>" <erdenebat at skysys.mn<mailto:erdenebat at skysys.mn>>:
Hello guys,

In pgpool-II FAQ<http://www.pgpool.net/mediawiki/index.php/FAQ#It_seems_my_pgpool-II_does_not_do_load_balancing._Why.3F>, it states that "SELECT will be load balanced even in a transaction if operated in the master/slave mode".
Is there any way to do it in reverse? Is there any configuration not to load balance SELECT statement if a transaction is in the master/slave mode?

Thanks in advance,
Erdenebat Oyungerel
,

_______________________________________________
pgpool-general mailing list
pgpool-general at pgpool.net<mailto:pgpool-general at pgpool.net>
http://www.pgpool.net/mailman/listinfo/pgpool-general
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20161107/b68fd08c/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 121724 bytes
Desc: image003.png
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20161107/b68fd08c/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image004.png
Type: image/png
Size: 1469 bytes
Desc: image004.png
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20161107/b68fd08c/attachment-0003.png>