On Tue, Feb 8, 2011 at 6:26 PM, Max Pinton wrote:
> I checked $dbh->{mysql_auto_reconnect} and, as per the docs, it's 1 in a
> mod_perl script and 0 otherwise. Is there another place to look? It seems
> like something I'd really want to have on.
Recommended practice is to turn this off. If it's
On Tue, Feb 8, 2011 at 16:26, Max Pinton wrote:
> On Feb 8, 2011, at 7:36 AM, Perrin Harkins wrote:
>> That doesn't explain all of your errors though. I'm guessing that
>> you're opening a connection during startup and forking with it. You
>> need to find that. Look for things that might open a
On Feb 8, 2011, at 7:36 AM, Perrin Harkins wrote:
I'm just curious why it used to work. It seems like DBI would
reconnect a $dbh closure if it timed out.
One thing that might have changed is your database configuration.
MySQL is often configured to automatically reconnect.
I checked $dbh->{my
On Sun, Feb 6, 2011 at 4:44 PM, Max Pinton wrote:
> Did earlier versions of Perl/mod_perl/DBI/Apache::DBI handle closures
> differently?
No, not at all. This is a core Perl thing.
> I'm just curious why it used to work. It seems like DBI would
> reconnect a $dbh closure if it timed out.
One th
On Feb 6, 2011, at 8:20 AM, Perrin Harkins wrote:
Are you running the worker MPM? Apache::DBI will do the right thing
with prefork MPM, but I don't think it will work with threads.
Nope, prefork:
# apache2 -V
Server version: Apache/2.2.16 (Debian)
Server built: Nov 14 2010 18:14:55
Server's
Hi Max,
On Sat, Feb 5, 2011 at 10:01 PM, Max Pinton wrote:
> But the issue I'm asking about today is with DBI (1.612) and Apache::DBI
> (1.08). In my old configuration they worked fine, but after the upgrade I
> started seeing tons of errors like this:
>
> DBD::mysql::st execute failed: Commands
[ Please keep it on the list... ]
On Fri, 2004-05-14 at 09:36, Alex McLintock wrote:
> sometimes at random my mod_perl/DBI/DBD::Mysql connections fail at
> the execute stage resulting in an error something like "fetch failed
> because of no execute" failure.
>
> Does this sound like the same pr
You didn't specify which Database server you're using. If it's mysql you need to be cautious of the 'ping' method used by Apache::DBI to check if a connection is stale or not. the DBD::mysql ping method always returns a 'true' string e.g. "0 but true" rather than a 1 or a 0.
I believe the latest
Thanks, Guys,
I ended up installing Apache::DBI from CPAN and it is under /home/dssweb/local-perl/lib/site_perl/5.8.3. I was mistaken that Apache::DBI would come with apache.
Event though it was, for some reason it didn't get installed.
Anyways, it is working now.
Cheers, Isarin
Perrin
On Wed, 2004-05-12 at 14:32, I S wrote:
> Sorry for being unclear. I mean Apache subdirectory
> under site_perl directory. I can seee Registry.pm
> under .../site_perl/5.8.3/sun4-solaris/Apache
> directory. (Apache::Registry) I would expect DBI in
> the same directory but it is not there.
That'
I S wrote:
Sorry for being unclear. I mean Apache subdirectory
under site_perl directory. I can seee Registry.pm
under .../site_perl/5.8.3/sun4-solaris/Apache
directory. (Apache::Registry) I would expect DBI in
the same directory but it is not there. I figured
that out after it gave me an erro
> Apache::DBI comes with mod_perl, and you should see
> it in your site_perl directory. It is a pure perl
> module, so it would not be under an i386
> directory (or whatever your architecture is). If
> you can do PerlModule Apache::DBI in your program
> without failure, it means that it is ther
On Wed, 2004-05-12 at 12:15, I S wrote:
> a) I don't understand why the database sometimes gets
> dropped. It happens randomly but frequently.
>
> could not prepare: Database disconnected at
> /dssweb/httpd/cgi-bin/feeds/viewReport line 157.
Usually this is caused by an inactivity timeout on you
I S wrote:
Hi all,
I have some questions with DBI.
a) I don't understand why the database sometimes gets
dropped. It happens randomly but frequently.
could not prepare: Database disconnected at
/dssweb/httpd/cgi-bin/feeds/viewReport line 157.
b) I built mod_perl and apache with EVERYTHING=1.
14 matches
Mail list logo
