[pgpool-general: 5411] Re: Log erros

[Yuri Leme]

Thanks!

On Fri, 31 Mar 2017 at 11:53 Tatsuo Ishii <ishii at sraoss.co.jp> wrote:

> > 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20170331/47d2a11a/attachment-0001.html>