[Freeswitch-users] Hung Sofia Profile

Wed Jun 13 22:42:44 UTC 2018

Thanks.  I was assuming it was the ODBC driver since MySQL itself isn't
prone to deadlocks.

We have switched all of our backends to PostgreSQL as of last week.  So far
so good.

On Wed, Jun 13, 2018 at 4:31 PM Giovanni Maruzzelli <gmaruzz at gmail.com>
wrote:

> On Sat, Jun 9, 2018, 02:12 Geoff Mina <gmina at connectfirst.com> wrote:
>
>> 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?
>>
>
>
> Problem is with the odbc driver.
>
>  So, short answer is: yes, definitely go with postgresql native support
>
>
> -giovanni
>
>
>
>> On Fri, Jun 8, 2018 at 2:48 PM Anthony Minessale <
>> anthony.minessale at gmail.com> wrote:
>>
>>> 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.
>>> If you do get that info file it to jira because its easier to deal with
>>> backtraces there.
>>>
>>>
>>> On Fri, Jun 8, 2018 at 12:04 PM, Geoff Mina <gmina at connectfirst.com>
>>> wrote:
>>>
>>>> Greetings,
>>>> 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.
>>>>
>>>> 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.
>>>>
>>>> Thread 445 (Thread 0x7fa2df6db700 (LWP 9395)):
>>>> #0  0x00007fa3712da42d in __lll_lock_wait () from
>>>> /usr/lib64/libpthread.so.0
>>>> #1  0x00007fa3712d5de6 in _L_lock_870 () from /usr/lib64/libpthread.so.0
>>>> #2  0x00007fa3712d5cdf in pthread_mutex_lock () from
>>>> /usr/lib64/libpthread.so.0
>>>> #3  0x00007fa35742468a in sofia_glue_execute_sql_callback () from
>>>> /usr/lib64/freeswitch/mod/mod_sofia.so
>>>> #4  0x00007fa3573df231 in select_from_profile () from
>>>> /usr/lib64/freeswitch/mod/mod_sofia.so
>>>> #5  0x00007fa3573e3b17 in sofia_contact_function () from
>>>> /usr/lib64/freeswitch/mod/mod_sofia.so
>>>> #6  0x00007fa3730594cc in switch_api_execute () from
>>>> /usr/lib64/libfreeswitch.so.1
>>>> #7  0x00007fa372fe69d6 in switch_channel_expand_variables_check () from
>>>> /usr/lib64/libfreeswitch.so.1
>>>> #8  0x00007fa3552d45e4 in user_outgoing_channel () from
>>>> /usr/lib64/freeswitch/mod/mod_dptools.so
>>>> #9  0x00007fa37300b42a in switch_core_session_outgoing_channel () from
>>>> /usr/lib64/libfreeswitch.so.1
>>>> #10 0x00007fa37308dc3b in switch_ivr_originate () from
>>>> /usr/lib64/libfreeswitch.so.1
>>>> #11 0x00007fa3552db0b5 in audio_bridge_function () from
>>>> /usr/lib64/freeswitch/mod/mod_dptools.so
>>>> #12 0x00007fa37300ebcb in switch_core_session_exec () from
>>>> /usr/lib64/libfreeswitch.so.1
>>>> #13 0x00007fa37300f179 in
>>>> switch_core_session_execute_application_get_flags () from
>>>> /usr/lib64/libfreeswitch.so.1
>>>> #14 0x00007fa373012a34 in switch_core_session_run () from
>>>> /usr/lib64/libfreeswitch.so.1
>>>> #15 0x00007fa37300c33e in switch_core_session_thread () from
>>>> /usr/lib64/libfreeswitch.so.1
>>>> #16 0x00007fa373007d83 in switch_core_session_thread_pool_worker ()
>>>> from /usr/lib64/libfreeswitch.so.1
>>>> #17 0x00007fa3732ce7c0 in dummy_worker () from
>>>> /usr/lib64/libfreeswitch.so.1
>>>> #18 0x00007fa3712d3e25 in start_thread () from
>>>> /usr/lib64/libpthread.so.0
>>>> #19 0x00007fa37092e34d in clone () from /usr/lib64/libc.so.6
>>>>
>>>>
>>>>
>>>> _________________________________________________________________________
>>>> Professional FreeSWITCH Services
>>>> sales at freeswitch.com
>>>> https://freeswitch.com
>>>>
>>>> Official FreeSWITCH Sites
>>>> https://freeswitch.com/oss
>>>> https://freeswitch.org/confluence
>>>> https://cluecon.com
>>>>
>>>> FreeSWITCH-users mailing list
>>>> FreeSWITCH-users at lists.freeswitch.org
>>>> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>>>> UNSUBSCRIBE:
>>>> http://lists.freeswitch.org/mailman/options/freeswitch-users
>>>> https://freeswitch.com
>>>>
>>>
>>>
>>>
>>> --
>>> Anthony Minessale II
>>> Founder, FreeSWITCH.
>>> http://freeswitch.com
>>>
>>>
>>> https://youtu.be/l_hOxzCt6X4
>>> https://www.youtube.com/watch?v=oAxXgyx5jUw
>>> https://www.youtube.com/watch?v=9XXgW34t40s
>>> https://www.youtube.com/watch?v=NLaDpGQuZDA
>>> _________________________________________________________________________
>>> Professional FreeSWITCH Services
>>> sales at freeswitch.com
>>> https://freeswitch.com
>>>
>>> Official FreeSWITCH Sites
>>> https://freeswitch.com/oss
>>> https://freeswitch.org/confluence
>>> https://cluecon.com
>>>
>>> FreeSWITCH-users mailing list
>>> FreeSWITCH-users at lists.freeswitch.org
>>> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>>> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
>>> https://freeswitch.com
>>
>> _________________________________________________________________________
>> Professional FreeSWITCH Services
>> sales at freeswitch.com
>> https://freeswitch.com
>>
>> Official FreeSWITCH Sites
>> https://freeswitch.com/oss
>> https://freeswitch.org/confluence
>> https://cluecon.com
>>
>> FreeSWITCH-users mailing list
>> FreeSWITCH-users at lists.freeswitch.org
>> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
>> https://freeswitch.com
>
> _________________________________________________________________________
> Professional FreeSWITCH Services
> sales at freeswitch.com
> https://freeswitch.com
>
> Official FreeSWITCH Sites
> https://freeswitch.com/oss
> https://freeswitch.org/confluence
> https://cluecon.com
>
> FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> https://freeswitch.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20180613/db9ce906/attachment-0001.html>