<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Verdana
}
--></style>
</head>
<body class='hmmessage'>
<br>I have tried to use strace, and this is what is reported:<br><br><font style="" face="Courier New">15:16:09.221845 execve("/opt/syslog-ng/sbin/syslog-ng", ["/opt/syslog-ng/sbin/syslog-ng", "-f", "/opt/syslog-ng/etc/syslog-ng.conf"], [/* 16 vars */]) = 0</font><font style="" face="Courier New"><br></font><font style="" face="Courier New">15:16:09.232664 brk(0) = 0x83e2000</font><font style="" face="Courier New"><br></font><font style="" face="Courier New">15:16:09.232971 access("/etc/ld.so.nohwcap", F_OK) = -1 ENOENT (No such file or directory)</font><font style="" face="Courier New"><br></font><font style="" face="Courier New">15:16:09.233274 mmap2(NULL, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0xb801d000</font><font style="" face="Courier New"><br></font><font style="" face="Courier New">15:16:09.233520 access("/etc/ld.so.preload", R_OK) = -1 ENOENT (No such file or directory)</font><font style="" face="Courier New"><br></font><font style="" face="Courier New">15:16:09.233717 open("/opt/syslog-ng/lib/tls/i686/sse2/cmov/libc.so.6", O_RDONLY) = -1 ENOENT (No such file or directory)</font><font style="" face="Courier New"><br></font><font style="" face="Courier New">15:16:09.236940 stat64("/opt/syslog-ng/lib/tls/i686/sse2/cmov", 0xbf83a9e0) = -1 ENOENT (No such file or directory)</font><font style="" face="Courier New"><br></font><font style="" face="Courier New">15:16:09.237178 open("/opt/syslog-ng/lib/tls/i686/sse2/libc.so.6", O_RDONLY) = -1 ENOENT (No such file or directory</font><font style="" face="Courier New"><br><br><br><font style="" face="Verdana">and it is looping with these error messages:<br><font style="" face="Courier New">15:16:09.237751 stat64("/opt/syslog-ng/lib/tls/i686/cmov", 0xbf83a9e0) = -1 ENOENT (No such file or directory)</font><font style="" face="Courier New"><br></font><font style="" face="Courier New">15:16:09.237930 open("/opt/syslog-ng/lib/tls/i686/libc.so.6", O_RDONLY) = -1 ENOENT (No such file or directory)</font><font style="" face="Courier New"><br></font><font style="" face="Courier New">15:16:09.238125 stat64("/opt/syslog-ng/lib/tls/i686", 0xbf83a9e0) = -1 ENOENT (No such file or directory)</font><font style="" face="Courier New"><br></font><font style="" face="Courier New">15:16:09.238296 open("/opt/syslog-ng/lib/tls/sse2/cmov/libc.so.6", O_RDONLY) = -1 ENOENT (No such file or directory)</font><font style="" face="Courier New"><br></font><font style="" face="Courier New">15:16:09.238488 stat64("/opt/syslog-ng/lib/tls/sse2/cmov", 0xbf83a9e0) = -1 ENOENT (No such file or directory)</font><br><br><br>On my Linux box there is no /etc/ld.so.nohwcap, and there is no "tls" path under the "lib" path of syslog-ng<br><br>I have used the compiled version of syslog-ng<br><br><font style="" face="Courier New">./syslog-ng -V</font><font style="" face="Courier New"><br></font><font style="" face="Courier New">syslog-ng 3.0.4</font><font style="" face="Courier New"><br></font><font style="" face="Courier New">Revision: ssh+git://bazsi@git.balabit//var/scm/git/syslog-ng/syslog-ng-ose--mainline--3.0#master#1b5d618e301ad94aa20e692ffba16469dece8d10</font><font style="" face="Courier New"><br></font><font style="" face="Courier New">Compile-Date: Aug 5 2009 17:38:20</font><font style="" face="Courier New"><br></font><font style="" face="Courier New">Enable-Threads: on</font><font style="" face="Courier New"><br></font><font style="" face="Courier New">Enable-Debug: off</font><font style="" face="Courier New"><br></font><font style="" face="Courier New">Enable-GProf: off</font><font style="" face="Courier New"><br></font><font style="" face="Courier New">Enable-Memtrace: off</font><font style="" face="Courier New"><br></font><font style="" face="Courier New">Enable-Sun-STREAMS: off</font><font style="" face="Courier New"><br></font><font style="" face="Courier New">Enable-Sun-Door: off</font><font style="" face="Courier New"><br></font><font style="" face="Courier New">Enable-IPv6: on</font><font style="" face="Courier New"><br></font><font style="" face="Courier New">Enable-Spoof-Source: on</font><font style="" face="Courier New"><br></font><font style="" face="Courier New">Enable-TCP-Wrapper: off</font><font style="" face="Courier New"><br></font><font style="" face="Courier New">Enable-SSL: on</font><font style="" face="Courier New"><br></font><font style="" face="Courier New">Enable-SQL: on</font><font style="" face="Courier New"><br></font><font style="" face="Courier New">Enable-Linux-Caps: on</font><font style="" face="Courier New"><br></font><font style="" face="Courier New">Enable-Pcre: off</font><font style="" face="Courier New"><br></font><font style="" face="Courier New"><br></font>Thank you<br><br></font></font><br>> ----------------------------------------------------------------------<br>> <br>> Message: 1<br>> Date: Wed, 7 Oct 2009 11:36:17 +0200<br>> From: Sandor Geller <Sandor.Geller@morganstanley.com><br>> Subject: Re: [syslog-ng] syslog-ng with sql() command, cpu to 100%<br>> To: "Syslog-ng users' and developers' mailing list"<br>> <syslog-ng@lists.balabit.hu><br>> Message-ID:<br>> <edabd2010910070236h460880edp4e824905927d9883@mail.gmail.com><br>> Content-Type: text/plain; charset=ISO-8859-1<br>> <br>> Hi,<br>> <br>> > it seems that the sql() statement go in loop;<br>> ><br>> > where is the error?<br>> <br>> Could you attach strace on syslog-ng, preferably restarting syslog-ng<br>> under strace? Something like<br>> <br>> strace -ff -tt -s 128 -p <PID of running syslog-ng> -o syslogstrace<br>> <br>> In the resulting files you could either find the cause of the problem,<br>> or you could send us some details about what's going on.<br>> <br>> Regards,<br>> <br>> Sandor<br>> <br>> <br>> ------------------------------<br>> <br>> _______________________________________________<br>> syslog-ng maillist - syslog-ng@lists.balabit.hu<br>> https://lists.balabit.hu/mailman/listinfo/syslog-ng<br>> <br>> <br>> End of syslog-ng Digest, Vol 54, Issue 7<br>> ****************************************<br> <br /><hr />Una risposta istantanea? <a href='http://www.messenger.it/accediWebMessengerHotmail.aspx' target='_new'>Usa Messenger da Hotmail</a></body>
</html>