>Hmmm. How busy is the site or is still in testing phase?
Testing phase.
>Are you saying your connection is getting dropped and then you get an
error,or that you get dropped and then it has to reconnect?
Here's a sample of errors that I'm getting the error_log file:
[Tue Aug 29 20:15:52 2000] null: DBD::Oracle::st execute failed:
ORA-01012: not logged on (DBD ERROR: OCIStmtExecute) at
/u1/web/modules/(some_dir)/process.pm line 580.
[Tue Aug 29 20:25:21 2000] null: DBD::Oracle::db ping failed: ORA-02396:
exceeded maximum idle time, please connect again (DBD ERROR:
OCIStmtExecute/Describe) at /usr/lib/perl5/site_perl/5.005/Apache/DBI.pm
line 112.
What I think is going on is that the script gets killed by Oracle for
being idle and tries to ping the connection, but the ping fails. I took
the suggestion in Apache::DBI and replaced the ping code with the
subroutine in Oracle.pm but we still encountered this issue. Later on
though we want the connection back but it never makes another call to the
connect subroutine that is described in the performance tuning t docs. I
was guessing that the .pm file that calls the connect routine is in memory
someplace so it has no need to call back connect since it assumes that the
connection is still present. Then at some random interval we get that
error message from apache. I'm out of ideas of what's causing this.
>
>I guess I am missing the key to the question here :^)
>
>I have some suggestions that can help, but I need to know which you are
>dealing with first.
Cool. Any help is much appreciated :)
>Rebild your mod_perl with the EVERYTHING=1 flag. That will get rid of
the
>above error message.
So I have to re-install it? Is there anything I need to do when I rebuild
it? Or do I just need to reinstall mod_perl as it's done in the
documentation?
--------------------------------------------------------------------------
Why is College Club the largest and fastest growing college student site?
Find out for yourself at http://www.collegeclub.com
