[asterisk-bugs] [JIRA] (ASTERISK-26177) func_odbc: Database handle is kept when it should be released

[Leandro Dardini (JIRA)]

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

Leandro Dardini commented on ASTERISK-26177:
--------------------------------------------

I think Alexei is right. I didn't pay attention to CHANGES and left max_connections to its default value (1). Setting max_connections to 20, produces no locks.

About single_db_connection, by setting it to "no", there is no more locks, regardless the value of max_connections. Turning it back to "yes" produces immediately a lock (with max_connections to 1). From a performance point of view, having asterisk working to setup a new connection for each ODBC_ command (if I have understood correctly) then can be a big penalty.

I confirm the problem with max_connections, raising it to 20 with single_db_connection to yes produces no locks.



> func_odbc: Database handle is kept when it should be released
> -------------------------------------------------------------
>
>                 Key: ASTERISK-26177
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-26177
>             Project: Asterisk
>          Issue Type: Bug
>      Security Level: None
>          Components: Functions/func_odbc
>    Affects Versions: 13.10.0-rc1
>         Environment: CentOS 6.8 64 bit with unixODBC-2.3.4-1 backported from fc23 and Oracle Mysql connector 5.3.6
>            Reporter: Leandro Dardini
>            Assignee: Joshua Colp
>         Attachments: backtrace-threads.txt, coreshowlocks.txt, full-lock.txt
>
>
> When processing normal dialplan commands, including several ODBC commands, at some point, just running a simple command like "FollowMe" locks up asterisk. Running the FollowMe command with the same parameter, but without running anything before, produces no lock. The same dialplan run under asterisk 13.2.0 produces no issues.



--
This message was sent by Atlassian JIRA
(v6.2#6252)