<html><head><meta http-equiv="Content-Type" content="text/html; charset=us-ascii"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">the history of issues is in the client and odbc drivers, yes.<div class=""><br class=""></div><div class="">Mike</div><div class=""><br class=""><div class=""><div class=""><div><br class=""><blockquote type="cite" class=""><div class="">On Jun 13, 2018, at 6:42 PM, Geoff Mina <<a href="mailto:gmina@connectfirst.com" class="">gmina@connectfirst.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div dir="ltr" class="">Thanks. I was assuming it was the ODBC driver since MySQL itself isn't prone to deadlocks.<div class=""><br class=""></div><div class="">We have switched all of our backends to PostgreSQL as of last week. So far so good.</div></div><br class=""><div class="gmail_quote"><div dir="ltr" class="">On Wed, Jun 13, 2018 at 4:31 PM Giovanni Maruzzelli <<a href="mailto:gmaruzz@gmail.com" class="">gmaruzz@gmail.com</a>> wrote:<br class=""></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="auto" class=""><div class=""><div class="gmail_quote"><div dir="ltr" class="">On Sat, Jun 9, 2018, 02:12 Geoff Mina <<a href="mailto:gmina@connectfirst.com" target="_blank" class="">gmina@connectfirst.com</a>> wrote:<br class=""></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr" class="">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></blockquote></div></div><div dir="auto" class=""><br class=""></div><div dir="auto" class=""><br class=""></div><div dir="auto" class="">Problem is with the odbc driver.</div><div dir="auto" class=""><br class=""></div><div dir="auto" class=""> So, short answer is: yes, definitely go with postgresql native support</div><div dir="auto" class=""><br class=""></div><div dir="auto" class=""><br class=""></div><div dir="auto" class="">-giovanni</div><div dir="auto" class=""><br class=""></div><div dir="auto" class=""><br class=""></div><div dir="auto" class=""><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><br class=""><div class="gmail_quote"><div dir="ltr" class="">On Fri, Jun 8, 2018 at 2:48 PM Anthony Minessale <<a href="mailto:anthony.minessale@gmail.com" rel="noreferrer" target="_blank" class="">anthony.minessale@gmail.com</a>> wrote:<br class=""></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr" class="">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 class="">If you do get that info file it to jira because its easier to deal with backtraces there.</div><div class=""><br class=""></div></div><div class="gmail_extra"><br class=""><div class="gmail_quote">On Fri, Jun 8, 2018 at 12:04 PM, Geoff Mina <span dir="ltr" class=""><<a href="mailto:gmina@connectfirst.com" rel="noreferrer" target="_blank" class="">gmina@connectfirst.com</a>></span> wrote:<br class=""><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr" class="">Greetings,<div class="">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 class=""><br class=""></div><div class="">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 class=""><br class=""></div><div class=""><div class="">Thread 445 (Thread 0x7fa2df6db700 (LWP 9395)):</div><div class="">#0 0x00007fa3712da42d in __lll_lock_wait () from /usr/lib64/libpthread.so.0</div><div class="">#1 0x00007fa3712d5de6 in _L_lock_870 () from /usr/lib64/libpthread.so.0</div><div class="">#2 0x00007fa3712d5cdf in pthread_mutex_lock () from /usr/lib64/libpthread.so.0</div><div class="">#3 0x00007fa35742468a in sofia_glue_execute_sql_callback () from /usr/lib64/freeswitch/mod/mod_sofia.so</div><div class="">#4 0x00007fa3573df231 in select_from_profile () from /usr/lib64/freeswitch/mod/mod_sofia.so</div><div class="">#5 0x00007fa3573e3b17 in sofia_contact_function () from /usr/lib64/freeswitch/mod/mod_sofia.so</div><div class="">#6 0x00007fa3730594cc in switch_api_execute () from /usr/lib64/libfreeswitch.so.1</div><div class="">#7 0x00007fa372fe69d6 in switch_channel_expand_variables_check () from /usr/lib64/libfreeswitch.so.1</div><div class="">#8 0x00007fa3552d45e4 in user_outgoing_channel () from /usr/lib64/freeswitch/mod/mod_dptools.so</div><div class="">#9 0x00007fa37300b42a in switch_core_session_outgoing_channel () from /usr/lib64/libfreeswitch.so.1</div><div class="">#10 0x00007fa37308dc3b in switch_ivr_originate () from /usr/lib64/libfreeswitch.so.1</div><div class="">#11 0x00007fa3552db0b5 in audio_bridge_function () from /usr/lib64/freeswitch/mod/mod_dptools.so</div><div class="">#12 0x00007fa37300ebcb in switch_core_session_exec () from /usr/lib64/libfreeswitch.so.1</div><div class="">#13 0x00007fa37300f179 in switch_core_session_execute_application_get_flags () from /usr/lib64/libfreeswitch.so.1</div><div class="">#14 0x00007fa373012a34 in switch_core_session_run () from /usr/lib64/libfreeswitch.so.1</div><div class="">#15 0x00007fa37300c33e in switch_core_session_thread () from /usr/lib64/libfreeswitch.so.1</div><div class="">#16 0x00007fa373007d83 in switch_core_session_thread_pool_worker () from /usr/lib64/libfreeswitch.so.1</div><div class="">#17 0x00007fa3732ce7c0 in dummy_worker () from /usr/lib64/libfreeswitch.so.1</div><div class="">#18 0x00007fa3712d3e25 in start_thread () from /usr/lib64/libpthread.so.0</div><div class="">#19 0x00007fa37092e34d in clone () from /usr/lib64/libc.so.6</div></div></div></blockquote></div></div></blockquote></div></blockquote></div></div></div></blockquote></div></div></blockquote></div><br class=""></div></div></div></body></html>