<div dir="ltr"><div class="gmail_default" style="font-family:verdana,sans-serif"><span style="font-size:12.8000001907349px;font-family:arial,sans-serif">Hi there,</span><br></div><div class="gmail_quote"><div dir="ltr"><div><span style="font-size:12.8000001907349px">I configured a pgpool with three node in Load Balance + Connection Pooling + Master Salve modes, so I have node 0 as master and node 1 and 2 as slaves.</span></div><div><span style="font-size:12.8000001907349px"><br></span></div><div><span style="font-size:12.8000001907349px">I had a problem with both slaves (no disk space left on servers) and pgpool stopped to accept connections with this error:</span></div><div><span style="font-size:12.8000001907349px"><br></span></div><div><div style="font-size:12.8000001907349px">psql -p 9999 -h /tmp</div><div style="font-size:12.8000001907349px">Password: </div><div style="font-size:12.8000001907349px">psql: ERROR: unable to read message kind</div><div style="font-size:12.8000001907349px">DETAIL: kind does not match between master(53) slot[1] (4e)</div><div style="font-size:12.8000001907349px"><br></div><div style="font-size:12.8000001907349px"><br></div><div style="font-size:12.8000001907349px"><br></div><div style="font-size:12.8000001907349px">However, slaves was continuing to accept connections, but was returning some worning:</div><div style="font-size:12.8000001907349px"><br></div><div><div><span style="font-size:12.8000001907349px">psql -p 5997 -h 10.0.0.3</span></div><div><span style="font-size:12.8000001907349px">Password: </span></div><div><span style="font-size:12.8000001907349px">WARNING: could not create relation-cache initialization file "global/pg_internal.init.19889": No space left on device</span></div><div><span style="font-size:12.8000001907349px">DETAIL: Continuing anyway, but there's something wrong.</span></div><div><span style="font-size:12.8000001907349px">WARNING: could not create relation-cache initialization file "base/12150/pg_internal.init.19889": No space left on device</span></div><div><span style="font-size:12.8000001907349px">DETAIL: Continuing anyway, but there's something wrong.</span></div><div><span style="font-size:12.8000001907349px">psql (9.4.4)</span></div><div><span style="font-size:12.8000001907349px">Type "help" for help.</span></div><div><span style="font-size:12.8000001907349px"><br></span></div><div><span style="font-size:12.8000001907349px">postgres=# </span></div><div><span style="font-size:12.8000001907349px"><br></span></div><div><span style="font-size:12.8000001907349px"><br></span></div><div><span style="font-size:12.8000001907349px"><br></span></div><div><span style="font-size:12.8000001907349px"><br></span></div><div><span style="font-size:12.8000001907349px">In this situation I was expected pgpool can detach both slave nodes and can continue to work with only master node, instead described situation has occurred.</span></div><div><br></div><div><span style="font-size:12.8000001907349px">Now the question is: can pgpool detach automatically slave nodes that go in a wrong state? Or </span><span style="font-size:12.8000001907349px">is use of pcp_detach command</span><span style="font-size:12.8000001907349px"> the only way to obtain my desiderata?</span></div><div><span style="font-size:12.8000001907349px"><br></span></div><div><span style="font-size:12.8000001907349px"><br></span></div><div><span style="font-size:12.8000001907349px">Thanks in advance.</span></div><div><span style="font-size:12.8000001907349px"><br></span></div><div><span style="font-size:12.8000001907349px">Mephysto</span></div></div></div></div>
</div><br></div>