<div dir="ltr"><div dir="ltr">Hello Team,<div><br></div><div>Earlier we have same issue in sqlite so i decide to switch to mysql but same issue i face with mysql.</div><div><br></div><div>I dont think postgres will solved this issue. </div><div><br></div><div>Please guide other solution and how to debug this issue more. </div><div> </div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Tue, Apr 9, 2019 at 8:56 AM Alexey Sibyakin <<a href="mailto:alex@freeswitch.com">alex@freeswitch.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">Hello,<div><br></div><div>Short answer: use Postgres, MySQL/MariaDB is known to have deadlocks in threaded workloads.</div><div><br></div><div>Regards,</div><div><br></div><div>Alex</div><div><br clear="all"><div><div dir="ltr" class="gmail-m_6934379550087255540gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div><div dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt;margin-left:4.5pt"><font color="#000000" face="arial, helvetica, sans-serif" size="1"><span style="white-space:pre-wrap">Alex Sibyakin | Support Engineer
SignalWire | 228 Hamilton Ave 3rd Floor, Palo Alto, CA 94303
Email: <a href="mailto:alex@freeswitch.com" target="_blank">alex@freeswitch.com</a>
Website: <a href="https://www.signalwire.com" target="_blank">https://www.signalwire.com</a></span></font><br></div><div dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt;margin-left:4.5pt"><font color="#000000" style="font-family:HelveticaNeue,"Helvetica Neue",Helvetica,Arial,"Lucida Grande",sans-serif;color:rgb(0,0,0);font-size:12.8px"><br></font></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Tue, Apr 9, 2019 at 6:53 AM Amit Nakum <<a href="mailto:amit.nakum2009@gmail.com" target="_blank">amit.nakum2009@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div dir="ltr">Hello Team,<div><br></div><div><div>You must be a member of this list to send messages to the list.</div><div><br></div><div><br></div><div><br></div><div><br></div><div>Dear Team,</div><div><br></div><div>I am using Freeswitch 1.8.5 64 in Server version: 5.5.60-MariaDB Server. I am facing strange issue, internal sofia stop processing incoming calls, during this time I can see incoming sip packets which reach to network using ngrep command but sofia is not responding to any sip message. </div><div><br></div><div>After restarting sofia its start processing again and after few houragain it stop process sip message.</div><div><br></div><div>We have install freeswitch 1.5.5 on centos7 on vpsdime cloud server.</div><div><br></div><div>Here is output of uname -a " Linux 3.10.0-957.5.1.el7.x86_64 #1 SMP Fri Feb 1 14:54:57 UTC 2019 x86_64 x86_64 x86_64 GNU/Linux"</div><div><br></div><div>output of sed '/^$/!H;/^$/x;$!d' /proc/cpuinfo</div><div>processor : 7 </div><div>vendor_id : GenuineIntel </div><div>cpu family : 6 </div><div>model : 62 </div><div>model name : Intel(R) Xeon(R) CPU E5-2690 v2 @ 3.00GHz </div><div>stepping : 4 </div><div>microcode : 0x1 </div><div>cpu MHz : 2999.998 </div><div>cache size : 16384 KB </div><div>physical id : 0 </div><div>siblings : 8 </div><div>core id : 7 </div><div>cpu cores : 8 </div><div>apicid : 7 </div><div>initial apicid : 7 </div><div>fpu : yes </div><div>fpu_exception : yes </div><div>cpuid level : 13 </div><div>wp : yes </div><div>flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ss ht syscall nx pdpe1gb rdtscp lm constant_tsc arch_perfmon rep_good </div><div>nopl xtopology eagerfpu pni pclmulqdq ssse3 cx16 pcid sse4_1 sse4_2 x2apic popcnt tsc_deadline_timer aes xsave avx f16c rdrand hypervisor lahf_lm fsgsbase tsc_adjust smep erms xsaveopt a</div><div>rat </div><div>bogomips : 5999.99 </div><div>clflush size : 64 </div><div>cache_alignment : 64 </div><div>address sizes : 40 bits physical, 48 bits virtual </div><div>power management</div><div><br></div><div>free -g </div><div> total used free shared buff/cache available </div><div>Mem: 31 0 22 1 7 28 </div><div>Swap: 1 0 1</div><div><br></div><div><br></div><div>Concurrent calls :30</div><div><br></div><div>Please help to resolved.</div><div><br></div><div><br></div><div> </div></div></div></div>
_________________________________________________________________________<br>
Professional FreeSWITCH Services<br>
<a href="mailto:sales@freeswitch.com" target="_blank">sales@freeswitch.com</a><br>
<a href="https://freeswitch.com" rel="noreferrer" target="_blank">https://freeswitch.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="https://freeswitch.com/oss" rel="noreferrer" target="_blank">https://freeswitch.com/oss</a><br>
<a href="https://freeswitch.org/confluence" rel="noreferrer" target="_blank">https://freeswitch.org/confluence</a><br>
<a href="https://cluecon.com" rel="noreferrer" target="_blank">https://cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" rel="noreferrer" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" rel="noreferrer" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="https://freeswitch.com" rel="noreferrer" target="_blank">https://freeswitch.com</a></blockquote></div>
_________________________________________________________________________<br>
Professional FreeSWITCH Services<br>
<a href="mailto:sales@freeswitch.com" target="_blank">sales@freeswitch.com</a><br>
<a href="https://freeswitch.com" rel="noreferrer" target="_blank">https://freeswitch.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="https://freeswitch.com/oss" rel="noreferrer" target="_blank">https://freeswitch.com/oss</a><br>
<a href="https://freeswitch.org/confluence" rel="noreferrer" target="_blank">https://freeswitch.org/confluence</a><br>
<a href="https://cluecon.com" rel="noreferrer" target="_blank">https://cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org" target="_blank">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" rel="noreferrer" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" rel="noreferrer" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="https://freeswitch.com" rel="noreferrer" target="_blank">https://freeswitch.com</a></blockquote></div></div>