[pgpool-hackers: 2810] Re: client_min_messages

[Muhammad Usama]

Hi Ishii-San


On Thu, May 24, 2018 at 11:37 AM, Tatsuo Ishii <ishii at sraoss.co.jp> wrote:

> It seems there's something wrong here:
>
> static void
> send_message_to_frontend(ErrorData *edata)
>         /*
>          * Leave if we are failing on sending the message to frontend.
>          */
>         if (++frontend_error_recursion_depth > 2)
>                 return;
>
> (gdb) p frontend_error_recursion_depth
> $11 = 97
>

Your observation is correct, apparently frontend_error_recursion_depth
check is not properly installed and it seems to be
swallowing the messages to frontend after sending the second message.

I will take a look into this issue.

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 Usama,
> >
> > I have question regarding client_min_messages behavior. If my
> > understanding is correct, following command will send all messages
> > (including debug messages) to frontend.
> >
> > pgpool set clint_min_messages to debug5;
> >
> > In reality, only some of debug messages are sent to frontend. Even
> > higher level logs (for example LOG messages) are lost. The rule for
> > choosing these messages among other messages seems to be random. This
> > is very different from the behavior of PostgreSQL. Any idea?
> >
> > test=# pgpool set client_min_messages to debug5;
> > SET
> > test=# select 1;
> > DEBUG:  pool_write: to frontend: kind:N po:0
> > DEBUG:  pool_virtual_master_db_node_id: virtual_master_node_id:1
> load_balance_node_id:1 PRIMARY_NODE_ID:0
> >  ?column?
> > ----------
> >         1
> > (1 row)
> >
> > Best regards,
> > --
> > Tatsuo Ishii
> > SRA OSS, Inc. Japan
> > English: http://www.sraoss.co.jp/index_en.php
> > Japanese:http://www.sraoss.co.jp
> > _______________________________________________
> > pgpool-hackers mailing list
> > pgpool-hackers at pgpool.net
> > http://www.pgpool.net/mailman/listinfo/pgpool-hackers
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-hackers/attachments/20180524/92593371/attachment.html>