Postgres Pro
Downloads
Home   >   mailing lists

Thread: Warning messages appearing twice

Warning messages appearing twice

From
vignesh C
Date:
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

From
Dilip Kumar
Date:
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

From
vignesh C
Date:
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