[asterisk-dev] [Code Review] 4405: Fix ast_odbc_find_table function in res_odbc

[ibercom]

> On Feb. 4, 2015, 8:24 p.m., Mark Michelson wrote:
> > I don't see anything wrong in this patch, but I'm a bit confused about what this is fixing and how this is fixing it. Can you go into a bit more detail about why this fixes the problem you were seeing?

wdoekes's explanation is better than mine.


- ibercom


-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviewboard.asterisk.org/r/4405/#review14411
-----------------------------------------------------------


On Feb. 4, 2015, 6:21 p.m., ibercom wrote:
> 
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> https://reviewboard.asterisk.org/r/4405/
> -----------------------------------------------------------
> 
> (Updated Feb. 4, 2015, 6:21 p.m.)
> 
> 
> Review request for Asterisk Developers.
> 
> 
> Bugs: ASTERISK-24742
>     https://issues.asterisk.org/jira/browse/ASTERISK-24742
> 
> 
> Repository: Asterisk
> 
> 
> Description
> -------
> 
> This patch fixes an anomalous behavior in ast_odbc_find_table function with Asterisk Realtime.
> 
> - SELECT or INSERT operation generate a single command "SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED" in database engine before operation.
> - UPDATE operation generates two commands "SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED" in database engine before operation.
> 
> The patch is trivial, just rearranges the call to ast_odbc_request_obj function. This isn't necessary when the table is cached.
> 
> 
> Diffs
> -----
> 
>   branches/11/res/res_odbc.c 431571 
> 
> Diff: https://reviewboard.asterisk.org/r/4405/diff/
> 
> 
> Testing
> -------
> 
> Log mysql usage.
> It is working for a week without problems.
> 
> 
> Thanks,
> 
> ibercom
> 
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-dev/attachments/20150205/ba9d85c0/attachment.html>