[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 CLOSED 
====================================================================== 
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:                     closed
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:              
Resolution:                 no change required
Fixed in Version:           
====================================================================== 
Date Submitted:             03-27-2008 02:14 CDT
Last Modified:              03-27-2008 08:26 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.
====================================================================== 

---------------------------------------------------------------------- 
 Corydon76 - 03-27-08 08:26  
---------------------------------------------------------------------- 
Please set "idlecheck" to 3600 in res_odbc.conf.  The parameter was created
specifically for the buggy MySQL driver. 

Issue History 
Date Modified   Username       Field                    Change               
====================================================================== 
03-27-08 08:26  Corydon76      Note Added: 0084650                          
03-27-08 08:26  Corydon76      Status                   assigned => closed  
03-27-08 08:26  Corydon76      Resolution               open => no change
required
======================================================================