[asterisk-bugs] [Asterisk 0016893]: Realtime queue does not re-read announce variable from mysql after first use

[Asterisk Bug Tracker]

A NOTE has been added to this issue. 
====================================================================== 
https://issues.asterisk.org/view.php?id=16893 
====================================================================== 
Reported By:                haakon
Assigned To:                tilghman
====================================================================== 
Project:                    Asterisk
Issue ID:                   16893
Category:                   Applications/app_queue
Reproducibility:            always
Severity:                   minor
Priority:                   normal
Status:                     feedback
Target Version:             1.6.2.11
Asterisk Version:           SVN 
JIRA:                       SWP-964 
Regression:                 No 
Reviewboard Link:            
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!):  
Request Review:              
====================================================================== 
Date Submitted:             2010-02-24 07:39 CST
Last Modified:              2010-07-26 07:09 CDT
====================================================================== 
Summary:                    Realtime queue does not re-read announce variable
from mysql after first use
Description: 
I am using realtime queues extensively with * 1.6.1.

Everything works great. Asterisk reads new values from the queue table
each time a user enters the queue.
Except from one thing: announcements. The "announce" variable from the
queue table, doesn't seem to be read more than once, if it has already
found a value.

Example:
I create a queue in the queue table, and add announce = "my_audio_file"
Then I call in, and the agent gets the audio file played correctly before
they are set up.

Then I set the announce field to NULL, or empty it with a empty string.
Now if i call in, the agent still gets the audio file set up earlier.

I even tried changing the ID of the queue entry in mysql (because i know
the queue_members table require this).
But it still reads the "ghost" value of announce.
====================================================================== 

---------------------------------------------------------------------- 
 (0125012) haakon (reporter) - 2010-07-26 07:09
 https://issues.asterisk.org/view.php?id=16893#c125012 
---------------------------------------------------------------------- 
I did test NULL and blank. None of them changed anything. 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2010-07-26 07:09 haakon         Note Added: 0125012                          
======================================================================