Summary: | ASTERISK-15486: ms sql connections problems | ||
Reporter: | Giedrius (voipas) | Labels: | |
Date Opened: | 2010-01-21 10:22:18.000-0600 | Date Closed: | 2011-06-07 14:01:08 |
Priority: | Major | Regression? | No |
Status: | Closed/Complete | Components: | Resources/res_odbc |
Versions: | Frequency of Occurrence | ||
Related Issues: | |||
Environment: | Attachments: | ||
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 | ||
Comments: | By: Sean Bright (seanbright) 2010-01-21 10:24:39.000-0600 Are you using the FreeTDS ODBC driver? By: Tilghman Lesher (tilghman) 2010-01-21 11:20:50.000-0600 Please see mailing list for the reply. Any discussion must occur on the mailing list. |