[Home]

Summary:ASTERISK-13947: odbc show says that limit is 232, and blocks when exceeding that amount
Reporter:Private Name (falves11)Labels:
Date Opened:2009-04-13 13:50:38Date Closed:2009-04-14 07:13:38
Priority:BlockerRegression?No
Status:Closed/CompleteComponents:CDR/cdr_odbc
Versions:Frequency of
Occurrence
Related
Issues:
Environment:Attachments:
Description:Name: sybase
DSN: sybase
Pooled: yes
Limit: 232
Connections in use: 9
 Connection 1: connected
 Connection 2: connected
 Connection 3: connected
 Connection 4: connected
 Connection 5: connected
 Connection 6: connected
 Connection 7: connected
 Connection 8: connected
 Connection 9: connected

Name: routing
DSN: sybase
Pooled: yes
Limit: 232
Connections in use: 1
 Connection 1: connected

Name: global
DSN: mssql
Pooled: yes
Limit: 232
Connections in use: 8
 Connection 1: connected
 Connection 2: connected
 Connection 3: connected
 Connection 4: connected
 Connection 5: connected
 Connection 6: connected
 Connection 7: connected
 Connection 8: connected


****** ADDITIONAL INFORMATION ******

my res_odbc.conf shows a limit of 1256 connections. When the 232 limit is reached, Asterisk stops routing calls and needs to be restarted, because it constipates and eats up all available file handles. My res_odbc.conf is:
[global]
enabled=yes
dsn=mssql
username=xxxx
password=xxxx
pre-connect => yes
pooling=>yes
limit=> 1256
idlecheck => 3600

[routing]
enabled=yes
dsn=sybase
username=xxxx
password=xxxx
pre-connect => yes
pooling=>yes
limit=> 1256
idlecheck => 3600

[sybase]
enabled=yes
dsn=sybase
username=xxxx
password=xxxx
pre-connect => yes
pooling=>yes
limit=> 1256
idlecheck => 3600
Comments:By: Tilghman Lesher (tilghman) 2009-04-13 15:31:34

What's your open file descriptor limit set to for Asterisk (ulimit -n)?  Also, on 1.4, your limit on number of odbc handles has an upper bound of 1023.
By: Private Name (falves11) 2009-04-13 16:14:20

I will be happy with 1023 ODBC connection limit.
[root@switch1 asterisk]# ulimit -n
400000
odbc show

Name: sybase
DSN: sybase
Pooled: yes
Limit: 232
Connections in use: 10
 Connection 1: connected
 Connection 2: connected
 Connection 3: connected
 Connection 4: connected
 Connection 5: connected
 Connection 6: connected
 Connection 7: connected
 Connection 8: connected
 Connection 9: connected
By: Digium Subversion (svnbot) 2009-04-13 18:04:16

Repository: asterisk
Revision: 188149

U   branches/1.4/res/res_odbc.c

------------------------------------------------------------------------
r188149 | tilghman | 2009-04-13 18:04:16 -0500 (Mon, 13 Apr 2009) | 4 lines

If fileconfig limit exceeds our maximum, then set the limit to the maximum.
(Closes issue ASTERISK-13947)
Reported by: falves11

------------------------------------------------------------------------

http://svn.digium.com/view/asterisk?view=rev&revision=188149
By: Digium Subversion (svnbot) 2009-04-13 18:05:54

Repository: asterisk
Revision: 188150

_U  trunk/

------------------------------------------------------------------------
r188150 | tilghman | 2009-04-13 18:05:54 -0500 (Mon, 13 Apr 2009) | 10 lines

Blocked revisions 188149 via svnmerge

........
 r188149 | tilghman | 2009-04-13 18:04:15 -0500 (Mon, 13 Apr 2009) | 4 lines
 
 If fileconfig limit exceeds our maximum, then set the limit to the maximum.
 (Closes issue ASTERISK-13947)
 Reported by: falves11
........

------------------------------------------------------------------------

http://svn.digium.com/view/asterisk?view=rev&revision=188150
By: Private Name (falves11) 2009-04-13 21:28:10

I cannot go above revision  179536, since from there onwards there is a 100% CPU issue. (bug 14723) Would you mind posting the patch in wget form so I may upgrade my production boxes, until the day when I can upgrade to the current version?
By: Tilghman Lesher (tilghman) 2009-04-14 00:24:24

If you want the patch, it can be obtained from SVN.
By: Private Name (falves11) 2009-04-14 00:43:43

Sorry about my ignorance. How exactly do I get the patch for this issue?
By: Leif Madsen (lmadsen) 2009-04-14 07:13:38

svn diff -r 188148:188149 http://svn.digium.com/svn/asterisk/branches/1.4

Google "showing diff in svn on a revision"  <-- very first link