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

Muhammad Usama m.usama at gmail.com
Thu Dec 4 21:32:30 JST 2014


On Thu, Dec 4, 2014 at 2:33 PM, Tatsuo Ishii <ishii at postgresql.org> wrote:
> 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.

Totally agree with you and have committed the change to master and 3.4
branch

http://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=12bf2f7231fee8c98d40e3a9c6c68cf1fbe54f59

Thanks
Best regards,
Muhammad Usama

>
> 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
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20141204/518708a4/attachment.html>


More information about the pgpool-general mailing list