[asterisk-bugs] [Asterisk 0011694]: Asterisk crashes when connecting the 10th simultaneous ODBC pooled connections

[noreply at bugs.digium.com]

A NOTE has been added to this issue. 
====================================================================== 
http://bugs.digium.com/view.php?id=11694 
====================================================================== 
Reported By:                falves11
Assigned To:                Corydon76
====================================================================== 
Project:                    Asterisk
Issue ID:                   11694
Category:                   Resources/res_odbc
Reproducibility:            always
Severity:                   crash
Priority:                   normal
Status:                     feedback
Asterisk Version:           SVN 
SVN Branch (only for SVN checkouts, not tarball releases):  trunk 
SVN Revision (number only!): 96645 
Disclaimer on File?:        N/A 
Request Review:              
====================================================================== 
Date Submitted:             01-06-2008 09:44 CST
Last Modified:              01-07-2008 14:15 CST
====================================================================== 
Summary:                    Asterisk crashes when connecting the 10th
simultaneous ODBC pooled connections
Description: 
After so much work now I nailed the ODBC problem.
I traced how many open connection I have in my SQL server from Asterisk
every second, and inf act, I see 1,2,3,4,5,6,7,8,9,0, and Asterisk crashes.
The capture below is obtained by setting verbose level to 1, and it can be
seen clearly that at the 10th ODBC connection Asterisk is unable to
connect. Yet, the command odbc show gives this output, which proves that
theoretically there is a 1000 limit on the connections.

 Name:   global
  DSN:    mssql
  Pooled: Yes
  Limit:  1000
  Connections in use: 1
    - Connection 1: connected

====================================================================== 

---------------------------------------------------------------------- 
 falves11 - 01-07-08 14:15  
---------------------------------------------------------------------- 
Yes, the user is a sysdamin, and has all rights. There are no limits. I
believe there was a problem with the ODBC Driver, and my vendor, Easysoft
is checking it right now. He might find an additional problem in the
Asterisk code since it keep blowing up under pressure. He is using Valgrind
to find the culprit. I will publish his findings here. Meanwhile, we should
increase the max amount of events to monitor by default from the current
value to a much higher number. The code is in /main/autoservice.c I am
using #define MAX_AUTOMONS 10256. 

Issue History 
Date Modified   Username       Field                    Change               
====================================================================== 
01-07-08 14:15  falves11       Note Added: 0076445                          
======================================================================