<html><head><meta http-equiv="Content-Type" content="text/html; charset=us-ascii"><meta name="Generator" content="Microsoft Word 14 (filtered medium)"><title>Re: [Freeswitch-users] CPU Spikes every 20 minutes</title><style><!--
/* Font Definitions */
@font-face
        {font-family:Calibri;
        panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
        {font-family:Tahoma;
        panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
        {margin:0cm;
        margin-bottom:.0001pt;
        font-size:12.0pt;
        font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
        {mso-style-priority:99;
        color:blue;
        text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
        {mso-style-priority:99;
        color:purple;
        text-decoration:underline;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
        {mso-style-priority:99;
        mso-style-link:"Texto de globo Car";
        margin:0cm;
        margin-bottom:.0001pt;
        font-size:8.0pt;
        font-family:"Tahoma","sans-serif";}
span.TextodegloboCar
        {mso-style-name:"Texto de globo Car";
        mso-style-priority:99;
        mso-style-link:"Texto de globo";
        font-family:"Tahoma","sans-serif";}
span.EstiloCorreo19
        {mso-style-type:personal-reply;
        font-family:"Calibri","sans-serif";
        color:#1F497D;}
.MsoChpDefault
        {mso-style-type:export-only;
        font-size:10.0pt;}
@page WordSection1
        {size:612.0pt 792.0pt;
        margin:70.85pt 3.0cm 70.85pt 3.0cm;}
div.WordSection1
        {page:WordSection1;}
--></style></head><body lang="ES-CL" link="blue" vlink="purple"><div class="WordSection1"><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Hi Ken.</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Maybe that is the problem. I was sure that the “load average” can’t go more than #cores in your system. In my case I have 8 cores, so a “load average” of 12 is high from my point of view. Where did you get the number 100 for this parameter?</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Anyway, what is running a sqlite in freeswitch. Does this have to do with the core.db file? Or with the cdr_sqlite module?.</span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> </span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Thanks</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Ricardo.-</span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"> </span></p>
<div><div style="border:none;border-top:solid #b5c4df 1.0pt;padding:3.0pt 0cm 0cm 0cm"><p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">De:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> <a href="mailto:freeswitch-users-bounces@lists.freeswitch.org">freeswitch-users-bounces@lists.freeswitch.org</a> [mailto:<a href="mailto:freeswitch-users-bo">freeswitch-users-bo</a></span><span lang="ES" style="font-size:10.0pt;font-family:"Tahoma","sans-serif""><a href="mailto:unces@lists.freeswitch.org">unces@lists.freeswitch.org</a>] <b>En nombre de </b>Ken Rice<br>
<b>Enviado el:</b> lunes, 22 de octubre de 2012 16:18<br><b>Para:</b> FreeSWITCH Users Help<br><b>Asunto:</b> Re: [Freeswitch-users] CPU Spikes every 20 minutes</span></p></div></div><p class="MsoNormal"> </p><p class="MsoNormal" style="margin-bottom:12.0pt">
<span style="font-size:11.0pt;font-family:"Courier New"">Could it be just a normal sqlite running a vacuum?<br><br>Sqlite does this every so often or if its calling a sync.... <br><br>Also freeswitch with a load avg of 12 for a short period of time isnt anything to really worry about. Due to the number of threads that’s possible with FS (ie: 1 per call leg) its not unusual to see a box humming along and the load avg well above 100 in my experience... This is due to the number of threads waiting in the run queue when it was sampled... Now, that’s not saying that this is not specifically indicative or a problem but something else to think about<br>
<br>On 10/22/12 1:52 PM, "Ricardo Martinez" <<a href="rmartinez@redvoiss.net">rmartinez@redvoiss.net</a>> wrote:</span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Courier New"">This is the gdb from the proccess consuming more cpu :<br>
<br>(gdb) thread 7<br>[Switching to thread 7 (Thread 31781)]#0 0x0000003c03c0e047 in fsync () from /lib64/libpthread.so.0<br>(gdb) bt<br>#0 0x0000003c03c0e047 in fsync () from /lib64/libpthread.so.0<br>#1 0x00002aede19276de in unixSync (id=0x2aaaac726380, dataOnly=<value optimized out>) at ./src/os_unix.c:1229<br>
#2 0x00002aede1951178 in syncJournal (pPager=0x1a1c200) at ./src/pager.c:2229<br>#3 0x00002aede1953b65 in sqlite3pager_sync (pPager=0x1a1c200, zMaster=0x0, nTrunc=0) at ./src/pager.c:3770<br>#4 0x00002aede193d07b in sqlite3BtreeSync (p=<value optimized out>, zMaster=0x0) at ./src/btree.c:6520<br>
#5 0x00002aede1931f15 in sqlite3VdbeHalt (p=0x2aaaad17ac70) at ./src/vdbeaux.c:1062<br>#6 0x00002aede1962613 in sqlite3VdbeExec (p=0x2aaaad17ac70) at ./src/vdbe.c:2360<br>#7 0x00002aede193036c in sqlite3Step (pStmt=0x2aaaad17ac70) at ./src/vdbeapi.c:236<br>
#8 sqlite3_step (pStmt=0x2aaaad17ac70) at ./src/vdbeapi.c:289<br>#9 0x00002aede1938978 in sqlite3_exec (db=0x1a1f070, zSql=0x2aede199e717 "COMMIT", xCallback=0, pArg=0x0, pzErrMsg=0x4178bed0)<br> at ./src/legacy.c:78<br>
#10 0x00002aede18ae0c1 in switch_core_db_exec (db=0x1a1f070, sql=0x2aede199e717 "COMMIT", callback=0, data=0x0, errmsg=0x4178bf38)<br> at src/switch_core_db.c:93<br>#11 0x00002aede1897c18 in switch_cache_db_execute_sql_real (dbh=0x1a2dce0, sql=0x2aede199e717 "COMMIT", err=0x0)<br>
at src/switch_core_sqldb.c:445<br>#12 0x00002aede18985c3 in switch_cache_db_persistant_execute_trans (dbh=0x1a2dce0, <br> sql=0x5f03bd0 "delete from calls where (caller_uuid='e64319c5-7f91-47a1-9561-42da291e499a' or callee_uuid='e64319c5-7f91-47a1-9561-42da291e499a') and hostname='<a href="http://transcoder.red.net">transcoder.red.net</a> <<a href="http://transcoder.red.net">http://transcoder.red.net</a>> ';\ndelete from calls where (call"..., retries=1)<br>
at src/switch_core_sqldb.c:787<br>#13 0x00002aede189bf1c in switch_core_sql_thread (thread=<value optimized out>, obj=<value optimized out>)<br> at src/switch_core_sqldb.c:1026<br>#14 0x0000003c03c0673d in start_thread () from /lib64/libpthread.so.0<br>
#15 0x0000003c030d3f6d in clone () from /lib64/libc.so.6<br> <br><br></span><b><span style="font-size:10.0pt;font-family:"Courier New"">De:</span></b><span style="font-size:10.0pt;font-family:"Courier New""> Ricardo Martinez [<a href="mailto:rmartinez@redvoiss.net">mailto:rmartinez@redvoiss.net</a>] <br>
<b>Enviado el:</b> lunes, 22 de octubre de 2012 15:50<br><b>Para:</b> 'FreeSWITCH Users Help'<br><b>Asunto:</b> RE: [Freeswitch-users] CPU Spikes every 20 minutes<br></span> <br><span style="font-size:11.0pt;font-family:"Courier New"">AS far as i can see there is no java running.<br>
This is the top at the moment of the spike : <br> <br>top - 15:48:29 up 17 days, 14:55, 3 users, load average: 14.07, 8.87, 6.48<br>Tasks: 158 total, 1 running, 157 sleeping, 0 stopped, 0 zombie<br>Cpu(s): 12.6%us, 9.0%sy, 0.0%ni, 66.1%id, 2.7%wa, 0.3%hi, 9.2%si, 0.0%st<br>
Mem: 8171500k total, 8041556k used, 129944k free, 177688k buffers<br>Swap: 10223608k total, 0k used, 10223608k free, 6951988k cached<br> <br> PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND <br>
31772 root 15 0 870m 481m 6880 S 212.4 6.0 9523:51 freeswitch <br> 4210 root 19 0 36344 2940 1444 S 1.0 0.0 56:21.08 sngtc_server <br>
29586 root 15 0 12740 1132 808 R 0.3 0.0 0:00.02 top <br> 1 root 15 0 10348 704 588 S 0.0 0.0 0:01.13 init <br>
2 root RT -5 0 0 0 S 0.0 0.0 0:00.41 migration/0 <br> 3 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/0 <br>
4 root RT -5 0 0 0 S 0.0 0.0 0:00.00 watchdog/0 <br> 5 root RT -5 0 0 0 S 0.0 0.0 0:00.83 migration/1 <br>
6 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/1 <br> 7 root RT -5 0 0 0 S 0.0 0.0 0:00.00 watchdog/1 <br>
8 root RT -5 0 0 0 S 0.0 0.0 0:00.14 migration/2 <br> 9 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/2 <br>
10 root RT -5 0 0 0 S 0.0 0.0 0:00.00 watchdog/2 <br> 11 root RT -5 0 0 0 S 0.0 0.0 0:00.07 migration/3 <br>
12 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/3 <br> 13 root RT -5 0 0 0 S 0.0 0.0 0:00.00 watchdog/3 <br>
14 root RT -5 0 0 0 S 0.0 0.0 0:00.06 migration/4 <br> 15 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/4 <br>
16 root RT -5 0 0 0 S 0.0 0.0 0:00.00 watchdog/4 <br> 17 root RT -5 0 0 0 S 0.0 0.0 0:00.06 migration/5 <br>
18 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/5 <br> 19 root RT -5 0 0 0 S 0.0 0.0 0:00.00 watchdog/5 <br>
20 root RT -5 0 0 0 S 0.0 0.0 0:00.07 migration/6 <br> <br> <br>Regards,<br>Ricardo.- <br> <br></span><b><span style="font-size:10.0pt;font-family:"Courier New"">De:</span></b><span style="font-size:10.0pt;font-family:"Courier New""> <a href="freeswitch-users-bounces@lists.freeswitch.org">freeswitch-users-bounces@lists.freeswitch.org</a> [<a href="mailto:freeswitch-users-bounces@lists.freeswitch.org">mailto:freeswitch-users-bounces@lists.freeswitch.org</a>] <b>En nombre de </b>Guillermo Ruiz Camauer<br>
<b>Enviado el:</b> lunes, 22 de octubre de 2012 15:38<br><b>Para:</b> FreeSWITCH Users Help<br><b>Asunto:</b> Re: [Freeswitch-users] CPU Spikes every 20 minutes<br></span> <br>Do you have anything like Java running that could be doing garbage collection?<br>
<span style="font-size:11.0pt;font-family:"Courier New""><br></span> <br><span style="font-size:11.0pt;font-family:"Courier New""><br></span>What other processes are running on the machine? Does TOP show which process is causing the spike?<br>
<span style="font-size:11.0pt;font-family:"Courier New""><br></span> <br><span style="font-size:11.0pt;font-family:"Courier New""><br></span>Guillermo<br><span style="font-size:11.0pt;font-family:"Courier New""><br>
</span>On Mon, Oct 22, 2012 at 3:29 PM, Ricardo Martinez <<a href="rmartinez@redvoiss.net">rmartinez@redvoiss.net</a>> wrote:<br>Hi Gabe.<br>I'm mean between the spikes there is nothing different as regarding to the<br>
calls... the cps maintains the same.. there are no scripts running or<br>crontabs running, the simultaneous calls are the same also. So, for some<br>reason the "load average" start to grow (every 20 or 25 minutes) without<br>
any clear cause.<br>I have debug with gdb the moment the server is with 12.5 of "load average"<br>here : <a href="http://pastebin.freeswitch.org/20112">http://pastebin.freeswitch.org/20112</a><br><br>Can we detect a problem from here?<br>
<br>Regards,<br>Ricardo.<br><br><br><br>-----Mensaje original-----<br>De: <a href="freeswitch-users-bounces@lists.freeswitch.org">freeswitch-users-bounces@lists.freeswitch.org</a><br>[<a href="mailto:freeswitch-users-bounces@lists.freeswitch.org">mailto:freeswitch-users-bounces@lists.freeswitch.org</a>] En nombre de<br>
Gabriel Gunderson<br>Enviado el: lunes, 22 de octubre de 2012 13:31<br>Para: FreeSWITCH Users Help<br>Asunto: Re: [Freeswitch-users] CPU Spikes every 20 minutes<br><span style="font-size:11.0pt;font-family:"Courier New""><br>
</span><br>On Mon, Oct 22, 2012 at 8:37 AM, Ricardo Martinez <<a href="rmartinez@redvoiss.net">rmartinez@redvoiss.net</a>><br>wrote:<br>> The problem is that I'm having weird spikes of "load average" cpu<br>
> every 20 minutes (aprox), without any reason, reaching near of 12.5 of<br>> load average for this machine.<br><br>What have you done to verify that it happens 'without any reason'?<br><br><br>Gabe<br><br>_________________________________________________________________________<br>
Professional FreeSWITCH Consulting Services:<br><a href="consulting@freeswitch.org">consulting@freeswitch.org</a><br><a href="http://www.freeswitchsolutions.com">http://www.freeswitchsolutions.com</a><br><br>FreeSWITCH-powered IP PBX: The CudaTel Communication Server<br>
<a href="http://www.cudatel.com">http://www.cudatel.com</a><br><br>Official FreeSWITCH Sites<br><a href="http://www.freeswitch.org">http://www.freeswitch.org</a><br><a href="http://wiki.freeswitch.org">http://wiki.freeswitch.org</a><br>
<a href="http://www.cluecon.com">http://www.cluecon.com</a><br><br>FreeSWITCH-users mailing list<br><a href="FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br><a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br><a href="http://www.freeswitch.org">http://www.freeswitch.org</a><br><br>
_________________________________________________________________________<br>Professional FreeSWITCH Consulting Services:<br><a href="consulting@freeswitch.org">consulting@freeswitch.org</a><br><a href="http://www.freeswitchsolutions.com">http://www.freeswitchsolutions.com</a><br>
<br>FreeSWITCH-powered IP PBX: The CudaTel Communication Server<br><a href="http://www.cudatel.com">http://www.cudatel.com</a><br><br>Official FreeSWITCH Sites<br><a href="http://www.freeswitch.org">http://www.freeswitch.org</a><br>
<a href="http://wiki.freeswitch.org">http://wiki.freeswitch.org</a><br><a href="http://www.cluecon.com">http://www.cluecon.com</a><br><br>FreeSWITCH-users mailing list<br><a href="FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org">http://www.freeswitch.org</a><br><br><br> </p><p class="MsoNormal"><br><span style="font-size:11.0pt;font-family:"Courier New"">-- <br>Ken<br><u><span style="color:blue"><a href="http://www.FreeSWITCH.org">http://www.FreeSWITCH.org</a><br>
<a href="http://www.ClueCon.com">http://www.ClueCon.com</a><br><a href="http://www.OSTAG.org">http://www.OSTAG.org</a><br></span></u><a href="http://irc.freenode.net">irc.freenode.net</a> #freeswitch</span></p></div></body></html>