<div dir="ltr">There are some params on confluence that show how to optimize the mysql.<div>We don't like evangelizing one or the other technology but ya, postgres was at least better at threading when we first added db support many years ago.</div><div><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Fri, Jun 8, 2018 at 4:12 PM, Geoff Mina <span dir="ltr"><<a href="mailto:gmina@connectfirst.com" target="_blank">gmina@connectfirst.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Would you guys suggest switching to Postgres on the back-end? I am guessing if there are known MySQL issues, the suggestion is probably native PGSQL?</div><div class="HOEnZb"><div class="h5"><br><div class="gmail_quote"><div dir="ltr">On Fri, Jun 8, 2018 at 2:48 PM Anthony Minessale <<a href="mailto:anthony.minessale@gmail.com" target="_blank">anthony.minessale@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">You would need to do a thread apply all bt to see what the other threads are doing. The thread you posted is stuck on a mutex waiting for something else, probably your DB in another thread.<div>If you do get that info file it to jira because its easier to deal with backtraces there.</div><div><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Fri, Jun 8, 2018 at 12:04 PM, Geoff Mina <span dir="ltr"><<a href="mailto:gmina@connectfirst.com" target="_blank">gmina@connectfirst.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Greetings,<div>Has anyone seen an instance where freeswitch gets hung with the following stack trace? I have about 400 threads in this state and eventually FS (1.6.19) just stops responding. </div><div><br></div><div>I am running FS against MySQL 5.6.38 on CentOS using ODBC. Guessing if this is known, it probably isn't fixed in 1.6.20... but I can hope. Any input on what a possible solution would be greatly appreciated. The MySQL server and FS are running on the same host connecting via localhost interface, so it's not a networking issue.</div><div><br></div><div><div>Thread 445 (Thread 0x7fa2df6db700 (LWP 9395)):</div><div>#0 0x00007fa3712da42d in __lll_lock_wait () from /usr/lib64/libpthread.so.0</div><div>#1 0x00007fa3712d5de6 in _L_lock_870 () from /usr/lib64/libpthread.so.0</div><div>#2 0x00007fa3712d5cdf in pthread_mutex_lock () from /usr/lib64/libpthread.so.0</div><div>#3 0x00007fa35742468a in sofia_glue_execute_sql_<wbr>callback () from /usr/lib64/freeswitch/mod/mod_<wbr>sofia.so</div><div>#4 0x00007fa3573df231 in select_from_profile () from /usr/lib64/freeswitch/mod/mod_<wbr>sofia.so</div><div>#5 0x00007fa3573e3b17 in sofia_contact_function () from /usr/lib64/freeswitch/mod/mod_<wbr>sofia.so</div><div>#6 0x00007fa3730594cc in switch_api_execute () from /usr/lib64/libfreeswitch.so.1</div><div>#7 0x00007fa372fe69d6 in switch_channel_expand_<wbr>variables_check () from /usr/lib64/libfreeswitch.so.1</div><div>#8 0x00007fa3552d45e4 in user_outgoing_channel () from /usr/lib64/freeswitch/mod/mod_<wbr>dptools.so</div><div>#9 0x00007fa37300b42a in switch_core_session_outgoing_<wbr>channel () from /usr/lib64/libfreeswitch.so.1</div><div>#10 0x00007fa37308dc3b in switch_ivr_originate () from /usr/lib64/libfreeswitch.so.1</div><div>#11 0x00007fa3552db0b5 in audio_bridge_function () from /usr/lib64/freeswitch/mod/mod_<wbr>dptools.so</div><div>#12 0x00007fa37300ebcb in switch_core_session_exec () from /usr/lib64/libfreeswitch.so.1</div><div>#13 0x00007fa37300f179 in switch_core_session_execute_<wbr>application_get_flags () from /usr/lib64/libfreeswitch.so.1</div><div>#14 0x00007fa373012a34 in switch_core_session_run () from /usr/lib64/libfreeswitch.so.1</div><div>#15 0x00007fa37300c33e in switch_core_session_thread () from /usr/lib64/libfreeswitch.so.1</div><div>#16 0x00007fa373007d83 in switch_core_session_thread_<wbr>pool_worker () from /usr/lib64/libfreeswitch.so.1</div><div>#17 0x00007fa3732ce7c0 in dummy_worker () from /usr/lib64/libfreeswitch.so.1</div><div>#18 0x00007fa3712d3e25 in start_thread () from /usr/lib64/libpthread.so.0</div><div>#19 0x00007fa37092e34d in clone () from /usr/lib64/libc.so.6</div></div><div><br></div></div>
<br>______________________________<wbr>______________________________<wbr>_____________<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/<wbr>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.<wbr>freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" rel="noreferrer" target="_blank">http://lists.freeswitch.org/<wbr>mailman/listinfo/freeswitch-<wbr>users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" rel="noreferrer" target="_blank">http://lists.<wbr>freeswitch.org/mailman/<wbr>options/freeswitch-users</a><br>
<a href="https://freeswitch.com" rel="noreferrer" target="_blank">https://freeswitch.com</a><br></blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="m_1517799069579562737m_3619534978507100116gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr">Anthony Minessale II</div><div dir="ltr">Founder, FreeSWITCH.</div><div dir="ltr"><div><a href="http://freeswitch.com" target="_blank">http://freeswitch.com</a></div><div><br></div><div><br></div><div><span style="font-size:12.8px"><a href="https://youtu.be/l_hOxzCt6X4" target="_blank">https://youtu.be/l_hOxzCt6X4</a></span><br></div><div><a href="https://www.youtube.com/watch?v=oAxXgyx5jUw" target="_blank">https://www.youtube.com/watch?<wbr>v=oAxXgyx5jUw</a><br></div><div><a href="https://www.youtube.com/watch?v=9XXgW34t40s" style="color:rgb(17,85,204);font-size:12.8000001907349px" target="_blank">https://www.youtube.com/watch?<wbr>v=9XXgW34t40s</a></div><div><a href="https://www.youtube.com/watch?v=NLaDpGQuZDA" target="_blank">https://www.youtube.com/watch?<wbr>v=NLaDpGQuZDA</a><br></div></div></div></div></div></div></div></div></div>
</div>
______________________________<wbr>______________________________<wbr>_____________<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/<wbr>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.<wbr>freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" rel="noreferrer" target="_blank">http://lists.freeswitch.org/<wbr>mailman/listinfo/freeswitch-<wbr>users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" rel="noreferrer" target="_blank">http://lists.<wbr>freeswitch.org/mailman/<wbr>options/freeswitch-users</a><br>
<a href="https://freeswitch.com" rel="noreferrer" target="_blank">https://freeswitch.com</a></blockquote></div>
</div></div><br>______________________________<wbr>______________________________<wbr>_____________<br>
Professional FreeSWITCH Services<br>
<a href="mailto:sales@freeswitch.com">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/<wbr>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">FreeSWITCH-users@lists.<wbr>freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" rel="noreferrer" target="_blank">http://lists.freeswitch.org/<wbr>mailman/listinfo/freeswitch-<wbr>users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" rel="noreferrer" target="_blank">http://lists.<wbr>freeswitch.org/mailman/<wbr>options/freeswitch-users</a><br>
<a href="https://freeswitch.com" rel="noreferrer" target="_blank">https://freeswitch.com</a><br></blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr">Anthony Minessale II</div><div dir="ltr">Founder, FreeSWITCH.</div><div dir="ltr"><div><a href="http://freeswitch.com" target="_blank">http://freeswitch.com</a></div><div><br></div><div><br></div><div><span style="font-size:12.8px"><a href="https://youtu.be/l_hOxzCt6X4" target="_blank">https://youtu.be/l_hOxzCt6X4</a></span><br></div><div><a href="https://www.youtube.com/watch?v=oAxXgyx5jUw" target="_blank">https://www.youtube.com/watch?v=oAxXgyx5jUw</a><br></div><div><a href="https://www.youtube.com/watch?v=9XXgW34t40s" style="color:rgb(17,85,204);font-size:12.8000001907349px" target="_blank">https://www.youtube.com/watch?v=9XXgW34t40s</a></div><div><a href="https://www.youtube.com/watch?v=NLaDpGQuZDA" target="_blank">https://www.youtube.com/watch?v=NLaDpGQuZDA</a><br></div></div></div></div></div></div></div></div></div>
</div>