<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#ffffff">
<font face="Helvetica, Arial, sans-serif">Hello;<br>
<br>
is it normal that connid and resutid have values of 73 and 74 ??<br>
<br>
How come this value increases ? What does this mean for values 1
to 70 ??<br>
<br>
<br>
[May 7 08:52:41] -- Executing [h@sub:10]
NoOp("SIP/kal3-0000024f", "") in new stack<br>
[May 7 08:52:41] -- Executing [h@sub:11]
NoOp("SIP/kal3-0000024f", "clear MySQL-connections") in new stack<br>
[May 7 08:52:41] -- Executing [h@sub:12]
MYSQL("SIP/kal3-0000024f", "Clear 74") in new stack<br>
[May 7 08:52:41] WARNING[15003]: app_mysql.c:194 find_identifier:
Identifier 74, identifier_type 2 not found in identifier list<br>
[May 7 08:52:41] WARNING[15003]: app_mysql.c:510 aMYSQL_clear:
Invalid result identifier 74 passed in aMYSQL_clear<br>
[May 7 08:52:41] -- Executing [h@sub:13]
MYSQL("SIP/kal3-0000024f", "Disconnect 73") in new stack<br>
[May 7 08:52:41] WARNING[15003]: app_mysql.c:194 find_identifier:
Identifier 73, identifier_type 1 not found in identifier list<br>
[May 7 08:52:41] WARNING[15003]: app_mysql.c:527
aMYSQL_disconnect: Invalid connection identifier 73 passed in
aMYSQL_disconnect<br>
[May 7 08:52:41] -- Executing [h@sub:14]
NoOp("SIP/kal3-0000024f", "clear MySQL-connections") in new stack<br>
[May 7 08:52:41] -- Executing [h@sub:15]
NoOp("SIP/kal3-0000024f", "end") in new stack<br>
<br>
<br>
There are currently only 8 calls going on...<br>
<br>
<br>
<br>
Kind regards,<br>
Jonas.<br>
<br>
</font><br>
-------- Original Message --------
<table class="moz-email-headers-table" border="0" cellpadding="0"
cellspacing="0">
<tbody>
<tr>
<th nowrap="nowrap" valign="BASELINE" align="RIGHT">Subject: </th>
<td>Re: [asterisk-users] Mysql identifier not found</td>
</tr>
<tr>
<th nowrap="nowrap" valign="BASELINE" align="RIGHT">Date: </th>
<td>Sat, 05 May 2012 12:06:38 +0200</td>
</tr>
<tr>
<th nowrap="nowrap" valign="BASELINE" align="RIGHT">From: </th>
<td>Jonas Kellens <a class="moz-txt-link-rfc2396E" href="mailto:jonas.kellens@telenet.be"><jonas.kellens@telenet.be></a></td>
</tr>
<tr>
<th nowrap="nowrap" valign="BASELINE" align="RIGHT">To: </th>
<td>Asterisk Users Mailing List - Non-Commercial Discussion
<a class="moz-txt-link-rfc2396E" href="mailto:asterisk-users@lists.digium.com"><asterisk-users@lists.digium.com></a></td>
</tr>
</tbody>
</table>
<br>
<br>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<font face="Helvetica, Arial, sans-serif">I ask this because I find
the MySQL status information a bit alarming (</font><font
face="Helvetica, Arial, sans-serif">2946 connections</font><font
face="Helvetica, Arial, sans-serif">) :<br>
<br>
<br>
mysql> status<br>
--------------<br>
mysql Ver 14.12 Distrib 5.0.95, for redhat-linux-gnu (x86_64)
using readline 5.1<br>
<br>
Connection id: 2922<br>
Current database: <br>
Current user: root@localhost<br>
SSL: Not in use<br>
Current pager: stdout<br>
Using outfile: ''<br>
Using delimiter: ;<br>
Server version: 5.0.95 Source distribution<br>
Protocol version: 10<br>
Connection: Localhost via UNIX socket<br>
Server characterset: latin1<br>
Db characterset: latin1<br>
Client characterset: latin1<br>
Conn. characterset: latin1<br>
UNIX socket: /var/lib/mysql/mysql.sock<br>
Uptime: 6 hours 54 min 31 sec<br>
<br>
Threads: 3 Questions: 4919496 Slow queries: 0 Opens: 47 Flush
tables: 1 Open tables: 41 Queries per second avg: 197.800<br>
--------------<br>
<br>
mysql> show status like 'Conn%';<br>
+---------------+-------+<br>
| Variable_name | Value |<br>
+---------------+-------+<br>
| Connections | 2946 | <br>
+---------------+-------+<br>
1 row in set (0.00 sec)<br>
<br>
<br>
<br>
Jonas.<br>
<br>
</font><br>
On 05/05/2012 11:53 AM, Jonas Kellens wrote:
<blockquote cite="mid:4FA4F8B0.8050305@telenet.be" type="cite">
<meta http-equiv="content-type" content="text/html;
charset=ISO-8859-1">
<font face="Helvetica, Arial, sans-serif">Hello,<br>
<br>
notice in the console output beneath that there is a resultid 6
but it can not be cleared :<br>
<br>
<br>
[May 5 11:46:27] -- Executing [s@sub:3]
MYSQL("SIP/vart-00000336", "Connect connid localhost dialplan
host Asterisk") in new stack<br>
[May 5 11:46:27] -- Executing [s@sub:4]
MYSQL("SIP/vart-00000336", "Query resultid 4 DELETE FROM
pickuptbl WHERE pickmark LIKE "%SIP/vart2-00000336%"") in new
stack<br>
[May 5 11:46:27] -- Executing [s@sub:5]
MYSQL("SIP/vart-00000336", "Clear 6") in new stack<br>
[May 5 11:46:27] WARNING[17803]: app_mysql.c:194
find_identifier: Identifier 6, identifier_type 2 not found in
identifier list<br>
[May 5 11:46:27] WARNING[17803]: app_mysql.c:510 aMYSQL_clear:
Invalid result identifier 6 passed in aMYSQL_clear<br>
[May 5 11:46:27] -- Executing [s@sub:6]
MYSQL("SIP/vart-00000336", "Disconnect 4") in new stack<br>
[May 5 11:46:27] -- Executing [s@sub:7]
Return("SIP/vart-00000336", "") in new stack<br>
<br>
<br>
How come ??<br>
<br>
<br>
Kind regards,<br>
Jonas.<br>
</font>
<pre wrap=""><fieldset class="mimeAttachmentHeader"></fieldset>
--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://www.api-digital.com">http://www.api-digital.com</a> --
New to Asterisk? Join us for a live introductory webinar every Thurs:
<a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://www.asterisk.org/hello">http://www.asterisk.org/hello</a>
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
<a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://lists.digium.com/mailman/listinfo/asterisk-users">http://lists.digium.com/mailman/listinfo/asterisk-users</a></pre>
</blockquote>
</body>
</html>