Uploaded image for project: 'FreeSWITCH'
  1. FreeSWITCH
  2. FS-9691

Hung in mutex when accessing SQL database via ODBC

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 1.6.12
    • Fix Version/s: 1.8
    • Component/s: core
    • Security Level: public
    • Labels:
      None
    • Environment:
      Centos 7.2.1511, physical machine
    • CPU Architecture:
      x86-64
    • Kernel:
      Linux
    • uname:
      Linux pbx-gr.huji.ac.il 3.10.0-327.36.3.el7.x86_64 #1 SMP Mon Oct 24 16:09:20 UTC 2016 x86_64 x86_64 x86_64 GNU/Linux
    • Userland:
      GNU/Linux
    • Distribution:
      CentOS
    • Distribution Version:
      CentOS 7
    • lsb_release:
      Hide
      core-4.1-amd64:core-4.1-noarch:cxx-4.1-amd64:cxx-4.1-noarch:desktop-4.1-amd64:desktop-4.1-noarch:languages-4.1-amd64:languages-4.1-noarch:printing-4.1-amd64:printing-4.1-noarch
      Show
      core-4.1-amd64:core-4.1-noarch:cxx-4.1-amd64:cxx-4.1-noarch:desktop-4.1-amd64:desktop-4.1-noarch:languages-4.1-amd64:languages-4.1-noarch:printing-4.1-amd64:printing-4.1-noarch
    • Compiler:
      gcc
    • Compiler Version:
      gcc version 4.8.5 20150623 (Red Hat 4.8.5-4) (GCC)
    • FreeSWITCH GIT Revision:
      Release 1.6.12
    • GIT Master Revision hash::
      1.6.12
    • Target Version:
      1.8

      Description

      From time to time (might be once every few days or a few times a day) FreeSwitch gets hung. Attached is an output of gcore, from which I undertstand that it is hung in Mutex lock to access SQL database.

      The problem is not reproduceable at will, and happens only on the production machine.

      The only way to get out of it is to shutdown and restart Freeswitch.

      All core databases and our databases are accessed to a local MariaDB database via ODBC.

      Thanks!

        Activity

        Hide
        yehavi Yehavi Bourvine added a comment -
        I've downloaded it and will install it on Sunday and let it run for a week. If I am quiet, it means no problems yet...

                       Thanks, __Yehavi:
        Show
        yehavi Yehavi Bourvine added a comment - I've downloaded it and will install it on Sunday and let it run for a week. If I am quiet, it means no problems yet...                Thanks, __Yehavi:
        Hide
        mikej Mike Jerris added a comment -
        Please make sure to chime in with what testing you have done once its completed
        Show
        mikej Mike Jerris added a comment - Please make sure to chime in with what testing you have done once its completed
        Hide
        mikej Mike Jerris added a comment -
        any results yet? we are going to pull a release probably tomorrow and I'd like to get it in
        Show
        mikej Mike Jerris added a comment - any results yet? we are going to pull a release probably tomorrow and I'd like to get it in
        Hide
        yehavi Yehavi Bourvine added a comment -
        4 full working days and not a problem.

        Please leave this ticket open for one more week, but it looks stable at the moment.

               Thanks! __Yehavi:
        Show
        yehavi Yehavi Bourvine added a comment - 4 full working days and not a problem. Please leave this ticket open for one more week, but it looks stable at the moment.        Thanks! __Yehavi:
        Hide
        yehavi Yehavi Bourvine added a comment -
        One more day passing quietly.
        Since our working week is Sunday-Thursday I'll update next Thursday (hopefully I won't have an update before :-)).

        Thanks for your help! __Yehavi:
        Show
        yehavi Yehavi Bourvine added a comment - One more day passing quietly. Since our working week is Sunday-Thursday I'll update next Thursday (hopefully I won't have an update before :-)). Thanks for your help! __Yehavi:

          People

          • Assignee:
            mikej Mike Jerris
            Reporter:
            yehavi Yehavi Bourvine
          • Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development