[asterisk-bugs] [Asterisk 0016668]: ms sql connections problems

[Asterisk Bug Tracker]

The following issue has been SUBMITTED. 
====================================================================== 
https://issues.asterisk.org/view.php?id=16668 
====================================================================== 
Reported By:                voipas
Assigned To:                tilghman
====================================================================== 
Project:                    Asterisk
Issue ID:                   16668
Category:                   Resources/res_odbc
Reproducibility:            always
Severity:                   major
Priority:                   normal
Status:                     assigned
Asterisk Version:           1.6.0.20 
JIRA:                        
Regression:                 No 
Reviewboard Link:            
SVN Branch (only for SVN checkouts, not tarball releases): N/A 
SVN Revision (number only!):  
Request Review:              
====================================================================== 
Date Submitted:             2010-01-21 10:22 CST
Last Modified:              2010-01-21 10:22 CST
====================================================================== 
Summary:                    ms sql connections problems
Description: 
Hello,

  In the peak (200 simultaneus calls) I started loose some data in MS SQL
(cdr records).
My previous configuration was:
[mfdb]
enabled => yes
dsn => MFDB
pooling => yes
limit => 40
username => login
password => password
pre-connect => yes
backslash_is_escape => no

`odbc show mfdb` showed me that I have used 40 connections. After
restarting asterisk and changing to these parameters:
[mfdb]
enabled => yes
dsn => MFDB
pooling => yes
limit => 200
share_connections => no
username => login
password => password
pre-connect => yes
backslash_is_escape => no


  and after my heavy testings , now I see 105 opened connections. And I
see all CDR records in database. 
 And is it possible close these connections , when I have for example 1
call and so on?

  Thanks
====================================================================== 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2010-01-21 10:22 voipas         New Issue                                    
2010-01-21 10:22 voipas         Status                   new => assigned     
2010-01-21 10:22 voipas         Assigned To               => tilghman        
2010-01-21 10:22 voipas         Asterisk Version          => 1.6.0.20        
2010-01-21 10:22 voipas         Regression                => No              
2010-01-21 10:22 voipas         SVN Branch (only for SVN checkouts, not tarball
releases) => N/A             
======================================================================