Re: [GENERAL] 7.3.2 closing connections, sometimes

2005-07-06 Thread felix
On Wed, Jul 06, 2005 at 05:44:44PM -0400, Bruce Momjian wrote: > [EMAIL PROTECTED] wrote: > > > > Could a corrupt db cause these mood swings? And if so, would that > > persist even across dropdb / creatdb? > > Yes, that is possible, but usually it would fail consistently. Have you > run memtest

Re: [GENERAL] 7.3.2 closing connections, sometimes

2005-07-06 Thread Bruce Momjian
[EMAIL PROTECTED] wrote: > > Bruce Momjian writes: > > > This message is from the backend exiting abruptly. Is isn't an "ERROR" > > > as we define it for logging purposes. That's why there is nothing in > > > the logs. > > > > Nonetheless I'd expect there to be at least a postmaster complaint a

Re: [GENERAL] 7.3.2 closing connections, sometimes

2005-07-06 Thread felix
On Wed, Jul 06, 2005 at 03:10:40PM -0400, Tom Lane wrote: > > [EMAIL PROTECTED] wrote: > >> This is a SOAP server, Apache with mod_perl, connecting to Postgres > >> via DBI/DBD::Pg. Sometimes it gets in a mood, for want of a better > >> term, where a specific SQL statement fails with the good ole

Re: [GENERAL] 7.3.2 closing connections, sometimes

2005-07-06 Thread felix
On Wed, Jul 06, 2005 at 02:32:31PM -0400, Bruce Momjian wrote: > > This message is from the backend exiting abruptly. Is isn't an "ERROR" > as we define it for logging purposes. That's why there is nothing in > the logs. I recommend turning on log_statement which prints before the > query is ru

Re: [GENERAL] 7.3.2 closing connections, sometimes

2005-07-06 Thread Tom Lane
> [EMAIL PROTECTED] wrote: >> This is a SOAP server, Apache with mod_perl, connecting to Postgres >> via DBI/DBD::Pg. Sometimes it gets in a mood, for want of a better >> term, where a specific SQL statement fails with the good ole message >> "server closed the connection unexpectedly". It will f

Re: [GENERAL] 7.3.2 closing connections, sometimes

2005-07-06 Thread Bruce Momjian
[EMAIL PROTECTED] wrote: > I hate to post as vague a description as this, but I don't think the > devil is in the details this time. I may be wrong ... > > This project is running 7.3.2 on a RedHat 9 system. We plan to > upgrade in a few weeks to Fedora Core and Postgres 8, so maybe this > probl

[GENERAL] 7.3.2 closing connections, sometimes

2005-07-06 Thread felix
I hate to post as vague a description as this, but I don't think the devil is in the details this time. I may be wrong ... This project is running 7.3.2 on a RedHat 9 system. We plan to upgrade in a few weeks to Fedora Core and Postgres 8, so maybe this problem is not worth wasting too much time