[asterisk-dev] losing CDRs on mysql backend

[Wilmar Campos]

This is working perfect for me since I applied the patch.



On 6/19/06, Juan Pablo Abuyeres <jpabuyer at tecnoera.com> wrote:
>
> I tried JBenden's patch posted on http://bugs.digium.com/view.php?
> id=7274 and it works very well. No CDRs are lost since the patch is
> applied. I'm reporting this here as requested by vechers.
>
>
> On Thu, 2006-06-01 at 17:50 -0400, 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.
> >
> > -Joe
> > Thralling Penguin LLC
> >
> >
> > On Thu, 2006-06-01 at 23:29 +0200, Matt Riddell (IT) wrote:
> > > Juan Pablo Abuyeres wrote:
> > > > Hi,
> > > >
> > > > I am losing CDR records on my MySQL backend. I just compared CSV
> records
> > > > with MySQL's and I was surprised with the difference. Searching a
> bit, I
> > > > hit this bug: http://bugs.digium.com/view.php?id=4953
> > > >
> > > > Questions:
> > > >
> > > > 1.- kpfleming says "The spooling issue will continue to be a problem
> for
> > > > v1-0 users, but HEAD (and v1-2) users can use the built-in spooling
> in
> > > > the CDR engine.". That "built-in spooling" has to be enabled
> somewhere
> > > > or is it automatic?
> > > >
> > > > 2.- If there is a built-in spooling into CDR itself and there is no
> > > > spooling in cdr_addon_mysql, when the mysql server is down, crashed,
> > > > full, unwired, firewalled, or whatever.. is built-in spooling in CDR
> > > > itself supposed to handle that??
> > > >
> > > > I'm using asterisk-1.2.7.1 and asterisk-addons-1.2.2
> > >
> > > Is there any way that we can tell which cdr records have been
> lost?  Is
> > > there an error in the console?  Does this apply to all realtime cdr
> > > operations i.e. postgres, odbc etc or just MySQL?
> > >
> > _______________________________________________
> > --Bandwidth and Colocation provided by Easynews.com --
> >
> > asterisk-dev mailing list
> > To UNSUBSCRIBE or update options visit:
> >    http://lists.digium.com/mailman/listinfo/asterisk-dev
>
> _______________________________________________
> --Bandwidth and Colocation provided by Easynews.com --
>
> asterisk-dev mailing list
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-dev
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-dev/attachments/20060619/bc08a672/attachment.htm