[pgpool-general: 3613] Re: Fwd: Strange error

[Tatsuo Ishii]

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