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

[Fabian Borot (JIRA)]

    [ https://issues.asterisk.org/jira/browse/ASTERISK-21039?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=202835#comment-202835 ] 

Fabian Borot commented on ASTERISK-21039:
-----------------------------------------

Hi, Were you able to see the attached files? thank you
                
> 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
>            Assignee: Fabian Borot
>            Severity: Critical
>         Attachments: odbc asterisk config on both versions.txt, odbc show asterisk 11.2.txt, odbc show asterisk 1.8.txt, odbc warnings in asterisk 11.2.0.txt
>
>
> 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