<html><head><meta http-equiv="Content-Type" content="text/html charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">Hi,<div class=""><br class=""></div><div class="">I’m running two PostgreSQL 9.2 in master-slave. Replication is handled by Postgres. </div><div class=""><br class=""></div><div class="">I’m using PgPool 3.4.0 as a load balancer, on a dedicated VM. </div><div class=""><div class=""><br class=""></div><div class="">pgpool.conf is at <a href="http://pastebin.com/vYR4nYTk" class="">http://pastebin.com/vYR4nYTk</a></div><div class=""><br class=""></div></div><div class="">However, once in a while, I see load spikes on that server. </div><div class=""><br class=""></div><div class="">In the log (in my case /var/log/syslog), I see a lot of messages like these:</div><div class=""><div class="">Dec 3 06:38:30 dblb01 pgpool[27216]: [6-1] 2014-12-03 06:38:30: pid 27216: LOG: Frontend terminated</div><div class="">Dec 3 06:38:30 dblb01 pgpool[27216]: [6-2] 2014-12-03 06:38:30: pid 27216: DETAIL: received message kind 'X' from frontend</div></div><div class=""><br class=""></div><div class="">These messages are apparently caused by clients that send a ‘X’ message:</div><div class=""><br class=""></div><div class="">src/protocol/pool_proto_modules.c:</div><div class=""> case 'X': /* Terminate */</div><div class=""><div class=""> if(contents)</div><div class=""> pfree(contents);</div><div class=""> ereport(LOG,</div><div class=""> (errmsg("Frontend terminated"),</div><div class=""> errdetail("received message kind 'X' from frontend")));</div><div class=""> return POOL_END;</div></div><div class=""><br class=""></div><div class="">I am not sure what this message means. Is this a client closing a database connection or does it indicate some client misbehaviour?</div><div class=""><br class=""></div><div class="">Best regards</div><div class="">Rutger Wessels</div><div class=""><br class=""></div></body></html>