<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/3.3.2">
</HEAD>
<BODY>
Hello,<BR>
<BR>
This conversation was dropped in the past as someone felt the spooling native to 1.2.x would handle the situation. However; the opposite is true. The code in cdr_addon_mysql will not report back to any calling code as to whether the database operation happened successfully. Thus losing CDRs is a true reality. Personally, I've been using my original patch whereby I spool the records to a file. This change was not accepted for CVS HEAD at that time.<BR>
<BR>
The way to tell if you are losing records is to run the Perl CSV (in the bug id) import tool, taking a count before hand, and afterwords. If you've got more records, then you lost some. However, getting the records that fell out would require more work. However the major reason for CDR loss stems from the database disappearing.<BR>
<BR>
I have never researched the other real-time cdr modules. Thus I can not speak for the other ones.<BR>
<BR>
-Joe<BR>
Thralling Penguin LLC<BR>
<BR>
<BR>
On Thu, 2006-06-01 at 23:29 +0200, Matt Riddell (IT) wrote:
<BLOCKQUOTE TYPE=CITE>
<PRE>
<FONT COLOR="#000000">Juan Pablo Abuyeres wrote:</FONT>
<FONT COLOR="#000000">> Hi,</FONT>
<FONT COLOR="#000000">> </FONT>
<FONT COLOR="#000000">> I am losing CDR records on my MySQL backend. I just compared CSV records</FONT>
<FONT COLOR="#000000">> with MySQL's and I was surprised with the difference. Searching a bit, I</FONT>
<FONT COLOR="#000000">> hit this bug: <A HREF="http://bugs.digium.com/view.php?id=4953">http://bugs.digium.com/view.php?id=4953</A></FONT>
<FONT COLOR="#000000">> </FONT>
<FONT COLOR="#000000">> Questions:</FONT>
<FONT COLOR="#000000">> </FONT>
<FONT COLOR="#000000">> 1.- kpfleming says "The spooling issue will continue to be a problem for</FONT>
<FONT COLOR="#000000">> v1-0 users, but HEAD (and v1-2) users can use the built-in spooling in</FONT>
<FONT COLOR="#000000">> the CDR engine.". That "built-in spooling" has to be enabled somewhere</FONT>
<FONT COLOR="#000000">> or is it automatic?</FONT>
<FONT COLOR="#000000">> </FONT>
<FONT COLOR="#000000">> 2.- If there is a built-in spooling into CDR itself and there is no</FONT>
<FONT COLOR="#000000">> spooling in cdr_addon_mysql, when the mysql server is down, crashed,</FONT>
<FONT COLOR="#000000">> full, unwired, firewalled, or whatever.. is built-in spooling in CDR</FONT>
<FONT COLOR="#000000">> itself supposed to handle that??</FONT>
<FONT COLOR="#000000">> </FONT>
<FONT COLOR="#000000">> I'm using asterisk-1.2.7.1 and asterisk-addons-1.2.2</FONT>
<FONT COLOR="#000000">Is there any way that we can tell which cdr records have been lost? Is</FONT>
<FONT COLOR="#000000">there an error in the console? Does this apply to all realtime cdr</FONT>
<FONT COLOR="#000000">operations i.e. postgres, odbc etc or just MySQL?</FONT>
</PRE>
</BLOCKQUOTE>
</BODY>
</HTML>