PostgreSQL unexpectedlly closes the connection
| От | João Miguel Ferreira |
|---|---|
| Тема | PostgreSQL unexpectedlly closes the connection |
| Дата | |
| Msg-id | 6BD455EEE2FDA24EA0AAC5E931302ECC075EE8@estgmail.estg.ipvc.pt обсуждение исходный текст |
| Ответы |
Re: PostgreSQL unexpectedlly closes the connection
Re: PostgreSQL unexpectedlly closes the connection |
| Список | pgsql-novice |
Hello all,
I'm developing a program (daemon) in Perl. This program colects system information and stores in Pg via perl-DBI and perl-DBD-Pg.
The performance is totally great... but once in a while I the server closes the connection when I try to do an Insert/Update/Delete...
The Perl-DBI error is +/- something like this "... server closed the connection unexpectedlly..."...
Strange enough the same query is executed thousands of times per hour an only ocasionally I get this error... my program detects the error and reconnects... but I'dd really like to get to the bottom of this...
I've already run my daemon with trace activated but I still can't get any additional info as to the reason of the problem...
What reasons make Pg close the connection ?
How do I begin debbuging this... ?
Thanks
jmf
В списке pgsql-novice по дате отправления: