[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:comment-tabpanel&focusedCommentId=203962#comment-203962 ] 

Matt Jordan commented on ASTERISK-21039:
----------------------------------------

I haven't been able to reproduce this behavior, and there were no changes to {{res_odbc}} between 1.8 and 11 save for using {{ao2_lock}} to lock the mutexes. Your warnings and errors show that Asterisk wasn't able to allocate a handle to the database:

{noformat}
[2013-02-05 20:54:53.630] WARNING[8074][C-000002bd]: res_config_odbc.c:85 custom_prepare: SQL Alloc Handle failed!
{noformat}

That means that {{SQLAllocHandle}} itself is failing - which is outside of Asterisk's control. The fact that you're also getting timeouts makes me thing there is something going on here that is system dependent.

{noformat}
[2013-02-05 20:54:53.556] WARNING[8074][C-000002bc]: res_odbc.c:1552 odbc_obj_connect: res_odbc: Error SQLConnect=-1 errno=0 [unixODBC][FreeTDS][SQL Server]Timeout expired
{noformat}

Since we can't reproduce this and there are no real changes between 1.8 and 11, I'm closing this out as "Can't Reproduce". If anyone else can reproduce this problem when moving between 1.8 and 11 and provide some indication as to what might be causing the problem, we can reopen this issue.

                
> 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: https://issues.asterisk.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira