Обсуждение: [GENERAL] Potential Bug: Frequent Unnecessary Degeneration

Поиск

Список

Период

Сортировка

[GENERAL] Potential Bug: Frequent Unnecessary Degeneration

От

"David O'Mahony"

Дата:

16 февраля 2017 г., 02:30:11

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

Re: [GENERAL] Potential Bug: Frequent Unnecessary Degeneration

От

Andres Freund

Дата:

16 февраля 2017 г., 03:15:11

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

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

Обсуждение: [GENERAL] Potential Bug: Frequent Unnecessary Degeneration

[GENERAL] Potential Bug: Frequent Unnecessary Degeneration

Re: [GENERAL] Potential Bug: Frequent Unnecessary Degeneration