[asterisk-bugs] [Asterisk 0018672]: MOH on park stops and restarts - causes CDR error as well

[Asterisk Bug Tracker]

A NOTE has been added to this issue. 
====================================================================== 
https://issues.asterisk.org/view.php?id=18672 
====================================================================== 
Reported By:                Raffles
Assigned To:                
====================================================================== 
Project:                    Asterisk
Issue ID:                   18672
Category:                   Features/Parking
Reproducibility:            always
Severity:                   minor
Priority:                   normal
Status:                     new
Asterisk Version:           1.6.2.16.1 
JIRA:                        
Regression:                 No 
Reviewboard Link:            
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!):  
Request Review:              
====================================================================== 
Date Submitted:             2011-01-25 03:45 CST
Last Modified:              2011-01-25 09:10 CST
====================================================================== 
Summary:                    MOH on park stops and restarts - causes CDR error as
well
Description: 
On call park - the MOH is stopped only to start again/  This, also, seems
to cause a CDR problem (see below).

    -- Executing [7000 at chambers:1] Park("SIP/2000-00000008", "") in new
stack
  == Parked SIP/2000-00000008 on 7001 (lot default). Will timeout back to
extension [chambers] s, 1 in 60 seconds
    -- Added extension '7001' priority 1 to parkedcalls (0xb6fd1160)
    -- <SIP/2000-00000008> Playing 'digits/7.gsm' (language 'en')
    -- <SIP/2000-00000008> Playing 'digits/0.gsm' (language 'en')
    -- <SIP/2000-00000008> Playing 'digits/0.gsm' (language 'en')
    -- <SIP/2000-00000008> Playing 'digits/1.gsm' (language 'en')
  == Spawn extension (chambers, s, 1) exited non-zero on
'Parked/SIP/2000-00000008<ZOMBIE>'
    -- Stopped music on hold on DAHDI/1-1
    -- Started music on hold, class 'dv-ip', on DAHDI/1-1
[Jan 21 13:39:17] ERROR[22913]: cdr_addon_mysql.c:313 mysql_log: Failed to
insert into database: (1062) Duplicate entry 'DV-IP-1295617064.8' for key
1
  == Spawn extension (park-dial, SIP02000, 1) exited non-zero on
'SIP/2000-00000008<ZOMBIE>'

BTW 'DV-IP-1295617064.8' is the CDR entry for when the call first came in
to the queue.  So, it looks like it's trying to use the same unique ID
again.
====================================================================== 

---------------------------------------------------------------------- 
 (0131001) Raffles (reporter) - 2011-01-25 09:10
 https://issues.asterisk.org/view.php?id=18672#c131001 
---------------------------------------------------------------------- 
Firstly, I am using DAHDI (2.4.0 of both).  Not sure if this is a DAHDI
timing related issue only (as first thought over at 18262).  Are you using
DAHDI?

The call does go to a queue first - I can't remember if I tried it to a
direct extension.  I'll try that and retest.

As for the mySQL error - I've just found this on the wiki:

"Attention! The uniqueid field is not guaranteed to be unique across the
different CDR entries, even though the name suggests exactly that. In fact
Uniqueid has never been guaranteed to be unique across all CDRs: It is only
unique across a channel, and a channel may have multiple CDRs."

I've obviously got my table definition a bit wrong there (that'll teach me
to copypasta!).  I'll trundle away and fix ;).

Thanks 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2011-01-25 09:10 Raffles        Note Added: 0131001                          
======================================================================