[Freeswitch-users] Hung Sofia Profile

Sat Jun 9 06:11:29 UTC 2018

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20180609/d78a0d5c/attachment-0001.html>