[asterisk-users] app_addon_sql_mysql.c:116 find_identifier

[Jonas Kellens]

The voip-info.org tells it differently :

*MYSQL(Clear* ${resultid}*)*

Frees memory and data structures associated with result set.

*MYSQL(Disconnect* ${connid}*)*

Disconnects from named connection to MySQL.

But it does not make a difference...

It's strange that every mysql-query is the same :


[May 14 09:20:24]     -- Executing [s at macro-QueryAstDB:5] 
MYSQL("Local/20 at 105002-ca25,2", "Clear 20") in new stack
[May 14 09:20:24]     -- Executing [s at macro-QueryAstDB:6] 
MYSQL("Local/20 at 105002-ca25,2", "Disconnect 19") in new stack

[May 14 09:20:24]     -- Executing [s at macro-GetSIPaccount:5] 
MYSQL("Local/20 at 105002-ca25,2", "Clear 20") in new stack
[May 14 09:20:24]     -- Executing [s at macro-GetSIPaccount:6] 
MYSQL("Local/20 at 105002-ca25,2", "Disconnect 19") in new stack

[May 14 09:20:34]     -- Executing [s at macro-GetMailboxFromSIPuserID:5] 
MYSQL("SIP/testcorp-083a2128", "Disconnect 19") in new stack
[May 14 09:20:34]     -- Executing [s at macro-GetMailboxFromSIPuserID:6] 
MYSQL("SIP/testcorp-083a2128", "Clear 20") in new stack

And then the last MySql-query :

[May 14 09:20:40]     -- Executing [s at macro-SDgeenopname:5] 
MYSQL("SIP/testcorp-083a2128", "Clear 20") in new stack
[May 14 09:20:40] WARNING[5939]: app_addon_sql_mysql.c:116 
find_identifier: Identifier 20, identifier_type 2 not found in 
identifier list
[May 14 09:20:40] WARNING[5939]: app_addon_sql_mysql.c:355 aMYSQL_clear: 
Invalid result identifier 20 passed in aMYSQL_clear
[May 14 09:20:40]     -- Executing [s at macro-SDgeenopname:6] 
MYSQL("SIP/testcorp-083a2128", "Disconnect 19") in new stack


The only difference is that this is a macro which is executed in the 
h-extension (so after the channel has been hung up). Could this be the 
issue ??
If so, what is the solution ?? No real solution is needed as it does not 
mess up anything, but it still is a "WARNING".



Jonas.

On 05/13/2010 04:26 PM, Doug Lytle wrote:
> Jonas Kellens wrote:
>    
>> exten =>  s,n,NoOp(fetchid = ${fetchid})
>> exten =>  s,n,MYSQL(Clear ${resultid})
>> exten =>  s,n,MYSQL(Disconnect ${connid})
>>      
> The only different between yours and mine is that I do a disconnect
> before I do the clear.
>
> Try:
>
> exten =>  s,n,MYSQL(Fetch fetchid ${resultid} extensie)
> exten =>  s,n,NoOp(fetchid = ${fetchid})
> exten =>  s,n,MYSQL(Disconnect ${connid})
> exten =>  s,n,MYSQL(Clear ${resultid})
>
>
> My guess is (If it works), that you can't clear an open channel.
>
> Doug

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20100514/b3763481/attachment.htm