From modperl-return-63370-apmail-perl-modperl-archive=perl.apache.org@perl.apache.org Tue Jun 4 19:32:52 2013 Return-Path: X-Original-To: apmail-perl-modperl-archive@www.apache.org Delivered-To: apmail-perl-modperl-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id DE140102AF for ; Tue, 4 Jun 2013 19:32:52 +0000 (UTC) Received: (qmail 65532 invoked by uid 500); 4 Jun 2013 19:32:51 -0000 Delivered-To: apmail-perl-modperl-archive@perl.apache.org Received: (qmail 65494 invoked by uid 500); 4 Jun 2013 19:32:51 -0000 Mailing-List: contact modperl-help@perl.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Delivered-To: mailing list modperl@perl.apache.org Received: (qmail 65487 invoked by uid 99); 4 Jun 2013 19:32:51 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 04 Jun 2013 19:32:51 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of xzheng@christianbook.com designates 208.68.76.78 as permitted sender) Received: from [208.68.76.78] (HELO dmzpostal.cckh.com) (208.68.76.78) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 04 Jun 2013 19:32:47 +0000 Received: from tigger2.cbdadmin.com ([10.10.1.140]) by dmzpostal.cckh.com (8.12.8/8.12.8) with ESMTP id r54JWHEh002193; Tue, 4 Jun 2013 15:32:17 -0400 Received: from cougar.cbdadmin.com (SAPPHIRE.cbdadmin.com [10.10.1.210] (may be forged)) by tigger2.cbdadmin.com (8.13.8/8.13.8) with ESMTP id r54JWJpw010400; Tue, 4 Jun 2013 15:32:19 -0400 Received: from cougar.cbdadmin.com ([::1]) by cougar.cbdadmin.com ([::1]) with mapi id 14.02.0247.003; Tue, 4 Jun 2013 15:32:19 -0400 From: Xinhuan Zheng To: Perrin Harkins CC: Jim Schueler , "modperl@perl.apache.org" Subject: Re: Apache::DBI "connection lost contact" error Thread-Topic: Apache::DBI "connection lost contact" error Thread-Index: AQHOXKIh3fPzO3Xb8Uq1FtDcASri05kc5b4AgAEHJQCAAHmXgIABDDaAgAAVWYD//7/bAIAAWXsAgAAF/oCAAGH5AIABLg4AgALhmwCAAK9dgIAA5qeAgABZGoD///MOgA== Date: Tue, 4 Jun 2013 19:32:18 +0000 Message-ID: In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: user-agent: Microsoft-MacOutlook/14.3.4.130416 x-originating-ip: [10.10.182.55] Content-Type: multipart/alternative; boundary="_000_CDD3B7BC3E00Exzhengchristianbookcom_" MIME-Version: 1.0 X-Virus-Checked: Checked by ClamAV on apache.org --_000_CDD3B7BC3E00Exzhengchristianbookcom_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi Perrin, I have seen in other web servers when apachectl starts, there is no "connec= t lost contact" error but it did happen when apachectl stops. If child proc= ess uses ping the inherited database handle and it is ping-able, then the c= hild process may use it. That'll be a problem. When child process exits, it calls rollback if AutoCommit is off, but when = another new child process is just born and uses its connection to send data= base updates, will that rollback interfere with new child process attempt t= o update database? Is the rollback necessary? Thanks, - xinhuan From: Perrin Harkins > Date: Tuesday, June 4, 2013 12:18 PM To: Xinhuan Zheng > Cc: Jim Schueler >,= "modperl@perl.apache.org" > Subject: Re: Apache::DBI "connection lost contact" error On Tue, Jun 4, 2013 at 9:59 AM, Xinhuan Zheng > wrote: > Will the new connection that's created be cached after then and the conne= ction that's not ping-able will be discarded? Yes. > Will this cached the new connection last until the child process exit? Yes, unless it times out on the Oracle side due to inactivity. > Will rollback be called when child process discovers the connection handl= e not ping-able? No, the connection is already closed at that point. > Will rollback be called when child process exit? Yes. Also, I think I see how to fix this, so when I have a few minutes I'll send= you a patch to try. - Perrin --_000_CDD3B7BC3E00Exzhengchristianbookcom_ Content-Type: text/html; charset="us-ascii" Content-ID: Content-Transfer-Encoding: quoted-printable
Hi Perrin,

I have seen in other web servers when apachectl starts, there is no &q= uot;connect lost contact" error but it did happen when apachectl stops= . If child process uses ping the inherited database handle and it is ping-a= ble, then the child process may use it. That'll be a problem.

When child process exits, it calls rollback if AutoCommit is off, but = when another new child process is just born and uses its connection to send= database updates, will that rollback interfere with new child process atte= mpt to update database? Is the rollback necessary?

Thanks,
- xinhuan

From: Perrin Harkins <pharkins@gmail.com>
Date: Tuesday, June 4, 2013 12:18 P= M
To: Xinhuan Zheng <xzheng@christianbook.com>
Cc: Jim Schueler <jschueler@eloquency.com>, "modperl@perl.apache.org" <<= a href=3D"mailto:modperl@perl.apache.org">modperl@perl.apache.org> Subject: Re: Apache::DBI "conn= ection lost contact" error

On Tue, Jun 4, 2013 at 9:59 AM, Xinhuan Zheng <xzheng@christianbook.com> wrote= :
> Will the new connection that's created be cached after then and the co= nnection that's not ping-able will be discarded?

Yes.

> Will this cached the new connection last until the child process = exit?

Yes, unless it times out on the Oracle side due to inactivity.

> Will rollback be called when child process discovers the connection ha= ndle not ping-able?

No, the connection is already closed at that point.

> Will rollback be called when child process exit?

Yes.

Also, I think I see how to fix this, so when I have a few minutes I'll send= you a patch to try.

- Perrin

--_000_CDD3B7BC3E00Exzhengchristianbookcom_--