[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 08:51 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.
====================================================================== 

---------------------------------------------------------------------- 
 (0131000) one47 (reporter) - 2011-01-25 08:51
 https://issues.asterisk.org/view.php?id=18672#c131000 
---------------------------------------------------------------------- 
I am using 1.6.2.16.1 with the same MOH patch.

As far as the MySQL duplicate entry, I suspect that you have put a
duplicate key on your "uniqueid" column - This is not valid. If a CDR forks
(as it often does) then the uniqueid will not necessarily change, and is
ofthen useful for tracking a call's progress.

I have been unable to replicate the reversed Stop/Start MOH messages that
show in your debug. I get the following:


  == Parked SIP/t28-0000000e on 211 (lot default). Will timeout back to
extension [external] 210, 13 in 90 seconds
    -- Added extension '211' priority 1 to parkedcalls_default
(0x9620190)
    -- <SIP/t28-0000000e> Playing 'digits/2.alaw' (language 'en')
    -- <SIP/t28-0000000e> Playing 'digits/1.alaw' (language 'en')
    -- <SIP/t28-0000000e> Playing 'digits/1.alaw' (language 'en')
    -- Started music on hold, class 'm-default', on SIP/t28-0000000e
  == Spawn extension (external, s, 1) exited non-zero on
'Parked/SIP/t28-0000000e<ZOMBIE>'
    -- Stopped music on hold on SIP/t28-0000000e

What is the exact sequence of events that occurs to the call to cause that
issue? Does it have to go through a Queue first? 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2011-01-25 08:51 one47          Note Added: 0131000                          
======================================================================