Mysql identifier not found

Home » Asterisk Users » Mysql identifier not found
Asterisk Users 2 Comments

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 ??

2 thoughts on - Mysql identifier not found

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

    mysql> status

  • 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…