[asterisk-bugs] [Asterisk 0016668]: ms sql connections problems
Asterisk Bug Tracker
noreply at bugs.digium.com
Thu Jan 21 11:20:50 CST 2010
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
======================================================================
More information about the asterisk-bugs
mailing list