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@sub:10] NoOp("SIP/kal3-0000024f",
"") in new stack
[May 7 08:52:41] -- Executing [h@sub:11] NoOp("SIP/kal3-0000024f",
"clear MySQL-connections") in new stack
[May 7 08:52:41] -- Executing [h@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@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@sub:14] NoOp("SIP/kal3-0000024f",
"clear MySQL-connections") in new stack
[May 7 08:52:41] -- Executing [h@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 <[email protected]>
To: Asterisk Users Mailing List - Non-Commercial Discussion
<[email protected]>
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@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@sub:3]
MYSQL("SIP/vart-00000336", "Connect connid localhost dialplan host
Asterisk") in new stack
[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
[May 5 11:46:27] -- Executing [s@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@sub:6]
MYSQL("SIP/vart-00000336", "Disconnect 4") in new stack
[May 5 11:46:27] -- Executing [s@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
--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by http://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
