[GENERAL] How to troubleshoot "write on backend 0 failed" - Mailing list pgsql-general

From David O'Mahony
Subject [GENERAL] How to troubleshoot "write on backend 0 failed"
Date
Msg-id CAD93rxr-FDG8CxMw8msLA7wo1au8CrLsB_=g3KfJ1hJ7XD6CjQ@mail.gmail.com
Whole thread Raw
List pgsql-general

Hi All,

We are using pgpool 3.6.1 with two nodes in the cluster.  We are seeing frequent occurrences where one node will be marked as offline.

When this occurs we are seeing the following statements in our logs.

2017-02-09 09:45:38: pid 12125: WARNING:  write on backend 0 failed with error :"Success"
2017-02-09 09:45:38: pid 12125: DETAIL:  while trying to write data from offset: 0 wlen: 5 

How do we troubleshoot the issue?

From looking at the source, the message appears to be generated from pool_stream.c:pool_flush_it().  

Based on the fact that the strerr() returns "Success", did anything actually go wrong?  What if the write() function simply returned 0 bytes written?   That's not necessarily an error is it?

Thanks in advance for your help,

Dave 

pgsql-general by date:

Previous
From: Rakesh Kumar
Date:
Subject: Re: [GENERAL] clarification about standby promotion
Next
From: Joshua Chamberlain
Date:
Subject: [GENERAL] CREATE TABLE with parallel workers, 10.0?