No subject

can see that it attempts to insert '1292094492.137196' instead of '0'. More
strangely, the billsec number that it attempts to insert looks very similar
to the UNIQUEID
___________
2010-12-11 19:08:12 UTC ERROR:  numeric field overflow
2010-12-11 19:08:12 UTC DETAIL:  A field with precision 14, scale 6 must
round to an absolute value less than 10^8.
2010-12-11 19:08:12 UTC STATEMENT:  INSERT INTO cdr
("clidnum","clidname","dialednum","calldate","answer","callend","duration","billsec","disposition","uniqueid","sequence")
VALUES (,,,,'2010-12-11 20:08:12','2010-12-11 20:08:12','2010-12-11
20:08:12','0.029349','1292094492.137196','NO
ANSWER','arcas-1292094492.13',0)
====================================================================== 

---------------------------------------------------------------------- 
 (0129805) svnbot (reporter) - 2010-12-20 11:48
 https://issues.asterisk.org/view.php?id=18460#c129805 
---------------------------------------------------------------------- 
Repository: asterisk
Revision: 299132

_U  trunk/
U   trunk/cdr/cdr_pgsql.c

------------------------------------------------------------------------
r299132 | tilghman | 2010-12-20 11:48:09 -0600 (Mon, 20 Dec 2010) | 25
lines

Merged revisions 299131 via svnmerge from 
https://origsvn.digium.com/svn/asterisk/branches/1.8

................
  r299131 | tilghman | 2010-12-20 11:47:10 -0600 (Mon, 20 Dec 2010) | 18
lines
  
  Merged revisions 299130 via svnmerge from 
  https://origsvn.digium.com/svn/asterisk/branches/1.6.2
  
  ........
    r299130 | tilghman | 2010-12-20 11:41:24 -0600 (Mon, 20 Dec 2010) | 11
lines
    
    If a call was not answered, then the billsec was calculated unusually
large.
    
    Also, due to a copy and paste error, a request for the answer field
would have
    given the start value, instead.
    
    (closes issue https://issues.asterisk.org/view.php?id=18460)
     Reported by: joscas
     Patches: 
           20101215__issue18460.diff.txt uploaded by tilghman (license 14)
     Tested by: joscas
  ........
................

------------------------------------------------------------------------

http://svn.digium.com/view/asterisk?view=rev&revision=299132 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2010-12-20 11:48 svnbot         Checkin                                      
2010-12-20 11:48 svnbot         Note Added: 0129805                          
======================================================================