[asterisk-bugs] [JIRA] (ASTERISK-21039) ODBC functions time out

[Fabian Borot (JIRA)]

Fabian Borot created ASTERISK-21039:
---------------------------------------

             Summary: ODBC functions time out
                 Key: ASTERISK-21039
                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-21039
             Project: Asterisk
          Issue Type: Information Request
      Security Level: None
          Components: Resources/res_odbc
    Affects Versions: 11.2.0
         Environment: Linux,Centos 5.7, Linux AW-ATL-CORE-01 2.6.18-274.7.1.el5 #1 SMP Thu Oct 20 16:21:01 EDT 2011 x86_64 x86_64 x86_64 GNU/Linux

            Reporter: Fabian Borot
            Severity: Critical


When calling ODBC functions in the dialplan we see time outs and several warnings like the ones shown below. This started happening when we upgraded from 1.8 to 11.2. 
We did not made any change to the OS nor to the freetds and odbc files that we use to connect to our SQL database. On the 1.8 asterisk this is not happening, same DNS, same network. 
Also when issuing the "odbc show" command on 1.8 we see up to 165 connections out of the limit of 256, on the 11.2.0 we see only 4.


I am attaching several files:
1- "res_odbc.conf" used in both asterisk versions (1.8 and 11.2.0)
2- file showing warning that show up in the asterisk console in version 11.2.0
3- file showing output of "odbc show" in both asterisk versions

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira