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

[Asterisk Bug Tracker]

The following issue has been CLOSED 
====================================================================== 
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:                     closed
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:              
Resolution:                 no change required
Fixed in Version:           
====================================================================== 
Date Submitted:             2010-01-21 10:22 CST
Last Modified:              2010-01-21 11:20 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
====================================================================== 

---------------------------------------------------------------------- 
 (0117035) tilghman (administrator) - 2010-01-21 11:20
 https://issues.asterisk.org/view.php?id=16668#c117035 
---------------------------------------------------------------------- 
Please see mailing list for the reply.  Any discussion must occur on the
mailing list. 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2010-01-21 11:20 tilghman       Note Added: 0117035                          
2010-01-21 11:20 tilghman       Status                   assigned => closed  
2010-01-21 11:20 tilghman       Resolution               open => no change
required
======================================================================