<html><head><style type='text/css'>p { margin: 0; }</style><style type='text/css'>body { font-family: 'Times New Roman'; font-size: 12pt; color: #000000}</style></head><body><style>p { margin: 0; }</style><style>body { font-family: 'Times New Roman'; font-size: 12pt; color: #000000}</style><link href="/zimbra/css/msgview.css?v=080321144137" rel="stylesheet">I had a similar problem, but in my case we had a custom application that was throwing an segmentation exception which was causing Asterisk to Restart. And in that case It use to miss the log in database.<br>You can determine the same by looking at the UNIQUEID being logged for the call. The UNIQUEID actually comprises of 2 things <span style="font-weight: bold;">DateTimeString.CallNumber</span>,<span style="font-weight: bold;"> </span>everytime Asterisk restarts CallNumber will start from 1. So you can check the 2-3 UNIQUEID before you missed entry in CDR table and 2-3 after the missed entry to determine if Asterisk Restarted.<br>Other way is you can see the kernel logs to see if Asterisk has thrown any exception. they can be found on Linux at /var/log/messages<br><br><br>Regards,<br>Sanjay Rajdev<br><br>----- Original Message -----<br>From: "Alex Balashov" <abalashov@evaristesys.com><br>To: "Asterisk Users Mailing List - Non-Commercial Discussion" <asterisk-users@lists.digium.com><br>Sent: Thursday, May 22, 2008 3:32:07 AM GMT +05:30 Chennai, Kolkata, Mumbai, New Delhi<br>Subject: Re: [asterisk-users] Asterisk Database Handling<br><br>Douglas Garstang wrote:<br><br>> We are sending CDR's to MySQL via odbc. It seems that Asterisk is <br>> sometimes dropping CDR's, and they aren't being sent to the database <br>> (they ARE in the Master.csv file though). We suspect that when the MySQL <br>> socket is idle, it gets disconnected, either by the MySQL server or by <br>> our firewall, and when Asterisk goes to send the next CDR over the <br>> socket, does not re-open the database, and drops that CDR. Possibly on <br>> the next call, it connects ok and sends the next CDR.<br><br>Isn't there a keepalive option somewhere for cdr_mysql.conf, or failing <br>that, a keepalive mechanism that can be enabled for TCP connections on <br>the server side?<br><br>-- <br>Alex Balashov<br>Evariste Systems<br>Web : http://www.evaristesys.com/<br>Tel : (+1) (678) 954-0670<br>Direct : (+1) (678) 954-0671<br>Mobile : (+1) (706) 338-8599<br><br>_______________________________________________<br>-- Bandwidth and Colocation Provided by http://www.api-digital.com --<br><br>asterisk-users mailing list<br>To UNSUBSCRIBE or update options visit:<br> http://lists.digium.com/mailman/listinfo/asterisk-users<br></body></html>