Potential Bug: Frequent Unnecessary Degeneration

From: "David O'Mahony" <david(dot)c(dot)omahony(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Potential Bug: Frequent Unnecessary Degeneration
Date: 2017-02-15 23:30:11
Message-ID: CAD93rxpQoMFPjesGgC8qkswzpcgcdQy4ukTrJrL9=iFQATWz_Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Patrick B 2017-02-15 23:58:37 How to evaluate "explain analyze" correctly after "explain" for the same statement ?
Previous Message Shawn Thomas 2017-02-15 23:09:50 Re: Can't restart Postgres