[asterisk-bugs] [JIRA] Updated: (ASTERISK-20162) app_queue does no Status update on empty SQL result

[Matt Jordan (JIRA)]

     [ https://issues.asterisk.org/jira/browse/ASTERISK-20162?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Matt Jordan updated ASTERISK-20162:
-----------------------------------

    Severity: Major  (was: Blocker)

> app_queue does no Status update on empty SQL result
> ---------------------------------------------------
>
>                 Key: ASTERISK-20162
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-20162
>             Project: Asterisk
>          Issue Type: Bug
>      Security Level: None
>          Components: Applications/app_queue, Resources/res_realtime
>    Affects Versions: 1.8.13.0
>         Environment: Debian 6, 64bit
>            Reporter: Ronny Becker
>
> 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.

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