[asterisk-bugs] [JIRA] (ASTERISK-20037) func_odbc timeout quite long when connection drops during query - possibly need to expose query timeout attribute to make it configurable

[Rusty Newton (JIRA)]

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

Rusty Newton reassigned ASTERISK-20037:
---------------------------------------

    Assignee:     (was: Rusty Newton)
    
> func_odbc timeout quite long when connection drops during query - possibly need to expose query timeout attribute to make it configurable
> -----------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: ASTERISK-20037
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-20037
>             Project: Asterisk
>          Issue Type: Improvement
>      Security Level: None
>          Components: Functions/func_odbc, Resources/res_odbc
>    Affects Versions: 1.8.9.3
>         Environment: Asterisk 1.8.9.2
> CentOS 5.5 Final
> MyODBC 5.1.9
>            Reporter: Steven T. Wheeler
>         Attachments: buglog.log
>
>
> When using UnixODBC to connect Asterisk to a MySQL database server we are encountering issues when the database goes down.  We have designed the system with a redundant database server, but Asterisk locks up when the primary database goes into a hung state where it neither accepts or rejects the connections.  We simulate this condition using this iptables rule on the Asterisk server: -A OUTPUT -d x.x.x.x -j DROP.  We have setup connection timeouts which work well if the connections are not established when the primary database server goes down, but it doesn't look like Asterisk implements any sort of query timeout.
> Am I missing something or is this a known issue with Asterisk?

--
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