[pgpool-general: 395] Re: kind mismatch among backends with load balance off

Aleksej Trofimov aleksej.trofimov at ruptela.lt
Fri Apr 27 15:17:09 JST 2012


On 04/26/2012 06:31 PM, Tatsuo Ishii wrote:
> 石井です。
>
>
>
>
> Probably replication delay?
Exactly, but as I understood, this could be work-arounded using:
delay_threshold and sr_check_period ?
>> Also how
>> could be "kind mismatch error" when load balance is off?
> You use "multi statement query". Pgpool-I does not support it as
> stated in docs. Pgpool thinks that whole query is SET, and sends it to
> primary and standby.
Ok, thank you, now this error is much clearer!
>> What could be the problem? Maybe postgres configuration issue? Or
>> something else? What additiona information could I provide to solve
>> this problem?
> The solution would be not to use multi statement queries.
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese: http://www.sraoss.co.jp


-- 
Best regards

Aleksej Trofimov

UAB "Ruptela"

Phone: +370 657 80475

E-Mail: aleksej.trofimov at ruptela.lt
Web:    http://www.ruptela.lt

Ruptela - the most successful IT company in Lithuania 2011
Ruptela - sekmingiausia Lietuvos aukštųjų technologijų įmonė 2011
http://www.prezidentas.lt/lt/spaudos_centras_392/pranesimai_spaudai/inovatyvus_verslas_-_konkurencingos_lietuvos_pagrindas.html
http://www.ruptela.lt/news/37/121/Ruptela-sekmingiausia-jauna-aukstuju-technologiju-imone-Lietuvoje



More information about the pgpool-general mailing list