[asterisk-bugs] [Asterisk 0015967]: Asterisk ignores changes to realtime queue member table after initial startup

[Asterisk Bug Tracker]

A NOTE has been added to this issue. 
====================================================================== 
https://issues.asterisk.org/view.php?id=15967 
====================================================================== 
Reported By:                ajohnson
Assigned To:                
====================================================================== 
Project:                    Asterisk
Issue ID:                   15967
Category:                   Applications/app_queue
Reproducibility:            always
Severity:                   minor
Priority:                   normal
Status:                     acknowledged
Asterisk Version:           1.6.2.0-rc2 
JIRA:                        
Regression:                 No 
Reviewboard Link:            
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!):  
Request Review:              
====================================================================== 
Date Submitted:             2009-09-25 14:52 CDT
Last Modified:              2009-10-21 12:19 CDT
====================================================================== 
Summary:                    Asterisk ignores changes to realtime queue member
table after initial startup
Description: 
On startup the member polycom1 was a member of the queue frish.  I then
updated the queue member table to change the member to polycom2.  This
change is not picked up, even though Asterisk does query the table.

pbx2*CLI> queue show frish
frish        has 0 calls (max unlimited) in 'ringall' strategy (0s
holdtime, 0s talktime), W:0, C:0, A:1, SL:0.0% within 0s
   Members:
      polycom1 (SIP/polycom1) with penalty 1 (realtime) (Not in use) has
taken no calls yet
   No Callers

pbx2*CLI>

Queries that realtime does:

                   1516 Query       SELECT * FROM queue_member_table WHERE
interface LIKE '%' AND queue_name = 'frish' ORDER BY interface
                   1516 Query       SET SESSION TRANSACTION ISOLATION
LEVEL READ COMMITTED
                   1516 Query       SELECT * FROM queue_table WHERE name =
'frish'
                   1516 Query       SET SESSION TRANSACTION ISOLATION
LEVEL READ COMMITTED
                   1516 Query       SELECT * FROM queue_member_table WHERE
interface LIKE '%' AND queue_name = 'frish' ORDER BY interface


Actual information in the table:
uniqueid, membername, queue_name, interface, penalty, paused
1, 'polycom2', 'Frish', 'SIP/polycom2', 1, 0

Reloading the extconfig and app_queue.so module does not result in the
right information being picked up.  Restarting Asterisk results in the
correct member being shown as part of the queue.
====================================================================== 

---------------------------------------------------------------------- 
 (0112568) ajohnson (reporter) - 2009-10-21 12:19
 https://issues.asterisk.org/view.php?id=15967#c112568 
---------------------------------------------------------------------- 
In 1.6.1.6, modifying the queue table does not result in the changes being
recognized until app_queue.so is unloaded and loaded again.  Issueing a
module reload app_queue.so does not cause the changes to be recognized. 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2009-10-21 12:19 ajohnson       Note Added: 0112568                          
======================================================================