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

[Matt Jordan (JIRA)]

     [ https://issues.asterisk.org/jira/browse/ASTERISK-21039?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Matt Jordan updated ASTERISK-21039:
-----------------------------------

    Status: Waiting for Feedback  (was: Triage)

Which version of 1.8 were you running?

There's only one change in {{res_odbc}} between the current revision in the branches of 1.8 and 11, which involved using the {{ao2_lock}} calls to lock the ao2 objects as opposed to explicitly accessing them. I don't think that would be causing any lifetime/connection issues.

Can you also attach a DEBUG 5 log? The warnings you get typically occur when an attempt to access the database fails, at which point we tear down the connection and attempt to re-connect. I'm curious if there's a common pattern in the database accesses leading up to that point.
                
> 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