[pgpool-general: 5407] Re: Log erros

[Tatsuo Ishii]

> Hello
> 
> We have an master-slave environment configured with an pgpool-II-3.6.2
> where our web application connects to it. Eventually, independent of the
> current load, we run off pgpool slots, causing our applications to become
> unresponsive.
> 
> After analysing the logs, among other errors,  we found this particular one
> "received serialization failure error message from master node." that we
> cannot understand why. Somebody already had been through this situation?
> What does it means?
> 
> log message:
> 2017-03-30 12:48:57: pid 208649: LOG:  SimpleQuery: received serialization
> failure error message from master node. query: SELECT ...

PostgreSQL returns an error with error code 40001. I suggest you check
the PoostgreSQL log to find out the cause.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp