[asterisk-users] Mysql identifier not found

[Jonas Kellens]

Hello;

is it normal that connid and resutid have values of 73 and 74 ??

How come this value increases ? What does this mean for values 1 to 70 ??


[May  7 08:52:41]     -- Executing [h at sub:10] NoOp("SIP/kal3-0000024f", 
"") in new stack
[May  7 08:52:41]     -- Executing [h at sub:11] NoOp("SIP/kal3-0000024f", 
"clear MySQL-connections") in new stack
[May  7 08:52:41]     -- Executing [h at sub:12] MYSQL("SIP/kal3-0000024f", 
"Clear 74") in new stack
[May  7 08:52:41] WARNING[15003]: app_mysql.c:194 find_identifier: 
Identifier 74, identifier_type 2 not found in identifier list
[May  7 08:52:41] WARNING[15003]: app_mysql.c:510 aMYSQL_clear: Invalid 
result identifier 74 passed in aMYSQL_clear
[May  7 08:52:41]     -- Executing [h at sub:13] MYSQL("SIP/kal3-0000024f", 
"Disconnect 73") in new stack
[May  7 08:52:41] WARNING[15003]: app_mysql.c:194 find_identifier: 
Identifier 73, identifier_type 1 not found in identifier list
[May  7 08:52:41] WARNING[15003]: app_mysql.c:527 aMYSQL_disconnect: 
Invalid connection identifier 73 passed in aMYSQL_disconnect
[May  7 08:52:41]     -- Executing [h at sub:14] NoOp("SIP/kal3-0000024f", 
"clear MySQL-connections") in new stack
[May  7 08:52:41]     -- Executing [h at sub:15] NoOp("SIP/kal3-0000024f", 
"end") in new stack


There are currently only 8 calls going on...



Kind regards,
Jonas.


-------- Original Message --------
Subject: 	Re: [asterisk-users] Mysql identifier not found
Date: 	Sat, 05 May 2012 12:06:38 +0200
From: 	Jonas Kellens <jonas.kellens at telenet.be>
To: 	Asterisk Users Mailing List - Non-Commercial Discussion 
<asterisk-users at lists.digium.com>



I ask this because I find the MySQL status information a bit alarming 
(2946 connections) :


mysql> status
--------------
mysql  Ver 14.12 Distrib 5.0.95, for redhat-linux-gnu (x86_64) using 
readline 5.1

Connection id:        2922
Current database:
Current user:        root at localhost
SSL:            Not in use
Current pager:        stdout
Using outfile:        ''
Using delimiter:    ;
Server version:        5.0.95 Source distribution
Protocol version:    10
Connection:        Localhost via UNIX socket
Server characterset:    latin1
Db     characterset:    latin1
Client characterset:    latin1
Conn.  characterset:    latin1
UNIX socket:        /var/lib/mysql/mysql.sock
Uptime:            6 hours 54 min 31 sec

Threads: 3  Questions: 4919496  Slow queries: 0  Opens: 47  Flush 
tables: 1  Open tables: 41  Queries per second avg: 197.800
--------------

mysql> show status like 'Conn%';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| Connections   | 2946  |
+---------------+-------+
1 row in set (0.00 sec)



Jonas.


On 05/05/2012 11:53 AM, Jonas Kellens wrote:
> Hello,
>
> notice in the console output beneath that there is a resultid 6 but it 
> can not be cleared :
>
>
> [May  5 11:46:27]     -- Executing [s at sub:3] 
> MYSQL("SIP/vart-00000336", "Connect connid localhost dialplan host 
> Asterisk") in new stack
> [May  5 11:46:27]     -- Executing [s at sub:4] 
> MYSQL("SIP/vart-00000336", "Query resultid 4 DELETE FROM pickuptbl 
> WHERE pickmark LIKE "%SIP/vart2-00000336%"") in new stack
> [May  5 11:46:27]     -- Executing [s at sub:5] 
> MYSQL("SIP/vart-00000336", "Clear 6") in new stack
> [May  5 11:46:27] WARNING[17803]: app_mysql.c:194 find_identifier: 
> Identifier 6, identifier_type 2 not found in identifier list
> [May  5 11:46:27] WARNING[17803]: app_mysql.c:510 aMYSQL_clear: 
> Invalid result identifier 6 passed in aMYSQL_clear
> [May  5 11:46:27]     -- Executing [s at sub:6] 
> MYSQL("SIP/vart-00000336", "Disconnect 4") in new stack
> [May  5 11:46:27]     -- Executing [s at sub:7] 
> Return("SIP/vart-00000336", "") in new stack
>
>
> How come ??
>
>
> Kind regards,
> Jonas.
>
>
> --
> _____________________________________________________________________
> -- Bandwidth and Colocation Provided byhttp://www.api-digital.com  --
> New to Asterisk? Join us for a live introductory webinar every Thurs:
>                 http://www.asterisk.org/hello
>
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
>     http://lists.digium.com/mailman/listinfo/asterisk-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20120507/1aeded8c/attachment.htm>