<div dir="ltr">Thanks!</div><br><div class="gmail_quote"><div dir="ltr">On Fri, 31 Mar 2017 at 11:53 Tatsuo Ishii <<a href="mailto:ishii@sraoss.co.jp">ishii@sraoss.co.jp</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">> Hello<br class="gmail_msg">
><br class="gmail_msg">
> We have an master-slave environment configured with an pgpool-II-3.6.2<br class="gmail_msg">
> where our web application connects to it. Eventually, independent of the<br class="gmail_msg">
> current load, we run off pgpool slots, causing our applications to become<br class="gmail_msg">
> unresponsive.<br class="gmail_msg">
><br class="gmail_msg">
> After analysing the logs, among other errors, we found this particular one<br class="gmail_msg">
> "received serialization failure error message from master node." that we<br class="gmail_msg">
> cannot understand why. Somebody already had been through this situation?<br class="gmail_msg">
> What does it means?<br class="gmail_msg">
><br class="gmail_msg">
> log message:<br class="gmail_msg">
> 2017-03-30 12:48:57: pid 208649: LOG: SimpleQuery: received serialization<br class="gmail_msg">
> failure error message from master node. query: SELECT ...<br class="gmail_msg">
<br class="gmail_msg">
PostgreSQL returns an error with error code 40001. I suggest you check<br class="gmail_msg">
the PoostgreSQL log to find out the cause.<br class="gmail_msg">
<br class="gmail_msg">
Best regards,<br class="gmail_msg">
--<br class="gmail_msg">
Tatsuo Ishii<br class="gmail_msg">
SRA OSS, Inc. Japan<br class="gmail_msg">
English: <a href="http://www.sraoss.co.jp/index_en.php" rel="noreferrer" class="gmail_msg" target="_blank">http://www.sraoss.co.jp/index_en.php</a><br class="gmail_msg">
Japanese:<a href="http://www.sraoss.co.jp" rel="noreferrer" class="gmail_msg" target="_blank">http://www.sraoss.co.jp</a><br class="gmail_msg">
</blockquote></div>