No subject


Thu Dec 16 07:37:03 UTC 2010


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)
====================================================================== 

---------------------------------------------------------------------- 
 (0129803) svnbot (reporter) - 2010-12-20 11:41
 https://issues.asterisk.org/view.php?id=18460#c129803 
---------------------------------------------------------------------- 
Repository: asterisk
Revision: 299130

U   branches/1.6.2/cdr/cdr_pgsql.c

------------------------------------------------------------------------
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=299130 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2010-12-20 11:41 svnbot         Checkin                                      
2010-12-20 11:41 svnbot         Note Added: 0129803                          
2010-12-20 11:41 svnbot         Status                   ready for testing =>
assigned
2010-12-20 11:41 svnbot         Status                   assigned => resolved
2010-12-20 11:41 svnbot         Resolution               open => fixed       
======================================================================




More information about the asterisk-bugs mailing list