[asterisk-dev] losing CDRs on mysql backend

[Matt Riddell (IT)]

Joseph Benden wrote:
> Hello,
> 
> 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.
> 
> 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.
> 
> I have never researched the other real-time cdr modules.  Thus I can not
> speak for the other ones.

Would it not make more sense for cdr-mysql to just report back the
result of attempting to insert to the DB?

-- 
Cheers,

Matt Riddell
_______________________________________________

http://www.sineapps.com/news.php (Daily Asterisk News - html)
http://freevoip.gedameurope.com (Free Asterisk Voip Community)
http://www.sineapps.com/rssfeed.php (Daily Asterisk News - rss)