[pgpool-general: 2767] both pgpool servers are master and using the same virtual IP

[Attila Heidrich]

Dear guys!

Where to find the problem in the situation above?

No logs at all, for some reason pgpool stopped logging (usually it uses
syslog).

root at postgres-1:/etc/pgpool2# pool status
Node: 0
Host: postgres-1
Port: 5433
Weight: 0.500000
Status: Up, in pool (1)
Role: Master

Node: 1
Host: postgres-2
Port: 5433
Weight: 0.500000
Status: Up, in pool (1)
Role: Master

root at postgres-2:/etc/pgpool2# pool status
Node: 0
Host: postgres-2
Port: 5433
Weight: 0.500000
Status: Up, in pool and connected (2)
Role: Master

Node: 1
Host: postgres-1
Port: 5433
Weight: 0.500000
Status: Up, in pool and connected (2)
Role: Master

This isn't the first time, usually happens in a high load situation.

Attila
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20140415/d68b9944/attachment.html>