[pgpool-general: 3342] Re: Frontend Terminated in log

[Tatsuo Ishii]

> 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?

This means a client is closing a database connection and
normal. Probably we should change this to DEBUG1 or something (before
3.4, we don't log this event).

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp