Обсуждение: Meaning of logs of postgresql

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

Meaning of logs of postgresql

От
"Suresh Gupta VG"
Дата:

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.

Re: Meaning of logs of postgresql

От
Andrew Sullivan
Дата:
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