pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Meaning of logs of postgresql
2+ messages / 2 participants
[nested] [flat]

* Meaning of logs of postgresql
@ 2008-02-28 12:45 Suresh Gupta VG <suresh.g@zensar.com>
  2008-02-28 15:40 ` Re: Meaning of logs of postgresql Andrew Sullivan <ajs@crankycanuck.ca>
  0 siblings, 1 reply; 2+ messages in thread

From: Suresh Gupta VG @ 2008-02-28 12:45 UTC (permalink / raw)
  To: pgsql-admin

Hi team,

 

I am in the testing of my application with the new database 8.2.5 on
solaris-9. I get the logs as below when ever any transactions come from
my application. What does it really mean?

 

WARNING:  there is no transaction in progress

LOG:  unexpected EOF on client connection

 

Regards,

G. V. Suresh Gupta

 



DISCLAIMER:
This email may contain confidential or privileged information for the intended recipient(s) and the views expressed in the same are not necessarily the views of Zensar Technologies Ltd. If you are not the intended recipient or have received this e-mail by error, its use is strictly prohibited, please delete the e-mail and notify the sender. Zensar Technologies Ltd. does not accept any liability for virus infected mails. 

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Meaning of logs of postgresql
  2008-02-28 12:45 Meaning of logs of postgresql Suresh Gupta VG <suresh.g@zensar.com>
@ 2008-02-28 15:40 ` Andrew Sullivan <ajs@crankycanuck.ca>
  0 siblings, 0 replies; 2+ messages in thread

From: Andrew Sullivan @ 2008-02-28 15:40 UTC (permalink / raw)
  To: pgsql-admin

On Thu, Feb 28, 2008 at 06:15:29PM +0530, Suresh Gupta VG wrote:
> WARNING:  there is no transaction in progress

This means you issued COMMIT when there was no BEGIN that started the
transaction.  I bet you're in autocommit mode and don't know it.
 
> LOG:  unexpected EOF on client connection

This means the client disappeared.  Are you disconnecting without closing
your connections?

A




^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2008-02-28 15:40 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-02-28 12:45 Meaning of logs of postgresql Suresh Gupta VG <suresh.g@zensar.com>
2008-02-28 15:40 ` Andrew Sullivan <ajs@crankycanuck.ca>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox