From modperl-return-63375-apmail-perl-modperl-archive=perl.apache.org@perl.apache.org Thu Jun 6 21:02:43 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 E938D10CA4 for ; Thu, 6 Jun 2013 21:02:43 +0000 (UTC) Received: (qmail 42398 invoked by uid 500); 6 Jun 2013 21:02:43 -0000 Delivered-To: apmail-perl-modperl-archive@perl.apache.org Received: (qmail 42374 invoked by uid 500); 6 Jun 2013 21:02:43 -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 42367 invoked by uid 99); 6 Jun 2013 21:02:43 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 06 Jun 2013 21:02:43 +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 (nike.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, 06 Jun 2013 21:02:37 +0000 Received: from tigger2.cbdadmin.com ([10.10.1.140]) by dmzpostal.cckh.com (8.12.8/8.12.8) with ESMTP id r56L2CEh023817; Thu, 6 Jun 2013 17:02:13 -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 r56L2FLj030871; Thu, 6 Jun 2013 17:02:15 -0400 Received: from cougar.cbdadmin.com ([::1]) by cougar.cbdadmin.com ([::1]) with mapi id 14.02.0247.003; Thu, 6 Jun 2013 17:02:14 -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//3nWA Date: Thu, 6 Jun 2013 21:02:13 +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_CDD670BF3E690xzhengchristianbookcom_" MIME-Version: 1.0 X-Virus-Checked: Checked by ClamAV on apache.org --_000_CDD670BF3E690xzhengchristianbookcom_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi Perrin, I did a testing with debugging. I don't see the "connection lost contact" e= rror 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 need= s 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 disconnected, 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 patch. Plea= se try this on your system and send the debug, like you did before. - Perrin --_000_CDD670BF3E690xzhengchristianbookcom_ Content-Type: text/html; charset="us-ascii" Content-ID: Content-Transfer-Encoding: quoted-printable
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 <pharkins@gmail.com>
Date: Thursday, June 6, 2013 3:02 P= M
To: Xinhuan Zheng <xzheng@christianbook.com>
Cc: "modperl@perl.apache.org" <modperl@perl.apache.org>
Subject: Re: Apache::DBI "conn= ection 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 s= tartup.pl needs to be really disconnected (not overloaded disconnect) s= o that won't leave an idle server
> process running on the database side. Once it's really disconnect= ed, 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 mak= e a patch.  Please try this on your system and send the debug, like yo= u did before.

- Perrin

--_000_CDD670BF3E690xzhengchristianbookcom_--