[pgpool-general: 3613] Re: Fwd: Strange error
Tatsuo Ishii
ishii at postgresql.org
Fri Apr 10 07:45:22 JST 2015
That indicates that pgpool-II fails to get result from
pg_last_xlog_replay_location() on node 2. Usual cause of the problem
is that node 2 is not a standby while pgpool-II believes the node is a
standby. You accidentaly promoted node 2 to primary?
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
> Hi there,
> I have two pgpool instance working together with watchdog and everything
> seems to work with no problems.
>
> But in log file of one of the instance I found an error that occur
> continuously:
>
>
> 2015-04-09 22:48:42: pid 5330: ERROR: Failed to check replication time lag
> 2015-04-09 22:48:42: pid 5330: DETAIL: Query to node (2) returned no data
> 2015-04-09 22:48:42: pid 5330: CONTEXT: while checking replication time lag
>
>
>
>
>>From what this message can depend?
>
> Thanks in advance.
>
> Cheers.
>
> Mephysto
More information about the pgpool-general
mailing list