[prev in list] [next in list] [prev in thread] [next in thread]
List: apache-modperl
Subject: Re: Apache::DBI "connection lost contact" error
From: Xinhuan Zheng <xzheng () christianbook ! com>
Date: 2013-06-13 15:06:46
Message-ID: CDDF57BF.3F690%xzheng () christianbook ! com
[Download RAW message or body]
Yes. It's the same way using it. There is database handle created in startu=
p.pl. The startup.pl file is configured in <Perl> 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 <pharkins@gmail.com<mailto:pharkins@gmail.com>>
Date: Thursday, June 13, 2013 11:03 AM
To: Xinhuan Zheng <xzheng@christianbook.com<mailto:xzheng@christianbook.com=
>>
Cc: "modperl@perl.apache.org<mailto:modperl@perl.apache.org>" <modperl@perl=
.apache.org<mailto: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 <Perl> 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 <xzheng@christianbook.com<ma=
ilto:xzheng@christianbook.com>> 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<http://startup.pl> 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 <pharkins@gmail.com<mailto:pharkins@gmail.com>>
Date: Wednesday, June 12, 2013 5:53 AM
To: Fred Moyer <fred@redhotpenguin.com<mailto:fred@redhotpenguin.com>>
Cc: Xinhuan Zheng <xzheng@christianbook.com<mailto:xzheng@christianbook.com=
>>, "modperl@perl.apache.org<mailto:modperl@perl.apache.org>" <modperl@perl=
.apache.org<mailto: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 <fred@redhotpenguin.com<mailto:=
fred@redhotpenguin.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<mailto:p=
harkins@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<m=
ailto:xzheng@christianbook.com>>
> 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 <pharkins@gmail.com<mailto:pharkins@gmail.com>>
>> Date: Thursday, June 6, 2013 3:02 PM
>> To: Xinhuan Zheng <xzheng@christianbook.com<mailto:xzheng@christianbook.=
com>>
>> Cc: "modperl@perl.apache.org<mailto:modperl@perl.apache.org>" <modperl@p=
erl.apache.org<mailto: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=
<mailto:xzheng@christianbook.com>>
>> wrote:
>> > The database handle that is created in startup.pl<http://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
>>
>
[Attachment #3 (text/html)]
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: \
after-white-space; color: rgb(0, 0, 0); font-size: 14px; font-family: Consolas, \
sans-serif; "> <div>Yes. It's the same way using it. There is database handle created \
in startup.pl. The startup.pl file is configured in <Perl> block. The \
"connection lost contact" error only happens when either in "apachectl \
stop" or when a child process exits.</div> <div><br>
</div>
<div>- xinhuan</div>
<div><br>
</div>
<span id="OLK_SRC_BODY_SECTION">
<div style="font-family:Calibri; font-size:11pt; text-align:left; color:black; \
BORDER-BOTTOM: medium none; BORDER-LEFT: medium none; PADDING-BOTTOM: 0in; \
PADDING-LEFT: 0in; PADDING-RIGHT: 0in; BORDER-TOP: #b5c4df 1pt solid; BORDER-RIGHT: \
medium none; PADDING-TOP: 3pt"> <span style="font-weight:bold">From: </span>Perrin \
Harkins <<a href="mailto:pharkins@gmail.com">pharkins@gmail.com</a>><br> <span \
style="font-weight:bold">Date: </span>Thursday, June 13, 2013 11:03 AM<br> <span \
style="font-weight:bold">To: </span>Xinhuan Zheng <<a \
href="mailto:xzheng@christianbook.com">xzheng@christianbook.com</a>><br> <span \
style="font-weight:bold">Cc: </span>"<a \
href="mailto:modperl@perl.apache.org">modperl@perl.apache.org</a>" <<a \
href="mailto:modperl@perl.apache.org">modperl@perl.apache.org</a>><br> <span \
style="font-weight:bold">Subject: </span>Re: Apache::DBI "connection lost \
contact" error<br> </div>
<div><br>
</div>
<div>
<div>
<div dir="ltr">That's unfortunate. Are you using it the same way, with a DBI \
connection in a <Perl> block? I haven't seen anyone else mention a \
problem with it in Apache 1. <div><br>
</div>
<div style="">- Perrin</div>
</div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">On Wed, Jun 12, 2013 at 5:05 PM, Xinhuan Zheng <span \
dir="ltr"> <<a href="mailto:xzheng@christianbook.com" \
target="_blank">xzheng@christianbook.com</a>></span> wrote:<br> <blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"> <div \
style="font-size:14px;font-family:Consolas,sans-serif;word-wrap:break-word"> <div>Hi \
Perrin,</div> <div><br>
</div>
<div>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 <a \
href="http://startup.pl" target="_blank">startup.pl</a> 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 \
Apache1. Is that possible to fix it with Apache1?</div> <div><br>
</div>
<div>Thanks,</div>
<div>- xinhuan</div>
<div><br>
</div>
<span>
<div style="border-right:medium \
none;padding-right:0in;padding-left:0in;padding-top:3pt;text-align:left;font-size:11pt;border-bottom:medium \
none;font-family:Calibri;border-top:#b5c4df 1pt \
solid;padding-bottom:0in;border-left:medium none"> <span \
style="font-weight:bold">From: </span>Perrin Harkins <<a \
href="mailto:pharkins@gmail.com" target="_blank">pharkins@gmail.com</a>><br> <span \
style="font-weight:bold">Date: </span>Wednesday, June 12, 2013 5:53 AM<br> <span \
style="font-weight:bold">To: </span>Fred Moyer <<a \
href="mailto:fred@redhotpenguin.com" \
target="_blank">fred@redhotpenguin.com</a>><br> <span style="font-weight:bold">Cc: \
</span>Xinhuan Zheng <<a href="mailto:xzheng@christianbook.com" \
target="_blank">xzheng@christianbook.com</a>>, "<a \
href="mailto:modperl@perl.apache.org" \
target="_blank">modperl@perl.apache.org</a>" <<a \
href="mailto:modperl@perl.apache.org" target="_blank">modperl@perl.apache.org</a>> \
<div> <div class="h5"><br>
<span style="font-weight:bold">Subject: </span>Re: Apache::DBI "connection lost \
contact" error<br> </div>
</div>
</div>
<div>
<div class="h5">
<div><br>
</div>
<div>
<div>
<div dir="ltr">Thanks Fred!</div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">On Wed, Jun 12, 2013 at 3:29 AM, Fred Moyer <span dir="ltr">
<<a href="mailto:fred@redhotpenguin.com" \
target="_blank">fred@redhotpenguin.com</a>></span> wrote:<br> <blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"> Apache-DBI 1.12 was just pushed to CPAN with this update. \
Thanks for<br> the great work on the fix Perrin.<br>
<div>
<div><br>
On Thu, Jun 6, 2013 at 2:53 PM, Perrin Harkins <<a \
href="mailto:pharkins@gmail.com" target="_blank">pharkins@gmail.com</a>> \
wrote:<br> > That's great! I'll commit the patch and see about getting a new \
release out<br> > to CPAN.<br>
><br>
> - Perrin<br>
><br>
><br>
> On Thu, Jun 6, 2013 at 5:02 PM, Xinhuan Zheng <<a \
href="mailto:xzheng@christianbook.com" \
target="_blank">xzheng@christianbook.com</a>><br> > wrote:<br>
>><br>
>> Hi Perrin,<br>
>><br>
>> I did a testing with debugging. I don't see the "connection lost \
contact"<br> >> error anymore. The patch looks good to me.<br>
>><br>
>> Thanks,<br>
>> - xinhuan<br>
>><br>
>> From: Perrin Harkins <<a href="mailto:pharkins@gmail.com" \
target="_blank">pharkins@gmail.com</a>><br> >> Date: Thursday, June 6, 2013 \
3:02 PM<br> >> To: Xinhuan Zheng <<a href="mailto:xzheng@christianbook.com" \
target="_blank">xzheng@christianbook.com</a>><br> >> Cc: "<a \
href="mailto:modperl@perl.apache.org" \
target="_blank">modperl@perl.apache.org</a>" <<a \
href="mailto:modperl@perl.apache.org" \
target="_blank">modperl@perl.apache.org</a>><br> >><br>
>> Subject: Re: Apache::DBI "connection lost contact" error<br>
>><br>
>> On Thu, Jun 6, 2013 at 12:22 PM, Xinhuan Zheng <<a \
href="mailto:xzheng@christianbook.com" \
target="_blank">xzheng@christianbook.com</a>><br> >> wrote:<br>
>> > The database handle that is created in <a href="http://startup.pl" \
target="_blank"> startup.pl</a> needs to be really<br>
>> > disconnected (not overloaded disconnect) so that won't leave an idle \
server<br> >> > process running on the database side. Once it's really \
disconnected, the<br> >> > server process can be cleaned up on the server \
side.<br> >><br>
>> Right, that's what the bug is preventing.<br>
>><br>
>> Because my flight was delayed last night, I had time to make a patch.<br>
>> Please try this on your system and send the debug, like you did before.<br>
>><br>
>> - Perrin<br>
>><br>
><br>
</div>
</div>
</blockquote>
</div>
<br>
</div>
</div>
</div>
</div>
</div>
</span></div>
</blockquote>
</div>
<br>
</div>
</div>
</div>
</span>
</body>
</html>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic