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

[Tatsuo Ishii]

Hi Usama,

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

Is there any reason for logging normal client disconnection being logged as "LOG"?
I feel this is a little bit annoying because:

1) before 3.4, the event was not logged (at least as LOG)

2) it occurs too often

I think it would better to change the log level to DEBUG1 or something.

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

>> 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
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general