[asterisk-bugs] [Asterisk 0018091]: [patch] dialgroup fills database with duplicates

[Asterisk Bug Tracker]

A NOTE has been added to this issue. 
====================================================================== 
https://issues.asterisk.org/view.php?id=18091 
====================================================================== 
Reported By:                bunny
Assigned To:                tilghman
====================================================================== 
Project:                    Asterisk
Issue ID:                   18091
Category:                   Functions/func_dialgroup
Reproducibility:            always
Severity:                   major
Priority:                   normal
Status:                     ready for testing
Asterisk Version:           1.6.2.11 
JIRA:                        
Regression:                 No 
Reviewboard Link:            
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!):  
Request Review:              
====================================================================== 
Date Submitted:             2010-10-04 20:37 CDT
Last Modified:              2010-10-06 22:08 CDT
====================================================================== 
Summary:                    [patch] dialgroup fills database with duplicates
Description: 
every time a dialgroup is called, it appends to the astdb resulting in a
ridiculous number of repeats. It is, however, sorting the duplicates.

example usage:
http://www.asterisk.org/docs/asterisk/trunk/functions/dialgroup
http://www.voip-info.org/wiki/view/Asterisk+func+dialgroup

Either the way to use dialgroup is violently wrong or there is a bug in
how stuff works.

After a while, you end up with:

/dialgroup/5f                                     :
SIP/500 at phone-521.office&SIP/500 at phone-521.office&SIP/500 at phone-521.office
&SIP/500 at phone-521.office&SIP/500 at phone-521.office&SIP/500 at phone-521.office
&SIP/500 at phone-521.office&SIP/500 at phone-521.office&SIP/500 at phone-521.office
&SIP/500 at phone-521.office&SIP/500 at phone-521.office&SIP/500 at phone-521.office
&SIP/500 at phone-521.office&SIP/500 at phone-521.office&SIP/500 at phone-521.office
&SIP/500 at phone-521.office&SIP/500 at phone-521.office&SIP/500 at phone-521.office
...
&SIP/500 at phone-521.office&SIP/500 at phone-521.office&SIP/500 at phone-521.office
&SIP/500 at phone-521.office&SIP/500 at phone-521.office&SIP/500 at phone-521.office
&SIP/500 at phone-521.office&SIP/500 at phone-521.office&SIP/500 at phone-512.office
&SIP/500 at phone-513.office&SIP/500 at phone-512.office&SIP/500 at phon...


database deltree dialgroup/5f also lies about its success.

====================================================================== 

---------------------------------------------------------------------- 
 (0127772) bunny (reporter) - 2010-10-06 22:08
 https://issues.asterisk.org/view.php?id=18091#c127772 
---------------------------------------------------------------------- 
I guess my understanding of it was wrong.
I thought it was a less error prone way (than say, 20
SIP/500 at phone-XXX.office& on one line) to build up the actual Dial( STUFF )
line.
As the Dial( all these phones ) soon becomes unmanageable.

Perhaps if there was a place to define and fill up the DIALGROUPS outside
the
extension stuff, that would make more sense and that is likely what I am
doing wrong. Our dialgroups don't change much, just some people want to
know when calls are coming in for other groups...

Database delete appears to lie, but that might be pilot error.

installed patch
removed astdb from /var/opt/asterisk
restarted asterisk
called 500

/dialgroup/5f                                     :
SIP/500 at phone-521.office&SIP/500 at phone-512.office&SIP/500 at phone-513.office&SIP/500 at phone-522.office

called again.
/dialgroup/5f                                     :
SIP/500 at phone-521.office&SIP/500 at phone-512.office&SIP/500 at phone-513.office&SIP/500 at phone-522.office


So this fix appears to work.

Thank you very much. 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2010-10-06 22:08 bunny          Note Added: 0127772                          
======================================================================