perl-modperl mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Xinhuan Zheng <xzh...@christianbook.com>
Subject Re: Apache::DBI "connection lost contact" error
Date Sat, 01 Jun 2013 00:45:26 GMT
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 <pharkins@gmail.com<mailto:pharkins@gmail.com>>
Date: Friday, May 31, 2013 10:54 AM
To: Jim Schueler <jschueler@eloquency.com<mailto:jschueler@eloquency.com>>
Cc: Xinhuan Zheng <xzheng@christianbook.com<mailto:xzheng@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

Mime
View raw message