: Xinhuan Zheng xzh...@christianbook.com, 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 f...@redhotpenguin.comwrote:
Apache-DBI 1.12 was just pushed to CPAN with this update
...@gmail.commailto:phark...@gmail.com
Date: Thursday, June 13, 2013 11:03 AM
To: Xinhuan Zheng xzh...@christianbook.commailto:xzh...@christianbook.com
Cc: modperl@perl.apache.orgmailto:modperl@perl.apache.org
modperl@perl.apache.orgmailto:modperl@perl.apache.org
Subject: Re: Apache::DBI connection lost contact error
To: Xinhuan Zheng xzh...@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 xzh...@christianbook.com
wrote:
The database handle that is created in startup.pl needs to be really
.
Thanks,
- xinhuan
From: Perrin Harkins phark...@gmail.com
Date: Thursday, June 6, 2013 3:02 PM
To: Xinhuan Zheng xzh...@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
: modperl@perl.apache.orgmailto:modperl@perl.apache.org
modperl@perl.apache.orgmailto:modperl@perl.apache.org
Subject: Re: Apache::DBI connection lost contact error
On Thu, Jun 6, 2013 at 12:22 PM, Xinhuan Zheng
xzh...@christianbook.commailto:xzh...@christianbook.com
wrote:
The database
...@christianbook.com
Cc: Jim Schueler jschue...@eloquency.commailto:jschue...@eloquency.com,
modperl@perl.apache.orgmailto:modperl@perl.apache.org
modperl@perl.apache.orgmailto:modperl@perl.apache.org
Subject: Re: Apache::DBI connection lost contact error
On Tue, Jun 4, 2013 at 2:32 PM, Xinhuan
On Thu, Jun 6, 2013 at 12:22 PM, Xinhuan Zheng xzh...@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 disconnected, the
...@christianbook.commailto:xzh...@christianbook.com
Cc: modperl@perl.apache.orgmailto:modperl@perl.apache.org
modperl@perl.apache.orgmailto:modperl@perl.apache.org
Subject: Re: Apache::DBI connection lost contact error
On Thu, Jun 6, 2013 at 12:22 PM, Xinhuan Zheng
xzh...@christianbook.commailto:xzh...@christianbook.com
good to me.
Thanks,
- xinhuan
From: Perrin Harkins phark...@gmail.com
Date: Thursday, June 6, 2013 3:02 PM
To: Xinhuan Zheng xzh...@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
On Tue, Jun 4, 2013 at 2:32 PM, Xinhuan Zheng xzh...@christianbook.com
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
On Mon, Jun 3, 2013 at 4:36 PM, Dave Morgan dave.mor...@100.com 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
connection lost contact error
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?
It's a test for whether or not we're running in the parent process, used to
skip caching connections during startup. It's
On Tue, Jun 4, 2013 at 9:59 AM, Xinhuan Zheng xzh...@christianbook.com
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
@perl.apache.orgmailto:modperl@perl.apache.org
Subject: Re: Apache::DBI connection lost contact error
On Tue, Jun 4, 2013 at 9:59 AM, Xinhuan Zheng
xzh...@christianbook.commailto:xzh...@christianbook.com wrote:
Will the new connection that's created be cached after then and the
connection that's
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 Monday, June 3, 2013, Xinhuan Zheng wrote:
What is the check to see if the server is restarting? Is that new child
processes spawning?
It's a test for whether or not we're running in the parent process, used to
skip caching connections during startup. It's this, line 128:
if
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
On Mon, Jun 3, 2013 at 2:36 PM, Dave Morgan dave.mor...@100.com 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
On Fri, May 31, 2013 at 5:45 PM, Xinhuan Zheng xzh...@christianbook.com
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
Try an explicit disconnect() call.
- Perrin
On Thu, May 30, 2013 at 7:46 PM, Xinhuan Zheng xzh...@christianbook.comwrote:
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
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
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
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.
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:
@perl.apache.orgmailto:modperl@perl.apache.org
modperl@perl.apache.orgmailto:modperl@perl.apache.org
Subject: Re: Apache::DBI connection lost contact error
$Apache::DBI::DEBUG = 2
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
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 jschue...@eloquency.com wrote:
Did this solve your problem?
Hi,
I have apache 2.2.23 statically compiled with mod_perl2 (prefork). perl binary
is 5.10.1. In startup.plhttp://startup.pl/ file there is call
Apache::DBI-connect_on_init.
code
use Apache::DBI;
Apache::DBI-connect_on_init( $DB_DRIVER, $DB_USER, $DB_PASSWORD );
use DBI;
/code
I need to call
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
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
30 matches
Mail list logo