[GENERAL] Potential Bug: Frequent Unnecessary Degeneration - Mailing list pgsql-general

From David O'Mahony
Subject [GENERAL] Potential Bug: Frequent Unnecessary Degeneration
Date
Msg-id CAD93rxpQoMFPjesGgC8qkswzpcgcdQy4ukTrJrL9=iFQATWz_Q@mail.gmail.com
Whole thread Raw
Responses Re: [GENERAL] Potential Bug: Frequent Unnecessary Degeneration  (Andres Freund <andres@anarazel.de>)
List pgsql-general
Hi All,

We're running two nodes using with replication enabled. 

pgpool routinely (every day) performs a failover with the following statements appearing the in log:

2017-02-15 13:16:01: pid 16190: WARNING:  write on backend 1 failed with error :"Success"
2017-02-15 13:16:01: pid 16190: DETAIL:  while trying to write data from offset: 0 wlen: 5

The source code (pool_stream.c:pool_flush_it()) seems to consider a write of 0 bytes an error.  Also the "Success" in the log statement indicates that errno was not set.  

There never appears to be any actual problem with the node.

Should pgpool trigger a failover in this situation?

Thanks,

Dave

pgsql-general by date:

Previous
From: Shawn Thomas
Date:
Subject: Re: [GENERAL] Can't restart Postgres
Next
From: Patrick B
Date:
Subject: [GENERAL] How to evaluate "explain analyze" correctly after "explain" for thesame statement ?