[asterisk-bugs] [JIRA] Commented: (ASTERISK-19793) Only last realtime member of a queue is not actually removed from queue when removed from database

[Ronny Becker (JIRA)]

    [ https://issues.asterisk.org/jira/browse/ASTERISK-19793?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=195226#comment-195226 ] 

Ronny Becker commented on ASTERISK-19793:
-----------------------------------------

Just for documentation:
Using the realtime queue_member_table.
Everything is fine as long as you have users for the queue in the table. If you delete the last user or of you delete all users at once, there is no update on the queue Status made. The Problem is:

[Jul 23 07:49:39] DEBUG[10242] res_config_mysql.c: MySQL RealTime: Connection okay.
[Jul 23 07:49:39] DEBUG[10242] res_config_mysql.c: MySQL RealTime: Retrieve SQL: SELECT * FROM queue_member_table WHERE interface LIKE '%' AND queue_name = 'bsimoe' ORDER BY interface
[Jul 23 07:49:39] DEBUG[10242] app_queue.c: Queue bsimoe has no realtime members defined. No need for update

If the SQL Query returns no result, there is no update made to the queue Status and all members that have been in the queue remain there. It has to remove all members of a queue if the SQL Query returns nothing.

This Bug came into asterisk between 1.8.7(works) and 1.8.13.

> Only last realtime member of a queue is not actually removed from queue when removed from database
> --------------------------------------------------------------------------------------------------
>
>                 Key: ASTERISK-19793
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-19793
>             Project: Asterisk
>          Issue Type: Bug
>      Security Level: None
>          Components: Addons/res_config_mysql, Applications/app_queue
>    Affects Versions: 1.8.11.1
>         Environment: OpenSUSE 11.4 2.6.37.6-0.11-desktop #1 SMP PREEMPT 2011-12-19 23:39:38 +0100 x86_64 x86_64 x86_64 GNU/Linux
>            Reporter: Marcus Haas
>            Assignee: Marcus Haas
>         Attachments: debugLog
>
>
> In the example I have two MySQL realtime queue members in the Queue "Secuway" (local/8850 at agents, local/8851 at agents).
> "QUEUE SHOW Secuway" displays both queue members.
> Now I remove the first member from the database.
> "QUEUE SHOW Secuway" displays the remaining member.
> After removing the second and last queue member from MySQL, "QUEUE SHOW Secuway" still shows it and the debug log says "Queue Secuway has no realtime members defined. No need for update". Also there is no REMOVEMEMBER Action logged to the queue_log for the last queue member.
> Full debug log is attached

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira