rrin Harkins mailto:phark...@gmail.com>>
Date: Thursday, June 13, 2013 11:03 AM
To: Xinhuan Zheng mailto:xzh...@christianbook.com>>
Cc: "modperl@perl.apache.org<mailto:modperl@perl.apache.org>"
mailto:modperl@perl.apache.org>>
Subject: Re: Apache::DBI "connection lost co
: Fred Moyer
> Cc: Xinhuan Zheng , "modperl@perl.apache.org" <
> 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:
>
>> Apac
y, June 12, 2013 5:53 AM
To: Fred Moyer mailto:f...@redhotpenguin.com>>
Cc: Xinhuan Zheng mailto:xzh...@christianbook.com>>,
"modperl@perl.apache.org<mailto:modperl@perl.apache.org>"
mailto:modperl@perl.apache.org>>
Subject: Re: Apache::DBI "connection lost co
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: Xinh
n
>>
>> 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, X
r 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
>
&g
hristianbook.com>>
Cc: "modperl@perl.apache.org<mailto:modperl@perl.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
mailto:xzh...@christianbook.com>>
On Thu, Jun 6, 2013 at 12:22 PM, Xinhuan Zheng
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 disconnected, the
server process can be
om>>
Cc: Jim Schueler mailto:jschue...@eloquency.com>>,
"modperl@perl.apache.org<mailto:modperl@perl.apache.org>"
mailto:modperl@perl.apache.org>>
Subject: Re: Apache::DBI "connection lost contact" error
On Tue, Jun 4, 2013 at 2:32 PM, Xinhuan Zheng
ma
On Tue, Jun 4, 2013 at 2:32 PM, Xinhuan Zheng
wrote:
> I have seen in other web servers when apachectl starts, there is no
"connect lost contact" error but it did happen when apachectl stops.
If your server does not receive constant requests, you may see this error
on shutdown because cached data
n
From: Perrin Harkins mailto:phark...@gmail.com>>
Date: Tuesday, June 4, 2013 12:18 PM
To: Xinhuan Zheng mailto:xzh...@christianbook.com>>
Cc: Jim Schueler mailto:jschue...@eloquency.com>>,
"modperl@perl.apache.org<mailto:modperl@perl.apache.org>"
mailto:m
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
connection 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
Hi Perrin,
> It looks to me like there's no danger here, just an annoying error message.
> Your connection from the parent process is being passed across the fork, but
> then when each child process tries to check it with ping() it fails and a new
> connection is opened to replace it.
It look
On Mon, Jun 3, 2013 at 4:36 PM, Dave Morgan wrote:
> As an administrator I still rely and depend on Apache::DBI, even if it is
unsupported.
Can we kill this rumor please? Apache::DBI is supported.
- Perrin
On Mon, Jun 3, 2013 at 2:36 PM, Dave Morgan wrote:
> On 06/03/2013 03:14 PM, Perrin Harkins wrote:
>
> DO NOT USE Apache::DBI with DBI::Connector or any other database caching
> technique. This requires
> knowledge of the code!!!
DBIx::Class monkey patches Apache::DBI so that the caching behavior
On 06/03/2013 03:14 PM, Perrin Harkins wrote:
On Monday, June 3, 2013, Xinhuan Zheng wrote:
> What is the check to see if the server is restarting? Is that new child
processes spawning?
I always found the best way to run/test Apache::DBI was to run a mod-perl
enabled http server without Apac
Hi Perrin,
> Does Apache::DBI work right with Apache2+mod_perl2?
Yes, but there may be a bug in how it checks to see if the server is restarting.
What is the check to see if the server is restarting? Is that new child
processes spawning?
If there is a bug in how it checks to see if the server
On Fri, May 31, 2013 at 5:45 PM, Xinhuan Zheng
wrote:
> 2520 Apache::DBI skipping connection during server startup,
read the docu !!
> 2520 Apache::DBI skipping connection during server startup,
read the docu !!
That's good.
> 2521 Apache::DBI push PerlChildEx
>>
Cc: Xinhuan Zheng mailto:xzh...@christianbook.com>>,
"modperl@perl.apache.org<mailto:modperl@perl.apache.org>"
mailto:modperl@perl.apache.org>>
Subject: Re: Apache::DBI "connection lost contact" error
$Apache::DBI::DEBUG = 2
Well, you are on the modperl list, so that means you. :)
Xinhuan, the error is harmless, but if you're concerned about it I would
try turning on debugging to make sure the connection is not being cached.
Do this:
$Apache::DBI::DEBUG = 2;
And then watch for a message like this in your log:
skippi
I'm afraid I'm out of my league. I just noticed the following comment on
the Apache::DBI man page:
Edmund Mergl was the original author of Apache::DBI. It is now supported
and maintained by the modperl mailinglist, see the mod_perl documentation
for instructions on how to subscribe.
-Ji
I believe I am using "my" declaration rather than "local". I also tried
explicitly disconnect but still have same issue. Since it only happens in
parent/child processes, I don't know a good way to debug parent/child, nor
reproducing the same error using a simple program. Can you guys help me
with t
Perrin is right. But fundamentally, I'd say that you're confusing
'local' and 'my' variable scoping:
http://www.perlmonks.org/?node_id=94007
-Jim
On Fri, 31 May 2013, Perrin Harkins wrote:
Try an explicit disconnect() call.
- Perrin
On Thu, May 30, 2013 at 7:46 PM, Xinhuan Zheng
wrot
Try an explicit disconnect() call.
- Perrin
On Thu, May 30, 2013 at 7:46 PM, Xinhuan Zheng wrote:
> The db handle is declared local and once it's out of scope, the destroy
> call will disconnect. But it appears even though variable is out of scope,
> we still get that error. Don't know why.
> -
The db handle is declared local and once it's out of scope, the destroy
call will disconnect. But it appears even though variable is out of scope,
we still get that error. Don't know why.
- xinhuan
On 5/30/13 8:31 AM, "Jim Schueler" wrote:
>Did this solve your problem?
>
> -Jim
>
>On Wed, 29 Ma
Did this solve your problem?
-Jim
On Wed, 29 May 2013, Perrin Harkins wrote:
Hi,
Apache::DBI is supposed to skip caching if you connect during startup. You
should just need to disconnect your database handle after you finish with
it. It sounds like you're opening it and then leaving it open
Hi,
Apache::DBI is supposed to skip caching if you connect during startup. You
should just need to disconnect your database handle after you finish with
it. It sounds like you're opening it and then leaving it open.
- Perrin
On Wed, May 29, 2013 at 3:24 PM, Xinhuan Zheng wrote:
> Hi,
>
> I
A few questions:
Precisely when do you get this error? When startup.pl exits or before?
Can you send a copy of your startup.pl file?
You get exactly the same error on startup and shutdown?
If PerlRequire startup.pl is commented out, do you still get errors?
Do you get errors when a
: Apache::DBI Connection Lost
On Wed, 2004-08-11 at 14:58, Kreimendahl, Chad J wrote:
> Not if he's set the vars that disable pinging...
It's on by default. Turning on DBI_TRACE to verify it is getting called
would be a good idea though, and $Apache::DBI::DEBUG too.
> Also, I'
On Wed, 2004-08-11 at 14:58, Kreimendahl, Chad J wrote:
> Not if he's set the vars that disable pinging...
It's on by default. Turning on DBI_TRACE to verify it is getting called
would be a good idea though, and $Apache::DBI::DEBUG too.
> Also, I've found that (in the past) sometimes the ping d
ROTECTED]
Sent: Wednesday, August 11, 2004 1:52 PM
To: Kreimendahl, Chad J
Cc: David Hofmann; Modperl List
Subject: RE: Apache::DBI Connection Lost
On Wed, 2004-08-11 at 14:43, Kreimendahl, Chad J wrote:
> Simple answer... do a $dbh->ping ... if unresponsive, reconnect.
He's already usi
On Wed, 2004-08-11 at 14:43, Kreimendahl, Chad J wrote:
> Simple answer... do a $dbh->ping ... if unresponsive, reconnect.
He's already using Apache::DBI, and that's exactly what it does.
- Perrin
--
Report problems: http://perl.apache.org/bugs/
Mail list info: http://perl.apache.org/maillist/
PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: Apache::DBI Connection Lost
Just tried it, still has the same problem.
David
>From: Perrin Harkins <[EMAIL PROTECTED]>
>To: David Hofmann <[EMAIL PROTECTED]>
>CC: Modperl List <[EMAIL PROTECTED]>
>Subject: Re:
Just tried it, still has the same problem.
David
From: Perrin Harkins <[EMAIL PROTECTED]>
To: David Hofmann <[EMAIL PROTECTED]>
CC: Modperl List <[EMAIL PROTECTED]>
Subject: Re: Apache::DBI Connection Lost
Date: Wed, 11 Aug 2004 12:43:59 -0400
On Wed, 2004-08-11 at 10:01, D
On Wed, 2004-08-11 at 10:01, David Hofmann wrote:
> Any suggestion on why Apache::DBI won't reconnect ?
>
> David Hofmann
>
> --- My Apache Startup Script ---
>
> # make sure we are in a sane environment.
> $ENV{MOD_PERL} or die "not running under mod_perl!";
>
> use strict;
> use Carp ();
> us
35 matches
Mail list logo
