RE: Problem with apache and mysql

[prev] [thread] [next] [Date index for 2005/03/10]

 
Thanks a lot Gokul !!

I created a handler to create a connection to database, process data (using
other modules that this main modle load) and then I close each connection
created (I'm sure each connection is closed)

I'm using Apache::DBI but I'm not sure if I correctly configure it. 

Considering that both (Apache & MySQL) are on the same machine, yesterday I
removed Apache::DBI and it has not fail until now ... it is maybe a matter
of time to see the error again ...

Do you know how to debug Apache::DBI in this situations ?

Thanks,
___________________________________

    Ing. Alejandro Galue.
    SYNC Consultores C.A.

    agalue@xxxx.xxx.xx
    http://www.sync.com.ve

    Telf. : +58 (212) 762-85-55
                      762-30-12
                      762-86-93
    Cel.  : +58 (414) 134-47-23
    Fax.  : +58 (212) 762-66-71
    Skype : agalue
    MSN   : agalue@xxxxxxx.xxx
___________________________________

-----Original Message-----
From: Gokul P. Nair [mailto:gpnair78@xxxxx.xxx] 
Sent: Wednesday, March 09, 2005 6:51 PM
To: Alejandro Galue; modperl@xxxx.xxxxxx.xxx
Cc: Arturo Martmn
Subject: Re: Problem with apache and mysql

My suggestion would be to use Apache::DBI too if ur not already doing so. my
guess is that the database handles open by DBI (not to be mistaken for
Apache::DBI) might remain open eventually leading to inability to access
mysql anymore.

hope that helps.

Gokul

--- Alejandro Galue <agalue@xxxx.xxx.xx> wrote:
>  
> 
> Hello All,
> 
> I'm using Fedora Core 3 with this packages version
> (RPM):
> 
> httpd-2.0.52-3.1
> mod_perl-1.99_16-3
> perl-DBI-1.40'5
> perl-DBD-MySQL-2.9004-4
> libdbi-0.6.5-10
> libdbi-dbd-mysql-0.6.5-10
> mysql-4.1.9-1
> mysql-server-4.1.9-1
> mysqlclient10-3.23.58-4
> 
> I downloaded source rpm for Mysql from fedora-development and rebuild 
> on a updated fedora core 3.
> 
> I have an application that run a script to read and modify mysql (this 
> part works great), and the web interface for this application. This 
> web interface
> 
> was created totally with mod_perl.
> 
> After a certain amount of time, it cannot be possible to use the 
> database frontend via web becase it cannot connect to database. This 
> problem appears when we run the application in a limited RAM machine
> - 128 - 256MB; before
> that we have never experience the problem. It has been working ok in 
> HW with RAM between 386MB and 512MB RAM.
> 
> I can enter to database manually and check status and mysql is up; but 
> I need to restart apache to have the Web front-end working properly 
> again.
> 
> After some hours the failure shows up again.
> 
> Anyone have any idea of what is happening here ?
> 
> My guest is : the problem should be related to perl-DBI or mod_perl or 
> maybe the configuracion of modperl or mysql. My questions in this 
> case:
> 
> - Does it sound like the place to look for the problem ?
> - Any tips on how to turn on the debugging on this components ? How to 
> figure out which one is responsible for the failure and why  ?
> 
> Thanks in advance,
> Alejandro Galue.
> 
> 
> 
> 


	
		
__________________________________
Celebrate Yahoo!'s 10th Birthday! 
Yahoo! Netrospective: 100 Moments of the Web
http://birthday.yahoo.com/netrospective/