Potential Bug: Frequent Unnecessary Degeneration

Started by David O'Mahonyabout 9 years ago2 messagesgeneral
Jump to latest
#1David O'Mahony
david.c.omahony@gmail.com

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

#2Andres Freund
andres@anarazel.de
In reply to: David O'Mahony (#1)
Re: Potential Bug: Frequent Unnecessary Degeneration

Hi,

On 2017-02-15 20:00:11 -0330, David O'Mahony wrote:

We're running two nodes using with replication enabled.

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

This list is about bugs in postgresql.org maintained projects, pgpool
isn't one of those. Check http://www.pgpool.net/mediawiki/index.php/Main_Page#Contacts

- Andres

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general