I set this DEBUG in Apache::DBI module. Here is the debugging error it produces at 'apachectl start':
2520 Apache::DBI skipping connection during server startup, read the docu !! 2520 Apache::DBI skipping connection during server startup, read the docu !! 2521 Apache::DBI push PerlChildExitHandler 2521 Apache::DBI need ping: yes 2521 Apache::DBI new connect to '….' 2521 Apache::DBI disconnect (overloaded) 2521 Apache::DBI need ping: yes 2521 Apache::DBI already connected to '….' 2521 Apache::DBI disconnect (overloaded) 2522 Apache::DBI PerlChildInitHandler 2522 Apache::DBI need ping: yes 2523 Apache::DBI PerlChildInitHandler DBD::Oracle::db DESTROY failed: ORA-03113: end-of-file on communication channel Process ID: 0 Session ID: 5471 Serial number: 19146 (DBD ERROR: OCISessionEnd) at /usr/local/lib/perl5/site_perl/5.10.1/Apache/DBI.pm line 229. 2524 Apache::DBI PerlChildInitHandler 2523 Apache::DBI need ping: yes DBD::Oracle::db DESTROY failed: ORA-03135: connection lost contact Process ID: 0 Session ID: 5471 Serial number: 19146 (DBD ERROR: OCISessionEnd) at /usr/local/lib/perl5/site_perl/5.10.1/Apache/DBI.pm line 229. 2525 Apache::DBI PerlChildInitHandler 2524 Apache::DBI need ping: yes DBD::Oracle::db DESTROY failed: ORA-03135: connection lost contact Process ID: 0 Session ID: 5471 Serial number: 19146 (DBD ERROR: OCISessionEnd) at /usr/local/lib/perl5/site_perl/5.10.1/Apache/DBI.pm line 229. 2525 Apache::DBI need ping: yes 2526 Apache::DBI PerlChildInitHandler DBD::Oracle::db DESTROY failed: ORA-03135: connection lost contact Process ID: 0 Session ID: 5471 Serial number: 19146 (DBD ERROR: OCISessionEnd) at /usr/local/lib/perl5/site_perl/5.10.1/Apache/DBI.pm line 229. 2526 Apache::DBI need ping: yes 2527 Apache::DBI PerlChildInitHandler [Fri May 31 20:27:36 2013] [notice] Apache/2.2.23 (Unix) mod_perl/2.0.5 Perl/v5.10.1 configured -- resuming normal operations [Fri May 31 20:27:36 2013] [info] Server built: Jan 14 2013 20:41:03 [Fri May 31 20:27:36 2013] [debug] prefork.c(1023): AcceptMutex: sysvsem (default: sysvsem) DBD::Oracle::db DESTROY failed: ORA-03135: connection lost contact Process ID: 0 Session ID: 5471 Serial number: 19146 (DBD ERROR: OCISessionEnd) at /usr/local/lib/perl5/site_perl/5.10.1/Apache/DBI.pm line 229. 2527 Apache::DBI need ping: yes 2529 Apache::DBI PerlChildInitHandler 2528 Apache::DBI PerlChildInitHandler 2530 Apache::DBI PerlChildInitHandler 2531 Apache::DBI PerlChildInitHandler DBD::Oracle::db DESTROY failed: ORA-03135: connection lost contact Process ID: 0 Session ID: 5471 Serial number: 19146 (DBD ERROR: OCISessionEnd) at /usr/local/lib/perl5/site_perl/5.10.1/Apache/DBI.pm line 229. 2530 Apache::DBI need ping: yes DBD::Oracle::db DESTROY failed: ORA-03135: connection lost contact Process ID: 0 Session ID: 5471 Serial number: 19146 (DBD ERROR: OCISessionEnd) at /usr/local/lib/perl5/site_perl/5.10.1/Apache/DBI.pm line 229. 2528 Apache::DBI need ping: yes DBD::Oracle::db DESTROY failed: ORA-03135: connection lost contact Process ID: 0 Session ID: 5471 Serial number: 19146 (DBD ERROR: OCISessionEnd) at /usr/local/lib/perl5/site_perl/5.10.1/Apache/DBI.pm line 229. DBD::Oracle::db DESTROY failed: ORA-03135: connection lost contact Process ID: 0 Session ID: 5471 Serial number: 19146 (DBD ERROR: OCISessionEnd) at /usr/local/lib/perl5/site_perl/5.10.1/Apache/DBI.pm line 229. 2522 Apache::DBI new connect to '….' 2529 Apache::DBI need ping: yes 2531 Apache::DBI need ping: yes 2523 Apache::DBI new connect to '….' 2525 Apache::DBI new connect to '….' 2524 Apache::DBI new connect to '….' 2527 Apache::DBI new connect to '….' 2526 Apache::DBI new connect to '….' 2530 Apache::DBI new connect to '….' 2528 Apache::DBI new connect to '….' 2529 Apache::DBI new connect to '….' 2531 Apache::DBI new connect to '….' PID 2520 is the very first ancestor. He died shortly after initialization. PID 2521 is the second ancestor. He became the parent process. PID 2522 to 2531 are children. Here is the error at 'apachectl stop': 2531 Apache::DBI PerlChildExitHandler 2528 Apache::DBI PerlChildExitHandler 2530 Apache::DBI PerlChildExitHandler 2529 Apache::DBI PerlChildExitHandler 2527 Apache::DBI PerlChildExitHandler 2525 Apache::DBI PerlChildExitHandler 2526 Apache::DBI PerlChildExitHandler 2522 Apache::DBI PerlChildExitHandler 2524 Apache::DBI PerlChildExitHandler 2523 Apache::DBI PerlChildExitHandler [Fri May 31 20:37:16 2013] [info] removed PID file httpd.pid (pid=2521) [Fri May 31 20:37:16 2013] [notice] caught SIGTERM, shutting down DBD::Oracle::db DESTROY failed: ORA-03135: connection lost contact Process ID: 0 Session ID: 5471 Serial number: 19146 (DBD ERROR: OCISessionEnd) during global destruction. Are children using same Database Handle? Does Apache::DBI work right with Apache2+mod_perl2? Thanks, - xinhuan From: Perrin Harkins <phark...@gmail.com<mailto:phark...@gmail.com>> Date: Friday, May 31, 2013 10:54 AM To: Jim Schueler <jschue...@eloquency.com<mailto:jschue...@eloquency.com>> Cc: Xinhuan Zheng <xzh...@christianbook.com<mailto:xzh...@christianbook.com>>, "modperl@perl.apache.org<mailto:modperl@perl.apache.org>" <modperl@perl.apache.org<mailto:modperl@perl.apache.org>> Subject: Re: Apache::DBI "connection lost contact" error $Apache::DBI::DEBUG = 2
