From modperl-return-63382-apmail-perl-modperl-archive=perl.apache.org@perl.apache.org Thu Jun 13 15:07:16 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 14FD5C392 for ; Thu, 13 Jun 2013 15:07:16 +0000 (UTC) Received: (qmail 91339 invoked by uid 500); 13 Jun 2013 15:07:15 -0000 Delivered-To: apmail-perl-modperl-archive@perl.apache.org Received: (qmail 91187 invoked by uid 500); 13 Jun 2013 15:07:14 -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 91180 invoked by uid 99); 13 Jun 2013 15:07:14 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 13 Jun 2013 15:07:14 +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; Thu, 13 Jun 2013 15:07:10 +0000 Received: from tigger2.cbdadmin.com ([10.10.1.140]) by dmzpostal.cckh.com (8.12.8/8.12.8) with ESMTP id r5DF6k0l020660; Thu, 13 Jun 2013 11:06:46 -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 r5DF6lq3019283; Thu, 13 Jun 2013 11:06:47 -0400 Received: from cougar.cbdadmin.com ([::1]) by cougar.cbdadmin.com ([::1]) with mapi id 14.02.0247.003; Thu, 13 Jun 2013 11:06:47 -0400 From: Xinhuan Zheng To: Perrin Harkins CC: "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///MOgIABnIqAgAFj5gCAAF7lAP//3nWAAAot9YABD5DsAAAFBfgAAA8TswAALg7+AP//vcKA Date: Thu, 13 Jun 2013 15:06:46 +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.5.130515 x-originating-ip: [10.10.182.55] Content-Type: multipart/alternative; boundary="_000_CDDF57BF3F690xzhengchristianbookcom_" MIME-Version: 1.0 X-Virus-Checked: Checked by ClamAV on apache.org --_000_CDDF57BF3F690xzhengchristianbookcom_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Yes. It's the same way using it. There is database handle created in startu= p.pl. The startup.pl file is configured in block. The "connection lo= st contact" error only happens when either in "apachectl stop" or when a ch= ild process exits. - xinhuan From: Perrin Harkins > Date: Thursday, June 13, 2013 11:03 AM To: Xinhuan Zheng > Cc: "modperl@perl.apache.org" > Subject: Re: Apache::DBI "connection lost contact" error That's unfortunate. Are you using it the same way, with a DBI connection i= n a block? I haven't seen anyone else mention a problem with it in = Apache 1. - Perrin On Wed, Jun 12, 2013 at 5:05 PM, Xinhuan Zheng > wrote: Hi Perrin, Today I tested the Apache-DBI 1.12 with Apache 1.3.42 and mod_perl 1. We ha= ve to use mod_perl 1 in some situations. There is same issue when startup.p= l has created database handle. This database handle gets= cached and forked across child processes. With debugging turned on, there = isn't "skipping connection during server startup, read the docu !!" message= at all. It appears this new version only works with Apache2 but not Apache= 1. Is that possible to fix it with Apache1? Thanks, - xinhuan From: Perrin Harkins > Date: Wednesday, June 12, 2013 5:53 AM To: Fred Moyer > Cc: Xinhuan Zheng >, "modperl@perl.apache.org" > Subject: Re: Apache::DBI "connection lost contact" error Thanks Fred! On Wed, Jun 12, 2013 at 3:29 AM, Fred Moyer > wrote: Apache-DBI 1.12 was just pushed to CPAN with this update. Thanks for the great work on the fix Perrin. On Thu, Jun 6, 2013 at 2:53 PM, Perrin Harkins > wrote: > That's great! I'll commit the patch and see about getting a new release = out > to CPAN. > > - Perrin > > > On Thu, Jun 6, 2013 at 5:02 PM, Xinhuan Zheng > > wrote: >> >> Hi Perrin, >> >> I did a testing with debugging. I don't see the "connection lost contact= " >> error anymore. The patch looks good to me. >> >> Thanks, >> - xinhuan >> >> From: Perrin Harkins > >> Date: Thursday, June 6, 2013 3:02 PM >> To: Xinhuan Zheng > >> Cc: "modperl@perl.apache.org" > >> >> Subject: Re: Apache::DBI "connection lost contact" error >> >> On Thu, Jun 6, 2013 at 12:22 PM, Xinhuan Zheng > >> wrote: >> > The database handle that is created in startup.pl n= eeds to be really >> > disconnected (not overloaded disconnect) so that won't leave an idle s= erver >> > process running on the database side. Once it's really disconnected, t= he >> > server process can be cleaned up on the server side. >> >> Right, that's what the bug is preventing. >> >> Because my flight was delayed last night, I had time to make a patch. >> Please try this on your system and send the debug, like you did before. >> >> - Perrin >> > --_000_CDDF57BF3F690xzhengchristianbookcom_ Content-Type: text/html; charset="us-ascii" Content-ID: <2B6E6CC8C5F1724BAD956DD9AA97D631@cbd.com> Content-Transfer-Encoding: quoted-printable
Yes. It's the same way using it. There is database handle created in s= tartup.pl. The startup.pl file is configured in <Perl> block. The &qu= ot;connection lost contact" error only happens when either in "ap= achectl stop" or when a child process exits.

- xinhuan

From: Perrin Harkins <pharkins@gmail.com>
Date: Thursday, June 13, 2013 11:03= AM
To: Xinhuan Zheng <xzheng@christianbook.com>
Cc: "modperl@perl.apache.org" <modperl@perl.apache.org>
Subject: Re: Apache::DBI "conn= ection lost contact" error

That's unfortunate.  Are you using it the same way, w= ith a DBI connection in a <Perl> block?  I haven't seen anyone e= lse mention a problem with it in Apache 1.

- Perrin


On Wed, Jun 12, 2013 at 5:05 PM, Xinhuan Zheng <= span dir=3D"ltr"> <xzheng@ch= ristianbook.com> wrote:
Hi Perrin,

Today I tested the Apache-DBI 1.12 with Apache 1.3.42 and mod_perl 1. = We have to use mod_perl 1 in some situations. There is same issue when startup.pl has created = database handle. This database handle gets cached and forked across child p= rocesses. With debugging turned on, there isn't "skipping connection d= uring server startup, read the docu !!" message at all. It appears this new version only works with Apache2 but not Apache= 1. Is that possible to fix it with Apache1?

Thanks,
- xinhuan

From: Perrin Harkins <pharkins@gmail.com> Date: Wednesday, June 12, 2013 5:53= AM
To: Fred Moyer <fred@redhotpenguin.com><= br> Cc: Xinhuan Zheng <xzheng@christianbook.com>, "= modperl@perl.apache.org" <modperl@perl.apache.org>

Subject: Re: Apache::DBI "conn= ection lost contact" error

Thanks Fred!


On Wed, Jun 12, 2013 at 3:29 AM, Fred Moyer <fred@redhot= penguin.com> wrote:
Apache-DBI 1.12 was just pushed to CPAN with this update. Thanks for
the great work on the fix Perrin.

On Thu, Jun 6, 2013 at 2:53 PM, Perrin Harkins <pharkins@gmail.com> wrote:
> That's great!  I'll commit the patch and see about getting a new = release out
> to CPAN.
>
> - Perrin
>
>
> On Thu, Jun 6, 2013 at 5:02 PM, Xinhuan Zheng <xzheng@christianbook.com><= br> > wrote:
>>
>> Hi Perrin,
>>
>> I did a testing with debugging. I don't see the "connection l= ost contact"
>> error anymore. The patch looks good to me.
>>
>> Thanks,
>> - xinhuan
>>
>> From: Perrin Harkins <pharkins@gmail.com>
>> Date: Thursday, June 6, 2013 3:02 PM
>> To: Xinhuan Zheng <xzheng@christianbook.com>
>> Cc: "modperl@perl.apache.org" <modperl@perl.apache.org>
>>
>> Subject: Re: Apache::DBI "connection lost contact" error=
>>
>> On Thu, Jun 6, 2013 at 12:22 PM, Xinhuan Zheng <xzheng@christianbook.com= >
>> wrote:
>> > The database handle that is created in startup.pl needs to be really
>> > disconnected (not overloaded disconnect) so that won't leave = an idle server
>> > process running on the database side. Once it's really discon= nected, the
>> > server process can be cleaned up on the server side.
>>
>> Right, that's what the bug is preventing.
>>
>> Because my flight was delayed last night, I had time to make a pat= ch.
>> Please try this on your system and send the debug, like you did be= fore.
>>
>> - Perrin
>>
>


--_000_CDDF57BF3F690xzhengchristianbookcom_--