[asterisk-bugs] [Asterisk 0012314]: CDR_ODBC don't log the first call when it needs to reconnect

[noreply at bugs.digium.com]

The following issue has been SUBMITTED. 
====================================================================== 
http://bugs.digium.com/view.php?id=12314 
====================================================================== 
Reported By:                yraber
Assigned To:                Corydon76
====================================================================== 
Project:                    Asterisk
Issue ID:                   12314
Category:                   CDR/cdr_odbc
Reproducibility:            always
Severity:                   major
Priority:                   normal
Status:                     assigned
Asterisk Version:           1.4.18 
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!):  
Disclaimer on File?:        N/A 
Request Review:              
====================================================================== 
Date Submitted:             03-27-2008 02:14 CDT
Last Modified:              03-27-2008 02:14 CDT
====================================================================== 
Summary:                    CDR_ODBC don't log the first call when it needs to
reconnect
Description: 
After a while without any activity (I don't know exactl how much, but a few
hours) it seems that Asterisk looses the MySQL connection, and when it
tries to reconnect, the first call is not logged. This problem only occurs
on the first call on reconnection, the next onces are ok.

Here is the what appears on the CLI :

       > cdr_odbc: Error in Query -1
       > cdr_odbc: Query FAILED Call not logged!
       > cdr_odbc: Reconnecting to dsn MySQL-asterisk
Really destroying SIP dialog
'6f2f45a40df45efd2d787858031a0340 at xxx.xxx.xxx.xx' Method: INVITE
       > cdr_odbc: Connected to MySQL-asterisk
       > cdr_odbc: Trying Query again!
       > cdr_odbc: Error in Query -2
       > cdr_odbc: Query FAILED Call not logged!

I don't know it this can be relevant, but I'm also using res_odbc.
====================================================================== 

Issue History 
Date Modified   Username       Field                    Change               
====================================================================== 
03-27-08 02:14  yraber         Asterisk Version          => 1.4.18          
03-27-08 02:14  yraber         SVN Branch (only for SVN checkou => N/A          
  
======================================================================