Обсуждение: Warning messages appearing twice

Поиск
Список
Период
Сортировка

Warning messages appearing twice

От
vignesh C
Дата:
Hi,

I have noticed in some cases the warning messages appear twice, one such instance is given below:
postgres=# begin;
BEGIN
postgres=# prepare transaction 't1';
PREPARE TRANSACTION
postgres=# rollback;
WARNING:  there is no transaction in progress
WARNING:  there is no transaction in progress
ROLLBACK

However if logging is enabled, the warning message appears only once.

I'm not sure if this is already known.
I'm not sure if this is widely used scenario or not.

Regards,
Vignesh
EnterpriseDB: http://www.enterprisedb.com

Re: Warning messages appearing twice

От
Dilip Kumar
Дата:
On Fri, Jul 26, 2019 at 11:04 AM vignesh C <vignesh21@gmail.com> wrote:
>
> Hi,
>
> I have noticed in some cases the warning messages appear twice, one such instance is given below:
> postgres=# begin;
> BEGIN
> postgres=# prepare transaction 't1';
> PREPARE TRANSACTION
> postgres=# rollback;
> WARNING:  there is no transaction in progress
> WARNING:  there is no transaction in progress
> ROLLBACK
>
> However if logging is enabled, the warning message appears only once.

Seems like you are seeing one message from the client and the other
one from the server log as you have not enabled the logging collector
the WARNING is printed on your console.

>
> I'm not sure if this is already known.
> I'm not sure if this is widely used scenario or not.


-- 
Regards,
Dilip Kumar
EnterpriseDB: http://www.enterprisedb.com

Re: Warning messages appearing twice

От
vignesh C
Дата:
On Fri, Jul 26, 2019 at 11:23 AM Dilip Kumar <dilipbalaut@gmail.com> wrote:
On Fri, Jul 26, 2019 at 11:04 AM vignesh C <vignesh21@gmail.com> wrote:
>
> Hi,
>
> I have noticed in some cases the warning messages appear twice, one such instance is given below:
> postgres=# begin;
> BEGIN
> postgres=# prepare transaction 't1';
> PREPARE TRANSACTION
> postgres=# rollback;
> WARNING:  there is no transaction in progress
> WARNING:  there is no transaction in progress
> ROLLBACK
>
> However if logging is enabled, the warning message appears only once.

Seems like you are seeing one message from the client and the other
one from the server log as you have not enabled the logging collector
the WARNING is printed on your console.

 
Thanks for the clarification Dilip.

Regards,
Vignesh