Please take our Survey
logo       

Choosing A Webhost:
A web hosting service is a type of Internet hosting service that allows individuals and organizations to provide their own website accessible via the World Wide Web. Web hosts are companies that provide space on a server they own for use by their clients as well as providing Internet connectivity, typically in a data center. Web hosts can also provide data center space and connectivity to the Internet for servers they do not own to be located in their data center, called colocation. more...

Signal 4 and 11 errors when LogSQLMassVirtualHosting On: msg#00000

apache.mod-log-sql

Subject: Signal 4 and 11 errors when LogSQLMassVirtualHosting On

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

Thought I would ask if anyone else has observed this or if it's
something that's already fixed in /trunk

Thank you, Jason

- --------------
Apache 2.0.52 on FreeBSD 4.10 with mod_log_sql-1.99

Config:

<IfModule mod_log_sql.c>
LogSQLLoginInfo
mysql://apachelogger:passwd-here-Ul0Cklys8PmTk5BG5B/5ktBPR1lH4CV8@xxxxxxxxxxxxxxxx/apachelogs
LogSQLCreateTables on
LogSQLDBParam socketfile /tmp/mysql.sock
LogSQLMassVirtualHosting On
LogSQLMachineID comox
LogSQlPreserveFile /tmp/mod-log-sql-preserve
</IfModule>

Error in httpd-error:

[Tue Dec 28 19:47:15 2004] [error] table does not exist, preserving
query
[Tue Dec 28 19:47:15 2004] [error] table doesn't exist...creating now
[Tue Dec 28 19:47:15 2004] [error] tables successfully created -
retrying query
[Tue Dec 28 19:47:15 2004] [notice] query successful after table
creation

Corresponds to

Dec 28 19:47:31 comox /kernel: pid 41673 (httpd), uid 80: exited on
signal 4


Signal 11s come from

[Tue Dec 28 19:54:02 2004] [notice] db reconnect successful
[Tue Dec 28 19:54:02 2004] [error] second attempt failed
[Tue Dec 28 19:54:02 2004] [notice] db reconnect successful
[Tue Dec 28 19:54:02 2004] [error] second attempt failed
[Tue Dec 28 19:54:02 2004] [notice] db reconnect successful
[Tue Dec 28 19:54:02 2004] [error] second attempt failed
[Tue Dec 28 19:54:03 2004] [notice] child pid 42022 exit signal
Segmentation fault (11)
[Tue Dec 28 19:54:03 2004] [notice] child pid 41970 exit signal
Segmentation fault (11)
[Tue Dec 28 19:54:03 2004] [notice] child pid 41956 exit signal
Segmentation fault (11)

When it's set to LogSQLMassVirtualHosting Off, the errors don't occur

-----BEGIN PGP SIGNATURE-----
Version: PGP 8.1

iQA/AwUBQdG9i1UyB+ajXkCLEQKDewCfRwW3AYEda+Vpdjpe5AJbCHIFeXQAn1VI
gYYQ9NJ3kA86gEnGzRjTy2JZ
=CmCd
-----END PGP SIGNATURE-----

_______________________________________________
Download the latest version at
http://www.outoforder.cc/projects/apache/mod_log_sql/

To unsubscribe send an e-mail to
mod_log_sql-unsubscribe-7qY7E20V6GW73k+5HYS8LQqVMODqnSLI@xxxxxxxxxxxxxxxx



<Prev in Thread] Current Thread [Next in Thread>
Google Custom Search

Recently Viewed:
version-control...    qnx.openqnx.dev...    redhat.rhn.user...    ietf.openpgp/20...    mail.mutt.user/...    web.microformat...    java.sync4j.use...    education.ezpro...    user-groups.blu...    solaris.manager...    org.fitug.debat...    technology.erps...    politics.activi...    linux.redhat.fe...    bug-tracking.ma...    xfce.user/2004-...    hams/2004-11/ms...    kde.users.pim/2...    culture.cooking...    freebsd.devel.x...    gnu.m4.adhoc/20...    ngpt.user/2002-...    apple.fink.deve...   
Home | advertise | OSDir is an inevitable website. super tiny logo

Free Magazines

Cisco News
Receive a free quarterly e-newsletter with exclusive articles on how Cisco IT uses its own products and solutions to enable the business.
subscribe

Systems Management News, the newspaper for IT systems administration and data center managers! Each issue of Systems Management News is chock-full of news and analysis to help you understand what's happening in your field.
subscribe

The Enterprise Newsweekly eWeek is the essential technology information source for builders of e-business.
subscribe

Oracle Magazine Oracle Magazine contains technology strategy articles, sample code, tips, Oracle and partner news, how to articles for developers and DBAs, and more. Oracle (NASDAQ: ORCL) is the world's largest enterprise software company.
subscribe

Total Telecom Total Telecom is "The Economist of the communications industry".
subscribe

Navigation