Bug#520406: core dump apache with mod_perl and mysql database connections

[Hartmut.Vogler at t-systems.com]

Package: libdbd-mysql-perl
Version: 4.007-1
 
I use lenny for an application in apache2/mod_perl2/ApacheDBI/mysql
enviroment.
 
If my mod_perl application is unused for some minutes (ca. 15-30) in
apache get messages about created core dumps:
 
f.e.:
[Wed Mar 18 16:08:09 2009] [notice] child pid 16489 exit signal
Segmentation fault (11), possible coredump in /tmp
 
If this happens, at the Web-Site errors (zero size page) will be
displayed, soo this problem is very critical.
My System constellation is:
 
||/ Name                                 Version
+++-====================================-===============
ii  apache2                              2.2.9-10+lenny2
ii  apache2-mpm-prefork                  2.2.9-10+lenny2
ii  apache2-utils                        2.2.9-10+lenny2
ii  apache2.2-common                     2.2.9-10+lenny2
ii  libapache-dbi-perl                   1.07-1
ii  libapache2-mod-perl2                 2.0.4-5        
ii  libdbd-mysql-perl                    4.007-1
ii  libmysqlclient15off                  5.0.51a-24      
ii  mysql-common                         5.0.51a-24      

 
 
To quickfix the problem, i have manualy install the current version of
DBD::mysql (4.010). With this solution no cores are wirtten but in this
relases the problem "Commands out of sync; you can't run this command
now" occured (in situations in witch this not should occured). 
The only working solution i found, is to install the "old" Version
DBD-mysql-3.0008 direct from CPAN.org .
The problem seems related to an already known bug at CPAN Bug Tracker
http://rt.cpan.org/Public/Bug/Display.html?id=37027 .
I think, there is an update in Lenny necessary, because with this bug,
no mysql/mod_perl/apache web applications can't be suggestive processed.

 

Regards 
Hartmut Vogler