Intermittent problem with .pl interface in I.E. 1

[PaulReed]

This is a summary of everything I've done to date and the errors that are being recieved.

1) I had to upgrade perl from 5.8.0 to 5.8.8.

2) Then I had problems with some of the Perl Modules calling on a problem with mod_perl.

3) I did a DSO mod_perl install which was successful.

4) I was able to finish installing the Perl Modules.

5) I'm getting this error in my log files...
[error] panic: DBI active kids (5) > kids (2) at /us$
Use of uninitialized value in concatenation (.) or string at /home/fum/lib/i/er$
i::error::report('panic: DBI active kids (6) > kids (2) at /usr/lib/per$
i::error::die('panic: DBI active kids (6) > kids (2) at /usr/lib/perl5/$
DBD::mysql::dr::connect('DBI::dr=HASH(0x9c1c538)','mysql_read_default_f$
Apache:BI::connect('undef','mysql_read_default_file=/home/fum/conf/my$
DBI::__ANON__('undef','undef') called at /usr/lib/perl5/site_perl/5.8.0$
DBI::connect('DBI','dbi:mysql:mysql_read_default_file=/home/fum/conf/my$
i::db::make_db_conn() called at /home/fum/lib/i/db.pm line 58
i::db::connect() called at /home/fum/lib/i/web.pm line 50
i::web::init() called at /home/fum/

http://www/5xx.pl

line 4
Apache::ROOT::_35xx_2epl::handler('Apache=SCALAR(0x9c72ee8)') called at$
eval {...} called at /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-m$
Apache::Registry::handler('Apache=SCALAR(0x9c72ee8)') called at /dev/nu$
eval {...} called at /dev/null line 0

6) Along with the intermittent problem in my browser with with the interface coming up just fine then hitting my refresh button and getting this...

Proxy Error
The proxy server received an invalid response from an upstream server.
The proxy server could not handle the request GET /members/login.pl.

Reason: Document contains no data

7) This is the results of crontab -l

30 4 * * 0 /usr/sbin/logrotate -f /home/fum/logs/logrotate.conf
0 4 * * 0 /usr/sbin/ntpdate ntp1.sf-bay.org; hwclock --systohc
30 * * * * cd /home/fum/lib && ./gen_webstats.sh > /dev/null

In my log files...
-bash: line 1: cd: /home/fum/conf/webstats/: No such file or directory

**gen_webstats.sh**
#!/bin/bash

source ../conf/conf.sh

su - $FUM_USER -c "cd ~/conf/webstats/ && webalizer"

cd $FUM_HOME/awstats/

http://wwwroot/cgi-bin

&& \
../../tools/awstats_buildstaticpages.pl -config=fum -update -dir=$FUM_HOME/

http://www/$

 

[PaulReed]

Hi Travis...

root@mxexpress /usr/mysql/var# cat mxexpress.net.err
080814 23:53:11 mysqld started
080814 23:53:13 InnoDB: Started
/usr/mysql/libexec/mysqld: ready for connections.
Version: '4.0.23a' socket: '/tmp/mysql.sock' port: 3306 Source distribution
080815 0:59:00 /usr/mysql/libexec/mysqld: Normal shutdown

080815 0:59:01 InnoDB: Starting shutdown...
080815 0:59:03 InnoDB: Shutdown completed
080815 0:59:03 /usr/mysql/libexec/mysqld: Shutdown Complete

080815 00:59:03 mysqld ended

080815 01:01:14 mysqld started
080815 1:01:16 InnoDB: Started
/usr/mysql/libexec/mysqld: ready for connections.
Version: '4.0.23a' socket: '/tmp/mysql.sock' port: 3306 Source distribution
080815 2:25:50 /usr/mysql/libexec/mysqld: Normal shutdown

080815 2:25:51 InnoDB: Starting shutdown...
080815 2:25:54 InnoDB: Shutdown completed
080815 2:25:54 /usr/mysql/libexec/mysqld: Shutdown Complete

080815 02:25:54 mysqld ended

080815 02:28:05 mysqld started
080815 2:28:06 InnoDB: Started
/usr/mysql/libexec/mysqld: ready for connections.
Version: '4.0.23a' socket: '/tmp/mysql.sock' port: 3306 Source distribution
080815 2:41:32 /usr/mysql/libexec/mysqld: Normal shutdown

080815 2:41:33 InnoDB: Starting shutdown...
080815 2:41:35 InnoDB: Shutdown completed
080815 2:41:35 /usr/mysql/libexec/mysqld: Shutdown Complete

080815 02:41:35 mysqld ended

080815 02:43:46 mysqld started
080815 2:43:47 InnoDB: Started
/usr/mysql/libexec/mysqld: ready for connections.
Version: '4.0.23a' socket: '/tmp/mysql.sock' port: 3306 Source distribution
080815 3:10:56 /usr/mysql/libexec/mysqld: Normal shutdown

080815 3:10:57 InnoDB: Starting shutdown...
080815 3:11:01 InnoDB: Shutdown completed
080815 3:11:01 /usr/mysql/libexec/mysqld: Shutdown Complete

080815 03:11:01 mysqld ended

080815 03:13:12 mysqld started
080815 3:13:13 InnoDB: Started
/usr/mysql/libexec/mysqld: ready for connections.
Version: '4.0.23a' socket: '/tmp/mysql.sock' port: 3306 Source distribution
A mysqld process already exists at Fri Aug 15 18:07:41 EDT 2008
080816 3:41:58 /usr/mysql/libexec/mysqld: Normal shutdown

080816 3:41:59 InnoDB: Starting shutdown...
080816 3:42:03 InnoDB: Shutdown completed
080816 3:42:03 /usr/mysql/libexec/mysqld: Shutdown Complete

080816 03:42:03 mysqld ended

080816 03:44:12 mysqld started
080816 3:44:13 InnoDB: Started
/usr/mysql/libexec/mysqld: ready for connections.
Version: '4.0.23a' socket: '/tmp/mysql.sock' port: 3306 Source distribution

 

[travs69]

So.. explain what the problem is again. It loads the first time, but if you click refresh it errors out and doesn't work again until you reload apache?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Travis - Those who say it cannot be done are usually interrupted by someone else doing it; Give the wrong symptoms, get the wrong solutions;

 

[PaulReed]

Yes and even if I reboot and things are fine, in a matter of time it goes back to receiving that "Error: panic: DBI active kids (6) > kids (2)" error I posted, and it happens more and more and gets worse.

Also when I mentioned my install files having a DBD-mysql-2.9004 file, disregard that because it's apparent that CPAN installed a much later version.

Thanks

 

[travs69]

Does that error come from apache, perl, or mysql? Is it a error from your application?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Travis - Those who say it cannot be done are usually interrupted by someone else doing it; Give the wrong symptoms, get the wrong solutions;

 

[PaulReed]

Blackened is something that works with Apache with my application, as far as if it's coming from Perl, Apache, or MySQL, what are your feelings on it after seeing the above error? I receive that error via email from the application.

Are you at all interested in coming on the server as a consultant and possibly correcting this?

 

[travs69]

I don't know how useful I would be as I don't do much with mod_perl or apache::dbi. You should verify you are running the latest version of both.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Travis - Those who say it cannot be done are usually interrupted by someone else doing it; Give the wrong symptoms, get the wrong solutions;

 

[PaulReed]

Ok...

I'm running Mod_Perl 1.29 and 1.33.3 in Apache but I can't see how that would be the problem.

 

[travs69]

not apache.. but apache::dbi the perl module. That's part of what is complaining.
Apache:BI::connect



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Travis - Those who say it cannot be done are usually interrupted by someone else doing it; Give the wrong symptoms, get the wrong solutions;

 

[PaulReed]

Travis,

I did the complete update on all the Modules I need from CPAN, wouldn't that be the latest version?

I've just lost a lot of time on this and I really need this up and running. I didn't mean to come off so abrupt earlier.

 

[travs69]

I would assume so but you didn't mention it anywhere so I didn't know what version of it you were using. Have you tried duplicating the problem locally vs on the server? I was trying to look up the blackened thing and I didn't see it anywhere. Is it a public app?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Travis - Those who say it cannot be done are usually interrupted by someone else doing it; Give the wrong symptoms, get the wrong solutions;

 

[PaulReed]

I don't know how to chack the version of Apache:BI. How would I duplicate the error, do you mean get another server and install my application on it? I don't think blackened is a public app.

 

[travs69]

yeah.. you can even run it on your pc. Just to verify how things are working.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Travis - Those who say it cannot be done are usually interrupted by someone else doing it; Give the wrong symptoms, get the wrong solutions;

 

[PaulReed]

You mean with ???ware, I don't remember what the name is?

I think if I can find someone that knows Apache, Mod_Perl and Apache:BI and Apache:BD they could tell me what's wrong real quick.

Do you know anyone that's good with this?

Thanks,

 

[travs69]

You can just run it on windows to. There are versions of all the software available for win32 (apache, mysql, mod_perl, perl, etc). Probably easier than vmware.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Travis - Those who say it cannot be done are usually interrupted by someone else doing it; Give the wrong symptoms, get the wrong solutions;

 

[PaulReed]

My application runs on Redhat or CentOS, not on Windows, and testing it on vmware would duplicate the OS.

Thanks alot and take care.