[Mod_log_sql] Apache is restarting after a few minutes

Thu May 26 06:21:28 EST 2005

Hi everybody,

I hope someone here can help me.
I didn't get an answer of Brian Thurlow who released the windows version of mod_log_sql.

I'm running a webserver on Windows 2000 Professional
Apache 2.0.54
PHP 5.0.3
MySQL 4.1.8

I have a problem with mod_log_sql.

I get following entry in my Errorlogfile of the depending virtualhost where I (want to) use mod_log_sql:

[Tue May 24 16:52:45 2005] [error] [client 84.151.147.72] File does not exist: G:/WWWRoot/light-gap.net/knauserer/css, referer: http://knauserer.light-gap.net/
[Tue May 24 16:52:58 2005] [error] [client 84.151.147.72] File does not exist: G:/WWWRoot/light-gap.net/knauserer/modules, referer: http://knauserer.light-gap.net/lexikonein.php
>>[Tue May 24 16:52:58 2005] [error] mysql_query returned (1)
>>[Tue May 24 16:52:58 2005] [notice] db reconnect successful
[Tue May 24 16:52:58 2005] [error] [client 84.151.147.72] File does not exist: G:/WWWRoot/light-gap.net/knauserer/css, referer: http://knauserer.light-gap.net/lexikonein.php
[Tue May 24 16:53:10 2005] [error] [client 82.83.247.111] File does not exist: G:/WWWRoot/gleitgeb.at/members/lulabi
>>[Tue May 24 16:53:43 2005] [error] mysql_query returned (1)
>>[Tue May 24 16:53:43 2005] [notice] db reconnect successful
[Tue May 24 16:53:58 2005] [error] [client 82.83.247.111] File does not exist: G:/WWWRoot/gleitgeb.at/members/lulabi
[Tue May 24 16:54:01 2005] [error] [client 84.151.147.72] File does not exist: G:/WWWRoot/light-gap.net/knauserer/modules, referer: http://knauserer.light-gap.net/
[Tue May 24 16:54:01 2005] [error] [client 84.151.147.72] File does not exist: G:/WWWRoot/light-gap.net/knauserer/css, referer: http://knauserer.light-gap.net/
[Tue May 24 16:54:04 2005] [error] [client 84.151.147.72] File does not exist: G:/WWWRoot/light-gap.net/knauserer/modules, referer: http://knauserer.light-gap.net/lexikon.php
>>[Tue May 24 16:54:04 2005] [error] mysql_query returned (1)
>>[Tue May 24 16:54:04 2005] [notice] db reconnect successful
[Tue May 24 16:54:06 2005] [error] [client 84.151.147.72] File does not exist: G:/WWWRoot/light-gap.net/knauserer/css, referer: http://knauserer.light-gap.net/lexikon.php
[Tue May 24 16:55:40 2005] [error] [client 82.83.247.111] File does not exist: G:/WWWRoot/gleitgeb.at/members/lulabi

At the same time (short after it) my Apache-Service crashes and gets restarted:

>>[Tue May 24 16:53:07 2005] [notice] Parent: child process exited with status 3221225477 -- Restarting.
[Tue May 24 16:53:08 2005] [notice] Apache/2.0.54 (Win32) DAV/2 PHP/5.0.3 mod_jk/1.2.8 configured -- resuming normal operations
[Tue May 24 16:53:08 2005] [notice] Server built: Apr 16 2005 14:25:31
[Tue May 24 16:53:08 2005] [notice] Parent: Created child process 2588
[Tue May 24 16:53:09 2005] [notice] Disabled use of AcceptEx() WinSock2 API
[Tue May 24 16:53:10 2005] [notice] Child 2588: Child process is running
[Tue May 24 16:53:10 2005] [notice] Child 2588: Acquired the start mutex.
[Tue May 24 16:53:10 2005] [notice] Child 2588: Starting 250 worker threads.
[Tue May 24 16:53:10 2005] [notice] Child 2588: Listening on port 80.
>>[Tue May 24 16:53:51 2005] [notice] Parent: child process exited with status 3221225477 -- Restarting.
[Tue May 24 16:53:52 2005] [notice] Apache/2.0.54 (Win32) DAV/2 PHP/5.0.3 mod_jk/1.2.8 configured -- resuming normal operations
[Tue May 24 16:53:52 2005] [notice] Server built: Apr 16 2005 14:25:31
[Tue May 24 16:53:52 2005] [notice] Parent: Created child process 5860
[Tue May 24 16:53:53 2005] [notice] Disabled use of AcceptEx() WinSock2 API
[Tue May 24 16:53:54 2005] [notice] Child 5860: Child process is running
[Tue May 24 16:53:54 2005] [notice] Child 5860: Acquired the start mutex.
[Tue May 24 16:53:54 2005] [notice] Child 5860: Starting 250 worker threads.
[Tue May 24 16:53:54 2005] [notice] Child 5860: Listening on port 80.
>>[Tue May 24 16:54:13 2005] [notice] Parent: child process exited with status 3221225477 -- Restarting.
[Tue May 24 16:54:15 2005] [notice] Apache/2.0.54 (Win32) DAV/2 PHP/5.0.3 mod_jk/1.2.8 configured -- resuming normal operations
[Tue May 24 16:54:15 2005] [notice] Server built: Apr 16 2005 14:25:31
[Tue May 24 16:54:15 2005] [notice] Parent: Created child process 4908
[Tue May 24 16:54:15 2005] [notice] Disabled use of AcceptEx() WinSock2 API
[Tue May 24 16:54:16 2005] [notice] bw_mod : Version 0.6 - Initialized [0 Confs]
[Tue May 24 16:54:16 2005] [notice] Child 4908: Child process is running
[Tue May 24 16:54:16 2005] [notice] Child 4908: Acquired the start mutex.
[Tue May 24 16:54:16 2005] [notice] Child 4908: Starting 250 worker threads.
[Tue May 24 16:54:16 2005] [notice] Child 4908: Listening on port 80.

If I disable mod_log_sql everything works fine.

Do anyone of you have an idea what can cause this problem?
What does "mysql_query returned (1)" mean?

I also tried the debug mode but there was no depending additional information in the logfile.

I hope for a fast answer.

Best regards
Günther Leitgeb
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.outoforder.cc/pipermail/mod_log_sql/attachments/20050526/2f7772b9/attachment.html 