[pgpool-general: 3341] Frontend Terminated in log

[Rutger Wessels]

Hi,

I’m running two PostgreSQL 9.2 in master-slave. Replication is handled by Postgres. 

I’m using PgPool 3.4.0 as a load balancer, on a dedicated VM. 

pgpool.conf is at http://pastebin.com/vYR4nYTk <http://pastebin.com/vYR4nYTk>

However, once in a while, I see load spikes on that server. 

In the log (in my case /var/log/syslog), I see a lot of messages like these:
Dec  3 06:38:30 dblb01 pgpool[27216]: [6-1] 2014-12-03 06:38:30: pid 27216: LOG:  Frontend terminated
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

These messages are apparently caused by clients that send a ‘X’ message:

src/protocol/pool_proto_modules.c:
                case 'X':       /* Terminate */
                        if(contents)
                                pfree(contents);
            ereport(LOG,
                (errmsg("Frontend terminated"),
                     errdetail("received message kind 'X' from frontend")));
            return POOL_END;

I am not sure what this message means. Is this a client closing a database connection or does it indicate some client misbehaviour?

Best regards
Rutger Wessels

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