Re: [GENERAL] 7.3.2 closing connections, sometimes
[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 problem is not worth wasting too much time on, right now. 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 fail like this 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 run. -- Bruce Momjian| http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [GENERAL] 7.3.2 closing connections, sometimes
[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 fail like this The specific statement being what exactly? Bruce Momjian pgman@candle.pha.pa.us 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 about a crashed backend --- assuming that that's what's going on. Do the other active connections get forcibly closed when this happens? regards, tom lane ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [GENERAL] 7.3.2 closing connections, sometimes
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 run. I hadn't thought of the error that way. I do have query logging on, and if I run that query directly, it finds the data I'd expect. It's a small table, or really three of them, all small for the time being. select it.id, it.it_class_id, it.it_code_version_id, it.it_data_version, it.note, it_class.class, it_class.id, it_code_version.version, it_code_version.id, it_class.id, it_code_version.id from it join it_class on (it_class.id = it.it_class_id) join it_code_version on (it_code_version.id = it.it_code_version_id) where class = ? AND version = ? AND it_data_version ? -- ... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._. Felix Finch: scarecrow repairman rocket surgeon / [EMAIL PROTECTED] GPG = E987 4493 C860 246C 3B1E 6477 7838 76E9 182E 8151 ITAR license #4933 I've found a solution to Fermat's Last Theorem but I see I've run out of room o ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [GENERAL] 7.3.2 closing connections, sometimes
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 message server closed the connection unexpectedly. It will fail like this The specific statement being what exactly? select it.id, it.it_class_id, it.it_code_version_id, it.it_data_version, it.note, it_class.class, it_class.id, it_code_version.version, it_code_version.id, it_class.id, it_code_version.id from it join it_class on (it_class.id = it.it_class_id) join it_code_version on (it_code_version.id = it.it_code_version_id) where class = ? AND version = ? AND it_data_version ? Bruce Momjian pgman@candle.pha.pa.us 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 about a crashed backend --- assuming that that's what's going on. Do the other active connections get forcibly closed when this happens? Haven't had any others open, it's a dev system. But I'll try leaving a psql session open. Right now it's gotten itself into the mood of always working, so it might have to wait a while. Could a corrupt db cause these mood swings? And if so, would that persist even across dropdb / creatdb? -- ... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._. Felix Finch: scarecrow repairman rocket surgeon / [EMAIL PROTECTED] GPG = E987 4493 C860 246C 3B1E 6477 7838 76E9 182E 8151 ITAR license #4933 I've found a solution to Fermat's Last Theorem but I see I've run out of room o ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [GENERAL] 7.3.2 closing connections, sometimes
[EMAIL PROTECTED] wrote: Bruce Momjian pgman@candle.pha.pa.us 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 about a crashed backend --- assuming that that's what's going on. Do the other active connections get forcibly closed when this happens? Haven't had any others open, it's a dev system. But I'll try leaving a psql session open. Right now it's gotten itself into the mood of always working, so it might have to wait a while. 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 and disk diagnostics? -- Bruce Momjian| http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [GENERAL] 7.3.2 closing connections, sometimes
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 and disk diagnostics? I moved the disks to a new machine, same problem, which doesn't rule out disk problems. We were getting a second machine ready for testing this problem, but my boss has decided to upgrade to 8.0.3 tonight for himself, and probably very soon after for the rest of us, and the problem is in the work mood right now, so we will no doubt follow the general principle of changing many things at once to make tracking things down more fun :-) -- ... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._. Felix Finch: scarecrow repairman rocket surgeon / [EMAIL PROTECTED] GPG = E987 4493 C860 246C 3B1E 6477 7838 76E9 182E 8151 ITAR license #4933 I've found a solution to Fermat's Last Theorem but I see I've run out of room o ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
