[Mod_log_sql] mod_log_sql and threaded apache2

Daniel Mayer [COUGA.net] mayer at couga.net
Sat Dec 16 21:29:11 EST 2006


Hi,

our company is using mod_log_sql for quite a while under apache 1.3. Now
we have a new server which runs Apache/2.0.54 and uses fastcgi to
implement php 4 and 5. Up to a week it seemed, that mod_log_mysql is
working perfectly fine with it.

But a customer complained that his page got stuck in the loading process
and it turned out that the apache processes were segfaulting. As I don't
use mod_php I think it is not related to the usual mysql issue (or can
it still be?). 

When I disable mod_log_sql the sefgaults don't appear anymore. From my
analysis it seems that if I don't use the threaded model but the
traditional prefork model the crashes also don't appear anymore. 

My question therefore is if mod_log_sql should work with the threaded
model or not at all. I tried the newest source code as well as some
older ones and the precompiled apache packages.

If it is important, this is my config:

LogSQLLoginInfo mysql://apachelogs:ccc@localhost/apachelogs
LogSQLCreateTables on
LogSQLDBParam socketfile /var/run/mysqld/mysqld.sock
LogSQLMassVirtualHosting On
LOGSQLMACHINEID xxx
LogSQLTransferLogFormat MAbHhmRSsTUuv


Thanks for your help,
Daniel



More information about the Mod_log_sql mailing list